When is "Jesus wept" used?

The first time I came across the usage of this phrase was in the movie Hellraiser, and I had no idea this was a common saying. Clearly though, there must be a double meaning there in the movie that I couldn't fully grasp without knowing the more colloquial meaning.

The description on Wikipedia is unfortunately not enough for me, I would like to see examples. And it's very hard to find those because Google gives me mostly links to religious websites.