Search Results validate_transaction

Overview

The APPS.INV_MGD_MVT_VALIDATE_PROC package is a PL/SQL specification belonging to the Oracle Inventory (INV) product family, specifically oriented toward movement statistics validation in a global trade, customs, and intrastat (movement reporting) context. Within Oracle EBS 12.1.1 and 12.2.2, this package functions as a wrapper API: its stated purpose in the source header is to "call Validate_Movement_Statistics." It therefore provides a stable, externally callable entry point through which applications and integrations can submit movement transaction data for validation against statutory reporting rules before those transactions are recorded or reported.

The package is declared with AUTHID CURRENT_USER, meaning that privilege checking is performed against the invoking user's schema rights rather than the package owner. It is classified in the ETRM as an OTHER API, indicating it is not one of the fully published, version-controlled Open Interfaces but is nonetheless documented and referenced by other PL/SQL programs.

Key Procedures and Functions

The specification documents a single public procedure:

• VALIDATE_TRANSACTION — This is the sole documented entry point and is explicitly marked PUBLIC. It is a wrapper API that delegates validation of movement statistics to the underlying validation engine (Validate_Movement_Statistics). Its parameters, as declared in the specification, include an API version number, an initialization flag for the message list (p_init_msg_list), a legal entity identifier, an economic zone code, a usage type, a stat type, a period name, and a document source type. It returns a standard Oracle API return status along with the standard x_msg_count and x_msg_data diagnostic outputs. All version and message-list parameters follow the shared FND_API conventions.

No other procedures or functions are documented in the specification. The procedure list in the header confirms Validate_Transaction is the only member.

Tables Accessed

The ETRM metadata identifies three tables accessed via APPS synonyms:

• HR_ALL_ORGANIZATION_UNITS — Primarily used to resolve or validate the legal entity / organization context supplied through the legal entity identifier parameter.
• INV_MVT_EXCEP_REP_TEMP — A temporary table associated with movement exceptions reporting; validation results or exception rows are likely staged here during processing.
• PLITBLM — A standard Oracle EBS PL/SQL message/token table used for error and diagnostic message resolution, consistent with the package's use of the FND message stack.

Usage Notes

Because this package is a wrapper rather than a public open interface, it is typically invoked by other PL/SQL packages, concurrent programs, or custom extensions that need to validate movement statistics before committing them to the reporting pipeline. The ETRM records that it is referenced by two other packages, confirming its role as a shared internal dependency.

Callers should supply the standard API parameters — API version, initialization flag, and the OUT diagnostic parameters — in accordance with FND_API conventions. The returned x_return_status and message data should always be inspected to determine whether the transaction passed validation. Direct invocation from forms is not documented; integrations and custom code should prefer calling this package over replicating validation logic, since it routes to the canonical Validate_Movement_Statistics routine. Due to its AUTHID CURRENT_USER declaration, the invoking user must possess appropriate privileges on the referenced objects.