Search Results dpp_log_pvt




Overview
Explore in AI Chat

Overview

The APPS.DPP_LOG_PVT package is a private (PVT-classified) PL/SQL logging utility within the Oracle E-Business Suite 12.1.1 and 12.2.2 Advanced Pricing / Deal Management infrastructure. Its central business function is to capture and persist audit and diagnostic log records generated during the execution of pricing and claims processing logic. The package acts as a write-and-forget logging layer: instead of scattering INSERT statements throughout the transactional code, the surrounding packages call DPP_LOG_PVT to record header, line, and claim-level audit data into dedicated log tables.

The PVT suffix indicates the package is not part of the public API surface exposed to customer extensions or external interfaces. It is consumed only by sibling packages in the DPP (Advanced Pricing) module, meaning its contract can change without public API commitments. The package holds VALID status in the APPS schema, and the metadata confirms both a package specification and a package body exist.

Key Procedures and Functions

Three documented procedures comprise the functional surface of this package:

  • INSERT_HEADERLOG — Writes a header-level log record, used to stamp the top of a processing run or transaction event into the header log table. It relies on a sequence for primary key generation.
  • INSERT_LINESLOG — Writes line-level detail records corresponding to individual pricing or transaction lines, providing the granular audit trail beneath each header entry.
  • INSERT_CLAIMSLOG — Writes claim-specific log records, supporting the customer claims processing path of the module.

Each procedure is named for the target table it populates. Consistent with private logging utilities, they depend on FND_API for standard concurrent-request context and error-handling conventions. Their design implies a header/lines/claims hierarchy: a parent record is created first, and dependent detail records reference the parent.

Tables Accessed

The package writes to the following documented tables, all referenced through APPS synonyms:

The presence of three dedicated ID sequences confirms each log table uses sequence-based surrogate keys rather than a shared key.

Usage Notes

DPP_LOG_PVT is invoked internally by four packages: DPP_COVEREDINVENTORY_PVT, DPP_CUSTOMERCLAIMS_PVT, DPP_TRANSACTION_PVT, and DPP_LOG_PVT itself (self-reference, likely for shared internal helpers). Customer code and forms typically do not call this package directly. Logging is triggered as a side effect of transaction, covered inventory, and claims processing, most often inside concurrent programs or during form-driven pricing operations. Because it is private and undocumented publicly, customizations should not invoke it; developers needing similar audit behavior should use supported public APIs or their own logging tables.