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.TX41, p_table_TX41,(50000*(p_idx-1)+45)) 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.TX41, p_table_TX41,(50000*(p_idx-1)+45)) THEN
408: l_score :=70;
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 432: IF HZ_DQM_SEARCH_UTIL.is_match(p_stage_rec.TX44, p_table_TX44,(50000*(p_idx-1)+49)) THEN

428: 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);
429: END IF;
430: END IF;
431: l_score :=0;
432: IF HZ_DQM_SEARCH_UTIL.is_match(p_stage_rec.TX44, p_table_TX44,(50000*(p_idx-1)+49)) THEN
433: l_score :=70;
434: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
435: 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);
436: END IF;

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

453: 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);
454: END IF;
455: END IF;
456: l_score :=0;
457: IF HZ_DQM_SEARCH_UTIL.is_match(p_stage_rec.TX2, p_table_TX2,(50000*(p_idx-1)+6)) THEN
458: l_score :=50;
459: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
460: 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);
461: END IF;

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

459: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
460: 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);
461: END IF;
462: ELSIF l_current_score<45 AND
463: HZ_DQM_SEARCH_UTIL.is_match(p_stage_rec.TX8, p_table_TX8,(50000*(p_idx-1)+12)) THEN
464: l_score :=45;
465: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
466: 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);
467: END IF;

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

465: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
466: 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);
467: END IF;
468: ELSIF l_current_score<35 AND
469: HZ_DQM_SEARCH_UTIL.is_similar_match(p_stage_rec.TX4, p_table_TX4, 75,(50000*(p_idx-1)+8)) THEN
470: l_score :=35;
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 2114: HZ_DQM_SEARCH_UTIL.set_num_eval(0);

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

Line 2904: HZ_DQM_SEARCH_UTIL.set_num_eval(l_num_eval);

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

Line 3060: HZ_DQM_SEARCH_UTIL.set_num_eval(0);

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

Line 3690: HZ_DQM_SEARCH_UTIL.set_num_eval(l_num_eval);

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