Search Results sql_errm

Overview

GML_RCV_DB_COMMON is a process-manufacturing (OPM) receiving utility package owned by APPS in Oracle E-Business Suite. Its documented purpose is to consolidate database-level logic required when receiving goods in a process-enabled organization, most notably the creation of quality samples for OPM items. The package header record shows an original creation date of 31-OCT-2002 under version control, and the body resides in the GMLRCVCB.pls script. Internally, the package derives a debug flag from the AFLOG_ENABLED profile option via FND_PROFILE.VALUE and builds a module prefix from the package name for consistent logging, which is the standard instrumentation pattern used across OPM PL/SQL packages.

Key Procedures and Functions

• RAISE_QUALITY_EVENT — Raises the OPM quality event that instigates sample creation when an item is received into a receiving location belonging to a process organization. The procedure reads the organization's PROCESS_ENABLED_FLAG from MTL_PARAMETERS and the item's PROCESS_QUALITY_ENABLED_FLAG from MTL_SYSTEM_ITEMS_B; only when both are set does it build a Workflow event name and key and dispatch the event using a WF_PARAMETER_LIST_T parameter list. According to the in-source comment, it is invoked from rvtth.lpc. The search term sql_errm relates to the package's exception handling convention, in which the SQL error message text is captured for diagnostic logging rather than being surfaced to the calling form.
• VALIDATE_RMA_LOT_QUANTITIES — Validates lot-level quantities on return material authorizations processed against OPM inventory, ensuring lot and unit-of-measure quantities reconcile before receipt posting.
• VALIDATE_IO_LOT_QUANTITIES — Performs the equivalent lot-quantity validation for internal order (IO) receipts, confirming that lot, serial, and UOM data are internally consistent prior to transaction processing.

Parameter lists are not documented in the available metadata and should be confirmed from the deployed package specification in a specific instance.

Tables Accessed

The package queries MTL_PARAMETERS to determine whether the destination organization is process enabled, and MTL_SYSTEM_ITEMS_B to read the item's process quality flag. Receiving transactions are read from RCV_TRANSACTIONS with delivery context supplied by WSH_DELIVERY_DETAILS and WSH_DELIVERY_ASSIGNMENTS. Lot and serial validation draws on OE_LOT_SERIAL_NUMBERS, while MTL_UNITS_OF_MEASURE and the legacy OPM synonyms SY_UOMS_MST, IC_ITEM_MST, and IC_TRAN_PND supply unit-of-measure and item master data. Sales order line context is available through OE_ORDER_LINES_ALL. WF_PARAMETER_LIST_T is not a physical table but the Workflow parameter-list type used to populate the raised event.

Usage Notes

The package is not an interface table or a user-facing concurrent program; it is a utility layer called from other OPM receiving code. ETRM records two dependent packages referencing it, confirming its role as a shared subroutine library. Typical invocation paths are the receiving transaction form, the OPM receiving transaction processor, and custom extensions that need the same quality-event or lot-quantity validation logic. Because the raise-quality path depends on AFLOG_ENABLED, enabling FND logging produces diagnostic output useful when troubleshooting sample creation failures in a process organization. Custom code should call these procedures rather than reimplementing the flag checks, and should expect no documented return values — validation failures are signalled through exceptions whose message text is captured in the same manner as the SQL error text.