Search Results igs_ge_unhandled_exp

Overview

IGS_AD_GEN_009 is a PL/SQL package body owned by the APPS schema in Oracle E-Business Suite, classified under the Student System (IGS) admissions product family. Its business purpose is to resolve system-level default status codes for admissions processing. In the Oracle Student System data model, admissions entities such as conditional offers, documentation requirements, entry qualifications, fees, offer formats, offer responses, organizational units, and unit organizational units are each governed by a status lookup table. Each status table contains both a user-defined status code and a corresponding system status code, linked through a system_default_ind flag and a closed_ind flag. This package provides the translation layer between those two representations.

The package is a utility-style API (ETRM classification: OTHER) rather than a business transaction API. It contains no insert, update, or delete logic; every routine is a read-only lookup function that returns a single status value given its system-level counterpart.

Key Procedures and Functions

The package exposes eight documented functions, each corresponding to one admissions status domain. All follow a consistent naming convention prefixed with ADMP_GET_SYS_:

• ADMP_GET_SYS_ACOS — Returns the user-defined system default admission conditional offer status for a given system admission conditional offer status. This is the first routine in the package body and defines the error-handling pattern repeated throughout.
• ADMP_GET_SYS_ADS — Returns the system default admission documentation status for a given system admission documentation status.
• ADMP_GET_SYS_AEQS — Returns the system default admission entry qualification status.
• ADMP_GET_SYS_AFS — Returns the system default admission fee status.
• ADMP_GET_SYS_AODS — Returns the system default admission offer detail format status.
• ADMP_GET_SYS_AORS — Returns the system default admission offer response status.
• ADMP_GET_SYS_AOS — Returns the system default admission offer status.
• ADMP_GET_SYS_AUOS — Returns the system default admission unit organizational unit status.

A shared behavioural characteristic, visible in the source of ADMP_GET_SYS_ACOS, is the treatment of ambiguity: the lookup cursor filters on system_default_ind = 'Y' and closed_ind = 'N', and if more than one row is returned, the function returns NULL rather than an arbitrary value. If no row is found, NULL is likewise returned. Callers must therefore treat a NULL result as "no unambiguous system default defined" rather than an error.

Tables Accessed

Each function queries exactly one status table, referenced through an APPS synonym. The documented tables are:

• IGS_AD_CNDNL_OFRSTAT — conditional offer statuses, read by ADMP_GET_SYS_ACOS.
• IGS_AD_DOC_STAT — admission documentation statuses, read by ADMP_GET_SYS_ADS.
• IGS_AD_ENT_QF_STAT — entry qualification statuses, read by ADMP_GET_SYS_AEQS.
• IGS_AD_FEE_STAT — admission fee statuses, read by ADMP_GET_SYS_AFS.
• IGS_AD_OFRDFRMT_STAT — offer detail format statuses, read by ADMP_GET_SYS_AODS.
• IGS_AD_OFR_RESP_STAT — offer response statuses, read by ADMP_GET_SYS_AORS.
• IGS_AD_OU_STAT — admission organizational unit statuses, read by ADMP_GET_SYS_AOS.
• IGS_AD_UNIT_OU_STAT — admission unit organizational unit statuses, read by ADMP_GET_SYS_AUOS.

All access is read-only via explicit cursors. No table in this package is modified.

Usage Notes

The package is referenced by twenty other packages in the E-Business Suite, indicating broad internal reuse across the admissions and offer-management flows. It is typically invoked from PL/SQL business logic where a system-level status must be mapped back to the institution's user-defined status before persistence, validation, or display. Because the routines are pure lookup functions with no side effects, they are safe to call from forms, concurrent programs, and custom extensions alike.

Error handling follows the standard EBS pattern: the WHEN OTHERS handler registers message IGS_GE_UNHANDLED_EXP — the identifier matched by the search term igs_ge_unhandled_exp — sets the NAME token to the fully qualified routine name, pushes the message stack via IGS_GE_MSG_STACK.ADD, and re-raises through App_Exception.Raise_Exception. When troubleshooting this token in 12.1.1 or 12.2.2, the token value identifies which of the eight functions failed, since each routine sets a distinct NAME token such as IGS_AD_GEN_009.admp_get_sys_acos. Callers should also expect and handle NULL returns for missing or multiply-defined system defaults.