Search Results details_all




Overview
Explore in AI Chat

Overview

FV_THIRD_PARTY_PAYMENTS_PKG is a Federal Financials (FV) package body owned by APPS in Oracle E-Business Suite. Its purpose is to support the Third Party Payments (TPP) process, which handles the printing and reconciliation of payments made on behalf of a third party against a government-issued check or checkrun. The package is invoked from a concurrent program that executes the Third Party Payments Process, orchestrating a sequence of internal procedures that read payment records, build check detail rows, produce an exception report, and submit the associated TPP report. The header comment (FVTPPPRB.pls 120.4, dated 2005/12/29) indicates the object has been stable since the early 11i era and is carried forward into the 12.1.1 and 12.2.2 releases. The user search term "details_all" does not correspond to a declared procedure in the documented metadata; the visibility of check-level details is instead handled by POPULATE_TPP_CHK_DTLS, which is the closest matching detail-population routine.

Key Procedures and Functions

The ETRM metadata documents one procedure entry point, but the package source excerpt reveals the full callable surface. The procedures and functions declared within the body are:

  • MAIN — The documented top-level entry point, called from the concurrent program to execute the Third Party Payments Process. It is responsible for invoking all subsequent procedures in the correct order.
  • LOG_MESSAGE — Accepts a message and writes it to the concurrent request log file, governed by an error level and debug flag.
  • INITIALIZATION — Performs setup work required before payment records are processed.
  • PROCESS_PAYMENT_RECS — Drives the processing of the payment records selected for the run.
  • POPULATE_TPP_CHK_DTLS — Inserts third party payment check detail rows, carrying assignment, check number, checkrun name, exception category, organization, set of books, and standard WHO audit columns.
  • PRINT_EXCEPTION_REPORT — Produces the exception report output for records that failed validation or matching.
  • VENDOR_NAME — Returns the supplier name for a given vendor identifier.
  • VENDOR_SITE — Returns the supplier site description for a given vendor site identifier.
  • SUBMIT_TPP_REPORT — Submits the Third Party Payments report as a concurrent request.

Tables Accessed

The ETRM metadata records no referenced tables through APPS synonyms for this package, and the provided source excerpt contains no SQL statements. Based on the parameter signatures, POPULATE_TPP_CHK_DTLS writes to the Third Party Payments check details table using the assignment, check number, checkrun, exception category, org, and set of books values passed by the caller. VENDOR_NAME and VENDOR_SITE read the Oracle Payables supplier and supplier site entities to resolve descriptive text for reporting. No other table dependencies are documented and none should be assumed.

Usage Notes

The package is invoked through the Third Party Payments Process concurrent program, which calls MAIN and passes the checkrun name along with the standard x_errbuf and x_retcode OUT parameters. MAIN then calls the remaining procedures in sequence, so the package is not intended for direct invocation from Oracle Forms. Because it is an APPS-owned body with no documented API classification other than OTHER, custom code should not call the internal procedures directly; the supported path is the concurrent program. The LOG_MESSAGE procedure provides the standard FV logging pattern, and the debug default of 'Y' means diagnostic output is emitted unless explicitly suppressed. The package is referenced by zero other packages according to ETRM metadata, confirming it sits at the top of the TPP call stack rather than being a shared utility.