index

Package gb_roomassignment_str

This package contains the error messages and error message functions for Room Assignment (GB_ROOMASSIGNMENT_STR).

Message KeyError Message
ASSESSMENTS_PROCESSEDRoom assignment assessments have already been processed; cannot delete
Room assignment assessments for term have been processed in the past.  After the initial room assessment for the term, records for the term cannot be deleted.
ASSESS_DONE_NO_TERMRoom Assignment Assessments have already been processed; cannot change term
Room assignment assessments for term have been processed in the past.  After the initial room assessment for the term, room assignment term code cannot be changed.
ASSESS_DONE_NO_RATERoom Assignment Assessments have already been processed; cannot change rate code
Room assignment assessments for term have been processed in the past.  After the initial meal assessment for the term, room assignment rate code cannot be changed.
BEGIN_LESS_THAN_ENDBegin date must be less than end date for room assignment
Value specified for the begin date must be less than value specified for the end date to create a valid room assignment date range.
CAPACITY_ERRORNormal room capacity is exceeded; select overload indicator to bypass
Room has no additional available capacity.
CANNOT_CHANGE_ARCannot change Room Assignment AR Indicator
Cannot change AR indicator.
INACTIVE_APPLICATIONApplication is inactive
The application for this student and term is not active, therefore no room assignments can be made.
INVALID_AR_INDInvalid Room Assignment AR Indicator, must be Y or N
Value specified for room assignment AR indicator must be Y for yes or N for no.
INVALID_ASSESS_NEEDEDInvalid Room Assignment Assessment Needed Indicator, must be Y or N
Value specified for room assignment assessment needed must be Y for yes or N for no.
INVALID_ASCD_CODEInvalid Room Assignment Status Code
Value specified for the status code must be a valid room assignment status for the term.
INVALID_ASCD_DATERoom Assignment date must be between start and end dates for the status code
Date specified for the room assignment must be in the date range for the status code.
INVALID_BLDG_CODEInvalid Room Assignment Building Code
Room assignment building code must have a building definition.
INVALID_BLDG_SEXRoom assignment building is restricted to a different gender
Building has been reserved for a different gender from the person requesting the room assignment.
INVALID_OVERRIDE_ERRORInvalid Room Assignment Override Error
Value specified for the room assignment override must have a valid value of Y (Override) or NULL (No Override).
INVALID_PIDMInvalid or missing room assignment PIDM
Internal personal identification number was not specified for room assignment.
INVALID_ONL_OR_BATInvalid Room Assignment Online or Batch Indicator, must be O(Online) or B(Batch)
Value specified for the room assignment online or batch indicator must have a valid value of O (Online) or B (Batch).
INVALID_ROLL_INDInvalid Room Assignment Roll Indicator, must be N or NULL
Value specified for the room assignment roll indicator must have a valid value of N (Do Not Roll) or NULL (Allow Roll).
INVALID_RRCD_CODEInvalid Room Assignment Room Rate Code
Value specified for the room assignment room rate must be established within assessments for the term.
INVALID_SLBTERM_CODE Room assignment term not available for processing, check SLBTERM
Room assignment term specified has to be defined in the SLBTERM table.
INVALID_TERM_CODEInvalid Room Assignment Term Code
Value specified for the room assignment term code must have a valid value in the Term Code validation table (STVTERM).
MAX_CAPACITY_ERRORMaximum room capacity is exceeded; select another room
Room has no additional available capacity.
MISSING_AR_INDMissing mandatory Room Assignment AR Indicator
Room assignment AR indicator must have value of 'Y' or 'N'.
MISSING_ASCD_CODEMissing mandatory Room Assignment Status Code
Value was not specified for the room assignment status code.
MISSING_ASCD_DATEMissing mandatory Room Assignment Status Date
Value was not specified for the room assignment status date.
MISSING_ASSESS_NEEDEDMissing mandatory Room Assignment Assessment Needed Indicator
Room assignment assessment needed indicator must have value of 'Y' or 'N'.
MISSING_BEGIN_DATEMissing mandatory Room Assignment Begin Date
Room assignment begin date must be specified.
MISSING_BLDG_CODEMissing mandatory Room Assignment Building Code
Value for the room assignment building code must be specified.
MISSING_END_DATEMissing mandatory Room Assignment End Date
Room assignment end date must be specified.
MISSING_ONL_OR_BATMissing mandatory Room Assignment Online/Batch Indicator
Room assignment (O)nlne or (B)atch indicator must be specified.
MISSING_PARENTRequired Room Assignment parent record not found 
Value specified for the room assignment does not have a parent record in another table.
MISSING_PIDMMissing mandatory Room Assignment PIDM
Internal personal identification number for the room assignment must be specified.
MISSING_ROOM_NUMBERMissing mandatory Room Assignment Room Number
Room assignment value for the room number must be specified.
MISSING_RRCD_CODEMissing mandatory Room Assignment Room Rate Code
Value for the room assignment rate code must be specified.
MISSING_TERM_CODEMissing mandatory Room Assignment Term Code
Value for the room assignment term code must be specified.
MISSING_TOTAL_DAYSMissing mandatory Room Assignment Total Days
Number of total days for the room assignment must be specified.
MISSING_TOTAL_MONTHSMissing mandatory Room Assignment Total Months
Number of total months for the room assignment must be specified.
MISSING_TOTAL_TERMSMissing mandatory Room Assignment Total Terms
Number of total terms for the room assignment must be specified.
NO_APPLICATIONTerm must be between Room Assignment application from and to terms
Term specified for the room assignment must be within the housing application term range.
NO_ROOM_APPLICATIONApplication is for meal assignments only; check application
Check that the application type on the application includes rooms.
NO_RATE_ASSESSRoom assignment assessments have already been processed; cannot update rate code
The rate code cannot be changed once the room assignment has been assessed.
OTHER_GENDERThis room has been reserved for a different gender
Gender of the person requesting the room assignment does not match gender associated with the room requested.
PK_NOT_FOUNDCannot find Room Assignment record using primary or unique key
Room assignment record was not found with the data values given.
PLAN_NOT_ESTABLISHEDRoom assignment plan not established within assessments
Room plan must be established within room assessments.
P_DELETE_FAILEDCannot delete, Room Assignment record does not exist
No room assignment record that corresponds to the values entered was found, so the record cannot be deleted.
RATE_CODE_NOT_DAILYRoom Assignment rate code not set up for daily assessment
Room assignment rate code is set up for assessment by monthly or by term.
RATE_CODE_NOT_MONTHLYRoom Assignment rate code not set up for monthly assessment
Room assignment rate code is set up for assessment by day or by term.
RATE_CODE_NOT_TERMLYRoom Assignment rate code not set up for term assessment
Room assignment rate code is set up for assessment by day or by month.
RESTRICTION_ERRORRestrictions prohibit room assignment
Room assignment cannot be completed because of restrictions on the room.
ROOM_DOES_NOT_EXISTRoom does not exist
Room number requested for the room assignment does not exist.
ROOM_INACTIVERoom is inactive at this time
Room number requested for the room assignment is not available to be assigned during the requested time.
ROOM_NOT_AVAILRoom is not available for the entire duration of the assignment
Room number requested for the room assignment is not available for the entire requested time.
ROOM_NOT_DORMRoom is not a dormitory
Room number requested for the room assignment is not available to be assigned as a dormitory.
P_DELETE_FAILEDCannot delete, record does not exist
Room assignment requested does not exist in room assignment table.
DELETE_NOT_ALLOWEDCannot delete, not allowed because of assessments needed indicator and AR indicator settings
Room assignment requested cannot be deleted due to the setting of the assessment needed and ar indicator.
RATE_OUT_OF_MONTH_RANGERoom Assignment rate value must be in range of 0 - 99
The value specified for the rate must be greater than or equal to 0 and less than or equal to 99.


Program units
f_get_error   Returns an error message corresponding to p_errorname.

Variables
error_tab   Global error message table


error_tab

error_tab gb_common_strings.errmsg_tab_type;

Global error message table


f_get_error

FUNCTION f_get_error(p_errorname VARCHAR2) RETURN VARCHAR2

Returns an error message corresponding to p_errorname.

Parameters
p_errorname   Name associated with the error message.

Returns
Error message corresponding to error name.  VARCHAR2