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_240 dependencies on FND_PROFILE

Line 2203: IF g_party_stage_rec.TX8 IS NOT NULL AND nvl(FND_PROFILE.VALUE('HZ_DQM_PN_THRESH_RESOLUTION'),'NONE')='SQL' AND p_dup_batch_id IS NULL THEN

2199: and check_estimate_hits('PARTY',p_party_contains_str)>l_max_thresh THEN
2200: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
2201: hz_utility_v2pub.debug(p_message=>'In eval party level estimated hits exceed threshold',p_module_prefix=>'dqm',p_module=>'hz_match_rule_xxx',p_prefix=>NULL,p_msg_level=>fnd_log.level_statement);
2202: END IF;
2203: IF g_party_stage_rec.TX8 IS NOT NULL AND nvl(FND_PROFILE.VALUE('HZ_DQM_PN_THRESH_RESOLUTION'),'NONE')='SQL' AND p_dup_batch_id IS NULL THEN
2204: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
2205: hz_utility_v2pub.debug(p_message=>'In eval party level resolution options is set to SQL search.',p_module_prefix=>'dqm',p_module=>'hz_match_rule_xxx',p_prefix=>NULL,p_msg_level=>fnd_log.level_statement);
2206: END IF;
2207: IF (l_party_site_contains_str IS NULL AND

Line 2259: AND nvl(FND_PROFILE.VALUE('HZ_DQM_PN_THRESH_RESOLUTION'),'NONE')='SQL'

2255: END IF;
2256: IF (l_party_id_idx-1)>l_max_thresh THEN
2257: IF p_index=1 AND call_order(2) = 'PARTY_SITE'
2258: AND call_type(2) = 'AND' AND l_contact_contains_str IS NULL
2259: AND nvl(FND_PROFILE.VALUE('HZ_DQM_PN_THRESH_RESOLUTION'),'NONE')='SQL'
2260: AND l_contact_pt_contains_str IS NULL THEN
2261: EXIT;
2262: END IF;
2263: CLOSE l_party_cur;

Line 2861: l_max_thresh:=nvl(FND_PROFILE.VALUE('HZ_DQM_MAX_EVAL_THRESH_BATCH'),10000);

2857:
2858: --End fix for bug 4417124
2859:
2860: IF p_dup_batch_id IS NOT NULL THEN
2861: l_max_thresh:=nvl(FND_PROFILE.VALUE('HZ_DQM_MAX_EVAL_THRESH_BATCH'),10000);
2862: ELSE
2863: l_max_thresh:=nvl(FND_PROFILE.VALUE('HZ_DQM_MAX_EVAL_THRESH'),200);
2864: END IF;
2865: IF nvl(FND_PROFILE.VALUE('HZ_DQM_SCORE_UNTIL_THRESH'),'N')='Y' THEN

Line 2863: l_max_thresh:=nvl(FND_PROFILE.VALUE('HZ_DQM_MAX_EVAL_THRESH'),200);

2859:
2860: IF p_dup_batch_id IS NOT NULL THEN
2861: l_max_thresh:=nvl(FND_PROFILE.VALUE('HZ_DQM_MAX_EVAL_THRESH_BATCH'),10000);
2862: ELSE
2863: l_max_thresh:=nvl(FND_PROFILE.VALUE('HZ_DQM_MAX_EVAL_THRESH'),200);
2864: END IF;
2865: IF nvl(FND_PROFILE.VALUE('HZ_DQM_SCORE_UNTIL_THRESH'),'N')='Y' THEN
2866: g_score_until_thresh := true;
2867: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN

Line 2865: IF nvl(FND_PROFILE.VALUE('HZ_DQM_SCORE_UNTIL_THRESH'),'N')='Y' THEN

2861: l_max_thresh:=nvl(FND_PROFILE.VALUE('HZ_DQM_MAX_EVAL_THRESH_BATCH'),10000);
2862: ELSE
2863: l_max_thresh:=nvl(FND_PROFILE.VALUE('HZ_DQM_MAX_EVAL_THRESH'),200);
2864: END IF;
2865: IF nvl(FND_PROFILE.VALUE('HZ_DQM_SCORE_UNTIL_THRESH'),'N')='Y' THEN
2866: g_score_until_thresh := true;
2867: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
2868: hz_utility_v2pub.debug(p_message=>'g_score_until_thresh is true',p_module_prefix=>'dqm',p_module=>'hz_match_rule_xxx',p_prefix=>NULL,p_msg_level=>fnd_log.level_statement);
2869: END IF;

Line 3176: IF g_party_stage_rec.TX8 IS NOT NULL AND nvl(FND_PROFILE.VALUE('HZ_DQM_PN_THRESH_RESOLUTION'),'NONE')='SQL' THEN

3172: and check_estimate_hits('PARTY',p_party_contains_str)>l_max_thresh THEN
3173: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
3174: hz_utility_v2pub.debug(p_message=>'In eval party level estimated hits exceed threshold',p_module_prefix=>'dqm',p_module=>'hz_match_rule_xxx',p_prefix=>NULL,p_msg_level=>fnd_log.level_statement);
3175: END IF;
3176: IF g_party_stage_rec.TX8 IS NOT NULL AND nvl(FND_PROFILE.VALUE('HZ_DQM_PN_THRESH_RESOLUTION'),'NONE')='SQL' THEN
3177: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
3178: hz_utility_v2pub.debug(p_message=>'In eval party level resolution option is set to SQL search.',p_module_prefix=>'dqm',p_module=>'hz_match_rule_xxx',p_prefix=>NULL,p_msg_level=>fnd_log.level_statement);
3179: END IF;
3180: IF (l_party_site_contains_str IS NULL AND

Line 3229: AND nvl(FND_PROFILE.VALUE('HZ_DQM_PN_THRESH_RESOLUTION'),'NONE')='SQL'

3225: END IF;
3226: IF (l_party_id_idx-1)>l_max_thresh THEN
3227: IF p_index=1 AND call_order(2) = 'PARTY_SITE'
3228: AND call_type(2) = 'AND' AND l_contact_contains_str IS NULL
3229: AND nvl(FND_PROFILE.VALUE('HZ_DQM_PN_THRESH_RESOLUTION'),'NONE')='SQL'
3230: AND l_contact_pt_contains_str IS NULL THEN
3231: H_PARTY_ID.DELETE(l_party_id_idx-1);
3232: H_PARTY_ID_LIST.DELETE(l_index);
3233: H_SCORES.DELETE(l_index);

Line 3770: l_max_thresh:=nvl(FND_PROFILE.VALUE('HZ_DQM_MAX_EVAL_THRESH'),200);

3766: END IF;
3767: l_entered_max_score:= init_search(p_party_search_rec,p_party_site_list,p_contact_list,p_contact_point_list, l_match_str, l_party_max_score, l_ps_max_score, l_contact_max_score, l_cpt_max_score);
3768: IF l_entered_max_score = 0 THEN l_entered_max_score:=1; END IF;
3769:
3770: l_max_thresh:=nvl(FND_PROFILE.VALUE('HZ_DQM_MAX_EVAL_THRESH'),200);
3771: IF nvl(FND_PROFILE.VALUE('HZ_DQM_SCORE_UNTIL_THRESH'),'N')='Y' THEN
3772: g_score_until_thresh := true;
3773: ELSE
3774: g_score_until_thresh := false;

Line 3771: IF nvl(FND_PROFILE.VALUE('HZ_DQM_SCORE_UNTIL_THRESH'),'N')='Y' THEN

3767: l_entered_max_score:= init_search(p_party_search_rec,p_party_site_list,p_contact_list,p_contact_point_list, l_match_str, l_party_max_score, l_ps_max_score, l_contact_max_score, l_cpt_max_score);
3768: IF l_entered_max_score = 0 THEN l_entered_max_score:=1; END IF;
3769:
3770: l_max_thresh:=nvl(FND_PROFILE.VALUE('HZ_DQM_MAX_EVAL_THRESH'),200);
3771: IF nvl(FND_PROFILE.VALUE('HZ_DQM_SCORE_UNTIL_THRESH'),'N')='Y' THEN
3772: g_score_until_thresh := true;
3773: ELSE
3774: g_score_until_thresh := false;
3775: END IF;

Line 5423: IF nvl(FND_PROFILE.VALUE('HZ_DQM_REL_PARTY_MATCH'),'N')='Y' THEN

5419: l_use_contact_info varchar2(1);
5420: BEGIN
5421:
5422: l_use_contact_info := 'Y';
5423: IF nvl(FND_PROFILE.VALUE('HZ_DQM_REL_PARTY_MATCH'),'N')='Y' THEN
5424: l_use_contact_info := 'N';
5425: END IF;
5426: l_party_id := p_party_id;
5427: FOR PARTY_SITES IN (