BANINST1@S10B80

index

Package sb_estimated_grades_strings

This package contains the error messages and error message functions for SB_ESTIMATED_GRADES.

Message NameError Message
INVALID_CRNCRN is not valid.
The CRN must exist in the section table for the same term as the Feedback Session.
INVALID_FACULTY_PIDMFaculty Pidm is not valid.
The Faculty Pidm must exist in Spriden table.
INVALID_SFBFFSC_IDFeedback Session Id is not valid.
There is no Feedback Session with the give Feedback Session surrogate id.
INVALID_STATUS_INDThe Feedback Status is not valid.
Valid values are O,M and C.
INVALID_STUDENT_PIDMStudent Pidm is not valid.
The Student Pidm must exist in the Spriden table.
MISSING_CRNRequired CRN is missing.
This value is required.
MISSING_DATA_ORIGINRequired Data Origin is missing.
This value is required.
MISSING_PARENTCannot create estimated_grades(sb_estimated_grades) because the the Feedback Session does not exist.
You must supply a valid Feedback Session Id to create the Estimated Grade record.
MISSING_SFBFFSC_IDRequired Feedback Session Id is missing.
This value is required.
MISSING_STATUS_CDERequired Feedback Status is missing.
This value is required.
MISSING_STUDENT_PIDMRequired Student Pidm is missing.
This value is required.
MISSING_SURROGATE_IDRequired Surrogate Id is missing.
This value is required.
MISSING_USER_IDRequired User Id is missing.
This value is required.
MISSING_VERSIONRequired Version number is missing.
This value is required.
PK_NOT_FOUNDCannot find record using primary or unique key for the sb_estimated_grades API.
There is no Estimated Grade record in the table with this key.
P_DELETE_FAILEDCannot delete estimated_grades(sb_estimated_grades) because the record does not exist.
Someone may have deleted the record while you were working on it. Requery and try the operation again.
RECORD_EXISTSCannot create estimated_grades(sb_estimated_grades) because the record already exists.
There already is an Estimated Grade record for this person for this course and feedback session.


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.