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_WAVE_PLANNING_PVT dependencies on WMS_WP_TASKS_GTMP

Line 14337: l_message WMS_WP_TASKS_GTMP.error%TYPE;

14333: l_statuses status_table_type;
14334: l_transaction_temp_ids_temp WMS_WAVE_PLANNING_PVT.transaction_temp_table_type;
14335: l_device_id NUMBER;
14336: l_messages WMS_WAVE_PLANNING_PVT.message_table_type;
14337: l_message WMS_WP_TASKS_GTMP.error%TYPE;
14338: g_cannot_update_putaway WMS_WP_TASKS_GTMP.error%TYPE;
14339: g_task_updated WMS_WP_TASKS_GTMP.error%TYPE;
14340:
14341: BEGIN

Line 14338: g_cannot_update_putaway WMS_WP_TASKS_GTMP.error%TYPE;

14334: l_transaction_temp_ids_temp WMS_WAVE_PLANNING_PVT.transaction_temp_table_type;
14335: l_device_id NUMBER;
14336: l_messages WMS_WAVE_PLANNING_PVT.message_table_type;
14337: l_message WMS_WP_TASKS_GTMP.error%TYPE;
14338: g_cannot_update_putaway WMS_WP_TASKS_GTMP.error%TYPE;
14339: g_task_updated WMS_WP_TASKS_GTMP.error%TYPE;
14340:
14341: BEGIN
14342: print_debug('XXXX Update Wave Header Status: ', l_debug);

Line 14339: g_task_updated WMS_WP_TASKS_GTMP.error%TYPE;

14335: l_device_id NUMBER;
14336: l_messages WMS_WAVE_PLANNING_PVT.message_table_type;
14337: l_message WMS_WP_TASKS_GTMP.error%TYPE;
14338: g_cannot_update_putaway WMS_WP_TASKS_GTMP.error%TYPE;
14339: g_task_updated WMS_WP_TASKS_GTMP.error%TYPE;
14340:
14341: BEGIN
14342: print_debug('XXXX Update Wave Header Status: ', l_debug);
14343:

Line 14357: UPDATE wms_wp_tasks_gtmp

14353:
14354: END IF;
14355:
14356: FORALL i IN p_transaction_temp_id.FIRST .. p_transaction_temp_id.LAST
14357: UPDATE wms_wp_tasks_gtmp
14358: SET RESULT = 'X'
14359: WHERE transaction_temp_id = p_transaction_temp_id (i)
14360: AND task_type_id = p_task_type_id (i);
14361:

Line 14373: UPDATE wms_wp_tasks_gtmp

14369: -- 6 Move Order Issue
14370: -- 7 Staging Move
14371:
14372: -- Cannot update putaway tasks or staging moves
14373: UPDATE wms_wp_tasks_gtmp
14374: SET RESULT = 'E',
14375: error =
14376: DECODE (task_type_id,
14377: 2, g_cannot_update_putaway

Line 14392: UPDATE wms_wp_tasks_gtmp

14388: -- 5 Move Order Transfer
14389: -- 6 Move Order Issue
14390: -- 7 Staging Move
14391: /* FORALL i IN p_transaction_temp_id.FIRST .. p_transaction_temp_id.LAST
14392: UPDATE wms_wp_tasks_gtmp
14393: SET RESULT = 'X'
14394: WHERE transaction_temp_id = p_transaction_temp_id(i)
14395: AND task_type_id = p_task_type_id(i);*/
14396:

Line 14401: FROM wms_wp_tasks_gtmp

14397: -- Invalid status changes
14398: IF p_to_status_id IS NOT NULL THEN
14399: SELECT transaction_temp_id, task_type_id, status BULK COLLECT
14400: INTO l_transaction_temp_ids, l_task_type_ids, l_statuses
14401: FROM wms_wp_tasks_gtmp
14402: WHERE RESULT = 'X'
14403: AND NOT ((status_id = 8 AND p_to_status_id IN (1, 2)) -- Unreleased to pending or queued
14404: OR (status_id = 1 AND p_to_status_id IN (2, 8)) -- Pending to queued or unreleased
14405: OR (status_id = 2 AND p_to_status_id IN (1, 8)) -- Queued to pending or unreleased

Line 14418: UPDATE wms_wp_tasks_gtmp

14414: l_messages(i) := fnd_message.get;
14415: END LOOP;
14416:
14417: FORALL i IN l_transaction_temp_ids.FIRST .. l_transaction_temp_ids.LAST
14418: UPDATE wms_wp_tasks_gtmp
14419: SET RESULT = 'E', error = l_messages(i)
14420: WHERE transaction_temp_id = l_transaction_temp_ids(i)
14421: AND task_type_id = l_task_type_ids(i);
14422: END IF;

Line 14427: FROM wms_wp_tasks_gtmp wwtt,

14423:
14424: IF p_to_status_id IN (1, 8) THEN
14425: SELECT wwtt.transaction_temp_id, wwtt.task_type_id, wwtt.status BULK COLLECT
14426: INTO l_transaction_temp_ids, l_task_type_ids, l_statuses
14427: FROM wms_wp_tasks_gtmp wwtt,
14428: mtl_material_transactions_temp mmtt,
14429: WMS_DISPATCHED_TASKS wdt
14430: WHERE wwtt.transaction_temp_id = wdt.transaction_temp_id
14431: AND wwtt.transaction_temp_id = mmtt.transaction_temp_id

Line 14467: UPDATE wms_wp_tasks_gtmp

14463: l_messages(i) := fnd_message.get;
14464: END LOOP;
14465:
14466: FORALL i IN l_transaction_temp_ids.FIRST .. l_transaction_temp_ids.LAST
14467: UPDATE wms_wp_tasks_gtmp
14468: SET RESULT = 'E',
14469: error = 'This group of tasks is currently being worked, cannot change status'
14470: WHERE transaction_temp_id = l_transaction_temp_ids(i)
14471: AND task_type_id = l_task_type_ids(i);

Line 14480: FROM wms_wp_tasks_gtmp wwtt

14476: -- if the original task status is Active, check if the user whom the task is assigned is
14477: -- logged on to the system
14478: SELECT transaction_temp_id, task_type_id, status BULK COLLECT
14479: INTO l_transaction_temp_ids, l_task_type_ids, l_statuses
14480: FROM wms_wp_tasks_gtmp wwtt
14481: WHERE RESULT = 'X'
14482: AND status_id = 9
14483: AND EXISTS
14484: (SELECT 1

Line 14493: UPDATE wms_wp_tasks_gtmp

14489: AND MMLH.EVENT_MESSAGE IS NULL);
14490:
14491: IF l_transaction_temp_ids.COUNT > 0 THEN
14492: FORALL i IN l_transaction_temp_ids.FIRST .. l_transaction_temp_ids.LAST
14493: UPDATE wms_wp_tasks_gtmp
14494: SET RESULT = 'E',
14495: error = 'This task is currently being worked, cannot change status'
14496: WHERE transaction_temp_id = l_transaction_temp_ids(i)
14497: AND task_type_id = l_task_type_ids(i);

Line 14510: UPDATE wms_wp_tasks_gtmp wwtt

14506: fnd_message.set_name('WMS', 'WMS_CANNOT_UPDATE_EMPLOYEE');
14507: fnd_message.set_token('EMPLOYEE', p_employee);
14508: l_message := fnd_message.get;
14509:
14510: UPDATE wms_wp_tasks_gtmp wwtt
14511: SET RESULT = 'E', error = l_message
14512: WHERE RESULT = 'X'
14513: AND NOT EXISTS
14514: (SELECT 1

Line 14522: FROM wms_wp_tasks_gtmp

14518: AND bre.person_id = p_employee_id);
14519:
14520: SELECT transaction_temp_id BULK COLLECT
14521: INTO l_transaction_temp_ids_temp
14522: FROM wms_wp_tasks_gtmp
14523: WHERE RESULT = 'X';
14524:
14525: --j Develop
14526: IF (l_transaction_temp_ids_temp.COUNT > 0) THEN

Line 14538: UPDATE wms_wp_tasks_gtmp wwtt

14534: print_DEBUG('l_device_id : ' || l_device_id, l_debug);
14535: print_DEBUG(' p_employee_id : ' || p_employee_id, l_debug);
14536: end if;
14537:
14538: UPDATE wms_wp_tasks_gtmp wwtt
14539: SET RESULT = 'E', error = l_message
14540: WHERE transaction_temp_id = l_transaction_temp_ids_temp(i)
14541: AND NOT EXISTS
14542: (SELECT 1

Line 14552: UPDATE wms_wp_tasks_gtmp wwtt

14548: END IF;
14549: -- End of J Develop
14550: END IF;
14551:
14552: UPDATE wms_wp_tasks_gtmp wwtt
14553: SET person_resource_id = (SELECT bre.resource_id
14554: FROM bom_std_op_resources bsor,
14555: bom_resource_employees bre
14556: WHERE wwtt.user_task_type_id =

Line 14567: UPDATE wms_wp_tasks_gtmp wwtt

14563: IF p_user_task_type_id IS NOT NULL THEN
14564: -- R12: Can update User Task Type if task is dispatched, active IF
14565: -- Dispatched or Active tasks are in the process of getting updated to pending or Unreleased
14566: IF p_to_status_id IS NOT NULL THEN
14567: UPDATE wms_wp_tasks_gtmp wwtt
14568: SET RESULT = 'E', error = l_message
14569: WHERE RESULT = 'X'
14570: AND (status_id NOT IN (1, 2, 3, 8, 9) AND
14571: p_to_status_id IN (1, 8))

Line 14576: UPDATE wms_wp_tasks_gtmp wwtt

14572: RETURNING transaction_temp_id, task_type_id, status BULK COLLECT INTO l_transaction_temp_ids, l_task_type_ids, l_statuses;
14573: ELSE
14574: -- R12: Cannot update User Task Type if task is dispatched, active or loaded IF
14575: -- Dispatched or Active tasks are NOT in the process of getting updated to pending or Unreleased
14576: UPDATE wms_wp_tasks_gtmp wwtt
14577: SET RESULT = 'E', error = l_message
14578: WHERE RESULT = 'X'
14579: AND status_id NOT IN (1, 8)
14580: RETURNING transaction_temp_id, task_type_id, status BULK COLLECT INTO l_transaction_temp_ids, l_task_type_ids, l_statuses;

Line 14591: UPDATE wms_wp_tasks_gtmp

14587: l_messages(i) := fnd_message.get;
14588: END LOOP;
14589:
14590: FORALL i IN l_transaction_temp_ids.FIRST .. l_transaction_temp_ids.LAST
14591: UPDATE wms_wp_tasks_gtmp
14592: SET RESULT = 'E', error = l_messages(i)
14593: WHERE transaction_temp_id = l_transaction_temp_ids(i)
14594: AND task_type_id = l_task_type_ids(i);
14595: END IF;

Line 14604: UPDATE wms_wp_tasks_gtmp wwtt

14600: p_clear_priority = 'Y' THEN
14601: -- R12: Can update priority if task is dispatched, active IF
14602: -- Dispatched or Active tasks are in the process of getting updated to pending or Unreleased
14603: IF p_to_status_id IS NOT NULL THEN
14604: UPDATE wms_wp_tasks_gtmp wwtt
14605: SET RESULT = 'E', error = l_message
14606: WHERE RESULT = 'X'
14607: AND (status_id NOT IN (1, 2, 3, 8, 9) AND
14608: p_to_status_id IN (1, 8))

Line 14613: UPDATE wms_wp_tasks_gtmp wwtt

14609: RETURNING transaction_temp_id, task_type_id, status BULK COLLECT INTO l_transaction_temp_ids, l_task_type_ids, l_statuses;
14610: ELSE
14611: -- R12: Cannot update priority if task is dispatched, active or loaded IF
14612: -- Dispatched or Active tasks are NOT in the process of getting updated to pending or Unreleased
14613: UPDATE wms_wp_tasks_gtmp wwtt
14614: SET RESULT = 'E', error = l_message
14615: WHERE RESULT = 'X'
14616: AND status_id NOT IN (1, 2, 8)
14617: RETURNING transaction_temp_id, task_type_id, status BULK COLLECT INTO l_transaction_temp_ids, l_task_type_ids, l_statuses;

Line 14628: UPDATE wms_wp_tasks_gtmp

14624: l_messages(i) := fnd_message.get;
14625: END LOOP;
14626:
14627: FORALL i IN l_transaction_temp_ids.FIRST .. l_transaction_temp_ids.LAST
14628: UPDATE wms_wp_tasks_gtmp
14629: SET RESULT = 'E', error = l_messages(i)
14630: WHERE transaction_temp_id = l_transaction_temp_ids(i)
14631: AND task_type_id = l_task_type_ids(i);
14632: END IF;

Line 14637: UPDATE wms_wp_tasks_gtmp

14633: END IF;
14634:
14635: -- If changing status to Queued
14636: IF p_to_status_id = 2 THEN
14637: UPDATE wms_wp_tasks_gtmp
14638: SET task_id = NVL(task_id, wms_dispatched_tasks_s.NEXTVAL),
14639: status = p_to_status,
14640: status_id = p_to_status_id,
14641: priority = DECODE(p_clear_priority,

Line 14675: UPDATE wms_wp_tasks_gtmp

14671:
14672: if l_debug = 1 then
14673: print_DEBUG('Else Part ______________________: ', l_debug);
14674: end if;
14675: UPDATE wms_wp_tasks_gtmp
14676: SET task_id = DECODE(p_to_status_id,
14677: 1,
14678: NULL,
14679: 8,

Line 14753: UPDATE wms_wp_tasks_gtmp

14749: end if;
14750: END IF;
14751:
14752: FORALL i IN p_transaction_temp_id.FIRST .. p_transaction_temp_id.LAST
14753: UPDATE wms_wp_tasks_gtmp
14754: SET RESULT = RESULT
14755: WHERE transaction_temp_id = p_transaction_temp_id(i)
14756: AND task_type_id = p_task_type_id(i)
14757: RETURNING task_id, RESULT, error BULK COLLECT INTO x_task_id, x_result, x_message;

Line 14828: FROM wms_wp_tasks_gtmp wwtt

14824: priority,
14825: priority_original,
14826: user_task_type_id,
14827: num_of_child_tasks
14828: FROM wms_wp_tasks_gtmp wwtt
14829: WHERE wwtt.is_modified = 'Y';
14830:
14831: --Patchset J: Bulk picking
14832: --Get the transaction_temp_id of the children tasks

Line 14878: UPDATE wms_wp_tasks_gtmp

14874: fnd_message.set_name('WMS', 'WMS_PLAN_CANCELLED');
14875: g_plan_cancelled := fnd_message.get;
14876: END IF;
14877:
14878: UPDATE wms_wp_tasks_gtmp
14879: SET is_modified = 'N', RESULT = 'S', error = g_plan_cancelled
14880: WHERE transaction_temp_id = rec_wwtt.transaction_temp_id;
14881:
14882: END IF;

Line 14997: FROM wms_wp_tasks_gtmp wwtt

14993: DELETE wms_dispatched_tasks wdt
14994: WHERE wdt.status IN (2, 3, 9) -- R12: Delete the Active or Dispatched tasks which were updated to pending/Unreleased
14995: AND wdt.transaction_temp_id IN
14996: (SELECT transaction_temp_id
14997: FROM wms_wp_tasks_gtmp wwtt
14998: WHERE wwtt.status_id IN (1, 8)
14999: AND wwtt.is_modified = 'Y');
15000: if l_debug = 1 then
15001: print_DEBUG('No of records deleted are-555 ' || SQL%ROWCOUNT,

Line 15054: FROM wms_wp_tasks_gtmp wwtt

15050: wwtt.priority,
15051: wwtt.move_order_line_id,
15052: wwtt.operation_plan_id,
15053: wwtt.to_lpn_id
15054: FROM wms_wp_tasks_gtmp wwtt
15055: WHERE wwtt.status_id = 2
15056: AND wwtt.status_id_original IN (1, 8)
15057: AND wwtt.is_modified = 'Y'
15058: AND NOT EXISTS

Line 15091: UPDATE wms_wp_tasks_gtmp

15087: END IF;
15088:
15089: -- forall i IN l_transaction_temp_id_table.first..l_transaction_temp_id_table.last
15090: FORALL i IN 1 .. l_transaction_temp_id_table.COUNT
15091: UPDATE wms_wp_tasks_gtmp
15092: SET RESULT = 'S',
15093: error = g_task_saved,
15094: is_modified = 'N',
15095: person_id_original = l_person_id_table(i),

Line 15124: UPDATE wms_wp_tasks_gtmp

15120:
15121: fnd_message.set_name('FND', 'FORM_RECORD_CHANGED');
15122: l_error_message := fnd_message.get;
15123:
15124: UPDATE wms_wp_tasks_gtmp
15125: SET RESULT = 'E', error = l_error_message
15126: WHERE is_modified = 'Y';
15127:
15128: if l_debug = 1 then

Line 15176: TYPE num_of_child_tasks_type IS TABLE OF wms_wp_tasks_gtmp.num_of_child_tasks%TYPE;

15172: PROCEDURE set_num_of_child_tasks IS
15173: l_debug NUMBER := NVL(fnd_profile.VALUE('INV_DEBUG_TRACE'), 0);
15174: l_progress NUMBER;
15175:
15176: TYPE num_of_child_tasks_type IS TABLE OF wms_wp_tasks_gtmp.num_of_child_tasks%TYPE;
15177: l_num_of_child_tasks_tbl num_of_child_tasks_type;
15178: l_parent_temp_ids_tbl wms_wave_planning_pvt.transaction_temp_table_type;
15179: BEGIN
15180: IF l_debug = 1 THEN

Line 15192: FROM wms_wp_tasks_gtmp wwtt, mtl_material_transactions_temp mmtt

15188: --MMTT used to get children task.
15189: --wwtt used to get the parent task.
15190: SELECT COUNT(1), wwtt.transaction_temp_id BULK COLLECT
15191: INTO l_num_of_child_tasks_tbl, l_parent_temp_ids_tbl
15192: FROM wms_wp_tasks_gtmp wwtt, mtl_material_transactions_temp mmtt
15193: WHERE wwtt.transaction_temp_id = mmtt.parent_line_id
15194: AND wwtt.transaction_temp_id <> mmtt.transaction_temp_id
15195: GROUP BY wwtt.transaction_temp_id;
15196:

Line 15202: UPDATE wms_wp_tasks_gtmp wwtt

15198:
15199: IF l_num_of_child_tasks_tbl.COUNT > 0 THEN
15200: l_progress := 30;
15201: FORALL i IN l_num_of_child_tasks_tbl.FIRST .. l_num_of_child_tasks_tbl.LAST
15202: UPDATE wms_wp_tasks_gtmp wwtt
15203: SET wwtt.num_of_child_tasks = l_num_of_child_tasks_tbl(i)
15204: WHERE wwtt.transaction_temp_id = l_parent_temp_ids_tbl(i);
15205: l_progress := 40;
15206: END IF;

Line 17143: --populate wms_wp_tasks_gtmp using view wms_wp_wwb_tasks_v and transaction_temp_id in l_transaction_temp_id

17139: l_task_type_id_table.count = 0) THEN
17140: RETURN;
17141: END IF;
17142:
17143: --populate wms_wp_tasks_gtmp using view wms_wp_wwb_tasks_v and transaction_temp_id in l_transaction_temp_id
17144: FORALL ttemp_id IN l_transaction_temp_id_table.FIRST .. l_transaction_temp_id_table.LAST
17145: insert into wms_wp_tasks_gtmp
17146: select task_id,
17147: to_lpn,

Line 17145: insert into wms_wp_tasks_gtmp

17141: END IF;
17142:
17143: --populate wms_wp_tasks_gtmp using view wms_wp_wwb_tasks_v and transaction_temp_id in l_transaction_temp_id
17144: FORALL ttemp_id IN l_transaction_temp_id_table.FIRST .. l_transaction_temp_id_table.LAST
17145: insert into wms_wp_tasks_gtmp
17146: select task_id,
17147: to_lpn,
17148: to_lpn_id,
17149: transaction_temp_id,

Line 17905: delete from wms_wp_tasks_gtmp;

17901:
17902: delete wms_wp_orders_gtmp;
17903: delete wms_wp_lines_gtmp;
17904: delete from wms_wp_exceptions_gtmp;
17905: delete from wms_wp_tasks_gtmp;
17906: delete from wms_wp_labor_gtmp;
17907:
17908: --Orders GTMP
17909: --bug12371804 query from base tables instead of from wms_wp_wwb_orders_v for performance

Line 18192: insert into wms_wp_tasks_gtmp(

18188:
18189:
18190:
18191: --12371804 query from base tables instead of from wms_wp_wwb_tasks_v
18192: insert into wms_wp_tasks_gtmp(
18193: TASK_ID,
18194: TO_LPN,
18195: TO_LPN_ID,
18196: TRANSACTION_TEMP_ID,