APPS.ISC_EDW_BACKLOGS_F_P dependencies on EDW_LOG

Line 98: EDW_LOG.Put_Line('Other errors in Insert_Fstg : '|| l_exception_msg);

94: g_errbuf := sqlerrm;
95: g_retcode := -1;
96: l_exception_msg := g_retcode || ':' || g_errbuf;
97: ROLLBACK;
98: EDW_LOG.Put_Line('Other errors in Insert_Fstg : '|| l_exception_msg);
99: RAISE;
100:
101: END INSERT_FSTG;
102:

Line 133: EDW_LOG.Put_Line('Marking '||l_count||' rows to be deleted from the Backlog Fact during next load');

129: l_count := l_count + 1;
130: END;
131: END IF;
132: END LOOP;
133: EDW_LOG.Put_Line('Marking '||l_count||' rows to be deleted from the Backlog Fact during next load');
134: EDW_LOG.Put_Line('All snapshots taken between '||l_from_date||' and '||l_to_date||' will be deleted.'); COMMIT;
135: END;
136: ELSE
137: BEGIN

Line 134: EDW_LOG.Put_Line('All snapshots taken between '||l_from_date||' and '||l_to_date||' will be deleted.'); COMMIT;

130: END;
131: END IF;
132: END LOOP;
133: EDW_LOG.Put_Line('Marking '||l_count||' rows to be deleted from the Backlog Fact during next load');
134: EDW_LOG.Put_Line('All snapshots taken between '||l_from_date||' and '||l_to_date||' will be deleted.'); COMMIT;
135: END;
136: ELSE
137: BEGIN
138: IF p_nb_days < 0

Line 139: THEN EDW_LOG.Put_Line('Please enter a positive number for the Number of Days');

135: END;
136: ELSE
137: BEGIN
138: IF p_nb_days < 0
139: THEN EDW_LOG.Put_Line('Please enter a positive number for the Number of Days');
140: ELSE
141: BEGIN
142: IF p_nb_days IS NULL
143: THEN EDW_LOG.Put_Line('All parameters are NULL,

Line 143: THEN EDW_LOG.Put_Line('All parameters are NULL,

139: THEN EDW_LOG.Put_Line('Please enter a positive number for the Number of Days');
140: ELSE
141: BEGIN
142: IF p_nb_days IS NULL
143: THEN EDW_LOG.Put_Line('All parameters are NULL,
144: please enter the following parameters :
145:
146: - both "FROM DATE" and "TO DATE", corresponding to the periode you want to PURGE,
147: or

Line 159: EDW_LOG.Put_Line('Marking '||l_count||' rows to be deleted from the Backlog Fact during next load.');

155: INSERT_FSTG(snap_rec.c_pk);
156: l_count := l_count + 1;
157: END IF;
158: END LOOP;
159: EDW_LOG.Put_Line('Marking '||l_count||' rows to be deleted from the Backlog Fact during next load.');
160: EDW_LOG.Put_Line('All snapshots taken prior to '||(sysdate - p_nb_days)||' will be deleted.');
161: END;
162: COMMIT;
163: END IF;

Line 160: EDW_LOG.Put_Line('All snapshots taken prior to '||(sysdate - p_nb_days)||' will be deleted.');

156: l_count := l_count + 1;
157: END IF;
158: END LOOP;
159: EDW_LOG.Put_Line('Marking '||l_count||' rows to be deleted from the Backlog Fact during next load.');
160: EDW_LOG.Put_Line('All snapshots taken prior to '||(sysdate - p_nb_days)||' will be deleted.');
161: END;
162: COMMIT;
163: END IF;
164: END;

Line 175: EDW_LOG.Put_Line('Other errors in Delete_Fact : '|| l_exception_msg);

171: g_errbuf := sqlerrm;
172: g_retcode := -1;
173: l_exception_msg := g_retcode || ':' || g_errbuf;
174: ROLLBACK;
175: EDW_LOG.Put_Line('Other errors in Delete_Fact : '|| l_exception_msg);
176: RAISE;
177:
178: END DELETE_FACT;
179: