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 FND_PROFILE

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

2484: and check_estimate_hits('PARTY',p_party_contains_str)>l_max_thresh THEN
2485: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
2486: 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);
2487: END IF;
2488: 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
2489: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
2490: 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);
2491: END IF;
2492: IF (l_party_site_contains_str IS NULL AND

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

2540: END IF;
2541: IF (l_party_id_idx-1)>l_max_thresh THEN
2542: IF p_index=1 AND call_order(2) = 'PARTY_SITE'
2543: AND call_type(2) = 'AND' AND l_contact_contains_str IS NULL
2544: AND nvl(FND_PROFILE.VALUE('HZ_DQM_PN_THRESH_RESOLUTION'),'NONE')='SQL'
2545: AND l_contact_pt_contains_str IS NULL THEN
2546: EXIT;
2547: END IF;
2548: CLOSE l_party_cur;

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

3142:
3143: --End fix for bug 4417124
3144:
3145: IF p_dup_batch_id IS NOT NULL THEN
3146: l_max_thresh:=nvl(FND_PROFILE.VALUE('HZ_DQM_MAX_EVAL_THRESH_BATCH'),10000);
3147: ELSE
3148: l_max_thresh:=nvl(FND_PROFILE.VALUE('HZ_DQM_MAX_EVAL_THRESH'),200);
3149: END IF;
3150: IF nvl(FND_PROFILE.VALUE('HZ_DQM_SCORE_UNTIL_THRESH'),'N')='Y' THEN

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

3144:
3145: IF p_dup_batch_id IS NOT NULL THEN
3146: l_max_thresh:=nvl(FND_PROFILE.VALUE('HZ_DQM_MAX_EVAL_THRESH_BATCH'),10000);
3147: ELSE
3148: l_max_thresh:=nvl(FND_PROFILE.VALUE('HZ_DQM_MAX_EVAL_THRESH'),200);
3149: END IF;
3150: IF nvl(FND_PROFILE.VALUE('HZ_DQM_SCORE_UNTIL_THRESH'),'N')='Y' THEN
3151: g_score_until_thresh := true;
3152: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN

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

3146: l_max_thresh:=nvl(FND_PROFILE.VALUE('HZ_DQM_MAX_EVAL_THRESH_BATCH'),10000);
3147: ELSE
3148: l_max_thresh:=nvl(FND_PROFILE.VALUE('HZ_DQM_MAX_EVAL_THRESH'),200);
3149: END IF;
3150: IF nvl(FND_PROFILE.VALUE('HZ_DQM_SCORE_UNTIL_THRESH'),'N')='Y' THEN
3151: g_score_until_thresh := true;
3152: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
3153: 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);
3154: END IF;

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

3464: and check_estimate_hits('PARTY',p_party_contains_str)>l_max_thresh THEN
3465: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
3466: 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);
3467: END IF;
3468: IF g_party_stage_rec.TX8 IS NOT NULL AND nvl(FND_PROFILE.VALUE('HZ_DQM_PN_THRESH_RESOLUTION'),'NONE')='SQL' THEN
3469: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
3470: 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);
3471: END IF;
3472: IF (l_party_site_contains_str IS NULL AND

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

3517: END IF;
3518: IF (l_party_id_idx-1)>l_max_thresh THEN
3519: IF p_index=1 AND call_order(2) = 'PARTY_SITE'
3520: AND call_type(2) = 'AND' AND l_contact_contains_str IS NULL
3521: AND nvl(FND_PROFILE.VALUE('HZ_DQM_PN_THRESH_RESOLUTION'),'NONE')='SQL'
3522: AND l_contact_pt_contains_str IS NULL THEN
3523: H_PARTY_ID.DELETE(l_party_id_idx-1);
3524: H_PARTY_ID_LIST.DELETE(l_index);
3525: H_SCORES.DELETE(l_index);

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

4058: END IF;
4059: 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);
4060: IF l_entered_max_score = 0 THEN l_entered_max_score:=1; END IF;
4061:
4062: l_max_thresh:=nvl(FND_PROFILE.VALUE('HZ_DQM_MAX_EVAL_THRESH'),200);
4063: IF nvl(FND_PROFILE.VALUE('HZ_DQM_SCORE_UNTIL_THRESH'),'N')='Y' THEN
4064: g_score_until_thresh := true;
4065: ELSE
4066: g_score_until_thresh := false;

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

4059: 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);
4060: IF l_entered_max_score = 0 THEN l_entered_max_score:=1; END IF;
4061:
4062: l_max_thresh:=nvl(FND_PROFILE.VALUE('HZ_DQM_MAX_EVAL_THRESH'),200);
4063: IF nvl(FND_PROFILE.VALUE('HZ_DQM_SCORE_UNTIL_THRESH'),'N')='Y' THEN
4064: g_score_until_thresh := true;
4065: ELSE
4066: g_score_until_thresh := false;
4067: END IF;

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

5713: l_use_contact_info varchar2(1);
5714: BEGIN
5715:
5716: l_use_contact_info := 'Y';
5717: IF nvl(FND_PROFILE.VALUE('HZ_DQM_REL_PARTY_MATCH'),'N')='Y' THEN
5718: l_use_contact_info := 'N';
5719: END IF;
5720: l_party_id := p_party_id;
5721: FOR PARTY_SITES IN (