Package sb_test_percentile

Package sb_test_percentile_strings

This package contains the error messages and error message functions for the Test Percentile API (sb_test_percentile).

Message Key	Error Message
INVALID_PERCENTILE	Invalid value for percentile
An attempt was made to create or update the Test Score Percentile to a value outside the range 0-99.
INVALID_PIDM	Invalid value for unique identifier (PIDM)
An attempt was made to create a test score percentile record with an invalid personal identification number.
INVALID_TESC_CODE	Invalid value for the test code
An attempt was made to create or update the test score percentile test code to a value not found in the STVTESC table.
INVALID_TSPT_CODE	Invalid value for percentile code
An attempt was made to create or update the Test Score Percentile to a value outside the range of 0-99.
MISSING_PARENT	Required parent record not found
An attempt was made to create a test score percentile record when the parent test score record does not exist.
MISSING_PERCENTILE	Missing mandatory value for percentile
The Test Score Percentile is missing and must be a value in the range of 0-99.
MISSING_PIDM	Missing mandatory value for unique identifier (PIDM)
The Test Score Percentile is missing and must be a valid number.
MISSING_TESC_CODE	Missing mandatory value for test code
The Test Score Percentile Test Code is missing and must be a value found in the STVTESC table.
MISSING_TEST_DATE	Missing mandatory value for test date
The Test Code Percentile Test Date is missing and must be a valid date.
MISSING_TSPT_CODE	Missing mandatory value for percentile code
The Test Code Percentile Code is missing and must be a value found in the STVTSPT table.
MISSING_USER_ID	Missing mandatory value for user
The Test Score Percentile User ID is missing.
PK_NOT_FOUND	Cannot find record using primary or unique key
The base test score percentile record does not exist.
P_DELETE_FAILED	Cannot delete, record does not exist
The base test score percentile record cannot be deleted because the record does not exist.
RECORD_EXISTS	Cannot create, record already exists
The base test score percentile record cannot be created because it already exists.

Program units

f_get_error

Variables

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.