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

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

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

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

199: 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);
200: END IF;
201: RETURN total;
202: END IF;
203: ELSIF HZ_DQM_SEARCH_UTIL.is_similar_match(g_party_stage_rec.TX4, p_table_TX4, 75,8) THEN
204: total := total+35;
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 212: IF HZ_DQM_SEARCH_UTIL.is_match(g_party_stage_rec.TX41, p_table_TX41,45) THEN

208: END IF;
209: RETURN total;
210: END IF;
211: END IF;
212: IF HZ_DQM_SEARCH_UTIL.is_match(g_party_stage_rec.TX41, p_table_TX41,45) THEN
213: total := total+70;
214: IF g_score_until_thresh AND (total)>=g_thres_score THEN
215: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
216: 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 221: IF HZ_DQM_SEARCH_UTIL.is_match(g_party_stage_rec.TX44, p_table_TX44,49) THEN

217: END IF;
218: RETURN total;
219: END IF;
220: END IF;
221: IF HZ_DQM_SEARCH_UTIL.is_match(g_party_stage_rec.TX44, p_table_TX44,49) THEN
222: total := total+70;
223: IF g_score_until_thresh AND (total)>=g_thres_score THEN
224: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
225: 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 246: IF HZ_DQM_SEARCH_UTIL.is_match(g_party_site_stage_list(J).TX3, p_table_TX3,(50000*(J-1)+66)) THEN

242: RETURN l_current_score;
243: END IF;
244: FOR J IN 1..g_party_site_stage_list.COUNT LOOP
245: l_current_score := 0;
246: IF HZ_DQM_SEARCH_UTIL.is_match(g_party_site_stage_list(J).TX3, p_table_TX3,(50000*(J-1)+66)) THEN
247: l_current_score:=l_current_score+ 60;
248: IF g_score_until_thresh AND (l_current_score)>=g_thres_score THEN
249: x_matchidx:=J;
250: RETURN l_current_score;

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

249: x_matchidx:=J;
250: RETURN l_current_score;
251: END IF;
252: ELSIF -- l_current_score<42 AND
253: HZ_DQM_SEARCH_UTIL.is_match(g_party_site_stage_list(J).TX4, p_table_TX4,(50000*(J-1)+67)) THEN
254: l_current_score:=l_current_score+ 42;
255: IF g_score_until_thresh AND (l_current_score)>=g_thres_score THEN
256: x_matchidx:=J;
257: RETURN l_current_score;

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

403: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
404: 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);
405: END IF;
406: l_score :=0;
407: IF HZ_DQM_SEARCH_UTIL.is_match(p_stage_rec.TX2, p_table_TX2,(50000*(p_idx-1)+6)) THEN
408: l_score :=50;
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 413: HZ_DQM_SEARCH_UTIL.is_match(p_stage_rec.TX8, p_table_TX8,(50000*(p_idx-1)+12)) THEN

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;
412: ELSIF l_current_score<45 AND
413: HZ_DQM_SEARCH_UTIL.is_match(p_stage_rec.TX8, p_table_TX8,(50000*(p_idx-1)+12)) THEN
414: l_score :=45;
415: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
416: 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);
417: END IF;

Line 419: HZ_DQM_SEARCH_UTIL.is_similar_match(p_stage_rec.TX4, p_table_TX4, 75,(50000*(p_idx-1)+8)) THEN

415: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
416: 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);
417: END IF;
418: ELSIF l_current_score<35 AND
419: HZ_DQM_SEARCH_UTIL.is_similar_match(p_stage_rec.TX4, p_table_TX4, 75,(50000*(p_idx-1)+8)) THEN
420: l_score :=35;
421: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
422: 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);
423: END IF;

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

440: 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);
441: END IF;
442: END IF;
443: l_score :=0;
444: IF HZ_DQM_SEARCH_UTIL.is_match(p_stage_rec.TX41, p_table_TX41,(50000*(p_idx-1)+45)) THEN
445: l_score :=70;
446: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
447: 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);
448: END IF;

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

465: 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);
466: END IF;
467: END IF;
468: l_score :=0;
469: IF HZ_DQM_SEARCH_UTIL.is_match(p_stage_rec.TX44, p_table_TX44,(50000*(p_idx-1)+49)) THEN
470: l_score :=70;
471: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
472: 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);
473: END IF;

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

508: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
509: 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);
510: END IF;
511: l_score :=0;
512: IF HZ_DQM_SEARCH_UTIL.is_match(p_stage_rec.TX3, p_table_TX3,(50000*(p_idx-1)+66)) THEN
513: l_score :=60;
514: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
515: 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);
516: END IF;

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

514: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
515: 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);
516: END IF;
517: ELSIF l_current_score<42 AND
518: HZ_DQM_SEARCH_UTIL.is_match(p_stage_rec.TX4, p_table_TX4,(50000*(p_idx-1)+67)) THEN
519: l_score :=42;
520: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
521: 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);
522: END IF;

Line 725: HZ_DQM_SEARCH_UTIL.set_score;

721: END IF;
722: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
723: 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);
724: END IF;
725: HZ_DQM_SEARCH_UTIL.set_score;
726: g_mappings.DELETE;
727: g_party_site_stage_list.DELETE;
728: g_contact_stage_list.DELETE;
729: g_contact_pt_stage_list.DELETE;

Line 732: HZ_DQM_SEARCH_UTIL.new_search;

728: g_contact_stage_list.DELETE;
729: g_contact_pt_stage_list.DELETE;
730: call_order.DELETE;
731: call_max_score.DELETE;
732: HZ_DQM_SEARCH_UTIL.new_search;
733: HZ_TRANS_PKG.set_party_type(p_party_search_rec.PARTY_TYPE);
734: HZ_DQM_SEARCH_UTIL.set_num_eval(0);
735:
736: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN

Line 734: HZ_DQM_SEARCH_UTIL.set_num_eval(0);

730: call_order.DELETE;
731: call_max_score.DELETE;
732: HZ_DQM_SEARCH_UTIL.new_search;
733: HZ_TRANS_PKG.set_party_type(p_party_search_rec.PARTY_TYPE);
734: HZ_DQM_SEARCH_UTIL.set_num_eval(0);
735:
736: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
737: 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);
738: END IF;

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

916: END IF;
917:
918: -- Setup query string for PARTY_NAME
919: l_prim_temp := null;
920: HZ_DQM_SEARCH_UTIL.add_transformation( -- CLEANSE SPECIAL + WRNAMES
921: g_party_stage_rec.TX4,'A8',l_prim_temp);
922:
923: IF l_denorm_str IS NOT NULL THEN
924: IF (p_non_denorm_max_score+50)>=p_threshold THEN

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

922:
923: IF l_denorm_str IS NOT NULL THEN
924: IF (p_non_denorm_max_score+50)>=p_threshold THEN
925: l_denorm_str := NULL;
926: HZ_DQM_SEARCH_UTIL.add_attribute(l_prim_temp, p_match_str, l_party_contains_str);
927: ELSIF (p_non_denorm_max_score+p_denorm_max_score+50)>=p_threshold THEN
928: HZ_DQM_SEARCH_UTIL.add_attribute_with_denorm(l_prim_temp, p_match_str, l_denorm_str, l_party_contains_str);
929: l_denorm_str := NULL;
930: END IF;

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

924: IF (p_non_denorm_max_score+50)>=p_threshold THEN
925: l_denorm_str := NULL;
926: HZ_DQM_SEARCH_UTIL.add_attribute(l_prim_temp, p_match_str, l_party_contains_str);
927: ELSIF (p_non_denorm_max_score+p_denorm_max_score+50)>=p_threshold THEN
928: HZ_DQM_SEARCH_UTIL.add_attribute_with_denorm(l_prim_temp, p_match_str, l_denorm_str, l_party_contains_str);
929: l_denorm_str := NULL;
930: END IF;
931: ELSE
932: HZ_DQM_SEARCH_UTIL.add_attribute(l_prim_temp, p_match_str, l_party_contains_str);

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

928: HZ_DQM_SEARCH_UTIL.add_attribute_with_denorm(l_prim_temp, p_match_str, l_denorm_str, l_party_contains_str);
929: l_denorm_str := NULL;
930: END IF;
931: ELSE
932: HZ_DQM_SEARCH_UTIL.add_attribute(l_prim_temp, p_match_str, l_party_contains_str);
933: END IF;
934: IF lengthb(l_party_contains_str) > 4000 THEN
935: FND_MESSAGE.SET_NAME('AR', 'HZ_SEARCH_CRIT_LARGE_ERROR');
936: FND_MESSAGE.SET_TOKEN('ENTITY','PARTY');

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

981:
982: -- Setup query string for POSTAL_CODE
983: l_prim_temp := null;
984: l_prim_temp_den := null;
985: HZ_DQM_SEARCH_UTIL.add_transformation( -- EXACT SPECIAL NOSPC
986: g_party_site_stage_list(I).TX11,'A30',l_prim_temp);
987: HZ_DQM_SEARCH_UTIL.add_transformation( -- EXACT SPECIAL NOSPC
988: g_party_site_stage_list(I).TX11,'D_PS',l_prim_temp_den);
989: HZ_DQM_SEARCH_UTIL.add_attribute(l_prim_temp_den, ' AND ', l_den_contains_str_temp);

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

983: l_prim_temp := null;
984: l_prim_temp_den := null;
985: HZ_DQM_SEARCH_UTIL.add_transformation( -- EXACT SPECIAL NOSPC
986: g_party_site_stage_list(I).TX11,'A30',l_prim_temp);
987: HZ_DQM_SEARCH_UTIL.add_transformation( -- EXACT SPECIAL NOSPC
988: g_party_site_stage_list(I).TX11,'D_PS',l_prim_temp_den);
989: HZ_DQM_SEARCH_UTIL.add_attribute(l_prim_temp_den, ' AND ', l_den_contains_str_temp);
990: HZ_DQM_SEARCH_UTIL.add_attribute(l_prim_temp, ' AND ', l_contains_str_temp);
991:

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

985: HZ_DQM_SEARCH_UTIL.add_transformation( -- EXACT SPECIAL NOSPC
986: g_party_site_stage_list(I).TX11,'A30',l_prim_temp);
987: HZ_DQM_SEARCH_UTIL.add_transformation( -- EXACT SPECIAL NOSPC
988: g_party_site_stage_list(I).TX11,'D_PS',l_prim_temp_den);
989: HZ_DQM_SEARCH_UTIL.add_attribute(l_prim_temp_den, ' AND ', l_den_contains_str_temp);
990: HZ_DQM_SEARCH_UTIL.add_attribute(l_prim_temp, ' AND ', l_contains_str_temp);
991:
992: HZ_DQM_SEARCH_UTIL.add_search_record(l_contains_str_temp, l_filter_str, l_contains_str);
993: HZ_DQM_SEARCH_UTIL.add_search_record(l_den_contains_str_temp, null, l_den_contains_str);

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

986: g_party_site_stage_list(I).TX11,'A30',l_prim_temp);
987: HZ_DQM_SEARCH_UTIL.add_transformation( -- EXACT SPECIAL NOSPC
988: g_party_site_stage_list(I).TX11,'D_PS',l_prim_temp_den);
989: HZ_DQM_SEARCH_UTIL.add_attribute(l_prim_temp_den, ' AND ', l_den_contains_str_temp);
990: HZ_DQM_SEARCH_UTIL.add_attribute(l_prim_temp, ' AND ', l_contains_str_temp);
991:
992: HZ_DQM_SEARCH_UTIL.add_search_record(l_contains_str_temp, l_filter_str, l_contains_str);
993: HZ_DQM_SEARCH_UTIL.add_search_record(l_den_contains_str_temp, null, l_den_contains_str);
994: END LOOP;

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

988: g_party_site_stage_list(I).TX11,'D_PS',l_prim_temp_den);
989: HZ_DQM_SEARCH_UTIL.add_attribute(l_prim_temp_den, ' AND ', l_den_contains_str_temp);
990: HZ_DQM_SEARCH_UTIL.add_attribute(l_prim_temp, ' AND ', l_contains_str_temp);
991:
992: HZ_DQM_SEARCH_UTIL.add_search_record(l_contains_str_temp, l_filter_str, l_contains_str);
993: HZ_DQM_SEARCH_UTIL.add_search_record(l_den_contains_str_temp, null, l_den_contains_str);
994: END LOOP;
995: -- Add the search criteria to query string
996: IF lengthb(l_contains_str) > 4000 THEN

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

989: HZ_DQM_SEARCH_UTIL.add_attribute(l_prim_temp_den, ' AND ', l_den_contains_str_temp);
990: HZ_DQM_SEARCH_UTIL.add_attribute(l_prim_temp, ' AND ', l_contains_str_temp);
991:
992: HZ_DQM_SEARCH_UTIL.add_search_record(l_contains_str_temp, l_filter_str, l_contains_str);
993: HZ_DQM_SEARCH_UTIL.add_search_record(l_den_contains_str_temp, null, l_den_contains_str);
994: END LOOP;
995: -- Add the search criteria to query string
996: IF lengthb(l_contains_str) > 4000 THEN
997: FND_MESSAGE.SET_NAME('AR', 'HZ_SEARCH_CRIT_LARGE_ERROR');

Line 2116: HZ_DQM_SEARCH_UTIL.set_num_eval(0);

2112: H_PARTY_ID.DELETE;
2113: H_PARTY_ID_LIST.DELETE;
2114: H_SCORES.DELETE;
2115: g_mappings.DELETE;
2116: HZ_DQM_SEARCH_UTIL.set_num_eval(0);
2117: call_order(5) := call_order(1);
2118: call_type(5) := 'AND';
2119: call_max_score(5) := call_max_score(1);
2120: call_type(2) := 'OR';

Line 2907: HZ_DQM_SEARCH_UTIL.set_num_eval(l_num_eval);

2903: ELSE
2904: l_party_id:=H_PARTY_ID_LIST.NEXT(l_party_id);
2905: END IF;
2906: END LOOP;
2907: HZ_DQM_SEARCH_UTIL.set_num_eval(l_num_eval);
2908: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
2909: 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);
2910: END IF;
2911: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN

Line 3063: HZ_DQM_SEARCH_UTIL.set_num_eval(0);

3059: H_PARTY_ID.DELETE;
3060: H_PARTY_ID_LIST.DELETE;
3061: H_SCORES.DELETE;
3062: g_mappings.DELETE;
3063: HZ_DQM_SEARCH_UTIL.set_num_eval(0);
3064: call_order(5) := call_order(1);
3065: call_type(5) := 'AND';
3066: call_max_score(5) := call_max_score(1);
3067: call_type(2) := 'OR';

Line 3694: HZ_DQM_SEARCH_UTIL.set_num_eval(l_num_eval);

3690: ELSE
3691: l_party_id:=H_PARTY_ID_LIST.NEXT(l_party_id);
3692: END IF;
3693: END LOOP;
3694: HZ_DQM_SEARCH_UTIL.set_num_eval(l_num_eval);
3695: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
3696: 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);
3697: END IF;
3698: EXCEPTION