Search Results insert_qual_error_message

Overview

QP_BULK_VALUE_TO_ID is an Oracle E-Business Suite PL/SQL package owned by the APPS schema that supports the Oracle Advanced Pricing bulk loading facility. Its central purpose is to resolve human-readable interface values into the internal identifiers required by the pricing data model. When pricing data is staged in the QP_INTERFACE_* tables for bulk upload, many columns contain textual or externally supplied values — list names, qualifier contexts, price list line attributes, and payment terms — rather than the surrogate primary keys used internally by Oracle Pricing. QP_BULK_VALUE_TO_ID performs the conversion of those values into the correct internal IDs so that the bulk loader can subsequently create valid pricing entities.

In effect, the package is a resolution and validation layer that sits between the user-supplied interface records and the core pricing tables. Where a supplied value cannot be resolved to a valid internal identifier, the package records descriptive error messages in the pricing interface error tables, allowing the bulk load process to report failures to the user rather than terminating with an unhandled exception. The package is classified as OTHER within the ETRM repository, indicating it is an internal utility rather than a published business API, and it is documented as VALID under 12.1.1 and 12.2.2.

Key Procedures and Functions

The documented API surface consists of six procedures and functions, organised by the interface entity they service:

• HEADER — Resolves values associated with price list header interface records, converting the supplied header-level attributes into the corresponding internal identifiers needed to create or match a price list header.
• QUALIFIER — Resolves qualifier-related interface values into internal qualifier identifiers and context references used by the pricing qualifier rules.
• LINE — Resolves price list line interface values, translating line-level attributes into the internal identifiers required for line creation.
• INSERT_HEADER_ERROR_MESSAGES — Writes error records to the pricing interface error tables when header value resolution fails.
• INSERT_QUAL_ERROR_MESSAGE — Writes error records when a qualifier value cannot be resolved.
• INSERT_LINE_ERROR_MESSAGE — Writes error records when a line value cannot be resolved.

The three error-insertion routines share a common design intent: they ensure that every unresolvable value is captured with sufficient context for the user to correct the source data and re-run the load. Parameter lists are not reproduced here.

Tables Accessed

The package reads from and writes to the following documented tables, all reached through APPS synonyms:

• QP_INTERFACE_LIST_HEADERS, QP_INTERFACE_LIST_LINES — the staged price list header and line records whose values are being converted.
• QP_INTERFACE_PRICING_ATTRIBS — staged pricing attribute values requiring resolution.
• QP_INTERFACE_QUALIFIERS — staged qualifier records processed by the QUALIFIER routine.
• QP_PRC_CONTEXTS_B — the pricing context definitions used to validate and resolve context references.
• QP_QUALIFIER_RULES — qualifier rule definitions consulted during qualifier resolution.
• RA_TERMS — payment terms, resolved when term values appear in pricing data.
• QP_INTERFACE_ERRORS, QP_INTERFACE_ERRORS_S — the error tables and their sequence, written by the INSERT_*_ERROR_MESSAGE routines.

Usage Notes

QP_BULK_VALUE_TO_ID is not intended for direct invocation by end users or by typical custom extensions. It is referenced internally by QP_BULK_LOADER_PUB, the public bulk loader package, which orchestrates the overall pricing bulk load. The dependency metadata confirms exactly one referencing package, reinforcing its role as a private helper invoked in sequence during bulk load processing.

The package depends only on SYS.STANDARD, meaning it relies on no other application package logic and performs its work primarily through the interface and pricing tables. Typical invocation therefore occurs when a concurrent program or batch process executes the pricing bulk loader against records previously staged in the QP_INTERFACE_* tables. The loader calls the HEADER, QUALIFIER, and LINE routines to resolve identifiers, and any failures are surfaced through the error tables for review via the pricing interface error inquiry. Custom code should use QP_BULK_LOADER_PUB rather than calling QP_BULK_VALUE_TO_ID directly.