index

Package sb_athletic_comments_strings

This package contains the error messages and error message functions for the Athletic Comments API (sb_athletic_comments).

Message KeyError Message
MISSING_PIDMUnique identifier (PIDM) is missing
Unique identifier (PIDM) is required for the athletic comments record and cannot be null.
MISSING_SEQNOSequence number is missing
Sequence number is required for the athletic comments record and cannot be null.
MISSING_CMTT_CODEComment type code is missing
Comment type code is required for the athletic comments record and cannot be null.
MISSING_ORIG_CODEOriginator code is missing
Originator code is required for the athletic comments record and cannot be null.
MISSING_USER_IDUser ID is missing
User ID is required for the athletic comments record and cannot be null.
INVALID_PIDMInvalid unique identifier (PIDM)
Unique identifier (PIDM) for the athletic comments record must be valid.
INVALID_SEQNOInvalid sequence number
Sequence number for the athletic comments record must be a valid value.
INVALID_CMTT_CODEInvalid comment type code
Comment type code for the athletic comments record must exist in the STVCMTT table.
INVALID_ORIG_CODEInvalid originator code
Originator code for the athletic comments record must exist in the STVORIG table.
INVALID_USER_IDInvalid user ID
User ID for the athletic comments record must be valid.
INVALID_DATA_ORIGINInvalid data origin
Data origin for the athletic comments is not valid.
P_DELETE_FAILEDCannot delete record because it does not exist.
Cannot delete the athletic comments record because it does not exist.
PK_NOT_FOUNDCannot find the record using the primary or unique key
Cannot find the athletic comments record using the primary or unique key.
RECORD_EXISTSCannot create a new record because the record already exists
The new athletic comments 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.