index

Package sb_edi_subtest_score_strings

This package contains the error messages and error message functions for the EDI Subtest Score API (sb_edi_subtest_score ).
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_TEST_SEQNO Missing mandatory value for test sequence number.
The test sequence number is missing.
MISSING_STST_SEQNO Missing mandatory value for subtest sequence number.
The subtest sequence number is missing.
MISSING_SEQNO Missing mandatory value for subtest score sequence number.
The subtest score sequence number is missing.
MISSING_SCORE Missing mandatory value for test score.
The test code is missing.
MISSING_USER_ID Missing mandatory value for user.
A valid user identification is required.
MISSING_DATA_ORIGIN Missing mandatory value for data origin.
Source system is required.
INVALID_TEFR_CODE Invalid value for test score method.
Please review STVTEFR setup.
INVALID_REVISED_IND Invalid value for revised score indicator.
Valid values are (Y) and (N).
INVALID_INVALIDATED_IND Invalid value for invalidated score indicator.
Valid values are (Y) and (N).
INVALID_SELFREPORTED_IND Invalid value for self reported score indicator.
Valid values are (Y) and (N).
MISSING_PARENT Required parent record not found.
Missing SHRSTST record.
P_DELETE_FAILED Cannot delete, record does not exist.
Cannot find record using the document sequence number, main test sequence number, subtest sequence number, and subtest score.
PK_NOT_FOUND Cannot find record using primary or unique key.
Cannot find record using the document sequence number, main test sequence number, subtest sequence number, and subtest score.
RECORD_EXISTS Cannot create, record already exists.
A record already exists for the document sequence number, main test sequence number, subtest sequence number, and subtest score.

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.