Search Results g_msg_lvl_success

Overview

WSM_RESERVATIONS_GRP is an Oracle EBS PL/SQL package body owned by the APPS schema and classified as a Group (GRP) API within the Warehouse Management (WSM) module. Its business function is to encapsulate reservation-related supply and demand processing logic, exposing a stable programmatic interface that other EBS modules and custom extensions can call without direct dependency on underlying inventory and work-in-process tables. The package is oriented toward reservation planning: determining what supply is available against a given demand, and validating that a proposed supply/demand relationship is consistent before reservations are created or committed.

As a GRP-type API, the package follows Oracle's standard API conventions. It declares package-level constants for logging and messaging, including the FND_LOG log-level constants (g_log_level_unexpected through g_log_level_statement) and FND_MSG_PUB message-level constants. Notable among these is g_msg_lvl_success NUMBER := FND_MSG_PUB.G_MSG_LVL_SUCCESS, the success-severity message level used by the API framework to register and retrieve informational messages via FND_MSG_PUB. The package also declares the standard return-status constants g_ret_success, g_ret_error, and g_ret_unexpected from FND_API, and identifies itself through g_pkg_name.

Key Procedures and Functions

The package exposes two documented public procedures:

• GET_AVAILABLE_SUPPLY_DEMAND — Retrieves available supply and demand quantities for a specified item and context. The procedure accepts organization, item, revision, lot, subinventory, locator, LPN, and project identifiers as input, together with supply/demand code, type, header, line, and line-detail identifiers. It returns an available quantity plus source UOM and source primary UOM codes, along with the standard API return status, message count, and message data output parameters. It is the principal query interface for reservation availability calculations.
• VALIDATE_SUPPLY_DEMAND — Validates the supply-and-demand combination supplied by the caller before reservation processing proceeds. It confirms that the referenced records and their relationships are consistent, returning the standard API return status and message outputs so callers can handle validation failures gracefully.

Tables Accessed

The package reads from several tables through APPS synonyms:

• MTL_SYSTEM_ITEMS — Provides item master attributes, including unit-of-measure information used to populate the source UOM and source primary UOM outputs.
• WIP_DISCRETE_JOBS and WIP_ENTITIES — Supply originating from work-in-process, including discrete job and WIP entity records, used to determine on-hand and expected supply available to satisfy demand.
• PLITBLM — An internal EBS table used in reservation and inventory processing; it participates in the underlying supply/demand resolution logic invoked by the package.

Usage Notes

WSM_RESERVATIONS_GRP is referenced by two other packages, indicating it is consumed programmatically rather than invoked by end-user forms directly. Typical invocation points include Warehouse Management reservation flows and custom PL/SQL that needs standardized supply/demand availability or validation logic. Callers should invoke GET_AVAILABLE_SUPPLY_DEMAND before creating reservations and call VALIDATE_SUPPLY_DEMAND to confirm data integrity. All results and failures are communicated through the standard FND_API return status and the FND_MSG_PUB message stack, with success-level messages governed by g_msg_lvl_success; callers should check x_return_status and drain messages using the FND_MSG_PUB API rather than reading the message-level constants directly.