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

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

2062: and check_estimate_hits('PARTY',p_party_contains_str)>l_max_thresh THEN
2063: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
2064: 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);
2065: END IF;
2066: 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
2067: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
2068: 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);
2069: END IF;
2070: IF (l_party_site_contains_str IS NULL AND

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

2118: END IF;
2119: IF (l_party_id_idx-1)>l_max_thresh THEN
2120: IF p_index=1 AND call_order(2) = 'PARTY_SITE'
2121: AND call_type(2) = 'AND' AND l_contact_contains_str IS NULL
2122: AND nvl(FND_PROFILE.VALUE('HZ_DQM_PN_THRESH_RESOLUTION'),'NONE')='SQL'
2123: AND l_contact_pt_contains_str IS NULL THEN
2124: EXIT;
2125: END IF;
2126: CLOSE l_party_cur;

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

2650:
2651: --End fix for bug 4417124
2652:
2653: IF p_dup_batch_id IS NOT NULL THEN
2654: l_max_thresh:=nvl(FND_PROFILE.VALUE('HZ_DQM_MAX_EVAL_THRESH_BATCH'),10000);
2655: ELSE
2656: l_max_thresh:=nvl(FND_PROFILE.VALUE('HZ_DQM_MAX_EVAL_THRESH'),200);
2657: END IF;
2658: IF nvl(FND_PROFILE.VALUE('HZ_DQM_SCORE_UNTIL_THRESH'),'N')='Y' THEN

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

2652:
2653: IF p_dup_batch_id IS NOT NULL THEN
2654: l_max_thresh:=nvl(FND_PROFILE.VALUE('HZ_DQM_MAX_EVAL_THRESH_BATCH'),10000);
2655: ELSE
2656: l_max_thresh:=nvl(FND_PROFILE.VALUE('HZ_DQM_MAX_EVAL_THRESH'),200);
2657: END IF;
2658: IF nvl(FND_PROFILE.VALUE('HZ_DQM_SCORE_UNTIL_THRESH'),'N')='Y' THEN
2659: g_score_until_thresh := true;
2660: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN

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

2654: l_max_thresh:=nvl(FND_PROFILE.VALUE('HZ_DQM_MAX_EVAL_THRESH_BATCH'),10000);
2655: ELSE
2656: l_max_thresh:=nvl(FND_PROFILE.VALUE('HZ_DQM_MAX_EVAL_THRESH'),200);
2657: END IF;
2658: IF nvl(FND_PROFILE.VALUE('HZ_DQM_SCORE_UNTIL_THRESH'),'N')='Y' THEN
2659: g_score_until_thresh := true;
2660: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
2661: 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);
2662: END IF;

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

2996: and check_estimate_hits('PARTY',p_party_contains_str)>l_max_thresh THEN
2997: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
2998: 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);
2999: END IF;
3000: IF g_party_stage_rec.TX8 IS NOT NULL AND nvl(FND_PROFILE.VALUE('HZ_DQM_PN_THRESH_RESOLUTION'),'NONE')='SQL' THEN
3001: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
3002: 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);
3003: END IF;
3004: IF (l_party_site_contains_str IS NULL AND

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

3049: END IF;
3050: IF (l_party_id_idx-1)>l_max_thresh THEN
3051: IF p_index=1 AND call_order(2) = 'PARTY_SITE'
3052: AND call_type(2) = 'AND' AND l_contact_contains_str IS NULL
3053: AND nvl(FND_PROFILE.VALUE('HZ_DQM_PN_THRESH_RESOLUTION'),'NONE')='SQL'
3054: AND l_contact_pt_contains_str IS NULL THEN
3055: H_PARTY_ID.DELETE(l_party_id_idx-1);
3056: H_PARTY_ID_LIST.DELETE(l_index);
3057: H_SCORES.DELETE(l_index);

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

3495: END IF;
3496: 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);
3497: IF l_entered_max_score = 0 THEN l_entered_max_score:=1; END IF;
3498:
3499: l_max_thresh:=nvl(FND_PROFILE.VALUE('HZ_DQM_MAX_EVAL_THRESH'),200);
3500: IF nvl(FND_PROFILE.VALUE('HZ_DQM_SCORE_UNTIL_THRESH'),'N')='Y' THEN
3501: g_score_until_thresh := true;
3502: ELSE
3503: g_score_until_thresh := false;

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

3496: 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);
3497: IF l_entered_max_score = 0 THEN l_entered_max_score:=1; END IF;
3498:
3499: l_max_thresh:=nvl(FND_PROFILE.VALUE('HZ_DQM_MAX_EVAL_THRESH'),200);
3500: IF nvl(FND_PROFILE.VALUE('HZ_DQM_SCORE_UNTIL_THRESH'),'N')='Y' THEN
3501: g_score_until_thresh := true;
3502: ELSE
3503: g_score_until_thresh := false;
3504: END IF;

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

5166: l_use_contact_info varchar2(1);
5167: BEGIN
5168:
5169: l_use_contact_info := 'Y';
5170: IF nvl(FND_PROFILE.VALUE('HZ_DQM_REL_PARTY_MATCH'),'N')='Y' THEN
5171: l_use_contact_info := 'N';
5172: END IF;
5173: l_party_id := p_party_id;
5174: FOR CONTACT_POINTS IN (