Search Results ce_invalid_bank_acc

Overview

APPS.CE_CEJEEXER_XMLP_PKG is the generated PL/SQL package body that backs the Oracle Cash Management XML Publisher (BI Publisher) concurrent report CEJEEXER. The report produces an external bank statement or statement-line exception listing for a selected bank branch, bank account, and statement number/date range. The package name follows the standard XML Publisher report package naming convention: the "XMLP_PKG" suffix denotes a package generated from an XML Publisher data template, while the "CE_JEEXER" stem identifies the specific Cash Management report definition.

The package performs two principal duties. First, it extracts the runtime parameters passed by the concurrent manager from FND_CONCURRENT_REQUESTS, since XML Publisher concurrent programs deliver their parameters concatenated into the ARGUMENT1 through ARGUMENTn columns rather than as discrete bind variables. Second, it supplies the PL/SQL "group" functions and formula columns required by the data template to format and translate report output. It also initializes Oracle Cash Management security before any data is fetched.

Key Procedures and Functions

• BEFOREREPORT — The report entry point. It sets P_CONC_REQUEST_ID from FND_GLOBAL.CONC_REQUEST_ID, calls CEP_STANDARD.INIT_SECURITY to enforce Cash Management access control, parses the seven positional arguments (request id, bank branch id, bank account id, statement number from/to, and statement date from/to) out of the FND_CONCURRENT_REQUESTS argument columns, formats the date parameters, resolves the "ALL" literal lookup, and sets the company name header from the window session title. Division (exception handling) sets a message and raises a generic application error when the security or setup context is invalid.
• AFTERREPORT — The post-report completion routine, typically used to release resources or finalize report-level state after the data template has finished processing.
• C_DATEFORMATFORMULA — Formula column that applies the session or report date format to statement dates for display.
• C_MESSAGE_DSPFORMULA — Formula column that resolves and displays the correct message text (translated where applicable) for statement or exception records.
• C_ALL_TRANSLATION_P — Supplies the translated rendering of the "ALL" lookup value used in report parameter display.
• C_BANK_BRANCH_NAME_DSP_P — Resolves the bank branch name for the selected bank branch identifier.
• C_BANK_CURRENCY_CODE_DSP_P — Derives the currency code associated with the selected bank account.
• C_COMPANY_NAME_HEADER_P — Returns the company/organization name used in the report page header.
• C_BASE_CURRENCY_CODE_DSP_P — Returns the ledger base currency code for the reporting context.
• C_BANK_ACCOUNT_NUM_DSP_P — Derives the formatted bank account number for report display.

Tables Accessed

• FND_CONCURRENT_REQUESTS — Read in BEFOREREPORT to retrieve the concatenated parameter arguments for the current concurrent request.
• CE_JE_MESSAGES — Cash Management statement/exception message repository, used by the message display formula to emit statement validation or reconciliation messages.
• FND_NEW_MESSAGES — Oracle Application Object Library message table, used to resolve translated message text.

Usage Notes

This package is invoked indirectly whenever the CEJEEXER concurrent program is submitted and XML Publisher executes its data template through the Oracle Reports-to-XML Publisher bridge. It is not a public API and should not be called directly from forms, custom concurrent programs, or client code; the "OTHER" API classification in the ETRM metadata reflects that it is a supporting object rather than a supported interface. Customizations should be applied to a copy of the report definition and its data template, never to the seeded package body, because patching or an upgrade may regenerate the package. The search term "ce_invalid_bank_acc" relates to Cash Management validation of bank account data; such validation errors surface in the report through the message formula sourcing CE_JE_MESSAGES and FND_NEW_MESSAGES.