APPS.FWK_PORTLET_GEN_UTIL dependencies on FND_FILE

Line 80: fnd_file.put_line(fnd_file.log, 'Refreshing materialized view');

76: retcode out nocopy number)
77: IS
78: begin
79:
80: fnd_file.put_line(fnd_file.log, 'Refreshing materialized view');
81: fnd_file.put_line(fnd_file.log, 'Start time : ' || to_char(sysdate, 'DD-MON-RR HH24:MI:SS'));
82:
83: dbms_mview.refresh('FWK_PORTLET_GEN_MV');
84:

Line 81: fnd_file.put_line(fnd_file.log, 'Start time : ' || to_char(sysdate, 'DD-MON-RR HH24:MI:SS'));

77: IS
78: begin
79:
80: fnd_file.put_line(fnd_file.log, 'Refreshing materialized view');
81: fnd_file.put_line(fnd_file.log, 'Start time : ' || to_char(sysdate, 'DD-MON-RR HH24:MI:SS'));
82:
83: dbms_mview.refresh('FWK_PORTLET_GEN_MV');
84:
85: fnd_file.put_line(fnd_file.log, 'Refresh successful.');

Line 85: fnd_file.put_line(fnd_file.log, 'Refresh successful.');

81: fnd_file.put_line(fnd_file.log, 'Start time : ' || to_char(sysdate, 'DD-MON-RR HH24:MI:SS'));
82:
83: dbms_mview.refresh('FWK_PORTLET_GEN_MV');
84:
85: fnd_file.put_line(fnd_file.log, 'Refresh successful.');
86: fnd_file.put_line(fnd_file.log, 'End time : ' || to_char(sysdate, 'DD-MON-RR HH24:MI:SS'));
87:
88:
89:

Line 86: fnd_file.put_line(fnd_file.log, 'End time : ' || to_char(sysdate, 'DD-MON-RR HH24:MI:SS'));

82:
83: dbms_mview.refresh('FWK_PORTLET_GEN_MV');
84:
85: fnd_file.put_line(fnd_file.log, 'Refresh successful.');
86: fnd_file.put_line(fnd_file.log, 'End time : ' || to_char(sysdate, 'DD-MON-RR HH24:MI:SS'));
87:
88:
89:
90: errbuf := 'Portlet MV Refresh successful.';

Line 127: fnd_file.put_line(fnd_file.log, 'Refreshing Portlet Generator Table');

123: appName appNameTAB;
124:
125: BEGIN
126:
127: fnd_file.put_line(fnd_file.log, 'Refreshing Portlet Generator Table');
128: fnd_file.put_line(fnd_file.log, 'Start time : ' || to_char(sysdate, 'DD-MON-RR HH24:MI:SS'));
129:
130: SELECT x.DOCUMENT_ID,
131: x.DOCUMENT_NAME,

Line 128: fnd_file.put_line(fnd_file.log, 'Start time : ' || to_char(sysdate, 'DD-MON-RR HH24:MI:SS'));

124:
125: BEGIN
126:
127: fnd_file.put_line(fnd_file.log, 'Refreshing Portlet Generator Table');
128: fnd_file.put_line(fnd_file.log, 'Start time : ' || to_char(sysdate, 'DD-MON-RR HH24:MI:SS'));
129:
130: SELECT x.DOCUMENT_ID,
131: x.DOCUMENT_NAME,
132: x.REGION_NAME,

Line 219: fnd_file.put_line(fnd_file.log, 'Refresh successful.');

215: regionName(i),
216: regionType(i),
217: appName(i));
218:
219: fnd_file.put_line(fnd_file.log, 'Refresh successful.');
220: fnd_file.put_line(fnd_file.log, 'End time : ' || to_char(sysdate, 'DD-MON-RR HH24:MI:SS'));
221:
222: errbuf := 'Portlet Table Refresh successful.';
223: retcode := 0;

Line 220: fnd_file.put_line(fnd_file.log, 'End time : ' || to_char(sysdate, 'DD-MON-RR HH24:MI:SS'));

216: regionType(i),
217: appName(i));
218:
219: fnd_file.put_line(fnd_file.log, 'Refresh successful.');
220: fnd_file.put_line(fnd_file.log, 'End time : ' || to_char(sysdate, 'DD-MON-RR HH24:MI:SS'));
221:
222: errbuf := 'Portlet Table Refresh successful.';
223: retcode := 0;
224: