Search Results g_auth_error

Overview

IBE_QUOTE_CHECKOUT_PVT is a private PL/SQL package that supports the checkout stage of the Oracle iStore and Oracle Quoting quote-to-order flow. Its principal responsibility is to perform the payment-related activities required to convert a sales quote into an order, most notably the authorization of credit card transactions against quote headers. The package is classified as a private API (PVT), which means it is intended for internal use by the Oracle E-Business Suite application layer rather than as a publicly callable interface for customer extensions. The body carries the source identifier IBEVQASB.pls (version 120.12, last modified 2006), confirming that the implementation has remained stable across the 12.1.1 and 12.2.2 code lines.

A distinctive element surfaced by the repository search term is the constant G_AUTH_ERROR, declared near the top of the package body with a value of 3. This constant represents a package-level return or status code used to signal an authorization failure within the checkout processing logic. Consultants tracing credit card declines or payment authorization errors in iStore checkout frequently encounter this identifier in debug logs and error-stack traces.

Key Procedures and Functions

The ETRM metadata documents two procedures in this package:

• AUTHORIZE_CREDIT_CARD — Processes the credit card authorization for a given quote header. Based on the source excerpt, the procedure accepts a quote header identifier and returns the standard FND_API outcome parameters (return status, message count, and message data). Internally it retrieves the transaction extension identifier from ASO_PAYMENTS, fetches quote-level details such as total price, currency, party, resource, and quote source, and then delegates to the IBY (Oracle Payments) funding and capture public APIs — specifically IBY_FNDCPT_TRXN_PUB and IBY_FNDCPT_COMMON_PUB — to construct the payer, payee, amount, and authorization attribute records and to capture the authorization result. Failure of this call is the typical context in which G_AUTH_ERROR is raised or propagated.
• SUBMITQUOTE — Finalizes submission of the quote during checkout, coordinating the transition of the quote into an order-ready state and invoking the payment authorization path where required.

No parameter lists are asserted here beyond what the documented source excerpt confirms.

Tables Accessed

The package reads and writes the following documented tables and views through APPS synonyms:

• ASO_PAYMENTS — Stores payment (transaction extension) records linked to quote headers; queried to obtain the transaction extension identifier used by the Payments API.
• ASO_QUOTE_HEADERS — The quote header entity underpinning the checkout; supplies header-level data required for authorization.
• IBY_FNDCPT_TX_EXTENSIONS — Holds funding and capture transaction extension data consumed during authorization.
• HZ_PARTIES and HZ_RELATIONSHIPS — Provide party and relationship information needed to build the payer context.
• FND_USER — Used for the current user context in the checkout session.
• PLITBLM — The standard FND message/error stack table used to accumulate messages returned to the caller.

Usage Notes

IBE_QUOTE_CHECKOUT_PVT is invoked indirectly by the Oracle Quoting and iStore checkout flows rather than being called explicitly from custom code; the metadata indicates it is referenced by two other packages. It is typically reached from a UI-driven checkout action in the Quote/Order capture forms, or from the corresponding order-submission logic during conversion. Because it is a PVT-class API, direct calls from customizations are discouraged and unsupported; supportability favors Oracle-supported public APIs. When diagnosing G_AUTH_ERROR conditions, administrators should examine the FND message stack populated via PLITBLM and verify that valid payment instrument and transaction extension records exist in ASO_PAYMENTS for the quote header in question.