index

Package sb_scp_continuant_str

Error messages and error message functions for the SCP_CONTINUANT API (sb_scp_continuant).
This package contains the error messages and error message functions for SB_SCP_CONTINUANT.

Message NameError Message
INVALID_SCPS_CODE_CONTInvalid or missing value for continuant student centric period code.
An attempt was made to create or update continuant student centric period record without passing the student centric period code. This is a required key value.
INVALID_STYP_CODEInvalid or missing value for Student type.
An attempt was made to create or update continuant student centric period record without passing the student type. This is a required key value.
INVALID_TERM_CODEInvalid or missing value for Term.
An attempt was made to create or update continuant student centric period record without passing the term code. This is a required key value.
INVALID_USERInvalid or missing value for Banner User ID.
An attempt was made to create or update continuant student centric period record without passing the banner User ID who created the record . This is a required key value.
MISSING_PARENTInvalid or missing value for Term code.
An attempt was made to create or update continuant student centric period record without passing the term code. This is a required key value.
MISSING_SCPS_CODE_CONTMissing mandatory value for continuant Student centric period code.
An attempt was made to create or update continuant student centric period record without passing the student centric period code. This is a required key value.
MISSING_STYP_CODEMissing mandatory value for Student type.
An attempt was made to create or update continuant student centric period record without passing the student type. This is a required key value.
MISSING_TERM_CODEMissing mandatory value for Term.
An attempt was made to create or update continuant student centric period record without passing the term code. This is a required key value.
MISSING_USERMissing mandatory value for Banner user.
An attempt was made to create or update continuant student centric period record without passing the banner User ID who created the record . This is a required key value.
PK_NOT_FOUNDCannot find record using primary or unique key.
The continuant student centric period record with the primary key that was passed does not exist
P_DELETE_FAILEDCannot delete, record does not exist.
The student centric period record cannot be deleted because it does not exist.
RECORD_EXISTSStudent centric period record already exists.Cannot create or update
The student centric period record cannot be created or updated because it 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.