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 4974: 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');

4970: l(' ELSE');
4971: l(' IF (p_restrict_sql IS NULL OR instrb(p_restrict_sql, ''SELECTIVE'')=0)');
4972: l(' and check_estimate_hits(''PARTY'',p_party_contains_str)>l_max_thresh THEN');
4973: ldbg_s('In eval party level estimated hits exceed threshold');
4974: 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');
4975: ldbg_s('In eval party level resolution options is set to SQL search.');
4976: l(' IF (l_party_site_contains_str IS NULL AND');
4977: l(' l_contact_contains_str IS NULL AND');
4978: l(' l_contact_pt_contains_str IS NULL) AND NOT g_other_party_level_attribs AND p_dup_set_id IS NULL THEN');

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

5021: l(' END IF;');
5022: l(' IF (l_party_id_idx-1)>l_max_thresh THEN');
5023: l(' IF p_index=1 AND call_order(2) = ''PARTY_SITE'' ');
5024: l(' AND call_type(2) = ''AND'' AND l_contact_contains_str IS NULL');
5025: l(' AND nvl(FND_PROFILE.VALUE(''HZ_DQM_PN_THRESH_RESOLUTION''),''NONE'')=''SQL'' ');
5026: l(' AND l_contact_pt_contains_str IS NULL THEN');
5027: l(' EXIT;');
5028: l(' END IF;');
5029: l(' CLOSE l_party_cur;'); --Bug No: 3872745

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

5575: l('');
5576: l(' --End fix for bug 4417124');
5577: l('');
5578: l(' IF p_dup_batch_id IS NOT NULL THEN');
5579: l(' l_max_thresh:=nvl(FND_PROFILE.VALUE(''HZ_DQM_MAX_EVAL_THRESH_BATCH''),10000);');
5580: l(' ELSE');
5581: l(' l_max_thresh:=nvl(FND_PROFILE.VALUE(''HZ_DQM_MAX_EVAL_THRESH''),200);');
5582: l(' END IF;');
5583:

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

5577: l('');
5578: l(' IF p_dup_batch_id IS NOT NULL THEN');
5579: l(' l_max_thresh:=nvl(FND_PROFILE.VALUE(''HZ_DQM_MAX_EVAL_THRESH_BATCH''),10000);');
5580: l(' ELSE');
5581: l(' l_max_thresh:=nvl(FND_PROFILE.VALUE(''HZ_DQM_MAX_EVAL_THRESH''),200);');
5582: l(' END IF;');
5583:
5584: l(' IF nvl(FND_PROFILE.VALUE(''HZ_DQM_SCORE_UNTIL_THRESH''),''N'')=''Y'' THEN');
5585: l(' g_score_until_thresh := true;');

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

5580: l(' ELSE');
5581: l(' l_max_thresh:=nvl(FND_PROFILE.VALUE(''HZ_DQM_MAX_EVAL_THRESH''),200);');
5582: l(' END IF;');
5583:
5584: l(' IF nvl(FND_PROFILE.VALUE(''HZ_DQM_SCORE_UNTIL_THRESH''),''N'')=''Y'' THEN');
5585: l(' g_score_until_thresh := true;');
5586: ldbg_s('g_score_until_thresh is true');
5587: l(' ELSE');
5588: l(' g_score_until_thresh := false;');

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

5980: l(' ELSE');
5981: l(' IF (p_restrict_sql IS NULL OR instrb(p_restrict_sql, ''SELECTIVE'')=0)');
5982: l(' and check_estimate_hits(''PARTY'',p_party_contains_str)>l_max_thresh THEN');
5983: ldbg_s('In eval party level estimated hits exceed threshold');
5984: l(' IF g_party_stage_rec.TX8 IS NOT NULL AND nvl(FND_PROFILE.VALUE(''HZ_DQM_PN_THRESH_RESOLUTION''),''NONE'')=''SQL'' THEN');
5985: ldbg_s('In eval party level resolution option is set to SQL search.');
5986: l(' IF (l_party_site_contains_str IS NULL AND');
5987: l(' l_contact_contains_str IS NULL AND');
5988: l(' l_contact_pt_contains_str IS NULL) AND NOT g_other_party_level_attribs IS NULL THEN');

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

6030: l(' END IF;');
6031: l(' IF (l_party_id_idx-1)>l_max_thresh THEN');
6032: l(' IF p_index=1 AND call_order(2) = ''PARTY_SITE'' ');
6033: l(' AND call_type(2) = ''AND'' AND l_contact_contains_str IS NULL');
6034: l(' AND nvl(FND_PROFILE.VALUE(''HZ_DQM_PN_THRESH_RESOLUTION''),''NONE'')=''SQL'' ');
6035: l(' AND l_contact_pt_contains_str IS NULL THEN');
6036: l(' H_PARTY_ID.DELETE(l_party_id_idx-1);');
6037: l(' H_PARTY_ID_LIST.DELETE(l_index);');
6038: l(' H_SCORES.DELETE(l_index);');

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

6551: l(' END IF;');
6552: 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);');
6553: l(' IF l_entered_max_score = 0 THEN l_entered_max_score:=1; END IF;');
6554: l('');
6555: l(' l_max_thresh:=nvl(FND_PROFILE.VALUE(''HZ_DQM_MAX_EVAL_THRESH''),200);');
6556: l(' IF nvl(FND_PROFILE.VALUE(''HZ_DQM_SCORE_UNTIL_THRESH''),''N'')=''Y'' THEN');
6557: l(' g_score_until_thresh := true;');
6558: l(' ELSE');
6559: l(' g_score_until_thresh := false;');

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

6552: 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);');
6553: l(' IF l_entered_max_score = 0 THEN l_entered_max_score:=1; END IF;');
6554: l('');
6555: l(' l_max_thresh:=nvl(FND_PROFILE.VALUE(''HZ_DQM_MAX_EVAL_THRESH''),200);');
6556: l(' IF nvl(FND_PROFILE.VALUE(''HZ_DQM_SCORE_UNTIL_THRESH''),''N'')=''Y'' THEN');
6557: l(' g_score_until_thresh := true;');
6558: l(' ELSE');
6559: l(' g_score_until_thresh := false;');
6560: l(' END IF;');

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

8404: l(' BEGIN');
8405: l(' g_debug_count := g_debug_count + 1;');
8406:
8407: l(' IF g_debug_count = 1 THEN');
8408: l(' IF fnd_profile.value(''HZ_API_FILE_DEBUG_ON'') = ''Y'' OR');
8409: l(' fnd_profile.value(''HZ_API_DBMS_DEBUG_ON'') = ''Y''');
8410: l(' THEN');
8411: l(' hz_utility_v2pub.enable_debug;');
8412: l(' g_debug := TRUE;');

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

8405: l(' g_debug_count := g_debug_count + 1;');
8406:
8407: l(' IF g_debug_count = 1 THEN');
8408: l(' IF fnd_profile.value(''HZ_API_FILE_DEBUG_ON'') = ''Y'' OR');
8409: l(' fnd_profile.value(''HZ_API_DBMS_DEBUG_ON'') = ''Y''');
8410: l(' THEN');
8411: l(' hz_utility_v2pub.enable_debug;');
8412: l(' g_debug := TRUE;');
8413: d('PKG: '||p_pkg_name||' (+)');

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

10196: l(' END IF; ');
10197: l('');
10198: l(' --End fix for bug 4417124');
10199: l('');
10200: l(' l_max_thresh:=nvl(FND_PROFILE.VALUE(''HZ_DQM_MAX_EVAL_THRESH''),200);');
10201: l(' IF nvl(FND_PROFILE.VALUE(''HZ_DQM_SCORE_UNTIL_THRESH''),''N'')=''Y'' THEN');
10202: l(' g_score_until_thresh := true;');
10203: l(' ELSE');
10204: l(' g_score_until_thresh := false;');

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

10197: l('');
10198: l(' --End fix for bug 4417124');
10199: l('');
10200: l(' l_max_thresh:=nvl(FND_PROFILE.VALUE(''HZ_DQM_MAX_EVAL_THRESH''),200);');
10201: l(' IF nvl(FND_PROFILE.VALUE(''HZ_DQM_SCORE_UNTIL_THRESH''),''N'')=''Y'' THEN');
10202: l(' g_score_until_thresh := true;');
10203: l(' ELSE');
10204: l(' g_score_until_thresh := false;');
10205: l(' END IF;');

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

10990: l(' SAVEPOINT find_persons;');
10991: 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);');
10992: l(' IF l_entered_max_score = 0 THEN l_entered_max_score:=1; END IF;');
10993: l('');
10994: l(' l_max_thresh:=nvl(FND_PROFILE.VALUE(''HZ_DQM_MAX_EVAL_THRESH''),200);');
10995: l(' IF nvl(FND_PROFILE.VALUE(''HZ_DQM_SCORE_UNTIL_THRESH''),''N'')=''Y'' THEN');
10996: l(' g_score_until_thresh := true;');
10997: l(' ELSE');
10998: l(' g_score_until_thresh := false;');

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

10991: 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);');
10992: l(' IF l_entered_max_score = 0 THEN l_entered_max_score:=1; END IF;');
10993: l('');
10994: l(' l_max_thresh:=nvl(FND_PROFILE.VALUE(''HZ_DQM_MAX_EVAL_THRESH''),200);');
10995: l(' IF nvl(FND_PROFILE.VALUE(''HZ_DQM_SCORE_UNTIL_THRESH''),''N'')=''Y'' THEN');
10996: l(' g_score_until_thresh := true;');
10997: l(' ELSE');
10998: l(' g_score_until_thresh := false;');
10999: l(' END IF;');

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

12702: l(' BEGIN');
12703: l(' g_debug_count := g_debug_count + 1;');
12704:
12705: l(' IF g_debug_count = 1 THEN');
12706: l(' IF fnd_profile.value(''HZ_API_FILE_DEBUG_ON'') = ''Y'' OR');
12707: l(' fnd_profile.value(''HZ_API_DBMS_DEBUG_ON'') = ''Y''');
12708: l(' THEN');
12709: l(' hz_utility_v2pub.enable_debug;');
12710: l(' g_debug := TRUE;');

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

12703: l(' g_debug_count := g_debug_count + 1;');
12704:
12705: l(' IF g_debug_count = 1 THEN');
12706: l(' IF fnd_profile.value(''HZ_API_FILE_DEBUG_ON'') = ''Y'' OR');
12707: l(' fnd_profile.value(''HZ_API_DBMS_DEBUG_ON'') = ''Y''');
12708: l(' THEN');
12709: l(' hz_utility_v2pub.enable_debug;');
12710: l(' g_debug := TRUE;');
12711: d('PKG: '||p_pkg_name||' (+)');

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

14166: l('');
14167:
14168: --bug 5169483
14169: l(' l_use_contact_info := ''Y'';');
14170: l(' IF nvl(FND_PROFILE.VALUE(''HZ_DQM_REL_PARTY_MATCH''),''N'')=''Y'' THEN');
14171: l(' l_use_contact_info := ''N'';');
14172: l(' END IF;');
14173: --bug 5169483
14174: