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_DISPATCH_GEN dependencies on WMS_TASK_DISPATCH_GEN

Line 1: PACKAGE BODY wms_task_dispatch_gen AS

1: PACKAGE BODY wms_task_dispatch_gen AS
2: /* $Header: WMSTASKB.pls 120.18.12010000.2 2008/08/22 10:57:04 satishku ship $ */
3:
4:
5: -- Global constant holding the package name

Line 7: g_pkg_name CONSTANT VARCHAR2(30) := 'WMS_Task_Dispatch_Gen';

3:
4:
5: -- Global constant holding the package name
6:
7: g_pkg_name CONSTANT VARCHAR2(30) := 'WMS_Task_Dispatch_Gen';
8: g_pkg_version CONSTANT VARCHAR2(100) := '$Header: WMSTASKB.pls 120.18.12010000.2 2008/08/22 10:57:04 satishku ship $';
9:
10: --Replenishment Project --6681109
11: g_ordered_psr wms_replenishment_pvt.psrTabTyp;

Line 28: -- wms_task_dispatch_gen.create_mo

24: , x_wf OUT NOCOPY NUMBER ); -- Bug2924823 H to I
25:
26: -- If you need to make any changes in the spec of create_mo, then make
27: -- changes both in wms_task_dispatch_put_away.create_mo and in
28: -- wms_task_dispatch_gen.create_mo
29:
30: PROCEDURE create_mo(
31: p_org_id IN NUMBER
32: , p_inventory_item_id IN NUMBER

Line 222: task_rec wms_task_dispatch_gen.task_rec_tp;

218: , p_sign_on_device_id IN NUMBER := NULL
219: , x_avail_device_id OUT NOCOPY NUMBER
220: ) IS
221: l_cartonization_id NUMBER := NULL;
222: task_rec wms_task_dispatch_gen.task_rec_tp;
223: l_task_cur wms_task_dispatch_gen.task_rec_cur_tp;
224: l_user_id NUMBER;
225: l_emp_id NUMBER;
226: l_org_id NUMBER;

Line 223: l_task_cur wms_task_dispatch_gen.task_rec_cur_tp;

219: , x_avail_device_id OUT NOCOPY NUMBER
220: ) IS
221: l_cartonization_id NUMBER := NULL;
222: task_rec wms_task_dispatch_gen.task_rec_tp;
223: l_task_cur wms_task_dispatch_gen.task_rec_cur_tp;
224: l_user_id NUMBER;
225: l_emp_id NUMBER;
226: l_org_id NUMBER;
227: l_zone VARCHAR2(10);

Line 993: task_rec wms_task_dispatch_gen.task_rec_tp;

989: , x_deliveries_list OUT NOCOPY VARCHAR2
990: , x_cartons_list OUT NOCOPY VARCHAR2
991: ) IS
992: l_cartonization_id NUMBER := NULL;
993: task_rec wms_task_dispatch_gen.task_rec_tp;
994: l_task_cur wms_task_dispatch_gen.task_rec_cur_tp;
995: l_user_id NUMBER;
996: l_emp_id NUMBER;
997: l_org_id NUMBER;

Line 994: l_task_cur wms_task_dispatch_gen.task_rec_cur_tp;

990: , x_cartons_list OUT NOCOPY VARCHAR2
991: ) IS
992: l_cartonization_id NUMBER := NULL;
993: task_rec wms_task_dispatch_gen.task_rec_tp;
994: l_task_cur wms_task_dispatch_gen.task_rec_cur_tp;
995: l_user_id NUMBER;
996: l_emp_id NUMBER;
997: l_org_id NUMBER;
998: l_zone VARCHAR2(10);

Line 2127: wms_task_dispatch_gen.get_primary_quantity(p_item_id => l_item_id, p_organization_id => l_org_id, p_from_quantity => l_qty

2123:
2124: -- Calculate Primary Quantity
2125:
2126: l_pr_qty :=
2127: wms_task_dispatch_gen.get_primary_quantity(p_item_id => l_item_id, p_organization_id => l_org_id, p_from_quantity => l_qty
2128: , p_from_unit => l_uom);
2129:
2130: IF (l_debug = 1) THEN
2131: mydebug('process_lot_serial: after prim qty');

Line 3170: IF l_mtlt_primary_qty >= wms_task_dispatch_gen.get_primary_quantity(p_item_id,p_org_id,l_wlc_quantity,l_wlc_uom_code) THEN

3166:
3167:
3168: IF l_wlc_quantity <> 0 THEN
3169:
3170: IF l_mtlt_primary_qty >= wms_task_dispatch_gen.get_primary_quantity(p_item_id,p_org_id,l_wlc_quantity,l_wlc_uom_code) THEN
3171:
3172: l_lpn_qty := l_lpn_qty +
3173: wms_task_dispatch_gen.get_primary_quantity(p_item_id,p_org_id,l_wlc_quantity,l_wlc_uom_code);
3174:

Line 3173: wms_task_dispatch_gen.get_primary_quantity(p_item_id,p_org_id,l_wlc_quantity,l_wlc_uom_code);

3169:
3170: IF l_mtlt_primary_qty >= wms_task_dispatch_gen.get_primary_quantity(p_item_id,p_org_id,l_wlc_quantity,l_wlc_uom_code) THEN
3171:
3172: l_lpn_qty := l_lpn_qty +
3173: wms_task_dispatch_gen.get_primary_quantity(p_item_id,p_org_id,l_wlc_quantity,l_wlc_uom_code);
3174:
3175: ELSE
3176:
3177: l_lpn_qty := l_lpn_qty + l_mtlt_primary_qty;

Line 3861: IF l_mtlt_primary_qty >= wms_task_dispatch_gen.get_primary_quantity(p_item_id,p_org_id,l_wlc_quantity,l_wlc_uom_code) THEN

3857: END;
3858:
3859: IF l_wlc_quantity <> 0 THEN
3860:
3861: IF l_mtlt_primary_qty >= wms_task_dispatch_gen.get_primary_quantity(p_item_id,p_org_id,l_wlc_quantity,l_wlc_uom_code) THEN
3862:
3863: l_lpn_qty := l_lpn_qty + wms_task_dispatch_gen.get_primary_quantity(p_item_id,p_org_id,l_wlc_quantity,l_wlc_uom_code);
3864:
3865: ELSE

Line 3863: l_lpn_qty := l_lpn_qty + wms_task_dispatch_gen.get_primary_quantity(p_item_id,p_org_id,l_wlc_quantity,l_wlc_uom_code);

3859: IF l_wlc_quantity <> 0 THEN
3860:
3861: IF l_mtlt_primary_qty >= wms_task_dispatch_gen.get_primary_quantity(p_item_id,p_org_id,l_wlc_quantity,l_wlc_uom_code) THEN
3862:
3863: l_lpn_qty := l_lpn_qty + wms_task_dispatch_gen.get_primary_quantity(p_item_id,p_org_id,l_wlc_quantity,l_wlc_uom_code);
3864:
3865: ELSE
3866:
3867: l_lpn_qty := l_lpn_qty + l_mtlt_primary_qty;

Line 3875: IF l_mtlt_primary_qty < wms_task_dispatch_gen.get_primary_quantity(p_item_id,p_org_id,l_wlc_quantity,l_wlc_uom_code) THEN

3871: END IF;
3872:
3873: IF l_lot_match <> 0 AND x_match <> 4 THEN
3874:
3875: IF l_mtlt_primary_qty < wms_task_dispatch_gen.get_primary_quantity(p_item_id,p_org_id,l_wlc_quantity,l_wlc_uom_code) THEN
3876:
3877: IF (l_debug = 1) THEN
3878: mydebug('lpn_match: Qty in LPN for lot ' || l_mtlt_lot_number || ' more than transaction qty for that lot');
3879: END IF;

Line 3882: ELSIF l_mtlt_primary_qty > wms_task_dispatch_gen.get_primary_quantity(p_item_id,p_org_id,l_wlc_quantity,l_wlc_uom_code) THEN

3878: mydebug('lpn_match: Qty in LPN for lot ' || l_mtlt_lot_number || ' more than transaction qty for that lot');
3879: END IF;
3880: x_match := 4;
3881:
3882: ELSIF l_mtlt_primary_qty > wms_task_dispatch_gen.get_primary_quantity(p_item_id,p_org_id,l_wlc_quantity,l_wlc_uom_code) THEN
3883:
3884: IF (l_debug = 1) THEN
3885: mydebug('lpn_match: Qty in LPN for lot ' || l_mtlt_lot_number || ' less than transaction qty for that lot');
3886: END IF;

Line 4323: l_exist_qty := wms_task_dispatch_gen.get_primary_quantity

4319: END IF;
4320:
4321: IF l_lpn_uom <> l_primary_uom THEN
4322:
4323: l_exist_qty := wms_task_dispatch_gen.get_primary_quantity
4324: (p_item_id => p_item_id,
4325: p_organization_id => p_org_id,
4326: p_from_quantity => l_exist_qty,
4327: p_from_unit => l_lpn_uom);

Line 4847: wms_task_dispatch_gen.multiple_pick(

4843: IF (l_debug = 1) THEN
4844: mydebug('lpn_match: just before multiple_pick');
4845: END IF;
4846:
4847: wms_task_dispatch_gen.multiple_pick(
4848: p_pick_qty => p_qty
4849: , p_org_id => p_org_id
4850: , p_temp_id => p_temp_id
4851: , x_return_status => l_return_status

Line 4899: wms_task_dispatch_gen.multiple_lpn_pick(

4895: mydebug('lpn_match: MMTT lines need to be split..');
4896: mydebug('lpn_match: Calling multiple lpn picking..');
4897: END IF;
4898:
4899: wms_task_dispatch_gen.multiple_lpn_pick(
4900: p_lpn_id => p_lpn
4901: , p_lpn_qty => l_lpn_qty
4902: , p_org_id => p_org_id
4903: , p_temp_id => p_temp_id

Line 5474: wms_task_dispatch_gen.multiple_pick(

5470: IF (l_debug = 1) THEN
5471: mydebug('load_pick : Neither lot nor serial control. Calling multiple_pick');
5472: END IF;
5473:
5474: wms_task_dispatch_gen.multiple_pick(
5475: p_pick_qty => l_qty_picked
5476: , p_org_id => p_org_id
5477: , p_temp_id => p_temp_id
5478: , x_return_status => l_return_status

Line 5661: , p_calling_program => 'wms_task_dispatch_gen.load_pick'

5657: , x_msg_count => l_msg_cnt
5658: , x_msg_data => l_msg_data
5659: , p_org_id => p_org_id
5660: , p_rsn_id => p_qty_rsn_id
5661: , p_calling_program => 'wms_task_dispatch_gen.load_pick'
5662: , p_tmp_id => p_temp_id
5663: , p_quantity_picked => l_qty_picked
5664: , p_dest_sub => p_act_sub
5665: , p_dest_loc => p_act_loc

Line 6994: wms_task_dispatch_gen.get_primary_quantity(p_item_id => l_item_id, p_organization_id => l_org_id, p_from_quantity => l_qty

6990:
6991: -- Calculate Primary Quantity
6992:
6993: l_pr_qty :=
6994: wms_task_dispatch_gen.get_primary_quantity(p_item_id => l_item_id, p_organization_id => l_org_id, p_from_quantity => l_qty
6995: , p_from_unit => l_uom);
6996:
6997: IF (l_debug = 1) THEN
6998: mydebug('multiple_lpn_pick: l_pr_qty = ' || l_pr_qty);

Line 7474: wms_task_dispatch_gen.get_primary_quantity(p_item_id => l_item_id, p_organization_id => l_org_id

7470: mydebug('multiple_lpn_pick: l_lot_primary_qty = ' || l_lot_primary_qty);
7471: END IF;
7472:
7473: l_lpn_lot_primary_qty :=
7474: wms_task_dispatch_gen.get_primary_quantity(p_item_id => l_item_id, p_organization_id => l_org_id
7475: , p_from_quantity => l_lpn_lot_qty, p_from_unit => l_lpn_uom_code);
7476:
7477: IF (l_debug = 1) THEN
7478: mydebug('multiple_lpn_pick: l_lpn_lot_primary_qty = ' || l_lpn_lot_primary_qty);

Line 7582: wms_task_dispatch_gen.get_primary_quantity(p_item_id => l_item_id, p_organization_id => l_org_id

7578: mydebug('multiple_lpn_pick: l_lot_primary_qty = ' || l_lot_primary_qty);
7579: END IF;
7580:
7581: l_lpn_lot_primary_qty :=
7582: wms_task_dispatch_gen.get_primary_quantity(p_item_id => l_item_id, p_organization_id => l_org_id
7583: , p_from_quantity => l_lpn_lot_qty, p_from_unit => l_lpn_uom_code);
7584:
7585: IF (l_debug = 1) THEN
7586: mydebug('multiple_lpn_pick: l_lpn_lot_primary_qty = ' || l_lpn_lot_primary_qty);

Line 8110: wms_task_dispatch_gen.check_pack_lpn

8106: END IF;
8107: RETURN;
8108: END IF;
8109:
8110: wms_task_dispatch_gen.check_pack_lpn
8111: ( p_lpn => p_pick_to_lpn
8112: , p_org_id => p_organization_id
8113: , x_return_status => x_return_status
8114: , x_msg_count => x_msg_count

Line 9005: wms_task_dispatch_gen.get_primary_quantity(p_item_id => l_item_id, p_organization_id => p_org_id, p_from_quantity => l_qty

9001: l_progress := '50';
9002: -- Calculate Primary Quantity
9003:
9004: l_pr_qty :=
9005: wms_task_dispatch_gen.get_primary_quantity(p_item_id => l_item_id, p_organization_id => p_org_id, p_from_quantity => l_qty
9006: , p_from_unit => l_sug_uom);
9007: l_progress := '60';
9008:
9009: IF (l_debug = 1) THEN

Line 9297: wms_task_dispatch_gen.check_is_reservable_sub

9293: IF (l_debug = 1) THEN
9294: mydebug('multiple_pick: transfer detailed reservations');
9295: END IF;
9296:
9297: wms_task_dispatch_gen.check_is_reservable_sub
9298: (x_return_status => l_return_status,
9299: p_organization_id => p_org_id,
9300: p_subinventory_code => l_act_sub,
9301: x_is_reservable_sub => l_is_conf_sub_reservable);

Line 11068: wms_task_dispatch_gen.insert_mmtt_pack(

11064: IF (l_debug = 1) THEN
11065: mydebug('pick_drop: Creating final row for packing. Calling insert_mmtt_pack');
11066: END IF;
11067:
11068: wms_task_dispatch_gen.insert_mmtt_pack(
11069: p_temp_id => p_temp_id
11070: , p_lpn_id => p_from_lpn_id
11071: , p_transfer_lpn => p_drop_lpn
11072: , p_container_item_id => 0

Line 12432: task_rec wms_task_dispatch_gen.task_rec_tp;

12428: , x_msg_count OUT NOCOPY NUMBER
12429: , x_msg_data OUT NOCOPY VARCHAR2
12430: ) IS
12431: l_cartonization_id NUMBER := NULL;
12432: task_rec wms_task_dispatch_gen.task_rec_tp;
12433: l_task_cur wms_task_dispatch_gen.task_rec_cur_tp;
12434: l_user_id NUMBER;
12435: l_emp_id NUMBER;
12436: l_org_id NUMBER;

Line 12433: l_task_cur wms_task_dispatch_gen.task_rec_cur_tp;

12429: , x_msg_data OUT NOCOPY VARCHAR2
12430: ) IS
12431: l_cartonization_id NUMBER := NULL;
12432: task_rec wms_task_dispatch_gen.task_rec_tp;
12433: l_task_cur wms_task_dispatch_gen.task_rec_cur_tp;
12434: l_user_id NUMBER;
12435: l_emp_id NUMBER;
12436: l_org_id NUMBER;
12437: l_zone VARCHAR2(10);

Line 12780: task_rec wms_task_dispatch_gen.task_rec_tp;

12776: , x_return_status OUT NOCOPY VARCHAR2
12777: , x_msg_count OUT NOCOPY NUMBER
12778: , x_msg_data OUT NOCOPY VARCHAR2
12779: ) IS
12780: task_rec wms_task_dispatch_gen.task_rec_tp;
12781: l_task_cur wms_task_dispatch_gen.task_rec_cur_tp;
12782: l_user_id NUMBER;
12783: l_emp_id NUMBER;
12784: l_org_id NUMBER;

Line 12781: l_task_cur wms_task_dispatch_gen.task_rec_cur_tp;

12777: , x_msg_count OUT NOCOPY NUMBER
12778: , x_msg_data OUT NOCOPY VARCHAR2
12779: ) IS
12780: task_rec wms_task_dispatch_gen.task_rec_tp;
12781: l_task_cur wms_task_dispatch_gen.task_rec_cur_tp;
12782: l_user_id NUMBER;
12783: l_emp_id NUMBER;
12784: l_org_id NUMBER;
12785: l_zone VARCHAR2(10);

Line 13372: inv_mobile_helper_functions.tracelog(p_err_msg => l_msg, p_module => 'WMS_Task_Dispatch_Gen', p_level => 4);

13368: -- select to_char(sysdate,'MM/DD/YYYY HH:MM:SS') INTO l_ts from dual;
13369: -- l_msg:=l_ts||' '||msg;
13370:
13371: l_msg := msg;
13372: inv_mobile_helper_functions.tracelog(p_err_msg => l_msg, p_module => 'WMS_Task_Dispatch_Gen', p_level => 4);
13373: --dbms_output.put_line(l_msg);
13374:
13375: NULL;
13376: END;

Line 15644: END wms_task_dispatch_gen;

15640:
15641: END default_pick_drop_lpn;
15642:
15643:
15644: END wms_task_dispatch_gen;