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_DEVICE_CONFIRMATION_PUB dependencies on WMS_DEVICE_INTEGRATION_PVT

Line 57: AND business_event_id IN (wms_device_integration_pvt.wms_be_task_confirm,wms_device_integration_pvt.wms_be_load_confirm)

53: SELECT lot_number,lot_qty,serial_number
54: FROM wms_device_requests
55: WHERE relation_id = p_relation_id
56: AND task_id = p_txn_temp_id
57: AND business_event_id IN (wms_device_integration_pvt.wms_be_task_confirm,wms_device_integration_pvt.wms_be_load_confirm)
58: AND task_summary = 'N';
59:
60: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
61:

Line 71: AND business_event_id IN (wms_device_integration_pvt.wms_be_task_confirm,wms_device_integration_pvt.wms_be_load_confirm)

67: SELECT COUNT(*),SUM(lot_qty) INTO l_count_child_rec,l_total_lot_qty
68: FROM wms_device_requests
69: WHERE relation_id = p_relation_id
70: AND task_id = p_txn_temp_id
71: AND business_event_id IN (wms_device_integration_pvt.wms_be_task_confirm,wms_device_integration_pvt.wms_be_load_confirm)
72: AND task_summary = 'N';
73:
74: IF (l_debug = 1) THEN
75: trace('l_count_temp::'||l_count_child_rec||' total_lot_qty::'||l_total_lot_qty);

Line 244: WHERE business_event_id IN (wms_device_integration_pvt.wms_be_load_confirm,wms_device_integration_pvt.wms_be_task_confirm)

240: , lot_qty
241: , serial_number
242: , device_id
243: FROM wms_device_requests
244: WHERE business_event_id IN (wms_device_integration_pvt.wms_be_load_confirm,wms_device_integration_pvt.wms_be_task_confirm)
245: ORDER BY relation_id ASC,task_id ASC, task_summary desc;
246:
247: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
248: BEGIN

Line 283: AND business_event_id IN (wms_device_integration_pvt.wms_be_pick_release,wms_device_integration_pvt.wms_be_wip_pick_release,wms_device_integration_pvt.wms_be_mo_task_alloc)

279: WHERE request_id = nvl(l_rec.relation_id,-1)
280: --nvl,to handle ERROR: when WCS does NOT pass relation_id or task_id
281: AND task_id = nvl(l_rec.task_id,-1)
282: AND task_summary = 'Y'
283: AND business_event_id IN (wms_device_integration_pvt.wms_be_pick_release,wms_device_integration_pvt.wms_be_wip_pick_release,wms_device_integration_pvt.wms_be_mo_task_alloc)
284: AND ROWNUM<2;
285: EXCEPTION
286: WHEN no_data_found THEN
287:

Line 410: WHERE business_event_id IN (wms_device_integration_pvt.wms_be_task_confirm,wms_device_integration_pvt.wms_be_load_confirm)

406: --IN the stack
407: UPDATE wms_device_requests
408: SET status_code = 'E',
409: status_msg = l_status_msg
410: WHERE business_event_id IN (wms_device_integration_pvt.wms_be_task_confirm,wms_device_integration_pvt.wms_be_load_confirm)
411: AND task_id = p_task_id
412: AND relation_id = p_relation_id;
413:
414: IF (l_debug = 1) THEN

Line 2599: (wms_device_integration_pvt.wms_be_task_confirm, wms_device_integration_pvt.wms_be_load_confirm)

2595: , reason_id
2596: , organization_id--Its NOT NULL Column
2597: FROM wms_device_requests
2598: WHERE business_event_id IN
2599: (wms_device_integration_pvt.wms_be_task_confirm, wms_device_integration_pvt.wms_be_load_confirm)
2600: AND device_status = 'S'
2601: AND task_summary = 'Y'
2602: ORDER BY xfer_lpn_id;
2603:

Line 2611: (wms_device_integration_pvt.wms_be_task_confirm,

2607: WHERE relation_id = p_relation_id
2608: AND task_id = p_temp_id
2609: AND task_summary = 'N'
2610: AND business_event_id IN
2611: (wms_device_integration_pvt.wms_be_task_confirm,
2612: wms_device_integration_pvt.wms_be_load_confirm);
2613:
2614:
2615: --Following c_update_xfer_lpn_context cursor is used to update LPN context to RESIDE_IN_INV after call to TM

Line 2612: wms_device_integration_pvt.wms_be_load_confirm);

2608: AND task_id = p_temp_id
2609: AND task_summary = 'N'
2610: AND business_event_id IN
2611: (wms_device_integration_pvt.wms_be_task_confirm,
2612: wms_device_integration_pvt.wms_be_load_confirm);
2613:
2614:
2615: --Following c_update_xfer_lpn_context cursor is used to update LPN context to RESIDE_IN_INV after call to TM
2616: --1-For REPLENISHMENT TASKS

Line 2630: WHERE wdr.business_event_id = wms_device_integration_pvt.WMS_BE_TASK_CONFIRM

2626: (SELECT wdr.xfer_lpn_id
2627: FROM wms_device_requests wdr,
2628: wms_device_requests_hist wdrh,
2629: wms_dispatched_tasks wdt
2630: WHERE wdr.business_event_id = wms_device_integration_pvt.WMS_BE_TASK_CONFIRM
2631: AND wdr.task_id = wdt.transaction_temp_id
2632: AND wdt.task_type IN (4,5,7) -- ONLY for Replenishment, MO Xfer,Staging TASKS
2633: AND wdr.status_code = 'S'
2634: AND wdr.device_status = 'S'

Line 2640: AND wdrh.business_event_id IN (wms_device_integration_pvt.wms_be_pick_release,wms_device_integration_pvt.wms_be_wip_pick_release,wms_device_integration_pvt.wms_be_mo_task_alloc)

2636: AND wdr.task_summary = wdrh.task_summary
2637: and wdrh.request_id = wdr.relation_id
2638: AND wdr.task_id = wdrh.task_id
2639: AND wdr.transaction_quantity > 0
2640: AND wdrh.business_event_id IN (wms_device_integration_pvt.wms_be_pick_release,wms_device_integration_pvt.wms_be_wip_pick_release,wms_device_integration_pvt.wms_be_mo_task_alloc)
2641: AND wdrh.TASK_TYPE_ID = 1);
2642:
2643:
2644: --used to xfer records into WDTH

Line 2654: WHERE business_event_id = wms_device_integration_pvt.WMS_BE_TASK_CONFIRM

2650:
2651: --used to update the account period in mmtt
2652: CURSOR c_open_period_check IS SELECT distinct organization_id, task_id
2653: FROM wms_device_requests
2654: WHERE business_event_id = wms_device_integration_pvt.WMS_BE_TASK_CONFIRM
2655: AND status_code = 'S'
2656: AND device_status = 'S'
2657: AND task_summary = 'Y';
2658:

Line 2718: AND business_event_id IN (wms_device_integration_pvt.wms_be_pick_release,wms_device_integration_pvt.wms_be_wip_pick_release,wms_device_integration_pvt.wms_be_mo_task_alloc)

2714: SELECT task_id,lpn_id INTO l_txn_temp_id,l_orig_lpn_id
2715: FROM wms_device_requests_hist
2716: WHERE request_id = l_rec.relation_id
2717: AND task_id = l_rec.task_id
2718: AND business_event_id IN (wms_device_integration_pvt.wms_be_pick_release,wms_device_integration_pvt.wms_be_wip_pick_release,wms_device_integration_pvt.wms_be_mo_task_alloc)
2719: AND ROWNUM <2;
2720: EXCEPTION
2721: WHEN no_data_found THEN
2722:

Line 3616: AND business_event_id = wms_device_integration_pvt.WMS_BE_TASK_CONFIRM

3612: AND msnt.fm_serial_number NOT IN
3613: (SELECT serial_number FROM wms_device_requests
3614: WHERE relation_id = l_rec.relation_id
3615: AND task_id = l_txn_temp_id
3616: AND business_event_id = wms_device_integration_pvt.WMS_BE_TASK_CONFIRM
3617: AND task_summary = 'N');
3618:
3619: END IF;
3620:

Line 3670: AND business_event_id IN (wms_device_integration_pvt.wms_be_task_confirm,wms_device_integration_pvt.WMS_BE_load_CONFIRM));

3666: wms_device_requests wdr
3667: WHERE relation_id = l_rec.relation_id
3668: AND task_id = l_txn_temp_id
3669: AND task_summary = 'N'
3670: AND business_event_id IN (wms_device_integration_pvt.wms_be_task_confirm,wms_device_integration_pvt.WMS_BE_load_CONFIRM));
3671:
3672:
3673: END IF;
3674:

Line 4057: AND l_rec.business_event_id <> wms_device_integration_pvt.wms_be_load_confirm;

4053: ,transaction_status = 3
4054: ,transaction_header_id = l_txn_hdr_id
4055: WHERE transaction_temp_id = l_txn_temp_id
4056: AND organization_id= l_rec.organization_id
4057: AND l_rec.business_event_id <> wms_device_integration_pvt.wms_be_load_confirm;
4058: -- update headerand txn_status of only those mmtt records that are destined TO be dropped
4059:
4060:
4061:

Line 4166: WHERE business_event_id in (wms_device_integration_pvt.wms_be_task_confirm,wms_device_integration_pvt.wms_be_load_confirm)

4162: --Update WDR for Success, which will be transferred to WDRH
4163: UPDATE wms_device_requests
4164: SET status_code = 'S',
4165: status_msg = null
4166: WHERE business_event_id in (wms_device_integration_pvt.wms_be_task_confirm,wms_device_integration_pvt.wms_be_load_confirm)
4167: AND task_id = l_rec.task_id
4168: AND relation_id = l_rec.relation_id;
4169:
4170: --It has come here it means that, this record was successful

Line 4401: AND BUSINESS_EVENT_ID IN (wms_device_integration_pvt.wms_be_task_confirm,wms_device_integration_pvt.wms_be_load_confirm);

4397: UPDATE wms_device_requests_hist
4398: SET status_code = 'E',resubmit_date = sysdate,
4399: status_msg= 'g_expected_error'
4400: WHERE request_id = l_new_request_id
4401: AND BUSINESS_EVENT_ID IN (wms_device_integration_pvt.wms_be_task_confirm,wms_device_integration_pvt.wms_be_load_confirm);
4402:
4403: COMMIT;
4404: ELSE --Bug#4535546. Added ELSE block.
4405: ROLLBACK TO WMS_DEVICE_REQUESTS_SP_OUTER;

Line 4438: AND BUSINESS_EVENT_ID IN (wms_device_integration_pvt.wms_be_task_confirm,wms_device_integration_pvt.wms_be_load_confirm);

4434: UPDATE wms_device_requests_hist
4435: SET status_code = 'E',resubmit_date = Sysdate,
4436: status_msg='g_unexpected_error'
4437: WHERE request_id = l_new_request_id
4438: AND BUSINESS_EVENT_ID IN (wms_device_integration_pvt.wms_be_task_confirm,wms_device_integration_pvt.wms_be_load_confirm);
4439:
4440: COMMIT;
4441: ELSE --Bug#4535546. Added ELSE block.
4442: ROLLBACK TO WMS_DEVICE_REQUESTS_SP_OUTER;