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.AMS_LISTSOURCETYPE_PVT dependencies on FND_MESSAGE

Line 433: FND_MESSAGE.set_name ('AMS', 'AMS_API_CANNOT_DELETE');

429: fetch c_delete_sources into l_x;
430: exit when c_delete_sources%notfound;
431: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)
432: THEN
433: FND_MESSAGE.set_name ('AMS', 'AMS_API_CANNOT_DELETE');
434: FND_MSG_PUB.add;
435: END IF;
436: RAISE FND_API.g_exc_error;
437: end loop ;

Line 442: FND_MESSAGE.set_name ('AMS', 'AMS_API_CANNOT_DELETE');

438: close c_delete_sources ;
439: IF (p_list_source_type_id <= 10000) THEN
440: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)
441: THEN
442: FND_MESSAGE.set_name ('AMS', 'AMS_API_CANNOT_DELETE');
443: FND_MSG_PUB.add;
444: END IF;
445: RAISE FND_API.g_exc_error;
446: END IF;

Line 479: FND_MESSAGE.set_name ('AMS', 'AMS_API_RECORD_NOT_FOUND');

475:
476: IF (SQL%NOTFOUND) THEN
477: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)
478: THEN
479: FND_MESSAGE.set_name ('AMS', 'AMS_API_RECORD_NOT_FOUND');
480: FND_MSG_PUB.add;
481: END IF;
482: RAISE FND_API.g_exc_error;
483: END IF;

Line 639: FND_MESSAGE.set_name ('AMS', 'AMS_API_RECORD_NOT_FOUND');

635: FETCH c_lock_req INTO l_dummy;
636: IF c_lock_req%NOTFOUND THEN
637: CLOSE c_lock_req;
638: IF FND_MSG_PUB.check_msg_level (FND_MSG_PUB.g_msg_lvl_error) THEN
639: FND_MESSAGE.set_name ('AMS', 'AMS_API_RECORD_NOT_FOUND');
640: FND_MSG_PUB.add;
641: END IF;
642: RAISE FND_API.g_exc_error;
643: END IF;

Line 659: FND_MESSAGE.set_name ('AMS', 'AMS_API_RESOURCE_LOCKED');

655: EXCEPTION
656: WHEN AMS_Utility_PVT.resource_locked THEN
657: x_return_status := FND_API.g_ret_sts_error;
658: IF FND_MSG_PUB.check_msg_level (FND_MSG_PUB.g_msg_lvl_error) THEN
659: FND_MESSAGE.set_name ('AMS', 'AMS_API_RESOURCE_LOCKED');
660: FND_MSG_PUB.add;
661: END IF;
662:
663: FND_MSG_PUB.count_and_get(

Line 759: FND_MESSAGE.set_name ('AMS', 'AMS_API_CANNOT_UPDATE');

755: /*
756: IF (l_listsrctype_rec.list_source_type_id <= 10000) THEN
757: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)
758: THEN
759: FND_MESSAGE.set_name ('AMS', 'AMS_API_CANNOT_UPDATE');
760: FND_MSG_PUB.add;
761: END IF;
762: RAISE FND_API.g_exc_error;
763: END IF;

Line 824: FND_MESSAGE.set_name ('AMS', 'AMS_API_RECORD_NOT_FOUND');

820: ;
821:
822: IF (SQL%NOTFOUND) THEN
823: IF FND_MSG_PUB.check_msg_level (FND_MSG_PUB.g_msg_lvl_error) THEN
824: FND_MESSAGE.set_name ('AMS', 'AMS_API_RECORD_NOT_FOUND');
825: FND_MSG_PUB.add;
826: END IF;
827: RAISE FND_API.g_exc_error;
828: END IF;

Line 846: FND_MESSAGE.set_name('AMS', 'API_UNEXP_ERROR_IN_PROCESSING');

842: -- Error, check the msg level and added an error message to the --
843: -- API message list. --
844: ------------------------------------------------------------------
845: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
846: FND_MESSAGE.set_name('AMS', 'API_UNEXP_ERROR_IN_PROCESSING');
847: FND_MESSAGE.Set_Token('ROW', 'AMS_ListSourceType_PVT.Upd_AMS_LIST_SRC_TYPES_TL', TRUE);
848: FND_MSG_PUB.Add;
849: END IF;
850: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 847: FND_MESSAGE.Set_Token('ROW', 'AMS_ListSourceType_PVT.Upd_AMS_LIST_SRC_TYPES_TL', TRUE);

843: -- API message list. --
844: ------------------------------------------------------------------
845: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
846: FND_MESSAGE.set_name('AMS', 'API_UNEXP_ERROR_IN_PROCESSING');
847: FND_MESSAGE.Set_Token('ROW', 'AMS_ListSourceType_PVT.Upd_AMS_LIST_SRC_TYPES_TL', TRUE);
848: FND_MSG_PUB.Add;
849: END IF;
850: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
851: END IF;

Line 1053: FND_MESSAGE.SET_NAME('AMS', 'AMS_INVALID_IMPORT_TYPE');

1049: OPEN c_import_type(p_listsrctype_rec.import_type);
1050: FETCH c_import_type into l_import_type;
1051: IF (c_import_type%NOTFOUND) THEN
1052: CLOSE c_import_type;
1053: FND_MESSAGE.SET_NAME('AMS', 'AMS_INVALID_IMPORT_TYPE');
1054: FND_MSG_PUB.Add;
1055: x_return_status := FND_API.g_ret_sts_error;
1056: RETURN;
1057: END IF;

Line 1066: FND_MESSAGE.SET_NAME('AMS', 'AMS_INVALID_SOURCE_TYPE_CODE');

1062: -- contains characters, numbers, and understore characters
1063: OPEN c_viewname(p_listsrctype_rec.source_type_code);
1064: FETCH c_viewname into l_cnt;
1065: IF l_cnt > 1 THEN
1066: FND_MESSAGE.SET_NAME('AMS', 'AMS_INVALID_SOURCE_TYPE_CODE');
1067: FND_MSG_PUB.Add;
1068: x_return_status := FND_API.g_ret_sts_error;
1069: RETURN;
1070: END IF;

Line 1298: FND_MESSAGE.set_name('AMS', 'AMS_API_RECORD_NOT_FOUND');

1294: FETCH c_fields INTO l_listsrctype_rec;
1295: IF c_fields%NOTFOUND THEN
1296: CLOSE c_fields;
1297: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
1298: FND_MESSAGE.set_name('AMS', 'AMS_API_RECORD_NOT_FOUND');
1299: FND_MSG_PUB.add;
1300: END IF;
1301: RAISE FND_API.g_exc_error;
1302: END IF;

Line 1381: FND_MESSAGE.set_name('AMS', 'AMS_LIST_NO_LISTSRC_TYPE');

1377:
1378: -- list_source_type
1379: IF p_listsrctype_rec.list_source_type IS NULL THEN
1380: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
1381: FND_MESSAGE.set_name('AMS', 'AMS_LIST_NO_LISTSRC_TYPE');
1382: FND_MSG_PUB.add;
1383: END IF;
1384:
1385: x_return_status := FND_API.g_ret_sts_error;

Line 1392: FND_MESSAGE.set_name('AMS', 'AMS_LIST_NO_LISTSRC_NAME');

1388:
1389: -- list_source_name
1390: IF p_listsrctype_rec.list_source_name IS NULL THEN
1391: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
1392: FND_MESSAGE.set_name('AMS', 'AMS_LIST_NO_LISTSRC_NAME');
1393: FND_MSG_PUB.add;
1394: END IF;
1395:
1396: x_return_status := FND_API.g_ret_sts_error;

Line 1404: FND_MESSAGE.set_name('AMS', 'AMS_LIST_NO_SRCTYPE_CODE');

1400:
1401: -- source_type_code
1402: IF p_listsrctype_rec.source_type_code IS NULL THEN
1403: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
1404: FND_MESSAGE.set_name('AMS', 'AMS_LIST_NO_SRCTYPE_CODE');
1405: FND_MSG_PUB.add;
1406: END IF;
1407:
1408: x_return_status := FND_API.g_ret_sts_error;

Line 1415: FND_MESSAGE.set_name('AMS', 'AMS_LIST_NO_SRCOBJ_NAME');

1411:
1412: -- source_object_name
1413: IF p_listsrctype_rec.source_object_name IS NULL THEN
1414: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
1415: FND_MESSAGE.set_name('AMS', 'AMS_LIST_NO_SRCOBJ_NAME');
1416: FND_MSG_PUB.add;
1417: END IF;
1418:
1419: x_return_status := FND_API.g_ret_sts_error;

Line 1469: FND_MESSAGE.set_name('AMS', 'AMS_LIST_DUPE_LISTSRC_NAME');

1465: FETCH c_name_create INTO l_valid_flag;
1466: CLOSE c_name_create;
1467: IF l_valid_flag IS NOT NULL THEN
1468: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
1469: FND_MESSAGE.set_name('AMS', 'AMS_LIST_DUPE_LISTSRC_NAME');
1470: FND_MSG_PUB.add;
1471: END IF;
1472: x_return_status := FND_API.g_ret_sts_error;
1473: l_valid_flag := NULL;

Line 1483: FND_MESSAGE.set_name('AMS', 'AMS_LIST_DUPE_LISTSRC_TYPE');

1479: p_where_clause => l_where_clause
1480: );
1481: IF l_valid_flag = FND_API.g_false THEN
1482: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
1483: FND_MESSAGE.set_name('AMS', 'AMS_LIST_DUPE_LISTSRC_TYPE');
1484: FND_MSG_PUB.add;
1485: END IF;
1486: x_return_status := FND_API.g_ret_sts_error;
1487: l_valid_flag := NULL;

Line 1496: FND_MESSAGE.set_name('AMS', 'AMS_LIST_DUPE_LISTSRC_NAME');

1492: FETCH c_name_update INTO l_valid_flag;
1493: CLOSE c_name_update;
1494: IF l_valid_flag IS NOT NULL THEN
1495: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
1496: FND_MESSAGE.set_name('AMS', 'AMS_LIST_DUPE_LISTSRC_NAME');
1497: FND_MSG_PUB.add;
1498: END IF;
1499: x_return_status := FND_API.g_ret_sts_error;
1500: l_valid_flag := NULL;

Line 1510: FND_MESSAGE.set_name('AMS', 'AMS_LIST_DUPE_LISTSRC_TYPE');

1506: p_where_clause => l_where_clause || ' AND list_source_type_id <> ' || p_listsrctype_rec.list_source_type_id
1507: );
1508: IF l_valid_flag = FND_API.g_false THEN
1509: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
1510: FND_MESSAGE.set_name('AMS', 'AMS_LIST_DUPE_LISTSRC_TYPE');
1511: FND_MSG_PUB.add;
1512: END IF;
1513: x_return_status := FND_API.g_ret_sts_error;
1514: l_valid_flag := NULL;

Line 1607: FND_MESSAGE.set_name ('AMS', 'AMS_LIST_BAD_MASTERSRC_FLAG');

1603: -- master_source_type_flag
1604: IF p_listsrctype_rec.master_source_type_flag <> FND_API.g_miss_char AND p_listsrctype_rec.master_source_type_flag IS NOT NULL THEN
1605: IF AMS_Utility_PVT.is_Y_or_N (p_listsrctype_rec.master_source_type_flag) = FND_API.g_false THEN
1606: IF FND_MSG_PUB.check_msg_level (FND_MSG_PUB.g_msg_lvl_error) THEN
1607: FND_MESSAGE.set_name ('AMS', 'AMS_LIST_BAD_MASTERSRC_FLAG');
1608: FND_MSG_PUB.add;
1609: END IF;
1610:
1611: x_return_status := FND_API.g_ret_sts_error;

Line 1620: FND_MESSAGE.set_name ('AMS', 'AMS_LIST_BAD_ENABLED_FLAG');

1616: -- enabled_flag
1617: IF p_listsrctype_rec.enabled_flag <> FND_API.g_miss_char AND p_listsrctype_rec.enabled_flag IS NOT NULL THEN
1618: IF AMS_Utility_PVT.is_Y_or_N (p_listsrctype_rec.enabled_flag) = FND_API.g_false THEN
1619: IF FND_MSG_PUB.check_msg_level (FND_MSG_PUB.g_msg_lvl_error) THEN
1620: FND_MESSAGE.set_name ('AMS', 'AMS_LIST_BAD_ENABLED_FLAG');
1621: FND_MSG_PUB.add;
1622: END IF;
1623:
1624: x_return_status := FND_API.g_ret_sts_error;