index

Package sb_mealassignment_str

This package contains the error messages and error message functions for the Meal Assignment API.

Message KeyError Message
ASSESSMENTS_PROCESSEDMeal Assignment Assessments have already been processed; cannot delete
Meal assignment assessments for the term have been processed.  After the initial meal assessment for the term, meal assignment records for the term cannot be deleted.
ASSESS_DONE_NO_TERMMeal Assignment Assessments have already been processed; cannot change term
Meal assignment assessments for term have been processed in the past.  After the initial meal assessment for the term, meal assignment term code cannot be changed.
ASSESS_DONE_NO_RATEMeal Assignment Assessments have already been processed; cannot change rate code
Meal assignment assessments for term have been processed in the past.  After the initial meal assessment for the term, meal assignment rate code cannot be changed.
BEGIN_LESS_THAN_ENDBegin date must be less than end date for meal assignment
Value specified for the begin date must be less than value specified for the end date to create a valid meal assignment date range.
CANNOT_CHANGE_ARCannot change Meal Assignment AR Indicator
Cannot change accounts receivable indicator.
INACTIVE_APPLICATIONApplication is inactive
The application for this student and term is not active, therefore no meal assignments can be made.
INVALID_AR_INDInvalid Meal Assignment AR Indicator, must by Y or N
Value specified for meal assignment accounts receivable indicator must be Y for yes or N for no.
INVALID_ASSESS_NEEDEDInvalid Meal Assignment Assessment Needed Indicator, must by Y or N
Value specified for meal assignment assessment needed must be Y for yes or N for no.
INVALID_ONL_OR_BATInvalid Meal Assignment Online or Batch Indicator, must be O(Online) or B(Batch)
Value specified for the meal assignment online or batch indicator must have a valid value of O(Online) or B(Batch).
INVALID_MRCD_CODEInvalid Meal Assignment Meal Plan Code
Value specified for the meal assignment rate code must be established within assessments for the term.
INVALID_MSCD_CODEInvalid Meal Assignment Status Code
Value specified for status code must be a valid meal assignment status for term.
INVALID_MSCD_DATEMeal Assignment Date must be between start and end dates for the status code
The date specified for the meal assignment must be within the date range for the status code.
INVALID_PIDMInvalid or missing Meal Assignment PIDM
Value was not specified for the meal assignment internal personal identification number.
INVALID_ROLL_INDInvalid Meal Assignment Roll Indicator, must be N or NULL
Value specified for the meal assignment roll indicator must have a valid value of N (Do Not Roll) or NULL (Allow Roll).
INVALID_SLBTERM_CODEMeal Assignment Term not available for processing, check SLBTERM
Meal assignment term specified has to be defined in the SLBTERM table.
INVALID_TERM_CODEInvalid Meal Assignment Term Code
Value specified for meal assignment term code must have a valid value in the Term Code validation table (STVTERM).
MISSING_AR_INDMissing mandatory Meal Assignment AR Indicator
Meal Assignment AR Indicator must have a value of 'Y' or 'N'.
MISSING_ASSESS_NEEDEDMissing mandatory Meal Assignment Assessment Needed Indicator
Meal assignment assessment needed indicator must have a value of 'Y' or 'N'.
MISSING_BEGIN_DATEMissing mandatory Meal Assignment Begin Date
Meal assignment begin date must be specified.
MISSING_END_DATEMissing mandatory Meal Assignment End Date
Meal assignment end date must be specified.
MISSING_MRCD_CODEMissing mandatory Meal Assignment Meal Plan Code
Value for the meal assignment meal plan rate code must be specified.
MISSING_MSCD_CODEMissing mandatory Meal Assignment Status Code
Value was not specified for meal assignment status code.
MISSING_MSCD_DATEMissing mandatory Meal Assignment Status Date
Value was not specified for meal assignment status date.
MISSING_ONL_OR_BATMissing mandatory Meal Assignment Online/Batch Indicator
Meal assignment (O)nline or (B)atch indicator must be specified.
MISSING_PIDMMissing mandatory Meal Assignment PIDM
Meal assignment internal personal identification number must be specified.
MISSING_TERM_CODEMissing mandatory Meal Assignment Term Code
Value for the meal assignment term code must be specified.
MISSING_TOTAL_DAYSMissing mandatory Meal Assignment Total Days
Number for the meal assignment total days must be specified.
MISSING_TOTAL_MONTHSMissing mandatory Meal Assignment Total Months
Number for the meal assignment total months must be specified.
MISSING_TOTAL_TERMSMissing mandatory Meal Assignment Total Terms
Number for the meal assignment total terms must be specified.
NO_APPLICATIONMeal Assignment Term must be between application from and to terms
Term specified for the meal assignment must be within housing application term range.
PLAN_NOT_ESTABLISHEDMeal Plan Not Established within Assessments
Meal plan code must be a valid for the term for the meal assignments.
RATE_CODE_NOT_DAILYRate code not set up for Meal Assignment daily assessment
Rate code is not set up for daily assessment.
RATE_CODE_NOT_MONTHLYRate code not set up for Meal Assignment monthly assessment
Rate code is not set up for monthly assessment.
RATE_CODE_NOT_TERMLYRate code not set up for Meal Assignment assessment by term
Rate code is not set up for assessment by term.
ROOM_APPLICATIONApplication is for room assignments only
Application is not set up for room assignments in SLBRMAP.
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_RANGEMeal Assignment rate value must be in range of 0 - 12
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  

Variables
error_tab  


error_tab

error_tab gb_common_strings.errmsg_tab_type;

Global table for error messages


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 error message.