[Home] [Help]
709:
710: l_progress := '250';
711:
712:
713: wms_atf_runtime_pub_apis.activate_operation_instance
714: ( p_source_task_id => gtmp_rec.transaction_temp_id
715: ,p_activity_id => G_OP_ACTIVITY_INBOUND
716: ,p_task_execute_rec => l_task_rec
717: ,p_operation_type_id => G_OP_TYPE_LOAD
3499: -- Call Validate_Operation for this MMTT to check whetehr the current step is crossdock.
3500: -- Call the WIP Integration APIs only if the current step is crossdock
3501: -- Else reset the WIP Related columns in the temp table.
3502: -- If this is any other xdock reset the xdock columns as well
3503: wms_atf_runtime_pub_apis.validate_operation
3504: ( x_return_status => l_return_status
3505: ,x_msg_data => l_msg_data
3506: ,x_msg_count => l_msg_count
3507: ,x_error_code => l_error_code
3789:
3790: /**
3791: * This function will call the ATF API to activate the
3792: * operation instance for load. It will call the ATF API
3793: * wms_atf_runtime_pub_apis.activate_operation_instance for
3794: * each MMTT. For the immediate and the child contents of the
3795: * LPN being passed.
3796: *
3797: * It returns the number of rows for which the plan is
3899: DEBUG('p_operation_type_id => ' || G_OP_TYPE_DROP,l_proc_name,9);
3900: END IF;
3901: l_progress := '300';
3902:
3903: wms_atf_runtime_pub_apis.activate_operation_instance
3904: ( p_source_task_id => l_tempid_tab(i)
3905: ,p_activity_id => G_OP_ACTIVITY_INBOUND
3906: ,p_task_execute_rec => l_task_rec
3907: ,p_operation_type_id => G_OP_TYPE_LOAD
3980:
3981:
3982: /**
3983: * This function will call the ATF API to complete the operation instance for load.
3984: * It will call the ATF API wms_atf_runtime_pub_apis.activate_operation_instance for
3985: * each MMTT. For the immediate and the child contents of the LPN being passed.
3986: *
3987: * It returns the number of rows for which the plan is completed. will return -1 in case of failure.
3988:
4076: DEBUG('p_operation_type_id => ' || G_OP_TYPE_DROP,l_proc_name,9);
4077: END IF;
4078: l_progress := '300';
4079:
4080: wms_atf_runtime_pub_apis.complete_operation_instance
4081: ( p_source_task_id => l_tempid_tab(i)
4082: ,p_activity_id => G_OP_ACTIVITY_INBOUND
4083: ,p_operation_type_id => G_OP_TYPE_LOAD
4084: ,x_return_status => x_return_status
4295:
4296:
4297: /**
4298: * This function will call the ATF API to activate the operation instance for drop
4299: * It will call the ATF API wms_atf_runtime_pub_apis.activate_operation_instance
4300: * for each 'All Task' row in the temp table.
4301: *
4302: * After call to ATF API the new dest sub/loc/LPN will be updated back to the
4303: * global temp table.
4430: DEBUG('p_operation_type_id => ' || G_OP_TYPE_DROP,l_proc_name,9);
4431: END IF;
4432: l_progress := '300';
4433:
4434: wms_atf_runtime_pub_apis.activate_operation_instance
4435: ( p_source_task_id => l_tempid_tab(i)
4436: ,p_activity_id => G_OP_ACTIVITY_INBOUND
4437: ,p_task_execute_rec => l_task_rec
4438: ,p_operation_type_id => G_OP_TYPE_DROP
5358:
5359: --BUG 3666138: Pass in 1 more parameter, p_for_manual_drop, so
5360: --that ATF would call revert_loc_sugg_capacity with an
5361: --autonomous commit
5362: wms_atf_runtime_pub_apis.Abort_Operation_Plan
5363: ( p_source_task_id => l_tempid_tab(i)
5364: ,p_activity_type_id => G_OP_ACTIVITY_INBOUND
5365: ,x_return_status => x_return_status
5366: ,x_msg_data => x_msg_data
5387: DEBUG('p_activity_type_id => ' || G_OP_ACTIVITY_INBOUND,l_proc_name,9);
5388: END IF;
5389: l_progress := '330';
5390:
5391: wms_atf_runtime_pub_apis.cancel_operation_plan
5392: ( p_source_task_id => l_tempid_tab(i)
5393: ,p_activity_type_id => G_OP_ACTIVITY_INBOUND
5394: ,x_return_status => x_return_status
5395: ,x_msg_data => x_msg_data
5415: DEBUG('p_operation_type_id => ' || G_OP_TYPE_DROP,l_proc_name,9);
5416: END IF;
5417: l_progress := '330';
5418:
5419: wms_atf_runtime_pub_apis.activate_operation_instance
5420: ( p_source_task_id => l_tempid_tab(i)
5421: ,p_activity_id => G_OP_ACTIVITY_INBOUND
5422: ,p_task_execute_rec => l_task_rec
5423: ,p_operation_type_id => G_OP_TYPE_DROP
5495:
5496:
5497: /**
5498: * This function will call the ATF API to activate the operation instance for inspect.
5499: * It will call the ATF API wms_atf_runtime_pub_apis.activate_operation_instance for
5500: * each MMTT. For the Move Order Line passed.
5501: *
5502: * ATF will check whether the current step. If it is not inspect, it will inturn call
5503: * the Abort operation instance to abort the current plan in progress. So we need not
5625: DEBUG('p_operation_type_id => ' || G_OP_TYPE_DROP,l_proc_name,9);
5626: END IF;
5627: l_progress := '300';
5628:
5629: wms_atf_runtime_pub_apis.activate_operation_instance
5630: ( p_source_task_id => l_tempid_tab(i)
5631: ,p_activity_id => G_OP_ACTIVITY_INBOUND
5632: ,p_task_execute_rec => l_task_rec
5633: ,p_operation_type_id => G_OP_TYPE_INSPECT
6047: DEBUG('p_activity_type_id => ' || G_OP_ACTIVITY_INBOUND,l_proc_name,9);
6048: END IF;
6049: l_progress := '300';
6050:
6051: wms_atf_runtime_pub_apis.Rollback_operation_plan
6052: ( p_source_task_id => l_tempid_tab(i)
6053: ,p_activity_type_id => G_OP_ACTIVITY_INBOUND
6054: ,x_return_status => x_return_status
6055: ,x_msg_data => x_msg_data
6285: DEBUG('p_activity_type_id => ' || G_OP_ACTIVITY_INBOUND,l_proc_name,9);
6286: END IF;
6287: l_progress := '310';
6288:
6289: wms_atf_runtime_pub_apis.Cleanup_Operation_Instance
6290: ( p_source_task_id => l_tempid_tab(i)
6291: ,p_activity_type_id => G_OP_ACTIVITY_INBOUND
6292: ,x_return_status => x_return_status
6293: ,x_msg_data => x_msg_data
7868: --l_task_execute_rec.loaded_time := Sysdate;
7869: --l_task_execute_rec.user_task_type := -1;
7870: --END DBI FIX
7871:
7872: wms_atf_runtime_pub_apis.activate_operation_instance
7873: ( p_source_task_id => l_mmtt_ids(i)
7874: ,p_activity_id => 1 -- Inbound
7875: ,p_task_execute_rec => l_task_execute_rec
7876: ,p_operation_type_id => 1 -- load
9119: -- Activate each MMTT's
9120: FOR i IN 1 .. l_txn_tmp_id_tb.COUNT LOOP
9121: l_progress := '73';
9122:
9123: wms_atf_runtime_pub_apis.validate_operation
9124: (x_return_status => x_return_status
9125: ,x_msg_data => x_msg_data
9126: ,x_msg_count => x_msg_count
9127: ,x_error_code => l_error_code
9160: DEBUG(' ,p_task_execute_rec => l_task_execute_rec','transfer_contents',9);
9161: DEBUG(' ,p_operation_type_id => 1 )','transfer_contents',9);
9162: END IF;
9163:
9164: wms_atf_runtime_pub_apis.activate_operation_instance
9165: ( p_source_task_id => l_txn_tmp_id_tb(i)
9166: ,p_activity_id => 1 -- Inbound
9167: ,p_task_execute_rec => l_task_execute_rec
9168: ,p_operation_type_id => 1 -- load
9401: END IF;
9402:
9403: -- Call complete operation instance
9404: FOR i IN 1 .. l_txn_tmp_id_tb.COUNT LOOP
9405: wms_atf_runtime_pub_apis.complete_operation_instance
9406: ( p_source_task_id => l_txn_tmp_id_tb(i)
9407: ,p_activity_id => 1 -- inbound
9408: ,p_operation_type_id => 1 -- load
9409: ,x_return_status => x_return_status
9646: END IF;
9647:
9648: -- Call complete operation instance
9649: FOR i IN 1 .. l_txn_tmp_id_tb.COUNT LOOP
9650: wms_atf_runtime_pub_apis.complete_operation_instance
9651: ( p_source_task_id => l_txn_tmp_id_tb(i)
9652: ,p_activity_id => 1 -- inbound
9653: ,p_operation_type_id => 1 -- load
9654: ,x_return_status => x_return_status
9992: ,x_proc_msg => x_msg_data);
9993:
9994: -- Call complete operation instance
9995: FOR i IN 1 .. l_txn_tmp_id_tb.COUNT LOOP
9996: wms_atf_runtime_pub_apis.complete_operation_instance
9997: ( p_source_task_id => l_txn_tmp_id_tb(i)
9998: ,p_activity_id => 1 -- inbound
9999: ,p_operation_type_id => 1 -- load
10000: ,x_return_status => x_return_status
13663: END IF;
13664:
13665:
13666: l_progress := '10';
13667: wms_atf_runtime_pub_apis.cancel_operation_plan ( p_source_task_id =>
13668: l_tempid_tab(i) ,p_activity_type_id => G_OP_ACTIVITY_INBOUND ,
13669: x_return_status => l_return_status ,x_msg_data => x_message ,
13670: x_msg_count => l_msg_count ,x_error_code => l_error_code );
13671: l_progress := '310';
14856: END IF;
14857:
14858: l_progress := 60;
14859: IF l_mmtt_rec.transaction_temp_id IS NOT NULL THEN
14860: wms_atf_runtime_pub_apis.Cleanup_Operation_Instance
14861: ( p_source_task_id => l_mmtt_rec.transaction_temp_id
14862: , p_activity_type_id => G_OP_ACTIVITY_INBOUND
14863: , x_return_status => x_return_status
14864: , x_msg_data => l_x_msg_data