index

Package sb_edi_acad_summ_strings

This package contains the error messages and error message functions for the EDI Academic Summary API (sb_edi_acad_summ).
For use with internal processing to produce the XML transcript.

Message NameError Message
MISSING_DCMT_SEQNOMissing mandatory value for document sequence number.
Document sequence number is part of the primary key and is a required value.
MISSING_GPA_SEQNOMissing mandatory value for GPA sequence number.
GPA sequence number is part of the primary key and is a required value.
PK_NOT_FOUNDCannot find record using primary or unique key.
Cannot find record using document sequence number and GPA sequence number.
P_DELETE_FAILEDCannot delete, record does not exist.
The record for the document sequence number and GPA sequence number does not exist.
RECORD_EXISTSCannot create, record already exists.
A record currently exists having the same document sequence number 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.