index

Package sp_grading_str

NOTE: Please be advised that this API is currently intended to only support internal operations.
To ensure data integrity, this API is not supported when called by external applications or interfaces to manipulate data. The recommendation for external applications is to use message level integration to integrate with this entitity in Banner.

This package contains the error messages and error message functions for the Grading API (sp_grading).

Message KeyError Message
FACULTY_NOT_ASSIGNEDInstructor not assigned to section
The grade submitted could not be posted because the instructor is not assigned to the section (CRN) for the term.
FGRADE_COMP_EXISTGradable components exist; generate final grade through component marks
The final grade submitted could not be posted because the section has gradable components which must be used to generate the final grade.
GRADE_POSTEDGrade already posted to student enrollment; no update performed
The final grade submitted could not be posted because it has already been posted to academic history.
GRADE_ROLLEDGrade already rolled to history
The final grade submitted could not be posted because it has already been rolled to academic history.
INVALID_GRADEGrade not valid for section
The grade submitted could not be posted because it is not valid for the term and grade for the section (CRN).
INVALID_INCMP_FINAL_GRADENot valid incomplete final default grade
The incomplete final default grade submitted could not be posted because it is not valid.
INVALID_SECTIONSection does not exist
The grade submitted could not be posted because the section (CRN) does not exist for the term.
INVALID_SECT_GRADESection is not gradable
The grade submitted could not be posted because the section (CRN) does not allow a grade to be entered.
MGRADE_COMP_EXISTGradable components exist; generate midterm grade through component marks
The midterm grade could not be posted because the section has gradable components which must be used to generate the midterm grade.
MISSING_CRSE_ENRLLearner course enrollment does not exist
The grade submitted could not be posted because the learner's course enrollment status does not allow a grade to be entered.
MISSING_ENRLLearner enrollment does not exist
The grade submitted could not be posted because the learner enrollment does not exist for the section (CRN) and term.
MISSING_GRDE_CODE_INCMP_FINALIncomplete default final grade does not exist; required when incomplete extension date entered
The extension date submitted could not be posted because incomplete default final grade does not exist.
MISSING_INCOMPLETE_EXT_DATEIncomplete extension does not exist; required when incomplete default final entered
The incomplete default final grade submitted could not be posted because extension date does not exist.
NOT_GRADABLELearner enrollment is not gradable
The grade submitted could not be posted because the learner's enrollment status does not allow a grade to be entered.
RESTRICTED_TO_INCMPCannot enter a default final grade when assigned grade is not an incomplete
The default final grade submitted could not be posted because it is not an incomplete grade.


Program units
f_get_error   Returns an error message corresponding to p_errorname.

Variables
error_tab   Global error table that holds the error message.


error_tab

error_tab gb_common_strings.errmsg_tab_type;

Global error table that holds the error message.


f_get_error

Function f_get_error(p_errorname VARCHAR2) return varchar2

Returns an error message corresponding to p_errorname.

Parameters
p_errorname   Name associated with the error message.