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

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

2622: and check_estimate_hits('PARTY',p_party_contains_str)>l_max_thresh THEN
2623: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
2624: 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);
2625: END IF;
2626: 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
2627: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
2628: 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);
2629: END IF;
2630: IF (l_party_site_contains_str IS NULL AND

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

2680: END IF;
2681: IF (l_party_id_idx-1)>l_max_thresh THEN
2682: IF p_index=1 AND call_order(2) = 'PARTY_SITE'
2683: AND call_type(2) = 'AND' AND l_contact_contains_str IS NULL
2684: AND nvl(FND_PROFILE.VALUE('HZ_DQM_PN_THRESH_RESOLUTION'),'NONE')='SQL'
2685: AND l_contact_pt_contains_str IS NULL THEN
2686: EXIT;
2687: END IF;
2688: CLOSE l_party_cur;

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

3282:
3283: --End fix for bug 4417124
3284:
3285: IF p_dup_batch_id IS NOT NULL THEN
3286: l_max_thresh:=nvl(FND_PROFILE.VALUE('HZ_DQM_MAX_EVAL_THRESH_BATCH'),10000);
3287: ELSE
3288: l_max_thresh:=nvl(FND_PROFILE.VALUE('HZ_DQM_MAX_EVAL_THRESH'),200);
3289: END IF;
3290: IF nvl(FND_PROFILE.VALUE('HZ_DQM_SCORE_UNTIL_THRESH'),'N')='Y' THEN

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

3284:
3285: IF p_dup_batch_id IS NOT NULL THEN
3286: l_max_thresh:=nvl(FND_PROFILE.VALUE('HZ_DQM_MAX_EVAL_THRESH_BATCH'),10000);
3287: ELSE
3288: l_max_thresh:=nvl(FND_PROFILE.VALUE('HZ_DQM_MAX_EVAL_THRESH'),200);
3289: END IF;
3290: IF nvl(FND_PROFILE.VALUE('HZ_DQM_SCORE_UNTIL_THRESH'),'N')='Y' THEN
3291: g_score_until_thresh := true;
3292: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN

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

3286: l_max_thresh:=nvl(FND_PROFILE.VALUE('HZ_DQM_MAX_EVAL_THRESH_BATCH'),10000);
3287: ELSE
3288: l_max_thresh:=nvl(FND_PROFILE.VALUE('HZ_DQM_MAX_EVAL_THRESH'),200);
3289: END IF;
3290: IF nvl(FND_PROFILE.VALUE('HZ_DQM_SCORE_UNTIL_THRESH'),'N')='Y' THEN
3291: g_score_until_thresh := true;
3292: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
3293: 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);
3294: END IF;

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

3608: and check_estimate_hits('PARTY',p_party_contains_str)>l_max_thresh THEN
3609: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
3610: 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);
3611: END IF;
3612: IF g_party_stage_rec.TX8 IS NOT NULL AND nvl(FND_PROFILE.VALUE('HZ_DQM_PN_THRESH_RESOLUTION'),'NONE')='SQL' THEN
3613: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
3614: 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);
3615: END IF;
3616: IF (l_party_site_contains_str IS NULL AND

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

3663: END IF;
3664: IF (l_party_id_idx-1)>l_max_thresh THEN
3665: IF p_index=1 AND call_order(2) = 'PARTY_SITE'
3666: AND call_type(2) = 'AND' AND l_contact_contains_str IS NULL
3667: AND nvl(FND_PROFILE.VALUE('HZ_DQM_PN_THRESH_RESOLUTION'),'NONE')='SQL'
3668: AND l_contact_pt_contains_str IS NULL THEN
3669: H_PARTY_ID.DELETE(l_party_id_idx-1);
3670: H_PARTY_ID_LIST.DELETE(l_index);
3671: H_SCORES.DELETE(l_index);

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

4204: END IF;
4205: 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);
4206: IF l_entered_max_score = 0 THEN l_entered_max_score:=1; END IF;
4207:
4208: l_max_thresh:=nvl(FND_PROFILE.VALUE('HZ_DQM_MAX_EVAL_THRESH'),200);
4209: IF nvl(FND_PROFILE.VALUE('HZ_DQM_SCORE_UNTIL_THRESH'),'N')='Y' THEN
4210: g_score_until_thresh := true;
4211: ELSE
4212: g_score_until_thresh := false;

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

4205: 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);
4206: IF l_entered_max_score = 0 THEN l_entered_max_score:=1; END IF;
4207:
4208: l_max_thresh:=nvl(FND_PROFILE.VALUE('HZ_DQM_MAX_EVAL_THRESH'),200);
4209: IF nvl(FND_PROFILE.VALUE('HZ_DQM_SCORE_UNTIL_THRESH'),'N')='Y' THEN
4210: g_score_until_thresh := true;
4211: ELSE
4212: g_score_until_thresh := false;
4213: END IF;

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

5886: l_use_contact_info varchar2(1);
5887: BEGIN
5888:
5889: l_use_contact_info := 'Y';
5890: IF nvl(FND_PROFILE.VALUE('HZ_DQM_REL_PARTY_MATCH'),'N')='Y' THEN
5891: l_use_contact_info := 'N';
5892: END IF;
5893: l_party_id := p_party_id;
5894: FOR PARTY_SITES IN (