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_REQUESTS

Line 54: FROM wms_device_requests

50: l_total_lot_qty NUMBER :=0;--for all record in MTLT corresponding to MMTT
51:
52: CURSOR child_rec_cursor IS
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';

Line 68: FROM wms_device_requests

64: trace('Inside validate_child_record');
65: END IF;
66:
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';

Line 243: FROM wms_device_requests

239: , lot_number
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);

Line 250: SELECT wms_device_requests_s.nextval INTO l_request_id FROM dual;

246:
247: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
248: BEGIN
249:
250: SELECT wms_device_requests_s.nextval INTO l_request_id FROM dual;
251: IF (l_debug = 1) THEN
252: trace('Inside populate_History: New request_id for all records:'||l_request_id);
253: END IF;
254:

Line 278: FROM wms_device_requests_hist

274: INTO
275: l_device_id
276: ,l_resp_application_id
277: ,l_resp_id
278: FROM wms_device_requests_hist
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'

Line 304: INSERT INTO wms_device_requests_hist(request_id

300: l_rec.status_msg := 'Error:Null parent_task_id or task_id';
301: END IF;
302:
303:
304: INSERT INTO wms_device_requests_hist(request_id
305: , relation_id -- parent_request_id
306: , task_id
307: , business_event_id
308: , transaction_quantity

Line 407: UPDATE wms_device_requests

403: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
404: BEGIN
405: l_status_msg := get_msg_stack;--only last message
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

Line 2489: -- retrieve all the records from wms_device_requests and process

2485: END get_lpn_match;
2486:
2487:
2488: -----------------------------------------------------
2489: -- retrieve all the records from wms_device_requests and process
2490: --
2491: ------------------------------------------------------
2492: PROCEDURE device_confirmation(
2493: x_return_status OUT NOCOPY VARCHAR2

Line 2597: FROM wms_device_requests

2593: , xfer_lpn_id
2594: , device_status
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'

Line 2606: SELECT lot_number,lot_qty FROM wms_device_requests

2602: ORDER BY xfer_lpn_id;
2603:
2604: --this cursor will be used to upate mtlt for unpicked lots
2605: CURSOR c_mtlt_update (p_relation_id NUMBER, p_temp_id NUMBER) IS
2606: SELECT lot_number,lot_qty FROM wms_device_requests
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

Line 2627: FROM wms_device_requests wdr,

2623: WHERE wlpn.lpn_context <> wms_container_pub.lpn_context_pregenerated
2624: --to avoid LPNS that have been unpacked by TM for non-LPN ctrld sub
2625: AND wlpn.lpn_id IN
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

Line 2628: wms_device_requests_hist wdrh,

2624: --to avoid LPNS that have been unpacked by TM for non-LPN ctrld sub
2625: AND wlpn.lpn_id IN
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

Line 2653: FROM wms_device_requests

2649:
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';

Line 2665: SAVEPOINT WMS_DEVICE_REQUESTS_SP_OUTER;

2661: BEGIN
2662: x_successful_row_cnt := 0;
2663: x_return_status:=FND_API.G_RET_STS_SUCCESS;
2664:
2665: SAVEPOINT WMS_DEVICE_REQUESTS_SP_OUTER;
2666:
2667: --this header_id will be used to call TM for the batch
2668: SELECT mtl_material_transactions_s.NEXTVAL INTO l_txn_hdr_id FROM DUAL;
2669:

Line 2676: SAVEPOINT WMS_DEVICE_REQUESTS_SP;

2672: END IF;
2673:
2674: FOR l_rec IN wdr_cursor LOOP
2675: --FOR each record this savepoint wil be overwritten
2676: SAVEPOINT WMS_DEVICE_REQUESTS_SP;
2677: FND_MSG_PUB.initialize;
2678: --Check if device status
2679:
2680: IF l_rec.device_status <> FND_API.g_ret_sts_success THEN

Line 2688: ROLLBACK TO WMS_DEVICE_REQUESTS_SP;

2684: FND_MESSAGE.SET_NAME('WMS', 'WMS_ERR_DEVICE_STATUS');
2685: FND_MSG_PUB.ADD;
2686:
2687: --update wdr for error_code and error_mesg
2688: ROLLBACK TO WMS_DEVICE_REQUESTS_SP;
2689: l_any_row_failed := TRUE;
2690: update_wdr_for_error_rec(l_rec.task_id,l_rec.relation_id);
2691: GOTO continue_loop;
2692:

Line 2702: ROLLBACK TO WMS_DEVICE_REQUESTS_SP;

2698: FND_MESSAGE.SET_NAME('WMS', 'WMS_MISSING_TASK_INFO');
2699: FND_MSG_PUB.ADD;
2700:
2701: --update wdr for error_code and error_mesg
2702: ROLLBACK TO WMS_DEVICE_REQUESTS_SP;
2703: l_any_row_failed := TRUE;
2704: update_wdr_for_error_rec(l_rec.task_id,l_rec.relation_id);
2705: GOTO continue_loop;
2706:

Line 2715: FROM wms_device_requests_hist

2711: --Check if corresponding RECORD exist in the WDRH history table
2712:
2713: BEGIN
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;

Line 2727: ROLLBACK TO WMS_DEVICE_REQUESTS_SP;

2723: FND_MESSAGE.SET_NAME('WMS', 'WMS_MISSING_TASK_INFO');
2724: FND_MSG_PUB.ADD;
2725:
2726: --update wdr for error_code and error_mesg
2727: ROLLBACK TO WMS_DEVICE_REQUESTS_SP;
2728: l_any_row_failed := TRUE;
2729: update_wdr_for_error_rec(l_rec.task_id,l_rec.relation_id);
2730: GOTO continue_loop;
2731: END;

Line 2792: ROLLBACK TO WMS_DEVICE_REQUESTS_SP;

2788: FND_MESSAGE.SET_NAME('WMS', 'WMS_INVALID_QTY');
2789: FND_MSG_PUB.ADD;
2790:
2791: --update wdr for error_code and mesg
2792: ROLLBACK TO WMS_DEVICE_REQUESTS_SP;
2793: l_any_row_failed := TRUE;
2794: update_wdr_for_error_rec(l_rec.task_id,l_rec.relation_id);
2795: GOTO continue_loop;
2796: END IF;

Line 2824: ROLLBACK TO WMS_DEVICE_REQUESTS_SP;

2820: FND_MESSAGE.SET_NAME('WMS', 'WMS_CONT_INVALID_SUB');
2821: FND_MSG_PUB.ADD;
2822:
2823: --update wdr for error_code and mesg
2824: ROLLBACK TO WMS_DEVICE_REQUESTS_SP;
2825: l_any_row_failed := TRUE;
2826: update_wdr_for_error_rec(l_rec.task_id,l_rec.relation_id);
2827: GOTO continue_loop;
2828: END;

Line 2836: ROLLBACK TO WMS_DEVICE_REQUESTS_SP;

2832: END IF;
2833: FND_MESSAGE.SET_NAME('WMS', 'WMS_SUB_NOLPN_CTRLD');
2834: FND_MSG_PUB.ADD;
2835: --update wdr for error_code and mesg
2836: ROLLBACK TO WMS_DEVICE_REQUESTS_SP;
2837: l_any_row_failed := TRUE;
2838: update_wdr_for_error_rec(l_rec.task_id,l_rec.relation_id);
2839: GOTO continue_loop;
2840: END IF;

Line 2867: ROLLBACK TO WMS_DEVICE_REQUESTS_SP;

2863: FND_MESSAGE.SET_NAME('WMS', 'WMS_CONT_INVALID_LOC');--done
2864: FND_MSG_PUB.ADD;
2865:
2866: --update wdr for error_code and mesg
2867: ROLLBACK TO WMS_DEVICE_REQUESTS_SP;
2868: l_any_row_failed := TRUE;
2869: update_wdr_for_error_rec(l_rec.task_id,l_rec.relation_id);
2870: GOTO continue_loop;
2871: END IF;

Line 2900: ROLLBACK TO WMS_DEVICE_REQUESTS_SP;

2896: FND_MESSAGE.SET_NAME('WMS', 'WMS_MISMATCH_LPN');
2897: FND_MSG_PUB.ADD;
2898:
2899: --update wdr for error_code and error_mesg
2900: ROLLBACK TO WMS_DEVICE_REQUESTS_SP;
2901: l_any_row_failed := TRUE;
2902: update_wdr_for_error_rec(l_rec.task_id,l_rec.relation_id);
2903: GOTO continue_loop;
2904:

Line 2933: ROLLBACK TO WMS_DEVICE_REQUESTS_SP;

2929: FND_MESSAGE.SET_NAME('WMS', 'WMS_CONT_INVALID_LPN');
2930: FND_MSG_PUB.ADD;
2931:
2932: --update wdr for error_code and error_mesg
2933: ROLLBACK TO WMS_DEVICE_REQUESTS_SP;
2934: update_wdr_for_error_rec(l_rec.task_id,l_rec.relation_id);
2935: GOTO continue_loop;
2936: END;
2937:

Line 2946: ROLLBACK TO WMS_DEVICE_REQUESTS_SP;

2942: FND_MESSAGE.SET_NAME('WMS', 'WMS_CONT_INVALID_LPN');
2943: FND_MSG_PUB.ADD;
2944:
2945: --update wdr for error_code and error_mesg
2946: ROLLBACK TO WMS_DEVICE_REQUESTS_SP;
2947: update_wdr_for_error_rec(l_rec.task_id,l_rec.relation_id);
2948: GOTO continue_loop;
2949:
2950: END IF;

Line 2999: ROLLBACK TO WMS_DEVICE_REQUESTS_SP;

2995: FND_MESSAGE.SET_NAME('WMS', 'WMS_SUBST_LPN_ERR');
2996: FND_MSG_PUB.ADD;
2997:
2998: --update wdr for error_code and error_mesg
2999: ROLLBACK TO WMS_DEVICE_REQUESTS_SP;
3000: l_any_row_failed := TRUE;
3001: update_wdr_for_error_rec(l_rec.task_id,l_rec.relation_id);
3002: GOTO continue_loop;
3003:

Line 3038: ROLLBACK TO WMS_DEVICE_REQUESTS_SP;

3034: FND_MESSAGE.SET_NAME('WMS', 'WMS_CONT_INVALID_LPN');
3035: FND_MSG_PUB.ADD;
3036:
3037: --update wdr for error_code and error_mesg
3038: ROLLBACK TO WMS_DEVICE_REQUESTS_SP;
3039: l_any_row_failed := TRUE;
3040: update_wdr_for_error_rec(l_rec.task_id,l_rec.relation_id);
3041: GOTO continue_loop;
3042: END;

Line 3053: ROLLBACK TO WMS_DEVICE_REQUESTS_SP;

3049: FND_MESSAGE.SET_NAME('WMS', 'WMS_CONT_INVALID_LPN');
3050: FND_MSG_PUB.ADD;
3051:
3052: --update wdr for error_code and error_mesg
3053: ROLLBACK TO WMS_DEVICE_REQUESTS_SP;
3054: l_any_row_failed := TRUE;
3055: update_wdr_for_error_rec(l_rec.task_id,l_rec.relation_id);
3056: GOTO continue_loop;
3057:

Line 3092: ROLLBACK TO WMS_DEVICE_REQUESTS_SP;

3088: IF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3089: FND_MESSAGE.SET_NAME('WMS', 'WMS_CONT_INVALID_LPN');
3090: FND_MSG_PUB.ADD;
3091: --update wdr for error_code and error_mesg
3092: ROLLBACK TO WMS_DEVICE_REQUESTS_SP;
3093: l_any_row_failed := TRUE;
3094: update_wdr_for_error_rec(l_rec.task_id,l_rec.relation_id);
3095: GOTO continue_loop;
3096:

Line 3101: ROLLBACK TO WMS_DEVICE_REQUESTS_SP;

3097: ELSIF x_return_status = FND_API.G_RET_STS_ERROR THEN
3098: FND_MESSAGE.SET_NAME('WMS', 'WMS_CONT_INVALID_LPN');
3099: FND_MSG_PUB.ADD;
3100: --update wdr for error_code and error_mesg
3101: ROLLBACK TO WMS_DEVICE_REQUESTS_SP;
3102: l_any_row_failed := TRUE;
3103: update_wdr_for_error_rec(l_rec.task_id,l_rec.relation_id);
3104: GOTO continue_loop;
3105: END IF;

Line 3117: ROLLBACK TO WMS_DEVICE_REQUESTS_SP;

3113: FND_MESSAGE.SET_NAME('WMS', 'WMS_MISSING_XFER_LPN');
3114: FND_MSG_PUB.ADD;
3115:
3116: --update wdr for error_code and error_mesg
3117: ROLLBACK TO WMS_DEVICE_REQUESTS_SP;
3118: l_any_row_failed := TRUE;
3119: update_wdr_for_error_rec(l_rec.task_id,l_rec.relation_id);
3120: GOTO continue_loop;
3121: END IF;

Line 3145: ROLLBACK TO WMS_DEVICE_REQUESTS_SP;

3141: FND_MESSAGE.SET_NAME('WMS', 'WMS_SER_SHORT_PICK_ERR');
3142: FND_MSG_PUB.ADD;
3143:
3144: --update wdr for error_code and error_mesg
3145: ROLLBACK TO WMS_DEVICE_REQUESTS_SP;
3146: l_any_row_failed := TRUE;
3147: update_wdr_for_error_rec(l_rec.task_id,l_rec.relation_id);
3148: GOTO continue_loop;
3149:

Line 3263: ROLLBACK TO WMS_DEVICE_REQUESTS_SP;

3259: FND_MESSAGE.SET_NAME('WMS', 'WMS_LOT_SER_VALIDATION_FAIL');
3260: FND_MSG_PUB.ADD;
3261:
3262: --update wdr for error_code and error_mesg
3263: ROLLBACK TO WMS_DEVICE_REQUESTS_SP;
3264: l_any_row_failed := TRUE;
3265: update_wdr_for_error_rec(l_rec.task_id,l_rec.relation_id);
3266: GOTO continue_loop;
3267:

Line 3311: ROLLBACK TO WMS_DEVICE_REQUESTS_SP;

3307: FND_MESSAGE.SET_NAME('WMS', 'WMS_INVLID_LPN_MOVE');
3308: FND_MSG_PUB.ADD;
3309:
3310: --update wdr for error_code and error_mesg
3311: ROLLBACK TO WMS_DEVICE_REQUESTS_SP;
3312: l_any_row_failed := TRUE;
3313: update_wdr_for_error_rec(l_rec.task_id,l_rec.relation_id);
3314: GOTO continue_loop;
3315: else

Line 3325: ROLLBACK TO WMS_DEVICE_REQUESTS_SP;

3321: FND_MESSAGE.SET_NAME('WMS', 'WMS_INVALID_QTY');
3322: FND_MSG_PUB.ADD;
3323:
3324: --update wdr for error_code and error_mesg
3325: ROLLBACK TO WMS_DEVICE_REQUESTS_SP;
3326: l_any_row_failed := TRUE;
3327: update_wdr_for_error_rec(l_rec.task_id,l_rec.relation_id);
3328: GOTO continue_loop;
3329:

Line 3349: ROLLBACK TO WMS_DEVICE_REQUESTS_SP;

3345: FND_MESSAGE.SET_NAME('WMS', 'WMS_INVALID_LPN_MOVE');
3346: FND_MSG_PUB.ADD;
3347:
3348: --update wdr for error_code and error_mesg
3349: ROLLBACK TO WMS_DEVICE_REQUESTS_SP;
3350: l_any_row_failed := TRUE;
3351: update_wdr_for_error_rec(l_rec.task_id,l_rec.relation_id);
3352: GOTO continue_loop;
3353: else

Line 3410: ROLLBACK TO WMS_DEVICE_REQUESTS_SP;

3406: FND_MESSAGE.SET_NAME('WMS', 'WMS_LOT_SER_VALIDATION_FAIL');
3407: FND_MSG_PUB.ADD;
3408:
3409: --update wdr for error_code and error_mesg
3410: ROLLBACK TO WMS_DEVICE_REQUESTS_SP;
3411: l_any_row_failed := TRUE;
3412: update_wdr_for_error_rec(l_rec.task_id,l_rec.relation_id);
3413: GOTO continue_loop;
3414: END IF;

Line 3495: ROLLBACK TO WMS_DEVICE_REQUESTS_SP;

3491: FND_MESSAGE.SET_NAME('WMS','WMS_BACKORDER_FAILED');
3492: FND_MSG_PUB.ADD;
3493:
3494: --update wdr for error_code and error_mesg
3495: ROLLBACK TO WMS_DEVICE_REQUESTS_SP;
3496: l_any_row_failed := TRUE;
3497: update_wdr_for_error_rec(l_rec.task_id,l_rec.relation_id);
3498: GOTO continue_loop;
3499: END IF;

Line 3516: ROLLBACK TO WMS_DEVICE_REQUESTS_SP;

3512: FND_MESSAGE.SET_NAME('WMS','WMS_BACKORDER_FAILED');
3513: FND_MSG_PUB.ADD;
3514:
3515: --update wdr for error_code and error_mesg
3516: ROLLBACK TO WMS_DEVICE_REQUESTS_SP;
3517: l_any_row_failed := TRUE;
3518: update_wdr_for_error_rec(l_rec.task_id,l_rec.relation_id);
3519: GOTO continue_loop;
3520: END IF;

Line 3613: (SELECT serial_number FROM wms_device_requests

3609: mtl_serial_numbers_temp msnt
3610: WHERE mtlt.serial_transaction_temp_id = msnt.transaction_temp_id
3611: AND mtlt.transaction_temp_id =l_txn_temp_id)
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');

Line 3666: wms_device_requests wdr

3662: DELETE FROM mtl_serial_numbers_temp msnt
3663: WHERE msnt.transaction_temp_id = l_txn_temp_id
3664: AND msnt.fm_serial_number NOT IN
3665: ( SELECT wdr.serial_number FROM
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));

Line 3701: ROLLBACK TO WMS_DEVICE_REQUESTS_SP;

3697: END IF;
3698: FND_MESSAGE.SET_NAME('WMS', 'WMS_INVALID_LPN_MOVE');
3699: FND_MSG_PUB.ADD;
3700: --update wdr for error_code and error_mesg
3701: ROLLBACK TO WMS_DEVICE_REQUESTS_SP;
3702: l_any_row_failed := TRUE;
3703: update_wdr_for_error_rec(l_rec.task_id,l_rec.relation_id);
3704: GOTO continue_loop;
3705:

Line 3731: ROLLBACK TO WMS_DEVICE_REQUESTS_SP;

3727: END IF;
3728: FND_MESSAGE.SET_NAME('WMS', 'WMS_INVALID_LPN_MOVE');
3729: FND_MSG_PUB.ADD;
3730: --update wdr for error_code and error_mesg
3731: ROLLBACK TO WMS_DEVICE_REQUESTS_SP;
3732: l_any_row_failed := TRUE;
3733: update_wdr_for_error_rec(l_rec.task_id,l_rec.relation_id);
3734: GOTO continue_loop;
3735: else if l_rec.transaction_quantity > l_lpn_qty_pickable then

Line 3743: ROLLBACK TO WMS_DEVICE_REQUESTS_SP;

3739: END IF;
3740: FND_MESSAGE.SET_NAME('WMS', 'WMS_INVALID_QTY');
3741: FND_MSG_PUB.ADD;
3742: --update wdr for error_code and error_mesg
3743: ROLLBACK TO WMS_DEVICE_REQUESTS_SP;
3744: l_any_row_failed := TRUE;
3745: update_wdr_for_error_rec(l_rec.task_id,l_rec.relation_id);
3746: GOTO continue_loop;
3747:

Line 3775: ROLLBACK TO WMS_DEVICE_REQUESTS_SP;

3771: END IF;
3772: FND_MESSAGE.SET_NAME('WMS', 'WMS_INVALID_LPN_MOVE');
3773: FND_MSG_PUB.ADD;
3774: --update wdr for error_code and error_mesg
3775: ROLLBACK TO WMS_DEVICE_REQUESTS_SP;
3776: l_any_row_failed := TRUE;
3777: update_wdr_for_error_rec(l_rec.task_id,l_rec.relation_id);
3778: GOTO continue_loop;
3779: ELSE

Line 3794: ROLLBACK TO WMS_DEVICE_REQUESTS_SP;

3790: END IF;
3791: FND_MESSAGE.SET_NAME('WMS', 'WMS_INVALID_QTY');
3792: FND_MSG_PUB.ADD;
3793: --update wdr for error_code and error_mesg
3794: ROLLBACK TO WMS_DEVICE_REQUESTS_SP;
3795: l_any_row_failed := TRUE;
3796: update_wdr_for_error_rec(l_rec.task_id,l_rec.relation_id);
3797: GOTO continue_loop;
3798:

Line 3810: ROLLBACK TO WMS_DEVICE_REQUESTS_SP;

3806: END IF;
3807: FND_MESSAGE.SET_NAME('WMS', 'WMS_INVALID_LPN_MOVE');
3808: FND_MSG_PUB.ADD;
3809: --update wdr for error_code and error_mesg
3810: ROLLBACK TO WMS_DEVICE_REQUESTS_SP;
3811: l_any_row_failed := TRUE;
3812: update_wdr_for_error_rec(l_rec.task_id,l_rec.relation_id);
3813: GOTO continue_loop;
3814: else

Line 3946: ROLLBACK TO WMS_DEVICE_REQUESTS_SP;

3942: IF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3943: FND_MESSAGE.SET_NAME('WMS','WMS_LOG_EXCEPTION_FAIL');
3944: FND_MSG_PUB.ADD;
3945: --update wdr for error_code and error_mesg
3946: ROLLBACK TO WMS_DEVICE_REQUESTS_SP;
3947: l_any_row_failed := TRUE;
3948: update_wdr_for_error_rec(l_rec.task_id,l_rec.relation_id);
3949: GOTO continue_loop;
3950:

Line 3955: ROLLBACK TO WMS_DEVICE_REQUESTS_SP;

3951: ELSIF x_return_status = FND_API.G_RET_STS_ERROR THEN
3952: FND_MESSAGE.SET_NAME('WMS','WMS_LOG_EXCEPTION_FAIL');
3953: FND_MSG_PUB.ADD;
3954: --update wdr for error_code and error_mesg
3955: ROLLBACK TO WMS_DEVICE_REQUESTS_SP;
3956: l_any_row_failed := TRUE;
3957: update_wdr_for_error_rec(l_rec.task_id,l_rec.relation_id);
3958: GOTO continue_loop;
3959:

Line 4021: ROLLBACK TO WMS_DEVICE_REQUESTS_SP;

4017: END IF;
4018: FND_MESSAGE.SET_NAME('WMS','WMS_WORK_FLOW_FAIL');
4019: FND_MSG_PUB.ADD;
4020: --update wdr for error_code and error_mesg
4021: ROLLBACK TO WMS_DEVICE_REQUESTS_SP;
4022: l_any_row_failed := TRUE;
4023: update_wdr_for_error_rec(l_rec.task_id,l_rec.relation_id);
4024: GOTO continue_loop;
4025:

Line 4033: ROLLBACK TO WMS_DEVICE_REQUESTS_SP;

4029: END IF;
4030: FND_MESSAGE.SET_NAME('WMS','WMS_WORK_FLOW_FAIL');
4031: FND_MSG_PUB.ADD;
4032: --update wdr for error_code and error_mesg
4033: ROLLBACK TO WMS_DEVICE_REQUESTS_SP;
4034: l_any_row_failed := TRUE;
4035: update_wdr_for_error_rec(l_rec.task_id,l_rec.relation_id);
4036: GOTO continue_loop;
4037:

Line 4100: ROLLBACK TO WMS_DEVICE_REQUESTS_SP;

4096: END IF;
4097: FND_MESSAGE.SET_NAME('WMS','WMS_TD_MODIFY_LPN_ERROR');
4098: FND_MSG_PUB.ADD;
4099: --update wdr for error_code and error_mesg
4100: ROLLBACK TO WMS_DEVICE_REQUESTS_SP;
4101: update_wdr_for_error_rec(l_rec.task_id,l_rec.relation_id);
4102: GOTO continue_loop;
4103:
4104:

Line 4133: ROLLBACK TO WMS_DEVICE_REQUESTS_SP;

4129: END IF;
4130: FND_MESSAGE.SET_NAME('WMS','WMS_TD_MODIFY_LPN_ERROR');
4131: FND_MSG_PUB.ADD;
4132: --update wdr for error_code and error_mesg
4133: ROLLBACK TO WMS_DEVICE_REQUESTS_SP;
4134: update_wdr_for_error_rec(l_rec.task_id,l_rec.relation_id);
4135: GOTO continue_loop;
4136: END IF;
4137: END IF;

Line 4153: ROLLBACK TO WMS_DEVICE_REQUESTS_SP;

4149: END IF;
4150: FND_MESSAGE.SET_NAME('WMS', 'WMS_MISSING_TASK_INFO');
4151: FND_MSG_PUB.ADD;
4152: --update wdr for error_code and error_mesg
4153: ROLLBACK TO WMS_DEVICE_REQUESTS_SP;
4154: l_any_row_failed := TRUE;
4155: update_wdr_for_error_rec(l_rec.task_id,l_rec.relation_id);
4156: GOTO continue_loop;
4157: END IF;

Line 4163: UPDATE wms_device_requests

4159:
4160: END IF;--device success
4161:
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

Line 4215: ROLLBACK TO WMS_DEVICE_REQUESTS_SP_OUTER;

4211: END IF;
4212: FND_MESSAGE.SET_NAME('INV', 'INV_NO_OPEN_PERIOD');
4213: FND_MSG_PUB.ADD;
4214: x_return_status := FND_API.g_ret_sts_error;
4215: ROLLBACK TO WMS_DEVICE_REQUESTS_SP_OUTER;
4216:
4217: END IF;
4218:
4219: END LOOP;

Line 4300: ROLLBACK TO WMS_DEVICE_REQUESTS_SP_OUTER;

4296: FND_MSG_PUB.ADD;
4297:
4298: x_return_status := FND_API.g_ret_sts_error;
4299:
4300: ROLLBACK TO WMS_DEVICE_REQUESTS_SP_OUTER;
4301:
4302: ELSE
4303: --TM CALL SUCCESSFUL
4304:

Line 4356: ROLLBACK TO wms_device_requests_sp_outer;

4352: END IF;
4353: FND_MESSAGE.SET_NAME('WMS','WMS_TD_MODIFY_LPN_ERROR' );
4354: FND_MSG_PUB.ADD;
4355: --rollback the batch
4356: ROLLBACK TO wms_device_requests_sp_outer;
4357:
4358: END IF;
4359:
4360: END LOOP;

Line 4372: delete from wms_device_requests;--since temp table is session specific

4368:
4369: IF (l_debug = 1) THEN
4370: trace(' device_confirmation:Delete requested rows from WDR');
4371: END IF;
4372: delete from wms_device_requests;--since temp table is session specific
4373:
4374: --Commit will be done by calling api
4375: IF (l_debug = 1) THEN
4376: trace('device_confirmation:done with this API');

Line 4397: UPDATE wms_device_requests_hist

4393: IF (l_debug = 1) THEN
4394: trace('Updating resubmitted records for EXP exception thrown' );
4395: END IF;
4396: --this is set to P in the form while making call to concurrent req
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);

Line 4405: ROLLBACK TO WMS_DEVICE_REQUESTS_SP_OUTER;

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;
4406: END IF;
4407:
4408: IF (l_debug = 1) THEN
4409: trace('DEVICE_CONFIRMATION:Error: G_EXC_ERR');

Line 4411: -- ROLLBACK TO WMS_DEVICE_REQUESTS_SP_OUTER;Commented for Bug#4535546

4407:
4408: IF (l_debug = 1) THEN
4409: trace('DEVICE_CONFIRMATION:Error: G_EXC_ERR');
4410: END IF;
4411: -- ROLLBACK TO WMS_DEVICE_REQUESTS_SP_OUTER;Commented for Bug#4535546
4412: x_return_status := FND_API.G_RET_STS_ERROR;
4413:
4414: x_msg_data:=GET_MSG_STACK ; --Bug#4535546.
4415:

Line 4434: UPDATE wms_device_requests_hist

4430: IF (l_debug = 1) THEN
4431: trace('Updating resubmitted records for UNEXP exception thrown' );
4432: END IF;
4433: --this is set to P in the form while making call to concurrent req
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);

Line 4442: ROLLBACK TO WMS_DEVICE_REQUESTS_SP_OUTER;

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;
4443: END IF;
4444:
4445: IF (l_debug = 1) THEN
4446: trace('DEVICE_CONFIRMATION:Error: G_UNEXC_ERR');

Line 4448: -- ROLLBACK TO WMS_DEVICE_REQUESTS_SP_OUTER; Commented for Bug#4535546

4444:
4445: IF (l_debug = 1) THEN
4446: trace('DEVICE_CONFIRMATION:Error: G_UNEXC_ERR');
4447: END IF;
4448: -- ROLLBACK TO WMS_DEVICE_REQUESTS_SP_OUTER; Commented for Bug#4535546
4449: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4450:
4451: x_msg_data:=GET_MSG_STACK ; --Bug#4535546.
4452: