31089:
31090: l_first_event_id := l_array_header_events(l_array_header_events.FIRST);
31091: l_last_event_id := l_array_header_events(l_array_header_events.LAST);
31092:
31093: fnd_file.put_line(fnd_file.LOG, ' ');
31094: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
31095: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );
31096: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');
31097:
31090: l_first_event_id := l_array_header_events(l_array_header_events.FIRST);
31091: l_last_event_id := l_array_header_events(l_array_header_events.LAST);
31092:
31093: fnd_file.put_line(fnd_file.LOG, ' ');
31094: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
31095: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );
31096: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');
31097:
31098: FOR line_record IN line_cur(l_first_event_id, l_last_event_id)
31091: l_last_event_id := l_array_header_events(l_array_header_events.LAST);
31092:
31093: fnd_file.put_line(fnd_file.LOG, ' ');
31094: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
31095: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );
31096: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');
31097:
31098: FOR line_record IN line_cur(l_first_event_id, l_last_event_id)
31099: LOOP
31092:
31093: fnd_file.put_line(fnd_file.LOG, ' ');
31094: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
31095: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );
31096: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');
31097:
31098: FOR line_record IN line_cur(l_first_event_id, l_last_event_id)
31099: LOOP
31100: IF (NOT l_array_header_events.EXISTS(line_record.event_id)) AND (NOT l_array_duplicate_checker.EXISTS(line_record.event_id)) THEN
31097:
31098: FOR line_record IN line_cur(l_first_event_id, l_last_event_id)
31099: LOOP
31100: IF (NOT l_array_header_events.EXISTS(line_record.event_id)) AND (NOT l_array_duplicate_checker.EXISTS(line_record.event_id)) THEN
31101: fnd_file.put_line(fnd_file.log, 'Event_id = ' || line_record.event_id);
31102: l_array_duplicate_checker(line_record.event_id) := line_record.event_id;
31103: END IF;
31104: END LOOP;
31105:
31102: l_array_duplicate_checker(line_record.event_id) := line_record.event_id;
31103: END IF;
31104: END LOOP;
31105:
31106: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
31107: fnd_file.put_line(fnd_file.LOG, ' ');
31108:
31109:
31110: xla_exceptions_pkg.raise_message
31103: END IF;
31104: END LOOP;
31105:
31106: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
31107: fnd_file.put_line(fnd_file.LOG, ' ');
31108:
31109:
31110: xla_exceptions_pkg.raise_message
31111: (p_location => 'XLA_00707_AAD_S_000007_BC_PKG.EventClass_53');
33167:
33168: l_first_event_id := l_array_header_events(l_array_header_events.FIRST);
33169: l_last_event_id := l_array_header_events(l_array_header_events.LAST);
33170:
33171: fnd_file.put_line(fnd_file.LOG, ' ');
33172: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
33173: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );
33174: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');
33175:
33168: l_first_event_id := l_array_header_events(l_array_header_events.FIRST);
33169: l_last_event_id := l_array_header_events(l_array_header_events.LAST);
33170:
33171: fnd_file.put_line(fnd_file.LOG, ' ');
33172: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
33173: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );
33174: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');
33175:
33176: FOR line_record IN line_cur(l_first_event_id, l_last_event_id)
33169: l_last_event_id := l_array_header_events(l_array_header_events.LAST);
33170:
33171: fnd_file.put_line(fnd_file.LOG, ' ');
33172: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
33173: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );
33174: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');
33175:
33176: FOR line_record IN line_cur(l_first_event_id, l_last_event_id)
33177: LOOP
33170:
33171: fnd_file.put_line(fnd_file.LOG, ' ');
33172: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
33173: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );
33174: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');
33175:
33176: FOR line_record IN line_cur(l_first_event_id, l_last_event_id)
33177: LOOP
33178: IF (NOT l_array_header_events.EXISTS(line_record.event_id)) AND (NOT l_array_duplicate_checker.EXISTS(line_record.event_id)) THEN
33175:
33176: FOR line_record IN line_cur(l_first_event_id, l_last_event_id)
33177: LOOP
33178: IF (NOT l_array_header_events.EXISTS(line_record.event_id)) AND (NOT l_array_duplicate_checker.EXISTS(line_record.event_id)) THEN
33179: fnd_file.put_line(fnd_file.log, 'Event_id = ' || line_record.event_id);
33180: l_array_duplicate_checker(line_record.event_id) := line_record.event_id;
33181: END IF;
33182: END LOOP;
33183:
33180: l_array_duplicate_checker(line_record.event_id) := line_record.event_id;
33181: END IF;
33182: END LOOP;
33183:
33184: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
33185: fnd_file.put_line(fnd_file.LOG, ' ');
33186:
33187:
33188: xla_exceptions_pkg.raise_message
33181: END IF;
33182: END LOOP;
33183:
33184: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
33185: fnd_file.put_line(fnd_file.LOG, ' ');
33186:
33187:
33188: xla_exceptions_pkg.raise_message
33189: (p_location => 'XLA_00707_AAD_S_000007_BC_PKG.EventClass_54');