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.

[Home] [Help]

APPS.HZ_MATCH_RULE_4 dependencies on FND_PROFILE

Line 2160: 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

2156: and check_estimate_hits('PARTY',p_party_contains_str)>l_max_thresh THEN
2157: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
2158: 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);
2159: END IF;
2160: 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
2161: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
2162: 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);
2163: END IF;
2164: IF (l_party_site_contains_str IS NULL AND

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

2212: END IF;
2213: IF (l_party_id_idx-1)>l_max_thresh THEN
2214: IF p_index=1 AND call_order(2) = 'PARTY_SITE'
2215: AND call_type(2) = 'AND' AND l_contact_contains_str IS NULL
2216: AND nvl(FND_PROFILE.VALUE('HZ_DQM_PN_THRESH_RESOLUTION'),'NONE')='SQL'
2217: AND l_contact_pt_contains_str IS NULL THEN
2218: EXIT;
2219: END IF;
2220: CLOSE l_party_cur;

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

2744:
2745: --End fix for bug 4417124
2746:
2747: IF p_dup_batch_id IS NOT NULL THEN
2748: l_max_thresh:=nvl(FND_PROFILE.VALUE('HZ_DQM_MAX_EVAL_THRESH_BATCH'),10000);
2749: ELSE
2750: l_max_thresh:=nvl(FND_PROFILE.VALUE('HZ_DQM_MAX_EVAL_THRESH'),200);
2751: END IF;
2752: IF nvl(FND_PROFILE.VALUE('HZ_DQM_SCORE_UNTIL_THRESH'),'N')='Y' THEN

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

2746:
2747: IF p_dup_batch_id IS NOT NULL THEN
2748: l_max_thresh:=nvl(FND_PROFILE.VALUE('HZ_DQM_MAX_EVAL_THRESH_BATCH'),10000);
2749: ELSE
2750: l_max_thresh:=nvl(FND_PROFILE.VALUE('HZ_DQM_MAX_EVAL_THRESH'),200);
2751: END IF;
2752: IF nvl(FND_PROFILE.VALUE('HZ_DQM_SCORE_UNTIL_THRESH'),'N')='Y' THEN
2753: g_score_until_thresh := true;
2754: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN

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

2748: l_max_thresh:=nvl(FND_PROFILE.VALUE('HZ_DQM_MAX_EVAL_THRESH_BATCH'),10000);
2749: ELSE
2750: l_max_thresh:=nvl(FND_PROFILE.VALUE('HZ_DQM_MAX_EVAL_THRESH'),200);
2751: END IF;
2752: IF nvl(FND_PROFILE.VALUE('HZ_DQM_SCORE_UNTIL_THRESH'),'N')='Y' THEN
2753: g_score_until_thresh := true;
2754: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
2755: 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);
2756: END IF;

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

3093: and check_estimate_hits('PARTY',p_party_contains_str)>l_max_thresh THEN
3094: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
3095: 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);
3096: END IF;
3097: IF g_party_stage_rec.TX8 IS NOT NULL AND nvl(FND_PROFILE.VALUE('HZ_DQM_PN_THRESH_RESOLUTION'),'NONE')='SQL' THEN
3098: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
3099: 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);
3100: END IF;
3101: IF (l_party_site_contains_str IS NULL AND

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

3146: END IF;
3147: IF (l_party_id_idx-1)>l_max_thresh THEN
3148: IF p_index=1 AND call_order(2) = 'PARTY_SITE'
3149: AND call_type(2) = 'AND' AND l_contact_contains_str IS NULL
3150: AND nvl(FND_PROFILE.VALUE('HZ_DQM_PN_THRESH_RESOLUTION'),'NONE')='SQL'
3151: AND l_contact_pt_contains_str IS NULL THEN
3152: H_PARTY_ID.DELETE(l_party_id_idx-1);
3153: H_PARTY_ID_LIST.DELETE(l_index);
3154: H_SCORES.DELETE(l_index);

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

3592: END IF;
3593: 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);
3594: IF l_entered_max_score = 0 THEN l_entered_max_score:=1; END IF;
3595:
3596: l_max_thresh:=nvl(FND_PROFILE.VALUE('HZ_DQM_MAX_EVAL_THRESH'),200);
3597: IF nvl(FND_PROFILE.VALUE('HZ_DQM_SCORE_UNTIL_THRESH'),'N')='Y' THEN
3598: g_score_until_thresh := true;
3599: ELSE
3600: g_score_until_thresh := false;

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

3593: 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);
3594: IF l_entered_max_score = 0 THEN l_entered_max_score:=1; END IF;
3595:
3596: l_max_thresh:=nvl(FND_PROFILE.VALUE('HZ_DQM_MAX_EVAL_THRESH'),200);
3597: IF nvl(FND_PROFILE.VALUE('HZ_DQM_SCORE_UNTIL_THRESH'),'N')='Y' THEN
3598: g_score_until_thresh := true;
3599: ELSE
3600: g_score_until_thresh := false;
3601: END IF;

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

5240: l_use_contact_info varchar2(1);
5241: BEGIN
5242:
5243: l_use_contact_info := 'Y';
5244: IF nvl(FND_PROFILE.VALUE('HZ_DQM_REL_PARTY_MATCH'),'N')='Y' THEN
5245: l_use_contact_info := 'N';
5246: END IF;
5247: l_party_id := p_party_id;
5248: FOR PARTY_SITES IN (