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

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

2834: and check_estimate_hits('PARTY',p_party_contains_str)>l_max_thresh THEN
2835: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
2836: 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);
2837: END IF;
2838: 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
2839: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
2840: 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);
2841: END IF;
2842: IF (l_party_site_contains_str IS NULL AND

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

2892: END IF;
2893: IF (l_party_id_idx-1)>l_max_thresh THEN
2894: IF p_index=1 AND call_order(2) = 'PARTY_SITE'
2895: AND call_type(2) = 'AND' AND l_contact_contains_str IS NULL
2896: AND nvl(FND_PROFILE.VALUE('HZ_DQM_PN_THRESH_RESOLUTION'),'NONE')='SQL'
2897: AND l_contact_pt_contains_str IS NULL THEN
2898: EXIT;
2899: END IF;
2900: CLOSE l_party_cur;

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

3494:
3495: --End fix for bug 4417124
3496:
3497: IF p_dup_batch_id IS NOT NULL THEN
3498: l_max_thresh:=nvl(FND_PROFILE.VALUE('HZ_DQM_MAX_EVAL_THRESH_BATCH'),10000);
3499: ELSE
3500: l_max_thresh:=nvl(FND_PROFILE.VALUE('HZ_DQM_MAX_EVAL_THRESH'),200);
3501: END IF;
3502: IF nvl(FND_PROFILE.VALUE('HZ_DQM_SCORE_UNTIL_THRESH'),'N')='Y' THEN

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

3496:
3497: IF p_dup_batch_id IS NOT NULL THEN
3498: l_max_thresh:=nvl(FND_PROFILE.VALUE('HZ_DQM_MAX_EVAL_THRESH_BATCH'),10000);
3499: ELSE
3500: l_max_thresh:=nvl(FND_PROFILE.VALUE('HZ_DQM_MAX_EVAL_THRESH'),200);
3501: END IF;
3502: IF nvl(FND_PROFILE.VALUE('HZ_DQM_SCORE_UNTIL_THRESH'),'N')='Y' THEN
3503: g_score_until_thresh := true;
3504: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN

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

3498: l_max_thresh:=nvl(FND_PROFILE.VALUE('HZ_DQM_MAX_EVAL_THRESH_BATCH'),10000);
3499: ELSE
3500: l_max_thresh:=nvl(FND_PROFILE.VALUE('HZ_DQM_MAX_EVAL_THRESH'),200);
3501: END IF;
3502: IF nvl(FND_PROFILE.VALUE('HZ_DQM_SCORE_UNTIL_THRESH'),'N')='Y' THEN
3503: g_score_until_thresh := true;
3504: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
3505: 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);
3506: END IF;

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

3823: and check_estimate_hits('PARTY',p_party_contains_str)>l_max_thresh THEN
3824: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
3825: 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);
3826: END IF;
3827: IF g_party_stage_rec.TX8 IS NOT NULL AND nvl(FND_PROFILE.VALUE('HZ_DQM_PN_THRESH_RESOLUTION'),'NONE')='SQL' THEN
3828: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
3829: 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);
3830: END IF;
3831: IF (l_party_site_contains_str IS NULL AND

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

3878: END IF;
3879: IF (l_party_id_idx-1)>l_max_thresh THEN
3880: IF p_index=1 AND call_order(2) = 'PARTY_SITE'
3881: AND call_type(2) = 'AND' AND l_contact_contains_str IS NULL
3882: AND nvl(FND_PROFILE.VALUE('HZ_DQM_PN_THRESH_RESOLUTION'),'NONE')='SQL'
3883: AND l_contact_pt_contains_str IS NULL THEN
3884: H_PARTY_ID.DELETE(l_party_id_idx-1);
3885: H_PARTY_ID_LIST.DELETE(l_index);
3886: H_SCORES.DELETE(l_index);

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

4419: END IF;
4420: 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);
4421: IF l_entered_max_score = 0 THEN l_entered_max_score:=1; END IF;
4422:
4423: l_max_thresh:=nvl(FND_PROFILE.VALUE('HZ_DQM_MAX_EVAL_THRESH'),200);
4424: IF nvl(FND_PROFILE.VALUE('HZ_DQM_SCORE_UNTIL_THRESH'),'N')='Y' THEN
4425: g_score_until_thresh := true;
4426: ELSE
4427: g_score_until_thresh := false;

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

4420: 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);
4421: IF l_entered_max_score = 0 THEN l_entered_max_score:=1; END IF;
4422:
4423: l_max_thresh:=nvl(FND_PROFILE.VALUE('HZ_DQM_MAX_EVAL_THRESH'),200);
4424: IF nvl(FND_PROFILE.VALUE('HZ_DQM_SCORE_UNTIL_THRESH'),'N')='Y' THEN
4425: g_score_until_thresh := true;
4426: ELSE
4427: g_score_until_thresh := false;
4428: END IF;

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

6178: l_use_contact_info varchar2(1);
6179: BEGIN
6180:
6181: l_use_contact_info := 'Y';
6182: IF nvl(FND_PROFILE.VALUE('HZ_DQM_REL_PARTY_MATCH'),'N')='Y' THEN
6183: l_use_contact_info := 'N';
6184: END IF;
6185: l_party_id := p_party_id;
6186: FOR PARTY_SITES IN (