index

Package sb_edi_status_strings

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

Message NameError Message
MISSING_COMP_INDMissing mandatory value for completion indicator.
The completion indicator is a required field.
MISSING_DATE_INMissing mandatory value for date in.
The date in is a required field.
MISSING_DCMT_SEQNOMissing mandatory value for document sequence number.
The document sequence number is a required field.
MISSING_DSTS_CODEMissing mandatory value for disposition status code.
The disposition status code is a required field.
MISSING_PRIORITYMissing mandatory value for document priority.
The document priority is a required field. Limited to 2 numeric positions.
MISSING_USERMissing mandatory value for user.
The user is a required field.
PK_NOT_FOUNDCannot find record using primary or unique key.
Cannot find record using document sequence number and disposition status code.
P_DELETE_FAILEDCannot delete, record does not exist.
Cannot find record using document sequence number and disposition status code.
RECORD_EXISTSCannot create, record already exists
A record already exists having the same document sequence number and disposition status code.

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.