DBA Data[Home] [Help]

APPS.AMS_CATEGORY_PVT dependencies on FND_MESSAGE

Line 194: FND_MESSAGE.set_name('AMS', 'AMS_INVALID_CAT_LEVEL');

190: CLOSE c_findParentofParent;
191:
192: if ( l_parent_id IS NOT NULL ) then
193: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
194: FND_MESSAGE.set_name('AMS', 'AMS_INVALID_CAT_LEVEL');
195: FND_MSG_PUB.add;
196: END IF;
197: RAISE FND_API.g_exc_error;
198: end if;

Line 472: FND_MESSAGE.set_name('AMS', 'AMS_INVALID_CAT_LEVEL');

468: CLOSE c_findParentofParent;
469:
470: if ( l_parent_id IS NOT NULL ) then
471: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
472: FND_MESSAGE.set_name('AMS', 'AMS_INVALID_CAT_LEVEL');
473: FND_MSG_PUB.add;
474: END IF;
475: RAISE FND_API.g_exc_error;
476: end if;

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

499: CATEGORY_ID = l_category_rec.category_id;
500:
501: IF (SQL%NOTFOUND) THEN
502: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
503: FND_MESSAGE.set_name('AMS', 'AMS_API_RECORD_NOT_FOUND');
504: FND_MSG_PUB.add;
505: END IF;
506: RAISE FND_API.g_exc_error;
507: END IF;

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

517: AND userenv('LANG') in (LANGUAGE, SOURCE_LANG);
518:
519: IF (SQL%NOTFOUND) THEN
520: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
521: FND_MESSAGE.set_name('AMS', 'AMS_API_RECORD_NOT_FOUND');
522: FND_MSG_PUB.add;
523: END IF;
524: RAISE FND_API.g_exc_error;
525: END IF;

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

559: CATEGORY_ID = l_category_rec.category_id;
560:
561: IF (SQL%NOTFOUND) THEN
562: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
563: FND_MESSAGE.set_name('AMS', 'AMS_API_RECORD_NOT_FOUND');
564: FND_MSG_PUB.add;
565: END IF;
566: RAISE FND_API.g_exc_error;
567: END IF;

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

579: AND userenv('LANG') in (LANGUAGE, SOURCE_LANG);
580:
581: IF (SQL%NOTFOUND) THEN
582: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
583: FND_MESSAGE.set_name('AMS', 'AMS_API_RECORD_NOT_FOUND');
584: FND_MSG_PUB.add;
585: END IF;
586: RAISE FND_API.g_exc_error;
587: END IF;

Line 748: FND_MESSAGE.set_name('AMS', 'AMS_CAT_CANNOT_MOD_SEED');

744: -- user cannot modify or delete seeded category
745: IF (l_category_id < 10000 ) THEN
746: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)
747: THEN
748: FND_MESSAGE.set_name('AMS', 'AMS_CAT_CANNOT_MOD_SEED');
749: FND_MSG_PUB.add;
750: END IF;
751: RAISE FND_API.g_exc_error;
752: END IF;

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

757:
758: IF (SQL%NOTFOUND) THEN
759: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)
760: THEN
761: FND_MESSAGE.set_name('AMS', 'AMS_API_RECORD_NOT_FOUND');
762: FND_MSG_PUB.add;
763: END IF;
764: RAISE FND_API.g_exc_error;
765: END IF;

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

771:
772: IF (SQL%NOTFOUND) THEN
773: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)
774: THEN
775: FND_MESSAGE.set_name('AMS', 'AMS_API_RECORD_NOT_FOUND');
776: FND_MSG_PUB.add;
777: END IF;
778: RAISE FND_API.g_exc_error;
779: END IF;

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

928: CLOSE C_ams_categories_b;
929: -- Error, check the msg level and added an error message to the
930: -- API message list
931: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
932: FND_MESSAGE.set_name('AMS', 'AMS_API_RECORD_NOT_FOUND');
933: FND_MSG_PUB.add;
934: END IF;
935:
936: RAISE FND_API.G_EXC_ERROR;

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

979: x_return_status := FND_API.G_RET_STS_ERROR ;
980:
981: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
982: THEN -- MMSG
983: FND_MESSAGE.SET_NAME('AMS','AMS_API_RESOURCE_LOCKED');
984: FND_MSG_PUB.Add;
985: END IF;
986:
987: FND_MSG_PUB.Count_AND_Get

Line 1286: FND_MESSAGE.set_name('AMS', 'AMS_CAT_BAD_PARENT_CAT_ID');

1282: ) = FND_API.G_FALSE
1283: THEN
1284: IF FND_MSG_PUB.check_msg_level (FND_MSG_PUB.G_MSG_LVL_ERROR)
1285: THEN
1286: FND_MESSAGE.set_name('AMS', 'AMS_CAT_BAD_PARENT_CAT_ID');
1287: FND_MSG_PUB.add;
1288: END IF;
1289: x_return_status := FND_API.G_RET_STS_ERROR;
1290: -- If any errors happen abort API/Procedure.

Line 1307: FND_MESSAGE.set_name('AMS', 'AMS_CAT_BAD_ENABLED_FLAG');

1303: IF AMS_Utility_PVT.is_Y_or_N(p_category_rec.enabled_flag) = FND_API.g_false
1304: THEN
1305: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)
1306: THEN
1307: FND_MESSAGE.set_name('AMS', 'AMS_CAT_BAD_ENABLED_FLAG');
1308: FND_MSG_PUB.add;
1309: END IF;
1310: x_return_status := FND_API.g_ret_sts_error;
1311: RETURN;

Line 1435: FND_MESSAGE.Set_Name('AMS', 'AMS_CAT_CANT_DISABLE');

1431: THEN
1432: -- FK checking
1433: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
1434: THEN -- MMSG
1435: FND_MESSAGE.Set_Name('AMS', 'AMS_CAT_CANT_DISABLE');
1436: FND_MSG_PUB.Add;
1437: END IF;
1438: x_return_status := FND_API.g_ret_sts_error;
1439: RETURN;

Line 1460: FND_MESSAGE.Set_Name('AMS', 'AMS_CAT_CANT_DISABLE_PARENT');

1456: IF l_count > 0 THEN
1457:
1458: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
1459: THEN -- MMSG
1460: FND_MESSAGE.Set_Name('AMS', 'AMS_CAT_CANT_DISABLE_PARENT');
1461: FND_MSG_PUB.Add;
1462: END IF;
1463:
1464: x_return_status := FND_API.g_ret_sts_error;

Line 1476: FND_MESSAGE.Set_Name('AMS', 'AMS_INV_PARENT_CR_FOR');

1472: fetch get_parent_det into l_parent_cr_for;
1473:
1474: IF (l_parent_cr_for <> p_category_rec.ARC_CATEGORY_CREATED_FOR)
1475: THEN
1476: FND_MESSAGE.Set_Name('AMS', 'AMS_INV_PARENT_CR_FOR');
1477: FND_MSG_PUB.Add;
1478:
1479: x_return_status := FND_API.g_ret_sts_error;
1480: RETURN;

Line 1613: FND_MESSAGE.Set_Name('AMS', 'AMS_CAT_DUPLICATE_NAME');

1609:
1610: -- invalid item
1611: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
1612: THEN -- MMSG
1613: FND_MESSAGE.Set_Name('AMS', 'AMS_CAT_DUPLICATE_NAME');
1614: FND_MSG_PUB.Add;
1615: END IF;
1616: x_return_status := FND_API.G_RET_STS_ERROR;
1617: -- If any errors happen abort API/Procedure.

Line 1647: FND_MESSAGE.Set_Name('AMS', 'AMS_CAT_DUPLICATE_NAME');

1643:
1644: -- invalid item
1645: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
1646: THEN -- MMSG
1647: FND_MESSAGE.Set_Name('AMS', 'AMS_CAT_DUPLICATE_NAME');
1648: FND_MSG_PUB.Add;
1649: END IF;
1650: x_return_status := FND_API.G_RET_STS_ERROR;
1651: -- If any errors happen abort API/Procedure.

Line 1728: FND_MESSAGE.Set_Name('AMS', 'AMS_CAT_CANT_DEL_PARENT');

1724: THEN
1725: -- FK checking
1726: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
1727: THEN -- MMSG
1728: FND_MESSAGE.Set_Name('AMS', 'AMS_CAT_CANT_DEL_PARENT');
1729: FND_MSG_PUB.Add;
1730: END IF;
1731: x_return_status := FND_API.g_ret_sts_error;
1732: RETURN;

Line 1744: FND_MESSAGE.Set_Name('AMS', 'AMS_CAT_CANT_DEL_ACT');

1740: THEN
1741: -- FK checking
1742: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
1743: THEN -- MMSG
1744: FND_MESSAGE.Set_Name('AMS', 'AMS_CAT_CANT_DEL_ACT');
1745: FND_MSG_PUB.Add;
1746: END IF;
1747: x_return_status := FND_API.g_ret_sts_error;
1748: RETURN;

Line 1761: FND_MESSAGE.Set_Name('AMS', 'AMS_CAT_CANT_DEL_METRICS');

1757: THEN
1758: -- FK checking
1759: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
1760: THEN -- MMSG
1761: FND_MESSAGE.Set_Name('AMS', 'AMS_CAT_CANT_DEL_METRICS');
1762: FND_MSG_PUB.Add;
1763: END IF;
1764: x_return_status := FND_API.g_ret_sts_error;
1765: RETURN;

Line 1777: FND_MESSAGE.Set_Name('AMS', 'AMS_CAT_CANT_DEL_METRICS');

1773: THEN
1774: -- FK checking
1775: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
1776: THEN -- MMSG
1777: FND_MESSAGE.Set_Name('AMS', 'AMS_CAT_CANT_DEL_METRICS');
1778: FND_MSG_PUB.Add;
1779: END IF;
1780: x_return_status := FND_API.g_ret_sts_error;
1781: RETURN;

Line 1796: FND_MESSAGE.Set_Name('AMS', 'AMS_CAT_CANT_DEL_DELV');

1792: THEN
1793: -- FK checking
1794: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
1795: THEN -- MMSG
1796: FND_MESSAGE.Set_Name('AMS', 'AMS_CAT_CANT_DEL_DELV');
1797: FND_MSG_PUB.Add;
1798: END IF;
1799: x_return_status := FND_API.g_ret_sts_error;
1800: RETURN;

Line 1827: FND_MESSAGE.Set_Name('AMS', 'AMS_CAT_CANT_DEL_DELV');

1823: THEN
1824: -- FK checking
1825: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
1826: THEN -- MMSG
1827: FND_MESSAGE.Set_Name('AMS', 'AMS_CAT_CANT_DEL_DELV');
1828: FND_MSG_PUB.Add;
1829: END IF;
1830: x_return_status := FND_API.g_ret_sts_error;
1831: RETURN;

Line 1848: FND_MESSAGE.Set_Name('AMS', 'AMS_CAT_CANT_DEL_DELV');

1844: THEN
1845: -- FK checking
1846: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
1847: THEN -- MMSG
1848: FND_MESSAGE.Set_Name('AMS', 'AMS_CAT_CANT_DEL_DELV');
1849: FND_MSG_PUB.Add;
1850: END IF;
1851: x_return_status := FND_API.g_ret_sts_error;
1852: RETURN;

Line 1883: FND_MESSAGE.Set_Name('AMS', 'AMS_CAT_CANT_DEL_ACT');

1879: THEN
1880: -- FK checking
1881: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
1882: THEN -- MMSG
1883: FND_MESSAGE.Set_Name('AMS', 'AMS_CAT_CANT_DEL_ACT');
1884: FND_MSG_PUB.Add;
1885: END IF;
1886: x_return_status := FND_API.g_ret_sts_error;
1887: RETURN;

Line 1902: FND_MESSAGE.Set_Name('AMS', 'AMS_CAT_CANT_DEL_DELV');

1898: THEN
1899: -- FK checking
1900: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
1901: THEN -- MMSG
1902: FND_MESSAGE.Set_Name('AMS', 'AMS_CAT_CANT_DEL_DELV');
1903: FND_MSG_PUB.Add;
1904: END IF;
1905: x_return_status := FND_API.g_ret_sts_error;
1906: RETURN;

Line 1953: FND_MESSAGE.set_name('AMS', 'AMS_CAT_NO_CAT_NAME');

1949: THEN
1950:
1951: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)
1952: THEN
1953: FND_MESSAGE.set_name('AMS', 'AMS_CAT_NO_CAT_NAME');
1954: FND_MSG_PUB.add;
1955: END IF;
1956: x_return_status := FND_API.g_ret_sts_error;
1957: RETURN;

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

1982: FETCH c_cat INTO l_category_rec;
1983: IF c_cat%NOTFOUND THEN
1984: CLOSE c_cat;
1985: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
1986: FND_MESSAGE.set_name('AMS', 'AMS_API_RECORD_NOT_FOUND');
1987: FND_MSG_PUB.add;
1988: END IF;
1989: RAISE FND_API.g_exc_error;
1990: END IF;