index

Package sb_roompreference_str

This package contains the error messages and error message functions for the Room Preference API.

Message KeyError Message
BLDG_GENDER_RESTRICTEDRoom Preference Building/Room is restricted to the opposite gender
The gender assigned to the building/room is different from the housing application/room preference gender.
INVALID_ARTP_CODEInvalid Room Preference Application Type
The housing application/room preference application type must be a valid value in the Room and Meal Application Type validation table (STVARTP).
INVALID_BCAT_CODECategory code invalid for this Room Preference building
The housing application/room preference room category code is not valid for the room specified.
INVALID_BCAT_ROOMCategory is not valid for preferred room
The value specified for the housing application/room preference preferred room does not have a room defined in the building.
INVALID_BLDG_CODEInvalid Room Preference Building Code
The value specified for the housing application/room preference building code must be a valid value in the Building Code validation table (STVBLDG).
INVALID_BLDG_ROOMInvalid Room Preference room for building
The value specified for the housing application/room preference preferred room does not have a room defined in the building.
INVALID_CAMP_CODEInvalid Room Preference Campus Code
The value specified for the housing application/room preference campus code must be a valid value in the Campus Code validation table (STVCAMP).
INVALID_CONFID_INDInvalid Room Preference Confidentiality Indicator
The value specified for the housing application/room preference confidentiality indicator is not valid.
INVALID_FROM_TERMInvalid Room Preference From Term
The value specified for the housing application/room preference 'from term' must be a valid value in the Term Code validation table (STVTERM).
INVALID_HAPS_CODEInvalid Room Preference Application Status Code
The value specified for the housing application/room preference application status date is invalid.
INVALID_MRCD_CODEInvalid Room Preference Meal Rate Code
The value specified for the housing application/room preference meal rate code must be a valid value in the Meal Rate Code validation table (STVMRCD).
INVALID_PIDMInvalid or missing Room Preference PIDM
The value specified for the housing application/room preference internal personal identification number does not exist in the person table.
INVALID_TO_TERMInvalid Room Preference To Term
The value specified for the housing application/room preference 'to term' must be a valid value in the Term Code validation table (STVTERM).
MEAL_ASSIGN_EXISTSRoom Preference Meal assignment exists within original term range
The housing application/room preference cannot have the term changed because there is a meal assignment associated with it.
MISSING_ARTP_CODEMissing mandatory Room Preference Application Type
The value for the housing application/room preference application type was not specified.
MISSING_FROM_TERMMissing mandatory Room Preference From Term
The value for the housing application/room preference 'from term' was not specified.
MISSING_HAPS_CODEMissing mandatory Room Preference Application Status Code
The value for the housing application/room preference application status code was not specified.
MISSING_PARENTRequired Room Preference parent record not found 
A housing application/room preference record that needs to exist in a parent table for a code or value you specified does not exist.
MISSING_PIDMMissing mandatory Room Preference PIDM
The housing application/room preference internal personal identification number was not specified.
MISSING_TO_TERMMissing mandatory Room Preference To Term
The housing application/room preference 'to term' was not specified.
PHONE_ASSIGN_EXISTSRoom Preference Phone assignment exists within original term range
The phone assignment specified already exists within the original term range.
PK_NOT_FOUNDCannot find Room Preference record using primary or unique key
The housing application/room preference record cannot be found with the values specified or does not exist.
P_DELETE_FAILEDCannot delete, Room Preference record does not exist
The housing application/room preference record with the values specified does not exist. Cannot delete.
PHONE_ASSIGN_EXISTSError Phone Assignment exists cannot change Room Preference Application term code
The housing application/room preference cannot have the term changed because there is a phone assignment associated with it.
RECORD_EXISTSCannot create, Room Preference record already exists
The housing application/room preference record of the values specified already exists.  Cannot create.
ROOM_ASSIGN_EXISTSRoom Preference Room assignment exists within original term range
The housing application/room assignment specified already exists in the original term range.
SLRMASG_CHILDREN_EXISTError Meal Assignment exists, Room Preference cannot be deleted.
The housing application/room preference cannot be deleted because there is a meal assignment associated with it.
SLRPASG_CHILDREN_EXISTError Phone Assignment exists, Room Preference cannot be deleted.
The housing application/room preference cannot be deleted because there is a phone assignment associated with it.
SLRRASG_CHILDREN_EXISTError Room Assignment exists, Room Preference cannot be deleted.
The housing application/room preference cannot be deleted because there is a room assignment associated with it.
TO_TERM_BETWEEN'To term' falls between the range of another Room Preference application
The 'to term' specified falls between the range of another 'from term' and 'to term' for a different housing application/room preference.
TO_TERM_LESS_THANRoom Preference 'to term' must be greater than or equal to 'from term'
The housing application/room preference 'to term' specified must be greater than the 'from term' for the term range to be valid.
TO_TERM_OVERLAPS'To term' overlaps existing Room Preference application
The housing application/room preference 'to term' overlaps an existing term range of another housing application.


Program units
f_get_error  

Variables
error_tab  


error_tab

error_tab gb_common_strings.errmsg_tab_type;

Error table global variable


f_get_error

Function f_get_error(p_errorname VARCHAR2) return varchar2

Returns the error message corresponding to p_errorname.

Parameters
p_errorname   Name associated with the error message.