Shift 1 through 6 like it is supposed to but overdrive did not work

The transmission started acting up shifting into fifth and sixth. It acted like it went into limp mode. So I checked transmission fluid. When I did I noticed that the dip stick tube was broke into where it bolts onto housing. If I put transmission into fourth gear manually it shifted just fine. But overdrive did not work. Then it started acting up when it shifted into fourth. Now it only works if you shift it into third manually. If it shifts into fourth, the RPM's go up like it is slipping and you cannot get it to shift out of fourth. The only way to get it to work again is to stop put truck into park and turn ignition of and restart truck.

Now it says engine is hot but it is not. And it says 4x4 temporarily unavailable and service engine throttle body.

I cleared codes. P0118 pops up when I turn key on and run codes.