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 232: -- FND_FILE.put_line(FND_FILE.log,l_message);

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

773: WHEN bad_input THEN
774: errbuf := sqlerrm ;
775: retcode := '2';
776: l_message := errbuf;
777: FND_FILE.put_line(FND_FILE.log,l_message);
778: raise;
779: WHEN OTHERS THEN
780: errbuf := sqlerrm ;
781: retcode := '2';

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

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

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

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

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

1442: || 'is locked ');
1443: dlog('stats on table '
1444: || rec_cur.table_name
1445: || ' is locked ');
1446: --fnd_file.put_line(FND_FILE.log,s_message);
1447: END LOOP;
1448: elsif ( (upper(OPTIONS)='GATHER AUTO') OR
1449: (
1450: upper(OPTIONS)='LIST AUTO'

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

1573: || 'is locked ');
1574: dlog('stats on table '
1575: || rec_cur.table_name
1576: || ' is locked ');
1577: --fnd_file.put_line(FND_FILE.log,s_message);
1578: END LOOP;
1579: -- GATHER AUTO includes GATHER EMPTY, so gather stats
1580: -- on any unalalyzed tables and/or indexes.
1581: FOR c_rec IN empty_cur_ten(upper(schemaname))

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

1675: || ' is locked ');
1676: dlog('stats on table '
1677: || rec_cur.table_name
1678: || ' is locked ');
1679: --fnd_file.put_line(FND_FILE.log,s_message);
1680: END LOOP;
1681: END IF;
1682: $END
1683: -- ENDI IF;

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

1702: loop
1703: dbms_output.put_line('stats on table ' || rec_cur.table_name || 'is locked ');
1704: dlog('stats on table ' || rec_cur.table_name || 'is locked ');
1705: s_message := 'stats on table ' || rec_cur.table_name || ' is locked ' ;
1706: fnd_file.put_line(FND_FILE.log,s_message);
1707: end loop; */
1708: END LOOP;
1709: /* schema_cur */
1710: END IF;

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

2326: dlog('stats on table '
2327: || rec_cur.table_name
2328: || ' is locked ');
2329: -- s_message := 'stats on table ' || rec_cur.table_name || ' is locked ' ;
2330: --fnd_file.put_line(FND_FILE.log,s_message);
2331: END LOOP;
2332: elsif ( (upper(OPTIONS)='GATHER AUTO') OR
2333: (
2334: upper(OPTIONS)='LIST AUTO'

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

2455: dlog('stats on table '
2456: || rec_cur.table_name
2457: || ' is locked ');
2458: -- s_message := 'stats on table ' || rec_cur.table_name || ' is locked ' ;
2459: --fnd_file.put_line(FND_FILE.log,s_message);
2460: END LOOP;
2461: -- GATHER AUTO includes GATHER EMPTY, so gather stats
2462: -- on any unalalyzed tables and/or indexes.
2463: FOR c_rec IN empty_cur_ten(upper(schemaname))

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

2535: dlog('stats on table '
2536: || rec_cur.table_name
2537: || ' is locked ');
2538: -- s_message := 'stats on table ' || rec_cur.table_name || ' is locked ' ;
2539: --fnd_file.put_line(FND_FILE.log,s_message);
2540: END LOOP;
2541: END IF;
2542: $END
2543: -- End timestamp

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

2669: WHEN exist_insufficient THEN
2670: errbuf := sqlerrm ;
2671: retcode := '2';
2672: l_message := errbuf;
2673: FND_FILE.put_line(FND_FILE.log,l_message);
2674: raise;
2675: WHEN OTHERS THEN
2676: errbuf := sqlerrm ;
2677: retcode := '2';

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

2675: WHEN OTHERS THEN
2676: errbuf := sqlerrm ;
2677: retcode := '2';
2678: l_message := errbuf;
2679: FND_FILE.put_line(FND_FILE.log,l_message);
2680: raise;
2681: END;
2682: /* GATHER_TABLE_STATS */
2683: /************************************************************************/

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

3336: WHEN OTHERS THEN
3337: errbuf := sqlerrm ;
3338: retcode := '2';
3339: l_message := errbuf;
3340: FND_FILE.put_line(FND_FILE.log,l_message);
3341: raise;
3342: END;
3343: /* end of conc mgr GATHER_ALL_COLUMN_STATS */
3344: /************************************************************************/

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

3372: ||'.'
3373: ||colname
3374: ||' backup_flag= '
3375: || backup_flag ;
3376: FND_FILE.put_line(FND_FILE.log,l_message);
3377: dlog(l_message);
3378: BEGIN
3379: dlog('about to g c s');
3380: FND_STATS.GATHER_COLUMN_STATS(ownname,tabname,colname,percent,degree ,hsize,backup_flag,partname,hmode,invalidate);

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

3382: WHEN exist_insufficient THEN
3383: errbuf := sqlerrm ;
3384: retcode := '2';
3385: l_message := errbuf;
3386: FND_FILE.put_line(FND_FILE.log,l_message);
3387: raise;
3388: WHEN OTHERS THEN
3389: errbuf := sqlerrm ;
3390: retcode := '2';

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

3388: WHEN OTHERS THEN
3389: errbuf := sqlerrm ;
3390: retcode := '2';
3391: l_message := errbuf;
3392: FND_FILE.put_line(FND_FILE.log,l_message);
3393: raise;
3394: END;
3395: END;
3396: /* end of GATHER_COLUMN_STATS for conc. job */

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

4290: EXCEPTION
4291: WHEN OTHERS THEN
4292: errbuf := sqlerrm ;
4293: retcode := '2';
4294: FND_FILE.put_line(FND_FILE.log,errbuf);
4295: raise;
4296: END;
4297: /************************************************************************/
4298: /* Procedure: table_stats */