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 2358: WMS_OP_INBOUND_PVT.ACTIVATE

2354: print_debug('Organization Id ==>'||l_mmtt_rec.organization_id,l_module_name,9);
2355: print_debug('l_mmtt_rec.inventory_item_id ==>'||l_mmtt_rec.inventory_item_id , l_module_name, 9);
2356: END IF;
2357:
2358: WMS_OP_INBOUND_PVT.ACTIVATE
2359: ( x_return_status => l_return_status,--Use l_return_status instead
2360: x_msg_count => l_msg_count, --of x_return_status because
2361: x_msg_data => l_msg_data, --it will override the value
2362: x_error_code => x_error_code, --returned from determine_attributes

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

2996: IF l_operation_type_id IN (g_op_type_drop, g_op_type_inspect) THEN
2997:
2998: IF (l_debug=1) THEN
2999: print_debug('Current operation is DROP or INSPECT. Need to call COMPLETE document handler',l_module_name,4);
3000: print_debug('Operation_plan_ID NULL - Before calling wms_op_inbound_pvt.complete with following parameters:',l_module_name,4);
3001: print_debug('p_source_task_id => '|| p_source_task_id,l_module_name,4);
3002: print_debug('p_document_rec.transaction_temp_id => '|| l_mmtt_rec.transaction_temp_id,l_module_name,4);
3003: print_debug('p_operation_type_id => '|| l_operation_type_id,l_module_name,4);
3004: print_debug('p_next_operation_type_id => '|| '',l_module_name,4);

Line 3011: wms_op_inbound_pvt.complete

3007: END IF;
3008:
3009: l_progress := 100;
3010:
3011: wms_op_inbound_pvt.complete
3012: (
3013: x_return_status => l_return_status
3014: , x_msg_data => l_msg_data
3015: , x_msg_count => l_msg_count

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

3026:
3027: l_progress := 102;
3028:
3029: IF (l_debug=1) THEN
3030: print_debug('Inbound op plan null - After calling wms_op_inbound_pvt.complete. ', l_module_name,4);
3031:
3032: print_debug('x_return_status => '||l_return_status, l_module_name,4);
3033: print_debug('x_msg_data => '||l_msg_data, l_module_name,4);
3034: print_debug('x_msg_count => '||l_msg_count, l_module_name,4);

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

3037: END IF;
3038: --bug 6924639
3039: IF l_return_status = fnd_api.g_ret_sts_unexp_error THEN
3040: IF (l_debug = 1) THEN
3041: print_debug('Inbound op plan null - wms_op_inbound_pvt.complete finished with error. l_return_status = ' || l_return_status,l_module_name,4);
3042: END IF;
3043:
3044: fnd_message.set_name('WMS', 'WMS_WORK_FLOW_FAIL');
3045: fnd_msg_pub.ADD;

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

3045: fnd_msg_pub.ADD;
3046: RAISE fnd_api.g_exc_unexpected_error;
3047: ELSIF l_return_status = fnd_api.g_ret_sts_error THEN
3048: IF (l_debug = 1) THEN
3049: print_debug('Inbound op plan null - wms_op_inbound_pvt.complete finished with error. l_return_status = ' || l_return_status,l_module_name,4);
3050: END IF;
3051:
3052: fnd_message.set_name('WMS', 'WMS_WORK_FLOW_FAIL');
3053: fnd_msg_pub.ADD;

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

3056: --bug 6924639
3057: /*
3058: IF l_return_status <>FND_API.g_ret_sts_success THEN
3059: IF (l_debug=1) THEN
3060: print_debug('Inbound op plan null - wms_op_inbound_pvt.complete finished with error. l_return_status = ' || l_return_status,l_module_name,4);
3061: END IF;
3062:
3063: RAISE FND_API.G_EXC_ERROR;
3064: END IF;

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

3312:
3313:
3314: IF (l_debug=1) THEN
3315:
3316: print_debug('Unforgivable error - Before calling wms_op_inbound_pvt.complete with following parameters:',l_module_name,4);
3317: print_debug('p_source_task_id => '|| p_source_task_id,l_module_name,4);
3318: print_debug('p_document_rec.transaction_temp_id => '|| l_mmtt_rec.transaction_temp_id,l_module_name,4);
3319: print_debug('p_operation_type_id => '|| l_operation_type_id,l_module_name,4);
3320: print_debug('p_next_operation_type_id => '|| '',l_module_name,4);

Line 3326: wms_op_inbound_pvt.complete

3322:
3323: END IF;
3324:
3325:
3326: wms_op_inbound_pvt.complete
3327: (
3328: x_return_status => l_return_status
3329: , x_msg_data => l_msg_data
3330: , x_msg_count => l_msg_count

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

3340: );
3341:
3342:
3343: IF (l_debug=1) THEN
3344: print_debug('Unforgivable Error - After calling wms_op_inbound_pvt.complete. ', l_module_name,4);
3345:
3346: print_debug('x_return_status => '||l_return_status, l_module_name,4);
3347: print_debug('x_msg_data => '||l_msg_data, l_module_name,4);
3348: print_debug('x_msg_count => '||l_msg_count, l_module_name,4);

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

3351: END IF;
3352: --bug 6924639
3353: IF l_return_status = fnd_api.g_ret_sts_unexp_error THEN
3354: IF (l_debug = 1) THEN
3355: print_debug('Unforgivable Error - wms_op_inbound_pvt.complete finished with error. l_return_status = ' || l_return_status,l_module_name,4);
3356: END IF;
3357:
3358: fnd_message.set_name('WMS', 'WMS_WORK_FLOW_FAIL');
3359: fnd_msg_pub.ADD;

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

3359: fnd_msg_pub.ADD;
3360: RAISE fnd_api.g_exc_unexpected_error;
3361: ELSIF l_return_status = fnd_api.g_ret_sts_error THEN
3362: IF (l_debug = 1) THEN
3363: print_debug('Unforgivable Error - wms_op_inbound_pvt.complete finished with error. l_return_status = ' || l_return_status,l_module_name,4);
3364: END IF;
3365:
3366: fnd_message.set_name('WMS', 'WMS_WORK_FLOW_FAIL');
3367: fnd_msg_pub.ADD;

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

3370: --bug 6924639
3371: /*
3372: IF l_return_status <>FND_API.g_ret_sts_success THEN
3373: IF (l_debug=1) THEN
3374: print_debug('Unforgivable Error - wms_op_inbound_pvt.complete finished with error. l_return_status = ' || l_return_status,l_module_name,4);
3375: END IF;
3376:
3377: RAISE FND_API.G_EXC_ERROR;
3378: END IF;

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

3553:
3554:
3555: IF (l_debug=1) THEN
3556:
3557: print_debug('Last operation in plan and inbound - Before calling wms_op_inbound_pvt.complete with following parameters:',l_module_name,4);
3558: print_debug('p_source_task_id => '|| p_source_task_id,l_module_name,4);
3559: print_debug('p_document_rec.transaction_temp_id => '|| l_mmtt_rec.transaction_temp_id,l_module_name,4);
3560: print_debug('p_operation_type_id => '|| l_operation_type_id,l_module_name,4);
3561: print_debug('p_next_operation_type_id => '|| '',l_module_name,4);

Line 3568: wms_op_inbound_pvt.complete

3564: END IF;
3565:
3566: l_progress := 180;
3567:
3568: wms_op_inbound_pvt.complete
3569: (
3570: x_return_status => l_return_status
3571: , x_msg_data => l_msg_data
3572: , x_msg_count => l_msg_count

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

3583:
3584: l_progress := 190;
3585:
3586: IF (l_debug=1) THEN
3587: print_debug('Last operation in plan - After calling wms_op_inbound_pvt.complete. ', l_module_name,4);
3588:
3589: print_debug('x_return_status => '||l_return_status, l_module_name,4);
3590: print_debug('x_msg_data => '||l_msg_data, l_module_name,4);
3591: print_debug('x_msg_count => '||l_msg_count, l_module_name,4);

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

3594: END IF;
3595: --bug 6924639
3596: IF l_return_status = fnd_api.g_ret_sts_unexp_error THEN
3597: IF (l_debug = 1) THEN
3598: print_debug('Inbound op plan null - wms_op_inbound_pvt.complete finished with error. l_return_status = ' || l_return_status,l_module_name,4);
3599: END IF;
3600:
3601: fnd_message.set_name('WMS', 'WMS_WORK_FLOW_FAIL');
3602: fnd_msg_pub.ADD;

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

3602: fnd_msg_pub.ADD;
3603: RAISE fnd_api.g_exc_unexpected_error;
3604: ELSIF l_return_status = fnd_api.g_ret_sts_error THEN
3605: IF (l_debug = 1) THEN
3606: print_debug('Inbound op plan null - wms_op_inbound_pvt.complete finished with error. l_return_status = ' || l_return_status,l_module_name,4);
3607: END IF;
3608:
3609: fnd_message.set_name('WMS', 'WMS_WORK_FLOW_FAIL');
3610: fnd_msg_pub.ADD;

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

3613: --bug 6924639
3614: /*
3615: IF l_return_status <>FND_API.g_ret_sts_success THEN
3616: IF (l_debug=1) THEN
3617: print_debug('Last operation in plan - wms_op_inbound_pvt.complete finished with error. l_return_status = ' || l_return_status,l_module_name,4);
3618: END IF;
3619:
3620: RAISE FND_API.G_EXC_ERROR;
3621: END IF;

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

3693: IF p_activity_id = g_op_activity_inbound THEN
3694:
3695:
3696: IF (l_debug=1) THEN
3697: print_debug('NOT Last operation in plan and inbound - Before calling wms_op_inbound_pvt.complete with following parameters:',l_module_name,4);
3698: print_debug('p_source_task_id => '|| p_source_task_id,l_module_name,4);
3699: print_debug('p_document_rec.transaction_temp_id => '|| l_mmtt_rec.transaction_temp_id,l_module_name,4);
3700: print_debug('p_operation_type_id => '|| l_operation_type_id,l_module_name,4);
3701: print_debug('p_next_operation_type_id => '|| l_operation_plan_detail_rec.operation_type, l_module_name,4);

Line 3713: wms_op_inbound_pvt.complete

3709:
3710: }}
3711: */
3712:
3713: wms_op_inbound_pvt.complete
3714: (
3715: x_return_status => l_return_status
3716: , x_msg_data => l_msg_data
3717: , x_msg_count => l_msg_count

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

3729:
3730: l_progress := 230;
3731:
3732: IF (l_debug=1) THEN
3733: print_debug('NOT Last operation in plan - After calling wms_op_inbound_pvt.complete. ', l_module_name,4);
3734:
3735: print_debug('x_return_status => '||l_return_status, l_module_name,4);
3736: print_debug('x_msg_data => '||l_msg_data, l_module_name,4);
3737: print_debug('x_msg_count => '||l_msg_count, l_module_name,4);

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

3739: print_debug('x_error_code => '||l_atf_error_code, l_module_name,4);
3740: END IF;
3741: IF l_return_status = fnd_api.g_ret_sts_unexp_error THEN
3742: IF (l_debug = 1) THEN
3743: print_debug('Inbound op plan null - wms_op_inbound_pvt.complete finished with error. l_return_status = ' || l_return_status,l_module_name,4);
3744: END IF;
3745:
3746: fnd_message.set_name('WMS', 'WMS_WORK_FLOW_FAIL');
3747: fnd_msg_pub.ADD;

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

3747: fnd_msg_pub.ADD;
3748: RAISE fnd_api.g_exc_unexpected_error;
3749: ELSIF l_return_status = fnd_api.g_ret_sts_error THEN
3750: IF (l_debug = 1) THEN
3751: print_debug('Inbound op plan null - wms_op_inbound_pvt.complete finished with error. l_return_status = ' || l_return_status,l_module_name,4);
3752: END IF;
3753:
3754: fnd_message.set_name('WMS', 'WMS_WORK_FLOW_FAIL');
3755: fnd_msg_pub.ADD;

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

6490:
6491: IF l_wdt_status = g_task_status_loaded THEN
6492:
6493: IF (l_debug = 1) THEN
6494: print_debug('l_wdt_status = '||g_task_status_loaded||', Drop operation, call WMS_OP_INBOUND_PVT.cleanup with following parameters: ',l_module_name,4);
6495: print_debug('p_source_task_id => ' || p_source_task_id,l_module_name,4);
6496: END IF;
6497:
6498: l_progress := 72;

Line 6502: wms_op_inbound_pvt.cleanup

6498: l_progress := 72;
6499:
6500: -- This call will cleanup wms_task_type (-1 -> 2) and lpn columns
6501:
6502: wms_op_inbound_pvt.cleanup
6503: (
6504: x_return_status => l_return_status
6505: , x_msg_data => l_msg_data
6506: , x_msg_count => l_msg_count

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

6509:
6510: l_progress := 74;
6511:
6512: IF (l_debug=1) THEN
6513: print_debug('After calling wms_op_inbound_pvt.cleanup.',l_module_name,4);
6514: print_debug('x_return_status => '|| l_return_status,l_module_name,4);
6515: print_debug('x_msg_count => '|| l_msg_count,l_module_name,4);
6516: print_debug('x_msg_data => '|| l_msg_data,l_module_name,4);
6517: END IF;

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

6517: END IF;
6518:
6519: IF l_return_status <>FND_API.g_ret_sts_success THEN
6520: IF (l_debug=1) THEN
6521: print_debug('wms_op_inbound_pvt.cleanup finished with error. l_return_status = ' || l_return_status,l_module_name,4);
6522: END IF;
6523:
6524: RAISE FND_API.G_EXC_ERROR;
6525: END IF;

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

6667:
6668:
6669: IF l_wooi_data_rec.operation_type_id = g_op_type_drop THEN
6670: IF (l_debug = 1) THEN
6671: print_debug('Drop operation, call WMS_OP_INBOUND_PVT.cleanup with following parameters: ',l_module_name,4);
6672: print_debug('p_source_task_id => ' || p_source_task_id,l_module_name,4);
6673: END IF;
6674:
6675: l_progress := 170;

Line 6677: wms_op_inbound_pvt.cleanup

6673: END IF;
6674:
6675: l_progress := 170;
6676:
6677: wms_op_inbound_pvt.cleanup
6678: (
6679: x_return_status => l_return_status
6680: , x_msg_data => l_msg_data
6681: , x_msg_count => l_msg_count

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

6684:
6685: l_progress := 180;
6686:
6687: IF (l_debug=1) THEN
6688: print_debug('After calling wms_op_inbound_pvt.cleanup.',l_module_name,4);
6689: print_debug('x_return_status => '|| l_return_status,l_module_name,4);
6690: print_debug('x_msg_count => '|| l_msg_count,l_module_name,4);
6691: print_debug('x_msg_data => '|| l_msg_data,l_module_name,4);
6692: END IF;

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

6692: END IF;
6693:
6694: IF l_return_status <>FND_API.g_ret_sts_success THEN
6695: IF (l_debug=1) THEN
6696: print_debug('wms_op_inbound_pvt.cleanup finished with error. l_return_status = ' || l_return_status,l_module_name,4);
6697: END IF;
6698:
6699: RAISE FND_API.G_EXC_ERROR;
6700: END IF;

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

7102: l_progress:=180;
7103:
7104: IF (l_debug=1) THEN
7105: print_debug('Inbound activity. ',l_module_name,4);
7106: print_debug('Before calling wms_op_inbound_pvt.cancel with following parameters: ' ,l_module_name,4);
7107: print_debug('p_source_task_id => '|| p_source_task_id,l_module_name,4);
7108:
7109: END IF;
7110:

Line 7111: wms_op_inbound_pvt.cancel

7107: print_debug('p_source_task_id => '|| p_source_task_id,l_module_name,4);
7108:
7109: END IF;
7110:
7111: wms_op_inbound_pvt.cancel
7112: (
7113: x_return_status => x_return_status,
7114: x_msg_data => x_msg_data,
7115: x_msg_count => x_msg_count,

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

7119: p_mmtt_error_explanation => p_mmtt_error_explanation
7120: );
7121:
7122: IF (l_debug=1) THEN
7123: print_debug('After calling wms_op_inbound_pvt.cancel.' ,l_module_name,4);
7124: print_debug('x_return_status => '|| x_return_status,l_module_name,4);
7125: print_debug('x_msg_data => '|| x_msg_data,l_module_name,4);
7126: print_debug('x_msg_count => '|| x_msg_count,l_module_name,4);
7127: END IF;

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

7127: END IF;
7128:
7129: IF x_return_status <>FND_API.g_ret_sts_success THEN
7130: IF (l_debug=1) THEN
7131: print_debug('wms_op_inbound_pvt.cancel finished with error. x_return_status = ' || x_return_status,l_module_name,4);
7132: END IF;
7133:
7134: RAISE FND_API.G_EXC_ERROR;
7135: END IF;

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

7631: l_document_rec.inventory_item_id := l_inbound_doc.inventory_item_id;
7632: l_document_rec.primary_quantity := l_inbound_doc.primary_quantity;
7633:
7634: IF l_debug=1 THEN
7635: print_debug('Before calling wms_op_inbound_pvt.ABORT with following parameters:',l_module_name,4);
7636: print_debug('l_document_rec.transaction_temp_id => '|| l_document_rec.transaction_temp_id,l_module_name,4);
7637: print_debug('l_document_rec.parent_line_id => '||l_document_rec.parent_line_id,l_module_name,4);
7638: print_debug('l_document_rec.locator_id => '||l_document_rec.locator_id,l_module_name,4);
7639: print_debug('l_document_rec.transfer_to_location => '||l_document_rec.transfer_to_location,l_module_name,4);

Line 7651: wms_op_inbound_pvt.ABORT

7647:
7648: END IF;
7649:
7650:
7651: wms_op_inbound_pvt.ABORT
7652: (x_return_status => l_return_status,
7653: x_msg_data => l_msg_data,
7654: x_msg_count => l_msg_count,
7655: p_document_rec => l_document_rec,

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

7658: p_for_manual_drop => p_for_manual_drop
7659: );
7660:
7661: IF l_debug=1 THEN
7662: print_debug('After calling wms_op_inbound_pvt.ABORT:',l_module_name,4);
7663: print_debug('x_return_status => '||l_return_status,l_module_name,4);
7664: print_debug('x_msg_data => '||l_msg_data,l_module_name,4);
7665: print_debug('x_msg_count => '||l_msg_count,l_module_name,4);
7666: END IF;

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

7666: END IF;
7667:
7668: IF l_return_status <> FND_API.g_ret_sts_success THEN
7669: IF (l_debug=1) THEN
7670: print_debug(' wms_op_inbound_pvt.ABORT finished with error. l_return_status = ' || l_return_status,l_module_name,4);
7671: END IF;
7672:
7673: RAISE FND_API.G_EXC_ERROR;
7674: END IF;

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

7954:
7955: l_progress := 40;
7956:
7957:
7958: -- Moved delete WDT to after WMS_OP_INBOUND_PVT.Cleanup
7959:
7960:
7961: /* Query the document tables based on p_source_taks_id and p_activity_id and populate the document record.
7962: * If p_activity_id=INBOUND then

Line 8000: WMS_OP_INBOUND_PVT.Cleanup

7996: END IF;
7997: /* for bug#5997558 */
7998: IF p_activity_type_id =G_OP_ACTIVITY_INBOUND THEN
7999:
8000: WMS_OP_INBOUND_PVT.Cleanup
8001: ( x_return_status => x_return_status
8002: , x_msg_data => x_msg_data
8003: , x_msg_count => x_msg_count
8004: , p_source_task_id => p_source_task_id

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

8020:
8021: /* End for bug#5997558 */
8022:
8023: -- Before we return, we should delete WDT here
8024: -- since now we delete WDT after calling WMS_OP_INBOUND_PVT.Cleanup at the end.
8025:
8026: DELETE FROM WMS_DISPATCHED_TASKS
8027: WHERE transaction_temp_id = p_source_task_id
8028: AND task_id = l_wdt_details.task_id;

Line 8253: * Call WMS_OP_INBOUND_PVT.Cleanup

8249:
8250: END IF;/*First Operation in Plan*/
8251:
8252: /*If p_activity_id =INBOUND then
8253: * Call WMS_OP_INBOUND_PVT.Cleanup
8254: *End If;
8255: */
8256: l_progress :=160;
8257: IF p_activity_type_id =G_OP_ACTIVITY_INBOUND THEN

Line 8259: WMS_OP_INBOUND_PVT.Cleanup

8255: */
8256: l_progress :=160;
8257: IF p_activity_type_id =G_OP_ACTIVITY_INBOUND THEN
8258:
8259: WMS_OP_INBOUND_PVT.Cleanup
8260: ( x_return_status => x_return_status
8261: , x_msg_data => x_msg_data
8262: , x_msg_count => x_msg_count
8263: , p_source_task_id => p_source_task_id

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

8277: END IF;
8278:
8279:
8280: /* Deleting the WDT record as the status is being reverted to Load Pending */
8281: -- Moved delete WDT to after calling WMS_OP_INBOUND_PVT.Cleanup
8282: -- because WMS_OP_INBOUND_PVT.Cleanup now calls putaway_cleanup, which assumes WDT still exists.
8283:
8284: DELETE FROM WMS_DISPATCHED_TASKS
8285: WHERE transaction_temp_id = p_source_task_id

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

8278:
8279:
8280: /* Deleting the WDT record as the status is being reverted to Load Pending */
8281: -- Moved delete WDT to after calling WMS_OP_INBOUND_PVT.Cleanup
8282: -- because WMS_OP_INBOUND_PVT.Cleanup now calls putaway_cleanup, which assumes WDT still exists.
8283:
8284: DELETE FROM WMS_DISPATCHED_TASKS
8285: WHERE transaction_temp_id = p_source_task_id
8286: AND task_id = l_wdt_details.task_id;