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_LIST_QUERY_PVT dependencies on FND_MESSAGE

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

1424:
1425: IF (c_List_Query%NOTFOUND) THEN
1426: CLOSE c_List_Query;
1427: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
1428: FND_MESSAGE.set_name('AMS', 'AMS_API_RECORD_NOT_FOUND');
1429: FND_MSG_PUB.add;
1430: END IF;
1431: RAISE FND_API.g_exc_error;
1432: END IF;

Line 1537: FND_MESSAGE.set_name('AMS', 'AMS_LIST_QUERY_DUPE_NAME');

1533:
1534: AMS_UTILITY_PVT.debug_message('parent id: ' || p_list_query_rec.parent_list_query_id );
1535:
1536: END IF;
1537: FND_MESSAGE.set_name('AMS', 'AMS_LIST_QUERY_DUPE_NAME');
1538: FND_MSG_PUB.add;
1539: END IF;
1540: x_return_status := FND_API.g_ret_sts_error;
1541: RETURN;

Line 1560: FND_MESSAGE.Set_Name('AMS', 'AMS_LIST_QUERY_NO_NAME');

1556:
1557: IF p_list_query_rec.name = FND_API.g_miss_char OR p_list_query_rec.name IS NULL THEN
1558: AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_list_query_NO_name');
1559: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
1560: FND_MESSAGE.Set_Name('AMS', 'AMS_LIST_QUERY_NO_NAME');
1561: FND_MSG_PUB.Add;
1562: END IF;
1563: x_return_status := FND_API.g_ret_sts_error;
1564: RETURN;

Line 1572: FND_MESSAGE.Set_Name('AMS', 'AMS_LIST_QUERY_NO_USEDBY_ID');

1568: /*
1569: IF p_list_query_rec.act_list_query_used_by_id = FND_API.g_miss_num OR p_list_query_rec.act_list_query_used_by_id IS NULL THEN
1570: AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_list_query_NO_act_list_query_used_by_id');
1571: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
1572: FND_MESSAGE.Set_Name('AMS', 'AMS_LIST_QUERY_NO_USEDBY_ID');
1573: FND_MSG_PUB.Add;
1574: END IF;
1575: x_return_status := FND_API.g_ret_sts_error;
1576: RETURN;

Line 1584: FND_MESSAGE.Set_Name('AMS', 'AMS_LIST_QUERY_NO_USEDBY');

1580:
1581: IF p_list_query_rec.arc_act_list_query_used_by = FND_API.g_miss_char OR p_list_query_rec.arc_act_list_query_used_by IS NULL THEN
1582: AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_list_query_NO_arc_act_list_query_used_by');
1583: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
1584: FND_MESSAGE.Set_Name('AMS', 'AMS_LIST_QUERY_NO_USEDBY');
1585: FND_MSG_PUB.Add;
1586: END IF;
1587: x_return_status := FND_API.g_ret_sts_error;
1588: RETURN;

Line 1594: FND_MESSAGE.Set_Name('AMS', 'AMS_LIST_QUERY_NO_SQLSTRING');

1590:
1591: */
1592: IF p_list_query_rec.sql_string = FND_API.g_miss_char OR p_list_query_rec.sql_string IS NULL THEN
1593: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
1594: FND_MESSAGE.Set_Name('AMS', 'AMS_LIST_QUERY_NO_SQLSTRING');
1595: FND_MSG_PUB.Add;
1596: END IF;
1597: x_return_status := FND_API.g_ret_sts_error;
1598: RETURN;

Line 1687: FND_MESSAGE.set_name('AMS', 'AMS_LIST_QRY_USEDBYID_INVALID');

1683:
1684: ELSE
1685: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
1686: THEN
1687: FND_MESSAGE.set_name('AMS', 'AMS_LIST_QRY_USEDBYID_INVALID');
1688: FND_MSG_PUB.Add;
1689: END IF;
1690: x_return_status := FND_API.G_RET_STS_ERROR;
1691: RAISE FND_API.G_EXC_ERROR;

Line 1715: FND_MESSAGE.set_name('AMS', 'AMS_LIST_QUERY_USEDBY_INVALID');

1711: ) = FND_API.g_false
1712: THEN
1713: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)
1714: THEN
1715: FND_MESSAGE.set_name('AMS', 'AMS_LIST_QUERY_USEDBY_INVALID');
1716: FND_MSG_PUB.add;
1717: END IF;
1718:
1719: x_return_status := FND_API.g_ret_sts_error;

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

1789: FETCH c_query INTO l_query_rec;
1790: IF c_query%NOTFOUND THEN
1791: CLOSE c_query;
1792: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
1793: FND_MESSAGE.set_name('AMS', 'AMS_API_RECORD_NOT_FOUND');
1794: FND_MSG_PUB.add;
1795: END IF;
1796: RAISE FND_API.g_exc_error;
1797: END IF;

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

2125: FETCH c_listquery INTO l_listquery_rec;
2126: IF c_listquery%NOTFOUND THEN
2127: CLOSE c_listquery;
2128: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
2129: FND_MESSAGE.set_name('AMS', 'AMS_API_RECORD_NOT_FOUND');
2130: FND_MSG_PUB.add;
2131: END IF;
2132: RAISE FND_API.g_exc_error;
2133: END IF;

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

2239: FETCH c_listquery INTO l_listquery_rec;
2240: IF c_listquery%NOTFOUND THEN
2241: CLOSE c_listquery;
2242: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
2243: FND_MESSAGE.set_name('AMS', 'AMS_API_RECORD_NOT_FOUND');
2244: FND_MSG_PUB.add;
2245: END IF;
2246: RAISE FND_API.g_exc_error;
2247: END IF;

Line 2413: FND_MESSAGE.set_name('AMS', 'AMS_API_DEBUG_MESSAGE');

2409: END IF;
2410:
2411: -- Debug Message
2412: IF (AMS_DEBUG_HIGH_ON) THEN
2413: FND_MESSAGE.set_name('AMS', 'AMS_API_DEBUG_MESSAGE');
2414: FND_MESSAGE.Set_Token('TEXT', 'AMS_List_Query_PVT.Copy_List_Queries: Start', TRUE);
2415: FND_MSG_PUB.Add;
2416: END IF;
2417:

Line 2414: FND_MESSAGE.Set_Token('TEXT', 'AMS_List_Query_PVT.Copy_List_Queries: Start', TRUE);

2410:
2411: -- Debug Message
2412: IF (AMS_DEBUG_HIGH_ON) THEN
2413: FND_MESSAGE.set_name('AMS', 'AMS_API_DEBUG_MESSAGE');
2414: FND_MESSAGE.Set_Token('TEXT', 'AMS_List_Query_PVT.Copy_List_Queries: Start', TRUE);
2415: FND_MSG_PUB.Add;
2416: END IF;
2417:
2418: -- Initialize API return status to success

Line 2519: FND_MESSAGE.Set_Name('AMS', 'API_SUCCESS');

2515:
2516: -- Success Message
2517: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_SUCCESS)
2518: THEN
2519: FND_MESSAGE.Set_Name('AMS', 'API_SUCCESS');
2520: FND_MESSAGE.Set_Token('ROW', 'AMS_List_Query_PVT.Copy_List_Queries', TRUE);
2521: FND_MSG_PUB.Add;
2522: END IF;
2523:

Line 2520: FND_MESSAGE.Set_Token('ROW', 'AMS_List_Query_PVT.Copy_List_Queries', TRUE);

2516: -- Success Message
2517: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_SUCCESS)
2518: THEN
2519: FND_MESSAGE.Set_Name('AMS', 'API_SUCCESS');
2520: FND_MESSAGE.Set_Token('ROW', 'AMS_List_Query_PVT.Copy_List_Queries', TRUE);
2521: FND_MSG_PUB.Add;
2522: END IF;
2523:
2524: IF (AMS_DEBUG_HIGH_ON) THEN

Line 2525: FND_MESSAGE.set_name('AMS', 'AMS_API_DEBUG_MESSAGE');

2521: FND_MSG_PUB.Add;
2522: END IF;
2523:
2524: IF (AMS_DEBUG_HIGH_ON) THEN
2525: FND_MESSAGE.set_name('AMS', 'AMS_API_DEBUG_MESSAGE');
2526: FND_MESSAGE.Set_Token('TEXT', 'AMS_List_Query_PVT.Copy_List_Queries: END', TRUE);
2527: FND_MSG_PUB.Add;
2528: END IF;
2529:

Line 2526: FND_MESSAGE.Set_Token('TEXT', 'AMS_List_Query_PVT.Copy_List_Queries: END', TRUE);

2522: END IF;
2523:
2524: IF (AMS_DEBUG_HIGH_ON) THEN
2525: FND_MESSAGE.set_name('AMS', 'AMS_API_DEBUG_MESSAGE');
2526: FND_MESSAGE.Set_Token('TEXT', 'AMS_List_Query_PVT.Copy_List_Queries: END', TRUE);
2527: FND_MSG_PUB.Add;
2528: END IF;
2529:
2530:

Line 2561: FND_MESSAGE.set_name('AMS','SQL ERROR ->' || sqlerrm );

2557: );
2558:
2559: WHEN OTHERS THEN
2560: ROLLBACK TO Copy_List_Queries_PVT;
2561: FND_MESSAGE.set_name('AMS','SQL ERROR ->' || sqlerrm );
2562: FND_MSG_PUB.Add;
2563: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2564: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
2565: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);