index

Package sb_edi_acrec_ude_strings

This package contains the error messages and error message functions for the EDI Academic Record user defined extension (UDE) API (sb_edi_acrec_ude).
For use with internal processing to produce the XML transcript.

Message KeyError Message
MISSING_DCMT_SEQNO Missing mandatory value for document sequence number.
The document sequence number is missing.
MISSING_GPA_SEQNO Missing mandatory value for GPA sequence number.
The GPA sequence number is missing.
MISSING_ACREC_UDE Missing mandatory value for academic record user-defined extension.
Academic record user-defined extension requires character data.
MISSING_USER_ID Missing mandatory value for user.
A valid Oracle ID is required.
P_DELETE_FAILED Cannot delete, record does not exist.
The record for the document and GPA sequence number does not exist.
PK_NOT_FOUND Cannot find record using primary or unique key.
Cannot find record using document and GPA sequence number.
RECORD_EXISTS Cannot create, record already exists.
A record currently exists have the same document and GPA sequence number.

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