Search Results igc_debug_enabled

Overview

The APPS.IGC_CC_DET_PF_PKG package body forms part of the Oracle E-Business Suite Grants Management (IGC) application, specifically the Contract Commitment (CC) sub-ledger currently maintained under the legacy 11i-era Grants Accounting codebase that continues to ship in EBS 12.1.1 and 12.2.2. The package encapsulates the database-side business logic associated with the IGC_CC_DET_PF entity, which represents contract commitment detail lines associated with cost or pricing factors. Its principal role is to serve as the persistence layer for the Contract Commitment Detail form (the "PF" suffix denotes the pricing factor detail block), encapsulating the DML operations required to insert, update, delete, and lock commitment detail records in a manner consistent with the Oracle Forms server-side Table Handler interaction pattern.

The package header exposes a debug instrumentation layer through the Output_Debug procedure, which is relevant because the user's search term, igc_debug_enabled, appears directly in the package body header. Line 8 of the source shows a commented-out profile reference to FND_PROFILE.VALUE('IGC_DEBUG_ENABLED'), which was superseded by FND_PROFILE.VALUE('AFLOG_ENABLED') on line 9. This reflects a deliberate migration to the FND_LOG framework around patch 3199488, which standardized Application Object Library logging across EBS modules.

Key Procedures and Functions

The ETRM metadata documents four procedures registered against this package body, all of which are standard Table Handler entry points:

• INSERT_ROW — Creates a new contract commitment pricing factor detail record in IGC_CC_DET_PF and its corresponding row in the intersection table IGC_CC_DET_PF_S, ensuring the surrogate key sequence is advanced correctly.
• LOCK_ROW — Acquires a row-level lock on an existing detail record during form navigation or prior to an update, guaranteeing that concurrent users cannot modify the same commitment line simultaneously.
• UPDATE_ROW — Persists changes to an existing commitment detail record, appending audit columns and keeping the associated account lines consistent.
• DELETE_ROW — Removes a detail record and its related intersection rows, typically following validation against downstream commitments.

The Output_Debug helper is not classified as a documented API procedure but is the mechanism through which the package emits diagnostics, conditioned on the runtime FND_LOG level being greater than or equal to the supplied severity.

Tables Accessed

The package references five tables through APPS synonyms. IGC_CC_DET_PF is the primary detail table holding pricing factor commitments. IGC_CC_DET_PF_S is the surrogate-key sequence/intersection table used to obtain a consistent primary key across detail lines. IGC_CC_HEADERS is consulted to validate header context and enforce parent-child integrity. IGC_CC_ACCT_LINES is touched so that accounting line records remain synchronized with detail changes. FND_APPLICATION is queried to resolve application identifiers within the debug logging path.

Usage Notes

This package is not intended for direct end-user invocation. It is called by the Oracle Forms-based Contract Commitment setup form on behalf of the Table Handler, and it is referenced by nine other PL/SQL packages within the IGC schema, which is why changes should be regression-tested carefully. When debugging, administrators should note that igc_debug_enabled is no longer the operative profile; logging is now driven by AFLOG_ENABLED and the FND_LOG runtime level, with messages written through FND_LOG.STRING at the path igc.plsql.igccdpfb.igc_cc_det_pf_pkg.