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

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

2147: and check_estimate_hits('PARTY',p_party_contains_str)>l_max_thresh THEN
2148: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
2149: 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);
2150: END IF;
2151: 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
2152: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
2153: 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);
2154: END IF;
2155: IF (l_party_site_contains_str IS NULL AND

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

2203: END IF;
2204: IF (l_party_id_idx-1)>l_max_thresh THEN
2205: IF p_index=1 AND call_order(2) = 'PARTY_SITE'
2206: AND call_type(2) = 'AND' AND l_contact_contains_str IS NULL
2207: AND nvl(FND_PROFILE.VALUE('HZ_DQM_PN_THRESH_RESOLUTION'),'NONE')='SQL'
2208: AND l_contact_pt_contains_str IS NULL THEN
2209: EXIT;
2210: END IF;
2211: CLOSE l_party_cur;

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

2735:
2736: --End fix for bug 4417124
2737:
2738: IF p_dup_batch_id IS NOT NULL THEN
2739: l_max_thresh:=nvl(FND_PROFILE.VALUE('HZ_DQM_MAX_EVAL_THRESH_BATCH'),10000);
2740: ELSE
2741: l_max_thresh:=nvl(FND_PROFILE.VALUE('HZ_DQM_MAX_EVAL_THRESH'),200);
2742: END IF;
2743: IF nvl(FND_PROFILE.VALUE('HZ_DQM_SCORE_UNTIL_THRESH'),'N')='Y' THEN

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

2737:
2738: IF p_dup_batch_id IS NOT NULL THEN
2739: l_max_thresh:=nvl(FND_PROFILE.VALUE('HZ_DQM_MAX_EVAL_THRESH_BATCH'),10000);
2740: ELSE
2741: l_max_thresh:=nvl(FND_PROFILE.VALUE('HZ_DQM_MAX_EVAL_THRESH'),200);
2742: END IF;
2743: IF nvl(FND_PROFILE.VALUE('HZ_DQM_SCORE_UNTIL_THRESH'),'N')='Y' THEN
2744: g_score_until_thresh := true;
2745: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN

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

2739: l_max_thresh:=nvl(FND_PROFILE.VALUE('HZ_DQM_MAX_EVAL_THRESH_BATCH'),10000);
2740: ELSE
2741: l_max_thresh:=nvl(FND_PROFILE.VALUE('HZ_DQM_MAX_EVAL_THRESH'),200);
2742: END IF;
2743: IF nvl(FND_PROFILE.VALUE('HZ_DQM_SCORE_UNTIL_THRESH'),'N')='Y' THEN
2744: g_score_until_thresh := true;
2745: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
2746: 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);
2747: END IF;

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

3082: and check_estimate_hits('PARTY',p_party_contains_str)>l_max_thresh THEN
3083: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
3084: 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);
3085: END IF;
3086: IF g_party_stage_rec.TX8 IS NOT NULL AND nvl(FND_PROFILE.VALUE('HZ_DQM_PN_THRESH_RESOLUTION'),'NONE')='SQL' THEN
3087: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
3088: 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);
3089: END IF;
3090: IF (l_party_site_contains_str IS NULL AND

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

3135: END IF;
3136: IF (l_party_id_idx-1)>l_max_thresh THEN
3137: IF p_index=1 AND call_order(2) = 'PARTY_SITE'
3138: AND call_type(2) = 'AND' AND l_contact_contains_str IS NULL
3139: AND nvl(FND_PROFILE.VALUE('HZ_DQM_PN_THRESH_RESOLUTION'),'NONE')='SQL'
3140: AND l_contact_pt_contains_str IS NULL THEN
3141: H_PARTY_ID.DELETE(l_party_id_idx-1);
3142: H_PARTY_ID_LIST.DELETE(l_index);
3143: H_SCORES.DELETE(l_index);

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

3581: END IF;
3582: 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);
3583: IF l_entered_max_score = 0 THEN l_entered_max_score:=1; END IF;
3584:
3585: l_max_thresh:=nvl(FND_PROFILE.VALUE('HZ_DQM_MAX_EVAL_THRESH'),200);
3586: IF nvl(FND_PROFILE.VALUE('HZ_DQM_SCORE_UNTIL_THRESH'),'N')='Y' THEN
3587: g_score_until_thresh := true;
3588: ELSE
3589: g_score_until_thresh := false;

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

3582: 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);
3583: IF l_entered_max_score = 0 THEN l_entered_max_score:=1; END IF;
3584:
3585: l_max_thresh:=nvl(FND_PROFILE.VALUE('HZ_DQM_MAX_EVAL_THRESH'),200);
3586: IF nvl(FND_PROFILE.VALUE('HZ_DQM_SCORE_UNTIL_THRESH'),'N')='Y' THEN
3587: g_score_until_thresh := true;
3588: ELSE
3589: g_score_until_thresh := false;
3590: END IF;

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

5216: l_use_contact_info varchar2(1);
5217: BEGIN
5218:
5219: l_use_contact_info := 'Y';
5220: IF nvl(FND_PROFILE.VALUE('HZ_DQM_REL_PARTY_MATCH'),'N')='Y' THEN
5221: l_use_contact_info := 'N';
5222: END IF;
5223: l_party_id := p_party_id;
5224: FOR PARTY_SITES IN (