BANINST1@S10B80

index

Package sb_feedback_codes_strings

This package contains the error messages and error message functions for SB_FEEDBACK_CODES.

Message NameError Message
INUSEThe issue or recommendation code cannot be deleted because the code is in use for faculty feedback.
Use the purge process to delete faculty feedback data, then retry the operation.
INVALID_ACTIVE_INDActive Indicator is not valid. Should be Y or N
Valid values are Y or N
INVALID_SURROGATE_IDSurrogate ID is not valid.
The surrogate id does not exist in the table.
INVALID_TYPEValidation Type Code is not valid. Should be ISSUE or RECOMMENDATION
Valid values are ISSUE or RECOMMENDATION.
MISSING_ACTIVE_INDActive Indicator is required.
Valid values are Y or N.
MISSING_CODECode is required.
This value cannot be null.
MISSING_DATA_ORIGINData Origin Value is missing. This field is required.
This value cannot be null.
MISSING_DESCDescription is required.
This value cannot be null.
MISSING_TYPEType Of Validation Code (ISSUE or RECOMMENDATION) is required.
This value cannot be null.
MISSING_USER_IDUser ID is missing. This field is required.
This value cannot be null.
MISSING_VERSIONVersion is missing. This field is required.
This value cannot be null.
NOUPDATECODECannot update code because the the code already exists.
This code is in use, so enter a different code.
OPTIMISTIC_LOCK_ERRORCannot perform operation as record has been updated by another user. Please refresh and try again.
Another user has changed the row while you were working on it. Requery and try the operation again.
P_DELETE_FAILEDCannot delete issue or recommendation because the record does not exist.
Another user may have deleted the row while you were working on it. Requery and try the operation again.
RECORD_EXISTSCannot create new issue or recommendation because the record already exists.
Codes must be unique, try a different code.


Program units
f_get_error   Returns the error message corresponding to p_errorname.

Variables
error_tab   Global PL/SQL table that holds the error messages.


error_tab

error_tab gb_common_strings.errmsg_tab_type;

Global PL/SQL table that holds the error messages.


f_get_error

Function f_get_error(p_errorname VARCHAR2)
  RETURN gb_common_strings.err_type

Returns the error message corresponding to p_errorname.

Parameters
p_errorname   Name associated with the error message.