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 FND_PROFILE

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

5235: l_use_contact_info varchar2(1);
5236: BEGIN
5237:
5238: l_use_contact_info := 'Y';
5239: IF nvl(FND_PROFILE.VALUE('HZ_DQM_REL_PARTY_MATCH'),'N')='Y' THEN
5240: l_use_contact_info := 'N';
5241: END IF;
5242: l_party_id := p_party_id;
5243: FOR PARTY_SITES IN (