I think that your friend was pulling your leg. The oxalate esters and hydrogen peroxide in a glow stick shouldn't be ingested, though the actual dye that gets excited to fluorescence would be relatively harmless. I also wouldn't expect the concentrations of active materials to remain high enough in urine for the glow reaction to be noticeable, even if all the chemicals were excreted unchanged.