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

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

2556: and check_estimate_hits('PARTY',p_party_contains_str)>l_max_thresh THEN
2557: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
2558: 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);
2559: END IF;
2560: 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
2561: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
2562: 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);
2563: END IF;
2564: IF (l_party_site_contains_str IS NULL AND

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

2612: END IF;
2613: IF (l_party_id_idx-1)>l_max_thresh THEN
2614: IF p_index=1 AND call_order(2) = 'PARTY_SITE'
2615: AND call_type(2) = 'AND' AND l_contact_contains_str IS NULL
2616: AND nvl(FND_PROFILE.VALUE('HZ_DQM_PN_THRESH_RESOLUTION'),'NONE')='SQL'
2617: AND l_contact_pt_contains_str IS NULL THEN
2618: EXIT;
2619: END IF;
2620: CLOSE l_party_cur;

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

3214:
3215: --End fix for bug 4417124
3216:
3217: IF p_dup_batch_id IS NOT NULL THEN
3218: l_max_thresh:=nvl(FND_PROFILE.VALUE('HZ_DQM_MAX_EVAL_THRESH_BATCH'),10000);
3219: ELSE
3220: l_max_thresh:=nvl(FND_PROFILE.VALUE('HZ_DQM_MAX_EVAL_THRESH'),200);
3221: END IF;
3222: IF nvl(FND_PROFILE.VALUE('HZ_DQM_SCORE_UNTIL_THRESH'),'N')='Y' THEN

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

3216:
3217: IF p_dup_batch_id IS NOT NULL THEN
3218: l_max_thresh:=nvl(FND_PROFILE.VALUE('HZ_DQM_MAX_EVAL_THRESH_BATCH'),10000);
3219: ELSE
3220: l_max_thresh:=nvl(FND_PROFILE.VALUE('HZ_DQM_MAX_EVAL_THRESH'),200);
3221: END IF;
3222: IF nvl(FND_PROFILE.VALUE('HZ_DQM_SCORE_UNTIL_THRESH'),'N')='Y' THEN
3223: g_score_until_thresh := true;
3224: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN

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

3218: l_max_thresh:=nvl(FND_PROFILE.VALUE('HZ_DQM_MAX_EVAL_THRESH_BATCH'),10000);
3219: ELSE
3220: l_max_thresh:=nvl(FND_PROFILE.VALUE('HZ_DQM_MAX_EVAL_THRESH'),200);
3221: END IF;
3222: IF nvl(FND_PROFILE.VALUE('HZ_DQM_SCORE_UNTIL_THRESH'),'N')='Y' THEN
3223: g_score_until_thresh := true;
3224: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
3225: 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);
3226: END IF;

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

3540: and check_estimate_hits('PARTY',p_party_contains_str)>l_max_thresh THEN
3541: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
3542: 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);
3543: END IF;
3544: IF g_party_stage_rec.TX8 IS NOT NULL AND nvl(FND_PROFILE.VALUE('HZ_DQM_PN_THRESH_RESOLUTION'),'NONE')='SQL' THEN
3545: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
3546: 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);
3547: END IF;
3548: IF (l_party_site_contains_str IS NULL AND

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

3593: END IF;
3594: IF (l_party_id_idx-1)>l_max_thresh THEN
3595: IF p_index=1 AND call_order(2) = 'PARTY_SITE'
3596: AND call_type(2) = 'AND' AND l_contact_contains_str IS NULL
3597: AND nvl(FND_PROFILE.VALUE('HZ_DQM_PN_THRESH_RESOLUTION'),'NONE')='SQL'
3598: AND l_contact_pt_contains_str IS NULL THEN
3599: H_PARTY_ID.DELETE(l_party_id_idx-1);
3600: H_PARTY_ID_LIST.DELETE(l_index);
3601: H_SCORES.DELETE(l_index);

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

4134: END IF;
4135: 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);
4136: IF l_entered_max_score = 0 THEN l_entered_max_score:=1; END IF;
4137:
4138: l_max_thresh:=nvl(FND_PROFILE.VALUE('HZ_DQM_MAX_EVAL_THRESH'),200);
4139: IF nvl(FND_PROFILE.VALUE('HZ_DQM_SCORE_UNTIL_THRESH'),'N')='Y' THEN
4140: g_score_until_thresh := true;
4141: ELSE
4142: g_score_until_thresh := false;

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

4135: 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);
4136: IF l_entered_max_score = 0 THEN l_entered_max_score:=1; END IF;
4137:
4138: l_max_thresh:=nvl(FND_PROFILE.VALUE('HZ_DQM_MAX_EVAL_THRESH'),200);
4139: IF nvl(FND_PROFILE.VALUE('HZ_DQM_SCORE_UNTIL_THRESH'),'N')='Y' THEN
4140: g_score_until_thresh := true;
4141: ELSE
4142: g_score_until_thresh := false;
4143: END IF;

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

5822: l_use_contact_info varchar2(1);
5823: BEGIN
5824:
5825: l_use_contact_info := 'Y';
5826: IF nvl(FND_PROFILE.VALUE('HZ_DQM_REL_PARTY_MATCH'),'N')='Y' THEN
5827: l_use_contact_info := 'N';
5828: END IF;
5829: l_party_id := p_party_id;
5830: FOR PARTY_SITES IN (