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_LOAD dependencies on WMS_PICKING_PKG

Line 5079: wms_picking_pkg.g_start_over_tempid.DELETE;

5075: mydebug('viks l_start_over_task return froom proc_start_over :' ||l_start_over_task);
5076: ELSE
5077: mydebug('viks start_over button not pressed :');
5078: --only when it is not start over case, the retain task will be used 431009
5079: wms_picking_pkg.g_start_over_tempid.DELETE;
5080: IF p_retain_task = 'Y' THEN --{ bug 4310093
5081: mydebug('change the task status to Dispatched if retain_task is Y');
5082: UPDATE wms_dispatched_tasks
5083: SET status = l_g_task_dispatched

Line 5678: l_prev_task_status := wms_picking_pkg.g_previous_task_status(p_transaction_temp_id);

5674: -- There is no need to check for a specific header_id . For F2, we anyway always
5675: -- delete all dispatched and active tasks
5676:
5677: BEGIN
5678: l_prev_task_status := wms_picking_pkg.g_previous_task_status(p_transaction_temp_id);
5679: wms_picking_pkg.g_previous_task_status.delete(p_transaction_temp_id);
5680: EXCEPTION
5681: WHEN OTHERS THEN
5682: mydebug('wms_picking_pkg.g_previous_task_status(p_transaction_temp_id) : ' || p_transaction_temp_id

Line 5679: wms_picking_pkg.g_previous_task_status.delete(p_transaction_temp_id);

5675: -- delete all dispatched and active tasks
5676:
5677: BEGIN
5678: l_prev_task_status := wms_picking_pkg.g_previous_task_status(p_transaction_temp_id);
5679: wms_picking_pkg.g_previous_task_status.delete(p_transaction_temp_id);
5680: EXCEPTION
5681: WHEN OTHERS THEN
5682: mydebug('wms_picking_pkg.g_previous_task_status(p_transaction_temp_id) : ' || p_transaction_temp_id
5683: || ' : not found' );

Line 5682: mydebug('wms_picking_pkg.g_previous_task_status(p_transaction_temp_id) : ' || p_transaction_temp_id

5678: l_prev_task_status := wms_picking_pkg.g_previous_task_status(p_transaction_temp_id);
5679: wms_picking_pkg.g_previous_task_status.delete(p_transaction_temp_id);
5680: EXCEPTION
5681: WHEN OTHERS THEN
5682: mydebug('wms_picking_pkg.g_previous_task_status(p_transaction_temp_id) : ' || p_transaction_temp_id
5683: || ' : not found' );
5684: l_prev_task_status := l_g_task_pending;
5685: END ;
5686:

Line 5713: l_prev_task_status := wms_picking_pkg.g_previous_task_status(rec_reset_task_status.transaction_temp_id);

5709: mydebug('l_progress = ' || l_progress || ' Update status of all other tasks in this group' );
5710: FOR rec_reset_task_status IN cur_reset_task_status
5711: LOOP
5712: BEGIN
5713: l_prev_task_status := wms_picking_pkg.g_previous_task_status(rec_reset_task_status.transaction_temp_id);
5714: wms_picking_pkg.g_previous_task_status.delete(rec_reset_task_status.transaction_temp_id);
5715: EXCEPTION
5716: WHEN OTHERS THEN
5717: mydebug('wms_picking_pkg.g_previous_task_status(transaction_temp_id) : '

Line 5714: wms_picking_pkg.g_previous_task_status.delete(rec_reset_task_status.transaction_temp_id);

5710: FOR rec_reset_task_status IN cur_reset_task_status
5711: LOOP
5712: BEGIN
5713: l_prev_task_status := wms_picking_pkg.g_previous_task_status(rec_reset_task_status.transaction_temp_id);
5714: wms_picking_pkg.g_previous_task_status.delete(rec_reset_task_status.transaction_temp_id);
5715: EXCEPTION
5716: WHEN OTHERS THEN
5717: mydebug('wms_picking_pkg.g_previous_task_status(transaction_temp_id) : '
5718: || rec_reset_task_status.transaction_temp_id || ' : not found' );

Line 5717: mydebug('wms_picking_pkg.g_previous_task_status(transaction_temp_id) : '

5713: l_prev_task_status := wms_picking_pkg.g_previous_task_status(rec_reset_task_status.transaction_temp_id);
5714: wms_picking_pkg.g_previous_task_status.delete(rec_reset_task_status.transaction_temp_id);
5715: EXCEPTION
5716: WHEN OTHERS THEN
5717: mydebug('wms_picking_pkg.g_previous_task_status(transaction_temp_id) : '
5718: || rec_reset_task_status.transaction_temp_id || ' : not found' );
5719: l_prev_task_status := l_g_task_pending;
5720: END ;
5721: mydebug('l_prev_task_status = ' || l_prev_task_status || ' for transaction_temp_id: '

Line 5836: l_prev_task_status := wms_picking_pkg.g_previous_task_status(p_transaction_temp_id);

5832: mydebug ('p_transaction_header_id : ' || p_transaction_header_id);
5833: mydebug ('p_transaction_temp_id : ' || p_transaction_temp_id );
5834: l_progress := 110;
5835:
5836: l_prev_task_status := wms_picking_pkg.g_previous_task_status(p_transaction_temp_id);
5837:
5838: SELECT count(*) into new_mmtt_count from mtl_allocations_gtmp;
5839: mydebug('Total count in mtl_allocations_gtemp: ' || new_mmtt_count);
5840:

Line 5841: l_first_index := wms_picking_pkg.g_start_over_tempid.first;

5837:
5838: SELECT count(*) into new_mmtt_count from mtl_allocations_gtmp;
5839: mydebug('Total count in mtl_allocations_gtemp: ' || new_mmtt_count);
5840:
5841: l_first_index := wms_picking_pkg.g_start_over_tempid.first;
5842: l_existing_count := wms_picking_pkg.g_start_over_tempid.count-1;
5843:
5844: mydebug('l_first_index is : ' ||l_first_index);
5845: mydebug('l_existing_count is : ' || l_existing_count);

Line 5842: l_existing_count := wms_picking_pkg.g_start_over_tempid.count-1;

5838: SELECT count(*) into new_mmtt_count from mtl_allocations_gtmp;
5839: mydebug('Total count in mtl_allocations_gtemp: ' || new_mmtt_count);
5840:
5841: l_first_index := wms_picking_pkg.g_start_over_tempid.first;
5842: l_existing_count := wms_picking_pkg.g_start_over_tempid.count-1;
5843:
5844: mydebug('l_first_index is : ' ||l_first_index);
5845: mydebug('l_existing_count is : ' || l_existing_count);
5846:

Line 5858: wms_picking_pkg.g_start_over_tempid(i+l_move_index_offset) := wms_picking_pkg.g_start_over_tempid(i);

5854: l_move_index_offset := (new_mmtt_count+1) - l_first_index;
5855: mydebug('Inl_move_index_offset:'||l_move_index_offset);
5856: if (l_move_index_offset >0) then -- move forward
5857: for i in REVERSE l_first_index .. (l_first_index+l_existing_count) LOOP
5858: wms_picking_pkg.g_start_over_tempid(i+l_move_index_offset) := wms_picking_pkg.g_start_over_tempid(i);
5859: mydebug('In else index :' ||i);
5860: END LOOP;
5861:
5862: elsif (l_move_index_offset <0) then -- move backward

Line 5864: wms_picking_pkg.g_start_over_tempid(i+l_move_index_offset) := wms_picking_pkg.g_start_over_tempid(i);

5860: END LOOP;
5861:
5862: elsif (l_move_index_offset <0) then -- move backward
5863: for i in l_first_index..l_first_index+l_existing_count LOOP
5864: wms_picking_pkg.g_start_over_tempid(i+l_move_index_offset) := wms_picking_pkg.g_start_over_tempid(i);
5865: wms_picking_pkg.g_start_over_tempid.DELETE(i);
5866: mydebug('In else if index offset is Neg:' ||wms_picking_pkg.g_start_over_tempid(i+l_move_index_offset));
5867: mydebug('In elseif index :' ||i);
5868: END LOOP;

Line 5865: wms_picking_pkg.g_start_over_tempid.DELETE(i);

5861:
5862: elsif (l_move_index_offset <0) then -- move backward
5863: for i in l_first_index..l_first_index+l_existing_count LOOP
5864: wms_picking_pkg.g_start_over_tempid(i+l_move_index_offset) := wms_picking_pkg.g_start_over_tempid(i);
5865: wms_picking_pkg.g_start_over_tempid.DELETE(i);
5866: mydebug('In else if index offset is Neg:' ||wms_picking_pkg.g_start_over_tempid(i+l_move_index_offset));
5867: mydebug('In elseif index :' ||i);
5868: END LOOP;
5869: end if;

Line 5866: mydebug('In else if index offset is Neg:' ||wms_picking_pkg.g_start_over_tempid(i+l_move_index_offset));

5862: elsif (l_move_index_offset <0) then -- move backward
5863: for i in l_first_index..l_first_index+l_existing_count LOOP
5864: wms_picking_pkg.g_start_over_tempid(i+l_move_index_offset) := wms_picking_pkg.g_start_over_tempid(i);
5865: wms_picking_pkg.g_start_over_tempid.DELETE(i);
5866: mydebug('In else if index offset is Neg:' ||wms_picking_pkg.g_start_over_tempid(i+l_move_index_offset));
5867: mydebug('In elseif index :' ||i);
5868: END LOOP;
5869: end if;
5870: END IF;

Line 5871: mydebug('Cont of table :'||wms_picking_pkg.g_start_over_tempid.COUNT);

5867: mydebug('In elseif index :' ||i);
5868: END LOOP;
5869: end if;
5870: END IF;
5871: mydebug('Cont of table :'||wms_picking_pkg.g_start_over_tempid.COUNT);
5872: -- insert temp id value into pl/sql table
5873:
5874: p := 1;
5875: FOR tempid_rec IN tempid_cur(v_transaction_temp_id => p_transaction_temp_id)

Line 5877: wms_picking_pkg.g_start_over_tempid(p) := tempid_rec.transaction_temp_id;

5873:
5874: p := 1;
5875: FOR tempid_rec IN tempid_cur(v_transaction_temp_id => p_transaction_temp_id)
5876: LOOP
5877: wms_picking_pkg.g_start_over_tempid(p) := tempid_rec.transaction_temp_id;
5878: mydebug('Temp ids in plsql :'||wms_picking_pkg.g_start_over_tempid(p)||'Index:'||p);
5879: wms_picking_pkg.g_previous_task_status(wms_picking_pkg.g_start_over_tempid(p)) :=l_prev_task_status;
5880: p := p +1;
5881: IF SQL%NOTFOUND THEN

Line 5878: mydebug('Temp ids in plsql :'||wms_picking_pkg.g_start_over_tempid(p)||'Index:'||p);

5874: p := 1;
5875: FOR tempid_rec IN tempid_cur(v_transaction_temp_id => p_transaction_temp_id)
5876: LOOP
5877: wms_picking_pkg.g_start_over_tempid(p) := tempid_rec.transaction_temp_id;
5878: mydebug('Temp ids in plsql :'||wms_picking_pkg.g_start_over_tempid(p)||'Index:'||p);
5879: wms_picking_pkg.g_previous_task_status(wms_picking_pkg.g_start_over_tempid(p)) :=l_prev_task_status;
5880: p := p +1;
5881: IF SQL%NOTFOUND THEN
5882: mydebug('transaction_temp_id not found only one temp_id present: ');

Line 5879: wms_picking_pkg.g_previous_task_status(wms_picking_pkg.g_start_over_tempid(p)) :=l_prev_task_status;

5875: FOR tempid_rec IN tempid_cur(v_transaction_temp_id => p_transaction_temp_id)
5876: LOOP
5877: wms_picking_pkg.g_start_over_tempid(p) := tempid_rec.transaction_temp_id;
5878: mydebug('Temp ids in plsql :'||wms_picking_pkg.g_start_over_tempid(p)||'Index:'||p);
5879: wms_picking_pkg.g_previous_task_status(wms_picking_pkg.g_start_over_tempid(p)) :=l_prev_task_status;
5880: p := p +1;
5881: IF SQL%NOTFOUND THEN
5882: mydebug('transaction_temp_id not found only one temp_id present: ');
5883: p :=1;

Line 5888: wms_picking_pkg.g_start_over_tempid(p):= p_transaction_temp_id;

5884: END IF;
5885:
5886: END LOOP;
5887:
5888: wms_picking_pkg.g_start_over_tempid(p):= p_transaction_temp_id;
5889: mydebug('Temp id sent last is :'||wms_picking_pkg.g_start_over_tempid(p) ||'Index is::'||p);
5890:
5891: L:=0;
5892:

Line 5889: mydebug('Temp id sent last is :'||wms_picking_pkg.g_start_over_tempid(p) ||'Index is::'||p);

5885:
5886: END LOOP;
5887:
5888: wms_picking_pkg.g_start_over_tempid(p):= p_transaction_temp_id;
5889: mydebug('Temp id sent last is :'||wms_picking_pkg.g_start_over_tempid(p) ||'Index is::'||p);
5890:
5891: L:=0;
5892:
5893: -- Updating wdd status and printing final values sent in pl/sql table

Line 5895: forall L in wms_picking_pkg.g_start_over_tempid.FIRST .. wms_picking_pkg.g_start_over_tempid.LAST

5891: L:=0;
5892:
5893: -- Updating wdd status and printing final values sent in pl/sql table
5894:
5895: forall L in wms_picking_pkg.g_start_over_tempid.FIRST .. wms_picking_pkg.g_start_over_tempid.LAST
5896: UPDATE wms_dispatched_tasks
5897: SET status = l_g_task_dispatched
5898: ,last_update_date = SYSDATE
5899: ,last_updated_by = p_user_id

Line 5900: WHERE transaction_temp_id = wms_picking_pkg.g_start_over_tempid(L);

5896: UPDATE wms_dispatched_tasks
5897: SET status = l_g_task_dispatched
5898: ,last_update_date = SYSDATE
5899: ,last_updated_by = p_user_id
5900: WHERE transaction_temp_id = wms_picking_pkg.g_start_over_tempid(L);
5901: IF SQL%NOTFOUND THEN
5902: mydebug('transaction_temp_id : ' ||wms_picking_pkg.g_start_over_tempid(L) ||' : not found to be updated');
5903: END IF;
5904:

Line 5902: mydebug('transaction_temp_id : ' ||wms_picking_pkg.g_start_over_tempid(L) ||' : not found to be updated');

5898: ,last_update_date = SYSDATE
5899: ,last_updated_by = p_user_id
5900: WHERE transaction_temp_id = wms_picking_pkg.g_start_over_tempid(L);
5901: IF SQL%NOTFOUND THEN
5902: mydebug('transaction_temp_id : ' ||wms_picking_pkg.g_start_over_tempid(L) ||' : not found to be updated');
5903: END IF;
5904:
5905: IF (l_debug = 1) THEN
5906: L :=0;

Line 5907: FOR L IN wms_picking_pkg.g_start_over_tempid.FIRST .. wms_picking_pkg.g_start_over_tempid.LAST

5903: END IF;
5904:
5905: IF (l_debug = 1) THEN
5906: L :=0;
5907: FOR L IN wms_picking_pkg.g_start_over_tempid.FIRST .. wms_picking_pkg.g_start_over_tempid.LAST
5908: LOOP
5909: mydebug('values sent are :' || wms_picking_pkg.g_start_over_tempid(L) || 'value of L' ||L);
5910: IF SQL%NOTFOUND THEN
5911: mydebug('transaction_temp_id : ' ||wms_picking_pkg.g_start_over_tempid(L) ||' : not found to be updated');

Line 5909: mydebug('values sent are :' || wms_picking_pkg.g_start_over_tempid(L) || 'value of L' ||L);

5905: IF (l_debug = 1) THEN
5906: L :=0;
5907: FOR L IN wms_picking_pkg.g_start_over_tempid.FIRST .. wms_picking_pkg.g_start_over_tempid.LAST
5908: LOOP
5909: mydebug('values sent are :' || wms_picking_pkg.g_start_over_tempid(L) || 'value of L' ||L);
5910: IF SQL%NOTFOUND THEN
5911: mydebug('transaction_temp_id : ' ||wms_picking_pkg.g_start_over_tempid(L) ||' : not found to be updated');
5912: END IF;
5913: END LOOP;

Line 5911: mydebug('transaction_temp_id : ' ||wms_picking_pkg.g_start_over_tempid(L) ||' : not found to be updated');

5907: FOR L IN wms_picking_pkg.g_start_over_tempid.FIRST .. wms_picking_pkg.g_start_over_tempid.LAST
5908: LOOP
5909: mydebug('values sent are :' || wms_picking_pkg.g_start_over_tempid(L) || 'value of L' ||L);
5910: IF SQL%NOTFOUND THEN
5911: mydebug('transaction_temp_id : ' ||wms_picking_pkg.g_start_over_tempid(L) ||' : not found to be updated');
5912: END IF;
5913: END LOOP;
5914: END IF;
5915:

Line 5916: x_start_over_taskno := wms_picking_pkg.g_start_over_tempid.count;

5912: END IF;
5913: END LOOP;
5914: END IF;
5915:
5916: x_start_over_taskno := wms_picking_pkg.g_start_over_tempid.count;
5917: mydebug('x_start_over_taskno in procedure start_over::'||x_start_over_taskno);
5918: mydebug('END = ' || l_proc_name );
5919: EXCEPTION
5920: WHEN fnd_api.g_exc_error THEN

Line 6357: wms_picking_pkg.g_previous_task_status.delete(p_temp_id);

6353: fnd_msg_pub.ADD;
6354: RAISE fnd_api.g_exc_unexpected_error;
6355: END IF;
6356: BEGIN
6357: wms_picking_pkg.g_previous_task_status.delete(p_temp_id);
6358: EXCEPTION
6359: WHEN OTHERS THEN
6360: null; -- it is ok not to find it.
6361: END ;