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 227: 'AND table_name = '||''''||p_tbl||''''||fnd_global.local_chr(10);

223:
224: l_stmt :='SELECT table_name, column_name
225: FROM all_tab_columns
226: WHERE owner = ''' || p_schema || ''' ' ||
227: 'AND table_name = '||''''||p_tbl||''''||fnd_global.local_chr(10);
228:
229: l_part_stmt := ' AND column_name not in (';
230:
231: FOR i IN g_options_tbl.FIRST .. g_options_tbl.LAST LOOP

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

255:
256: IF (l_col_exclusions.count > 0) THEN
257: FOR i in l_col_exclusions.first .. l_col_exclusions.last LOOP
258: IF l_col_exclusions(i).cType = 'P' THEN
259: l_col_list := ' AND COLUMN_NAME NOT LIKE '||''''||l_col_exclusions(i).cValue||''''||fnd_global.local_chr(10);
260: l_stmt := l_stmt||l_col_list;
261: ELSE
262: l_part_stmt := l_part_stmt||''''||l_col_exclusions(i).cValue||''''||',';
263: END IF;

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

266: log(l_calling_fn, 'No exclusions to process.');
267: END IF; -- l_col_exclusions.count > 0
268:
269: l_part_stmt := substr(l_part_stmt, 1, length(l_part_stmt) -1)||')';
270: l_stmt := l_stmt||l_part_stmt||fnd_global.local_chr(10);
271:
272: IF nvl(g_jx_enabled, 'N') = 'N' THEN
273: l_stmt := l_stmt||' AND column_name not like '||''''||'GLOBAL_AT%'||'''';
274: END IF;

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

272: IF nvl(g_jx_enabled, 'N') = 'N' THEN
273: l_stmt := l_stmt||' AND column_name not like '||''''||'GLOBAL_AT%'||'''';
274: END IF;
275:
276: l_stmt := l_stmt||fnd_global.local_chr(10)||' Order by column_name';
277: x_stmt := l_stmt;
278:
279: EXCEPTION
280: WHEN OTHERS THEN

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

626:
627: l_calling_fn varchar2(40) := 'fa_asset_trace_pvt.get_system_options';
628:
629: BEGIN
630: l_appid := FND_GLOBAL.resp_appl_id; log(l_calling_fn, 'l_appid: '||l_appid);
631: l_userid := fnd_global.user_id; log(l_calling_fn, 'l_userid: '||l_userid);
632: l_respid := Fnd_Global.Resp_Id; log(l_calling_fn, 'l_respid: '||l_respid);
633:
634: if (nvl(g_use_utl_file, 'Y')='N') then

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

627: l_calling_fn varchar2(40) := 'fa_asset_trace_pvt.get_system_options';
628:
629: BEGIN
630: l_appid := FND_GLOBAL.resp_appl_id; log(l_calling_fn, 'l_appid: '||l_appid);
631: l_userid := fnd_global.user_id; log(l_calling_fn, 'l_userid: '||l_userid);
632: l_respid := Fnd_Global.Resp_Id; log(l_calling_fn, 'l_respid: '||l_respid);
633:
634: if (nvl(g_use_utl_file, 'Y')='N') then
635: l_stmt :=fafsc('fpon.profile_option_name')||fafsc('site_pov.profile_option_value');

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

628:
629: BEGIN
630: l_appid := FND_GLOBAL.resp_appl_id; log(l_calling_fn, 'l_appid: '||l_appid);
631: l_userid := fnd_global.user_id; log(l_calling_fn, 'l_userid: '||l_userid);
632: l_respid := Fnd_Global.Resp_Id; log(l_calling_fn, 'l_respid: '||l_respid);
633:
634: if (nvl(g_use_utl_file, 'Y')='N') then
635: l_stmt :=fafsc('fpon.profile_option_name')||fafsc('site_pov.profile_option_value');
636: l_stmt :=l_stmt||fafsc('appl_pov.profile_option_value')||fafsc('resp_pov.profile_option_value');

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

1081: if g_param_tbl.exists(l_cnt) then
1082: l_sec_col := to_char(NVL(g_param_tbl(l_cnt).cValue, g_param_tbl(g_param_tbl.first).nValue));
1083: end if;
1084:
1085: l_title := nvl(FND_GLOBAL.APPLICATION_NAME, 'Assets')||': '||p_calling_prog;
1086: --margin-left: 5%; margin-right: 5%; font-style: normal
1087: l_header := ''||nvl(FND_GLOBAL.APPLICATION_SHORT_NAME,'FA ')||'- Trace Utility
1088:
1089:

'||l_title||'

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

1083: end if;
1084:
1085: l_title := nvl(FND_GLOBAL.APPLICATION_NAME, 'Assets')||': '||p_calling_prog;
1086: --margin-left: 5%; margin-right: 5%; font-style: normal
1087: l_header := ''||nvl(FND_GLOBAL.APPLICATION_SHORT_NAME,'FA ')||'- Trace Utility
1088:
1089:

'||l_title||'

1090: ';
1091:

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

1188: Fnd_File.Put_Line (Fnd_File.Log, p_calling_fn|| ': '||p_msg);
1189: end if;
1190: --
1191: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1192: l_module := FND_GLOBAL.APPLICATION_SHORT_NAME||'.PLSQL.'||p_calling_fn;
1193: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_module, p_msg);
1194: END IF;
1195:
1196: EXCEPTION