[Home] [Help]
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
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;
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:
754: -- Base on p_validate_bo_flag, check the completeness of business objects
755: IF(p_validate_bo_flag = FND_API.G_TRUE) THEN
1080: -- call DQM search API
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;
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:
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;
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)|| ' ' ||
1126: l_party_search_rec.PERSON_LAST_NAME := l_person_rec.PERSON_LAST_NAME;
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:
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;
1165: l_party_site_list(i).POSTAL_CODE := p_person_obj.party_site_objs(i).location_obj.POSTAL_CODE;
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;
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;
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;
1201: l_contact_point_list(i).PRIMARY_FLAG := p_person_obj.phone_objs(i).PRIMARY_FLAG;
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
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
1224: x_msg_data => x_msg_data);
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;
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;
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:
1243: l_contact_point_list(l_cpt_count+i).STATUS := p_person_obj.email_objs(i).STATUS;
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;
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:
1278: l_contact_point_list(l_cpt_count+i).CONTACT_POINT_PURPOSE := p_person_obj.sms_objs(i).CONTACT_POINT_PURPOSE;
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:
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 (
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,
1299: x_msg_data => x_msg_data
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');
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
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
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');
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;
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
1319: x_match_score => l_match_score,
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
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');
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');
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');
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;
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:
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,
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,
1334: hz_dup_pvt.get_match_rule_thresholds(p_match_rule_id => l_match_rule_id,
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;
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:
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
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;
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
1360: and rownum = 1;
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;
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:
1366: end if;
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');
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;
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
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.
1408: IF x_return_status<>FND_API.G_RET_STS_SUCCESS THEN
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:
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:
1425: ,x_return_status => x_return_status
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;
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
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
1457: x_request_id => l_request_id,
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:
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
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
1467: end if; --if l_dup_set_id is not null
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:
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:
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,
1484: p_msg_data=>x_msg_data,
1485: p_msg_type=>'WARNING',
1486: p_msg_level=>fnd_log.level_exception);
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;
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,
1484: p_msg_data=>x_msg_data,
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;
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:
1494: EXCEPTION
1495: WHEN fnd_api.g_exc_error THEN
1509: p_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);
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;
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,
1515: p_msg_data=>x_msg_data,
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;
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:
1525: WHEN fnd_api.g_exc_unexpected_error THEN
1526: ROLLBACK TO do_create_person_bo_pub;
1539: p_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);
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;
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,
1545: p_msg_data=>x_msg_data,
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;
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:
1555: WHEN OTHERS THEN
1556: ROLLBACK TO do_create_person_bo_pub;
1573: p_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);
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;
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,
1579: p_msg_data=>x_msg_data,
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;
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;
1589:
1590: PROCEDURE create_person_bo(
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
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;
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:
1727: x_person_id := p_person_obj.person_id;
1728: x_person_os := p_person_obj.orig_system;
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,
2078: p_msg_data=>x_msg_data,
2079: p_msg_type=>'WARNING',
2080: p_msg_level=>fnd_log.level_exception);
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;
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,
2078: p_msg_data=>x_msg_data,
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;
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
2088: WHEN fnd_api.g_exc_error THEN
2089: ROLLBACK TO do_update_person_bo_pub;
2102: p_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);
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;
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,
2108: p_msg_data=>x_msg_data,
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;
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:
2118:
2119: WHEN fnd_api.g_exc_unexpected_error THEN
2133: p_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);
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;
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,
2139: p_msg_data=>x_msg_data,
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;
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
2149: ROLLBACK TO do_update_person_bo_pub;
2150:
2166: p_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);
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;
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,
2172: p_msg_data=>x_msg_data,
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;
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;
2182:
2183: PROCEDURE update_person_bo(
2277: FND_MSG_PUB.initialize;
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;
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:
2287: x_person_id := p_person_obj.person_id;
2288: x_person_os := p_person_obj.orig_system;
2342: RAISE FND_API.G_EXC_ERROR;
2343: END IF;
2344:
2345: -- Debug info.
2346: IF fnd_log.level_exception>=fnd_log.g_current_runtime_level THEN
2347: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
2348: p_msg_data=>x_msg_data,
2349: p_msg_type=>'WARNING',
2350: p_msg_level=>fnd_log.level_exception);
2346: IF fnd_log.level_exception>=fnd_log.g_current_runtime_level THEN
2347: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
2348: p_msg_data=>x_msg_data,
2349: p_msg_type=>'WARNING',
2350: p_msg_level=>fnd_log.level_exception);
2351: END IF;
2352: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2353: hz_utility_v2pub.debug(p_message=>'do_save_person_bo(-)',
2354: p_prefix=>l_debug_prefix,
2348: p_msg_data=>x_msg_data,
2349: p_msg_type=>'WARNING',
2350: p_msg_level=>fnd_log.level_exception);
2351: END IF;
2352: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2353: hz_utility_v2pub.debug(p_message=>'do_save_person_bo(-)',
2354: p_prefix=>l_debug_prefix,
2355: p_msg_level=>fnd_log.level_procedure);
2356: END IF;
2351: END IF;
2352: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2353: hz_utility_v2pub.debug(p_message=>'do_save_person_bo(-)',
2354: p_prefix=>l_debug_prefix,
2355: p_msg_level=>fnd_log.level_procedure);
2356: END IF;
2357: EXCEPTION
2358: WHEN fnd_api.g_exc_error THEN
2359: x_return_status := fnd_api.g_ret_sts_error;
2362: p_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);
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;
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,
2368: p_msg_data=>x_msg_data,
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;
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:
2378: WHEN fnd_api.g_exc_unexpected_error THEN
2379: x_return_status := fnd_api.g_ret_sts_unexp_error;
2382: p_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);
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;
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,
2388: p_msg_data=>x_msg_data,
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;
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
2398: x_return_status := fnd_api.g_ret_sts_unexp_error;
2399:
2405: p_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);
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;
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,
2411: p_msg_data=>x_msg_data,
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;
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;
2421:
2422: PROCEDURE save_person_bo(
2546: -- initialize API return status to success.
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;
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:
2556: --------------------------------
2557: -- Assign person language record
2572: x_msg_data => x_msg_data
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;
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');
2582: FND_MESSAGE.SET_TOKEN('ENTITY', 'HZ_PERSON_LANGUAGE');
2583: FND_MSG_PUB.ADD;
2608: x_msg_data => x_msg_data
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;
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');
2618: FND_MESSAGE.SET_TOKEN('ENTITY', 'HZ_EDUCATION');
2619: FND_MSG_PUB.ADD;
2644: x_msg_data => x_msg_data
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;
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');
2654: FND_MESSAGE.SET_TOKEN('ENTITY', 'HZ_CITIZENSHIP');
2655: FND_MSG_PUB.ADD;
2680: x_msg_data => x_msg_data
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;
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');
2690: FND_MESSAGE.SET_TOKEN('STRUCTURE', 'HZ_EMPLOYMENT_HISTORY');
2691: FND_MSG_PUB.ADD;
2715: x_msg_data => x_msg_data
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;
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');
2725: FND_MESSAGE.SET_TOKEN('ENTITY', 'HZ_WORK_CLASS');
2726: FND_MSG_PUB.ADD;
2754: x_msg_data => x_msg_data
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;
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');
2764: FND_MESSAGE.SET_TOKEN('ENTITY', 'HZ_PERSON_INTEREST');
2765: FND_MSG_PUB.ADD;
2771: END LOOP;
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);
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;
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,
2777: p_msg_data=>x_msg_data,
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;
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
2787: WHEN fnd_api.g_exc_error THEN
2788: ROLLBACK TO create_person_info_pub;
2792: p_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);
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;
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,
2798: p_msg_data=>x_msg_data,
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;
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
2808: ROLLBACK TO create_person_info_pub;
2809: x_return_status := fnd_api.g_ret_sts_unexp_error;
2812: p_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);
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;
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,
2818: p_msg_data=>x_msg_data,
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;
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:
2828: WHEN OTHERS THEN
2829: ROLLBACK TO create_person_info_pub;
2837: p_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);
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;
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,
2843: p_msg_data=>x_msg_data,
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;
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;
2853:
2854: -- PRIVATE PROCEDURE save_person_info
2909: -- initialize API return status to success.
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;
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:
2919: --------------------------------
2920: -- Create/Update person language
2934: x_object_version_number => 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;
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');
2944: FND_MSG_PUB.ADD;
2945: FND_MESSAGE.SET_NAME('AR', 'HZ_API_PROPAGATE_ENTITY_ERROR');
2973: -- assign person language_use_reference_id
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;
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');
2983: FND_MESSAGE.SET_TOKEN('ENTITY', 'HZ_PERSON_LANGUAGE');
2984: FND_MSG_PUB.ADD;
3007: x_object_version_number => 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;
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');
3017: FND_MSG_PUB.ADD;
3018: FND_MESSAGE.SET_NAME('AR', 'HZ_API_PROPAGATE_ENTITY_ERROR');
3046: -- assign education_id
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;
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');
3056: FND_MESSAGE.SET_TOKEN('ENTITY', 'HZ_EDUCATION');
3057: FND_MSG_PUB.ADD;
3078: x_object_version_number => 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;
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');
3088: FND_MSG_PUB.ADD;
3089: FND_MESSAGE.SET_NAME('AR', 'HZ_API_PROPAGATE_ENTITY_ERROR');
3117: -- assign citizenship_id
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;
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');
3127: FND_MESSAGE.SET_TOKEN('ENTITY', 'HZ_CITIZENSHIP');
3128: FND_MSG_PUB.ADD;
3151: x_object_version_number => 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;
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');
3161: FND_MSG_PUB.ADD;
3162: FND_MESSAGE.SET_NAME('AR', 'HZ_API_PROPAGATE_STRUCT_ERROR');
3191: -- assign employment_history_id
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;
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');
3201: FND_MESSAGE.SET_TOKEN('STRUCTURE', 'HZ_EMPLOYMENT_HISTORY');
3202: FND_MSG_PUB.ADD;
3220: x_object_version_number => 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;
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');
3230: FND_MSG_PUB.ADD;
3231: FND_MESSAGE.SET_NAME('AR', 'HZ_API_PROPAGATE_ENTITY_ERROR');
3259: -- assign work_class_id
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;
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');
3269: FND_MESSAGE.SET_TOKEN('ENTITY', 'HZ_WORK_CLASS');
3270: FND_MSG_PUB.ADD;
3296: x_object_version_number => 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;
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');
3306: FND_MSG_PUB.ADD;
3307: FND_MESSAGE.SET_NAME('AR', 'HZ_API_PROPAGATE_ENTITY_ERROR');
3335: -- assign person_interest_id
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;
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');
3345: FND_MESSAGE.SET_TOKEN('ENTITY', 'HZ_PERSON_INTEREST');
3346: FND_MSG_PUB.ADD;
3349: END LOOP;
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);
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;
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,
3355: p_msg_data=>x_msg_data,
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;
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
3365: WHEN fnd_api.g_exc_error THEN
3366: ROLLBACK TO save_person_info_pub;
3370: p_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);
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;
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,
3376: p_msg_data=>x_msg_data,
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;
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
3386: ROLLBACK TO save_person_info_pub;
3387: x_return_status := fnd_api.g_ret_sts_unexp_error;
3390: p_count => x_msg_count,
3391: p_data => x_msg_data);
3392:
3393: -- Debug info.
3394: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
3395: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
3396: p_msg_data=>x_msg_data,
3397: p_msg_type=>'UNEXPECTED ERROR',
3398: p_msg_level=>fnd_log.level_error);
3394: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
3395: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
3396: p_msg_data=>x_msg_data,
3397: p_msg_type=>'UNEXPECTED ERROR',
3398: p_msg_level=>fnd_log.level_error);
3399: END IF;
3400: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
3401: hz_utility_v2pub.debug(p_message=>'save_person_info(-)',
3402: p_prefix=>l_debug_prefix,
3396: p_msg_data=>x_msg_data,
3397: p_msg_type=>'UNEXPECTED ERROR',
3398: p_msg_level=>fnd_log.level_error);
3399: END IF;
3400: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
3401: hz_utility_v2pub.debug(p_message=>'save_person_info(-)',
3402: p_prefix=>l_debug_prefix,
3403: p_msg_level=>fnd_log.level_procedure);
3404: END IF;
3399: END IF;
3400: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
3401: hz_utility_v2pub.debug(p_message=>'save_person_info(-)',
3402: p_prefix=>l_debug_prefix,
3403: p_msg_level=>fnd_log.level_procedure);
3404: END IF;
3405:
3406: WHEN OTHERS THEN
3407: ROLLBACK TO save_person_info_pub;
3415: p_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);
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;
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,
3421: p_msg_data=>x_msg_data,
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;
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;
3431:
3432: --------------------------------------
3524: END IF;
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;
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:
3534: -- check if pass in contact_point_id and/or os+osr
3535: -- extraction validation logic is same as update
3565: END IF;
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);
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;
3575:
3576: -- Debug info.
3577: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
3573: p_msg_level=>fnd_log.level_exception);
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;
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:
3583:
3584: EXCEPTION
3590: p_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);
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;
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,
3596: p_msg_data=>x_msg_data,
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;
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
3606: x_return_status := fnd_api.g_ret_sts_unexp_error;
3607:
3609: p_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);
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;
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,
3615: p_msg_data=>x_msg_data,
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;
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
3625: x_return_status := fnd_api.g_ret_sts_unexp_error;
3626:
3632: p_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);
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;
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,
3638: p_msg_data=>x_msg_data,
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;
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:
3648: end;
3649:
3743: END IF;
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;
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:
3753:
3754: HZ_EXTRACT_BO_UTIL_PVT.validate_event_id(p_event_id => p_event_id,
3775:
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);
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;
3785:
3786: -- Debug info.
3787: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
3783: p_msg_level=>fnd_log.level_exception);
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;
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:
3793:
3794: EXCEPTION
3800: p_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);
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;
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,
3806: p_msg_data=>x_msg_data,
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;
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
3816: x_return_status := fnd_api.g_ret_sts_unexp_error;
3817:
3819: p_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);
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;
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,
3825: p_msg_data=>x_msg_data,
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;
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
3835: x_return_status := fnd_api.g_ret_sts_unexp_error;
3836:
3842: p_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);
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;
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,
3848: p_msg_data=>x_msg_data,
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;
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:
3858: end;
3859:
3946: END IF;
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;
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:
3956: HZ_EXTRACT_BO_UTIL_PVT.validate_event_id(p_event_id => p_event_id,
3957: p_party_id => null,
3977:
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);
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;
3987:
3988: -- Debug info.
3989: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
3985: p_msg_level=>fnd_log.level_exception);
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;
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:
3995:
3996: EXCEPTION
4002: p_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);
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;
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,
4008: p_msg_data=>x_msg_data,
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;
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
4018: x_return_status := fnd_api.g_ret_sts_unexp_error;
4019:
4021: p_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);
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;
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,
4027: p_msg_data=>x_msg_data,
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;
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
4037: x_return_status := fnd_api.g_ret_sts_unexp_error;
4038:
4044: p_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);
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;
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,
4050: p_msg_data=>x_msg_data,
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;
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:
4060: end;
4061:
4140: END IF;
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;
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:
4150: HZ_EXTRACT_BO_UTIL_PVT.validate_event_id(p_event_id => p_event_id,
4151: p_party_id => p_person_id,
4173:
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);
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;
4183:
4184: -- Debug info.
4185: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
4181: p_msg_level=>fnd_log.level_exception);
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;
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:
4191:
4192: EXCEPTION
4198: p_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);
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;
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,
4204: p_msg_data=>x_msg_data,
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;
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
4214: x_return_status := fnd_api.g_ret_sts_unexp_error;
4215:
4217: p_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);
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;
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,
4223: p_msg_data=>x_msg_data,
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;
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
4233: x_return_status := fnd_api.g_ret_sts_unexp_error;
4234:
4240: p_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);
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;
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,
4246: p_msg_data=>x_msg_data,
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;
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:
4256: end;
4257:
4302: END IF;
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;
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:
4312:
4313: HZ_EXTRACT_BO_UTIL_PVT.validate_event_id(p_event_id => p_event_id,
4333: END IF;
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);
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;
4343:
4344: -- Debug info.
4345: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
4341: p_msg_level=>fnd_log.level_exception);
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;
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:
4351:
4352: EXCEPTION
4358: p_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);
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;
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,
4364: p_msg_data=>x_msg_data,
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;
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
4374: x_return_status := fnd_api.g_ret_sts_unexp_error;
4375:
4377: p_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);
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;
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,
4383: p_msg_data=>x_msg_data,
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;
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
4393: x_return_status := fnd_api.g_ret_sts_unexp_error;
4394:
4400: p_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);
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;
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,
4406: p_msg_data=>x_msg_data,
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;
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:
4416: end;
4417:
4437: END IF;
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;
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:
4447: HZ_EXTRACT_BO_UTIL_PVT.validate_event_id(p_event_id => p_event_id,
4448: p_party_id => null,
4467: END IF;
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);
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;
4477:
4478: -- Debug info.
4479: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
4475: p_msg_level=>fnd_log.level_exception);
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;
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:
4485:
4486: EXCEPTION
4492: p_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);
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;
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,
4498: p_msg_data=>x_msg_data,
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;
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
4508: x_return_status := fnd_api.g_ret_sts_unexp_error;
4509:
4511: p_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);
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;
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,
4517: p_msg_data=>x_msg_data,
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;
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
4527: x_return_status := fnd_api.g_ret_sts_unexp_error;
4528:
4534: p_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);
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;
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,
4540: p_msg_data=>x_msg_data,
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;
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:
4550: end;
4551: