a flop
A flop-on is when a guy can’t get hard because he drank so much beer he turned into a puddle.
My uncle had a flop-on at the bar. He couldn’t even stand up.
That guy had a flop-on at the concert. He fell off the stage.
My brother had a flop-on at the party. He cried like a baby.