Search Results ozf_om_validation_pvt




Overview
Explore in AI Chat

Overview

The APPS.OZF_OM_VALIDATION_PVT package body is a private (PVT) PL/SQL API within the Oracle E-Business Suite Trade Management (formerly Oracle Trade Management, part of the CRM/Order Management family) module. It provides the core validation and defaulting logic that governs the relationship between Order Management (OM) transactions and Trade Management claims. Specifically, this package supports the process by which deductions, chargebacks, and promotional claims raised against customer invoices are validated against the originating order and order line data before they are accepted, approved, or settled within the claims workflow.

Because the package is classified as a PVT API, it is not intended as a public integration point. It is invoked internally by the higher-level public claim APIs — notably OZF_CLAIM_PVT and OZF_CLAIM_LINE_PVT — and by Order Management hooks. Its principal responsibilities are to default claim line attributes (such as eligible order types and claim line details) and to validate claim lines against order headers, order lines, and accounts receivable transactions, culminating in a complete RMA (Return Material Authorization) validation routine. The dependency listing confirms tight coupling with FND_API, FND_MSG_PUB, and OE_ORDER_PUB, indicating it follows the standard EBS API error-handling and message-stack conventions.

Key Procedures and Functions

The package body exposes six documented program units:

  • GET_DEFAULT_ORDER_TYPE — Returns the default order type applied when a claim line is created without an explicitly supplied order type, sourcing the value from profile options and Trade Management system parameters.
  • DEFAULT_CLAIM_LINE — Populates a single claim line record with defaulted values (order references, pricing attributes, and other derived fields) prior to validation and insertion.
  • DEFAULT_CLAIM_LINE_TBL — The table-handler variant of the above, applying defaulting logic across a PL/SQL table (PLITBLM) of claim lines in a single bulk operation.
  • VALIDATE_CLAIM_LINE — Performs validation on an individual claim line, confirming that the referenced order, order line, and AR transaction data are consistent and eligible for the claim type.
  • VALIDATE_CLAIM_LINE_TBL — The bulk table-handler version of claim line validation, iterating over a collection of lines and accumulating errors on the FND message stack.
  • COMPLETE_RMA_VALIDATION — Executes the end-to-end validation of an RMA-based claim, cross-checking returned order lines and credit transactions to ensure the claim is fully supported by the underlying return.

Tables Accessed

The package reads from and writes to the following documented tables and views, accessed through APPS synonyms:

Additional dependencies include MTL_SYSTEM_ITEMS_VL for item validation, OZF_CLAIM_TYPES_VL and OZF_REASON_CODES_VL for claim type and reason code reference data, and internal callers OZF_OM_PAYMENT_PVT, OZF_ORDER_PRICE_PVT, OZF_UTILITY_PVT, and QP_PREQ_GRP.

Usage Notes

OZF_OM_VALIDATION_PVT is a private package and is not referenced by external database objects outside the Trade Management schema. It is invoked internally during claim entry through the Trade Management HTML/Forms user interface, during concurrent claim import and validation programs, and by the public claim APIs (OZF_CLAIM_PVT, OZF_CLAIM_LINE_PVT) whenever a claim line must be defaulted or validated. Customizations should not call this package directly, as its signature is not part of the supported public interface; developers requiring similar logic should route through the corresponding public claim APIs, which invoke these routines on the caller's behalf and maintain the FND message stack and error handling. Because the package relies on FND_API conventions, callers within the supported framework can rely on standard FND_MSG_PUB error reporting when validation fails.