index

Package sb_athletic_transfer_strings

This package contains the error messages and error message functions for the Athletic Transfer API (sb_athletic_transfer).

Message KeyError Message
MISSING_PIDMUnique identifier (PIDM) is missing
Unique identifier (PIDM) is required for the athletic transfer record and cannot be null.
MISSING_TRANS_ELIGIBLE_INDValue for the Eligible To Transfer indicator is missing
Eligible to Transfer indicator is required for the athletic transfer record and cannot be null.
MISSING_RES_REQ_INDValue for the Residency Requirement indicator is missing
Residency Requirement indicator is required for the athletic transfer record and cannot be null.
MISSING_RES_EXCP_INDValue for the Residency Exception indicator is missing
Residency Exception indicator is required for the athletic transfer record and cannot be null.
MISSING_MET_CREDIT_YR_INDValue for the Met Academic Credit Year indicator is missing
Met Academic Credit Year indicator is required for the athletic transfer record and cannot be null.
MISSING_USER_IDUser ID is missing
User ID is required for the athletic transfer record and cannot be null.
INVALID_PIDMInvalid unique identifier (PIDM)
Unique identifier (PIDM) for athletic transfer record must be valid.
INVALID_USER_IDInvalid user ID
User ID for athletic transfer record must be valid.
INVALID_TRANS_ELIGIBLE_INDInvalid Eligible to Transfer indicator
Eligible to Transfer indicator for athletic transfer record must be Y or N.
INVALID_RES_REQ_INDInvalid Residency Requirement indicator
Residency Requirement indicator for athletic transfer record must be Y or N.
INVALID_RES_EXCP_INDInvalid Residency Exception indicator
Residency Exception indicator for athletic transfer record must be Y or N.
INVALID_MET_CREDIT_YR_INDInvalid Met Academic Credit Year indicator
Met Academic Credit Year indicator for athletic transfer record must be Y or N.
INVALID_HS_CORE_COURSESInvalid value for High School Core Courses
Value for High School Core Courses for athletic transfer record must be valid.
INVALID_TRANS_QUALITY_POINTSInvalid value for Transfer Quality Points
Value for Transfer Quality Points for athletic transfer record must be valid.
INVALID_TRANS_GPAInvalid value for transfer GPA
Value for Transfer GPA for athletic transfer record must be valid.
INVALID_TRANS_TERMS_ATTENDEDInvalid value for Transfer Terms Attended
Value for Transfer Terms Attended for athletic transfer record must be valid.
INVALID_TRANS_HOURS_ATTEMPTEDInvalid value for Transfer Attempted Hours
Value for Transfer Attempted Hours for athletic transfer record must be valid.
INVALID_TRANS_HOURS_EARNEDInvalid value for Transfer Hours
Value for Transfer Hours for athletic transfer record must be valid.
INVALID_SATR_CODEInvalid transfer status
Transfer status for athletic transfer record must exist in the STVSATR table.
INVALID_TRANS_ACCEPT_DATEInvalid transfer acceptance date
Transfer acceptance date for athletic transfer record must be valid.
INVALID_DATA_ORIGINInvalid data origin
Data origin for athletic transfer record must be valid.
P_DELETE_FAILEDCannot delete the record because it does not exist
Cannot delete the athletic transfer record because it does not exist.
PK_NOT_FOUNDCannot find the record using the primary or unique key
Cannot find the athletic transfer record using the primary or unique key.
RECORD_EXISTSCannot create a new record because the record already exists
The new athletic transfer 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.