Search Results g_error_exists

Overview

The APPS.JL_CO_GL_NIT_MANAGEMENT package body is a Colombian localizations (JL) utility within Oracle E-Business Suite that manages the relationship between subledger transactions and the General Ledger, specifically organized around the NIT (Número de Identificación Tributaria) — the Colombian tax identification number. Its core purpose is to create, calculate, and reverse balance records that reconcile subledger activity to GL balances while preserving NIT-level tax reporting attributes required by Colombian statutory reporting.

The package operates as a supporting engine for NIT-based balance tracking, reading transactional detail from Payables, Receivables, Cash Management, and Cost Management, and then aggregating or offsetting amounts against the JL_CO_GL_TRX table. The package body contains a private cursor (journals) that joins GL_JE_HEADERS and GL_JE_LINES, resolving the NIT identifier from GL_JE_LINES.CO_THIRD_PARTY (with fallback to GLOBAL_ATTRIBUTE1 for R12 compatibility), and derives supporting attributes such as NIT type, NIT name, verification digit, and period information. Global package variables hold period set name, chart of accounts context, period number/year, and functional currency across procedure calls.

Key Procedures and Functions

• CREATE_TRX_BALANCE — Creates balance rows in JL_CO_GL_TRX for the subledger transactions selected for a given period and set of books. This is the primary entry point for building the NIT-level balance records.
• CALCULATE_BALANCE — Computes balances from the underlying transaction and journal data, aggregating debits and credits and applying the NIT and period context assembled in the package globals. It provides the calculated figures used by balance creation and reporting.
• REVERSE_BALANCE — Reverses previously created balance records, supporting correction, period adjustment, or reprocessing scenarios without leaving stale NIT balance entries in the localizations table.

An internal Create_Balances procedure is declared and invoked by the package’s own logic rather than being exposed as a public API.

Tables Accessed

The package reads and writes through APPS synonyms. The principal destination is JL_CO_GL_TRX, which stores the NIT transaction/balance records. Source transaction data is drawn from Payables tables (AP_INVOICES_ALL, AP_INVOICE_LINES_ALL, AP_INVOICE_DISTRIBUTIONS_ALL, AP_PAYMENT_HISTORY_ALL, AP_PREPAY_APP_DISTS, AP_CHECKS_ALL, AP_SUPPLIERS, AP_BANK_ACCOUNTS_ALL, AP_BANK_BRANCHES), Receivables (AR_CASH_RECEIPTS_ALL), Cash Management (CE_BANK_ACCOUNTS, CE_BANK_ACCT_USES_ALL), and Cost Management (CST_WRITE_OFFS). The FND_NEW_MESSAGES table is used for message lookup and error/notification text. The package is not referenced by any other package, so it functions as an end-point consumer of these tables rather than as a shared library.

Usage Notes

This package is invoked from Colombian localization flows that require NIT-level GL reconciliation, typically triggered by concurrent programs or localization forms during period close and tax reporting. In EBS 12.1.1 and 12.2.2 the R12 code path resolves the NIT from CO_THIRD_PARTY rather than the pre-R12 GLOBAL_ATTRIBUTE1, so custom code calling this package must supply a valid period, period year, period number, and set of books identifier. Because it is classified as an OTHER API and is referenced by no other package, customizations should treat it as an internal localization utility: call it only through the supported Colombian localization concurrent programs or forms, and avoid direct invocation unless the surrounding NIT balance context (globals, period, and set of books) is fully initialized. No formal error-code contract is documented, so callers should rely on the standard EBS message conventions and the FND_NEW_MESSAGES lookups surfaced by the package.