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

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

2355: and check_estimate_hits('PARTY',p_party_contains_str)>l_max_thresh THEN
2356: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
2357: 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);
2358: END IF;
2359: 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
2360: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
2361: 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);
2362: END IF;
2363: IF (l_party_site_contains_str IS NULL AND

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

2413: END IF;
2414: IF (l_party_id_idx-1)>l_max_thresh THEN
2415: IF p_index=1 AND call_order(2) = 'PARTY_SITE'
2416: AND call_type(2) = 'AND' AND l_contact_contains_str IS NULL
2417: AND nvl(FND_PROFILE.VALUE('HZ_DQM_PN_THRESH_RESOLUTION'),'NONE')='SQL'
2418: AND l_contact_pt_contains_str IS NULL THEN
2419: EXIT;
2420: END IF;
2421: CLOSE l_party_cur;

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

3015:
3016: --End fix for bug 4417124
3017:
3018: IF p_dup_batch_id IS NOT NULL THEN
3019: l_max_thresh:=nvl(FND_PROFILE.VALUE('HZ_DQM_MAX_EVAL_THRESH_BATCH'),10000);
3020: ELSE
3021: l_max_thresh:=nvl(FND_PROFILE.VALUE('HZ_DQM_MAX_EVAL_THRESH'),200);
3022: END IF;
3023: IF nvl(FND_PROFILE.VALUE('HZ_DQM_SCORE_UNTIL_THRESH'),'N')='Y' THEN

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

3017:
3018: IF p_dup_batch_id IS NOT NULL THEN
3019: l_max_thresh:=nvl(FND_PROFILE.VALUE('HZ_DQM_MAX_EVAL_THRESH_BATCH'),10000);
3020: ELSE
3021: l_max_thresh:=nvl(FND_PROFILE.VALUE('HZ_DQM_MAX_EVAL_THRESH'),200);
3022: END IF;
3023: IF nvl(FND_PROFILE.VALUE('HZ_DQM_SCORE_UNTIL_THRESH'),'N')='Y' THEN
3024: g_score_until_thresh := true;
3025: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN

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

3019: l_max_thresh:=nvl(FND_PROFILE.VALUE('HZ_DQM_MAX_EVAL_THRESH_BATCH'),10000);
3020: ELSE
3021: l_max_thresh:=nvl(FND_PROFILE.VALUE('HZ_DQM_MAX_EVAL_THRESH'),200);
3022: END IF;
3023: IF nvl(FND_PROFILE.VALUE('HZ_DQM_SCORE_UNTIL_THRESH'),'N')='Y' THEN
3024: g_score_until_thresh := true;
3025: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
3026: 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);
3027: END IF;

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

3334: and check_estimate_hits('PARTY',p_party_contains_str)>l_max_thresh THEN
3335: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
3336: 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);
3337: END IF;
3338: IF g_party_stage_rec.TX8 IS NOT NULL AND nvl(FND_PROFILE.VALUE('HZ_DQM_PN_THRESH_RESOLUTION'),'NONE')='SQL' THEN
3339: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
3340: 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);
3341: END IF;
3342: IF (l_party_site_contains_str IS NULL AND

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

3389: END IF;
3390: IF (l_party_id_idx-1)>l_max_thresh THEN
3391: IF p_index=1 AND call_order(2) = 'PARTY_SITE'
3392: AND call_type(2) = 'AND' AND l_contact_contains_str IS NULL
3393: AND nvl(FND_PROFILE.VALUE('HZ_DQM_PN_THRESH_RESOLUTION'),'NONE')='SQL'
3394: AND l_contact_pt_contains_str IS NULL THEN
3395: H_PARTY_ID.DELETE(l_party_id_idx-1);
3396: H_PARTY_ID_LIST.DELETE(l_index);
3397: H_SCORES.DELETE(l_index);

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

3930: END IF;
3931: 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);
3932: IF l_entered_max_score = 0 THEN l_entered_max_score:=1; END IF;
3933:
3934: l_max_thresh:=nvl(FND_PROFILE.VALUE('HZ_DQM_MAX_EVAL_THRESH'),200);
3935: IF nvl(FND_PROFILE.VALUE('HZ_DQM_SCORE_UNTIL_THRESH'),'N')='Y' THEN
3936: g_score_until_thresh := true;
3937: ELSE
3938: g_score_until_thresh := false;

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

3931: 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);
3932: IF l_entered_max_score = 0 THEN l_entered_max_score:=1; END IF;
3933:
3934: l_max_thresh:=nvl(FND_PROFILE.VALUE('HZ_DQM_MAX_EVAL_THRESH'),200);
3935: IF nvl(FND_PROFILE.VALUE('HZ_DQM_SCORE_UNTIL_THRESH'),'N')='Y' THEN
3936: g_score_until_thresh := true;
3937: ELSE
3938: g_score_until_thresh := false;
3939: END IF;

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

5579: l_use_contact_info varchar2(1);
5580: BEGIN
5581:
5582: l_use_contact_info := 'Y';
5583: IF nvl(FND_PROFILE.VALUE('HZ_DQM_REL_PARTY_MATCH'),'N')='Y' THEN
5584: l_use_contact_info := 'N';
5585: END IF;
5586: l_party_id := p_party_id;
5587: FOR CONTACT_POINTS IN (