The body of a Scottish man who went missing on a stag weekend in Hamburg has been found, according to a charity helping his family.