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

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

2448: and check_estimate_hits('PARTY',p_party_contains_str)>l_max_thresh THEN
2449: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
2450: 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);
2451: END IF;
2452: 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
2453: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
2454: 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);
2455: END IF;
2456: IF (l_party_site_contains_str IS NULL AND

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

2504: END IF;
2505: IF (l_party_id_idx-1)>l_max_thresh THEN
2506: IF p_index=1 AND call_order(2) = 'PARTY_SITE'
2507: AND call_type(2) = 'AND' AND l_contact_contains_str IS NULL
2508: AND nvl(FND_PROFILE.VALUE('HZ_DQM_PN_THRESH_RESOLUTION'),'NONE')='SQL'
2509: AND l_contact_pt_contains_str IS NULL THEN
2510: EXIT;
2511: END IF;
2512: CLOSE l_party_cur;

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

3036:
3037: --End fix for bug 4417124
3038:
3039: IF p_dup_batch_id IS NOT NULL THEN
3040: l_max_thresh:=nvl(FND_PROFILE.VALUE('HZ_DQM_MAX_EVAL_THRESH_BATCH'),10000);
3041: ELSE
3042: l_max_thresh:=nvl(FND_PROFILE.VALUE('HZ_DQM_MAX_EVAL_THRESH'),200);
3043: END IF;
3044: IF nvl(FND_PROFILE.VALUE('HZ_DQM_SCORE_UNTIL_THRESH'),'N')='Y' THEN

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

3038:
3039: IF p_dup_batch_id IS NOT NULL THEN
3040: l_max_thresh:=nvl(FND_PROFILE.VALUE('HZ_DQM_MAX_EVAL_THRESH_BATCH'),10000);
3041: ELSE
3042: l_max_thresh:=nvl(FND_PROFILE.VALUE('HZ_DQM_MAX_EVAL_THRESH'),200);
3043: END IF;
3044: IF nvl(FND_PROFILE.VALUE('HZ_DQM_SCORE_UNTIL_THRESH'),'N')='Y' THEN
3045: g_score_until_thresh := true;
3046: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN

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

3040: l_max_thresh:=nvl(FND_PROFILE.VALUE('HZ_DQM_MAX_EVAL_THRESH_BATCH'),10000);
3041: ELSE
3042: l_max_thresh:=nvl(FND_PROFILE.VALUE('HZ_DQM_MAX_EVAL_THRESH'),200);
3043: END IF;
3044: IF nvl(FND_PROFILE.VALUE('HZ_DQM_SCORE_UNTIL_THRESH'),'N')='Y' THEN
3045: g_score_until_thresh := true;
3046: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
3047: 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);
3048: END IF;

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

3387: and check_estimate_hits('PARTY',p_party_contains_str)>l_max_thresh THEN
3388: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
3389: 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);
3390: END IF;
3391: IF g_party_stage_rec.TX8 IS NOT NULL AND nvl(FND_PROFILE.VALUE('HZ_DQM_PN_THRESH_RESOLUTION'),'NONE')='SQL' THEN
3392: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
3393: 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);
3394: END IF;
3395: IF (l_party_site_contains_str IS NULL AND

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

3440: END IF;
3441: IF (l_party_id_idx-1)>l_max_thresh THEN
3442: IF p_index=1 AND call_order(2) = 'PARTY_SITE'
3443: AND call_type(2) = 'AND' AND l_contact_contains_str IS NULL
3444: AND nvl(FND_PROFILE.VALUE('HZ_DQM_PN_THRESH_RESOLUTION'),'NONE')='SQL'
3445: AND l_contact_pt_contains_str IS NULL THEN
3446: H_PARTY_ID.DELETE(l_party_id_idx-1);
3447: H_PARTY_ID_LIST.DELETE(l_index);
3448: H_SCORES.DELETE(l_index);

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

3886: END IF;
3887: 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);
3888: IF l_entered_max_score = 0 THEN l_entered_max_score:=1; END IF;
3889:
3890: l_max_thresh:=nvl(FND_PROFILE.VALUE('HZ_DQM_MAX_EVAL_THRESH'),200);
3891: IF nvl(FND_PROFILE.VALUE('HZ_DQM_SCORE_UNTIL_THRESH'),'N')='Y' THEN
3892: g_score_until_thresh := true;
3893: ELSE
3894: g_score_until_thresh := false;

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

3887: 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);
3888: IF l_entered_max_score = 0 THEN l_entered_max_score:=1; END IF;
3889:
3890: l_max_thresh:=nvl(FND_PROFILE.VALUE('HZ_DQM_MAX_EVAL_THRESH'),200);
3891: IF nvl(FND_PROFILE.VALUE('HZ_DQM_SCORE_UNTIL_THRESH'),'N')='Y' THEN
3892: g_score_until_thresh := true;
3893: ELSE
3894: g_score_until_thresh := false;
3895: END IF;

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

5557: l_use_contact_info varchar2(1);
5558: BEGIN
5559:
5560: l_use_contact_info := 'Y';
5561: IF nvl(FND_PROFILE.VALUE('HZ_DQM_REL_PARTY_MATCH'),'N')='Y' THEN
5562: l_use_contact_info := 'N';
5563: END IF;
5564: l_party_id := p_party_id;
5565: FOR PARTY_SITES IN (