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 2000: WMS_OP_RUNTIME_PVT_APIS.Insert_Dispatched_tasks

1996: END IF;
1997:
1998: l_progress:=60;
1999:
2000: WMS_OP_RUNTIME_PVT_APIS.Insert_Dispatched_tasks
2001: ( p_wdt_rec => l_wdt_rec,
2002: p_source_task_id => p_source_task_id,
2003: x_return_status => x_return_status,
2004: x_msg_count => x_msg_count,

Line 2122: WMS_OP_RUNTIME_PVT_APIS.Insert_Dispatched_tasks

2118: END IF;
2119:
2120: l_progress:=100;
2121:
2122: WMS_OP_RUNTIME_PVT_APIS.Insert_Dispatched_tasks
2123: ( p_wdt_rec => l_wdt_rec,
2124: p_source_task_id => p_source_task_id,
2125: x_return_status => x_return_status,
2126: x_msg_count => x_msg_count,

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

2251:
2252: l_progress:=170;
2253:
2254: IF (l_debug=1) THEN
2255: print_debug('Calling WMS_OP_RUNTIME_PVT_APIS.UPDATE_PLAN_INSTANCE to update the foll values',l_module_name,9);
2256: print_debug('Status'||l_wopi_rec.status,l_module_name,9);
2257: print_debug('Plan Instance Id'||l_wopi_rec.op_plan_instance_id,l_module_name,9);
2258:
2259: END IF;

Line 2261: WMS_OP_RUNTIME_PVT_APIS.UPDATE_PLAN_INSTANCE

2257: print_debug('Plan Instance Id'||l_wopi_rec.op_plan_instance_id,l_module_name,9);
2258:
2259: END IF;
2260:
2261: WMS_OP_RUNTIME_PVT_APIS.UPDATE_PLAN_INSTANCE
2262: ( p_update_rec => l_wopi_rec
2263: ,x_return_status => x_return_status
2264: ,x_msg_count => x_msg_count
2265: ,x_msg_data => x_msg_data);

Line 2390: WMS_OP_RUNTIME_PVT_APIS.UPDATE_OPERATION_INSTANCE

2386: END IF;/*Activity Inbound and Drop Operation*/
2387:
2388: l_progress:=240;
2389:
2390: WMS_OP_RUNTIME_PVT_APIS.UPDATE_OPERATION_INSTANCE
2391: ( x_return_status => l_return_status --Use l_return_status instead
2392: , x_msg_count => l_msg_count --of x_return_status because
2393: , x_msg_data => l_msg_data --it will override the value
2394: , p_update_rec => l_wooi_rec); --returned from determine_attributes

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

2831: IF (l_debug=1) THEN
2832: print_debug('Current operation is inspect.' ,l_module_name,4);
2833: print_debug('Set l_operation_type_id to inspect.' ,l_module_name,4);
2834:
2835: print_debug('Before calling wms_op_runtime_pvt_apis.archive_dispatched_tasks with following parameters' ,l_module_name,4);
2836: print_debug('p_task_id => '|| l_wdt_task_id,l_module_name,4);
2837: print_debug('p_source_task_id => '|| p_source_task_id,l_module_name,4);
2838: print_debug('p_activity_type_id => '|| p_activity_id,l_module_name,4);
2839: END IF;

Line 2845: wms_op_runtime_pvt_apis.archive_dispatched_tasks

2841: l_operation_type_id := g_op_type_inspect;
2842:
2843: l_progress := 40;
2844:
2845: wms_op_runtime_pvt_apis.archive_dispatched_tasks
2846: (
2847: x_return_status => l_return_status
2848: , x_msg_count => l_msg_count
2849: , x_msg_data => l_msg_data

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

2856:
2857: l_progress := 50;
2858:
2859: IF (l_debug=1) THEN
2860: print_debug('After calling wms_op_runtime_pvt_apis.archive_dispatched_tasks .' ,l_module_name,4);
2861: print_debug('x_return_status => '|| l_return_status,l_module_name,4);
2862: print_debug('x_msg_count => '|| l_msg_count,l_module_name,4);
2863: print_debug('x_msg_data => '|| l_msg_data,l_module_name,4);
2864: END IF;

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

2865:
2866:
2867: IF l_return_status <>FND_API.g_ret_sts_success THEN
2868: IF (l_debug=1) THEN
2869: print_debug('wms_op_runtime_pvt_apis.archive_dispatched_tasks finished with error. l_return_status = ' || l_return_status,l_module_name,4);
2870: END IF;
2871: fnd_message.set_name('WMS', 'WMS_ATF_ARCHIVE_TASK_FAILURE');
2872: fnd_msg_pub.ADD;
2873: RAISE FND_API.G_EXC_ERROR;

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

2922: l_operation_type_id := g_op_type_drop;
2923:
2924: IF (l_debug=1) THEN
2925:
2926: print_debug('Drop - Before calling wms_op_runtime_pvt_apis.archive_dispatched_tasks with following parameters' ,l_module_name,4);
2927: print_debug('p_task_id => '|| l_wdt_task_id,l_module_name,4);
2928: print_debug('p_source_task_id => '|| p_source_task_id,l_module_name,4);
2929: print_debug('p_activity_type_id => '|| p_activity_id,l_module_name,4);
2930: END IF;

Line 2934: wms_op_runtime_pvt_apis.archive_dispatched_tasks

2930: END IF;
2931:
2932: l_progress := 80;
2933:
2934: wms_op_runtime_pvt_apis.archive_dispatched_tasks
2935: (
2936: x_return_status => l_return_status
2937: , x_msg_count => l_msg_count
2938: , x_msg_data => l_msg_data

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

2945:
2946: l_progress := 90;
2947:
2948: IF (l_debug=1) THEN
2949: print_debug('Drop - After calling wms_op_runtime_pvt_apis.archive_dispatched_tasks .' ,l_module_name,4);
2950: print_debug('x_return_status => '|| l_return_status,l_module_name,4);
2951: print_debug('x_msg_count => '|| l_msg_count,l_module_name,4);
2952: print_debug('x_msg_data => '|| l_msg_data,l_module_name,4);
2953: END IF;

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

2954:
2955:
2956: IF l_return_status <>FND_API.g_ret_sts_success THEN
2957: IF (l_debug=1) THEN
2958: print_debug('Drop - wms_op_runtime_pvt_apis.archive_dispatched_tasks finished with error. l_return_status = ' || l_return_status,l_module_name,4);
2959: END IF;
2960: fnd_message.set_name('WMS', 'WMS_ATF_ARCHIVE_TASK_FAILURE');
2961: fnd_msg_pub.ADD;
2962: RAISE FND_API.G_EXC_ERROR;

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

3428: END IF; -- IF l_operation_type_id = g_op_type_drop T
3429:
3430:
3431: IF (l_debug=1) THEN
3432: print_debug('Before calling wms_op_runtime_pvt_apis.update_operation_instance with following parameters: ',l_module_name,4);
3433: print_debug('l_wooi_rec.operation_instance_id => '|| l_wooi_rec.operation_instance_id,l_module_name,4);
3434: print_debug('l_wooi_rec.operation_status => '|| l_wooi_rec.operation_status,l_module_name,4);
3435: print_debug('l_wooi_rec.complete_time => '|| To_char(l_wooi_rec.complete_time),l_module_name,4);
3436: print_debug('l_wooi_rec.to_subinventory_code => '|| l_wooi_rec.to_subinventory_code,l_module_name,4);

Line 3444: wms_op_runtime_pvt_apis.update_operation_instance

3440: END IF;
3441:
3442: l_progress := 120;
3443:
3444: wms_op_runtime_pvt_apis.update_operation_instance
3445: (x_return_status => l_return_status
3446: , x_msg_count => l_msg_count
3447: , x_msg_data => l_msg_data
3448: , p_update_rec => l_wooi_rec);

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

3449:
3450: l_progress := 130;
3451:
3452: IF (l_debug=1) THEN
3453: print_debug('After calling wms_op_runtime_pvt_apis.update_operation_instance: ' ,l_module_name,4);
3454: print_debug('x_return_status => '|| l_return_status,l_module_name,4);
3455: print_debug('x_msg_count => '|| l_msg_count,l_module_name,4);
3456: print_debug('x_msg_data => '|| l_msg_data,l_module_name,4);
3457: END IF;

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

3457: END IF;
3458:
3459: IF l_return_status <>FND_API.g_ret_sts_success THEN
3460: IF (l_debug=1) THEN
3461: print_debug('wms_op_runtime_pvt_apis.update_operation_instance finished with error. l_return_status = ' || l_return_status,l_module_name,4);
3462: END IF;
3463:
3464: RAISE FND_API.G_EXC_ERROR;
3465: END IF;

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

3473:
3474: -- this is the last operation in the plan
3475: IF (l_debug=1) THEN
3476: print_debug('Current operation is the last step of the operation plan.',l_module_name,4);
3477: print_debug('Before calling wms_op_runtime_pvt_apis.archive_dispatched_tasks with following parameters : ' , l_module_name,4);
3478: print_debug('p_task_id => '||'', l_module_name,4);
3479: print_debug('p_source_task_id => '||l_mmtt_rec.parent_line_id, l_module_name,4);
3480: print_debug('p_activity_type_id => '||p_activity_id, l_module_name,4);
3481: print_debug('p_op_plan_instance_id => '||l_wooi_data_rec.op_plan_instance_id, l_module_name,4);

Line 3486: wms_op_runtime_pvt_apis.archive_dispatched_tasks

3482: print_debug('p_op_plan_status => '||G_OP_INS_STAT_COMPLETED,l_module_name,4);
3483: END IF;
3484:
3485: -- Need to archive the parent MMTT record into WDTH
3486: wms_op_runtime_pvt_apis.archive_dispatched_tasks
3487: (
3488: x_return_status => l_return_status
3489: , x_msg_count => l_msg_count
3490: , x_msg_data => l_msg_data

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

3495: , p_op_plan_status => G_OP_INS_STAT_COMPLETED
3496: );
3497:
3498: IF (l_debug=1) THEN
3499: print_debug('After calling wms_op_runtime_pvt_apis.archive_dispatched_tasks.',l_module_name,4);
3500: print_debug('x_return_status => '|| l_return_status,l_module_name,4);
3501: print_debug('x_msg_count => '|| l_msg_count,l_module_name,4);
3502: print_debug('x_msg_data => '|| l_msg_data,l_module_name,4);
3503:

Line 3508: 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);

3504: END IF;
3505:
3506: IF l_return_status <>FND_API.g_ret_sts_success THEN
3507: IF (l_debug=1) THEN
3508: 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);
3509: END IF;
3510: fnd_message.set_name('WMS', 'WMS_ATF_ARCHIVE_TASK_FAILURE');
3511: fnd_msg_pub.ADD;
3512: RAISE FND_API.G_EXC_ERROR;

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

3512: RAISE FND_API.G_EXC_ERROR;
3513: END IF;
3514:
3515: IF (l_debug=1) THEN
3516: print_debug('Before calling wms_op_runtime_pvt_apis.complete_plan_instance with following parameters:', l_module_name,4);
3517: print_debug('p_op_plan_instance_id => '||l_wooi_data_rec.op_plan_instance_id, l_module_name,4);
3518: END IF;
3519:
3520: -- Complete the operation plan instance

Line 3523: wms_op_runtime_pvt_apis.complete_plan_instance

3519:
3520: -- Complete the operation plan instance
3521: l_progress := 160;
3522:
3523: wms_op_runtime_pvt_apis.complete_plan_instance
3524: (x_return_status => l_return_status,
3525: x_msg_data => l_msg_data,
3526: x_msg_count => l_msg_count,
3527: p_op_plan_instance_id => l_wooi_data_rec.op_plan_instance_id

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

3529:
3530: l_progress := 170;
3531:
3532: IF (l_debug=1) THEN
3533: print_debug('After calling wms_op_runtime_pvt_apis.complete_plan_instance. ', l_module_name,4);
3534:
3535: print_debug('x_return_status => '||l_return_status, l_module_name,4);
3536: print_debug('x_msg_data => '||l_msg_data, l_module_name,4);
3537: print_debug('x_msg_count => '||l_msg_count, l_module_name,4);

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

3538: END IF;
3539:
3540: IF l_return_status <>FND_API.g_ret_sts_success THEN
3541: IF (l_debug=1) THEN
3542: print_debug('wms_op_runtime_pvt_apis.complete_plan_instance finished with error. l_return_status = ' || l_return_status,l_module_name,4);
3543: END IF;
3544:
3545: RAISE FND_API.G_EXC_ERROR;
3546: END IF;

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

3767:
3768: -- create next operation instance
3769:
3770: IF (l_debug=1) THEN
3771: print_debug('Before calling wms_op_runtime_pvt_apis.insert_operation_instance:' ,l_module_name,4);
3772: END IF;
3773:
3774: wms_op_runtime_pvt_apis.insert_operation_instance
3775: (

Line 3774: wms_op_runtime_pvt_apis.insert_operation_instance

3770: IF (l_debug=1) THEN
3771: print_debug('Before calling wms_op_runtime_pvt_apis.insert_operation_instance:' ,l_module_name,4);
3772: END IF;
3773:
3774: wms_op_runtime_pvt_apis.insert_operation_instance
3775: (
3776: x_return_status => l_return_status ,
3777: x_msg_count => x_msg_count ,
3778: x_msg_data => x_msg_data ,

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

3778: x_msg_data => x_msg_data ,
3779: p_insert_rec => l_wooi_rec );
3780:
3781: IF (l_debug=1) THEN
3782: print_debug('After calling wms_op_runtime_pvt_apis.insert_operation_instance:' ,l_module_name,4);
3783: END IF;
3784:
3785: IF l_return_status <>FND_API.g_ret_sts_success THEN
3786: IF (l_debug=1) THEN

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

3783: END IF;
3784:
3785: IF l_return_status <>FND_API.g_ret_sts_success THEN
3786: IF (l_debug=1) THEN
3787: print_debug('wms_op_runtime_pvt_apis.insert_operation_instance finished with error. l_return_status = ' || l_return_status,l_module_name,4);
3788: END IF;
3789:
3790: RAISE FND_API.G_EXC_ERROR;
3791: END IF;

Line 5743: WMS_OP_RUNTIME_PVT_APIS.INSERT_PLAN_INSTANCE(

5739: l_progress := 170;
5740: --call wms_op_plan_instance table handler to insert l_wopi_split_rec INTO the table
5741:
5742: l_progress := 180;
5743: WMS_OP_RUNTIME_PVT_APIS.INSERT_PLAN_INSTANCE(
5744: x_return_status => x_return_status ,
5745: x_msg_count => x_msg_count ,
5746: x_msg_data => x_msg_data ,
5747: p_insert_rec => l_wopi_split_rec );

Line 6069: WMS_OP_RUNTIME_PVT_APIS.insert_operation_instance

6065: FROM dual;
6066: l_progress := 220;
6067:
6068: l_progress := 230;
6069: WMS_OP_RUNTIME_PVT_APIS.insert_operation_instance
6070: ( x_return_status => x_return_status,
6071: x_msg_count => x_msg_count,
6072: x_msg_data => x_msg_data,
6073: p_insert_rec => l_wooi_new_rec

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

6561:
6562: -- Firs need to update current active operation instance to pending
6563:
6564: IF (l_debug=1) THEN
6565: print_debug('Before calling wms_op_runtime_pvt_apis.update_operation_instance with following parameters: ',l_module_name,4);
6566: print_debug('l_wooi_rec.operation_instance_id => '|| l_wooi_rec.operation_instance_id,l_module_name,4);
6567: print_debug('l_wooi_rec.operation_status => '|| l_wooi_rec.operation_status,l_module_name,4);
6568: END IF;
6569:

Line 6572: wms_op_runtime_pvt_apis.update_operation_instance

6568: END IF;
6569:
6570: l_progress := 120;
6571:
6572: wms_op_runtime_pvt_apis.update_operation_instance
6573: (x_return_status => l_return_status
6574: , x_msg_count => l_msg_count
6575: , x_msg_data => l_msg_data
6576: , p_update_rec => l_wooi_rec);

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

6577:
6578: l_progress := 130;
6579:
6580: IF (l_debug=1) THEN
6581: print_debug('After calling wms_op_runtime_pvt_apis.update_operation_instance: ' ,l_module_name,4);
6582: print_debug('x_return_status => '|| l_return_status,l_module_name,4);
6583: print_debug('x_msg_count => '|| l_msg_count,l_module_name,4);
6584: print_debug('x_msg_data => '|| l_msg_data,l_module_name,4);
6585: END IF;

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

6585: END IF;
6586:
6587: IF l_return_status <>FND_API.g_ret_sts_success THEN
6588: IF (l_debug=1) THEN
6589: print_debug('wms_op_runtime_pvt_apis.update_operation_instance finished with error. l_return_status = ' || l_return_status,l_module_name,4);
6590: END IF;
6591:
6592: RAISE FND_API.G_EXC_ERROR;
6593: END IF;

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

6631:
6632: IF (l_debug=1) THEN
6633: print_debug('Current operation is the first step of the operation plan.',l_module_name,4);
6634:
6635: print_debug('Calling WMS_OP_RUNTIME_PVT_APIS.Update_plan_instance with the following values to be updated',l_module_name,4);
6636: print_debug('l_wopi_update_rec.status => '||l_wopi_update_rec.status,l_module_name,9);
6637: print_debug('l_wopi_update_rec.op_plan_instance_id => '||l_wopi_update_rec.op_plan_instance_id,l_module_name,9);
6638: END IF;
6639:

Line 6642: WMS_OP_RUNTIME_PVT_APIS.Update_Plan_Instance

6638: END IF;
6639:
6640: l_progress := 150;
6641:
6642: WMS_OP_RUNTIME_PVT_APIS.Update_Plan_Instance
6643: (p_update_rec => l_wopi_update_rec,
6644: x_return_status => l_return_status,
6645: x_msg_count => x_msg_count,
6646: x_msg_data => x_msg_data);

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

6647:
6648: l_progress := 160;
6649:
6650: IF (l_debug=1) THEN
6651: print_debug('After calling WMS_OP_RUNTIME_PVT_APIS.Update_plan_instance.',l_module_name,4);
6652: print_debug('x_return_status => '|| l_return_status,l_module_name,4);
6653: print_debug('x_msg_count => '|| l_msg_count,l_module_name,4);
6654: print_debug('x_msg_data => '|| l_msg_data,l_module_name,4);
6655: END IF;

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

6655: END IF;
6656:
6657: IF l_return_status <>FND_API.g_ret_sts_success THEN
6658: IF (l_debug=1) THEN
6659: print_debug('wms_op_runtime_pvt_apis.Update_plan_instance finished with error. l_return_status = ' || l_return_status,l_module_name,4);
6660: END IF;
6661:
6662: RAISE FND_API.G_EXC_ERROR;
6663: END IF;

Line 6963: call WMS_OP_RUNTIME_PVT_APIS.Update_operation_plan_instance to update

6959: l_progress:=70;
6960:
6961:
6962: /*Mark the current Operation Plan (WOPI record) as 'Cancelled';
6963: call WMS_OP_RUNTIME_PVT_APIS.Update_operation_plan_instance to update
6964: the Operation Plan instance*/
6965: l_wopi_update_rec.status := G_OP_INS_STAT_CANCELLED;
6966: l_wopi_update_rec.op_plan_instance_id := l_operation_instance_rec.op_plan_instance_id;
6967:

Line 6976: WMS_OP_RUNTIME_PVT_APIS.Update_Plan_Instance

6972: print_debug('Plan status => '||l_wopi_update_rec.status,l_module_name,9);
6973: print_debug('Plan Instance id => '||l_wopi_update_rec.op_plan_instance_id,l_module_name,9);
6974: END IF;
6975:
6976: WMS_OP_RUNTIME_PVT_APIS.Update_Plan_Instance
6977: (p_update_rec => l_wopi_update_rec,
6978: x_return_status => x_return_status,
6979: x_msg_count => x_msg_count,
6980: x_msg_data => x_msg_data);

Line 7012: WMS_OP_RUNTIME_PVT_APIS.Update_Operation_Instance

7008: END IF;
7009:
7010: l_progress:=130;
7011:
7012: WMS_OP_RUNTIME_PVT_APIS.Update_Operation_Instance
7013: (p_update_rec => l_wooi_update_rec,
7014: x_return_status => x_return_status,
7015: x_msg_count => x_msg_count,
7016: x_msg_data => x_msg_data);

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

7030: END IF;
7031:
7032:
7033: l_progress:=140;
7034: /*Call WMS_OP_RUNTIME_PVT_APIS.Archive_op_plan_instance to archive the
7035: Cancelled operation plan instance.
7036: */
7037: IF (l_debug=1) THEN
7038: print_debug('Archiving Plan Instance with Plan Instance Id'||l_operation_instance_rec.op_plan_instance_id,l_module_name,9);

Line 7041: WMS_OP_RUNTIME_PVT_APIS.Archive_Plan_Instance

7037: IF (l_debug=1) THEN
7038: print_debug('Archiving Plan Instance with Plan Instance Id'||l_operation_instance_rec.op_plan_instance_id,l_module_name,9);
7039: END IF;
7040:
7041: WMS_OP_RUNTIME_PVT_APIS.Archive_Plan_Instance
7042: (p_op_plan_instance_id => l_operation_instance_rec.op_plan_instance_id,
7043: x_return_status => x_return_status,
7044: x_msg_count => x_msg_count,
7045: x_msg_data => x_msg_data);

Line 7074: WMS_OP_RUNTIME_PVT_APIS.archive_dispatched_tasks(

7070: print_debug('p_op_plan_instance_id ==> '||l_operation_instance_rec.op_plan_instance_id,l_module_name,4);
7071: print_debug('p_op_plan_status ==> '||G_OP_INS_STAT_CANCELLED,l_module_name,4);
7072: END IF;
7073:
7074: WMS_OP_RUNTIME_PVT_APIS.archive_dispatched_tasks(
7075: x_return_status => x_return_status
7076: , x_msg_count => x_msg_count
7077: , x_msg_data => x_msg_data
7078: , p_task_id => NULL

Line 7430: call WMS_OP_RUNTIME_PVT_APIS.Update_operation_plan_instance to update

7426:
7427: l_progress:=70;
7428:
7429: /*Mark the current Operation Plan (WOPI record) as 'Aborted;
7430: call WMS_OP_RUNTIME_PVT_APIS.Update_operation_plan_instance to update
7431: the Operation Plan instance*/
7432: l_wopi_update_rec.status := G_OP_INS_STAT_ABORTED;
7433: l_wopi_update_rec.op_plan_instance_id := l_operation_instance.op_plan_instance_id;
7434:

Line 7443: WMS_OP_RUNTIME_PVT_APIS.Update_Plan_Instance

7439: print_debug('Plan status => '||l_wopi_update_rec.status,l_module_name,9);
7440: print_debug('Plan Instance id => '||l_wopi_update_rec.op_plan_instance_id,l_module_name,9);
7441: END IF;
7442:
7443: WMS_OP_RUNTIME_PVT_APIS.Update_Plan_Instance
7444: (p_update_rec => l_wopi_update_rec,
7445: x_return_status => x_return_status,
7446: x_msg_count => x_msg_count,
7447: x_msg_data => x_msg_data);

Line 7479: WMS_OP_RUNTIME_PVT_APIS.Update_Operation_Instance

7475: END IF;
7476:
7477: l_progress:=110;
7478:
7479: WMS_OP_RUNTIME_PVT_APIS.Update_Operation_Instance
7480: (p_update_rec => l_wooi_update_rec,
7481: x_return_status => x_return_status,
7482: x_msg_count => x_msg_count,
7483: x_msg_data => x_msg_data);

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

7498:
7499:
7500: l_progress:=120;
7501:
7502: /*Call WMS_OP_RUNTIME_PVT_APIS.Archive_op_plan_instance to archive the
7503: aborted operation plan instance.
7504: */
7505: IF (l_debug=1) THEN
7506: print_debug('Archiving Plan Instance with Plan Instance Id'||l_operation_instance.op_plan_instance_id,l_module_name,9);

Line 7509: WMS_OP_RUNTIME_PVT_APIS.Archive_Plan_Instance

7505: IF (l_debug=1) THEN
7506: print_debug('Archiving Plan Instance with Plan Instance Id'||l_operation_instance.op_plan_instance_id,l_module_name,9);
7507: END IF;
7508:
7509: WMS_OP_RUNTIME_PVT_APIS.Archive_Plan_Instance
7510: (p_op_plan_instance_id => l_operation_instance.op_plan_instance_id,
7511: x_return_status => x_return_status,
7512: x_msg_count => x_msg_count,
7513: x_msg_data => x_msg_data);

Line 7542: WMS_OP_RUNTIME_PVT_APIS.archive_dispatched_tasks(

7538: print_debug('p_op_plan_instance_id ==> '||l_operation_instance.op_plan_instance_id,l_module_name,4);
7539: print_debug('p_op_plan_status ==> '||G_OP_INS_STAT_ABORTED,l_module_name,4);
7540: END IF;
7541:
7542: WMS_OP_RUNTIME_PVT_APIS.archive_dispatched_tasks(
7543: x_return_status => x_return_status
7544: , x_msg_count => x_msg_count
7545: , x_msg_data => x_msg_data
7546: , p_task_id => NULL

Line 8088: WMS_OP_RUNTIME_PVT_APIS.UPDATE_OPERATION_INSTANCE

8084: END IF;
8085:
8086: l_progress := 80;
8087:
8088: WMS_OP_RUNTIME_PVT_APIS.UPDATE_OPERATION_INSTANCE
8089: (p_update_rec => l_wooi_rec,
8090: x_return_status => x_return_status,
8091: x_msg_count => x_msg_count,
8092: x_msg_data => x_msg_data);

Line 8165: WMS_OP_RUNTIME_PVT_APIS.DELETE_OPERATION_INSTANCE

8161: IF (l_debug=1) THEN
8162: print_debug('Calling Deleting Operation Instance with operation Instance Id'||l_wooi_data_rec.operation_instance_id,l_module_name,9);
8163: END IF;
8164:
8165: WMS_OP_RUNTIME_PVT_APIS.DELETE_OPERATION_INSTANCE
8166: ( p_operation_instance_id => l_wooi_data_rec.operation_instance_id
8167: ,x_return_status => x_return_status
8168: ,x_msg_count => x_msg_count
8169: ,x_msg_data => x_msg_data);

Line 8232: WMS_OP_RUNTIME_PVT_APIS.UPDATE_PLAN_INSTANCE

8228: print_debug('Op_plan_instance_id => '||l_wopi_rec.op_plan_instance_id,l_module_name,9);
8229: print_debug('Status => '||l_wopi_rec.status,l_module_name,9);
8230: END IF;
8231:
8232: WMS_OP_RUNTIME_PVT_APIS.UPDATE_PLAN_INSTANCE
8233: (p_update_rec => l_wopi_rec,
8234: x_return_status => x_return_status,
8235: x_msg_count => x_msg_count,
8236: x_msg_data => x_msg_data);