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 431: FND_MESSAGE.set_name ('AMS', 'AMS_API_CANNOT_DELETE');

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

1601: -- master_source_type_flag
1602: 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
1603: IF AMS_Utility_PVT.is_Y_or_N (p_listsrctype_rec.master_source_type_flag) = FND_API.g_false THEN
1604: IF FND_MSG_PUB.check_msg_level (FND_MSG_PUB.g_msg_lvl_error) THEN
1605: FND_MESSAGE.set_name ('AMS', 'AMS_LIST_BAD_MASTERSRC_FLAG');
1606: FND_MSG_PUB.add;
1607: END IF;
1608:
1609: x_return_status := FND_API.g_ret_sts_error;

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

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