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.INV_DIAG_OBJ dependencies on JTF_DIAGNOSTIC_COREAPI

Line 39: JTF_DIAGNOSTIC_COREAPI.insert_style_sheet;

35:
36: BEGIN
37: JTF_DIAGNOSTIC_ADAPTUTIL.setUpVars;
38: JTF_DIAGNOSTIC_ADAPTUTIL.addStringToReport('@html');
39: JTF_DIAGNOSTIC_COREAPI.insert_style_sheet;
40: -- accept input
41: l_script :=JTF_DIAGNOSTIC_ADAPTUTIL.getInputValue('CheckName',inputs);
42: l_app_id :=JTF_DIAGNOSTIC_ADAPTUTIL.getInputValue('ApplicationId',inputs);
43: l_pkg :=JTF_DIAGNOSTIC_ADAPTUTIL.getInputValue('Package',inputs);

Line 50: JTF_DIAGNOSTIC_COREAPI.BRPrint;

46: l_conc_prg :=JTF_DIAGNOSTIC_ADAPTUTIL.getInputValue('ConcurrentProgram',inputs);
47: row_limit :=INV_DIAG_GRP.g_max_row;
48:
49: JTF_DIAGNOSTIC_ADAPTUTIL.addStringToReport(':'||l_org_id||' Check '||l_script||' appId '||l_app_id);
50: JTF_DIAGNOSTIC_COREAPI.BRPrint;
51:
52: if l_app_id is null then
53: select APPLICATION_ID
54: into l_app_id

Line 84: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sqltxt,'Invalid database objects related to INV'||reportStr);

80: 'ORDER BY object_name, object_type';
81: if l_app_id <> 401 then
82: reportStr :=' and '||l_app;
83: end if;
84: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sqltxt,'Invalid database objects related to INV'||reportStr);
85:
86: elsif l_script ='profile' then
87: sqltxt :='SELECT b.user_profile_option_name "Long Name" '||
88: ' , a.profile_option_name "Short Name" '||

Line 120: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sqltxt,'Profileoptions and settings for applicationId '||l_app_id);

116: ' AND c.level_value = g.responsibility_id (+) '||
117: ' AND c.level_value = h.application_id (+) '||
118: 'ORDER BY b.user_profile_option_name, c.level_id, c.profile_option_value';
119:
120: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sqltxt,'Profileoptions and settings for applicationId '||l_app_id);
121:
122: elsif l_script = 'version' then
123:
124: if l_pkg is not null then

Line 126: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sqltxt,'Version of the package '||l_pkg);

122: elsif l_script = 'version' then
123:
124: if l_pkg is not null then
125: sqltxt := ' select text "Package(Spec/Body)" from dba_source where owner =''APPS'' and name= upper('''||l_pkg||''') and line=2';
126: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sqltxt,'Version of the package '||l_pkg);
127: elsif l_file is null then
128: sqltxt := ' select name "Package(Spec/Body)", text "File Info" from dba_source where owner =''APPS'' and name like '''||l_app||'_%'' and line=2 order by name';
129: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sqltxt,'Version of all packages from application '||l_app);
130: end if;

Line 129: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sqltxt,'Version of all packages from application '||l_app);

125: sqltxt := ' select text "Package(Spec/Body)" from dba_source where owner =''APPS'' and name= upper('''||l_pkg||''') and line=2';
126: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sqltxt,'Version of the package '||l_pkg);
127: elsif l_file is null then
128: sqltxt := ' select name "Package(Spec/Body)", text "File Info" from dba_source where owner =''APPS'' and name like '''||l_app||'_%'' and line=2 order by name';
129: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sqltxt,'Version of all packages from application '||l_app);
130: end if;
131:
132: if l_file is not null then
133: sqltxt := ' select f.filename Name, subdir Directory, version'||

Line 141: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sqltxt,'Latest Patched Version of the file: '||l_pkg);

137: ' (select max(fv.file_version_id)'||
138: ' from ad_file_versions fv'||
139: ' where fv.file_id=v.file_id) '||
140: ' and f.filename like '''||l_file||'%''';
141: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sqltxt,'Latest Patched Version of the file: '||l_pkg);
142: elsif l_pkg is null then
143: sqltxt := ' select f.filename Name, subdir Directory, version'||
144: ' from ad_file_versions v, ad_files f'||
145: ' where v.file_id=f.file_id'||

Line 153: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sqltxt,'Latest Patched Forms from Application: '||l_app);

149: ' where fv.file_id=v.file_id) '||
150: ' and subdir like ''forms%'' '||
151: ' and f.app_short_name = '''||l_app||''''||
152: ' order by subdir, f.last_update_date';
153: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sqltxt,'Latest Patched Forms from Application: '||l_app);
154:
155: sqltxt := ' select f.filename Name, subdir Directory, version'||
156: ' from ad_file_versions v, ad_files f'||
157: ' where v.file_id=f.file_id'||

Line 165: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sqltxt,'Latest Patched Libraries from Application: '||l_app);

161: ' where fv.file_id=v.file_id) '||
162: ' and subdir = ''resource'' '||
163: ' and f.app_short_name = '''||l_app||''''||
164: ' order by subdir, f.last_update_date';
165: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sqltxt,'Latest Patched Libraries from Application: '||l_app);
166:
167: sqltxt := ' select f.filename Name, subdir Directory, version'||
168: ' from ad_file_versions v, ad_files f'||
169: ' where v.file_id=f.file_id'||

Line 177: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sqltxt,'Latest Patched Java Classes from Application: '||l_app);

173: ' where fv.file_id=v.file_id) '||
174: ' and subdir like ''java%'' '||
175: ' and f.app_short_name = '''||l_app||''''||
176: ' order by subdir, f.last_update_date';
177: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sqltxt,'Latest Patched Java Classes from Application: '||l_app);
178:
179: sqltxt := ' select f.filename Name, subdir Directory, version'||
180: ' from ad_file_versions v, ad_files f'||
181: ' where v.file_id=f.file_id'||

Line 189: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sqltxt,'Latest Patched odf files from Application: '||l_app);

185: ' where fv.file_id=v.file_id) '||
186: ' and subdir = ''patch/115/odf'' '||
187: ' and f.app_short_name = '''||l_app||''''||
188: ' order by subdir, f.last_update_date';
189: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sqltxt,'Latest Patched odf files from Application: '||l_app);
190:
191: sqltxt := ' select f.filename Name, subdir Directory, version'||
192: ' from ad_file_versions v, ad_files f'||
193: ' where v.file_id=f.file_id'||

Line 201: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sqltxt,'Latest Patched Reports from Application: '||l_app);

197: ' where fv.file_id=v.file_id) '||
198: ' and subdir like ''reports%'' '||
199: ' and f.app_short_name = '''||l_app||''''||
200: ' order by subdir, f.last_update_date';
201: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sqltxt,'Latest Patched Reports from Application: '||l_app);
202: end if;
203:
204: elsif l_script = 'lock' then
205: sqltxt :='select a.*,b.module,p.spid from (select s.sid,to_char(s.logon_time,''DD-MON-YY HH:MI:SS'') logon_time, s.serial#,'||

Line 276: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sqltxt,'Display database locks and latches');

272: ' and p.latchwait = l.addr) a , v$session b,v$process p where'||
273: ' a.sid=b.sid and a.object like ''%MTL%'' and b.paddr = p.addr(+)';
274:
275: sqltxt := 'select * from ('||sqltxt||') WHERE ROWNUM <= '||row_limit;
276: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sqltxt,'Display database locks and latches');
277:
278: elsif l_script = 'patch' then
279: sqltxt := 'select patch_name, patch_type , max(creation_date) "Applied Date" from ad_applied_patches ';
280: if l_patch is not null then

Line 285: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sqltxt,'Display applied patch '||l_patch);

281: sqltxt := sqltxt||' where patch_name= '''||l_patch||'''';
282: end if;
283: sqltxt := sqltxt||' group by patch_name, patch_type order by max(creation_date) desc';
284:
285: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sqltxt,'Display applied patch '||l_patch);
286:
287: elsif l_script ='manager' then
288: sqltxt :='SELECT fa.application_name "Application Name" '||
289: ' , fa.application_short_name "Application|Shortname" '||

Line 306: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sqltxt, 'Concurrent Managers related to Inventory');

302: 'ORDER BY fcp.application_id DESC '||
303: ', fcp.concurrent_processor_id '||
304: ', fcp.concurrent_processor_name';
305:
306: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sqltxt, 'Concurrent Managers related to Inventory');
307: sqltxt :='SELECT PROCESS_TYPE "Manager" '||
308: ' , PROCESS_NAME "Internal|Name" '||
309: ' , WORKER_ROWS "Worker|Rows" '||
310: ' , TIMEOUT_HOURS || '':'' || TIMEOUT_MINUTES "Timeout|Hrs:Min" '||

Line 319: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sqltxt, 'Configuration of the INV Txn Manager');

315: ' , PROCESS_CODE'||
316: ' , PROCESS_APP_SHORT_NAME'||
317: ' FROM mtl_interface_proc_controls_v '||
318: 'ORDER BY process_type ' ;
319: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sqltxt, 'Configuration of the INV Txn Manager');
320:
321: if l_conc_prg is not null then
322: sqltxt :=' SELECT request_id "Request" '||
323: ' , fcp.concurrent_program_name "Concurrent Program" '||

Line 360: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sqltxt,'Concurrent request information');

356: ' FROM fnd_concurrent_requests fcr, fnd_concurrent_programs fcp '||
357: ' WHERE fcp.concurrent_program_name = '''||l_conc_prg||''''||
358: ' AND fcp.concurrent_program_id = fcr.concurrent_program_id '||
359: ' AND fcp.application_id = fcr.program_application_id ';
360: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sqltxt,'Concurrent request information');
361: end if;
362:
363: elsif l_script ='debug' then
364: sqltxt :='SELECT b.user_profile_option_name "Long Name" '||

Line 416: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sqltxt,'Debug- and Trace-related profileoptions');

412: ' , ''WIP_CONC_MESSAGE_LEVEL'' '||
413: ' , ''WSH_DEBUG_LOG_DIRECTORY'' , ''WSH_DEBUG_MODE'' '||
414: ' ) '||
415: 'ORDER BY b.user_profile_option_name, c.level_id';
416: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sqltxt,'Debug- and Trace-related profileoptions');
417:
418: sqltxt :='SELECT name, value '||
419: 'FROM v$parameter '||
420: 'WHERE UPPER( name ) IN ( ''UTL_FILE_DIR'', ''USER_DUMP_DEST'', ''MAX_DUMP_FILE_SIZE'' )';

Line 421: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sqltxt,'DB parameters : UTL_FILE_DIR , USER_DUMP_DEST and MAX_DUMP_FILE_SIZE');

417:
418: sqltxt :='SELECT name, value '||
419: 'FROM v$parameter '||
420: 'WHERE UPPER( name ) IN ( ''UTL_FILE_DIR'', ''USER_DUMP_DEST'', ''MAX_DUMP_FILE_SIZE'' )';
421: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sqltxt,'DB parameters : UTL_FILE_DIR , USER_DUMP_DEST and MAX_DUMP_FILE_SIZE');
422: end if;
423: -- construct report
424: statusStr := 'SUCCESS';
425: isFatal := 'FALSE';