index

Package sb_learnermodule_str

This package contains the error messages and error message functions for the Learner Module API (sb_learnermodule).

Message Key Error Message
INVALID_LMOD_CODEInvalid value for the Learner Module
An attempt was made to create or update the Learner Module to a value not found in the Learner Module Validation table (STVLMOD).
INVALID_MAX_CURRICULAInvalid value for Learner Module  maximum curricula
An attempt was made to create or update the Learner Module maximum number of curricula to a value less than 0.
INVALID_SYS_REQ_INDInvalid system required indicator for Learner Module
An attempt was made to create or update the System Required indicator for a Learner Module with a value other than 'Y' or 'N'.
MISSING_LMOD_CODEMissing mandatory value for Learner Module Code
The Learner Module code is missing and must be a valid code in the Learner Module Validation table (STVLMOD).
MISSING_MAX_CURRICULAMissing mandatory value for Learner Module maximum curricula
The Learner Module maximum curricula is missing and must be a valid integer greater than 0.
MISSING_SYS_REQ_INDMissing mandatory value for Learner Module system-required indicator
The Learner Module system-required indicator is missing and must be 'Y' (Yes) or 'N' (No).
MISSING_USER_IDMissing mandatory value for Learner Module User ID
The Learner Module User ID is missing.
PK_NOT_FOUNDCannot find record using Learner Module code
An attempt to update or delete a Learner Module record was unsuccessful because the record could not be found using the primary key of Learner Module code.
P_DELETE_FAILEDCannot delete, Learner Module record does not exist
An attempt to delete a Learner Module was unsuccessful because the record could not be found.
RECORD_EXISTSCannot create, Learner Module record already exists
An attempt to create a Learner Module was unsuccessful because the record already exists; duplicates are not allowed.
RECORD_REQUIREDCannot delete, Learner Module record is required
An attempt to delete a Learner Module was unsuccessful because the Learner Module is system required.
SORLCUR_EXISTSCannot delete, Learner Curriculum (SORLCUR) record exists
An attempt to delete a Learner Module was unsuccessful because there is a corresponding Learner Curriculum record.


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 error message corresponding to p_errorname.

Parameters
p_errorname   Name associated with the error message.

Returns
Error message corresponding to p_errorname.