Search Results print_debug




Overview
Explore in AI Chat

Overview

The APPS.WMS_ATF_Util_APIs package body is a utility API layer within the Oracle Warehouse Management System (WMS) module of Oracle E-Business Suite. The naming convention (WMS, ATF) associates the package with the Application Transaction Framework, the WMS subsystem responsible for executing warehouse task activities such as picking, put-away, and operation plan assignment. The package exposes public APIs that WMS mobile and desktop flows invoke to drive task execution and transactional processing.

The package specification header identifies it as WMSOPUTB.pls, version 120.0.12020000.2, dated 2012/07/04. It declares a series of package-level constants that map to Inventory action and source type codes defined in inv_globals (for example, receipt, intransit receipt, sub-transfer, move order, purchase order, internal requisition, RMA, and inventory source types). These constants standardize how the package resolves transaction semantics when calling Inventory APIs. The package is classified as OTHER in the ETRM metadata and is referenced by two other packages, confirming its role as a shared utility rather than an entry-point program.

Key Procedures and Functions

The ETRM metadata documents two procedures:

  • ASSIGN_OPERATION_PLAN — Assigns an operation plan to a WMS task. It follows the standard Oracle API pattern with API version, initialization message list, commit flag, and validation level inputs, returning x_return_status, x_msg_count, and x_msg_data. Business inputs include a task identifier, an optional activity type identifier, and an optional organization identifier. The procedure initializes x_return_status to g_ret_sts_success and uses the INV_DEBUG_TRACE profile to gate debug output.
  • COMPLETE_TM_PROCESSING — Completes task manager processing, finalizing the transactional outcome of a WMS task activity.

The body also contains a private helper, print_debug, which accepts an error message and a level argument. It reads the INV_DEBUG_TRACE profile option, and when tracing is enabled it delegates to inv_mobile_helper_functions.tracelog, tagging entries with the module name 'WMS_ATF_Util_APIs'. This is the internal routine that produces diagnostic output during API execution.

Tables Accessed

  • MTL_MATERIAL_TRANSACTIONS_TEMP — the Inventory transaction interface table, used to stage material transaction records that are subsequently processed by the transaction manager.
  • RCV_TRANSACTIONS — the receiving transactions table, accessed to record or validate receiving activity associated with inbound task processing.
  • WMS_DISPATCHED_TASKS — the WMS table holding dispatched warehouse tasks; central to task assignment and completion logic.
  • DUAL — used for scalar evaluations, such as resolving profile values or constants.

Usage Notes

WMS_ATF_Util_APIs is invoked programmatically from other WMS packages and from mobile/desktop WMS forms and concurrent processes that need to assign operation plans or complete task manager processing. Because the procedures conform to the FND_API message-handling convention, callers must inspect x_return_status and drain x_msg_count/x_msg_data to surface errors. Set the INV_DEBUG_TRACE profile option to enable diagnostic logging through inv_mobile_helper_functions.tracelog when troubleshooting the "print_debug" path. Customizations should treat this package as a dependency owned by Oracle, invoking it through its documented public APIs only.