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

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

2553: and check_estimate_hits('PARTY',p_party_contains_str)>l_max_thresh THEN
2554: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
2555: 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);
2556: END IF;
2557: 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
2558: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
2559: 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);
2560: END IF;
2561: IF (l_party_site_contains_str IS NULL AND

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

2609: END IF;
2610: IF (l_party_id_idx-1)>l_max_thresh THEN
2611: IF p_index=1 AND call_order(2) = 'PARTY_SITE'
2612: AND call_type(2) = 'AND' AND l_contact_contains_str IS NULL
2613: AND nvl(FND_PROFILE.VALUE('HZ_DQM_PN_THRESH_RESOLUTION'),'NONE')='SQL'
2614: AND l_contact_pt_contains_str IS NULL THEN
2615: EXIT;
2616: END IF;
2617: CLOSE l_party_cur;

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

3211:
3212: --End fix for bug 4417124
3213:
3214: IF p_dup_batch_id IS NOT NULL THEN
3215: l_max_thresh:=nvl(FND_PROFILE.VALUE('HZ_DQM_MAX_EVAL_THRESH_BATCH'),10000);
3216: ELSE
3217: l_max_thresh:=nvl(FND_PROFILE.VALUE('HZ_DQM_MAX_EVAL_THRESH'),200);
3218: END IF;
3219: IF nvl(FND_PROFILE.VALUE('HZ_DQM_SCORE_UNTIL_THRESH'),'N')='Y' THEN

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

3213:
3214: IF p_dup_batch_id IS NOT NULL THEN
3215: l_max_thresh:=nvl(FND_PROFILE.VALUE('HZ_DQM_MAX_EVAL_THRESH_BATCH'),10000);
3216: ELSE
3217: l_max_thresh:=nvl(FND_PROFILE.VALUE('HZ_DQM_MAX_EVAL_THRESH'),200);
3218: END IF;
3219: IF nvl(FND_PROFILE.VALUE('HZ_DQM_SCORE_UNTIL_THRESH'),'N')='Y' THEN
3220: g_score_until_thresh := true;
3221: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN

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

3215: l_max_thresh:=nvl(FND_PROFILE.VALUE('HZ_DQM_MAX_EVAL_THRESH_BATCH'),10000);
3216: ELSE
3217: l_max_thresh:=nvl(FND_PROFILE.VALUE('HZ_DQM_MAX_EVAL_THRESH'),200);
3218: END IF;
3219: IF nvl(FND_PROFILE.VALUE('HZ_DQM_SCORE_UNTIL_THRESH'),'N')='Y' THEN
3220: g_score_until_thresh := true;
3221: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
3222: 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);
3223: END IF;

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

3536: and check_estimate_hits('PARTY',p_party_contains_str)>l_max_thresh THEN
3537: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
3538: 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);
3539: END IF;
3540: IF g_party_stage_rec.TX8 IS NOT NULL AND nvl(FND_PROFILE.VALUE('HZ_DQM_PN_THRESH_RESOLUTION'),'NONE')='SQL' THEN
3541: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
3542: 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);
3543: END IF;
3544: IF (l_party_site_contains_str IS NULL AND

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

3589: END IF;
3590: IF (l_party_id_idx-1)>l_max_thresh THEN
3591: IF p_index=1 AND call_order(2) = 'PARTY_SITE'
3592: AND call_type(2) = 'AND' AND l_contact_contains_str IS NULL
3593: AND nvl(FND_PROFILE.VALUE('HZ_DQM_PN_THRESH_RESOLUTION'),'NONE')='SQL'
3594: AND l_contact_pt_contains_str IS NULL THEN
3595: H_PARTY_ID.DELETE(l_party_id_idx-1);
3596: H_PARTY_ID_LIST.DELETE(l_index);
3597: H_SCORES.DELETE(l_index);

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

4130: END IF;
4131: 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);
4132: IF l_entered_max_score = 0 THEN l_entered_max_score:=1; END IF;
4133:
4134: l_max_thresh:=nvl(FND_PROFILE.VALUE('HZ_DQM_MAX_EVAL_THRESH'),200);
4135: IF nvl(FND_PROFILE.VALUE('HZ_DQM_SCORE_UNTIL_THRESH'),'N')='Y' THEN
4136: g_score_until_thresh := true;
4137: ELSE
4138: g_score_until_thresh := false;

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

4131: 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);
4132: IF l_entered_max_score = 0 THEN l_entered_max_score:=1; END IF;
4133:
4134: l_max_thresh:=nvl(FND_PROFILE.VALUE('HZ_DQM_MAX_EVAL_THRESH'),200);
4135: IF nvl(FND_PROFILE.VALUE('HZ_DQM_SCORE_UNTIL_THRESH'),'N')='Y' THEN
4136: g_score_until_thresh := true;
4137: ELSE
4138: g_score_until_thresh := false;
4139: END IF;

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

5817: l_use_contact_info varchar2(1);
5818: BEGIN
5819:
5820: l_use_contact_info := 'Y';
5821: IF nvl(FND_PROFILE.VALUE('HZ_DQM_REL_PARTY_MATCH'),'N')='Y' THEN
5822: l_use_contact_info := 'N';
5823: END IF;
5824: l_party_id := p_party_id;
5825: FOR PARTY_SITES IN (