eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.HZ_MATCH_RULE_3 dependencies on HZ_DQM_SEARCH_UTIL

Line 183: IF HZ_DQM_SEARCH_UTIL.is_match(g_party_stage_rec.TX44, p_table_TX44,49) THEN

179: hz_utility_v2pub.debug(p_message=>'get_party_score returned total = '||total,p_module_prefix=>'dqm',p_module=>'hz_match_rule_xxx',p_prefix=>NULL,p_msg_level=>fnd_log.level_statement);
180: END IF;
181: RETURN total;
182: END IF;
183: IF HZ_DQM_SEARCH_UTIL.is_match(g_party_stage_rec.TX44, p_table_TX44,49) THEN
184: total := total+20;
185: IF g_score_until_thresh AND (total)>=g_thres_score THEN
186: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
187: hz_utility_v2pub.debug(p_message=>'get_party_score returned total = '||total,p_module_prefix=>'dqm',p_module=>'hz_match_rule_xxx',p_prefix=>NULL,p_msg_level=>fnd_log.level_statement);

Line 247: IF HZ_DQM_SEARCH_UTIL.is_match(g_contact_pt_stage_list(J).TX1, p_table_TX1,(50000*(J-1)+110)) THEN

243: RETURN l_current_score;
244: END IF;
245: FOR J IN 1..g_contact_pt_stage_list.COUNT LOOP
246: l_current_score := 0;
247: IF HZ_DQM_SEARCH_UTIL.is_match(g_contact_pt_stage_list(J).TX1, p_table_TX1,(50000*(J-1)+110)) THEN
248: l_current_score:=l_current_score+ 20;
249: IF g_score_until_thresh AND (l_current_score)>=g_thres_score THEN
250: x_matchidx:=J;
251: RETURN l_current_score;

Line 254: IF HZ_DQM_SEARCH_UTIL.is_match(g_contact_pt_stage_list(J).TX5, p_table_TX5,(50000*(J-1)+114)) THEN

250: x_matchidx:=J;
251: RETURN l_current_score;
252: END IF;
253: END IF;
254: IF HZ_DQM_SEARCH_UTIL.is_match(g_contact_pt_stage_list(J).TX5, p_table_TX5,(50000*(J-1)+114)) THEN
255: l_current_score:=l_current_score+ 20;
256: IF g_score_until_thresh AND (l_current_score)>=g_thres_score THEN
257: x_matchidx:=J;
258: RETURN l_current_score;

Line 261: HZ_DQM_SEARCH_UTIL.is_match(g_contact_pt_stage_list(J).TX6, p_table_TX6,(50000*(J-1)+115)) THEN

257: x_matchidx:=J;
258: RETURN l_current_score;
259: END IF;
260: ELSIF -- l_current_score<15 AND
261: HZ_DQM_SEARCH_UTIL.is_match(g_contact_pt_stage_list(J).TX6, p_table_TX6,(50000*(J-1)+115)) THEN
262: l_current_score:=l_current_score+ 15;
263: IF g_score_until_thresh AND (l_current_score)>=g_thres_score THEN
264: x_matchidx:=J;
265: RETURN l_current_score;

Line 347: IF HZ_DQM_SEARCH_UTIL.is_match(p_stage_rec.TX44, p_table_TX44,(50000*(p_idx-1)+49)) THEN

343: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
344: hz_utility_v2pub.debug(p_message=>'Inside Calling Procedure - INSERT_PARTY_SCORE',p_module_prefix=>'dqm',p_module=>'hz_match_rule_xxx',p_prefix=>NULL,p_msg_level=>fnd_log.level_statement);
345: END IF;
346: l_score :=0;
347: IF HZ_DQM_SEARCH_UTIL.is_match(p_stage_rec.TX44, p_table_TX44,(50000*(p_idx-1)+49)) THEN
348: l_score :=20;
349: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
350: hz_utility_v2pub.debug(p_message=>'l_score is - '||l_score,p_module_prefix=>'dqm',p_module=>'hz_match_rule_xxx',p_prefix=>NULL,p_msg_level=>fnd_log.level_statement);
351: END IF;

Line 423: IF HZ_DQM_SEARCH_UTIL.is_match(p_stage_rec.TX1, p_table_TX1,(50000*(p_idx-1)+110)) THEN

419: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
420: hz_utility_v2pub.debug(p_message=>'Inside Calling Procedure - INSERT_CONTACT_POINTS_SCORE',p_module_prefix=>'dqm',p_module=>'hz_match_rule_xxx',p_prefix=>NULL,p_msg_level=>fnd_log.level_statement);
421: END IF;
422: l_score :=0;
423: IF HZ_DQM_SEARCH_UTIL.is_match(p_stage_rec.TX1, p_table_TX1,(50000*(p_idx-1)+110)) THEN
424: l_score :=20;
425: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
426: hz_utility_v2pub.debug(p_message=>'l_score is - '||l_score,p_module_prefix=>'dqm',p_module=>'hz_match_rule_xxx',p_prefix=>NULL,p_msg_level=>fnd_log.level_statement);
427: END IF;

Line 448: IF HZ_DQM_SEARCH_UTIL.is_match(p_stage_rec.TX5, p_table_TX5,(50000*(p_idx-1)+114)) THEN

444: hz_utility_v2pub.debug(p_message=>'Inserting into HZ_PARTY_SCORE_DTLS_GT ... Done',p_module_prefix=>'dqm',p_module=>'hz_match_rule_xxx',p_prefix=>NULL,p_msg_level=>fnd_log.level_statement);
445: END IF;
446: END IF;
447: l_score :=0;
448: IF HZ_DQM_SEARCH_UTIL.is_match(p_stage_rec.TX5, p_table_TX5,(50000*(p_idx-1)+114)) THEN
449: l_score :=20;
450: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
451: hz_utility_v2pub.debug(p_message=>'l_score is - '||l_score,p_module_prefix=>'dqm',p_module=>'hz_match_rule_xxx',p_prefix=>NULL,p_msg_level=>fnd_log.level_statement);
452: END IF;

Line 454: HZ_DQM_SEARCH_UTIL.is_match(p_stage_rec.TX6, p_table_TX6,(50000*(p_idx-1)+115)) THEN

450: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
451: hz_utility_v2pub.debug(p_message=>'l_score is - '||l_score,p_module_prefix=>'dqm',p_module=>'hz_match_rule_xxx',p_prefix=>NULL,p_msg_level=>fnd_log.level_statement);
452: END IF;
453: ELSIF l_current_score<15 AND
454: HZ_DQM_SEARCH_UTIL.is_match(p_stage_rec.TX6, p_table_TX6,(50000*(p_idx-1)+115)) THEN
455: l_score :=15;
456: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
457: hz_utility_v2pub.debug(p_message=>'l_score is - '||l_score,p_module_prefix=>'dqm',p_module=>'hz_match_rule_xxx',p_prefix=>NULL,p_msg_level=>fnd_log.level_statement);
458: END IF;

Line 629: HZ_DQM_SEARCH_UTIL.set_score;

625: END IF;
626: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
627: hz_utility_v2pub.debug(p_message=>'In init_search calling util package set_score',p_module_prefix=>'dqm',p_module=>'hz_match_rule_xxx',p_prefix=>NULL,p_msg_level=>fnd_log.level_statement);
628: END IF;
629: HZ_DQM_SEARCH_UTIL.set_score;
630: g_mappings.DELETE;
631: g_party_site_stage_list.DELETE;
632: g_contact_stage_list.DELETE;
633: g_contact_pt_stage_list.DELETE;

Line 636: HZ_DQM_SEARCH_UTIL.new_search;

632: g_contact_stage_list.DELETE;
633: g_contact_pt_stage_list.DELETE;
634: call_order.DELETE;
635: call_max_score.DELETE;
636: HZ_DQM_SEARCH_UTIL.new_search;
637: HZ_TRANS_PKG.set_party_type(p_party_search_rec.PARTY_TYPE);
638: HZ_DQM_SEARCH_UTIL.set_num_eval(0);
639:
640: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN

Line 638: HZ_DQM_SEARCH_UTIL.set_num_eval(0);

634: call_order.DELETE;
635: call_max_score.DELETE;
636: HZ_DQM_SEARCH_UTIL.new_search;
637: HZ_TRANS_PKG.set_party_type(p_party_search_rec.PARTY_TYPE);
638: HZ_DQM_SEARCH_UTIL.set_num_eval(0);
639:
640: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
641: hz_utility_v2pub.debug(p_message=>'In init_search calling the Map procedures',p_module_prefix=>'dqm',p_module=>'hz_match_rule_xxx',p_prefix=>NULL,p_msg_level=>fnd_log.level_statement);
642: END IF;

Line 824: HZ_DQM_SEARCH_UTIL.add_transformation( -- EXACT SPECIAL

820: END IF;
821:
822: -- Setup query string for TAX_REFERENCE
823: l_prim_temp := null;
824: HZ_DQM_SEARCH_UTIL.add_transformation( -- EXACT SPECIAL
825: g_party_stage_rec.TX44,'A18',l_prim_temp);
826:
827: IF l_denorm_str IS NOT NULL THEN
828: IF (p_non_denorm_max_score+20)>=p_threshold THEN

Line 830: HZ_DQM_SEARCH_UTIL.add_attribute(l_prim_temp, p_match_str, l_party_contains_str);

826:
827: IF l_denorm_str IS NOT NULL THEN
828: IF (p_non_denorm_max_score+20)>=p_threshold THEN
829: l_denorm_str := NULL;
830: HZ_DQM_SEARCH_UTIL.add_attribute(l_prim_temp, p_match_str, l_party_contains_str);
831: ELSIF (p_non_denorm_max_score+p_denorm_max_score+20)>=p_threshold THEN
832: HZ_DQM_SEARCH_UTIL.add_attribute_with_denorm(l_prim_temp, p_match_str, l_denorm_str, l_party_contains_str);
833: l_denorm_str := NULL;
834: END IF;

Line 832: HZ_DQM_SEARCH_UTIL.add_attribute_with_denorm(l_prim_temp, p_match_str, l_denorm_str, l_party_contains_str);

828: IF (p_non_denorm_max_score+20)>=p_threshold THEN
829: l_denorm_str := NULL;
830: HZ_DQM_SEARCH_UTIL.add_attribute(l_prim_temp, p_match_str, l_party_contains_str);
831: ELSIF (p_non_denorm_max_score+p_denorm_max_score+20)>=p_threshold THEN
832: HZ_DQM_SEARCH_UTIL.add_attribute_with_denorm(l_prim_temp, p_match_str, l_denorm_str, l_party_contains_str);
833: l_denorm_str := NULL;
834: END IF;
835: ELSE
836: HZ_DQM_SEARCH_UTIL.add_attribute(l_prim_temp, p_match_str, l_party_contains_str);

Line 836: HZ_DQM_SEARCH_UTIL.add_attribute(l_prim_temp, p_match_str, l_party_contains_str);

832: HZ_DQM_SEARCH_UTIL.add_attribute_with_denorm(l_prim_temp, p_match_str, l_denorm_str, l_party_contains_str);
833: l_denorm_str := NULL;
834: END IF;
835: ELSE
836: HZ_DQM_SEARCH_UTIL.add_attribute(l_prim_temp, p_match_str, l_party_contains_str);
837: END IF;
838: IF lengthb(l_party_contains_str) > 4000 THEN
839: FND_MESSAGE.SET_NAME('AR', 'HZ_SEARCH_CRIT_LARGE_ERROR');
840: FND_MESSAGE.SET_TOKEN('ENTITY','PARTY');

Line 922: HZ_DQM_SEARCH_UTIL.add_transformation( -- EXACT SPECIAL CTX

918:
919: -- Setup query string for FLEX_FORMAT_PHONE_NUMBER
920: l_prim_temp := null;
921: l_prim_temp_den := null;
922: HZ_DQM_SEARCH_UTIL.add_transformation( -- EXACT SPECIAL CTX
923: g_contact_pt_stage_list(I).TX1,'A44',l_prim_temp);
924: HZ_DQM_SEARCH_UTIL.add_attribute(l_prim_temp, ' AND ', l_contains_str_temp);
925:
926: -- Setup query string for EMAIL_ADDRESS

Line 924: HZ_DQM_SEARCH_UTIL.add_attribute(l_prim_temp, ' AND ', l_contains_str_temp);

920: l_prim_temp := null;
921: l_prim_temp_den := null;
922: HZ_DQM_SEARCH_UTIL.add_transformation( -- EXACT SPECIAL CTX
923: g_contact_pt_stage_list(I).TX1,'A44',l_prim_temp);
924: HZ_DQM_SEARCH_UTIL.add_attribute(l_prim_temp, ' AND ', l_contains_str_temp);
925:
926: -- Setup query string for EMAIL_ADDRESS
927: l_prim_temp := null;
928: l_prim_temp_den := null;

Line 929: HZ_DQM_SEARCH_UTIL.add_transformation( -- CLEANSE (EMAIL) + WRDOMAIN

925:
926: -- Setup query string for EMAIL_ADDRESS
927: l_prim_temp := null;
928: l_prim_temp_den := null;
929: HZ_DQM_SEARCH_UTIL.add_transformation( -- CLEANSE (EMAIL) + WRDOMAIN
930: g_contact_pt_stage_list(I).TX6,'A48',l_prim_temp);
931: HZ_DQM_SEARCH_UTIL.add_attribute(l_prim_temp, ' AND ', l_contains_str_temp);
932:
933: HZ_DQM_SEARCH_UTIL.add_search_record(l_contains_str_temp, l_filter_str, l_contains_str);

Line 931: HZ_DQM_SEARCH_UTIL.add_attribute(l_prim_temp, ' AND ', l_contains_str_temp);

927: l_prim_temp := null;
928: l_prim_temp_den := null;
929: HZ_DQM_SEARCH_UTIL.add_transformation( -- CLEANSE (EMAIL) + WRDOMAIN
930: g_contact_pt_stage_list(I).TX6,'A48',l_prim_temp);
931: HZ_DQM_SEARCH_UTIL.add_attribute(l_prim_temp, ' AND ', l_contains_str_temp);
932:
933: HZ_DQM_SEARCH_UTIL.add_search_record(l_contains_str_temp, l_filter_str, l_contains_str);
934: HZ_DQM_SEARCH_UTIL.add_search_record(l_den_contains_str_temp, null, l_den_contains_str);
935: END LOOP;

Line 933: HZ_DQM_SEARCH_UTIL.add_search_record(l_contains_str_temp, l_filter_str, l_contains_str);

929: HZ_DQM_SEARCH_UTIL.add_transformation( -- CLEANSE (EMAIL) + WRDOMAIN
930: g_contact_pt_stage_list(I).TX6,'A48',l_prim_temp);
931: HZ_DQM_SEARCH_UTIL.add_attribute(l_prim_temp, ' AND ', l_contains_str_temp);
932:
933: HZ_DQM_SEARCH_UTIL.add_search_record(l_contains_str_temp, l_filter_str, l_contains_str);
934: HZ_DQM_SEARCH_UTIL.add_search_record(l_den_contains_str_temp, null, l_den_contains_str);
935: END LOOP;
936: -- Add the search criteria to query string
937: IF lengthb(l_contains_str) > 4000 THEN

Line 934: HZ_DQM_SEARCH_UTIL.add_search_record(l_den_contains_str_temp, null, l_den_contains_str);

930: g_contact_pt_stage_list(I).TX6,'A48',l_prim_temp);
931: HZ_DQM_SEARCH_UTIL.add_attribute(l_prim_temp, ' AND ', l_contains_str_temp);
932:
933: HZ_DQM_SEARCH_UTIL.add_search_record(l_contains_str_temp, l_filter_str, l_contains_str);
934: HZ_DQM_SEARCH_UTIL.add_search_record(l_den_contains_str_temp, null, l_den_contains_str);
935: END LOOP;
936: -- Add the search criteria to query string
937: IF lengthb(l_contains_str) > 4000 THEN
938: FND_MESSAGE.SET_NAME('AR', 'HZ_SEARCH_CRIT_LARGE_ERROR');

Line 2025: HZ_DQM_SEARCH_UTIL.set_num_eval(0);

2021: H_PARTY_ID.DELETE;
2022: H_PARTY_ID_LIST.DELETE;
2023: H_SCORES.DELETE;
2024: g_mappings.DELETE;
2025: HZ_DQM_SEARCH_UTIL.set_num_eval(0);
2026: call_order(5) := call_order(1);
2027: call_type(5) := 'AND';
2028: call_max_score(5) := call_max_score(1);
2029: call_type(2) := 'OR';

Line 2816: HZ_DQM_SEARCH_UTIL.set_num_eval(l_num_eval);

2812: ELSE
2813: l_party_id:=H_PARTY_ID_LIST.NEXT(l_party_id);
2814: END IF;
2815: END LOOP;
2816: HZ_DQM_SEARCH_UTIL.set_num_eval(l_num_eval);
2817: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
2818: hz_utility_v2pub.debug(p_message=>'Exiting Procedure find_parties',p_module_prefix=>'dqm',p_module=>'hz_match_rule_xxx',p_prefix=>NULL,p_msg_level=>fnd_log.level_statement);
2819: END IF;
2820: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN

Line 2970: HZ_DQM_SEARCH_UTIL.set_num_eval(0);

2966: H_PARTY_ID.DELETE;
2967: H_PARTY_ID_LIST.DELETE;
2968: H_SCORES.DELETE;
2969: g_mappings.DELETE;
2970: HZ_DQM_SEARCH_UTIL.set_num_eval(0);
2971: call_order(5) := call_order(1);
2972: call_type(5) := 'AND';
2973: call_max_score(5) := call_max_score(1);
2974: call_type(2) := 'OR';

Line 3601: HZ_DQM_SEARCH_UTIL.set_num_eval(l_num_eval);

3597: ELSE
3598: l_party_id:=H_PARTY_ID_LIST.NEXT(l_party_id);
3599: END IF;
3600: END LOOP;
3601: HZ_DQM_SEARCH_UTIL.set_num_eval(l_num_eval);
3602: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
3603: hz_utility_v2pub.debug(p_message=>'find_persons(-) ',p_module_prefix=>'dqm',p_module=>'hz_match_rule_xxx',p_prefix=>NULL,p_msg_level=>fnd_log.level_procedure);
3604: END IF;
3605: EXCEPTION