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 184: IF l_mo_line_stat = INV_GLOBALS.G_TO_STATUS_CANCEL_BY_SOURCE

180: , l_api_name
181: );
182: END IF;
183:
184: IF l_mo_line_stat = INV_GLOBALS.G_TO_STATUS_CANCEL_BY_SOURCE
185: THEN
186: x_drop_type := 'CANCELLED';
187: ELSIF l_txn_action_id = INV_GLOBALS.G_ACTION_STGXFR THEN
188: x_drop_type := 'STG_XFER';

Line 187: ELSIF l_txn_action_id = INV_GLOBALS.G_ACTION_STGXFR THEN

183:
184: IF l_mo_line_stat = INV_GLOBALS.G_TO_STATUS_CANCEL_BY_SOURCE
185: THEN
186: x_drop_type := 'CANCELLED';
187: ELSIF l_txn_action_id = INV_GLOBALS.G_ACTION_STGXFR THEN
188: x_drop_type := 'STG_XFER';
189: ELSIF l_move_order_type = INV_GLOBALS.G_MOVE_ORDER_MFG_PICK
190: AND l_txn_action_id = INV_GLOBALS.G_ACTION_ISSUE THEN
191: x_drop_type := 'WIP_ISSUE';

Line 189: ELSIF l_move_order_type = INV_GLOBALS.G_MOVE_ORDER_MFG_PICK

185: THEN
186: x_drop_type := 'CANCELLED';
187: ELSIF l_txn_action_id = INV_GLOBALS.G_ACTION_STGXFR THEN
188: x_drop_type := 'STG_XFER';
189: ELSIF l_move_order_type = INV_GLOBALS.G_MOVE_ORDER_MFG_PICK
190: AND l_txn_action_id = INV_GLOBALS.G_ACTION_ISSUE THEN
191: x_drop_type := 'WIP_ISSUE';
192: ELSIF l_move_order_type = INV_GLOBALS.G_MOVE_ORDER_MFG_PICK
193: AND l_txn_action_id = INV_GLOBALS.G_ACTION_SUBXFR THEN

Line 190: AND l_txn_action_id = INV_GLOBALS.G_ACTION_ISSUE THEN

186: x_drop_type := 'CANCELLED';
187: ELSIF l_txn_action_id = INV_GLOBALS.G_ACTION_STGXFR THEN
188: x_drop_type := 'STG_XFER';
189: ELSIF l_move_order_type = INV_GLOBALS.G_MOVE_ORDER_MFG_PICK
190: AND l_txn_action_id = INV_GLOBALS.G_ACTION_ISSUE THEN
191: x_drop_type := 'WIP_ISSUE';
192: ELSIF l_move_order_type = INV_GLOBALS.G_MOVE_ORDER_MFG_PICK
193: AND l_txn_action_id = INV_GLOBALS.G_ACTION_SUBXFR THEN
194: x_drop_type := 'WIP_SUB_XFER';

Line 192: ELSIF l_move_order_type = INV_GLOBALS.G_MOVE_ORDER_MFG_PICK

188: x_drop_type := 'STG_XFER';
189: ELSIF l_move_order_type = INV_GLOBALS.G_MOVE_ORDER_MFG_PICK
190: AND l_txn_action_id = INV_GLOBALS.G_ACTION_ISSUE THEN
191: x_drop_type := 'WIP_ISSUE';
192: ELSIF l_move_order_type = INV_GLOBALS.G_MOVE_ORDER_MFG_PICK
193: AND l_txn_action_id = INV_GLOBALS.G_ACTION_SUBXFR THEN
194: x_drop_type := 'WIP_SUB_XFER';
195: ELSIF l_txn_action_id = INV_GLOBALS.G_ACTION_SUBXFR THEN
196: x_drop_type := 'SUB_XFER';

Line 193: AND l_txn_action_id = INV_GLOBALS.G_ACTION_SUBXFR THEN

189: ELSIF l_move_order_type = INV_GLOBALS.G_MOVE_ORDER_MFG_PICK
190: AND l_txn_action_id = INV_GLOBALS.G_ACTION_ISSUE THEN
191: x_drop_type := 'WIP_ISSUE';
192: ELSIF l_move_order_type = INV_GLOBALS.G_MOVE_ORDER_MFG_PICK
193: AND l_txn_action_id = INV_GLOBALS.G_ACTION_SUBXFR THEN
194: x_drop_type := 'WIP_SUB_XFER';
195: ELSIF l_txn_action_id = INV_GLOBALS.G_ACTION_SUBXFR THEN
196: x_drop_type := 'SUB_XFER';
197: END IF;

Line 195: ELSIF l_txn_action_id = INV_GLOBALS.G_ACTION_SUBXFR THEN

191: x_drop_type := 'WIP_ISSUE';
192: ELSIF l_move_order_type = INV_GLOBALS.G_MOVE_ORDER_MFG_PICK
193: AND l_txn_action_id = INV_GLOBALS.G_ACTION_SUBXFR THEN
194: x_drop_type := 'WIP_SUB_XFER';
195: ELSIF l_txn_action_id = INV_GLOBALS.G_ACTION_SUBXFR THEN
196: x_drop_type := 'SUB_XFER';
197: END IF;
198: ELSIF l_wms_task_type = 7 THEN
199: x_drop_type := 'CONS_STG_MV';

Line 200: ELSIF l_txn_action_id = INV_GLOBALS.G_ACTION_SUBXFR THEN

196: x_drop_type := 'SUB_XFER';
197: END IF;
198: ELSIF l_wms_task_type = 7 THEN
199: x_drop_type := 'CONS_STG_MV';
200: ELSIF l_txn_action_id = INV_GLOBALS.G_ACTION_SUBXFR THEN
201: x_drop_type := 'OVERPICK';
202: END IF;
203:
204: IF x_drop_type IS NULL THEN

Line 1331: IF l_txn_action_id = INV_GLOBALS.G_ACTION_STGXFR

1327: END IF;
1328:
1329: l_progress := 90;
1330:
1331: IF l_txn_action_id = INV_GLOBALS.G_ACTION_STGXFR
1332: AND
1333: x_drop_type <> 'CANCELLED'
1334: THEN
1335: OPEN c_num_stg_xfers (p_organization_id, p_transfer_lpn_id);

Line 1345: ELSIF l_txn_src_type_id = INV_GLOBALS.G_SOURCETYPE_WIP

1341: ( '# of sales order/internal order drops: ' || to_char(l_drop_count)
1342: , l_api_name
1343: );
1344: END IF;
1345: ELSIF l_txn_src_type_id = INV_GLOBALS.G_SOURCETYPE_WIP
1346: AND
1347: l_txn_action_id = INV_GLOBALS.G_ACTION_ISSUE
1348: THEN
1349: OPEN c_num_wip_issue_drops (p_organization_id, p_transfer_lpn_id);

Line 1347: l_txn_action_id = INV_GLOBALS.G_ACTION_ISSUE

1343: );
1344: END IF;
1345: ELSIF l_txn_src_type_id = INV_GLOBALS.G_SOURCETYPE_WIP
1346: AND
1347: l_txn_action_id = INV_GLOBALS.G_ACTION_ISSUE
1348: THEN
1349: OPEN c_num_wip_issue_drops (p_organization_id, p_transfer_lpn_id);
1350: FETCH c_num_wip_issue_drops INTO l_drop_count;
1351: CLOSE c_num_wip_issue_drops;

Line 1367: ELSIF l_txn_action_id = INV_GLOBALS.G_ACTION_SUBXFR

1363: --
1364: -- Force deconsolidation
1365: --
1366: l_drop_count := 2;
1367: ELSIF l_txn_action_id = INV_GLOBALS.G_ACTION_SUBXFR
1368: THEN
1369: OPEN c_num_sub_xfers (p_organization_id, p_transfer_lpn_id);
1370: FETCH c_num_sub_xfers INTO l_drop_count;
1371: CLOSE c_num_sub_xfers;

Line 8302: , INV_GLOBALS.G_TYPE_CONTAINER_PACK

8298: , 1
8299: , 1
8300: , transaction_uom
8301: , transaction_cost
8302: , INV_GLOBALS.G_TYPE_CONTAINER_PACK
8303: , INV_GLOBALS.G_ACTION_CONTAINERPACK
8304: , INV_GLOBALS.G_SOURCETYPE_INVENTORY
8305: , NULL
8306: , NULL

Line 8303: , INV_GLOBALS.G_ACTION_CONTAINERPACK

8299: , 1
8300: , transaction_uom
8301: , transaction_cost
8302: , INV_GLOBALS.G_TYPE_CONTAINER_PACK
8303: , INV_GLOBALS.G_ACTION_CONTAINERPACK
8304: , INV_GLOBALS.G_SOURCETYPE_INVENTORY
8305: , NULL
8306: , NULL
8307: , SYSDATE

Line 8304: , INV_GLOBALS.G_SOURCETYPE_INVENTORY

8300: , transaction_uom
8301: , transaction_cost
8302: , INV_GLOBALS.G_TYPE_CONTAINER_PACK
8303: , INV_GLOBALS.G_ACTION_CONTAINERPACK
8304: , INV_GLOBALS.G_SOURCETYPE_INVENTORY
8305: , NULL
8306: , NULL
8307: , SYSDATE
8308: , acct_period_id

Line 9187: IF l_to_loc_type <> inv_globals.g_loc_type_staging_lane THEN

9183: EXCEPTION WHEN NO_DATA_FOUND THEN
9184: IF (l_debug = 1) THEN print_debug('exception selecting to_loc_type', l_api_name ); END IF;
9185: RAISE FND_API.G_exc_unexpected_error;
9186: END ;
9187: IF l_to_loc_type <> inv_globals.g_loc_type_staging_lane THEN
9188: fnd_message.set_name('WMS', 'WMS_STAGE_FROM_CONSOL_LPN');
9189: fnd_msg_pub.ADD;
9190: IF l_debug = 1 THEN
9191: print_debug('WMS_STAGE_FROM_CONSOL_LPN : Destination Locator must be ' ||

Line 9567: IF l_txn_type_id <> INV_GLOBALS.G_TYPE_CONTAINER_PACK

9563:
9564: --
9565: -- Call complete_pick
9566: --
9567: IF l_txn_type_id <> INV_GLOBALS.G_TYPE_CONTAINER_PACK
9568: THEN
9569: l_api_return_status := fnd_api.g_ret_sts_success;
9570: wms_task_dispatch_gen.complete_pick
9571: ( p_lpn => p_drop_lpn

Line 9612: IF l_txn_type_id = INV_GLOBALS.G_TYPE_CONTAINER_PACK

9608: END IF;
9609: END IF;
9610:
9611: BEGIN
9612: IF l_txn_type_id = INV_GLOBALS.G_TYPE_CONTAINER_PACK
9613: THEN
9614: UPDATE mtl_material_transactions_temp mmtt
9615: SET mmtt.transaction_header_id = l_txn_header_id
9616: , mmtt.subinventory_code = p_subinventory