Definitely 'Ten Inch Hero' starring Jensen Ackles and Danneel Harris.
Here is one of the best scenes from the film to give you a taster: While on his supply run for their sandwich store, Priestly (Ackles) is asked by Tish (Harris) to buy tampons for the ladies room - hilarious results!
link