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

Line 167: IF nvl(FND_PROFILE.VALUE('HZ_DQM_DEV_DEBUG'), 'N') = 'N'

163:
164: /*** Private procedure for inserting statement , procedure level debug start lines into generated packages **/
165: PROCEDURE ds(p_msg_level NUMBER,pad VARCHAR2 DEFAULT ' ') IS
166: BEGIN
167: IF nvl(FND_PROFILE.VALUE('HZ_DQM_DEV_DEBUG'), 'N') = 'N'
168: THEN
169: IF p_msg_level=FND_LOG.LEVEL_STATEMENT THEN
170: l(pad||'IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN');
171: ELSIF p_msg_level=FND_LOG.LEVEL_PROCEDURE THEN

Line 183: IF nvl(FND_PROFILE.VALUE('HZ_DQM_DEV_DEBUG'), 'N') = 'N'

179: /*** Private procedure for inserting statement , procedure level debug content lines into generated packages **/
180: PROCEDURE dc(p_msg_level NUMBER,str VARCHAR2, val VARCHAR2 DEFAULT NULL, pad VARCHAR2 DEFAULT ' ') IS
181: l_msg_level VARCHAR2(30);
182: BEGIN
183: IF nvl(FND_PROFILE.VALUE('HZ_DQM_DEV_DEBUG'), 'N') = 'N'
184: THEN
185: IF p_msg_level=FND_LOG.LEVEL_STATEMENT THEN
186: l_msg_level :='fnd_log.level_statement';
187: ELSIF p_msg_level=FND_LOG.LEVEL_PROCEDURE THEN

Line 213: IF nvl(FND_PROFILE.VALUE('HZ_DQM_DEV_DEBUG'), 'N') = 'N'

209:
210: /*** Private procedure for inserting statement , procedure level debug end lines into generated packages **/
211: PROCEDURE de(pad VARCHAR2 DEFAULT ' ') IS
212: BEGIN
213: IF nvl(FND_PROFILE.VALUE('HZ_DQM_DEV_DEBUG'), 'N') = 'N'
214: THEN
215: l(pad||'END IF;');
216: END IF;
217: END;

Line 304: IF nvl(FND_PROFILE.VALUE('HZ_DQM_DEV_DEBUG'), 'N') = 'Y'

300:
301: PROCEDURE ldbg_procedure
302: IS
303: BEGIN
304: IF nvl(FND_PROFILE.VALUE('HZ_DQM_DEV_DEBUG'), 'N') = 'Y'
305: THEN
306: l('');
307: l('PROCEDURE output_long_strings(input_str VARCHAR2 DEFAULT NULL)');
308: l('IS');

Line 879: l(' IF (fnd_profile.value(''HZ_QUALITY_WEIGHTING_USER_HOOK'') = ''Y'') THEN ');

875: END LOOP;
876: l(' END IF;');
877: -- Quality Score
878: l(' -- User quality score ');
879: l(' IF (fnd_profile.value(''HZ_QUALITY_WEIGHTING_USER_HOOK'') = ''Y'') THEN ');
880: l(' HZ_DQM_SEARCH_UTIL.get_quality_score ( x_search_ctx_id, p_rule_id); ');
881: l(' END IF; ');
882:
883: d(fnd_log.level_procedure,'find_parties(-)');

Line 2242: l(' IF fnd_profile.value(''HZ_API_FILE_DEBUG_ON'') = ''Y'' OR');

2238: l(' BEGIN');
2239: l(' g_debug_count := g_debug_count + 1;');
2240:
2241: l(' IF g_debug_count = 1 THEN');
2242: l(' IF fnd_profile.value(''HZ_API_FILE_DEBUG_ON'') = ''Y'' OR');
2243: l(' fnd_profile.value(''HZ_API_DBMS_DEBUG_ON'') = ''Y''');
2244: l(' THEN');
2245: l(' hz_utility_v2pub.enable_debug;');
2246: l(' g_debug := TRUE;');

Line 2243: l(' fnd_profile.value(''HZ_API_DBMS_DEBUG_ON'') = ''Y''');

2239: l(' g_debug_count := g_debug_count + 1;');
2240:
2241: l(' IF g_debug_count = 1 THEN');
2242: l(' IF fnd_profile.value(''HZ_API_FILE_DEBUG_ON'') = ''Y'' OR');
2243: l(' fnd_profile.value(''HZ_API_DBMS_DEBUG_ON'') = ''Y''');
2244: l(' THEN');
2245: l(' hz_utility_v2pub.enable_debug;');
2246: l(' g_debug := TRUE;');
2247: l(' END IF;');

Line 4984: l(' 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');

4980: l(' ELSE');
4981: l(' IF (p_restrict_sql IS NULL OR instrb(p_restrict_sql, ''SELECTIVE'')=0)');
4982: l(' and check_estimate_hits(''PARTY'',p_party_contains_str)>l_max_thresh THEN');
4983: ldbg_s('In eval party level estimated hits exceed threshold');
4984: l(' 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');
4985: ldbg_s('In eval party level resolution options is set to SQL search.');
4986: l(' IF (l_party_site_contains_str IS NULL AND');
4987: l(' l_contact_contains_str IS NULL AND');
4988: l(' l_contact_pt_contains_str IS NULL) AND NOT g_other_party_level_attribs AND p_dup_set_id IS NULL THEN');

Line 5040: l(' AND nvl(FND_PROFILE.VALUE(''HZ_DQM_PN_THRESH_RESOLUTION''),''NONE'')=''SQL'' ');

5036: l(' END IF;');
5037: l(' IF (l_party_id_idx-1)>l_max_thresh THEN');
5038: l(' IF p_index=1 AND call_order(2) = ''PARTY_SITE'' ');
5039: l(' AND call_type(2) = ''AND'' AND l_contact_contains_str IS NULL');
5040: l(' AND nvl(FND_PROFILE.VALUE(''HZ_DQM_PN_THRESH_RESOLUTION''),''NONE'')=''SQL'' ');
5041: l(' AND l_contact_pt_contains_str IS NULL THEN');
5042: l(' EXIT;');
5043: l(' END IF;');
5044: l(' CLOSE l_party_cur;'); --Bug No: 3872745

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

5590: l('');
5591: l(' --End fix for bug 4417124');
5592: l('');
5593: l(' IF p_dup_batch_id IS NOT NULL THEN');
5594: l(' l_max_thresh:=nvl(FND_PROFILE.VALUE(''HZ_DQM_MAX_EVAL_THRESH_BATCH''),10000);');
5595: l(' ELSE');
5596: l(' l_max_thresh:=nvl(FND_PROFILE.VALUE(''HZ_DQM_MAX_EVAL_THRESH''),200);');
5597: l(' END IF;');
5598:

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

5592: l('');
5593: l(' IF p_dup_batch_id IS NOT NULL THEN');
5594: l(' l_max_thresh:=nvl(FND_PROFILE.VALUE(''HZ_DQM_MAX_EVAL_THRESH_BATCH''),10000);');
5595: l(' ELSE');
5596: l(' l_max_thresh:=nvl(FND_PROFILE.VALUE(''HZ_DQM_MAX_EVAL_THRESH''),200);');
5597: l(' END IF;');
5598:
5599: l(' IF nvl(FND_PROFILE.VALUE(''HZ_DQM_SCORE_UNTIL_THRESH''),''N'')=''Y'' THEN');
5600: l(' g_score_until_thresh := true;');

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

5595: l(' ELSE');
5596: l(' l_max_thresh:=nvl(FND_PROFILE.VALUE(''HZ_DQM_MAX_EVAL_THRESH''),200);');
5597: l(' END IF;');
5598:
5599: l(' IF nvl(FND_PROFILE.VALUE(''HZ_DQM_SCORE_UNTIL_THRESH''),''N'')=''Y'' THEN');
5600: l(' g_score_until_thresh := true;');
5601: ldbg_s('g_score_until_thresh is true');
5602: l(' ELSE');
5603: l(' g_score_until_thresh := false;');

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

6004: l(' ELSE');
6005: l(' IF (p_restrict_sql IS NULL OR instrb(p_restrict_sql, ''SELECTIVE'')=0)');
6006: l(' and check_estimate_hits(''PARTY'',p_party_contains_str)>l_max_thresh THEN');
6007: ldbg_s('In eval party level estimated hits exceed threshold');
6008: l(' IF g_party_stage_rec.TX8 IS NOT NULL AND nvl(FND_PROFILE.VALUE(''HZ_DQM_PN_THRESH_RESOLUTION''),''NONE'')=''SQL'' THEN');
6009: ldbg_s('In eval party level resolution option is set to SQL search.');
6010: l(' IF (l_party_site_contains_str IS NULL AND');
6011: l(' l_contact_contains_str IS NULL AND');
6012: l(' l_contact_pt_contains_str IS NULL) AND NOT g_other_party_level_attribs IS NULL THEN');

Line 6063: l(' AND nvl(FND_PROFILE.VALUE(''HZ_DQM_PN_THRESH_RESOLUTION''),''NONE'')=''SQL'' ');

6059: l(' END IF;');
6060: l(' IF (l_party_id_idx-1)>l_max_thresh THEN');
6061: l(' IF p_index=1 AND call_order(2) = ''PARTY_SITE'' ');
6062: l(' AND call_type(2) = ''AND'' AND l_contact_contains_str IS NULL');
6063: l(' AND nvl(FND_PROFILE.VALUE(''HZ_DQM_PN_THRESH_RESOLUTION''),''NONE'')=''SQL'' ');
6064: l(' AND l_contact_pt_contains_str IS NULL THEN');
6065: l(' H_PARTY_ID.DELETE(l_party_id_idx-1);');
6066: l(' H_PARTY_ID_LIST.DELETE(l_index);');
6067: l(' H_SCORES.DELETE(l_index);');

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

6580: l(' END IF;');
6581: l(' 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);');
6582: l(' IF l_entered_max_score = 0 THEN l_entered_max_score:=1; END IF;');
6583: l('');
6584: l(' l_max_thresh:=nvl(FND_PROFILE.VALUE(''HZ_DQM_MAX_EVAL_THRESH''),200);');
6585: l(' IF nvl(FND_PROFILE.VALUE(''HZ_DQM_SCORE_UNTIL_THRESH''),''N'')=''Y'' THEN');
6586: l(' g_score_until_thresh := true;');
6587: l(' ELSE');
6588: l(' g_score_until_thresh := false;');

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

6581: l(' 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);');
6582: l(' IF l_entered_max_score = 0 THEN l_entered_max_score:=1; END IF;');
6583: l('');
6584: l(' l_max_thresh:=nvl(FND_PROFILE.VALUE(''HZ_DQM_MAX_EVAL_THRESH''),200);');
6585: l(' IF nvl(FND_PROFILE.VALUE(''HZ_DQM_SCORE_UNTIL_THRESH''),''N'')=''Y'' THEN');
6586: l(' g_score_until_thresh := true;');
6587: l(' ELSE');
6588: l(' g_score_until_thresh := false;');
6589: l(' END IF;');

Line 8454: l(' IF fnd_profile.value(''HZ_API_FILE_DEBUG_ON'') = ''Y'' OR');

8450: l(' BEGIN');
8451: l(' g_debug_count := g_debug_count + 1;');
8452:
8453: l(' IF g_debug_count = 1 THEN');
8454: l(' IF fnd_profile.value(''HZ_API_FILE_DEBUG_ON'') = ''Y'' OR');
8455: l(' fnd_profile.value(''HZ_API_DBMS_DEBUG_ON'') = ''Y''');
8456: l(' THEN');
8457: l(' hz_utility_v2pub.enable_debug;');
8458: l(' g_debug := TRUE;');

Line 8455: l(' fnd_profile.value(''HZ_API_DBMS_DEBUG_ON'') = ''Y''');

8451: l(' g_debug_count := g_debug_count + 1;');
8452:
8453: l(' IF g_debug_count = 1 THEN');
8454: l(' IF fnd_profile.value(''HZ_API_FILE_DEBUG_ON'') = ''Y'' OR');
8455: l(' fnd_profile.value(''HZ_API_DBMS_DEBUG_ON'') = ''Y''');
8456: l(' THEN');
8457: l(' hz_utility_v2pub.enable_debug;');
8458: l(' g_debug := TRUE;');
8459: d('PKG: '||p_pkg_name||' (+)');

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

10242: l(' END IF; ');
10243: l('');
10244: l(' --End fix for bug 4417124');
10245: l('');
10246: l(' l_max_thresh:=nvl(FND_PROFILE.VALUE(''HZ_DQM_MAX_EVAL_THRESH''),200);');
10247: l(' IF nvl(FND_PROFILE.VALUE(''HZ_DQM_SCORE_UNTIL_THRESH''),''N'')=''Y'' THEN');
10248: l(' g_score_until_thresh := true;');
10249: l(' ELSE');
10250: l(' g_score_until_thresh := false;');

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

10243: l('');
10244: l(' --End fix for bug 4417124');
10245: l('');
10246: l(' l_max_thresh:=nvl(FND_PROFILE.VALUE(''HZ_DQM_MAX_EVAL_THRESH''),200);');
10247: l(' IF nvl(FND_PROFILE.VALUE(''HZ_DQM_SCORE_UNTIL_THRESH''),''N'')=''Y'' THEN');
10248: l(' g_score_until_thresh := true;');
10249: l(' ELSE');
10250: l(' g_score_until_thresh := false;');
10251: l(' END IF;');

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

11046: l(' SAVEPOINT find_persons;');
11047: l(' 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);');
11048: l(' IF l_entered_max_score = 0 THEN l_entered_max_score:=1; END IF;');
11049: l('');
11050: l(' l_max_thresh:=nvl(FND_PROFILE.VALUE(''HZ_DQM_MAX_EVAL_THRESH''),200);');
11051: l(' IF nvl(FND_PROFILE.VALUE(''HZ_DQM_SCORE_UNTIL_THRESH''),''N'')=''Y'' THEN');
11052: l(' g_score_until_thresh := true;');
11053: l(' ELSE');
11054: l(' g_score_until_thresh := false;');

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

11047: l(' 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);');
11048: l(' IF l_entered_max_score = 0 THEN l_entered_max_score:=1; END IF;');
11049: l('');
11050: l(' l_max_thresh:=nvl(FND_PROFILE.VALUE(''HZ_DQM_MAX_EVAL_THRESH''),200);');
11051: l(' IF nvl(FND_PROFILE.VALUE(''HZ_DQM_SCORE_UNTIL_THRESH''),''N'')=''Y'' THEN');
11052: l(' g_score_until_thresh := true;');
11053: l(' ELSE');
11054: l(' g_score_until_thresh := false;');
11055: l(' END IF;');

Line 12762: l(' IF fnd_profile.value(''HZ_API_FILE_DEBUG_ON'') = ''Y'' OR');

12758: l(' BEGIN');
12759: l(' g_debug_count := g_debug_count + 1;');
12760:
12761: l(' IF g_debug_count = 1 THEN');
12762: l(' IF fnd_profile.value(''HZ_API_FILE_DEBUG_ON'') = ''Y'' OR');
12763: l(' fnd_profile.value(''HZ_API_DBMS_DEBUG_ON'') = ''Y''');
12764: l(' THEN');
12765: l(' hz_utility_v2pub.enable_debug;');
12766: l(' g_debug := TRUE;');

Line 12763: l(' fnd_profile.value(''HZ_API_DBMS_DEBUG_ON'') = ''Y''');

12759: l(' g_debug_count := g_debug_count + 1;');
12760:
12761: l(' IF g_debug_count = 1 THEN');
12762: l(' IF fnd_profile.value(''HZ_API_FILE_DEBUG_ON'') = ''Y'' OR');
12763: l(' fnd_profile.value(''HZ_API_DBMS_DEBUG_ON'') = ''Y''');
12764: l(' THEN');
12765: l(' hz_utility_v2pub.enable_debug;');
12766: l(' g_debug := TRUE;');
12767: d('PKG: '||p_pkg_name||' (+)');

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

14222: l('');
14223:
14224: --bug 5169483
14225: l(' l_use_contact_info := ''Y'';');
14226: l(' IF nvl(FND_PROFILE.VALUE(''HZ_DQM_REL_PARTY_MATCH''),''N'')=''Y'' THEN');
14227: l(' l_use_contact_info := ''N'';');
14228: l(' END IF;');
14229: --bug 5169483
14230: