Search Results log_event

Overview

WMS_CARTONIZATION_USER_PUB is a public PL/SQL package in the Oracle Warehouse Management (WMS) module of Oracle E-Business Suite, delivered under the APPS schema and classified as a PUB API. Its business purpose is to provide a customer-extensible entry point for cartonization logic within the warehouse outbound flow. Cartonization is the process of determining the appropriate shipping container (license plate number, or LPN) into which picked items are packed. The package follows the standard Oracle EBS API template with OUT NOCOPY status, message count, and message data parameters, and is intended to be modified or extended by customers who require customized container-selection rules.

The package body exposes a private helper, log_event, used for internal tracing, and a single public procedure, CARTONIZE. The body carries the header signature $Header: WMSCRTUB.pls 120.2 2008/04/16 19:24:38 rsagar noship $, indicating a non-shipping, customization-oriented file. The documented API classification confirms that CARTONIZE is the supported public interface, while log_event is an internal utility rather than a callable API.

Key Procedures and Functions

The documented public interface consists of one procedure:

• CARTONIZE — The primary public API. It accepts a task table describing the items to be cartonized along with an organization identifier, and returns a task table reflecting the container assignment. It also returns the standard x_return_status, x_msg_count, and x_msg_data parameters used for error propagation. Internally, the procedure iterates over the task table and invokes WMS_CONTAINER_PUB.GENERATE_LPN to create the target LPN, capturing the resulting LPN and LPN ID.

The private log_event helper records timestamped diagnostic messages. It reads the INV_DEBUG_TRACE profile option via FND_PROFILE.VALUE; when this profile is set to 1, the message is routed to INV_TRX_UTIL_PUB.TRACE under the module tag WMS_CARTNZN_PUB. This mechanism allows implementers to trace cartonization activity when the user searches for log_event, since that term does not correspond to a public API but to this internal diagnostic routine. The prefix label assigned by log_event is wms.plsql.wms_cartnzn_pub.cartonization.

Tables Accessed

The documented table reference for this package is PLITBLM, accessed through an APPS synonym. This table is associated with material-handling and container/LPN processing within WMS. The package does not directly perform DML on core transactional tables; instead, LPN generation is delegated to WMS_CONTAINER_PUB.GENERATE_LPN, which handles the underlying persistence of license plate records. The PLITBLM reference supports the workflow and container logic consumed during cartonization.

Usage Notes

WMS_CARTONIZATION_USER_PUB.CARTONIZE is typically invoked within the outbound shipping or pick-confirm flow, either from Oracle WMS forms or from concurrent programs that perform automated cartonization. Because the body is a customer-modifiable stub, implementers commonly place custom container-selection logic inside it and drive execution through the standard cartonization framework rather than calling it directly from ad-hoc code. The INV_DEBUG_TRACE profile should be enabled only during troubleshooting, since log_event writes trace output to INV_TRX_UTIL_PUB.TRACE. When extending the package, developers should preserve the documented CARTONIZE signature and the standard return-status conventions, validating inputs and returning FND_API.G_RET_STS_ERROR or FND_API.G_RET_STS_UNEXP_ERROR as appropriate. No public procedure other than CARTONIZE is documented for external use.