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

Line 185: IF HZ_DQM_SEARCH_UTIL.is_match(g_party_stage_rec.TX39, p_table_TX39,43) 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.TX39, p_table_TX39,43) THEN
186: total := total+19;
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 194: IF HZ_DQM_SEARCH_UTIL.is_match(g_party_stage_rec.TX41, p_table_TX41,45) THEN

190: END IF;
191: RETURN total;
192: END IF;
193: END IF;
194: IF HZ_DQM_SEARCH_UTIL.is_match(g_party_stage_rec.TX41, p_table_TX41,45) THEN
195: total := total+20;
196: IF g_score_until_thresh AND (total)>=g_thres_score THEN
197: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
198: 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 203: IF HZ_DQM_SEARCH_UTIL.is_match(g_party_stage_rec.TX44, p_table_TX44,49) THEN

199: END IF;
200: RETURN total;
201: END IF;
202: END IF;
203: IF HZ_DQM_SEARCH_UTIL.is_match(g_party_stage_rec.TX44, p_table_TX44,49) THEN
204: total := total+20;
205: IF g_score_until_thresh AND (total)>=g_thres_score THEN
206: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
207: 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 227: IF HZ_DQM_SEARCH_UTIL.is_match(g_party_site_stage_list(J).TX3, p_table_TX3,(50000*(J-1)+66)) THEN

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

Line 366: IF HZ_DQM_SEARCH_UTIL.is_match(p_stage_rec.TX39, p_table_TX39,(50000*(p_idx-1)+43)) THEN

362: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
363: 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);
364: END IF;
365: l_score :=0;
366: IF HZ_DQM_SEARCH_UTIL.is_match(p_stage_rec.TX39, p_table_TX39,(50000*(p_idx-1)+43)) THEN
367: l_score :=19;
368: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
369: 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);
370: END IF;

Line 391: IF HZ_DQM_SEARCH_UTIL.is_match(p_stage_rec.TX41, p_table_TX41,(50000*(p_idx-1)+45)) THEN

387: 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);
388: END IF;
389: END IF;
390: l_score :=0;
391: IF HZ_DQM_SEARCH_UTIL.is_match(p_stage_rec.TX41, p_table_TX41,(50000*(p_idx-1)+45)) THEN
392: l_score :=20;
393: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
394: 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);
395: END IF;

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

412: 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);
413: END IF;
414: END IF;
415: l_score :=0;
416: IF HZ_DQM_SEARCH_UTIL.is_match(p_stage_rec.TX44, p_table_TX44,(50000*(p_idx-1)+49)) THEN
417: l_score :=20;
418: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
419: 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);
420: END IF;

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

454: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
455: 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);
456: END IF;
457: l_score :=0;
458: IF HZ_DQM_SEARCH_UTIL.is_match(p_stage_rec.TX3, p_table_TX3,(50000*(p_idx-1)+66)) THEN
459: l_score :=19;
460: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
461: 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);
462: END IF;

Line 665: HZ_DQM_SEARCH_UTIL.set_score;

661: END IF;
662: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
663: 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);
664: END IF;
665: HZ_DQM_SEARCH_UTIL.set_score;
666: g_mappings.DELETE;
667: g_party_site_stage_list.DELETE;
668: g_contact_stage_list.DELETE;
669: g_contact_pt_stage_list.DELETE;

Line 672: HZ_DQM_SEARCH_UTIL.new_search;

668: g_contact_stage_list.DELETE;
669: g_contact_pt_stage_list.DELETE;
670: call_order.DELETE;
671: call_max_score.DELETE;
672: HZ_DQM_SEARCH_UTIL.new_search;
673: HZ_TRANS_PKG.set_party_type(p_party_search_rec.PARTY_TYPE);
674: HZ_DQM_SEARCH_UTIL.set_num_eval(0);
675:
676: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN

Line 674: HZ_DQM_SEARCH_UTIL.set_num_eval(0);

670: call_order.DELETE;
671: call_max_score.DELETE;
672: HZ_DQM_SEARCH_UTIL.new_search;
673: HZ_TRANS_PKG.set_party_type(p_party_search_rec.PARTY_TYPE);
674: HZ_DQM_SEARCH_UTIL.set_num_eval(0);
675:
676: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
677: 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);
678: END IF;

Line 860: HZ_DQM_SEARCH_UTIL.add_transformation( -- EXACT SPECIAL + WRNAMES

856: END IF;
857:
858: -- Setup query string for PARTY_ALL_NAMES
859: l_prim_temp := null;
860: HZ_DQM_SEARCH_UTIL.add_transformation( -- EXACT SPECIAL + WRNAMES
861: g_party_stage_rec.TX39,'A15',l_prim_temp);
862:
863: IF l_denorm_str IS NOT NULL THEN
864: IF (p_non_denorm_max_score+19)>=p_threshold THEN

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

862:
863: IF l_denorm_str IS NOT NULL THEN
864: IF (p_non_denorm_max_score+19)>=p_threshold THEN
865: l_denorm_str := NULL;
866: HZ_DQM_SEARCH_UTIL.add_attribute(l_prim_temp, p_match_str, l_party_contains_str);
867: ELSIF (p_non_denorm_max_score+p_denorm_max_score+19)>=p_threshold THEN
868: HZ_DQM_SEARCH_UTIL.add_attribute_with_denorm(l_prim_temp, p_match_str, l_denorm_str, l_party_contains_str);
869: l_denorm_str := NULL;
870: END IF;

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

864: IF (p_non_denorm_max_score+19)>=p_threshold THEN
865: l_denorm_str := NULL;
866: HZ_DQM_SEARCH_UTIL.add_attribute(l_prim_temp, p_match_str, l_party_contains_str);
867: ELSIF (p_non_denorm_max_score+p_denorm_max_score+19)>=p_threshold THEN
868: HZ_DQM_SEARCH_UTIL.add_attribute_with_denorm(l_prim_temp, p_match_str, l_denorm_str, l_party_contains_str);
869: l_denorm_str := NULL;
870: END IF;
871: ELSE
872: HZ_DQM_SEARCH_UTIL.add_attribute(l_prim_temp, p_match_str, l_party_contains_str);

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

868: HZ_DQM_SEARCH_UTIL.add_attribute_with_denorm(l_prim_temp, p_match_str, l_denorm_str, l_party_contains_str);
869: l_denorm_str := NULL;
870: END IF;
871: ELSE
872: HZ_DQM_SEARCH_UTIL.add_attribute(l_prim_temp, p_match_str, l_party_contains_str);
873: END IF;
874:
875: -- Setup query string for DUNS_NUMBER_C
876: l_prim_temp := null;

Line 880: HZ_DQM_SEARCH_UTIL.add_transformation( -- EXACT

876: l_prim_temp := null;
877: IF g_party_stage_rec.TX41 IS NOT NULL THEN
878: IF ltrim(g_party_stage_rec.TX41,'0') IS NOT NULL THEN
879: FOR I in lengthb(ltrim(g_party_stage_rec.TX41,'0'))..9 LOOP
880: HZ_DQM_SEARCH_UTIL.add_transformation( -- EXACT
881: lpad(ltrim(g_party_stage_rec.TX41,'0'),I,chr(48)),'A16',l_prim_temp);
882: END LOOP;
883: END IF;
884: END IF;

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

885:
886: IF l_denorm_str IS NOT NULL THEN
887: IF (p_non_denorm_max_score+20)>=p_threshold THEN
888: l_denorm_str := NULL;
889: HZ_DQM_SEARCH_UTIL.add_attribute(l_prim_temp, p_match_str, l_party_contains_str);
890: ELSIF (p_non_denorm_max_score+p_denorm_max_score+20)>=p_threshold THEN
891: HZ_DQM_SEARCH_UTIL.add_attribute_with_denorm(l_prim_temp, p_match_str, l_denorm_str, l_party_contains_str);
892: l_denorm_str := NULL;
893: END IF;

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

887: IF (p_non_denorm_max_score+20)>=p_threshold THEN
888: l_denorm_str := NULL;
889: HZ_DQM_SEARCH_UTIL.add_attribute(l_prim_temp, p_match_str, l_party_contains_str);
890: ELSIF (p_non_denorm_max_score+p_denorm_max_score+20)>=p_threshold THEN
891: HZ_DQM_SEARCH_UTIL.add_attribute_with_denorm(l_prim_temp, p_match_str, l_denorm_str, l_party_contains_str);
892: l_denorm_str := NULL;
893: END IF;
894: ELSE
895: HZ_DQM_SEARCH_UTIL.add_attribute(l_prim_temp, p_match_str, l_party_contains_str);

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

891: HZ_DQM_SEARCH_UTIL.add_attribute_with_denorm(l_prim_temp, p_match_str, l_denorm_str, l_party_contains_str);
892: l_denorm_str := NULL;
893: END IF;
894: ELSE
895: HZ_DQM_SEARCH_UTIL.add_attribute(l_prim_temp, p_match_str, l_party_contains_str);
896: END IF;
897:
898: -- Setup query string for TAX_REFERENCE
899: l_prim_temp := null;

Line 900: HZ_DQM_SEARCH_UTIL.add_transformation( -- EXACT SPECIAL

896: END IF;
897:
898: -- Setup query string for TAX_REFERENCE
899: l_prim_temp := null;
900: HZ_DQM_SEARCH_UTIL.add_transformation( -- EXACT SPECIAL
901: g_party_stage_rec.TX44,'A18',l_prim_temp);
902:
903: IF l_denorm_str IS NOT NULL THEN
904: IF (p_non_denorm_max_score+20)>=p_threshold THEN

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

902:
903: IF l_denorm_str IS NOT NULL THEN
904: IF (p_non_denorm_max_score+20)>=p_threshold THEN
905: l_denorm_str := NULL;
906: HZ_DQM_SEARCH_UTIL.add_attribute(l_prim_temp, p_match_str, l_party_contains_str);
907: ELSIF (p_non_denorm_max_score+p_denorm_max_score+20)>=p_threshold THEN
908: HZ_DQM_SEARCH_UTIL.add_attribute_with_denorm(l_prim_temp, p_match_str, l_denorm_str, l_party_contains_str);
909: l_denorm_str := NULL;
910: END IF;

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

904: IF (p_non_denorm_max_score+20)>=p_threshold THEN
905: l_denorm_str := NULL;
906: HZ_DQM_SEARCH_UTIL.add_attribute(l_prim_temp, p_match_str, l_party_contains_str);
907: ELSIF (p_non_denorm_max_score+p_denorm_max_score+20)>=p_threshold THEN
908: HZ_DQM_SEARCH_UTIL.add_attribute_with_denorm(l_prim_temp, p_match_str, l_denorm_str, l_party_contains_str);
909: l_denorm_str := NULL;
910: END IF;
911: ELSE
912: HZ_DQM_SEARCH_UTIL.add_attribute(l_prim_temp, p_match_str, l_party_contains_str);

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

908: HZ_DQM_SEARCH_UTIL.add_attribute_with_denorm(l_prim_temp, p_match_str, l_denorm_str, l_party_contains_str);
909: l_denorm_str := NULL;
910: END IF;
911: ELSE
912: HZ_DQM_SEARCH_UTIL.add_attribute(l_prim_temp, p_match_str, l_party_contains_str);
913: END IF;
914: IF lengthb(l_party_contains_str) > 4000 THEN
915: FND_MESSAGE.SET_NAME('AR', 'HZ_SEARCH_CRIT_LARGE_ERROR');
916: FND_MESSAGE.SET_TOKEN('ENTITY','PARTY');

Line 965: HZ_DQM_SEARCH_UTIL.add_transformation( -- EXACT SPECIAL + WRADDRESS

961:
962: -- Setup query string for ADDRESS
963: l_prim_temp := null;
964: l_prim_temp_den := null;
965: HZ_DQM_SEARCH_UTIL.add_transformation( -- EXACT SPECIAL + WRADDRESS
966: g_party_site_stage_list(I).TX3,'A27',l_prim_temp);
967: HZ_DQM_SEARCH_UTIL.add_attribute(l_prim_temp, ' AND ', l_contains_str_temp);
968:
969: HZ_DQM_SEARCH_UTIL.add_search_record(l_contains_str_temp, l_filter_str, l_contains_str);

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

963: l_prim_temp := null;
964: l_prim_temp_den := null;
965: HZ_DQM_SEARCH_UTIL.add_transformation( -- EXACT SPECIAL + WRADDRESS
966: g_party_site_stage_list(I).TX3,'A27',l_prim_temp);
967: HZ_DQM_SEARCH_UTIL.add_attribute(l_prim_temp, ' AND ', l_contains_str_temp);
968:
969: HZ_DQM_SEARCH_UTIL.add_search_record(l_contains_str_temp, l_filter_str, l_contains_str);
970: HZ_DQM_SEARCH_UTIL.add_search_record(l_den_contains_str_temp, null, l_den_contains_str);
971: END LOOP;

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

965: HZ_DQM_SEARCH_UTIL.add_transformation( -- EXACT SPECIAL + WRADDRESS
966: g_party_site_stage_list(I).TX3,'A27',l_prim_temp);
967: HZ_DQM_SEARCH_UTIL.add_attribute(l_prim_temp, ' AND ', l_contains_str_temp);
968:
969: HZ_DQM_SEARCH_UTIL.add_search_record(l_contains_str_temp, l_filter_str, l_contains_str);
970: HZ_DQM_SEARCH_UTIL.add_search_record(l_den_contains_str_temp, null, l_den_contains_str);
971: END LOOP;
972: -- Add the search criteria to query string
973: IF lengthb(l_contains_str) > 4000 THEN

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

966: g_party_site_stage_list(I).TX3,'A27',l_prim_temp);
967: HZ_DQM_SEARCH_UTIL.add_attribute(l_prim_temp, ' AND ', l_contains_str_temp);
968:
969: HZ_DQM_SEARCH_UTIL.add_search_record(l_contains_str_temp, l_filter_str, l_contains_str);
970: HZ_DQM_SEARCH_UTIL.add_search_record(l_den_contains_str_temp, null, l_den_contains_str);
971: END LOOP;
972: -- Add the search criteria to query string
973: IF lengthb(l_contains_str) > 4000 THEN
974: FND_MESSAGE.SET_NAME('AR', 'HZ_SEARCH_CRIT_LARGE_ERROR');

Line 2105: HZ_DQM_SEARCH_UTIL.set_num_eval(0);

2101: H_PARTY_ID.DELETE;
2102: H_PARTY_ID_LIST.DELETE;
2103: H_SCORES.DELETE;
2104: g_mappings.DELETE;
2105: HZ_DQM_SEARCH_UTIL.set_num_eval(0);
2106: call_order(5) := call_order(1);
2107: call_type(5) := 'AND';
2108: call_max_score(5) := call_max_score(1);
2109: call_type(2) := 'OR';

Line 2895: HZ_DQM_SEARCH_UTIL.set_num_eval(l_num_eval);

2891: ELSE
2892: l_party_id:=H_PARTY_ID_LIST.NEXT(l_party_id);
2893: END IF;
2894: END LOOP;
2895: HZ_DQM_SEARCH_UTIL.set_num_eval(l_num_eval);
2896: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
2897: 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);
2898: END IF;
2899: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN

Line 3049: HZ_DQM_SEARCH_UTIL.set_num_eval(0);

3045: H_PARTY_ID.DELETE;
3046: H_PARTY_ID_LIST.DELETE;
3047: H_SCORES.DELETE;
3048: g_mappings.DELETE;
3049: HZ_DQM_SEARCH_UTIL.set_num_eval(0);
3050: call_order(5) := call_order(1);
3051: call_type(5) := 'AND';
3052: call_max_score(5) := call_max_score(1);
3053: call_type(2) := 'OR';

Line 3679: HZ_DQM_SEARCH_UTIL.set_num_eval(l_num_eval);

3675: ELSE
3676: l_party_id:=H_PARTY_ID_LIST.NEXT(l_party_id);
3677: END IF;
3678: END LOOP;
3679: HZ_DQM_SEARCH_UTIL.set_num_eval(l_num_eval);
3680: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
3681: 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);
3682: END IF;
3683: EXCEPTION