USP_EVENTLODGINGROOM_VALIDATEROOMINFO

            CREATE procedure dbo.USP_EVENTLODGINGROOM_VALIDATEROOMINFO(@ROOMINFORMATION xml)
            with execute as caller
            as            
                declare @ERRORMESSAGE nvarchar(max);

                declare @ROOMTYPECODEID uniqueidentifier

                select top 1 @ROOMTYPECODEID = ROOMTYPECODEID from dbo.UFN_EVENTLODGINGROOM_GETEVENTLODGINGROOMINFORMATION_FROMITEMLISTXML(@ROOMINFORMATION) as ROOMINFORMATION

                if @ROOMTYPECODEID is null begin
                    raiserror('ERR_NO_ROOM_INFORMATION', 13, 1);
                end