Search Results save_message

Overview

QP_BULK_MSG is an Oracle EBS Advanced Pricing (QP) utility package body residing in the APPS schema. Its business function is to centralize the recording, staging, and persistence of error and status messages generated during bulk pricing and bulk list processing operations. Bulk operations such as bulk list import, bulk pricing adjustments, and mass update of price lists process large volumes of records asynchronously; when individual records fail validation or interface processing, the resulting messages must be captured reliably for later review by pricing administrators.

QP_BULK_MSG provides the common messaging layer used by the bulk loader infrastructure. Rather than writing error text directly to every calling program's log, the package funnels messages through a controlled interface (FND_MSG_PUB via FND_MESSAGE conventions, and custom persistence into the QP_INTERFACE_ERRORS table) so that failures surface both in the concurrent request log and in the pricing interface errors user interface. The package body is documented as VALID and is classified under API classification OTHER, indicating it is an internal implementation utility rather than a public, externally versioned API.

Key Procedures and Functions

The ETRM metadata documents two procedures within QP_BULK_MSG:

• ADD — Registers a message for subsequent processing within the bulk messaging context. It is the entry point used by bulk processing callers to queue or accumulate a message in the package's internal message structures so that it can be handled consistently with the rest of the bulk run.
• SAVE_MESSAGE — Persists accumulated messages to the pricing interface errors repository. This is the procedure that transitions the in-memory or staged message into durable storage, ensuring that errors raised during a bulk run are visible after the concurrent program completes.

No parameter lists are asserted here; parameter signatures must be verified against the deployed package specification in the target environment.

Tables Accessed

The documented table references resolve through APPS synonyms and PUBLIC/SYS objects:

• QP_INTERFACE_ERRORS — The base pricing interface errors table. QP_BULK_MSG writes message rows here so that failed bulk interface records can be queried and reviewed in the Pricing Interface Errors view.
• QP_INTERFACE_ERRORS_S — The sequence associated with QP_INTERFACE_ERRORS, referenced to obtain primary key values for new error rows. This is the object most directly implied by the user's search term.
• PLITBLM — The Oracle-supplied PL/SQL table type, used to hold collections of message text or message identifiers internally during processing before persistence.

Additional dependencies include FND_API, FND_GLOBAL, FND_MESSAGE, and QP_BULK_LOADER_PUB, indicating integration with the Oracle Application Object Library messaging framework and the bulk loader public API.

Usage Notes

QP_BULK_MSG is not invoked directly from Oracle EBS forms or standard concurrent program parameters. It is called internally by the bulk pricing loader infrastructure — principally through QP_BULK_LOADER_PUB — during bulk list and bulk price adjustment processing. When a caller detects a record-level failure, it invokes ADD to register the message; SAVE_MESSAGE is then called to flush messages into QP_INTERFACE_ERRORS, where they are surfaced through the standard Pricing Interface Errors concurrent program and query UI.

Because the metadata records that QP_BULK_MSG is referenced by two other packages and references QP_INTERFACE_ERRORS and QP_INTERFACE_ERRORS_S, customizations should treat it as an internal dependency: extend behavior by wrapping QP_BULK_LOADER_PUB or querying QP_INTERFACE_ERRORS, rather than calling QP_BULK_MSG.ADD or SAVE_MESSAGE directly, since signatures and internal behavior are not guaranteed across EBS patch levels in 12.1.1 and 12.2.2.