96: l_progress VARCHAR2(3);
97:
98: BEGIN
99:
100: fnd_file.put_line(fnd_file.log ,'>> PO_DRAFT_EVENTS_PKG.DELETE_DRAFT_EVENTS');
101:
102: l_progress := '000';
103:
104: IF g_debug_stmt THEN
169: IF g_debug_stmt THEN
170: PO_DEBUG.debug_stmt(l_log_head,l_progress,'After Deletion of Unprocessed Events');
171: END IF;
172:
173: fnd_file.put_line(fnd_file.log ,'The following BC unprocessed/Error events have been deleted');
174: fnd_file.put_line(fnd_file.log ,'Event_id Event_status_code Process_status_code');
175: fnd_file.put_line(fnd_file.log ,'--------- ----------------- -------------------');
176:
177: FOR i IN 1..l_event_count LOOP
170: PO_DEBUG.debug_stmt(l_log_head,l_progress,'After Deletion of Unprocessed Events');
171: END IF;
172:
173: fnd_file.put_line(fnd_file.log ,'The following BC unprocessed/Error events have been deleted');
174: fnd_file.put_line(fnd_file.log ,'Event_id Event_status_code Process_status_code');
175: fnd_file.put_line(fnd_file.log ,'--------- ----------------- -------------------');
176:
177: FOR i IN 1..l_event_count LOOP
178: fnd_file.put_line(fnd_file.log ,l_events_tab(i).event_id||' '||
171: END IF;
172:
173: fnd_file.put_line(fnd_file.log ,'The following BC unprocessed/Error events have been deleted');
174: fnd_file.put_line(fnd_file.log ,'Event_id Event_status_code Process_status_code');
175: fnd_file.put_line(fnd_file.log ,'--------- ----------------- -------------------');
176:
177: FOR i IN 1..l_event_count LOOP
178: fnd_file.put_line(fnd_file.log ,l_events_tab(i).event_id||' '||
179: l_events_tab(i).event_status_code ||' '||
174: fnd_file.put_line(fnd_file.log ,'Event_id Event_status_code Process_status_code');
175: fnd_file.put_line(fnd_file.log ,'--------- ----------------- -------------------');
176:
177: FOR i IN 1..l_event_count LOOP
178: fnd_file.put_line(fnd_file.log ,l_events_tab(i).event_id||' '||
179: l_events_tab(i).event_status_code ||' '||
180: l_events_tab(i).process_status_code);
181:
182:
179: l_events_tab(i).event_status_code ||' '||
180: l_events_tab(i).process_status_code);
181:
182:
183: fnd_file.put_line(fnd_file.log ,'Count of BC events deleted:' || l_event_count);
184: fnd_file.put_line(fnd_file.log ,'>> PO_DRAFT_EVENTS_PKG.DELETE_DRAFT_EVENTS');
185:
186: l_progress := '005';
187:
180: l_events_tab(i).process_status_code);
181:
182:
183: fnd_file.put_line(fnd_file.log ,'Count of BC events deleted:' || l_event_count);
184: fnd_file.put_line(fnd_file.log ,'>> PO_DRAFT_EVENTS_PKG.DELETE_DRAFT_EVENTS');
185:
186: l_progress := '005';
187:
188: IF g_debug_stmt THEN