index

Package sb_transcript_name_source_str

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

Message NameError Message
INVALID_DEGR_INDInvalid value for the degree indicator
A value other than Y (yes) or N (no) was entered for the degree indicator.
INVALID_EDI_INDInvalid value for the EDI indicator
A value other than Y (yes) or N (no) was entered for the electronic distribution indicator.
INVALID_NTYP_INDInvalid value for the name type indicator
A value other than Y (yes) or N (no) was entered for the name source type indicator.
INVALID_SYS_REQ_INDInvalid value for the system required indicator
A value other than Y (yes) or N (no) was entered for the system required indicator.
INVALID_TRNS_CODEInvalid transcript name source
The name source code entered for the name to be printed on the transcript does not exist in the STVTRNS table.
MISSING_DATA_ORIGINMissing mandatory value for the data origin
The value for the origin of the data was not entered.
MISSING_DEGR_INDMissing mandatory value for degree indicator
A Y (yes) or N (no) value for the degree indicator was not entered.
MISSING_EDI_INDMissing mandatory value for the electronic distribution indicator
A Y (yes) or N (no) value for the EDI indicator was not entered.
MISSING_NTYP_INDMissing mandatory value for the name type indicator
A Y (yes) or N (no) value for the name type indicator was not entered.
MISSING_SYS_REQ_INDMissing mandatory value for the system required indicator
A Y (yes) or N (no) value for the system required indicator was not entered.
MISSING_TRNS_CODEMissing mandatory value for the transcript name source indicator
No code was entered for the transcript name source.
MISSING_USER_IDMissing mandatory value for the user ID
The user ID to create or update the record was not entered.
PK_NOT_FOUNDCannot find record using primary or unique key
Cannot find the desired record using name source code that is to be printed on the transcript in the STVTRNS table.
P_DELETE_FAILEDCannot delete record
The record to be deleted using the name source code that was entered does not exist in the SHRTRNS table.
RECORD_EXISTSCannot create record
The record using the name source code that was entered already exists in the SHRTRNS table.
SYS_REQ_DELETE_RESTRICTIONDelete not allowed because record is system required
You can only delete records with a system required indicator of N.
SYS_REQ_UPDATE_RESTRICTIONUpdate to record not allowed because record is system required
You can only update records with a system required indicator of N.


Program units
f_get_error  

Variables
error_tab  


error_tab

error_tab gb_common.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.err_type

Returns the error message corresponding to p_errorname.

Parameters
p_errorname   Name associated with the error message.