index

Package sb_scp_ruletimestat_lvl_str

Error messages and error message functions for the SCP_RULETIMESTAT_LVL API (sb_scp_ruletimestat_lvl).
This package contains the error messages and error message functions for SB_SCP_RULETIMESTAT_LVL.

Message NameError Message
INVALID_CAMP_CODEInvalid camp code.
Campus code should be a valid code from STVCAMP table.
INVALID_COLL_CODEInvalid college code.
College code should be a valid code from STVCOLL table.
INVALID_DEGC_CODEInvalid degree code.
Degree code should be a valid code from STVDEGC table.
INVALID_LEVL_CODEInvalid level code.
Level code should be a valid code from STVLEVL table.
INVALID_LEVL_CODE_CRSEInvalid level of course code.
Level of course code should be a valid code from STVLEVL table.
INVALID_MAJR_CODEInvalid major code.
Major code should be a valid code from STVMAJR table.
INVALID_SCPS_CODE_EFFInvalid student centric period code.
Period code should be a valid code from SOBSCPS table.
INVALID_STYP_CODEInvalid STYP code.
Student type code should be a valid code from STVSTYP table.
INVALID_TMST_CODEInvalid TMST code.
Time status code should be a valid code from STVTMST table.
MISSING_LEVL_CODE_CRSEMissing level of course code.
Level of course code is missing.
MISSING_SCPS_CODE_EFFMissing student centric period code.
Student Centric period code is missing.
MISSING_TMST_CODEMissing TMST code.
Time status code is missing.
PK_NOT_FOUNDCannot find time status rule level record using primary or unique key.
Time status rule level doesnot exists.
P_DELETE_FAILEDCannot delete time status rule level because the record does not exist.
Cannot delete time status rule level because the record does not exist.
RECORD_EXISTSTime status rule level already exists, record not created.
Time status rule level 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.