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

Line 849: fnd_file.PUT_LINE(fnd_file.LOG, ' ');

845: set_rec set_refresh_numbers % rowtype;
846: deleted NUMBER;
847:
848: BEGIN
849: fnd_file.PUT_LINE(fnd_file.LOG, ' ');
850: fnd_file.PUT_LINE(fnd_file.LOG, '+---------------------------------------------------------------------------+');
851: fnd_file.PUT_LINE(fnd_file.LOG, '+--------------Entering the procedure purge_custom_data_stream--------------+');
852:
853: FOR rec IN min_refresh_numbers

Line 850: fnd_file.PUT_LINE(fnd_file.LOG, '+---------------------------------------------------------------------------+');

846: deleted NUMBER;
847:
848: BEGIN
849: fnd_file.PUT_LINE(fnd_file.LOG, ' ');
850: fnd_file.PUT_LINE(fnd_file.LOG, '+---------------------------------------------------------------------------+');
851: fnd_file.PUT_LINE(fnd_file.LOG, '+--------------Entering the procedure purge_custom_data_stream--------------+');
852:
853: FOR rec IN min_refresh_numbers
854: LOOP

Line 851: fnd_file.PUT_LINE(fnd_file.LOG, '+--------------Entering the procedure purge_custom_data_stream--------------+');

847:
848: BEGIN
849: fnd_file.PUT_LINE(fnd_file.LOG, ' ');
850: fnd_file.PUT_LINE(fnd_file.LOG, '+---------------------------------------------------------------------------+');
851: fnd_file.PUT_LINE(fnd_file.LOG, '+--------------Entering the procedure purge_custom_data_stream--------------+');
852:
853: FOR rec IN min_refresh_numbers
854: LOOP
855:

Line 874: fnd_file.PUT_LINE(fnd_file.LOG, l_sql_stmt);

870:
871: EXECUTE IMMEDIATE l_sql_stmt;
872:
873: IF fnd_profile.VALUE('MRP_DEBUG_MODE') = 'Y' THEN
874: fnd_file.PUT_LINE(fnd_file.LOG, l_sql_stmt);
875: END IF;
876:
877: COMMIT;
878:

Line 879: --fnd_file.PUT_LINE(fnd_file.LOG, l_sql_stmt);

875: END IF;
876:
877: COMMIT;
878:
879: --fnd_file.PUT_LINE(fnd_file.LOG, l_sql_stmt);
880: deleted := deleted + set_rec.deleted_rec;
881:
882: END IF;
883:

Line 891: fnd_file.PUT_LINE(fnd_file.LOG, to_char(deleted) || ' unused records purged for the custom stream - ' || rec.csname);

887:
888: CLOSE set_refresh_numbers;
889:
890: IF deleted > 0 THEN
891: fnd_file.PUT_LINE(fnd_file.LOG, to_char(deleted) || ' unused records purged for the custom stream - ' || rec.csname);
892:
893: END IF;
894:
895: END IF;

Line 899: fnd_file.PUT_LINE(fnd_file.LOG, '+-------------Exiting from the procedure purge_custom_data_stream-----------+');

895: END IF;
896:
897: END LOOP;
898:
899: fnd_file.PUT_LINE(fnd_file.LOG, '+-------------Exiting from the procedure purge_custom_data_stream-----------+');
900: fnd_file.PUT_LINE(fnd_file.LOG, '+---------------------------------------------------------------------------+');
901: fnd_file.PUT_LINE(fnd_file.LOG, ' ');
902:
903: EXCEPTION

Line 900: fnd_file.PUT_LINE(fnd_file.LOG, '+---------------------------------------------------------------------------+');

896:
897: END LOOP;
898:
899: fnd_file.PUT_LINE(fnd_file.LOG, '+-------------Exiting from the procedure purge_custom_data_stream-----------+');
900: fnd_file.PUT_LINE(fnd_file.LOG, '+---------------------------------------------------------------------------+');
901: fnd_file.PUT_LINE(fnd_file.LOG, ' ');
902:
903: EXCEPTION
904: WHEN others THEN

Line 901: fnd_file.PUT_LINE(fnd_file.LOG, ' ');

897: END LOOP;
898:
899: fnd_file.PUT_LINE(fnd_file.LOG, '+-------------Exiting from the procedure purge_custom_data_stream-----------+');
900: fnd_file.PUT_LINE(fnd_file.LOG, '+---------------------------------------------------------------------------+');
901: fnd_file.PUT_LINE(fnd_file.LOG, ' ');
902:
903: EXCEPTION
904: WHEN others THEN
905: lv_error_text := SUBSTR(sqlerrm, 1, 240);

Line 906: fnd_file.PUT_LINE(fnd_file.LOG, 'Error while purging unused custom stream data');

902:
903: EXCEPTION
904: WHEN others THEN
905: lv_error_text := SUBSTR(sqlerrm, 1, 240);
906: fnd_file.PUT_LINE(fnd_file.LOG, 'Error while purging unused custom stream data');
907: fnd_file.PUT_LINE(fnd_file.LOG, lv_error_text);
908: retcode := -1;
909:
910: END purge_custom_stream_data;

Line 907: fnd_file.PUT_LINE(fnd_file.LOG, lv_error_text);

903: EXCEPTION
904: WHEN others THEN
905: lv_error_text := SUBSTR(sqlerrm, 1, 240);
906: fnd_file.PUT_LINE(fnd_file.LOG, 'Error while purging unused custom stream data');
907: fnd_file.PUT_LINE(fnd_file.LOG, lv_error_text);
908: retcode := -1;
909:
910: END purge_custom_stream_data;
911: