eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.WMS_PICK_DROP_PVT dependencies on INV_GLOBALS

Line 194: IF l_mo_line_stat = INV_GLOBALS.G_TO_STATUS_CANCEL_BY_SOURCE

190: , l_api_name
191: );
192: END IF;
193:
194: IF l_mo_line_stat = INV_GLOBALS.G_TO_STATUS_CANCEL_BY_SOURCE
195: THEN
196: x_drop_type := 'CANCELLED';
197: ELSIF l_txn_action_id = INV_GLOBALS.G_ACTION_STGXFR THEN
198: x_drop_type := 'STG_XFER';

Line 197: ELSIF l_txn_action_id = INV_GLOBALS.G_ACTION_STGXFR THEN

193:
194: IF l_mo_line_stat = INV_GLOBALS.G_TO_STATUS_CANCEL_BY_SOURCE
195: THEN
196: x_drop_type := 'CANCELLED';
197: ELSIF l_txn_action_id = INV_GLOBALS.G_ACTION_STGXFR THEN
198: x_drop_type := 'STG_XFER';
199: ELSIF l_move_order_type = INV_GLOBALS.G_MOVE_ORDER_MFG_PICK
200: AND l_txn_action_id = INV_GLOBALS.G_ACTION_ISSUE THEN
201: x_drop_type := 'WIP_ISSUE';

Line 199: ELSIF l_move_order_type = INV_GLOBALS.G_MOVE_ORDER_MFG_PICK

195: THEN
196: x_drop_type := 'CANCELLED';
197: ELSIF l_txn_action_id = INV_GLOBALS.G_ACTION_STGXFR THEN
198: x_drop_type := 'STG_XFER';
199: ELSIF l_move_order_type = INV_GLOBALS.G_MOVE_ORDER_MFG_PICK
200: AND l_txn_action_id = INV_GLOBALS.G_ACTION_ISSUE THEN
201: x_drop_type := 'WIP_ISSUE';
202: ELSIF l_move_order_type = INV_GLOBALS.G_MOVE_ORDER_MFG_PICK
203: AND l_txn_action_id = INV_GLOBALS.G_ACTION_SUBXFR THEN

Line 200: AND l_txn_action_id = INV_GLOBALS.G_ACTION_ISSUE THEN

196: x_drop_type := 'CANCELLED';
197: ELSIF l_txn_action_id = INV_GLOBALS.G_ACTION_STGXFR THEN
198: x_drop_type := 'STG_XFER';
199: ELSIF l_move_order_type = INV_GLOBALS.G_MOVE_ORDER_MFG_PICK
200: AND l_txn_action_id = INV_GLOBALS.G_ACTION_ISSUE THEN
201: x_drop_type := 'WIP_ISSUE';
202: ELSIF l_move_order_type = INV_GLOBALS.G_MOVE_ORDER_MFG_PICK
203: AND l_txn_action_id = INV_GLOBALS.G_ACTION_SUBXFR THEN
204: x_drop_type := 'WIP_SUB_XFER';

Line 202: ELSIF l_move_order_type = INV_GLOBALS.G_MOVE_ORDER_MFG_PICK

198: x_drop_type := 'STG_XFER';
199: ELSIF l_move_order_type = INV_GLOBALS.G_MOVE_ORDER_MFG_PICK
200: AND l_txn_action_id = INV_GLOBALS.G_ACTION_ISSUE THEN
201: x_drop_type := 'WIP_ISSUE';
202: ELSIF l_move_order_type = INV_GLOBALS.G_MOVE_ORDER_MFG_PICK
203: AND l_txn_action_id = INV_GLOBALS.G_ACTION_SUBXFR THEN
204: x_drop_type := 'WIP_SUB_XFER';
205: ELSIF l_txn_action_id = INV_GLOBALS.G_ACTION_SUBXFR THEN
206: x_drop_type := 'SUB_XFER';

Line 203: AND l_txn_action_id = INV_GLOBALS.G_ACTION_SUBXFR THEN

199: ELSIF l_move_order_type = INV_GLOBALS.G_MOVE_ORDER_MFG_PICK
200: AND l_txn_action_id = INV_GLOBALS.G_ACTION_ISSUE THEN
201: x_drop_type := 'WIP_ISSUE';
202: ELSIF l_move_order_type = INV_GLOBALS.G_MOVE_ORDER_MFG_PICK
203: AND l_txn_action_id = INV_GLOBALS.G_ACTION_SUBXFR THEN
204: x_drop_type := 'WIP_SUB_XFER';
205: ELSIF l_txn_action_id = INV_GLOBALS.G_ACTION_SUBXFR THEN
206: x_drop_type := 'SUB_XFER';
207: END IF;

Line 205: ELSIF l_txn_action_id = INV_GLOBALS.G_ACTION_SUBXFR THEN

201: x_drop_type := 'WIP_ISSUE';
202: ELSIF l_move_order_type = INV_GLOBALS.G_MOVE_ORDER_MFG_PICK
203: AND l_txn_action_id = INV_GLOBALS.G_ACTION_SUBXFR THEN
204: x_drop_type := 'WIP_SUB_XFER';
205: ELSIF l_txn_action_id = INV_GLOBALS.G_ACTION_SUBXFR THEN
206: x_drop_type := 'SUB_XFER';
207: END IF;
208: ELSIF l_wms_task_type = 7 THEN
209: x_drop_type := 'CONS_STG_MV';

Line 210: ELSIF l_txn_action_id = INV_GLOBALS.G_ACTION_SUBXFR THEN

206: x_drop_type := 'SUB_XFER';
207: END IF;
208: ELSIF l_wms_task_type = 7 THEN
209: x_drop_type := 'CONS_STG_MV';
210: ELSIF l_txn_action_id = INV_GLOBALS.G_ACTION_SUBXFR THEN
211: x_drop_type := 'OVERPICK';
212: END IF;
213:
214: IF x_drop_type IS NULL THEN

Line 1421: IF l_txn_action_id = INV_GLOBALS.G_ACTION_STGXFR

1417: END IF;
1418:
1419: l_progress := 90;
1420:
1421: IF l_txn_action_id = INV_GLOBALS.G_ACTION_STGXFR
1422: AND
1423: x_drop_type <> 'CANCELLED'
1424: THEN
1425: OPEN c_num_stg_xfers (p_organization_id, p_transfer_lpn_id);

Line 1478: ELSIF l_txn_src_type_id = INV_GLOBALS.G_SOURCETYPE_WIP

1474: ( '# of sales order/internal order drops: ' || to_char(l_drop_count)
1475: , l_api_name
1476: );
1477: END IF;
1478: ELSIF l_txn_src_type_id = INV_GLOBALS.G_SOURCETYPE_WIP
1479: AND
1480: l_txn_action_id = INV_GLOBALS.G_ACTION_ISSUE
1481: THEN
1482: OPEN c_num_wip_issue_drops (p_organization_id, p_transfer_lpn_id);

Line 1480: l_txn_action_id = INV_GLOBALS.G_ACTION_ISSUE

1476: );
1477: END IF;
1478: ELSIF l_txn_src_type_id = INV_GLOBALS.G_SOURCETYPE_WIP
1479: AND
1480: l_txn_action_id = INV_GLOBALS.G_ACTION_ISSUE
1481: THEN
1482: OPEN c_num_wip_issue_drops (p_organization_id, p_transfer_lpn_id);
1483: FETCH c_num_wip_issue_drops INTO l_drop_count;
1484: CLOSE c_num_wip_issue_drops;

Line 1500: ELSIF l_txn_action_id = INV_GLOBALS.G_ACTION_SUBXFR

1496: --
1497: -- Force deconsolidation
1498: --
1499: l_drop_count := 2;
1500: ELSIF l_txn_action_id = INV_GLOBALS.G_ACTION_SUBXFR
1501: THEN
1502: -- Added for bug 12853197
1503: OPEN c_chk_mult_subinv (p_organization_id, p_transfer_lpn_id);
1504: FETCH c_chk_mult_subinv INTO g_chk_mult_subinv;

Line 8596: , INV_GLOBALS.G_TYPE_CONTAINER_PACK

8592: , 1
8593: , 1
8594: , transaction_uom
8595: , transaction_cost
8596: , INV_GLOBALS.G_TYPE_CONTAINER_PACK
8597: , INV_GLOBALS.G_ACTION_CONTAINERPACK
8598: , INV_GLOBALS.G_SOURCETYPE_INVENTORY
8599: , NULL
8600: , NULL

Line 8597: , INV_GLOBALS.G_ACTION_CONTAINERPACK

8593: , 1
8594: , transaction_uom
8595: , transaction_cost
8596: , INV_GLOBALS.G_TYPE_CONTAINER_PACK
8597: , INV_GLOBALS.G_ACTION_CONTAINERPACK
8598: , INV_GLOBALS.G_SOURCETYPE_INVENTORY
8599: , NULL
8600: , NULL
8601: , SYSDATE

Line 8598: , INV_GLOBALS.G_SOURCETYPE_INVENTORY

8594: , transaction_uom
8595: , transaction_cost
8596: , INV_GLOBALS.G_TYPE_CONTAINER_PACK
8597: , INV_GLOBALS.G_ACTION_CONTAINERPACK
8598: , INV_GLOBALS.G_SOURCETYPE_INVENTORY
8599: , NULL
8600: , NULL
8601: , SYSDATE
8602: , acct_period_id

Line 9506: IF l_to_loc_type <> inv_globals.g_loc_type_staging_lane THEN

9502: EXCEPTION WHEN NO_DATA_FOUND THEN
9503: IF (l_debug = 1) THEN print_debug('exception selecting to_loc_type', l_api_name ); END IF;
9504: RAISE FND_API.G_exc_unexpected_error;
9505: END ;
9506: IF l_to_loc_type <> inv_globals.g_loc_type_staging_lane THEN
9507: fnd_message.set_name('WMS', 'WMS_STAGE_FROM_CONSOL_LPN');
9508: fnd_msg_pub.ADD;
9509: IF l_debug = 1 THEN
9510: print_debug('WMS_STAGE_FROM_CONSOL_LPN : Destination Locator must be ' ||

Line 9890: IF l_txn_type_id <> INV_GLOBALS.G_TYPE_CONTAINER_PACK

9886:
9887: --
9888: -- Call complete_pick
9889: --
9890: IF l_txn_type_id <> INV_GLOBALS.G_TYPE_CONTAINER_PACK
9891: THEN
9892: l_api_return_status := fnd_api.g_ret_sts_success;
9893: wms_task_dispatch_gen.complete_pick
9894: ( p_lpn => p_drop_lpn

Line 9935: IF l_txn_type_id = INV_GLOBALS.G_TYPE_CONTAINER_PACK

9931: END IF;
9932: END IF;
9933:
9934: BEGIN
9935: IF l_txn_type_id = INV_GLOBALS.G_TYPE_CONTAINER_PACK
9936: THEN
9937: UPDATE mtl_material_transactions_temp mmtt
9938: SET mmtt.transaction_header_id = l_txn_header_id
9939: , mmtt.subinventory_code = p_subinventory