Hello and welcome to healthcare magic !!
well reading the history given by you, it looks like either your son has developed a urinary tract infection
or kidney stones given his history of soda and sugary drinks, but just to be sure get an ultra sound
of abdomen and pelvis done and also renal function tests consisting of blood urea, serum creatinine
levels. Consult a paediatrician with the reports .