Getting one's self into serious trouble, especially when doing something bad or not what you're supposed to do.

when you're hungover as shit after a spending a night drunk as a skunk

Digging your own grave means doing smth. that is going to effect you negatively