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 121: FA_ASSET_TRACE_PVT.g_use_utl_file := 'Y';

117: l_filename := 'GTU_'||replace(ltrim(rtrim(p_book)),' ','_') || '_' || replace(p_asset_number,' ','_') ||'.log';
118: g_submit_sub := TRUE;
119: end if;
120: log(l_calling_fn, 'l_filename: '||l_filename);
121: FA_ASSET_TRACE_PVT.g_use_utl_file := 'Y';
122: FA_ASSET_TRACE_PVT.ocfile (FA_ASSET_TRACE_PVT.g_logfile, l_filename,'O');
123: END IF;
124: log(l_calling_fn, 'use utl file: '|| fa_asset_trace_pkg.g_use_utl_file);
125: if (nvl(fa_asset_trace_pkg.g_use_utl_file, 'Y') = 'N') then

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

118: g_submit_sub := TRUE;
119: end if;
120: log(l_calling_fn, 'l_filename: '||l_filename);
121: FA_ASSET_TRACE_PVT.g_use_utl_file := 'Y';
122: FA_ASSET_TRACE_PVT.ocfile (FA_ASSET_TRACE_PVT.g_logfile, l_filename,'O');
123: END IF;
124: log(l_calling_fn, 'use utl file: '|| fa_asset_trace_pkg.g_use_utl_file);
125: if (nvl(fa_asset_trace_pkg.g_use_utl_file, 'Y') = 'N') then
126: l_parent_request := fnd_global.conc_request_id;

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

215: l_desc := 'FATRACE - SLA Subrequest from backend: '||g_book||'-'||g_asset_id||'-'||to_char(sysdate);
216: end if;
217:
218: --populate param tbl.
219: l_count :=FA_ASSET_TRACE_PVT.g_param_tbl.count + 1;
220: FA_ASSET_TRACE_PVT.g_param_tbl(l_count).param_column :='ASSET_ID';
221: FA_ASSET_TRACE_PVT.g_param_tbl(l_count).nValue := g_asset_id;
222: l_count := l_count +1;
223: FA_ASSET_TRACE_PVT.g_param_tbl(l_count).param_column :='BOOK_TYPE_CODE';

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

216: end if;
217:
218: --populate param tbl.
219: l_count :=FA_ASSET_TRACE_PVT.g_param_tbl.count + 1;
220: FA_ASSET_TRACE_PVT.g_param_tbl(l_count).param_column :='ASSET_ID';
221: FA_ASSET_TRACE_PVT.g_param_tbl(l_count).nValue := g_asset_id;
222: l_count := l_count +1;
223: FA_ASSET_TRACE_PVT.g_param_tbl(l_count).param_column :='BOOK_TYPE_CODE';
224: FA_ASSET_TRACE_PVT.g_param_tbl(l_count).cValue := g_book;

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

217:
218: --populate param tbl.
219: l_count :=FA_ASSET_TRACE_PVT.g_param_tbl.count + 1;
220: FA_ASSET_TRACE_PVT.g_param_tbl(l_count).param_column :='ASSET_ID';
221: FA_ASSET_TRACE_PVT.g_param_tbl(l_count).nValue := g_asset_id;
222: l_count := l_count +1;
223: FA_ASSET_TRACE_PVT.g_param_tbl(l_count).param_column :='BOOK_TYPE_CODE';
224: FA_ASSET_TRACE_PVT.g_param_tbl(l_count).cValue := g_book;
225:

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

219: l_count :=FA_ASSET_TRACE_PVT.g_param_tbl.count + 1;
220: FA_ASSET_TRACE_PVT.g_param_tbl(l_count).param_column :='ASSET_ID';
221: FA_ASSET_TRACE_PVT.g_param_tbl(l_count).nValue := g_asset_id;
222: l_count := l_count +1;
223: FA_ASSET_TRACE_PVT.g_param_tbl(l_count).param_column :='BOOK_TYPE_CODE';
224: FA_ASSET_TRACE_PVT.g_param_tbl(l_count).cValue := g_book;
225:
226: if g_print_debug then
227: fa_debug_pkg.add(l_calling_fn, 'setting', 'localizations info');

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

220: FA_ASSET_TRACE_PVT.g_param_tbl(l_count).param_column :='ASSET_ID';
221: FA_ASSET_TRACE_PVT.g_param_tbl(l_count).nValue := g_asset_id;
222: l_count := l_count +1;
223: FA_ASSET_TRACE_PVT.g_param_tbl(l_count).param_column :='BOOK_TYPE_CODE';
224: FA_ASSET_TRACE_PVT.g_param_tbl(l_count).cValue := g_book;
225:
226: if g_print_debug then
227: fa_debug_pkg.add(l_calling_fn, 'setting', 'localizations info');
228: end if;

Line 280: FA_ASSET_TRACE_PVT.g_jx_enabled := g_jx_enabled;

276: g_prorate_calendar:= fa_cache_pkg.fazcbc_record.prorate_calendar;
277:
278: log (l_calling_fn,'g_source_book: '||g_source_book);
279:
280: FA_ASSET_TRACE_PVT.g_jx_enabled := g_jx_enabled;
281: FA_ASSET_TRACE_PVT.g_mrc_enabled := g_mrc_enabled;
282:
283: select release_name
284: into l_app_version

Line 281: FA_ASSET_TRACE_PVT.g_mrc_enabled := g_mrc_enabled;

277:
278: log (l_calling_fn,'g_source_book: '||g_source_book);
279:
280: FA_ASSET_TRACE_PVT.g_jx_enabled := g_jx_enabled;
281: FA_ASSET_TRACE_PVT.g_mrc_enabled := g_mrc_enabled;
282:
283: select release_name
284: into l_app_version
285: from fnd_product_groups;

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

348:
349: log(l_calling_fn,'Parent request, retcode is '||retcode);
350: if (nvl(fa_asset_trace_pkg.g_use_utl_file, 'N') = 'Y') then
351: log(l_calling_fn, 'Trying to close log file');
352: FA_ASSET_TRACE_PVT.ocfile (FA_ASSET_TRACE_PVT.g_logfile, null,'C');
353: end if;
354: g_submit_sub := FALSE;
355: elsif ((NOT g_submit_sub) OR ((nvl(fa_asset_trace_pkg.g_sla_only, 'N') = 'Y'))) then
356:

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

358: load_xla_info(l_desc, retcode, g_log_level_rec);
359: log(l_calling_fn,'sla subrequest retcode is '||retcode);
360:
361: if (nvl(fa_asset_trace_pkg.g_use_utl_file, 'N') = 'Y') then
362: FA_ASSET_TRACE_PVT.ocfile (FA_ASSET_TRACE_PVT.g_logfile, null,'C');
363: end if;
364:
365: end if;
366:

Line 1632: RETURN FA_ASSET_TRACE_PVT.fafsc(p_col);

1628: END submit_subrequest;
1629: --
1630: FUNCTION fafsc (p_col VARCHAR2) RETURN VARCHAR2 IS
1631: BEGIN
1632: RETURN FA_ASSET_TRACE_PVT.fafsc(p_col);
1633: END fafsc;
1634: --
1635: FUNCTION fparse_header(p_in_str VARCHAR2) RETURN VARCHAR2 IS
1636: BEGIN

Line 1637: RETURN FA_ASSET_TRACE_PVT.fparse_header(p_in_str);

1633: END fafsc;
1634: --
1635: FUNCTION fparse_header(p_in_str VARCHAR2) RETURN VARCHAR2 IS
1636: BEGIN
1637: RETURN FA_ASSET_TRACE_PVT.fparse_header(p_in_str);
1638: END fparse_header;
1639: --
1640: FUNCTION enqueue_request RETURN BOOLEAN IS
1641:

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

1786: p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null) IS
1787:
1788: BEGIN
1789:
1790: FA_ASSET_TRACE_PVT.LOG(p_calling_fn,p_msg,g_log_level_rec);
1791:
1792: END log;
1793: --
1794: END FA_ASSET_TRACE_PKG;