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_PUTAWAY_UTILS dependencies on WMS_GLOBALS

Line 48: G_OP_TYPE_LOAD CONSTANT NUMBER := wms_globals.g_op_type_load;

44: G_ATF_ACTIVATE_PLAN CONSTANT NUMBER := 1;
45: G_ATF_ABORT_PLAN CONSTANT NUMBER := 2;
46: G_ATF_CANCEL_PLAN CONSTANT NUMBER := 3;
47:
48: G_OP_TYPE_LOAD CONSTANT NUMBER := wms_globals.g_op_type_load;
49: G_OP_TYPE_DROP CONSTANT NUMBER := wms_globals.G_OP_TYPE_DROP;
50: G_OP_TYPE_INSPECT CONSTANT NUMBER := wms_globals.G_OP_TYPE_INSPECT;
51: G_OP_TYPE_PACK CONSTANT NUMBER := wms_globals.G_OP_TYPE_PACK;
52: G_OP_TYPE_CROSSDOCK CONSTANT NUMBER := wms_globals.G_OP_TYPE_CROSSDOCK;

Line 49: G_OP_TYPE_DROP CONSTANT NUMBER := wms_globals.G_OP_TYPE_DROP;

45: G_ATF_ABORT_PLAN CONSTANT NUMBER := 2;
46: G_ATF_CANCEL_PLAN CONSTANT NUMBER := 3;
47:
48: G_OP_TYPE_LOAD CONSTANT NUMBER := wms_globals.g_op_type_load;
49: G_OP_TYPE_DROP CONSTANT NUMBER := wms_globals.G_OP_TYPE_DROP;
50: G_OP_TYPE_INSPECT CONSTANT NUMBER := wms_globals.G_OP_TYPE_INSPECT;
51: G_OP_TYPE_PACK CONSTANT NUMBER := wms_globals.G_OP_TYPE_PACK;
52: G_OP_TYPE_CROSSDOCK CONSTANT NUMBER := wms_globals.G_OP_TYPE_CROSSDOCK;
53:

Line 50: G_OP_TYPE_INSPECT CONSTANT NUMBER := wms_globals.G_OP_TYPE_INSPECT;

46: G_ATF_CANCEL_PLAN CONSTANT NUMBER := 3;
47:
48: G_OP_TYPE_LOAD CONSTANT NUMBER := wms_globals.g_op_type_load;
49: G_OP_TYPE_DROP CONSTANT NUMBER := wms_globals.G_OP_TYPE_DROP;
50: G_OP_TYPE_INSPECT CONSTANT NUMBER := wms_globals.G_OP_TYPE_INSPECT;
51: G_OP_TYPE_PACK CONSTANT NUMBER := wms_globals.G_OP_TYPE_PACK;
52: G_OP_TYPE_CROSSDOCK CONSTANT NUMBER := wms_globals.G_OP_TYPE_CROSSDOCK;
53:
54: G_OP_ACTIVITY_INBOUND CONSTANT NUMBER := wms_globals.G_OP_ACTIVITY_INBOUND;

Line 51: G_OP_TYPE_PACK CONSTANT NUMBER := wms_globals.G_OP_TYPE_PACK;

47:
48: G_OP_TYPE_LOAD CONSTANT NUMBER := wms_globals.g_op_type_load;
49: G_OP_TYPE_DROP CONSTANT NUMBER := wms_globals.G_OP_TYPE_DROP;
50: G_OP_TYPE_INSPECT CONSTANT NUMBER := wms_globals.G_OP_TYPE_INSPECT;
51: G_OP_TYPE_PACK CONSTANT NUMBER := wms_globals.G_OP_TYPE_PACK;
52: G_OP_TYPE_CROSSDOCK CONSTANT NUMBER := wms_globals.G_OP_TYPE_CROSSDOCK;
53:
54: G_OP_ACTIVITY_INBOUND CONSTANT NUMBER := wms_globals.G_OP_ACTIVITY_INBOUND;
55: G_TASK_STATUS_DISPATCHED CONSTANT NUMBER := 3;

Line 52: G_OP_TYPE_CROSSDOCK CONSTANT NUMBER := wms_globals.G_OP_TYPE_CROSSDOCK;

48: G_OP_TYPE_LOAD CONSTANT NUMBER := wms_globals.g_op_type_load;
49: G_OP_TYPE_DROP CONSTANT NUMBER := wms_globals.G_OP_TYPE_DROP;
50: G_OP_TYPE_INSPECT CONSTANT NUMBER := wms_globals.G_OP_TYPE_INSPECT;
51: G_OP_TYPE_PACK CONSTANT NUMBER := wms_globals.G_OP_TYPE_PACK;
52: G_OP_TYPE_CROSSDOCK CONSTANT NUMBER := wms_globals.G_OP_TYPE_CROSSDOCK;
53:
54: G_OP_ACTIVITY_INBOUND CONSTANT NUMBER := wms_globals.G_OP_ACTIVITY_INBOUND;
55: G_TASK_STATUS_DISPATCHED CONSTANT NUMBER := 3;
56: G_TASK_STATUS_LOADED CONSTANT NUMBER := 4;

Line 54: G_OP_ACTIVITY_INBOUND CONSTANT NUMBER := wms_globals.G_OP_ACTIVITY_INBOUND;

50: G_OP_TYPE_INSPECT CONSTANT NUMBER := wms_globals.G_OP_TYPE_INSPECT;
51: G_OP_TYPE_PACK CONSTANT NUMBER := wms_globals.G_OP_TYPE_PACK;
52: G_OP_TYPE_CROSSDOCK CONSTANT NUMBER := wms_globals.G_OP_TYPE_CROSSDOCK;
53:
54: G_OP_ACTIVITY_INBOUND CONSTANT NUMBER := wms_globals.G_OP_ACTIVITY_INBOUND;
55: G_TASK_STATUS_DISPATCHED CONSTANT NUMBER := 3;
56: G_TASK_STATUS_LOADED CONSTANT NUMBER := 4;
57:
58: /*

Line 59: G_OP_INS_STAT_PENDING CONSTANT NUMBER := wms_globals.G_OP_INS_STAT_PENDING;

55: G_TASK_STATUS_DISPATCHED CONSTANT NUMBER := 3;
56: G_TASK_STATUS_LOADED CONSTANT NUMBER := 4;
57:
58: /*
59: G_OP_INS_STAT_PENDING CONSTANT NUMBER := wms_globals.G_OP_INS_STAT_PENDING;
60: G_OP_INS_STAT_ACTIVE CONSTANT NUMBER := wms_globals.G_OP_INS_STAT_ACTIVE;
61: G_OP_INS_STAT_COMPLETED CONSTANT NUMBER := wms_globals.G_OP_INS_STAT_COMPLETED;
62: G_OP_INS_STAT_ABORTED CONSTANT NUMBER := WMS_GLOBALS.G_OP_INS_STAT_ABORTED;
63: G_OP_INS_STAT_CANCELLED CONSTANT NUMBER := WMS_GLOBALS.G_OP_INS_STAT_CANCELLED;

Line 60: G_OP_INS_STAT_ACTIVE CONSTANT NUMBER := wms_globals.G_OP_INS_STAT_ACTIVE;

56: G_TASK_STATUS_LOADED CONSTANT NUMBER := 4;
57:
58: /*
59: G_OP_INS_STAT_PENDING CONSTANT NUMBER := wms_globals.G_OP_INS_STAT_PENDING;
60: G_OP_INS_STAT_ACTIVE CONSTANT NUMBER := wms_globals.G_OP_INS_STAT_ACTIVE;
61: G_OP_INS_STAT_COMPLETED CONSTANT NUMBER := wms_globals.G_OP_INS_STAT_COMPLETED;
62: G_OP_INS_STAT_ABORTED CONSTANT NUMBER := WMS_GLOBALS.G_OP_INS_STAT_ABORTED;
63: G_OP_INS_STAT_CANCELLED CONSTANT NUMBER := WMS_GLOBALS.G_OP_INS_STAT_CANCELLED;
64: */

Line 61: G_OP_INS_STAT_COMPLETED CONSTANT NUMBER := wms_globals.G_OP_INS_STAT_COMPLETED;

57:
58: /*
59: G_OP_INS_STAT_PENDING CONSTANT NUMBER := wms_globals.G_OP_INS_STAT_PENDING;
60: G_OP_INS_STAT_ACTIVE CONSTANT NUMBER := wms_globals.G_OP_INS_STAT_ACTIVE;
61: G_OP_INS_STAT_COMPLETED CONSTANT NUMBER := wms_globals.G_OP_INS_STAT_COMPLETED;
62: G_OP_INS_STAT_ABORTED CONSTANT NUMBER := WMS_GLOBALS.G_OP_INS_STAT_ABORTED;
63: G_OP_INS_STAT_CANCELLED CONSTANT NUMBER := WMS_GLOBALS.G_OP_INS_STAT_CANCELLED;
64: */
65:

Line 62: G_OP_INS_STAT_ABORTED CONSTANT NUMBER := WMS_GLOBALS.G_OP_INS_STAT_ABORTED;

58: /*
59: G_OP_INS_STAT_PENDING CONSTANT NUMBER := wms_globals.G_OP_INS_STAT_PENDING;
60: G_OP_INS_STAT_ACTIVE CONSTANT NUMBER := wms_globals.G_OP_INS_STAT_ACTIVE;
61: G_OP_INS_STAT_COMPLETED CONSTANT NUMBER := wms_globals.G_OP_INS_STAT_COMPLETED;
62: G_OP_INS_STAT_ABORTED CONSTANT NUMBER := WMS_GLOBALS.G_OP_INS_STAT_ABORTED;
63: G_OP_INS_STAT_CANCELLED CONSTANT NUMBER := WMS_GLOBALS.G_OP_INS_STAT_CANCELLED;
64: */
65:
66: --Constant to hold values for call type param

Line 63: G_OP_INS_STAT_CANCELLED CONSTANT NUMBER := WMS_GLOBALS.G_OP_INS_STAT_CANCELLED;

59: G_OP_INS_STAT_PENDING CONSTANT NUMBER := wms_globals.G_OP_INS_STAT_PENDING;
60: G_OP_INS_STAT_ACTIVE CONSTANT NUMBER := wms_globals.G_OP_INS_STAT_ACTIVE;
61: G_OP_INS_STAT_COMPLETED CONSTANT NUMBER := wms_globals.G_OP_INS_STAT_COMPLETED;
62: G_OP_INS_STAT_ABORTED CONSTANT NUMBER := WMS_GLOBALS.G_OP_INS_STAT_ABORTED;
63: G_OP_INS_STAT_CANCELLED CONSTANT NUMBER := WMS_GLOBALS.G_OP_INS_STAT_CANCELLED;
64: */
65:
66: --Constant to hold values for call type param
67: G_CT_NORMAL_LOAD CONSTANT NUMBER := 1;

Line 338: AND mmtt.wms_task_type <> WMS_GLOBALS.g_wms_task_type_putaway

334: WHERE wlpn.organization_id = p_org_id
335: AND wlpn.outermost_lpn_id = p_lpn_id
336: AND wlpn.outermost_lpn_id <> wlpn.lpn_id
337: AND mmtt.organization_id = p_org_id
338: AND mmtt.wms_task_type <> WMS_GLOBALS.g_wms_task_type_putaway
339: AND ( mmtt.content_lpn_id= wlpn.lpn_id OR mmtt.lpn_id = wlpn.lpn_id );
340:
341: l_par_lpn_id NUMBER;
342: l_lpn_id NUMBER;

Line 6262: DEBUG('p_wms_task_type =====> ' || WMS_GLOBALS.G_WMS_TASK_TYPE_PUTAWAY,l_proc_name,9);

6258: IF (p_call_type = g_ct_inspect_b4_tm) THEN
6259: IF (l_debug = 1) THEN
6260: DEBUG('Calling DELETE_DISPATCHED_TASK ...',l_proc_name,9);
6261: DEBUG('p_source_task_id => ' || l_tempid_tab(i),l_proc_name,9);
6262: DEBUG('p_wms_task_type =====> ' || WMS_GLOBALS.G_WMS_TASK_TYPE_PUTAWAY,l_proc_name,9);
6263: END IF;
6264: l_progress := '305';
6265:
6266: WMS_OP_RUNTIME_PVT_APIS.delete_dispatched_task

Line 6268: ,p_wms_task_type => WMS_GLOBALS.G_WMS_TASK_TYPE_INSPECT

6264: l_progress := '305';
6265:
6266: WMS_OP_RUNTIME_PVT_APIS.delete_dispatched_task
6267: ( p_source_task_id => l_tempid_tab(i)
6268: ,p_wms_task_type => WMS_GLOBALS.G_WMS_TASK_TYPE_INSPECT
6269: ,x_return_status => x_return_status
6270: ,x_msg_count => x_msg_count
6271: ,x_msg_data => x_msg_data
6272: );

Line 6779: AND mmtt.wms_task_type <> WMS_GLOBALS.g_wms_task_type_putaway

6775: SELECT COUNT(1) INTO l_invalid_cnt
6776: FROM Mtl_material_transactions_temp mmtt,
6777: Wms_License_Plate_Numbers wlpn
6778: WHERE mmtt.organization_id=p_org_id
6779: AND mmtt.wms_task_type <> WMS_GLOBALS.g_wms_task_type_putaway
6780: AND wlpn.outermost_lpn_id = p_lpn_id
6781: AND wlpn.organization_id = p_org_id
6782: AND mmtt.allocated_lpn_id = wlpn.lpn_id
6783: AND NOT EXISTS ( SELECT 1 FROM Wms_dispatched_tasks wdt

Line 6934: AND W.TASK_TYPE = WMS_GLOBALS.g_wms_task_type_putaway); --Bug#6920388.Added putaway check

6930: AND t.organization_id = p_org_id
6931: AND w.organization_id = p_org_id
6932: AND T.transaction_temp_id = W.transaction_temp_id
6933: AND W.STATUS = 4
6934: AND W.TASK_TYPE = WMS_GLOBALS.g_wms_task_type_putaway); --Bug#6920388.Added putaway check
6935: EXCEPTION
6936: WHEN NO_DATA_FOUND THEN
6937: x_loaded_status := 'N';
6938: END;