Hi, Intermittent right lower abdominal pain and hematuria, suggest a right ureteric stone. Which due to incresed muscular contractions during intercourse could had lead to acute ureteric colic pain. General abdominal pain is due to gastritis with is not subsiding due to your continued alcohol and drug intake, despite having gerd. I would suggest that you get an ultrasound of your abdomen done along with a routine urine test to look for the stone and start on a ppi tablet like omeprazole or pantaprazole. Further management will depend upon the location, size and number of stones. Hope i have been helpful. Regards Dr. Ashish Verma