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

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

3401: and check_estimate_hits('PARTY',p_party_contains_str)>l_max_thresh THEN
3402: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
3403: 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);
3404: END IF;
3405: 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
3406: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
3407: 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);
3408: END IF;
3409: IF (l_party_site_contains_str IS NULL AND

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

3459: END IF;
3460: IF (l_party_id_idx-1)>l_max_thresh THEN
3461: IF p_index=1 AND call_order(2) = 'PARTY_SITE'
3462: AND call_type(2) = 'AND' AND l_contact_contains_str IS NULL
3463: AND nvl(FND_PROFILE.VALUE('HZ_DQM_PN_THRESH_RESOLUTION'),'NONE')='SQL'
3464: AND l_contact_pt_contains_str IS NULL THEN
3465: EXIT;
3466: END IF;
3467: CLOSE l_party_cur;

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

4061:
4062: --End fix for bug 4417124
4063:
4064: IF p_dup_batch_id IS NOT NULL THEN
4065: l_max_thresh:=nvl(FND_PROFILE.VALUE('HZ_DQM_MAX_EVAL_THRESH_BATCH'),10000);
4066: ELSE
4067: l_max_thresh:=nvl(FND_PROFILE.VALUE('HZ_DQM_MAX_EVAL_THRESH'),200);
4068: END IF;
4069: IF nvl(FND_PROFILE.VALUE('HZ_DQM_SCORE_UNTIL_THRESH'),'N')='Y' THEN

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

4063:
4064: IF p_dup_batch_id IS NOT NULL THEN
4065: l_max_thresh:=nvl(FND_PROFILE.VALUE('HZ_DQM_MAX_EVAL_THRESH_BATCH'),10000);
4066: ELSE
4067: l_max_thresh:=nvl(FND_PROFILE.VALUE('HZ_DQM_MAX_EVAL_THRESH'),200);
4068: END IF;
4069: IF nvl(FND_PROFILE.VALUE('HZ_DQM_SCORE_UNTIL_THRESH'),'N')='Y' THEN
4070: g_score_until_thresh := true;
4071: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN

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

4065: l_max_thresh:=nvl(FND_PROFILE.VALUE('HZ_DQM_MAX_EVAL_THRESH_BATCH'),10000);
4066: ELSE
4067: l_max_thresh:=nvl(FND_PROFILE.VALUE('HZ_DQM_MAX_EVAL_THRESH'),200);
4068: END IF;
4069: IF nvl(FND_PROFILE.VALUE('HZ_DQM_SCORE_UNTIL_THRESH'),'N')='Y' THEN
4070: g_score_until_thresh := true;
4071: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
4072: 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);
4073: END IF;

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

4394: and check_estimate_hits('PARTY',p_party_contains_str)>l_max_thresh THEN
4395: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
4396: 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);
4397: END IF;
4398: IF g_party_stage_rec.TX8 IS NOT NULL AND nvl(FND_PROFILE.VALUE('HZ_DQM_PN_THRESH_RESOLUTION'),'NONE')='SQL' THEN
4399: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
4400: 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);
4401: END IF;
4402: IF (l_party_site_contains_str IS NULL AND

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

4449: END IF;
4450: IF (l_party_id_idx-1)>l_max_thresh THEN
4451: IF p_index=1 AND call_order(2) = 'PARTY_SITE'
4452: AND call_type(2) = 'AND' AND l_contact_contains_str IS NULL
4453: AND nvl(FND_PROFILE.VALUE('HZ_DQM_PN_THRESH_RESOLUTION'),'NONE')='SQL'
4454: AND l_contact_pt_contains_str IS NULL THEN
4455: H_PARTY_ID.DELETE(l_party_id_idx-1);
4456: H_PARTY_ID_LIST.DELETE(l_index);
4457: H_SCORES.DELETE(l_index);

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

4990: END IF;
4991: 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);
4992: IF l_entered_max_score = 0 THEN l_entered_max_score:=1; END IF;
4993:
4994: l_max_thresh:=nvl(FND_PROFILE.VALUE('HZ_DQM_MAX_EVAL_THRESH'),200);
4995: IF nvl(FND_PROFILE.VALUE('HZ_DQM_SCORE_UNTIL_THRESH'),'N')='Y' THEN
4996: g_score_until_thresh := true;
4997: ELSE
4998: g_score_until_thresh := false;

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

4991: 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);
4992: IF l_entered_max_score = 0 THEN l_entered_max_score:=1; END IF;
4993:
4994: l_max_thresh:=nvl(FND_PROFILE.VALUE('HZ_DQM_MAX_EVAL_THRESH'),200);
4995: IF nvl(FND_PROFILE.VALUE('HZ_DQM_SCORE_UNTIL_THRESH'),'N')='Y' THEN
4996: g_score_until_thresh := true;
4997: ELSE
4998: g_score_until_thresh := false;
4999: END IF;

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

6815: l_use_contact_info varchar2(1);
6816: BEGIN
6817:
6818: l_use_contact_info := 'Y';
6819: IF nvl(FND_PROFILE.VALUE('HZ_DQM_REL_PARTY_MATCH'),'N')='Y' THEN
6820: l_use_contact_info := 'N';
6821: END IF;
6822: l_party_id := p_party_id;
6823: FOR PARTY_SITES IN (