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

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

2040: and check_estimate_hits('PARTY',p_party_contains_str)>l_max_thresh THEN
2041: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
2042: 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);
2043: END IF;
2044: 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
2045: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
2046: 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);
2047: END IF;
2048: IF (l_party_site_contains_str IS NULL AND

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

2096: END IF;
2097: IF (l_party_id_idx-1)>l_max_thresh THEN
2098: IF p_index=1 AND call_order(2) = 'PARTY_SITE'
2099: AND call_type(2) = 'AND' AND l_contact_contains_str IS NULL
2100: AND nvl(FND_PROFILE.VALUE('HZ_DQM_PN_THRESH_RESOLUTION'),'NONE')='SQL'
2101: AND l_contact_pt_contains_str IS NULL THEN
2102: EXIT;
2103: END IF;
2104: CLOSE l_party_cur;

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

2628:
2629: --End fix for bug 4417124
2630:
2631: IF p_dup_batch_id IS NOT NULL THEN
2632: l_max_thresh:=nvl(FND_PROFILE.VALUE('HZ_DQM_MAX_EVAL_THRESH_BATCH'),10000);
2633: ELSE
2634: l_max_thresh:=nvl(FND_PROFILE.VALUE('HZ_DQM_MAX_EVAL_THRESH'),200);
2635: END IF;
2636: IF nvl(FND_PROFILE.VALUE('HZ_DQM_SCORE_UNTIL_THRESH'),'N')='Y' THEN

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

2630:
2631: IF p_dup_batch_id IS NOT NULL THEN
2632: l_max_thresh:=nvl(FND_PROFILE.VALUE('HZ_DQM_MAX_EVAL_THRESH_BATCH'),10000);
2633: ELSE
2634: l_max_thresh:=nvl(FND_PROFILE.VALUE('HZ_DQM_MAX_EVAL_THRESH'),200);
2635: END IF;
2636: IF nvl(FND_PROFILE.VALUE('HZ_DQM_SCORE_UNTIL_THRESH'),'N')='Y' THEN
2637: g_score_until_thresh := true;
2638: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN

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

2632: l_max_thresh:=nvl(FND_PROFILE.VALUE('HZ_DQM_MAX_EVAL_THRESH_BATCH'),10000);
2633: ELSE
2634: l_max_thresh:=nvl(FND_PROFILE.VALUE('HZ_DQM_MAX_EVAL_THRESH'),200);
2635: END IF;
2636: IF nvl(FND_PROFILE.VALUE('HZ_DQM_SCORE_UNTIL_THRESH'),'N')='Y' THEN
2637: g_score_until_thresh := true;
2638: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
2639: 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);
2640: END IF;

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

2974: and check_estimate_hits('PARTY',p_party_contains_str)>l_max_thresh THEN
2975: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
2976: 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);
2977: END IF;
2978: IF g_party_stage_rec.TX8 IS NOT NULL AND nvl(FND_PROFILE.VALUE('HZ_DQM_PN_THRESH_RESOLUTION'),'NONE')='SQL' THEN
2979: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
2980: 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);
2981: END IF;
2982: IF (l_party_site_contains_str IS NULL AND

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

3027: END IF;
3028: IF (l_party_id_idx-1)>l_max_thresh THEN
3029: IF p_index=1 AND call_order(2) = 'PARTY_SITE'
3030: AND call_type(2) = 'AND' AND l_contact_contains_str IS NULL
3031: AND nvl(FND_PROFILE.VALUE('HZ_DQM_PN_THRESH_RESOLUTION'),'NONE')='SQL'
3032: AND l_contact_pt_contains_str IS NULL THEN
3033: H_PARTY_ID.DELETE(l_party_id_idx-1);
3034: H_PARTY_ID_LIST.DELETE(l_index);
3035: H_SCORES.DELETE(l_index);

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

3473: END IF;
3474: 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);
3475: IF l_entered_max_score = 0 THEN l_entered_max_score:=1; END IF;
3476:
3477: l_max_thresh:=nvl(FND_PROFILE.VALUE('HZ_DQM_MAX_EVAL_THRESH'),200);
3478: IF nvl(FND_PROFILE.VALUE('HZ_DQM_SCORE_UNTIL_THRESH'),'N')='Y' THEN
3479: g_score_until_thresh := true;
3480: ELSE
3481: g_score_until_thresh := false;

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

3474: 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);
3475: IF l_entered_max_score = 0 THEN l_entered_max_score:=1; END IF;
3476:
3477: l_max_thresh:=nvl(FND_PROFILE.VALUE('HZ_DQM_MAX_EVAL_THRESH'),200);
3478: IF nvl(FND_PROFILE.VALUE('HZ_DQM_SCORE_UNTIL_THRESH'),'N')='Y' THEN
3479: g_score_until_thresh := true;
3480: ELSE
3481: g_score_until_thresh := false;
3482: END IF;

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

5102: l_use_contact_info varchar2(1);
5103: BEGIN
5104:
5105: l_use_contact_info := 'Y';
5106: IF nvl(FND_PROFILE.VALUE('HZ_DQM_REL_PARTY_MATCH'),'N')='Y' THEN
5107: l_use_contact_info := 'N';
5108: END IF;
5109: l_party_id := p_party_id;
5110: FOR PARTY_SITES IN (