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 2491: 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

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

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

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

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

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

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

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

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

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

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

3468: and check_estimate_hits('PARTY',p_party_contains_str)>l_max_thresh 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 estimated hits exceed threshold',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 g_party_stage_rec.TX8 IS NOT NULL AND nvl(FND_PROFILE.VALUE('HZ_DQM_PN_THRESH_RESOLUTION'),'NONE')='SQL' THEN
3473: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
3474: 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);
3475: END IF;
3476: IF (l_party_site_contains_str IS NULL AND

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

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

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

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

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

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

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

5718: l_use_contact_info varchar2(1);
5719: BEGIN
5720:
5721: l_use_contact_info := 'Y';
5722: IF nvl(FND_PROFILE.VALUE('HZ_DQM_REL_PARTY_MATCH'),'N')='Y' THEN
5723: l_use_contact_info := 'N';
5724: END IF;
5725: l_party_id := p_party_id;
5726: FOR PARTY_SITES IN (