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

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

2141: and check_estimate_hits('PARTY',p_party_contains_str)>l_max_thresh THEN
2142: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
2143: 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);
2144: END IF;
2145: 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
2146: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
2147: 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);
2148: END IF;
2149: IF (l_party_site_contains_str IS NULL AND

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

2197: END IF;
2198: IF (l_party_id_idx-1)>l_max_thresh THEN
2199: IF p_index=1 AND call_order(2) = 'PARTY_SITE'
2200: AND call_type(2) = 'AND' AND l_contact_contains_str IS NULL
2201: AND nvl(FND_PROFILE.VALUE('HZ_DQM_PN_THRESH_RESOLUTION'),'NONE')='SQL'
2202: AND l_contact_pt_contains_str IS NULL THEN
2203: EXIT;
2204: END IF;
2205: CLOSE l_party_cur;

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

2799:
2800: --End fix for bug 4417124
2801:
2802: IF p_dup_batch_id IS NOT NULL THEN
2803: l_max_thresh:=nvl(FND_PROFILE.VALUE('HZ_DQM_MAX_EVAL_THRESH_BATCH'),10000);
2804: ELSE
2805: l_max_thresh:=nvl(FND_PROFILE.VALUE('HZ_DQM_MAX_EVAL_THRESH'),200);
2806: END IF;
2807: IF nvl(FND_PROFILE.VALUE('HZ_DQM_SCORE_UNTIL_THRESH'),'N')='Y' THEN

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

2801:
2802: IF p_dup_batch_id IS NOT NULL THEN
2803: l_max_thresh:=nvl(FND_PROFILE.VALUE('HZ_DQM_MAX_EVAL_THRESH_BATCH'),10000);
2804: ELSE
2805: l_max_thresh:=nvl(FND_PROFILE.VALUE('HZ_DQM_MAX_EVAL_THRESH'),200);
2806: END IF;
2807: IF nvl(FND_PROFILE.VALUE('HZ_DQM_SCORE_UNTIL_THRESH'),'N')='Y' THEN
2808: g_score_until_thresh := true;
2809: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN

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

2803: l_max_thresh:=nvl(FND_PROFILE.VALUE('HZ_DQM_MAX_EVAL_THRESH_BATCH'),10000);
2804: ELSE
2805: l_max_thresh:=nvl(FND_PROFILE.VALUE('HZ_DQM_MAX_EVAL_THRESH'),200);
2806: END IF;
2807: IF nvl(FND_PROFILE.VALUE('HZ_DQM_SCORE_UNTIL_THRESH'),'N')='Y' THEN
2808: g_score_until_thresh := true;
2809: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
2810: 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);
2811: END IF;

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

3116: and check_estimate_hits('PARTY',p_party_contains_str)>l_max_thresh THEN
3117: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
3118: 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);
3119: END IF;
3120: IF g_party_stage_rec.TX8 IS NOT NULL AND nvl(FND_PROFILE.VALUE('HZ_DQM_PN_THRESH_RESOLUTION'),'NONE')='SQL' THEN
3121: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
3122: 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);
3123: END IF;
3124: IF (l_party_site_contains_str IS NULL AND

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

3169: END IF;
3170: IF (l_party_id_idx-1)>l_max_thresh THEN
3171: IF p_index=1 AND call_order(2) = 'PARTY_SITE'
3172: AND call_type(2) = 'AND' AND l_contact_contains_str IS NULL
3173: AND nvl(FND_PROFILE.VALUE('HZ_DQM_PN_THRESH_RESOLUTION'),'NONE')='SQL'
3174: AND l_contact_pt_contains_str IS NULL THEN
3175: H_PARTY_ID.DELETE(l_party_id_idx-1);
3176: H_PARTY_ID_LIST.DELETE(l_index);
3177: H_SCORES.DELETE(l_index);

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

3710: END IF;
3711: 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);
3712: IF l_entered_max_score = 0 THEN l_entered_max_score:=1; END IF;
3713:
3714: l_max_thresh:=nvl(FND_PROFILE.VALUE('HZ_DQM_MAX_EVAL_THRESH'),200);
3715: IF nvl(FND_PROFILE.VALUE('HZ_DQM_SCORE_UNTIL_THRESH'),'N')='Y' THEN
3716: g_score_until_thresh := true;
3717: ELSE
3718: g_score_until_thresh := false;

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

3711: 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);
3712: IF l_entered_max_score = 0 THEN l_entered_max_score:=1; END IF;
3713:
3714: l_max_thresh:=nvl(FND_PROFILE.VALUE('HZ_DQM_MAX_EVAL_THRESH'),200);
3715: IF nvl(FND_PROFILE.VALUE('HZ_DQM_SCORE_UNTIL_THRESH'),'N')='Y' THEN
3716: g_score_until_thresh := true;
3717: ELSE
3718: g_score_until_thresh := false;
3719: END IF;

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

5332: l_use_contact_info varchar2(1);
5333: BEGIN
5334:
5335: l_use_contact_info := 'Y';
5336: IF nvl(FND_PROFILE.VALUE('HZ_DQM_REL_PARTY_MATCH'),'N')='Y' THEN
5337: l_use_contact_info := 'N';
5338: END IF;
5339: l_party_id := p_party_id;
5340: FOR PARTY_SITES IN (