Search Results dpp_lines_log_id_seq

Overview

DPP_LOG_PVT is a private PL/SQL package in the APPS schema that supports the logging infrastructure of Oracle E-Business Suite's Advanced Pricing and trade management (DPP) modules. Its documented purpose is the insertion of log records into the transactional logging tables used by the DPP application family. The package is classified as a "PVT" (private) API, meaning it is intended for internal use by other DPP packages rather than direct invocation by external customizations. In Oracle EBS 12.1.1 and 12.2.2, DPP_LOG_PVT serves as the write layer for header, line, and claim-level audit trails, capturing the state of pricing and trade transactions as they are processed.

Key Procedures and Functions

The package exposes three documented procedures, all of which follow the Oracle EBS API standard with parameters including p_api_version, p_init_msg_list, p_commit, and p_validation_level, returning the standard x_return_status, x_msg_count, and x_msg_data outputs.

• INSERT_HEADERLOG — Inserts a record into the transaction headers log, accepting a transaction header record of type dpp_cst_hdr_rec_type. This procedure is the target of the user's search for "insert_headerlog" and is the entry point for logging header-level transactional data.
• INSERT_LINESLOG — Inserts corresponding line-level log records, capturing the individual transaction lines associated with a header.
• INSERT_CLAIMSLOG — Inserts customer claim log records, documenting claim activity tied to the pricing or trade transaction.

Tables Accessed

The package writes to the following documented log tables, using sequence generators to obtain primary keys:

• DPP_TRANSACTION_HEADERS_LOG — the header log table, populated via DPP_HEADERS_LOG_ID_SEQ.
• DPP_TRANSACTION_LINES_LOG — the line log table, populated via DPP_LINES_LOG_ID_SEQ.
• DPP_CUSTOMER_CLAIMS_LOG — the customer claims log table, populated via DPP_CLAIMS_LOG_ID_SEQ.
• PLITBLM — the standard Oracle EBS message table used by FND_MSG_PUB for API message handling.

These accesses are consistent with the package's role as a pure logging/audit facility: it inserts into log tables and reads only the sequence objects and message infrastructure needed to support those inserts.

Usage Notes

DPP_LOG_PVT is referenced by four other packages within the DPP module, indicating it is invoked internally during transaction processing flows — likely after a pricing or trade transaction is created, updated, or validated — to persist an audit snapshot. Custom developers should not call this package directly; instead, they should invoke the public DPP APIs that in turn call DPP_LOG_PVT. Because the procedures follow the FND_API standard, they establish a savepoint, validate API version compatibility, initialize the message list when requested, and return standard status indicators. Error handling, when it occurs, raises FND_API.G_EXC_UNEXPECTED_ERROR. The package also honors the FND debug message level, emitting diagnostic output when g_debug is enabled. In EBS 12.2.2, the same behavior applies; the package is not documented as having been materially changed between 12.1.1 and 12.2.2.