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.

APPS.HZ_MATCH_RULE_58 dependencies on FND_PROFILE

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

2396: and check_estimate_hits('PARTY',p_party_contains_str)>l_max_thresh THEN
2397: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
2398: 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);
2399: END IF;
2400: 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
2401: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
2402: 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);
2403: END IF;
2404: IF (l_party_site_contains_str IS NULL AND

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

2452: END IF;
2453: IF (l_party_id_idx-1)>l_max_thresh THEN
2454: IF p_index=1 AND call_order(2) = 'PARTY_SITE'
2455: AND call_type(2) = 'AND' AND l_contact_contains_str IS NULL
2456: AND nvl(FND_PROFILE.VALUE('HZ_DQM_PN_THRESH_RESOLUTION'),'NONE')='SQL'
2457: AND l_contact_pt_contains_str IS NULL THEN
2458: EXIT;
2459: END IF;
2460: CLOSE l_party_cur;

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

3054:
3055: --End fix for bug 4417124
3056:
3057: IF p_dup_batch_id IS NOT NULL THEN
3058: l_max_thresh:=nvl(FND_PROFILE.VALUE('HZ_DQM_MAX_EVAL_THRESH_BATCH'),10000);
3059: ELSE
3060: l_max_thresh:=nvl(FND_PROFILE.VALUE('HZ_DQM_MAX_EVAL_THRESH'),200);
3061: END IF;
3062: IF nvl(FND_PROFILE.VALUE('HZ_DQM_SCORE_UNTIL_THRESH'),'N')='Y' THEN

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

3056:
3057: IF p_dup_batch_id IS NOT NULL THEN
3058: l_max_thresh:=nvl(FND_PROFILE.VALUE('HZ_DQM_MAX_EVAL_THRESH_BATCH'),10000);
3059: ELSE
3060: l_max_thresh:=nvl(FND_PROFILE.VALUE('HZ_DQM_MAX_EVAL_THRESH'),200);
3061: END IF;
3062: IF nvl(FND_PROFILE.VALUE('HZ_DQM_SCORE_UNTIL_THRESH'),'N')='Y' THEN
3063: g_score_until_thresh := true;
3064: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN

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

3058: l_max_thresh:=nvl(FND_PROFILE.VALUE('HZ_DQM_MAX_EVAL_THRESH_BATCH'),10000);
3059: ELSE
3060: l_max_thresh:=nvl(FND_PROFILE.VALUE('HZ_DQM_MAX_EVAL_THRESH'),200);
3061: END IF;
3062: IF nvl(FND_PROFILE.VALUE('HZ_DQM_SCORE_UNTIL_THRESH'),'N')='Y' THEN
3063: g_score_until_thresh := true;
3064: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
3065: 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);
3066: END IF;

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

3373: and check_estimate_hits('PARTY',p_party_contains_str)>l_max_thresh THEN
3374: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
3375: 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);
3376: END IF;
3377: IF g_party_stage_rec.TX8 IS NOT NULL AND nvl(FND_PROFILE.VALUE('HZ_DQM_PN_THRESH_RESOLUTION'),'NONE')='SQL' THEN
3378: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
3379: 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);
3380: END IF;
3381: IF (l_party_site_contains_str IS NULL AND

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

3426: END IF;
3427: IF (l_party_id_idx-1)>l_max_thresh THEN
3428: IF p_index=1 AND call_order(2) = 'PARTY_SITE'
3429: AND call_type(2) = 'AND' AND l_contact_contains_str IS NULL
3430: AND nvl(FND_PROFILE.VALUE('HZ_DQM_PN_THRESH_RESOLUTION'),'NONE')='SQL'
3431: AND l_contact_pt_contains_str IS NULL THEN
3432: H_PARTY_ID.DELETE(l_party_id_idx-1);
3433: H_PARTY_ID_LIST.DELETE(l_index);
3434: H_SCORES.DELETE(l_index);

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

3967: END IF;
3968: 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);
3969: IF l_entered_max_score = 0 THEN l_entered_max_score:=1; END IF;
3970:
3971: l_max_thresh:=nvl(FND_PROFILE.VALUE('HZ_DQM_MAX_EVAL_THRESH'),200);
3972: IF nvl(FND_PROFILE.VALUE('HZ_DQM_SCORE_UNTIL_THRESH'),'N')='Y' THEN
3973: g_score_until_thresh := true;
3974: ELSE
3975: g_score_until_thresh := false;

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

3968: 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);
3969: IF l_entered_max_score = 0 THEN l_entered_max_score:=1; END IF;
3970:
3971: l_max_thresh:=nvl(FND_PROFILE.VALUE('HZ_DQM_MAX_EVAL_THRESH'),200);
3972: IF nvl(FND_PROFILE.VALUE('HZ_DQM_SCORE_UNTIL_THRESH'),'N')='Y' THEN
3973: g_score_until_thresh := true;
3974: ELSE
3975: g_score_until_thresh := false;
3976: END IF;

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

5645: l_use_contact_info varchar2(1);
5646: BEGIN
5647:
5648: l_use_contact_info := 'Y';
5649: IF nvl(FND_PROFILE.VALUE('HZ_DQM_REL_PARTY_MATCH'),'N')='Y' THEN
5650: l_use_contact_info := 'N';
5651: END IF;
5652: l_party_id := p_party_id;
5653: FOR CONTACTS IN (