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 740: HZ_UTILITY_V2PUB.G_CALLING_API := 'BO_API';

736: FND_MSG_PUB.initialize;
737: END IF;
738:
739: -- initialize Global variable
740: HZ_UTILITY_V2PUB.G_CALLING_API := 'BO_API';
741: IF(p_created_by_module IS NULL) THEN
742: HZ_UTILITY_V2PUB.G_CREATED_BY_MODULE := 'BO_API';
743: ELSE
744: HZ_UTILITY_V2PUB.G_CREATED_BY_MODULE := p_created_by_module;

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

738:
739: -- initialize Global variable
740: HZ_UTILITY_V2PUB.G_CALLING_API := 'BO_API';
741: IF(p_created_by_module IS NULL) THEN
742: HZ_UTILITY_V2PUB.G_CREATED_BY_MODULE := 'BO_API';
743: ELSE
744: HZ_UTILITY_V2PUB.G_CREATED_BY_MODULE := p_created_by_module;
745: END IF;
746:

Line 744: HZ_UTILITY_V2PUB.G_CREATED_BY_MODULE := p_created_by_module;

740: HZ_UTILITY_V2PUB.G_CALLING_API := 'BO_API';
741: IF(p_created_by_module IS NULL) THEN
742: HZ_UTILITY_V2PUB.G_CREATED_BY_MODULE := 'BO_API';
743: ELSE
744: HZ_UTILITY_V2PUB.G_CREATED_BY_MODULE := p_created_by_module;
745: END IF;
746:
747: -- Debug info.
748: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN

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

745: END IF;
746:
747: -- Debug info.
748: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
749: hz_utility_v2pub.debug(p_message=>'do_create_person_bo(+)',
750: p_prefix=>l_debug_prefix,
751: p_msg_level=>fnd_log.level_procedure);
752: END IF;
753:

Line 952: l_cbm := HZ_UTILITY_V2PUB.G_CREATED_BY_MODULE;

948: RAISE FND_API.G_EXC_ERROR;
949: END IF;
950: END IF;
951:
952: l_cbm := HZ_UTILITY_V2PUB.G_CREATED_BY_MODULE;
953:
954: ----------------------------
955: -- Create logical party site
956: ----------------------------

Line 977: HZ_UTILITY_V2PUB.G_CREATED_BY_MODULE := l_cbm;

973: RAISE FND_API.G_EXC_ERROR;
974: END IF;
975: END IF;
976:
977: HZ_UTILITY_V2PUB.G_CREATED_BY_MODULE := l_cbm;
978:
979: ------------------------
980: -- Create contact points
981: ------------------------

Line 1010: HZ_UTILITY_V2PUB.G_CREATED_BY_MODULE := l_cbm;

1006: RAISE FND_API.G_EXC_ERROR;
1007: END IF;
1008: END IF;
1009:
1010: HZ_UTILITY_V2PUB.G_CREATED_BY_MODULE := l_cbm;
1011:
1012: ----------------------------
1013: -- Certifications
1014: ----------------------------

Line 1085: hz_utility_v2pub.debug(p_message=>'Enable DQ on Integration Services: START ',p_prefix=>'DEBUG: ',p_msg_level=>fnd_log.level_statement, p_module=>'HZ_Module.enableDQ');

1081:
1082: l_match_rule_id := nvl(fnd_profile.value('HZ_BO_PERSON_MATCH_RULE'), 240); -- 240: new person match rule
1083:
1084: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
1085: hz_utility_v2pub.debug(p_message=>'Enable DQ on Integration Services: START ',p_prefix=>'DEBUG: ',p_msg_level=>fnd_log.level_statement, p_module=>'HZ_Module.enableDQ');
1086: hz_utility_v2pub.debug(p_message=>'Match Rule ID '||l_match_rule_id,p_prefix=>'DEBUG: ',p_msg_level=>fnd_log.level_statement, p_module=>'HZ_Module.enableDQ');
1087: hz_utility_v2pub.debug(p_message=>'Newly Created Party Id: '||x_person_id,p_prefix=>'DEBUG: ',p_msg_level=>fnd_log.level_statement, p_module=>'HZ_Module.enableDQ');
1088: END IF;
1089:

Line 1086: hz_utility_v2pub.debug(p_message=>'Match Rule ID '||l_match_rule_id,p_prefix=>'DEBUG: ',p_msg_level=>fnd_log.level_statement, p_module=>'HZ_Module.enableDQ');

1082: l_match_rule_id := nvl(fnd_profile.value('HZ_BO_PERSON_MATCH_RULE'), 240); -- 240: new person match rule
1083:
1084: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
1085: hz_utility_v2pub.debug(p_message=>'Enable DQ on Integration Services: START ',p_prefix=>'DEBUG: ',p_msg_level=>fnd_log.level_statement, p_module=>'HZ_Module.enableDQ');
1086: hz_utility_v2pub.debug(p_message=>'Match Rule ID '||l_match_rule_id,p_prefix=>'DEBUG: ',p_msg_level=>fnd_log.level_statement, p_module=>'HZ_Module.enableDQ');
1087: hz_utility_v2pub.debug(p_message=>'Newly Created Party Id: '||x_person_id,p_prefix=>'DEBUG: ',p_msg_level=>fnd_log.level_statement, p_module=>'HZ_Module.enableDQ');
1088: END IF;
1089:
1090: l_party_search_rec.JGZZ_FISCAL_CODE := l_person_rec.JGZZ_FISCAL_CODE;

Line 1087: hz_utility_v2pub.debug(p_message=>'Newly Created Party Id: '||x_person_id,p_prefix=>'DEBUG: ',p_msg_level=>fnd_log.level_statement, p_module=>'HZ_Module.enableDQ');

1083:
1084: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
1085: hz_utility_v2pub.debug(p_message=>'Enable DQ on Integration Services: START ',p_prefix=>'DEBUG: ',p_msg_level=>fnd_log.level_statement, p_module=>'HZ_Module.enableDQ');
1086: hz_utility_v2pub.debug(p_message=>'Match Rule ID '||l_match_rule_id,p_prefix=>'DEBUG: ',p_msg_level=>fnd_log.level_statement, p_module=>'HZ_Module.enableDQ');
1087: hz_utility_v2pub.debug(p_message=>'Newly Created Party Id: '||x_person_id,p_prefix=>'DEBUG: ',p_msg_level=>fnd_log.level_statement, p_module=>'HZ_Module.enableDQ');
1088: END IF;
1089:
1090: l_party_search_rec.JGZZ_FISCAL_CODE := l_person_rec.JGZZ_FISCAL_CODE;
1091: l_party_search_rec.PARTY_ALL_NAMES := hz_format_pub.format_name(x_person_id)|| ' ' ||

Line 1131: hz_utility_v2pub.debug(p_message=>'l_party_search_rec.PARTY_NAME(formatted): '||l_party_search_rec.PARTY_NAME,p_prefix=>'DEBUG: ',p_msg_level=>fnd_log.level_statement, p_module=>'HZ_Module.enableDQ');

1127: l_party_search_rec.PERSON_LAST_NAME_PHONETIC := l_person_rec.PERSON_LAST_NAME_PHONETIC;
1128: l_party_search_rec.PERSON_MIDDLE_NAME := l_person_rec.PERSON_MIDDLE_NAME;
1129: l_party_search_rec.PERSON_NAME := l_party_search_rec.PARTY_NAME;
1130: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
1131: hz_utility_v2pub.debug(p_message=>'l_party_search_rec.PARTY_NAME(formatted): '||l_party_search_rec.PARTY_NAME,p_prefix=>'DEBUG: ',p_msg_level=>fnd_log.level_statement, p_module=>'HZ_Module.enableDQ');
1132:
1133: END IF;
1134:
1135: l_party_search_rec.PERSON_NAME_PHONETIC := l_person_rec.PERSON_NAME_PHONETIC;

Line 1170: hz_utility_v2pub.debug(p_message=>'l_party_site_list('||i||').address: '||l_party_site_list(i).ADDRESS,p_prefix=>'DEBUG: ',p_msg_level=>fnd_log.level_statement, p_module=>'HZ_Module.enableDQ');

1166: l_party_site_list(i).POSTAL_PLUS4_CODE := p_person_obj.party_site_objs(i).location_obj.POSTAL_PLUS4_CODE;
1167: l_party_site_list(i).PROVINCE := p_person_obj.party_site_objs(i).location_obj.PROVINCE;
1168:
1169: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
1170: hz_utility_v2pub.debug(p_message=>'l_party_site_list('||i||').address: '||l_party_site_list(i).ADDRESS,p_prefix=>'DEBUG: ',p_msg_level=>fnd_log.level_statement, p_module=>'HZ_Module.enableDQ');
1171: hz_utility_v2pub.debug(p_message=>'l_party_site_list('||i||').postal_code: '||l_party_site_list(i).POSTAL_CODE,p_prefix=>'DEBUG: ',p_msg_level=>fnd_log.level_statement, p_module=>'HZ_Module.enableDQ');
1172: END IF;
1173: l_party_site_list(i).SALES_TAX_GEOCODE := p_person_obj.party_site_objs(i).location_obj.SALES_TAX_GEOCODE;
1174: l_party_site_list(i).SALES_TAX_INSIDE_CITY_LIMITS := p_person_obj.party_site_objs(i).location_obj.SALES_TAX_INSIDE_CITY_LIMITS;

Line 1171: hz_utility_v2pub.debug(p_message=>'l_party_site_list('||i||').postal_code: '||l_party_site_list(i).POSTAL_CODE,p_prefix=>'DEBUG: ',p_msg_level=>fnd_log.level_statement, p_module=>'HZ_Module.enableDQ');

1167: l_party_site_list(i).PROVINCE := p_person_obj.party_site_objs(i).location_obj.PROVINCE;
1168:
1169: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
1170: hz_utility_v2pub.debug(p_message=>'l_party_site_list('||i||').address: '||l_party_site_list(i).ADDRESS,p_prefix=>'DEBUG: ',p_msg_level=>fnd_log.level_statement, p_module=>'HZ_Module.enableDQ');
1171: hz_utility_v2pub.debug(p_message=>'l_party_site_list('||i||').postal_code: '||l_party_site_list(i).POSTAL_CODE,p_prefix=>'DEBUG: ',p_msg_level=>fnd_log.level_statement, p_module=>'HZ_Module.enableDQ');
1172: END IF;
1173: l_party_site_list(i).SALES_TAX_GEOCODE := p_person_obj.party_site_objs(i).location_obj.SALES_TAX_GEOCODE;
1174: l_party_site_list(i).SALES_TAX_INSIDE_CITY_LIMITS := p_person_obj.party_site_objs(i).location_obj.SALES_TAX_INSIDE_CITY_LIMITS;
1175: l_party_site_list(i).STATE := p_person_obj.party_site_objs(i).location_obj.STATE;

Line 1206: hz_utility_v2pub.debug(p_message=>'l_contact_point_list('||i||')'||'.phone_number'||l_contact_point_list(i).PHONE_NUMBER,p_prefix=>'DEBUG: ',p_msg_level=>fnd_log.level_statement, p_module=>'HZ_Module.enableDQ');

1202: l_contact_point_list(i).RAW_PHONE_NUMBER := p_person_obj.phone_objs(i).RAW_PHONE_NUMBER;
1203: l_contact_point_list(i).TELEPHONE_TYPE := p_person_obj.phone_objs(i).PHONE_LINE_TYPE;
1204: l_contact_point_list(i).TIME_ZONE := p_person_obj.phone_objs(i).TIMEZONE_ID;
1205: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
1206: hz_utility_v2pub.debug(p_message=>'l_contact_point_list('||i||')'||'.phone_number'||l_contact_point_list(i).PHONE_NUMBER,p_prefix=>'DEBUG: ',p_msg_level=>fnd_log.level_statement, p_module=>'HZ_Module.enableDQ');
1207: end if;
1208: -- Per DQM, flex_formatted_phone_number is the concate of country code, area code and phone number
1209: if p_person_obj.phone_objs(i).PHONE_NUMBER is not null
1210: then

Line 1229: hz_utility_v2pub.debug(p_message=>'l_contact_point_list('||to_char(i)||').flex_format_phone_number: '||l_contact_point_list(i).FLEX_FORMAT_PHONE_NUMBER,p_prefix=>'DEBUG: ',p_msg_level=>fnd_log.level_statement, p_module=>'HZ_Module.enableDQ');

1225: l_contact_point_list(i).FLEX_FORMAT_PHONE_NUMBER := l_contact_point_list(i).PHONE_COUNTRY_CODE ||l_contact_point_list(i).PHONE_AREA_CODE||l_contact_point_list(i).PHONE_NUMBER;
1226:
1227: end if;
1228: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
1229: hz_utility_v2pub.debug(p_message=>'l_contact_point_list('||to_char(i)||').flex_format_phone_number: '||l_contact_point_list(i).FLEX_FORMAT_PHONE_NUMBER,p_prefix=>'DEBUG: ',p_msg_level=>fnd_log.level_statement, p_module=>'HZ_Module.enableDQ');
1230: hz_utility_v2pub.debug(p_message=>'l_contact_point_list('||i||').phone_number(parsed): '||l_contact_point_list(i).PHONE_NUMBER,p_prefix=>'DEBUG: ',p_msg_level=>fnd_log.level_statement, p_module=>'HZ_Module.enableDQ');
1231: END IF;
1232: end loop;
1233: end if;

Line 1230: hz_utility_v2pub.debug(p_message=>'l_contact_point_list('||i||').phone_number(parsed): '||l_contact_point_list(i).PHONE_NUMBER,p_prefix=>'DEBUG: ',p_msg_level=>fnd_log.level_statement, p_module=>'HZ_Module.enableDQ');

1226:
1227: end if;
1228: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
1229: hz_utility_v2pub.debug(p_message=>'l_contact_point_list('||to_char(i)||').flex_format_phone_number: '||l_contact_point_list(i).FLEX_FORMAT_PHONE_NUMBER,p_prefix=>'DEBUG: ',p_msg_level=>fnd_log.level_statement, p_module=>'HZ_Module.enableDQ');
1230: hz_utility_v2pub.debug(p_message=>'l_contact_point_list('||i||').phone_number(parsed): '||l_contact_point_list(i).PHONE_NUMBER,p_prefix=>'DEBUG: ',p_msg_level=>fnd_log.level_statement, p_module=>'HZ_Module.enableDQ');
1231: END IF;
1232: end loop;
1233: end if;
1234:

Line 1248: hz_utility_v2pub.debug(p_message=>'l_contact_point_list('||to_char(l_cpt_count+i)||')'||'.email_address'||l_contact_point_list(l_cpt_count+i).EMAIL_ADDRESS,p_prefix=>'DEBUG: ',p_msg_level=>fnd_log.level_statement, p_module=>'HZ_Module.enableDQ');

1244: l_contact_point_list(l_cpt_count+i).CONTACT_POINT_PURPOSE := p_person_obj.email_objs(i).CONTACT_POINT_PURPOSE;
1245: l_contact_point_list(l_cpt_count+i).EMAIL_ADDRESS := p_person_obj.email_objs(i).EMAIL_ADDRESS;
1246: l_contact_point_list(l_cpt_count+i).EMAIL_FORMAT := p_person_obj.email_objs(i).EMAIL_FORMAT;
1247: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
1248: hz_utility_v2pub.debug(p_message=>'l_contact_point_list('||to_char(l_cpt_count+i)||')'||'.email_address'||l_contact_point_list(l_cpt_count+i).EMAIL_ADDRESS,p_prefix=>'DEBUG: ',p_msg_level=>fnd_log.level_statement, p_module=>'HZ_Module.enableDQ');
1249: end if;
1250: end loop;
1251: end if;
1252:

Line 1283: hz_utility_v2pub.debug(p_message=>'Calling DQM API HZ_PARTY_SEARCH.find_persons ',p_prefix=>'DEBUG: ',p_msg_level=>fnd_log.level_statement, p_module=>'HZ_Module.enableDQ');

1279: end loop;
1280: end if;
1281:
1282: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
1283: hz_utility_v2pub.debug(p_message=>'Calling DQM API HZ_PARTY_SEARCH.find_persons ',p_prefix=>'DEBUG: ',p_msg_level=>fnd_log.level_statement, p_module=>'HZ_Module.enableDQ');
1284: hz_utility_v2pub.debug(p_message=>'HZ_PARTY_SEARCH.find_persons Start time: '||TO_CHAR(SYSDATE, 'MM-DD-YY HH24:MI:SS'),p_prefix=>'DEBUG: ',p_msg_level=>fnd_log.level_statement, p_module=>'HZ_Module.enableDQ');
1285: END IF;
1286:
1287: HZ_PARTY_SEARCH.find_persons (

Line 1284: hz_utility_v2pub.debug(p_message=>'HZ_PARTY_SEARCH.find_persons Start time: '||TO_CHAR(SYSDATE, 'MM-DD-YY HH24:MI:SS'),p_prefix=>'DEBUG: ',p_msg_level=>fnd_log.level_statement, p_module=>'HZ_Module.enableDQ');

1280: end if;
1281:
1282: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
1283: hz_utility_v2pub.debug(p_message=>'Calling DQM API HZ_PARTY_SEARCH.find_persons ',p_prefix=>'DEBUG: ',p_msg_level=>fnd_log.level_statement, p_module=>'HZ_Module.enableDQ');
1284: hz_utility_v2pub.debug(p_message=>'HZ_PARTY_SEARCH.find_persons Start time: '||TO_CHAR(SYSDATE, 'MM-DD-YY HH24:MI:SS'),p_prefix=>'DEBUG: ',p_msg_level=>fnd_log.level_statement, p_module=>'HZ_Module.enableDQ');
1285: END IF;
1286:
1287: HZ_PARTY_SEARCH.find_persons (
1288: p_rule_id => l_match_rule_id,

Line 1304: hz_utility_v2pub.debug(p_message=>'HZ_PARTY_SEARCH.find_persons end time: '||TO_CHAR(SYSDATE, 'MM-DD-YY HH24:MI:SS'),p_prefix=>'DEBUG: ',p_msg_level=>fnd_log.level_statement, p_module=>'HZ_Module.enableDQ');

1300:
1301: );
1302:
1303: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
1304: hz_utility_v2pub.debug(p_message=>'HZ_PARTY_SEARCH.find_persons end time: '||TO_CHAR(SYSDATE, 'MM-DD-YY HH24:MI:SS'),p_prefix=>'DEBUG: ',p_msg_level=>fnd_log.level_statement, p_module=>'HZ_Module.enableDQ');
1305: -- hz_utility_v2pub.debug(p_message=>'# of Matches: '||l_num_matches,p_prefix=>'DEBUG: ',p_msg_level=>fnd_log.level_statement, p_module=>'HZ_Module.enableDQ');
1306: hz_utility_v2pub.debug(p_message=>'return status of find_persons: '||x_return_status,p_prefix=>'DEBUG: ',p_msg_level=>fnd_log.level_statement, p_module=>'HZ_Module.enableDQ');
1307: hz_utility_v2pub.debug(p_message=>'search_ctx_id: '||l_search_ctx_id,p_prefix=>'DEBUG: ',p_msg_level=>fnd_log.level_statement, p_module=>'HZ_Module.enableDQ');
1308: if l_num_matches = 0

Line 1305: -- hz_utility_v2pub.debug(p_message=>'# of Matches: '||l_num_matches,p_prefix=>'DEBUG: ',p_msg_level=>fnd_log.level_statement, p_module=>'HZ_Module.enableDQ');

1301: );
1302:
1303: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
1304: hz_utility_v2pub.debug(p_message=>'HZ_PARTY_SEARCH.find_persons end time: '||TO_CHAR(SYSDATE, 'MM-DD-YY HH24:MI:SS'),p_prefix=>'DEBUG: ',p_msg_level=>fnd_log.level_statement, p_module=>'HZ_Module.enableDQ');
1305: -- hz_utility_v2pub.debug(p_message=>'# of Matches: '||l_num_matches,p_prefix=>'DEBUG: ',p_msg_level=>fnd_log.level_statement, p_module=>'HZ_Module.enableDQ');
1306: hz_utility_v2pub.debug(p_message=>'return status of find_persons: '||x_return_status,p_prefix=>'DEBUG: ',p_msg_level=>fnd_log.level_statement, p_module=>'HZ_Module.enableDQ');
1307: hz_utility_v2pub.debug(p_message=>'search_ctx_id: '||l_search_ctx_id,p_prefix=>'DEBUG: ',p_msg_level=>fnd_log.level_statement, p_module=>'HZ_Module.enableDQ');
1308: if l_num_matches = 0
1309: then

Line 1306: hz_utility_v2pub.debug(p_message=>'return status of find_persons: '||x_return_status,p_prefix=>'DEBUG: ',p_msg_level=>fnd_log.level_statement, p_module=>'HZ_Module.enableDQ');

1302:
1303: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
1304: hz_utility_v2pub.debug(p_message=>'HZ_PARTY_SEARCH.find_persons end time: '||TO_CHAR(SYSDATE, 'MM-DD-YY HH24:MI:SS'),p_prefix=>'DEBUG: ',p_msg_level=>fnd_log.level_statement, p_module=>'HZ_Module.enableDQ');
1305: -- hz_utility_v2pub.debug(p_message=>'# of Matches: '||l_num_matches,p_prefix=>'DEBUG: ',p_msg_level=>fnd_log.level_statement, p_module=>'HZ_Module.enableDQ');
1306: hz_utility_v2pub.debug(p_message=>'return status of find_persons: '||x_return_status,p_prefix=>'DEBUG: ',p_msg_level=>fnd_log.level_statement, p_module=>'HZ_Module.enableDQ');
1307: hz_utility_v2pub.debug(p_message=>'search_ctx_id: '||l_search_ctx_id,p_prefix=>'DEBUG: ',p_msg_level=>fnd_log.level_statement, p_module=>'HZ_Module.enableDQ');
1308: if l_num_matches = 0
1309: then
1310: hz_utility_v2pub.debug(p_message=>'# of Matches: '||l_num_matches,p_prefix=>'DEBUG: ',p_msg_level=>fnd_log.level_statement, p_module=>'HZ_Module.enableDQ');

Line 1307: hz_utility_v2pub.debug(p_message=>'search_ctx_id: '||l_search_ctx_id,p_prefix=>'DEBUG: ',p_msg_level=>fnd_log.level_statement, p_module=>'HZ_Module.enableDQ');

1303: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
1304: hz_utility_v2pub.debug(p_message=>'HZ_PARTY_SEARCH.find_persons end time: '||TO_CHAR(SYSDATE, 'MM-DD-YY HH24:MI:SS'),p_prefix=>'DEBUG: ',p_msg_level=>fnd_log.level_statement, p_module=>'HZ_Module.enableDQ');
1305: -- hz_utility_v2pub.debug(p_message=>'# of Matches: '||l_num_matches,p_prefix=>'DEBUG: ',p_msg_level=>fnd_log.level_statement, p_module=>'HZ_Module.enableDQ');
1306: hz_utility_v2pub.debug(p_message=>'return status of find_persons: '||x_return_status,p_prefix=>'DEBUG: ',p_msg_level=>fnd_log.level_statement, p_module=>'HZ_Module.enableDQ');
1307: hz_utility_v2pub.debug(p_message=>'search_ctx_id: '||l_search_ctx_id,p_prefix=>'DEBUG: ',p_msg_level=>fnd_log.level_statement, p_module=>'HZ_Module.enableDQ');
1308: if l_num_matches = 0
1309: then
1310: hz_utility_v2pub.debug(p_message=>'# of Matches: '||l_num_matches,p_prefix=>'DEBUG: ',p_msg_level=>fnd_log.level_statement, p_module=>'HZ_Module.enableDQ');
1311: end if;

Line 1310: hz_utility_v2pub.debug(p_message=>'# of Matches: '||l_num_matches,p_prefix=>'DEBUG: ',p_msg_level=>fnd_log.level_statement, p_module=>'HZ_Module.enableDQ');

1306: hz_utility_v2pub.debug(p_message=>'return status of find_persons: '||x_return_status,p_prefix=>'DEBUG: ',p_msg_level=>fnd_log.level_statement, p_module=>'HZ_Module.enableDQ');
1307: hz_utility_v2pub.debug(p_message=>'search_ctx_id: '||l_search_ctx_id,p_prefix=>'DEBUG: ',p_msg_level=>fnd_log.level_statement, p_module=>'HZ_Module.enableDQ');
1308: if l_num_matches = 0
1309: then
1310: hz_utility_v2pub.debug(p_message=>'# of Matches: '||l_num_matches,p_prefix=>'DEBUG: ',p_msg_level=>fnd_log.level_statement, p_module=>'HZ_Module.enableDQ');
1311: end if;
1312: END IF;
1313:
1314: if l_num_matches > 0 then

Line 1324: hz_utility_v2pub.debug(p_message=>'# of Matches: 0 ',p_prefix=>'DEBUG: ',p_msg_level=>fnd_log.level_statement, p_module=>'HZ_Module.enableDQ');

1320: x_party_name => l_party_name);
1321: if l_party_id is null
1322: then
1323: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
1324: hz_utility_v2pub.debug(p_message=>'# of Matches: 0 ',p_prefix=>'DEBUG: ',p_msg_level=>fnd_log.level_statement, p_module=>'HZ_Module.enableDQ');
1325: end if;
1326: else
1327: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
1328: hz_utility_v2pub.debug(p_message=>'# of Matches: '||l_num_matches,p_prefix=>'DEBUG: ',p_msg_level=>fnd_log.level_statement, p_module=>'HZ_Module.enableDQ');

Line 1328: hz_utility_v2pub.debug(p_message=>'# of Matches: '||l_num_matches,p_prefix=>'DEBUG: ',p_msg_level=>fnd_log.level_statement, p_module=>'HZ_Module.enableDQ');

1324: hz_utility_v2pub.debug(p_message=>'# of Matches: 0 ',p_prefix=>'DEBUG: ',p_msg_level=>fnd_log.level_statement, p_module=>'HZ_Module.enableDQ');
1325: end if;
1326: else
1327: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
1328: hz_utility_v2pub.debug(p_message=>'# of Matches: '||l_num_matches,p_prefix=>'DEBUG: ',p_msg_level=>fnd_log.level_statement, p_module=>'HZ_Module.enableDQ');
1329: hz_utility_v2pub.debug(p_message=>'Most matching Party Id: '||l_party_id,p_prefix=>'DEBUG: ',p_msg_level=>fnd_log.level_statement, p_module=>'HZ_Module.enableDQ');
1330: hz_utility_v2pub.debug(p_message=>'Most matching Party Name: '||l_party_name,p_prefix=>'DEBUG: ',p_msg_level=>fnd_log.level_statement, p_module=>'HZ_Module.enableDQ');
1331: hz_utility_v2pub.debug(p_message=>'Match score: '||l_match_score,p_prefix=>'DEBUG: ',p_msg_level=>fnd_log.level_statement, p_module=>'HZ_Module.enableDQ');
1332: END IF;

Line 1329: hz_utility_v2pub.debug(p_message=>'Most matching Party Id: '||l_party_id,p_prefix=>'DEBUG: ',p_msg_level=>fnd_log.level_statement, p_module=>'HZ_Module.enableDQ');

1325: end if;
1326: else
1327: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
1328: hz_utility_v2pub.debug(p_message=>'# of Matches: '||l_num_matches,p_prefix=>'DEBUG: ',p_msg_level=>fnd_log.level_statement, p_module=>'HZ_Module.enableDQ');
1329: hz_utility_v2pub.debug(p_message=>'Most matching Party Id: '||l_party_id,p_prefix=>'DEBUG: ',p_msg_level=>fnd_log.level_statement, p_module=>'HZ_Module.enableDQ');
1330: hz_utility_v2pub.debug(p_message=>'Most matching Party Name: '||l_party_name,p_prefix=>'DEBUG: ',p_msg_level=>fnd_log.level_statement, p_module=>'HZ_Module.enableDQ');
1331: hz_utility_v2pub.debug(p_message=>'Match score: '||l_match_score,p_prefix=>'DEBUG: ',p_msg_level=>fnd_log.level_statement, p_module=>'HZ_Module.enableDQ');
1332: END IF;
1333:

Line 1330: hz_utility_v2pub.debug(p_message=>'Most matching Party Name: '||l_party_name,p_prefix=>'DEBUG: ',p_msg_level=>fnd_log.level_statement, p_module=>'HZ_Module.enableDQ');

1326: else
1327: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
1328: hz_utility_v2pub.debug(p_message=>'# of Matches: '||l_num_matches,p_prefix=>'DEBUG: ',p_msg_level=>fnd_log.level_statement, p_module=>'HZ_Module.enableDQ');
1329: hz_utility_v2pub.debug(p_message=>'Most matching Party Id: '||l_party_id,p_prefix=>'DEBUG: ',p_msg_level=>fnd_log.level_statement, p_module=>'HZ_Module.enableDQ');
1330: hz_utility_v2pub.debug(p_message=>'Most matching Party Name: '||l_party_name,p_prefix=>'DEBUG: ',p_msg_level=>fnd_log.level_statement, p_module=>'HZ_Module.enableDQ');
1331: hz_utility_v2pub.debug(p_message=>'Match score: '||l_match_score,p_prefix=>'DEBUG: ',p_msg_level=>fnd_log.level_statement, p_module=>'HZ_Module.enableDQ');
1332: END IF;
1333:
1334: hz_dup_pvt.get_match_rule_thresholds(p_match_rule_id => l_match_rule_id,

Line 1331: hz_utility_v2pub.debug(p_message=>'Match score: '||l_match_score,p_prefix=>'DEBUG: ',p_msg_level=>fnd_log.level_statement, p_module=>'HZ_Module.enableDQ');

1327: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
1328: hz_utility_v2pub.debug(p_message=>'# of Matches: '||l_num_matches,p_prefix=>'DEBUG: ',p_msg_level=>fnd_log.level_statement, p_module=>'HZ_Module.enableDQ');
1329: hz_utility_v2pub.debug(p_message=>'Most matching Party Id: '||l_party_id,p_prefix=>'DEBUG: ',p_msg_level=>fnd_log.level_statement, p_module=>'HZ_Module.enableDQ');
1330: hz_utility_v2pub.debug(p_message=>'Most matching Party Name: '||l_party_name,p_prefix=>'DEBUG: ',p_msg_level=>fnd_log.level_statement, p_module=>'HZ_Module.enableDQ');
1331: hz_utility_v2pub.debug(p_message=>'Match score: '||l_match_score,p_prefix=>'DEBUG: ',p_msg_level=>fnd_log.level_statement, p_module=>'HZ_Module.enableDQ');
1332: END IF;
1333:
1334: hz_dup_pvt.get_match_rule_thresholds(p_match_rule_id => l_match_rule_id,
1335: x_match_threshold => l_match_threshold,

Line 1339: hz_utility_v2pub.debug(p_message=>'Match Threshold: '||l_match_threshold,p_prefix=>'DEBUG: ',p_msg_level=>fnd_log.level_statement, p_module=>'HZ_Module.enableDQ');

1335: x_match_threshold => l_match_threshold,
1336: x_automerge_threshold => l_automerge_threshold);
1337:
1338: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
1339: hz_utility_v2pub.debug(p_message=>'Match Threshold: '||l_match_threshold,p_prefix=>'DEBUG: ',p_msg_level=>fnd_log.level_statement, p_module=>'HZ_Module.enableDQ');
1340: hz_utility_v2pub.debug(p_message=>'Automerge Threshold: '||l_automerge_threshold,p_prefix=>'DEBUG: ',p_msg_level=>fnd_log.level_statement, p_module=>'HZ_Module.enableDQ');
1341:
1342: END IF;
1343:

Line 1340: hz_utility_v2pub.debug(p_message=>'Automerge Threshold: '||l_automerge_threshold,p_prefix=>'DEBUG: ',p_msg_level=>fnd_log.level_statement, p_module=>'HZ_Module.enableDQ');

1336: x_automerge_threshold => l_automerge_threshold);
1337:
1338: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
1339: hz_utility_v2pub.debug(p_message=>'Match Threshold: '||l_match_threshold,p_prefix=>'DEBUG: ',p_msg_level=>fnd_log.level_statement, p_module=>'HZ_Module.enableDQ');
1340: hz_utility_v2pub.debug(p_message=>'Automerge Threshold: '||l_automerge_threshold,p_prefix=>'DEBUG: ',p_msg_level=>fnd_log.level_statement, p_module=>'HZ_Module.enableDQ');
1341:
1342: END IF;
1343:
1344: if l_match_score >= l_match_threshold

Line 1349: hz_utility_v2pub.debug(p_message=>'xx: Winner Party ID is changed. Overlapping Merge Req ID: '||l_overlap_merge_req_id,p_prefix=>'DEBUG: ',p_msg_level=>fnd_log.level_statement, p_module=>'HZ_Module.enableDQ');

1345: then
1346: hz_dup_pvt.validate_master_party_id(px_party_id => l_party_id,
1347: x_overlap_merge_req_id => l_overlap_merge_req_id);
1348:
1349: hz_utility_v2pub.debug(p_message=>'xx: Winner Party ID is changed. Overlapping Merge Req ID: '||l_overlap_merge_req_id,p_prefix=>'DEBUG: ',p_msg_level=>fnd_log.level_statement, p_module=>'HZ_Module.enableDQ');
1350: hz_utility_v2pub.debug(p_message=>'xx: Winner Party ID is changed. Party ID: '||l_party_id,p_prefix=>'DEBUG: ',p_msg_level=>fnd_log.level_statement, p_module=>'HZ_Module.enableDQ');
1351: if l_overlap_merge_req_id is not null
1352: then
1353: l_tmp_score := l_match_score;

Line 1350: hz_utility_v2pub.debug(p_message=>'xx: Winner Party ID is changed. Party ID: '||l_party_id,p_prefix=>'DEBUG: ',p_msg_level=>fnd_log.level_statement, p_module=>'HZ_Module.enableDQ');

1346: hz_dup_pvt.validate_master_party_id(px_party_id => l_party_id,
1347: x_overlap_merge_req_id => l_overlap_merge_req_id);
1348:
1349: hz_utility_v2pub.debug(p_message=>'xx: Winner Party ID is changed. Overlapping Merge Req ID: '||l_overlap_merge_req_id,p_prefix=>'DEBUG: ',p_msg_level=>fnd_log.level_statement, p_module=>'HZ_Module.enableDQ');
1350: hz_utility_v2pub.debug(p_message=>'xx: Winner Party ID is changed. Party ID: '||l_party_id,p_prefix=>'DEBUG: ',p_msg_level=>fnd_log.level_statement, p_module=>'HZ_Module.enableDQ');
1351: if l_overlap_merge_req_id is not null
1352: then
1353: l_tmp_score := l_match_score;
1354: begin

Line 1365: hz_utility_v2pub.debug(p_message=>'The changed party is not a duplicate with the newly created party' ,p_prefix=>'DEBUG: ',p_msg_level=>fnd_log.level_statement, p_module=>'HZ_Module.enableDQ');

1361: EXCEPTION
1362: WHEN NO_DATA_FOUND THEN
1363: l_match_score := 0;
1364: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
1365: hz_utility_v2pub.debug(p_message=>'The changed party is not a duplicate with the newly created party' ,p_prefix=>'DEBUG: ',p_msg_level=>fnd_log.level_statement, p_module=>'HZ_Module.enableDQ');
1366: end if;
1367:
1368: END;
1369:

Line 1371: hz_utility_v2pub.debug(p_message=>'Winner Party ID is changed. Overlapping Merge Req ID: '||l_overlap_merge_req_id,p_prefix=>'DEBUG: ',p_msg_level=>fnd_log.level_statement, p_module=>'HZ_Module.enableDQ');

1367:
1368: END;
1369:
1370: IF l_match_score > 0 and fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
1371: hz_utility_v2pub.debug(p_message=>'Winner Party ID is changed. Overlapping Merge Req ID: '||l_overlap_merge_req_id,p_prefix=>'DEBUG: ',p_msg_level=>fnd_log.level_statement, p_module=>'HZ_Module.enableDQ');
1372:
1373: hz_utility_v2pub.debug(p_message=>'Winner Party Id: '||l_party_id,p_prefix=>'DEBUG: ',p_msg_level=>fnd_log.level_statement, p_module=>'HZ_Module.enableDQ');
1374: hz_utility_v2pub.debug(p_message=>'Winner Party Id match score: '||l_match_score,p_prefix=>'DEBUG: ',p_msg_level=>fnd_log.level_statement, p_module=>'HZ_Module.enableDQ');
1375: end if;

Line 1373: hz_utility_v2pub.debug(p_message=>'Winner Party Id: '||l_party_id,p_prefix=>'DEBUG: ',p_msg_level=>fnd_log.level_statement, p_module=>'HZ_Module.enableDQ');

1369:
1370: IF l_match_score > 0 and fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
1371: hz_utility_v2pub.debug(p_message=>'Winner Party ID is changed. Overlapping Merge Req ID: '||l_overlap_merge_req_id,p_prefix=>'DEBUG: ',p_msg_level=>fnd_log.level_statement, p_module=>'HZ_Module.enableDQ');
1372:
1373: hz_utility_v2pub.debug(p_message=>'Winner Party Id: '||l_party_id,p_prefix=>'DEBUG: ',p_msg_level=>fnd_log.level_statement, p_module=>'HZ_Module.enableDQ');
1374: hz_utility_v2pub.debug(p_message=>'Winner Party Id match score: '||l_match_score,p_prefix=>'DEBUG: ',p_msg_level=>fnd_log.level_statement, p_module=>'HZ_Module.enableDQ');
1375: end if;
1376: END IF;
1377: if l_match_score >= l_match_threshold

Line 1374: hz_utility_v2pub.debug(p_message=>'Winner Party Id match score: '||l_match_score,p_prefix=>'DEBUG: ',p_msg_level=>fnd_log.level_statement, p_module=>'HZ_Module.enableDQ');

1370: IF l_match_score > 0 and fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
1371: hz_utility_v2pub.debug(p_message=>'Winner Party ID is changed. Overlapping Merge Req ID: '||l_overlap_merge_req_id,p_prefix=>'DEBUG: ',p_msg_level=>fnd_log.level_statement, p_module=>'HZ_Module.enableDQ');
1372:
1373: hz_utility_v2pub.debug(p_message=>'Winner Party Id: '||l_party_id,p_prefix=>'DEBUG: ',p_msg_level=>fnd_log.level_statement, p_module=>'HZ_Module.enableDQ');
1374: hz_utility_v2pub.debug(p_message=>'Winner Party Id match score: '||l_match_score,p_prefix=>'DEBUG: ',p_msg_level=>fnd_log.level_statement, p_module=>'HZ_Module.enableDQ');
1375: end if;
1376: END IF;
1377: if l_match_score >= l_match_threshold
1378: then -- match score might get reset due to overlapping req, need to check this again.

Line 1413: hz_utility_v2pub.debug(p_message=>'Created dup batch: dup_set_id: '||l_dup_set_id,p_prefix=>'DEBUG: ',p_msg_level=>fnd_log.level_statement, p_module=>'HZ_Module.enableDQ');

1409: RAISE FND_API.G_EXC_ERROR;
1410: END IF;
1411:
1412: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
1413: hz_utility_v2pub.debug(p_message=>'Created dup batch: dup_set_id: '||l_dup_set_id,p_prefix=>'DEBUG: ',p_msg_level=>fnd_log.level_statement, p_module=>'HZ_Module.enableDQ');
1414:
1415: END IF;
1416:
1417:

Line 1430: hz_utility_v2pub.debug(p_message=>'Merge Request Created with merge request id: '||l_dup_set_id,p_prefix=>'DEBUG: ',p_msg_level=>fnd_log.level_statement, p_module=>'HZ_Module.enableDQ');

1426: ,x_msg_count => x_msg_count
1427: ,x_msg_data => x_msg_data);
1428:
1429: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
1430: hz_utility_v2pub.debug(p_message=>'Merge Request Created with merge request id: '||l_dup_set_id,p_prefix=>'DEBUG: ',p_msg_level=>fnd_log.level_statement, p_module=>'HZ_Module.enableDQ');
1431: hz_utility_v2pub.debug(p_message=>'Create Merge Request conc request id: '||l_request_id,p_prefix=>'DEBUG: ',p_msg_level=>fnd_log.level_statement, p_module=>'HZ_Module.enableDQ');
1432:
1433: end if;
1434: end if; --if l_match_score < l_automerge_threshold

Line 1431: hz_utility_v2pub.debug(p_message=>'Create Merge Request conc request id: '||l_request_id,p_prefix=>'DEBUG: ',p_msg_level=>fnd_log.level_statement, p_module=>'HZ_Module.enableDQ');

1427: ,x_msg_data => x_msg_data);
1428:
1429: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
1430: hz_utility_v2pub.debug(p_message=>'Merge Request Created with merge request id: '||l_dup_set_id,p_prefix=>'DEBUG: ',p_msg_level=>fnd_log.level_statement, p_module=>'HZ_Module.enableDQ');
1431: hz_utility_v2pub.debug(p_message=>'Create Merge Request conc request id: '||l_request_id,p_prefix=>'DEBUG: ',p_msg_level=>fnd_log.level_statement, p_module=>'HZ_Module.enableDQ');
1432:
1433: end if;
1434: end if; --if l_match_score < l_automerge_threshold
1435: end if; --if l_match_score >= l_match_threshold then

Line 1462: hz_utility_v2pub.debug(p_message=>'Party Merge request status: '||x_return_status,p_prefix=>'DEBUG: ',p_msg_level=>fnd_log.level_statement, p_module=>'HZ_Module.enableDQ');

1458: x_return_status => x_return_status,
1459: x_msg_count => x_msg_count,
1460: x_msg_data => x_msg_data);
1461: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
1462: hz_utility_v2pub.debug(p_message=>'Party Merge request status: '||x_return_status,p_prefix=>'DEBUG: ',p_msg_level=>fnd_log.level_statement, p_module=>'HZ_Module.enableDQ');
1463: hz_utility_v2pub.debug(p_message=>'Party Merge request submitted with conc request_id: '||l_request_id,p_prefix=>'DEBUG: ',p_msg_level=>fnd_log.level_statement, p_module=>'HZ_Module.enableDQ');
1464: end if;
1465:
1466: end if; -- if l_match_score >= l_automerge_threshold

Line 1463: hz_utility_v2pub.debug(p_message=>'Party Merge request submitted with conc request_id: '||l_request_id,p_prefix=>'DEBUG: ',p_msg_level=>fnd_log.level_statement, p_module=>'HZ_Module.enableDQ');

1459: x_msg_count => x_msg_count,
1460: x_msg_data => x_msg_data);
1461: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
1462: hz_utility_v2pub.debug(p_message=>'Party Merge request status: '||x_return_status,p_prefix=>'DEBUG: ',p_msg_level=>fnd_log.level_statement, p_module=>'HZ_Module.enableDQ');
1463: hz_utility_v2pub.debug(p_message=>'Party Merge request submitted with conc request_id: '||l_request_id,p_prefix=>'DEBUG: ',p_msg_level=>fnd_log.level_statement, p_module=>'HZ_Module.enableDQ');
1464: end if;
1465:
1466: end if; -- if l_match_score >= l_automerge_threshold
1467: end if; --if l_dup_set_id is not null

Line 1472: hz_utility_v2pub.debug(p_message=>'Enable DQ on Integration Services: End ',p_prefix=>'DEBUG: ',p_msg_level=>fnd_log.level_statement, p_module=>'HZ_Module.enableDQ');

1468: end if; -- if l_match_score >= l_match_threshold
1469: end if; -- if l_party_id = x_person_id
1470: end if; -- if l_num_matches > 0 then
1471: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
1472: hz_utility_v2pub.debug(p_message=>'Enable DQ on Integration Services: End ',p_prefix=>'DEBUG: ',p_msg_level=>fnd_log.level_statement, p_module=>'HZ_Module.enableDQ');
1473: end if;
1474: end if; -- if nvl(fnd_profile.value('HZ_BO_ENABLE_DQ'),'N') = 'Y'
1475:
1476:

Line 1478: HZ_UTILITY_V2PUB.G_CALLING_API := NULL;

1474: end if; -- if nvl(fnd_profile.value('HZ_BO_ENABLE_DQ'),'N') = 'Y'
1475:
1476:
1477: -- reset Global variable
1478: HZ_UTILITY_V2PUB.G_CALLING_API := NULL;
1479: HZ_UTILITY_V2PUB.G_CREATED_BY_MODULE := NULL;
1480:
1481: -- Debug info.
1482: IF fnd_log.level_exception>=fnd_log.g_current_runtime_level THEN

Line 1479: HZ_UTILITY_V2PUB.G_CREATED_BY_MODULE := NULL;

1475:
1476:
1477: -- reset Global variable
1478: HZ_UTILITY_V2PUB.G_CALLING_API := NULL;
1479: HZ_UTILITY_V2PUB.G_CREATED_BY_MODULE := NULL;
1480:
1481: -- Debug info.
1482: IF fnd_log.level_exception>=fnd_log.g_current_runtime_level THEN
1483: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,

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

1479: HZ_UTILITY_V2PUB.G_CREATED_BY_MODULE := NULL;
1480:
1481: -- Debug info.
1482: IF fnd_log.level_exception>=fnd_log.g_current_runtime_level THEN
1483: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
1484: p_msg_data=>x_msg_data,
1485: p_msg_type=>'WARNING',
1486: p_msg_level=>fnd_log.level_exception);
1487: END IF;

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

1485: p_msg_type=>'WARNING',
1486: p_msg_level=>fnd_log.level_exception);
1487: END IF;
1488: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1489: hz_utility_v2pub.debug(p_message=>'do_create_person_bo(-)',
1490: p_prefix=>l_debug_prefix,
1491: p_msg_level=>fnd_log.level_procedure);
1492: END IF;
1493:

Line 1499: HZ_UTILITY_V2PUB.G_CALLING_API := NULL;

1495: WHEN fnd_api.g_exc_error THEN
1496: ROLLBACK TO do_create_person_bo_pub;
1497:
1498: -- reset Global variable
1499: HZ_UTILITY_V2PUB.G_CALLING_API := NULL;
1500: HZ_UTILITY_V2PUB.G_CREATED_BY_MODULE := NULL;
1501:
1502: FND_MESSAGE.SET_NAME('AR', 'HZ_API_PROPAGATE_OBJECT_ERROR');
1503: FND_MESSAGE.SET_TOKEN('OBJECT', 'PERSON');

Line 1500: HZ_UTILITY_V2PUB.G_CREATED_BY_MODULE := NULL;

1496: ROLLBACK TO do_create_person_bo_pub;
1497:
1498: -- reset Global variable
1499: HZ_UTILITY_V2PUB.G_CALLING_API := NULL;
1500: HZ_UTILITY_V2PUB.G_CREATED_BY_MODULE := NULL;
1501:
1502: FND_MESSAGE.SET_NAME('AR', 'HZ_API_PROPAGATE_OBJECT_ERROR');
1503: FND_MESSAGE.SET_TOKEN('OBJECT', 'PERSON');
1504: FND_MSG_PUB.ADD;

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

1510: p_data => x_msg_data);
1511:
1512: -- Debug info.
1513: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
1514: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
1515: p_msg_data=>x_msg_data,
1516: p_msg_type=>'ERROR',
1517: p_msg_level=>fnd_log.level_error);
1518: END IF;

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

1516: p_msg_type=>'ERROR',
1517: p_msg_level=>fnd_log.level_error);
1518: END IF;
1519: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1520: hz_utility_v2pub.debug(p_message=>'do_create_person_bo(-)',
1521: p_prefix=>l_debug_prefix,
1522: p_msg_level=>fnd_log.level_procedure);
1523: END IF;
1524:

Line 1529: HZ_UTILITY_V2PUB.G_CALLING_API := NULL;

1525: WHEN fnd_api.g_exc_unexpected_error THEN
1526: ROLLBACK TO do_create_person_bo_pub;
1527:
1528: -- reset Global variable
1529: HZ_UTILITY_V2PUB.G_CALLING_API := NULL;
1530: HZ_UTILITY_V2PUB.G_CREATED_BY_MODULE := NULL;
1531:
1532: FND_MESSAGE.SET_NAME('AR', 'HZ_API_PROPAGATE_OBJECT_ERROR');
1533: FND_MESSAGE.SET_TOKEN('OBJECT', 'PERSON');

Line 1530: HZ_UTILITY_V2PUB.G_CREATED_BY_MODULE := NULL;

1526: ROLLBACK TO do_create_person_bo_pub;
1527:
1528: -- reset Global variable
1529: HZ_UTILITY_V2PUB.G_CALLING_API := NULL;
1530: HZ_UTILITY_V2PUB.G_CREATED_BY_MODULE := NULL;
1531:
1532: FND_MESSAGE.SET_NAME('AR', 'HZ_API_PROPAGATE_OBJECT_ERROR');
1533: FND_MESSAGE.SET_TOKEN('OBJECT', 'PERSON');
1534: FND_MSG_PUB.ADD;

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

1540: p_data => x_msg_data);
1541:
1542: -- Debug info.
1543: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
1544: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
1545: p_msg_data=>x_msg_data,
1546: p_msg_type=>'UNEXPECTED ERROR',
1547: p_msg_level=>fnd_log.level_error);
1548: END IF;

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

1546: p_msg_type=>'UNEXPECTED ERROR',
1547: p_msg_level=>fnd_log.level_error);
1548: END IF;
1549: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1550: hz_utility_v2pub.debug(p_message=>'do_create_person_bo(-)',
1551: p_prefix=>l_debug_prefix,
1552: p_msg_level=>fnd_log.level_procedure);
1553: END IF;
1554:

Line 1559: HZ_UTILITY_V2PUB.G_CALLING_API := NULL;

1555: WHEN OTHERS THEN
1556: ROLLBACK TO do_create_person_bo_pub;
1557:
1558: -- reset Global variable
1559: HZ_UTILITY_V2PUB.G_CALLING_API := NULL;
1560: HZ_UTILITY_V2PUB.G_CREATED_BY_MODULE := NULL;
1561:
1562: FND_MESSAGE.SET_NAME('AR', 'HZ_API_PROPAGATE_OBJECT_ERROR');
1563: FND_MESSAGE.SET_TOKEN('OBJECT', 'PERSON');

Line 1560: HZ_UTILITY_V2PUB.G_CREATED_BY_MODULE := NULL;

1556: ROLLBACK TO do_create_person_bo_pub;
1557:
1558: -- reset Global variable
1559: HZ_UTILITY_V2PUB.G_CALLING_API := NULL;
1560: HZ_UTILITY_V2PUB.G_CREATED_BY_MODULE := NULL;
1561:
1562: FND_MESSAGE.SET_NAME('AR', 'HZ_API_PROPAGATE_OBJECT_ERROR');
1563: FND_MESSAGE.SET_TOKEN('OBJECT', 'PERSON');
1564: FND_MSG_PUB.ADD;

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

1574: p_data => x_msg_data);
1575:
1576: -- Debug info.
1577: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
1578: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
1579: p_msg_data=>x_msg_data,
1580: p_msg_type=>'SQL ERROR',
1581: p_msg_level=>fnd_log.level_error);
1582: END IF;

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

1580: p_msg_type=>'SQL ERROR',
1581: p_msg_level=>fnd_log.level_error);
1582: END IF;
1583: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1584: hz_utility_v2pub.debug(p_message=>'do_create_person_bo(-)',
1585: p_prefix=>l_debug_prefix,
1586: p_msg_level=>fnd_log.level_procedure);
1587: END IF;
1588: END do_create_person_bo;

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

1709: FND_MSG_PUB.initialize;
1710: END IF;
1711:
1712: -- initialize Global variable
1713: HZ_UTILITY_V2PUB.G_CALLING_API := 'BO_API';
1714: IF(p_created_by_module IS NULL) THEN
1715: HZ_UTILITY_V2PUB.G_CREATED_BY_MODULE := 'BO_API';
1716: ELSE
1717: HZ_UTILITY_V2PUB.G_CREATED_BY_MODULE := p_created_by_module;

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

1711:
1712: -- initialize Global variable
1713: HZ_UTILITY_V2PUB.G_CALLING_API := 'BO_API';
1714: IF(p_created_by_module IS NULL) THEN
1715: HZ_UTILITY_V2PUB.G_CREATED_BY_MODULE := 'BO_API';
1716: ELSE
1717: HZ_UTILITY_V2PUB.G_CREATED_BY_MODULE := p_created_by_module;
1718: END IF;
1719:

Line 1717: HZ_UTILITY_V2PUB.G_CREATED_BY_MODULE := p_created_by_module;

1713: HZ_UTILITY_V2PUB.G_CALLING_API := 'BO_API';
1714: IF(p_created_by_module IS NULL) THEN
1715: HZ_UTILITY_V2PUB.G_CREATED_BY_MODULE := 'BO_API';
1716: ELSE
1717: HZ_UTILITY_V2PUB.G_CREATED_BY_MODULE := p_created_by_module;
1718: END IF;
1719:
1720: -- Debug info.
1721: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN

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

1718: END IF;
1719:
1720: -- Debug info.
1721: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1722: hz_utility_v2pub.debug(p_message=>'do_update_person_bo(+)',
1723: p_prefix=>l_debug_prefix,
1724: p_msg_level=>fnd_log.level_procedure);
1725: END IF;
1726:

Line 1936: l_cbm := HZ_UTILITY_V2PUB.G_CREATED_BY_MODULE;

1932: RAISE FND_API.G_EXC_ERROR;
1933: END IF;
1934: END IF;
1935:
1936: l_cbm := HZ_UTILITY_V2PUB.G_CREATED_BY_MODULE;
1937:
1938: -----------------
1939: -- For Party Site
1940: -----------------

Line 1961: HZ_UTILITY_V2PUB.G_CREATED_BY_MODULE := l_cbm;

1957: RAISE FND_API.G_EXC_ERROR;
1958: END IF;
1959: END IF;
1960:
1961: HZ_UTILITY_V2PUB.G_CREATED_BY_MODULE := l_cbm;
1962:
1963: ---------------------
1964: -- For Contact Points
1965: ---------------------

Line 1994: HZ_UTILITY_V2PUB.G_CREATED_BY_MODULE := l_cbm;

1990: RAISE FND_API.G_EXC_ERROR;
1991: END IF;
1992: END IF;
1993:
1994: HZ_UTILITY_V2PUB.G_CREATED_BY_MODULE := l_cbm;
1995:
1996: ---------------------
1997: -- Certifications
1998: ---------------------

Line 2072: HZ_UTILITY_V2PUB.G_CALLING_API := NULL;

2068: );
2069: END IF;
2070:
2071: -- reset Global variable
2072: HZ_UTILITY_V2PUB.G_CALLING_API := NULL;
2073: HZ_UTILITY_V2PUB.G_CREATED_BY_MODULE := NULL;
2074:
2075: -- Debug info.
2076: IF fnd_log.level_exception>=fnd_log.g_current_runtime_level THEN

Line 2073: HZ_UTILITY_V2PUB.G_CREATED_BY_MODULE := NULL;

2069: END IF;
2070:
2071: -- reset Global variable
2072: HZ_UTILITY_V2PUB.G_CALLING_API := NULL;
2073: HZ_UTILITY_V2PUB.G_CREATED_BY_MODULE := NULL;
2074:
2075: -- Debug info.
2076: IF fnd_log.level_exception>=fnd_log.g_current_runtime_level THEN
2077: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,

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

2073: HZ_UTILITY_V2PUB.G_CREATED_BY_MODULE := NULL;
2074:
2075: -- Debug info.
2076: IF fnd_log.level_exception>=fnd_log.g_current_runtime_level THEN
2077: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
2078: p_msg_data=>x_msg_data,
2079: p_msg_type=>'WARNING',
2080: p_msg_level=>fnd_log.level_exception);
2081: END IF;

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

2079: p_msg_type=>'WARNING',
2080: p_msg_level=>fnd_log.level_exception);
2081: END IF;
2082: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2083: hz_utility_v2pub.debug(p_message=>'do_update_person_bo(-)',
2084: p_prefix=>l_debug_prefix,
2085: p_msg_level=>fnd_log.level_procedure);
2086: END IF;
2087: EXCEPTION

Line 2092: HZ_UTILITY_V2PUB.G_CALLING_API := NULL;

2088: WHEN fnd_api.g_exc_error THEN
2089: ROLLBACK TO do_update_person_bo_pub;
2090:
2091: -- reset Global variable
2092: HZ_UTILITY_V2PUB.G_CALLING_API := NULL;
2093: HZ_UTILITY_V2PUB.G_CREATED_BY_MODULE := NULL;
2094:
2095: FND_MESSAGE.SET_NAME('AR', 'HZ_API_PROPAGATE_OBJECT_ERROR');
2096: FND_MESSAGE.SET_TOKEN('OBJECT', 'PERSON');

Line 2093: HZ_UTILITY_V2PUB.G_CREATED_BY_MODULE := NULL;

2089: ROLLBACK TO do_update_person_bo_pub;
2090:
2091: -- reset Global variable
2092: HZ_UTILITY_V2PUB.G_CALLING_API := NULL;
2093: HZ_UTILITY_V2PUB.G_CREATED_BY_MODULE := NULL;
2094:
2095: FND_MESSAGE.SET_NAME('AR', 'HZ_API_PROPAGATE_OBJECT_ERROR');
2096: FND_MESSAGE.SET_TOKEN('OBJECT', 'PERSON');
2097: FND_MSG_PUB.ADD;

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

2103: p_data => x_msg_data);
2104:
2105: -- Debug info.
2106: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
2107: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
2108: p_msg_data=>x_msg_data,
2109: p_msg_type=>'ERROR',
2110: p_msg_level=>fnd_log.level_error);
2111: END IF;

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

2109: p_msg_type=>'ERROR',
2110: p_msg_level=>fnd_log.level_error);
2111: END IF;
2112: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2113: hz_utility_v2pub.debug(p_message=>'do_update_person_bo(-)',
2114: p_prefix=>l_debug_prefix,
2115: p_msg_level=>fnd_log.level_procedure);
2116: END IF;
2117:

Line 2123: HZ_UTILITY_V2PUB.G_CALLING_API := NULL;

2119: WHEN fnd_api.g_exc_unexpected_error THEN
2120: ROLLBACK TO do_update_person_bo_pub;
2121:
2122: -- reset Global variable
2123: HZ_UTILITY_V2PUB.G_CALLING_API := NULL;
2124: HZ_UTILITY_V2PUB.G_CREATED_BY_MODULE := NULL;
2125:
2126: FND_MESSAGE.SET_NAME('AR', 'HZ_API_PROPAGATE_OBJECT_ERROR');
2127: FND_MESSAGE.SET_TOKEN('OBJECT', 'PERSON');

Line 2124: HZ_UTILITY_V2PUB.G_CREATED_BY_MODULE := NULL;

2120: ROLLBACK TO do_update_person_bo_pub;
2121:
2122: -- reset Global variable
2123: HZ_UTILITY_V2PUB.G_CALLING_API := NULL;
2124: HZ_UTILITY_V2PUB.G_CREATED_BY_MODULE := NULL;
2125:
2126: FND_MESSAGE.SET_NAME('AR', 'HZ_API_PROPAGATE_OBJECT_ERROR');
2127: FND_MESSAGE.SET_TOKEN('OBJECT', 'PERSON');
2128: FND_MSG_PUB.ADD;

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

2134: p_data => x_msg_data);
2135:
2136: -- Debug info.
2137: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
2138: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
2139: p_msg_data=>x_msg_data,
2140: p_msg_type=>'UNEXPECTED ERROR',
2141: p_msg_level=>fnd_log.level_error);
2142: END IF;

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

2140: p_msg_type=>'UNEXPECTED ERROR',
2141: p_msg_level=>fnd_log.level_error);
2142: END IF;
2143: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2144: hz_utility_v2pub.debug(p_message=>'do_update_person_bo(-)',
2145: p_prefix=>l_debug_prefix,
2146: p_msg_level=>fnd_log.level_procedure);
2147: END IF;
2148: WHEN OTHERS THEN

Line 2152: HZ_UTILITY_V2PUB.G_CALLING_API := NULL;

2148: WHEN OTHERS THEN
2149: ROLLBACK TO do_update_person_bo_pub;
2150:
2151: -- reset Global variable
2152: HZ_UTILITY_V2PUB.G_CALLING_API := NULL;
2153: HZ_UTILITY_V2PUB.G_CREATED_BY_MODULE := NULL;
2154:
2155: FND_MESSAGE.SET_NAME('AR', 'HZ_API_PROPAGATE_OBJECT_ERROR');
2156: FND_MESSAGE.SET_TOKEN('OBJECT', 'PERSON');

Line 2153: HZ_UTILITY_V2PUB.G_CREATED_BY_MODULE := NULL;

2149: ROLLBACK TO do_update_person_bo_pub;
2150:
2151: -- reset Global variable
2152: HZ_UTILITY_V2PUB.G_CALLING_API := NULL;
2153: HZ_UTILITY_V2PUB.G_CREATED_BY_MODULE := NULL;
2154:
2155: FND_MESSAGE.SET_NAME('AR', 'HZ_API_PROPAGATE_OBJECT_ERROR');
2156: FND_MESSAGE.SET_TOKEN('OBJECT', 'PERSON');
2157: FND_MSG_PUB.ADD;

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

2167: p_data => x_msg_data);
2168:
2169: -- Debug info.
2170: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
2171: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
2172: p_msg_data=>x_msg_data,
2173: p_msg_type=>'SQL ERROR',
2174: p_msg_level=>fnd_log.level_error);
2175: END IF;

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

2173: p_msg_type=>'SQL ERROR',
2174: p_msg_level=>fnd_log.level_error);
2175: END IF;
2176: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2177: hz_utility_v2pub.debug(p_message=>'do_update_person_bo(-)',
2178: p_prefix=>l_debug_prefix,
2179: p_msg_level=>fnd_log.level_procedure);
2180: END IF;
2181: END do_update_person_bo;

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

2278: END IF;
2279:
2280: -- Debug info.
2281: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2282: hz_utility_v2pub.debug(p_message=>'do_save_person_bo(+)',
2283: p_prefix=>l_debug_prefix,
2284: p_msg_level=>fnd_log.level_procedure);
2285: END IF;
2286:

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=>'do_save_person_bo(-)',

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=>'do_save_person_bo(-)',
2354: p_prefix=>l_debug_prefix,
2355: p_msg_level=>fnd_log.level_procedure);
2356: END IF;
2357: EXCEPTION

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

2363: p_data => x_msg_data);
2364:
2365: -- Debug info.
2366: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
2367: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
2368: p_msg_data=>x_msg_data,
2369: p_msg_type=>'ERROR',
2370: p_msg_level=>fnd_log.level_error);
2371: END IF;

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

2369: p_msg_type=>'ERROR',
2370: p_msg_level=>fnd_log.level_error);
2371: END IF;
2372: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2373: hz_utility_v2pub.debug(p_message=>'do_save_person_bo(-)',
2374: p_prefix=>l_debug_prefix,
2375: p_msg_level=>fnd_log.level_procedure);
2376: END IF;
2377:

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

2383: p_data => x_msg_data);
2384:
2385: -- Debug info.
2386: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
2387: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
2388: p_msg_data=>x_msg_data,
2389: p_msg_type=>'UNEXPECTED ERROR',
2390: p_msg_level=>fnd_log.level_error);
2391: END IF;

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

2389: p_msg_type=>'UNEXPECTED ERROR',
2390: p_msg_level=>fnd_log.level_error);
2391: END IF;
2392: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2393: hz_utility_v2pub.debug(p_message=>'do_save_person_bo(-)',
2394: p_prefix=>l_debug_prefix,
2395: p_msg_level=>fnd_log.level_procedure);
2396: END IF;
2397: WHEN OTHERS THEN

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

2406: p_data => x_msg_data);
2407:
2408: -- Debug info.
2409: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
2410: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
2411: p_msg_data=>x_msg_data,
2412: p_msg_type=>'SQL ERROR',
2413: p_msg_level=>fnd_log.level_error);
2414: END IF;

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

2412: p_msg_type=>'SQL ERROR',
2413: p_msg_level=>fnd_log.level_error);
2414: END IF;
2415: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2416: hz_utility_v2pub.debug(p_message=>'do_save_person_bo(-)',
2417: p_prefix=>l_debug_prefix,
2418: p_msg_level=>fnd_log.level_procedure);
2419: END IF;
2420: END do_save_person_bo;

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

2547: x_return_status := FND_API.G_RET_STS_SUCCESS;
2548:
2549: -- Debug info.
2550: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2551: hz_utility_v2pub.debug(p_message=>'create_person_info(+)',
2552: p_prefix=>l_debug_prefix,
2553: p_msg_level=>fnd_log.level_procedure);
2554: END IF;
2555:

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

2573: );
2574:
2575: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2576: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2577: hz_utility_v2pub.debug(p_message=>'Create Person Language - Error occurred at hz_person_bo_pub.create_person_info, person id: '||p_person_id,
2578: p_prefix=>l_debug_prefix,
2579: p_msg_level=>fnd_log.level_procedure);
2580: END IF;
2581: FND_MESSAGE.SET_NAME('AR', 'HZ_API_PROPAGATE_ENTITY_ERROR');

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

2609: );
2610:
2611: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2612: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2613: hz_utility_v2pub.debug(p_message=>'Create Education - Error occurred at hz_person_bo_pub.create_person_info, person id: '||p_person_id,
2614: p_prefix=>l_debug_prefix,
2615: p_msg_level=>fnd_log.level_procedure);
2616: END IF;
2617: FND_MESSAGE.SET_NAME('AR', 'HZ_API_PROPAGATE_ENTITY_ERROR');

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

2645: );
2646:
2647: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2648: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2649: hz_utility_v2pub.debug(p_message=>'Create Citizenship - Error occurred at hz_person_bo_pub.create_person_info, person id: '||p_person_id,
2650: p_prefix=>l_debug_prefix,
2651: p_msg_level=>fnd_log.level_procedure);
2652: END IF;
2653: FND_MESSAGE.SET_NAME('AR', 'HZ_API_PROPAGATE_ENTITY_ERROR');

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

2681: );
2682:
2683: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2684: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2685: hz_utility_v2pub.debug(p_message=>'Create Employment History - Error occurred at hz_person_bo_pub.create_person_info, person id: '||p_person_id,
2686: p_prefix=>l_debug_prefix,
2687: p_msg_level=>fnd_log.level_procedure);
2688: END IF;
2689: FND_MESSAGE.SET_NAME('AR', 'HZ_API_PROPAGATE_STRUCT_ERROR');

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

2716: );
2717:
2718: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2719: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2720: 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,
2721: p_prefix=>l_debug_prefix,
2722: p_msg_level=>fnd_log.level_procedure);
2723: END IF;
2724: FND_MESSAGE.SET_NAME('AR', 'HZ_API_PROPAGATE_ENTITY_ERROR');

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

2755: );
2756:
2757: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2758: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2759: hz_utility_v2pub.debug(p_message=>'Create Person Interest - Error occurred at hz_person_bo_pub.create_person_info, person id: '||p_person_id,
2760: p_prefix=>l_debug_prefix,
2761: p_msg_level=>fnd_log.level_procedure);
2762: END IF;
2763: FND_MESSAGE.SET_NAME('AR', 'HZ_API_PROPAGATE_ENTITY_ERROR');

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

2772: END IF;
2773:
2774: -- Debug info.
2775: IF fnd_log.level_exception>=fnd_log.g_current_runtime_level THEN
2776: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
2777: p_msg_data=>x_msg_data,
2778: p_msg_type=>'WARNING',
2779: p_msg_level=>fnd_log.level_exception);
2780: END IF;

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

2778: p_msg_type=>'WARNING',
2779: p_msg_level=>fnd_log.level_exception);
2780: END IF;
2781: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2782: hz_utility_v2pub.debug(p_message=>'create_person_info(-)',
2783: p_prefix=>l_debug_prefix,
2784: p_msg_level=>fnd_log.level_procedure);
2785: END IF;
2786: EXCEPTION

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

2793: p_data => x_msg_data);
2794:
2795: -- Debug info.
2796: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
2797: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
2798: p_msg_data=>x_msg_data,
2799: p_msg_type=>'ERROR',
2800: p_msg_level=>fnd_log.level_error);
2801: END IF;

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

2799: p_msg_type=>'ERROR',
2800: p_msg_level=>fnd_log.level_error);
2801: END IF;
2802: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2803: hz_utility_v2pub.debug(p_message=>'create_person_info(-)',
2804: p_prefix=>l_debug_prefix,
2805: p_msg_level=>fnd_log.level_procedure);
2806: END IF;
2807: WHEN fnd_api.g_exc_unexpected_error THEN

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

2813: p_data => x_msg_data);
2814:
2815: -- Debug info.
2816: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
2817: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
2818: p_msg_data=>x_msg_data,
2819: p_msg_type=>'UNEXPECTED ERROR',
2820: p_msg_level=>fnd_log.level_error);
2821: END IF;

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

2819: p_msg_type=>'UNEXPECTED ERROR',
2820: p_msg_level=>fnd_log.level_error);
2821: END IF;
2822: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2823: hz_utility_v2pub.debug(p_message=>'create_person_info(-)',
2824: p_prefix=>l_debug_prefix,
2825: p_msg_level=>fnd_log.level_procedure);
2826: END IF;
2827:

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

2838: p_data => x_msg_data);
2839:
2840: -- Debug info.
2841: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
2842: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
2843: p_msg_data=>x_msg_data,
2844: p_msg_type=>'SQL ERROR',
2845: p_msg_level=>fnd_log.level_error);
2846: END IF;

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

2844: p_msg_type=>'SQL ERROR',
2845: p_msg_level=>fnd_log.level_error);
2846: END IF;
2847: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2848: hz_utility_v2pub.debug(p_message=>'create_person_info(-)',
2849: p_prefix=>l_debug_prefix,
2850: p_msg_level=>fnd_log.level_procedure);
2851: END IF;
2852: END create_person_info;

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

2910: x_return_status := FND_API.G_RET_STS_SUCCESS;
2911:
2912: -- Debug info.
2913: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2914: hz_utility_v2pub.debug(p_message=>'save_person_info(+)',
2915: p_prefix=>l_debug_prefix,
2916: p_msg_level=>fnd_log.level_procedure);
2917: END IF;
2918:

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

2935: );
2936:
2937: IF(l_ovn = -1) THEN
2938: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2939: 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,
2940: p_prefix=>l_debug_prefix,
2941: p_msg_level=>fnd_log.level_procedure);
2942: END IF;
2943: FND_MESSAGE.SET_NAME('AR', 'HZ_API_INVALID_ID');

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

2974: p_language_obj(i).language_use_reference_id := l_person_lang_rec.language_use_reference_id;
2975: END IF;
2976: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2977: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2978: 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,
2979: p_prefix=>l_debug_prefix,
2980: p_msg_level=>fnd_log.level_procedure);
2981: END IF;
2982: FND_MESSAGE.SET_NAME('AR', 'HZ_API_PROPAGATE_ENTITY_ERROR');

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

3008: );
3009:
3010: IF(l_ovn = -1) THEN
3011: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
3012: 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,
3013: p_prefix=>l_debug_prefix,
3014: p_msg_level=>fnd_log.level_procedure);
3015: END IF;
3016: FND_MESSAGE.SET_NAME('AR', 'HZ_API_INVALID_ID');

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

3047: p_education_obj(i).education_id := l_education_rec.education_id;
3048: END IF;
3049: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
3050: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
3051: 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,
3052: p_prefix=>l_debug_prefix,
3053: p_msg_level=>fnd_log.level_procedure);
3054: END IF;
3055: FND_MESSAGE.SET_NAME('AR', 'HZ_API_PROPAGATE_ENTITY_ERROR');

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

3079: );
3080:
3081: IF(l_ovn = -1) THEN
3082: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
3083: 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,
3084: p_prefix=>l_debug_prefix,
3085: p_msg_level=>fnd_log.level_procedure);
3086: END IF;
3087: FND_MESSAGE.SET_NAME('AR', 'HZ_API_INVALID_ID');

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

3118: p_citizenship_obj(i).citizenship_id := l_citizenship_rec.citizenship_id;
3119: END IF;
3120: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
3121: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
3122: 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,
3123: p_prefix=>l_debug_prefix,
3124: p_msg_level=>fnd_log.level_procedure);
3125: END IF;
3126: FND_MESSAGE.SET_NAME('AR', 'HZ_API_PROPAGATE_ENTITY_ERROR');

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

3152: );
3153:
3154: IF(l_ovn = -1) THEN
3155: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
3156: 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,
3157: p_prefix=>l_debug_prefix,
3158: p_msg_level=>fnd_log.level_procedure);
3159: END IF;
3160: FND_MESSAGE.SET_NAME('AR', 'HZ_API_INVALID_ID');

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

3192: p_employ_hist_obj(i).employment_history_id := l_dummy_id;
3193: END IF;
3194: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
3195: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
3196: 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,
3197: p_prefix=>l_debug_prefix,
3198: p_msg_level=>fnd_log.level_procedure);
3199: END IF;
3200: FND_MESSAGE.SET_NAME('AR', 'HZ_API_PROPAGATE_STRUCT_ERROR');

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

3221: );
3222:
3223: IF(l_ovn = -1) THEN
3224: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
3225: 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,
3226: p_prefix=>l_debug_prefix,
3227: p_msg_level=>fnd_log.level_procedure);
3228: END IF;
3229: FND_MESSAGE.SET_NAME('AR', 'HZ_API_INVALID_ID');

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

3260: p_employ_hist_obj(i).work_class_objs(j).work_class_id := l_work_class_rec.work_class_id;
3261: END IF;
3262: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
3263: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
3264: 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,
3265: p_prefix=>l_debug_prefix,
3266: p_msg_level=>fnd_log.level_procedure);
3267: END IF;
3268: FND_MESSAGE.SET_NAME('AR', 'HZ_API_PROPAGATE_ENTITY_ERROR');

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

3297: );
3298:
3299: IF(l_ovn = -1) THEN
3300: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
3301: 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,
3302: p_prefix=>l_debug_prefix,
3303: p_msg_level=>fnd_log.level_procedure);
3304: END IF;
3305: FND_MESSAGE.SET_NAME('AR', 'HZ_API_INVALID_ID');

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

3336: p_interest_obj(i).person_interest_id := l_interest_rec.person_interest_id;
3337: END IF;
3338: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
3339: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
3340: 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,
3341: p_prefix=>l_debug_prefix,
3342: p_msg_level=>fnd_log.level_procedure);
3343: END IF;
3344: FND_MESSAGE.SET_NAME('AR', 'HZ_API_PROPAGATE_ENTITY_ERROR');

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

3350: END IF;
3351:
3352: -- Debug info.
3353: IF fnd_log.level_exception>=fnd_log.g_current_runtime_level THEN
3354: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
3355: p_msg_data=>x_msg_data,
3356: p_msg_type=>'WARNING',
3357: p_msg_level=>fnd_log.level_exception);
3358: END IF;

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

3356: p_msg_type=>'WARNING',
3357: p_msg_level=>fnd_log.level_exception);
3358: END IF;
3359: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
3360: hz_utility_v2pub.debug(p_message=>'save_person_info(-)',
3361: p_prefix=>l_debug_prefix,
3362: p_msg_level=>fnd_log.level_procedure);
3363: END IF;
3364: EXCEPTION

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

3371: p_data => x_msg_data);
3372:
3373: -- Debug info.
3374: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
3375: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
3376: p_msg_data=>x_msg_data,
3377: p_msg_type=>'ERROR',
3378: p_msg_level=>fnd_log.level_error);
3379: END IF;

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

3377: p_msg_type=>'ERROR',
3378: p_msg_level=>fnd_log.level_error);
3379: END IF;
3380: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
3381: hz_utility_v2pub.debug(p_message=>'save_person_info(-)',
3382: p_prefix=>l_debug_prefix,
3383: p_msg_level=>fnd_log.level_procedure);
3384: END IF;
3385: 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=>'save_person_info(-)',

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=>'save_person_info(-)',
3402: p_prefix=>l_debug_prefix,
3403: p_msg_level=>fnd_log.level_procedure);
3404: END IF;
3405:

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

3416: p_data => x_msg_data);
3417:
3418: -- Debug info.
3419: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
3420: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
3421: p_msg_data=>x_msg_data,
3422: p_msg_type=>'SQL ERROR',
3423: p_msg_level=>fnd_log.level_error);
3424: END IF;

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

3422: p_msg_type=>'SQL ERROR',
3423: p_msg_level=>fnd_log.level_error);
3424: END IF;
3425: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
3426: hz_utility_v2pub.debug(p_message=>'save_person_info(-)',
3427: p_prefix=>l_debug_prefix,
3428: p_msg_level=>fnd_log.level_procedure);
3429: END IF;
3430: END save_person_info;

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

3525:
3526:
3527: -- Debug info.
3528: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
3529: hz_utility_v2pub.debug(p_message=>'hz_person_bo_pub.get_person_bo(+)',
3530: p_prefix=>l_debug_prefix,
3531: p_msg_level=>fnd_log.level_procedure);
3532: END IF;
3533:

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

3566:
3567:
3568: -- Debug info.
3569: IF fnd_log.level_exception>=fnd_log.g_current_runtime_level THEN
3570: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
3571: p_msg_data=>x_msg_data,
3572: p_msg_type=>'WARNING',
3573: p_msg_level=>fnd_log.level_exception);
3574: END IF;

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

3574: END IF;
3575:
3576: -- Debug info.
3577: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
3578: hz_utility_v2pub.debug(p_message=>'hz_person_bo_pub.get_person_bo (-)',
3579: p_prefix=>l_debug_prefix,
3580: p_msg_level=>fnd_log.level_procedure);
3581: END IF;
3582:

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

3591: p_data => x_msg_data);
3592:
3593: -- Debug info.
3594: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
3595: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
3596: p_msg_data=>x_msg_data,
3597: p_msg_type=>'ERROR',
3598: p_msg_level=>fnd_log.level_error);
3599: END IF;

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

3597: p_msg_type=>'ERROR',
3598: p_msg_level=>fnd_log.level_error);
3599: END IF;
3600: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
3601: hz_utility_v2pub.debug(p_message=>'hz_person_bo_pub.get_person_bo (-)',
3602: p_prefix=>l_debug_prefix,
3603: p_msg_level=>fnd_log.level_procedure);
3604: END IF;
3605: WHEN fnd_api.g_exc_unexpected_error THEN

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

3610: p_data => x_msg_data);
3611:
3612: -- Debug info.
3613: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
3614: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
3615: p_msg_data=>x_msg_data,
3616: p_msg_type=>'UNEXPECTED ERROR',
3617: p_msg_level=>fnd_log.level_error);
3618: END IF;

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

3616: p_msg_type=>'UNEXPECTED ERROR',
3617: p_msg_level=>fnd_log.level_error);
3618: END IF;
3619: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
3620: hz_utility_v2pub.debug(p_message=>'hz_person_bo_pub.get_person_bo (-)',
3621: p_prefix=>l_debug_prefix,
3622: p_msg_level=>fnd_log.level_procedure);
3623: END IF;
3624: WHEN OTHERS THEN

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

3633: p_data => x_msg_data);
3634:
3635: -- Debug info.
3636: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
3637: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
3638: p_msg_data=>x_msg_data,
3639: p_msg_type=>'SQL ERROR',
3640: p_msg_level=>fnd_log.level_error);
3641: END IF;

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

3639: p_msg_type=>'SQL ERROR',
3640: p_msg_level=>fnd_log.level_error);
3641: END IF;
3642: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
3643: hz_utility_v2pub.debug(p_message=>'hz_person_bo_pub.get_person_bo (-)',
3644: p_prefix=>l_debug_prefix,
3645: p_msg_level=>fnd_log.level_procedure);
3646: END IF;
3647:

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

3744:
3745:
3746: -- Debug info.
3747: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
3748: hz_utility_v2pub.debug(p_message=>'hz_person_bo_pub.get_persons_created(+)',
3749: p_prefix=>l_debug_prefix,
3750: p_msg_level=>fnd_log.level_procedure);
3751: END IF;
3752:

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

3776:
3777:
3778: -- Debug info.
3779: IF fnd_log.level_exception>=fnd_log.g_current_runtime_level THEN
3780: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
3781: p_msg_data=>x_msg_data,
3782: p_msg_type=>'WARNING',
3783: p_msg_level=>fnd_log.level_exception);
3784: END IF;

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

3784: END IF;
3785:
3786: -- Debug info.
3787: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
3788: hz_utility_v2pub.debug(p_message=>'hz_person_bo_pub.get_persons_created (-)',
3789: p_prefix=>l_debug_prefix,
3790: p_msg_level=>fnd_log.level_procedure);
3791: END IF;
3792:

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

3801: p_data => x_msg_data);
3802:
3803: -- Debug info.
3804: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
3805: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
3806: p_msg_data=>x_msg_data,
3807: p_msg_type=>'ERROR',
3808: p_msg_level=>fnd_log.level_error);
3809: END IF;

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

3807: p_msg_type=>'ERROR',
3808: p_msg_level=>fnd_log.level_error);
3809: END IF;
3810: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
3811: hz_utility_v2pub.debug(p_message=>'hz_person_bo_pub.get_persons_created(-)',
3812: p_prefix=>l_debug_prefix,
3813: p_msg_level=>fnd_log.level_procedure);
3814: END IF;
3815: WHEN fnd_api.g_exc_unexpected_error THEN

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

3820: p_data => x_msg_data);
3821:
3822: -- Debug info.
3823: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
3824: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
3825: p_msg_data=>x_msg_data,
3826: p_msg_type=>'UNEXPECTED ERROR',
3827: p_msg_level=>fnd_log.level_error);
3828: END IF;

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

3826: p_msg_type=>'UNEXPECTED ERROR',
3827: p_msg_level=>fnd_log.level_error);
3828: END IF;
3829: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
3830: hz_utility_v2pub.debug(p_message=>'hz_person_bo_pub.get_persons_created(-)',
3831: p_prefix=>l_debug_prefix,
3832: p_msg_level=>fnd_log.level_procedure);
3833: END IF;
3834: WHEN OTHERS THEN

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

3843: p_data => x_msg_data);
3844:
3845: -- Debug info.
3846: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
3847: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
3848: p_msg_data=>x_msg_data,
3849: p_msg_type=>'SQL ERROR',
3850: p_msg_level=>fnd_log.level_error);
3851: END IF;

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

3849: p_msg_type=>'SQL ERROR',
3850: p_msg_level=>fnd_log.level_error);
3851: END IF;
3852: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
3853: hz_utility_v2pub.debug(p_message=>'hz_person_bo_pub.get_persons_created(-)',
3854: p_prefix=>l_debug_prefix,
3855: p_msg_level=>fnd_log.level_procedure);
3856: END IF;
3857:

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

3947:
3948:
3949: -- Debug info.
3950: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
3951: hz_utility_v2pub.debug(p_message=>'hz_person_bo_pub.get_persons_updated(+)',
3952: p_prefix=>l_debug_prefix,
3953: p_msg_level=>fnd_log.level_procedure);
3954: END IF;
3955:

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

3978:
3979:
3980: -- Debug info.
3981: IF fnd_log.level_exception>=fnd_log.g_current_runtime_level THEN
3982: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
3983: p_msg_data=>x_msg_data,
3984: p_msg_type=>'WARNING',
3985: p_msg_level=>fnd_log.level_exception);
3986: END IF;

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

3986: END IF;
3987:
3988: -- Debug info.
3989: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
3990: hz_utility_v2pub.debug(p_message=>'hz_person_bo_pub.get_persons_updated (-)',
3991: p_prefix=>l_debug_prefix,
3992: p_msg_level=>fnd_log.level_procedure);
3993: END IF;
3994:

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

4003: p_data => x_msg_data);
4004:
4005: -- Debug info.
4006: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
4007: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
4008: p_msg_data=>x_msg_data,
4009: p_msg_type=>'ERROR',
4010: p_msg_level=>fnd_log.level_error);
4011: END IF;

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

4009: p_msg_type=>'ERROR',
4010: p_msg_level=>fnd_log.level_error);
4011: END IF;
4012: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
4013: hz_utility_v2pub.debug(p_message=>'hz_person_bo_pub.get_persons_updated(-)',
4014: p_prefix=>l_debug_prefix,
4015: p_msg_level=>fnd_log.level_procedure);
4016: END IF;
4017: WHEN fnd_api.g_exc_unexpected_error THEN

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

4022: p_data => x_msg_data);
4023:
4024: -- Debug info.
4025: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
4026: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
4027: p_msg_data=>x_msg_data,
4028: p_msg_type=>'UNEXPECTED ERROR',
4029: p_msg_level=>fnd_log.level_error);
4030: END IF;

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

4028: p_msg_type=>'UNEXPECTED ERROR',
4029: p_msg_level=>fnd_log.level_error);
4030: END IF;
4031: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
4032: hz_utility_v2pub.debug(p_message=>'hz_person_bo_pub.get_persons_updated(-)',
4033: p_prefix=>l_debug_prefix,
4034: p_msg_level=>fnd_log.level_procedure);
4035: END IF;
4036: WHEN OTHERS THEN

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

4045: p_data => x_msg_data);
4046:
4047: -- Debug info.
4048: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
4049: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
4050: p_msg_data=>x_msg_data,
4051: p_msg_type=>'SQL ERROR',
4052: p_msg_level=>fnd_log.level_error);
4053: END IF;

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

4051: p_msg_type=>'SQL ERROR',
4052: p_msg_level=>fnd_log.level_error);
4053: END IF;
4054: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
4055: hz_utility_v2pub.debug(p_message=>'hz_person_bo_pub.get_persons_updated(-)',
4056: p_prefix=>l_debug_prefix,
4057: p_msg_level=>fnd_log.level_procedure);
4058: END IF;
4059:

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

4141:
4142:
4143: -- Debug info.
4144: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
4145: hz_utility_v2pub.debug(p_message=>'hz_person_bo_pub.get_person_updated(+)',
4146: p_prefix=>l_debug_prefix,
4147: p_msg_level=>fnd_log.level_procedure);
4148: END IF;
4149:

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

4174:
4175:
4176: -- Debug info.
4177: IF fnd_log.level_exception>=fnd_log.g_current_runtime_level THEN
4178: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
4179: p_msg_data=>x_msg_data,
4180: p_msg_type=>'WARNING',
4181: p_msg_level=>fnd_log.level_exception);
4182: END IF;

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

4182: END IF;
4183:
4184: -- Debug info.
4185: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
4186: hz_utility_v2pub.debug(p_message=>'hz_person_bo_pub.get_person_updated (-)',
4187: p_prefix=>l_debug_prefix,
4188: p_msg_level=>fnd_log.level_procedure);
4189: END IF;
4190:

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

4199: p_data => x_msg_data);
4200:
4201: -- Debug info.
4202: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
4203: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
4204: p_msg_data=>x_msg_data,
4205: p_msg_type=>'ERROR',
4206: p_msg_level=>fnd_log.level_error);
4207: END IF;

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

4205: p_msg_type=>'ERROR',
4206: p_msg_level=>fnd_log.level_error);
4207: END IF;
4208: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
4209: hz_utility_v2pub.debug(p_message=>'hz_person_bo_pub.get_person_updated(-)',
4210: p_prefix=>l_debug_prefix,
4211: p_msg_level=>fnd_log.level_procedure);
4212: END IF;
4213: WHEN fnd_api.g_exc_unexpected_error THEN

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

4218: p_data => x_msg_data);
4219:
4220: -- Debug info.
4221: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
4222: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
4223: p_msg_data=>x_msg_data,
4224: p_msg_type=>'UNEXPECTED ERROR',
4225: p_msg_level=>fnd_log.level_error);
4226: END IF;

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

4224: p_msg_type=>'UNEXPECTED ERROR',
4225: p_msg_level=>fnd_log.level_error);
4226: END IF;
4227: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
4228: hz_utility_v2pub.debug(p_message=>'hz_person_bo_pub.get_person_updated(-)',
4229: p_prefix=>l_debug_prefix,
4230: p_msg_level=>fnd_log.level_procedure);
4231: END IF;
4232: WHEN OTHERS THEN

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

4241: p_data => x_msg_data);
4242:
4243: -- Debug info.
4244: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
4245: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
4246: p_msg_data=>x_msg_data,
4247: p_msg_type=>'SQL ERROR',
4248: p_msg_level=>fnd_log.level_error);
4249: END IF;

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

4247: p_msg_type=>'SQL ERROR',
4248: p_msg_level=>fnd_log.level_error);
4249: END IF;
4250: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
4251: hz_utility_v2pub.debug(p_message=>'hz_person_bo_pub.get_person_updated(-)',
4252: p_prefix=>l_debug_prefix,
4253: p_msg_level=>fnd_log.level_procedure);
4254: END IF;
4255:

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

4303:
4304:
4305: -- Debug info.
4306: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
4307: hz_utility_v2pub.debug(p_message=>'get_ids_persons_created(+)',
4308: p_prefix=>l_debug_prefix,
4309: p_msg_level=>fnd_log.level_procedure);
4310: END IF;
4311:

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

4334:
4335:
4336: -- Debug info.
4337: IF fnd_log.level_exception>=fnd_log.g_current_runtime_level THEN
4338: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
4339: p_msg_data=>x_msg_data,
4340: p_msg_type=>'WARNING',
4341: p_msg_level=>fnd_log.level_exception);
4342: END IF;

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

4342: END IF;
4343:
4344: -- Debug info.
4345: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
4346: hz_utility_v2pub.debug(p_message=>'get_ids_persons_created (-)',
4347: p_prefix=>l_debug_prefix,
4348: p_msg_level=>fnd_log.level_procedure);
4349: END IF;
4350:

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

4359: p_data => x_msg_data);
4360:
4361: -- Debug info.
4362: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
4363: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
4364: p_msg_data=>x_msg_data,
4365: p_msg_type=>'ERROR',
4366: p_msg_level=>fnd_log.level_error);
4367: END IF;

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

4365: p_msg_type=>'ERROR',
4366: p_msg_level=>fnd_log.level_error);
4367: END IF;
4368: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
4369: hz_utility_v2pub.debug(p_message=>'get_ids_persons_created(-)',
4370: p_prefix=>l_debug_prefix,
4371: p_msg_level=>fnd_log.level_procedure);
4372: END IF;
4373: WHEN fnd_api.g_exc_unexpected_error THEN

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

4378: p_data => x_msg_data);
4379:
4380: -- Debug info.
4381: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
4382: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
4383: p_msg_data=>x_msg_data,
4384: p_msg_type=>'UNEXPECTED ERROR',
4385: p_msg_level=>fnd_log.level_error);
4386: END IF;

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

4384: p_msg_type=>'UNEXPECTED ERROR',
4385: p_msg_level=>fnd_log.level_error);
4386: END IF;
4387: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
4388: hz_utility_v2pub.debug(p_message=>'get_ids_persons_created(-)',
4389: p_prefix=>l_debug_prefix,
4390: p_msg_level=>fnd_log.level_procedure);
4391: END IF;
4392: WHEN OTHERS THEN

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

4401: p_data => x_msg_data);
4402:
4403: -- Debug info.
4404: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
4405: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
4406: p_msg_data=>x_msg_data,
4407: p_msg_type=>'SQL ERROR',
4408: p_msg_level=>fnd_log.level_error);
4409: END IF;

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

4407: p_msg_type=>'SQL ERROR',
4408: p_msg_level=>fnd_log.level_error);
4409: END IF;
4410: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
4411: hz_utility_v2pub.debug(p_message=>'get_ids_persons_created(-)',
4412: p_prefix=>l_debug_prefix,
4413: p_msg_level=>fnd_log.level_procedure);
4414: END IF;
4415:

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

4438:
4439:
4440: -- Debug info.
4441: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
4442: hz_utility_v2pub.debug(p_message=>'get_ids_persons_updated(+)',
4443: p_prefix=>l_debug_prefix,
4444: p_msg_level=>fnd_log.level_procedure);
4445: END IF;
4446:

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

4468:
4469:
4470: -- Debug info.
4471: IF fnd_log.level_exception>=fnd_log.g_current_runtime_level THEN
4472: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
4473: p_msg_data=>x_msg_data,
4474: p_msg_type=>'WARNING',
4475: p_msg_level=>fnd_log.level_exception);
4476: END IF;

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

4476: END IF;
4477:
4478: -- Debug info.
4479: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
4480: hz_utility_v2pub.debug(p_message=>'get_ids_persons_updated (-)',
4481: p_prefix=>l_debug_prefix,
4482: p_msg_level=>fnd_log.level_procedure);
4483: END IF;
4484:

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

4493: p_data => x_msg_data);
4494:
4495: -- Debug info.
4496: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
4497: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
4498: p_msg_data=>x_msg_data,
4499: p_msg_type=>'ERROR',
4500: p_msg_level=>fnd_log.level_error);
4501: END IF;

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

4499: p_msg_type=>'ERROR',
4500: p_msg_level=>fnd_log.level_error);
4501: END IF;
4502: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
4503: hz_utility_v2pub.debug(p_message=>'get_ids_persons_updated(-)',
4504: p_prefix=>l_debug_prefix,
4505: p_msg_level=>fnd_log.level_procedure);
4506: END IF;
4507: WHEN fnd_api.g_exc_unexpected_error THEN

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

4512: p_data => x_msg_data);
4513:
4514: -- Debug info.
4515: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
4516: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
4517: p_msg_data=>x_msg_data,
4518: p_msg_type=>'UNEXPECTED ERROR',
4519: p_msg_level=>fnd_log.level_error);
4520: END IF;

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

4518: p_msg_type=>'UNEXPECTED ERROR',
4519: p_msg_level=>fnd_log.level_error);
4520: END IF;
4521: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
4522: hz_utility_v2pub.debug(p_message=>'get_ids_persons_updated(-)',
4523: p_prefix=>l_debug_prefix,
4524: p_msg_level=>fnd_log.level_procedure);
4525: END IF;
4526: WHEN OTHERS THEN

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

4535: p_data => x_msg_data);
4536:
4537: -- Debug info.
4538: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
4539: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
4540: p_msg_data=>x_msg_data,
4541: p_msg_type=>'SQL ERROR',
4542: p_msg_level=>fnd_log.level_error);
4543: END IF;

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

4541: p_msg_type=>'SQL ERROR',
4542: p_msg_level=>fnd_log.level_error);
4543: END IF;
4544: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
4545: hz_utility_v2pub.debug(p_message=>'get_ids_persons_updated(-)',
4546: p_prefix=>l_debug_prefix,
4547: p_msg_level=>fnd_log.level_procedure);
4548: END IF;
4549: