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 58: AND business_event_id IN (wms_device_integration_pvt.wms_be_task_confirm,wms_device_integration_pvt.wms_be_load_confirm)

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

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

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

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

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

Line 284: 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)

280: WHERE request_id = nvl(l_rec.relation_id,-1)
281: --nvl,to handle ERROR: when WCS does NOT pass relation_id or task_id
282: AND task_id = nvl(l_rec.task_id,-1)
283: AND task_summary = 'Y'
284: 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)
285: AND ROWNUM<2;
286: EXCEPTION
287: WHEN no_data_found THEN
288:

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

925: --IN the stack
926: UPDATE wms_device_requests
927: SET status_code = 'E',
928: status_msg = l_status_msg
929: WHERE business_event_id IN (wms_device_integration_pvt.wms_be_task_confirm,wms_device_integration_pvt.wms_be_load_confirm)
930: AND task_id = p_task_id
931: AND relation_id = p_relation_id;
932:
933: IF (l_debug = 1) THEN

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

3121: , reason_id
3122: , organization_id--Its NOT NULL Column
3123: FROM wms_device_requests
3124: WHERE business_event_id IN
3125: (wms_device_integration_pvt.wms_be_task_confirm, wms_device_integration_pvt.wms_be_load_confirm)
3126: AND device_status = 'S'
3127: AND task_summary = 'Y'
3128: ORDER BY xfer_lpn_id;
3129:

Line 3137: (wms_device_integration_pvt.wms_be_task_confirm,

3133: WHERE relation_id = p_relation_id
3134: AND task_id = p_temp_id
3135: AND task_summary = 'N'
3136: AND business_event_id IN
3137: (wms_device_integration_pvt.wms_be_task_confirm,
3138: wms_device_integration_pvt.wms_be_load_confirm);
3139:
3140:
3141: --Following c_update_xfer_lpn_context cursor is used to update LPN context to RESIDE_IN_INV after call to TM

Line 3138: wms_device_integration_pvt.wms_be_load_confirm);

3134: AND task_id = p_temp_id
3135: AND task_summary = 'N'
3136: AND business_event_id IN
3137: (wms_device_integration_pvt.wms_be_task_confirm,
3138: wms_device_integration_pvt.wms_be_load_confirm);
3139:
3140:
3141: --Following c_update_xfer_lpn_context cursor is used to update LPN context to RESIDE_IN_INV after call to TM
3142: --1-For REPLENISHMENT TASKS

Line 3156: WHERE wdr.business_event_id = wms_device_integration_pvt.WMS_BE_TASK_CONFIRM

3152: (SELECT wdr.xfer_lpn_id
3153: FROM wms_device_requests wdr,
3154: wms_device_requests_hist wdrh,
3155: wms_dispatched_tasks wdt
3156: WHERE wdr.business_event_id = wms_device_integration_pvt.WMS_BE_TASK_CONFIRM
3157: AND wdr.task_id = wdt.transaction_temp_id
3158: AND wdt.task_type IN (4,5,7) -- ONLY for Replenishment, MO Xfer,Staging TASKS
3159: AND wdr.status_code = 'S'
3160: AND wdr.device_status = 'S'

Line 3166: 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)

3162: AND wdr.task_summary = wdrh.task_summary
3163: and wdrh.request_id = wdr.relation_id
3164: AND wdr.task_id = wdrh.task_id
3165: AND wdr.transaction_quantity > 0
3166: 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)
3167: AND wdrh.TASK_TYPE_ID = 1);
3168:
3169:
3170: --used to xfer records into WDTH

Line 3180: WHERE business_event_id = wms_device_integration_pvt.WMS_BE_TASK_CONFIRM

3176:
3177: --used to update the account period in mmtt
3178: CURSOR c_open_period_check IS SELECT distinct organization_id, task_id
3179: FROM wms_device_requests
3180: WHERE business_event_id = wms_device_integration_pvt.WMS_BE_TASK_CONFIRM
3181: AND status_code = 'S'
3182: AND device_status = 'S'
3183: AND task_summary = 'Y';
3184:

Line 3262: 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)

3258: SELECT task_id,lpn_id INTO l_txn_temp_id,l_orig_lpn_id
3259: FROM wms_device_requests_hist
3260: WHERE request_id = l_rec.relation_id
3261: AND task_id = l_rec.task_id
3262: 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)
3263: AND ROWNUM <2;
3264: EXCEPTION
3265: WHEN no_data_found THEN
3266:

Line 4222: AND business_event_id = wms_device_integration_pvt.WMS_BE_TASK_CONFIRM

4218: AND msnt.fm_serial_number NOT IN
4219: (SELECT serial_number FROM wms_device_requests
4220: WHERE relation_id = l_rec.relation_id
4221: AND task_id = l_txn_temp_id
4222: AND business_event_id = wms_device_integration_pvt.WMS_BE_TASK_CONFIRM
4223: AND task_summary = 'N');
4224:
4225: END IF;
4226:

Line 4269: AND wdr.business_event_id in ( wms_device_integration_pvt.WMS_BE_TASK_CONFIRM,wms_device_integration_pvt.WMS_BE_LOAD_CONFIRM)

4265: AND NOT EXISTS (
4266: SELECT 1 FROM wms_device_requests wdr
4267: WHERE wdr.relation_id = l_rec.relation_id
4268: AND wdr.task_id = l_txn_temp_id
4269: AND wdr.business_event_id in ( wms_device_integration_pvt.WMS_BE_TASK_CONFIRM,wms_device_integration_pvt.WMS_BE_LOAD_CONFIRM)
4270: AND wdr.task_summary = 'N'
4271: AND wdr.task_id = mtlt.transaction_temp_id
4272: AND wdr.lot_number = mtlt.lot_number
4273: );

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

4284: wms_device_requests wdr
4285: WHERE relation_id = l_rec.relation_id
4286: AND task_id = l_txn_temp_id
4287: AND task_summary = 'N'
4288: AND business_event_id IN (wms_device_integration_pvt.wms_be_task_confirm,wms_device_integration_pvt.WMS_BE_load_CONFIRM));
4289:
4290:
4291: END IF;
4292:

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

4778: ,transaction_status = 3
4779: ,transaction_header_id = l_txn_hdr_id
4780: WHERE transaction_temp_id = l_txn_temp_id
4781: AND organization_id= l_rec.organization_id
4782: AND l_rec.business_event_id <> wms_device_integration_pvt.wms_be_load_confirm;
4783: -- update headerand txn_status of only those mmtt records that are destined TO be dropped
4784:
4785:
4786:

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

4890: --Update WDR for Success, which will be transferred to WDRH
4891: UPDATE wms_device_requests
4892: SET status_code = 'S',
4893: status_msg = null
4894: WHERE business_event_id in (wms_device_integration_pvt.wms_be_task_confirm,wms_device_integration_pvt.wms_be_load_confirm)
4895: AND task_id = l_rec.task_id
4896: AND relation_id = l_rec.relation_id;
4897:
4898: --It has come here it means that, this record was successful

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

5126: UPDATE wms_device_requests_hist
5127: SET status_code = 'E',resubmit_date = sysdate,
5128: status_msg= 'g_expected_error'
5129: WHERE request_id = l_new_request_id
5130: AND BUSINESS_EVENT_ID IN (wms_device_integration_pvt.wms_be_task_confirm,wms_device_integration_pvt.wms_be_load_confirm);
5131:
5132: COMMIT;
5133: ELSE --Bug#4535546. Added ELSE block.
5134: ROLLBACK TO WMS_DEVICE_REQUESTS_SP_OUTER;

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

5163: UPDATE wms_device_requests_hist
5164: SET status_code = 'E',resubmit_date = Sysdate,
5165: status_msg='g_unexpected_error'
5166: WHERE request_id = l_new_request_id
5167: AND BUSINESS_EVENT_ID IN (wms_device_integration_pvt.wms_be_task_confirm,wms_device_integration_pvt.wms_be_load_confirm);
5168:
5169: COMMIT;
5170: ELSE --Bug#4535546. Added ELSE block.
5171: ROLLBACK TO WMS_DEVICE_REQUESTS_SP_OUTER;