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_PVT dependencies on FND_GLOBAL

Line 46: l_app_short_name := FND_GLOBAL.APPLICATION_SHORT_NAME;

42: raise null_param_tbl;
43: END IF;
44:
45: -- Get schema
46: l_app_short_name := FND_GLOBAL.APPLICATION_SHORT_NAME;
47: if ((nvl(g_use_utl_file, 'N')='Y') and (l_app_short_name is null)) then
48: l_app_short_name :='OFA';
49: end if;
50: if not (fnd_installation.get_app_info (

Line 234: AND syn.synonym_name = '||''''||p_tbl||''''||fnd_global.local_chr(10);

230: l_stmt :='SELECT syn.synonym_name, column_name
231: FROM user_synonyms syn,all_tab_columns col
232: WHERE col.owner = syn.table_owner
233: AND col.table_name = syn.table_name
234: AND syn.synonym_name = '||''''||p_tbl||''''||fnd_global.local_chr(10);
235:
236: l_part_stmt := ' AND column_name not in (';
237:
238: FOR i IN g_options_tbl.FIRST .. g_options_tbl.LAST LOOP

Line 266: l_col_list := ' AND COLUMN_NAME NOT LIKE '||''''||l_col_exclusions(i).cValue||''''||fnd_global.local_chr(10);

262:
263: IF (l_col_exclusions.count > 0) THEN
264: FOR i in l_col_exclusions.first .. l_col_exclusions.last LOOP
265: IF l_col_exclusions(i).cType = 'P' THEN
266: l_col_list := ' AND COLUMN_NAME NOT LIKE '||''''||l_col_exclusions(i).cValue||''''||fnd_global.local_chr(10);
267: l_stmt := l_stmt||l_col_list;
268: ELSE
269: l_part_stmt := l_part_stmt||''''||l_col_exclusions(i).cValue||''''||',';
270: END IF;

Line 277: l_stmt := l_stmt||l_part_stmt||fnd_global.local_chr(10);

273: log(l_calling_fn, 'No exclusions to process.');
274: END IF; -- l_col_exclusions.count > 0
275:
276: l_part_stmt := substr(l_part_stmt, 1, length(l_part_stmt) -1)||')';
277: l_stmt := l_stmt||l_part_stmt||fnd_global.local_chr(10);
278:
279: IF nvl(g_jx_enabled, 'N') = 'N' THEN
280: l_stmt := l_stmt||' AND column_name not like '||''''||'GLOBAL_AT%'||'''';
281: END IF;

Line 283: l_stmt := l_stmt||fnd_global.local_chr(10)||' Order by column_name';

279: IF nvl(g_jx_enabled, 'N') = 'N' THEN
280: l_stmt := l_stmt||' AND column_name not like '||''''||'GLOBAL_AT%'||'''';
281: END IF;
282:
283: l_stmt := l_stmt||fnd_global.local_chr(10)||' Order by column_name';
284: x_stmt := l_stmt;
285:
286: EXCEPTION
287: WHEN OTHERS THEN

Line 637: l_appid := FND_GLOBAL.resp_appl_id; log(l_calling_fn, 'l_appid: '||l_appid);

633:
634: l_calling_fn varchar2(40) := 'fa_asset_trace_pvt.get_system_options';
635:
636: BEGIN
637: l_appid := FND_GLOBAL.resp_appl_id; log(l_calling_fn, 'l_appid: '||l_appid);
638: l_userid := fnd_global.user_id; log(l_calling_fn, 'l_userid: '||l_userid);
639: l_respid := Fnd_Global.Resp_Id; log(l_calling_fn, 'l_respid: '||l_respid);
640:
641: if (nvl(g_use_utl_file, 'Y')='N') then

Line 638: l_userid := fnd_global.user_id; log(l_calling_fn, 'l_userid: '||l_userid);

634: l_calling_fn varchar2(40) := 'fa_asset_trace_pvt.get_system_options';
635:
636: BEGIN
637: l_appid := FND_GLOBAL.resp_appl_id; log(l_calling_fn, 'l_appid: '||l_appid);
638: l_userid := fnd_global.user_id; log(l_calling_fn, 'l_userid: '||l_userid);
639: l_respid := Fnd_Global.Resp_Id; log(l_calling_fn, 'l_respid: '||l_respid);
640:
641: if (nvl(g_use_utl_file, 'Y')='N') then
642: l_stmt :=fafsc('fpon.profile_option_name')||fafsc('site_pov.profile_option_value');

Line 639: l_respid := Fnd_Global.Resp_Id; log(l_calling_fn, 'l_respid: '||l_respid);

635:
636: BEGIN
637: l_appid := FND_GLOBAL.resp_appl_id; log(l_calling_fn, 'l_appid: '||l_appid);
638: l_userid := fnd_global.user_id; log(l_calling_fn, 'l_userid: '||l_userid);
639: l_respid := Fnd_Global.Resp_Id; log(l_calling_fn, 'l_respid: '||l_respid);
640:
641: if (nvl(g_use_utl_file, 'Y')='N') then
642: l_stmt :=fafsc('fpon.profile_option_name')||fafsc('site_pov.profile_option_value');
643: l_stmt :=l_stmt||fafsc('appl_pov.profile_option_value')||fafsc('resp_pov.profile_option_value');

Line 1101: l_title := nvl(FND_GLOBAL.APPLICATION_NAME, 'Assets')||': '||p_calling_prog;

1097: if g_param_tbl.exists(l_cnt) then
1098: l_sec_col := to_char(NVL(g_param_tbl(l_cnt).cValue, g_param_tbl(g_param_tbl.first).nValue));
1099: end if;
1100:
1101: l_title := nvl(FND_GLOBAL.APPLICATION_NAME, 'Assets')||': '||p_calling_prog;
1102: --margin-left: 5%; margin-right: 5%; font-style: normal
1103: l_header := ''||nvl(FND_GLOBAL.APPLICATION_SHORT_NAME,'FA ')||'- Trace Utility
1104:
1105:

'||l_title||'

Line 1103: l_header := ''||nvl(FND_GLOBAL.APPLICATION_SHORT_NAME,'FA ')||'- Trace Utility

1099: end if;
1100:
1101: l_title := nvl(FND_GLOBAL.APPLICATION_NAME, 'Assets')||': '||p_calling_prog;
1102: --margin-left: 5%; margin-right: 5%; font-style: normal
1103: l_header := ''||nvl(FND_GLOBAL.APPLICATION_SHORT_NAME,'FA ')||'- Trace Utility
1104:
1105:

'||l_title||'

1106: ';
1107:

Line 1208: l_module := FND_GLOBAL.APPLICATION_SHORT_NAME||'.PLSQL.'||p_calling_fn;

1204: Fnd_File.Put_Line (Fnd_File.Log, p_calling_fn|| ': '||p_msg);
1205: end if;
1206: --
1207: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1208: l_module := FND_GLOBAL.APPLICATION_SHORT_NAME||'.PLSQL.'||p_calling_fn;
1209: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_module, p_msg);
1210: END IF;
1211:
1212: EXCEPTION