[Home] [Help]
299: BEGIN
300: IF p_entity = 'PARTY' THEN
301: IF p_attribute = 'PARTY_ALL_NAMES' THEN
302:
303: l_matched_value := HZ_PARTY_ACQUIRE.get_known_as (p_record_id, p_entity,'PARTY_ALL_NAMES','Y');
304: RETURN l_matched_value;
305: END IF;
306: NULL;
307: END IF;
330: NULL;
331: END IF;
332: IF p_entity = 'CONTACT_POINTS' THEN
333: IF p_attribute = 'FLEX_FORMAT_PHONE_NUMBER' THEN
334: l_matched_value := HZ_PARTY_ACQUIRE.get_phone_number (p_record_id, p_entity,'FLEX_FORMAT_PHONE_NUMBER','Y');
335: RETURN l_matched_value;
336: END IF;
337: IF p_attribute = 'EMAIL_ADDRESS' THEN
338: BEGIN
5537: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
5538: 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);
5539: END IF;
5540: x_party_search_rec.PARTY_ALL_NAMES:=
5541: HZ_PARTY_ACQUIRE.get_known_as(p_party_id , 'PARTY','PARTY_ALL_NAMES');
5542:
5543: EXCEPTION
5544: WHEN OTHERS THEN
5545: FND_MESSAGE.SET_NAME('AR', 'HZ_PARTY_QUERY_ERROR');
5698: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
5699: 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);
5700: END IF;
5701: x_contact_point_list(J).FLEX_FORMAT_PHONE_NUMBER:=
5702: HZ_PARTY_ACQUIRE.get_phone_number(l_contact_point_id , 'CONTACT_POINTS','FLEX_FORMAT_PHONE_NUMBER');
5703: J:=J+1;
5704:
5705: END LOOP;
5706: CLOSE c_cpts;