Search Results submit_error

Overview

FV_IPA_PKG_PVT is a private PL/SQL package body in the APPS schema that supports the Federal Financials Interfund Processing Application (IPA) flow within Oracle E-Business Suite. Its single documented procedure, IPA_TRX, is responsible for programmatically submitting the Lockbox Finance Charge Application concurrent program (FVDCLCKB) and then waiting for that request to finish before returning control to the calling process. In practice, this package acts as a synchronous wrapper around an asynchronous concurrent request: the caller is the Lockbox Execution report, and the IPA_TRX routine ensures the finance charge application step completes before the Lockbox Execution report continues. The package is classified as PVT (private) in the ETRM metadata, meaning it is an internal implementation object rather than a public integration API, and it is referenced by one other package. The source header indicates the file is "noship," i.e., a non-shipped or one-off object, and its last revision dates to 2005. The package is written with Multi-Org Access Control (MOAC) awareness, reading and setting the current organization context before submitting the child request.

Key Procedures and Functions

The package exposes one documented procedure:

• IPA_TRX — Submits the FVDCLCKB concurrent request (Lockbox Finance Charge Application) for a given transmission, then enters a polling loop using FND_CONCURRENT.GET_REQUEST_STATUS until the request reaches the COMPLETE phase or the status call fails. The procedure raises a locally declared submit_error exception when FND_REQUEST.SUBMIT_REQUEST returns zero (indicating submission failure), and it logs diagnostic messages through FV_UTILITY at statement, error, and unexpected levels. The submit_error handler writes a specific error message and re-raises via APP_EXCEPTION.RAISE_EXCEPTION; a WHEN OTHERS handler logs the SQL error text and likewise re-raises. Between polling iterations the procedure sleeps using DBMS_LOCK.SLEEP.

No other procedures or functions are documented in the ETRM metadata for this package body.

Tables Accessed

The documented table reference for this package body is DBMS_LOCK, which is the Oracle-supplied lock management package rather than an application table. It is used here solely for its SLEEP procedure to throttle the polling loop while the child concurrent request executes. No APPS application tables are recorded as directly referenced by this package in the ETRM metadata; any data manipulation associated with finance charge application is performed by the FVDCLCKB concurrent program that this package submits, not by FV_IPA_PKG_PVT itself.

Usage Notes

Because the package is marked PVT and is referenced by exactly one other package, it is not intended for direct invocation from forms, OA Framework pages, or arbitrary custom code. It is invoked internally as part of the Federal Lockbox Execution reporting flow, which calls IPA_TRX to launch and then await the Lockbox Finance Charge Application request. The procedure honors MOAC by calling MO_GLOBAL.GET_CURRENT_ORG_ID and FND_REQUEST.SET_ORG_ID before submission, so the current organization must be initialized by the caller. The blocking loop (with a five-second sleep interval) means IPA_TRX effectively makes the parent process wait on the child request; if submission fails, the submit_error exception propagates after logging. Developers troubleshooting failed or missing finance charge application submissions in the Federal Financials Lockbox process should look for the logged messages emitted by this package, which identify FV_IPA_PKG_PVT.IPA_TRX as the source.