index

Package sb_pesc_status_imp_strings

This package contains the error messages and error message functions for the PESC Status Import API (sb_xml_status_imp).
"PESC" stands for "Postsecondary Electronic Standards Council".
For use with internal processing to produce the XML transcript.

Message KeyError Message
MISSING_RECV_DOCUMENT_ID Missing received document identification.
The received document identifier is required.
MISSING_SENT_DOCUMENT_ID Missing sent document identification.
The sent document identifier is required.
MISSING_SENT_ORG_CDE Missing sending institution organization code.
The sending institution code is required.
MISSING_SENT_ORG_CDE_TYPE Missing sending institution organization type code.
The sending institution code type is required.
MISSING_DOC_ID_RECEIVE_STATUS Missing received document identification status.
The received document identification status is required.
MISSING_USER_ID Missing user.
A valid Oracle ID is required.
MISSING_DATA_ORIGIN Missing data origin.
Source system is required.
INVALID_DOC_ID_RECEIVE_STATUS Invalid received document ID status for PESC_STATUS_IMP, must be R=Received or P=processed.
Valid values are (R) and (P).
P_DELETE_FAILED Cannot delete, record does not exist.
Cannot find record using documentation identifier.
PK_NOT_FOUND Cannot find record using primary or unique key.
Cannot find record using the documentation identifier.
RECORD_EXISTS Cannot create, record already exists.
A record currently exists having the same document identifier.


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