index

Package sb_athletic_compliance_strings

This package contains the error messages and error message functions for the Athletic Compliance API (sb_athletic_compliance).

Message KeyError Message
MISSING_PIDMUnique identifier (PIDM) is missing
Unique identifier (PIDM) is required for the athletic compliance record and cannot be null.
MISSING_TERM_CODETerm code is missing
Term code is required for the athletic compliance record and cannot be null.
MISSING_ACTC_CODEActivity code is missing
Activity code is required for the athletic compliance record and cannot be null.
MISSING_USER_IDUser ID is missing
User ID is required for the athletic compliance record and cannot be null.
INVALID_PIDMInvalid unique identifier (PIDM)
Unique identifier (PIDM) for the athletic compliance record is not valid.
INVALID_TERM_CODEInvalid term code
Term code for the athletic compliance record must exist on the STVTERM table.
INVALID_ACTC_CODEInvalid activity code
Activity code for the athletic compliance record must exist on the STVACTC table
INVALID_SPST_CODEInvalid sport code
Sport code for the athletic compliance record must exist on the STVSPST table.
INVALID_ELIG_CODEInvalid eligibility code
Eligibility code for the athletic compliance record must exist on the STVELIG table.
INVALID_ATHL_AID_INDInvalid athletic aid indicator
Value entered for athletic aid indicator must be Y, N, or null.
INVALID_USER_IDInvalid user ID
User ID for the athletic compliance record is not valid.
INVALID_SAEL_CODEInvalid athletic official eligibility code
Athletic official eligibility code for the athletic compliance record must exist on the STVSAEL table.
INVALID_DATA_ORIGINInvalid data origin
Data Origin for the athletic compliance record is not valid.
P_DELETE_FAILEDCannot delete the record because it does not exist
Cannot delete the athletic compliance record because it does not exist.
PK_NOT_FOUNDCannot find the record using the primary or unique key
Cannot find the athletic compliance record using the primary or unique key.
RECORD_EXISTSCannot create a new record because the record already exists
The new athletic compliance record cannot be created because the record 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.