index

Package sb_learnercurricstatus_str

This package contains the error messages and error message functions for the Learner Curriculum Status API (sb_learnercurricstatus).

Message Key Error Message
INVALID_ACTIVE_INDInvalid learner curriculum activity status indicator value, must be Y or N
An attempt was made to create or update the learner curriculum activity status indicator to a value other than 'Y' (active) or 'N' (not active).
INVALID_CACT_CODEInvalid status code for learner curriculum activity status
An attempt was made to create or update the curriculum activity status code with an invalid value.  The code must exist as a valid code on the learner curriculum activity validation table (STVCACT).
INVALID_SYS_REQ_INDInvalid system required indicator for learner curriculum activity status
An attempt was made to create or update the system required indicator for a learner curriculum activity status with a value other than 'Y' or 'N'.
INVALID_USER_IDInvalid user ID for a learner curriculum activity status
An attempt was made to create or update the user ID for a learner curriculum activity status to an invalid value.
MISSING_ACTIVE_INDMissing active indicator for learner curriculum activity status
The active indicator for learner curriculum activity status is missing and must be 'Y' or 'N'.
MISSING_CACT_CODEMissing learner curriculum activity status code
The learner curriculum activity status code is missing and is required.
MISSING_SYS_REQ_INDMissing system required indicator for learner curriculum activity status
The learner curriculum activity status system required indicator is missing and must be designated with a 'Y'(Yes) or 'N'(No).
MISSING_USER_IDMissing User ID for learner curriculum activity status
The learner curriculum activity status user ID is missing and must be designated with a valid value.
PK_NOT_FOUNDCannot find learner curriculum activity status record using primary or unique key
An attempt to update or delete a learner curriculum activity status was unsuccessful because the record could not be found using the primary key of curriculum activity status code.
P_DELETE_FAILEDCannot delete, learner curriculum activity status record does not exist
An attempt to delete a learner curriculum activity status was unsuccessful because the record could not be found.
RECORD_EXISTSCannot create, learner curriculum activity status record already exists
An attempt to create a learner curriculum activity status was unsuccessful because the record already exists; duplicates are not allowed.
RECORD_REQUIREDCannot delete, learner curriculum activity status record is required for the system
An attempt to delete a learner curriculum activity status was unsuccessful because the learner curriculum activity status is system required.
SORLCUR_EXISTSCannot delete, learner curriculum table exists
An attempt was made to delete a learner curriculum activity status when a learner curriculum table exists.
SORLFOS_EXISTSCannot delete, learner curriculum field of study exists
An attempt was made to delete a learner curriculum activity status when a learner curriculum field of study exists.


Program units
f_get_error  

Variables
error_tab  


error_tab

error_tab gb_common.errmsg_tab_type;

PL/SQL table type to hold API-specific error message strings.


f_get_error

Function f_get_error(p_errorname VARCHAR2) return varchar2

Returns the error message corresponding to p_errorname.

Parameters
p_errorname   Name associated with the error message.

Returns
Returns the error message corresponding to p_errorname.