index

Package sb_facassignment_str

This package contains the error messages and error message functions for the Faculty Assignment API (sb_facassignment).

Message KeyError Message
INACTIVE_FACULTYCannot add assignment; Faculty is not active for this term
An attempt was made to assign an inactive faculty member to a course.  Faculty Assignments must be active for the term specified in SIBINST.
INVALID_ASTY_CODEInvalid Assignment Type Code for faculty assignment
An attempt was made to create or update the Faculty Assignment Type Code with an invalid value.  The Assignment Type Code must exist in the Assignment Type Validation Table (STVASTY).
INVALID_CATEGORYInvalid Category Code for faculty assignment
An attempt was made to create or update the Faculty Assignment Category Code with an invalid value.  The Category Code must exist in the Faculty Category Code Validation Table (STVFCTG).
INVALID_CRNInvalid CRN for faculty assignment
An attempt was made to create or update the Faculty Assignment CRN.  The CRN must be a valid section in SSBSECT.
INVALID_FCNT_CODEInvalid Contract Code for faculty assignment
An attempt was made to create or update the Faculty Assignment Contract Type Code with an invalid value.  The Contract Type Code must exist in the Contract Type Validation Table (STVFCNT).
INVALID_OVER_RIDEConflict override must be O or null for faculty assignment
An attempt was made to create or update the Faculty Assignment Conflict override indicator.  The conflict override indicator must be O or null.
INVALID_PERCENT_RESPONSEInvalid Percent Responsibility for faculty assignment
An attempt was made to create or update the Faculty Assignment Percent Responsibility value.  The percent responsibility value must be a number between 0 and 100.
INVALID_PERCENT_SESSInvalid Session Percentage for faculty assignment
An attempt was made to create or update the Faculty Assignment Session Percentage value.  The session percentage value must be a number between 0 and 100.
INVALID_PIDMInvalid or missing PIDM for faculty assignment
An attempt to create or update faculty assignment information was unsuccessful because a person record does not exist.
INVALID_POSITIONInvalid Position for faculty assignment
An attempt was made to create or update the Faculty Assignment Position Code with an invalid value.  The Position Code must exist in the Employee Jobs Table (NBRJOBS) if the Banner HR system is installed.
INVALID_PRIMARY_INDInvalid Primary Indicator for faculty assignment
An attempt was made to create or update the Faculty Assignment Primary indicator.  The primary indicator must be Y or N.
INVALID_SUFFInvalid Position Suffix for faculty assignment
An attempt was made to create or update the Faculty Assignment Suffix Code with an invalid value.  The Suffix Code must exist in the Employee Jobs Table (NBRJOBS) if the Banner HR system is installed.
INVALID_TERM_CODEInvalid Term Code for faculty assignment
An attempt was made to create or update the Faculty Assignment Term Code with an invalid value.  The Term Code must exist in the Term Code Validation Table (STVTERM).
INVALID_WORKLOAD_ADJUSTInvalid Workload Adjustment for faculty assignment
An attempt was made to create or update the Faculty Assignment Workload Adjustment value.  The Workload Adjustment value must be a number between 0 and 999999.999.
MISSING_CATEGORYMissing mandatory Category Code for faculty assignment
The Faculty Assignment Category Code is missing and must be a valid value in the Category Code Validation Table (STVFCTG).
MISSING_CRNMissing mandatory CRN for faculty assignment
The Faculty Assignment CRN is missing and must be a valid value in the Section table (SSBSECT).
MISSING_PARENTRequired parent record not found for faculty assignment
An attempt to create a Faculty Assignment record was unsuccessful because a parent section record does not exist in the Section table (SSBSECT) for this term code and CRN.
MISSING_PERCENT_RESPONSEMissing mandatory Percent Responsibility for faculty assignment
The Faculty Assignment Percent Responsibility is missing and must be a valid value between 0 and 100.
MISSING_PERCENT_SESSMissing mandatory Session Percentage for faculty assignment
The Faculty Assignment Session Percentage is missing and must be a valid value between 0 and 100.
MISSING_PIDMMissing mandatory PIDM  for faculty assignment
The Faculty Assignment information could not be created because a required value for the PIDM (internal personal identification number) was not provided.
PIDMs provided must exist in general identification table (SPRIDEN).
MISSING_TERM_CODEMissing mandatory Term Code for faculty assignment
The Faculty Assignment Term Code is missing and must be a valid value in the Term Code Validation Table (STVTERM).
MORE_THAN_1_SESSIONMore than one session exists, enter Session ID for faculty assignment
An attempt to create or update a Faculty Assignment record was unsuccessful because more than one meeting time record exists for this term code and CRN and a session ID was not specified.
NO_SESSION_CRNInvalid CRN or CRN has no sessions for faculty assignment
An attempt to create or update a Faculty Assignment record was unsuccessful because a matching CRN does not exist in the Section table (SSBSECT) or no meeting time records exist for this term code and CRN in SSRMEET.
NO_SSRMEET_SESSIONFaculty assignment session has no meeting times defined for section
An attempt to create or update a Faculty Assignment record was unsuccessful because no meeting time records exist for this term code and CRN in (SSRMEET).
ONE_PRIMARYOnly one primary instructor can be defined for CRN for faculty assignment
An attempt to create or update a Faculty Assignment record was unsuccessful because a primary instructor already exists for this term code and CRN with a Primary Indicator of Y.
PK_NOT_FOUNDCannot find record using primary or unique key for faculty assignment
An attempt to find a Faculty Assignment record was unsuccessful because the record could not be found using the primary or unique key of the PIDM (internal personal identification number), Term, CRN and Category.
P_DELETE_FAILEDCannot delete, record does not exist for faculty assignment
An attempt to delete a Faculty Assignment failed because no matching record was found.
RECORD_EXISTSCannot create, record already exists for faculty assignment
An attempt to create a Faculty Assignment record was unsuccessful because the record already exists.
SCHEDULE_CONFLICTInstructor schedule conflict for faculty assignment
An attempt to create or update a Faculty Assignment record was unsuccessful because a schedule conflict for this PIDM (internal personal identification number) exists for this Term and Meeting Time.
@headcom


Program units
f_get_error  

Variables
error_tab  


error_tab

error_tab gb_common_strings.errmsg_tab_type;

Global error message table


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.

Returns
VARCHAR2 Error message associated with the error name.