The tolerance for this should be....ZERO! Throw these pricks out on their @rse. That could be my family in the back of that jet.
If this continues to be a problem, there should be a 24 hour rule imposed. No drinking within 24 hours of a scheduled flight and anyone caught breaking this rule would be fired!