DBA Data[Home] [Help]

APPS.MRP_EPI dependencies on FND_FILE

Line 542: FND_FILE.put_line(fnd_file.log,'MRP_BIS_FORECAST_WB : '||sqlerrm(sqlcode));

538: DBMS_STATS.gather_table_stats('MRP','MRP_BIS_FORECAST_WB', estimate_percent
539: => 10, degree => 2, granularity => 'GLOBAL', cascade =>TRUE);
540: EXCEPTION
541: WHEN OTHERS THEN
542: FND_FILE.put_line(fnd_file.log,'MRP_BIS_FORECAST_WB : '||sqlerrm(sqlcode));
543: END;
544:
545: /*----------------------------------------------------------------+
546: | Each run of the concurrent program repopulates the summary |

Line 567: FND_FILE.put_line(fnd_file.log,'Drop Index 1 Error : '||SQLERRM(sqlcode));

563: object_name => 'MRP_BIS_FORECAST_WB');
564: --
565: EXCEPTION
566: WHEN OTHERS THEN
567: FND_FILE.put_line(fnd_file.log,'Drop Index 1 Error : '||SQLERRM(sqlcode));
568: END;
569: --
570: BEGIN
571: ad_ddl.do_ddl( applsys_schema => 'APPLSYS',

Line 581: FND_FILE.put_line(fnd_file.log,'Drop Index 2 Error : '||SQLERRM(sqlcode));

577:
578: --
579: EXCEPTION
580: WHEN OTHERS THEN
581: FND_FILE.put_line(fnd_file.log,'Drop Index 2 Error : '||SQLERRM(sqlcode));
582: END;
583:
584: /*----------------------------------------------------------------+
585: | Insert forecast records this select statement retrieves the |

Line 868: FND_FILE.put_line(fnd_file.log,'Create Index 1 Error : '||SQLERRM(sqlcode))

864: ||' STORAGE (INITIAL 40K NEXT 2520K PCTINCREASE 50) ',
865: object_name =>'MRP_BIS_FORECAST_WB');
866: EXCEPTION
867: WHEN OTHERS THEN
868: FND_FILE.put_line(fnd_file.log,'Create Index 1 Error : '||SQLERRM(sqlcode))
869: ;
870: END;
871:
872: BEGIN

Line 884: FND_FILE.put_line(fnd_file.log,'Create Index 2 Error : '||SQLERRM(sqlcode));

880: ||' STORAGE (INITIAL 40K NEXT 3784K PCTINCREASE 50) ',
881: object_name =>'MRP_BIS_FORECAST_WB');
882: EXCEPTION
883: WHEN OTHERS THEN
884: FND_FILE.put_line(fnd_file.log,'Create Index 2 Error : '||SQLERRM(sqlcode));
885: END;
886:
887: /*---------------------------------------------------------------------+
888: | Corner-case to catch records that match with order on everything |