Results for “qp_bulk_msg”
36 results
AI-generated from documented ETRM metadata — verify critical details on the linked pages.
Overview
QP_BULK_MSG is an internal PL/SQL package in the APPS schema that supports Oracle E-Business Suite's bulk order import and validation infrastructure within the Advanced Pricing (QP) module. Its primary business function is to manage and record error and status messages generated during bulk processing operations — specifically, the import of order and price list interface data and the validation of that data before it is applied to live pricing and order entities. Rather than exposing a public application programming interface, QP_BULK_MSG functions as a shared utility that centralizes message handling for the bulk loader and bulk validation processes, ensuring consistent error capture and diagnostics across the pricing interface workflow.
The package is classified as an "OTHER" API type in ETRM. This classification indicates it is not a documented open API intended for direct customer invocation, but rather a supporting internal component referenced by other pricing packages. In EBS 12.1.1 and 12.2.2, this package remains schema-resident in APPS and is reported VALID in the data dictionary.
Key Procedures and Functions
The documented package exposes two procedures/functions: ADD and SAVE_MESSAGE.
- ADD — Appends a message entry to the bulk message collection. It is the entry point by which calling routines register a message, typically an error or informational note, associated with a bulk interface row. The routine contributes to building the in-memory message set processed by the loader or validator.
- SAVE_MESSAGE — Persists the accumulated or individual messages to the database. It writes message records into the pricing interface error tables so that failures can be reviewed by users and administrators after the bulk process completes, enabling diagnosis and correction of rejected interface records.
Parameter lists are not documented in the ETRM metadata and thus are intentionally omitted. In practice these routines are consumed programmatically by sibling packages, not invoked by end users.
Tables Accessed
QP_BULK_MSG references the following tables through APPS synonyms:
- QP_INTERFACE_ERRORS — the primary error repository for pricing interface processing. QP_BULK_MSG writes diagnostic messages here so that failed interface rows carry an auditable reason code or description.
- QP_INTERFACE_ERRORS_S — the corresponding sequence (or supporting entity) used to generate unique identifiers for interface error records.
- PLITBLM — an Oracle EBS standard PL/SQL table type (index-by table of VARCHAR2) frequently used to hold collections of messages in memory. Its reference indicates QP_BULK_MSG stages messages in a PL/SQL associative array before flushing them to the error tables.
Usage Notes
QP_BULK_MSG is not intended for direct invocation by end users or custom developers. It is referenced by QP_BULK_LOADER_PUB, QP_BULK_VALIDATE, and recursively by QP_BULK_MSG itself. These callers operate within the bulk load and validation concurrent programs and PL/SQL flows used to import pricing data from interface tables. When the bulk loader encounters a rejected or warning condition, it calls the message-handling routines; SAVE_MESSAGE is then invoked at the appropriate commit boundary to persist messages into QP_INTERFACE_ERRORS for review.
In both 12.1.1 and 12.2.2 environments, developers should treat QP_BULK_MSG as read-only infrastructure. Customizations should not call it directly; instead, use documented public pricing APIs such as QP_BULK_LOADER_PUB. Any dependency changes to this package can cascade to the loader and validator packages noted above, so database administrators should preserve it during patching and cloning operations.
-
PACKAGE: APPS.QP_BULK_MSG 12.2.2
-
PACKAGE: APPS.QP_BULK_MSG 12.1.1
-
PACKAGE: APPS.QP_BULK_MSG 12.1.1
-
PACKAGE: APPS.QP_BULK_MSG 12.2.2
-
12.1.1 DBA Data 12.1.1
-
12.1.1 DBA Data 12.1.1
-
12.2.2 DBA Data 12.2.2
-
12.2.2 DBA Data 12.2.2
-
SYNONYM: PUBLIC.PLITBLM 12.1.1
-
12.2.2 DBA Data 12.2.2
-
SYNONYM: PUBLIC.PLITBLM 12.2.2
-
12.2.2 DBA Data 12.2.2
-
12.1.1 DBA Data 12.1.1
-
12.1.1 DBA Data 12.1.1