index

Package sb_athletic_acad_prog_strings

Error messages and error message functions for the Athletic Academic Progress API (sb_athletic_acad_prog).

Message KeyError Message
MISSING_PIDMUnique identifier (PIDM) is missing
Unique identifier (PIDM) is required for the athletic academic progress record and cannot be null.
MISSING_TERM_CODETerm code is missing
Term code is required for the athletic academic progress record and cannot be null.
MISSING_SEQ_NOSequence number is missing
Sequence number is required for the athletic academic progress record and cannot be null.
MISSING_ACTIVE_INDActive indicator is missing
Active indicator is required for the athletic academic progress record and cannot be null.
MISSING_USER_IDUser ID is missing
Unique identifier (PIDM) value is required for the athletic academic progress record and must be not null.
INVALID_PIDMInvalid unique identifier (PIDM)
Unique identifier (PIDM) for the athletic academic progress must be valid.
INVALID_TERM_CODEInvalid term code
Term code for the athletic academic progress record must exist on the STVTERM table.
INVALID_SEQ_NOInvalid sequence number
Sequence number for the athletic academic progress record must be numeric.
INVALID_ACTIVE_INDInvalid active indicator
Active indicator for the athletic academic progress record must be Y or N.
INVALID_USER_IDInvalid user ID
User ID for the athletic academic progress record must be valid.
INVALID_SINGLE_TERM_HOURSInvalid value for Single Term Hours
Number of hours reported for athletic academic progress for a single term is not in a valid format.
INVALID_TERM_1_HOURSInvalid value for Term 1 Hours
Number of hours reported for athletic academic progress for the first term of the academic year is not in a valid format.
INVALID_TERM_2_HOURSInvalid value for Term 2 Hours
Number of hours reported for athletic academic progress for the second term of the academic year is not in a valid format.
INVALID_TERM_3_HOURSInvalid value for Term 3 Hours
Number of hours reported for athletic academic progress for the third term of the academic year is not in a valid format.
INVALID_TOTAL_YEAR_HOURSInvalid value for Total Year Hours
Total number of hours reported for athletic academic progress for the academic year is not in a valid format.
INVALID_DATA_ORIGINInvalid data origin
Data origin for the athletic academic progress record is not valid.
P_DELETE_FAILEDCannot delete the record because it does not exist
Cannot delete the athletic academic progress record because it does not exist.
PK_NOT_FOUNDCannot find the record using the primary or unique key
Cannot find the athletic academic progress record using the primary or unique key.
RECORD_EXISTSCannot create a new record because the record already exists
The new athletic academic progress 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.