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

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

3389: and check_estimate_hits('PARTY',p_party_contains_str)>l_max_thresh THEN
3390: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
3391: 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);
3392: END IF;
3393: 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
3394: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
3395: 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);
3396: END IF;
3397: IF (l_party_site_contains_str IS NULL AND

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

3445: END IF;
3446: IF (l_party_id_idx-1)>l_max_thresh THEN
3447: IF p_index=1 AND call_order(2) = 'PARTY_SITE'
3448: AND call_type(2) = 'AND' AND l_contact_contains_str IS NULL
3449: AND nvl(FND_PROFILE.VALUE('HZ_DQM_PN_THRESH_RESOLUTION'),'NONE')='SQL'
3450: AND l_contact_pt_contains_str IS NULL THEN
3451: EXIT;
3452: END IF;
3453: CLOSE l_party_cur;

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

4047:
4048: --End fix for bug 4417124
4049:
4050: IF p_dup_batch_id IS NOT NULL THEN
4051: l_max_thresh:=nvl(FND_PROFILE.VALUE('HZ_DQM_MAX_EVAL_THRESH_BATCH'),10000);
4052: ELSE
4053: l_max_thresh:=nvl(FND_PROFILE.VALUE('HZ_DQM_MAX_EVAL_THRESH'),200);
4054: END IF;
4055: IF nvl(FND_PROFILE.VALUE('HZ_DQM_SCORE_UNTIL_THRESH'),'N')='Y' THEN

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

4049:
4050: IF p_dup_batch_id IS NOT NULL THEN
4051: l_max_thresh:=nvl(FND_PROFILE.VALUE('HZ_DQM_MAX_EVAL_THRESH_BATCH'),10000);
4052: ELSE
4053: l_max_thresh:=nvl(FND_PROFILE.VALUE('HZ_DQM_MAX_EVAL_THRESH'),200);
4054: END IF;
4055: IF nvl(FND_PROFILE.VALUE('HZ_DQM_SCORE_UNTIL_THRESH'),'N')='Y' THEN
4056: g_score_until_thresh := true;
4057: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN

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

4051: l_max_thresh:=nvl(FND_PROFILE.VALUE('HZ_DQM_MAX_EVAL_THRESH_BATCH'),10000);
4052: ELSE
4053: l_max_thresh:=nvl(FND_PROFILE.VALUE('HZ_DQM_MAX_EVAL_THRESH'),200);
4054: END IF;
4055: IF nvl(FND_PROFILE.VALUE('HZ_DQM_SCORE_UNTIL_THRESH'),'N')='Y' THEN
4056: g_score_until_thresh := true;
4057: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
4058: 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);
4059: END IF;

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

4383: and check_estimate_hits('PARTY',p_party_contains_str)>l_max_thresh THEN
4384: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
4385: 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);
4386: END IF;
4387: IF g_party_stage_rec.TX8 IS NOT NULL AND nvl(FND_PROFILE.VALUE('HZ_DQM_PN_THRESH_RESOLUTION'),'NONE')='SQL' THEN
4388: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
4389: 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);
4390: END IF;
4391: IF (l_party_site_contains_str IS NULL AND

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

4436: END IF;
4437: IF (l_party_id_idx-1)>l_max_thresh THEN
4438: IF p_index=1 AND call_order(2) = 'PARTY_SITE'
4439: AND call_type(2) = 'AND' AND l_contact_contains_str IS NULL
4440: AND nvl(FND_PROFILE.VALUE('HZ_DQM_PN_THRESH_RESOLUTION'),'NONE')='SQL'
4441: AND l_contact_pt_contains_str IS NULL THEN
4442: H_PARTY_ID.DELETE(l_party_id_idx-1);
4443: H_PARTY_ID_LIST.DELETE(l_index);
4444: H_SCORES.DELETE(l_index);

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

4977: END IF;
4978: 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);
4979: IF l_entered_max_score = 0 THEN l_entered_max_score:=1; END IF;
4980:
4981: l_max_thresh:=nvl(FND_PROFILE.VALUE('HZ_DQM_MAX_EVAL_THRESH'),200);
4982: IF nvl(FND_PROFILE.VALUE('HZ_DQM_SCORE_UNTIL_THRESH'),'N')='Y' THEN
4983: g_score_until_thresh := true;
4984: ELSE
4985: g_score_until_thresh := false;

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

4978: 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);
4979: IF l_entered_max_score = 0 THEN l_entered_max_score:=1; END IF;
4980:
4981: l_max_thresh:=nvl(FND_PROFILE.VALUE('HZ_DQM_MAX_EVAL_THRESH'),200);
4982: IF nvl(FND_PROFILE.VALUE('HZ_DQM_SCORE_UNTIL_THRESH'),'N')='Y' THEN
4983: g_score_until_thresh := true;
4984: ELSE
4985: g_score_until_thresh := false;
4986: END IF;

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

6820: l_use_contact_info varchar2(1);
6821: BEGIN
6822:
6823: l_use_contact_info := 'Y';
6824: IF nvl(FND_PROFILE.VALUE('HZ_DQM_REL_PARTY_MATCH'),'N')='Y' THEN
6825: l_use_contact_info := 'N';
6826: END IF;
6827: l_party_id := p_party_id;
6828: FOR PARTY_SITES IN (