When someone screws up or drops the ball on something.

Pvt Lonthin really screwed the pooch when he woke up, drunk, with a handle of Jack Daniels in hand, and answered his door for the base Sergeant Major.