[Home] [Help]
715: HZ_UTILITY_V2PUB.G_CREATED_BY_MODULE := p_created_by_module;
716: END IF;
717:
718: -- Debug info.
719: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
720: hz_utility_v2pub.debug(p_message=>'do_create_person_bo(+)',
721: p_prefix=>l_debug_prefix,
722: p_msg_level=>fnd_log.level_procedure);
723: END IF;
718: -- Debug info.
719: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
720: hz_utility_v2pub.debug(p_message=>'do_create_person_bo(+)',
721: p_prefix=>l_debug_prefix,
722: p_msg_level=>fnd_log.level_procedure);
723: END IF;
724:
725: -- Base on p_validate_bo_flag, check the completeness of business objects
726: IF(p_validate_bo_flag = FND_API.G_TRUE) THEN
1049: HZ_UTILITY_V2PUB.G_CALLING_API := NULL;
1050: HZ_UTILITY_V2PUB.G_CREATED_BY_MODULE := NULL;
1051:
1052: -- Debug info.
1053: IF fnd_log.level_exception>=fnd_log.g_current_runtime_level THEN
1054: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
1055: p_msg_data=>x_msg_data,
1056: p_msg_type=>'WARNING',
1057: p_msg_level=>fnd_log.level_exception);
1053: IF fnd_log.level_exception>=fnd_log.g_current_runtime_level THEN
1054: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
1055: p_msg_data=>x_msg_data,
1056: p_msg_type=>'WARNING',
1057: p_msg_level=>fnd_log.level_exception);
1058: END IF;
1059: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1060: hz_utility_v2pub.debug(p_message=>'do_create_person_bo(-)',
1061: p_prefix=>l_debug_prefix,
1055: p_msg_data=>x_msg_data,
1056: p_msg_type=>'WARNING',
1057: p_msg_level=>fnd_log.level_exception);
1058: END IF;
1059: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1060: hz_utility_v2pub.debug(p_message=>'do_create_person_bo(-)',
1061: p_prefix=>l_debug_prefix,
1062: p_msg_level=>fnd_log.level_procedure);
1063: END IF;
1058: END IF;
1059: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1060: hz_utility_v2pub.debug(p_message=>'do_create_person_bo(-)',
1061: p_prefix=>l_debug_prefix,
1062: p_msg_level=>fnd_log.level_procedure);
1063: END IF;
1064:
1065: EXCEPTION
1066: WHEN fnd_api.g_exc_error THEN
1080: p_count => x_msg_count,
1081: p_data => x_msg_data);
1082:
1083: -- Debug info.
1084: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
1085: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
1086: p_msg_data=>x_msg_data,
1087: p_msg_type=>'ERROR',
1088: p_msg_level=>fnd_log.level_error);
1084: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
1085: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
1086: p_msg_data=>x_msg_data,
1087: p_msg_type=>'ERROR',
1088: p_msg_level=>fnd_log.level_error);
1089: END IF;
1090: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1091: hz_utility_v2pub.debug(p_message=>'do_create_person_bo(-)',
1092: p_prefix=>l_debug_prefix,
1086: p_msg_data=>x_msg_data,
1087: p_msg_type=>'ERROR',
1088: p_msg_level=>fnd_log.level_error);
1089: END IF;
1090: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1091: hz_utility_v2pub.debug(p_message=>'do_create_person_bo(-)',
1092: p_prefix=>l_debug_prefix,
1093: p_msg_level=>fnd_log.level_procedure);
1094: END IF;
1089: END IF;
1090: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1091: hz_utility_v2pub.debug(p_message=>'do_create_person_bo(-)',
1092: p_prefix=>l_debug_prefix,
1093: p_msg_level=>fnd_log.level_procedure);
1094: END IF;
1095:
1096: WHEN fnd_api.g_exc_unexpected_error THEN
1097: ROLLBACK TO do_create_person_bo_pub;
1110: p_count => x_msg_count,
1111: p_data => x_msg_data);
1112:
1113: -- Debug info.
1114: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
1115: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
1116: p_msg_data=>x_msg_data,
1117: p_msg_type=>'UNEXPECTED ERROR',
1118: p_msg_level=>fnd_log.level_error);
1114: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
1115: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
1116: p_msg_data=>x_msg_data,
1117: p_msg_type=>'UNEXPECTED ERROR',
1118: p_msg_level=>fnd_log.level_error);
1119: END IF;
1120: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1121: hz_utility_v2pub.debug(p_message=>'do_create_person_bo(-)',
1122: p_prefix=>l_debug_prefix,
1116: p_msg_data=>x_msg_data,
1117: p_msg_type=>'UNEXPECTED ERROR',
1118: p_msg_level=>fnd_log.level_error);
1119: END IF;
1120: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1121: hz_utility_v2pub.debug(p_message=>'do_create_person_bo(-)',
1122: p_prefix=>l_debug_prefix,
1123: p_msg_level=>fnd_log.level_procedure);
1124: END IF;
1119: END IF;
1120: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1121: hz_utility_v2pub.debug(p_message=>'do_create_person_bo(-)',
1122: p_prefix=>l_debug_prefix,
1123: p_msg_level=>fnd_log.level_procedure);
1124: END IF;
1125:
1126: WHEN OTHERS THEN
1127: ROLLBACK TO do_create_person_bo_pub;
1144: p_count => x_msg_count,
1145: p_data => x_msg_data);
1146:
1147: -- Debug info.
1148: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
1149: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
1150: p_msg_data=>x_msg_data,
1151: p_msg_type=>'SQL ERROR',
1152: p_msg_level=>fnd_log.level_error);
1148: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
1149: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
1150: p_msg_data=>x_msg_data,
1151: p_msg_type=>'SQL ERROR',
1152: p_msg_level=>fnd_log.level_error);
1153: END IF;
1154: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1155: hz_utility_v2pub.debug(p_message=>'do_create_person_bo(-)',
1156: p_prefix=>l_debug_prefix,
1150: p_msg_data=>x_msg_data,
1151: p_msg_type=>'SQL ERROR',
1152: p_msg_level=>fnd_log.level_error);
1153: END IF;
1154: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1155: hz_utility_v2pub.debug(p_message=>'do_create_person_bo(-)',
1156: p_prefix=>l_debug_prefix,
1157: p_msg_level=>fnd_log.level_procedure);
1158: END IF;
1153: END IF;
1154: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1155: hz_utility_v2pub.debug(p_message=>'do_create_person_bo(-)',
1156: p_prefix=>l_debug_prefix,
1157: p_msg_level=>fnd_log.level_procedure);
1158: END IF;
1159: END do_create_person_bo;
1160:
1161: PROCEDURE create_person_bo(
1288: HZ_UTILITY_V2PUB.G_CREATED_BY_MODULE := p_created_by_module;
1289: END IF;
1290:
1291: -- Debug info.
1292: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1293: hz_utility_v2pub.debug(p_message=>'do_update_person_bo(+)',
1294: p_prefix=>l_debug_prefix,
1295: p_msg_level=>fnd_log.level_procedure);
1296: END IF;
1291: -- Debug info.
1292: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1293: hz_utility_v2pub.debug(p_message=>'do_update_person_bo(+)',
1294: p_prefix=>l_debug_prefix,
1295: p_msg_level=>fnd_log.level_procedure);
1296: END IF;
1297:
1298: x_person_id := p_person_obj.person_id;
1299: x_person_os := p_person_obj.orig_system;
1643: HZ_UTILITY_V2PUB.G_CALLING_API := NULL;
1644: HZ_UTILITY_V2PUB.G_CREATED_BY_MODULE := NULL;
1645:
1646: -- Debug info.
1647: IF fnd_log.level_exception>=fnd_log.g_current_runtime_level THEN
1648: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
1649: p_msg_data=>x_msg_data,
1650: p_msg_type=>'WARNING',
1651: p_msg_level=>fnd_log.level_exception);
1647: IF fnd_log.level_exception>=fnd_log.g_current_runtime_level THEN
1648: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
1649: p_msg_data=>x_msg_data,
1650: p_msg_type=>'WARNING',
1651: p_msg_level=>fnd_log.level_exception);
1652: END IF;
1653: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1654: hz_utility_v2pub.debug(p_message=>'do_update_person_bo(-)',
1655: p_prefix=>l_debug_prefix,
1649: p_msg_data=>x_msg_data,
1650: p_msg_type=>'WARNING',
1651: p_msg_level=>fnd_log.level_exception);
1652: END IF;
1653: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1654: hz_utility_v2pub.debug(p_message=>'do_update_person_bo(-)',
1655: p_prefix=>l_debug_prefix,
1656: p_msg_level=>fnd_log.level_procedure);
1657: END IF;
1652: END IF;
1653: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1654: hz_utility_v2pub.debug(p_message=>'do_update_person_bo(-)',
1655: p_prefix=>l_debug_prefix,
1656: p_msg_level=>fnd_log.level_procedure);
1657: END IF;
1658: EXCEPTION
1659: WHEN fnd_api.g_exc_error THEN
1660: ROLLBACK TO do_update_person_bo_pub;
1673: p_count => x_msg_count,
1674: p_data => x_msg_data);
1675:
1676: -- Debug info.
1677: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
1678: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
1679: p_msg_data=>x_msg_data,
1680: p_msg_type=>'ERROR',
1681: p_msg_level=>fnd_log.level_error);
1677: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
1678: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
1679: p_msg_data=>x_msg_data,
1680: p_msg_type=>'ERROR',
1681: p_msg_level=>fnd_log.level_error);
1682: END IF;
1683: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1684: hz_utility_v2pub.debug(p_message=>'do_update_person_bo(-)',
1685: p_prefix=>l_debug_prefix,
1679: p_msg_data=>x_msg_data,
1680: p_msg_type=>'ERROR',
1681: p_msg_level=>fnd_log.level_error);
1682: END IF;
1683: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1684: hz_utility_v2pub.debug(p_message=>'do_update_person_bo(-)',
1685: p_prefix=>l_debug_prefix,
1686: p_msg_level=>fnd_log.level_procedure);
1687: END IF;
1682: END IF;
1683: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1684: hz_utility_v2pub.debug(p_message=>'do_update_person_bo(-)',
1685: p_prefix=>l_debug_prefix,
1686: p_msg_level=>fnd_log.level_procedure);
1687: END IF;
1688:
1689:
1690: WHEN fnd_api.g_exc_unexpected_error THEN
1704: p_count => x_msg_count,
1705: p_data => x_msg_data);
1706:
1707: -- Debug info.
1708: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
1709: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
1710: p_msg_data=>x_msg_data,
1711: p_msg_type=>'UNEXPECTED ERROR',
1712: p_msg_level=>fnd_log.level_error);
1708: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
1709: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
1710: p_msg_data=>x_msg_data,
1711: p_msg_type=>'UNEXPECTED ERROR',
1712: p_msg_level=>fnd_log.level_error);
1713: END IF;
1714: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1715: hz_utility_v2pub.debug(p_message=>'do_update_person_bo(-)',
1716: p_prefix=>l_debug_prefix,
1710: p_msg_data=>x_msg_data,
1711: p_msg_type=>'UNEXPECTED ERROR',
1712: p_msg_level=>fnd_log.level_error);
1713: END IF;
1714: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1715: hz_utility_v2pub.debug(p_message=>'do_update_person_bo(-)',
1716: p_prefix=>l_debug_prefix,
1717: p_msg_level=>fnd_log.level_procedure);
1718: END IF;
1713: END IF;
1714: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1715: hz_utility_v2pub.debug(p_message=>'do_update_person_bo(-)',
1716: p_prefix=>l_debug_prefix,
1717: p_msg_level=>fnd_log.level_procedure);
1718: END IF;
1719: WHEN OTHERS THEN
1720: ROLLBACK TO do_update_person_bo_pub;
1721:
1737: p_count => x_msg_count,
1738: p_data => x_msg_data);
1739:
1740: -- Debug info.
1741: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
1742: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
1743: p_msg_data=>x_msg_data,
1744: p_msg_type=>'SQL ERROR',
1745: p_msg_level=>fnd_log.level_error);
1741: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
1742: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
1743: p_msg_data=>x_msg_data,
1744: p_msg_type=>'SQL ERROR',
1745: p_msg_level=>fnd_log.level_error);
1746: END IF;
1747: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1748: hz_utility_v2pub.debug(p_message=>'do_update_person_bo(-)',
1749: p_prefix=>l_debug_prefix,
1743: p_msg_data=>x_msg_data,
1744: p_msg_type=>'SQL ERROR',
1745: p_msg_level=>fnd_log.level_error);
1746: END IF;
1747: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1748: hz_utility_v2pub.debug(p_message=>'do_update_person_bo(-)',
1749: p_prefix=>l_debug_prefix,
1750: p_msg_level=>fnd_log.level_procedure);
1751: END IF;
1746: END IF;
1747: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1748: hz_utility_v2pub.debug(p_message=>'do_update_person_bo(-)',
1749: p_prefix=>l_debug_prefix,
1750: p_msg_level=>fnd_log.level_procedure);
1751: END IF;
1752: END do_update_person_bo;
1753:
1754: PROCEDURE update_person_bo(
1848: FND_MSG_PUB.initialize;
1849: END IF;
1850:
1851: -- Debug info.
1852: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1853: hz_utility_v2pub.debug(p_message=>'do_save_person_bo(+)',
1854: p_prefix=>l_debug_prefix,
1855: p_msg_level=>fnd_log.level_procedure);
1856: END IF;
1851: -- Debug info.
1852: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1853: hz_utility_v2pub.debug(p_message=>'do_save_person_bo(+)',
1854: p_prefix=>l_debug_prefix,
1855: p_msg_level=>fnd_log.level_procedure);
1856: END IF;
1857:
1858: x_person_id := p_person_obj.person_id;
1859: x_person_os := p_person_obj.orig_system;
1913: RAISE FND_API.G_EXC_ERROR;
1914: END IF;
1915:
1916: -- Debug info.
1917: IF fnd_log.level_exception>=fnd_log.g_current_runtime_level THEN
1918: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
1919: p_msg_data=>x_msg_data,
1920: p_msg_type=>'WARNING',
1921: p_msg_level=>fnd_log.level_exception);
1917: IF fnd_log.level_exception>=fnd_log.g_current_runtime_level THEN
1918: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
1919: p_msg_data=>x_msg_data,
1920: p_msg_type=>'WARNING',
1921: p_msg_level=>fnd_log.level_exception);
1922: END IF;
1923: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1924: hz_utility_v2pub.debug(p_message=>'do_save_person_bo(-)',
1925: p_prefix=>l_debug_prefix,
1919: p_msg_data=>x_msg_data,
1920: p_msg_type=>'WARNING',
1921: p_msg_level=>fnd_log.level_exception);
1922: END IF;
1923: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1924: hz_utility_v2pub.debug(p_message=>'do_save_person_bo(-)',
1925: p_prefix=>l_debug_prefix,
1926: p_msg_level=>fnd_log.level_procedure);
1927: END IF;
1922: END IF;
1923: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1924: hz_utility_v2pub.debug(p_message=>'do_save_person_bo(-)',
1925: p_prefix=>l_debug_prefix,
1926: p_msg_level=>fnd_log.level_procedure);
1927: END IF;
1928: EXCEPTION
1929: WHEN fnd_api.g_exc_error THEN
1930: x_return_status := fnd_api.g_ret_sts_error;
1933: p_count => x_msg_count,
1934: p_data => x_msg_data);
1935:
1936: -- Debug info.
1937: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
1938: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
1939: p_msg_data=>x_msg_data,
1940: p_msg_type=>'ERROR',
1941: p_msg_level=>fnd_log.level_error);
1937: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
1938: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
1939: p_msg_data=>x_msg_data,
1940: p_msg_type=>'ERROR',
1941: p_msg_level=>fnd_log.level_error);
1942: END IF;
1943: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1944: hz_utility_v2pub.debug(p_message=>'do_save_person_bo(-)',
1945: p_prefix=>l_debug_prefix,
1939: p_msg_data=>x_msg_data,
1940: p_msg_type=>'ERROR',
1941: p_msg_level=>fnd_log.level_error);
1942: END IF;
1943: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1944: hz_utility_v2pub.debug(p_message=>'do_save_person_bo(-)',
1945: p_prefix=>l_debug_prefix,
1946: p_msg_level=>fnd_log.level_procedure);
1947: END IF;
1942: END IF;
1943: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1944: hz_utility_v2pub.debug(p_message=>'do_save_person_bo(-)',
1945: p_prefix=>l_debug_prefix,
1946: p_msg_level=>fnd_log.level_procedure);
1947: END IF;
1948:
1949: WHEN fnd_api.g_exc_unexpected_error THEN
1950: x_return_status := fnd_api.g_ret_sts_unexp_error;
1953: p_count => x_msg_count,
1954: p_data => x_msg_data);
1955:
1956: -- Debug info.
1957: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
1958: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
1959: p_msg_data=>x_msg_data,
1960: p_msg_type=>'UNEXPECTED ERROR',
1961: p_msg_level=>fnd_log.level_error);
1957: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
1958: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
1959: p_msg_data=>x_msg_data,
1960: p_msg_type=>'UNEXPECTED ERROR',
1961: p_msg_level=>fnd_log.level_error);
1962: END IF;
1963: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1964: hz_utility_v2pub.debug(p_message=>'do_save_person_bo(-)',
1965: p_prefix=>l_debug_prefix,
1959: p_msg_data=>x_msg_data,
1960: p_msg_type=>'UNEXPECTED ERROR',
1961: p_msg_level=>fnd_log.level_error);
1962: END IF;
1963: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1964: hz_utility_v2pub.debug(p_message=>'do_save_person_bo(-)',
1965: p_prefix=>l_debug_prefix,
1966: p_msg_level=>fnd_log.level_procedure);
1967: END IF;
1962: END IF;
1963: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1964: hz_utility_v2pub.debug(p_message=>'do_save_person_bo(-)',
1965: p_prefix=>l_debug_prefix,
1966: p_msg_level=>fnd_log.level_procedure);
1967: END IF;
1968: WHEN OTHERS THEN
1969: x_return_status := fnd_api.g_ret_sts_unexp_error;
1970:
1976: p_count => x_msg_count,
1977: p_data => x_msg_data);
1978:
1979: -- Debug info.
1980: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
1981: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
1982: p_msg_data=>x_msg_data,
1983: p_msg_type=>'SQL ERROR',
1984: p_msg_level=>fnd_log.level_error);
1980: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
1981: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
1982: p_msg_data=>x_msg_data,
1983: p_msg_type=>'SQL ERROR',
1984: p_msg_level=>fnd_log.level_error);
1985: END IF;
1986: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1987: hz_utility_v2pub.debug(p_message=>'do_save_person_bo(-)',
1988: p_prefix=>l_debug_prefix,
1982: p_msg_data=>x_msg_data,
1983: p_msg_type=>'SQL ERROR',
1984: p_msg_level=>fnd_log.level_error);
1985: END IF;
1986: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1987: hz_utility_v2pub.debug(p_message=>'do_save_person_bo(-)',
1988: p_prefix=>l_debug_prefix,
1989: p_msg_level=>fnd_log.level_procedure);
1990: END IF;
1985: END IF;
1986: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1987: hz_utility_v2pub.debug(p_message=>'do_save_person_bo(-)',
1988: p_prefix=>l_debug_prefix,
1989: p_msg_level=>fnd_log.level_procedure);
1990: END IF;
1991: END do_save_person_bo;
1992:
1993: PROCEDURE save_person_bo(
2117: -- initialize API return status to success.
2118: x_return_status := FND_API.G_RET_STS_SUCCESS;
2119:
2120: -- Debug info.
2121: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2122: hz_utility_v2pub.debug(p_message=>'create_person_info(+)',
2123: p_prefix=>l_debug_prefix,
2124: p_msg_level=>fnd_log.level_procedure);
2125: END IF;
2120: -- Debug info.
2121: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2122: hz_utility_v2pub.debug(p_message=>'create_person_info(+)',
2123: p_prefix=>l_debug_prefix,
2124: p_msg_level=>fnd_log.level_procedure);
2125: END IF;
2126:
2127: --------------------------------
2128: -- Assign person language record
2143: x_msg_data => x_msg_data
2144: );
2145:
2146: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2147: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2148: hz_utility_v2pub.debug(p_message=>'Create Person Language - Error occurred at hz_person_bo_pub.create_person_info, person id: '||p_person_id,
2149: p_prefix=>l_debug_prefix,
2150: p_msg_level=>fnd_log.level_procedure);
2151: END IF;
2146: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2147: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2148: hz_utility_v2pub.debug(p_message=>'Create Person Language - Error occurred at hz_person_bo_pub.create_person_info, person id: '||p_person_id,
2149: p_prefix=>l_debug_prefix,
2150: p_msg_level=>fnd_log.level_procedure);
2151: END IF;
2152: FND_MESSAGE.SET_NAME('AR', 'HZ_API_PROPAGATE_ENTITY_ERROR');
2153: FND_MESSAGE.SET_TOKEN('ENTITY', 'HZ_PERSON_LANGUAGE');
2154: FND_MSG_PUB.ADD;
2179: x_msg_data => x_msg_data
2180: );
2181:
2182: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2183: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2184: hz_utility_v2pub.debug(p_message=>'Create Education - Error occurred at hz_person_bo_pub.create_person_info, person id: '||p_person_id,
2185: p_prefix=>l_debug_prefix,
2186: p_msg_level=>fnd_log.level_procedure);
2187: END IF;
2182: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2183: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2184: hz_utility_v2pub.debug(p_message=>'Create Education - Error occurred at hz_person_bo_pub.create_person_info, person id: '||p_person_id,
2185: p_prefix=>l_debug_prefix,
2186: p_msg_level=>fnd_log.level_procedure);
2187: END IF;
2188: FND_MESSAGE.SET_NAME('AR', 'HZ_API_PROPAGATE_ENTITY_ERROR');
2189: FND_MESSAGE.SET_TOKEN('ENTITY', 'HZ_EDUCATION');
2190: FND_MSG_PUB.ADD;
2215: x_msg_data => x_msg_data
2216: );
2217:
2218: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2219: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2220: hz_utility_v2pub.debug(p_message=>'Create Citizenship - Error occurred at hz_person_bo_pub.create_person_info, person id: '||p_person_id,
2221: p_prefix=>l_debug_prefix,
2222: p_msg_level=>fnd_log.level_procedure);
2223: END IF;
2218: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2219: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2220: hz_utility_v2pub.debug(p_message=>'Create Citizenship - Error occurred at hz_person_bo_pub.create_person_info, person id: '||p_person_id,
2221: p_prefix=>l_debug_prefix,
2222: p_msg_level=>fnd_log.level_procedure);
2223: END IF;
2224: FND_MESSAGE.SET_NAME('AR', 'HZ_API_PROPAGATE_ENTITY_ERROR');
2225: FND_MESSAGE.SET_TOKEN('ENTITY', 'HZ_CITIZENSHIP');
2226: FND_MSG_PUB.ADD;
2251: x_msg_data => x_msg_data
2252: );
2253:
2254: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2255: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2256: hz_utility_v2pub.debug(p_message=>'Create Employment History - Error occurred at hz_person_bo_pub.create_person_info, person id: '||p_person_id,
2257: p_prefix=>l_debug_prefix,
2258: p_msg_level=>fnd_log.level_procedure);
2259: END IF;
2254: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2255: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2256: hz_utility_v2pub.debug(p_message=>'Create Employment History - Error occurred at hz_person_bo_pub.create_person_info, person id: '||p_person_id,
2257: p_prefix=>l_debug_prefix,
2258: p_msg_level=>fnd_log.level_procedure);
2259: END IF;
2260: FND_MESSAGE.SET_NAME('AR', 'HZ_API_PROPAGATE_STRUCT_ERROR');
2261: FND_MESSAGE.SET_TOKEN('STRUCTURE', 'HZ_EMPLOYMENT_HISTORY');
2262: FND_MSG_PUB.ADD;
2286: x_msg_data => x_msg_data
2287: );
2288:
2289: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2290: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2291: hz_utility_v2pub.debug(p_message=>'Create Work Class - Error occurred at hz_person_bo_pub.create_person_info, employ_hist_id: '||l_dummy_id,
2292: p_prefix=>l_debug_prefix,
2293: p_msg_level=>fnd_log.level_procedure);
2294: END IF;
2289: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2290: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2291: hz_utility_v2pub.debug(p_message=>'Create Work Class - Error occurred at hz_person_bo_pub.create_person_info, employ_hist_id: '||l_dummy_id,
2292: p_prefix=>l_debug_prefix,
2293: p_msg_level=>fnd_log.level_procedure);
2294: END IF;
2295: FND_MESSAGE.SET_NAME('AR', 'HZ_API_PROPAGATE_ENTITY_ERROR');
2296: FND_MESSAGE.SET_TOKEN('ENTITY', 'HZ_WORK_CLASS');
2297: FND_MSG_PUB.ADD;
2325: x_msg_data => x_msg_data
2326: );
2327:
2328: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2329: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2330: hz_utility_v2pub.debug(p_message=>'Create Person Interest - Error occurred at hz_person_bo_pub.create_person_info, person id: '||p_person_id,
2331: p_prefix=>l_debug_prefix,
2332: p_msg_level=>fnd_log.level_procedure);
2333: END IF;
2328: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2329: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2330: hz_utility_v2pub.debug(p_message=>'Create Person Interest - Error occurred at hz_person_bo_pub.create_person_info, person id: '||p_person_id,
2331: p_prefix=>l_debug_prefix,
2332: p_msg_level=>fnd_log.level_procedure);
2333: END IF;
2334: FND_MESSAGE.SET_NAME('AR', 'HZ_API_PROPAGATE_ENTITY_ERROR');
2335: FND_MESSAGE.SET_TOKEN('ENTITY', 'HZ_PERSON_INTEREST');
2336: FND_MSG_PUB.ADD;
2342: END LOOP;
2343: END IF;
2344:
2345: -- Debug info.
2346: IF fnd_log.level_exception>=fnd_log.g_current_runtime_level THEN
2347: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
2348: p_msg_data=>x_msg_data,
2349: p_msg_type=>'WARNING',
2350: p_msg_level=>fnd_log.level_exception);
2346: IF fnd_log.level_exception>=fnd_log.g_current_runtime_level THEN
2347: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
2348: p_msg_data=>x_msg_data,
2349: p_msg_type=>'WARNING',
2350: p_msg_level=>fnd_log.level_exception);
2351: END IF;
2352: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2353: hz_utility_v2pub.debug(p_message=>'create_person_info(-)',
2354: p_prefix=>l_debug_prefix,
2348: p_msg_data=>x_msg_data,
2349: p_msg_type=>'WARNING',
2350: p_msg_level=>fnd_log.level_exception);
2351: END IF;
2352: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2353: hz_utility_v2pub.debug(p_message=>'create_person_info(-)',
2354: p_prefix=>l_debug_prefix,
2355: p_msg_level=>fnd_log.level_procedure);
2356: END IF;
2351: END IF;
2352: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2353: hz_utility_v2pub.debug(p_message=>'create_person_info(-)',
2354: p_prefix=>l_debug_prefix,
2355: p_msg_level=>fnd_log.level_procedure);
2356: END IF;
2357: EXCEPTION
2358: WHEN fnd_api.g_exc_error THEN
2359: ROLLBACK TO create_person_info_pub;
2363: p_count => x_msg_count,
2364: p_data => x_msg_data);
2365:
2366: -- Debug info.
2367: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
2368: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
2369: p_msg_data=>x_msg_data,
2370: p_msg_type=>'ERROR',
2371: p_msg_level=>fnd_log.level_error);
2367: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
2368: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
2369: p_msg_data=>x_msg_data,
2370: p_msg_type=>'ERROR',
2371: p_msg_level=>fnd_log.level_error);
2372: END IF;
2373: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2374: hz_utility_v2pub.debug(p_message=>'create_person_info(-)',
2375: p_prefix=>l_debug_prefix,
2369: p_msg_data=>x_msg_data,
2370: p_msg_type=>'ERROR',
2371: p_msg_level=>fnd_log.level_error);
2372: END IF;
2373: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2374: hz_utility_v2pub.debug(p_message=>'create_person_info(-)',
2375: p_prefix=>l_debug_prefix,
2376: p_msg_level=>fnd_log.level_procedure);
2377: END IF;
2372: END IF;
2373: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2374: hz_utility_v2pub.debug(p_message=>'create_person_info(-)',
2375: p_prefix=>l_debug_prefix,
2376: p_msg_level=>fnd_log.level_procedure);
2377: END IF;
2378: WHEN fnd_api.g_exc_unexpected_error THEN
2379: ROLLBACK TO create_person_info_pub;
2380: x_return_status := fnd_api.g_ret_sts_unexp_error;
2383: p_count => x_msg_count,
2384: p_data => x_msg_data);
2385:
2386: -- Debug info.
2387: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
2388: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
2389: p_msg_data=>x_msg_data,
2390: p_msg_type=>'UNEXPECTED ERROR',
2391: p_msg_level=>fnd_log.level_error);
2387: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
2388: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
2389: p_msg_data=>x_msg_data,
2390: p_msg_type=>'UNEXPECTED ERROR',
2391: p_msg_level=>fnd_log.level_error);
2392: END IF;
2393: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2394: hz_utility_v2pub.debug(p_message=>'create_person_info(-)',
2395: p_prefix=>l_debug_prefix,
2389: p_msg_data=>x_msg_data,
2390: p_msg_type=>'UNEXPECTED ERROR',
2391: p_msg_level=>fnd_log.level_error);
2392: END IF;
2393: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2394: hz_utility_v2pub.debug(p_message=>'create_person_info(-)',
2395: p_prefix=>l_debug_prefix,
2396: p_msg_level=>fnd_log.level_procedure);
2397: END IF;
2392: END IF;
2393: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2394: hz_utility_v2pub.debug(p_message=>'create_person_info(-)',
2395: p_prefix=>l_debug_prefix,
2396: p_msg_level=>fnd_log.level_procedure);
2397: END IF;
2398:
2399: WHEN OTHERS THEN
2400: ROLLBACK TO create_person_info_pub;
2408: p_count => x_msg_count,
2409: p_data => x_msg_data);
2410:
2411: -- Debug info.
2412: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
2413: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
2414: p_msg_data=>x_msg_data,
2415: p_msg_type=>'SQL ERROR',
2416: p_msg_level=>fnd_log.level_error);
2412: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
2413: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
2414: p_msg_data=>x_msg_data,
2415: p_msg_type=>'SQL ERROR',
2416: p_msg_level=>fnd_log.level_error);
2417: END IF;
2418: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2419: hz_utility_v2pub.debug(p_message=>'create_person_info(-)',
2420: p_prefix=>l_debug_prefix,
2414: p_msg_data=>x_msg_data,
2415: p_msg_type=>'SQL ERROR',
2416: p_msg_level=>fnd_log.level_error);
2417: END IF;
2418: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2419: hz_utility_v2pub.debug(p_message=>'create_person_info(-)',
2420: p_prefix=>l_debug_prefix,
2421: p_msg_level=>fnd_log.level_procedure);
2422: END IF;
2417: END IF;
2418: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2419: hz_utility_v2pub.debug(p_message=>'create_person_info(-)',
2420: p_prefix=>l_debug_prefix,
2421: p_msg_level=>fnd_log.level_procedure);
2422: END IF;
2423: END create_person_info;
2424:
2425: -- PRIVATE PROCEDURE save_person_info
2480: -- initialize API return status to success.
2481: x_return_status := FND_API.G_RET_STS_SUCCESS;
2482:
2483: -- Debug info.
2484: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2485: hz_utility_v2pub.debug(p_message=>'save_person_info(+)',
2486: p_prefix=>l_debug_prefix,
2487: p_msg_level=>fnd_log.level_procedure);
2488: END IF;
2483: -- Debug info.
2484: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2485: hz_utility_v2pub.debug(p_message=>'save_person_info(+)',
2486: p_prefix=>l_debug_prefix,
2487: p_msg_level=>fnd_log.level_procedure);
2488: END IF;
2489:
2490: --------------------------------
2491: -- Create/Update person language
2505: x_object_version_number => l_ovn
2506: );
2507:
2508: IF(l_ovn = -1) THEN
2509: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2510: hz_utility_v2pub.debug(p_message=>'Save Person Language - Error occurred at hz_person_bo_pub.check_language_op, person id: '||p_person_id||' '||' ovn:'||l_ovn,
2511: p_prefix=>l_debug_prefix,
2512: p_msg_level=>fnd_log.level_procedure);
2513: END IF;
2508: IF(l_ovn = -1) THEN
2509: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2510: hz_utility_v2pub.debug(p_message=>'Save Person Language - Error occurred at hz_person_bo_pub.check_language_op, person id: '||p_person_id||' '||' ovn:'||l_ovn,
2511: p_prefix=>l_debug_prefix,
2512: p_msg_level=>fnd_log.level_procedure);
2513: END IF;
2514: FND_MESSAGE.SET_NAME('AR', 'HZ_API_INVALID_ID');
2515: FND_MSG_PUB.ADD;
2516: FND_MESSAGE.SET_NAME('AR', 'HZ_API_PROPAGATE_ENTITY_ERROR');
2544: -- assign person language_use_reference_id
2545: p_language_obj(i).language_use_reference_id := l_person_lang_rec.language_use_reference_id;
2546: END IF;
2547: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2548: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2549: hz_utility_v2pub.debug(p_message=>'Save Person Language - Error occurred at hz_person_bo_pub.save_person_info, person id: '||p_person_id||' '||' ovn:'||l_ovn,
2550: p_prefix=>l_debug_prefix,
2551: p_msg_level=>fnd_log.level_procedure);
2552: END IF;
2547: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2548: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2549: hz_utility_v2pub.debug(p_message=>'Save Person Language - Error occurred at hz_person_bo_pub.save_person_info, person id: '||p_person_id||' '||' ovn:'||l_ovn,
2550: p_prefix=>l_debug_prefix,
2551: p_msg_level=>fnd_log.level_procedure);
2552: END IF;
2553: FND_MESSAGE.SET_NAME('AR', 'HZ_API_PROPAGATE_ENTITY_ERROR');
2554: FND_MESSAGE.SET_TOKEN('ENTITY', 'HZ_PERSON_LANGUAGE');
2555: FND_MSG_PUB.ADD;
2578: x_object_version_number => l_ovn
2579: );
2580:
2581: IF(l_ovn = -1) THEN
2582: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2583: hz_utility_v2pub.debug(p_message=>'Save Education - Error occurred at hz_person_bo_pub.check_education_op, person id: '||p_person_id||' '||' ovn:'||l_ovn,
2584: p_prefix=>l_debug_prefix,
2585: p_msg_level=>fnd_log.level_procedure);
2586: END IF;
2581: IF(l_ovn = -1) THEN
2582: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2583: hz_utility_v2pub.debug(p_message=>'Save Education - Error occurred at hz_person_bo_pub.check_education_op, person id: '||p_person_id||' '||' ovn:'||l_ovn,
2584: p_prefix=>l_debug_prefix,
2585: p_msg_level=>fnd_log.level_procedure);
2586: END IF;
2587: FND_MESSAGE.SET_NAME('AR', 'HZ_API_INVALID_ID');
2588: FND_MSG_PUB.ADD;
2589: FND_MESSAGE.SET_NAME('AR', 'HZ_API_PROPAGATE_ENTITY_ERROR');
2617: -- assign education_id
2618: p_education_obj(i).education_id := l_education_rec.education_id;
2619: END IF;
2620: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2621: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2622: hz_utility_v2pub.debug(p_message=>'Save Education - Error occurred at hz_person_bo_pub.save_person_info, person id: '||p_person_id||' '||' ovn:'||l_ovn,
2623: p_prefix=>l_debug_prefix,
2624: p_msg_level=>fnd_log.level_procedure);
2625: END IF;
2620: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2621: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2622: hz_utility_v2pub.debug(p_message=>'Save Education - Error occurred at hz_person_bo_pub.save_person_info, person id: '||p_person_id||' '||' ovn:'||l_ovn,
2623: p_prefix=>l_debug_prefix,
2624: p_msg_level=>fnd_log.level_procedure);
2625: END IF;
2626: FND_MESSAGE.SET_NAME('AR', 'HZ_API_PROPAGATE_ENTITY_ERROR');
2627: FND_MESSAGE.SET_TOKEN('ENTITY', 'HZ_EDUCATION');
2628: FND_MSG_PUB.ADD;
2649: x_object_version_number => l_ovn
2650: );
2651:
2652: IF(l_ovn = -1) THEN
2653: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2654: hz_utility_v2pub.debug(p_message=>'Save Citizenship - Error occurred at hz_person_bo_pub.check_citizenship_op, person id: '||p_person_id||' '||' ovn:'||l_ovn,
2655: p_prefix=>l_debug_prefix,
2656: p_msg_level=>fnd_log.level_procedure);
2657: END IF;
2652: IF(l_ovn = -1) THEN
2653: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2654: hz_utility_v2pub.debug(p_message=>'Save Citizenship - Error occurred at hz_person_bo_pub.check_citizenship_op, person id: '||p_person_id||' '||' ovn:'||l_ovn,
2655: p_prefix=>l_debug_prefix,
2656: p_msg_level=>fnd_log.level_procedure);
2657: END IF;
2658: FND_MESSAGE.SET_NAME('AR', 'HZ_API_INVALID_ID');
2659: FND_MSG_PUB.ADD;
2660: FND_MESSAGE.SET_NAME('AR', 'HZ_API_PROPAGATE_ENTITY_ERROR');
2688: -- assign citizenship_id
2689: p_citizenship_obj(i).citizenship_id := l_citizenship_rec.citizenship_id;
2690: END IF;
2691: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2692: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2693: hz_utility_v2pub.debug(p_message=>'Save Citizenship - Error occurred at hz_person_bo_pub.save_person_info, person id: '||p_person_id||' '||' ovn:'||l_ovn,
2694: p_prefix=>l_debug_prefix,
2695: p_msg_level=>fnd_log.level_procedure);
2696: END IF;
2691: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2692: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2693: hz_utility_v2pub.debug(p_message=>'Save Citizenship - Error occurred at hz_person_bo_pub.save_person_info, person id: '||p_person_id||' '||' ovn:'||l_ovn,
2694: p_prefix=>l_debug_prefix,
2695: p_msg_level=>fnd_log.level_procedure);
2696: END IF;
2697: FND_MESSAGE.SET_NAME('AR', 'HZ_API_PROPAGATE_ENTITY_ERROR');
2698: FND_MESSAGE.SET_TOKEN('ENTITY', 'HZ_CITIZENSHIP');
2699: FND_MSG_PUB.ADD;
2722: x_object_version_number => l_ovn
2723: );
2724:
2725: IF(l_ovn = -1) THEN
2726: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2727: hz_utility_v2pub.debug(p_message=>'Save Employment History - Error occurred at hz_person_bo_pub.check_employ_hist_op, person id: '||p_person_id||' '||' ovn:'||l_ovn,
2728: p_prefix=>l_debug_prefix,
2729: p_msg_level=>fnd_log.level_procedure);
2730: END IF;
2725: IF(l_ovn = -1) THEN
2726: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2727: hz_utility_v2pub.debug(p_message=>'Save Employment History - Error occurred at hz_person_bo_pub.check_employ_hist_op, person id: '||p_person_id||' '||' ovn:'||l_ovn,
2728: p_prefix=>l_debug_prefix,
2729: p_msg_level=>fnd_log.level_procedure);
2730: END IF;
2731: FND_MESSAGE.SET_NAME('AR', 'HZ_API_INVALID_ID');
2732: FND_MSG_PUB.ADD;
2733: FND_MESSAGE.SET_NAME('AR', 'HZ_API_PROPAGATE_STRUCT_ERROR');
2762: -- assign employment_history_id
2763: p_employ_hist_obj(i).employment_history_id := l_dummy_id;
2764: END IF;
2765: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2766: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2767: hz_utility_v2pub.debug(p_message=>'Save Employment History - Error occurred at hz_person_bo_pub.save_person_info, person id: '||p_person_id||' '||' ovn:'||l_ovn,
2768: p_prefix=>l_debug_prefix,
2769: p_msg_level=>fnd_log.level_procedure);
2770: END IF;
2765: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2766: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2767: hz_utility_v2pub.debug(p_message=>'Save Employment History - Error occurred at hz_person_bo_pub.save_person_info, person id: '||p_person_id||' '||' ovn:'||l_ovn,
2768: p_prefix=>l_debug_prefix,
2769: p_msg_level=>fnd_log.level_procedure);
2770: END IF;
2771: FND_MESSAGE.SET_NAME('AR', 'HZ_API_PROPAGATE_STRUCT_ERROR');
2772: FND_MESSAGE.SET_TOKEN('STRUCTURE', 'HZ_EMPLOYMENT_HISTORY');
2773: FND_MSG_PUB.ADD;
2791: x_object_version_number => l_ovn
2792: );
2793:
2794: IF(l_ovn = -1) THEN
2795: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2796: hz_utility_v2pub.debug(p_message=>'Save Work Class - Error occurred at hz_person_bo_pub.check_work_class_op, person id: '||p_person_id||' '||' ovn:'||l_ovn,
2797: p_prefix=>l_debug_prefix,
2798: p_msg_level=>fnd_log.level_procedure);
2799: END IF;
2794: IF(l_ovn = -1) THEN
2795: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2796: hz_utility_v2pub.debug(p_message=>'Save Work Class - Error occurred at hz_person_bo_pub.check_work_class_op, person id: '||p_person_id||' '||' ovn:'||l_ovn,
2797: p_prefix=>l_debug_prefix,
2798: p_msg_level=>fnd_log.level_procedure);
2799: END IF;
2800: FND_MESSAGE.SET_NAME('AR', 'HZ_API_INVALID_ID');
2801: FND_MSG_PUB.ADD;
2802: FND_MESSAGE.SET_NAME('AR', 'HZ_API_PROPAGATE_ENTITY_ERROR');
2830: -- assign work_class_id
2831: p_employ_hist_obj(i).work_class_objs(j).work_class_id := l_work_class_rec.work_class_id;
2832: END IF;
2833: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2834: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2835: hz_utility_v2pub.debug(p_message=>'Save Work Class - Error occurred at hz_person_bo_pub.save_person_info, employ_hist_id: '||l_dummy_id||' '||' ovn:'||l_ovn,
2836: p_prefix=>l_debug_prefix,
2837: p_msg_level=>fnd_log.level_procedure);
2838: END IF;
2833: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2834: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2835: hz_utility_v2pub.debug(p_message=>'Save Work Class - Error occurred at hz_person_bo_pub.save_person_info, employ_hist_id: '||l_dummy_id||' '||' ovn:'||l_ovn,
2836: p_prefix=>l_debug_prefix,
2837: p_msg_level=>fnd_log.level_procedure);
2838: END IF;
2839: FND_MESSAGE.SET_NAME('AR', 'HZ_API_PROPAGATE_ENTITY_ERROR');
2840: FND_MESSAGE.SET_TOKEN('ENTITY', 'HZ_WORK_CLASS');
2841: FND_MSG_PUB.ADD;
2867: x_object_version_number => l_ovn
2868: );
2869:
2870: IF(l_ovn = -1) THEN
2871: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2872: hz_utility_v2pub.debug(p_message=>'Save Person Interest - Error occurred at hz_person_bo_pub.check_interest_op, person id: '||p_person_id||' '||' ovn:'||l_ovn,
2873: p_prefix=>l_debug_prefix,
2874: p_msg_level=>fnd_log.level_procedure);
2875: END IF;
2870: IF(l_ovn = -1) THEN
2871: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2872: hz_utility_v2pub.debug(p_message=>'Save Person Interest - Error occurred at hz_person_bo_pub.check_interest_op, person id: '||p_person_id||' '||' ovn:'||l_ovn,
2873: p_prefix=>l_debug_prefix,
2874: p_msg_level=>fnd_log.level_procedure);
2875: END IF;
2876: FND_MESSAGE.SET_NAME('AR', 'HZ_API_INVALID_ID');
2877: FND_MSG_PUB.ADD;
2878: FND_MESSAGE.SET_NAME('AR', 'HZ_API_PROPAGATE_ENTITY_ERROR');
2906: -- assign person_interest_id
2907: p_interest_obj(i).person_interest_id := l_interest_rec.person_interest_id;
2908: END IF;
2909: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2910: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2911: hz_utility_v2pub.debug(p_message=>'Save Person Interest - Error occurred at hz_person_bo_pub.save_person_info, person id: '||p_person_id||' '||' ovn:'||l_ovn,
2912: p_prefix=>l_debug_prefix,
2913: p_msg_level=>fnd_log.level_procedure);
2914: END IF;
2909: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2910: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2911: hz_utility_v2pub.debug(p_message=>'Save Person Interest - Error occurred at hz_person_bo_pub.save_person_info, person id: '||p_person_id||' '||' ovn:'||l_ovn,
2912: p_prefix=>l_debug_prefix,
2913: p_msg_level=>fnd_log.level_procedure);
2914: END IF;
2915: FND_MESSAGE.SET_NAME('AR', 'HZ_API_PROPAGATE_ENTITY_ERROR');
2916: FND_MESSAGE.SET_TOKEN('ENTITY', 'HZ_PERSON_INTEREST');
2917: FND_MSG_PUB.ADD;
2920: END LOOP;
2921: END IF;
2922:
2923: -- Debug info.
2924: IF fnd_log.level_exception>=fnd_log.g_current_runtime_level THEN
2925: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
2926: p_msg_data=>x_msg_data,
2927: p_msg_type=>'WARNING',
2928: p_msg_level=>fnd_log.level_exception);
2924: IF fnd_log.level_exception>=fnd_log.g_current_runtime_level THEN
2925: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
2926: p_msg_data=>x_msg_data,
2927: p_msg_type=>'WARNING',
2928: p_msg_level=>fnd_log.level_exception);
2929: END IF;
2930: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2931: hz_utility_v2pub.debug(p_message=>'save_person_info(-)',
2932: p_prefix=>l_debug_prefix,
2926: p_msg_data=>x_msg_data,
2927: p_msg_type=>'WARNING',
2928: p_msg_level=>fnd_log.level_exception);
2929: END IF;
2930: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2931: hz_utility_v2pub.debug(p_message=>'save_person_info(-)',
2932: p_prefix=>l_debug_prefix,
2933: p_msg_level=>fnd_log.level_procedure);
2934: END IF;
2929: END IF;
2930: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2931: hz_utility_v2pub.debug(p_message=>'save_person_info(-)',
2932: p_prefix=>l_debug_prefix,
2933: p_msg_level=>fnd_log.level_procedure);
2934: END IF;
2935: EXCEPTION
2936: WHEN fnd_api.g_exc_error THEN
2937: ROLLBACK TO save_person_info_pub;
2941: p_count => x_msg_count,
2942: p_data => x_msg_data);
2943:
2944: -- Debug info.
2945: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
2946: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
2947: p_msg_data=>x_msg_data,
2948: p_msg_type=>'ERROR',
2949: p_msg_level=>fnd_log.level_error);
2945: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
2946: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
2947: p_msg_data=>x_msg_data,
2948: p_msg_type=>'ERROR',
2949: p_msg_level=>fnd_log.level_error);
2950: END IF;
2951: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2952: hz_utility_v2pub.debug(p_message=>'save_person_info(-)',
2953: p_prefix=>l_debug_prefix,
2947: p_msg_data=>x_msg_data,
2948: p_msg_type=>'ERROR',
2949: p_msg_level=>fnd_log.level_error);
2950: END IF;
2951: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2952: hz_utility_v2pub.debug(p_message=>'save_person_info(-)',
2953: p_prefix=>l_debug_prefix,
2954: p_msg_level=>fnd_log.level_procedure);
2955: END IF;
2950: END IF;
2951: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2952: hz_utility_v2pub.debug(p_message=>'save_person_info(-)',
2953: p_prefix=>l_debug_prefix,
2954: p_msg_level=>fnd_log.level_procedure);
2955: END IF;
2956: WHEN fnd_api.g_exc_unexpected_error THEN
2957: ROLLBACK TO save_person_info_pub;
2958: x_return_status := fnd_api.g_ret_sts_unexp_error;
2961: p_count => x_msg_count,
2962: p_data => x_msg_data);
2963:
2964: -- Debug info.
2965: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
2966: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
2967: p_msg_data=>x_msg_data,
2968: p_msg_type=>'UNEXPECTED ERROR',
2969: p_msg_level=>fnd_log.level_error);
2965: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
2966: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
2967: p_msg_data=>x_msg_data,
2968: p_msg_type=>'UNEXPECTED ERROR',
2969: p_msg_level=>fnd_log.level_error);
2970: END IF;
2971: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2972: hz_utility_v2pub.debug(p_message=>'save_person_info(-)',
2973: p_prefix=>l_debug_prefix,
2967: p_msg_data=>x_msg_data,
2968: p_msg_type=>'UNEXPECTED ERROR',
2969: p_msg_level=>fnd_log.level_error);
2970: END IF;
2971: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2972: hz_utility_v2pub.debug(p_message=>'save_person_info(-)',
2973: p_prefix=>l_debug_prefix,
2974: p_msg_level=>fnd_log.level_procedure);
2975: END IF;
2970: END IF;
2971: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2972: hz_utility_v2pub.debug(p_message=>'save_person_info(-)',
2973: p_prefix=>l_debug_prefix,
2974: p_msg_level=>fnd_log.level_procedure);
2975: END IF;
2976:
2977: WHEN OTHERS THEN
2978: ROLLBACK TO save_person_info_pub;
2986: p_count => x_msg_count,
2987: p_data => x_msg_data);
2988:
2989: -- Debug info.
2990: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
2991: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
2992: p_msg_data=>x_msg_data,
2993: p_msg_type=>'SQL ERROR',
2994: p_msg_level=>fnd_log.level_error);
2990: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
2991: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
2992: p_msg_data=>x_msg_data,
2993: p_msg_type=>'SQL ERROR',
2994: p_msg_level=>fnd_log.level_error);
2995: END IF;
2996: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2997: hz_utility_v2pub.debug(p_message=>'save_person_info(-)',
2998: p_prefix=>l_debug_prefix,
2992: p_msg_data=>x_msg_data,
2993: p_msg_type=>'SQL ERROR',
2994: p_msg_level=>fnd_log.level_error);
2995: END IF;
2996: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2997: hz_utility_v2pub.debug(p_message=>'save_person_info(-)',
2998: p_prefix=>l_debug_prefix,
2999: p_msg_level=>fnd_log.level_procedure);
3000: END IF;
2995: END IF;
2996: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2997: hz_utility_v2pub.debug(p_message=>'save_person_info(-)',
2998: p_prefix=>l_debug_prefix,
2999: p_msg_level=>fnd_log.level_procedure);
3000: END IF;
3001: END save_person_info;
3002:
3003: --------------------------------------
3095: END IF;
3096:
3097:
3098: -- Debug info.
3099: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
3100: hz_utility_v2pub.debug(p_message=>'hz_person_bo_pub.get_person_bo(+)',
3101: p_prefix=>l_debug_prefix,
3102: p_msg_level=>fnd_log.level_procedure);
3103: END IF;
3098: -- Debug info.
3099: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
3100: hz_utility_v2pub.debug(p_message=>'hz_person_bo_pub.get_person_bo(+)',
3101: p_prefix=>l_debug_prefix,
3102: p_msg_level=>fnd_log.level_procedure);
3103: END IF;
3104:
3105: -- check if pass in contact_point_id and/or os+osr
3106: -- extraction validation logic is same as update
3136: END IF;
3137:
3138:
3139: -- Debug info.
3140: IF fnd_log.level_exception>=fnd_log.g_current_runtime_level THEN
3141: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
3142: p_msg_data=>x_msg_data,
3143: p_msg_type=>'WARNING',
3144: p_msg_level=>fnd_log.level_exception);
3140: IF fnd_log.level_exception>=fnd_log.g_current_runtime_level THEN
3141: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
3142: p_msg_data=>x_msg_data,
3143: p_msg_type=>'WARNING',
3144: p_msg_level=>fnd_log.level_exception);
3145: END IF;
3146:
3147: -- Debug info.
3148: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
3144: p_msg_level=>fnd_log.level_exception);
3145: END IF;
3146:
3147: -- Debug info.
3148: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
3149: hz_utility_v2pub.debug(p_message=>'hz_person_bo_pub.get_person_bo (-)',
3150: p_prefix=>l_debug_prefix,
3151: p_msg_level=>fnd_log.level_procedure);
3152: END IF;
3147: -- Debug info.
3148: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
3149: hz_utility_v2pub.debug(p_message=>'hz_person_bo_pub.get_person_bo (-)',
3150: p_prefix=>l_debug_prefix,
3151: p_msg_level=>fnd_log.level_procedure);
3152: END IF;
3153:
3154:
3155: EXCEPTION
3161: p_count => x_msg_count,
3162: p_data => x_msg_data);
3163:
3164: -- Debug info.
3165: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
3166: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
3167: p_msg_data=>x_msg_data,
3168: p_msg_type=>'ERROR',
3169: p_msg_level=>fnd_log.level_error);
3165: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
3166: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
3167: p_msg_data=>x_msg_data,
3168: p_msg_type=>'ERROR',
3169: p_msg_level=>fnd_log.level_error);
3170: END IF;
3171: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
3172: hz_utility_v2pub.debug(p_message=>'hz_person_bo_pub.get_person_bo (-)',
3173: p_prefix=>l_debug_prefix,
3167: p_msg_data=>x_msg_data,
3168: p_msg_type=>'ERROR',
3169: p_msg_level=>fnd_log.level_error);
3170: END IF;
3171: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
3172: hz_utility_v2pub.debug(p_message=>'hz_person_bo_pub.get_person_bo (-)',
3173: p_prefix=>l_debug_prefix,
3174: p_msg_level=>fnd_log.level_procedure);
3175: END IF;
3170: END IF;
3171: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
3172: hz_utility_v2pub.debug(p_message=>'hz_person_bo_pub.get_person_bo (-)',
3173: p_prefix=>l_debug_prefix,
3174: p_msg_level=>fnd_log.level_procedure);
3175: END IF;
3176: WHEN fnd_api.g_exc_unexpected_error THEN
3177: x_return_status := fnd_api.g_ret_sts_unexp_error;
3178:
3180: p_count => x_msg_count,
3181: p_data => x_msg_data);
3182:
3183: -- Debug info.
3184: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
3185: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
3186: p_msg_data=>x_msg_data,
3187: p_msg_type=>'UNEXPECTED ERROR',
3188: p_msg_level=>fnd_log.level_error);
3184: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
3185: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
3186: p_msg_data=>x_msg_data,
3187: p_msg_type=>'UNEXPECTED ERROR',
3188: p_msg_level=>fnd_log.level_error);
3189: END IF;
3190: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
3191: hz_utility_v2pub.debug(p_message=>'hz_person_bo_pub.get_person_bo (-)',
3192: p_prefix=>l_debug_prefix,
3186: p_msg_data=>x_msg_data,
3187: p_msg_type=>'UNEXPECTED ERROR',
3188: p_msg_level=>fnd_log.level_error);
3189: END IF;
3190: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
3191: hz_utility_v2pub.debug(p_message=>'hz_person_bo_pub.get_person_bo (-)',
3192: p_prefix=>l_debug_prefix,
3193: p_msg_level=>fnd_log.level_procedure);
3194: END IF;
3189: END IF;
3190: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
3191: hz_utility_v2pub.debug(p_message=>'hz_person_bo_pub.get_person_bo (-)',
3192: p_prefix=>l_debug_prefix,
3193: p_msg_level=>fnd_log.level_procedure);
3194: END IF;
3195: WHEN OTHERS THEN
3196: x_return_status := fnd_api.g_ret_sts_unexp_error;
3197:
3203: p_count => x_msg_count,
3204: p_data => x_msg_data);
3205:
3206: -- Debug info.
3207: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
3208: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
3209: p_msg_data=>x_msg_data,
3210: p_msg_type=>'SQL ERROR',
3211: p_msg_level=>fnd_log.level_error);
3207: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
3208: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
3209: p_msg_data=>x_msg_data,
3210: p_msg_type=>'SQL ERROR',
3211: p_msg_level=>fnd_log.level_error);
3212: END IF;
3213: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
3214: hz_utility_v2pub.debug(p_message=>'hz_person_bo_pub.get_person_bo (-)',
3215: p_prefix=>l_debug_prefix,
3209: p_msg_data=>x_msg_data,
3210: p_msg_type=>'SQL ERROR',
3211: p_msg_level=>fnd_log.level_error);
3212: END IF;
3213: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
3214: hz_utility_v2pub.debug(p_message=>'hz_person_bo_pub.get_person_bo (-)',
3215: p_prefix=>l_debug_prefix,
3216: p_msg_level=>fnd_log.level_procedure);
3217: END IF;
3212: END IF;
3213: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
3214: hz_utility_v2pub.debug(p_message=>'hz_person_bo_pub.get_person_bo (-)',
3215: p_prefix=>l_debug_prefix,
3216: p_msg_level=>fnd_log.level_procedure);
3217: END IF;
3218:
3219: end;
3220:
3314: END IF;
3315:
3316:
3317: -- Debug info.
3318: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
3319: hz_utility_v2pub.debug(p_message=>'hz_person_bo_pub.get_persons_created(+)',
3320: p_prefix=>l_debug_prefix,
3321: p_msg_level=>fnd_log.level_procedure);
3322: END IF;
3317: -- Debug info.
3318: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
3319: hz_utility_v2pub.debug(p_message=>'hz_person_bo_pub.get_persons_created(+)',
3320: p_prefix=>l_debug_prefix,
3321: p_msg_level=>fnd_log.level_procedure);
3322: END IF;
3323:
3324:
3325: HZ_EXTRACT_BO_UTIL_PVT.validate_event_id(p_event_id => p_event_id,
3346:
3347:
3348:
3349: -- Debug info.
3350: IF fnd_log.level_exception>=fnd_log.g_current_runtime_level THEN
3351: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
3352: p_msg_data=>x_msg_data,
3353: p_msg_type=>'WARNING',
3354: p_msg_level=>fnd_log.level_exception);
3350: IF fnd_log.level_exception>=fnd_log.g_current_runtime_level THEN
3351: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
3352: p_msg_data=>x_msg_data,
3353: p_msg_type=>'WARNING',
3354: p_msg_level=>fnd_log.level_exception);
3355: END IF;
3356:
3357: -- Debug info.
3358: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
3354: p_msg_level=>fnd_log.level_exception);
3355: END IF;
3356:
3357: -- Debug info.
3358: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
3359: hz_utility_v2pub.debug(p_message=>'hz_person_bo_pub.get_persons_created (-)',
3360: p_prefix=>l_debug_prefix,
3361: p_msg_level=>fnd_log.level_procedure);
3362: END IF;
3357: -- Debug info.
3358: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
3359: hz_utility_v2pub.debug(p_message=>'hz_person_bo_pub.get_persons_created (-)',
3360: p_prefix=>l_debug_prefix,
3361: p_msg_level=>fnd_log.level_procedure);
3362: END IF;
3363:
3364:
3365: EXCEPTION
3371: p_count => x_msg_count,
3372: p_data => x_msg_data);
3373:
3374: -- Debug info.
3375: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
3376: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
3377: p_msg_data=>x_msg_data,
3378: p_msg_type=>'ERROR',
3379: p_msg_level=>fnd_log.level_error);
3375: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
3376: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
3377: p_msg_data=>x_msg_data,
3378: p_msg_type=>'ERROR',
3379: p_msg_level=>fnd_log.level_error);
3380: END IF;
3381: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
3382: hz_utility_v2pub.debug(p_message=>'hz_person_bo_pub.get_persons_created(-)',
3383: p_prefix=>l_debug_prefix,
3377: p_msg_data=>x_msg_data,
3378: p_msg_type=>'ERROR',
3379: p_msg_level=>fnd_log.level_error);
3380: END IF;
3381: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
3382: hz_utility_v2pub.debug(p_message=>'hz_person_bo_pub.get_persons_created(-)',
3383: p_prefix=>l_debug_prefix,
3384: p_msg_level=>fnd_log.level_procedure);
3385: END IF;
3380: END IF;
3381: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
3382: hz_utility_v2pub.debug(p_message=>'hz_person_bo_pub.get_persons_created(-)',
3383: p_prefix=>l_debug_prefix,
3384: p_msg_level=>fnd_log.level_procedure);
3385: END IF;
3386: WHEN fnd_api.g_exc_unexpected_error THEN
3387: x_return_status := fnd_api.g_ret_sts_unexp_error;
3388:
3390: p_count => x_msg_count,
3391: p_data => x_msg_data);
3392:
3393: -- Debug info.
3394: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
3395: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
3396: p_msg_data=>x_msg_data,
3397: p_msg_type=>'UNEXPECTED ERROR',
3398: p_msg_level=>fnd_log.level_error);
3394: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
3395: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
3396: p_msg_data=>x_msg_data,
3397: p_msg_type=>'UNEXPECTED ERROR',
3398: p_msg_level=>fnd_log.level_error);
3399: END IF;
3400: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
3401: hz_utility_v2pub.debug(p_message=>'hz_person_bo_pub.get_persons_created(-)',
3402: p_prefix=>l_debug_prefix,
3396: p_msg_data=>x_msg_data,
3397: p_msg_type=>'UNEXPECTED ERROR',
3398: p_msg_level=>fnd_log.level_error);
3399: END IF;
3400: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
3401: hz_utility_v2pub.debug(p_message=>'hz_person_bo_pub.get_persons_created(-)',
3402: p_prefix=>l_debug_prefix,
3403: p_msg_level=>fnd_log.level_procedure);
3404: END IF;
3399: END IF;
3400: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
3401: hz_utility_v2pub.debug(p_message=>'hz_person_bo_pub.get_persons_created(-)',
3402: p_prefix=>l_debug_prefix,
3403: p_msg_level=>fnd_log.level_procedure);
3404: END IF;
3405: WHEN OTHERS THEN
3406: x_return_status := fnd_api.g_ret_sts_unexp_error;
3407:
3413: p_count => x_msg_count,
3414: p_data => x_msg_data);
3415:
3416: -- Debug info.
3417: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
3418: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
3419: p_msg_data=>x_msg_data,
3420: p_msg_type=>'SQL ERROR',
3421: p_msg_level=>fnd_log.level_error);
3417: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
3418: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
3419: p_msg_data=>x_msg_data,
3420: p_msg_type=>'SQL ERROR',
3421: p_msg_level=>fnd_log.level_error);
3422: END IF;
3423: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
3424: hz_utility_v2pub.debug(p_message=>'hz_person_bo_pub.get_persons_created(-)',
3425: p_prefix=>l_debug_prefix,
3419: p_msg_data=>x_msg_data,
3420: p_msg_type=>'SQL ERROR',
3421: p_msg_level=>fnd_log.level_error);
3422: END IF;
3423: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
3424: hz_utility_v2pub.debug(p_message=>'hz_person_bo_pub.get_persons_created(-)',
3425: p_prefix=>l_debug_prefix,
3426: p_msg_level=>fnd_log.level_procedure);
3427: END IF;
3422: END IF;
3423: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
3424: hz_utility_v2pub.debug(p_message=>'hz_person_bo_pub.get_persons_created(-)',
3425: p_prefix=>l_debug_prefix,
3426: p_msg_level=>fnd_log.level_procedure);
3427: END IF;
3428:
3429: end;
3430:
3517: END IF;
3518:
3519:
3520: -- Debug info.
3521: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
3522: hz_utility_v2pub.debug(p_message=>'hz_person_bo_pub.get_persons_updated(+)',
3523: p_prefix=>l_debug_prefix,
3524: p_msg_level=>fnd_log.level_procedure);
3525: END IF;
3520: -- Debug info.
3521: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
3522: hz_utility_v2pub.debug(p_message=>'hz_person_bo_pub.get_persons_updated(+)',
3523: p_prefix=>l_debug_prefix,
3524: p_msg_level=>fnd_log.level_procedure);
3525: END IF;
3526:
3527: HZ_EXTRACT_BO_UTIL_PVT.validate_event_id(p_event_id => p_event_id,
3528: p_party_id => null,
3548:
3549:
3550:
3551: -- Debug info.
3552: IF fnd_log.level_exception>=fnd_log.g_current_runtime_level THEN
3553: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
3554: p_msg_data=>x_msg_data,
3555: p_msg_type=>'WARNING',
3556: p_msg_level=>fnd_log.level_exception);
3552: IF fnd_log.level_exception>=fnd_log.g_current_runtime_level THEN
3553: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
3554: p_msg_data=>x_msg_data,
3555: p_msg_type=>'WARNING',
3556: p_msg_level=>fnd_log.level_exception);
3557: END IF;
3558:
3559: -- Debug info.
3560: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
3556: p_msg_level=>fnd_log.level_exception);
3557: END IF;
3558:
3559: -- Debug info.
3560: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
3561: hz_utility_v2pub.debug(p_message=>'hz_person_bo_pub.get_persons_updated (-)',
3562: p_prefix=>l_debug_prefix,
3563: p_msg_level=>fnd_log.level_procedure);
3564: END IF;
3559: -- Debug info.
3560: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
3561: hz_utility_v2pub.debug(p_message=>'hz_person_bo_pub.get_persons_updated (-)',
3562: p_prefix=>l_debug_prefix,
3563: p_msg_level=>fnd_log.level_procedure);
3564: END IF;
3565:
3566:
3567: EXCEPTION
3573: p_count => x_msg_count,
3574: p_data => x_msg_data);
3575:
3576: -- Debug info.
3577: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
3578: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
3579: p_msg_data=>x_msg_data,
3580: p_msg_type=>'ERROR',
3581: p_msg_level=>fnd_log.level_error);
3577: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
3578: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
3579: p_msg_data=>x_msg_data,
3580: p_msg_type=>'ERROR',
3581: p_msg_level=>fnd_log.level_error);
3582: END IF;
3583: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
3584: hz_utility_v2pub.debug(p_message=>'hz_person_bo_pub.get_persons_updated(-)',
3585: p_prefix=>l_debug_prefix,
3579: p_msg_data=>x_msg_data,
3580: p_msg_type=>'ERROR',
3581: p_msg_level=>fnd_log.level_error);
3582: END IF;
3583: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
3584: hz_utility_v2pub.debug(p_message=>'hz_person_bo_pub.get_persons_updated(-)',
3585: p_prefix=>l_debug_prefix,
3586: p_msg_level=>fnd_log.level_procedure);
3587: END IF;
3582: END IF;
3583: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
3584: hz_utility_v2pub.debug(p_message=>'hz_person_bo_pub.get_persons_updated(-)',
3585: p_prefix=>l_debug_prefix,
3586: p_msg_level=>fnd_log.level_procedure);
3587: END IF;
3588: WHEN fnd_api.g_exc_unexpected_error THEN
3589: x_return_status := fnd_api.g_ret_sts_unexp_error;
3590:
3592: p_count => x_msg_count,
3593: p_data => x_msg_data);
3594:
3595: -- Debug info.
3596: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
3597: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
3598: p_msg_data=>x_msg_data,
3599: p_msg_type=>'UNEXPECTED ERROR',
3600: p_msg_level=>fnd_log.level_error);
3596: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
3597: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
3598: p_msg_data=>x_msg_data,
3599: p_msg_type=>'UNEXPECTED ERROR',
3600: p_msg_level=>fnd_log.level_error);
3601: END IF;
3602: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
3603: hz_utility_v2pub.debug(p_message=>'hz_person_bo_pub.get_persons_updated(-)',
3604: p_prefix=>l_debug_prefix,
3598: p_msg_data=>x_msg_data,
3599: p_msg_type=>'UNEXPECTED ERROR',
3600: p_msg_level=>fnd_log.level_error);
3601: END IF;
3602: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
3603: hz_utility_v2pub.debug(p_message=>'hz_person_bo_pub.get_persons_updated(-)',
3604: p_prefix=>l_debug_prefix,
3605: p_msg_level=>fnd_log.level_procedure);
3606: END IF;
3601: END IF;
3602: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
3603: hz_utility_v2pub.debug(p_message=>'hz_person_bo_pub.get_persons_updated(-)',
3604: p_prefix=>l_debug_prefix,
3605: p_msg_level=>fnd_log.level_procedure);
3606: END IF;
3607: WHEN OTHERS THEN
3608: x_return_status := fnd_api.g_ret_sts_unexp_error;
3609:
3615: p_count => x_msg_count,
3616: p_data => x_msg_data);
3617:
3618: -- Debug info.
3619: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
3620: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
3621: p_msg_data=>x_msg_data,
3622: p_msg_type=>'SQL ERROR',
3623: p_msg_level=>fnd_log.level_error);
3619: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
3620: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
3621: p_msg_data=>x_msg_data,
3622: p_msg_type=>'SQL ERROR',
3623: p_msg_level=>fnd_log.level_error);
3624: END IF;
3625: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
3626: hz_utility_v2pub.debug(p_message=>'hz_person_bo_pub.get_persons_updated(-)',
3627: p_prefix=>l_debug_prefix,
3621: p_msg_data=>x_msg_data,
3622: p_msg_type=>'SQL ERROR',
3623: p_msg_level=>fnd_log.level_error);
3624: END IF;
3625: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
3626: hz_utility_v2pub.debug(p_message=>'hz_person_bo_pub.get_persons_updated(-)',
3627: p_prefix=>l_debug_prefix,
3628: p_msg_level=>fnd_log.level_procedure);
3629: END IF;
3624: END IF;
3625: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
3626: hz_utility_v2pub.debug(p_message=>'hz_person_bo_pub.get_persons_updated(-)',
3627: p_prefix=>l_debug_prefix,
3628: p_msg_level=>fnd_log.level_procedure);
3629: END IF;
3630:
3631: end;
3632:
3711: END IF;
3712:
3713:
3714: -- Debug info.
3715: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
3716: hz_utility_v2pub.debug(p_message=>'hz_person_bo_pub.get_person_updated(+)',
3717: p_prefix=>l_debug_prefix,
3718: p_msg_level=>fnd_log.level_procedure);
3719: END IF;
3714: -- Debug info.
3715: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
3716: hz_utility_v2pub.debug(p_message=>'hz_person_bo_pub.get_person_updated(+)',
3717: p_prefix=>l_debug_prefix,
3718: p_msg_level=>fnd_log.level_procedure);
3719: END IF;
3720:
3721: HZ_EXTRACT_BO_UTIL_PVT.validate_event_id(p_event_id => p_event_id,
3722: p_party_id => p_person_id,
3744:
3745:
3746:
3747: -- Debug info.
3748: IF fnd_log.level_exception>=fnd_log.g_current_runtime_level THEN
3749: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
3750: p_msg_data=>x_msg_data,
3751: p_msg_type=>'WARNING',
3752: p_msg_level=>fnd_log.level_exception);
3748: IF fnd_log.level_exception>=fnd_log.g_current_runtime_level THEN
3749: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
3750: p_msg_data=>x_msg_data,
3751: p_msg_type=>'WARNING',
3752: p_msg_level=>fnd_log.level_exception);
3753: END IF;
3754:
3755: -- Debug info.
3756: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
3752: p_msg_level=>fnd_log.level_exception);
3753: END IF;
3754:
3755: -- Debug info.
3756: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
3757: hz_utility_v2pub.debug(p_message=>'hz_person_bo_pub.get_person_updated (-)',
3758: p_prefix=>l_debug_prefix,
3759: p_msg_level=>fnd_log.level_procedure);
3760: END IF;
3755: -- Debug info.
3756: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
3757: hz_utility_v2pub.debug(p_message=>'hz_person_bo_pub.get_person_updated (-)',
3758: p_prefix=>l_debug_prefix,
3759: p_msg_level=>fnd_log.level_procedure);
3760: END IF;
3761:
3762:
3763: EXCEPTION
3769: p_count => x_msg_count,
3770: p_data => x_msg_data);
3771:
3772: -- Debug info.
3773: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
3774: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
3775: p_msg_data=>x_msg_data,
3776: p_msg_type=>'ERROR',
3777: p_msg_level=>fnd_log.level_error);
3773: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
3774: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
3775: p_msg_data=>x_msg_data,
3776: p_msg_type=>'ERROR',
3777: p_msg_level=>fnd_log.level_error);
3778: END IF;
3779: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
3780: hz_utility_v2pub.debug(p_message=>'hz_person_bo_pub.get_person_updated(-)',
3781: p_prefix=>l_debug_prefix,
3775: p_msg_data=>x_msg_data,
3776: p_msg_type=>'ERROR',
3777: p_msg_level=>fnd_log.level_error);
3778: END IF;
3779: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
3780: hz_utility_v2pub.debug(p_message=>'hz_person_bo_pub.get_person_updated(-)',
3781: p_prefix=>l_debug_prefix,
3782: p_msg_level=>fnd_log.level_procedure);
3783: END IF;
3778: END IF;
3779: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
3780: hz_utility_v2pub.debug(p_message=>'hz_person_bo_pub.get_person_updated(-)',
3781: p_prefix=>l_debug_prefix,
3782: p_msg_level=>fnd_log.level_procedure);
3783: END IF;
3784: WHEN fnd_api.g_exc_unexpected_error THEN
3785: x_return_status := fnd_api.g_ret_sts_unexp_error;
3786:
3788: p_count => x_msg_count,
3789: p_data => x_msg_data);
3790:
3791: -- Debug info.
3792: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
3793: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
3794: p_msg_data=>x_msg_data,
3795: p_msg_type=>'UNEXPECTED ERROR',
3796: p_msg_level=>fnd_log.level_error);
3792: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
3793: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
3794: p_msg_data=>x_msg_data,
3795: p_msg_type=>'UNEXPECTED ERROR',
3796: p_msg_level=>fnd_log.level_error);
3797: END IF;
3798: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
3799: hz_utility_v2pub.debug(p_message=>'hz_person_bo_pub.get_person_updated(-)',
3800: p_prefix=>l_debug_prefix,
3794: p_msg_data=>x_msg_data,
3795: p_msg_type=>'UNEXPECTED ERROR',
3796: p_msg_level=>fnd_log.level_error);
3797: END IF;
3798: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
3799: hz_utility_v2pub.debug(p_message=>'hz_person_bo_pub.get_person_updated(-)',
3800: p_prefix=>l_debug_prefix,
3801: p_msg_level=>fnd_log.level_procedure);
3802: END IF;
3797: END IF;
3798: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
3799: hz_utility_v2pub.debug(p_message=>'hz_person_bo_pub.get_person_updated(-)',
3800: p_prefix=>l_debug_prefix,
3801: p_msg_level=>fnd_log.level_procedure);
3802: END IF;
3803: WHEN OTHERS THEN
3804: x_return_status := fnd_api.g_ret_sts_unexp_error;
3805:
3811: p_count => x_msg_count,
3812: p_data => x_msg_data);
3813:
3814: -- Debug info.
3815: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
3816: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
3817: p_msg_data=>x_msg_data,
3818: p_msg_type=>'SQL ERROR',
3819: p_msg_level=>fnd_log.level_error);
3815: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
3816: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
3817: p_msg_data=>x_msg_data,
3818: p_msg_type=>'SQL ERROR',
3819: p_msg_level=>fnd_log.level_error);
3820: END IF;
3821: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
3822: hz_utility_v2pub.debug(p_message=>'hz_person_bo_pub.get_person_updated(-)',
3823: p_prefix=>l_debug_prefix,
3817: p_msg_data=>x_msg_data,
3818: p_msg_type=>'SQL ERROR',
3819: p_msg_level=>fnd_log.level_error);
3820: END IF;
3821: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
3822: hz_utility_v2pub.debug(p_message=>'hz_person_bo_pub.get_person_updated(-)',
3823: p_prefix=>l_debug_prefix,
3824: p_msg_level=>fnd_log.level_procedure);
3825: END IF;
3820: END IF;
3821: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
3822: hz_utility_v2pub.debug(p_message=>'hz_person_bo_pub.get_person_updated(-)',
3823: p_prefix=>l_debug_prefix,
3824: p_msg_level=>fnd_log.level_procedure);
3825: END IF;
3826:
3827: end;
3828:
3873: END IF;
3874:
3875:
3876: -- Debug info.
3877: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
3878: hz_utility_v2pub.debug(p_message=>'get_ids_persons_created(+)',
3879: p_prefix=>l_debug_prefix,
3880: p_msg_level=>fnd_log.level_procedure);
3881: END IF;
3876: -- Debug info.
3877: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
3878: hz_utility_v2pub.debug(p_message=>'get_ids_persons_created(+)',
3879: p_prefix=>l_debug_prefix,
3880: p_msg_level=>fnd_log.level_procedure);
3881: END IF;
3882:
3883:
3884: HZ_EXTRACT_BO_UTIL_PVT.validate_event_id(p_event_id => p_event_id,
3904: END IF;
3905:
3906:
3907: -- Debug info.
3908: IF fnd_log.level_exception>=fnd_log.g_current_runtime_level THEN
3909: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
3910: p_msg_data=>x_msg_data,
3911: p_msg_type=>'WARNING',
3912: p_msg_level=>fnd_log.level_exception);
3908: IF fnd_log.level_exception>=fnd_log.g_current_runtime_level THEN
3909: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
3910: p_msg_data=>x_msg_data,
3911: p_msg_type=>'WARNING',
3912: p_msg_level=>fnd_log.level_exception);
3913: END IF;
3914:
3915: -- Debug info.
3916: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
3912: p_msg_level=>fnd_log.level_exception);
3913: END IF;
3914:
3915: -- Debug info.
3916: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
3917: hz_utility_v2pub.debug(p_message=>'get_ids_persons_created (-)',
3918: p_prefix=>l_debug_prefix,
3919: p_msg_level=>fnd_log.level_procedure);
3920: END IF;
3915: -- Debug info.
3916: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
3917: hz_utility_v2pub.debug(p_message=>'get_ids_persons_created (-)',
3918: p_prefix=>l_debug_prefix,
3919: p_msg_level=>fnd_log.level_procedure);
3920: END IF;
3921:
3922:
3923: EXCEPTION
3929: p_count => x_msg_count,
3930: p_data => x_msg_data);
3931:
3932: -- Debug info.
3933: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
3934: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
3935: p_msg_data=>x_msg_data,
3936: p_msg_type=>'ERROR',
3937: p_msg_level=>fnd_log.level_error);
3933: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
3934: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
3935: p_msg_data=>x_msg_data,
3936: p_msg_type=>'ERROR',
3937: p_msg_level=>fnd_log.level_error);
3938: END IF;
3939: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
3940: hz_utility_v2pub.debug(p_message=>'get_ids_persons_created(-)',
3941: p_prefix=>l_debug_prefix,
3935: p_msg_data=>x_msg_data,
3936: p_msg_type=>'ERROR',
3937: p_msg_level=>fnd_log.level_error);
3938: END IF;
3939: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
3940: hz_utility_v2pub.debug(p_message=>'get_ids_persons_created(-)',
3941: p_prefix=>l_debug_prefix,
3942: p_msg_level=>fnd_log.level_procedure);
3943: END IF;
3938: END IF;
3939: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
3940: hz_utility_v2pub.debug(p_message=>'get_ids_persons_created(-)',
3941: p_prefix=>l_debug_prefix,
3942: p_msg_level=>fnd_log.level_procedure);
3943: END IF;
3944: WHEN fnd_api.g_exc_unexpected_error THEN
3945: x_return_status := fnd_api.g_ret_sts_unexp_error;
3946:
3948: p_count => x_msg_count,
3949: p_data => x_msg_data);
3950:
3951: -- Debug info.
3952: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
3953: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
3954: p_msg_data=>x_msg_data,
3955: p_msg_type=>'UNEXPECTED ERROR',
3956: p_msg_level=>fnd_log.level_error);
3952: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
3953: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
3954: p_msg_data=>x_msg_data,
3955: p_msg_type=>'UNEXPECTED ERROR',
3956: p_msg_level=>fnd_log.level_error);
3957: END IF;
3958: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
3959: hz_utility_v2pub.debug(p_message=>'get_ids_persons_created(-)',
3960: p_prefix=>l_debug_prefix,
3954: p_msg_data=>x_msg_data,
3955: p_msg_type=>'UNEXPECTED ERROR',
3956: p_msg_level=>fnd_log.level_error);
3957: END IF;
3958: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
3959: hz_utility_v2pub.debug(p_message=>'get_ids_persons_created(-)',
3960: p_prefix=>l_debug_prefix,
3961: p_msg_level=>fnd_log.level_procedure);
3962: END IF;
3957: END IF;
3958: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
3959: hz_utility_v2pub.debug(p_message=>'get_ids_persons_created(-)',
3960: p_prefix=>l_debug_prefix,
3961: p_msg_level=>fnd_log.level_procedure);
3962: END IF;
3963: WHEN OTHERS THEN
3964: x_return_status := fnd_api.g_ret_sts_unexp_error;
3965:
3971: p_count => x_msg_count,
3972: p_data => x_msg_data);
3973:
3974: -- Debug info.
3975: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
3976: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
3977: p_msg_data=>x_msg_data,
3978: p_msg_type=>'SQL ERROR',
3979: p_msg_level=>fnd_log.level_error);
3975: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
3976: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
3977: p_msg_data=>x_msg_data,
3978: p_msg_type=>'SQL ERROR',
3979: p_msg_level=>fnd_log.level_error);
3980: END IF;
3981: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
3982: hz_utility_v2pub.debug(p_message=>'get_ids_persons_created(-)',
3983: p_prefix=>l_debug_prefix,
3977: p_msg_data=>x_msg_data,
3978: p_msg_type=>'SQL ERROR',
3979: p_msg_level=>fnd_log.level_error);
3980: END IF;
3981: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
3982: hz_utility_v2pub.debug(p_message=>'get_ids_persons_created(-)',
3983: p_prefix=>l_debug_prefix,
3984: p_msg_level=>fnd_log.level_procedure);
3985: END IF;
3980: END IF;
3981: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
3982: hz_utility_v2pub.debug(p_message=>'get_ids_persons_created(-)',
3983: p_prefix=>l_debug_prefix,
3984: p_msg_level=>fnd_log.level_procedure);
3985: END IF;
3986:
3987: end;
3988:
4008: END IF;
4009:
4010:
4011: -- Debug info.
4012: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
4013: hz_utility_v2pub.debug(p_message=>'get_ids_persons_updated(+)',
4014: p_prefix=>l_debug_prefix,
4015: p_msg_level=>fnd_log.level_procedure);
4016: END IF;
4011: -- Debug info.
4012: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
4013: hz_utility_v2pub.debug(p_message=>'get_ids_persons_updated(+)',
4014: p_prefix=>l_debug_prefix,
4015: p_msg_level=>fnd_log.level_procedure);
4016: END IF;
4017:
4018: HZ_EXTRACT_BO_UTIL_PVT.validate_event_id(p_event_id => p_event_id,
4019: p_party_id => null,
4038: END IF;
4039:
4040:
4041: -- Debug info.
4042: IF fnd_log.level_exception>=fnd_log.g_current_runtime_level THEN
4043: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
4044: p_msg_data=>x_msg_data,
4045: p_msg_type=>'WARNING',
4046: p_msg_level=>fnd_log.level_exception);
4042: IF fnd_log.level_exception>=fnd_log.g_current_runtime_level THEN
4043: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
4044: p_msg_data=>x_msg_data,
4045: p_msg_type=>'WARNING',
4046: p_msg_level=>fnd_log.level_exception);
4047: END IF;
4048:
4049: -- Debug info.
4050: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
4046: p_msg_level=>fnd_log.level_exception);
4047: END IF;
4048:
4049: -- Debug info.
4050: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
4051: hz_utility_v2pub.debug(p_message=>'get_ids_persons_updated (-)',
4052: p_prefix=>l_debug_prefix,
4053: p_msg_level=>fnd_log.level_procedure);
4054: END IF;
4049: -- Debug info.
4050: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
4051: hz_utility_v2pub.debug(p_message=>'get_ids_persons_updated (-)',
4052: p_prefix=>l_debug_prefix,
4053: p_msg_level=>fnd_log.level_procedure);
4054: END IF;
4055:
4056:
4057: EXCEPTION
4063: p_count => x_msg_count,
4064: p_data => x_msg_data);
4065:
4066: -- Debug info.
4067: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
4068: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
4069: p_msg_data=>x_msg_data,
4070: p_msg_type=>'ERROR',
4071: p_msg_level=>fnd_log.level_error);
4067: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
4068: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
4069: p_msg_data=>x_msg_data,
4070: p_msg_type=>'ERROR',
4071: p_msg_level=>fnd_log.level_error);
4072: END IF;
4073: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
4074: hz_utility_v2pub.debug(p_message=>'get_ids_persons_updated(-)',
4075: p_prefix=>l_debug_prefix,
4069: p_msg_data=>x_msg_data,
4070: p_msg_type=>'ERROR',
4071: p_msg_level=>fnd_log.level_error);
4072: END IF;
4073: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
4074: hz_utility_v2pub.debug(p_message=>'get_ids_persons_updated(-)',
4075: p_prefix=>l_debug_prefix,
4076: p_msg_level=>fnd_log.level_procedure);
4077: END IF;
4072: END IF;
4073: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
4074: hz_utility_v2pub.debug(p_message=>'get_ids_persons_updated(-)',
4075: p_prefix=>l_debug_prefix,
4076: p_msg_level=>fnd_log.level_procedure);
4077: END IF;
4078: WHEN fnd_api.g_exc_unexpected_error THEN
4079: x_return_status := fnd_api.g_ret_sts_unexp_error;
4080:
4082: p_count => x_msg_count,
4083: p_data => x_msg_data);
4084:
4085: -- Debug info.
4086: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
4087: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
4088: p_msg_data=>x_msg_data,
4089: p_msg_type=>'UNEXPECTED ERROR',
4090: p_msg_level=>fnd_log.level_error);
4086: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
4087: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
4088: p_msg_data=>x_msg_data,
4089: p_msg_type=>'UNEXPECTED ERROR',
4090: p_msg_level=>fnd_log.level_error);
4091: END IF;
4092: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
4093: hz_utility_v2pub.debug(p_message=>'get_ids_persons_updated(-)',
4094: p_prefix=>l_debug_prefix,
4088: p_msg_data=>x_msg_data,
4089: p_msg_type=>'UNEXPECTED ERROR',
4090: p_msg_level=>fnd_log.level_error);
4091: END IF;
4092: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
4093: hz_utility_v2pub.debug(p_message=>'get_ids_persons_updated(-)',
4094: p_prefix=>l_debug_prefix,
4095: p_msg_level=>fnd_log.level_procedure);
4096: END IF;
4091: END IF;
4092: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
4093: hz_utility_v2pub.debug(p_message=>'get_ids_persons_updated(-)',
4094: p_prefix=>l_debug_prefix,
4095: p_msg_level=>fnd_log.level_procedure);
4096: END IF;
4097: WHEN OTHERS THEN
4098: x_return_status := fnd_api.g_ret_sts_unexp_error;
4099:
4105: p_count => x_msg_count,
4106: p_data => x_msg_data);
4107:
4108: -- Debug info.
4109: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
4110: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
4111: p_msg_data=>x_msg_data,
4112: p_msg_type=>'SQL ERROR',
4113: p_msg_level=>fnd_log.level_error);
4109: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
4110: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
4111: p_msg_data=>x_msg_data,
4112: p_msg_type=>'SQL ERROR',
4113: p_msg_level=>fnd_log.level_error);
4114: END IF;
4115: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
4116: hz_utility_v2pub.debug(p_message=>'get_ids_persons_updated(-)',
4117: p_prefix=>l_debug_prefix,
4111: p_msg_data=>x_msg_data,
4112: p_msg_type=>'SQL ERROR',
4113: p_msg_level=>fnd_log.level_error);
4114: END IF;
4115: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
4116: hz_utility_v2pub.debug(p_message=>'get_ids_persons_updated(-)',
4117: p_prefix=>l_debug_prefix,
4118: p_msg_level=>fnd_log.level_procedure);
4119: END IF;
4114: END IF;
4115: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
4116: hz_utility_v2pub.debug(p_message=>'get_ids_persons_updated(-)',
4117: p_prefix=>l_debug_prefix,
4118: p_msg_level=>fnd_log.level_procedure);
4119: END IF;
4120:
4121: end;
4122: