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

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

2173: and check_estimate_hits('PARTY',p_party_contains_str)>l_max_thresh THEN
2174: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
2175: 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);
2176: END IF;
2177: 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
2178: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
2179: 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);
2180: END IF;
2181: IF (l_party_site_contains_str IS NULL AND

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

2229: END IF;
2230: IF (l_party_id_idx-1)>l_max_thresh THEN
2231: IF p_index=1 AND call_order(2) = 'PARTY_SITE'
2232: AND call_type(2) = 'AND' AND l_contact_contains_str IS NULL
2233: AND nvl(FND_PROFILE.VALUE('HZ_DQM_PN_THRESH_RESOLUTION'),'NONE')='SQL'
2234: AND l_contact_pt_contains_str IS NULL THEN
2235: EXIT;
2236: END IF;
2237: CLOSE l_party_cur;

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

2831:
2832: --End fix for bug 4417124
2833:
2834: IF p_dup_batch_id IS NOT NULL THEN
2835: l_max_thresh:=nvl(FND_PROFILE.VALUE('HZ_DQM_MAX_EVAL_THRESH_BATCH'),10000);
2836: ELSE
2837: l_max_thresh:=nvl(FND_PROFILE.VALUE('HZ_DQM_MAX_EVAL_THRESH'),200);
2838: END IF;
2839: IF nvl(FND_PROFILE.VALUE('HZ_DQM_SCORE_UNTIL_THRESH'),'N')='Y' THEN

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

2833:
2834: IF p_dup_batch_id IS NOT NULL THEN
2835: l_max_thresh:=nvl(FND_PROFILE.VALUE('HZ_DQM_MAX_EVAL_THRESH_BATCH'),10000);
2836: ELSE
2837: l_max_thresh:=nvl(FND_PROFILE.VALUE('HZ_DQM_MAX_EVAL_THRESH'),200);
2838: END IF;
2839: IF nvl(FND_PROFILE.VALUE('HZ_DQM_SCORE_UNTIL_THRESH'),'N')='Y' THEN
2840: g_score_until_thresh := true;
2841: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN

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

2835: l_max_thresh:=nvl(FND_PROFILE.VALUE('HZ_DQM_MAX_EVAL_THRESH_BATCH'),10000);
2836: ELSE
2837: l_max_thresh:=nvl(FND_PROFILE.VALUE('HZ_DQM_MAX_EVAL_THRESH'),200);
2838: END IF;
2839: IF nvl(FND_PROFILE.VALUE('HZ_DQM_SCORE_UNTIL_THRESH'),'N')='Y' THEN
2840: g_score_until_thresh := true;
2841: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
2842: 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);
2843: END IF;

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

3148: and check_estimate_hits('PARTY',p_party_contains_str)>l_max_thresh THEN
3149: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
3150: 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);
3151: END IF;
3152: IF g_party_stage_rec.TX8 IS NOT NULL AND nvl(FND_PROFILE.VALUE('HZ_DQM_PN_THRESH_RESOLUTION'),'NONE')='SQL' THEN
3153: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
3154: 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);
3155: END IF;
3156: IF (l_party_site_contains_str IS NULL AND

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

3201: END IF;
3202: IF (l_party_id_idx-1)>l_max_thresh THEN
3203: IF p_index=1 AND call_order(2) = 'PARTY_SITE'
3204: AND call_type(2) = 'AND' AND l_contact_contains_str IS NULL
3205: AND nvl(FND_PROFILE.VALUE('HZ_DQM_PN_THRESH_RESOLUTION'),'NONE')='SQL'
3206: AND l_contact_pt_contains_str IS NULL THEN
3207: H_PARTY_ID.DELETE(l_party_id_idx-1);
3208: H_PARTY_ID_LIST.DELETE(l_index);
3209: H_SCORES.DELETE(l_index);

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

3742: END IF;
3743: 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);
3744: IF l_entered_max_score = 0 THEN l_entered_max_score:=1; END IF;
3745:
3746: l_max_thresh:=nvl(FND_PROFILE.VALUE('HZ_DQM_MAX_EVAL_THRESH'),200);
3747: IF nvl(FND_PROFILE.VALUE('HZ_DQM_SCORE_UNTIL_THRESH'),'N')='Y' THEN
3748: g_score_until_thresh := true;
3749: ELSE
3750: g_score_until_thresh := false;

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

3743: 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);
3744: IF l_entered_max_score = 0 THEN l_entered_max_score:=1; END IF;
3745:
3746: l_max_thresh:=nvl(FND_PROFILE.VALUE('HZ_DQM_MAX_EVAL_THRESH'),200);
3747: IF nvl(FND_PROFILE.VALUE('HZ_DQM_SCORE_UNTIL_THRESH'),'N')='Y' THEN
3748: g_score_until_thresh := true;
3749: ELSE
3750: g_score_until_thresh := false;
3751: END IF;

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

5394: l_use_contact_info varchar2(1);
5395: BEGIN
5396:
5397: l_use_contact_info := 'Y';
5398: IF nvl(FND_PROFILE.VALUE('HZ_DQM_REL_PARTY_MATCH'),'N')='Y' THEN
5399: l_use_contact_info := 'N';
5400: END IF;
5401: l_party_id := p_party_id;
5402: FOR CONTACTS IN (