DBA Data[Home] [Help]

APPS.AMS_THLDACT_PVT dependencies on FND_MESSAGE

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

450: -- Error, check the msg level and added an error message to the
451: -- API message list
452: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
453: THEN -- MMSG
454: FND_MESSAGE.set_name('AMS', 'AMS_API_RECORD_NOT_FOUND');
455: FND_MSG_PUB.Add;
456: END IF;
457:
458: RAISE FND_API.G_EXC_ERROR;

Line 613: FND_MESSAGE.Set_Name('FND', 'AMS_API_RECORD_NOT_FOUND');

609: -- Error, check the msg level and added an error message to the
610: -- API message list
611: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
612: THEN -- MMSG
613: FND_MESSAGE.Set_Name('FND', 'AMS_API_RECORD_NOT_FOUND');
614: FND_MSG_PUB.Add;
615: END IF;
616:
617: RAISE FND_API.G_EXC_ERROR;

Line 664: FND_MESSAGE.SET_NAME('AMS','AMS_API_RESOURCE_LOCKED');

660: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
661:
662: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
663: THEN -- MMSG
664: FND_MESSAGE.SET_NAME('AMS','AMS_API_RESOURCE_LOCKED');
665: FND_MSG_PUB.Add;
666: END IF;
667:
668: FND_MSG_PUB.Count_AND_Get

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

840: -- API message list
841: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
842: THEN -- MMSG
843:
844: FND_MESSAGE.set_name('AMS', 'AMS_API_RECORD_NOT_FOUND');
845: FND_MSG_PUB.Add;
846: END IF;
847:
848: RAISE FND_API.G_EXC_ERROR;

Line 1122: FND_MESSAGE.Set_Name('AMS', 'AMS_TRIG_MISSING_TRIG_ID');

1118: -- missing required field
1119: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
1120: THEN -- MMSG
1121: --dbms_output.put_line('trigger_id is missing');
1122: FND_MESSAGE.Set_Name('AMS', 'AMS_TRIG_MISSING_TRIG_ID');
1123: FND_MSG_PUB.Add;
1124: END IF;
1125: x_return_status := FND_API.G_RET_STS_ERROR;
1126: -- If any errors happen abort API/Procedure.

Line 1177: FND_MESSAGE.set_name('AMS', 'AMS_TRIG_DUPLICATE_ACTION');

1173: ) = FND_API.g_false
1174: THEN
1175: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)
1176: THEN
1177: FND_MESSAGE.set_name('AMS', 'AMS_TRIG_DUPLICATE_ACTION');
1178: FND_MSG_PUB.add;
1179: END IF;
1180: x_return_status := FND_API.g_ret_sts_error;
1181: RETURN;

Line 1207: FND_MESSAGE.set_name('AMS', 'AMS_TRIG_DUP_TRIG_ID');

1203: ) = FND_API.g_false
1204: THEN
1205: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)
1206: THEN
1207: FND_MESSAGE.set_name('AMS', 'AMS_TRIG_DUP_TRIG_ID');
1208: FND_MSG_PUB.add;
1209: END IF;
1210: x_return_status := FND_API.g_ret_sts_error;
1211: RETURN;

Line 1274: FND_MESSAGE.Set_Name('AMS', 'AMS_TRIG_INVALID_TRIGGER_ID');

1270: -- invalid item
1271: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
1272: THEN -- MMSG
1273: -- DBMS_OUTPUT.Put_Line('Foreign Key Does not Exist');
1274: FND_MESSAGE.Set_Name('AMS', 'AMS_TRIG_INVALID_TRIGGER_ID');
1275: FND_MSG_PUB.Add;
1276: END IF;
1277: x_return_status := FND_API.G_RET_STS_ERROR;
1278: -- If any errors happen abort API/Procedure.

Line 1315: FND_MESSAGE.Set_Name('AMS', 'AMS_TRIG_INVALID_LIST');

1311: -- invalid item
1312: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
1313: THEN -- MMSG
1314: -- DBMS_OUTPUT.Put_Line('Foreign Key Does not Exist');
1315: FND_MESSAGE.Set_Name('AMS', 'AMS_TRIG_INVALID_LIST');
1316: FND_MSG_PUB.Add;
1317: END IF;
1318: x_return_status := FND_API.G_RET_STS_ERROR;
1319: -- If any errors happen abort API/Procedure.

Line 1354: FND_MESSAGE.Set_Name('AMS', 'AMS_TRIG_INVALID_APPROVER');

1350: -- invalid item
1351: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
1352: THEN -- MMSG
1353: -- DBMS_OUTPUT.Put_Line('Foreign Key Does not Exist');
1354: FND_MESSAGE.Set_Name('AMS', 'AMS_TRIG_INVALID_APPROVER');
1355: FND_MSG_PUB.Add;
1356: END IF;
1357: x_return_status := FND_API.G_RET_STS_ERROR;
1358: -- If any errors happen abort API/Procedure.

Line 1387: FND_MESSAGE.Set_Name('AMS', 'AMS_TRIG_INVALID_DSCRIPT');

1383: -- invalid item
1384: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
1385: THEN -- MMSG
1386: -- DBMS_OUTPUT.Put_Line('Foreign Key Does not Exist');
1387: FND_MESSAGE.Set_Name('AMS', 'AMS_TRIG_INVALID_DSCRIPT');
1388: FND_MSG_PUB.Add;
1389: END IF;
1390: x_return_status := FND_API.G_RET_STS_ERROR;
1391: -- If any errors happen abort API/Procedure.

Line 1420: FND_MESSAGE.Set_Name('AMS', 'AMS_TRIG_INVALID_OFFER');

1416: -- invalid item
1417: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
1418: THEN -- MMSG
1419: -- DBMS_OUTPUT.Put_Line('Foreign Key Does not Exist');
1420: FND_MESSAGE.Set_Name('AMS', 'AMS_TRIG_INVALID_OFFER');
1421: FND_MSG_PUB.Add;
1422: END IF;
1423: x_return_status := FND_API.G_RET_STS_ERROR;
1424: -- If any errors happen abort API/Procedure.

Line 1456: FND_MESSAGE.Set_Name ('AMS', 'AMS_TRIG_INVALID_COVER_LETTER');

1452: ,p_additional_where_clause => l_additional_where_clause
1453: ) = FND_API.G_FALSE
1454: THEN
1455: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
1456: FND_MESSAGE.Set_Name ('AMS', 'AMS_TRIG_INVALID_COVER_LETTER');
1457: FND_MSG_PUB.Add;
1458: END IF;
1459: x_return_status := FND_API.G_RET_STS_ERROR;
1460: RETURN;

Line 1512: FND_MESSAGE.Set_Name('AMS', 'AMS_TRIG_INVALID_ACTION_TYPE');

1508: -- invalid item
1509: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
1510: THEN -- MMSG
1511: -- DBMS_OUTPUT.Put_Line('Check1 Type is invalid');
1512: FND_MESSAGE.Set_Name('AMS', 'AMS_TRIG_INVALID_ACTION_TYPE');
1513: FND_MSG_PUB.Add;
1514: END IF;
1515: x_return_status := FND_API.G_RET_STS_ERROR;
1516: -- If any errors happen abort API/Procedure.

Line 1559: FND_MESSAGE.set_name('AMS', 'AMS_TRIG_BAD_NOTIFY_FLAG');

1555: IF AMS_Utility_PVT.is_Y_or_N(p_thldact_rec.notify_flag) = FND_API.g_false
1556: THEN
1557: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)
1558: THEN
1559: FND_MESSAGE.set_name('AMS', 'AMS_TRIG_BAD_NOTIFY_FLAG');
1560: FND_MSG_PUB.add;
1561: END IF;
1562:
1563: x_return_status := FND_API.g_ret_sts_error;

Line 1579: FND_MESSAGE.set_name('AMS', 'AMS_TRIG_BAD_GEN_LIST_FLAG');

1575: IF AMS_Utility_PVT.is_Y_or_N(p_thldact_rec.generate_list_flag) = FND_API.g_false
1576: THEN
1577: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)
1578: THEN
1579: FND_MESSAGE.set_name('AMS', 'AMS_TRIG_BAD_GEN_LIST_FLAG');
1580: FND_MSG_PUB.add;
1581: END IF;
1582:
1583: x_return_status := FND_API.g_ret_sts_error;

Line 1599: FND_MESSAGE.set_name('AMS', 'AMS_TRIG_BAD_APPR_FLAG');

1595: IF AMS_Utility_PVT.is_Y_or_N(p_thldact_rec.action_need_approval_flag) = FND_API.g_false
1596: THEN
1597: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)
1598: THEN
1599: FND_MESSAGE.set_name('AMS', 'AMS_TRIG_BAD_APPR_FLAG');
1600: FND_MSG_PUB.add;
1601: END IF;
1602:
1603: x_return_status := FND_API.g_ret_sts_error;

Line 1754: FND_MESSAGE.Set_Name('AMS', 'AMS_TRIG_MISSING_LIST');

1750: -- missing required field
1751: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
1752: THEN -- MMSG
1753: --dbms_output.put_line('list_use_this_source_code is missing');
1754: FND_MESSAGE.Set_Name('AMS', 'AMS_TRIG_MISSING_LIST');
1755: FND_MSG_PUB.Add;
1756: END IF;
1757: x_return_status := FND_API.G_RET_STS_ERROR;
1758: -- If any errors happen abort API/Procedure.

Line 1798: FND_MESSAGE.Set_Name ('AMS', 'AMS_TRIG_INVALID_DELV_ID');

1794: ,p_additional_where_clause => l_additional_where_clause
1795: ) = FND_API.G_FALSE
1796: THEN
1797: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
1798: FND_MESSAGE.Set_Name ('AMS', 'AMS_TRIG_INVALID_DELV_ID');
1799: FND_MSG_PUB.Add;
1800: END IF;
1801:
1802: x_return_status := FND_API.G_RET_STS_ERROR;

Line 1828: FND_MESSAGE.Set_Name('AMS', 'AMS_TRIG_MISSING_COVER_LETTER');

1824: -- missing required field
1825: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
1826: THEN -- MMSG
1827: --dbms_output.put_line('list_use_this_source_code is missing');
1828: FND_MESSAGE.Set_Name('AMS', 'AMS_TRIG_MISSING_COVER_LETTER');
1829: FND_MSG_PUB.Add;
1830: END IF;
1831: x_return_status := FND_API.G_RET_STS_ERROR;
1832: -- If any errors happen abort API/Procedure.

Line 1844: FND_MESSAGE.Set_Name('AMS', 'AMS_TRIG_MISSING_NOTIFY_USER');

1840: /*
1841: IF ((p_thldact_rec.ACTION_NOTIF_USER_ID IS NULL) OR (p_thldact_rec.ACTION_NOTIF_USER_ID = FND_API.G_MISS_NUM)) THEN
1842: IF p_thldact_rec.notify_flag = 'Y' THEN
1843: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
1844: FND_MESSAGE.Set_Name('AMS', 'AMS_TRIG_MISSING_NOTIFY_USER');
1845: FND_MSG_PUB.Add;
1846: END IF;
1847: x_return_status := FND_API.G_RET_STS_ERROR;
1848: END IF;

Line 1856: FND_MESSAGE.Set_Name('AMS', 'AMS_TRIG_MISSING_NOTIFY_USER');

1852: IF p_thldact_rec.execute_action_type = 'NOTIFY'
1853: AND ((p_thldact_rec.action_for_id IS NULL) OR (p_thldact_rec.action_for_id = FND_API.G_MISS_NUM))
1854: THEN
1855: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
1856: FND_MESSAGE.Set_Name('AMS', 'AMS_TRIG_MISSING_NOTIFY_USER');
1857: FND_MSG_PUB.Add;
1858: END IF;
1859: x_return_status := FND_API.G_RET_STS_ERROR;
1860: END IF;

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

1953: FETCH c_thldact INTO l_thldact_rec;
1954: IF c_thldact%NOTFOUND THEN
1955: CLOSE c_thldact;
1956: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
1957: FND_MESSAGE.set_name('AMS', 'AMS_API_RECORD_NOT_FOUND');
1958: FND_MSG_PUB.add;
1959: END IF;
1960: RAISE FND_API.g_exc_error;
1961: END IF;