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 1183: l_trolin_val_rec := inv_trolin_util.convert_miss_to_null(l_trolin_val_rec);

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

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

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

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

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

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

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

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

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

Line 1300: 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);

1296: --debug('calling clear dependent attr');
1297: IF (l_debug = 1) THEN
1298: DEBUG('calling clear dependent attr', 'Inv_Transfer_Order_PVT.Trolins');
1299: END IF;
1300: 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);
1301: --debug('after calling dependent attr');
1302: END IF;
1303:
1304: -- Apply attribute changes

Line 1311: 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);

1307: --debug('Trolin Apply attr');
1308: IF (l_debug = 1) THEN
1309: DEBUG('Trolin Apply attr', 'Inv_Transfer_Order_PVT.Trolins');
1310: END IF;
1311: 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);
1312: END IF;
1313:
1314: --debug('AFter Trolin APply attr');
1315:

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

1411: RAISE fnd_api.g_exc_error;
1412: END IF;
1413: END IF;
1414:
1415: inv_trolin_util.delete_row(p_line_id => l_trolin_rec.line_id);
1416: ELSIF l_trolin_rec.operation = inv_globals.g_opr_update THEN
1417: -- Get Who Information
1418: -- Bug 3030538. Creation_date becomes null when both an update and
1419: -- create are done in move orders form

Line 1486: inv_trolin_util.update_row(l_trolin_rec);

1482: IF (l_debug = 1) THEN
1483: DEBUG('calling update row', 'Inv_Transfer_Order_PVT.Trolins');
1484: DEBUG(l_trolin_rec.line_id, 'Inv_Transfer_Order_PVT.Trolins');
1485: END IF;
1486: inv_trolin_util.update_row(l_trolin_rec);
1487: IF (l_debug = 1) THEN
1488: DEBUG('after update row', 'Inv_Transfer_Order_PVT.Trolins');
1489: END IF;
1490: ELSIF l_trolin_rec.operation = inv_globals.g_opr_create THEN

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

1497: DEBUG('create row', 'Inv_Transfer_Order_PVT.Trolins');
1498: END IF;
1499: /*Bug#5764123. Added the below line to convert the MISSING data
1500: to NULL.*/
1501: l_trolin_rec := inv_trolin_util.convert_miss_to_null(l_trolin_rec);
1502: inv_trolin_util.insert_row(l_trolin_rec);
1503: END IF;
1504: END IF;
1505:

Line 1502: inv_trolin_util.insert_row(l_trolin_rec);

1498: END IF;
1499: /*Bug#5764123. Added the below line to convert the MISSING data
1500: to NULL.*/
1501: l_trolin_rec := inv_trolin_util.convert_miss_to_null(l_trolin_rec);
1502: inv_trolin_util.insert_row(l_trolin_rec);
1503: END IF;
1504: END IF;
1505:
1506: IF (l_debug = 1) THEN

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

1904:
1905: -- Lock trolin
1906: FOR i IN 1 .. p_trolin_tbl.COUNT LOOP
1907: IF p_trolin_tbl(i).operation = inv_globals.g_opr_lock THEN
1908: inv_trolin_util.lock_row(p_trolin_rec => p_trolin_tbl(i), x_trolin_rec => l_trolin_rec, x_return_status => l_return_status);
1909:
1910: IF l_return_status = fnd_api.g_ret_sts_unexp_error THEN
1911: RAISE fnd_api.g_exc_unexpected_error;
1912: ELSIF l_return_status = fnd_api.g_ret_sts_error THEN

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

1991: -- Get trohdr ( parent = trohdr )
1992: l_trohdr_rec := inv_trohdr_util.query_row(p_header_id => p_header_id);
1993: -- Get trolin ( parent = trohdr )
1994: --debug('TRO : in get_transfer_order '||to_char(p_header_id)||' '||to_char(l_trohdr_rec.header_id));
1995: l_trolin_tbl := inv_trolin_util.query_rows(p_header_id => l_trohdr_rec.header_id);
1996: -- Load out parameters
1997: x_trohdr_rec := l_trohdr_rec;
1998: x_trolin_tbl := l_trolin_tbl;
1999: -- Set return status

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

2673: DEBUG('after calling mold_query_row', 'Finalize_Pick_Confirm');
2674: DEBUG('move order line id is '|| l_mmtt_rec.move_order_line_id, 'Finalize_Pick_Confirm');
2675: END IF;
2676: -- query the move order line for that move order line detail
2677: l_trolin_rec := inv_trolin_util.query_row(l_mmtt_rec.move_order_line_id);
2678: IF (l_debug = 1) THEN
2679: DEBUG('after calling trolin query row', 'Finalize_Pick_Confirm');
2680: DEBUG('transaction_quantity is '|| l_mmtt_rec.transaction_quantity, 'Finalize_Pick_Confirm');
2681: DEBUG('quantity detailed '|| l_trolin_rec.quantity_detailed, 'Finalize_Pick_Confirm');

Line 3205: inv_trolin_util.update_row(l_trolin_rec);

3201: -- Update the Move Order line
3202: IF (l_debug = 1) THEN
3203: DEBUG('calling update_row', 'Finalize_Pick_Confirm');
3204: END IF;
3205: inv_trolin_util.update_row(l_trolin_rec);
3206:
3207: /* Bug:4994950( Actual Bug 4762505). First checking if the current mo_line_id is closed or not.
3208: * Then checking if the record count exists for the current line_id.
3209: * If exists then increment the mmtt record count.

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

6276: DEBUG('Move Order Type = ' || l_mo_type,'INV_TRANSFER_ORDER_PVT.KILL_MOVE_ORDER');
6277: END IF;
6278: --If it is a replenishment move order, then check quantities and close it
6279: IF (l_mo_type = 2) THEN
6280: l_trolin_rec := inv_trolin_util.query_row(l_rep_mmtt_rec.move_order_line_id);
6281: --If the line is not closed, check quantity_delivered against quantity
6282: --If it is greater, then close the move order line
6283:
6284: IF l_trolin_rec.line_status NOT IN (5, 6) THEN

Line 6290: inv_trolin_util.update_row(l_trolin_rec);

6286: l_trolin_rec.line_status := 5;
6287: IF (l_debug = 1) THEN
6288: DEBUG('Closing the replenishment move order','INV_TRANSFER_ORDER_PVT.KILL_MOVE_ORDER');
6289: END IF;
6290: inv_trolin_util.update_row(l_trolin_rec);
6291: END IF; --END IF quantity_delivered > quantity
6292: END IF; --END IF line_status not closed, cancelled
6293: END IF; --END IF move_order_type = 2
6294: END LOOP;