DBA Data[Home] [Help]

APPS.AMS_AGENDAS_PVT dependencies on FND_MESSAGE

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

853: API message list
854: */
855: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
856: THEN -- MMSG
857: FND_MESSAGE.set_name('AMS', 'AMS_API_RECORD_NOT_FOUND');
858: FND_MSG_PUB.Add;
859: END IF;
860: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
861: END IF;

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

871: AND USERENV('LANG') IN (language, source_lang);
872:
873: IF (SQL%NOTFOUND) THEN
874: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
875: FND_MESSAGE.set_name('AMS', 'AMS_API_RECORD_NOT_FOUND');
876: FND_MSG_PUB.add;
877: END IF;
878: RAISE FND_API.g_exc_error;
879: END IF;

Line 1044: Fnd_Message.set_name('AMS', 'AMS_NO_SESSION');

1040: IF(l_count > 0)
1041: THEN
1042: IF Fnd_Msg_Pub.check_msg_level(Fnd_Msg_Pub.G_MSG_LVL_ERROR)
1043: THEN
1044: Fnd_Message.set_name('AMS', 'AMS_NO_SESSION');
1045: Fnd_Msg_Pub.ADD;
1046: END IF;
1047: RAISE FND_API.g_exc_error;
1048: END IF;

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

1141:
1142: IF (SQL%NOTFOUND) THEN
1143: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)
1144: THEN
1145: FND_MESSAGE.set_name('AMS', 'AMS_API_RECORD_NOT_FOUND');
1146: FND_MSG_PUB.add;
1147: END IF;
1148: RAISE FND_API.g_exc_error;
1149: END IF;

Line 1289: FND_MESSAGE.Set_Name('AMS', 'AMS_API_RECORD_NOT_FOUND');

1285: API message list
1286: */
1287: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
1288: THEN -- MMSG
1289: FND_MESSAGE.Set_Name('AMS', 'AMS_API_RECORD_NOT_FOUND');
1290: FND_MSG_PUB.Add;
1291: END IF;
1292: RAISE FND_API.G_EXC_ERROR;
1293: END IF;

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

1318:
1319: /* WHEN AMS_Utility_PVT.agenda_locked THEN
1320: x_return_status := FND_API.g_ret_sts_error;
1321: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
1322: FND_MESSAGE.set_name('AMS', 'AMS_API_RESOURCE_LOCKED');
1323: FND_MSG_PUB.add;
1324: END IF; */
1325:
1326: FND_MSG_PUB.Count_AND_Get

Line 1499: FND_MESSAGE.set_name('AMS', 'AMS_API_NO_APPLICATION_ID');

1495:
1496: ------------------------ application_id --------------------------
1497: IF (p_agenda_rec.application_id IS NULL OR p_agenda_rec.application_id = FND_API.g_miss_num) THEN
1498: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
1499: FND_MESSAGE.set_name('AMS', 'AMS_API_NO_APPLICATION_ID');
1500: FND_MSG_PUB.add;
1501: END IF;
1502: x_return_status := FND_API.g_ret_sts_error;
1503: RETURN;

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

1506: IF (p_agenda_rec.parent_id IS NULL OR p_agenda_rec.parent_id = FND_API.g_miss_num) THEN
1507: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
1508: IF (p_agenda_rec.agenda_type = 'TRACK')
1509: THEN
1510: FND_MESSAGE.set_name('AMS', 'AMS_EVO_NO_PARENT_OFFER_ID');
1511: -- ELSIF(p_agenda_rec.agenda_type = 'SESSION')
1512: -- FND_MESSAGE.set_name('AMS', 'AMS_NO_TRACK_ID');
1513: END IF;
1514: FND_MSG_PUB.add;

Line 1512: -- FND_MESSAGE.set_name('AMS', 'AMS_NO_TRACK_ID');

1508: IF (p_agenda_rec.agenda_type = 'TRACK')
1509: THEN
1510: FND_MESSAGE.set_name('AMS', 'AMS_EVO_NO_PARENT_OFFER_ID');
1511: -- ELSIF(p_agenda_rec.agenda_type = 'SESSION')
1512: -- FND_MESSAGE.set_name('AMS', 'AMS_NO_TRACK_ID');
1513: END IF;
1514: FND_MSG_PUB.add;
1515: END IF;
1516: x_return_status := FND_API.g_ret_sts_error;

Line 1525: FND_MESSAGE.set_name('AMS', 'AMS_EVO_NO_PARENT_OFFER_TYPE');

1521: IF (p_agenda_rec.parent_type IS NULL OR p_agenda_rec.parent_type = FND_API.g_miss_char) THEN
1522: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
1523: IF (p_agenda_rec.agenda_type = 'TRACK')
1524: THEN
1525: FND_MESSAGE.set_name('AMS', 'AMS_EVO_NO_PARENT_OFFER_TYPE');
1526: ELSIF(p_agenda_rec.agenda_type = 'SESSION')THEN
1527: FND_MESSAGE.set_name('AMS', 'AMS_NO_TRACK_TYPE');
1528: END IF;
1529: FND_MSG_PUB.add;

Line 1527: FND_MESSAGE.set_name('AMS', 'AMS_NO_TRACK_TYPE');

1523: IF (p_agenda_rec.agenda_type = 'TRACK')
1524: THEN
1525: FND_MESSAGE.set_name('AMS', 'AMS_EVO_NO_PARENT_OFFER_TYPE');
1526: ELSIF(p_agenda_rec.agenda_type = 'SESSION')THEN
1527: FND_MESSAGE.set_name('AMS', 'AMS_NO_TRACK_TYPE');
1528: END IF;
1529: FND_MSG_PUB.add;
1530: END IF;
1531: x_return_status := FND_API.g_ret_sts_error;

Line 1538: FND_MESSAGE.set_name('AMS', 'AMS_NO_AGENDA_TYPE');

1534:
1535: ------------------------ agenda_type--------------------------
1536: IF (p_agenda_rec.agenda_type IS NULL OR p_agenda_rec.agenda_type = FND_API.g_miss_char) THEN
1537: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
1538: FND_MESSAGE.set_name('AMS', 'AMS_NO_AGENDA_TYPE');
1539: FND_MSG_PUB.add;
1540: END IF;
1541: x_return_status := FND_API.g_ret_sts_error;
1542: RETURN;

Line 1586: FND_MESSAGE.set_name('AMS', 'AMS_EVO_DUPLICATE_ID');

1582: 'agenda_id = ' || p_agenda_rec.agenda_id
1583: ) = FND_API.g_false
1584: THEN
1585: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
1586: FND_MESSAGE.set_name('AMS', 'AMS_EVO_DUPLICATE_ID');
1587: FND_MSG_PUB.add;
1588: END IF;
1589: x_return_status := FND_API.g_ret_sts_error;
1590: RETURN;

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

1601: fetch c_track_name into l_dummy;
1602: close c_track_name;
1603: IF l_dummy = 1 THEN
1604: IF FND_MSG_PUB.check_msg_level (FND_MSG_PUB.g_msg_lvl_error) THEN
1605: FND_MESSAGE.set_name ('AMS', 'AMS_DUP_NAME');
1606: FND_MSG_PUB.add;
1607: END IF;
1608: x_return_status := FND_API.g_ret_sts_error;
1609: RETURN;

Line 1648: FND_MESSAGE.set_name('AMS', 'AMS_EVO_BAD_APP_ID');

1644: ) = FND_API.g_false
1645: THEN
1646: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)
1647: THEN
1648: FND_MESSAGE.set_name('AMS', 'AMS_EVO_BAD_APP_ID');
1649: FND_MSG_PUB.add;
1650: END IF;
1651: x_return_status := FND_API.g_ret_sts_error;
1652: RETURN;

Line 1670: FND_MESSAGE.set_name('AMS', 'AMS_EVO_BAD_PARENT_OFFER');

1666: ) = FND_API.g_false
1667: THEN
1668: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)
1669: THEN
1670: FND_MESSAGE.set_name('AMS', 'AMS_EVO_BAD_PARENT_OFFER');
1671: FND_MSG_PUB.add;
1672: END IF;
1673: x_return_status := FND_API.g_ret_sts_error;
1674: RETURN;

Line 1689: FND_MESSAGE.set_name('AMS', 'AMS_EVO_BAD_PARENT_OFFER');

1685: ) = FND_API.g_false
1686: THEN
1687: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)
1688: THEN
1689: FND_MESSAGE.set_name('AMS', 'AMS_EVO_BAD_PARENT_OFFER');
1690: FND_MSG_PUB.add;
1691: END IF;
1692: x_return_status := FND_API.g_ret_sts_error;
1693: RETURN;

Line 1710: FND_MESSAGE.set_name('AMS', 'AMS_EVO_BAD_TIMEZONE_ID');

1706: ) = FND_API.g_false
1707: THEN
1708: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)
1709: THEN
1710: FND_MESSAGE.set_name('AMS', 'AMS_EVO_BAD_TIMEZONE_ID');
1711: FND_MSG_PUB.add;
1712: END IF;
1713: x_return_status := FND_API.g_ret_sts_error;
1714: RETURN;

Line 1729: FND_MESSAGE.set_name('AMS', 'AMS_EVO_BAD_VENUE_ID');

1725: ) = FND_API.g_false
1726: THEN
1727: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)
1728: THEN
1729: FND_MESSAGE.set_name('AMS', 'AMS_EVO_BAD_VENUE_ID');
1730: FND_MSG_PUB.add;
1731: END IF;
1732: x_return_status := FND_API.g_ret_sts_error;
1733: RETURN;

Line 1751: FND_MESSAGE.set_name('AMS', 'AMS_ACT_RSC_BAD_RESOURCE');

1747: ) = FND_API.G_FALSE
1748: THEN
1749: IF FND_MSG_PUB.check_msg_level (FND_MSG_PUB.G_MSG_LVL_ERROR)
1750: THEN
1751: FND_MESSAGE.set_name('AMS', 'AMS_ACT_RSC_BAD_RESOURCE');
1752: FND_MSG_PUB.add;
1753: END IF;
1754: x_return_status := FND_API.G_RET_STS_ERROR;
1755: -- If any errors happen abort API/Procedure.

Line 1790: FND_MESSAGE.set_name('AMS', 'AMS_EVO_BAD_TYPE');

1786: ) = FND_API.g_false
1787: THEN
1788: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)
1789: THEN
1790: FND_MESSAGE.set_name('AMS', 'AMS_EVO_BAD_TYPE');
1791: FND_MSG_PUB.add;
1792: END IF;
1793: x_return_status := FND_API.g_ret_sts_error;
1794: RETURN;

Line 1826: FND_MESSAGE.set_name('AMS', 'AMS_EVO_BAD_ACTIVE_FLAG');

1822: IF AMS_Utility_PVT.is_Y_or_N(p_agenda_rec.active_flag) = FND_API.g_false
1823: THEN
1824: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)
1825: THEN
1826: FND_MESSAGE.set_name('AMS', 'AMS_EVO_BAD_ACTIVE_FLAG');
1827: FND_MSG_PUB.add;
1828: END IF;
1829: x_return_status := FND_API.g_ret_sts_error;
1830: RETURN;

Line 1842: FND_MESSAGE.set_name('AMS', 'AMS_EVO_BAD_TRACK_FLAG');

1838: IF AMS_Utility_PVT.is_Y_or_N(p_agenda_rec.default_track_flag) = FND_API.g_false
1839: THEN
1840: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)
1841: THEN
1842: FND_MESSAGE.set_name('AMS', 'AMS_EVO_BAD_TRACK_FLAG');
1843: FND_MSG_PUB.add;
1844: END IF;
1845: x_return_status := FND_API.g_ret_sts_error;
1846: RETURN;

Line 1956: Fnd_Message.set_name('AMS', 'AMS_EVT_RES_DATE_NOT_FIT_IN');

1952: OR p_agenda_rec.END_DATE_TIME < l_end_date)
1953: THEN
1954: IF Fnd_Msg_Pub.check_msg_level(Fnd_Msg_Pub.G_MSG_LVL_ERROR)
1955: THEN
1956: Fnd_Message.set_name('AMS', 'AMS_EVT_RES_DATE_NOT_FIT_IN');
1957: Fnd_Msg_Pub.ADD;
1958: END IF;
1959: RAISE FND_API.g_exc_error;
1960: END IF;

Line 2053: Fnd_Message.set_name('AMS', 'AMS_NO_SESSION');

2049: IF Fnd_Msg_Pub.check_msg_level(Fnd_Msg_Pub.G_MSG_LVL_ERROR)
2050: THEN
2051: IF p_agenda_rec.agenda_type = 'SESSION'
2052: THEN
2053: Fnd_Message.set_name('AMS', 'AMS_NO_SESSION');
2054: Fnd_Msg_Pub.ADD;
2055: ELSIF p_agenda_rec.agenda_type = 'TRACK'
2056: THEN
2057: Fnd_Message.set_name('AMS', 'AMS_NO_TRACK');

Line 2057: Fnd_Message.set_name('AMS', 'AMS_NO_TRACK');

2053: Fnd_Message.set_name('AMS', 'AMS_NO_SESSION');
2054: Fnd_Msg_Pub.ADD;
2055: ELSIF p_agenda_rec.agenda_type = 'TRACK'
2056: THEN
2057: Fnd_Message.set_name('AMS', 'AMS_NO_TRACK');
2058: Fnd_Msg_Pub.ADD;
2059: END IF;
2060: END IF;
2061: RAISE FND_API.g_exc_error;

Line 2073: Fnd_Message.set_name('AMS', 'AMS_NO_SESSION');

2069: IF(l_count > 0)
2070: THEN
2071: IF Fnd_Msg_Pub.check_msg_level(Fnd_Msg_Pub.G_MSG_LVL_ERROR)
2072: THEN
2073: Fnd_Message.set_name('AMS', 'AMS_NO_SESSION');
2074: Fnd_Msg_Pub.ADD;
2075: END IF;
2076: RAISE FND_API.g_exc_error;
2077: END IF;

Line 2088: Fnd_Message.set_name('AMS', 'AMS_EDTIME_LS_STTIME');

2084: THEN
2085: -- IF (AMS_DEBUG_HIGH_ON) THEN Ams_Utility_Pvt.debug_message('The End time is lesser than Start time'); END IF;
2086: IF Fnd_Msg_Pub.check_msg_level(Fnd_Msg_Pub.G_MSG_LVL_ERROR)
2087: THEN
2088: Fnd_Message.set_name('AMS', 'AMS_EDTIME_LS_STTIME');
2089: Fnd_Msg_Pub.ADD;
2090: END IF;
2091: RAISE FND_API.g_exc_error;
2092: END IF; -- (p_agenda_rec.start_date_time > p_agenda_rec.end_date_time)

Line 2206: Fnd_Message.set_name('AMS', 'AMS_SESSION_LS_EVENT_DATE');

2202: Ams_Utility_Pvt.debug_message('Came to check with event dates');
2203: END IF;
2204: IF Fnd_Msg_Pub.check_msg_level(Fnd_Msg_Pub.G_MSG_LVL_ERROR)
2205: THEN
2206: Fnd_Message.set_name('AMS', 'AMS_SESSION_LS_EVENT_DATE');
2207: Fnd_Msg_Pub.ADD;
2208: END IF;
2209: RAISE FND_API.g_exc_error;
2210: END IF; -- end of start_date_time < l_event_start_date_time

Line 2222: Fnd_Message.set_name('AMS', 'AMS_SESSION_LS_EVENT_TIME');

2218: Ams_Utility_Pvt.debug_message('Came to check with event start time');
2219: END IF;
2220: IF Fnd_Msg_Pub.check_msg_level(Fnd_Msg_Pub.G_MSG_LVL_ERROR)
2221: THEN
2222: Fnd_Message.set_name('AMS', 'AMS_SESSION_LS_EVENT_TIME');
2223: Fnd_Msg_Pub.ADD;
2224: END IF;
2225: RAISE FND_API.g_exc_error;
2226: END IF; --IF( to_date(to_char(p_agenda_rec.start_date_time,'HH24:MI'))

Line 2239: Fnd_Message.set_name('AMS', 'AMS_SESSION_GT_EVENT_TIME');

2235: Ams_Utility_Pvt.debug_message('Came to check with event end time');
2236: END IF;
2237: IF Fnd_Msg_Pub.check_msg_level(Fnd_Msg_Pub.G_MSG_LVL_ERROR)
2238: THEN
2239: Fnd_Message.set_name('AMS', 'AMS_SESSION_GT_EVENT_TIME');
2240: Fnd_Msg_Pub.ADD;
2241: END IF;
2242: RAISE FND_API.g_exc_error;
2243: END IF; --IF( to_date(to_char(p_agenda_rec.start_date_time,'HH24:MI'))

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

2373: IF c_agenda%NOTFOUND THEN
2374: CLOSE c_agenda;
2375:
2376: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
2377: FND_MESSAGE.set_name('AMS', 'AMS_API_RECORD_NOT_FOUND');
2378: FND_MSG_PUB.add;
2379: END IF;
2380: RAISE FND_API.g_exc_error;
2381: END IF;