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_RUNTIME_PVT_APIS

Line 531: /*Call WMS_OP_PLAN_INSTANCES table handler, WMS_OP_RUNTIME_PVT_APIS.INSERT_OPERATION_PLAN_INSTANCE,

527: print_debug('Orig_dest_sub_code ==>'||l_op_plan_instance_rec.orig_dest_sub_code,l_module_name,4);
528: print_debug('Orig_dest_loc_id ==>'||l_op_plan_instance_rec.orig_dest_loc_id,l_module_name,4);
529: END IF;
530:
531: /*Call WMS_OP_PLAN_INSTANCES table handler, WMS_OP_RUNTIME_PVT_APIS.INSERT_OPERATION_PLAN_INSTANCE,
532: to insert record into the WMS_OP_PLAN_INSTANCES table.*/
533:
534: WMS_OP_RUNTIME_PVT_APIS.INSERT_PLAN_INSTANCE(
535: x_return_status => x_return_status ,

Line 534: WMS_OP_RUNTIME_PVT_APIS.INSERT_PLAN_INSTANCE(

530:
531: /*Call WMS_OP_PLAN_INSTANCES table handler, WMS_OP_RUNTIME_PVT_APIS.INSERT_OPERATION_PLAN_INSTANCE,
532: to insert record into the WMS_OP_PLAN_INSTANCES table.*/
533:
534: WMS_OP_RUNTIME_PVT_APIS.INSERT_PLAN_INSTANCE(
535: x_return_status => x_return_status ,
536: x_msg_count => x_msg_count ,
537: x_msg_data => x_msg_data ,
538: p_insert_rec => l_op_plan_instance_rec );

Line 589: /*Call WMS_OP_OPERATION_INSTANCES table handler, WMS_OP_RUNTIME_PVT_APIS.INSERT_OPERATION_INSTANCE,

585: print_debug('operation_type_id ==>'||l_operation_instance_rec.operation_type_id,l_module_name,4);
586: print_debug('Source Task Id ==>'||l_operation_instance_rec.source_task_id,l_module_name,4);
587: END IF;
588:
589: /*Call WMS_OP_OPERATION_INSTANCES table handler, WMS_OP_RUNTIME_PVT_APIS.INSERT_OPERATION_INSTANCE,
590: to insert record into the WMS_OP_OPERATION_INSTANCES table.*/
591:
592: WMS_OP_RUNTIME_PVT_APIS.insert_operation_instance
593: ( x_return_status => x_return_status,

Line 592: WMS_OP_RUNTIME_PVT_APIS.insert_operation_instance

588:
589: /*Call WMS_OP_OPERATION_INSTANCES table handler, WMS_OP_RUNTIME_PVT_APIS.INSERT_OPERATION_INSTANCE,
590: to insert record into the WMS_OP_OPERATION_INSTANCES table.*/
591:
592: WMS_OP_RUNTIME_PVT_APIS.insert_operation_instance
593: ( x_return_status => x_return_status,
594: x_msg_count => x_msg_count,
595: x_msg_data => x_msg_data,
596: p_insert_rec => l_operation_instance_rec

Line 2006: WMS_OP_RUNTIME_PVT_APIS.Insert_Dispatched_tasks_nauto

2002:
2003: -- 14284768
2004: IF l_task_del_flag = 1 THEN
2005:
2006: WMS_OP_RUNTIME_PVT_APIS.Insert_Dispatched_tasks_nauto
2007: ( p_wdt_rec => l_wdt_rec,
2008: p_source_task_id => p_source_task_id,
2009: x_return_status => x_return_status,
2010: x_msg_count => x_msg_count,

Line 2016: WMS_OP_RUNTIME_PVT_APIS.insert_dispatched_tasks

2012: );
2013:
2014: ELSE
2015:
2016: WMS_OP_RUNTIME_PVT_APIS.insert_dispatched_tasks
2017: ( p_wdt_rec => l_wdt_rec,
2018: p_source_task_id => p_source_task_id,
2019: x_return_status => x_return_status,
2020: x_msg_count => x_msg_count,

Line 2144: WMS_OP_RUNTIME_PVT_APIS.Insert_Dispatched_tasks_nauto

2140:
2141: -- 14284768
2142: IF l_task_del_flag = 1 THEN
2143:
2144: WMS_OP_RUNTIME_PVT_APIS.Insert_Dispatched_tasks_nauto
2145: ( p_wdt_rec => l_wdt_rec,
2146: p_source_task_id => p_source_task_id,
2147: x_return_status => x_return_status,
2148: x_msg_count => x_msg_count,

Line 2154: WMS_OP_RUNTIME_PVT_APIS.insert_dispatched_tasks

2150: );
2151:
2152: ELSE
2153:
2154: WMS_OP_RUNTIME_PVT_APIS.insert_dispatched_tasks
2155: ( p_wdt_rec => l_wdt_rec,
2156: p_source_task_id => p_source_task_id,
2157: x_return_status => x_return_status,
2158: x_msg_count => x_msg_count,

Line 2290: print_debug('Calling WMS_OP_RUNTIME_PVT_APIS.UPDATE_PLAN_INSTANCE to update the foll values',l_module_name,9);

2286:
2287: l_progress:=170;
2288:
2289: IF (l_debug=1) THEN
2290: print_debug('Calling WMS_OP_RUNTIME_PVT_APIS.UPDATE_PLAN_INSTANCE to update the foll values',l_module_name,9);
2291: print_debug('Status'||l_wopi_rec.status,l_module_name,9);
2292: print_debug('Plan Instance Id'||l_wopi_rec.op_plan_instance_id,l_module_name,9);
2293:
2294: END IF;

Line 2296: WMS_OP_RUNTIME_PVT_APIS.UPDATE_PLAN_INSTANCE

2292: print_debug('Plan Instance Id'||l_wopi_rec.op_plan_instance_id,l_module_name,9);
2293:
2294: END IF;
2295:
2296: WMS_OP_RUNTIME_PVT_APIS.UPDATE_PLAN_INSTANCE
2297: ( p_update_rec => l_wopi_rec
2298: ,x_return_status => x_return_status
2299: ,x_msg_count => x_msg_count
2300: ,x_msg_data => x_msg_data);

Line 2425: WMS_OP_RUNTIME_PVT_APIS.UPDATE_OPERATION_INSTANCE

2421: END IF;/*Activity Inbound and Drop Operation*/
2422:
2423: l_progress:=240;
2424:
2425: WMS_OP_RUNTIME_PVT_APIS.UPDATE_OPERATION_INSTANCE
2426: ( x_return_status => l_return_status --Use l_return_status instead
2427: , x_msg_count => l_msg_count --of x_return_status because
2428: , x_msg_data => l_msg_data --it will override the value
2429: , p_update_rec => l_wooi_rec); --returned from determine_attributes

Line 2875: print_debug('Before calling wms_op_runtime_pvt_apis.archive_dispatched_tasks with following parameters' ,l_module_name,4);

2871: IF (l_debug=1) THEN
2872: print_debug('Current operation is inspect.' ,l_module_name,4);
2873: print_debug('Set l_operation_type_id to inspect.' ,l_module_name,4);
2874:
2875: print_debug('Before calling wms_op_runtime_pvt_apis.archive_dispatched_tasks with following parameters' ,l_module_name,4);
2876: print_debug('p_task_id => '|| l_wdt_task_id,l_module_name,4);
2877: print_debug('p_source_task_id => '|| p_source_task_id,l_module_name,4);
2878: print_debug('p_activity_type_id => '|| p_activity_id,l_module_name,4);
2879: END IF;

Line 2885: wms_op_runtime_pvt_apis.archive_dispatched_tasks

2881: l_operation_type_id := g_op_type_inspect;
2882:
2883: l_progress := 40;
2884:
2885: wms_op_runtime_pvt_apis.archive_dispatched_tasks
2886: (
2887: x_return_status => l_return_status
2888: , x_msg_count => l_msg_count
2889: , x_msg_data => l_msg_data

Line 2900: print_debug('After calling wms_op_runtime_pvt_apis.archive_dispatched_tasks .' ,l_module_name,4);

2896:
2897: l_progress := 50;
2898:
2899: IF (l_debug=1) THEN
2900: print_debug('After calling wms_op_runtime_pvt_apis.archive_dispatched_tasks .' ,l_module_name,4);
2901: print_debug('x_return_status => '|| l_return_status,l_module_name,4);
2902: print_debug('x_msg_count => '|| l_msg_count,l_module_name,4);
2903: print_debug('x_msg_data => '|| l_msg_data,l_module_name,4);
2904: END IF;

Line 2909: print_debug('wms_op_runtime_pvt_apis.archive_dispatched_tasks finished with error. l_return_status = ' || l_return_status,l_module_name,4);

2905:
2906:
2907: IF l_return_status <>FND_API.g_ret_sts_success THEN
2908: IF (l_debug=1) THEN
2909: print_debug('wms_op_runtime_pvt_apis.archive_dispatched_tasks finished with error. l_return_status = ' || l_return_status,l_module_name,4);
2910: END IF;
2911: fnd_message.set_name('WMS', 'WMS_ATF_ARCHIVE_TASK_FAILURE');
2912: fnd_msg_pub.ADD;
2913: RAISE FND_API.G_EXC_ERROR;

Line 2966: print_debug('Drop - Before calling wms_op_runtime_pvt_apis.archive_dispatched_tasks with following parameters' ,l_module_name,4);

2962: l_operation_type_id := g_op_type_drop;
2963:
2964: IF (l_debug=1) THEN
2965:
2966: print_debug('Drop - Before calling wms_op_runtime_pvt_apis.archive_dispatched_tasks with following parameters' ,l_module_name,4);
2967: print_debug('p_task_id => '|| l_wdt_task_id,l_module_name,4);
2968: print_debug('p_source_task_id => '|| p_source_task_id,l_module_name,4);
2969: print_debug('p_activity_type_id => '|| p_activity_id,l_module_name,4);
2970: END IF;

Line 2974: wms_op_runtime_pvt_apis.archive_dispatched_tasks

2970: END IF;
2971:
2972: l_progress := 80;
2973:
2974: wms_op_runtime_pvt_apis.archive_dispatched_tasks
2975: (
2976: x_return_status => l_return_status
2977: , x_msg_count => l_msg_count
2978: , x_msg_data => l_msg_data

Line 2989: print_debug('Drop - After calling wms_op_runtime_pvt_apis.archive_dispatched_tasks .' ,l_module_name,4);

2985:
2986: l_progress := 90;
2987:
2988: IF (l_debug=1) THEN
2989: print_debug('Drop - After calling wms_op_runtime_pvt_apis.archive_dispatched_tasks .' ,l_module_name,4);
2990: print_debug('x_return_status => '|| l_return_status,l_module_name,4);
2991: print_debug('x_msg_count => '|| l_msg_count,l_module_name,4);
2992: print_debug('x_msg_data => '|| l_msg_data,l_module_name,4);
2993: END IF;

Line 2998: print_debug('Drop - wms_op_runtime_pvt_apis.archive_dispatched_tasks finished with error. l_return_status = ' || l_return_status,l_module_name,4);

2994:
2995:
2996: IF l_return_status <>FND_API.g_ret_sts_success THEN
2997: IF (l_debug=1) THEN
2998: print_debug('Drop - wms_op_runtime_pvt_apis.archive_dispatched_tasks finished with error. l_return_status = ' || l_return_status,l_module_name,4);
2999: END IF;
3000: fnd_message.set_name('WMS', 'WMS_ATF_ARCHIVE_TASK_FAILURE');
3001: fnd_msg_pub.ADD;
3002: RAISE FND_API.G_EXC_ERROR;

Line 3472: print_debug('Before calling wms_op_runtime_pvt_apis.update_operation_instance with following parameters: ',l_module_name,4);

3468: END IF; -- IF l_operation_type_id = g_op_type_drop T
3469:
3470:
3471: IF (l_debug=1) THEN
3472: print_debug('Before calling wms_op_runtime_pvt_apis.update_operation_instance with following parameters: ',l_module_name,4);
3473: print_debug('l_wooi_rec.operation_instance_id => '|| l_wooi_rec.operation_instance_id,l_module_name,4);
3474: print_debug('l_wooi_rec.operation_status => '|| l_wooi_rec.operation_status,l_module_name,4);
3475: print_debug('l_wooi_rec.complete_time => '|| To_char(l_wooi_rec.complete_time),l_module_name,4);
3476: print_debug('l_wooi_rec.to_subinventory_code => '|| l_wooi_rec.to_subinventory_code,l_module_name,4);

Line 3484: wms_op_runtime_pvt_apis.update_operation_instance

3480: END IF;
3481:
3482: l_progress := 120;
3483:
3484: wms_op_runtime_pvt_apis.update_operation_instance
3485: (x_return_status => l_return_status
3486: , x_msg_count => l_msg_count
3487: , x_msg_data => l_msg_data
3488: , p_update_rec => l_wooi_rec);

Line 3493: print_debug('After calling wms_op_runtime_pvt_apis.update_operation_instance: ' ,l_module_name,4);

3489:
3490: l_progress := 130;
3491:
3492: IF (l_debug=1) THEN
3493: print_debug('After calling wms_op_runtime_pvt_apis.update_operation_instance: ' ,l_module_name,4);
3494: print_debug('x_return_status => '|| l_return_status,l_module_name,4);
3495: print_debug('x_msg_count => '|| l_msg_count,l_module_name,4);
3496: print_debug('x_msg_data => '|| l_msg_data,l_module_name,4);
3497: END IF;

Line 3501: print_debug('wms_op_runtime_pvt_apis.update_operation_instance finished with error. l_return_status = ' || l_return_status,l_module_name,4);

3497: END IF;
3498:
3499: IF l_return_status <>FND_API.g_ret_sts_success THEN
3500: IF (l_debug=1) THEN
3501: print_debug('wms_op_runtime_pvt_apis.update_operation_instance finished with error. l_return_status = ' || l_return_status,l_module_name,4);
3502: END IF;
3503:
3504: RAISE FND_API.G_EXC_ERROR;
3505: END IF;

Line 3517: print_debug('Before calling wms_op_runtime_pvt_apis.archive_dispatched_tasks with following parameters : ' , l_module_name,4);

3513:
3514: -- this is the last operation in the plan
3515: IF (l_debug=1) THEN
3516: print_debug('Current operation is the last step of the operation plan.',l_module_name,4);
3517: print_debug('Before calling wms_op_runtime_pvt_apis.archive_dispatched_tasks with following parameters : ' , l_module_name,4);
3518: print_debug('p_task_id => '||'', l_module_name,4);
3519: print_debug('p_source_task_id => '||l_mmtt_rec.parent_line_id, l_module_name,4);
3520: print_debug('p_activity_type_id => '||p_activity_id, l_module_name,4);
3521: print_debug('p_op_plan_instance_id => '||l_wooi_data_rec.op_plan_instance_id, l_module_name,4);

Line 3526: wms_op_runtime_pvt_apis.archive_dispatched_tasks

3522: print_debug('p_op_plan_status => '||G_OP_INS_STAT_COMPLETED,l_module_name,4);
3523: END IF;
3524:
3525: -- Need to archive the parent MMTT record into WDTH
3526: wms_op_runtime_pvt_apis.archive_dispatched_tasks
3527: (
3528: x_return_status => l_return_status
3529: , x_msg_count => l_msg_count
3530: , x_msg_data => l_msg_data

Line 3539: print_debug('After calling wms_op_runtime_pvt_apis.archive_dispatched_tasks.',l_module_name,4);

3535: , p_op_plan_status => G_OP_INS_STAT_COMPLETED
3536: );
3537:
3538: IF (l_debug=1) THEN
3539: print_debug('After calling wms_op_runtime_pvt_apis.archive_dispatched_tasks.',l_module_name,4);
3540: print_debug('x_return_status => '|| l_return_status,l_module_name,4);
3541: print_debug('x_msg_count => '|| l_msg_count,l_module_name,4);
3542: print_debug('x_msg_data => '|| l_msg_data,l_module_name,4);
3543:

Line 3548: print_debug('Last operation: archive parent MMTT - wms_op_runtime_pvt_apis.archive_dispatched_tasks finished with error. l_return_status = ' || l_return_status,l_module_name,4);

3544: END IF;
3545:
3546: IF l_return_status <>FND_API.g_ret_sts_success THEN
3547: IF (l_debug=1) THEN
3548: print_debug('Last operation: archive parent MMTT - wms_op_runtime_pvt_apis.archive_dispatched_tasks finished with error. l_return_status = ' || l_return_status,l_module_name,4);
3549: END IF;
3550: fnd_message.set_name('WMS', 'WMS_ATF_ARCHIVE_TASK_FAILURE');
3551: fnd_msg_pub.ADD;
3552: RAISE FND_API.G_EXC_ERROR;

Line 3556: print_debug('Before calling wms_op_runtime_pvt_apis.complete_plan_instance with following parameters:', l_module_name,4);

3552: RAISE FND_API.G_EXC_ERROR;
3553: END IF;
3554:
3555: IF (l_debug=1) THEN
3556: print_debug('Before calling wms_op_runtime_pvt_apis.complete_plan_instance with following parameters:', l_module_name,4);
3557: print_debug('p_op_plan_instance_id => '||l_wooi_data_rec.op_plan_instance_id, l_module_name,4);
3558: END IF;
3559:
3560: -- Complete the operation plan instance

Line 3563: wms_op_runtime_pvt_apis.complete_plan_instance

3559:
3560: -- Complete the operation plan instance
3561: l_progress := 160;
3562:
3563: wms_op_runtime_pvt_apis.complete_plan_instance
3564: (x_return_status => l_return_status,
3565: x_msg_data => l_msg_data,
3566: x_msg_count => l_msg_count,
3567: p_op_plan_instance_id => l_wooi_data_rec.op_plan_instance_id

Line 3573: print_debug('After calling wms_op_runtime_pvt_apis.complete_plan_instance. ', l_module_name,4);

3569:
3570: l_progress := 170;
3571:
3572: IF (l_debug=1) THEN
3573: print_debug('After calling wms_op_runtime_pvt_apis.complete_plan_instance. ', l_module_name,4);
3574:
3575: print_debug('x_return_status => '||l_return_status, l_module_name,4);
3576: print_debug('x_msg_data => '||l_msg_data, l_module_name,4);
3577: print_debug('x_msg_count => '||l_msg_count, l_module_name,4);

Line 3582: print_debug('wms_op_runtime_pvt_apis.complete_plan_instance finished with error. l_return_status = ' || l_return_status,l_module_name,4);

3578: END IF;
3579:
3580: IF l_return_status <>FND_API.g_ret_sts_success THEN
3581: IF (l_debug=1) THEN
3582: print_debug('wms_op_runtime_pvt_apis.complete_plan_instance finished with error. l_return_status = ' || l_return_status,l_module_name,4);
3583: END IF;
3584:
3585: RAISE FND_API.G_EXC_ERROR;
3586: END IF;

Line 3811: print_debug('Before calling wms_op_runtime_pvt_apis.insert_operation_instance:' ,l_module_name,4);

3807:
3808: -- create next operation instance
3809:
3810: IF (l_debug=1) THEN
3811: print_debug('Before calling wms_op_runtime_pvt_apis.insert_operation_instance:' ,l_module_name,4);
3812: END IF;
3813:
3814: wms_op_runtime_pvt_apis.insert_operation_instance
3815: (

Line 3814: wms_op_runtime_pvt_apis.insert_operation_instance

3810: IF (l_debug=1) THEN
3811: print_debug('Before calling wms_op_runtime_pvt_apis.insert_operation_instance:' ,l_module_name,4);
3812: END IF;
3813:
3814: wms_op_runtime_pvt_apis.insert_operation_instance
3815: (
3816: x_return_status => l_return_status ,
3817: x_msg_count => x_msg_count ,
3818: x_msg_data => x_msg_data ,

Line 3822: print_debug('After calling wms_op_runtime_pvt_apis.insert_operation_instance:' ,l_module_name,4);

3818: x_msg_data => x_msg_data ,
3819: p_insert_rec => l_wooi_rec );
3820:
3821: IF (l_debug=1) THEN
3822: print_debug('After calling wms_op_runtime_pvt_apis.insert_operation_instance:' ,l_module_name,4);
3823: END IF;
3824:
3825: IF l_return_status <>FND_API.g_ret_sts_success THEN
3826: IF (l_debug=1) THEN

Line 3827: print_debug('wms_op_runtime_pvt_apis.insert_operation_instance finished with error. l_return_status = ' || l_return_status,l_module_name,4);

3823: END IF;
3824:
3825: IF l_return_status <>FND_API.g_ret_sts_success THEN
3826: IF (l_debug=1) THEN
3827: print_debug('wms_op_runtime_pvt_apis.insert_operation_instance finished with error. l_return_status = ' || l_return_status,l_module_name,4);
3828: END IF;
3829:
3830: RAISE FND_API.G_EXC_ERROR;
3831: END IF;

Line 5868: WMS_OP_RUNTIME_PVT_APIS.INSERT_PLAN_INSTANCE(

5864: l_progress := 170;
5865: --call wms_op_plan_instance table handler to insert l_wopi_split_rec INTO the table
5866:
5867: l_progress := 180;
5868: WMS_OP_RUNTIME_PVT_APIS.INSERT_PLAN_INSTANCE(
5869: x_return_status => x_return_status ,
5870: x_msg_count => x_msg_count ,
5871: x_msg_data => x_msg_data ,
5872: p_insert_rec => l_wopi_split_rec );

Line 6199: WMS_OP_RUNTIME_PVT_APIS.insert_operation_instance

6195: FROM dual;
6196: l_progress := 220;
6197:
6198: l_progress := 230;
6199: WMS_OP_RUNTIME_PVT_APIS.insert_operation_instance
6200: ( x_return_status => x_return_status,
6201: x_msg_count => x_msg_count,
6202: x_msg_data => x_msg_data,
6203: p_insert_rec => l_wooi_new_rec

Line 6695: print_debug('Before calling wms_op_runtime_pvt_apis.update_operation_instance with following parameters: ',l_module_name,4);

6691:
6692: -- Firs need to update current active operation instance to pending
6693:
6694: IF (l_debug=1) THEN
6695: print_debug('Before calling wms_op_runtime_pvt_apis.update_operation_instance with following parameters: ',l_module_name,4);
6696: print_debug('l_wooi_rec.operation_instance_id => '|| l_wooi_rec.operation_instance_id,l_module_name,4);
6697: print_debug('l_wooi_rec.operation_status => '|| l_wooi_rec.operation_status,l_module_name,4);
6698: END IF;
6699:

Line 6702: wms_op_runtime_pvt_apis.update_operation_instance

6698: END IF;
6699:
6700: l_progress := 120;
6701:
6702: wms_op_runtime_pvt_apis.update_operation_instance
6703: (x_return_status => l_return_status
6704: , x_msg_count => l_msg_count
6705: , x_msg_data => l_msg_data
6706: , p_update_rec => l_wooi_rec);

Line 6711: print_debug('After calling wms_op_runtime_pvt_apis.update_operation_instance: ' ,l_module_name,4);

6707:
6708: l_progress := 130;
6709:
6710: IF (l_debug=1) THEN
6711: print_debug('After calling wms_op_runtime_pvt_apis.update_operation_instance: ' ,l_module_name,4);
6712: print_debug('x_return_status => '|| l_return_status,l_module_name,4);
6713: print_debug('x_msg_count => '|| l_msg_count,l_module_name,4);
6714: print_debug('x_msg_data => '|| l_msg_data,l_module_name,4);
6715: END IF;

Line 6719: print_debug('wms_op_runtime_pvt_apis.update_operation_instance finished with error. l_return_status = ' || l_return_status,l_module_name,4);

6715: END IF;
6716:
6717: IF l_return_status <>FND_API.g_ret_sts_success THEN
6718: IF (l_debug=1) THEN
6719: print_debug('wms_op_runtime_pvt_apis.update_operation_instance finished with error. l_return_status = ' || l_return_status,l_module_name,4);
6720: END IF;
6721:
6722: RAISE FND_API.G_EXC_ERROR;
6723: END IF;

Line 6765: print_debug('Calling WMS_OP_RUNTIME_PVT_APIS.Update_plan_instance with the following values to be updated',l_module_name,4);

6761:
6762: IF (l_debug=1) THEN
6763: print_debug('Current operation is the first step of the operation plan.',l_module_name,4);
6764:
6765: print_debug('Calling WMS_OP_RUNTIME_PVT_APIS.Update_plan_instance with the following values to be updated',l_module_name,4);
6766: print_debug('l_wopi_update_rec.status => '||l_wopi_update_rec.status,l_module_name,9);
6767: print_debug('l_wopi_update_rec.op_plan_instance_id => '||l_wopi_update_rec.op_plan_instance_id,l_module_name,9);
6768: END IF;
6769:

Line 6772: WMS_OP_RUNTIME_PVT_APIS.Update_Plan_Instance

6768: END IF;
6769:
6770: l_progress := 150;
6771:
6772: WMS_OP_RUNTIME_PVT_APIS.Update_Plan_Instance
6773: (p_update_rec => l_wopi_update_rec,
6774: x_return_status => l_return_status,
6775: x_msg_count => x_msg_count,
6776: x_msg_data => x_msg_data);

Line 6781: print_debug('After calling WMS_OP_RUNTIME_PVT_APIS.Update_plan_instance.',l_module_name,4);

6777:
6778: l_progress := 160;
6779:
6780: IF (l_debug=1) THEN
6781: print_debug('After calling WMS_OP_RUNTIME_PVT_APIS.Update_plan_instance.',l_module_name,4);
6782: print_debug('x_return_status => '|| l_return_status,l_module_name,4);
6783: print_debug('x_msg_count => '|| l_msg_count,l_module_name,4);
6784: print_debug('x_msg_data => '|| l_msg_data,l_module_name,4);
6785: END IF;

Line 6789: print_debug('wms_op_runtime_pvt_apis.Update_plan_instance finished with error. l_return_status = ' || l_return_status,l_module_name,4);

6785: END IF;
6786:
6787: IF l_return_status <>FND_API.g_ret_sts_success THEN
6788: IF (l_debug=1) THEN
6789: print_debug('wms_op_runtime_pvt_apis.Update_plan_instance finished with error. l_return_status = ' || l_return_status,l_module_name,4);
6790: END IF;
6791:
6792: RAISE FND_API.G_EXC_ERROR;
6793: END IF;

Line 7093: call WMS_OP_RUNTIME_PVT_APIS.Update_operation_plan_instance to update

7089: l_progress:=70;
7090:
7091:
7092: /*Mark the current Operation Plan (WOPI record) as 'Cancelled';
7093: call WMS_OP_RUNTIME_PVT_APIS.Update_operation_plan_instance to update
7094: the Operation Plan instance*/
7095: l_wopi_update_rec.status := G_OP_INS_STAT_CANCELLED;
7096: l_wopi_update_rec.op_plan_instance_id := l_operation_instance_rec.op_plan_instance_id;
7097:

Line 7106: WMS_OP_RUNTIME_PVT_APIS.Update_Plan_Instance

7102: print_debug('Plan status => '||l_wopi_update_rec.status,l_module_name,9);
7103: print_debug('Plan Instance id => '||l_wopi_update_rec.op_plan_instance_id,l_module_name,9);
7104: END IF;
7105:
7106: WMS_OP_RUNTIME_PVT_APIS.Update_Plan_Instance
7107: (p_update_rec => l_wopi_update_rec,
7108: x_return_status => x_return_status,
7109: x_msg_count => x_msg_count,
7110: x_msg_data => x_msg_data);

Line 7142: WMS_OP_RUNTIME_PVT_APIS.Update_Operation_Instance

7138: END IF;
7139:
7140: l_progress:=130;
7141:
7142: WMS_OP_RUNTIME_PVT_APIS.Update_Operation_Instance
7143: (p_update_rec => l_wooi_update_rec,
7144: x_return_status => x_return_status,
7145: x_msg_count => x_msg_count,
7146: x_msg_data => x_msg_data);

Line 7164: /*Call WMS_OP_RUNTIME_PVT_APIS.Archive_op_plan_instance to archive the

7160: END IF;
7161:
7162:
7163: l_progress:=140;
7164: /*Call WMS_OP_RUNTIME_PVT_APIS.Archive_op_plan_instance to archive the
7165: Cancelled operation plan instance.
7166: */
7167: IF (l_debug=1) THEN
7168: print_debug('Archiving Plan Instance with Plan Instance Id'||l_operation_instance_rec.op_plan_instance_id,l_module_name,9);

Line 7171: WMS_OP_RUNTIME_PVT_APIS.Archive_Plan_Instance

7167: IF (l_debug=1) THEN
7168: print_debug('Archiving Plan Instance with Plan Instance Id'||l_operation_instance_rec.op_plan_instance_id,l_module_name,9);
7169: END IF;
7170:
7171: WMS_OP_RUNTIME_PVT_APIS.Archive_Plan_Instance
7172: (p_op_plan_instance_id => l_operation_instance_rec.op_plan_instance_id,
7173: x_return_status => x_return_status,
7174: x_msg_count => x_msg_count,
7175: x_msg_data => x_msg_data);

Line 7204: WMS_OP_RUNTIME_PVT_APIS.archive_dispatched_tasks(

7200: print_debug('p_op_plan_instance_id ==> '||l_operation_instance_rec.op_plan_instance_id,l_module_name,4);
7201: print_debug('p_op_plan_status ==> '||G_OP_INS_STAT_CANCELLED,l_module_name,4);
7202: END IF;
7203:
7204: WMS_OP_RUNTIME_PVT_APIS.archive_dispatched_tasks(
7205: x_return_status => x_return_status
7206: , x_msg_count => x_msg_count
7207: , x_msg_data => x_msg_data
7208: , p_task_id => NULL

Line 7560: call WMS_OP_RUNTIME_PVT_APIS.Update_operation_plan_instance to update

7556:
7557: l_progress:=70;
7558:
7559: /*Mark the current Operation Plan (WOPI record) as 'Aborted;
7560: call WMS_OP_RUNTIME_PVT_APIS.Update_operation_plan_instance to update
7561: the Operation Plan instance*/
7562: l_wopi_update_rec.status := G_OP_INS_STAT_ABORTED;
7563: l_wopi_update_rec.op_plan_instance_id := l_operation_instance.op_plan_instance_id;
7564:

Line 7573: WMS_OP_RUNTIME_PVT_APIS.Update_Plan_Instance

7569: print_debug('Plan status => '||l_wopi_update_rec.status,l_module_name,9);
7570: print_debug('Plan Instance id => '||l_wopi_update_rec.op_plan_instance_id,l_module_name,9);
7571: END IF;
7572:
7573: WMS_OP_RUNTIME_PVT_APIS.Update_Plan_Instance
7574: (p_update_rec => l_wopi_update_rec,
7575: x_return_status => x_return_status,
7576: x_msg_count => x_msg_count,
7577: x_msg_data => x_msg_data);

Line 7609: WMS_OP_RUNTIME_PVT_APIS.Update_Operation_Instance

7605: END IF;
7606:
7607: l_progress:=110;
7608:
7609: WMS_OP_RUNTIME_PVT_APIS.Update_Operation_Instance
7610: (p_update_rec => l_wooi_update_rec,
7611: x_return_status => x_return_status,
7612: x_msg_count => x_msg_count,
7613: x_msg_data => x_msg_data);

Line 7632: /*Call WMS_OP_RUNTIME_PVT_APIS.Archive_op_plan_instance to archive the

7628:
7629:
7630: l_progress:=120;
7631:
7632: /*Call WMS_OP_RUNTIME_PVT_APIS.Archive_op_plan_instance to archive the
7633: aborted operation plan instance.
7634: */
7635: IF (l_debug=1) THEN
7636: print_debug('Archiving Plan Instance with Plan Instance Id'||l_operation_instance.op_plan_instance_id,l_module_name,9);

Line 7639: WMS_OP_RUNTIME_PVT_APIS.Archive_Plan_Instance

7635: IF (l_debug=1) THEN
7636: print_debug('Archiving Plan Instance with Plan Instance Id'||l_operation_instance.op_plan_instance_id,l_module_name,9);
7637: END IF;
7638:
7639: WMS_OP_RUNTIME_PVT_APIS.Archive_Plan_Instance
7640: (p_op_plan_instance_id => l_operation_instance.op_plan_instance_id,
7641: x_return_status => x_return_status,
7642: x_msg_count => x_msg_count,
7643: x_msg_data => x_msg_data);

Line 7672: WMS_OP_RUNTIME_PVT_APIS.archive_dispatched_tasks(

7668: print_debug('p_op_plan_instance_id ==> '||l_operation_instance.op_plan_instance_id,l_module_name,4);
7669: print_debug('p_op_plan_status ==> '||G_OP_INS_STAT_ABORTED,l_module_name,4);
7670: END IF;
7671:
7672: WMS_OP_RUNTIME_PVT_APIS.archive_dispatched_tasks(
7673: x_return_status => x_return_status
7674: , x_msg_count => x_msg_count
7675: , x_msg_data => x_msg_data
7676: , p_task_id => NULL

Line 8218: WMS_OP_RUNTIME_PVT_APIS.UPDATE_OPERATION_INSTANCE

8214: END IF;
8215:
8216: l_progress := 80;
8217:
8218: WMS_OP_RUNTIME_PVT_APIS.UPDATE_OPERATION_INSTANCE
8219: (p_update_rec => l_wooi_rec,
8220: x_return_status => x_return_status,
8221: x_msg_count => x_msg_count,
8222: x_msg_data => x_msg_data);

Line 8295: WMS_OP_RUNTIME_PVT_APIS.DELETE_OPERATION_INSTANCE

8291: IF (l_debug=1) THEN
8292: print_debug('Calling Deleting Operation Instance with operation Instance Id'||l_wooi_data_rec.operation_instance_id,l_module_name,9);
8293: END IF;
8294:
8295: WMS_OP_RUNTIME_PVT_APIS.DELETE_OPERATION_INSTANCE
8296: ( p_operation_instance_id => l_wooi_data_rec.operation_instance_id
8297: ,x_return_status => x_return_status
8298: ,x_msg_count => x_msg_count
8299: ,x_msg_data => x_msg_data);

Line 8362: WMS_OP_RUNTIME_PVT_APIS.UPDATE_PLAN_INSTANCE

8358: print_debug('Op_plan_instance_id => '||l_wopi_rec.op_plan_instance_id,l_module_name,9);
8359: print_debug('Status => '||l_wopi_rec.status,l_module_name,9);
8360: END IF;
8361:
8362: WMS_OP_RUNTIME_PVT_APIS.UPDATE_PLAN_INSTANCE
8363: (p_update_rec => l_wopi_rec,
8364: x_return_status => x_return_status,
8365: x_msg_count => x_msg_count,
8366: x_msg_data => x_msg_data);