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

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

2629: and check_estimate_hits('PARTY',p_party_contains_str)>l_max_thresh THEN
2630: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
2631: 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);
2632: END IF;
2633: 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
2634: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
2635: 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);
2636: END IF;
2637: IF (l_party_site_contains_str IS NULL AND

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

2685: END IF;
2686: IF (l_party_id_idx-1)>l_max_thresh THEN
2687: IF p_index=1 AND call_order(2) = 'PARTY_SITE'
2688: AND call_type(2) = 'AND' AND l_contact_contains_str IS NULL
2689: AND nvl(FND_PROFILE.VALUE('HZ_DQM_PN_THRESH_RESOLUTION'),'NONE')='SQL'
2690: AND l_contact_pt_contains_str IS NULL THEN
2691: EXIT;
2692: END IF;
2693: CLOSE l_party_cur;

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

3287:
3288: --End fix for bug 4417124
3289:
3290: IF p_dup_batch_id IS NOT NULL THEN
3291: l_max_thresh:=nvl(FND_PROFILE.VALUE('HZ_DQM_MAX_EVAL_THRESH_BATCH'),10000);
3292: ELSE
3293: l_max_thresh:=nvl(FND_PROFILE.VALUE('HZ_DQM_MAX_EVAL_THRESH'),200);
3294: END IF;
3295: IF nvl(FND_PROFILE.VALUE('HZ_DQM_SCORE_UNTIL_THRESH'),'N')='Y' THEN

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

3289:
3290: IF p_dup_batch_id IS NOT NULL THEN
3291: l_max_thresh:=nvl(FND_PROFILE.VALUE('HZ_DQM_MAX_EVAL_THRESH_BATCH'),10000);
3292: ELSE
3293: l_max_thresh:=nvl(FND_PROFILE.VALUE('HZ_DQM_MAX_EVAL_THRESH'),200);
3294: END IF;
3295: IF nvl(FND_PROFILE.VALUE('HZ_DQM_SCORE_UNTIL_THRESH'),'N')='Y' THEN
3296: g_score_until_thresh := true;
3297: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN

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

3291: l_max_thresh:=nvl(FND_PROFILE.VALUE('HZ_DQM_MAX_EVAL_THRESH_BATCH'),10000);
3292: ELSE
3293: l_max_thresh:=nvl(FND_PROFILE.VALUE('HZ_DQM_MAX_EVAL_THRESH'),200);
3294: END IF;
3295: IF nvl(FND_PROFILE.VALUE('HZ_DQM_SCORE_UNTIL_THRESH'),'N')='Y' THEN
3296: g_score_until_thresh := true;
3297: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
3298: 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);
3299: END IF;

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

3612: and check_estimate_hits('PARTY',p_party_contains_str)>l_max_thresh THEN
3613: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
3614: 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);
3615: END IF;
3616: IF g_party_stage_rec.TX8 IS NOT NULL AND nvl(FND_PROFILE.VALUE('HZ_DQM_PN_THRESH_RESOLUTION'),'NONE')='SQL' THEN
3617: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
3618: 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);
3619: END IF;
3620: IF (l_party_site_contains_str IS NULL AND

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

3665: END IF;
3666: IF (l_party_id_idx-1)>l_max_thresh THEN
3667: IF p_index=1 AND call_order(2) = 'PARTY_SITE'
3668: AND call_type(2) = 'AND' AND l_contact_contains_str IS NULL
3669: AND nvl(FND_PROFILE.VALUE('HZ_DQM_PN_THRESH_RESOLUTION'),'NONE')='SQL'
3670: AND l_contact_pt_contains_str IS NULL THEN
3671: H_PARTY_ID.DELETE(l_party_id_idx-1);
3672: H_PARTY_ID_LIST.DELETE(l_index);
3673: H_SCORES.DELETE(l_index);

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

4206: END IF;
4207: 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);
4208: IF l_entered_max_score = 0 THEN l_entered_max_score:=1; END IF;
4209:
4210: l_max_thresh:=nvl(FND_PROFILE.VALUE('HZ_DQM_MAX_EVAL_THRESH'),200);
4211: IF nvl(FND_PROFILE.VALUE('HZ_DQM_SCORE_UNTIL_THRESH'),'N')='Y' THEN
4212: g_score_until_thresh := true;
4213: ELSE
4214: g_score_until_thresh := false;

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

4207: 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);
4208: IF l_entered_max_score = 0 THEN l_entered_max_score:=1; END IF;
4209:
4210: l_max_thresh:=nvl(FND_PROFILE.VALUE('HZ_DQM_MAX_EVAL_THRESH'),200);
4211: IF nvl(FND_PROFILE.VALUE('HZ_DQM_SCORE_UNTIL_THRESH'),'N')='Y' THEN
4212: g_score_until_thresh := true;
4213: ELSE
4214: g_score_until_thresh := false;
4215: END IF;

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

5937: l_use_contact_info varchar2(1);
5938: BEGIN
5939:
5940: l_use_contact_info := 'Y';
5941: IF nvl(FND_PROFILE.VALUE('HZ_DQM_REL_PARTY_MATCH'),'N')='Y' THEN
5942: l_use_contact_info := 'N';
5943: END IF;
5944: l_party_id := p_party_id;
5945: FOR PARTY_SITES IN (