index

Package sb_highschool_strings

This package contains the error messages and error message functions for the High School API (sb_highschool).

Message KeyError
 Message
ADMR_DUPLAdmission checklist request code has been used for another high school, and cannot be duplicated
An attempt was made to assign an admissions request code to the high school that was already assigned to a high school record for this person
CLASS_RANKClass rank may not be greater than class size
An attempt was made to assign a class rank greater than class size
INVALID_ADMR_CODEInvalid value for High School Admissions Checklist Request code
An attempt was made to create or update the high school admissions request checklist code with an invalid value.
The admissions request checklist code must exist in the Admissions Request Checklist Validation Table (STVADMR)
INVALID_COLL_PREP_INDInvalid College Preparatory Indicator for high school.
An attempt was made to create or update the high school college preparatory indicator with a value other than 'Y' or 'N'
INVALID_DPLM_CODEInvalid Diploma Type Code for high school
An attempt was made to create or update the high school Diploma Type code with an invalid value. The Diploma Type code must exist in the Diploma Type Code Validation Table (STVDPLM)
INVALID_PIDMInvalid or missing value for the unique identifier (PIDM)
An attempt was made to create or update the high school record by passing a high school internal identification number that does not exist
INVALID_SBGI_CODEInvalid or missing value for High School Code
An attempt was made to create or update the high school record with an invalid High School Code. The High School code must exist on the Source/Background Institution Code Validation Table (STVSBGI)
MISSING_PIDMMissing mandatory value for the unique identifier (PIDM)
An attempt was made to create or update the high school record without passing the high school internal identification number. This is a required key value
MISSING_SBGI_CODEMissing mandatory value for High School Code
An attempt was made to create or update the high school record without passing the high school code. This is a required key value
PK_NOT_FOUNDCannot find record using primary or unique key
The high school record does not exist
P_DELETE_FAILEDCannot delete, the record does not exist
The high school record cannot be deleted because it does not exist
RECORD_EXISTSCannot create, record already exists
The high school record cannot be created because it already exists
SUBJ_EXISTCannot delete High School record, subject records exist
The high school record cannot be deleted because high school subject records exist for the high school


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.