index

Package sb_scp_timestatus_hist_str

Error messages and error message functions for the SCP_TIMESTATUS_HIST API (sb_scp_timestatus_hist).
This package contains the error messages and error message functions for SB_SCP_TIMESTATUS_HIST.

Message NameError Message
INVALID_PIDMInvalid or missing value for PIDM.
An attempt was made to create or update time status record without passing the internal identification number. This is a required key value.
INVALID_SCP_CODEInvalid or missing value for Student Centric Period Code.
An attempt was made to create or update time status record without passing the student centric period code. This is a required key value.
INVALID_TMST_CODEInvalid or missing value for Time Status Code.
An attempt was made to create or update time status record without passing the time status code. This is a required key value.
INVALID_TMST_DATEInvalid or missing value for Time Status Creation Date.
An attempt was made to create or update time status record without passing the date the record was created. This is a required key value.
INVALID_TMST_MAINT_INDInvalid or missing value for Time Status Maintenance Indicator.
An attempt was made to create or update time status record without passing the time status maintenance indicator. This is a required key value.
INVALID_USERInvalid or missing value for Banner User ID.
An attempt was made to create or update time status record without passing the banner User ID who created the record . This is a required key value.
MISSING_PIDMMissing mandatory value for PIDM.
An attempt was made to create or update time status record without passing the internal identification number. This is a required key value.
MISSING_SCP_CODEMissing mandatory value for Student Centric Period Code.
An attempt was made to create or update time status record without passing the student centric period code. This is a required key value.
MISSING_TMST_CODEMissing mandatory value for Time Status Code.
An attempt was made to create or update time status record without passing the time status code. This is a required key value.
MISSING_TMST_DATEMissing mandatory value for Time Status Creation Date.
An attempt was made to create or update time status record without passing the date the record was created. This is a required key value.
MISSING_TMST_MAINT_INDMissing mandatory value for Time Status Maintenance Indicator.
An attempt was made to create or update time status record without passing the time status maintenance indicator. This is a required key value.
PK_NOT_FOUNDCannot find record using primary or unique key.
The time status record with the primary key that was passed does not exist
P_DELETE_FAILEDCannot delete, record does not exist.
The time status record cannot be deleted because it does not exist.
RECORD_EXISTSCannot create, record already exists.
The time status record cannot be created 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.