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_PERSON_INFO_V2PUB dependencies on FND_MSG_PUB

Line 206: FND_MSG_PUB.ADD;

202: WHERE LANGUAGE_USE_REFERENCE_ID = p_person_language_rec.language_use_reference_id;
203:
204: FND_MESSAGE.SET_NAME('AR', 'HZ_API_DUPLICATE_COLUMN');
205: FND_MESSAGE.SET_TOKEN('COLUMN', 'language_use_reference_id');
206: FND_MSG_PUB.ADD;
207: RAISE FND_API.G_EXC_ERROR;
208:
209: EXCEPTION
210: WHEN NO_DATA_FOUND THEN

Line 391: FND_MSG_PUB.ADD;

387: )
388: THEN
389: FND_MESSAGE.SET_NAME('AR', 'HZ_API_RECORD_CHANGED');
390: FND_MESSAGE.SET_TOKEN('TABLE', 'HZ_PERSON_LANGUAGE');
391: FND_MSG_PUB.ADD;
392: RAISE FND_API.G_EXC_ERROR;
393: END IF;
394:
395: p_object_version_number := nvl(l_object_version_number, 1) + 1;

Line 402: FND_MSG_PUB.ADD;

398: WHEN NO_DATA_FOUND THEN
399: FND_MESSAGE.SET_NAME('AR', 'HZ_API_NO_RECORD');
400: FND_MESSAGE.SET_TOKEN('RECORD', 'HZ_PERSON_LANGUAGE');
401: FND_MESSAGE.SET_TOKEN('VALUE', NVL( TO_CHAR( p_person_language_rec.language_use_reference_id ), 'null' ) );
402: FND_MSG_PUB.ADD;
403: RAISE FND_API.G_EXC_ERROR;
404: END;
405:
406: -- 2820135, Added this new feature. Actually this should have been party of hzk

Line 566: FND_MSG_PUB.ADD;

562: WHERE CITIZENSHIP_ID = p_citizenship_rec.citizenship_id;
563:
564: FND_MESSAGE.SET_NAME('AR', 'HZ_API_DUPLICATE_COLUMN');
565: FND_MESSAGE.SET_TOKEN('COLUMN', 'citizenship_id');
566: FND_MSG_PUB.ADD;
567: RAISE FND_API.G_EXC_ERROR;
568:
569: EXCEPTION
570: WHEN NO_DATA_FOUND THEN

Line 670: FND_MSG_PUB.ADD;

666: )
667: THEN
668: FND_MESSAGE.SET_NAME('AR', 'HZ_API_RECORD_CHANGED');
669: FND_MESSAGE.SET_TOKEN('TABLE', 'HZ_CITIZENSHIP');
670: FND_MSG_PUB.ADD;
671: RAISE FND_API.G_EXC_ERROR;
672: END IF;
673:
674: p_object_version_number := nvl(l_object_version_number, 1) + 1;

Line 681: FND_MSG_PUB.ADD;

677: WHEN NO_DATA_FOUND THEN
678: FND_MESSAGE.SET_NAME('AR', 'HZ_API_NO_RECORD');
679: FND_MESSAGE.SET_TOKEN('RECORD', 'HZ_CITIZENSHIP');
680: FND_MESSAGE.SET_TOKEN('VALUE', NVL( TO_CHAR( p_citizenship_rec.citizenship_id ), 'null' ) );
681: FND_MSG_PUB.ADD;
682: RAISE FND_API.G_EXC_ERROR;
683: END;
684:
685: -- validate person interest record

Line 769: FND_MSG_PUB.ADD;

765: WHERE EDUCATION_ID = p_education_rec.education_id;
766:
767: FND_MESSAGE.SET_NAME('AR', 'HZ_API_DUPLICATE_COLUMN');
768: FND_MESSAGE.SET_TOKEN('COLUMN', 'education_id');
769: FND_MSG_PUB.ADD;
770: RAISE FND_API.G_EXC_ERROR;
771:
772: EXCEPTION
773: WHEN NO_DATA_FOUND THEN

Line 872: FND_MSG_PUB.ADD;

868: )
869: THEN
870: FND_MESSAGE.SET_NAME('AR', 'HZ_API_RECORD_CHANGED');
871: FND_MESSAGE.SET_TOKEN('TABLE', 'HZ_EDUCATION');
872: FND_MSG_PUB.ADD;
873: RAISE FND_API.G_EXC_ERROR;
874: END IF;
875:
876: p_object_version_number := nvl(l_object_version_number, 1) + 1;

Line 883: FND_MSG_PUB.ADD;

879: WHEN NO_DATA_FOUND THEN
880: FND_MESSAGE.SET_NAME('AR', 'HZ_API_NO_RECORD');
881: FND_MESSAGE.SET_TOKEN('RECORD', 'HZ_EDUCATION');
882: FND_MESSAGE.SET_TOKEN('VALUE', NVL( TO_CHAR( p_education_rec.education_id ), 'null' ) );
883: FND_MSG_PUB.ADD;
884: RAISE FND_API.G_EXC_ERROR;
885: END;
886:
887: -- validate person interest record

Line 969: FND_MSG_PUB.ADD;

965: WHERE EMPLOYMENT_HISTORY_ID = p_employment_history_rec.employment_history_id;
966:
967: FND_MESSAGE.SET_NAME('AR', 'HZ_API_DUPLICATE_COLUMN');
968: FND_MESSAGE.SET_TOKEN('COLUMN', 'employment_history_id');
969: FND_MSG_PUB.ADD;
970: RAISE FND_API.G_EXC_ERROR;
971:
972: EXCEPTION
973: WHEN NO_DATA_FOUND THEN

Line 1088: FND_MSG_PUB.ADD;

1084: )
1085: THEN
1086: FND_MESSAGE.SET_NAME('AR', 'HZ_API_RECORD_CHANGED');
1087: FND_MESSAGE.SET_TOKEN('TABLE', 'HZ_EMPLOYMENT_HISTORY');
1088: FND_MSG_PUB.ADD;
1089: RAISE FND_API.G_EXC_ERROR;
1090: END IF;
1091:
1092: p_object_version_number := nvl(l_object_version_number, 1) + 1;

Line 1099: FND_MSG_PUB.ADD;

1095: WHEN NO_DATA_FOUND THEN
1096: FND_MESSAGE.SET_NAME('AR', 'HZ_API_NO_RECORD');
1097: FND_MESSAGE.SET_TOKEN('RECORD', 'HZ_EMPLOYMENT_HISTORY');
1098: FND_MESSAGE.SET_TOKEN('VALUE', NVL( TO_CHAR( p_employment_history_rec.employment_history_id ), 'null' ) );
1099: FND_MSG_PUB.ADD;
1100: RAISE FND_API.G_EXC_ERROR;
1101: END;
1102:
1103: -- validate person employement_history record

Line 1199: FND_MSG_PUB.ADD;

1195: WHERE WORK_CLASS_ID = p_work_class_rec.work_class_id;
1196:
1197: FND_MESSAGE.SET_NAME('AR', 'HZ_API_DUPLICATE_COLUMN');
1198: FND_MESSAGE.SET_TOKEN('COLUMN', 'work_class_id');
1199: FND_MSG_PUB.ADD;
1200: RAISE FND_API.G_EXC_ERROR;
1201:
1202: EXCEPTION
1203: WHEN NO_DATA_FOUND THEN

Line 1301: FND_MSG_PUB.ADD;

1297: )
1298: THEN
1299: FND_MESSAGE.SET_NAME('AR', 'HZ_API_RECORD_CHANGED');
1300: FND_MESSAGE.SET_TOKEN('TABLE', 'HZ_WORK_CLASS');
1301: FND_MSG_PUB.ADD;
1302: RAISE FND_API.G_EXC_ERROR;
1303: END IF;
1304:
1305: p_object_version_number := nvl(l_object_version_number, 1) + 1;

Line 1312: FND_MSG_PUB.ADD;

1308: WHEN NO_DATA_FOUND THEN
1309: FND_MESSAGE.SET_NAME('AR', 'HZ_API_NO_RECORD');
1310: FND_MESSAGE.SET_TOKEN('RECORD', 'HZ_WORK_CLASS');
1311: FND_MESSAGE.SET_TOKEN('VALUE', NVL( TO_CHAR( p_work_class_rec.work_class_id ), 'null' ) );
1312: FND_MSG_PUB.ADD;
1313: RAISE FND_API.G_EXC_ERROR;
1314: END;
1315:
1316: -- validate work class record

Line 1394: FND_MSG_PUB.ADD;

1390: WHERE person_interest_ID = p_person_interest_rec.person_interest_id;
1391:
1392: FND_MESSAGE.SET_NAME('AR', 'HZ_API_DUPLICATE_COLUMN');
1393: FND_MESSAGE.SET_TOKEN('COLUMN', 'person_interest_id');
1394: FND_MSG_PUB.ADD;
1395: RAISE FND_API.G_EXC_ERROR;
1396:
1397: EXCEPTION
1398: WHEN NO_DATA_FOUND THEN

Line 1502: FND_MSG_PUB.ADD;

1498: )
1499: THEN
1500: FND_MESSAGE.SET_NAME('AR', 'HZ_API_RECORD_CHANGED');
1501: FND_MESSAGE.SET_TOKEN('TABLE', 'HZ_person_interest');
1502: FND_MSG_PUB.ADD;
1503: RAISE FND_API.G_EXC_ERROR;
1504: END IF;
1505:
1506: p_object_version_number := nvl(l_object_version_number, 1) + 1;

Line 1513: FND_MSG_PUB.ADD;

1509: WHEN NO_DATA_FOUND THEN
1510: FND_MESSAGE.SET_NAME('AR', 'HZ_API_NO_RECORD');
1511: FND_MESSAGE.SET_TOKEN('RECORD', 'HZ_person_interest');
1512: FND_MESSAGE.SET_TOKEN('VALUE', NVL( TO_CHAR( p_person_interest_rec.person_interest_id ), 'null' ) );
1513: FND_MSG_PUB.ADD;
1514: RAISE FND_API.G_EXC_ERROR;
1515: END;
1516:
1517: -- validate work class record

Line 1610: FND_MSG_PUB.initialize;

1606: SAVEPOINT create_person_language;
1607:
1608: --Initialize message list if p_init_msg_list is set to TRUE.
1609: IF FND_API.to_Boolean(p_init_msg_list) THEN
1610: FND_MSG_PUB.initialize;
1611: END IF;
1612:
1613: --Initialize API return status to success.
1614: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 1637: FND_MSG_PUB.Count_And_Get(

1633: END IF;
1634: END IF;
1635:
1636: --Standard call to get message count and if count is 1, get message info.
1637: FND_MSG_PUB.Count_And_Get(
1638: p_encoded => FND_API.G_FALSE,
1639: p_count => x_msg_count,
1640: p_data => x_msg_data);
1641:

Line 1646: FND_MSG_PUB.Count_And_Get(

1642: EXCEPTION
1643: WHEN FND_API.G_EXC_ERROR THEN
1644: ROLLBACK TO create_person_language;
1645: x_return_status := FND_API.G_RET_STS_ERROR;
1646: FND_MSG_PUB.Count_And_Get(
1647: p_encoded => FND_API.G_FALSE,
1648: p_count => x_msg_count,
1649: p_data => x_msg_data);
1650:

Line 1654: FND_MSG_PUB.Count_And_Get(

1650:
1651: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1652: ROLLBACK TO create_person_language;
1653: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1654: FND_MSG_PUB.Count_And_Get(
1655: p_encoded => FND_API.G_FALSE,
1656: p_count => x_msg_count,
1657: p_data => x_msg_data);
1658:

Line 1664: FND_MSG_PUB.ADD;

1660: ROLLBACK TO create_person_language;
1661: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1662: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
1663: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
1664: FND_MSG_PUB.ADD;
1665: FND_MSG_PUB.Count_And_Get(
1666: p_encoded => FND_API.G_FALSE,
1667: p_count => x_msg_count,
1668: p_data => x_msg_data);

Line 1665: FND_MSG_PUB.Count_And_Get(

1661: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1662: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
1663: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
1664: FND_MSG_PUB.ADD;
1665: FND_MSG_PUB.Count_And_Get(
1666: p_encoded => FND_API.G_FALSE,
1667: p_count => x_msg_count,
1668: p_data => x_msg_data);
1669:

Line 1724: FND_MSG_PUB.initialize;

1720: SAVEPOINT update_person_language;
1721:
1722: --Initialize message list if p_init_msg_list is set to TRUE.
1723: IF FND_API.to_Boolean(p_init_msg_list) THEN
1724: FND_MSG_PUB.initialize;
1725: END IF;
1726:
1727: --Initialize API return status to success.
1728: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 1765: FND_MSG_PUB.Count_And_Get(

1761: END IF;
1762: END IF;
1763:
1764: --Standard call to get message count and if count is 1, get message info.
1765: FND_MSG_PUB.Count_And_Get(
1766: p_encoded => FND_API.G_FALSE,
1767: p_count => x_msg_count,
1768: p_data => x_msg_data);
1769:

Line 1774: FND_MSG_PUB.Count_And_Get(

1770: EXCEPTION
1771: WHEN FND_API.G_EXC_ERROR THEN
1772: ROLLBACK TO update_person_language;
1773: x_return_status := FND_API.G_RET_STS_ERROR;
1774: FND_MSG_PUB.Count_And_Get(
1775: p_encoded => FND_API.G_FALSE,
1776: p_count => x_msg_count,
1777: p_data => x_msg_data);
1778:

Line 1782: FND_MSG_PUB.Count_And_Get(

1778:
1779: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1780: ROLLBACK TO update_person_language;
1781: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1782: FND_MSG_PUB.Count_And_Get(
1783: p_encoded => FND_API.G_FALSE,
1784: p_count => x_msg_count,
1785: p_data => x_msg_data);
1786:

Line 1792: FND_MSG_PUB.ADD;

1788: ROLLBACK TO update_person_language;
1789: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1790: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
1791: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
1792: FND_MSG_PUB.ADD;
1793: FND_MSG_PUB.Count_And_Get(
1794: p_encoded => FND_API.G_FALSE,
1795: p_count => x_msg_count,
1796: p_data => x_msg_data);

Line 1793: FND_MSG_PUB.Count_And_Get(

1789: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1790: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
1791: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
1792: FND_MSG_PUB.ADD;
1793: FND_MSG_PUB.Count_And_Get(
1794: p_encoded => FND_API.G_FALSE,
1795: p_count => x_msg_count,
1796: p_data => x_msg_data);
1797:

Line 1849: FND_MSG_PUB.initialize;

1845: BEGIN
1846:
1847: --Initialize message list if p_init_msg_list is set to TRUE.
1848: IF FND_API.to_Boolean(p_init_msg_list) THEN
1849: FND_MSG_PUB.initialize;
1850: END IF;
1851:
1852: --Initialize API return status to success.
1853: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 1860: FND_MSG_PUB.ADD;

1856: IF p_language_use_reference_id IS NULL OR
1857: p_language_use_reference_id = FND_API.G_MISS_NUM THEN
1858: FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_MISSING_COLUMN' );
1859: FND_MESSAGE.SET_TOKEN( 'COLUMN', 'language_use_reference_id' );
1860: FND_MSG_PUB.ADD;
1861: RAISE FND_API.G_EXC_ERROR;
1862: END IF;
1863:
1864: -- The x_person_language_rec.language_use_reference_id must be initiated to p_language_use_reference_id

Line 1883: FND_MSG_PUB.Count_And_Get(

1879: X_APPLICATION_ID => p_person_language_rec.application_id
1880: );
1881:
1882: --Standard call to get message count and if count is 1, get message info.
1883: FND_MSG_PUB.Count_And_Get(
1884: p_encoded => FND_API.G_FALSE,
1885: p_count => x_msg_count,
1886: p_data => x_msg_data );
1887:

Line 1892: FND_MSG_PUB.Count_And_Get(

1888: EXCEPTION
1889: WHEN FND_API.G_EXC_ERROR THEN
1890: x_return_status := FND_API.G_RET_STS_ERROR;
1891:
1892: FND_MSG_PUB.Count_And_Get(
1893: p_encoded => FND_API.G_FALSE,
1894: p_count => x_msg_count,
1895: p_data => x_msg_data );
1896: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 1899: FND_MSG_PUB.Count_And_Get(

1895: p_data => x_msg_data );
1896: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1897: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1898:
1899: FND_MSG_PUB.Count_And_Get(
1900: p_encoded => FND_API.G_FALSE,
1901: p_count => x_msg_count,
1902: p_data => x_msg_data );
1903:

Line 1909: FND_MSG_PUB.ADD;

1905: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1906:
1907: FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_OTHERS_EXCEP' );
1908: FND_MESSAGE.SET_TOKEN( 'ERROR' ,SQLERRM );
1909: FND_MSG_PUB.ADD;
1910:
1911: FND_MSG_PUB.Count_And_Get(
1912: p_encoded => FND_API.G_FALSE,
1913: p_count => x_msg_count,

Line 1911: FND_MSG_PUB.Count_And_Get(

1907: FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_OTHERS_EXCEP' );
1908: FND_MESSAGE.SET_TOKEN( 'ERROR' ,SQLERRM );
1909: FND_MSG_PUB.ADD;
1910:
1911: FND_MSG_PUB.Count_And_Get(
1912: p_encoded => FND_API.G_FALSE,
1913: p_count => x_msg_count,
1914: p_data => x_msg_data );
1915:

Line 1969: FND_MSG_PUB.initialize;

1965: SAVEPOINT create_citizenship;
1966:
1967: --Initialize message list if p_init_msg_list is set to TRUE.
1968: IF FND_API.to_Boolean(p_init_msg_list) THEN
1969: FND_MSG_PUB.initialize;
1970: END IF;
1971:
1972: --Initialize API return status to success.
1973: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 1997: FND_MSG_PUB.Count_And_Get(

1993: END IF;
1994:
1995:
1996: --Standard call to get message count and if count is 1, get message info.
1997: FND_MSG_PUB.Count_And_Get(
1998: p_encoded => FND_API.G_FALSE,
1999: p_count => x_msg_count,
2000: p_data => x_msg_data);
2001:

Line 2006: FND_MSG_PUB.Count_And_Get(

2002: EXCEPTION
2003: WHEN FND_API.G_EXC_ERROR THEN
2004: ROLLBACK TO create_citizenship;
2005: x_return_status := FND_API.G_RET_STS_ERROR;
2006: FND_MSG_PUB.Count_And_Get(
2007: p_encoded => FND_API.G_FALSE,
2008: p_count => x_msg_count,
2009: p_data => x_msg_data);
2010:

Line 2014: FND_MSG_PUB.Count_And_Get(

2010:
2011: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2012: ROLLBACK TO create_citizenship;
2013: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2014: FND_MSG_PUB.Count_And_Get(
2015: p_encoded => FND_API.G_FALSE,
2016: p_count => x_msg_count,
2017: p_data => x_msg_data);
2018:

Line 2024: FND_MSG_PUB.ADD;

2020: ROLLBACK TO create_citizenship;
2021: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2022: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
2023: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
2024: FND_MSG_PUB.ADD;
2025: FND_MSG_PUB.Count_And_Get(
2026: p_encoded => FND_API.G_FALSE,
2027: p_count => x_msg_count,
2028: p_data => x_msg_data);

Line 2025: FND_MSG_PUB.Count_And_Get(

2021: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2022: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
2023: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
2024: FND_MSG_PUB.ADD;
2025: FND_MSG_PUB.Count_And_Get(
2026: p_encoded => FND_API.G_FALSE,
2027: p_count => x_msg_count,
2028: p_data => x_msg_data);
2029:

Line 2084: FND_MSG_PUB.initialize;

2080: SAVEPOINT update_citizenship;
2081:
2082: --Initialize message list if p_init_msg_list is set to TRUE.
2083: IF FND_API.to_Boolean(p_init_msg_list) THEN
2084: FND_MSG_PUB.initialize;
2085: END IF;
2086:
2087: --Initialize API return status to success.
2088: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 2126: FND_MSG_PUB.Count_And_Get(

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

Line 2135: FND_MSG_PUB.Count_And_Get(

2131: EXCEPTION
2132: WHEN FND_API.G_EXC_ERROR THEN
2133: ROLLBACK TO update_citizenship;
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 2143: FND_MSG_PUB.Count_And_Get(

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

Line 2153: FND_MSG_PUB.ADD;

2149: ROLLBACK TO update_citizenship;
2150: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2151: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
2152: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
2153: FND_MSG_PUB.ADD;
2154: FND_MSG_PUB.Count_And_Get(
2155: p_encoded => FND_API.G_FALSE,
2156: p_count => x_msg_count,
2157: p_data => x_msg_data);

Line 2154: FND_MSG_PUB.Count_And_Get(

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

Line 2209: FND_MSG_PUB.initialize;

2205: BEGIN
2206:
2207: --Initialize message list if p_init_msg_list is set to TRUE.
2208: IF FND_API.to_Boolean(p_init_msg_list) THEN
2209: FND_MSG_PUB.initialize;
2210: END IF;
2211:
2212: --Initialize API return status to success.
2213: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 2220: FND_MSG_PUB.ADD;

2216: IF p_citizenship_id IS NULL OR
2217: p_citizenship_id = FND_API.G_MISS_NUM THEN
2218: FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_MISSING_COLUMN' );
2219: FND_MESSAGE.SET_TOKEN( 'COLUMN', 'citizenship_id' );
2220: FND_MSG_PUB.ADD;
2221: RAISE FND_API.G_EXC_ERROR;
2222: END IF;
2223:
2224: -- The x_citizenship_rec.citizenship_id must be initiated to x_citizenship_id

Line 2244: FND_MSG_PUB.Count_And_Get(

2240:
2241: );
2242:
2243: --Standard call to get message count and if count is 1, get message info.
2244: FND_MSG_PUB.Count_And_Get(
2245: p_encoded => FND_API.G_FALSE,
2246: p_count => x_msg_count,
2247: p_data => x_msg_data );
2248:

Line 2253: FND_MSG_PUB.Count_And_Get(

2249: EXCEPTION
2250: WHEN FND_API.G_EXC_ERROR THEN
2251: x_return_status := FND_API.G_RET_STS_ERROR;
2252:
2253: FND_MSG_PUB.Count_And_Get(
2254: p_encoded => FND_API.G_FALSE,
2255: p_count => x_msg_count,
2256: p_data => x_msg_data );
2257: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 2260: FND_MSG_PUB.Count_And_Get(

2256: p_data => x_msg_data );
2257: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2258: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2259:
2260: FND_MSG_PUB.Count_And_Get(
2261: p_encoded => FND_API.G_FALSE,
2262: p_count => x_msg_count,
2263: p_data => x_msg_data );
2264:

Line 2270: FND_MSG_PUB.ADD;

2266: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2267:
2268: FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_OTHERS_EXCEP' );
2269: FND_MESSAGE.SET_TOKEN( 'ERROR' ,SQLERRM );
2270: FND_MSG_PUB.ADD;
2271:
2272: FND_MSG_PUB.Count_And_Get(
2273: p_encoded => FND_API.G_FALSE,
2274: p_count => x_msg_count,

Line 2272: FND_MSG_PUB.Count_And_Get(

2268: FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_OTHERS_EXCEP' );
2269: FND_MESSAGE.SET_TOKEN( 'ERROR' ,SQLERRM );
2270: FND_MSG_PUB.ADD;
2271:
2272: FND_MSG_PUB.Count_And_Get(
2273: p_encoded => FND_API.G_FALSE,
2274: p_count => x_msg_count,
2275: p_data => x_msg_data );
2276:

Line 2331: FND_MSG_PUB.initialize;

2327: SAVEPOINT create_education;
2328:
2329: --Initialize message list if p_init_msg_list is set to TRUE.
2330: IF FND_API.to_Boolean(p_init_msg_list) THEN
2331: FND_MSG_PUB.initialize;
2332: END IF;
2333:
2334: --Initialize API return status to success.
2335: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 2360: FND_MSG_PUB.Count_And_Get(

2356: END IF;
2357:
2358:
2359: --Standard call to get message count and if count is 1, get message info.
2360: FND_MSG_PUB.Count_And_Get(
2361: p_encoded => FND_API.G_FALSE,
2362: p_count => x_msg_count,
2363: p_data => x_msg_data);
2364:

Line 2369: FND_MSG_PUB.Count_And_Get(

2365: EXCEPTION
2366: WHEN FND_API.G_EXC_ERROR THEN
2367: ROLLBACK TO create_education;
2368: x_return_status := FND_API.G_RET_STS_ERROR;
2369: FND_MSG_PUB.Count_And_Get(
2370: p_encoded => FND_API.G_FALSE,
2371: p_count => x_msg_count,
2372: p_data => x_msg_data);
2373:

Line 2377: FND_MSG_PUB.Count_And_Get(

2373:
2374: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2375: ROLLBACK TO create_education;
2376: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2377: FND_MSG_PUB.Count_And_Get(
2378: p_encoded => FND_API.G_FALSE,
2379: p_count => x_msg_count,
2380: p_data => x_msg_data);
2381:

Line 2387: FND_MSG_PUB.ADD;

2383: ROLLBACK TO create_education;
2384: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2385: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
2386: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
2387: FND_MSG_PUB.ADD;
2388: FND_MSG_PUB.Count_And_Get(
2389: p_encoded => FND_API.G_FALSE,
2390: p_count => x_msg_count,
2391: p_data => x_msg_data);

Line 2388: FND_MSG_PUB.Count_And_Get(

2384: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2385: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
2386: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
2387: FND_MSG_PUB.ADD;
2388: FND_MSG_PUB.Count_And_Get(
2389: p_encoded => FND_API.G_FALSE,
2390: p_count => x_msg_count,
2391: p_data => x_msg_data);
2392:

Line 2447: FND_MSG_PUB.initialize;

2443: SAVEPOINT update_education;
2444:
2445: --Initialize message list if p_init_msg_list is set to TRUE.
2446: IF FND_API.to_Boolean(p_init_msg_list) THEN
2447: FND_MSG_PUB.initialize;
2448: END IF;
2449:
2450: --Initialize API return status to success.
2451: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 2488: FND_MSG_PUB.Count_And_Get(

2484: END IF;
2485: END IF;
2486:
2487: --Standard call to get message count and if count is 1, get message info.
2488: FND_MSG_PUB.Count_And_Get(
2489: p_encoded => FND_API.G_FALSE,
2490: p_count => x_msg_count,
2491: p_data => x_msg_data);
2492:

Line 2497: FND_MSG_PUB.Count_And_Get(

2493: EXCEPTION
2494: WHEN FND_API.G_EXC_ERROR THEN
2495: ROLLBACK TO update_education;
2496: x_return_status := FND_API.G_RET_STS_ERROR;
2497: FND_MSG_PUB.Count_And_Get(
2498: p_encoded => FND_API.G_FALSE,
2499: p_count => x_msg_count,
2500: p_data => x_msg_data);
2501:

Line 2505: FND_MSG_PUB.Count_And_Get(

2501:
2502: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2503: ROLLBACK TO update_education;
2504: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2505: FND_MSG_PUB.Count_And_Get(
2506: p_encoded => FND_API.G_FALSE,
2507: p_count => x_msg_count,
2508: p_data => x_msg_data);
2509:

Line 2515: FND_MSG_PUB.ADD;

2511: ROLLBACK TO update_education;
2512: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2513: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
2514: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
2515: FND_MSG_PUB.ADD;
2516: FND_MSG_PUB.Count_And_Get(
2517: p_encoded => FND_API.G_FALSE,
2518: p_count => x_msg_count,
2519: p_data => x_msg_data);

Line 2516: FND_MSG_PUB.Count_And_Get(

2512: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2513: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
2514: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
2515: FND_MSG_PUB.ADD;
2516: FND_MSG_PUB.Count_And_Get(
2517: p_encoded => FND_API.G_FALSE,
2518: p_count => x_msg_count,
2519: p_data => x_msg_data);
2520:

Line 2572: FND_MSG_PUB.initialize;

2568: BEGIN
2569:
2570: --Initialize message list if p_init_msg_list is set to TRUE.
2571: IF FND_API.to_Boolean(p_init_msg_list) THEN
2572: FND_MSG_PUB.initialize;
2573: END IF;
2574:
2575: --Initialize API return status to success.
2576: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 2583: FND_MSG_PUB.ADD;

2579: IF p_education_id IS NULL OR
2580: p_education_id = FND_API.G_MISS_NUM THEN
2581: FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_MISSING_COLUMN' );
2582: FND_MESSAGE.SET_TOKEN( 'COLUMN', 'education_id' );
2583: FND_MSG_PUB.ADD;
2584: RAISE FND_API.G_EXC_ERROR;
2585: END IF;
2586:
2587: -- The x_education_rec.education_id must be initiated to p_education_id

Line 2608: FND_MSG_PUB.Count_And_Get(

2604:
2605: );
2606:
2607: --Standard call to get message count and if count is 1, get message info.
2608: FND_MSG_PUB.Count_And_Get(
2609: p_encoded => FND_API.G_FALSE,
2610: p_count => x_msg_count,
2611: p_data => x_msg_data );
2612:

Line 2617: FND_MSG_PUB.Count_And_Get(

2613: EXCEPTION
2614: WHEN FND_API.G_EXC_ERROR THEN
2615: x_return_status := FND_API.G_RET_STS_ERROR;
2616:
2617: FND_MSG_PUB.Count_And_Get(
2618: p_encoded => FND_API.G_FALSE,
2619: p_count => x_msg_count,
2620: p_data => x_msg_data );
2621: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 2624: FND_MSG_PUB.Count_And_Get(

2620: p_data => x_msg_data );
2621: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2622: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2623:
2624: FND_MSG_PUB.Count_And_Get(
2625: p_encoded => FND_API.G_FALSE,
2626: p_count => x_msg_count,
2627: p_data => x_msg_data );
2628:

Line 2634: FND_MSG_PUB.ADD;

2630: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2631:
2632: FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_OTHERS_EXCEP' );
2633: FND_MESSAGE.SET_TOKEN( 'ERROR' ,SQLERRM );
2634: FND_MSG_PUB.ADD;
2635:
2636: FND_MSG_PUB.Count_And_Get(
2637: p_encoded => FND_API.G_FALSE,
2638: p_count => x_msg_count,

Line 2636: FND_MSG_PUB.Count_And_Get(

2632: FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_OTHERS_EXCEP' );
2633: FND_MESSAGE.SET_TOKEN( 'ERROR' ,SQLERRM );
2634: FND_MSG_PUB.ADD;
2635:
2636: FND_MSG_PUB.Count_And_Get(
2637: p_encoded => FND_API.G_FALSE,
2638: p_count => x_msg_count,
2639: p_data => x_msg_data );
2640:

Line 2694: FND_MSG_PUB.initialize;

2690: SAVEPOINT create_employment_history;
2691:
2692: --Initialize message list if p_init_msg_list is set to TRUE.
2693: IF FND_API.to_Boolean(p_init_msg_list) THEN
2694: FND_MSG_PUB.initialize;
2695: END IF;
2696:
2697: --Initialize API return status to success.
2698: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 2721: FND_MSG_PUB.Count_And_Get(

2717: END IF;
2718: END IF;
2719:
2720: --Standard call to get message count and if count is 1, get message info.
2721: FND_MSG_PUB.Count_And_Get(
2722: p_encoded => FND_API.G_FALSE,
2723: p_count => x_msg_count,
2724: p_data => x_msg_data);
2725:

Line 2730: FND_MSG_PUB.Count_And_Get(

2726: EXCEPTION
2727: WHEN FND_API.G_EXC_ERROR THEN
2728: ROLLBACK TO create_employment_history;
2729: x_return_status := FND_API.G_RET_STS_ERROR;
2730: FND_MSG_PUB.Count_And_Get(
2731: p_encoded => FND_API.G_FALSE,
2732: p_count => x_msg_count,
2733: p_data => x_msg_data);
2734:

Line 2738: FND_MSG_PUB.Count_And_Get(

2734:
2735: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2736: ROLLBACK TO create_employment_history;
2737: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2738: FND_MSG_PUB.Count_And_Get(
2739: p_encoded => FND_API.G_FALSE,
2740: p_count => x_msg_count,
2741: p_data => x_msg_data);
2742:

Line 2748: FND_MSG_PUB.ADD;

2744: ROLLBACK TO create_employment_history;
2745: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2746: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
2747: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
2748: FND_MSG_PUB.ADD;
2749: FND_MSG_PUB.Count_And_Get(
2750: p_encoded => FND_API.G_FALSE,
2751: p_count => x_msg_count,
2752: p_data => x_msg_data);

Line 2749: FND_MSG_PUB.Count_And_Get(

2745: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2746: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
2747: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
2748: FND_MSG_PUB.ADD;
2749: FND_MSG_PUB.Count_And_Get(
2750: p_encoded => FND_API.G_FALSE,
2751: p_count => x_msg_count,
2752: p_data => x_msg_data);
2753:

Line 2808: FND_MSG_PUB.initialize;

2804: SAVEPOINT update_employment_history;
2805:
2806: --Initialize message list if p_init_msg_list is set to TRUE.
2807: IF FND_API.to_Boolean(p_init_msg_list) THEN
2808: FND_MSG_PUB.initialize;
2809: END IF;
2810:
2811: --Initialize API return status to success.
2812: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 2849: FND_MSG_PUB.Count_And_Get(

2845: END IF;
2846: END IF;
2847:
2848: --Standard call to get message count and if count is 1, get message info.
2849: FND_MSG_PUB.Count_And_Get(
2850: p_encoded => FND_API.G_FALSE,
2851: p_count => x_msg_count,
2852: p_data => x_msg_data);
2853:

Line 2858: FND_MSG_PUB.Count_And_Get(

2854: EXCEPTION
2855: WHEN FND_API.G_EXC_ERROR THEN
2856: ROLLBACK TO update_employment_history;
2857: x_return_status := FND_API.G_RET_STS_ERROR;
2858: FND_MSG_PUB.Count_And_Get(
2859: p_encoded => FND_API.G_FALSE,
2860: p_count => x_msg_count,
2861: p_data => x_msg_data);
2862:

Line 2866: FND_MSG_PUB.Count_And_Get(

2862:
2863: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2864: ROLLBACK TO update_employment_history;
2865: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2866: FND_MSG_PUB.Count_And_Get(
2867: p_encoded => FND_API.G_FALSE,
2868: p_count => x_msg_count,
2869: p_data => x_msg_data);
2870:

Line 2876: FND_MSG_PUB.ADD;

2872: ROLLBACK TO update_employment_history;
2873: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2874: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
2875: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
2876: FND_MSG_PUB.ADD;
2877: FND_MSG_PUB.Count_And_Get(
2878: p_encoded => FND_API.G_FALSE,
2879: p_count => x_msg_count,
2880: p_data => x_msg_data);

Line 2877: FND_MSG_PUB.Count_And_Get(

2873: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2874: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
2875: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
2876: FND_MSG_PUB.ADD;
2877: FND_MSG_PUB.Count_And_Get(
2878: p_encoded => FND_API.G_FALSE,
2879: p_count => x_msg_count,
2880: p_data => x_msg_data);
2881:

Line 2932: FND_MSG_PUB.initialize;

2928: BEGIN
2929:
2930: --Initialize message list if p_init_msg_list is set to TRUE.
2931: IF FND_API.to_Boolean(p_init_msg_list) THEN
2932: FND_MSG_PUB.initialize;
2933: END IF;
2934:
2935: --Initialize API return status to success.
2936: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 2943: FND_MSG_PUB.ADD;

2939: IF p_employment_history_id IS NULL OR
2940: p_employment_history_id = FND_API.G_MISS_NUM THEN
2941: FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_MISSING_COLUMN' );
2942: FND_MESSAGE.SET_TOKEN( 'COLUMN', 'employment_history_id' );
2943: FND_MSG_PUB.ADD;
2944: RAISE FND_API.G_EXC_ERROR;
2945: END IF;
2946:
2947: -- The x_employment_history_rec.employment_history_id must be initiated to p_employment_history_id

Line 2979: FND_MSG_PUB.Count_And_Get(

2975: X_COMMENTS => x_employment_history_rec.comments
2976: );
2977:
2978: --Standard call to get message count and if count is 1, get message info.
2979: FND_MSG_PUB.Count_And_Get(
2980: p_encoded => FND_API.G_FALSE,
2981: p_count => x_msg_count,
2982: p_data => x_msg_data );
2983:

Line 2988: FND_MSG_PUB.Count_And_Get(

2984: EXCEPTION
2985: WHEN FND_API.G_EXC_ERROR THEN
2986: x_return_status := FND_API.G_RET_STS_ERROR;
2987:
2988: FND_MSG_PUB.Count_And_Get(
2989: p_encoded => FND_API.G_FALSE,
2990: p_count => x_msg_count,
2991: p_data => x_msg_data );
2992: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 2995: FND_MSG_PUB.Count_And_Get(

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

Line 3005: FND_MSG_PUB.ADD;

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

Line 3007: FND_MSG_PUB.Count_And_Get(

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

Line 3065: FND_MSG_PUB.initialize;

3061: SAVEPOINT create_work_class;
3062:
3063: --Initialize message list if p_init_msg_list is set to TRUE.
3064: IF FND_API.to_Boolean(p_init_msg_list) THEN
3065: FND_MSG_PUB.initialize;
3066: END IF;
3067:
3068: --Initialize API return status to success.
3069: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 3093: FND_MSG_PUB.Count_And_Get(

3089: END IF;
3090: END IF;
3091:
3092: --Standard call to get message count and if count is 1, get message info.
3093: FND_MSG_PUB.Count_And_Get(
3094: p_encoded => FND_API.G_FALSE,
3095: p_count => x_msg_count,
3096: p_data => x_msg_data);
3097:

Line 3102: FND_MSG_PUB.Count_And_Get(

3098: EXCEPTION
3099: WHEN FND_API.G_EXC_ERROR THEN
3100: ROLLBACK TO create_work_class;
3101: x_return_status := FND_API.G_RET_STS_ERROR;
3102: FND_MSG_PUB.Count_And_Get(
3103: p_encoded => FND_API.G_FALSE,
3104: p_count => x_msg_count,
3105: p_data => x_msg_data);
3106:

Line 3110: FND_MSG_PUB.Count_And_Get(

3106:
3107: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3108: ROLLBACK TO create_work_class;
3109: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3110: FND_MSG_PUB.Count_And_Get(
3111: p_encoded => FND_API.G_FALSE,
3112: p_count => x_msg_count,
3113: p_data => x_msg_data);
3114:

Line 3120: FND_MSG_PUB.ADD;

3116: ROLLBACK TO create_work_class;
3117: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3118: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
3119: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
3120: FND_MSG_PUB.ADD;
3121: FND_MSG_PUB.Count_And_Get(
3122: p_encoded => FND_API.G_FALSE,
3123: p_count => x_msg_count,
3124: p_data => x_msg_data);

Line 3121: FND_MSG_PUB.Count_And_Get(

3117: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3118: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
3119: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
3120: FND_MSG_PUB.ADD;
3121: FND_MSG_PUB.Count_And_Get(
3122: p_encoded => FND_API.G_FALSE,
3123: p_count => x_msg_count,
3124: p_data => x_msg_data);
3125:

Line 3180: FND_MSG_PUB.initialize;

3176: SAVEPOINT update_work_class;
3177:
3178: --Initialize message list if p_init_msg_list is set to TRUE.
3179: IF FND_API.to_Boolean(p_init_msg_list) THEN
3180: FND_MSG_PUB.initialize;
3181: END IF;
3182:
3183: --Initialize API return status to success.
3184: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 3221: FND_MSG_PUB.Count_And_Get(

3217: END IF;
3218: END IF;
3219:
3220: --Standard call to get message count and if count is 1, get message info.
3221: FND_MSG_PUB.Count_And_Get(
3222: p_encoded => FND_API.G_FALSE,
3223: p_count => x_msg_count,
3224: p_data => x_msg_data);
3225:

Line 3230: FND_MSG_PUB.Count_And_Get(

3226: EXCEPTION
3227: WHEN FND_API.G_EXC_ERROR THEN
3228: ROLLBACK TO update_work_class;
3229: x_return_status := FND_API.G_RET_STS_ERROR;
3230: FND_MSG_PUB.Count_And_Get(
3231: p_encoded => FND_API.G_FALSE,
3232: p_count => x_msg_count,
3233: p_data => x_msg_data);
3234:

Line 3238: FND_MSG_PUB.Count_And_Get(

3234:
3235: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3236: ROLLBACK TO update_work_class;
3237: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3238: FND_MSG_PUB.Count_And_Get(
3239: p_encoded => FND_API.G_FALSE,
3240: p_count => x_msg_count,
3241: p_data => x_msg_data);
3242:

Line 3248: FND_MSG_PUB.ADD;

3244: ROLLBACK TO update_work_class;
3245: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3246: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
3247: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
3248: FND_MSG_PUB.ADD;
3249: FND_MSG_PUB.Count_And_Get(
3250: p_encoded => FND_API.G_FALSE,
3251: p_count => x_msg_count,
3252: p_data => x_msg_data);

Line 3249: FND_MSG_PUB.Count_And_Get(

3245: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3246: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
3247: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
3248: FND_MSG_PUB.ADD;
3249: FND_MSG_PUB.Count_And_Get(
3250: p_encoded => FND_API.G_FALSE,
3251: p_count => x_msg_count,
3252: p_data => x_msg_data);
3253:

Line 3304: FND_MSG_PUB.initialize;

3300: BEGIN
3301:
3302: --Initialize message list if p_init_msg_list is set to TRUE.
3303: IF FND_API.to_Boolean(p_init_msg_list) THEN
3304: FND_MSG_PUB.initialize;
3305: END IF;
3306:
3307: --Initialize API return status to success.
3308: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 3315: FND_MSG_PUB.ADD;

3311: IF p_work_class_id IS NULL OR
3312: p_work_class_id = FND_API.G_MISS_NUM THEN
3313: FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_MISSING_COLUMN' );
3314: FND_MESSAGE.SET_TOKEN( 'COLUMN', 'work_class_id' );
3315: FND_MSG_PUB.ADD;
3316: RAISE FND_API.G_EXC_ERROR;
3317: END IF;
3318:
3319: -- The x_work_class_rec.work_class_id must be initiated to p_work_class_id

Line 3334: FND_MSG_PUB.Count_And_Get(

3330: x_created_by_module => x_work_class_rec.created_by_module
3331: );
3332:
3333: --Standard call to get message count and if count is 1, get message info.
3334: FND_MSG_PUB.Count_And_Get(
3335: p_encoded => FND_API.G_FALSE,
3336: p_count => x_msg_count,
3337: p_data => x_msg_data );
3338:

Line 3343: FND_MSG_PUB.Count_And_Get(

3339: EXCEPTION
3340: WHEN FND_API.G_EXC_ERROR THEN
3341: x_return_status := FND_API.G_RET_STS_ERROR;
3342:
3343: FND_MSG_PUB.Count_And_Get(
3344: p_encoded => FND_API.G_FALSE,
3345: p_count => x_msg_count,
3346: p_data => x_msg_data );
3347: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 3350: FND_MSG_PUB.Count_And_Get(

3346: p_data => x_msg_data );
3347: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3348: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3349:
3350: FND_MSG_PUB.Count_And_Get(
3351: p_encoded => FND_API.G_FALSE,
3352: p_count => x_msg_count,
3353: p_data => x_msg_data );
3354:

Line 3360: FND_MSG_PUB.ADD;

3356: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3357:
3358: FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_OTHERS_EXCEP' );
3359: FND_MESSAGE.SET_TOKEN( 'ERROR' ,SQLERRM );
3360: FND_MSG_PUB.ADD;
3361:
3362: FND_MSG_PUB.Count_And_Get(
3363: p_encoded => FND_API.G_FALSE,
3364: p_count => x_msg_count,

Line 3362: FND_MSG_PUB.Count_And_Get(

3358: FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_OTHERS_EXCEP' );
3359: FND_MESSAGE.SET_TOKEN( 'ERROR' ,SQLERRM );
3360: FND_MSG_PUB.ADD;
3361:
3362: FND_MSG_PUB.Count_And_Get(
3363: p_encoded => FND_API.G_FALSE,
3364: p_count => x_msg_count,
3365: p_data => x_msg_data );
3366:

Line 3420: FND_MSG_PUB.initialize;

3416: SAVEPOINT create_person_interest;
3417:
3418: --Initialize message list if p_init_msg_list is set to TRUE.
3419: IF FND_API.to_Boolean(p_init_msg_list) THEN
3420: FND_MSG_PUB.initialize;
3421: END IF;
3422:
3423: --Initialize API return status to success.
3424: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 3447: FND_MSG_PUB.Count_And_Get(

3443: END IF;
3444: END IF;
3445:
3446: --Standard call to get message count and if count is 1, get message info.
3447: FND_MSG_PUB.Count_And_Get(
3448: p_encoded => FND_API.G_FALSE,
3449: p_count => x_msg_count,
3450: p_data => x_msg_data);
3451:

Line 3456: FND_MSG_PUB.Count_And_Get(

3452: EXCEPTION
3453: WHEN FND_API.G_EXC_ERROR THEN
3454: ROLLBACK TO create_person_interest;
3455: x_return_status := FND_API.G_RET_STS_ERROR;
3456: FND_MSG_PUB.Count_And_Get(
3457: p_encoded => FND_API.G_FALSE,
3458: p_count => x_msg_count,
3459: p_data => x_msg_data);
3460:

Line 3464: FND_MSG_PUB.Count_And_Get(

3460:
3461: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3462: ROLLBACK TO create_person_interest;
3463: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3464: FND_MSG_PUB.Count_And_Get(
3465: p_encoded => FND_API.G_FALSE,
3466: p_count => x_msg_count,
3467: p_data => x_msg_data);
3468:

Line 3474: FND_MSG_PUB.ADD;

3470: ROLLBACK TO create_person_interest;
3471: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3472: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
3473: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
3474: FND_MSG_PUB.ADD;
3475: FND_MSG_PUB.Count_And_Get(
3476: p_encoded => FND_API.G_FALSE,
3477: p_count => x_msg_count,
3478: p_data => x_msg_data);

Line 3475: FND_MSG_PUB.Count_And_Get(

3471: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3472: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
3473: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
3474: FND_MSG_PUB.ADD;
3475: FND_MSG_PUB.Count_And_Get(
3476: p_encoded => FND_API.G_FALSE,
3477: p_count => x_msg_count,
3478: p_data => x_msg_data);
3479:

Line 3534: FND_MSG_PUB.initialize;

3530: SAVEPOINT update_person_interest;
3531:
3532: --Initialize message list if p_init_msg_list is set to TRUE.
3533: IF FND_API.to_Boolean(p_init_msg_list) THEN
3534: FND_MSG_PUB.initialize;
3535: END IF;
3536:
3537: --Initialize API return status to success.
3538: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 3575: FND_MSG_PUB.Count_And_Get(

3571: END IF;
3572: END IF;
3573:
3574: --Standard call to get message count and if count is 1, get message info.
3575: FND_MSG_PUB.Count_And_Get(
3576: p_encoded => FND_API.G_FALSE,
3577: p_count => x_msg_count,
3578: p_data => x_msg_data);
3579:

Line 3584: FND_MSG_PUB.Count_And_Get(

3580: EXCEPTION
3581: WHEN FND_API.G_EXC_ERROR THEN
3582: ROLLBACK TO update_person_interest;
3583: x_return_status := FND_API.G_RET_STS_ERROR;
3584: FND_MSG_PUB.Count_And_Get(
3585: p_encoded => FND_API.G_FALSE,
3586: p_count => x_msg_count,
3587: p_data => x_msg_data);
3588:

Line 3592: FND_MSG_PUB.Count_And_Get(

3588:
3589: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3590: ROLLBACK TO update_person_interest;
3591: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3592: FND_MSG_PUB.Count_And_Get(
3593: p_encoded => FND_API.G_FALSE,
3594: p_count => x_msg_count,
3595: p_data => x_msg_data);
3596:

Line 3602: FND_MSG_PUB.ADD;

3598: ROLLBACK TO update_person_interest;
3599: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3600: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
3601: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
3602: FND_MSG_PUB.ADD;
3603: FND_MSG_PUB.Count_And_Get(
3604: p_encoded => FND_API.G_FALSE,
3605: p_count => x_msg_count,
3606: p_data => x_msg_data);

Line 3603: FND_MSG_PUB.Count_And_Get(

3599: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3600: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
3601: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
3602: FND_MSG_PUB.ADD;
3603: FND_MSG_PUB.Count_And_Get(
3604: p_encoded => FND_API.G_FALSE,
3605: p_count => x_msg_count,
3606: p_data => x_msg_data);
3607:

Line 3658: FND_MSG_PUB.initialize;

3654: BEGIN
3655:
3656: --Initialize message list if p_init_msg_list is set to TRUE.
3657: IF FND_API.to_Boolean(p_init_msg_list) THEN
3658: FND_MSG_PUB.initialize;
3659: END IF;
3660:
3661: --Initialize API return status to success.
3662: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 3669: FND_MSG_PUB.ADD;

3665: IF p_person_interest_id IS NULL OR
3666: p_person_interest_id = FND_API.G_MISS_NUM THEN
3667: FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_MISSING_COLUMN' );
3668: FND_MESSAGE.SET_TOKEN( 'COLUMN', 'person_interest_id' );
3669: FND_MSG_PUB.ADD;
3670: RAISE FND_API.G_EXC_ERROR;
3671: END IF;
3672:
3673: -- The x_person_interest_rec.person_interest_id must be initiated to p_person_interest_id

Line 3695: FND_MSG_PUB.Count_And_Get(

3691: x_created_by_module => x_person_interest_rec.created_by_module
3692: );
3693:
3694: --Standard call to get message count and if count is 1, get message info.
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 3704: FND_MSG_PUB.Count_And_Get(

3700: EXCEPTION
3701: WHEN FND_API.G_EXC_ERROR THEN
3702: x_return_status := FND_API.G_RET_STS_ERROR;
3703:
3704: FND_MSG_PUB.Count_And_Get(
3705: p_encoded => FND_API.G_FALSE,
3706: p_count => x_msg_count,
3707: p_data => x_msg_data );
3708: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 3711: FND_MSG_PUB.Count_And_Get(

3707: p_data => x_msg_data );
3708: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3709: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3710:
3711: FND_MSG_PUB.Count_And_Get(
3712: p_encoded => FND_API.G_FALSE,
3713: p_count => x_msg_count,
3714: p_data => x_msg_data );
3715:

Line 3721: FND_MSG_PUB.ADD;

3717: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3718:
3719: FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_OTHERS_EXCEP' );
3720: FND_MESSAGE.SET_TOKEN( 'ERROR' ,SQLERRM );
3721: FND_MSG_PUB.ADD;
3722:
3723: FND_MSG_PUB.Count_And_Get(
3724: p_encoded => FND_API.G_FALSE,
3725: p_count => x_msg_count,

Line 3723: FND_MSG_PUB.Count_And_Get(

3719: FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_OTHERS_EXCEP' );
3720: FND_MESSAGE.SET_TOKEN( 'ERROR' ,SQLERRM );
3721: FND_MSG_PUB.ADD;
3722:
3723: FND_MSG_PUB.Count_And_Get(
3724: p_encoded => FND_API.G_FALSE,
3725: p_count => x_msg_count,
3726: p_data => x_msg_data );
3727: