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

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

2865: and check_estimate_hits('PARTY',p_party_contains_str)>l_max_thresh THEN
2866: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
2867: 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);
2868: END IF;
2869: 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
2870: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
2871: 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);
2872: END IF;
2873: IF (l_party_site_contains_str IS NULL AND

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

2923: END IF;
2924: IF (l_party_id_idx-1)>l_max_thresh THEN
2925: IF p_index=1 AND call_order(2) = 'PARTY_SITE'
2926: AND call_type(2) = 'AND' AND l_contact_contains_str IS NULL
2927: AND nvl(FND_PROFILE.VALUE('HZ_DQM_PN_THRESH_RESOLUTION'),'NONE')='SQL'
2928: AND l_contact_pt_contains_str IS NULL THEN
2929: EXIT;
2930: END IF;
2931: CLOSE l_party_cur;

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

3525:
3526: --End fix for bug 4417124
3527:
3528: IF p_dup_batch_id IS NOT NULL THEN
3529: l_max_thresh:=nvl(FND_PROFILE.VALUE('HZ_DQM_MAX_EVAL_THRESH_BATCH'),10000);
3530: ELSE
3531: l_max_thresh:=nvl(FND_PROFILE.VALUE('HZ_DQM_MAX_EVAL_THRESH'),200);
3532: END IF;
3533: IF nvl(FND_PROFILE.VALUE('HZ_DQM_SCORE_UNTIL_THRESH'),'N')='Y' THEN

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

3527:
3528: IF p_dup_batch_id IS NOT NULL THEN
3529: l_max_thresh:=nvl(FND_PROFILE.VALUE('HZ_DQM_MAX_EVAL_THRESH_BATCH'),10000);
3530: ELSE
3531: l_max_thresh:=nvl(FND_PROFILE.VALUE('HZ_DQM_MAX_EVAL_THRESH'),200);
3532: END IF;
3533: IF nvl(FND_PROFILE.VALUE('HZ_DQM_SCORE_UNTIL_THRESH'),'N')='Y' THEN
3534: g_score_until_thresh := true;
3535: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN

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

3529: l_max_thresh:=nvl(FND_PROFILE.VALUE('HZ_DQM_MAX_EVAL_THRESH_BATCH'),10000);
3530: ELSE
3531: l_max_thresh:=nvl(FND_PROFILE.VALUE('HZ_DQM_MAX_EVAL_THRESH'),200);
3532: END IF;
3533: IF nvl(FND_PROFILE.VALUE('HZ_DQM_SCORE_UNTIL_THRESH'),'N')='Y' THEN
3534: g_score_until_thresh := true;
3535: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
3536: 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);
3537: END IF;

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

3854: and check_estimate_hits('PARTY',p_party_contains_str)>l_max_thresh THEN
3855: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
3856: 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);
3857: END IF;
3858: IF g_party_stage_rec.TX8 IS NOT NULL AND nvl(FND_PROFILE.VALUE('HZ_DQM_PN_THRESH_RESOLUTION'),'NONE')='SQL' THEN
3859: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
3860: 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);
3861: END IF;
3862: IF (l_party_site_contains_str IS NULL AND

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

3909: END IF;
3910: IF (l_party_id_idx-1)>l_max_thresh THEN
3911: IF p_index=1 AND call_order(2) = 'PARTY_SITE'
3912: AND call_type(2) = 'AND' AND l_contact_contains_str IS NULL
3913: AND nvl(FND_PROFILE.VALUE('HZ_DQM_PN_THRESH_RESOLUTION'),'NONE')='SQL'
3914: AND l_contact_pt_contains_str IS NULL THEN
3915: H_PARTY_ID.DELETE(l_party_id_idx-1);
3916: H_PARTY_ID_LIST.DELETE(l_index);
3917: H_SCORES.DELETE(l_index);

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

4450: END IF;
4451: 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);
4452: IF l_entered_max_score = 0 THEN l_entered_max_score:=1; END IF;
4453:
4454: l_max_thresh:=nvl(FND_PROFILE.VALUE('HZ_DQM_MAX_EVAL_THRESH'),200);
4455: IF nvl(FND_PROFILE.VALUE('HZ_DQM_SCORE_UNTIL_THRESH'),'N')='Y' THEN
4456: g_score_until_thresh := true;
4457: ELSE
4458: g_score_until_thresh := false;

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

4451: 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);
4452: IF l_entered_max_score = 0 THEN l_entered_max_score:=1; END IF;
4453:
4454: l_max_thresh:=nvl(FND_PROFILE.VALUE('HZ_DQM_MAX_EVAL_THRESH'),200);
4455: IF nvl(FND_PROFILE.VALUE('HZ_DQM_SCORE_UNTIL_THRESH'),'N')='Y' THEN
4456: g_score_until_thresh := true;
4457: ELSE
4458: g_score_until_thresh := false;
4459: END IF;

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

6211: l_use_contact_info varchar2(1);
6212: BEGIN
6213:
6214: l_use_contact_info := 'Y';
6215: IF nvl(FND_PROFILE.VALUE('HZ_DQM_REL_PARTY_MATCH'),'N')='Y' THEN
6216: l_use_contact_info := 'N';
6217: END IF;
6218: l_party_id := p_party_id;
6219: FOR PARTY_SITES IN (