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_TROHDR_UTIL dependencies on FND_MSG_PUB

Line 900: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN

896: , ship_to_location_id = p_trohdr_rec.ship_to_location_id
897: WHERE header_id = p_trohdr_rec.header_id;
898: EXCEPTION
899: WHEN OTHERS THEN
900: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
901: fnd_msg_pub.add_exc_msg(g_pkg_name, 'Update_Row');
902: END IF;
903:
904: RAISE fnd_api.g_exc_unexpected_error;

Line 901: fnd_msg_pub.add_exc_msg(g_pkg_name, 'Update_Row');

897: WHERE header_id = p_trohdr_rec.header_id;
898: EXCEPTION
899: WHEN OTHERS THEN
900: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
901: fnd_msg_pub.add_exc_msg(g_pkg_name, 'Update_Row');
902: END IF;
903:
904: RAISE fnd_api.g_exc_unexpected_error;
905: END update_row;

Line 996: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN

992: , p_trohdr_rec.ship_to_location_id
993: );
994: EXCEPTION
995: WHEN OTHERS THEN
996: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
997: fnd_msg_pub.add_exc_msg(g_pkg_name, 'Insert_Row');
998: END IF;
999:
1000: RAISE fnd_api.g_exc_unexpected_error;

Line 997: fnd_msg_pub.add_exc_msg(g_pkg_name, 'Insert_Row');

993: );
994: EXCEPTION
995: WHEN OTHERS THEN
996: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
997: fnd_msg_pub.add_exc_msg(g_pkg_name, 'Insert_Row');
998: END IF;
999:
1000: RAISE fnd_api.g_exc_unexpected_error;
1001: END insert_row;

Line 1011: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN

1007: DELETE FROM mtl_txn_request_headers
1008: WHERE header_id = p_header_id;
1009: EXCEPTION
1010: WHEN OTHERS THEN
1011: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
1012: fnd_msg_pub.add_exc_msg(g_pkg_name, 'Delete_Row');
1013: END IF;
1014:
1015: RAISE fnd_api.g_exc_unexpected_error;

Line 1012: fnd_msg_pub.add_exc_msg(g_pkg_name, 'Delete_Row');

1008: WHERE header_id = p_header_id;
1009: EXCEPTION
1010: WHEN OTHERS THEN
1011: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
1012: fnd_msg_pub.add_exc_msg(g_pkg_name, 'Delete_Row');
1013: END IF;
1014:
1015: RAISE fnd_api.g_exc_unexpected_error;
1016: END delete_row;

Line 1031: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN

1027: l_trohdr_rec.last_update_login := fnd_global.login_id;
1028: inv_trohdr_util.update_row(l_trohdr_rec);
1029: EXCEPTION
1030: WHEN OTHERS THEN
1031: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
1032: fnd_msg_pub.add_exc_msg(g_pkg_name, 'Update_Row_Status');
1033: END IF;
1034:
1035: RAISE fnd_api.g_exc_unexpected_error;

Line 1032: fnd_msg_pub.add_exc_msg(g_pkg_name, 'Update_Row_Status');

1028: inv_trohdr_util.update_row(l_trohdr_rec);
1029: EXCEPTION
1030: WHEN OTHERS THEN
1031: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
1032: fnd_msg_pub.add_exc_msg(g_pkg_name, 'Update_Row_Status');
1033: END IF;
1034:
1035: RAISE fnd_api.g_exc_unexpected_error;
1036: END update_row_status;

Line 1128: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN

1124:
1125: RETURN l_trohdr_rec;
1126: EXCEPTION
1127: WHEN OTHERS THEN
1128: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
1129: fnd_msg_pub.add_exc_msg(g_pkg_name, 'Query_Row');
1130: END IF;
1131:
1132: RAISE fnd_api.g_exc_unexpected_error;

Line 1129: fnd_msg_pub.add_exc_msg(g_pkg_name, 'Query_Row');

1125: RETURN l_trohdr_rec;
1126: EXCEPTION
1127: WHEN OTHERS THEN
1128: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
1129: fnd_msg_pub.add_exc_msg(g_pkg_name, 'Query_Row');
1130: END IF;
1131:
1132: RAISE fnd_api.g_exc_unexpected_error;
1133: END query_row;

Line 1277: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error) THEN

1273:
1274: x_return_status := fnd_api.g_ret_sts_error;
1275: x_trohdr_rec.return_status := fnd_api.g_ret_sts_error;
1276:
1277: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error) THEN
1278: fnd_message.set_name('INV', 'OE_LOCK_ROW_CHANGED');
1279: fnd_msg_pub.ADD;
1280: END IF;
1281: END IF;

Line 1279: fnd_msg_pub.ADD;

1275: x_trohdr_rec.return_status := fnd_api.g_ret_sts_error;
1276:
1277: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error) THEN
1278: fnd_message.set_name('INV', 'OE_LOCK_ROW_CHANGED');
1279: fnd_msg_pub.ADD;
1280: END IF;
1281: END IF;
1282: EXCEPTION
1283: WHEN NO_DATA_FOUND THEN

Line 1287: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error) THEN

1283: WHEN NO_DATA_FOUND THEN
1284: x_return_status := fnd_api.g_ret_sts_error;
1285: x_trohdr_rec.return_status := fnd_api.g_ret_sts_error;
1286:
1287: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error) THEN
1288: fnd_message.set_name('INV', 'OE_LOCK_ROW_DELETED');
1289: fnd_msg_pub.ADD;
1290: END IF;
1291: WHEN app_exceptions.record_lock_exception THEN

Line 1289: fnd_msg_pub.ADD;

1285: x_trohdr_rec.return_status := fnd_api.g_ret_sts_error;
1286:
1287: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error) THEN
1288: fnd_message.set_name('INV', 'OE_LOCK_ROW_DELETED');
1289: fnd_msg_pub.ADD;
1290: END IF;
1291: WHEN app_exceptions.record_lock_exception THEN
1292: x_return_status := fnd_api.g_ret_sts_error;
1293: x_trohdr_rec.return_status := fnd_api.g_ret_sts_error;

Line 1295: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error) THEN

1291: WHEN app_exceptions.record_lock_exception THEN
1292: x_return_status := fnd_api.g_ret_sts_error;
1293: x_trohdr_rec.return_status := fnd_api.g_ret_sts_error;
1294:
1295: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error) THEN
1296: fnd_message.set_name('INV', 'OE_LOCK_ROW_ALREADY_LOCKED');
1297: fnd_msg_pub.ADD;
1298: END IF;
1299: WHEN OTHERS THEN

Line 1297: fnd_msg_pub.ADD;

1293: x_trohdr_rec.return_status := fnd_api.g_ret_sts_error;
1294:
1295: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error) THEN
1296: fnd_message.set_name('INV', 'OE_LOCK_ROW_ALREADY_LOCKED');
1297: fnd_msg_pub.ADD;
1298: END IF;
1299: WHEN OTHERS THEN
1300: x_return_status := fnd_api.g_ret_sts_unexp_error;
1301: x_trohdr_rec.return_status := fnd_api.g_ret_sts_unexp_error;

Line 1303: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN

1299: WHEN OTHERS THEN
1300: x_return_status := fnd_api.g_ret_sts_unexp_error;
1301: x_trohdr_rec.return_status := fnd_api.g_ret_sts_unexp_error;
1302:
1303: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
1304: fnd_msg_pub.add_exc_msg(g_pkg_name, 'Lock_Row');
1305: END IF;
1306: END lock_row;
1307:

Line 1304: fnd_msg_pub.add_exc_msg(g_pkg_name, 'Lock_Row');

1300: x_return_status := fnd_api.g_ret_sts_unexp_error;
1301: x_trohdr_rec.return_status := fnd_api.g_ret_sts_unexp_error;
1302:
1303: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
1304: fnd_msg_pub.add_exc_msg(g_pkg_name, 'Lock_Row');
1305: END IF;
1306: END lock_row;
1307:
1308: -- Function Get_Values

Line 1388: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_success) THEN

1384: IF p_trohdr_val_rec.from_subinventory <> fnd_api.g_miss_char THEN
1385: IF p_trohdr_rec.from_subinventory_code <> fnd_api.g_miss_char THEN
1386: l_trohdr_rec.from_subinventory_code := p_trohdr_rec.from_subinventory_code;
1387:
1388: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_success) THEN
1389: fnd_message.set_name('INV', 'FND_BOTH_VAL_AND_ID_EXIST');
1390: fnd_message.set_token('ATTRIBUTE', 'from_subinventory');
1391: fnd_msg_pub.ADD;
1392: END IF;

Line 1391: fnd_msg_pub.ADD;

1387:
1388: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_success) THEN
1389: fnd_message.set_name('INV', 'FND_BOTH_VAL_AND_ID_EXIST');
1390: fnd_message.set_token('ATTRIBUTE', 'from_subinventory');
1391: fnd_msg_pub.ADD;
1392: END IF;
1393: ELSE
1394: l_trohdr_rec.from_subinventory_code := inv_value_to_id.from_subinventory(p_organization_id => p_trohdr_rec.organization_id, p_from_subinventory => p_trohdr_val_rec.from_subinventory);
1395:

Line 1406: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_success) THEN

1402: IF p_trohdr_val_rec.header <> fnd_api.g_miss_char THEN
1403: IF p_trohdr_rec.header_id <> fnd_api.g_miss_num THEN
1404: l_trohdr_rec.header_id := p_trohdr_rec.header_id;
1405:
1406: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_success) THEN
1407: fnd_message.set_name('INV', 'FND_BOTH_VAL_AND_ID_EXIST');
1408: fnd_message.set_token('ATTRIBUTE', 'header');
1409: fnd_msg_pub.ADD;
1410: END IF;

Line 1409: fnd_msg_pub.ADD;

1405:
1406: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_success) THEN
1407: fnd_message.set_name('INV', 'FND_BOTH_VAL_AND_ID_EXIST');
1408: fnd_message.set_token('ATTRIBUTE', 'header');
1409: fnd_msg_pub.ADD;
1410: END IF;
1411: ELSE
1412: l_trohdr_rec.header_id := inv_value_to_id.header(p_header => p_trohdr_val_rec.header);
1413:

Line 1424: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_success) THEN

1420: IF p_trohdr_val_rec.ORGANIZATION <> fnd_api.g_miss_char THEN
1421: IF p_trohdr_rec.organization_id <> fnd_api.g_miss_num THEN
1422: l_trohdr_rec.organization_id := p_trohdr_rec.organization_id;
1423:
1424: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_success) THEN
1425: fnd_message.set_name('INV', 'FND_BOTH_VAL_AND_ID_EXIST');
1426: fnd_message.set_token('ATTRIBUTE', 'organization');
1427: fnd_msg_pub.ADD;
1428: END IF;

Line 1427: fnd_msg_pub.ADD;

1423:
1424: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_success) THEN
1425: fnd_message.set_name('INV', 'FND_BOTH_VAL_AND_ID_EXIST');
1426: fnd_message.set_token('ATTRIBUTE', 'organization');
1427: fnd_msg_pub.ADD;
1428: END IF;
1429: ELSE
1430: l_trohdr_rec.organization_id := inv_value_to_id.ORGANIZATION(p_organization => p_trohdr_val_rec.ORGANIZATION);
1431:

Line 1442: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_success) THEN

1438: IF p_trohdr_val_rec.to_account <> fnd_api.g_miss_char THEN
1439: IF p_trohdr_rec.to_account_id <> fnd_api.g_miss_num THEN
1440: l_trohdr_rec.to_account_id := p_trohdr_rec.to_account_id;
1441:
1442: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_success) THEN
1443: fnd_message.set_name('INV', 'FND_BOTH_VAL_AND_ID_EXIST');
1444: fnd_message.set_token('ATTRIBUTE', 'to_account');
1445: fnd_msg_pub.ADD;
1446: END IF;

Line 1445: fnd_msg_pub.ADD;

1441:
1442: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_success) THEN
1443: fnd_message.set_name('INV', 'FND_BOTH_VAL_AND_ID_EXIST');
1444: fnd_message.set_token('ATTRIBUTE', 'to_account');
1445: fnd_msg_pub.ADD;
1446: END IF;
1447: ELSE
1448: l_trohdr_rec.to_account_id := inv_value_to_id.to_account(p_organization_id => p_trohdr_rec.organization_id, p_to_account => p_trohdr_val_rec.to_account);
1449:

Line 1460: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_success) THEN

1456: IF p_trohdr_val_rec.to_subinventory <> fnd_api.g_miss_char THEN
1457: IF p_trohdr_rec.to_subinventory_code <> fnd_api.g_miss_char THEN
1458: l_trohdr_rec.to_subinventory_code := p_trohdr_rec.to_subinventory_code;
1459:
1460: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_success) THEN
1461: fnd_message.set_name('INV', 'FND_BOTH_VAL_AND_ID_EXIST');
1462: fnd_message.set_token('ATTRIBUTE', 'to_subinventory');
1463: fnd_msg_pub.ADD;
1464: END IF;

Line 1463: fnd_msg_pub.ADD;

1459:
1460: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_success) THEN
1461: fnd_message.set_name('INV', 'FND_BOTH_VAL_AND_ID_EXIST');
1462: fnd_message.set_token('ATTRIBUTE', 'to_subinventory');
1463: fnd_msg_pub.ADD;
1464: END IF;
1465: ELSE
1466: l_trohdr_rec.to_subinventory_code := inv_value_to_id.to_subinventory(p_organization_id => p_trohdr_rec.organization_id, p_to_subinventory => p_trohdr_val_rec.to_subinventory);
1467:

Line 1478: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_success) THEN

1474: IF p_trohdr_val_rec.move_order_type <> fnd_api.g_miss_char THEN
1475: IF p_trohdr_rec.move_order_type <> fnd_api.g_miss_num THEN
1476: l_trohdr_rec.move_order_type := p_trohdr_rec.move_order_type;
1477:
1478: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_success) THEN
1479: fnd_message.set_name('INV', 'FND_BOTH_VAL_AND_ID_EXIST');
1480: fnd_message.set_token('ATTRIBUTE', 'move_order_type');
1481: fnd_msg_pub.ADD;
1482: END IF;

Line 1481: fnd_msg_pub.ADD;

1477:
1478: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_success) THEN
1479: fnd_message.set_name('INV', 'FND_BOTH_VAL_AND_ID_EXIST');
1480: fnd_message.set_token('ATTRIBUTE', 'move_order_type');
1481: fnd_msg_pub.ADD;
1482: END IF;
1483: ELSE
1484: l_trohdr_rec.move_order_type := inv_value_to_id.move_order_type(p_move_order_type => p_trohdr_val_rec.move_order_type);
1485:

Line 1497: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_SUCCESS)

1493: IF p_trohdr_rec.transaction_type_id <> FND_API.G_MISS_NUM THEN
1494:
1495: l_trohdr_rec.transaction_type_id := p_trohdr_rec.transaction_type_id;
1496:
1497: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_SUCCESS)
1498: THEN
1499:
1500: FND_MESSAGE.SET_NAME('INV','FND_BOTH_VAL_AND_ID_EXIST');
1501: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','transaction_type_id');

Line 1502: FND_MSG_PUB.Add;

1498: THEN
1499:
1500: FND_MESSAGE.SET_NAME('INV','FND_BOTH_VAL_AND_ID_EXIST');
1501: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','transaction_type_id');
1502: FND_MSG_PUB.Add;
1503:
1504: END IF;
1505:
1506: ELSE