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.FND_STATS dependencies on FND_FILE

Line 230: -- FND_FILE.put_line(FND_FILE.log,l_message);

226: END IF;
227: -- dbms_output.put_line('Request_id is '||request_id);
228: -- dbms_output.put_line('Effective Request_id is '||request_id_l);
229: -- l_message := 'Request_id is '||cur_request_id|| 'Effective Request_id is '||request_id_l;
230: -- FND_FILE.put_line(FND_FILE.log,l_message);
231: RETURN request_id_l;
232: END;
233: /************************************************************************/
234: /* Procedure: CREATE_STAT_TABLE */

Line 325: FND_FILE.put_line(FND_FILE.log,l_message);

321: WHEN exist_insufficient THEN
322: errbuf := sqlerrm ;
323: retcode := '2';
324: l_message := errbuf;
325: FND_FILE.put_line(FND_FILE.log,l_message);
326: raise;
327: WHEN OTHERS THEN
328: errbuf := sqlerrm ;
329: retcode := '2';

Line 331: FND_FILE.put_line(FND_FILE.log,l_message);

327: WHEN OTHERS THEN
328: errbuf := sqlerrm ;
329: retcode := '2';
330: l_message := errbuf;
331: FND_FILE.put_line(FND_FILE.log,l_message);
332: raise;
333: END;
334: /************************************************************************/
335: /* Procedure: BACKUP_SCHEMA_STATS */

Line 388: FND_FILE.put_line(FND_FILE.log,l_message);

384: WHEN exist_insufficient THEN
385: errbuf := sqlerrm ;
386: retcode := '2';
387: l_message := errbuf;
388: FND_FILE.put_line(FND_FILE.log,l_message);
389: raise;
390: WHEN OTHERS THEN
391: errbuf := sqlerrm ;
392: retcode := '2';

Line 394: FND_FILE.put_line(FND_FILE.log,l_message);

390: WHEN OTHERS THEN
391: errbuf := sqlerrm ;
392: retcode := '2';
393: l_message := errbuf;
394: FND_FILE.put_line(FND_FILE.log,l_message);
395: raise;
396: END;
397: /* BACKUP_TABLE_STATS */
398: /************************************************************************/

Line 471: FND_FILE.put_line(FND_FILE.log,l_message);

467: WHEN exist_insufficient THEN
468: errbuf := sqlerrm;
469: retcode := '2';
470: l_message := errbuf;
471: FND_FILE.put_line(FND_FILE.log,l_message);
472: raise;
473: WHEN exist_invalid THEN
474: errbuf := 'ORA-20001: Invalid or inconsistent values in the user stattab ='
475: ||fnd_stattab

Line 480: FND_FILE.put_line(FND_FILE.log,l_message);

476: ||' statid='
477: ||statid ;
478: retcode := '2';
479: l_message := errbuf;
480: FND_FILE.put_line(FND_FILE.log,l_message);
481: raise;
482: WHEN OTHERS THEN
483: errbuf := sqlerrm ;
484: retcode := '2';

Line 486: FND_FILE.put_line(FND_FILE.log,l_message);

482: WHEN OTHERS THEN
483: errbuf := sqlerrm ;
484: retcode := '2';
485: l_message := errbuf;
486: FND_FILE.put_line(FND_FILE.log,l_message);
487: raise;
488: END;
489: /* RESTORE_TABLE_STATS */
490: /************************************************************************/

Line 585: FND_FILE.put_line(FND_FILE.log,p_str);

581: PROCEDURE dlog(p_str IN VARCHAR2)
582: IS
583: BEGIN
584: dbms_output.put_line(SUBSTR(p_str,1,250));
585: FND_FILE.put_line(FND_FILE.log,p_str);
586: END dlog;
587: /************************************************************************/
588: /* Procedure: GATHER_TABLE_STATS_PVT */
589: /* Desciption: Private package that now calls dbms_stats dynamically */

Line 759: FND_FILE.put_line(FND_FILE.log,l_message);

755: || ' degree = '
756: || TO_CHAR(degree_parallel)
757: || ' internal_flag= '
758: || internal_flag ;
759: FND_FILE.put_line(FND_FILE.log,l_message);
760: BEGIN
761: FND_STATS.GATHER_SCHEMA_STATS(schemaname, estimate_percent, degree_parallel, internal_flag , request_id,stathist, OPTIONS,modpercent,invalidate); -- removed errors parameter for error handling
762: EXCEPTION
763: WHEN exist_insufficient THEN

Line 767: FND_FILE.put_line(FND_FILE.log,l_message);

763: WHEN exist_insufficient THEN
764: errbuf := sqlerrm ;
765: retcode := '2';
766: l_message := errbuf;
767: FND_FILE.put_line(FND_FILE.log,l_message);
768: raise;
769: WHEN bad_input THEN
770: errbuf := sqlerrm ;
771: retcode := '2';

Line 773: FND_FILE.put_line(FND_FILE.log,l_message);

769: WHEN bad_input THEN
770: errbuf := sqlerrm ;
771: retcode := '2';
772: l_message := errbuf;
773: FND_FILE.put_line(FND_FILE.log,l_message);
774: raise;
775: WHEN OTHERS THEN
776: errbuf := sqlerrm ;
777: retcode := '2';

Line 779: FND_FILE.put_line(FND_FILE.log,l_message);

775: WHEN OTHERS THEN
776: errbuf := sqlerrm ;
777: retcode := '2';
778: l_message := errbuf;
779: FND_FILE.put_line(FND_FILE.log,l_message);
780: raise;
781: END;
782: FOR i IN 0..MAX_ERRORS_PRINTED
783: LOOP

Line 787: FND_FILE.put_line(FND_FILE.log,'Error #'

783: LOOP
784: EXIT
785: WHEN g_Errors(i) IS NULL;
786: Error_counter:=i+1;
787: FND_FILE.put_line(FND_FILE.log,'Error #'
788: ||Error_counter
789: || ': '
790: ||g_Errors(i));
791: -- added to send back status to concurrent program manager bug 2625022

Line 1042: --fnd_file.put_line(FND_FILE.log,s_message);

1038: || 'is locked ');
1039: dlog('stats on table '
1040: || rec_cur.table_name
1041: || ' is locked ');
1042: --fnd_file.put_line(FND_FILE.log,s_message);
1043: END LOOP;
1044: elsif ( (upper(OPTIONS)='GATHER AUTO') OR
1045: (
1046: upper(OPTIONS)='LIST AUTO'

Line 1153: --fnd_file.put_line(FND_FILE.log,s_message);

1149: || 'is locked ');
1150: dlog('stats on table '
1151: || rec_cur.table_name
1152: || ' is locked ');
1153: --fnd_file.put_line(FND_FILE.log,s_message);
1154: END LOOP;
1155: -- GATHER AUTO includes GATHER EMPTY, so gather stats
1156: -- on any unalalyzed tables and/or indexes.
1157: FOR c_rec IN empty_cur(upper(schemaname))

Line 1250: --fnd_file.put_line(FND_FILE.log,s_message);

1246: || ' is locked ');
1247: dlog('stats on table '
1248: || rec_cur.table_name
1249: || ' is locked ');
1250: --fnd_file.put_line(FND_FILE.log,s_message);
1251: END LOOP;
1252: END IF;
1253: /* end of if upper(options)= */
1254: -- End timestamp

Line 1274: fnd_file.put_line(FND_FILE.log,s_message);

1270: loop
1271: dbms_output.put_line('stats on table ' || rec_cur.table_name || 'is locked ');
1272: dlog('stats on table ' || rec_cur.table_name || 'is locked ');
1273: s_message := 'stats on table ' || rec_cur.table_name || ' is locked ' ;
1274: fnd_file.put_line(FND_FILE.log,s_message);
1275: end loop; */
1276: END LOOP;
1277: /* schema_cur */
1278: END IF;

Line 1531: --fnd_file.put_line(FND_FILE.log,s_message);

1527: dlog('stats on table '
1528: || rec_cur.table_name
1529: || ' is locked ');
1530: -- s_message := 'stats on table ' || rec_cur.table_name || ' is locked ' ;
1531: --fnd_file.put_line(FND_FILE.log,s_message);
1532: END LOOP;
1533: elsif ( (upper(OPTIONS)='GATHER AUTO') OR
1534: (
1535: upper(OPTIONS)='LIST AUTO'

Line 1642: --fnd_file.put_line(FND_FILE.log,s_message);

1638: dlog('stats on table '
1639: || rec_cur.table_name
1640: || ' is locked ');
1641: -- s_message := 'stats on table ' || rec_cur.table_name || ' is locked ' ;
1642: --fnd_file.put_line(FND_FILE.log,s_message);
1643: END LOOP;
1644: -- GATHER AUTO includes GATHER EMPTY, so gather stats
1645: -- on any unalalyzed tables and/or indexes.
1646: FOR c_rec IN empty_cur(upper(schemaname))

Line 1719: --fnd_file.put_line(FND_FILE.log,s_message);

1715: dlog('stats on table '
1716: || rec_cur.table_name
1717: || ' is locked ');
1718: -- s_message := 'stats on table ' || rec_cur.table_name || ' is locked ' ;
1719: --fnd_file.put_line(FND_FILE.log,s_message);
1720: END LOOP;
1721: END IF;
1722: /* end of if upper(options)= */
1723: -- End timestamp

Line 1849: FND_FILE.put_line(FND_FILE.log,l_message);

1845: WHEN exist_insufficient THEN
1846: errbuf := sqlerrm ;
1847: retcode := '2';
1848: l_message := errbuf;
1849: FND_FILE.put_line(FND_FILE.log,l_message);
1850: raise;
1851: WHEN OTHERS THEN
1852: errbuf := sqlerrm ;
1853: retcode := '2';

Line 1855: FND_FILE.put_line(FND_FILE.log,l_message);

1851: WHEN OTHERS THEN
1852: errbuf := sqlerrm ;
1853: retcode := '2';
1854: l_message := errbuf;
1855: FND_FILE.put_line(FND_FILE.log,l_message);
1856: raise;
1857: END;
1858: /* GATHER_TABLE_STATS */
1859: /************************************************************************/

Line 2388: FND_FILE.put_line(FND_FILE.log,l_message);

2384: WHEN OTHERS THEN
2385: errbuf := sqlerrm ;
2386: retcode := '2';
2387: l_message := errbuf;
2388: FND_FILE.put_line(FND_FILE.log,l_message);
2389: raise;
2390: END;
2391: /* end of conc mgr GATHER_ALL_COLUMN_STATS */
2392: /************************************************************************/

Line 2424: FND_FILE.put_line(FND_FILE.log,l_message);

2420: ||'.'
2421: ||colname
2422: ||' backup_flag= '
2423: || backup_flag ;
2424: FND_FILE.put_line(FND_FILE.log,l_message);
2425: dlog(l_message);
2426: BEGIN
2427: dlog('about to g c s');
2428: FND_STATS.GATHER_COLUMN_STATS(ownname,tabname,colname,percent,degree ,hsize,backup_flag,partname,hmode,invalidate);

Line 2434: FND_FILE.put_line(FND_FILE.log,l_message);

2430: WHEN exist_insufficient THEN
2431: errbuf := sqlerrm ;
2432: retcode := '2';
2433: l_message := errbuf;
2434: FND_FILE.put_line(FND_FILE.log,l_message);
2435: raise;
2436: WHEN OTHERS THEN
2437: errbuf := sqlerrm ;
2438: retcode := '2';

Line 2440: FND_FILE.put_line(FND_FILE.log,l_message);

2436: WHEN OTHERS THEN
2437: errbuf := sqlerrm ;
2438: retcode := '2';
2439: l_message := errbuf;
2440: FND_FILE.put_line(FND_FILE.log,l_message);
2441: raise;
2442: END;
2443: END;
2444: /* end of GATHER_COLUMN_STATS for conc. job */

Line 3341: FND_FILE.put_line(FND_FILE.log,errbuf);

3337: EXCEPTION
3338: WHEN OTHERS THEN
3339: errbuf := sqlerrm ;
3340: retcode := '2';
3341: FND_FILE.put_line(FND_FILE.log,errbuf);
3342: raise;
3343: END;
3344: /************************************************************************/
3345: /* Procedure: table_stats */