index

Package sb_scp_ruletimestat_strings

Error messages and error message functions for the SCP_RULETIMESTAT API (sb_scp_ruletimestat).
This package contains the error messages and error message functions for SB_SCP_RULETIMESTAT.

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_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_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 record using primary or unique key.
Time status rule doesnot exists.
P_DELETE_FAILEDCannot delete time status rule because the record does not exist.
Cannot delete time status rule because the record does not exist.
RECORD_EXISTSTime status rule already exists, record not created.
Time status rule 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.