index

Package sb_edi_medical_strings

This package contains the error messages and error message functions for the EDI Medical API (sb_edi_medical).
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_MEDI_CODE Missing mandatory value for medical code.
The medical code is missing.
MISSING_USER_ID Missing mandatory value for user.
A valid user identification is required.
INVALID_MEDI_CODE Invalid value for medical code.
A record already exists having the same document sequence number, medical code, and medical date.
P_DELETE_FAILED Cannot delete, record does not exist.
Cannot find record using document sequence number, medical code, and medical date.
PK_NOT_FOUND Cannot find record using primary or unique key.
Cannot find record using document sequence number, medical code, and medical date.
RECORD_EXISTS Cannot create, record already exists.
A record currently exists having the same document sequence number, medical code, and medical date.


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.