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_UTILS_PVT dependencies on INV_GLOBALS

Line 27: AND mol.line_status = inv_globals.g_to_status_cancel_by_source;

23: FROM mtl_material_transactions_temp mmtt
24: , mtl_txn_request_lines mol
25: WHERE mmtt.transfer_lpn_id = p_lpn_id
26: AND mmtt.move_order_line_id = mol.line_id
27: AND mol.line_status = inv_globals.g_to_status_cancel_by_source;
28:
29: l_debug NUMBER := NVL(fnd_profile.VALUE('INV_DEBUG_TRACE'), 0);
30: BEGIN
31: IF (l_debug = 1) THEN

Line 245: IF (line_status = inv_globals.g_to_status_cancel_by_source) THEN

241: IF (l_debug = 1) THEN
242: mydebug(' move order line status ' || line_status);
243: END IF;
244:
245: IF (line_status = inv_globals.g_to_status_cancel_by_source) THEN
246: IF (l_debug = 1) THEN
247: mydebug(' move order line cancelled ');
248: END IF;
249:

Line 319: SET line_status = inv_globals.g_to_status_closed

315: mydebug(' so closing the mo line ' || mol_id);
316: END IF;
317:
318: UPDATE mtl_txn_request_lines
319: SET line_status = inv_globals.g_to_status_closed
320: WHERE line_id = mol_id;
321:
322: IF (l_debug = 1) THEN
323: mydebug(' updated the mo line status to ' || inv_globals.g_to_status_closed);

Line 323: mydebug(' updated the mo line status to ' || inv_globals.g_to_status_closed);

319: SET line_status = inv_globals.g_to_status_closed
320: WHERE line_id = mol_id;
321:
322: IF (l_debug = 1) THEN
323: mydebug(' updated the mo line status to ' || inv_globals.g_to_status_closed);
324: END IF;
325: ELSE
326: IF (l_debug = 1) THEN
327: mydebug(' allocations in mmtt left for this mo line - count ' || mol_id || ' - ' || cnt);

Line 1642: mmtt_row.transaction_source_type_id := inv_globals.g_sourcetype_moveorder; -- bug 4230494

1638: -- Always the second task is a replenishment task
1639:
1640: mmtt_row.wms_task_type := 4;
1641: mmtt_row.move_order_line_id := p_mo_line_id;
1642: mmtt_row.transaction_source_type_id := inv_globals.g_sourcetype_moveorder; -- bug 4230494
1643: mmtt_row.transaction_type_id := 64; -- bug 4230494 move order xfer
1644: mmtt_row.transaction_action_id := inv_globals.g_action_subxfr;
1645: mmtt_row.process_flag := 'Y';
1646: mmtt_row.transaction_status := 2;

Line 1644: mmtt_row.transaction_action_id := inv_globals.g_action_subxfr;

1640: mmtt_row.wms_task_type := 4;
1641: mmtt_row.move_order_line_id := p_mo_line_id;
1642: mmtt_row.transaction_source_type_id := inv_globals.g_sourcetype_moveorder; -- bug 4230494
1643: mmtt_row.transaction_type_id := 64; -- bug 4230494 move order xfer
1644: mmtt_row.transaction_action_id := inv_globals.g_action_subxfr;
1645: mmtt_row.process_flag := 'Y';
1646: mmtt_row.transaction_status := 2;
1647: mmtt_row.transfer_subinventory := p_old_sub_code;
1648: mmtt_row.transfer_to_location := p_old_loc_id;

Line 1735: l_trohdr_rec.header_status := INV_Globals.G_TO_STATUS_PREAPPROVED;

1731: l_trohdr_rec.created_by := FND_GLOBAL.USER_ID;
1732: l_trohdr_rec.creation_date := sysdate;
1733: l_trohdr_rec.date_required := sysdate;
1734: l_trohdr_rec.from_subinventory_code := mmtt_row.subinventory_code;
1735: l_trohdr_rec.header_status := INV_Globals.G_TO_STATUS_PREAPPROVED;
1736: l_trohdr_rec.last_updated_by := FND_GLOBAL.USER_ID;
1737: l_trohdr_rec.last_update_date := sysdate;
1738: l_trohdr_rec.last_update_login := FND_GLOBAL.USER_ID;
1739: l_trohdr_rec.organization_id := mmtt_row.organization_id;

Line 1742: l_trohdr_rec. move_order_type := INV_GLOBALS.g_move_order_replenishment;

1738: l_trohdr_rec.last_update_login := FND_GLOBAL.USER_ID;
1739: l_trohdr_rec.organization_id := mmtt_row.organization_id;
1740: l_trohdr_rec.status_date := sysdate;
1741: l_trohdr_rec.to_subinventory_code := mmtt_row.transfer_subinventory;
1742: l_trohdr_rec. move_order_type := INV_GLOBALS.g_move_order_replenishment;
1743: l_trohdr_rec.db_flag := FND_API.G_TRUE;
1744: l_trohdr_rec.operation := INV_GLOBALS.G_OPR_CREATE;
1745:
1746: l_line_num := 1;

Line 1744: l_trohdr_rec.operation := INV_GLOBALS.G_OPR_CREATE;

1740: l_trohdr_rec.status_date := sysdate;
1741: l_trohdr_rec.to_subinventory_code := mmtt_row.transfer_subinventory;
1742: l_trohdr_rec. move_order_type := INV_GLOBALS.g_move_order_replenishment;
1743: l_trohdr_rec.db_flag := FND_API.G_TRUE;
1744: l_trohdr_rec.operation := INV_GLOBALS.G_OPR_CREATE;
1745:
1746: l_line_num := 1;
1747: l_trolin_tbl(1).header_id := l_trohdr_rec.header_id;
1748: l_trolin_tbl(1).created_by := FND_GLOBAL.USER_ID;

Line 1761: l_trolin_tbl(1).line_status := INV_Globals.G_TO_STATUS_PREAPPROVED;

1757: l_trolin_tbl(1).last_update_date := sysdate;
1758: l_trolin_tbl(1).last_update_login := FND_GLOBAL.LOGIN_ID;
1759: l_trolin_tbl(1).line_id := FND_API.G_MISS_NUM;
1760: l_trolin_tbl(1).line_number := l_line_num;
1761: l_trolin_tbl(1).line_status := INV_Globals.G_TO_STATUS_PREAPPROVED;
1762: l_trolin_tbl(1).organization_id := mmtt_row.organization_id;
1763: l_trolin_tbl(1).quantity := mmtt_row.primary_quantity;
1764: l_trolin_tbl(1).quantity_detailed := mmtt_row.primary_quantity;
1765: --Bug 4593622 stamping mmtt_row.primary_quantity as quantity_detailed

Line 1771: l_trolin_tbl(1).operation := INV_GLOBALS.G_OPR_CREATE;

1767: l_trolin_tbl(1).status_date := sysdate;
1768: l_trolin_tbl(1).to_subinventory_code := mmtt_row.transfer_subinventory;
1769: l_trolin_tbl(1).uom_code := l_uom;
1770: l_trolin_tbl(1).db_flag := FND_API.G_TRUE;
1771: l_trolin_tbl(1).operation := INV_GLOBALS.G_OPR_CREATE;
1772:
1773: l_trolin_tbl(1).lpn_id := NULL;
1774: l_trolin_tbl(1).reference:=l_ref;
1775: l_trolin_tbl(1).reference_type_code:=l_ref_type;

Line 2285: AND mtrl.line_status = INV_GLOBALS.G_TO_STATUS_CANCEL_BY_SOURCE;

2281: FROM mtl_material_transactions_temp mmtt
2282: , mtl_txn_request_lines mtrl
2283: WHERE (mmtt.transaction_temp_id = p_temp_id OR mmtt.parent_line_id = p_temp_id)
2284: AND mtrl.line_id = mmtt.move_order_line_id
2285: AND mtrl.line_status = INV_GLOBALS.G_TO_STATUS_CANCEL_BY_SOURCE;
2286:
2287: CURSOR c_mmtt_to_del IS
2288: SELECT mmtt.transaction_temp_id, mmtt.primary_quantity
2289: FROM mtl_material_transactions_temp mmtt

Line 2391: , line_status = DECODE(l_mmtt_count, 0, INV_GLOBALS.G_TO_STATUS_CLOSED, line_status)

2387: CLOSE c_get_mmtt_count;
2388:
2389: UPDATE mtl_txn_request_lines
2390: SET quantity_detailed =(quantity_detailed - l_deleted_quantity)
2391: , line_status = DECODE(l_mmtt_count, 0, INV_GLOBALS.G_TO_STATUS_CLOSED, line_status)
2392: WHERE line_id = l_mo_line_id;
2393: END LOOP;
2394: CLOSE c_mo_line_id;
2395: