index

Package sb_athletic_competition_str

The package contains the error messages and error message functions for the Athletic Competition API (sb_athletic_competition).

Message KeyError Message
MISSING_PIDMUnique identifier (PIDM) is missing
Unique identifier (PIDM) is required for the athletic competition record and cannot be null.
MISSING_TERM_CODETerm code is missing
Term code is required for the athletic competition record and cannot be null.
MISSING_ACTC_CODESport code is missing
Sport code is required for the athletic competition record and cannot be null.
MISSING_SEQ_NOSequence number is missing
Sequence number is required for the athletic competition record and cannot be null.
MISSING_CURRENT_INDCurrent indicator is missing
Current indicator is required for the athletic competition record and cannot be null.
MISSING_SEASONS_AVAILABLESeasons available is missing
Seasons available is required for the athletic competition record and cannot be null.
MISSING_SEASON_USED_INDSeason used is missing
Season used is required for the athletic competition record and cannot be null.
MISSING_USER_IDUser ID is missing
User ID is required for the athletic competition record and cannot be null.
MISSING_CREATE_ACTIVITY_DATERecord creation activity date is missing
Record creation activity date is required for the athletic competition record and cannot be null.
MISSING_CREATE_USER_IDRecord creation user ID is missing
Record creation user ID is required for the athletic competition record and cannot be null.
INVALID_PIDMInvalid unique identifier (PIDM)
Unique identifier (PIDM) for athletic competition record must be valid.
INVALID_USER_IDInvalid user ID
User ID for athletic competition record must be valid.
INVALID_TERM_CODEInvalid term code
Term code for athletic competition record must exist in the STVTERM table.
INVALID_ACTC_CODEInvalid sport code
Sport code for athletic competition record must exist in the STVACTC table.
INVALID_SEQ_NOInvalid sequence number
Sequence number for athletic competition record must be valid.
INVALID_SEASONS_AVAILABLEInvalid seasons available
Value entered for seasons available for athletic competition record is not valid.
INVALID_SEASON_USED_INDInvalid season used indicator
Value entered for season used indicator for athletic competition record must be Y or N.
INVALID_CREATE_ACTIVITY_DATEInvalid record creation activity date
Record creation activity date for athletic competition record is not valid.
INVALID_CREATE_USER_IDInvalid record creation user ID
Record creation user ID for athletic competition record is not valid.
INVALID_SARE_CODEInvalid reason code
Reason code for athletic competition record must exist in the STVSARE table.
INVALID_ELIG_BEGIN_TERM_CODEInvalid eligibility begin term code
Eligibility begin term code for athletic competition record must exist in the STVTERM table.
INVALID_ELIG_END_TERM_CODEInvalid eligibility end term code
Eligibility end term code for athletic competition record must exist in the STVTERM table.
INVALID_DATA_ORIGINInvalid data origin
Data origin for athletic competition record is not valid.
CURRENT_ALREADY_EXISTSCurrent record already exists
Current athletic competition record already exists.
P_DELETE_FAILEDCannot delete the record because it does not exist
Cannot delete the athletic competition record because it does not exist.
PK_NOT_FOUNDCannot find the athletic competition record using the primary or unique key
Cannot find the athletic competition record using the primary or unique key.
RECORD_EXISTSCannot create a new record because the record already exists
The new athletic competition 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.