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_5 dependencies on HZ_DQM_SEARCH_UTIL

Line 185: IF HZ_DQM_SEARCH_UTIL.is_match(g_party_stage_rec.TX2, p_table_TX2,6) THEN

181: 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);
182: END IF;
183: RETURN total;
184: END IF;
185: IF HZ_DQM_SEARCH_UTIL.is_match(g_party_stage_rec.TX2, p_table_TX2,6) THEN
186: total := total+50;
187: IF g_score_until_thresh AND (total)>=g_thres_score THEN
188: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
189: 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 193: ELSIF HZ_DQM_SEARCH_UTIL.is_match(g_party_stage_rec.TX8, p_table_TX8,12) THEN

189: 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);
190: END IF;
191: RETURN total;
192: END IF;
193: ELSIF HZ_DQM_SEARCH_UTIL.is_match(g_party_stage_rec.TX8, p_table_TX8,12) THEN
194: total := total+45;
195: IF g_score_until_thresh AND (total)>=g_thres_score THEN
196: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
197: 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 201: ELSIF HZ_DQM_SEARCH_UTIL.is_match(g_party_stage_rec.TX4, p_table_TX4,8) THEN

197: 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);
198: END IF;
199: RETURN total;
200: END IF;
201: ELSIF HZ_DQM_SEARCH_UTIL.is_match(g_party_stage_rec.TX4, p_table_TX4,8) THEN
202: total := total+35;
203: IF g_score_until_thresh AND (total)>=g_thres_score THEN
204: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
205: 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 226: IF HZ_DQM_SEARCH_UTIL.is_match(g_party_site_stage_list(J).TX3, p_table_TX3,(50000*(J-1)+66)) THEN

222: RETURN l_current_score;
223: END IF;
224: FOR J IN 1..g_party_site_stage_list.COUNT LOOP
225: l_current_score := 0;
226: IF HZ_DQM_SEARCH_UTIL.is_match(g_party_site_stage_list(J).TX3, p_table_TX3,(50000*(J-1)+66)) THEN
227: l_current_score:=l_current_score+ 60;
228: IF g_score_until_thresh AND (l_current_score)>=g_thres_score THEN
229: x_matchidx:=J;
230: RETURN l_current_score;

Line 233: HZ_DQM_SEARCH_UTIL.is_match(g_party_site_stage_list(J).TX4, p_table_TX4,(50000*(J-1)+67)) THEN

229: x_matchidx:=J;
230: RETURN l_current_score;
231: END IF;
232: ELSIF -- l_current_score<42 AND
233: HZ_DQM_SEARCH_UTIL.is_match(g_party_site_stage_list(J).TX4, p_table_TX4,(50000*(J-1)+67)) THEN
234: l_current_score:=l_current_score+ 42;
235: IF g_score_until_thresh AND (l_current_score)>=g_thres_score THEN
236: x_matchidx:=J;
237: RETURN l_current_score;

Line 346: IF HZ_DQM_SEARCH_UTIL.is_match(p_stage_rec.TX2, p_table_TX2,(50000*(p_idx-1)+6)) THEN

342: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
343: 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);
344: END IF;
345: l_score :=0;
346: IF HZ_DQM_SEARCH_UTIL.is_match(p_stage_rec.TX2, p_table_TX2,(50000*(p_idx-1)+6)) THEN
347: l_score :=50;
348: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
349: 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);
350: END IF;

Line 352: HZ_DQM_SEARCH_UTIL.is_match(p_stage_rec.TX8, p_table_TX8,(50000*(p_idx-1)+12)) THEN

348: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
349: 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);
350: END IF;
351: ELSIF l_current_score<45 AND
352: HZ_DQM_SEARCH_UTIL.is_match(p_stage_rec.TX8, p_table_TX8,(50000*(p_idx-1)+12)) THEN
353: l_score :=45;
354: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
355: 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);
356: END IF;

Line 358: HZ_DQM_SEARCH_UTIL.is_match(p_stage_rec.TX4, p_table_TX4,(50000*(p_idx-1)+8)) THEN

354: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
355: 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);
356: END IF;
357: ELSIF l_current_score<35 AND
358: HZ_DQM_SEARCH_UTIL.is_match(p_stage_rec.TX4, p_table_TX4,(50000*(p_idx-1)+8)) THEN
359: l_score :=35;
360: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
361: 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);
362: END IF;

Line 401: IF HZ_DQM_SEARCH_UTIL.is_match(p_stage_rec.TX3, p_table_TX3,(50000*(p_idx-1)+66)) THEN

397: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
398: hz_utility_v2pub.debug(p_message=>'Inside Calling Procedure - INSERT_PARTY_SITES_SCORE',p_module_prefix=>'dqm',p_module=>'hz_match_rule_xxx',p_prefix=>NULL,p_msg_level=>fnd_log.level_statement);
399: END IF;
400: l_score :=0;
401: IF HZ_DQM_SEARCH_UTIL.is_match(p_stage_rec.TX3, p_table_TX3,(50000*(p_idx-1)+66)) THEN
402: l_score :=60;
403: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
404: 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);
405: END IF;

Line 407: HZ_DQM_SEARCH_UTIL.is_match(p_stage_rec.TX4, p_table_TX4,(50000*(p_idx-1)+67)) THEN

403: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
404: 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);
405: END IF;
406: ELSIF l_current_score<42 AND
407: HZ_DQM_SEARCH_UTIL.is_match(p_stage_rec.TX4, p_table_TX4,(50000*(p_idx-1)+67)) THEN
408: l_score :=42;
409: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
410: 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);
411: END IF;

Line 614: HZ_DQM_SEARCH_UTIL.set_score;

610: END IF;
611: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
612: 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);
613: END IF;
614: HZ_DQM_SEARCH_UTIL.set_score;
615: g_mappings.DELETE;
616: g_party_site_stage_list.DELETE;
617: g_contact_stage_list.DELETE;
618: g_contact_pt_stage_list.DELETE;

Line 621: HZ_DQM_SEARCH_UTIL.new_search;

617: g_contact_stage_list.DELETE;
618: g_contact_pt_stage_list.DELETE;
619: call_order.DELETE;
620: call_max_score.DELETE;
621: HZ_DQM_SEARCH_UTIL.new_search;
622: HZ_TRANS_PKG.set_party_type(p_party_search_rec.PARTY_TYPE);
623: HZ_DQM_SEARCH_UTIL.set_num_eval(0);
624:
625: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN

Line 623: HZ_DQM_SEARCH_UTIL.set_num_eval(0);

619: call_order.DELETE;
620: call_max_score.DELETE;
621: HZ_DQM_SEARCH_UTIL.new_search;
622: HZ_TRANS_PKG.set_party_type(p_party_search_rec.PARTY_TYPE);
623: HZ_DQM_SEARCH_UTIL.set_num_eval(0);
624:
625: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
626: 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);
627: END IF;

Line 809: HZ_DQM_SEARCH_UTIL.add_transformation( -- CLEANSE SPECIAL + WRNAMES

805: END IF;
806:
807: -- Setup query string for PARTY_NAME
808: l_prim_temp := null;
809: HZ_DQM_SEARCH_UTIL.add_transformation( -- CLEANSE SPECIAL + WRNAMES
810: g_party_stage_rec.TX4,'A8',l_prim_temp);
811:
812: IF l_denorm_str IS NOT NULL THEN
813: IF (p_non_denorm_max_score+50)>=p_threshold THEN

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

811:
812: IF l_denorm_str IS NOT NULL THEN
813: IF (p_non_denorm_max_score+50)>=p_threshold THEN
814: l_denorm_str := NULL;
815: HZ_DQM_SEARCH_UTIL.add_attribute(l_prim_temp, p_match_str, l_party_contains_str);
816: ELSIF (p_non_denorm_max_score+p_denorm_max_score+50)>=p_threshold THEN
817: HZ_DQM_SEARCH_UTIL.add_attribute_with_denorm(l_prim_temp, p_match_str, l_denorm_str, l_party_contains_str);
818: l_denorm_str := NULL;
819: END IF;

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

813: IF (p_non_denorm_max_score+50)>=p_threshold THEN
814: l_denorm_str := NULL;
815: HZ_DQM_SEARCH_UTIL.add_attribute(l_prim_temp, p_match_str, l_party_contains_str);
816: ELSIF (p_non_denorm_max_score+p_denorm_max_score+50)>=p_threshold THEN
817: HZ_DQM_SEARCH_UTIL.add_attribute_with_denorm(l_prim_temp, p_match_str, l_denorm_str, l_party_contains_str);
818: l_denorm_str := NULL;
819: END IF;
820: ELSE
821: HZ_DQM_SEARCH_UTIL.add_attribute(l_prim_temp, p_match_str, l_party_contains_str);

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

817: HZ_DQM_SEARCH_UTIL.add_attribute_with_denorm(l_prim_temp, p_match_str, l_denorm_str, l_party_contains_str);
818: l_denorm_str := NULL;
819: END IF;
820: ELSE
821: HZ_DQM_SEARCH_UTIL.add_attribute(l_prim_temp, p_match_str, l_party_contains_str);
822: END IF;
823: IF lengthb(l_party_contains_str) > 4000 THEN
824: FND_MESSAGE.SET_NAME('AR', 'HZ_SEARCH_CRIT_LARGE_ERROR');
825: FND_MESSAGE.SET_TOKEN('ENTITY','PARTY');

Line 874: HZ_DQM_SEARCH_UTIL.add_transformation( -- EXACT SPECIAL NOSPC

870:
871: -- Setup query string for POSTAL_CODE
872: l_prim_temp := null;
873: l_prim_temp_den := null;
874: HZ_DQM_SEARCH_UTIL.add_transformation( -- EXACT SPECIAL NOSPC
875: g_party_site_stage_list(I).TX11,'A30',l_prim_temp);
876: HZ_DQM_SEARCH_UTIL.add_transformation( -- EXACT SPECIAL NOSPC
877: g_party_site_stage_list(I).TX11,'D_PS',l_prim_temp_den);
878: HZ_DQM_SEARCH_UTIL.add_attribute(l_prim_temp_den, ' AND ', l_den_contains_str_temp);

Line 876: HZ_DQM_SEARCH_UTIL.add_transformation( -- EXACT SPECIAL NOSPC

872: l_prim_temp := null;
873: l_prim_temp_den := null;
874: HZ_DQM_SEARCH_UTIL.add_transformation( -- EXACT SPECIAL NOSPC
875: g_party_site_stage_list(I).TX11,'A30',l_prim_temp);
876: HZ_DQM_SEARCH_UTIL.add_transformation( -- EXACT SPECIAL NOSPC
877: g_party_site_stage_list(I).TX11,'D_PS',l_prim_temp_den);
878: HZ_DQM_SEARCH_UTIL.add_attribute(l_prim_temp_den, ' AND ', l_den_contains_str_temp);
879: HZ_DQM_SEARCH_UTIL.add_attribute(l_prim_temp, ' AND ', l_contains_str_temp);
880:

Line 878: HZ_DQM_SEARCH_UTIL.add_attribute(l_prim_temp_den, ' AND ', l_den_contains_str_temp);

874: HZ_DQM_SEARCH_UTIL.add_transformation( -- EXACT SPECIAL NOSPC
875: g_party_site_stage_list(I).TX11,'A30',l_prim_temp);
876: HZ_DQM_SEARCH_UTIL.add_transformation( -- EXACT SPECIAL NOSPC
877: g_party_site_stage_list(I).TX11,'D_PS',l_prim_temp_den);
878: HZ_DQM_SEARCH_UTIL.add_attribute(l_prim_temp_den, ' AND ', l_den_contains_str_temp);
879: HZ_DQM_SEARCH_UTIL.add_attribute(l_prim_temp, ' AND ', l_contains_str_temp);
880:
881: HZ_DQM_SEARCH_UTIL.add_search_record(l_contains_str_temp, l_filter_str, l_contains_str);
882: HZ_DQM_SEARCH_UTIL.add_search_record(l_den_contains_str_temp, null, l_den_contains_str);

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

875: g_party_site_stage_list(I).TX11,'A30',l_prim_temp);
876: HZ_DQM_SEARCH_UTIL.add_transformation( -- EXACT SPECIAL NOSPC
877: g_party_site_stage_list(I).TX11,'D_PS',l_prim_temp_den);
878: HZ_DQM_SEARCH_UTIL.add_attribute(l_prim_temp_den, ' AND ', l_den_contains_str_temp);
879: HZ_DQM_SEARCH_UTIL.add_attribute(l_prim_temp, ' AND ', l_contains_str_temp);
880:
881: HZ_DQM_SEARCH_UTIL.add_search_record(l_contains_str_temp, l_filter_str, l_contains_str);
882: HZ_DQM_SEARCH_UTIL.add_search_record(l_den_contains_str_temp, null, l_den_contains_str);
883: END LOOP;

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

877: g_party_site_stage_list(I).TX11,'D_PS',l_prim_temp_den);
878: HZ_DQM_SEARCH_UTIL.add_attribute(l_prim_temp_den, ' AND ', l_den_contains_str_temp);
879: HZ_DQM_SEARCH_UTIL.add_attribute(l_prim_temp, ' AND ', l_contains_str_temp);
880:
881: HZ_DQM_SEARCH_UTIL.add_search_record(l_contains_str_temp, l_filter_str, l_contains_str);
882: HZ_DQM_SEARCH_UTIL.add_search_record(l_den_contains_str_temp, null, l_den_contains_str);
883: END LOOP;
884: -- Add the search criteria to query string
885: IF lengthb(l_contains_str) > 4000 THEN

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

878: HZ_DQM_SEARCH_UTIL.add_attribute(l_prim_temp_den, ' AND ', l_den_contains_str_temp);
879: HZ_DQM_SEARCH_UTIL.add_attribute(l_prim_temp, ' AND ', l_contains_str_temp);
880:
881: HZ_DQM_SEARCH_UTIL.add_search_record(l_contains_str_temp, l_filter_str, l_contains_str);
882: HZ_DQM_SEARCH_UTIL.add_search_record(l_den_contains_str_temp, null, l_den_contains_str);
883: END LOOP;
884: -- Add the search criteria to query string
885: IF lengthb(l_contains_str) > 4000 THEN
886: FND_MESSAGE.SET_NAME('AR', 'HZ_SEARCH_CRIT_LARGE_ERROR');

Line 2003: HZ_DQM_SEARCH_UTIL.set_num_eval(0);

1999: H_PARTY_ID.DELETE;
2000: H_PARTY_ID_LIST.DELETE;
2001: H_SCORES.DELETE;
2002: g_mappings.DELETE;
2003: HZ_DQM_SEARCH_UTIL.set_num_eval(0);
2004: call_order(5) := call_order(1);
2005: call_type(5) := 'AND';
2006: call_max_score(5) := call_max_score(1);
2007: call_type(2) := 'OR';

Line 2794: HZ_DQM_SEARCH_UTIL.set_num_eval(l_num_eval);

2790: ELSE
2791: l_party_id:=H_PARTY_ID_LIST.NEXT(l_party_id);
2792: END IF;
2793: END LOOP;
2794: HZ_DQM_SEARCH_UTIL.set_num_eval(l_num_eval);
2795: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
2796: 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);
2797: END IF;
2798: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN

Line 2948: HZ_DQM_SEARCH_UTIL.set_num_eval(0);

2944: H_PARTY_ID.DELETE;
2945: H_PARTY_ID_LIST.DELETE;
2946: H_SCORES.DELETE;
2947: g_mappings.DELETE;
2948: HZ_DQM_SEARCH_UTIL.set_num_eval(0);
2949: call_order(5) := call_order(1);
2950: call_type(5) := 'AND';
2951: call_max_score(5) := call_max_score(1);
2952: call_type(2) := 'OR';

Line 3579: HZ_DQM_SEARCH_UTIL.set_num_eval(l_num_eval);

3575: ELSE
3576: l_party_id:=H_PARTY_ID_LIST.NEXT(l_party_id);
3577: END IF;
3578: END LOOP;
3579: HZ_DQM_SEARCH_UTIL.set_num_eval(l_num_eval);
3580: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
3581: 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);
3582: END IF;
3583: EXCEPTION