index

Package sb_pesc_status_export_strings

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

Message KeyError Message
MISSING_PIDM Missing mandatory value for internal identifier (PIDM).
The internal identifier (PIDM) is a required field.
MISSING_REQUEST_SEQ_NO Missing mandatory value for transcript request number.
The transcript request number is a required field.
MISSING_USER_ID Missing mandatory value for user.
A valid Oracle ID is required.
MISSING_DOCUMENT_ID Missing mandatory value for document identification.
The document ID is a required field.
INVALID_PIDM Invalid value for internal identifier (PIDM).
A record already exists with this internal identifier (PIDM) and document ID.
P_DELETE_FAILED Cannot delete, record does not exist.
Cannot find record using internal identifier (PIDM) and document identification.
PK_NOT_FOUND Cannot find record using primary or unique key.
Cannot find record using internal identifier (PIDM) and document identification.
RECORD_EXISTS Cannot create, record already exists.
A record currently exists having the same internal identifier (PIDM) and document identification.

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.