My Son Is 10, He Is Sleepwalking/disoriented After Waking Several

My son is 10, he is sleepwalking/disoriented after waking several times a night, has stomach pain in upper right and lower left parts of his stomach, his head hurts, he is dizzy, and lightheaded. Symptoms are worse at time of sleepwalking which he does 3-4 times each night for the past week. We have gone to ER where they found bladder retention on a CT. No medicine, or diagnosis was given at ER. Just a referral to Urologist. This visit to the ER was his first, he is not sick often. During night-wakings he begs me to help him and repeats that "IT HURTS". PLease help me understand what's happening.