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.HZ_CLASSIFICATION_V2PUB dependencies on FND_MSG_PUB

Line 241: FND_MSG_PUB.ADD;

237:
238: If HZ_CLASS_VALIDATE_V2PUB.is_valid_delimiter(p_class_cat_rec.class_category,p_class_cat_rec.delimiter)='N'
239: then
240: FND_MESSAGE.SET_NAME('AR', 'HZ_INVALID_DELIMITER');
241: FND_MSG_PUB.ADD;
242: RAISE FND_API.G_EXC_ERROR;
243: end if;
244:
245: HZ_CLASS_CATEGORIES_PKG.Insert_Row (

Line 314: FND_MSG_PUB.ADD;

310: OR (p_object_version_number = l_object_version_number))
311: THEN
312: FND_MESSAGE.SET_NAME('AR', 'HZ_API_RECORD_CHANGED');
313: FND_MESSAGE.SET_TOKEN('TABLE', 'HZ_CLASS_CATEGORIES');
314: FND_MSG_PUB.ADD;
315: RAISE FND_API.G_EXC_ERROR;
316: END IF;
317:
318: p_object_version_number := nvl(l_object_version_number, 1) + 1;

Line 324: FND_MSG_PUB.ADD;

320: EXCEPTION WHEN NO_DATA_FOUND THEN
321: FND_MESSAGE.SET_NAME('AR', 'HZ_API_NO_RECORD');
322: FND_MESSAGE.SET_TOKEN('RECORD', 'HZ_CLASS_CATEGORIES');
323: FND_MESSAGE.SET_TOKEN('VALUE', 'p_class_cat_rec.class_category');
324: FND_MSG_PUB.ADD;
325: RAISE FND_API.G_EXC_ERROR;
326: END;
327:
328: -- call for validations.

Line 341: FND_MSG_PUB.ADD;

337: then
338: If HZ_CLASS_VALIDATE_V2PUB.is_valid_delimiter(p_class_cat_rec.class_category,p_class_cat_rec.delimiter)='N'
339: then
340: FND_MESSAGE.SET_NAME('AR', 'HZ_INVALID_DELIMITER');
341: FND_MSG_PUB.ADD;
342: RAISE FND_API.G_EXC_ERROR;
343: end if;
344: end if;
345:

Line 492: FND_MSG_PUB.ADD;

488: OR (p_object_version_number = l_object_version_number))
489: THEN
490: FND_MESSAGE.SET_NAME('AR', 'HZ_API_RECORD_CHANGED');
491: FND_MESSAGE.SET_TOKEN('TABLE', 'HZ_CLASS_CODE_RELATIONS');
492: FND_MSG_PUB.ADD;
493: RAISE FND_API.G_EXC_ERROR;
494: END IF;
495:
496: p_object_version_number := nvl(l_object_version_number, 1) + 1;

Line 502: FND_MSG_PUB.ADD;

498: EXCEPTION WHEN NO_DATA_FOUND THEN
499: FND_MESSAGE.SET_NAME('AR', 'HZ_API_NO_RECORD');
500: FND_MESSAGE.SET_TOKEN('RECORD', 'HZ_CLASS_CODE_RELATIONS');
501: FND_MESSAGE.SET_TOKEN('VALUE', 'p_class_code_rel_rec.class_category');
502: FND_MSG_PUB.ADD;
503: RAISE FND_API.G_EXC_ERROR;
504: END;
505:
506: -- call for validations.

Line 711: FND_MSG_PUB.ADD;

707: --
708: FND_MESSAGE.SET_NAME('AR', 'HZ_DSS_NO_INSERT_PRIVILEGE');
709: FND_MESSAGE.SET_TOKEN('ENTITY_NAME',
710: hz_dss_util_pub.get_display_name('HZ_CODE_ASSIGNMENTS', null));
711: FND_MSG_PUB.ADD;
712: RAISE FND_API.G_EXC_ERROR;
713: end if;
714: END IF;
715:

Line 960: FND_MSG_PUB.ADD;

956: p_object_version_number = l_object_version_number))
957: THEN
958: FND_MESSAGE.SET_NAME('AR', 'HZ_API_RECORD_CHANGED');
959: FND_MESSAGE.SET_TOKEN('TABLE', 'HZ_CODE_ASSIGNMENTS');
960: FND_MSG_PUB.ADD;
961: RAISE FND_API.G_EXC_ERROR;
962: END IF;
963:
964: p_object_version_number := nvl(l_object_version_number, 1) + 1;

Line 970: FND_MSG_PUB.ADD;

966: EXCEPTION WHEN NO_DATA_FOUND THEN
967: FND_MESSAGE.SET_NAME('AR', 'HZ_API_NO_RECORD');
968: FND_MESSAGE.SET_TOKEN('RECORD', 'HZ_CODE_ASSIGNMENTS');
969: FND_MESSAGE.SET_TOKEN('VALUE', 'p_code_assignment_rec.code_assignment_id');
970: FND_MSG_PUB.ADD;
971: RAISE FND_API.G_EXC_ERROR;
972: END;
973:
974: -- call for validations.

Line 1344: FND_MSG_PUB.ADD;

1340: OR (p_object_version_number = l_object_version_number))
1341: THEN
1342: FND_MESSAGE.SET_NAME('AR', 'HZ_API_RECORD_CHANGED');
1343: FND_MESSAGE.SET_TOKEN('TABLE', 'HZ_CLASS_CATEGORY_USES');
1344: FND_MSG_PUB.ADD;
1345: RAISE FND_API.G_EXC_ERROR;
1346: END IF;
1347:
1348: p_object_version_number := nvl(l_object_version_number, 1) + 1;

Line 1354: FND_MSG_PUB.ADD;

1350: EXCEPTION WHEN NO_DATA_FOUND THEN
1351: FND_MESSAGE.SET_NAME('AR', 'HZ_API_NO_RECORD');
1352: FND_MESSAGE.SET_TOKEN('RECORD', 'HZ_CLASS_CATEGORY_USES');
1353: FND_MESSAGE.SET_TOKEN('VALUE', 'p_class_category_use_rec.class_category');
1354: FND_MSG_PUB.ADD;
1355: RAISE FND_API.G_EXC_ERROR;
1356: END;
1357:
1358: -- call for validations.

Line 1433: FND_MSG_PUB.initialize;

1429: SAVEPOINT create_class_category;
1430:
1431: -- initialize message list if p_init_msg_list is set to TRUE.
1432: IF FND_API.to_Boolean(p_init_msg_list) THEN
1433: FND_MSG_PUB.initialize;
1434: END IF;
1435:
1436: -- initialize API return status to success.
1437: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 1456: FND_MSG_PUB.Count_And_Get(

1452:
1453: END IF;
1454:
1455: -- standard call to get message count and if count is 1, get message info.
1456: FND_MSG_PUB.Count_And_Get(
1457: p_encoded => FND_API.G_FALSE,
1458: p_count => x_msg_count,
1459: p_data => x_msg_data);
1460:

Line 1465: FND_MSG_PUB.Count_And_Get(

1461: EXCEPTION
1462: WHEN FND_API.G_EXC_ERROR THEN
1463: ROLLBACK TO create_class_category;
1464: x_return_status := FND_API.G_RET_STS_ERROR;
1465: FND_MSG_PUB.Count_And_Get(
1466: p_encoded => FND_API.G_FALSE,
1467: p_count => x_msg_count,
1468: p_data => x_msg_data);
1469:

Line 1473: FND_MSG_PUB.Count_And_Get(

1469:
1470: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1471: ROLLBACK TO create_class_category;
1472: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1473: FND_MSG_PUB.Count_And_Get(
1474: p_encoded => FND_API.G_FALSE,
1475: p_count => x_msg_count,
1476: p_data => x_msg_data);
1477:

Line 1483: FND_MSG_PUB.ADD;

1479: ROLLBACK TO create_class_category;
1480: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1481: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
1482: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
1483: FND_MSG_PUB.ADD;
1484: FND_MSG_PUB.Count_And_Get(
1485: p_encoded => FND_API.G_FALSE,
1486: p_count => x_msg_count,
1487: p_data => x_msg_data);

Line 1484: FND_MSG_PUB.Count_And_Get(

1480: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1481: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
1482: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
1483: FND_MSG_PUB.ADD;
1484: FND_MSG_PUB.Count_And_Get(
1485: p_encoded => FND_API.G_FALSE,
1486: p_count => x_msg_count,
1487: p_data => x_msg_data);
1488: END create_class_category;

Line 1541: FND_MSG_PUB.initialize;

1537: SAVEPOINT update_class_category;
1538:
1539: -- initialize message list if p_init_msg_list is set to TRUE.
1540: IF FND_API.to_Boolean(p_init_msg_list) THEN
1541: FND_MSG_PUB.initialize;
1542: END IF;
1543:
1544: -- initialize API return status to success.
1545: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 1580: FND_MSG_PUB.Count_And_Get(

1576:
1577: END IF;
1578:
1579: -- standard call to get message count and if count is 1, get message info.
1580: FND_MSG_PUB.Count_And_Get(
1581: p_encoded => FND_API.G_FALSE,
1582: p_count => x_msg_count,
1583: p_data => x_msg_data);
1584:

Line 1589: FND_MSG_PUB.Count_And_Get(

1585: EXCEPTION
1586: WHEN FND_API.G_EXC_ERROR THEN
1587: ROLLBACK TO update_class_category;
1588: x_return_status := FND_API.G_RET_STS_ERROR;
1589: FND_MSG_PUB.Count_And_Get(
1590: p_encoded => FND_API.G_FALSE,
1591: p_count => x_msg_count,
1592: p_data => x_msg_data);
1593:

Line 1597: FND_MSG_PUB.Count_And_Get(

1593:
1594: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1595: ROLLBACK TO update_class_category;
1596: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1597: FND_MSG_PUB.Count_And_Get(
1598: p_encoded => FND_API.G_FALSE,
1599: p_count => x_msg_count,
1600: p_data => x_msg_data);
1601:

Line 1607: FND_MSG_PUB.ADD;

1603: ROLLBACK TO update_class_category;
1604: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1605: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
1606: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
1607: FND_MSG_PUB.ADD;
1608: FND_MSG_PUB.Count_And_Get(
1609: p_encoded => FND_API.G_FALSE,
1610: p_count => x_msg_count,
1611: p_data => x_msg_data);

Line 1608: FND_MSG_PUB.Count_And_Get(

1604: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1605: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
1606: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
1607: FND_MSG_PUB.ADD;
1608: FND_MSG_PUB.Count_And_Get(
1609: p_encoded => FND_API.G_FALSE,
1610: p_count => x_msg_count,
1611: p_data => x_msg_data);
1612:

Line 1663: FND_MSG_PUB.initialize;

1659: SAVEPOINT create_class_code_relation;
1660:
1661: -- initialize message list if p_init_msg_list is set to TRUE.
1662: IF FND_API.to_Boolean(p_init_msg_list) THEN
1663: FND_MSG_PUB.initialize;
1664: END IF;
1665:
1666: -- initialize API return status to success.
1667: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 1685: FND_MSG_PUB.Count_And_Get(

1681:
1682: END IF;
1683:
1684: -- standard call to get message count and if count is 1, get message info.
1685: FND_MSG_PUB.Count_And_Get(
1686: p_encoded => FND_API.G_FALSE,
1687: p_count => x_msg_count,
1688: p_data => x_msg_data);
1689:

Line 1694: FND_MSG_PUB.Count_And_Get(

1690: EXCEPTION
1691: WHEN FND_API.G_EXC_ERROR THEN
1692: ROLLBACK TO create_class_code_relation;
1693: x_return_status := FND_API.G_RET_STS_ERROR;
1694: FND_MSG_PUB.Count_And_Get(
1695: p_encoded => FND_API.G_FALSE,
1696: p_count => x_msg_count,
1697: p_data => x_msg_data);
1698:

Line 1702: FND_MSG_PUB.Count_And_Get(

1698:
1699: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1700: ROLLBACK TO create_class_code_relation;
1701: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1702: FND_MSG_PUB.Count_And_Get(
1703: p_encoded => FND_API.G_FALSE,
1704: p_count => x_msg_count,
1705: p_data => x_msg_data);
1706:

Line 1712: FND_MSG_PUB.ADD;

1708: ROLLBACK TO create_class_code_relation;
1709: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1710: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
1711: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
1712: FND_MSG_PUB.ADD;
1713: FND_MSG_PUB.Count_And_Get(
1714: p_encoded => FND_API.G_FALSE,
1715: p_count => x_msg_count,
1716: p_data => x_msg_data);

Line 1713: FND_MSG_PUB.Count_And_Get(

1709: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1710: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
1711: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
1712: FND_MSG_PUB.ADD;
1713: FND_MSG_PUB.Count_And_Get(
1714: p_encoded => FND_API.G_FALSE,
1715: p_count => x_msg_count,
1716: p_data => x_msg_data);
1717: END create_class_code_relation;

Line 1770: FND_MSG_PUB.initialize;

1766: SAVEPOINT update_class_code_relation;
1767:
1768: -- initialize message list if p_init_msg_list is set to TRUE.
1769: IF FND_API.to_Boolean(p_init_msg_list) THEN
1770: FND_MSG_PUB.initialize;
1771: END IF;
1772:
1773: -- initialize API return status to success.
1774: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 1812: FND_MSG_PUB.Count_And_Get(

1808:
1809: END IF;
1810:
1811: -- standard call to get message count and if count is 1, get message info.
1812: FND_MSG_PUB.Count_And_Get(
1813: p_encoded => FND_API.G_FALSE,
1814: p_count => x_msg_count,
1815: p_data => x_msg_data);
1816:

Line 1821: FND_MSG_PUB.Count_And_Get(

1817: EXCEPTION
1818: WHEN FND_API.G_EXC_ERROR THEN
1819: ROLLBACK TO update_class_code_relation;
1820: x_return_status := FND_API.G_RET_STS_ERROR;
1821: FND_MSG_PUB.Count_And_Get(
1822: p_encoded => FND_API.G_FALSE,
1823: p_count => x_msg_count,
1824: p_data => x_msg_data);
1825:

Line 1829: FND_MSG_PUB.Count_And_Get(

1825:
1826: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1827: ROLLBACK TO update_class_code_relation;
1828: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1829: FND_MSG_PUB.Count_And_Get(
1830: p_encoded => FND_API.G_FALSE,
1831: p_count => x_msg_count,
1832: p_data => x_msg_data);
1833:

Line 1839: FND_MSG_PUB.ADD;

1835: ROLLBACK TO update_class_code_relation;
1836: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1837: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
1838: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
1839: FND_MSG_PUB.ADD;
1840: FND_MSG_PUB.Count_And_Get(
1841: p_encoded => FND_API.G_FALSE,
1842: p_count => x_msg_count,
1843: p_data => x_msg_data);

Line 1840: FND_MSG_PUB.Count_And_Get(

1836: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1837: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
1838: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
1839: FND_MSG_PUB.ADD;
1840: FND_MSG_PUB.Count_And_Get(
1841: p_encoded => FND_API.G_FALSE,
1842: p_count => x_msg_count,
1843: p_data => x_msg_data);
1844:

Line 1908: FND_MSG_PUB.initialize;

1904: SAVEPOINT create_code_assignment;
1905:
1906: -- initialize message list if p_init_msg_list is set to TRUE.
1907: IF FND_API.to_Boolean(p_init_msg_list) THEN
1908: FND_MSG_PUB.initialize;
1909: END IF;
1910:
1911: -- initialize API return status to success.
1912: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 1950: FND_MSG_PUB.Count_And_Get(

1946: END IF;
1947: END IF;
1948:
1949: -- standard call to get message count and if count is 1, get message info.
1950: FND_MSG_PUB.Count_And_Get(
1951: p_encoded => FND_API.G_FALSE,
1952: p_count => x_msg_count,
1953: p_data => x_msg_data);
1954:

Line 1959: FND_MSG_PUB.Count_And_Get(

1955: EXCEPTION
1956: WHEN FND_API.G_EXC_ERROR THEN
1957: ROLLBACK TO create_code_assignment;
1958: x_return_status := FND_API.G_RET_STS_ERROR;
1959: FND_MSG_PUB.Count_And_Get(
1960: p_encoded => FND_API.G_FALSE,
1961: p_count => x_msg_count,
1962: p_data => x_msg_data);
1963:

Line 1967: FND_MSG_PUB.Count_And_Get(

1963:
1964: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1965: ROLLBACK TO create_code_assignment;
1966: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1967: FND_MSG_PUB.Count_And_Get(
1968: p_encoded => FND_API.G_FALSE,
1969: p_count => x_msg_count,
1970: p_data => x_msg_data);
1971:

Line 1977: FND_MSG_PUB.ADD;

1973: ROLLBACK TO create_code_assignment;
1974: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1975: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
1976: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
1977: FND_MSG_PUB.ADD;
1978: FND_MSG_PUB.Count_And_Get(
1979: p_encoded => FND_API.G_FALSE,
1980: p_count => x_msg_count,
1981: p_data => x_msg_data);

Line 1978: FND_MSG_PUB.Count_And_Get(

1974: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1975: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
1976: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
1977: FND_MSG_PUB.ADD;
1978: FND_MSG_PUB.Count_And_Get(
1979: p_encoded => FND_API.G_FALSE,
1980: p_count => x_msg_count,
1981: p_data => x_msg_data);
1982: END create_code_assignment;

Line 2040: FND_MSG_PUB.initialize;

2036: SAVEPOINT update_code_assignment;
2037:
2038: -- initialize message list if p_init_msg_list is set to TRUE.
2039: IF FND_API.to_Boolean(p_init_msg_list) THEN
2040: FND_MSG_PUB.initialize;
2041: END IF;
2042:
2043: -- initialize API return status to success.
2044: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 2097: hz_dss_util_pub.get_display_name('HZ_CODE_ASSIGNMENTS', null)); FND_MSG_PUB.ADD;

2093: -- Bug 3835601: replaced the dss message with a more user friendly message
2094: --
2095: FND_MESSAGE.SET_NAME('AR', 'HZ_DSS_NO_UPDATE_PRIVILEGE');
2096: FND_MESSAGE.SET_TOKEN('ENTITY_NAME',
2097: hz_dss_util_pub.get_display_name('HZ_CODE_ASSIGNMENTS', null)); FND_MSG_PUB.ADD;
2098: RAISE FND_API.G_EXC_ERROR;
2099: end if;
2100: END IF;
2101:

Line 2125: FND_MSG_PUB.Count_And_Get(

2121: END IF;
2122:
2123: HZ_UTILITY_V2PUB.G_UPDATE_ACS := NULL;
2124: -- standard call to get message count and if count is 1, get message info.
2125: FND_MSG_PUB.Count_And_Get(
2126: p_encoded => FND_API.G_FALSE,
2127: p_count => x_msg_count,
2128: p_data => x_msg_data);
2129:

Line 2135: FND_MSG_PUB.Count_And_Get(

2131: WHEN FND_API.G_EXC_ERROR THEN
2132: ROLLBACK TO update_code_assignment;
2133: HZ_UTILITY_V2PUB.G_UPDATE_ACS := NULL;
2134: x_return_status := FND_API.G_RET_STS_ERROR;
2135: FND_MSG_PUB.Count_And_Get(
2136: p_encoded => FND_API.G_FALSE,
2137: p_count => x_msg_count,
2138: p_data => x_msg_data);
2139:

Line 2144: FND_MSG_PUB.Count_And_Get(

2140: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2141: ROLLBACK TO update_code_assignment;
2142: HZ_UTILITY_V2PUB.G_UPDATE_ACS := NULL;
2143: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2144: FND_MSG_PUB.Count_And_Get(
2145: p_encoded => FND_API.G_FALSE,
2146: p_count => x_msg_count,
2147: p_data => x_msg_data);
2148:

Line 2155: FND_MSG_PUB.ADD;

2151: HZ_UTILITY_V2PUB.G_UPDATE_ACS := NULL;
2152: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2153: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
2154: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
2155: FND_MSG_PUB.ADD;
2156: FND_MSG_PUB.Count_And_Get(
2157: p_encoded => FND_API.G_FALSE,
2158: p_count => x_msg_count,
2159: p_data => x_msg_data);

Line 2156: FND_MSG_PUB.Count_And_Get(

2152: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2153: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
2154: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
2155: FND_MSG_PUB.ADD;
2156: FND_MSG_PUB.Count_And_Get(
2157: p_encoded => FND_API.G_FALSE,
2158: p_count => x_msg_count,
2159: p_data => x_msg_data);
2160:

Line 2241: FND_MSG_PUB.initialize;

2237: SAVEPOINT set_primary_code_assign;
2238:
2239: --Initialize message list if p_init_msg_list is set to TRUE.
2240: IF FND_API.to_Boolean(p_init_msg_list) THEN
2241: FND_MSG_PUB.initialize;
2242: END IF;
2243:
2244: --Initialize API return status to success.
2245: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 2330: FND_MSG_PUB.Count_And_Get(

2326: NULL;
2327: END IF;
2328:
2329: --Standard call to get message count and if count is 1, get message info.
2330: FND_MSG_PUB.Count_And_Get(
2331: p_encoded => FND_API.G_FALSE,
2332: p_count => x_msg_count,
2333: p_data => x_msg_data);
2334:

Line 2339: FND_MSG_PUB.Count_And_Get(

2335: EXCEPTION
2336: WHEN FND_API.G_EXC_ERROR THEN
2337: ROLLBACK TO set_primary_code_assign;
2338: x_return_status := FND_API.G_RET_STS_ERROR;
2339: FND_MSG_PUB.Count_And_Get(
2340: p_encoded => FND_API.G_FALSE,
2341: p_count => x_msg_count,
2342: p_data => x_msg_data);
2343:

Line 2347: FND_MSG_PUB.Count_And_Get(

2343:
2344: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2345: ROLLBACK TO set_primary_code_assign;
2346: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2347: FND_MSG_PUB.Count_And_Get(
2348: p_encoded => FND_API.G_FALSE,
2349: p_count => x_msg_count,
2350: p_data => x_msg_data);
2351:

Line 2357: FND_MSG_PUB.ADD;

2353: ROLLBACK TO set_primary_code_assign;
2354: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2355: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
2356: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
2357: FND_MSG_PUB.ADD;
2358: FND_MSG_PUB.Count_And_Get(
2359: p_encoded => FND_API.G_FALSE,
2360: p_count => x_msg_count,
2361: p_data => x_msg_data);

Line 2358: FND_MSG_PUB.Count_And_Get(

2354: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2355: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
2356: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
2357: FND_MSG_PUB.ADD;
2358: FND_MSG_PUB.Count_And_Get(
2359: p_encoded => FND_API.G_FALSE,
2360: p_count => x_msg_count,
2361: p_data => x_msg_data);
2362: END;

Line 2412: FND_MSG_PUB.INITIALIZE;

2408: SAVEPOINT create_class_category_use;
2409:
2410: -- initialize message list if p_init_msg_list is TRUE
2411: IF FND_API.to_Boolean(p_init_msg_list) THEN
2412: FND_MSG_PUB.INITIALIZE;
2413: END IF;
2414:
2415: -- initialize API return status to SUCCESS
2416: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 2435: FND_MSG_PUB.count_and_get(

2431:
2432: END IF;
2433:
2434: -- standard Call to get message count and if count is 1 get message info.
2435: FND_MSG_PUB.count_and_get(
2436: p_encoded => fnd_api.g_false,
2437: p_count => x_msg_count,
2438: p_data => x_msg_data );
2439:

Line 2444: FND_MSG_PUB.Count_And_Get(

2440: EXCEPTION
2441: WHEN FND_API.G_EXC_ERROR THEN
2442: ROLLBACK TO create_class_category_use;
2443: x_return_status := FND_API.G_RET_STS_ERROR;
2444: FND_MSG_PUB.Count_And_Get(
2445: p_encoded => FND_API.G_FALSE,
2446: p_count => x_msg_count,
2447: p_data => x_msg_data );
2448:

Line 2452: FND_MSG_PUB.Count_And_Get(

2448:
2449: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2450: ROLLBACK TO create_class_category_use;
2451: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2452: FND_MSG_PUB.Count_And_Get(
2453: p_encoded => FND_API.G_FALSE,
2454: p_count => x_msg_count,
2455: p_data => x_msg_data );
2456:

Line 2462: FND_MSG_PUB.Count_And_Get(

2458: ROLLBACK TO create_class_category_use;
2459: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2460: FND_MESSAGE.Set_Name('AR','HZ_API_OTHERS_EXCEP');
2461: FND_MESSAGE.Set_Token('ERROR',SQLERRM);
2462: FND_MSG_PUB.Count_And_Get(
2463: p_encoded => FND_API.G_FALSE,
2464: p_count => x_msg_count,
2465: p_data => x_msg_data );
2466:

Line 2520: FND_MSG_PUB.initialize;

2516: SAVEPOINT update_class_category_use;
2517:
2518: -- initialize message list if p_init_msg_list is set to TRUE.
2519: IF FND_API.to_Boolean(p_init_msg_list) THEN
2520: FND_MSG_PUB.initialize;
2521: END IF;
2522:
2523: -- Initialize API return status to success.
2524: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 2560: FND_MSG_PUB.Count_And_Get(

2556:
2557: END IF;
2558:
2559: -- standard call to get message count and if count is 1, get message info.
2560: FND_MSG_PUB.Count_And_Get(
2561: p_encoded => FND_API.G_FALSE,
2562: p_count => x_msg_count,
2563: p_data => x_msg_data);
2564:

Line 2570: FND_MSG_PUB.Count_And_Get(

2566: WHEN FND_API.G_EXC_ERROR THEN
2567: ROLLBACK TO update_class_category_use;
2568: x_return_status := FND_API.G_RET_STS_ERROR;
2569:
2570: FND_MSG_PUB.Count_And_Get(
2571: p_encoded => FND_API.G_FALSE,
2572: p_count => x_msg_count,
2573: p_data => x_msg_data );
2574:

Line 2579: FND_MSG_PUB.Count_And_Get(

2575: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2576: ROLLBACK TO update_class_category_use;
2577: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2578:
2579: FND_MSG_PUB.Count_And_Get(
2580: p_encoded => FND_API.G_FALSE,
2581: p_count => x_msg_count,
2582: p_data => x_msg_data );
2583:

Line 2590: FND_MSG_PUB.ADD;

2586: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2587:
2588: FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_OTHERS_EXCEP' );
2589: FND_MESSAGE.SET_TOKEN( 'ERROR' ,SQLERRM );
2590: FND_MSG_PUB.ADD;
2591:
2592: FND_MSG_PUB.Count_And_Get(
2593: p_encoded => FND_API.G_FALSE,
2594: p_count => x_msg_count,

Line 2592: FND_MSG_PUB.Count_And_Get(

2588: FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_OTHERS_EXCEP' );
2589: FND_MESSAGE.SET_TOKEN( 'ERROR' ,SQLERRM );
2590: FND_MSG_PUB.ADD;
2591:
2592: FND_MSG_PUB.Count_And_Get(
2593: p_encoded => FND_API.G_FALSE,
2594: p_count => x_msg_count,
2595: p_data => x_msg_data );
2596:

Line 2828: FND_MSG_PUB.initialize;

2824: BEGIN
2825:
2826: --Initialize message list if p_init_msg_list is set to TRUE.
2827: IF FND_API.to_Boolean(p_init_msg_list) THEN
2828: FND_MSG_PUB.initialize;
2829: END IF;
2830:
2831: --Initialize API return status to success.
2832: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 2839: FND_MSG_PUB.ADD;

2835: IF p_class_category IS NULL OR
2836: p_class_category = FND_API.G_MISS_CHAR THEN
2837: FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_MISSING_COLUMN' );
2838: FND_MESSAGE.SET_TOKEN( 'COLUMN', 'class_category' );
2839: FND_MSG_PUB.ADD;
2840: RAISE FND_API.G_EXC_ERROR;
2841: END IF;
2842:
2843: x_class_category_rec.class_category := p_class_category;

Line 2856: FND_MSG_PUB.Count_And_Get(

2852: X_DELIMITER => x_class_category_rec.delimiter
2853: );
2854:
2855: --Standard call to get message count and if count is 1, get message info.
2856: FND_MSG_PUB.Count_And_Get(
2857: p_encoded => FND_API.G_FALSE,
2858: p_count => x_msg_count,
2859: p_data => x_msg_data );
2860:

Line 2865: FND_MSG_PUB.Count_And_Get(

2861: EXCEPTION
2862: WHEN FND_API.G_EXC_ERROR THEN
2863: x_return_status := FND_API.G_RET_STS_ERROR;
2864:
2865: FND_MSG_PUB.Count_And_Get(
2866: p_encoded => FND_API.G_FALSE,
2867: p_count => x_msg_count,
2868: p_data => x_msg_data );
2869:

Line 2873: FND_MSG_PUB.Count_And_Get(

2869:
2870: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2871: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2872:
2873: FND_MSG_PUB.Count_And_Get(
2874: p_encoded => FND_API.G_FALSE,
2875: p_count => x_msg_count,
2876: p_data => x_msg_data );
2877:

Line 2883: FND_MSG_PUB.ADD;

2879: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2880:
2881: FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_OTHERS_EXCEP' );
2882: FND_MESSAGE.SET_TOKEN( 'ERROR' ,SQLERRM );
2883: FND_MSG_PUB.ADD;
2884:
2885: FND_MSG_PUB.Count_And_Get(
2886: p_encoded => FND_API.G_FALSE,
2887: p_count => x_msg_count,

Line 2885: FND_MSG_PUB.Count_And_Get(

2881: FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_OTHERS_EXCEP' );
2882: FND_MESSAGE.SET_TOKEN( 'ERROR' ,SQLERRM );
2883: FND_MSG_PUB.ADD;
2884:
2885: FND_MSG_PUB.Count_And_Get(
2886: p_encoded => FND_API.G_FALSE,
2887: p_count => x_msg_count,
2888: p_data => x_msg_data );
2889:

Line 2939: FND_MSG_PUB.initialize;

2935: BEGIN
2936:
2937: --Initialize message list if p_init_msg_list is set to TRUE.
2938: IF FND_API.to_Boolean(p_init_msg_list) THEN
2939: FND_MSG_PUB.initialize;
2940: END IF;
2941:
2942: --Initialize API return status to success.
2943: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 2950: FND_MSG_PUB.ADD;

2946: IF p_class_category IS NULL OR
2947: p_class_category = FND_API.G_MISS_CHAR THEN
2948: FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_MISSING_COLUMN' );
2949: FND_MESSAGE.SET_TOKEN( 'COLUMN', 'class_category' );
2950: FND_MSG_PUB.ADD;
2951: RAISE FND_API.G_EXC_ERROR;
2952: END IF;
2953:
2954: IF p_owner_table IS NULL OR

Line 2958: FND_MSG_PUB.ADD;

2954: IF p_owner_table IS NULL OR
2955: p_owner_table = FND_API.G_MISS_CHAR THEN
2956: FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_MISSING_COLUMN' );
2957: FND_MESSAGE.SET_TOKEN( 'COLUMN', 'owner_table' );
2958: FND_MSG_PUB.ADD;
2959: RAISE FND_API.G_EXC_ERROR;
2960: END IF;
2961:
2962: x_class_category_use_rec.class_category := p_class_category;

Line 2975: FND_MSG_PUB.Count_And_Get(

2971: X_APPLICATION_ID => x_class_category_use_rec.application_id
2972: );
2973:
2974: --Standard call to get message count and if count is 1, get message info.
2975: FND_MSG_PUB.Count_And_Get(
2976: p_encoded => FND_API.G_FALSE,
2977: p_count => x_msg_count,
2978: p_data => x_msg_data );
2979:

Line 2984: FND_MSG_PUB.Count_And_Get(

2980: EXCEPTION
2981: WHEN FND_API.G_EXC_ERROR THEN
2982: x_return_status := FND_API.G_RET_STS_ERROR;
2983:
2984: FND_MSG_PUB.Count_And_Get(
2985: p_encoded => FND_API.G_FALSE,
2986: p_count => x_msg_count,
2987: p_data => x_msg_data );
2988:

Line 2992: FND_MSG_PUB.Count_And_Get(

2988:
2989: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2990: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2991:
2992: FND_MSG_PUB.Count_And_Get(
2993: p_encoded => FND_API.G_FALSE,
2994: p_count => x_msg_count,
2995: p_data => x_msg_data );
2996:

Line 3002: FND_MSG_PUB.ADD;

2998: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2999:
3000: FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_OTHERS_EXCEP' );
3001: FND_MESSAGE.SET_TOKEN( 'ERROR' ,SQLERRM );
3002: FND_MSG_PUB.ADD;
3003:
3004: FND_MSG_PUB.Count_And_Get(
3005: p_encoded => FND_API.G_FALSE,
3006: p_count => x_msg_count,

Line 3004: FND_MSG_PUB.Count_And_Get(

3000: FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_OTHERS_EXCEP' );
3001: FND_MESSAGE.SET_TOKEN( 'ERROR' ,SQLERRM );
3002: FND_MSG_PUB.ADD;
3003:
3004: FND_MSG_PUB.Count_And_Get(
3005: p_encoded => FND_API.G_FALSE,
3006: p_count => x_msg_count,
3007: p_data => x_msg_data );
3008:

Line 3062: FND_MSG_PUB.initialize;

3058: BEGIN
3059:
3060: --Initialize message list if p_init_msg_list is set to TRUE.
3061: IF FND_API.to_Boolean(p_init_msg_list) THEN
3062: FND_MSG_PUB.initialize;
3063: END IF;
3064:
3065: --Initialize API return status to success.
3066: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 3073: FND_MSG_PUB.ADD;

3069: IF p_class_category IS NULL OR
3070: p_class_category = FND_API.G_MISS_CHAR THEN
3071: FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_MISSING_COLUMN' );
3072: FND_MESSAGE.SET_TOKEN( 'COLUMN', 'class_category' );
3073: FND_MSG_PUB.ADD;
3074: RAISE FND_API.G_EXC_ERROR;
3075: END IF;
3076:
3077: IF p_class_code IS NULL OR

Line 3081: FND_MSG_PUB.ADD;

3077: IF p_class_code IS NULL OR
3078: p_class_code = FND_API.G_MISS_CHAR THEN
3079: FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_MISSING_COLUMN' );
3080: FND_MESSAGE.SET_TOKEN( 'COLUMN', 'class_code' );
3081: FND_MSG_PUB.ADD;
3082: RAISE FND_API.G_EXC_ERROR;
3083: END IF;
3084:
3085: IF p_sub_class_code IS NULL OR

Line 3089: FND_MSG_PUB.ADD;

3085: IF p_sub_class_code IS NULL OR
3086: p_sub_class_code = FND_API.G_MISS_CHAR THEN
3087: FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_MISSING_COLUMN' );
3088: FND_MESSAGE.SET_TOKEN( 'COLUMN', 'sub_class_code' );
3089: FND_MSG_PUB.ADD;
3090: RAISE FND_API.G_EXC_ERROR;
3091: END IF;
3092:
3093: IF p_start_date_active IS NULL OR

Line 3097: FND_MSG_PUB.ADD;

3093: IF p_start_date_active IS NULL OR
3094: p_start_date_active = FND_API.G_MISS_DATE THEN
3095: FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_MISSING_COLUMN' );
3096: FND_MESSAGE.SET_TOKEN( 'COLUMN', 'start_date_active' );
3097: FND_MSG_PUB.ADD;
3098: RAISE FND_API.G_EXC_ERROR;
3099: END IF;
3100:
3101: x_class_code_relation_rec.class_category := p_class_category;

Line 3117: FND_MSG_PUB.Count_And_Get(

3113: X_APPLICATION_ID => x_class_code_relation_rec.application_id
3114: );
3115:
3116: --Standard call to get message count and if count is 1, get message info.
3117: FND_MSG_PUB.Count_And_Get(
3118: p_encoded => FND_API.G_FALSE,
3119: p_count => x_msg_count,
3120: p_data => x_msg_data );
3121:

Line 3126: FND_MSG_PUB.Count_And_Get(

3122: EXCEPTION
3123: WHEN FND_API.G_EXC_ERROR THEN
3124: x_return_status := FND_API.G_RET_STS_ERROR;
3125:
3126: FND_MSG_PUB.Count_And_Get(
3127: p_encoded => FND_API.G_FALSE,
3128: p_count => x_msg_count,
3129: p_data => x_msg_data );
3130:

Line 3134: FND_MSG_PUB.Count_And_Get(

3130:
3131: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3132: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3133:
3134: FND_MSG_PUB.Count_And_Get(
3135: p_encoded => FND_API.G_FALSE,
3136: p_count => x_msg_count,
3137: p_data => x_msg_data );
3138:

Line 3144: FND_MSG_PUB.ADD;

3140: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3141:
3142: FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_OTHERS_EXCEP' );
3143: FND_MESSAGE.SET_TOKEN( 'ERROR' ,SQLERRM );
3144: FND_MSG_PUB.ADD;
3145:
3146: FND_MSG_PUB.Count_And_Get(
3147: p_encoded => FND_API.G_FALSE,
3148: p_count => x_msg_count,

Line 3146: FND_MSG_PUB.Count_And_Get(

3142: FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_OTHERS_EXCEP' );
3143: FND_MESSAGE.SET_TOKEN( 'ERROR' ,SQLERRM );
3144: FND_MSG_PUB.ADD;
3145:
3146: FND_MSG_PUB.Count_And_Get(
3147: p_encoded => FND_API.G_FALSE,
3148: p_count => x_msg_count,
3149: p_data => x_msg_data );
3150:

Line 3201: FND_MSG_PUB.initialize;

3197: BEGIN
3198:
3199: --Initialize message list if p_init_msg_list is set to TRUE.
3200: IF FND_API.to_Boolean(p_init_msg_list) THEN
3201: FND_MSG_PUB.initialize;
3202: END IF;
3203:
3204: --Initialize API return status to success.
3205: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 3212: FND_MSG_PUB.ADD;

3208: IF p_code_assignment_id IS NULL OR
3209: p_code_assignment_id = FND_API.G_MISS_NUM THEN
3210: FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_MISSING_COLUMN' );
3211: FND_MESSAGE.SET_TOKEN( 'COLUMN', 'code_assignment_id' );
3212: FND_MSG_PUB.ADD;
3213: RAISE FND_API.G_EXC_ERROR;
3214: END IF;
3215:
3216: x_code_assignment_rec.code_assignment_id := p_code_assignment_id;

Line 3243: FND_MSG_PUB.Count_And_Get(

3239:
3240: );
3241:
3242: --Standard call to get message count and if count is 1, get message info.
3243: FND_MSG_PUB.Count_And_Get(
3244: p_encoded => FND_API.G_FALSE,
3245: p_count => x_msg_count,
3246: p_data => x_msg_data );
3247:

Line 3252: FND_MSG_PUB.Count_And_Get(

3248: EXCEPTION
3249: WHEN FND_API.G_EXC_ERROR THEN
3250: x_return_status := FND_API.G_RET_STS_ERROR;
3251:
3252: FND_MSG_PUB.Count_And_Get(
3253: p_encoded => FND_API.G_FALSE,
3254: p_count => x_msg_count,
3255: p_data => x_msg_data );
3256:

Line 3260: FND_MSG_PUB.Count_And_Get(

3256:
3257: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3258: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3259:
3260: FND_MSG_PUB.Count_And_Get(
3261: p_encoded => FND_API.G_FALSE,
3262: p_count => x_msg_count,
3263: p_data => x_msg_data );
3264:

Line 3270: FND_MSG_PUB.ADD;

3266: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3267:
3268: FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_OTHERS_EXCEP' );
3269: FND_MESSAGE.SET_TOKEN( 'ERROR' ,SQLERRM );
3270: FND_MSG_PUB.ADD;
3271:
3272: FND_MSG_PUB.Count_And_Get(
3273: p_encoded => FND_API.G_FALSE,
3274: p_count => x_msg_count,

Line 3272: FND_MSG_PUB.Count_And_Get(

3268: FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_OTHERS_EXCEP' );
3269: FND_MESSAGE.SET_TOKEN( 'ERROR' ,SQLERRM );
3270: FND_MSG_PUB.ADD;
3271:
3272: FND_MSG_PUB.Count_And_Get(
3273: p_encoded => FND_API.G_FALSE,
3274: p_count => x_msg_count,
3275: p_data => x_msg_data );
3276:

Line 3592: FND_MSG_PUB.initialize;

3588: savepoint create_class_code;
3589:
3590: -- initialize message list if p_init_msg_list is set to TRUE.
3591: IF FND_API.to_Boolean(p_init_msg_list) THEN
3592: FND_MSG_PUB.initialize;
3593: END IF;
3594:
3595: -- Initialize return status to SUCCESS
3596: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 3601: FND_MSG_PUB.ADD;

3597:
3598: If HZ_CLASS_VALIDATE_V2PUB.is_valid_class_code_meaning(l_class_code_rec.type,l_class_code_rec.meaning)='N'
3599: then
3600: FND_MESSAGE.SET_NAME('AR', 'HZ_MODIFY_CLASS_CODE_MEANING');
3601: FND_MSG_PUB.ADD;
3602: RAISE FND_API.G_EXC_ERROR;
3603: end if;
3604:
3605: --Bug fix 2783498

Line 3687: FND_MSG_PUB.Count_And_Get(

3683:
3684: WHEN FND_API.G_EXC_ERROR THEN
3685: ROLLBACK TO create_class_code;
3686: x_return_status := FND_API.G_RET_STS_ERROR;
3687: FND_MSG_PUB.Count_And_Get(
3688: p_encoded => FND_API.G_FALSE,
3689: p_count => x_msg_count,
3690: p_data => x_msg_data);
3691:

Line 3695: FND_MSG_PUB.Count_And_Get(

3691:
3692: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3693: ROLLBACK TO create_class_code ;
3694: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3695: FND_MSG_PUB.Count_And_Get(
3696: p_encoded => FND_API.G_FALSE,
3697: p_count => x_msg_count,
3698: p_data => x_msg_data);
3699:

Line 3705: FND_MSG_PUB.ADD;

3701: ROLLBACK TO create_class_code;
3702: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3703: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
3704: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
3705: FND_MSG_PUB.ADD;
3706: FND_MSG_PUB.Count_And_Get(
3707: p_encoded => FND_API.G_FALSE,
3708: p_count => x_msg_count,
3709: p_data => x_msg_data);

Line 3706: FND_MSG_PUB.Count_And_Get(

3702: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3703: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
3704: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
3705: FND_MSG_PUB.ADD;
3706: FND_MSG_PUB.Count_And_Get(
3707: p_encoded => FND_API.G_FALSE,
3708: p_count => x_msg_count,
3709: p_data => x_msg_data);
3710:

Line 3765: FND_MSG_PUB.initialize;

3761: savepoint update_class_code;
3762:
3763: -- initialize message list if p_init_msg_list is set to TRUE.
3764: IF FND_API.to_Boolean(p_init_msg_list) THEN
3765: FND_MSG_PUB.initialize;
3766: END IF;
3767:
3768: --Bug fix 2783498
3769: SELECT start_date_active,end_date_active into l_start_date_active,l_end_date_active

Line 3797: FND_MSG_PUB.ADD;

3793: then
3794: If HZ_CLASS_VALIDATE_V2PUB.is_valid_class_code_meaning(l_class_code_rec.type,l_class_code_rec.meaning)='N'
3795: then
3796: FND_MESSAGE.SET_NAME('AR', 'HZ_MODIFY_CLASS_CODE_MEANING');
3797: FND_MSG_PUB.ADD;
3798: RAISE FND_API.G_EXC_ERROR;
3799: end if;
3800: end if;
3801:

Line 3851: FND_MSG_PUB.Count_And_Get(

3847:
3848: WHEN FND_API.G_EXC_ERROR THEN
3849: ROLLBACK TO update_class_code;
3850: x_return_status := FND_API.G_RET_STS_ERROR;
3851: FND_MSG_PUB.Count_And_Get(
3852: p_encoded => FND_API.G_FALSE,
3853: p_count => x_msg_count,
3854: p_data => x_msg_data);
3855:

Line 3859: FND_MSG_PUB.Count_And_Get(

3855:
3856: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3857: ROLLBACK TO update_class_code ;
3858: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3859: FND_MSG_PUB.Count_And_Get(
3860: p_encoded => FND_API.G_FALSE,
3861: p_count => x_msg_count,
3862: p_data => x_msg_data);
3863:

Line 3869: FND_MSG_PUB.ADD;

3865: ROLLBACK TO update_class_code;
3866: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3867: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
3868: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
3869: FND_MSG_PUB.ADD;
3870: FND_MSG_PUB.Count_And_Get(
3871: p_encoded => FND_API.G_FALSE,
3872: p_count => x_msg_count,
3873: p_data => x_msg_data);

Line 3870: FND_MSG_PUB.Count_And_Get(

3866: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3867: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
3868: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
3869: FND_MSG_PUB.ADD;
3870: FND_MSG_PUB.Count_And_Get(
3871: p_encoded => FND_API.G_FALSE,
3872: p_count => x_msg_count,
3873: p_data => x_msg_data);
3874:

Line 3973: FND_MSG_PUB.Count_And_Get(

3969:
3970: EXCEPTION
3971: WHEN FND_API.G_EXC_ERROR THEN
3972: x_return_status := FND_API.G_RET_STS_ERROR;
3973: FND_MSG_PUB.Count_And_Get(
3974: p_encoded => FND_API.G_FALSE,
3975: p_count => x_msg_count,
3976: p_data => x_msg_data);
3977:

Line 3980: FND_MSG_PUB.Count_And_Get(

3976: p_data => x_msg_data);
3977:
3978: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3979: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3980: FND_MSG_PUB.Count_And_Get(
3981: p_encoded => FND_API.G_FALSE,
3982: p_count => x_msg_count,
3983: p_data => x_msg_data);
3984:

Line 3989: FND_MSG_PUB.ADD;

3985: WHEN OTHERS THEN
3986: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3987: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
3988: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
3989: FND_MSG_PUB.ADD;
3990: FND_MSG_PUB.Count_And_Get(
3991: p_encoded => FND_API.G_FALSE,
3992: p_count => x_msg_count,
3993: p_data => x_msg_data);

Line 3990: FND_MSG_PUB.Count_And_Get(

3986: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3987: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
3988: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
3989: FND_MSG_PUB.ADD;
3990: FND_MSG_PUB.Count_And_Get(
3991: p_encoded => FND_API.G_FALSE,
3992: p_count => x_msg_count,
3993: p_data => x_msg_data);
3994: