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

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

2478: and check_estimate_hits('PARTY',p_party_contains_str)>l_max_thresh THEN
2479: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
2480: 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);
2481: END IF;
2482: 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
2483: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
2484: 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);
2485: END IF;
2486: IF (l_party_site_contains_str IS NULL AND

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

2534: END IF;
2535: IF (l_party_id_idx-1)>l_max_thresh THEN
2536: IF p_index=1 AND call_order(2) = 'PARTY_SITE'
2537: AND call_type(2) = 'AND' AND l_contact_contains_str IS NULL
2538: AND nvl(FND_PROFILE.VALUE('HZ_DQM_PN_THRESH_RESOLUTION'),'NONE')='SQL'
2539: AND l_contact_pt_contains_str IS NULL THEN
2540: EXIT;
2541: END IF;
2542: CLOSE l_party_cur;

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

3066:
3067: --End fix for bug 4417124
3068:
3069: IF p_dup_batch_id IS NOT NULL THEN
3070: l_max_thresh:=nvl(FND_PROFILE.VALUE('HZ_DQM_MAX_EVAL_THRESH_BATCH'),10000);
3071: ELSE
3072: l_max_thresh:=nvl(FND_PROFILE.VALUE('HZ_DQM_MAX_EVAL_THRESH'),200);
3073: END IF;
3074: IF nvl(FND_PROFILE.VALUE('HZ_DQM_SCORE_UNTIL_THRESH'),'N')='Y' THEN

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

3068:
3069: IF p_dup_batch_id IS NOT NULL THEN
3070: l_max_thresh:=nvl(FND_PROFILE.VALUE('HZ_DQM_MAX_EVAL_THRESH_BATCH'),10000);
3071: ELSE
3072: l_max_thresh:=nvl(FND_PROFILE.VALUE('HZ_DQM_MAX_EVAL_THRESH'),200);
3073: END IF;
3074: IF nvl(FND_PROFILE.VALUE('HZ_DQM_SCORE_UNTIL_THRESH'),'N')='Y' THEN
3075: g_score_until_thresh := true;
3076: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN

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

3070: l_max_thresh:=nvl(FND_PROFILE.VALUE('HZ_DQM_MAX_EVAL_THRESH_BATCH'),10000);
3071: ELSE
3072: l_max_thresh:=nvl(FND_PROFILE.VALUE('HZ_DQM_MAX_EVAL_THRESH'),200);
3073: END IF;
3074: IF nvl(FND_PROFILE.VALUE('HZ_DQM_SCORE_UNTIL_THRESH'),'N')='Y' THEN
3075: g_score_until_thresh := true;
3076: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
3077: 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);
3078: END IF;

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

3419: and check_estimate_hits('PARTY',p_party_contains_str)>l_max_thresh THEN
3420: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
3421: 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);
3422: END IF;
3423: IF g_party_stage_rec.TX8 IS NOT NULL AND nvl(FND_PROFILE.VALUE('HZ_DQM_PN_THRESH_RESOLUTION'),'NONE')='SQL' THEN
3424: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
3425: 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);
3426: END IF;
3427: IF (l_party_site_contains_str IS NULL AND

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

3472: END IF;
3473: IF (l_party_id_idx-1)>l_max_thresh THEN
3474: IF p_index=1 AND call_order(2) = 'PARTY_SITE'
3475: AND call_type(2) = 'AND' AND l_contact_contains_str IS NULL
3476: AND nvl(FND_PROFILE.VALUE('HZ_DQM_PN_THRESH_RESOLUTION'),'NONE')='SQL'
3477: AND l_contact_pt_contains_str IS NULL THEN
3478: H_PARTY_ID.DELETE(l_party_id_idx-1);
3479: H_PARTY_ID_LIST.DELETE(l_index);
3480: H_SCORES.DELETE(l_index);

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

3918: END IF;
3919: 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);
3920: IF l_entered_max_score = 0 THEN l_entered_max_score:=1; END IF;
3921:
3922: l_max_thresh:=nvl(FND_PROFILE.VALUE('HZ_DQM_MAX_EVAL_THRESH'),200);
3923: IF nvl(FND_PROFILE.VALUE('HZ_DQM_SCORE_UNTIL_THRESH'),'N')='Y' THEN
3924: g_score_until_thresh := true;
3925: ELSE
3926: g_score_until_thresh := false;

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

3919: 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);
3920: IF l_entered_max_score = 0 THEN l_entered_max_score:=1; END IF;
3921:
3922: l_max_thresh:=nvl(FND_PROFILE.VALUE('HZ_DQM_MAX_EVAL_THRESH'),200);
3923: IF nvl(FND_PROFILE.VALUE('HZ_DQM_SCORE_UNTIL_THRESH'),'N')='Y' THEN
3924: g_score_until_thresh := true;
3925: ELSE
3926: g_score_until_thresh := false;
3927: END IF;

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

5618: l_use_contact_info varchar2(1);
5619: BEGIN
5620:
5621: l_use_contact_info := 'Y';
5622: IF nvl(FND_PROFILE.VALUE('HZ_DQM_REL_PARTY_MATCH'),'N')='Y' THEN
5623: l_use_contact_info := 'N';
5624: END IF;
5625: l_party_id := p_party_id;
5626: FOR PARTY_SITES IN (