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

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

2380: and check_estimate_hits('PARTY',p_party_contains_str)>l_max_thresh THEN
2381: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
2382: 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);
2383: END IF;
2384: 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
2385: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
2386: 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);
2387: END IF;
2388: IF (l_party_site_contains_str IS NULL AND

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

2436: END IF;
2437: IF (l_party_id_idx-1)>l_max_thresh THEN
2438: IF p_index=1 AND call_order(2) = 'PARTY_SITE'
2439: AND call_type(2) = 'AND' AND l_contact_contains_str IS NULL
2440: AND nvl(FND_PROFILE.VALUE('HZ_DQM_PN_THRESH_RESOLUTION'),'NONE')='SQL'
2441: AND l_contact_pt_contains_str IS NULL THEN
2442: EXIT;
2443: END IF;
2444: CLOSE l_party_cur;

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

2968:
2969: --End fix for bug 4417124
2970:
2971: IF p_dup_batch_id IS NOT NULL THEN
2972: l_max_thresh:=nvl(FND_PROFILE.VALUE('HZ_DQM_MAX_EVAL_THRESH_BATCH'),10000);
2973: ELSE
2974: l_max_thresh:=nvl(FND_PROFILE.VALUE('HZ_DQM_MAX_EVAL_THRESH'),200);
2975: END IF;
2976: IF nvl(FND_PROFILE.VALUE('HZ_DQM_SCORE_UNTIL_THRESH'),'N')='Y' THEN

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

2970:
2971: IF p_dup_batch_id IS NOT NULL THEN
2972: l_max_thresh:=nvl(FND_PROFILE.VALUE('HZ_DQM_MAX_EVAL_THRESH_BATCH'),10000);
2973: ELSE
2974: l_max_thresh:=nvl(FND_PROFILE.VALUE('HZ_DQM_MAX_EVAL_THRESH'),200);
2975: END IF;
2976: IF nvl(FND_PROFILE.VALUE('HZ_DQM_SCORE_UNTIL_THRESH'),'N')='Y' THEN
2977: g_score_until_thresh := true;
2978: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN

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

2972: l_max_thresh:=nvl(FND_PROFILE.VALUE('HZ_DQM_MAX_EVAL_THRESH_BATCH'),10000);
2973: ELSE
2974: l_max_thresh:=nvl(FND_PROFILE.VALUE('HZ_DQM_MAX_EVAL_THRESH'),200);
2975: END IF;
2976: IF nvl(FND_PROFILE.VALUE('HZ_DQM_SCORE_UNTIL_THRESH'),'N')='Y' THEN
2977: g_score_until_thresh := true;
2978: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
2979: 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);
2980: END IF;

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

3323: and check_estimate_hits('PARTY',p_party_contains_str)>l_max_thresh THEN
3324: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
3325: 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);
3326: END IF;
3327: IF g_party_stage_rec.TX8 IS NOT NULL AND nvl(FND_PROFILE.VALUE('HZ_DQM_PN_THRESH_RESOLUTION'),'NONE')='SQL' THEN
3328: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
3329: 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);
3330: END IF;
3331: IF (l_party_site_contains_str IS NULL AND

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

3376: END IF;
3377: IF (l_party_id_idx-1)>l_max_thresh THEN
3378: IF p_index=1 AND call_order(2) = 'PARTY_SITE'
3379: AND call_type(2) = 'AND' AND l_contact_contains_str IS NULL
3380: AND nvl(FND_PROFILE.VALUE('HZ_DQM_PN_THRESH_RESOLUTION'),'NONE')='SQL'
3381: AND l_contact_pt_contains_str IS NULL THEN
3382: H_PARTY_ID.DELETE(l_party_id_idx-1);
3383: H_PARTY_ID_LIST.DELETE(l_index);
3384: H_SCORES.DELETE(l_index);

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

3822: END IF;
3823: 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);
3824: IF l_entered_max_score = 0 THEN l_entered_max_score:=1; END IF;
3825:
3826: l_max_thresh:=nvl(FND_PROFILE.VALUE('HZ_DQM_MAX_EVAL_THRESH'),200);
3827: IF nvl(FND_PROFILE.VALUE('HZ_DQM_SCORE_UNTIL_THRESH'),'N')='Y' THEN
3828: g_score_until_thresh := true;
3829: ELSE
3830: g_score_until_thresh := false;

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

3823: 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);
3824: IF l_entered_max_score = 0 THEN l_entered_max_score:=1; END IF;
3825:
3826: l_max_thresh:=nvl(FND_PROFILE.VALUE('HZ_DQM_MAX_EVAL_THRESH'),200);
3827: IF nvl(FND_PROFILE.VALUE('HZ_DQM_SCORE_UNTIL_THRESH'),'N')='Y' THEN
3828: g_score_until_thresh := true;
3829: ELSE
3830: g_score_until_thresh := false;
3831: END IF;

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

5508: l_use_contact_info varchar2(1);
5509: BEGIN
5510:
5511: l_use_contact_info := 'Y';
5512: IF nvl(FND_PROFILE.VALUE('HZ_DQM_REL_PARTY_MATCH'),'N')='Y' THEN
5513: l_use_contact_info := 'N';
5514: END IF;
5515: l_party_id := null;
5516: FOR PARTY_SITES IN (