Temptation is not the same as near occasion of sin. A near occasion of sin is something that generally leads one to commit mortal sins… one needs to avoid such.
In regards to mortal sin…(ie.complete loss of reason OR drunk driving, OR drinking that is leading to various mortal sins)
catholicreference.net/index.cfm?id=33231
One has to intend to avoid the near occasion of sin (that is what generally leads one into mortal sin) so if drinking a couple drinks is really a near occasion to mortal sin (generally leads one to this…to getting drunk mortally) then one must intend to avoid such. (all mortal sins must be of course be confessed and with contrition and a firm purpose of amendment…intending yes to avoid the near occasion to them)
In regards confession of just venial sins…(that is in a confession where we know we are only confessing venial sins at that time) some excess in eating and drinking -usually individual acts are usually venial…(which does not make them good of course) but there can be say medical reasons or other reasons that can make it grave due to circumstance)…one has to in ones confession be sorry …with firm purpose of amendment …for at least one confessed actually committed sin…for the confession to be valid…now the firm purpose of amendment etc does not have to be the same as in mortal sins…it can be the case say with more “regular” venial sins that one often falls into say…that one at least intends to work at making them fewer etc…of getting better as a Christian. (of course if one is not sorry for a venial sin…it does not get forgiven…so not something one should even bother confessing)
Of course let us seek to follow Christ and avoid sin in general…and what leads us to it…and seek virtue…to live temperance etc (which can be different in different occasions…like a kind of “celebration temperance” can be different than ordinary temperance…still though according to reason etc).
And of course we want to not lead others (approve, assist etc) to mortal sins etc either