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

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

3013: and check_estimate_hits('PARTY',p_party_contains_str)>l_max_thresh THEN
3014: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
3015: 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);
3016: END IF;
3017: 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
3018: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
3019: 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);
3020: END IF;
3021: IF (l_party_site_contains_str IS NULL AND

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

3069: END IF;
3070: IF (l_party_id_idx-1)>l_max_thresh THEN
3071: IF p_index=1 AND call_order(2) = 'PARTY_SITE'
3072: AND call_type(2) = 'AND' AND l_contact_contains_str IS NULL
3073: AND nvl(FND_PROFILE.VALUE('HZ_DQM_PN_THRESH_RESOLUTION'),'NONE')='SQL'
3074: AND l_contact_pt_contains_str IS NULL THEN
3075: EXIT;
3076: END IF;
3077: CLOSE l_party_cur;

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

3671:
3672: --End fix for bug 4417124
3673:
3674: IF p_dup_batch_id IS NOT NULL THEN
3675: l_max_thresh:=nvl(FND_PROFILE.VALUE('HZ_DQM_MAX_EVAL_THRESH_BATCH'),10000);
3676: ELSE
3677: l_max_thresh:=nvl(FND_PROFILE.VALUE('HZ_DQM_MAX_EVAL_THRESH'),200);
3678: END IF;
3679: IF nvl(FND_PROFILE.VALUE('HZ_DQM_SCORE_UNTIL_THRESH'),'N')='Y' THEN

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

3673:
3674: IF p_dup_batch_id IS NOT NULL THEN
3675: l_max_thresh:=nvl(FND_PROFILE.VALUE('HZ_DQM_MAX_EVAL_THRESH_BATCH'),10000);
3676: ELSE
3677: l_max_thresh:=nvl(FND_PROFILE.VALUE('HZ_DQM_MAX_EVAL_THRESH'),200);
3678: END IF;
3679: IF nvl(FND_PROFILE.VALUE('HZ_DQM_SCORE_UNTIL_THRESH'),'N')='Y' THEN
3680: g_score_until_thresh := true;
3681: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN

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

3675: l_max_thresh:=nvl(FND_PROFILE.VALUE('HZ_DQM_MAX_EVAL_THRESH_BATCH'),10000);
3676: ELSE
3677: l_max_thresh:=nvl(FND_PROFILE.VALUE('HZ_DQM_MAX_EVAL_THRESH'),200);
3678: END IF;
3679: IF nvl(FND_PROFILE.VALUE('HZ_DQM_SCORE_UNTIL_THRESH'),'N')='Y' THEN
3680: g_score_until_thresh := true;
3681: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
3682: 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);
3683: END IF;

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

4003: and check_estimate_hits('PARTY',p_party_contains_str)>l_max_thresh THEN
4004: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
4005: 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);
4006: END IF;
4007: IF g_party_stage_rec.TX8 IS NOT NULL AND nvl(FND_PROFILE.VALUE('HZ_DQM_PN_THRESH_RESOLUTION'),'NONE')='SQL' THEN
4008: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
4009: 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);
4010: END IF;
4011: IF (l_party_site_contains_str IS NULL AND

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

4056: END IF;
4057: IF (l_party_id_idx-1)>l_max_thresh THEN
4058: IF p_index=1 AND call_order(2) = 'PARTY_SITE'
4059: AND call_type(2) = 'AND' AND l_contact_contains_str IS NULL
4060: AND nvl(FND_PROFILE.VALUE('HZ_DQM_PN_THRESH_RESOLUTION'),'NONE')='SQL'
4061: AND l_contact_pt_contains_str IS NULL THEN
4062: H_PARTY_ID.DELETE(l_party_id_idx-1);
4063: H_PARTY_ID_LIST.DELETE(l_index);
4064: H_SCORES.DELETE(l_index);

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

4597: END IF;
4598: 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);
4599: IF l_entered_max_score = 0 THEN l_entered_max_score:=1; END IF;
4600:
4601: l_max_thresh:=nvl(FND_PROFILE.VALUE('HZ_DQM_MAX_EVAL_THRESH'),200);
4602: IF nvl(FND_PROFILE.VALUE('HZ_DQM_SCORE_UNTIL_THRESH'),'N')='Y' THEN
4603: g_score_until_thresh := true;
4604: ELSE
4605: g_score_until_thresh := false;

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

4598: 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);
4599: IF l_entered_max_score = 0 THEN l_entered_max_score:=1; END IF;
4600:
4601: l_max_thresh:=nvl(FND_PROFILE.VALUE('HZ_DQM_MAX_EVAL_THRESH'),200);
4602: IF nvl(FND_PROFILE.VALUE('HZ_DQM_SCORE_UNTIL_THRESH'),'N')='Y' THEN
4603: g_score_until_thresh := true;
4604: ELSE
4605: g_score_until_thresh := false;
4606: END IF;

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

6376: l_use_contact_info varchar2(1);
6377: BEGIN
6378:
6379: l_use_contact_info := 'Y';
6380: IF nvl(FND_PROFILE.VALUE('HZ_DQM_REL_PARTY_MATCH'),'N')='Y' THEN
6381: l_use_contact_info := 'N';
6382: END IF;
6383: l_party_id := p_party_id;
6384: FOR PARTY_SITES IN (