Search Results icx_req_cart_errors_s

Overview

APPS.ICX_REQ_SUBMIT is a PL/SQL package body that supports the requisition submission phase of the Oracle E-Business Suite iProcurement (Internet Procurement) shopping flow. Its primary business function is to convert the contents of a shopping cart held in the ICX tables into a valid Oracle Purchasing requisition, validating cart data, recording errors and messages, and finalizing the submission transaction. The package is classified as OTHER in the ETRM repository, indicating it is a supporting utility rather than a published public API, though it is referenced by several other packages.

The body composes calls to a wide set of dependencies including FND_API, FND_MESSAGE, FND_CURRENCY, GL_SETS_OF_BOOKS, ICX_LOAD_REQ_INTERFACE, ICX_ON_UTILITIES, ICX_REQ_ACCT2, ICX_REQ_CUSTOM, ICX_REQ_NAVIGATION, and ICX_REQ_ORDER. This dependency chain confirms the package sits at the center of the checkout-to-requisition pipeline: it reads shopping cart structures, validates them, invokes the requisition interface load routines, and hands off to order/requisition processing.

Key Procedures and Functions

The ETRM metadata documents three procedures or functions within the package body:

• FINALSUBMIT — Drives the final submission stage of the shopping cart, coordinating validation, currency and system parameter lookups, and the transition from cart to requisition. It is the principal entry point invoked when a user or concurrent process commits a requisition submission.
• STOREERROR — Records validation or processing failures encountered during cart submission into the ICX_REQ_CART_ERRORS structure, providing the error messages later surfaced to the user. This routine relies on FND_MESSAGE and the error sequence ICX_REQ_CART_ERRORS_S to assign error identifiers.
• SHOW_END — A terminating or display routine, likely used after submission processing to close the interaction, write output through HTP/OWA_UTIL, or finalize navigation state.

No parameter lists are documented in the metadata and are therefore not reproduced here.

Tables Accessed

The package references its tables through APPS synonyms. Documented references include:

• ICX_SHOPPING_CARTS and ICX_SHOPPING_CART_LINES — source cart headers and lines converted into requisition lines.
• ICX_CART_DISTRIBUTIONS and ICX_CART_LINE_DISTRIBUTIONS — accounting distribution data carried forward onto the requisition.
• ICX_REQ_CART_ERRORS and ICX_REQ_CART_ERRORS_S — error staging and the sequence that supplies primary keys for error rows. The sequence ICX_REQ_CART_ERRORS_S is directly relevant to users searching for it, as it is populated during failed submissions.
• MTL_SYSTEM_ITEMS and MTL_SYSTEM_ITEMS_KFV — item validation and descriptive flexfield/key flexfield value resolution.
• FINANCIALS_SYSTEM_PARAMETERS, FND_CURRENCIES, and GL_SETS_OF_BOOKS — currency, set of books, and system-level defaults.
• PO_UNIQUE_IDENTIFIER_CONTROL — requisition numbering and unique identifier assignment.
• DUAL, HTP, OWA_UTIL, and PLITBLM — utility constructs for single-row queries and HTML output generation.

Usage Notes

ICX_REQ_SUBMIT is normally invoked indirectly by the iProcurement shopping cart and checkout flow rather than being called directly. It is referenced by three other database objects, indicating it forms part of an internal call graph within the requisition submission stack (for example, navigation and order-handling packages). Administrators troubleshooting cart submission failures commonly inspect ICX_REQ_CART_ERRORS and its sequence ICX_REQ_CART_ERRORS_S, since STOREERROR writes diagnostic rows there. Customizations should avoid direct modification of this package body and instead use documented extension points such as ICX_REQ_CUSTOM or the public FND_API error-handling framework, as the body is a standard, VALID object owned by APPS.