Search Results igf_aw_gen




Overview
Explore in AI Chat

Overview

IGF_AW_GEN is a PL/SQL package body in the APPS schema that supports the Oracle E-Business Suite Financial Aid subsystem, specifically the Award (AW) module. It serves as a general-purpose maintenance and processing engine for award, disbursement, fund, and financial-aid baseline records. Rather than exposing a public API, IGF_AW_GEN gathers a collection of utility, update, and validation routines used during award generation, disbursement processing, and notification handling. Its documented status is VALID in both the 12.1.1 and 12.2.2 releases, and it is classified as an OTHER API within the ETRM documentation. The package has an exceptionally wide integration footprint: it is referenced by 190 other database objects, indicating that it sits near the center of the Financial Aid Award dependency graph and is invoked by award, disbursement, loan, and baseline-record packages throughout the module.

Key Procedures and Functions

The ETRM metadata documents sixteen procedures and functions. Their names indicate the following purposes:

Tables Accessed

The package reads and writes a broad set of Financial Aid tables through APPS synonyms. Award data is handled via IGF_AW_AWARD_ALL, IGF_AW_AWARD_PRD, IGF_AW_AWD_DISB_ALL, IGF_AW_AWD_DIST_PLANS, IGF_AW_AWD_PRD_TERM, IGF_AW_DP_TEACH_PRDS, and IGF_AW_DP_TERMS. Fund data is accessed through IGF_AW_FUND_CAT_ALL and IGF_AW_FUND_MAST_ALL. Baseline and matched record tables include IGF_AP_FA_BASE_REC_ALL and IGF_AP_ISIR_MATCHED_ALL. Disbursement detail is handled through IGF_DB_AWD_DISB_DTL_ALL. Setup and control tables include IGF_SL_CL_SETUP_ALL and IGS_CA_INST_ALL. FND_CONCURRENT_PROGRAMS_TL is queried for concurrent program names. It also interacts with package objects IGF_AP_FA_BASE_REC_PKG, IGF_AW_AWARD_PKG, IGF_AW_FUND_MAST_PKG, IGF_DB_AWD_DISB_DTL_PKG, IGF_SL_AWARD, IGF_SL_LOANS_PKG, IGF_SL_GEN, IGS_GE_GEN_003, and IGS_GE_MSG_STACK for error handling, messaging, and cross-package processing.

Usage Notes

IGF_AW_GEN is not an end-user form package; it is invoked programmatically from award and disbursement processing flows, concurrent programs, and dependent Financial Aid packages. Because 190 objects reference it, changes to its internal logic carry broad regression risk and should be validated against award generation, disbursement, fund control, and notification scenarios. Error handling is routed through APP_EXCEPTION, FND_MESSAGE, FND_LOG, and IGS_GE_MSG_STACK, allowing exceptions and messages to surface correctly in concurrent manager logs and forms. When troubleshooting award or disbursement discrepancies in 12.1.1 or 12.2.2, the documented routines UPDATE_AWARD, UPDATE_DISB, UPDATE_FMAST, and IS_FUND_LOCKED_FOR_AWD_PERIOD are the primary entry points to review.