464: RETURN l_matched_value;
465: END IF;
466: IF p_attribute = 'PARTY_ALL_NAMES' THEN
467:
468: l_matched_value := HZ_PARTY_ACQUIRE.get_known_as (p_record_id, p_entity,'PARTY_ALL_NAMES','Y');
469: RETURN l_matched_value;
470: END IF;
471: IF p_attribute = 'TAX_REFERENCE' THEN
472:
549: NULL;
550: END IF;
551: IF p_entity = 'PARTY_SITES' THEN
552: IF p_attribute = 'ADDRESS' THEN
553: l_matched_value := HZ_PARTY_ACQUIRE.get_address (p_record_id, p_entity,'ADDRESS','Y');
554: RETURN l_matched_value;
555: END IF;
556: IF p_attribute = 'CITY' THEN
557: BEGIN
608: NULL;
609: END IF;
610: IF p_entity = 'CONTACTS' THEN
611: IF p_attribute = 'CONTACT_NAME' THEN
612: l_matched_value := HZ_PARTY_ACQUIRE.get_contact_name (p_record_id, p_entity,'CONTACT_NAME','Y');
613: RETURN l_matched_value;
614: END IF;
615: NULL;
616: END IF;
615: NULL;
616: END IF;
617: IF p_entity = 'CONTACT_POINTS' THEN
618: IF p_attribute = 'FLEX_FORMAT_PHONE_NUMBER' THEN
619: l_matched_value := HZ_PARTY_ACQUIRE.get_phone_number (p_record_id, p_entity,'FLEX_FORMAT_PHONE_NUMBER','Y');
620: RETURN l_matched_value;
621: END IF;
622: IF p_attribute = 'EMAIL_ADDRESS' THEN
623: BEGIN
6590: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
6591: hz_utility_v2pub.debug(p_message=>'Inside calling procedure - generate_custom_code',p_module_prefix=>'dqm',p_module=>'hz_match_rule_xxx',p_prefix=>NULL,p_msg_level=>fnd_log.level_statement);
6592: END IF;
6593: x_party_search_rec.PARTY_ALL_NAMES:=
6594: HZ_PARTY_ACQUIRE.get_known_as(p_party_id , 'PARTY','PARTY_ALL_NAMES');
6595:
6596: EXCEPTION
6597: WHEN OTHERS THEN
6598: FND_MESSAGE.SET_NAME('AR', 'HZ_PARTY_QUERY_ERROR');
6647: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
6648: hz_utility_v2pub.debug(p_message=>'Inside calling procedure - generate_custom_code',p_module_prefix=>'dqm',p_module=>'hz_match_rule_xxx',p_prefix=>NULL,p_msg_level=>fnd_log.level_statement);
6649: END IF;
6650: x_party_site_list(J).ADDRESS:=
6651: HZ_PARTY_ACQUIRE.get_address(l_party_site_id , 'PARTY_SITES','ADDRESS');
6652: J:=J+1;
6653:
6654: END LOOP;
6655: CLOSE c_party_sites;
6705: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
6706: hz_utility_v2pub.debug(p_message=>'Inside calling procedure - generate_custom_code',p_module_prefix=>'dqm',p_module=>'hz_match_rule_xxx',p_prefix=>NULL,p_msg_level=>fnd_log.level_statement);
6707: END IF;
6708: x_contact_list(J).CONTACT_NAME:=
6709: HZ_PARTY_ACQUIRE.get_contact_name(l_org_contact_id , 'CONTACTS','CONTACT_NAME');
6710:
6711: J:=J+1;
6712: END LOOP;
6713: CLOSE c_contacts;
6761: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
6762: hz_utility_v2pub.debug(p_message=>'Inside calling procedure - generate_custom_code',p_module_prefix=>'dqm',p_module=>'hz_match_rule_xxx',p_prefix=>NULL,p_msg_level=>fnd_log.level_statement);
6763: END IF;
6764: x_contact_point_list(J).FLEX_FORMAT_PHONE_NUMBER:=
6765: HZ_PARTY_ACQUIRE.get_phone_number(l_contact_point_id , 'CONTACT_POINTS','FLEX_FORMAT_PHONE_NUMBER');
6766: J:=J+1;
6767:
6768: END LOOP;
6769: CLOSE c_cpts;