index

Package sb_recruit_str

This package contains the error messages and error message functions for the Recruit API (sb_recruit).

Message KeyError Message
MISSING_PIDMMissing mandatory value for SRBRECR_PIDM
An attempt was made to create or update the recruit record without passing the recruit internal identification number.  This is a required key value.
MISSING_TERM_CODEMissing mandatory value for Recruit Term Code
An attempt was made to create or update the recruit record without passing the term code.  This is a required key value.
MISSING_ADMIN_SEQNOMissing mandatory value for Recruit Admin sequence number
An attempt was made to create or update the recruit record without passing the administrative sequence number.  This is a required key value.
MISSING_ADD_DATEMissing mandatory value for Recruit Add Date
An attempt was made to create or update the recruit record without passing the date the recruit was added.  This is a required value.
INVALID_PIDMInvalid value for SRBRECR_PIDM
An attempt was made to create or update the recruit record by passing a recruit internal identification number that does not exist.
INVALID_TERM_CODEInvalid value for Recruit Term Code
An attempt was made to create or update the recruit record without a valid term code.  The term code entered does not exist.
INVALID_RECR_CODEInvalid value for Recruiter Code
An attempt was made to create or update the recruit record without a valid recruiter code.
INVALID_RSTA_CODEInvalid value for Recruit Status Code
An attempt was made to create or update the recruit record without a valid recruit status code.
INVALID_SELECT_INDInvalid value for Recruit Selected Indicator
An attempt was made to create or update a recruit record with Selected indicator = Y when one already exists for the term.
INVALID_ADMT_CODEInvalid value for Recruit Admit Code
An attempt was made to create or update the recruit record with an invalid admit type code.  This field may be NULL.
INVALID_EDLV_CODEInvalid value for Recruit Education Level Code
An attempt was made to create or update the recruit record with an invalid education level code.  This field may be NULL.
INVALID_EGOL_CODEInvalid value for Recruit Education Goal Code
An attempt was made to create or update the recruit record with an invalid education goal code.  This field may be NULL.
INVALID_FULL_PART_INDInvalid value for Recruit Full-/Part-Time Indicator
An attempt was made to create or update the recruit record with a value other than 'F' (Full-time), 'P' (Part-time), or NULL.
INVALID_SBGI_CODEInvalid value for Recruit Source Background Code
An attempt was made to create or update the recruit record with an invalid source background code.  This field may be NULL.
INVALID_WRSN_CODEInvalid value for Recruit Withdrawal Reason Code
An attempt was made to create or update the recruit record with an invalid withdrawal reason code.  This field may be NULL.
INVALID_RTYP_CODEInvalid value for Recruit Type Code
An attempt was made to create or update the recruit record with an invalid recruit type code.  This field may be NULL.
INVALID_RESD_CODEInvalid value for Recruit Residence Code
An attempt was made to create or update the recruit record with an invalid residence code.  This field may be NULL.
INVALID_SESS_CODEInvalid value for Recruit Session Code
An attempt was made to create or update the recruit record with an invalid session code.  This field may be NULL.
INVALID_SITE_CODEInvalid value for Recruit Site Code
An attempt was made to create or update the recruit record with an invalid site code.  This field may be NULL.
INVALID_STYP_CODEInvalid value for Recruit Student Type Code
An attempt was made to create or update the recruit record with an invalid student type code.  This field may be NULL.
P_DELETE_FAILEDCannot delete; record does not exist
The recruit record cannot be deleted because it does not exist.
PK_NOT_FOUNDCannot find record using primary or unique key
The recruit record with the primary key that was passed does not exist.
RECORD_EXISTSCannot create, record already exists
The recruit record cannot be created because it already exists.
ERROR_SELECT_INDSelected recruit record already exists
An attempt was made to create or update the recruit record with a value other than 'Y' or NULL for the Selected indicator.
INVALID_ENTITYRecruit record can only be added to a Person entity
An attempt was made to add a recruit record to an entity other than a person.

Program units
f_get_error  

Variables
error_tab  

Constants
FULL_TIME_VALUE  
PART_TIME_VALUE  
SELECT_IND_VALUE  

error_tab 

error_tab gb_common_strings.errmsg_tab_type;

FULL_TIME_VALUE 

FULL_TIME_VALUE CONSTANT VARCHAR2(1) := 'F';

Value assigned to FULL_PART_IND to indicate full-time status.

PART_TIME_VALUE 

PART_TIME_VALUE CONSTANT VARCHAR2(1) := 'P';

Value assigned to FULL_PART_IND to indicate part-time status.

SELECT_IND_VALUE 

SELECT_IND_VALUE CONSTANT VARCHAR2(1) := 'Y';

Value assigned to SELECT_IND to indicate that the recruit row for the term is the preferred one.

f_get_error 

Function f_get_error(p_errorname VARCHAR2) return varchar2

Returns the error message corresponding to p_errorname.

Parameters
p_errorname   Name associated with the error message.