Search Results complete_transaction

Overview

AR_TRANSACTION_GRP is a Group API (GRP) package in the Oracle E-Business Suite Receivables module, owned by the APPS schema. It belongs to the family of standalone transaction APIs introduced to provide streamlined, batch-oriented processing of AutoInvoice staging data. As a Group type API, it consolidates several lower-level Public APIs into higher-level transactional operations, exposing a single entry point that orchestrates validation, setup lookup, and the calling of the underlying public interfaces. In this way it delivers a simplified interface for external programs and integration code that would otherwise need to replicate coordination logic.

The package body carries a header identifying the source file as ARXGTRXB.pls (version 120.5, dated 2005/09/07), indicating its provenance as a Receivables transaction processing component. Its declared scope is the management of the lifecycle state of transaction records held in the interface tables, moving them between complete and incomplete status in a controlled, validated manner.

Key Procedures and Functions

ETRM documents two public procedures within this package:

• COMPLETE_TRANSACTION — Marks an interface transaction as complete so that it is eligible for processing by the Receivables transaction import machinery. It performs the necessary setup validation and invokes the appropriate public transaction APIs to finalize the record.
• INCOMPLETE_TRANSACTION — Reverses the completed state, returning an interface transaction to an incomplete status so that it can be corrected, revalidated, or excluded from import processing.

Both procedures follow the Group API convention of returning a standard FND_API return status, allowing callers to distinguish success from expected or unexpected errors. The package body also contains private helper procedures such as trx_debug, a logging wrapper that delegates to ARP_UTIL.DEBUG based on the AFLOG_ENABLED profile option, and fetch_trx_type, which retrieves a row from RA_CUST_TRX_TYPES for a given customer transaction identifier into a record variable. These private routines support the public interface but are not intended for direct invocation.

Tables Accessed

The package operates against the core Receivables transaction and setup tables, accessed through APPS synonyms:

• RA_CUSTOMER_TRX — the transaction header table, used to identify and update the transaction being completed or incompleted.
• RA_CUST_TRX_TYPES — the transaction type definition table, read via the private fetch_trx_type routine to resolve transaction type attributes.
• RA_BATCH_SOURCES — the batch source definition table, consulted to validate the source assigned to the transaction record.
• AR_SYSTEM_PARAMETERS — the Receivables system options table, providing setup values required for validation and control logic.

Usage Notes

AR_TRANSACTION_GRP is typically invoked from custom integration code, concurrent programs, or extension routines that manage the import status of transactions held in the AutoInvoice interface tables. It is referenced by one other documented package, reflecting its role as a shared service rather than an end-user-facing API. Callers should supply a valid interface or customer transaction identifier, handle the returned FND_API status value, and invoke COMPLETE_TRANSACTION only after the record has been fully populated. Because the package is a Group API, direct calls to its private helpers are not supported; customizations should restrict themselves to the two documented public procedures and treat the debug and fetch routines as internal implementation details subject to change.