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 6298: wms_picking_pkg.g_start_over_tempid.DELETE;

6294: mydebug('viks l_start_over_task return froom proc_start_over :' ||l_start_over_task);
6295: ELSE
6296: mydebug('viks start_over button not pressed :');
6297: --only when it is not start over case, the retain task will be used 431009
6298: wms_picking_pkg.g_start_over_tempid.DELETE;
6299: IF p_retain_task = 'Y' THEN --{ bug 4310093
6300: mydebug('change the task status to Dispatched if retain_task is Y');
6301: UPDATE wms_dispatched_tasks
6302: SET status = l_g_task_dispatched

Line 6382: wms_picking_pkg.clear_order_numbers(

6378: END IF;
6379:
6380: --Added for Case Picking Project start
6381:
6382: wms_picking_pkg.clear_order_numbers(
6383: x_return_status =>x_return_status,
6384: x_msg_count =>x_msg_count,
6385: x_msg_data => x_msg_data);
6386: mydebug('wms_picking_pkg.clear_order_numbers x_msg_count/Data = ' || x_msg_count || '/'|| x_msg_data);

Line 6386: mydebug('wms_picking_pkg.clear_order_numbers x_msg_count/Data = ' || x_msg_count || '/'|| x_msg_data);

6382: wms_picking_pkg.clear_order_numbers(
6383: x_return_status =>x_return_status,
6384: x_msg_count =>x_msg_count,
6385: x_msg_data => x_msg_data);
6386: mydebug('wms_picking_pkg.clear_order_numbers x_msg_count/Data = ' || x_msg_count || '/'|| x_msg_data);
6387: mydebug('wms_picking_pkg.clear_order_numbers x_return_status = ' ||x_return_status );
6388: wms_picking_pkg.clear_pick_slip_number(
6389: x_return_status =>x_return_status,
6390: x_msg_count =>x_msg_count,

Line 6387: mydebug('wms_picking_pkg.clear_order_numbers x_return_status = ' ||x_return_status );

6383: x_return_status =>x_return_status,
6384: x_msg_count =>x_msg_count,
6385: x_msg_data => x_msg_data);
6386: mydebug('wms_picking_pkg.clear_order_numbers x_msg_count/Data = ' || x_msg_count || '/'|| x_msg_data);
6387: mydebug('wms_picking_pkg.clear_order_numbers x_return_status = ' ||x_return_status );
6388: wms_picking_pkg.clear_pick_slip_number(
6389: x_return_status =>x_return_status,
6390: x_msg_count =>x_msg_count,
6391: x_msg_data => x_msg_data);

Line 6388: wms_picking_pkg.clear_pick_slip_number(

6384: x_msg_count =>x_msg_count,
6385: x_msg_data => x_msg_data);
6386: mydebug('wms_picking_pkg.clear_order_numbers x_msg_count/Data = ' || x_msg_count || '/'|| x_msg_data);
6387: mydebug('wms_picking_pkg.clear_order_numbers x_return_status = ' ||x_return_status );
6388: wms_picking_pkg.clear_pick_slip_number(
6389: x_return_status =>x_return_status,
6390: x_msg_count =>x_msg_count,
6391: x_msg_data => x_msg_data);
6392: mydebug('wms_picking_pkg.clear_pick_slip_number x_msg_count/Data = ' || x_msg_count || '/'|| x_msg_data);

Line 6392: mydebug('wms_picking_pkg.clear_pick_slip_number x_msg_count/Data = ' || x_msg_count || '/'|| x_msg_data);

6388: wms_picking_pkg.clear_pick_slip_number(
6389: x_return_status =>x_return_status,
6390: x_msg_count =>x_msg_count,
6391: x_msg_data => x_msg_data);
6392: mydebug('wms_picking_pkg.clear_pick_slip_number x_msg_count/Data = ' || x_msg_count || '/'|| x_msg_data);
6393: mydebug('wms_picking_pkg.clear_pick_slip_number x_return_status = ' ||x_return_status );
6394:
6395: --Added for Case Picking Project end
6396:

Line 6393: mydebug('wms_picking_pkg.clear_pick_slip_number x_return_status = ' ||x_return_status );

6389: x_return_status =>x_return_status,
6390: x_msg_count =>x_msg_count,
6391: x_msg_data => x_msg_data);
6392: mydebug('wms_picking_pkg.clear_pick_slip_number x_msg_count/Data = ' || x_msg_count || '/'|| x_msg_data);
6393: mydebug('wms_picking_pkg.clear_pick_slip_number x_return_status = ' ||x_return_status );
6394:
6395: --Added for Case Picking Project end
6396:
6397:

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

6916: -- There is no need to check for a specific header_id . For F2, we anyway always
6917: -- delete all dispatched and active tasks
6918:
6919: BEGIN
6920: l_prev_task_status := wms_picking_pkg.g_previous_task_status(p_transaction_temp_id);
6921: wms_picking_pkg.g_previous_task_status.delete(p_transaction_temp_id);
6922: EXCEPTION
6923: WHEN OTHERS THEN
6924: mydebug('wms_picking_pkg.g_previous_task_status(p_transaction_temp_id) : ' || p_transaction_temp_id

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

6917: -- delete all dispatched and active tasks
6918:
6919: BEGIN
6920: l_prev_task_status := wms_picking_pkg.g_previous_task_status(p_transaction_temp_id);
6921: wms_picking_pkg.g_previous_task_status.delete(p_transaction_temp_id);
6922: EXCEPTION
6923: WHEN OTHERS THEN
6924: mydebug('wms_picking_pkg.g_previous_task_status(p_transaction_temp_id) : ' || p_transaction_temp_id
6925: || ' : not found' );

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

6920: l_prev_task_status := wms_picking_pkg.g_previous_task_status(p_transaction_temp_id);
6921: wms_picking_pkg.g_previous_task_status.delete(p_transaction_temp_id);
6922: EXCEPTION
6923: WHEN OTHERS THEN
6924: mydebug('wms_picking_pkg.g_previous_task_status(p_transaction_temp_id) : ' || p_transaction_temp_id
6925: || ' : not found' );
6926: l_prev_task_status := l_g_task_pending;
6927: END ;
6928:

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

6951: mydebug('l_progress = ' || l_progress || ' Update status of all other tasks in this group' );
6952: FOR rec_reset_task_status IN cur_reset_task_status
6953: LOOP
6954: BEGIN
6955: l_prev_task_status := wms_picking_pkg.g_previous_task_status(rec_reset_task_status.transaction_temp_id);
6956: wms_picking_pkg.g_previous_task_status.delete(rec_reset_task_status.transaction_temp_id);
6957: EXCEPTION
6958: WHEN OTHERS THEN
6959: mydebug('wms_picking_pkg.g_previous_task_status(transaction_temp_id) : '

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

6952: FOR rec_reset_task_status IN cur_reset_task_status
6953: LOOP
6954: BEGIN
6955: l_prev_task_status := wms_picking_pkg.g_previous_task_status(rec_reset_task_status.transaction_temp_id);
6956: wms_picking_pkg.g_previous_task_status.delete(rec_reset_task_status.transaction_temp_id);
6957: EXCEPTION
6958: WHEN OTHERS THEN
6959: mydebug('wms_picking_pkg.g_previous_task_status(transaction_temp_id) : '
6960: || rec_reset_task_status.transaction_temp_id || ' : not found' );

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

6955: l_prev_task_status := wms_picking_pkg.g_previous_task_status(rec_reset_task_status.transaction_temp_id);
6956: wms_picking_pkg.g_previous_task_status.delete(rec_reset_task_status.transaction_temp_id);
6957: EXCEPTION
6958: WHEN OTHERS THEN
6959: mydebug('wms_picking_pkg.g_previous_task_status(transaction_temp_id) : '
6960: || rec_reset_task_status.transaction_temp_id || ' : not found' );
6961: l_prev_task_status := l_g_task_pending;
6962: END ;
6963: mydebug('l_prev_task_status = ' || l_prev_task_status || ' for transaction_temp_id: '

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

7074: mydebug ('p_transaction_header_id : ' || p_transaction_header_id);
7075: mydebug ('p_transaction_temp_id : ' || p_transaction_temp_id );
7076: l_progress := 110;
7077:
7078: l_prev_task_status := wms_picking_pkg.g_previous_task_status(p_transaction_temp_id);
7079:
7080: SELECT count(*) into new_mmtt_count from mtl_allocations_gtmp;
7081: mydebug('Total count in mtl_allocations_gtemp: ' || new_mmtt_count);
7082:

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

7079:
7080: SELECT count(*) into new_mmtt_count from mtl_allocations_gtmp;
7081: mydebug('Total count in mtl_allocations_gtemp: ' || new_mmtt_count);
7082:
7083: l_first_index := wms_picking_pkg.g_start_over_tempid.first;
7084: l_existing_count := wms_picking_pkg.g_start_over_tempid.count-1;
7085:
7086: mydebug('l_first_index is : ' ||l_first_index);
7087: mydebug('l_existing_count is : ' || l_existing_count);

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

7080: SELECT count(*) into new_mmtt_count from mtl_allocations_gtmp;
7081: mydebug('Total count in mtl_allocations_gtemp: ' || new_mmtt_count);
7082:
7083: l_first_index := wms_picking_pkg.g_start_over_tempid.first;
7084: l_existing_count := wms_picking_pkg.g_start_over_tempid.count-1;
7085:
7086: mydebug('l_first_index is : ' ||l_first_index);
7087: mydebug('l_existing_count is : ' || l_existing_count);
7088:

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

7096: l_move_index_offset := (new_mmtt_count+1) - l_first_index;
7097: mydebug('Inl_move_index_offset:'||l_move_index_offset);
7098: if (l_move_index_offset >0) then -- move forward
7099: for i in REVERSE l_first_index .. (l_first_index+l_existing_count) LOOP
7100: wms_picking_pkg.g_start_over_tempid(i+l_move_index_offset) := wms_picking_pkg.g_start_over_tempid(i);
7101: mydebug('In else index :' ||i);
7102: END LOOP;
7103:
7104: elsif (l_move_index_offset <0) then -- move backward

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

7102: END LOOP;
7103:
7104: elsif (l_move_index_offset <0) then -- move backward
7105: for i in l_first_index..l_first_index+l_existing_count LOOP
7106: wms_picking_pkg.g_start_over_tempid(i+l_move_index_offset) := wms_picking_pkg.g_start_over_tempid(i);
7107: wms_picking_pkg.g_start_over_tempid.DELETE(i);
7108: mydebug('In else if index offset is Neg:' ||wms_picking_pkg.g_start_over_tempid(i+l_move_index_offset));
7109: mydebug('In elseif index :' ||i);
7110: END LOOP;

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

7103:
7104: elsif (l_move_index_offset <0) then -- move backward
7105: for i in l_first_index..l_first_index+l_existing_count LOOP
7106: wms_picking_pkg.g_start_over_tempid(i+l_move_index_offset) := wms_picking_pkg.g_start_over_tempid(i);
7107: wms_picking_pkg.g_start_over_tempid.DELETE(i);
7108: mydebug('In else if index offset is Neg:' ||wms_picking_pkg.g_start_over_tempid(i+l_move_index_offset));
7109: mydebug('In elseif index :' ||i);
7110: END LOOP;
7111: end if;

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

7104: elsif (l_move_index_offset <0) then -- move backward
7105: for i in l_first_index..l_first_index+l_existing_count LOOP
7106: wms_picking_pkg.g_start_over_tempid(i+l_move_index_offset) := wms_picking_pkg.g_start_over_tempid(i);
7107: wms_picking_pkg.g_start_over_tempid.DELETE(i);
7108: mydebug('In else if index offset is Neg:' ||wms_picking_pkg.g_start_over_tempid(i+l_move_index_offset));
7109: mydebug('In elseif index :' ||i);
7110: END LOOP;
7111: end if;
7112: END IF;

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

7109: mydebug('In elseif index :' ||i);
7110: END LOOP;
7111: end if;
7112: END IF;
7113: mydebug('Cont of table :'||wms_picking_pkg.g_start_over_tempid.COUNT);
7114: -- insert temp id value into pl/sql table
7115:
7116: p := 1;
7117: FOR tempid_rec IN tempid_cur(v_transaction_temp_id => p_transaction_temp_id)

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

7115:
7116: p := 1;
7117: FOR tempid_rec IN tempid_cur(v_transaction_temp_id => p_transaction_temp_id)
7118: LOOP
7119: wms_picking_pkg.g_start_over_tempid(p) := tempid_rec.transaction_temp_id;
7120: mydebug('Temp ids in plsql :'||wms_picking_pkg.g_start_over_tempid(p)||'Index:'||p);
7121: wms_picking_pkg.g_previous_task_status(wms_picking_pkg.g_start_over_tempid(p)) :=l_prev_task_status;
7122: p := p +1;
7123: IF SQL%NOTFOUND THEN

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

7116: p := 1;
7117: FOR tempid_rec IN tempid_cur(v_transaction_temp_id => p_transaction_temp_id)
7118: LOOP
7119: wms_picking_pkg.g_start_over_tempid(p) := tempid_rec.transaction_temp_id;
7120: mydebug('Temp ids in plsql :'||wms_picking_pkg.g_start_over_tempid(p)||'Index:'||p);
7121: wms_picking_pkg.g_previous_task_status(wms_picking_pkg.g_start_over_tempid(p)) :=l_prev_task_status;
7122: p := p +1;
7123: IF SQL%NOTFOUND THEN
7124: mydebug('transaction_temp_id not found only one temp_id present: ');

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

7117: FOR tempid_rec IN tempid_cur(v_transaction_temp_id => p_transaction_temp_id)
7118: LOOP
7119: wms_picking_pkg.g_start_over_tempid(p) := tempid_rec.transaction_temp_id;
7120: mydebug('Temp ids in plsql :'||wms_picking_pkg.g_start_over_tempid(p)||'Index:'||p);
7121: wms_picking_pkg.g_previous_task_status(wms_picking_pkg.g_start_over_tempid(p)) :=l_prev_task_status;
7122: p := p +1;
7123: IF SQL%NOTFOUND THEN
7124: mydebug('transaction_temp_id not found only one temp_id present: ');
7125: p :=1;

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

7126: END IF;
7127:
7128: END LOOP;
7129:
7130: wms_picking_pkg.g_start_over_tempid(p):= p_transaction_temp_id;
7131: mydebug('Temp id sent last is :'||wms_picking_pkg.g_start_over_tempid(p) ||'Index is::'||p);
7132:
7133: L:=0;
7134:

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

7127:
7128: END LOOP;
7129:
7130: wms_picking_pkg.g_start_over_tempid(p):= p_transaction_temp_id;
7131: mydebug('Temp id sent last is :'||wms_picking_pkg.g_start_over_tempid(p) ||'Index is::'||p);
7132:
7133: L:=0;
7134:
7135: -- Updating wdd status and printing final values sent in pl/sql table

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

7133: L:=0;
7134:
7135: -- Updating wdd status and printing final values sent in pl/sql table
7136:
7137: forall L in wms_picking_pkg.g_start_over_tempid.FIRST .. wms_picking_pkg.g_start_over_tempid.LAST
7138: UPDATE wms_dispatched_tasks
7139: SET status = l_g_task_dispatched
7140: ,last_update_date = SYSDATE
7141: ,last_updated_by = p_user_id

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

7138: UPDATE wms_dispatched_tasks
7139: SET status = l_g_task_dispatched
7140: ,last_update_date = SYSDATE
7141: ,last_updated_by = p_user_id
7142: WHERE transaction_temp_id = wms_picking_pkg.g_start_over_tempid(L);
7143: IF SQL%NOTFOUND THEN
7144: mydebug('transaction_temp_id : ' ||wms_picking_pkg.g_start_over_tempid(L) ||' : not found to be updated');
7145: END IF;
7146:

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

7140: ,last_update_date = SYSDATE
7141: ,last_updated_by = p_user_id
7142: WHERE transaction_temp_id = wms_picking_pkg.g_start_over_tempid(L);
7143: IF SQL%NOTFOUND THEN
7144: mydebug('transaction_temp_id : ' ||wms_picking_pkg.g_start_over_tempid(L) ||' : not found to be updated');
7145: END IF;
7146:
7147: IF (l_debug = 1) THEN
7148: L :=0;

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

7145: END IF;
7146:
7147: IF (l_debug = 1) THEN
7148: L :=0;
7149: FOR L IN wms_picking_pkg.g_start_over_tempid.FIRST .. wms_picking_pkg.g_start_over_tempid.LAST
7150: LOOP
7151: mydebug('values sent are :' || wms_picking_pkg.g_start_over_tempid(L) || 'value of L' ||L);
7152: IF SQL%NOTFOUND THEN
7153: mydebug('transaction_temp_id : ' ||wms_picking_pkg.g_start_over_tempid(L) ||' : not found to be updated');

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

7147: IF (l_debug = 1) THEN
7148: L :=0;
7149: FOR L IN wms_picking_pkg.g_start_over_tempid.FIRST .. wms_picking_pkg.g_start_over_tempid.LAST
7150: LOOP
7151: mydebug('values sent are :' || wms_picking_pkg.g_start_over_tempid(L) || 'value of L' ||L);
7152: IF SQL%NOTFOUND THEN
7153: mydebug('transaction_temp_id : ' ||wms_picking_pkg.g_start_over_tempid(L) ||' : not found to be updated');
7154: END IF;
7155: END LOOP;

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

7149: FOR L IN wms_picking_pkg.g_start_over_tempid.FIRST .. wms_picking_pkg.g_start_over_tempid.LAST
7150: LOOP
7151: mydebug('values sent are :' || wms_picking_pkg.g_start_over_tempid(L) || 'value of L' ||L);
7152: IF SQL%NOTFOUND THEN
7153: mydebug('transaction_temp_id : ' ||wms_picking_pkg.g_start_over_tempid(L) ||' : not found to be updated');
7154: END IF;
7155: END LOOP;
7156: END IF;
7157:

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

7154: END IF;
7155: END LOOP;
7156: END IF;
7157:
7158: x_start_over_taskno := wms_picking_pkg.g_start_over_tempid.count;
7159: mydebug('x_start_over_taskno in procedure start_over::'||x_start_over_taskno);
7160: mydebug('END = ' || l_proc_name );
7161: EXCEPTION
7162: WHEN fnd_api.g_exc_error THEN

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

7641: fnd_msg_pub.ADD;
7642: RAISE fnd_api.g_exc_unexpected_error;
7643: END IF;
7644: BEGIN
7645: wms_picking_pkg.g_previous_task_status.delete(p_temp_id);
7646: EXCEPTION
7647: WHEN OTHERS THEN
7648: null; -- it is ok not to find it.
7649: END ;