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

Line 188: IF HZ_DQM_SEARCH_UTIL.is_match(g_party_stage_rec.TX34, p_table_TX34,38) THEN

184: 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);
185: END IF;
186: RETURN total;
187: END IF;
188: IF HZ_DQM_SEARCH_UTIL.is_match(g_party_stage_rec.TX34, p_table_TX34,38) THEN
189: total := total+100;
190: IF g_score_until_thresh AND (total)>=g_thres_score THEN
191: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
192: 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 197: IF HZ_DQM_SEARCH_UTIL.is_match(g_party_stage_rec.TX36, p_table_TX36,40) THEN

193: END IF;
194: RETURN total;
195: END IF;
196: END IF;
197: IF HZ_DQM_SEARCH_UTIL.is_match(g_party_stage_rec.TX36, p_table_TX36,40) THEN
198: total := total+10;
199: IF g_score_until_thresh AND (total)>=g_thres_score THEN
200: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
201: 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 206: IF HZ_DQM_SEARCH_UTIL.is_match(g_party_stage_rec.TX39, p_table_TX39,43) THEN

202: END IF;
203: RETURN total;
204: END IF;
205: END IF;
206: IF HZ_DQM_SEARCH_UTIL.is_match(g_party_stage_rec.TX39, p_table_TX39,43) THEN
207: total := total+40;
208: IF g_score_until_thresh AND (total)>=g_thres_score THEN
209: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
210: 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 214: ELSIF HZ_DQM_SEARCH_UTIL.is_match(g_party_stage_rec.TX40, p_table_TX40,44) THEN

210: 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);
211: END IF;
212: RETURN total;
213: END IF;
214: ELSIF HZ_DQM_SEARCH_UTIL.is_match(g_party_stage_rec.TX40, p_table_TX40,44) THEN
215: total := total+32;
216: IF g_score_until_thresh AND (total)>=g_thres_score THEN
217: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
218: 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 222: ELSIF HZ_DQM_SEARCH_UTIL.is_match(g_party_stage_rec.TX158, p_table_TX158,123) THEN

218: 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);
219: END IF;
220: RETURN total;
221: END IF;
222: ELSIF HZ_DQM_SEARCH_UTIL.is_match(g_party_stage_rec.TX158, p_table_TX158,123) THEN
223: total := total+24;
224: IF g_score_until_thresh AND (total)>=g_thres_score THEN
225: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
226: 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 231: IF HZ_DQM_SEARCH_UTIL.is_match(g_party_stage_rec.TX46, p_table_TX46,51) THEN

227: END IF;
228: RETURN total;
229: END IF;
230: END IF;
231: IF HZ_DQM_SEARCH_UTIL.is_match(g_party_stage_rec.TX46, p_table_TX46,51) THEN
232: total := total+20;
233: IF g_score_until_thresh AND (total)>=g_thres_score THEN
234: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
235: 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 260: IF HZ_DQM_SEARCH_UTIL.is_match(g_party_site_stage_list(J).TX3, p_table_TX3,(50000*(J-1)+66)) THEN

256: RETURN l_current_score;
257: END IF;
258: FOR J IN 1..g_party_site_stage_list.COUNT LOOP
259: l_current_score := 0;
260: IF HZ_DQM_SEARCH_UTIL.is_match(g_party_site_stage_list(J).TX3, p_table_TX3,(50000*(J-1)+66)) THEN
261: l_current_score:=l_current_score+ 25;
262: IF g_score_until_thresh AND (l_current_score)>=g_thres_score THEN
263: x_matchidx:=J;
264: RETURN l_current_score;

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

263: x_matchidx:=J;
264: RETURN l_current_score;
265: END IF;
266: ELSIF -- l_current_score<20 AND
267: HZ_DQM_SEARCH_UTIL.is_match(g_party_site_stage_list(J).TX4, p_table_TX4,(50000*(J-1)+67)) THEN
268: l_current_score:=l_current_score+ 20;
269: IF g_score_until_thresh AND (l_current_score)>=g_thres_score THEN
270: x_matchidx:=J;
271: RETURN l_current_score;

Line 274: IF HZ_DQM_SEARCH_UTIL.is_match(g_party_site_stage_list(J).TX9, p_table_TX9,(50000*(J-1)+72)) THEN

270: x_matchidx:=J;
271: RETURN l_current_score;
272: END IF;
273: END IF;
274: IF HZ_DQM_SEARCH_UTIL.is_match(g_party_site_stage_list(J).TX9, p_table_TX9,(50000*(J-1)+72)) THEN
275: l_current_score:=l_current_score+ 10;
276: IF g_score_until_thresh AND (l_current_score)>=g_thres_score THEN
277: x_matchidx:=J;
278: RETURN l_current_score;

Line 281: HZ_DQM_SEARCH_UTIL.is_match(g_party_site_stage_list(J).TX10, p_table_TX10,(50000*(J-1)+73)) THEN

277: x_matchidx:=J;
278: RETURN l_current_score;
279: END IF;
280: ELSIF -- l_current_score<8 AND
281: HZ_DQM_SEARCH_UTIL.is_match(g_party_site_stage_list(J).TX10, p_table_TX10,(50000*(J-1)+73)) THEN
282: l_current_score:=l_current_score+ 8;
283: IF g_score_until_thresh AND (l_current_score)>=g_thres_score THEN
284: x_matchidx:=J;
285: RETURN l_current_score;

Line 288: IF HZ_DQM_SEARCH_UTIL.is_match(g_party_site_stage_list(J).TX14, p_table_TX14,(50000*(J-1)+77)) THEN

284: x_matchidx:=J;
285: RETURN l_current_score;
286: END IF;
287: END IF;
288: IF HZ_DQM_SEARCH_UTIL.is_match(g_party_site_stage_list(J).TX14, p_table_TX14,(50000*(J-1)+77)) THEN
289: l_current_score:=l_current_score+ 5;
290: IF g_score_until_thresh AND (l_current_score)>=g_thres_score THEN
291: x_matchidx:=J;
292: RETURN l_current_score;

Line 295: IF HZ_DQM_SEARCH_UTIL.is_match(g_party_site_stage_list(J).TX22, p_table_TX22,(50000*(J-1)+85)) THEN

291: x_matchidx:=J;
292: RETURN l_current_score;
293: END IF;
294: END IF;
295: IF HZ_DQM_SEARCH_UTIL.is_match(g_party_site_stage_list(J).TX22, p_table_TX22,(50000*(J-1)+85)) THEN
296: l_current_score:=l_current_score+ 5;
297: IF g_score_until_thresh AND (l_current_score)>=g_thres_score THEN
298: x_matchidx:=J;
299: RETURN l_current_score;

Line 492: IF HZ_DQM_SEARCH_UTIL.is_match(p_stage_rec.TX34, p_table_TX34,(50000*(p_idx-1)+38)) THEN

488: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
489: 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);
490: END IF;
491: l_score :=0;
492: IF HZ_DQM_SEARCH_UTIL.is_match(p_stage_rec.TX34, p_table_TX34,(50000*(p_idx-1)+38)) THEN
493: l_score :=100;
494: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
495: 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);
496: END IF;

Line 517: IF HZ_DQM_SEARCH_UTIL.is_match(p_stage_rec.TX36, p_table_TX36,(50000*(p_idx-1)+40)) THEN

513: 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);
514: END IF;
515: END IF;
516: l_score :=0;
517: IF HZ_DQM_SEARCH_UTIL.is_match(p_stage_rec.TX36, p_table_TX36,(50000*(p_idx-1)+40)) THEN
518: l_score :=10;
519: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
520: 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);
521: END IF;

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

538: 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);
539: END IF;
540: END IF;
541: l_score :=0;
542: IF HZ_DQM_SEARCH_UTIL.is_match(p_stage_rec.TX39, p_table_TX39,(50000*(p_idx-1)+43)) THEN
543: l_score :=40;
544: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
545: 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);
546: END IF;

Line 548: HZ_DQM_SEARCH_UTIL.is_match(p_stage_rec.TX40, p_table_TX40,(50000*(p_idx-1)+44)) THEN

544: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
545: 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);
546: END IF;
547: ELSIF l_current_score<32 AND
548: HZ_DQM_SEARCH_UTIL.is_match(p_stage_rec.TX40, p_table_TX40,(50000*(p_idx-1)+44)) THEN
549: l_score :=32;
550: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
551: 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);
552: END IF;

Line 554: HZ_DQM_SEARCH_UTIL.is_match(p_stage_rec.TX158, p_table_TX158,(50000*(p_idx-1)+123)) THEN

550: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
551: 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);
552: END IF;
553: ELSIF l_current_score<24 AND
554: HZ_DQM_SEARCH_UTIL.is_match(p_stage_rec.TX158, p_table_TX158,(50000*(p_idx-1)+123)) THEN
555: l_score :=24;
556: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
557: 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);
558: END IF;

Line 579: IF HZ_DQM_SEARCH_UTIL.is_match(p_stage_rec.TX46, p_table_TX46,(50000*(p_idx-1)+51)) THEN

575: 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);
576: END IF;
577: END IF;
578: l_score :=0;
579: IF HZ_DQM_SEARCH_UTIL.is_match(p_stage_rec.TX46, p_table_TX46,(50000*(p_idx-1)+51)) THEN
580: l_score :=20;
581: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
582: 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);
583: END IF;

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

622: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
623: 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);
624: END IF;
625: l_score :=0;
626: IF HZ_DQM_SEARCH_UTIL.is_match(p_stage_rec.TX3, p_table_TX3,(50000*(p_idx-1)+66)) THEN
627: l_score :=25;
628: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
629: 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);
630: END IF;

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

628: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
629: 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);
630: END IF;
631: ELSIF l_current_score<20 AND
632: HZ_DQM_SEARCH_UTIL.is_match(p_stage_rec.TX4, p_table_TX4,(50000*(p_idx-1)+67)) THEN
633: l_score :=20;
634: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
635: 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);
636: END IF;

Line 657: IF HZ_DQM_SEARCH_UTIL.is_match(p_stage_rec.TX9, p_table_TX9,(50000*(p_idx-1)+72)) THEN

653: 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);
654: END IF;
655: END IF;
656: l_score :=0;
657: IF HZ_DQM_SEARCH_UTIL.is_match(p_stage_rec.TX9, p_table_TX9,(50000*(p_idx-1)+72)) THEN
658: l_score :=10;
659: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
660: 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);
661: END IF;

Line 663: HZ_DQM_SEARCH_UTIL.is_match(p_stage_rec.TX10, p_table_TX10,(50000*(p_idx-1)+73)) THEN

659: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
660: 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);
661: END IF;
662: ELSIF l_current_score<8 AND
663: HZ_DQM_SEARCH_UTIL.is_match(p_stage_rec.TX10, p_table_TX10,(50000*(p_idx-1)+73)) THEN
664: l_score :=8;
665: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
666: 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);
667: END IF;

Line 688: IF HZ_DQM_SEARCH_UTIL.is_match(p_stage_rec.TX14, p_table_TX14,(50000*(p_idx-1)+77)) THEN

684: 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);
685: END IF;
686: END IF;
687: l_score :=0;
688: IF HZ_DQM_SEARCH_UTIL.is_match(p_stage_rec.TX14, p_table_TX14,(50000*(p_idx-1)+77)) THEN
689: l_score :=5;
690: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
691: 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);
692: END IF;

Line 713: IF HZ_DQM_SEARCH_UTIL.is_match(p_stage_rec.TX22, p_table_TX22,(50000*(p_idx-1)+85)) THEN

709: 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);
710: END IF;
711: END IF;
712: l_score :=0;
713: IF HZ_DQM_SEARCH_UTIL.is_match(p_stage_rec.TX22, p_table_TX22,(50000*(p_idx-1)+85)) THEN
714: l_score :=5;
715: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
716: 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);
717: END IF;

Line 925: HZ_DQM_SEARCH_UTIL.set_score;

921: END IF;
922: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
923: 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);
924: END IF;
925: HZ_DQM_SEARCH_UTIL.set_score;
926: g_mappings.DELETE;
927: g_party_site_stage_list.DELETE;
928: g_contact_stage_list.DELETE;
929: g_contact_pt_stage_list.DELETE;

Line 932: HZ_DQM_SEARCH_UTIL.new_search;

928: g_contact_stage_list.DELETE;
929: g_contact_pt_stage_list.DELETE;
930: call_order.DELETE;
931: call_max_score.DELETE;
932: HZ_DQM_SEARCH_UTIL.new_search;
933: HZ_TRANS_PKG.set_party_type(p_party_search_rec.PARTY_TYPE);
934: HZ_DQM_SEARCH_UTIL.set_num_eval(0);
935:
936: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN

Line 934: HZ_DQM_SEARCH_UTIL.set_num_eval(0);

930: call_order.DELETE;
931: call_max_score.DELETE;
932: HZ_DQM_SEARCH_UTIL.new_search;
933: HZ_TRANS_PKG.set_party_type(p_party_search_rec.PARTY_TYPE);
934: HZ_DQM_SEARCH_UTIL.set_num_eval(0);
935:
936: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
937: 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);
938: END IF;

Line 1120: HZ_DQM_SEARCH_UTIL.add_transformation( -- EXACT

1116: END IF;
1117:
1118: -- Setup query string for PARTY_TYPE
1119: l_prim_temp := null;
1120: HZ_DQM_SEARCH_UTIL.add_transformation( -- EXACT
1121: g_party_stage_rec.TX36,'A14',l_prim_temp);
1122:
1123: IF l_denorm_str IS NOT NULL THEN
1124: IF (p_non_denorm_max_score+10)>=p_threshold THEN

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

1122:
1123: IF l_denorm_str IS NOT NULL THEN
1124: IF (p_non_denorm_max_score+10)>=p_threshold THEN
1125: l_denorm_str := NULL;
1126: HZ_DQM_SEARCH_UTIL.add_attribute(l_prim_temp, p_match_str, l_party_contains_str);
1127: ELSIF (p_non_denorm_max_score+p_denorm_max_score+10)>=p_threshold THEN
1128: HZ_DQM_SEARCH_UTIL.add_attribute_with_denorm(l_prim_temp, p_match_str, l_denorm_str, l_party_contains_str);
1129: l_denorm_str := NULL;
1130: END IF;

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

1124: IF (p_non_denorm_max_score+10)>=p_threshold THEN
1125: l_denorm_str := NULL;
1126: HZ_DQM_SEARCH_UTIL.add_attribute(l_prim_temp, p_match_str, l_party_contains_str);
1127: ELSIF (p_non_denorm_max_score+p_denorm_max_score+10)>=p_threshold THEN
1128: HZ_DQM_SEARCH_UTIL.add_attribute_with_denorm(l_prim_temp, p_match_str, l_denorm_str, l_party_contains_str);
1129: l_denorm_str := NULL;
1130: END IF;
1131: ELSE
1132: HZ_DQM_SEARCH_UTIL.add_attribute(l_prim_temp, p_match_str, l_party_contains_str);

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

1128: HZ_DQM_SEARCH_UTIL.add_attribute_with_denorm(l_prim_temp, p_match_str, l_denorm_str, l_party_contains_str);
1129: l_denorm_str := NULL;
1130: END IF;
1131: ELSE
1132: HZ_DQM_SEARCH_UTIL.add_attribute(l_prim_temp, p_match_str, l_party_contains_str);
1133: END IF;
1134:
1135: -- Setup query string for SIC_CODE
1136: l_prim_temp := null;

Line 1137: HZ_DQM_SEARCH_UTIL.add_transformation( -- EXACT

1133: END IF;
1134:
1135: -- Setup query string for SIC_CODE
1136: l_prim_temp := null;
1137: HZ_DQM_SEARCH_UTIL.add_transformation( -- EXACT
1138: g_party_stage_rec.TX46,'A20',l_prim_temp);
1139:
1140: IF l_denorm_str IS NOT NULL THEN
1141: IF (p_non_denorm_max_score+20)>=p_threshold THEN

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

1139:
1140: IF l_denorm_str IS NOT NULL THEN
1141: IF (p_non_denorm_max_score+20)>=p_threshold THEN
1142: l_denorm_str := NULL;
1143: HZ_DQM_SEARCH_UTIL.add_attribute(l_prim_temp, p_match_str, l_party_contains_str);
1144: ELSIF (p_non_denorm_max_score+p_denorm_max_score+20)>=p_threshold THEN
1145: HZ_DQM_SEARCH_UTIL.add_attribute_with_denorm(l_prim_temp, p_match_str, l_denorm_str, l_party_contains_str);
1146: l_denorm_str := NULL;
1147: END IF;

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

1141: IF (p_non_denorm_max_score+20)>=p_threshold THEN
1142: l_denorm_str := NULL;
1143: HZ_DQM_SEARCH_UTIL.add_attribute(l_prim_temp, p_match_str, l_party_contains_str);
1144: ELSIF (p_non_denorm_max_score+p_denorm_max_score+20)>=p_threshold THEN
1145: HZ_DQM_SEARCH_UTIL.add_attribute_with_denorm(l_prim_temp, p_match_str, l_denorm_str, l_party_contains_str);
1146: l_denorm_str := NULL;
1147: END IF;
1148: ELSE
1149: HZ_DQM_SEARCH_UTIL.add_attribute(l_prim_temp, p_match_str, l_party_contains_str);

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

1145: HZ_DQM_SEARCH_UTIL.add_attribute_with_denorm(l_prim_temp, p_match_str, l_denorm_str, l_party_contains_str);
1146: l_denorm_str := NULL;
1147: END IF;
1148: ELSE
1149: HZ_DQM_SEARCH_UTIL.add_attribute(l_prim_temp, p_match_str, l_party_contains_str);
1150: END IF;
1151:
1152: -- Setup query string for PARTY_ALL_NAMES
1153: l_prim_temp := null;

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

1150: END IF;
1151:
1152: -- Setup query string for PARTY_ALL_NAMES
1153: l_prim_temp := null;
1154: HZ_DQM_SEARCH_UTIL.add_transformation( -- CLEANSE SPECIAL + WRNAMES
1155: g_party_stage_rec.TX40,'A15',l_prim_temp);
1156: HZ_DQM_SEARCH_UTIL.add_transformation( -- SOUNDEX
1157: g_party_stage_rec.TX158,'A15',l_prim_temp);
1158:

Line 1156: HZ_DQM_SEARCH_UTIL.add_transformation( -- SOUNDEX

1152: -- Setup query string for PARTY_ALL_NAMES
1153: l_prim_temp := null;
1154: HZ_DQM_SEARCH_UTIL.add_transformation( -- CLEANSE SPECIAL + WRNAMES
1155: g_party_stage_rec.TX40,'A15',l_prim_temp);
1156: HZ_DQM_SEARCH_UTIL.add_transformation( -- SOUNDEX
1157: g_party_stage_rec.TX158,'A15',l_prim_temp);
1158:
1159: IF l_denorm_str IS NOT NULL THEN
1160: IF (p_non_denorm_max_score+40)>=p_threshold THEN

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

1158:
1159: IF l_denorm_str IS NOT NULL THEN
1160: IF (p_non_denorm_max_score+40)>=p_threshold THEN
1161: l_denorm_str := NULL;
1162: HZ_DQM_SEARCH_UTIL.add_attribute(l_prim_temp, p_match_str, l_party_contains_str);
1163: ELSIF (p_non_denorm_max_score+p_denorm_max_score+40)>=p_threshold THEN
1164: HZ_DQM_SEARCH_UTIL.add_attribute_with_denorm(l_prim_temp, p_match_str, l_denorm_str, l_party_contains_str);
1165: l_denorm_str := NULL;
1166: END IF;

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

1160: IF (p_non_denorm_max_score+40)>=p_threshold THEN
1161: l_denorm_str := NULL;
1162: HZ_DQM_SEARCH_UTIL.add_attribute(l_prim_temp, p_match_str, l_party_contains_str);
1163: ELSIF (p_non_denorm_max_score+p_denorm_max_score+40)>=p_threshold THEN
1164: HZ_DQM_SEARCH_UTIL.add_attribute_with_denorm(l_prim_temp, p_match_str, l_denorm_str, l_party_contains_str);
1165: l_denorm_str := NULL;
1166: END IF;
1167: ELSE
1168: HZ_DQM_SEARCH_UTIL.add_attribute(l_prim_temp, p_match_str, l_party_contains_str);

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

1164: HZ_DQM_SEARCH_UTIL.add_attribute_with_denorm(l_prim_temp, p_match_str, l_denorm_str, l_party_contains_str);
1165: l_denorm_str := NULL;
1166: END IF;
1167: ELSE
1168: HZ_DQM_SEARCH_UTIL.add_attribute(l_prim_temp, p_match_str, l_party_contains_str);
1169: END IF;
1170:
1171: -- Setup query string for PARTY_NUMBER
1172: l_prim_temp := null;

Line 1173: HZ_DQM_SEARCH_UTIL.add_transformation( -- EXACT SPECIAL

1169: END IF;
1170:
1171: -- Setup query string for PARTY_NUMBER
1172: l_prim_temp := null;
1173: HZ_DQM_SEARCH_UTIL.add_transformation( -- EXACT SPECIAL
1174: g_party_stage_rec.TX34,'A12',l_prim_temp);
1175:
1176: IF l_denorm_str IS NOT NULL THEN
1177: IF (p_non_denorm_max_score+100)>=p_threshold THEN

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

1175:
1176: IF l_denorm_str IS NOT NULL THEN
1177: IF (p_non_denorm_max_score+100)>=p_threshold THEN
1178: l_denorm_str := NULL;
1179: HZ_DQM_SEARCH_UTIL.add_attribute(l_prim_temp, p_match_str, l_party_contains_str);
1180: ELSIF (p_non_denorm_max_score+p_denorm_max_score+100)>=p_threshold THEN
1181: HZ_DQM_SEARCH_UTIL.add_attribute_with_denorm(l_prim_temp, p_match_str, l_denorm_str, l_party_contains_str);
1182: l_denorm_str := NULL;
1183: END IF;

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

1177: IF (p_non_denorm_max_score+100)>=p_threshold THEN
1178: l_denorm_str := NULL;
1179: HZ_DQM_SEARCH_UTIL.add_attribute(l_prim_temp, p_match_str, l_party_contains_str);
1180: ELSIF (p_non_denorm_max_score+p_denorm_max_score+100)>=p_threshold THEN
1181: HZ_DQM_SEARCH_UTIL.add_attribute_with_denorm(l_prim_temp, p_match_str, l_denorm_str, l_party_contains_str);
1182: l_denorm_str := NULL;
1183: END IF;
1184: ELSE
1185: HZ_DQM_SEARCH_UTIL.add_attribute(l_prim_temp, p_match_str, l_party_contains_str);

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

1181: HZ_DQM_SEARCH_UTIL.add_attribute_with_denorm(l_prim_temp, p_match_str, l_denorm_str, l_party_contains_str);
1182: l_denorm_str := NULL;
1183: END IF;
1184: ELSE
1185: HZ_DQM_SEARCH_UTIL.add_attribute(l_prim_temp, p_match_str, l_party_contains_str);
1186: END IF;
1187: IF lengthb(l_party_contains_str) > 4000 THEN
1188: FND_MESSAGE.SET_NAME('AR', 'HZ_SEARCH_CRIT_LARGE_ERROR');
1189: FND_MESSAGE.SET_TOKEN('ENTITY','PARTY');

Line 1238: HZ_DQM_SEARCH_UTIL.add_transformation( -- CLEANSE SPECIAL + WRADDRESS

1234:
1235: -- Setup query string for ADDRESS
1236: l_prim_temp := null;
1237: l_prim_temp_den := null;
1238: HZ_DQM_SEARCH_UTIL.add_transformation( -- CLEANSE SPECIAL + WRADDRESS
1239: g_party_site_stage_list(I).TX4,'A27',l_prim_temp);
1240: HZ_DQM_SEARCH_UTIL.add_attribute(l_prim_temp, ' AND ', l_contains_str_temp);
1241:
1242: -- Setup query string for CITY

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

1236: l_prim_temp := null;
1237: l_prim_temp_den := null;
1238: HZ_DQM_SEARCH_UTIL.add_transformation( -- CLEANSE SPECIAL + WRADDRESS
1239: g_party_site_stage_list(I).TX4,'A27',l_prim_temp);
1240: HZ_DQM_SEARCH_UTIL.add_attribute(l_prim_temp, ' AND ', l_contains_str_temp);
1241:
1242: -- Setup query string for CITY
1243: l_prim_temp := null;
1244: l_prim_temp_den := null;

Line 1245: HZ_DQM_SEARCH_UTIL.add_transformation( -- CLEANSE

1241:
1242: -- Setup query string for CITY
1243: l_prim_temp := null;
1244: l_prim_temp_den := null;
1245: HZ_DQM_SEARCH_UTIL.add_transformation( -- CLEANSE
1246: g_party_site_stage_list(I).TX10,'A29',l_prim_temp);
1247: HZ_DQM_SEARCH_UTIL.add_transformation( -- CLEANSE
1248: g_party_site_stage_list(I).TX10,'D_PS',l_prim_temp_den);
1249: HZ_DQM_SEARCH_UTIL.add_attribute(l_prim_temp_den, ' AND ', l_den_contains_str_temp);

Line 1247: HZ_DQM_SEARCH_UTIL.add_transformation( -- CLEANSE

1243: l_prim_temp := null;
1244: l_prim_temp_den := null;
1245: HZ_DQM_SEARCH_UTIL.add_transformation( -- CLEANSE
1246: g_party_site_stage_list(I).TX10,'A29',l_prim_temp);
1247: HZ_DQM_SEARCH_UTIL.add_transformation( -- CLEANSE
1248: g_party_site_stage_list(I).TX10,'D_PS',l_prim_temp_den);
1249: HZ_DQM_SEARCH_UTIL.add_attribute(l_prim_temp_den, ' AND ', l_den_contains_str_temp);
1250: HZ_DQM_SEARCH_UTIL.add_attribute(l_prim_temp, ' AND ', l_contains_str_temp);
1251:

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

1245: HZ_DQM_SEARCH_UTIL.add_transformation( -- CLEANSE
1246: g_party_site_stage_list(I).TX10,'A29',l_prim_temp);
1247: HZ_DQM_SEARCH_UTIL.add_transformation( -- CLEANSE
1248: g_party_site_stage_list(I).TX10,'D_PS',l_prim_temp_den);
1249: HZ_DQM_SEARCH_UTIL.add_attribute(l_prim_temp_den, ' AND ', l_den_contains_str_temp);
1250: HZ_DQM_SEARCH_UTIL.add_attribute(l_prim_temp, ' AND ', l_contains_str_temp);
1251:
1252: -- Setup query string for STATE
1253: l_prim_temp := null;

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

1246: g_party_site_stage_list(I).TX10,'A29',l_prim_temp);
1247: HZ_DQM_SEARCH_UTIL.add_transformation( -- CLEANSE
1248: g_party_site_stage_list(I).TX10,'D_PS',l_prim_temp_den);
1249: HZ_DQM_SEARCH_UTIL.add_attribute(l_prim_temp_den, ' AND ', l_den_contains_str_temp);
1250: HZ_DQM_SEARCH_UTIL.add_attribute(l_prim_temp, ' AND ', l_contains_str_temp);
1251:
1252: -- Setup query string for STATE
1253: l_prim_temp := null;
1254: l_prim_temp_den := null;

Line 1255: HZ_DQM_SEARCH_UTIL.add_transformation( -- EXACT + WRSTATE

1251:
1252: -- Setup query string for STATE
1253: l_prim_temp := null;
1254: l_prim_temp_den := null;
1255: HZ_DQM_SEARCH_UTIL.add_transformation( -- EXACT + WRSTATE
1256: g_party_site_stage_list(I).TX14,'A32',l_prim_temp);
1257: HZ_DQM_SEARCH_UTIL.add_transformation( -- EXACT + WRSTATE
1258: g_party_site_stage_list(I).TX14,'D_PS',l_prim_temp_den);
1259: HZ_DQM_SEARCH_UTIL.add_attribute(l_prim_temp_den, ' AND ', l_den_contains_str_temp);

Line 1257: HZ_DQM_SEARCH_UTIL.add_transformation( -- EXACT + WRSTATE

1253: l_prim_temp := null;
1254: l_prim_temp_den := null;
1255: HZ_DQM_SEARCH_UTIL.add_transformation( -- EXACT + WRSTATE
1256: g_party_site_stage_list(I).TX14,'A32',l_prim_temp);
1257: HZ_DQM_SEARCH_UTIL.add_transformation( -- EXACT + WRSTATE
1258: g_party_site_stage_list(I).TX14,'D_PS',l_prim_temp_den);
1259: HZ_DQM_SEARCH_UTIL.add_attribute(l_prim_temp_den, ' AND ', l_den_contains_str_temp);
1260: HZ_DQM_SEARCH_UTIL.add_attribute(l_prim_temp, ' AND ', l_contains_str_temp);
1261:

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

1255: HZ_DQM_SEARCH_UTIL.add_transformation( -- EXACT + WRSTATE
1256: g_party_site_stage_list(I).TX14,'A32',l_prim_temp);
1257: HZ_DQM_SEARCH_UTIL.add_transformation( -- EXACT + WRSTATE
1258: g_party_site_stage_list(I).TX14,'D_PS',l_prim_temp_den);
1259: HZ_DQM_SEARCH_UTIL.add_attribute(l_prim_temp_den, ' AND ', l_den_contains_str_temp);
1260: HZ_DQM_SEARCH_UTIL.add_attribute(l_prim_temp, ' AND ', l_contains_str_temp);
1261:
1262: -- Setup query string for COUNTRY
1263: l_prim_temp := null;

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

1256: g_party_site_stage_list(I).TX14,'A32',l_prim_temp);
1257: HZ_DQM_SEARCH_UTIL.add_transformation( -- EXACT + WRSTATE
1258: g_party_site_stage_list(I).TX14,'D_PS',l_prim_temp_den);
1259: HZ_DQM_SEARCH_UTIL.add_attribute(l_prim_temp_den, ' AND ', l_den_contains_str_temp);
1260: HZ_DQM_SEARCH_UTIL.add_attribute(l_prim_temp, ' AND ', l_contains_str_temp);
1261:
1262: -- Setup query string for COUNTRY
1263: l_prim_temp := null;
1264: l_prim_temp_den := null;

Line 1265: HZ_DQM_SEARCH_UTIL.add_transformation( -- EXACT

1261:
1262: -- Setup query string for COUNTRY
1263: l_prim_temp := null;
1264: l_prim_temp_den := null;
1265: HZ_DQM_SEARCH_UTIL.add_transformation( -- EXACT
1266: g_party_site_stage_list(I).TX22,'A36',l_prim_temp);
1267: HZ_DQM_SEARCH_UTIL.add_transformation( -- EXACT
1268: g_party_site_stage_list(I).TX22,'D_PS',l_prim_temp_den);
1269: HZ_DQM_SEARCH_UTIL.add_attribute(l_prim_temp_den, ' AND ', l_den_contains_str_temp);

Line 1267: HZ_DQM_SEARCH_UTIL.add_transformation( -- EXACT

1263: l_prim_temp := null;
1264: l_prim_temp_den := null;
1265: HZ_DQM_SEARCH_UTIL.add_transformation( -- EXACT
1266: g_party_site_stage_list(I).TX22,'A36',l_prim_temp);
1267: HZ_DQM_SEARCH_UTIL.add_transformation( -- EXACT
1268: g_party_site_stage_list(I).TX22,'D_PS',l_prim_temp_den);
1269: HZ_DQM_SEARCH_UTIL.add_attribute(l_prim_temp_den, ' AND ', l_den_contains_str_temp);
1270: HZ_DQM_SEARCH_UTIL.add_attribute(l_prim_temp, ' AND ', l_contains_str_temp);
1271:

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

1265: HZ_DQM_SEARCH_UTIL.add_transformation( -- EXACT
1266: g_party_site_stage_list(I).TX22,'A36',l_prim_temp);
1267: HZ_DQM_SEARCH_UTIL.add_transformation( -- EXACT
1268: g_party_site_stage_list(I).TX22,'D_PS',l_prim_temp_den);
1269: HZ_DQM_SEARCH_UTIL.add_attribute(l_prim_temp_den, ' AND ', l_den_contains_str_temp);
1270: HZ_DQM_SEARCH_UTIL.add_attribute(l_prim_temp, ' AND ', l_contains_str_temp);
1271:
1272: HZ_DQM_SEARCH_UTIL.add_search_record(l_contains_str_temp, l_filter_str, l_contains_str);
1273: HZ_DQM_SEARCH_UTIL.add_search_record(l_den_contains_str_temp, null, l_den_contains_str);

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

1266: g_party_site_stage_list(I).TX22,'A36',l_prim_temp);
1267: HZ_DQM_SEARCH_UTIL.add_transformation( -- EXACT
1268: g_party_site_stage_list(I).TX22,'D_PS',l_prim_temp_den);
1269: HZ_DQM_SEARCH_UTIL.add_attribute(l_prim_temp_den, ' AND ', l_den_contains_str_temp);
1270: HZ_DQM_SEARCH_UTIL.add_attribute(l_prim_temp, ' AND ', l_contains_str_temp);
1271:
1272: HZ_DQM_SEARCH_UTIL.add_search_record(l_contains_str_temp, l_filter_str, l_contains_str);
1273: HZ_DQM_SEARCH_UTIL.add_search_record(l_den_contains_str_temp, null, l_den_contains_str);
1274: END LOOP;

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

1268: g_party_site_stage_list(I).TX22,'D_PS',l_prim_temp_den);
1269: HZ_DQM_SEARCH_UTIL.add_attribute(l_prim_temp_den, ' AND ', l_den_contains_str_temp);
1270: HZ_DQM_SEARCH_UTIL.add_attribute(l_prim_temp, ' AND ', l_contains_str_temp);
1271:
1272: HZ_DQM_SEARCH_UTIL.add_search_record(l_contains_str_temp, l_filter_str, l_contains_str);
1273: HZ_DQM_SEARCH_UTIL.add_search_record(l_den_contains_str_temp, null, l_den_contains_str);
1274: END LOOP;
1275: -- Add the search criteria to query string
1276: IF lengthb(l_contains_str) > 4000 THEN

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

1269: HZ_DQM_SEARCH_UTIL.add_attribute(l_prim_temp_den, ' AND ', l_den_contains_str_temp);
1270: HZ_DQM_SEARCH_UTIL.add_attribute(l_prim_temp, ' AND ', l_contains_str_temp);
1271:
1272: HZ_DQM_SEARCH_UTIL.add_search_record(l_contains_str_temp, l_filter_str, l_contains_str);
1273: HZ_DQM_SEARCH_UTIL.add_search_record(l_den_contains_str_temp, null, l_den_contains_str);
1274: END LOOP;
1275: -- Add the search criteria to query string
1276: IF lengthb(l_contains_str) > 4000 THEN
1277: FND_MESSAGE.SET_NAME('AR', 'HZ_SEARCH_CRIT_LARGE_ERROR');

Line 2447: HZ_DQM_SEARCH_UTIL.set_num_eval(0);

2443: H_PARTY_ID.DELETE;
2444: H_PARTY_ID_LIST.DELETE;
2445: H_SCORES.DELETE;
2446: g_mappings.DELETE;
2447: HZ_DQM_SEARCH_UTIL.set_num_eval(0);
2448: call_order(5) := call_order(1);
2449: call_type(5) := 'AND';
2450: call_max_score(5) := call_max_score(1);
2451: call_type(2) := 'OR';

Line 3276: HZ_DQM_SEARCH_UTIL.set_num_eval(l_num_eval);

3272: ELSE
3273: l_party_id:=H_PARTY_ID_LIST.NEXT(l_party_id);
3274: END IF;
3275: END LOOP;
3276: HZ_DQM_SEARCH_UTIL.set_num_eval(l_num_eval);
3277: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
3278: 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);
3279: END IF;
3280: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN

Line 3438: HZ_DQM_SEARCH_UTIL.set_num_eval(0);

3434: H_PARTY_ID.DELETE;
3435: H_PARTY_ID_LIST.DELETE;
3436: H_SCORES.DELETE;
3437: g_mappings.DELETE;
3438: HZ_DQM_SEARCH_UTIL.set_num_eval(0);
3439: call_order(5) := call_order(1);
3440: call_type(5) := 'AND';
3441: call_max_score(5) := call_max_score(1);
3442: call_type(2) := 'OR';

Line 4138: HZ_DQM_SEARCH_UTIL.set_num_eval(l_num_eval);

4134: ELSE
4135: l_party_id:=H_PARTY_ID_LIST.NEXT(l_party_id);
4136: END IF;
4137: END LOOP;
4138: HZ_DQM_SEARCH_UTIL.set_num_eval(l_num_eval);
4139: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
4140: 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);
4141: END IF;
4142: EXCEPTION