Search Results ce_leveling_messages_s

Overview

CE_LEVELING_UTILS is a public PL/SQL package body owned by the APPS schema in Oracle E-Business Oracle Cash Management. It encapsulates the server-side logic that supports the Cash Leveling (cash concentration / notional pooling) process, which allows treasury users to consolidate surplus balances from participating bank accounts into a target account and, where required, to fund accounts that fall below defined thresholds. The package is classified as OTHER in the ETRM repository and is the procedural engine behind the Cash Leveling Proposal user interface and its associated concurrent processing. Its documented header revision, 120.16.12020000.5 (2013/04/12), is common to both the 12.1.1 and 12.2.2 releases.

In addition to core leveling logic, the package contains a small logging utility, log_msg, that writes diagnostic output to the FND_LOG infrastructure under the package identifier 'CE_LEVELING_UTILS'. This is consistent with the debug logging standardization adopted through enhancement 16462154.

Key Procedures and Functions

The package exposes ten documented program units:

• GENERATE_BUTTON — Invoked from the Cash Leveling Proposal confirmation page (typically via an OA Controller class). It submits the 'Generate Cash Leveling Fund Transfers' concurrent program (short name CECLEVEL) using FND_REQUEST.SUBMIT_REQUEST and returns the request identifier.
• CASH_LEVELING — The principal driver that orchestrates the leveling calculation, invoking the supporting population and update routines that build the proposal.
• GENERATE_FUND_TRANSFER — Creates the fund transfer records derived from the accepted leveling proposal.
• POPULATE_NESTED_ACCOUNTS — Populates the hierarchy of nested (parent/child) sub-accounts participating in a cash pool.
• DELETE_SUB_ACCOUNTS — Removes sub-account rows, typically as part of re-running or regenerating a proposal.
• UPDATE_PARENT_NESTED_ACCOUNTS — Maintains the parent-level aggregation of nested account relationships.
• POPULATE_TARGET_BALANCES — Derives the target balances each participating account should hold after leveling, based on the pool definition and available surplus.
• POPULATE_BAT_PAYMENT_DETAILS — Populates Bank Account Transfer (BAT) payment details required for executing the resulting transfers.
• UPDATE_BANK_ACCOUNT_ID — Resolves or stamps the correct bank account identifier on the working records.
• MATCH_CASHPOOL — Matches transactions or accounts to the appropriate cash pool definition.

Tables Accessed

The package reads and writes the following documented tables via APPS synonyms:

• CE_BANK_ACCOUNTS — Source of bank account attributes and account identifiers.
• CE_CASHPOOLS, CE_CASHPOOL_SUB_ACCTS, CE_CASHPOOL_SUB_ACCTS_S — Cash pool headers and their member sub-accounts, including the translated (_S) view, used to determine pool composition and parent/child nesting.
• CE_CP_WORKSHEET_LINES — The cash positioning/leveling worksheet lines that hold the computed proposal.
• CE_FORECAST_ROWS — Forecast balances used as input to target balance computation.
• CE_LEVELING_MESSAGES, CE_LEVELING_MESSAGES_S — Leveling messages (errors, warnings, informational text) surfaced to the user, including the translated view.
• CE_PROPOSED_TRANSFERS — The proposed fund transfers generated for the leveling proposal.
• CE_STATEMENT_LINES — Bank statement lines contributing actual balances and transaction detail.
• CE_TRXNS_SUBTYPE_CODES — Transaction subtype codes used to classify statement activity.
• FND_APPLICATION, FND_NEW_MESSAGES — Application and message repository lookups for message resolution and localization.

Usage Notes

CE_LEVELING_UTILS is not intended as a standalone public API for external consumption; it is an internal utility layer. Its documented entry point for the user interface is GENERATE_BUTTON, called from OA Controller classes on the Cash Leveling Proposal confirmation page, which submits the CECLEVEL concurrent program. The remaining procedures are typically invoked by that concurrent program and by the Cash Leveling flows within Cash Management.

The package is referenced by one other package in the ETRM inventory, and any custom extension should preserve the documented call signatures and rely on the standard FND_LOG-based diagnostics for troubleshooting. Because the object is owned by APPS and depends on message and application metadata, it must be deployed and run within the standard EBS environment; direct modification is neither expected nor supported.