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.FA_ASSET_TRACE_PKG dependencies on FA_ASSET_TRACE_PVT

Line 42: g_sel_tbl FA_ASSET_TRACE_PVT.t_asset_tbl;

38: g_tmpc_tbl t_col_tbl;
39: g_tbl_hldr t_col_tbl;
40: g_anchor_tbl t_col_tbl;
41: g_hdr_tbl t_asset_tbl;
42: g_sel_tbl FA_ASSET_TRACE_PVT.t_asset_tbl;
43: g_no_rec_tbl t_asset_tbl;
44: g_tmp_tbl t_asset_tbl;
45: g_output_tbl t_asset_tbl;
46: g_asset_number FA_ADDITIONS.ASSET_NUMBER%TYPE;

Line 133: FA_ASSET_TRACE_PVT.g_use_utl_file := 'Y';

129: l_filename := 'GTU_'||replace(ltrim(rtrim(p_book)),' ','_') || '_' || replace(p_asset_number,' ','_') ||'.log';
130: g_submit_sub := TRUE;
131: end if;
132: log(l_calling_fn, 'l_filename: '||l_filename);
133: FA_ASSET_TRACE_PVT.g_use_utl_file := 'Y';
134: FA_ASSET_TRACE_PVT.ocfile (FA_ASSET_TRACE_PVT.g_logfile, l_filename,'O');
135: END IF;
136: log(l_calling_fn, 'use utl file: '|| fa_asset_trace_pkg.g_use_utl_file);
137: if (nvl(fa_asset_trace_pkg.g_use_utl_file, 'Y') = 'N') then

Line 134: FA_ASSET_TRACE_PVT.ocfile (FA_ASSET_TRACE_PVT.g_logfile, l_filename,'O');

130: g_submit_sub := TRUE;
131: end if;
132: log(l_calling_fn, 'l_filename: '||l_filename);
133: FA_ASSET_TRACE_PVT.g_use_utl_file := 'Y';
134: FA_ASSET_TRACE_PVT.ocfile (FA_ASSET_TRACE_PVT.g_logfile, l_filename,'O');
135: END IF;
136: log(l_calling_fn, 'use utl file: '|| fa_asset_trace_pkg.g_use_utl_file);
137: if (nvl(fa_asset_trace_pkg.g_use_utl_file, 'Y') = 'N') then
138: l_parent_request := fnd_global.conc_request_id;

Line 239: l_count :=FA_ASSET_TRACE_PVT.g_param_tbl.count + 1;

235: l_desc := 'FATRACE - SLA Subrequest from backend: '||g_book||'-'||g_asset_id||'-'||to_char(sysdate);
236: end if;
237:
238: --populate param tbl.
239: l_count :=FA_ASSET_TRACE_PVT.g_param_tbl.count + 1;
240: FA_ASSET_TRACE_PVT.g_param_tbl(l_count).param_column :='ASSET_ID';
241: FA_ASSET_TRACE_PVT.g_param_tbl(l_count).nValue := g_asset_id;
242: l_count := l_count +1;
243: FA_ASSET_TRACE_PVT.g_param_tbl(l_count).param_column :='BOOK_TYPE_CODE';

Line 240: FA_ASSET_TRACE_PVT.g_param_tbl(l_count).param_column :='ASSET_ID';

236: end if;
237:
238: --populate param tbl.
239: l_count :=FA_ASSET_TRACE_PVT.g_param_tbl.count + 1;
240: FA_ASSET_TRACE_PVT.g_param_tbl(l_count).param_column :='ASSET_ID';
241: FA_ASSET_TRACE_PVT.g_param_tbl(l_count).nValue := g_asset_id;
242: l_count := l_count +1;
243: FA_ASSET_TRACE_PVT.g_param_tbl(l_count).param_column :='BOOK_TYPE_CODE';
244: FA_ASSET_TRACE_PVT.g_param_tbl(l_count).cValue := g_book;

Line 241: FA_ASSET_TRACE_PVT.g_param_tbl(l_count).nValue := g_asset_id;

237:
238: --populate param tbl.
239: l_count :=FA_ASSET_TRACE_PVT.g_param_tbl.count + 1;
240: FA_ASSET_TRACE_PVT.g_param_tbl(l_count).param_column :='ASSET_ID';
241: FA_ASSET_TRACE_PVT.g_param_tbl(l_count).nValue := g_asset_id;
242: l_count := l_count +1;
243: FA_ASSET_TRACE_PVT.g_param_tbl(l_count).param_column :='BOOK_TYPE_CODE';
244: FA_ASSET_TRACE_PVT.g_param_tbl(l_count).cValue := g_book;
245:

Line 243: FA_ASSET_TRACE_PVT.g_param_tbl(l_count).param_column :='BOOK_TYPE_CODE';

239: l_count :=FA_ASSET_TRACE_PVT.g_param_tbl.count + 1;
240: FA_ASSET_TRACE_PVT.g_param_tbl(l_count).param_column :='ASSET_ID';
241: FA_ASSET_TRACE_PVT.g_param_tbl(l_count).nValue := g_asset_id;
242: l_count := l_count +1;
243: FA_ASSET_TRACE_PVT.g_param_tbl(l_count).param_column :='BOOK_TYPE_CODE';
244: FA_ASSET_TRACE_PVT.g_param_tbl(l_count).cValue := g_book;
245:
246: if g_print_debug then
247: fa_debug_pkg.add(l_calling_fn, 'setting', 'localizations info');

Line 244: FA_ASSET_TRACE_PVT.g_param_tbl(l_count).cValue := g_book;

240: FA_ASSET_TRACE_PVT.g_param_tbl(l_count).param_column :='ASSET_ID';
241: FA_ASSET_TRACE_PVT.g_param_tbl(l_count).nValue := g_asset_id;
242: l_count := l_count +1;
243: FA_ASSET_TRACE_PVT.g_param_tbl(l_count).param_column :='BOOK_TYPE_CODE';
244: FA_ASSET_TRACE_PVT.g_param_tbl(l_count).cValue := g_book;
245:
246: if g_print_debug then
247: fa_debug_pkg.add(l_calling_fn, 'setting', 'localizations info');
248: end if;

Line 300: FA_ASSET_TRACE_PVT.g_jx_enabled := g_jx_enabled;

296: g_prorate_calendar:= fa_cache_pkg.fazcbc_record.prorate_calendar;
297:
298: log (l_calling_fn,'g_source_book: '||g_source_book);
299:
300: FA_ASSET_TRACE_PVT.g_jx_enabled := g_jx_enabled;
301: FA_ASSET_TRACE_PVT.g_mrc_enabled := g_mrc_enabled;
302:
303: select release_name
304: into l_app_version

Line 301: FA_ASSET_TRACE_PVT.g_mrc_enabled := g_mrc_enabled;

297:
298: log (l_calling_fn,'g_source_book: '||g_source_book);
299:
300: FA_ASSET_TRACE_PVT.g_jx_enabled := g_jx_enabled;
301: FA_ASSET_TRACE_PVT.g_mrc_enabled := g_mrc_enabled;
302:
303: select release_name
304: into l_app_version
305: from fnd_product_groups;

Line 372: FA_ASSET_TRACE_PVT.ocfile (FA_ASSET_TRACE_PVT.g_logfile, null,'C');

368:
369: log(l_calling_fn,'Parent request, retcode is '||retcode);
370: if (nvl(fa_asset_trace_pkg.g_use_utl_file, 'N') = 'Y') then
371: log(l_calling_fn, 'Trying to close log file');
372: FA_ASSET_TRACE_PVT.ocfile (FA_ASSET_TRACE_PVT.g_logfile, null,'C');
373: end if;
374: g_submit_sub := FALSE;
375: elsif ((NOT g_submit_sub) OR ((nvl(fa_asset_trace_pkg.g_sla_only, 'N') = 'Y'))) then
376:

Line 382: FA_ASSET_TRACE_PVT.ocfile (FA_ASSET_TRACE_PVT.g_logfile, null,'C');

378: load_xla_info(l_desc, retcode, g_log_level_rec);
379: log(l_calling_fn,'sla subrequest retcode is '||retcode);
380:
381: if (nvl(fa_asset_trace_pkg.g_use_utl_file, 'N') = 'Y') then
382: FA_ASSET_TRACE_PVT.ocfile (FA_ASSET_TRACE_PVT.g_logfile, null,'C');
383: end if;
384:
385: end if;
386:

Line 1687: RETURN FA_ASSET_TRACE_PVT.fafsc(p_col);

1683: END submit_subrequest;
1684: --
1685: FUNCTION fafsc (p_col VARCHAR2) RETURN VARCHAR2 IS
1686: BEGIN
1687: RETURN FA_ASSET_TRACE_PVT.fafsc(p_col);
1688: END fafsc;
1689: --
1690: FUNCTION fparse_header(p_in_str VARCHAR2) RETURN VARCHAR2 IS
1691: BEGIN

Line 1692: RETURN FA_ASSET_TRACE_PVT.fparse_header(p_in_str);

1688: END fafsc;
1689: --
1690: FUNCTION fparse_header(p_in_str VARCHAR2) RETURN VARCHAR2 IS
1691: BEGIN
1692: RETURN FA_ASSET_TRACE_PVT.fparse_header(p_in_str);
1693: END fparse_header;
1694: --
1695: FUNCTION enqueue_request RETURN BOOLEAN IS
1696:

Line 1845: FA_ASSET_TRACE_PVT.LOG(p_calling_fn,p_msg,g_log_level_rec);

1841: p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null) IS
1842:
1843: BEGIN
1844:
1845: FA_ASSET_TRACE_PVT.LOG(p_calling_fn,p_msg,g_log_level_rec);
1846:
1847: END log;
1848: --
1849: END FA_ASSET_TRACE_PKG;