index

Package sb_testscore_strings

This package contains the error messages and error message functions for the Test Score API (sb_testscore).


Message NameError Messages
INVALID_ADMR_CODEInvalid value for Test Score Admission Checklist Request code
An attempt was made to create or update the test score admissions checklist request code with an invalid admissions
 checklist request code with an invalid admissions checklist request code. The admission checklist request code must exist in the Admissions Checklist Request Validation Table (STVADMR)
INVALID_APPL_NOInvalid value for Test Score Application number
An attempt was made to create or update the test score application number with a value that does not exist in the admissions application record (SARADAP) for the person
INVALID_EQUIV_INDInvalid value for Test Score Equivalency Indicator
An attempt was made to create or attempt the test score equivalency indicator with a value other than 'Y' or 'N'
INVALID_TEIN_CODEInvalid value for Test Score Instrument code
An attempt was made to create or update the test score instrument code with an invalid test score instrument code.
The test score instrument code must exist in the Test Score Instrument Validation Table (STVTEIN)
INVALID_PIDMInvalid or missing value for the unique identifier (PIDM)
An attempt was made to create or update the test score record by passing a test score invalid internal identification number that does not exist
INVALID_RCRV_INDInvalid value for Test Score Revised or Recentered Indicator
An attempt was made to create or update the test score revised or recentered indicator with a value other than 'X', 'R' or 'Z'
INVALID_RELEASE_INDInvalid value for Test Score Release Indicator
An attempt was made to create or update the test score release indicator with a value other than 'Y' or 'N'
INVALID_TADM_CODEInvalid value for Test Score Administrative Type code
An attempt was made to create or update the test score administrative type code with an invalid test score administ
rative type code. The test score administrative type code must exist in the Test Score Administrative Type Validation Table (STVTADM)
INVALID_TEAC_CODEInvalid value for Test Score Accommodation code
An attempt was made to create or update the test score accommodation code with an invalid test score accommodation
code.  The test score accommodation code must exist in the Test Score Accommodation Validation Table (STVTEAC)
INVALID_TEFR_CODEInvalid value for Test Score Form code
An attempt was made to create or update the test score form code with an invalid test score form code.  The test score form code must exist in the Test Score Form Validation Table (STVTEFR)
INVALID_TEPR_CODEInvalid value for Test Score Purpose code
An attempt was made to create or update the test score purpose code with an invalid test score purpose code. The te
st score purpose code must exist in the Test Score Purpose Validation Table (STVTEPR)
INVALID_TERM_CODE_ENTRYInvalid value for Test Score Term code
An attempt was made to create or update the test score term code with an invalid test score term code. The test score term code must exist on the Term Code Validation Table (STVTERM)
INVALID_TESC_CODEInvalid value for Test Score code
An attempt was made to create or update the test score code with an invalid test score code. The test score code must exist on the Test Score Validation Table (STVTESC)
INVALID_TEST_DATEInvalid value for Test Score Date
An attempt was made to create or update the test score date with a value greater than the current date
INVALID_TEST_SCOREInvalid value for Test Score
An attempt was made to create or update the test score with a value whose length is invalid or contains non-numeric values
INVALID_TSRC_CODEInvalid value for Test Score Source
An attempt was made to create or update the test score source code with an invalid test score source code. The test
score source code must exist in the Test Code Source Validation Table (STVTSRC)
MISSING_EQUIV_INDMissing mandatory value for Test Score Equivalency indicator
An attempt was made to create or update the test score record with a missing equivalency indicator
MISSING_PIDMMissing mandatory value for the unique identifier (PIDM)
An attempt was made to create or update the internal identification number. This is a required key value
MISSING_TESC_CODEMissing mandatory value for Test Score Code
An attempt was made to create or update the test score record without passing the test score code. This is a required key value
MISSING_TEST_DATEMissing mandatory value for Test Score Date
An attempt was made to create or update the test score record without passing the test score date taken. This is a required key value
MISSING_TEST_SCOREMissing mandatory value for Test Score
An attempt was made to create or update test score without passing the test score
PK_NOT_FOUNDCannot find record using primary or unique key
The test score record does not exist
P_DELETE_FAILEDCannot delete, the record does not exist
The test score record cannot be deleted because it did not exist
RECORD_EXISTSCannot create, the record already exists
The test score record cannot be created because it already exists


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.