423: NULL;
424: END IF;
425: IF p_entity = 'PARTY_SITES' THEN
426: IF p_attribute = 'ADDRESS' THEN
427: l_matched_value := HZ_PARTY_ACQUIRE.get_address (p_record_id, p_entity,'ADDRESS','Y');
428: RETURN l_matched_value;
429: END IF;
430: IF p_attribute = 'CITY' THEN
431: BEGIN
469: NULL;
470: END IF;
471: IF p_entity = 'CONTACTS' THEN
472: IF p_attribute = 'CONTACT_NAME' THEN
473: l_matched_value := HZ_PARTY_ACQUIRE.get_contact_name (p_record_id, p_entity,'CONTACT_NAME','Y');
474: RETURN l_matched_value;
475: END IF;
476: IF p_attribute = 'JOB_TITLE' THEN
477: BEGIN
505: END;
506: RETURN l_matched_value;
507: END IF;
508: IF p_attribute = 'RAW_PHONE_NUMBER' THEN
509: l_matched_value := HZ_PARTY_ACQUIRE.get_phone_number (p_record_id, p_entity,'RAW_PHONE_NUMBER','Y');
510: RETURN l_matched_value;
511: END IF;
512: NULL;
513: END IF;
4752: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
4753: 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);
4754: END IF;
4755: x_party_site_list(J).ADDRESS:=
4756: HZ_PARTY_ACQUIRE.get_address(l_party_site_id , 'PARTY_SITES','ADDRESS');
4757: J:=J+1;
4758:
4759: END LOOP;
4760: CLOSE c_party_sites;
4812: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
4813: 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);
4814: END IF;
4815: x_contact_list(J).CONTACT_NAME:=
4816: HZ_PARTY_ACQUIRE.get_contact_name(l_org_contact_id , 'CONTACTS','CONTACT_NAME');
4817:
4818: J:=J+1;
4819: END LOOP;
4820: CLOSE c_contacts;
4868: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
4869: 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);
4870: END IF;
4871: x_contact_point_list(J).RAW_PHONE_NUMBER:=
4872: HZ_PARTY_ACQUIRE.get_phone_number(l_contact_point_id , 'CONTACT_POINTS','RAW_PHONE_NUMBER');
4873: J:=J+1;
4874:
4875: END LOOP;
4876: CLOSE c_cpts;