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_BO_PUB dependencies on HZ_UTILITY_V2PUB

Line 361: px_person_rec.created_by_module:= HZ_UTILITY_V2PUB.G_CREATED_BY_MODULE;

357: px_person_rec.internal_flag:= p_person_obj.internal_flag;
358: IF(p_create_or_update = 'C') THEN
359: px_person_rec.party_rec.orig_system:= p_person_os;
360: px_person_rec.party_rec.orig_system_reference:= p_person_osr;
361: px_person_rec.created_by_module:= HZ_UTILITY_V2PUB.G_CREATED_BY_MODULE;
362: END IF;
363: px_person_rec.actual_content_source:= p_person_obj.actual_content_source;
364: px_person_rec.party_rec.party_id:= p_person_id;
365: px_person_rec.party_rec.party_number:= p_person_obj.party_number;

Line 442: px_person_lang_rec.created_by_module := HZ_UTILITY_V2PUB.G_CREATED_BY_MODULE;

438: px_person_lang_rec.spoken_comprehension_level:= p_person_lang_obj.spoken_comprehension_level;
439: IF(p_person_lang_obj.status in ('A','I')) THEN
440: px_person_lang_rec.status := p_person_lang_obj.status;
441: END IF;
442: px_person_lang_rec.created_by_module := HZ_UTILITY_V2PUB.G_CREATED_BY_MODULE;
443: END assign_person_lang_rec;
444:
445: -- PRIVATE PROCEDURE assign_education_rec
446: --

Line 484: px_education_rec.created_by_module:= HZ_UTILITY_V2PUB.G_CREATED_BY_MODULE;

480: px_education_rec.type_of_school:= p_education_obj.type_of_school;
481: IF(p_education_obj.status in ('A','I')) THEN
482: px_education_rec.status:= p_education_obj.status;
483: END IF;
484: px_education_rec.created_by_module:= HZ_UTILITY_V2PUB.G_CREATED_BY_MODULE;
485: END assign_education_rec;
486:
487: -- PRIVATE PROCEDURE assign_citizenship_rec
488: --

Line 526: px_citizenship_rec.created_by_module := HZ_UTILITY_V2PUB.G_CREATED_BY_MODULE;

522: px_citizenship_rec.document_reference := p_citizenship_obj.document_reference;
523: IF(p_citizenship_obj.status in ('A','I')) THEN
524: px_citizenship_rec.status := p_citizenship_obj.status;
525: END IF;
526: px_citizenship_rec.created_by_module := HZ_UTILITY_V2PUB.G_CREATED_BY_MODULE;
527: END assign_citizenship_rec;
528:
529: -- PRIVATE PROCEDURE assign_employ_hist_rec
530: --

Line 581: px_employ_hist_rec.created_by_module := HZ_UTILITY_V2PUB.G_CREATED_BY_MODULE;

577: px_employ_hist_rec.comments := p_employ_hist_obj.comments;
578: IF(p_employ_hist_obj.status in ('A','I')) THEN
579: px_employ_hist_rec.status := p_employ_hist_obj.status;
580: END IF;
581: px_employ_hist_rec.created_by_module := HZ_UTILITY_V2PUB.G_CREATED_BY_MODULE;
582: END assign_employ_hist_rec;
583:
584: -- PRIVATE PROCEDURE assign_work_class_rec
585: --

Line 618: px_work_class_rec.created_by_module := HZ_UTILITY_V2PUB.G_CREATED_BY_MODULE;

614: px_work_class_rec.employment_history_id := p_employ_hist_id;
615: IF(p_work_class_obj.status in ('A','I')) THEN
616: px_work_class_rec.status := p_work_class_obj.status;
617: END IF;
618: px_work_class_rec.created_by_module := HZ_UTILITY_V2PUB.G_CREATED_BY_MODULE;
619: END assign_work_class_rec;
620:
621: -- PRIVATE PROCEDURE assign_interest_rec
622: --

Line 664: px_person_interest_rec.created_by_module := HZ_UTILITY_V2PUB.G_CREATED_BY_MODULE;

660: px_person_interest_rec.since := p_person_interest_obj.since;
661: IF(p_person_interest_obj.status in ('A','I')) THEN
662: px_person_interest_rec.status := p_person_interest_obj.status;
663: END IF;
664: px_person_interest_rec.created_by_module := HZ_UTILITY_V2PUB.G_CREATED_BY_MODULE;
665: END assign_interest_rec;
666:
667: -- PROCEDURE do_create_person_bo
668: --

Line 711: HZ_UTILITY_V2PUB.G_CALLING_API := 'BO_API';

707: FND_MSG_PUB.initialize;
708: END IF;
709:
710: -- initialize Global variable
711: HZ_UTILITY_V2PUB.G_CALLING_API := 'BO_API';
712: IF(p_created_by_module IS NULL) THEN
713: HZ_UTILITY_V2PUB.G_CREATED_BY_MODULE := 'BO_API';
714: ELSE
715: HZ_UTILITY_V2PUB.G_CREATED_BY_MODULE := p_created_by_module;

Line 713: HZ_UTILITY_V2PUB.G_CREATED_BY_MODULE := 'BO_API';

709:
710: -- initialize Global variable
711: HZ_UTILITY_V2PUB.G_CALLING_API := 'BO_API';
712: IF(p_created_by_module IS NULL) THEN
713: HZ_UTILITY_V2PUB.G_CREATED_BY_MODULE := 'BO_API';
714: ELSE
715: HZ_UTILITY_V2PUB.G_CREATED_BY_MODULE := p_created_by_module;
716: END IF;
717:

Line 715: HZ_UTILITY_V2PUB.G_CREATED_BY_MODULE := p_created_by_module;

711: HZ_UTILITY_V2PUB.G_CALLING_API := 'BO_API';
712: IF(p_created_by_module IS NULL) THEN
713: HZ_UTILITY_V2PUB.G_CREATED_BY_MODULE := 'BO_API';
714: ELSE
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

Line 720: hz_utility_v2pub.debug(p_message=>'do_create_person_bo(+)',

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;
724:

Line 923: l_cbm := HZ_UTILITY_V2PUB.G_CREATED_BY_MODULE;

919: RAISE FND_API.G_EXC_ERROR;
920: END IF;
921: END IF;
922:
923: l_cbm := HZ_UTILITY_V2PUB.G_CREATED_BY_MODULE;
924:
925: ----------------------------
926: -- Create logical party site
927: ----------------------------

Line 948: HZ_UTILITY_V2PUB.G_CREATED_BY_MODULE := l_cbm;

944: RAISE FND_API.G_EXC_ERROR;
945: END IF;
946: END IF;
947:
948: HZ_UTILITY_V2PUB.G_CREATED_BY_MODULE := l_cbm;
949:
950: ------------------------
951: -- Create contact points
952: ------------------------

Line 981: HZ_UTILITY_V2PUB.G_CREATED_BY_MODULE := l_cbm;

977: RAISE FND_API.G_EXC_ERROR;
978: END IF;
979: END IF;
980:
981: HZ_UTILITY_V2PUB.G_CREATED_BY_MODULE := l_cbm;
982:
983: ----------------------------
984: -- Certifications
985: ----------------------------

Line 1049: HZ_UTILITY_V2PUB.G_CALLING_API := NULL;

1045: );
1046: END IF;
1047:
1048: -- reset Global variable
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

Line 1050: HZ_UTILITY_V2PUB.G_CREATED_BY_MODULE := NULL;

1046: END IF;
1047:
1048: -- reset Global variable
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,

Line 1054: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,

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);
1058: END IF;

Line 1060: hz_utility_v2pub.debug(p_message=>'do_create_person_bo(-)',

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;
1064:

Line 1070: HZ_UTILITY_V2PUB.G_CALLING_API := NULL;

1066: WHEN fnd_api.g_exc_error THEN
1067: ROLLBACK TO do_create_person_bo_pub;
1068:
1069: -- reset Global variable
1070: HZ_UTILITY_V2PUB.G_CALLING_API := NULL;
1071: HZ_UTILITY_V2PUB.G_CREATED_BY_MODULE := NULL;
1072:
1073: FND_MESSAGE.SET_NAME('AR', 'HZ_API_PROPAGATE_OBJECT_ERROR');
1074: FND_MESSAGE.SET_TOKEN('OBJECT', 'PERSON');

Line 1071: HZ_UTILITY_V2PUB.G_CREATED_BY_MODULE := NULL;

1067: ROLLBACK TO do_create_person_bo_pub;
1068:
1069: -- reset Global variable
1070: HZ_UTILITY_V2PUB.G_CALLING_API := NULL;
1071: HZ_UTILITY_V2PUB.G_CREATED_BY_MODULE := NULL;
1072:
1073: FND_MESSAGE.SET_NAME('AR', 'HZ_API_PROPAGATE_OBJECT_ERROR');
1074: FND_MESSAGE.SET_TOKEN('OBJECT', 'PERSON');
1075: FND_MSG_PUB.ADD;

Line 1085: hz_utility_v2pub.debug_return_messages(p_msg_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);
1089: END IF;

Line 1091: hz_utility_v2pub.debug(p_message=>'do_create_person_bo(-)',

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;
1095:

Line 1100: HZ_UTILITY_V2PUB.G_CALLING_API := NULL;

1096: WHEN fnd_api.g_exc_unexpected_error THEN
1097: ROLLBACK TO do_create_person_bo_pub;
1098:
1099: -- reset Global variable
1100: HZ_UTILITY_V2PUB.G_CALLING_API := NULL;
1101: HZ_UTILITY_V2PUB.G_CREATED_BY_MODULE := NULL;
1102:
1103: FND_MESSAGE.SET_NAME('AR', 'HZ_API_PROPAGATE_OBJECT_ERROR');
1104: FND_MESSAGE.SET_TOKEN('OBJECT', 'PERSON');

Line 1101: HZ_UTILITY_V2PUB.G_CREATED_BY_MODULE := NULL;

1097: ROLLBACK TO do_create_person_bo_pub;
1098:
1099: -- reset Global variable
1100: HZ_UTILITY_V2PUB.G_CALLING_API := NULL;
1101: HZ_UTILITY_V2PUB.G_CREATED_BY_MODULE := NULL;
1102:
1103: FND_MESSAGE.SET_NAME('AR', 'HZ_API_PROPAGATE_OBJECT_ERROR');
1104: FND_MESSAGE.SET_TOKEN('OBJECT', 'PERSON');
1105: FND_MSG_PUB.ADD;

Line 1115: hz_utility_v2pub.debug_return_messages(p_msg_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);
1119: END IF;

Line 1121: hz_utility_v2pub.debug(p_message=>'do_create_person_bo(-)',

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;
1125:

Line 1130: HZ_UTILITY_V2PUB.G_CALLING_API := NULL;

1126: WHEN OTHERS THEN
1127: ROLLBACK TO do_create_person_bo_pub;
1128:
1129: -- reset Global variable
1130: HZ_UTILITY_V2PUB.G_CALLING_API := NULL;
1131: HZ_UTILITY_V2PUB.G_CREATED_BY_MODULE := NULL;
1132:
1133: FND_MESSAGE.SET_NAME('AR', 'HZ_API_PROPAGATE_OBJECT_ERROR');
1134: FND_MESSAGE.SET_TOKEN('OBJECT', 'PERSON');

Line 1131: HZ_UTILITY_V2PUB.G_CREATED_BY_MODULE := NULL;

1127: ROLLBACK TO do_create_person_bo_pub;
1128:
1129: -- reset Global variable
1130: HZ_UTILITY_V2PUB.G_CALLING_API := NULL;
1131: HZ_UTILITY_V2PUB.G_CREATED_BY_MODULE := NULL;
1132:
1133: FND_MESSAGE.SET_NAME('AR', 'HZ_API_PROPAGATE_OBJECT_ERROR');
1134: FND_MESSAGE.SET_TOKEN('OBJECT', 'PERSON');
1135: FND_MSG_PUB.ADD;

Line 1149: hz_utility_v2pub.debug_return_messages(p_msg_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);
1153: END IF;

Line 1155: hz_utility_v2pub.debug(p_message=>'do_create_person_bo(-)',

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;
1159: END do_create_person_bo;

Line 1284: HZ_UTILITY_V2PUB.G_CALLING_API := 'BO_API';

1280: FND_MSG_PUB.initialize;
1281: END IF;
1282:
1283: -- initialize Global variable
1284: HZ_UTILITY_V2PUB.G_CALLING_API := 'BO_API';
1285: IF(p_created_by_module IS NULL) THEN
1286: HZ_UTILITY_V2PUB.G_CREATED_BY_MODULE := 'BO_API';
1287: ELSE
1288: HZ_UTILITY_V2PUB.G_CREATED_BY_MODULE := p_created_by_module;

Line 1286: HZ_UTILITY_V2PUB.G_CREATED_BY_MODULE := 'BO_API';

1282:
1283: -- initialize Global variable
1284: HZ_UTILITY_V2PUB.G_CALLING_API := 'BO_API';
1285: IF(p_created_by_module IS NULL) THEN
1286: HZ_UTILITY_V2PUB.G_CREATED_BY_MODULE := 'BO_API';
1287: ELSE
1288: HZ_UTILITY_V2PUB.G_CREATED_BY_MODULE := p_created_by_module;
1289: END IF;
1290:

Line 1288: HZ_UTILITY_V2PUB.G_CREATED_BY_MODULE := p_created_by_module;

1284: HZ_UTILITY_V2PUB.G_CALLING_API := 'BO_API';
1285: IF(p_created_by_module IS NULL) THEN
1286: HZ_UTILITY_V2PUB.G_CREATED_BY_MODULE := 'BO_API';
1287: ELSE
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

Line 1293: hz_utility_v2pub.debug(p_message=>'do_update_person_bo(+)',

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;
1297:

Line 1507: l_cbm := HZ_UTILITY_V2PUB.G_CREATED_BY_MODULE;

1503: RAISE FND_API.G_EXC_ERROR;
1504: END IF;
1505: END IF;
1506:
1507: l_cbm := HZ_UTILITY_V2PUB.G_CREATED_BY_MODULE;
1508:
1509: -----------------
1510: -- For Party Site
1511: -----------------

Line 1532: HZ_UTILITY_V2PUB.G_CREATED_BY_MODULE := l_cbm;

1528: RAISE FND_API.G_EXC_ERROR;
1529: END IF;
1530: END IF;
1531:
1532: HZ_UTILITY_V2PUB.G_CREATED_BY_MODULE := l_cbm;
1533:
1534: ---------------------
1535: -- For Contact Points
1536: ---------------------

Line 1565: HZ_UTILITY_V2PUB.G_CREATED_BY_MODULE := l_cbm;

1561: RAISE FND_API.G_EXC_ERROR;
1562: END IF;
1563: END IF;
1564:
1565: HZ_UTILITY_V2PUB.G_CREATED_BY_MODULE := l_cbm;
1566:
1567: ---------------------
1568: -- Certifications
1569: ---------------------

Line 1643: HZ_UTILITY_V2PUB.G_CALLING_API := NULL;

1639: );
1640: END IF;
1641:
1642: -- reset Global variable
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

Line 1644: HZ_UTILITY_V2PUB.G_CREATED_BY_MODULE := NULL;

1640: END IF;
1641:
1642: -- reset Global variable
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,

Line 1648: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,

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);
1652: END IF;

Line 1654: hz_utility_v2pub.debug(p_message=>'do_update_person_bo(-)',

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;
1658: EXCEPTION

Line 1663: HZ_UTILITY_V2PUB.G_CALLING_API := NULL;

1659: WHEN fnd_api.g_exc_error THEN
1660: ROLLBACK TO do_update_person_bo_pub;
1661:
1662: -- reset Global variable
1663: HZ_UTILITY_V2PUB.G_CALLING_API := NULL;
1664: HZ_UTILITY_V2PUB.G_CREATED_BY_MODULE := NULL;
1665:
1666: FND_MESSAGE.SET_NAME('AR', 'HZ_API_PROPAGATE_OBJECT_ERROR');
1667: FND_MESSAGE.SET_TOKEN('OBJECT', 'PERSON');

Line 1664: HZ_UTILITY_V2PUB.G_CREATED_BY_MODULE := NULL;

1660: ROLLBACK TO do_update_person_bo_pub;
1661:
1662: -- reset Global variable
1663: HZ_UTILITY_V2PUB.G_CALLING_API := NULL;
1664: HZ_UTILITY_V2PUB.G_CREATED_BY_MODULE := NULL;
1665:
1666: FND_MESSAGE.SET_NAME('AR', 'HZ_API_PROPAGATE_OBJECT_ERROR');
1667: FND_MESSAGE.SET_TOKEN('OBJECT', 'PERSON');
1668: FND_MSG_PUB.ADD;

Line 1678: hz_utility_v2pub.debug_return_messages(p_msg_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);
1682: END IF;

Line 1684: hz_utility_v2pub.debug(p_message=>'do_update_person_bo(-)',

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;
1688:

Line 1694: HZ_UTILITY_V2PUB.G_CALLING_API := NULL;

1690: WHEN fnd_api.g_exc_unexpected_error THEN
1691: ROLLBACK TO do_update_person_bo_pub;
1692:
1693: -- reset Global variable
1694: HZ_UTILITY_V2PUB.G_CALLING_API := NULL;
1695: HZ_UTILITY_V2PUB.G_CREATED_BY_MODULE := NULL;
1696:
1697: FND_MESSAGE.SET_NAME('AR', 'HZ_API_PROPAGATE_OBJECT_ERROR');
1698: FND_MESSAGE.SET_TOKEN('OBJECT', 'PERSON');

Line 1695: HZ_UTILITY_V2PUB.G_CREATED_BY_MODULE := NULL;

1691: ROLLBACK TO do_update_person_bo_pub;
1692:
1693: -- reset Global variable
1694: HZ_UTILITY_V2PUB.G_CALLING_API := NULL;
1695: HZ_UTILITY_V2PUB.G_CREATED_BY_MODULE := NULL;
1696:
1697: FND_MESSAGE.SET_NAME('AR', 'HZ_API_PROPAGATE_OBJECT_ERROR');
1698: FND_MESSAGE.SET_TOKEN('OBJECT', 'PERSON');
1699: FND_MSG_PUB.ADD;

Line 1709: hz_utility_v2pub.debug_return_messages(p_msg_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);
1713: END IF;

Line 1715: hz_utility_v2pub.debug(p_message=>'do_update_person_bo(-)',

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;
1719: WHEN OTHERS THEN

Line 1723: HZ_UTILITY_V2PUB.G_CALLING_API := NULL;

1719: WHEN OTHERS THEN
1720: ROLLBACK TO do_update_person_bo_pub;
1721:
1722: -- reset Global variable
1723: HZ_UTILITY_V2PUB.G_CALLING_API := NULL;
1724: HZ_UTILITY_V2PUB.G_CREATED_BY_MODULE := NULL;
1725:
1726: FND_MESSAGE.SET_NAME('AR', 'HZ_API_PROPAGATE_OBJECT_ERROR');
1727: FND_MESSAGE.SET_TOKEN('OBJECT', 'PERSON');

Line 1724: HZ_UTILITY_V2PUB.G_CREATED_BY_MODULE := NULL;

1720: ROLLBACK TO do_update_person_bo_pub;
1721:
1722: -- reset Global variable
1723: HZ_UTILITY_V2PUB.G_CALLING_API := NULL;
1724: HZ_UTILITY_V2PUB.G_CREATED_BY_MODULE := NULL;
1725:
1726: FND_MESSAGE.SET_NAME('AR', 'HZ_API_PROPAGATE_OBJECT_ERROR');
1727: FND_MESSAGE.SET_TOKEN('OBJECT', 'PERSON');
1728: FND_MSG_PUB.ADD;

Line 1742: hz_utility_v2pub.debug_return_messages(p_msg_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);
1746: END IF;

Line 1748: hz_utility_v2pub.debug(p_message=>'do_update_person_bo(-)',

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;
1752: END do_update_person_bo;

Line 1853: hz_utility_v2pub.debug(p_message=>'do_save_person_bo(+)',

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;
1857:

Line 1918: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,

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);
1922: END IF;

Line 1924: hz_utility_v2pub.debug(p_message=>'do_save_person_bo(-)',

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;
1928: EXCEPTION

Line 1938: hz_utility_v2pub.debug_return_messages(p_msg_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);
1942: END IF;

Line 1944: hz_utility_v2pub.debug(p_message=>'do_save_person_bo(-)',

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;
1948:

Line 1958: hz_utility_v2pub.debug_return_messages(p_msg_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);
1962: END IF;

Line 1964: hz_utility_v2pub.debug(p_message=>'do_save_person_bo(-)',

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;
1968: WHEN OTHERS THEN

Line 1981: hz_utility_v2pub.debug_return_messages(p_msg_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);
1985: END IF;

Line 1987: hz_utility_v2pub.debug(p_message=>'do_save_person_bo(-)',

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;
1991: END do_save_person_bo;

Line 2122: hz_utility_v2pub.debug(p_message=>'create_person_info(+)',

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;
2126:

Line 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,

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;
2152: FND_MESSAGE.SET_NAME('AR', 'HZ_API_PROPAGATE_ENTITY_ERROR');

Line 2184: hz_utility_v2pub.debug(p_message=>'Create Education - Error occurred at hz_person_bo_pub.create_person_info, person id: '||p_person_id,

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;
2188: FND_MESSAGE.SET_NAME('AR', 'HZ_API_PROPAGATE_ENTITY_ERROR');

Line 2220: hz_utility_v2pub.debug(p_message=>'Create Citizenship - Error occurred at hz_person_bo_pub.create_person_info, person id: '||p_person_id,

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;
2224: FND_MESSAGE.SET_NAME('AR', 'HZ_API_PROPAGATE_ENTITY_ERROR');

Line 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,

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;
2260: FND_MESSAGE.SET_NAME('AR', 'HZ_API_PROPAGATE_STRUCT_ERROR');

Line 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,

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;
2295: FND_MESSAGE.SET_NAME('AR', 'HZ_API_PROPAGATE_ENTITY_ERROR');

Line 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,

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;
2334: FND_MESSAGE.SET_NAME('AR', 'HZ_API_PROPAGATE_ENTITY_ERROR');

Line 2347: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,

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);
2351: END IF;

Line 2353: hz_utility_v2pub.debug(p_message=>'create_person_info(-)',

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;
2357: EXCEPTION

Line 2368: hz_utility_v2pub.debug_return_messages(p_msg_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);
2372: END IF;

Line 2374: hz_utility_v2pub.debug(p_message=>'create_person_info(-)',

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;
2378: WHEN fnd_api.g_exc_unexpected_error THEN

Line 2388: hz_utility_v2pub.debug_return_messages(p_msg_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);
2392: END IF;

Line 2394: hz_utility_v2pub.debug(p_message=>'create_person_info(-)',

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;
2398:

Line 2413: hz_utility_v2pub.debug_return_messages(p_msg_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);
2417: END IF;

Line 2419: hz_utility_v2pub.debug(p_message=>'create_person_info(-)',

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;
2423: END create_person_info;

Line 2485: hz_utility_v2pub.debug(p_message=>'save_person_info(+)',

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;
2489:

Line 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,

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;
2514: FND_MESSAGE.SET_NAME('AR', 'HZ_API_INVALID_ID');

Line 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,

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;
2553: FND_MESSAGE.SET_NAME('AR', 'HZ_API_PROPAGATE_ENTITY_ERROR');

Line 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,

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;
2587: FND_MESSAGE.SET_NAME('AR', 'HZ_API_INVALID_ID');

Line 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,

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;
2626: FND_MESSAGE.SET_NAME('AR', 'HZ_API_PROPAGATE_ENTITY_ERROR');

Line 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,

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;
2658: FND_MESSAGE.SET_NAME('AR', 'HZ_API_INVALID_ID');

Line 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,

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;
2697: FND_MESSAGE.SET_NAME('AR', 'HZ_API_PROPAGATE_ENTITY_ERROR');

Line 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,

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;
2731: FND_MESSAGE.SET_NAME('AR', 'HZ_API_INVALID_ID');

Line 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,

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;
2771: FND_MESSAGE.SET_NAME('AR', 'HZ_API_PROPAGATE_STRUCT_ERROR');

Line 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,

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;
2800: FND_MESSAGE.SET_NAME('AR', 'HZ_API_INVALID_ID');

Line 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,

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;
2839: FND_MESSAGE.SET_NAME('AR', 'HZ_API_PROPAGATE_ENTITY_ERROR');

Line 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,

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;
2876: FND_MESSAGE.SET_NAME('AR', 'HZ_API_INVALID_ID');

Line 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,

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;
2915: FND_MESSAGE.SET_NAME('AR', 'HZ_API_PROPAGATE_ENTITY_ERROR');

Line 2925: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,

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);
2929: END IF;

Line 2931: hz_utility_v2pub.debug(p_message=>'save_person_info(-)',

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;
2935: EXCEPTION

Line 2946: hz_utility_v2pub.debug_return_messages(p_msg_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);
2950: END IF;

Line 2952: hz_utility_v2pub.debug(p_message=>'save_person_info(-)',

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;
2956: WHEN fnd_api.g_exc_unexpected_error THEN

Line 2966: hz_utility_v2pub.debug_return_messages(p_msg_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);
2970: END IF;

Line 2972: hz_utility_v2pub.debug(p_message=>'save_person_info(-)',

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;
2976:

Line 2991: hz_utility_v2pub.debug_return_messages(p_msg_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);
2995: END IF;

Line 2997: hz_utility_v2pub.debug(p_message=>'save_person_info(-)',

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;
3001: END save_person_info;

Line 3100: hz_utility_v2pub.debug(p_message=>'hz_person_bo_pub.get_person_bo(+)',

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;
3104:

Line 3141: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,

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);
3145: END IF;

Line 3149: hz_utility_v2pub.debug(p_message=>'hz_person_bo_pub.get_person_bo (-)',

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;
3153:

Line 3166: hz_utility_v2pub.debug_return_messages(p_msg_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);
3170: END IF;

Line 3172: hz_utility_v2pub.debug(p_message=>'hz_person_bo_pub.get_person_bo (-)',

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;
3176: WHEN fnd_api.g_exc_unexpected_error THEN

Line 3185: hz_utility_v2pub.debug_return_messages(p_msg_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);
3189: END IF;

Line 3191: hz_utility_v2pub.debug(p_message=>'hz_person_bo_pub.get_person_bo (-)',

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;
3195: WHEN OTHERS THEN

Line 3208: hz_utility_v2pub.debug_return_messages(p_msg_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);
3212: END IF;

Line 3214: hz_utility_v2pub.debug(p_message=>'hz_person_bo_pub.get_person_bo (-)',

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;
3218:

Line 3319: hz_utility_v2pub.debug(p_message=>'hz_person_bo_pub.get_persons_created(+)',

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;
3323:

Line 3351: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,

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);
3355: END IF;

Line 3359: hz_utility_v2pub.debug(p_message=>'hz_person_bo_pub.get_persons_created (-)',

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;
3363:

Line 3376: hz_utility_v2pub.debug_return_messages(p_msg_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);
3380: END IF;

Line 3382: hz_utility_v2pub.debug(p_message=>'hz_person_bo_pub.get_persons_created(-)',

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;
3386: WHEN fnd_api.g_exc_unexpected_error THEN

Line 3395: hz_utility_v2pub.debug_return_messages(p_msg_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);
3399: END IF;

Line 3401: hz_utility_v2pub.debug(p_message=>'hz_person_bo_pub.get_persons_created(-)',

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;
3405: WHEN OTHERS THEN

Line 3418: hz_utility_v2pub.debug_return_messages(p_msg_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);
3422: END IF;

Line 3424: hz_utility_v2pub.debug(p_message=>'hz_person_bo_pub.get_persons_created(-)',

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;
3428:

Line 3522: hz_utility_v2pub.debug(p_message=>'hz_person_bo_pub.get_persons_updated(+)',

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;
3526:

Line 3553: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,

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);
3557: END IF;

Line 3561: hz_utility_v2pub.debug(p_message=>'hz_person_bo_pub.get_persons_updated (-)',

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;
3565:

Line 3578: hz_utility_v2pub.debug_return_messages(p_msg_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);
3582: END IF;

Line 3584: hz_utility_v2pub.debug(p_message=>'hz_person_bo_pub.get_persons_updated(-)',

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;
3588: WHEN fnd_api.g_exc_unexpected_error THEN

Line 3597: hz_utility_v2pub.debug_return_messages(p_msg_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);
3601: END IF;

Line 3603: hz_utility_v2pub.debug(p_message=>'hz_person_bo_pub.get_persons_updated(-)',

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;
3607: WHEN OTHERS THEN

Line 3620: hz_utility_v2pub.debug_return_messages(p_msg_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);
3624: END IF;

Line 3626: hz_utility_v2pub.debug(p_message=>'hz_person_bo_pub.get_persons_updated(-)',

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;
3630:

Line 3716: hz_utility_v2pub.debug(p_message=>'hz_person_bo_pub.get_person_updated(+)',

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;
3720:

Line 3749: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,

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);
3753: END IF;

Line 3757: hz_utility_v2pub.debug(p_message=>'hz_person_bo_pub.get_person_updated (-)',

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;
3761:

Line 3774: hz_utility_v2pub.debug_return_messages(p_msg_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);
3778: END IF;

Line 3780: hz_utility_v2pub.debug(p_message=>'hz_person_bo_pub.get_person_updated(-)',

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;
3784: WHEN fnd_api.g_exc_unexpected_error THEN

Line 3793: hz_utility_v2pub.debug_return_messages(p_msg_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);
3797: END IF;

Line 3799: hz_utility_v2pub.debug(p_message=>'hz_person_bo_pub.get_person_updated(-)',

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;
3803: WHEN OTHERS THEN

Line 3816: hz_utility_v2pub.debug_return_messages(p_msg_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);
3820: END IF;

Line 3822: hz_utility_v2pub.debug(p_message=>'hz_person_bo_pub.get_person_updated(-)',

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;
3826:

Line 3878: hz_utility_v2pub.debug(p_message=>'get_ids_persons_created(+)',

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;
3882:

Line 3909: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,

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);
3913: END IF;

Line 3917: hz_utility_v2pub.debug(p_message=>'get_ids_persons_created (-)',

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;
3921:

Line 3934: hz_utility_v2pub.debug_return_messages(p_msg_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);
3938: END IF;

Line 3940: hz_utility_v2pub.debug(p_message=>'get_ids_persons_created(-)',

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;
3944: WHEN fnd_api.g_exc_unexpected_error THEN

Line 3953: hz_utility_v2pub.debug_return_messages(p_msg_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);
3957: END IF;

Line 3959: hz_utility_v2pub.debug(p_message=>'get_ids_persons_created(-)',

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;
3963: WHEN OTHERS THEN

Line 3976: hz_utility_v2pub.debug_return_messages(p_msg_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);
3980: END IF;

Line 3982: hz_utility_v2pub.debug(p_message=>'get_ids_persons_created(-)',

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;
3986:

Line 4013: hz_utility_v2pub.debug(p_message=>'get_ids_persons_updated(+)',

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;
4017:

Line 4043: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,

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);
4047: END IF;

Line 4051: hz_utility_v2pub.debug(p_message=>'get_ids_persons_updated (-)',

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;
4055:

Line 4068: hz_utility_v2pub.debug_return_messages(p_msg_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);
4072: END IF;

Line 4074: hz_utility_v2pub.debug(p_message=>'get_ids_persons_updated(-)',

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;
4078: WHEN fnd_api.g_exc_unexpected_error THEN

Line 4087: hz_utility_v2pub.debug_return_messages(p_msg_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);
4091: END IF;

Line 4093: hz_utility_v2pub.debug(p_message=>'get_ids_persons_updated(-)',

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;
4097: WHEN OTHERS THEN

Line 4110: hz_utility_v2pub.debug_return_messages(p_msg_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);
4114: END IF;

Line 4116: hz_utility_v2pub.debug(p_message=>'get_ids_persons_updated(-)',

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;
4120: