index

Package gb_hold_str

This package contains the error messages and error message functions for the Hold API (gb_hold).

Message KeyError Message
INVALID_HLDD_CODEInvalid hold value
The hold code entered must be valid in the Hold Code validation table STVHLDD.
INVALID_ORIG_CODEInvalid hold origination value
The origination code entered must be valid in the Originator Code validation table STVORIG.
INVALID_PIDMInvalid learner internal identification number
The hold could not be created or updated because a match could not be found for the person record.
INVALID_RELEASE_INDHold release indicator must be Y for secured hold or N for an unsecured hold
An attempt was made to enter a value other than 'Y' or 'N' for the hold release indicator.
INVALID_USERUser does not have the privilege to modify the hold
An attempt to update or remove the hold failed because the current user does not have permission to change the hold.
MISSING_FROM_DATEMissing mandatory hold "from" date
The required hold "from" date is missing and must be designated with a valid date value and format.
MISSING_HLDD_CODEMissing mandatory hold value
The required hold code is missing and must be entered as a valid code from the Hold Code validation table (STVHLDD).
MISSING_PIDMMissing mandatory learner internal identification number
The required person record is missing and must match an existing person record.
MISSING_RELEASE_INDMissing mandatory hold release indicator
The required release indicator is missing and must be designated with a value of 'N' (No) or 'Y' (Yes).
MISSING_TO_DATEMissing mandatory hold to date
The required hold to date is missing and must be designated with a valid date value and format.
MISSING_USERMissing mandatory Oracle sign-on value
The required Oracle ID is missing and must be designated with a valid Oracle ID.
PK_NOT_FOUNDCannot find the hold record
An attempt to read, update or delete the hold record failed because no matching record was found.
P_DELETE_FAILEDCannot delete, hold record does not exist
An attempt to delete the hold record failed because no matching record was found.


Program units
f_get_error   Returns an error message corresponding to p_errorname.

Variables
error_tab   Global error table that holds the error message.


error_tab

error_tab gb_common_strings.errmsg_tab_type;

Global error table that holds the error message.


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.