Search Results ozf_claim_lines_util




Overview
Explore in AI Chat

Overview

APPS.OZF_CLAIM_SETTLEMENT_VAL_PVT is a private validation package body within the Oracle E-Business Suite Trade Management (formerly Oracle Trade Management / OZF) module. It supports the claim settlement workflow by performing server-side validation of claim lines and claim header data before settlement records are committed. The package is classified as a PVT (private) API, meaning its procedures are intended for internal consumption by the public OZF claim settlement APIs and are not guaranteed for direct customer invocation.

The package operates against the core claim tables (OZF_CLAIMS, OZF_CLAIMS_ALL, OZF_CLAIM_LINES) and integrates with a broad set of validation and utility dependencies, including OZF_CLAIM_LINES_UTIL, OZF_CLAIM_PVT, OZF_CLAIM_LINE_PVT, OZF_AR_VALIDATION_PVT, OZF_OM_VALIDATION_PVT, and OZF_UTILITY_PVT. Standard EBS framework packages FND_API, FND_MESSAGE, and FND_MSG_PUB provide the error handling and message stack conventions common to EBS PL/SQL APIs.

Key Procedures and Functions

The documented package exposes seven procedures and functions, organized around defaulting, validation, and completion of claim settlement processing.

  • DEFAULT_CLAIM_LINE — Populates default values for a single claim line record, typically deriving values from the associated claim, settlement method, or system parameters rather than requiring the caller to supply them explicitly.
  • DEFAULT_CLAIM_LINE_TBL — The table-based (bulk) counterpart to DEFAULT_CLAIM_LINE, applying defaulting logic across a PL/SQL collection of claim lines in a single pass.
  • VALIDATE_CLAIM_LINE — Performs validation on a single claim line, confirming that required attributes are present and consistent with settlement rules. Validation errors are surfaced through the FND message stack.
  • VALIDATE_CLAIM_LINE_TBL — Bulk validation of a collection of claim lines, allowing multiple lines to be validated in one call.
  • COMPLETE_CLAIM_VALIDATION — Executes the broader claim-level validation required before settlement can proceed, coordinating line-level results into a claim-wide status.
  • COMPLETE_CLAIM — Finalizes the claim for settlement after validation succeeds, signaling completion of the claim settlement flow.
  • GL_DATE_IN_OPEN — Determines whether a given general ledger date falls within an open accounting period, referencing GL_PERIOD_STATUSES. This guards against settling claims into closed periods.

Tables Accessed

The package references the following tables through APPS synonyms: OZF_CLAIMS and OZF_CLAIMS_ALL (claim header data), OZF_CLAIM_LINES (line-level claim detail), OZF_CLAIM_LINES_UTIL (claim line utility logic surfaced as a dependency), OZF_CLAIM_STTLMNT_METHODS_ALL (valid settlement methods), OZF_FUNDS_UTILIZED (fund consumption tied to the claim), OZF_OFFER_PERFORMANCES (offer performance context), OZF_SYS_PARAMETERS (module-level configuration), RA_CUSTOMER_TRX_LINES (receivables transaction lines referenced during validation), GL_PERIOD_STATUSES (open/closed period determination), and PLITBLM (the standard EBS PL/SQL index-by table type). The package also has an internal self-reference to OZF_CLAIM_SETTLEMENT_VAL_PVT.

Usage Notes

Because OZF_CLAIM_SETTLEMENT_VAL_PVT is a private package, it is normally invoked indirectly through public OZF claim APIs such as OZF_CLAIM_PVT and OZF_CLAIM_LINE_PVT, which call the validation routines before committing settlement data. It is referenced by four other database objects. Direct invocation from forms or concurrent programs is not supported; customizations should call the public API layer instead. The package inherits standard EBS API behavior — error conditions are reported via FND_MSG_PUB rather than propagated exceptions alone, so callers must check the message stack after execution.