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 55: FROM wms_device_requests

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

Line 69: FROM wms_device_requests

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

Line 244: FROM wms_device_requests

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

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

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

Line 279: FROM wms_device_requests_hist

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

Line 305: INSERT INTO wms_device_requests_hist(request_id

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

Line 926: UPDATE wms_device_requests

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

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

3005: END get_lpn_match;
3006:
3007:
3008: -----------------------------------------------------
3009: -- retrieve all the records from wms_device_requests and process
3010: --
3011: ------------------------------------------------------
3012: PROCEDURE device_confirmation(
3013: x_return_status OUT NOCOPY VARCHAR2

Line 3123: FROM wms_device_requests

3119: , xfer_lpn_id
3120: , device_status
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'

Line 3132: SELECT lot_number,lot_qty FROM wms_device_requests

3128: ORDER BY xfer_lpn_id;
3129:
3130: --this cursor will be used to upate mtlt for unpicked lots
3131: CURSOR c_mtlt_update (p_relation_id NUMBER, p_temp_id NUMBER) IS
3132: SELECT lot_number,lot_qty FROM wms_device_requests
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

Line 3153: FROM wms_device_requests wdr,

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

Line 3154: wms_device_requests_hist wdrh,

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

Line 3179: FROM wms_device_requests

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

Line 3196: SAVEPOINT WMS_DEVICE_REQUESTS_SP_OUTER;

3192: BEGIN
3193: x_successful_row_cnt := 0;
3194: x_return_status:=FND_API.G_RET_STS_SUCCESS;
3195:
3196: SAVEPOINT WMS_DEVICE_REQUESTS_SP_OUTER;
3197:
3198: --this header_id will be used to call TM for the batch
3199: SELECT mtl_material_transactions_s.NEXTVAL INTO l_txn_hdr_id FROM DUAL;
3200:

Line 3207: SAVEPOINT WMS_DEVICE_REQUESTS_SP;

3203: END IF;
3204:
3205: FOR l_rec IN wdr_cursor LOOP
3206: --FOR each record this savepoint wil be overwritten
3207: SAVEPOINT WMS_DEVICE_REQUESTS_SP;
3208: FND_MSG_PUB.initialize;
3209: --Check if device status
3210:
3211: --Bug#5868236 Initialize the local variables -- 14028129

Line 3232: ROLLBACK TO WMS_DEVICE_REQUESTS_SP;

3228: FND_MESSAGE.SET_NAME('WMS', 'WMS_ERR_DEVICE_STATUS');
3229: FND_MSG_PUB.ADD;
3230:
3231: --update wdr for error_code and error_mesg
3232: ROLLBACK TO WMS_DEVICE_REQUESTS_SP;
3233: l_any_row_failed := TRUE;
3234: update_wdr_for_error_rec(l_rec.task_id,l_rec.relation_id);
3235: GOTO continue_loop;
3236:

Line 3246: ROLLBACK TO WMS_DEVICE_REQUESTS_SP;

3242: FND_MESSAGE.SET_NAME('WMS', 'WMS_MISSING_TASK_INFO');
3243: FND_MSG_PUB.ADD;
3244:
3245: --update wdr for error_code and error_mesg
3246: ROLLBACK TO WMS_DEVICE_REQUESTS_SP;
3247: l_any_row_failed := TRUE;
3248: update_wdr_for_error_rec(l_rec.task_id,l_rec.relation_id);
3249: GOTO continue_loop;
3250:

Line 3259: FROM wms_device_requests_hist

3255: --Check if corresponding RECORD exist in the WDRH history table
3256:
3257: BEGIN
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;

Line 3271: ROLLBACK TO WMS_DEVICE_REQUESTS_SP;

3267: FND_MESSAGE.SET_NAME('WMS', 'WMS_MISSING_TASK_INFO');
3268: FND_MSG_PUB.ADD;
3269:
3270: --update wdr for error_code and error_mesg
3271: ROLLBACK TO WMS_DEVICE_REQUESTS_SP;
3272: l_any_row_failed := TRUE;
3273: update_wdr_for_error_rec(l_rec.task_id,l_rec.relation_id);
3274: GOTO continue_loop;
3275: END;

Line 3337: ROLLBACK TO WMS_DEVICE_REQUESTS_SP;

3333: FND_MESSAGE.SET_NAME('WMS', 'WMS_INVALID_QTY');
3334: FND_MSG_PUB.ADD;
3335:
3336: --update wdr for error_code and mesg
3337: ROLLBACK TO WMS_DEVICE_REQUESTS_SP;
3338: l_any_row_failed := TRUE;
3339: update_wdr_for_error_rec(l_rec.task_id,l_rec.relation_id);
3340: GOTO continue_loop;
3341: END IF;

Line 3369: ROLLBACK TO WMS_DEVICE_REQUESTS_SP;

3365: FND_MESSAGE.SET_NAME('WMS', 'WMS_CONT_INVALID_SUB');
3366: FND_MSG_PUB.ADD;
3367:
3368: --update wdr for error_code and mesg
3369: ROLLBACK TO WMS_DEVICE_REQUESTS_SP;
3370: l_any_row_failed := TRUE;
3371: update_wdr_for_error_rec(l_rec.task_id,l_rec.relation_id);
3372: GOTO continue_loop;
3373: END;

Line 3381: ROLLBACK TO WMS_DEVICE_REQUESTS_SP;

3377: END IF;
3378: FND_MESSAGE.SET_NAME('WMS', 'WMS_SUB_NOLPN_CTRLD');
3379: FND_MSG_PUB.ADD;
3380: --update wdr for error_code and mesg
3381: ROLLBACK TO WMS_DEVICE_REQUESTS_SP;
3382: l_any_row_failed := TRUE;
3383: update_wdr_for_error_rec(l_rec.task_id,l_rec.relation_id);
3384: GOTO continue_loop;
3385: END IF;

Line 3412: ROLLBACK TO WMS_DEVICE_REQUESTS_SP;

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

Line 3445: ROLLBACK TO WMS_DEVICE_REQUESTS_SP;

3441: FND_MESSAGE.SET_NAME('WMS', 'WMS_MISMATCH_LPN');
3442: FND_MSG_PUB.ADD;
3443:
3444: --update wdr for error_code and error_mesg
3445: ROLLBACK TO WMS_DEVICE_REQUESTS_SP;
3446: l_any_row_failed := TRUE;
3447: update_wdr_for_error_rec(l_rec.task_id,l_rec.relation_id);
3448: GOTO continue_loop;
3449:

Line 3478: ROLLBACK TO WMS_DEVICE_REQUESTS_SP;

3474: FND_MESSAGE.SET_NAME('WMS', 'WMS_CONT_INVALID_LPN');
3475: FND_MSG_PUB.ADD;
3476:
3477: --update wdr for error_code and error_mesg
3478: ROLLBACK TO WMS_DEVICE_REQUESTS_SP;
3479: update_wdr_for_error_rec(l_rec.task_id,l_rec.relation_id);
3480: GOTO continue_loop;
3481: END;
3482:

Line 3491: ROLLBACK TO WMS_DEVICE_REQUESTS_SP;

3487: FND_MESSAGE.SET_NAME('WMS', 'WMS_CONT_INVALID_LPN');
3488: FND_MSG_PUB.ADD;
3489:
3490: --update wdr for error_code and error_mesg
3491: ROLLBACK TO WMS_DEVICE_REQUESTS_SP;
3492: update_wdr_for_error_rec(l_rec.task_id,l_rec.relation_id);
3493: GOTO continue_loop;
3494:
3495: END IF;

Line 3544: ROLLBACK TO WMS_DEVICE_REQUESTS_SP;

3540: FND_MESSAGE.SET_NAME('WMS', 'WMS_SUBST_LPN_ERR');
3541: FND_MSG_PUB.ADD;
3542:
3543: --update wdr for error_code and error_mesg
3544: ROLLBACK TO WMS_DEVICE_REQUESTS_SP;
3545: l_any_row_failed := TRUE;
3546: update_wdr_for_error_rec(l_rec.task_id,l_rec.relation_id);
3547: GOTO continue_loop;
3548:

Line 3583: ROLLBACK TO WMS_DEVICE_REQUESTS_SP;

3579: FND_MESSAGE.SET_NAME('WMS', 'WMS_CONT_INVALID_LPN');
3580: FND_MSG_PUB.ADD;
3581:
3582: --update wdr for error_code and error_mesg
3583: ROLLBACK TO WMS_DEVICE_REQUESTS_SP;
3584: l_any_row_failed := TRUE;
3585: update_wdr_for_error_rec(l_rec.task_id,l_rec.relation_id);
3586: GOTO continue_loop;
3587: END;

Line 3598: ROLLBACK TO WMS_DEVICE_REQUESTS_SP;

3594: FND_MESSAGE.SET_NAME('WMS', 'WMS_CONT_INVALID_LPN');
3595: FND_MSG_PUB.ADD;
3596:
3597: --update wdr for error_code and error_mesg
3598: ROLLBACK TO WMS_DEVICE_REQUESTS_SP;
3599: l_any_row_failed := TRUE;
3600: update_wdr_for_error_rec(l_rec.task_id,l_rec.relation_id);
3601: GOTO continue_loop;
3602:

Line 3637: ROLLBACK TO WMS_DEVICE_REQUESTS_SP;

3633: IF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3634: FND_MESSAGE.SET_NAME('WMS', 'WMS_CONT_INVALID_LPN');
3635: FND_MSG_PUB.ADD;
3636: --update wdr for error_code and error_mesg
3637: ROLLBACK TO WMS_DEVICE_REQUESTS_SP;
3638: l_any_row_failed := TRUE;
3639: update_wdr_for_error_rec(l_rec.task_id,l_rec.relation_id);
3640: GOTO continue_loop;
3641:

Line 3646: ROLLBACK TO WMS_DEVICE_REQUESTS_SP;

3642: ELSIF x_return_status = FND_API.G_RET_STS_ERROR THEN
3643: FND_MESSAGE.SET_NAME('WMS', 'WMS_CONT_INVALID_LPN');
3644: FND_MSG_PUB.ADD;
3645: --update wdr for error_code and error_mesg
3646: ROLLBACK TO WMS_DEVICE_REQUESTS_SP;
3647: l_any_row_failed := TRUE;
3648: update_wdr_for_error_rec(l_rec.task_id,l_rec.relation_id);
3649: GOTO continue_loop;
3650: END IF;

Line 3662: ROLLBACK TO WMS_DEVICE_REQUESTS_SP;

3658: FND_MESSAGE.SET_NAME('WMS', 'WMS_MISSING_XFER_LPN');
3659: FND_MSG_PUB.ADD;
3660:
3661: --update wdr for error_code and error_mesg
3662: ROLLBACK TO WMS_DEVICE_REQUESTS_SP;
3663: l_any_row_failed := TRUE;
3664: update_wdr_for_error_rec(l_rec.task_id,l_rec.relation_id);
3665: GOTO continue_loop;
3666: END IF;

Line 3690: ROLLBACK TO WMS_DEVICE_REQUESTS_SP;

3686: FND_MESSAGE.SET_NAME('WMS', 'WMS_SER_SHORT_PICK_ERR');
3687: FND_MSG_PUB.ADD;
3688:
3689: --update wdr for error_code and error_mesg
3690: ROLLBACK TO WMS_DEVICE_REQUESTS_SP;
3691: l_any_row_failed := TRUE;
3692: update_wdr_for_error_rec(l_rec.task_id,l_rec.relation_id);
3693: GOTO continue_loop;
3694:

Line 3735: ROLLBACK TO WMS_DEVICE_REQUESTS_SP;

3731: END IF;
3732: FND_MESSAGE.SET_NAME('WMS','WMS_RES_TASK_TYPE_ERR');
3733: FND_MSG_PUB.ADD;
3734: --update wdr for error_code and error_mesg
3735: ROLLBACK TO WMS_DEVICE_REQUESTS_SP;
3736: update_wdr_for_error_rec(l_rec.task_id,l_rec.relation_id);
3737: GOTO continue_loop;
3738: END;
3739: --Added for bug#8721738 end

Line 3862: ROLLBACK TO WMS_DEVICE_REQUESTS_SP;

3858: FND_MESSAGE.SET_NAME('WMS', 'WMS_LOT_SER_VALIDATION_FAIL');
3859: FND_MSG_PUB.ADD;
3860:
3861: --update wdr for error_code and error_mesg
3862: ROLLBACK TO WMS_DEVICE_REQUESTS_SP;
3863: l_any_row_failed := TRUE;
3864: update_wdr_for_error_rec(l_rec.task_id,l_rec.relation_id);
3865: GOTO continue_loop;
3866:

Line 3910: ROLLBACK TO WMS_DEVICE_REQUESTS_SP;

3906: FND_MESSAGE.SET_NAME('WMS', 'WMS_INVLID_LPN_MOVE');
3907: FND_MSG_PUB.ADD;
3908:
3909: --update wdr for error_code and error_mesg
3910: ROLLBACK TO WMS_DEVICE_REQUESTS_SP;
3911: l_any_row_failed := TRUE;
3912: update_wdr_for_error_rec(l_rec.task_id,l_rec.relation_id);
3913: GOTO continue_loop;
3914: else

Line 3924: ROLLBACK TO WMS_DEVICE_REQUESTS_SP;

3920: FND_MESSAGE.SET_NAME('WMS', 'WMS_INVALID_QTY');
3921: FND_MSG_PUB.ADD;
3922:
3923: --update wdr for error_code and error_mesg
3924: ROLLBACK TO WMS_DEVICE_REQUESTS_SP;
3925: l_any_row_failed := TRUE;
3926: update_wdr_for_error_rec(l_rec.task_id,l_rec.relation_id);
3927: GOTO continue_loop;
3928:

Line 3948: ROLLBACK TO WMS_DEVICE_REQUESTS_SP;

3944: FND_MESSAGE.SET_NAME('WMS', 'WMS_INVALID_LPN_MOVE');
3945: FND_MSG_PUB.ADD;
3946:
3947: --update wdr for error_code and error_mesg
3948: ROLLBACK TO WMS_DEVICE_REQUESTS_SP;
3949: l_any_row_failed := TRUE;
3950: update_wdr_for_error_rec(l_rec.task_id,l_rec.relation_id);
3951: GOTO continue_loop;
3952: else

Line 4009: ROLLBACK TO WMS_DEVICE_REQUESTS_SP;

4005: FND_MESSAGE.SET_NAME('WMS', 'WMS_LOT_SER_VALIDATION_FAIL');
4006: FND_MSG_PUB.ADD;
4007:
4008: --update wdr for error_code and error_mesg
4009: ROLLBACK TO WMS_DEVICE_REQUESTS_SP;
4010: l_any_row_failed := TRUE;
4011: update_wdr_for_error_rec(l_rec.task_id,l_rec.relation_id);
4012: GOTO continue_loop;
4013: END IF;

Line 4101: ROLLBACK TO WMS_DEVICE_REQUESTS_SP;

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

Line 4122: ROLLBACK TO WMS_DEVICE_REQUESTS_SP;

4118: FND_MESSAGE.SET_NAME('WMS','WMS_BACKORDER_FAILED');
4119: FND_MSG_PUB.ADD;
4120:
4121: --update wdr for error_code and error_mesg
4122: ROLLBACK TO WMS_DEVICE_REQUESTS_SP;
4123: l_any_row_failed := TRUE;
4124: update_wdr_for_error_rec(l_rec.task_id,l_rec.relation_id);
4125: GOTO continue_loop;
4126: END IF;

Line 4219: (SELECT serial_number FROM wms_device_requests

4215: mtl_serial_numbers_temp msnt
4216: WHERE mtlt.serial_transaction_temp_id = msnt.transaction_temp_id
4217: AND mtlt.transaction_temp_id =l_txn_temp_id)
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');

Line 4266: SELECT 1 FROM wms_device_requests wdr

4262: /*9908576-It is possible that some lots are totally missing. Let's delete them from MTLT*/
4263: DELETE FROM mtl_transaction_lots_temp mtlt
4264: WHERE mtlt.transaction_temp_id = l_txn_temp_id
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'

Line 4284: wms_device_requests wdr

4280: DELETE FROM mtl_serial_numbers_temp msnt
4281: WHERE msnt.transaction_temp_id = l_txn_temp_id
4282: AND msnt.fm_serial_number NOT IN
4283: ( SELECT wdr.serial_number FROM
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));

Line 4321: ROLLBACK TO WMS_DEVICE_REQUESTS_SP;

4317: END IF;
4318: FND_MESSAGE.SET_NAME('WMS', 'WMS_INVALID_LPN_MOVE');
4319: FND_MSG_PUB.ADD;
4320: --update wdr for error_code and error_mesg
4321: ROLLBACK TO WMS_DEVICE_REQUESTS_SP;
4322: l_any_row_failed := TRUE;
4323: update_wdr_for_error_rec(l_rec.task_id,l_rec.relation_id);
4324: GOTO continue_loop;
4325:

Line 4351: ROLLBACK TO WMS_DEVICE_REQUESTS_SP;

4347: END IF;
4348: FND_MESSAGE.SET_NAME('WMS', 'WMS_INVALID_LPN_MOVE');
4349: FND_MSG_PUB.ADD;
4350: --update wdr for error_code and error_mesg
4351: ROLLBACK TO WMS_DEVICE_REQUESTS_SP;
4352: l_any_row_failed := TRUE;
4353: update_wdr_for_error_rec(l_rec.task_id,l_rec.relation_id);
4354: GOTO continue_loop;
4355: else if l_rec.transaction_quantity > l_lpn_qty_pickable then

Line 4363: ROLLBACK TO WMS_DEVICE_REQUESTS_SP;

4359: END IF;
4360: FND_MESSAGE.SET_NAME('WMS', 'WMS_INVALID_QTY');
4361: FND_MSG_PUB.ADD;
4362: --update wdr for error_code and error_mesg
4363: ROLLBACK TO WMS_DEVICE_REQUESTS_SP;
4364: l_any_row_failed := TRUE;
4365: update_wdr_for_error_rec(l_rec.task_id,l_rec.relation_id);
4366: GOTO continue_loop;
4367:

Line 4395: ROLLBACK TO WMS_DEVICE_REQUESTS_SP;

4391: END IF;
4392: FND_MESSAGE.SET_NAME('WMS', 'WMS_INVALID_LPN_MOVE');
4393: FND_MSG_PUB.ADD;
4394: --update wdr for error_code and error_mesg
4395: ROLLBACK TO WMS_DEVICE_REQUESTS_SP;
4396: l_any_row_failed := TRUE;
4397: update_wdr_for_error_rec(l_rec.task_id,l_rec.relation_id);
4398: GOTO continue_loop;
4399: ELSE

Line 4414: ROLLBACK TO WMS_DEVICE_REQUESTS_SP;

4410: END IF;
4411: FND_MESSAGE.SET_NAME('WMS', 'WMS_INVALID_QTY');
4412: FND_MSG_PUB.ADD;
4413: --update wdr for error_code and error_mesg
4414: ROLLBACK TO WMS_DEVICE_REQUESTS_SP;
4415: l_any_row_failed := TRUE;
4416: update_wdr_for_error_rec(l_rec.task_id,l_rec.relation_id);
4417: GOTO continue_loop;
4418:

Line 4430: ROLLBACK TO WMS_DEVICE_REQUESTS_SP;

4426: END IF;
4427: FND_MESSAGE.SET_NAME('WMS', 'WMS_INVALID_LPN_MOVE');
4428: FND_MSG_PUB.ADD;
4429: --update wdr for error_code and error_mesg
4430: ROLLBACK TO WMS_DEVICE_REQUESTS_SP;
4431: l_any_row_failed := TRUE;
4432: update_wdr_for_error_rec(l_rec.task_id,l_rec.relation_id);
4433: GOTO continue_loop;
4434: else

Line 4593: ROLLBACK TO WMS_DEVICE_REQUESTS_SP;

4589: IF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
4590: FND_MESSAGE.SET_NAME('WMS','WMS_LOG_EXCEPTION_FAIL');
4591: FND_MSG_PUB.ADD;
4592: --update wdr for error_code and error_mesg
4593: ROLLBACK TO WMS_DEVICE_REQUESTS_SP;
4594: l_any_row_failed := TRUE;
4595: update_wdr_for_error_rec(l_rec.task_id,l_rec.relation_id);
4596: GOTO continue_loop;
4597:

Line 4602: ROLLBACK TO WMS_DEVICE_REQUESTS_SP;

4598: ELSIF x_return_status = FND_API.G_RET_STS_ERROR THEN
4599: FND_MESSAGE.SET_NAME('WMS','WMS_LOG_EXCEPTION_FAIL');
4600: FND_MSG_PUB.ADD;
4601: --update wdr for error_code and error_mesg
4602: ROLLBACK TO WMS_DEVICE_REQUESTS_SP;
4603: l_any_row_failed := TRUE;
4604: update_wdr_for_error_rec(l_rec.task_id,l_rec.relation_id);
4605: GOTO continue_loop;
4606:

Line 4708: ROLLBACK TO WMS_DEVICE_REQUESTS_SP;

4704: END IF;
4705: FND_MESSAGE.SET_NAME('WMS','WMS_WORK_FLOW_FAIL');
4706: FND_MSG_PUB.ADD;
4707: --update wdr for error_code and error_mesg
4708: ROLLBACK TO WMS_DEVICE_REQUESTS_SP;
4709: l_any_row_failed := TRUE;
4710: update_wdr_for_error_rec(l_rec.task_id,l_rec.relation_id);
4711: GOTO continue_loop;
4712:

Line 4720: ROLLBACK TO WMS_DEVICE_REQUESTS_SP;

4716: END IF;
4717: FND_MESSAGE.SET_NAME('WMS','WMS_WORK_FLOW_FAIL');
4718: FND_MSG_PUB.ADD;
4719: --update wdr for error_code and error_mesg
4720: ROLLBACK TO WMS_DEVICE_REQUESTS_SP;
4721: l_any_row_failed := TRUE;
4722: update_wdr_for_error_rec(l_rec.task_id,l_rec.relation_id);
4723: GOTO continue_loop;
4724:

Line 4825: ROLLBACK TO WMS_DEVICE_REQUESTS_SP;

4821: END IF;
4822: FND_MESSAGE.SET_NAME('WMS','WMS_TD_MODIFY_LPN_ERROR');
4823: FND_MSG_PUB.ADD;
4824: --update wdr for error_code and error_mesg
4825: ROLLBACK TO WMS_DEVICE_REQUESTS_SP;
4826: update_wdr_for_error_rec(l_rec.task_id,l_rec.relation_id);
4827: GOTO continue_loop;
4828:
4829:

Line 4860: ROLLBACK TO WMS_DEVICE_REQUESTS_SP;

4856: END IF;
4857: FND_MESSAGE.SET_NAME('WMS','WMS_TD_MODIFY_LPN_ERROR');
4858: FND_MSG_PUB.ADD;
4859: --update wdr for error_code and error_mesg
4860: ROLLBACK TO WMS_DEVICE_REQUESTS_SP;
4861: update_wdr_for_error_rec(l_rec.task_id,l_rec.relation_id);
4862: GOTO continue_loop;
4863: END IF;
4864: END IF;

Line 4881: ROLLBACK TO WMS_DEVICE_REQUESTS_SP;

4877: END IF;
4878: FND_MESSAGE.SET_NAME('WMS', 'WMS_MISSING_TASK_INFO');
4879: FND_MSG_PUB.ADD;
4880: --update wdr for error_code and error_mesg
4881: ROLLBACK TO WMS_DEVICE_REQUESTS_SP;
4882: l_any_row_failed := TRUE;
4883: update_wdr_for_error_rec(l_rec.task_id,l_rec.relation_id);
4884: GOTO continue_loop;
4885: END IF;

Line 4891: UPDATE wms_device_requests

4887:
4888: END IF;--device success
4889:
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

Line 4943: ROLLBACK TO WMS_DEVICE_REQUESTS_SP_OUTER;

4939: END IF;
4940: FND_MESSAGE.SET_NAME('INV', 'INV_NO_OPEN_PERIOD');
4941: FND_MSG_PUB.ADD;
4942: x_return_status := FND_API.g_ret_sts_error;
4943: ROLLBACK TO WMS_DEVICE_REQUESTS_SP_OUTER;
4944:
4945: END IF;
4946:
4947: END LOOP;

Line 5029: ROLLBACK TO WMS_DEVICE_REQUESTS_SP_OUTER;

5025: FND_MSG_PUB.ADD;
5026:
5027: x_return_status := FND_API.g_ret_sts_error;
5028:
5029: ROLLBACK TO WMS_DEVICE_REQUESTS_SP_OUTER;
5030:
5031: ELSE
5032: --TM CALL SUCCESSFUL
5033:

Line 5085: ROLLBACK TO wms_device_requests_sp_outer;

5081: END IF;
5082: FND_MESSAGE.SET_NAME('WMS','WMS_TD_MODIFY_LPN_ERROR' );
5083: FND_MSG_PUB.ADD;
5084: --rollback the batch
5085: ROLLBACK TO wms_device_requests_sp_outer;
5086:
5087: END IF;
5088:
5089: END LOOP;

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

5097:
5098: IF (l_debug = 1) THEN
5099: trace(' device_confirmation:Delete requested rows from WDR');
5100: END IF;
5101: delete from wms_device_requests;--since temp table is session specific
5102:
5103: --Commit will be done by calling api
5104: IF (l_debug = 1) THEN
5105: trace('device_confirmation:done with this API');

Line 5126: UPDATE wms_device_requests_hist

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

Line 5134: ROLLBACK TO WMS_DEVICE_REQUESTS_SP_OUTER;

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;
5135: END IF;
5136:
5137: IF (l_debug = 1) THEN
5138: trace('DEVICE_CONFIRMATION:Error: G_EXC_ERR');

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

5136:
5137: IF (l_debug = 1) THEN
5138: trace('DEVICE_CONFIRMATION:Error: G_EXC_ERR');
5139: END IF;
5140: -- ROLLBACK TO WMS_DEVICE_REQUESTS_SP_OUTER;Commented for Bug#4535546
5141: x_return_status := FND_API.G_RET_STS_ERROR;
5142:
5143: x_msg_data:=GET_MSG_STACK ; --Bug#4535546.
5144:

Line 5163: UPDATE wms_device_requests_hist

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

Line 5171: ROLLBACK TO WMS_DEVICE_REQUESTS_SP_OUTER;

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;
5172: END IF;
5173:
5174: IF (l_debug = 1) THEN
5175: trace('DEVICE_CONFIRMATION:Error: G_UNEXC_ERR');

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

5173:
5174: IF (l_debug = 1) THEN
5175: trace('DEVICE_CONFIRMATION:Error: G_UNEXC_ERR');
5176: END IF;
5177: -- ROLLBACK TO WMS_DEVICE_REQUESTS_SP_OUTER; Commented for Bug#4535546
5178: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
5179:
5180: x_msg_data:=GET_MSG_STACK ; --Bug#4535546.
5181: