Search Results failed_payment_validation

Overview

APPS.AP_PAYMENT_UTIL_PKG is a shared PL/SQL utility package within the Oracle Payables (AP) module of Oracle E-Business Suite. It supplies the payment workbench and payment processing infrastructure with reusable helper routines that retrieve names, statuses, counts, interest calculations, and action orchestration logic. The package is classified in the ETRM repository as an "OTHER" API, meaning it is not an externally supported public interface but rather an internal utility consumed by other Payables packages, forms, and concurrent programs. Its header, which references version 120.25.12010000.2, confirms it is a long-standing component of the payment codebase and remains present in both 12.1.1 and 12.2.2.

Key Procedures and Functions

The package exposes a broad set of getter routines and two orchestration procedures. It contains 28 documented program units, the most prominent of which include:

• GET_LE_NAME – Returns the Legal Entity name associated with a given legal_entity_id, used wherever a transaction must display its owning legal entity.
• GET_OU_NAME – Returns the Operating Unit name for a supplied org_id. The package comment notes this should be replaced by fnd_access_control_util.get_org_name.
• GET_IBY_PAYER_DEFAULTS – Retrieves the Payments (IBY) payer-level defaults, including the document rejection level, payment rejection level, and whether payment processing should stop for review after proposed payments are created.
• Count functions (GET_PI_COUNT, GET_SELECTED_PS_COUNT, GET_UNSEL_PS_COUNT, GET_REJECTED_PS_COUNT, GET_UNSEL_REASON_COUNT, GET_PS_UR_COUNT, GET_MISSING_RATES_PS_COUNT) – Return row counts used by the payment workbench to summarize selected, unselected, rejected, and rate-incomplete payment schedules.
• Interest functions (GET_INTEREST_DUE, GET_INTEREST_PAID, GET_INTEREST_INV, GET_INTEREST_RATE) – Compute or retrieve interest amounts and rates for late-payment interest processing.
• Amount and status functions (GET_GAIN_LOSS_AMOUNT, GET_PAYMENT_STATUS_FLAG, GET_PSR_STATUS, GET_DESTINATION_FUNCTION) – Derive gain/loss figures, payment status flags, payment schedule request status, and destination routing behaviour.
• ACTION_SWITCHER and GET_ACTION_FUNCTION – Provide dispatch logic that maps a requested action to the appropriate underlying routine.

In the context of the search term "failed_payment_validation," the status and count functions above are the most relevant, as they are the mechanisms through which payment validation outcomes are summarized and surfaced.

Tables Accessed

The package reads from a defined set of AP and related synonyms, including AP_CHECKS_ALL, AP_INVOICE_PAYMENTS_ALL, AP_INVOICES_ALL, AP_INVOICE_RELATIONSHIPS, AP_PAYMENT_SCHEDULES_ALL, AP_PAYMENT_TEMPLATES, AP_INV_SELECTION_CRITERIA_ALL, AP_SELECTED_INVOICES and AP_SELECTED_INVOICES_ALL, AP_UNSELECTED_INVOICES_ALL, AP_SYSTEM_PARAMETERS_ALL, AP_CURRENCY_GROUP, AP_INTEREST_PERIODS, AP_LE_GROUP, and AP_OU_GROUP. These support name lookups, selected/unselected invoice tracking, payment schedule interrogation, interest computation, and currency grouping for payment processing.

Usage Notes

AP_PAYMENT_UTIL_PKG is typically invoked indirectly: the Payments workbench form and the payment creation, formatting, and validation concurrent programs call its routines rather than end users. It is referenced by five other packages in the APPS schema, indicating a dependency role in the payment processing chain. Because it is classified as OTHER and is not a supported public API, custom code should avoid direct dependence on it; developers should instead use supported IBY and AP public APIs. Any diagnostic work on failed payment validation should treat this package as an internal helper whose outputs are surfaced through the payment workbench and its concurrent programs.