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.

[Home] [Help]

APPS.HZ_MATCH_RULE_8 dependencies on FND_PROFILE

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

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

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

2674: END IF;
2675: IF (l_party_id_idx-1)>l_max_thresh THEN
2676: IF p_index=1 AND call_order(2) = 'PARTY_SITE'
2677: AND call_type(2) = 'AND' AND l_contact_contains_str IS NULL
2678: AND nvl(FND_PROFILE.VALUE('HZ_DQM_PN_THRESH_RESOLUTION'),'NONE')='SQL'
2679: AND l_contact_pt_contains_str IS NULL THEN
2680: EXIT;
2681: END IF;
2682: CLOSE l_party_cur;

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

3276:
3277: --End fix for bug 4417124
3278:
3279: IF p_dup_batch_id IS NOT NULL THEN
3280: l_max_thresh:=nvl(FND_PROFILE.VALUE('HZ_DQM_MAX_EVAL_THRESH_BATCH'),10000);
3281: ELSE
3282: l_max_thresh:=nvl(FND_PROFILE.VALUE('HZ_DQM_MAX_EVAL_THRESH'),200);
3283: END IF;
3284: IF nvl(FND_PROFILE.VALUE('HZ_DQM_SCORE_UNTIL_THRESH'),'N')='Y' THEN

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

3278:
3279: IF p_dup_batch_id IS NOT NULL THEN
3280: l_max_thresh:=nvl(FND_PROFILE.VALUE('HZ_DQM_MAX_EVAL_THRESH_BATCH'),10000);
3281: ELSE
3282: l_max_thresh:=nvl(FND_PROFILE.VALUE('HZ_DQM_MAX_EVAL_THRESH'),200);
3283: END IF;
3284: IF nvl(FND_PROFILE.VALUE('HZ_DQM_SCORE_UNTIL_THRESH'),'N')='Y' THEN
3285: g_score_until_thresh := true;
3286: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN

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

3280: l_max_thresh:=nvl(FND_PROFILE.VALUE('HZ_DQM_MAX_EVAL_THRESH_BATCH'),10000);
3281: ELSE
3282: l_max_thresh:=nvl(FND_PROFILE.VALUE('HZ_DQM_MAX_EVAL_THRESH'),200);
3283: END IF;
3284: IF nvl(FND_PROFILE.VALUE('HZ_DQM_SCORE_UNTIL_THRESH'),'N')='Y' THEN
3285: g_score_until_thresh := true;
3286: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
3287: 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);
3288: END IF;

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

3601: and check_estimate_hits('PARTY',p_party_contains_str)>l_max_thresh THEN
3602: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
3603: 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);
3604: END IF;
3605: IF g_party_stage_rec.TX8 IS NOT NULL AND nvl(FND_PROFILE.VALUE('HZ_DQM_PN_THRESH_RESOLUTION'),'NONE')='SQL' THEN
3606: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
3607: 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);
3608: END IF;
3609: IF (l_party_site_contains_str IS NULL AND

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

3654: END IF;
3655: IF (l_party_id_idx-1)>l_max_thresh THEN
3656: IF p_index=1 AND call_order(2) = 'PARTY_SITE'
3657: AND call_type(2) = 'AND' AND l_contact_contains_str IS NULL
3658: AND nvl(FND_PROFILE.VALUE('HZ_DQM_PN_THRESH_RESOLUTION'),'NONE')='SQL'
3659: AND l_contact_pt_contains_str IS NULL THEN
3660: H_PARTY_ID.DELETE(l_party_id_idx-1);
3661: H_PARTY_ID_LIST.DELETE(l_index);
3662: H_SCORES.DELETE(l_index);

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

4195: END IF;
4196: 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);
4197: IF l_entered_max_score = 0 THEN l_entered_max_score:=1; END IF;
4198:
4199: l_max_thresh:=nvl(FND_PROFILE.VALUE('HZ_DQM_MAX_EVAL_THRESH'),200);
4200: IF nvl(FND_PROFILE.VALUE('HZ_DQM_SCORE_UNTIL_THRESH'),'N')='Y' THEN
4201: g_score_until_thresh := true;
4202: ELSE
4203: g_score_until_thresh := false;

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

4196: 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);
4197: IF l_entered_max_score = 0 THEN l_entered_max_score:=1; END IF;
4198:
4199: l_max_thresh:=nvl(FND_PROFILE.VALUE('HZ_DQM_MAX_EVAL_THRESH'),200);
4200: IF nvl(FND_PROFILE.VALUE('HZ_DQM_SCORE_UNTIL_THRESH'),'N')='Y' THEN
4201: g_score_until_thresh := true;
4202: ELSE
4203: g_score_until_thresh := false;
4204: END IF;

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

5940: l_use_contact_info varchar2(1);
5941: BEGIN
5942:
5943: l_use_contact_info := 'Y';
5944: IF nvl(FND_PROFILE.VALUE('HZ_DQM_REL_PARTY_MATCH'),'N')='Y' THEN
5945: l_use_contact_info := 'N';
5946: END IF;
5947: l_party_id := p_party_id;
5948: FOR PARTY_SITES IN (