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_ATF_RUNTIME_PUB_APIS dependencies on WMS_OP_INBOUND_PVT

Line 417: print_debug('Calling WMS_OP_INBOUND_PVT.INIT with the parameters',l_module_name,4);

413: END IF;
414:
415: /*Call document handler for creating child records*/
416: IF (l_debug=1) THEN
417: print_debug('Calling WMS_OP_INBOUND_PVT.INIT with the parameters',l_module_name,4);
418: print_debug('p_source_task_id ==>'||p_source_task_id,l_module_name,4);
419: print_debug('p_operation_type ==>'||l_operation_plan_detail_rec.operation_type,l_module_name,4);
420: print_debug('MMTT.transaction_temp_id ==>'||p_source_task_id,l_module_name,4);
421: print_debug('MMTT.inventory_item_id ==>'||l_inbound_doc_rec.inventory_item_id,l_module_name,4);

Line 440: WMS_OP_INBOUND_PVT.INIT

436: }}
437: */
438:
439:
440: WMS_OP_INBOUND_PVT.INIT
441: (
442: x_return_status => x_return_status
443: , x_msg_count => x_msg_count
444: , x_msg_data => x_msg_data

Line 746: x_plan_attributes OUT NOCOPY WMS_OP_INBOUND_PVT.DEST_PARAM_REC_TYPE,

742: x_msg_count OUT NOCOPY NUMBER,
743: x_error_code OUT NOCOPY NUMBER,
744: x_consolidation_method_id OUT NOCOPY NUMBER,
745: x_drop_lpn_option OUT NOCOPY NUMBER, -- xdock
746: x_plan_attributes OUT NOCOPY WMS_OP_INBOUND_PVT.DEST_PARAM_REC_TYPE,
747: p_source_task_id IN NUMBER,
748: p_activity_type_id IN NUMBER,
749: p_inventory_item_id IN NUMBER
750: ) IS

Line 756: l_attributes WMS_OP_INBOUND_PVT.DEST_PARAM_REC_TYPE;

752: l_debug NUMBER := NVL(fnd_profile.VALUE('INV_DEBUG_TRACE'),0);
753: l_module_name VARCHAR2(30) := 'Determine_Attributes';
754: l_progress VARCHAR2(30) := '0';
755:
756: l_attributes WMS_OP_INBOUND_PVT.DEST_PARAM_REC_TYPE;
757:
758: l_sub_determination_method NUMBER;
759: l_loc_determination_method NUMBER;
760: l_lpn_determination_method NUMBER;

Line 1762: l_dest_param_rec WMS_OP_INBOUND_PVT.DEST_PARAM_REC_TYPE;

1758: l_wopi_rec wms_op_plan_instances%ROWTYPE := NULL;
1759: l_sug_sub_code VARCHAR2(10);
1760: l_sug_location_id NUMBER;
1761: l_sug_to_lpn_id NUMBER;
1762: l_dest_param_rec WMS_OP_INBOUND_PVT.DEST_PARAM_REC_TYPE;
1763: l_operation_type_id NUMBER;
1764:
1765: l_debug NUMBER := NVL(fnd_profile.VALUE('INV_DEBUG_TRACE'), 0);
1766: l_module_name VARCHAR2(30) := 'Activate_Operation_Instance';

Line 2393: WMS_OP_INBOUND_PVT.ACTIVATE

2389: print_debug('Organization Id ==>'||l_mmtt_rec.organization_id,l_module_name,9);
2390: print_debug('l_mmtt_rec.inventory_item_id ==>'||l_mmtt_rec.inventory_item_id , l_module_name, 9);
2391: END IF;
2392:
2393: WMS_OP_INBOUND_PVT.ACTIVATE
2394: ( x_return_status => l_return_status,--Use l_return_status instead
2395: x_msg_count => l_msg_count, --of x_return_status because
2396: x_msg_data => l_msg_data, --it will override the value
2397: x_error_code => x_error_code, --returned from determine_attributes

Line 3040: print_debug('Operation_plan_ID NULL - Before calling wms_op_inbound_pvt.complete with following parameters:',l_module_name,4);

3036: IF l_operation_type_id IN (g_op_type_drop, g_op_type_inspect) THEN
3037:
3038: IF (l_debug=1) THEN
3039: print_debug('Current operation is DROP or INSPECT. Need to call COMPLETE document handler',l_module_name,4);
3040: print_debug('Operation_plan_ID NULL - Before calling wms_op_inbound_pvt.complete with following parameters:',l_module_name,4);
3041: print_debug('p_source_task_id => '|| p_source_task_id,l_module_name,4);
3042: print_debug('p_document_rec.transaction_temp_id => '|| l_mmtt_rec.transaction_temp_id,l_module_name,4);
3043: print_debug('p_operation_type_id => '|| l_operation_type_id,l_module_name,4);
3044: print_debug('p_next_operation_type_id => '|| '',l_module_name,4);

Line 3051: wms_op_inbound_pvt.complete

3047: END IF;
3048:
3049: l_progress := 100;
3050:
3051: wms_op_inbound_pvt.complete
3052: (
3053: x_return_status => l_return_status
3054: , x_msg_data => l_msg_data
3055: , x_msg_count => l_msg_count

Line 3070: print_debug('Inbound op plan null - After calling wms_op_inbound_pvt.complete. ', l_module_name,4);

3066:
3067: l_progress := 102;
3068:
3069: IF (l_debug=1) THEN
3070: print_debug('Inbound op plan null - After calling wms_op_inbound_pvt.complete. ', l_module_name,4);
3071:
3072: print_debug('x_return_status => '||l_return_status, l_module_name,4);
3073: print_debug('x_msg_data => '||l_msg_data, l_module_name,4);
3074: print_debug('x_msg_count => '||l_msg_count, l_module_name,4);

Line 3081: print_debug('Inbound op plan null - wms_op_inbound_pvt.complete finished with error. l_return_status = ' || l_return_status,l_module_name,4);

3077: END IF;
3078: --bug 6924639
3079: IF l_return_status = fnd_api.g_ret_sts_unexp_error THEN
3080: IF (l_debug = 1) THEN
3081: print_debug('Inbound op plan null - wms_op_inbound_pvt.complete finished with error. l_return_status = ' || l_return_status,l_module_name,4);
3082: END IF;
3083:
3084: fnd_message.set_name('WMS', 'WMS_WORK_FLOW_FAIL');
3085: fnd_msg_pub.ADD;

Line 3089: print_debug('Inbound op plan null - wms_op_inbound_pvt.complete finished with error. l_return_status = ' || l_return_status,l_module_name,4);

3085: fnd_msg_pub.ADD;
3086: RAISE fnd_api.g_exc_unexpected_error;
3087: ELSIF l_return_status = fnd_api.g_ret_sts_error THEN
3088: IF (l_debug = 1) THEN
3089: print_debug('Inbound op plan null - wms_op_inbound_pvt.complete finished with error. l_return_status = ' || l_return_status,l_module_name,4);
3090: END IF;
3091:
3092: fnd_message.set_name('WMS', 'WMS_WORK_FLOW_FAIL');
3093: fnd_msg_pub.ADD;

Line 3100: print_debug('Inbound op plan null - wms_op_inbound_pvt.complete finished with error. l_return_status = ' || l_return_status,l_module_name,4);

3096: --bug 6924639
3097: /*
3098: IF l_return_status <>FND_API.g_ret_sts_success THEN
3099: IF (l_debug=1) THEN
3100: print_debug('Inbound op plan null - wms_op_inbound_pvt.complete finished with error. l_return_status = ' || l_return_status,l_module_name,4);
3101: END IF;
3102:
3103: RAISE FND_API.G_EXC_ERROR;
3104: END IF;

Line 3356: print_debug('Unforgivable error - Before calling wms_op_inbound_pvt.complete with following parameters:',l_module_name,4);

3352:
3353:
3354: IF (l_debug=1) THEN
3355:
3356: print_debug('Unforgivable error - Before calling wms_op_inbound_pvt.complete with following parameters:',l_module_name,4);
3357: print_debug('p_source_task_id => '|| p_source_task_id,l_module_name,4);
3358: print_debug('p_document_rec.transaction_temp_id => '|| l_mmtt_rec.transaction_temp_id,l_module_name,4);
3359: print_debug('p_operation_type_id => '|| l_operation_type_id,l_module_name,4);
3360: print_debug('p_next_operation_type_id => '|| '',l_module_name,4);

Line 3366: wms_op_inbound_pvt.complete

3362:
3363: END IF;
3364:
3365:
3366: wms_op_inbound_pvt.complete
3367: (
3368: x_return_status => l_return_status
3369: , x_msg_data => l_msg_data
3370: , x_msg_count => l_msg_count

Line 3384: print_debug('Unforgivable Error - After calling wms_op_inbound_pvt.complete. ', l_module_name,4);

3380: );
3381:
3382:
3383: IF (l_debug=1) THEN
3384: print_debug('Unforgivable Error - After calling wms_op_inbound_pvt.complete. ', l_module_name,4);
3385:
3386: print_debug('x_return_status => '||l_return_status, l_module_name,4);
3387: print_debug('x_msg_data => '||l_msg_data, l_module_name,4);
3388: print_debug('x_msg_count => '||l_msg_count, l_module_name,4);

Line 3395: print_debug('Unforgivable Error - wms_op_inbound_pvt.complete finished with error. l_return_status = ' || l_return_status,l_module_name,4);

3391: END IF;
3392: --bug 6924639
3393: IF l_return_status = fnd_api.g_ret_sts_unexp_error THEN
3394: IF (l_debug = 1) THEN
3395: print_debug('Unforgivable Error - wms_op_inbound_pvt.complete finished with error. l_return_status = ' || l_return_status,l_module_name,4);
3396: END IF;
3397:
3398: fnd_message.set_name('WMS', 'WMS_WORK_FLOW_FAIL');
3399: fnd_msg_pub.ADD;

Line 3403: print_debug('Unforgivable Error - wms_op_inbound_pvt.complete finished with error. l_return_status = ' || l_return_status,l_module_name,4);

3399: fnd_msg_pub.ADD;
3400: RAISE fnd_api.g_exc_unexpected_error;
3401: ELSIF l_return_status = fnd_api.g_ret_sts_error THEN
3402: IF (l_debug = 1) THEN
3403: print_debug('Unforgivable Error - wms_op_inbound_pvt.complete finished with error. l_return_status = ' || l_return_status,l_module_name,4);
3404: END IF;
3405:
3406: fnd_message.set_name('WMS', 'WMS_WORK_FLOW_FAIL');
3407: fnd_msg_pub.ADD;

Line 3414: print_debug('Unforgivable Error - wms_op_inbound_pvt.complete finished with error. l_return_status = ' || l_return_status,l_module_name,4);

3410: --bug 6924639
3411: /*
3412: IF l_return_status <>FND_API.g_ret_sts_success THEN
3413: IF (l_debug=1) THEN
3414: print_debug('Unforgivable Error - wms_op_inbound_pvt.complete finished with error. l_return_status = ' || l_return_status,l_module_name,4);
3415: END IF;
3416:
3417: RAISE FND_API.G_EXC_ERROR;
3418: END IF;

Line 3597: print_debug('Last operation in plan and inbound - Before calling wms_op_inbound_pvt.complete with following parameters:',l_module_name,4);

3593:
3594:
3595: IF (l_debug=1) THEN
3596:
3597: print_debug('Last operation in plan and inbound - Before calling wms_op_inbound_pvt.complete with following parameters:',l_module_name,4);
3598: print_debug('p_source_task_id => '|| p_source_task_id,l_module_name,4);
3599: print_debug('p_document_rec.transaction_temp_id => '|| l_mmtt_rec.transaction_temp_id,l_module_name,4);
3600: print_debug('p_operation_type_id => '|| l_operation_type_id,l_module_name,4);
3601: print_debug('p_next_operation_type_id => '|| '',l_module_name,4);

Line 3608: wms_op_inbound_pvt.complete

3604: END IF;
3605:
3606: l_progress := 180;
3607:
3608: wms_op_inbound_pvt.complete
3609: (
3610: x_return_status => l_return_status
3611: , x_msg_data => l_msg_data
3612: , x_msg_count => l_msg_count

Line 3627: print_debug('Last operation in plan - After calling wms_op_inbound_pvt.complete. ', l_module_name,4);

3623:
3624: l_progress := 190;
3625:
3626: IF (l_debug=1) THEN
3627: print_debug('Last operation in plan - After calling wms_op_inbound_pvt.complete. ', l_module_name,4);
3628:
3629: print_debug('x_return_status => '||l_return_status, l_module_name,4);
3630: print_debug('x_msg_data => '||l_msg_data, l_module_name,4);
3631: print_debug('x_msg_count => '||l_msg_count, l_module_name,4);

Line 3638: print_debug('Inbound op plan null - wms_op_inbound_pvt.complete finished with error. l_return_status = ' || l_return_status,l_module_name,4);

3634: END IF;
3635: --bug 6924639
3636: IF l_return_status = fnd_api.g_ret_sts_unexp_error THEN
3637: IF (l_debug = 1) THEN
3638: print_debug('Inbound op plan null - wms_op_inbound_pvt.complete finished with error. l_return_status = ' || l_return_status,l_module_name,4);
3639: END IF;
3640:
3641: fnd_message.set_name('WMS', 'WMS_WORK_FLOW_FAIL');
3642: fnd_msg_pub.ADD;

Line 3646: print_debug('Inbound op plan null - wms_op_inbound_pvt.complete finished with error. l_return_status = ' || l_return_status,l_module_name,4);

3642: fnd_msg_pub.ADD;
3643: RAISE fnd_api.g_exc_unexpected_error;
3644: ELSIF l_return_status = fnd_api.g_ret_sts_error THEN
3645: IF (l_debug = 1) THEN
3646: print_debug('Inbound op plan null - wms_op_inbound_pvt.complete finished with error. l_return_status = ' || l_return_status,l_module_name,4);
3647: END IF;
3648:
3649: fnd_message.set_name('WMS', 'WMS_WORK_FLOW_FAIL');
3650: fnd_msg_pub.ADD;

Line 3657: print_debug('Last operation in plan - wms_op_inbound_pvt.complete finished with error. l_return_status = ' || l_return_status,l_module_name,4);

3653: --bug 6924639
3654: /*
3655: IF l_return_status <>FND_API.g_ret_sts_success THEN
3656: IF (l_debug=1) THEN
3657: print_debug('Last operation in plan - wms_op_inbound_pvt.complete finished with error. l_return_status = ' || l_return_status,l_module_name,4);
3658: END IF;
3659:
3660: RAISE FND_API.G_EXC_ERROR;
3661: END IF;

Line 3737: print_debug('NOT Last operation in plan and inbound - Before calling wms_op_inbound_pvt.complete with following parameters:',l_module_name,4);

3733: IF p_activity_id = g_op_activity_inbound THEN
3734:
3735:
3736: IF (l_debug=1) THEN
3737: print_debug('NOT Last operation in plan and inbound - Before calling wms_op_inbound_pvt.complete with following parameters:',l_module_name,4);
3738: print_debug('p_source_task_id => '|| p_source_task_id,l_module_name,4);
3739: print_debug('p_document_rec.transaction_temp_id => '|| l_mmtt_rec.transaction_temp_id,l_module_name,4);
3740: print_debug('p_operation_type_id => '|| l_operation_type_id,l_module_name,4);
3741: print_debug('p_next_operation_type_id => '|| l_operation_plan_detail_rec.operation_type, l_module_name,4);

Line 3753: wms_op_inbound_pvt.complete

3749:
3750: }}
3751: */
3752:
3753: wms_op_inbound_pvt.complete
3754: (
3755: x_return_status => l_return_status
3756: , x_msg_data => l_msg_data
3757: , x_msg_count => l_msg_count

Line 3773: print_debug('NOT Last operation in plan - After calling wms_op_inbound_pvt.complete. ', l_module_name,4);

3769:
3770: l_progress := 230;
3771:
3772: IF (l_debug=1) THEN
3773: print_debug('NOT Last operation in plan - After calling wms_op_inbound_pvt.complete. ', l_module_name,4);
3774:
3775: print_debug('x_return_status => '||l_return_status, l_module_name,4);
3776: print_debug('x_msg_data => '||l_msg_data, l_module_name,4);
3777: print_debug('x_msg_count => '||l_msg_count, l_module_name,4);

Line 3783: print_debug('Inbound op plan null - wms_op_inbound_pvt.complete finished with error. l_return_status = ' || l_return_status,l_module_name,4);

3779: print_debug('x_error_code => '||l_atf_error_code, l_module_name,4);
3780: END IF;
3781: IF l_return_status = fnd_api.g_ret_sts_unexp_error THEN
3782: IF (l_debug = 1) THEN
3783: print_debug('Inbound op plan null - wms_op_inbound_pvt.complete finished with error. l_return_status = ' || l_return_status,l_module_name,4);
3784: END IF;
3785:
3786: fnd_message.set_name('WMS', 'WMS_WORK_FLOW_FAIL');
3787: fnd_msg_pub.ADD;

Line 3791: print_debug('Inbound op plan null - wms_op_inbound_pvt.complete finished with error. l_return_status = ' || l_return_status,l_module_name,4);

3787: fnd_msg_pub.ADD;
3788: RAISE fnd_api.g_exc_unexpected_error;
3789: ELSIF l_return_status = fnd_api.g_ret_sts_error THEN
3790: IF (l_debug = 1) THEN
3791: print_debug('Inbound op plan null - wms_op_inbound_pvt.complete finished with error. l_return_status = ' || l_return_status,l_module_name,4);
3792: END IF;
3793:
3794: fnd_message.set_name('WMS', 'WMS_WORK_FLOW_FAIL');
3795: fnd_msg_pub.ADD;

Line 6624: print_debug('l_wdt_status = '||g_task_status_loaded||', Drop operation, call WMS_OP_INBOUND_PVT.cleanup with following parameters: ',l_module_name,4);

6620:
6621: IF l_wdt_status = g_task_status_loaded THEN
6622:
6623: IF (l_debug = 1) THEN
6624: print_debug('l_wdt_status = '||g_task_status_loaded||', Drop operation, call WMS_OP_INBOUND_PVT.cleanup with following parameters: ',l_module_name,4);
6625: print_debug('p_source_task_id => ' || p_source_task_id,l_module_name,4);
6626: END IF;
6627:
6628: l_progress := 72;

Line 6632: wms_op_inbound_pvt.cleanup

6628: l_progress := 72;
6629:
6630: -- This call will cleanup wms_task_type (-1 -> 2) and lpn columns
6631:
6632: wms_op_inbound_pvt.cleanup
6633: (
6634: x_return_status => l_return_status
6635: , x_msg_data => l_msg_data
6636: , x_msg_count => l_msg_count

Line 6643: print_debug('After calling wms_op_inbound_pvt.cleanup.',l_module_name,4);

6639:
6640: l_progress := 74;
6641:
6642: IF (l_debug=1) THEN
6643: print_debug('After calling wms_op_inbound_pvt.cleanup.',l_module_name,4);
6644: print_debug('x_return_status => '|| l_return_status,l_module_name,4);
6645: print_debug('x_msg_count => '|| l_msg_count,l_module_name,4);
6646: print_debug('x_msg_data => '|| l_msg_data,l_module_name,4);
6647: END IF;

Line 6651: print_debug('wms_op_inbound_pvt.cleanup finished with error. l_return_status = ' || l_return_status,l_module_name,4);

6647: END IF;
6648:
6649: IF l_return_status <>FND_API.g_ret_sts_success THEN
6650: IF (l_debug=1) THEN
6651: print_debug('wms_op_inbound_pvt.cleanup finished with error. l_return_status = ' || l_return_status,l_module_name,4);
6652: END IF;
6653:
6654: RAISE FND_API.G_EXC_ERROR;
6655: END IF;

Line 6801: print_debug('Drop operation, call WMS_OP_INBOUND_PVT.cleanup with following parameters: ',l_module_name,4);

6797:
6798:
6799: IF l_wooi_data_rec.operation_type_id = g_op_type_drop THEN
6800: IF (l_debug = 1) THEN
6801: print_debug('Drop operation, call WMS_OP_INBOUND_PVT.cleanup with following parameters: ',l_module_name,4);
6802: print_debug('p_source_task_id => ' || p_source_task_id,l_module_name,4);
6803: END IF;
6804:
6805: l_progress := 170;

Line 6807: wms_op_inbound_pvt.cleanup

6803: END IF;
6804:
6805: l_progress := 170;
6806:
6807: wms_op_inbound_pvt.cleanup
6808: (
6809: x_return_status => l_return_status
6810: , x_msg_data => l_msg_data
6811: , x_msg_count => l_msg_count

Line 6818: print_debug('After calling wms_op_inbound_pvt.cleanup.',l_module_name,4);

6814:
6815: l_progress := 180;
6816:
6817: IF (l_debug=1) THEN
6818: print_debug('After calling wms_op_inbound_pvt.cleanup.',l_module_name,4);
6819: print_debug('x_return_status => '|| l_return_status,l_module_name,4);
6820: print_debug('x_msg_count => '|| l_msg_count,l_module_name,4);
6821: print_debug('x_msg_data => '|| l_msg_data,l_module_name,4);
6822: END IF;

Line 6826: print_debug('wms_op_inbound_pvt.cleanup finished with error. l_return_status = ' || l_return_status,l_module_name,4);

6822: END IF;
6823:
6824: IF l_return_status <>FND_API.g_ret_sts_success THEN
6825: IF (l_debug=1) THEN
6826: print_debug('wms_op_inbound_pvt.cleanup finished with error. l_return_status = ' || l_return_status,l_module_name,4);
6827: END IF;
6828:
6829: RAISE FND_API.G_EXC_ERROR;
6830: END IF;

Line 7236: print_debug('Before calling wms_op_inbound_pvt.cancel with following parameters: ' ,l_module_name,4);

7232: l_progress:=180;
7233:
7234: IF (l_debug=1) THEN
7235: print_debug('Inbound activity. ',l_module_name,4);
7236: print_debug('Before calling wms_op_inbound_pvt.cancel with following parameters: ' ,l_module_name,4);
7237: print_debug('p_source_task_id => '|| p_source_task_id,l_module_name,4);
7238:
7239: END IF;
7240:

Line 7241: wms_op_inbound_pvt.cancel

7237: print_debug('p_source_task_id => '|| p_source_task_id,l_module_name,4);
7238:
7239: END IF;
7240:
7241: wms_op_inbound_pvt.cancel
7242: (
7243: x_return_status => x_return_status,
7244: x_msg_data => x_msg_data,
7245: x_msg_count => x_msg_count,

Line 7253: print_debug('After calling wms_op_inbound_pvt.cancel.' ,l_module_name,4);

7249: p_mmtt_error_explanation => p_mmtt_error_explanation
7250: );
7251:
7252: IF (l_debug=1) THEN
7253: print_debug('After calling wms_op_inbound_pvt.cancel.' ,l_module_name,4);
7254: print_debug('x_return_status => '|| x_return_status,l_module_name,4);
7255: print_debug('x_msg_data => '|| x_msg_data,l_module_name,4);
7256: print_debug('x_msg_count => '|| x_msg_count,l_module_name,4);
7257: END IF;

Line 7261: print_debug('wms_op_inbound_pvt.cancel finished with error. x_return_status = ' || x_return_status,l_module_name,4);

7257: END IF;
7258:
7259: IF x_return_status <>FND_API.g_ret_sts_success THEN
7260: IF (l_debug=1) THEN
7261: print_debug('wms_op_inbound_pvt.cancel finished with error. x_return_status = ' || x_return_status,l_module_name,4);
7262: END IF;
7263:
7264: RAISE FND_API.G_EXC_ERROR;
7265: END IF;

Line 7765: print_debug('Before calling wms_op_inbound_pvt.ABORT with following parameters:',l_module_name,4);

7761: l_document_rec.inventory_item_id := l_inbound_doc.inventory_item_id;
7762: l_document_rec.primary_quantity := l_inbound_doc.primary_quantity;
7763:
7764: IF l_debug=1 THEN
7765: print_debug('Before calling wms_op_inbound_pvt.ABORT with following parameters:',l_module_name,4);
7766: print_debug('l_document_rec.transaction_temp_id => '|| l_document_rec.transaction_temp_id,l_module_name,4);
7767: print_debug('l_document_rec.parent_line_id => '||l_document_rec.parent_line_id,l_module_name,4);
7768: print_debug('l_document_rec.locator_id => '||l_document_rec.locator_id,l_module_name,4);
7769: print_debug('l_document_rec.transfer_to_location => '||l_document_rec.transfer_to_location,l_module_name,4);

Line 7781: wms_op_inbound_pvt.ABORT

7777:
7778: END IF;
7779:
7780:
7781: wms_op_inbound_pvt.ABORT
7782: (x_return_status => l_return_status,
7783: x_msg_data => l_msg_data,
7784: x_msg_count => l_msg_count,
7785: p_document_rec => l_document_rec,

Line 7792: print_debug('After calling wms_op_inbound_pvt.ABORT:',l_module_name,4);

7788: p_for_manual_drop => p_for_manual_drop
7789: );
7790:
7791: IF l_debug=1 THEN
7792: print_debug('After calling wms_op_inbound_pvt.ABORT:',l_module_name,4);
7793: print_debug('x_return_status => '||l_return_status,l_module_name,4);
7794: print_debug('x_msg_data => '||l_msg_data,l_module_name,4);
7795: print_debug('x_msg_count => '||l_msg_count,l_module_name,4);
7796: END IF;

Line 7800: print_debug(' wms_op_inbound_pvt.ABORT finished with error. l_return_status = ' || l_return_status,l_module_name,4);

7796: END IF;
7797:
7798: IF l_return_status <> FND_API.g_ret_sts_success THEN
7799: IF (l_debug=1) THEN
7800: print_debug(' wms_op_inbound_pvt.ABORT finished with error. l_return_status = ' || l_return_status,l_module_name,4);
7801: END IF;
7802:
7803: RAISE FND_API.G_EXC_ERROR;
7804: END IF;

Line 8088: -- Moved delete WDT to after WMS_OP_INBOUND_PVT.Cleanup

8084:
8085: l_progress := 40;
8086:
8087:
8088: -- Moved delete WDT to after WMS_OP_INBOUND_PVT.Cleanup
8089:
8090:
8091: /* Query the document tables based on p_source_taks_id and p_activity_id and populate the document record.
8092: * If p_activity_id=INBOUND then

Line 8130: WMS_OP_INBOUND_PVT.Cleanup

8126: END IF;
8127: /* for bug#5997558 */
8128: IF p_activity_type_id =G_OP_ACTIVITY_INBOUND THEN
8129:
8130: WMS_OP_INBOUND_PVT.Cleanup
8131: ( x_return_status => x_return_status
8132: , x_msg_data => x_msg_data
8133: , x_msg_count => x_msg_count
8134: , p_source_task_id => p_source_task_id

Line 8154: -- since now we delete WDT after calling WMS_OP_INBOUND_PVT.Cleanup at the end.

8150:
8151: /* End for bug#5997558 */
8152:
8153: -- Before we return, we should delete WDT here
8154: -- since now we delete WDT after calling WMS_OP_INBOUND_PVT.Cleanup at the end.
8155:
8156: DELETE FROM WMS_DISPATCHED_TASKS
8157: WHERE transaction_temp_id = p_source_task_id
8158: AND task_id = l_wdt_details.task_id;

Line 8383: * Call WMS_OP_INBOUND_PVT.Cleanup

8379:
8380: END IF;/*First Operation in Plan*/
8381:
8382: /*If p_activity_id =INBOUND then
8383: * Call WMS_OP_INBOUND_PVT.Cleanup
8384: *End If;
8385: */
8386: l_progress :=160;
8387: IF p_activity_type_id =G_OP_ACTIVITY_INBOUND THEN

Line 8389: WMS_OP_INBOUND_PVT.Cleanup

8385: */
8386: l_progress :=160;
8387: IF p_activity_type_id =G_OP_ACTIVITY_INBOUND THEN
8388:
8389: WMS_OP_INBOUND_PVT.Cleanup
8390: ( x_return_status => x_return_status
8391: , x_msg_data => x_msg_data
8392: , x_msg_count => x_msg_count
8393: , p_source_task_id => p_source_task_id

Line 8411: -- Moved delete WDT to after calling WMS_OP_INBOUND_PVT.Cleanup

8407: END IF;
8408:
8409:
8410: /* Deleting the WDT record as the status is being reverted to Load Pending */
8411: -- Moved delete WDT to after calling WMS_OP_INBOUND_PVT.Cleanup
8412: -- because WMS_OP_INBOUND_PVT.Cleanup now calls putaway_cleanup, which assumes WDT still exists.
8413:
8414: DELETE FROM WMS_DISPATCHED_TASKS
8415: WHERE transaction_temp_id = p_source_task_id

Line 8412: -- because WMS_OP_INBOUND_PVT.Cleanup now calls putaway_cleanup, which assumes WDT still exists.

8408:
8409:
8410: /* Deleting the WDT record as the status is being reverted to Load Pending */
8411: -- Moved delete WDT to after calling WMS_OP_INBOUND_PVT.Cleanup
8412: -- because WMS_OP_INBOUND_PVT.Cleanup now calls putaway_cleanup, which assumes WDT still exists.
8413:
8414: DELETE FROM WMS_DISPATCHED_TASKS
8415: WHERE transaction_temp_id = p_source_task_id
8416: AND task_id = l_wdt_details.task_id;