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.IBW_BI_UTL_PVT dependencies on FND_LOG

Line 19: --FND Logging

15: FUNCTION GET_LOOKUPS_MNG(p_lkp_type IN varchar2,p_lkp_code in varchar2)
16: return VARCHAR2 IS
17:
18: l_meaning varchar2(100);
19: --FND Logging
20: l_full_path VARCHAR2(50);
21: gaflog_value VARCHAR2(10);
22:
23: CURSOR c_meaning (lkp_type varchar2,lkp_code varchar2) IS

Line 33: --FND Logging

29: lookup_type = lkp_type AND
30: lookup_code = lkp_code;
31:
32: BEGIN
33: --FND Logging
34: l_full_path := 'ibw.plsql.ibwbutlb.get_lookups_mng';
35: --Profile is : FND: Debug Log Enabled and FND: Debug Log Level for Log Level
36: gaflog_value := fnd_profile.value('AFLOG_ENABLED');
37:

Line 38: IF gaflog_value ='Y' AND (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN

34: l_full_path := 'ibw.plsql.ibwbutlb.get_lookups_mng';
35: --Profile is : FND: Debug Log Enabled and FND: Debug Log Level for Log Level
36: gaflog_value := fnd_profile.value('AFLOG_ENABLED');
37:
38: IF gaflog_value ='Y' AND (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
39: fnd_log.string(fnd_log.level_statement,l_full_path,' BEGIN : p_lkp_type '|| p_lkp_type || ' p_lkp_code '|| p_lkp_code);
40: END IF;
41:
42: OPEN c_meaning(p_lkp_type,p_lkp_code);

Line 39: fnd_log.string(fnd_log.level_statement,l_full_path,' BEGIN : p_lkp_type '|| p_lkp_type || ' p_lkp_code '|| p_lkp_code);

35: --Profile is : FND: Debug Log Enabled and FND: Debug Log Level for Log Level
36: gaflog_value := fnd_profile.value('AFLOG_ENABLED');
37:
38: IF gaflog_value ='Y' AND (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
39: fnd_log.string(fnd_log.level_statement,l_full_path,' BEGIN : p_lkp_type '|| p_lkp_type || ' p_lkp_code '|| p_lkp_code);
40: END IF;
41:
42: OPEN c_meaning(p_lkp_type,p_lkp_code);
43: FETCH c_meaning INTO l_meaning;

Line 46: IF gaflog_value ='Y' AND (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN

42: OPEN c_meaning(p_lkp_type,p_lkp_code);
43: FETCH c_meaning INTO l_meaning;
44: CLOSE c_meaning;
45:
46: IF gaflog_value ='Y' AND (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
47: fnd_log.string(fnd_log.level_statement,l_full_path,' END : Lookup Meaning = ' || l_meaning );
48: END IF;
49:
50: return l_meaning;

Line 47: fnd_log.string(fnd_log.level_statement,l_full_path,' END : Lookup Meaning = ' || l_meaning );

43: FETCH c_meaning INTO l_meaning;
44: CLOSE c_meaning;
45:
46: IF gaflog_value ='Y' AND (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
47: fnd_log.string(fnd_log.level_statement,l_full_path,' END : Lookup Meaning = ' || l_meaning );
48: END IF;
49:
50: return l_meaning;
51:

Line 54: if (fnd_log.level_unexpected >= fnd_log.g_current_runtime_level) then

50: return l_meaning;
51:
52: EXCEPTION
53: WHEN OTHERS THEN
54: if (fnd_log.level_unexpected >= fnd_log.g_current_runtime_level) then
55: fnd_log.string(fnd_log.level_unexpected,l_full_path,SQLERRM);
56: end if;
57: return null;
58:

Line 55: fnd_log.string(fnd_log.level_unexpected,l_full_path,SQLERRM);

51:
52: EXCEPTION
53: WHEN OTHERS THEN
54: if (fnd_log.level_unexpected >= fnd_log.g_current_runtime_level) then
55: fnd_log.string(fnd_log.level_unexpected,l_full_path,SQLERRM);
56: end if;
57: return null;
58:
59: END GET_LOOKUPS_MNG;

Line 80: --FND Logging

76: l_first VARCHAR2(100);
77: l_attr_code VARCHAR2(100);
78: l_last VARCHAR2(100);
79: l_region_code VARCHAR2(100);
80: --FND Logging
81: l_full_path VARCHAR2(50);
82: gaflog_value VARCHAR2(10);
83:
84: CURSOR c_last (regioncode varchar2,attributecode varchar2) IS

Line 91: --FND Logging

87: where region_code = regioncode
88: and attribute_code = attributecode;
89: BEGIN
90:
91: --FND Logging
92: l_full_path := 'ibw.plsql.ibwbutlb.get_grph_ttl';
93: --Profile is : FND: Debug Log Enabled and FND: Debug Log Level for Log Level
94: gaflog_value := fnd_profile.value('AFLOG_ENABLED');
95:

Line 96: IF gaflog_value ='Y' AND (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN

92: l_full_path := 'ibw.plsql.ibwbutlb.get_grph_ttl';
93: --Profile is : FND: Debug Log Enabled and FND: Debug Log Level for Log Level
94: gaflog_value := fnd_profile.value('AFLOG_ENABLED');
95:
96: IF gaflog_value ='Y' AND (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
97: fnd_log.string(fnd_log.level_statement,l_full_path,' BEGIN : p_region_code '|| p_region_code || ' p_lkp_code '|| p_lkp_code || ' p_view_by '|| p_view_by);
98: END IF;
99:
100: -- Based on the short name passed as parameter the appropriate region code is initialised in l_region_code

Line 97: fnd_log.string(fnd_log.level_statement,l_full_path,' BEGIN : p_region_code '|| p_region_code || ' p_lkp_code '|| p_lkp_code || ' p_view_by '|| p_view_by);

93: --Profile is : FND: Debug Log Enabled and FND: Debug Log Level for Log Level
94: gaflog_value := fnd_profile.value('AFLOG_ENABLED');
95:
96: IF gaflog_value ='Y' AND (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
97: fnd_log.string(fnd_log.level_statement,l_full_path,' BEGIN : p_region_code '|| p_region_code || ' p_lkp_code '|| p_lkp_code || ' p_view_by '|| p_view_by);
98: END IF;
99:
100: -- Based on the short name passed as parameter the appropriate region code is initialised in l_region_code
101: -- This is done mainly to reduce the length of the long label in Ak region items from

Line 126: IF gaflog_value ='Y' AND (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN

122: l_region_code := 'IBW_BI_PROD_INT';
123:
124: END IF;
125:
126: IF gaflog_value ='Y' AND (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
127: fnd_log.string(fnd_log.level_statement,l_full_path,' l_region_code '|| l_region_code );
128: END IF;
129:
130: -- The lookup meaning gives the first part of the graph title

Line 127: fnd_log.string(fnd_log.level_statement,l_full_path,' l_region_code '|| l_region_code );

123:
124: END IF;
125:
126: IF gaflog_value ='Y' AND (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
127: fnd_log.string(fnd_log.level_statement,l_full_path,' l_region_code '|| l_region_code );
128: END IF;
129:
130: -- The lookup meaning gives the first part of the graph title
131:

Line 178: IF gaflog_value ='Y' AND (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN

174: OPEN c_last(l_region_code,l_attr_code);
175: FETCH c_last INTO l_last;
176: CLOSE c_last;
177:
178: IF gaflog_value ='Y' AND (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
179: fnd_log.string(fnd_log.level_statement,l_full_path,' END : l_first '|| l_first || ' l_last '|| l_last);
180: END IF;
181:
182: return l_first||' '||l_last;

Line 179: fnd_log.string(fnd_log.level_statement,l_full_path,' END : l_first '|| l_first || ' l_last '|| l_last);

175: FETCH c_last INTO l_last;
176: CLOSE c_last;
177:
178: IF gaflog_value ='Y' AND (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
179: fnd_log.string(fnd_log.level_statement,l_full_path,' END : l_first '|| l_first || ' l_last '|| l_last);
180: END IF;
181:
182: return l_first||' '||l_last;
183:

Line 186: if (fnd_log.level_unexpected >= fnd_log.g_current_runtime_level) then

182: return l_first||' '||l_last;
183:
184: EXCEPTION
185: WHEN OTHERS THEN
186: if (fnd_log.level_unexpected >= fnd_log.g_current_runtime_level) then
187: fnd_log.string(fnd_log.level_unexpected,l_full_path,SQLERRM);
188: end if;
189: return null;
190:

Line 187: fnd_log.string(fnd_log.level_unexpected,l_full_path,SQLERRM);

183:
184: EXCEPTION
185: WHEN OTHERS THEN
186: if (fnd_log.level_unexpected >= fnd_log.g_current_runtime_level) then
187: fnd_log.string(fnd_log.level_unexpected,l_full_path,SQLERRM);
188: end if;
189: return null;
190:
191: END GTTL;

Line 233: --FND Logging

229: x_view_by OUT NOCOPY VARCHAR2)
230: AS
231:
232: l_parameter_name varchar2(1000);
233: --FND Logging
234: l_full_path VARCHAR2(50);
235: gaflog_value VARCHAR2(10);
236:
237: BEGIN

Line 239: --FND Logging

235: gaflog_value VARCHAR2(10);
236:
237: BEGIN
238:
239: --FND Logging
240: l_full_path := 'ibw.plsql.ibwbutlb.get_page_parameters';
241: --Profile is : FND: Debug Log Enabled and FND: Debug Log Level for Log Level
242: gaflog_value := fnd_profile.value('AFLOG_ENABLED');
243:

Line 244: IF gaflog_value ='Y' AND (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN

240: l_full_path := 'ibw.plsql.ibwbutlb.get_page_parameters';
241: --Profile is : FND: Debug Log Enabled and FND: Debug Log Level for Log Level
242: gaflog_value := fnd_profile.value('AFLOG_ENABLED');
243:
244: IF gaflog_value ='Y' AND (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
245: fnd_log.string(fnd_log.level_statement,l_full_path,' BEGIN : ');
246: END IF;
247:
248: FOR i IN p_pmv_parameters.FIRST..p_pmv_parameters.LAST

Line 245: fnd_log.string(fnd_log.level_statement,l_full_path,' BEGIN : ');

241: --Profile is : FND: Debug Log Enabled and FND: Debug Log Level for Log Level
242: gaflog_value := fnd_profile.value('AFLOG_ENABLED');
243:
244: IF gaflog_value ='Y' AND (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
245: fnd_log.string(fnd_log.level_statement,l_full_path,' BEGIN : ');
246: END IF;
247:
248: FOR i IN p_pmv_parameters.FIRST..p_pmv_parameters.LAST
249: LOOP

Line 303: IF gaflog_value ='Y' AND (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN

299: x_view_by := p_pmv_parameters(i).parameter_value;
300:
301: END IF;
302: END LOOP;
303: IF gaflog_value ='Y' AND (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
304: fnd_log.string(fnd_log.level_statement,l_full_path,' END : x_period_type ' || x_period_type ||
305: ' x_currency_code '|| x_currency_code || ' x_site '|| x_site ||' x_site_area '|| x_site_area ||
306: ' x_page '|| x_page || ' x_cust_class '|| x_cust_class || ' x_cust '|| x_cust || ' x_referral ' ||
307: x_referral ||' x_prod_cat ' || x_prod_cat || ' x_prod '|| x_prod || ' x_campaign ' || x_campaign || ' x_view_by '||

Line 304: fnd_log.string(fnd_log.level_statement,l_full_path,' END : x_period_type ' || x_period_type ||

300:
301: END IF;
302: END LOOP;
303: IF gaflog_value ='Y' AND (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
304: fnd_log.string(fnd_log.level_statement,l_full_path,' END : x_period_type ' || x_period_type ||
305: ' x_currency_code '|| x_currency_code || ' x_site '|| x_site ||' x_site_area '|| x_site_area ||
306: ' x_page '|| x_page || ' x_cust_class '|| x_cust_class || ' x_cust '|| x_cust || ' x_referral ' ||
307: x_referral ||' x_prod_cat ' || x_prod_cat || ' x_prod '|| x_prod || ' x_campaign ' || x_campaign || ' x_view_by '||
308: x_view_by);

Line 313: if (fnd_log.level_unexpected >= fnd_log.g_current_runtime_level) then

309: END IF;
310:
311: EXCEPTION
312: WHEN OTHERS THEN
313: if (fnd_log.level_unexpected >= fnd_log.g_current_runtime_level) then
314: fnd_log.string(fnd_log.level_unexpected,l_full_path,SQLERRM);
315: end if;
316:
317: END GET_PAGE_PARAMETERS;

Line 314: fnd_log.string(fnd_log.level_unexpected,l_full_path,SQLERRM);

310:
311: EXCEPTION
312: WHEN OTHERS THEN
313: if (fnd_log.level_unexpected >= fnd_log.g_current_runtime_level) then
314: fnd_log.string(fnd_log.level_unexpected,l_full_path,SQLERRM);
315: end if;
316:
317: END GET_PAGE_PARAMETERS;
318: