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

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

2300: and check_estimate_hits('PARTY',p_party_contains_str)>l_max_thresh THEN
2301: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
2302: 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);
2303: END IF;
2304: 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
2305: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
2306: 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);
2307: END IF;
2308: IF (l_party_site_contains_str IS NULL AND

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

2356: END IF;
2357: IF (l_party_id_idx-1)>l_max_thresh THEN
2358: IF p_index=1 AND call_order(2) = 'PARTY_SITE'
2359: AND call_type(2) = 'AND' AND l_contact_contains_str IS NULL
2360: AND nvl(FND_PROFILE.VALUE('HZ_DQM_PN_THRESH_RESOLUTION'),'NONE')='SQL'
2361: AND l_contact_pt_contains_str IS NULL THEN
2362: EXIT;
2363: END IF;
2364: CLOSE l_party_cur;

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

2888:
2889: --End fix for bug 4417124
2890:
2891: IF p_dup_batch_id IS NOT NULL THEN
2892: l_max_thresh:=nvl(FND_PROFILE.VALUE('HZ_DQM_MAX_EVAL_THRESH_BATCH'),10000);
2893: ELSE
2894: l_max_thresh:=nvl(FND_PROFILE.VALUE('HZ_DQM_MAX_EVAL_THRESH'),200);
2895: END IF;
2896: IF nvl(FND_PROFILE.VALUE('HZ_DQM_SCORE_UNTIL_THRESH'),'N')='Y' THEN

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

2890:
2891: IF p_dup_batch_id IS NOT NULL THEN
2892: l_max_thresh:=nvl(FND_PROFILE.VALUE('HZ_DQM_MAX_EVAL_THRESH_BATCH'),10000);
2893: ELSE
2894: l_max_thresh:=nvl(FND_PROFILE.VALUE('HZ_DQM_MAX_EVAL_THRESH'),200);
2895: END IF;
2896: IF nvl(FND_PROFILE.VALUE('HZ_DQM_SCORE_UNTIL_THRESH'),'N')='Y' THEN
2897: g_score_until_thresh := true;
2898: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN

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

2892: l_max_thresh:=nvl(FND_PROFILE.VALUE('HZ_DQM_MAX_EVAL_THRESH_BATCH'),10000);
2893: ELSE
2894: l_max_thresh:=nvl(FND_PROFILE.VALUE('HZ_DQM_MAX_EVAL_THRESH'),200);
2895: END IF;
2896: IF nvl(FND_PROFILE.VALUE('HZ_DQM_SCORE_UNTIL_THRESH'),'N')='Y' THEN
2897: g_score_until_thresh := true;
2898: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
2899: 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);
2900: END IF;

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

3239: and check_estimate_hits('PARTY',p_party_contains_str)>l_max_thresh THEN
3240: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
3241: 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);
3242: END IF;
3243: IF g_party_stage_rec.TX8 IS NOT NULL AND nvl(FND_PROFILE.VALUE('HZ_DQM_PN_THRESH_RESOLUTION'),'NONE')='SQL' THEN
3244: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
3245: 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);
3246: END IF;
3247: IF (l_party_site_contains_str IS NULL AND

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

3292: END IF;
3293: IF (l_party_id_idx-1)>l_max_thresh THEN
3294: IF p_index=1 AND call_order(2) = 'PARTY_SITE'
3295: AND call_type(2) = 'AND' AND l_contact_contains_str IS NULL
3296: AND nvl(FND_PROFILE.VALUE('HZ_DQM_PN_THRESH_RESOLUTION'),'NONE')='SQL'
3297: AND l_contact_pt_contains_str IS NULL THEN
3298: H_PARTY_ID.DELETE(l_party_id_idx-1);
3299: H_PARTY_ID_LIST.DELETE(l_index);
3300: H_SCORES.DELETE(l_index);

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

3738: END IF;
3739: 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);
3740: IF l_entered_max_score = 0 THEN l_entered_max_score:=1; END IF;
3741:
3742: l_max_thresh:=nvl(FND_PROFILE.VALUE('HZ_DQM_MAX_EVAL_THRESH'),200);
3743: IF nvl(FND_PROFILE.VALUE('HZ_DQM_SCORE_UNTIL_THRESH'),'N')='Y' THEN
3744: g_score_until_thresh := true;
3745: ELSE
3746: g_score_until_thresh := false;

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

3739: 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);
3740: IF l_entered_max_score = 0 THEN l_entered_max_score:=1; END IF;
3741:
3742: l_max_thresh:=nvl(FND_PROFILE.VALUE('HZ_DQM_MAX_EVAL_THRESH'),200);
3743: IF nvl(FND_PROFILE.VALUE('HZ_DQM_SCORE_UNTIL_THRESH'),'N')='Y' THEN
3744: g_score_until_thresh := true;
3745: ELSE
3746: g_score_until_thresh := false;
3747: END IF;

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

5439: l_use_contact_info varchar2(1);
5440: BEGIN
5441:
5442: l_use_contact_info := 'Y';
5443: IF nvl(FND_PROFILE.VALUE('HZ_DQM_REL_PARTY_MATCH'),'N')='Y' THEN
5444: l_use_contact_info := 'N';
5445: END IF;
5446: l_party_id := p_party_id;
5447: FOR PARTY_SITES IN (