index

Package sb_transcript_req_name_strings

This package contains the error messages and error message functions for the Transcript Request Name API (sb_transcript_req_name).

Message NameError Message
INVALID_DATA_ORIGINInvalid value for data origin
Data origin value entered is invalid.
INVALID_DEGR_SEQ_NOInvalid value for degree sequence number
Degree sequence number entered is invalid.
INVALID_NAME_SEQNOInvalid value for name sequence
Name sequence number entered is invalid
INVALID_NTYP_CODEInvalid value for name type code
Name type code entered is invalid.
INVALID_PIDMInvalid value for unique identifier (PIDM)
Unique identifier (PIDM) entered is invalid.
INVALID_TRAN_SEQNOInvalid value for transcript sequence number
Transcript sequence number entered is invalid.
INVALID_TRAN_USERInvalid value for transcript user
Transcript user entered is invalid.
INVALID_TRNS_CODEInvalid value for transcript code
Transcript code entered is invalid.
INVALID_USER_IDInvalid value for user ID
User ID entered is invalid.
MISSING_DATA_ORIGINMissing mandatory value for data origin
Data origin value is required.
MISSING_NAME_SEQNOMissing mandatory value for name sequence number
Name sequence number value is required.
MISSING_PARENTRequired parent record not found
Required parent record not found.
MISSING_PIDMMissing mandatory value for unique indentifier (PIDM)
Unique identifier (PIDM) value is required.
MISSING_TRAN_SEQNOMissing mandatory value for transcript sequence number
Transcript sequence number is required.
MISSING_TRAN_USERMissing mandatory value for transcript user
Transcript user value is required.
MISSING_TRNS_CODEMissing mandatory value for transcript code
Transcript code value is required.
MISSING_USER_IDMissing mandatory value for user ID
User ID value is required.
PK_NOT_FOUNDCannot find record using primary or unique key
Cannot find the record using the primary or unique key.
P_DELETE_FAILEDCannot delete, record does not exist
Unable to delete the record; record does not exist.
RECORD_EXISTSCannot create, record already exists
Unable to create the record; record already exists.

Program units
f_get_error  

Variables
error_tab  

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.