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 5345: l_err_msg := 'Calling API wms_waveplan_tasks_pvt.query_tasks for task: '||p_transaction_number;

5341: FROM mtl_material_transactions_temp
5342: WHERE transaction_temp_id = p_transaction_number;
5343:
5344: IF(l_debug = 1) THEN
5345: l_err_msg := 'Calling API wms_waveplan_tasks_pvt.query_tasks for task: '||p_transaction_number;
5346: inv_trx_util_pub.trace(l_api_name||': '||l_err_msg);
5347: END IF;
5348:
5349: --Munish

Line 5355: --CALLL wms_waveplan_tasks_pvt.query_tasks API WITH

5351: FETCH c_cd_task into c_cd_exist;
5352: CLOSE c_cd_task;
5353:
5354: If (c_cd_exist = 1) THEN
5355: --CALLL wms_waveplan_tasks_pvt.query_tasks API WITH
5356: --p_crossdock_include=true and p_outbound_include=false and p_inbound_include=false
5357: wms_waveplan_tasks_pvt.query_tasks(
5358: p_add => FALSE
5359: ,p_organization_id => l_mmtt_rec.organization_id

Line 5357: wms_waveplan_tasks_pvt.query_tasks(

5353:
5354: If (c_cd_exist = 1) THEN
5355: --CALLL wms_waveplan_tasks_pvt.query_tasks API WITH
5356: --p_crossdock_include=true and p_outbound_include=false and p_inbound_include=false
5357: wms_waveplan_tasks_pvt.query_tasks(
5358: p_add => FALSE
5359: ,p_organization_id => l_mmtt_rec.organization_id
5360: ,p_subinventory_code => l_mmtt_rec.subinventory_code
5361: ,p_locator_id => l_mmtt_rec.locator_id

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

5396: ,p_is_aborted_plan => FALSE
5397: ,p_is_api_call => TRUE --Bug 13594691
5398: );
5399: ELSE
5400: --CALLL wms_waveplan_tasks_pvt.query_tasks API WITH p_crossdock_include=false and
5401: --p_outbound_include=true and p_inbound_include=true
5402: --MKGUPTA2 6868286 Start
5403: IF l_mmtt_rec.parent_line_id IS NOT NULL THEN
5404: l_mmtt_rec.pick_slip_number:=NULL;

Line 5410: wms_waveplan_tasks_pvt.query_tasks(

5406: l_mmtt_rec.subinventory_code:=NULL;
5407: l_mmtt_rec.locator_id:=NULL;
5408: END IF;
5409: -- 6868286 End
5410: wms_waveplan_tasks_pvt.query_tasks(
5411: p_add => FALSE
5412: ,p_organization_id => l_mmtt_rec.organization_id
5413: ,p_subinventory_code => l_mmtt_rec.subinventory_code
5414: ,p_locator_id => l_mmtt_rec.locator_id

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

5451: );
5452: END IF;
5453:
5454: IF(l_debug = 1) THEN
5455: l_err_msg := 'Status returned by API wms_waveplan_tasks_pvt.query_tasks: '||x_return_status;
5456: inv_trx_util_pub.trace(l_api_name||': '||l_err_msg);
5457: END IF;
5458:
5459: IF (x_return_status = FND_API.G_RET_STS_SUCCESS) THEN

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

5607: v_cycle_count_name := NULL;
5608: END;
5609:
5610: IF(l_debug = 1) THEN
5611: l_err_msg := 'Calling API wms_waveplan_tasks_pvt.query_tasks for cycle count task: '||p_transaction_number;
5612: inv_trx_util_pub.trace(l_api_name||': '||l_err_msg);
5613: inv_trx_util_pub.trace('Cycle Count Name '||v_cycle_count_name);
5614: END IF;
5615:

Line 5616: wms_waveplan_tasks_pvt.query_tasks(

5612: inv_trx_util_pub.trace(l_api_name||': '||l_err_msg);
5613: inv_trx_util_pub.trace('Cycle Count Name '||v_cycle_count_name);
5614: END IF;
5615:
5616: wms_waveplan_tasks_pvt.query_tasks(
5617: p_add => FALSE
5618: ,p_organization_id => l_mcce_rec.organization_id
5619: ,p_subinventory_code => l_mcce_rec.subinventory
5620: ,p_locator_id => l_mcce_rec.locator_id

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

5653: );
5654:
5655:
5656: IF(l_debug = 1) THEN
5657: l_err_msg := 'Status returned by API wms_waveplan_tasks_pvt.query_tasks for cycle count task: '||x_return_status;
5658: inv_trx_util_pub.trace(l_api_name||': '||l_err_msg);
5659: END IF;
5660:
5661: IF (x_return_status = FND_API.G_RET_STS_SUCCESS) THEN

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

5801: FROM wms_dispatched_tasks_history
5802: WHERE transaction_id = p_transaction_number;
5803:
5804: IF(l_debug = 1) THEN
5805: l_err_msg := 'Calling API wms_waveplan_tasks_pvt.query_tasks for task: '||p_transaction_number;
5806: inv_trx_util_pub.trace(l_api_name||': '||l_err_msg);
5807: END IF;
5808:
5809: --Munish checking completed crossdock task

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

5811: FETCH c_cd_task1 into c_cd_exist;
5812: CLOSE c_cd_task1;
5813:
5814: If (c_cd_exist = 1) THEN
5815: inv_trx_util_pub.trace('calling API wms_waveplan_tasks_pvt.query_tasks for completed crossdock task');
5816: --CALLL wms_waveplan_tasks_pvt.query_tasks API WITH
5817: --p_crossdock_include=true and p_outbound_include=false and p_inbound_include=false
5818: wms_waveplan_tasks_pvt.query_tasks(
5819: p_add => FALSE

Line 5816: --CALLL wms_waveplan_tasks_pvt.query_tasks API WITH

5812: CLOSE c_cd_task1;
5813:
5814: If (c_cd_exist = 1) THEN
5815: inv_trx_util_pub.trace('calling API wms_waveplan_tasks_pvt.query_tasks for completed crossdock task');
5816: --CALLL wms_waveplan_tasks_pvt.query_tasks API WITH
5817: --p_crossdock_include=true and p_outbound_include=false and p_inbound_include=false
5818: wms_waveplan_tasks_pvt.query_tasks(
5819: p_add => FALSE
5820: ,p_organization_id => l_wdth_rec.organization_id

Line 5818: wms_waveplan_tasks_pvt.query_tasks(

5814: If (c_cd_exist = 1) THEN
5815: inv_trx_util_pub.trace('calling API wms_waveplan_tasks_pvt.query_tasks for completed crossdock task');
5816: --CALLL wms_waveplan_tasks_pvt.query_tasks API WITH
5817: --p_crossdock_include=true and p_outbound_include=false and p_inbound_include=false
5818: wms_waveplan_tasks_pvt.query_tasks(
5819: p_add => FALSE
5820: ,p_organization_id => l_wdth_rec.organization_id
5821: ,p_subinventory_code => l_wdth_rec.source_subinventory_code
5822: ,p_locator_id => l_wdth_rec.source_locator_id

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

5857: ,p_is_aborted_plan => FALSE
5858: ,p_is_api_call => TRUE --Bug 13594691
5859: );
5860: ELSE
5861: --CALLL wms_waveplan_tasks_pvt.query_tasks API WITH p_crossdock_include=false and
5862: --p_outbound_include=true and p_inbound_include=true
5863: inv_trx_util_pub.trace('calling completed inbound task');--mkgupta2
5864: IF l_wdth_rec.is_parent ='Y' THEN
5865: inv_trx_util_pub.trace('checking if its a parent task completed inbound task');

Line 5869: wms_waveplan_tasks_pvt.query_tasks(

5865: inv_trx_util_pub.trace('checking if its a parent task completed inbound task');
5866: l_wdth_rec.source_subinventory_code:=NULL;
5867: l_wdth_rec.source_locator_id:=NULL;
5868: END IF;
5869: wms_waveplan_tasks_pvt.query_tasks(
5870: p_add => FALSE
5871: ,p_organization_id => l_wdth_rec.organization_id
5872: ,p_subinventory_code => l_wdth_rec.source_subinventory_code
5873: ,p_locator_id => l_wdth_rec.source_locator_id

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

5910: );
5911: END IF;
5912:
5913: IF(l_debug = 1) THEN
5914: l_err_msg := 'Status returned by API wms_waveplan_tasks_pvt.query_tasks: '||x_return_status;
5915: inv_trx_util_pub.trace(l_api_name||': '||l_err_msg);
5916: END IF;
5917:
5918: IF (x_return_status = FND_API.G_RET_STS_SUCCESS) THEN

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

6051: WHERE transaction_id = p_transaction_number;
6052: inv_trx_util_pub.trace('task existing in mmt');
6053:
6054: IF(l_debug = 1) THEN
6055: l_err_msg := 'Calling API wms_waveplan_tasks_pvt.query_tasks for task: '||p_transaction_number;
6056: inv_trx_util_pub.trace(l_api_name||': '||l_err_msg);
6057: END IF;
6058:
6059: inv_trx_util_pub.trace('checking for bulk task');

Line 6063: wms_waveplan_tasks_pvt.query_tasks(

6059: inv_trx_util_pub.trace('checking for bulk task');
6060: IF l_mmt_rec.parent_transaction_id IS NOT NULL THEN
6061: l_mmt_rec.pick_slip_number:=NULL;
6062: END IF;
6063: wms_waveplan_tasks_pvt.query_tasks(
6064: p_add => FALSE
6065: ,p_organization_id => l_mmt_rec.organization_id
6066: ,p_subinventory_code => l_mmt_rec.subinventory_code
6067: ,p_locator_id => l_mmt_rec.locator_id

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

6103: ,p_is_api_call => TRUE --Bug 13594691
6104: );
6105:
6106: IF(l_debug = 1) THEN
6107: l_err_msg := 'Status returned by API wms_waveplan_tasks_pvt.query_tasks: '||x_return_status;
6108: inv_trx_util_pub.trace(l_api_name||': '||l_err_msg);
6109: END IF;
6110:
6111: IF (x_return_status = FND_API.G_RET_STS_SUCCESS) THEN

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

6404: ---call the main API to find the queried tasks
6405: IF (l_execute_qry) THEN
6406:
6407: IF(l_debug = 1) THEN
6408: l_err_msg := 'Calling API wms_waveplan_tasks_pvt.query_tasks for Query: '||p_query_name;
6409: inv_trx_util_pub.trace(l_api_name||': '||l_err_msg);
6410: END IF;
6411:
6412: wms_waveplan_tasks_pvt.query_tasks (

Line 6412: wms_waveplan_tasks_pvt.query_tasks (

6408: l_err_msg := 'Calling API wms_waveplan_tasks_pvt.query_tasks for Query: '||p_query_name;
6409: inv_trx_util_pub.trace(l_api_name||': '||l_err_msg);
6410: END IF;
6411:
6412: wms_waveplan_tasks_pvt.query_tasks (
6413: FALSE, ---p_add BOOLEAN DEFAULT FALSE,
6414: l_organization_id, ---p_organization_id NUMBER DEFAULT NULL,
6415: g_main_tab(67).field_value, ---p_subinventory_code VARCHAR2 DEFAULT NULL,
6416: g_main_tab(40).field_value, ---p_locator_id NUMBER DEFAULT NULL,

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

6513: g_main_tab(47).field_value ---p_op_plan_id NUMBER DEFAULT NULL
6514: );
6515:
6516: IF(l_debug = 1) THEN
6517: l_err_msg := 'Status returned by API wms_waveplan_tasks_pvt.query_tasks: '||x_return_status;
6518: inv_trx_util_pub.trace(l_api_name||': '||l_err_msg);
6519: END IF;
6520:
6521: IF(x_return_status = FND_API.G_RET_STS_SUCCESS) THEN