22142:
22143: l_first_event_id := l_array_header_events(l_array_header_events.FIRST);
22144: l_last_event_id := l_array_header_events(l_array_header_events.LAST);
22145:
22146: fnd_file.put_line(fnd_file.LOG, ' ');
22147: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
22148: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );
22149: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');
22150:
22143: l_first_event_id := l_array_header_events(l_array_header_events.FIRST);
22144: l_last_event_id := l_array_header_events(l_array_header_events.LAST);
22145:
22146: fnd_file.put_line(fnd_file.LOG, ' ');
22147: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
22148: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );
22149: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');
22150:
22151: FOR line_record IN line_cur(l_first_event_id, l_last_event_id)
22144: l_last_event_id := l_array_header_events(l_array_header_events.LAST);
22145:
22146: fnd_file.put_line(fnd_file.LOG, ' ');
22147: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
22148: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );
22149: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');
22150:
22151: FOR line_record IN line_cur(l_first_event_id, l_last_event_id)
22152: LOOP
22145:
22146: fnd_file.put_line(fnd_file.LOG, ' ');
22147: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
22148: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );
22149: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');
22150:
22151: FOR line_record IN line_cur(l_first_event_id, l_last_event_id)
22152: LOOP
22153: IF (NOT l_array_header_events.EXISTS(line_record.event_id)) AND (NOT l_array_duplicate_checker.EXISTS(line_record.event_id)) THEN
22150:
22151: FOR line_record IN line_cur(l_first_event_id, l_last_event_id)
22152: LOOP
22153: IF (NOT l_array_header_events.EXISTS(line_record.event_id)) AND (NOT l_array_duplicate_checker.EXISTS(line_record.event_id)) THEN
22154: fnd_file.put_line(fnd_file.log, 'Event_id = ' || line_record.event_id);
22155: l_array_duplicate_checker(line_record.event_id) := line_record.event_id;
22156: END IF;
22157: END LOOP;
22158:
22155: l_array_duplicate_checker(line_record.event_id) := line_record.event_id;
22156: END IF;
22157: END LOOP;
22158:
22159: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
22160: fnd_file.put_line(fnd_file.LOG, ' ');
22161:
22162:
22163: xla_exceptions_pkg.raise_message
22156: END IF;
22157: END LOOP;
22158:
22159: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
22160: fnd_file.put_line(fnd_file.LOG, ' ');
22161:
22162:
22163: xla_exceptions_pkg.raise_message
22164: (p_location => 'XLA_00222_AAD_S_000004_PKG.EventClass_40');
24541:
24542: l_first_event_id := l_array_header_events(l_array_header_events.FIRST);
24543: l_last_event_id := l_array_header_events(l_array_header_events.LAST);
24544:
24545: fnd_file.put_line(fnd_file.LOG, ' ');
24546: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
24547: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );
24548: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');
24549:
24542: l_first_event_id := l_array_header_events(l_array_header_events.FIRST);
24543: l_last_event_id := l_array_header_events(l_array_header_events.LAST);
24544:
24545: fnd_file.put_line(fnd_file.LOG, ' ');
24546: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
24547: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );
24548: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');
24549:
24550: FOR line_record IN line_cur(l_first_event_id, l_last_event_id)
24543: l_last_event_id := l_array_header_events(l_array_header_events.LAST);
24544:
24545: fnd_file.put_line(fnd_file.LOG, ' ');
24546: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
24547: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );
24548: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');
24549:
24550: FOR line_record IN line_cur(l_first_event_id, l_last_event_id)
24551: LOOP
24544:
24545: fnd_file.put_line(fnd_file.LOG, ' ');
24546: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
24547: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );
24548: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');
24549:
24550: FOR line_record IN line_cur(l_first_event_id, l_last_event_id)
24551: LOOP
24552: IF (NOT l_array_header_events.EXISTS(line_record.event_id)) AND (NOT l_array_duplicate_checker.EXISTS(line_record.event_id)) THEN
24549:
24550: FOR line_record IN line_cur(l_first_event_id, l_last_event_id)
24551: LOOP
24552: IF (NOT l_array_header_events.EXISTS(line_record.event_id)) AND (NOT l_array_duplicate_checker.EXISTS(line_record.event_id)) THEN
24553: fnd_file.put_line(fnd_file.log, 'Event_id = ' || line_record.event_id);
24554: l_array_duplicate_checker(line_record.event_id) := line_record.event_id;
24555: END IF;
24556: END LOOP;
24557:
24554: l_array_duplicate_checker(line_record.event_id) := line_record.event_id;
24555: END IF;
24556: END LOOP;
24557:
24558: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
24559: fnd_file.put_line(fnd_file.LOG, ' ');
24560:
24561:
24562: xla_exceptions_pkg.raise_message
24555: END IF;
24556: END LOOP;
24557:
24558: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
24559: fnd_file.put_line(fnd_file.LOG, ' ');
24560:
24561:
24562: xla_exceptions_pkg.raise_message
24563: (p_location => 'XLA_00222_AAD_S_000004_PKG.EventClass_41');