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.INV_TRANSFER_ORDER_PVT dependencies on INV_TROLIN_UTIL

Line 1186: l_trolin_val_rec := inv_trolin_util.convert_miss_to_null(l_trolin_val_rec);

1182:
1183: IF p_trolin_val_tbl.EXISTS(i) THEN
1184: l_trolin_val_rec := p_trolin_val_tbl(i);
1185: -- Bug#2536932: Setting Missing Values as NULL.
1186: l_trolin_val_rec := inv_trolin_util.convert_miss_to_null(l_trolin_val_rec);
1187: ELSE
1188: l_trolin_val_rec := NULL;
1189: END IF;
1190:

Line 1217: l_old_trolin_rec := inv_trolin_util.convert_miss_to_null(l_old_trolin_rec);

1213: --debug('Trolin convert');
1214: IF (l_debug = 1) THEN
1215: DEBUG('Trolin convert', 'Inv_Transfer_Order_PVT.Trolins');
1216: END IF;
1217: l_old_trolin_rec := inv_trolin_util.convert_miss_to_null(l_old_trolin_rec);
1218: ELSIF l_trolin_rec.operation = inv_globals.g_opr_update
1219: OR l_trolin_rec.operation = inv_globals.g_opr_delete THEN
1220: l_trolin_rec.db_flag := fnd_api.g_true;
1221:

Line 1228: l_old_trolin_rec := inv_trolin_util.query_row(p_line_id => l_trolin_rec.line_id);

1224: --debug('Trolin line_id miss num');
1225: IF (l_debug = 1) THEN
1226: DEBUG('Trolin line_id miss num', 'Inv_Transfer_Order_PVT.Trolins');
1227: END IF;
1228: l_old_trolin_rec := inv_trolin_util.query_row(p_line_id => l_trolin_rec.line_id);
1229: ELSE
1230: -- Set missing old record elements to NULL.
1231: l_old_trolin_rec := inv_trolin_util.convert_miss_to_null(l_old_trolin_rec);
1232: END IF;

Line 1231: l_old_trolin_rec := inv_trolin_util.convert_miss_to_null(l_old_trolin_rec);

1227: END IF;
1228: l_old_trolin_rec := inv_trolin_util.query_row(p_line_id => l_trolin_rec.line_id);
1229: ELSE
1230: -- Set missing old record elements to NULL.
1231: l_old_trolin_rec := inv_trolin_util.convert_miss_to_null(l_old_trolin_rec);
1232: END IF;
1233:
1234: -- Complete new record from old
1235: l_trolin_rec := inv_trolin_util.complete_record(p_trolin_rec => l_trolin_rec, p_old_trolin_rec => l_old_trolin_rec);

Line 1235: l_trolin_rec := inv_trolin_util.complete_record(p_trolin_rec => l_trolin_rec, p_old_trolin_rec => l_old_trolin_rec);

1231: l_old_trolin_rec := inv_trolin_util.convert_miss_to_null(l_old_trolin_rec);
1232: END IF;
1233:
1234: -- Complete new record from old
1235: l_trolin_rec := inv_trolin_util.complete_record(p_trolin_rec => l_trolin_rec, p_old_trolin_rec => l_old_trolin_rec);
1236: END IF;
1237:
1238: --Bug 4756455 (11.5.10 bug 4755172 )
1239: --Reverted change of Bug 4329971here and removed the code

Line 1303: inv_trolin_util.clear_dependent_attr(p_trolin_rec => l_trolin_rec, p_old_trolin_rec => l_old_trolin_rec, x_trolin_rec => l_trolin_rec);

1299: --debug('calling clear dependent attr');
1300: IF (l_debug = 1) THEN
1301: DEBUG('calling clear dependent attr', 'Inv_Transfer_Order_PVT.Trolins');
1302: END IF;
1303: inv_trolin_util.clear_dependent_attr(p_trolin_rec => l_trolin_rec, p_old_trolin_rec => l_old_trolin_rec, x_trolin_rec => l_trolin_rec);
1304: --debug('after calling dependent attr');
1305: END IF;
1306:
1307: -- Apply attribute changes

Line 1314: inv_trolin_util.apply_attribute_changes(p_trolin_rec => l_trolin_rec, p_old_trolin_rec => l_old_trolin_rec, x_trolin_rec => l_trolin_rec);

1310: --debug('Trolin Apply attr');
1311: IF (l_debug = 1) THEN
1312: DEBUG('Trolin Apply attr', 'Inv_Transfer_Order_PVT.Trolins');
1313: END IF;
1314: inv_trolin_util.apply_attribute_changes(p_trolin_rec => l_trolin_rec, p_old_trolin_rec => l_old_trolin_rec, x_trolin_rec => l_trolin_rec);
1315: END IF;
1316:
1317: --debug('AFter Trolin APply attr');
1318:

Line 1428: inv_trolin_util.delete_row(p_line_id => l_trolin_rec.line_id);

1424: RAISE fnd_api.g_exc_error;
1425: END IF;
1426: END IF;
1427:
1428: inv_trolin_util.delete_row(p_line_id => l_trolin_rec.line_id);
1429: ELSIF l_trolin_rec.operation = inv_globals.g_opr_update THEN
1430: -- Get Who Information
1431: -- Bug 3030538. Creation_date becomes null when both an update and
1432: -- create are done in move orders form

Line 1499: inv_trolin_util.update_row(l_trolin_rec);

1495: IF (l_debug = 1) THEN
1496: DEBUG('calling update row', 'Inv_Transfer_Order_PVT.Trolins');
1497: DEBUG(l_trolin_rec.line_id, 'Inv_Transfer_Order_PVT.Trolins');
1498: END IF;
1499: inv_trolin_util.update_row(l_trolin_rec);
1500: IF (l_debug = 1) THEN
1501: DEBUG('after update row', 'Inv_Transfer_Order_PVT.Trolins');
1502: END IF;
1503: ELSIF l_trolin_rec.operation = inv_globals.g_opr_create THEN

Line 1514: l_trolin_rec := inv_trolin_util.convert_miss_to_null(l_trolin_rec);

1510: DEBUG('create row', 'Inv_Transfer_Order_PVT.Trolins');
1511: END IF;
1512: /*Bug#5764123. Added the below line to convert the MISSING data
1513: to NULL.*/
1514: l_trolin_rec := inv_trolin_util.convert_miss_to_null(l_trolin_rec);
1515: inv_trolin_util.insert_row(l_trolin_rec);
1516: END IF;
1517: END IF;
1518:

Line 1515: inv_trolin_util.insert_row(l_trolin_rec);

1511: END IF;
1512: /*Bug#5764123. Added the below line to convert the MISSING data
1513: to NULL.*/
1514: l_trolin_rec := inv_trolin_util.convert_miss_to_null(l_trolin_rec);
1515: inv_trolin_util.insert_row(l_trolin_rec);
1516: END IF;
1517: END IF;
1518:
1519: IF (l_debug = 1) THEN

Line 1921: inv_trolin_util.lock_row(p_trolin_rec => p_trolin_tbl(i), x_trolin_rec => l_trolin_rec, x_return_status => l_return_status);

1917:
1918: -- Lock trolin
1919: FOR i IN 1 .. p_trolin_tbl.COUNT LOOP
1920: IF p_trolin_tbl(i).operation = inv_globals.g_opr_lock THEN
1921: inv_trolin_util.lock_row(p_trolin_rec => p_trolin_tbl(i), x_trolin_rec => l_trolin_rec, x_return_status => l_return_status);
1922:
1923: IF l_return_status = fnd_api.g_ret_sts_unexp_error THEN
1924: RAISE fnd_api.g_exc_unexpected_error;
1925: ELSIF l_return_status = fnd_api.g_ret_sts_error THEN

Line 2008: l_trolin_tbl := inv_trolin_util.query_rows(p_header_id => l_trohdr_rec.header_id);

2004: -- Get trohdr ( parent = trohdr )
2005: l_trohdr_rec := inv_trohdr_util.query_row(p_header_id => p_header_id);
2006: -- Get trolin ( parent = trohdr )
2007: --debug('TRO : in get_transfer_order '||to_char(p_header_id)||' '||to_char(l_trohdr_rec.header_id));
2008: l_trolin_tbl := inv_trolin_util.query_rows(p_header_id => l_trohdr_rec.header_id);
2009: -- Load out parameters
2010: x_trohdr_rec := l_trohdr_rec;
2011: x_trolin_tbl := l_trolin_tbl;
2012: -- Set return status

Line 2708: l_trolin_rec := inv_trolin_util.query_row(l_mmtt_rec.move_order_line_id);

2704: DEBUG('after calling mold_query_row', 'Finalize_Pick_Confirm');
2705: DEBUG('move order line id is '|| l_mmtt_rec.move_order_line_id, 'Finalize_Pick_Confirm');
2706: END IF;
2707: -- query the move order line for that move order line detail
2708: l_trolin_rec := inv_trolin_util.query_row(l_mmtt_rec.move_order_line_id);
2709: IF (l_debug = 1) THEN
2710: DEBUG(' after calling trolin query row ', 'Finalize_Pick_Confirm');
2711: DEBUG(' transaction_quantity is '|| l_mmtt_rec.transaction_quantity, 'Finalize_Pick_Confirm');
2712: DEBUG(' quantity detailed '|| l_trolin_rec.quantity_detailed, 'Finalize_Pick_Confirm');

Line 3432: inv_trolin_util.update_row(l_trolin_rec);

3428: -- Update the Move Order line
3429: IF (l_debug = 1) THEN
3430: DEBUG('calling update_row', 'Finalize_Pick_Confirm');
3431: END IF;
3432: inv_trolin_util.update_row(l_trolin_rec);
3433:
3434: /* Bug:4994950( Actual Bug 4762505). First checking if the current mo_line_id is closed or not.
3435: * Then checking if the record count exists for the current line_id.
3436: * If exists then increment the mmtt record count.

Line 6713: l_trolin_rec := inv_trolin_util.query_row(l_rep_mmtt_rec.move_order_line_id);

6709: DEBUG('Move Order Type = ' || l_mo_type,'INV_TRANSFER_ORDER_PVT.KILL_MOVE_ORDER');
6710: END IF;
6711: --If it is a replenishment move order, then check quantities and close it
6712: IF (l_mo_type = 2) THEN
6713: l_trolin_rec := inv_trolin_util.query_row(l_rep_mmtt_rec.move_order_line_id);
6714: --If the line is not closed, check quantity_delivered against quantity
6715: --If it is greater, then close the move order line
6716:
6717: IF l_trolin_rec.line_status NOT IN (5, 6) THEN

Line 6724: inv_trolin_util.update_row(l_trolin_rec);

6720: l_trolin_rec.status_date := SYSDATE; -- Bug 8563083
6721: IF (l_debug = 1) THEN
6722: DEBUG('Closing the replenishment move order','INV_TRANSFER_ORDER_PVT.KILL_MOVE_ORDER');
6723: END IF;
6724: inv_trolin_util.update_row(l_trolin_rec);
6725: END IF; --END IF quantity_delivered > quantity
6726: END IF; --END IF line_status not closed, cancelled
6727: END IF; --END IF move_order_type = 2
6728: END LOOP;