It's when you think you're going to get laid, however you don't. Often results in blue balls. See Seinfeld yada yada yada.
We made out at the bar, then yada yada nada, she passed out in my bed.