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_S

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 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 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 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 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 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 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: