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_TASK_MGMT_PUB dependencies on WMS_WAVEPLAN_TASKS_PVT

Line 13: ---need to be passed to wms_waveplan_tasks_pvt.query_tasks procedure

9: IS
10: BEGIN
11: ---initialize the main table
12: ---this table will have all the parameters with default values that
13: ---need to be passed to wms_waveplan_tasks_pvt.query_tasks procedure
14: g_main_tab(1).field_name := 'ACTIVE';
15: g_main_tab(1).field_value := NULL;
16: g_main_tab(2).field_name := 'ASSEMBLY_ID';
17: g_main_tab(2).field_value := NULL;

Line 5256: l_err_msg := 'Calling API wms_waveplan_tasks_pvt.query_tasks for task: '||p_transaction_number;

5252: FROM mtl_material_transactions_temp
5253: WHERE transaction_temp_id = p_transaction_number;
5254:
5255: IF(l_debug = 1) THEN
5256: l_err_msg := 'Calling API wms_waveplan_tasks_pvt.query_tasks for task: '||p_transaction_number;
5257: inv_trx_util_pub.trace(l_api_name||': '||l_err_msg);
5258: END IF;
5259:
5260: --Munish

Line 5266: --CALLL wms_waveplan_tasks_pvt.query_tasks API WITH

5262: FETCH c_cd_task into c_cd_exist;
5263: CLOSE c_cd_task;
5264:
5265: If (c_cd_exist = 1) THEN
5266: --CALLL wms_waveplan_tasks_pvt.query_tasks API WITH
5267: --p_crossdock_include=true and p_outbound_include=false and p_inbound_include=false
5268: wms_waveplan_tasks_pvt.query_tasks(
5269: p_add => FALSE
5270: ,p_organization_id => l_mmtt_rec.organization_id

Line 5268: wms_waveplan_tasks_pvt.query_tasks(

5264:
5265: If (c_cd_exist = 1) THEN
5266: --CALLL wms_waveplan_tasks_pvt.query_tasks API WITH
5267: --p_crossdock_include=true and p_outbound_include=false and p_inbound_include=false
5268: wms_waveplan_tasks_pvt.query_tasks(
5269: p_add => FALSE
5270: ,p_organization_id => l_mmtt_rec.organization_id
5271: ,p_subinventory_code => l_mmtt_rec.subinventory_code
5272: ,p_locator_id => l_mmtt_rec.locator_id

Line 5310: --CALLL wms_waveplan_tasks_pvt.query_tasks API WITH p_crossdock_include=false and

5306: ,p_is_cancelled_plan => FALSE
5307: ,p_is_aborted_plan => FALSE
5308: );
5309: ELSE
5310: --CALLL wms_waveplan_tasks_pvt.query_tasks API WITH p_crossdock_include=false and
5311: --p_outbound_include=true and p_inbound_include=true
5312: --MKGUPTA2 6868286 Start
5313: IF l_mmtt_rec.parent_line_id IS NOT NULL THEN
5314: l_mmtt_rec.pick_slip_number:=NULL;

Line 5320: wms_waveplan_tasks_pvt.query_tasks(

5316: l_mmtt_rec.subinventory_code:=NULL;
5317: l_mmtt_rec.locator_id:=NULL;
5318: END IF;
5319: -- 6868286 End
5320: wms_waveplan_tasks_pvt.query_tasks(
5321: p_add => FALSE
5322: ,p_organization_id => l_mmtt_rec.organization_id
5323: ,p_subinventory_code => l_mmtt_rec.subinventory_code
5324: ,p_locator_id => l_mmtt_rec.locator_id

Line 5364: l_err_msg := 'Status returned by API wms_waveplan_tasks_pvt.query_tasks: '||x_return_status;

5360: );
5361: END IF;
5362:
5363: IF(l_debug = 1) THEN
5364: l_err_msg := 'Status returned by API wms_waveplan_tasks_pvt.query_tasks: '||x_return_status;
5365: inv_trx_util_pub.trace(l_api_name||': '||l_err_msg);
5366: END IF;
5367:
5368: IF (x_return_status = FND_API.G_RET_STS_SUCCESS) THEN

Line 5520: l_err_msg := 'Calling API wms_waveplan_tasks_pvt.query_tasks for cycle count task: '||p_transaction_number;

5516: v_cycle_count_name := NULL;
5517: END;
5518:
5519: IF(l_debug = 1) THEN
5520: l_err_msg := 'Calling API wms_waveplan_tasks_pvt.query_tasks for cycle count task: '||p_transaction_number;
5521: inv_trx_util_pub.trace(l_api_name||': '||l_err_msg);
5522: inv_trx_util_pub.trace('Cycle Count Name '||v_cycle_count_name);
5523: END IF;
5524:

Line 5525: wms_waveplan_tasks_pvt.query_tasks(

5521: inv_trx_util_pub.trace(l_api_name||': '||l_err_msg);
5522: inv_trx_util_pub.trace('Cycle Count Name '||v_cycle_count_name);
5523: END IF;
5524:
5525: wms_waveplan_tasks_pvt.query_tasks(
5526: p_add => FALSE
5527: ,p_organization_id => l_mcce_rec.organization_id
5528: ,p_subinventory_code => l_mcce_rec.subinventory
5529: ,p_locator_id => l_mcce_rec.locator_id

Line 5565: l_err_msg := 'Status returned by API wms_waveplan_tasks_pvt.query_tasks for cycle count task: '||x_return_status;

5561: );
5562:
5563:
5564: IF(l_debug = 1) THEN
5565: l_err_msg := 'Status returned by API wms_waveplan_tasks_pvt.query_tasks for cycle count task: '||x_return_status;
5566: inv_trx_util_pub.trace(l_api_name||': '||l_err_msg);
5567: END IF;
5568:
5569: IF (x_return_status = FND_API.G_RET_STS_SUCCESS) THEN

Line 5713: l_err_msg := 'Calling API wms_waveplan_tasks_pvt.query_tasks for task: '||p_transaction_number;

5709: FROM wms_dispatched_tasks_history
5710: WHERE transaction_id = p_transaction_number;
5711:
5712: IF(l_debug = 1) THEN
5713: l_err_msg := 'Calling API wms_waveplan_tasks_pvt.query_tasks for task: '||p_transaction_number;
5714: inv_trx_util_pub.trace(l_api_name||': '||l_err_msg);
5715: END IF;
5716:
5717: --Munish checking completed crossdock task

Line 5723: inv_trx_util_pub.trace('calling API wms_waveplan_tasks_pvt.query_tasks for completed crossdock task');

5719: FETCH c_cd_task1 into c_cd_exist;
5720: CLOSE c_cd_task1;
5721:
5722: If (c_cd_exist = 1) THEN
5723: inv_trx_util_pub.trace('calling API wms_waveplan_tasks_pvt.query_tasks for completed crossdock task');
5724: --CALLL wms_waveplan_tasks_pvt.query_tasks API WITH
5725: --p_crossdock_include=true and p_outbound_include=false and p_inbound_include=false
5726: wms_waveplan_tasks_pvt.query_tasks(
5727: p_add => FALSE

Line 5724: --CALLL wms_waveplan_tasks_pvt.query_tasks API WITH

5720: CLOSE c_cd_task1;
5721:
5722: If (c_cd_exist = 1) THEN
5723: inv_trx_util_pub.trace('calling API wms_waveplan_tasks_pvt.query_tasks for completed crossdock task');
5724: --CALLL wms_waveplan_tasks_pvt.query_tasks API WITH
5725: --p_crossdock_include=true and p_outbound_include=false and p_inbound_include=false
5726: wms_waveplan_tasks_pvt.query_tasks(
5727: p_add => FALSE
5728: ,p_organization_id => l_wdth_rec.organization_id

Line 5726: wms_waveplan_tasks_pvt.query_tasks(

5722: If (c_cd_exist = 1) THEN
5723: inv_trx_util_pub.trace('calling API wms_waveplan_tasks_pvt.query_tasks for completed crossdock task');
5724: --CALLL wms_waveplan_tasks_pvt.query_tasks API WITH
5725: --p_crossdock_include=true and p_outbound_include=false and p_inbound_include=false
5726: wms_waveplan_tasks_pvt.query_tasks(
5727: p_add => FALSE
5728: ,p_organization_id => l_wdth_rec.organization_id
5729: ,p_subinventory_code => l_wdth_rec.source_subinventory_code
5730: ,p_locator_id => l_wdth_rec.source_locator_id

Line 5768: --CALLL wms_waveplan_tasks_pvt.query_tasks API WITH p_crossdock_include=false and

5764: ,p_is_cancelled_plan => FALSE
5765: ,p_is_aborted_plan => FALSE
5766: );
5767: ELSE
5768: --CALLL wms_waveplan_tasks_pvt.query_tasks API WITH p_crossdock_include=false and
5769: --p_outbound_include=true and p_inbound_include=true
5770: inv_trx_util_pub.trace('calling completed inbound task');--mkgupta2
5771: IF l_wdth_rec.is_parent ='Y' THEN
5772: inv_trx_util_pub.trace('checking if its a parent task completed inbound task');

Line 5776: wms_waveplan_tasks_pvt.query_tasks(

5772: inv_trx_util_pub.trace('checking if its a parent task completed inbound task');
5773: l_wdth_rec.source_subinventory_code:=NULL;
5774: l_wdth_rec.source_locator_id:=NULL;
5775: END IF;
5776: wms_waveplan_tasks_pvt.query_tasks(
5777: p_add => FALSE
5778: ,p_organization_id => l_wdth_rec.organization_id
5779: ,p_subinventory_code => l_wdth_rec.source_subinventory_code
5780: ,p_locator_id => l_wdth_rec.source_locator_id

Line 5820: l_err_msg := 'Status returned by API wms_waveplan_tasks_pvt.query_tasks: '||x_return_status;

5816: );
5817: END IF;
5818:
5819: IF(l_debug = 1) THEN
5820: l_err_msg := 'Status returned by API wms_waveplan_tasks_pvt.query_tasks: '||x_return_status;
5821: inv_trx_util_pub.trace(l_api_name||': '||l_err_msg);
5822: END IF;
5823:
5824: IF (x_return_status = FND_API.G_RET_STS_SUCCESS) THEN

Line 5961: l_err_msg := 'Calling API wms_waveplan_tasks_pvt.query_tasks for task: '||p_transaction_number;

5957: WHERE transaction_id = p_transaction_number;
5958: inv_trx_util_pub.trace('task existing in mmt');
5959:
5960: IF(l_debug = 1) THEN
5961: l_err_msg := 'Calling API wms_waveplan_tasks_pvt.query_tasks for task: '||p_transaction_number;
5962: inv_trx_util_pub.trace(l_api_name||': '||l_err_msg);
5963: END IF;
5964:
5965: inv_trx_util_pub.trace('checking for bulk task');

Line 5969: wms_waveplan_tasks_pvt.query_tasks(

5965: inv_trx_util_pub.trace('checking for bulk task');
5966: IF l_mmt_rec.parent_transaction_id IS NOT NULL THEN
5967: l_mmt_rec.pick_slip_number:=NULL;
5968: END IF;
5969: wms_waveplan_tasks_pvt.query_tasks(
5970: p_add => FALSE
5971: ,p_organization_id => l_mmt_rec.organization_id
5972: ,p_subinventory_code => l_mmt_rec.subinventory_code
5973: ,p_locator_id => l_mmt_rec.locator_id

Line 6012: l_err_msg := 'Status returned by API wms_waveplan_tasks_pvt.query_tasks: '||x_return_status;

6008: ,p_is_aborted_plan =>FALSE
6009: );
6010:
6011: IF(l_debug = 1) THEN
6012: l_err_msg := 'Status returned by API wms_waveplan_tasks_pvt.query_tasks: '||x_return_status;
6013: inv_trx_util_pub.trace(l_api_name||': '||l_err_msg);
6014: END IF;
6015:
6016: IF (x_return_status = FND_API.G_RET_STS_SUCCESS) THEN

Line 6313: l_err_msg := 'Calling API wms_waveplan_tasks_pvt.query_tasks for Query: '||p_query_name;

6309: ---call the main API to find the queried tasks
6310: IF (l_execute_qry) THEN
6311:
6312: IF(l_debug = 1) THEN
6313: l_err_msg := 'Calling API wms_waveplan_tasks_pvt.query_tasks for Query: '||p_query_name;
6314: inv_trx_util_pub.trace(l_api_name||': '||l_err_msg);
6315: END IF;
6316:
6317: wms_waveplan_tasks_pvt.query_tasks (

Line 6317: wms_waveplan_tasks_pvt.query_tasks (

6313: l_err_msg := 'Calling API wms_waveplan_tasks_pvt.query_tasks for Query: '||p_query_name;
6314: inv_trx_util_pub.trace(l_api_name||': '||l_err_msg);
6315: END IF;
6316:
6317: wms_waveplan_tasks_pvt.query_tasks (
6318: FALSE, ---p_add BOOLEAN DEFAULT FALSE,
6319: l_organization_id, ---p_organization_id NUMBER DEFAULT NULL,
6320: g_main_tab(67).field_value, ---p_subinventory_code VARCHAR2 DEFAULT NULL,
6321: g_main_tab(40).field_value, ---p_locator_id NUMBER DEFAULT NULL,

Line 6422: l_err_msg := 'Status returned by API wms_waveplan_tasks_pvt.query_tasks: '||x_return_status;

6418: g_main_tab(47).field_value ---p_op_plan_id NUMBER DEFAULT NULL
6419: );
6420:
6421: IF(l_debug = 1) THEN
6422: l_err_msg := 'Status returned by API wms_waveplan_tasks_pvt.query_tasks: '||x_return_status;
6423: inv_trx_util_pub.trace(l_api_name||': '||l_err_msg);
6424: END IF;
6425:
6426: IF(x_return_status = FND_API.G_RET_STS_SUCCESS) THEN