Search Results dpp_error_pvt_dpp_lines_tbl_t

Overview

APPS.DPP_BPEL_UPDATEERROR is an Oracle E-Business Suite package that forms part of the DPP (Deferred Product Processing / BPEL integration) layer used for error handling in outbound and inbound BPEL-related flows. Its central purpose is to persist and update error information captured during BPEL-driven processing, using Oracle's standard PL/SQL-to-SQL type conversion pattern to move records between the PL/SQL environment and the SQL layer.

The package is bound to DPP_ERROR_PVT record and collection types, most notably DPP_ERROR_PVT.DPP_ERROR_REC_TYPE and DPP_ERROR_PVT.DPP_LINES_TBL_TYPE, and their corresponding SQL-level mirrors DPP_ERROR_PVT_DPP_ERROR_REC_T and DPP_ERROR_PVT_DPP_LINES_TBL_T. This design allows error data captured in PL/SQL structures to be passed to SQL DML operations that maintain the error records.

Key Procedures and Functions

• PL_TO_SQL0 — Converts a DPP_ERROR_REC_TYPE PL/SQL record into the SQL-equivalent DPP_ERROR_PVT_DPP_ERROR_REC_T object type.
• SQL_TO_PL0 — Performs the inverse conversion, mapping a SQL-layer DPP_ERROR_PVT_DPP_ERROR_REC_T back into the PL/SQL DPP_ERROR_REC_TYPE record.
• PL_TO_SQL1 — Converts a DPP_LINES_TBL_TYPE PL/SQL collection into the corresponding SQL collection type DPP_ERROR_PVT_DPP_LINES_TBL_T.
• SQL_TO_PL1 — Performs the reverse conversion, mapping DPP_ERROR_PVT_DPP_LINES_TBL_T back to the PL/SQL DPP_LINES_TBL_TYPE collection.
• DPP_ERROR_PVT$UPDATE_ERROR — The core update procedure. It accepts standard API parameters (API version, message list initialization, commit flag, validation level) together with OUT parameters for return status, message count, and message data, plus the error record and error lines collection. It is responsible for writing or refreshing error information in the underlying error storage.

Tables Accessed

The package references the table PLITBLM through an APPS synonym. PLITBLM (PL/SQL Interface Table BLOB/Message) is a standard EBS message repository table used by the message-handling framework (FND_MSG_PUB / PL/SQL message infrastructure) to store translatable message text and related attributes in a language-independent form. In this package, PLITBLM supports the message data output (X_MSG_DATA) and message count (X_MSG_COUNT) returned by DPP_ERROR_PVT$UPDATE_ERROR, allowing callers to retrieve diagnostic or error text associated with the update operation.

Usage Notes

DPP_BPEL_UPDATEERROR is an internal integration utility rather than a user-facing API. It is typically invoked from within BPEL/DPP integration code paths—such as deferred processing error handlers, retry logic, or the BPEL callback layer—when a processing error must be recorded or updated. Because it depends on DPP_ERROR_PVT types and the PLITBLM message infrastructure, callers must have access to these public types and to the standard message dictionary setup.

The package is not documented as being referenced by any other package in the ETRM metadata, indicating that its direct callers are external to this reference set and are likely within the DPP/BPEL processing modules. Customizations should not call the $UPDATE_ERROR entry point directly unless the surrounding DPP error-handling context is fully understood, as it manipulates internal error records. The header version (120.4, dated 2007-12-17) indicates the object is stable and largely unchanged across the 12.1.1 and 12.2.2 releases.