Package sb_admissionsapplication

BANINST1@S10B80

Package sb_admissionsapplication_str

This package contains the error messages and error message functions for the Admissions Application API.

Message Key	Error Message
MISSING_PIDM	Missing mandatory value for SARADAP_PIDM
An attempt was made to create or update the application record without passing the applicant internal identification number. This is a required key value.
MISSING_TERM_CODE_ENTRY	Missing mandatory value for Admissions Term Code Entry
An attempt was made to create or update the application record without passing the term code of entry. This is a required key value.
MISSING_APPL_NO	Missing mandatory value for Admissions Application Number
An attempt was made to update the application record without passing the application number. This is a required key value.
MISSING_APST_CODE	Missing mandatory value for Admissions Application Status Code
An attempt was made to update the application record without passing the application status code. This is a required value.
MISSING_APST_DATE	Missing mandatory value for Admissions Application Status Date
An attempt was made to update the application record without passing the application status date. This is a required value.
MISSING_MAINT_IND	Missing mandatory value for Admissions Application Maintenance Indicator
An attempt was made to create or update the application record without passing the application maintenance indicator. This is a required value that must be set to 'S' (System) or 'U'(User).
MISSING_STYP_CODE	Missing mandatory value for Admissions Application Student Type Code
An attempt was made to create or update the application record without passing the student type code. This is a required value.
MISSING_RESD_CODE	Missing mandatory value for Admissions Application Residency Code
An attempt was made to create or update the application record without passing the residency code. This is a required value.
INVALID_PIDM	Invalid value for SARADAP_PIDM
An attempt was made to create or update the application record by passing an applicant insternal identification number that does not exist.
INVALID_TERM_CODE_ENTRY	Invalid value for Admissions Term Code Entry
An attempt was made to create or update the application record without a valid term code. The term code entered does not exist.
INVALID_APST_CODE	Missing mandatory value for Admissions Application Status Code
An attempt was made to create or update the application record without a valid application status code.
INVALID_ADMT_CODE	Invalid value for Admissions Admit Code
An attempt was made to create or update the application record without a valid admission type date.
INVALID_STYP_CODE	Invalid value for Admissions Student Type Code
An attempt was made to create or update the application record with an invalid student type code. This field may not be NULL.
INVALID_SITE_CODE	Invalid value for Admissions Site Code
An attempt was made to create or update the application record with an invalid site code. This field may be NULL.
INVALID_RESD_CODE	Invalid value for Admissions Residency Code
An attempt was made to create or update the application record with an invalid residency code. This field may not be NULL.
INVALID_FULL_PART_IND	Invalid value for Admissions Application Full/Part Time Indicator
An attempt was made to create or update the application record with a value other than 'F' (Full-time) or 'P' (Part-time) for the full- or part-time indicator.
INVALID_SESS_CODE	Invalid value for Admissions Application Session Code
An attempt was made to create or update the application record with an invalid session code. This field may be NULL.
INVALID_WRSN_CODE	Invalid value for Admissions Application Withdrawal Reason Code
An attempt was made to create or update the application record with an invalid withdrawal reason code. This field may be NULL.
INVALID_INTV_CODE	Invalid value for Admissions Application Interview Code
An attempt was made to create or update the application record with an invalid interview code. This field may be NULL.
INVALID_FEE_IND	Invalid value for Admissions Application Fee Indicator
An attempt was made to create or update the application record with a value other than 'Y' (Yes) or 'W' (Waived) for the application fee code.
INVALID_RATE_CODE	Invalid value for Admissions Application Rate Code
An attempt was made to create or update the application record with an invalid rate code. This field may be NULL.
INVALID_EGOL_CODE	Invalid value for Admissions Application Education Goal Code
An attempt was made to create or update the application record with an invalid education goal code. This field may be NULL.
INVALID_EDVL_CODE	Invalid value for Admissions Application Education Level Code
An attempt was made to create or update the application record with an invalid education level code. This field may be NULL.
INVALID_RECR_CODE	Invalid value for Admissions Application Recruiter Code
An attempt was made to create or update the application record with an invalid recruiter code. This field may be NULL.
INVALID_ADMT_CODE	Invalid value for Admissions Application Admit Code
An attempt was made to create or update the application record with an invalid admit code. This field may be NULL.
INVALID_SBGI_CODE	Invalid value for Admissions Application Source Background Code
An attempt was made to create or update the application record with an invalid source background code. This field may be NULL.
INVALID_RTYP_CODE	Invalid value for Admissions Application Recruit Type Code
An attempt was made to create or update the application record with an invalid recruit type code. This field may be NULL.
INVALID_WEB_ACCT_MISC_IND	Invalid value for Admissions Application Web Account Misc Indicator
An attempt was made to create or update the application record with a value other than 'M' (Miscellaneous), 'T' (Transaction) or NULL for the application Web account miscellaneous indicator.
INVALID_WAIV_CODE	Invalid value for Admissions Application Fee Waiver Reason
An attempt was made to create or update the application record with an invalid waiver reason code. This field may be NULL.
P_DELETE_FAILED	Cannot delete; record does not exist
The application record cannot be deleted because it does not exist.
PK_NOT_FOUND	Cannot find record using primary or unique key
The application record does not exist.
RECORD_EXISTS	Cannot create; record already exists
The application record cannot be created because it already exists.
INVALID_ENTITY	Application can only be added to a Person entity
An attempt was made to add an application to an entity other than a person entity.

Program units

f_get_error

Returns the error message corresponding to p_errorname.

Variables

error_tab

Constants

FULL_TIME_VALUE	Value assigned to FULL_PART_IND to indicate full-time status.
PART_TIME_VALUE	Value assigned to FULL_PART_IND to indicate part-time status.
YES_FEE_VALUE	Value assigned to FEE_IND to indicate that the fee is required.
WAIVE_FEE_VALUE	Value assigned to FEE_IND to indicate that the fee is waived.
WEB_MISC_ACCT_VALUE	Value for the miscellaneous receivable if the application fee was paid by credit card via the Web.
WEB_TRAN_ACCT_VALUE	Value for the TBRACCD receivable if the application fee was paid by credit card via the Web.
SYSTEM_MAINT_VALUE	Value assigned to MAINT_IND to indicate that the application status is maintained by the system.
USER_MAINT_VALUE	Value assigned to MAINT_IND to indicate that the application status is maintained by the user.

error_tab

error_tab gb_common_strings.errmsg_tab_type;

FILE NAME..: sokb_admissions_strg0.sql RELEASE....: 7.0 OBJECT NAME: SB_ADMISSIONSAPPLICATION_STR PRODUCT....: STUDENT USAGE......: Error messages and subprograms for admissionsapplication COPYRIGHT..: Copyright (C) SunGard Corporation 2004. All rights reserved.

DESCRIPTION:

Error messages and subprograms for admissionsapplication

DESCRIPTION END

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 error message.

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.

YES_FEE_VALUE

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

Value assigned to FEE_IND to indicate that the fee is required.

WAIVE_FEE_VALUE

WAIVE_FEE_VALUE  CONSTANT VARCHAR2(1) := 'W';

Value assigned to FEE_IND to indicate that the fee is waived.

WEB_MISC_ACCT_VALUE

WEB_MISC_ACCT_VALUE  CONSTANT VARCHAR2(1) := 'M';

Value for the miscellaneous receivable if the application fee was paid by credit card via the Web.

WEB_TRAN_ACCT_VALUE

WEB_TRAN_ACCT_VALUE  CONSTANT VARCHAR2(1) := 'T';

Value for the TBRACCD receivable if the application fee was paid by credit card via the Web.

SYSTEM_MAINT_VALUE

SYSTEM_MAINT_VALUE     CONSTANT VARCHAR2(1) := 'S';

Value assigned to MAINT_IND to indicate that the application status is maintained by the system.

USER_MAINT_VALUE

USER_MAINT_VALUE     CONSTANT VARCHAR2(1) := 'U';

Value assigned to MAINT_IND to indicate that the application status is maintained by the user.