4144:
4145: l_first_event_id := l_array_header_events(l_array_header_events.FIRST);
4146: l_last_event_id := l_array_header_events(l_array_header_events.LAST);
4147:
4148: fnd_file.put_line(fnd_file.LOG, ' ');
4149: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
4150: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );
4151: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');
4152:
4145: l_first_event_id := l_array_header_events(l_array_header_events.FIRST);
4146: l_last_event_id := l_array_header_events(l_array_header_events.LAST);
4147:
4148: fnd_file.put_line(fnd_file.LOG, ' ');
4149: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
4150: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );
4151: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');
4152:
4153: FOR line_record IN line_cur(l_first_event_id, l_last_event_id)
4146: l_last_event_id := l_array_header_events(l_array_header_events.LAST);
4147:
4148: fnd_file.put_line(fnd_file.LOG, ' ');
4149: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
4150: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );
4151: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');
4152:
4153: FOR line_record IN line_cur(l_first_event_id, l_last_event_id)
4154: LOOP
4147:
4148: fnd_file.put_line(fnd_file.LOG, ' ');
4149: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
4150: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );
4151: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');
4152:
4153: FOR line_record IN line_cur(l_first_event_id, l_last_event_id)
4154: LOOP
4155: IF (NOT l_array_header_events.EXISTS(line_record.event_id)) AND (NOT l_array_duplicate_checker.EXISTS(line_record.event_id)) THEN
4152:
4153: FOR line_record IN line_cur(l_first_event_id, l_last_event_id)
4154: LOOP
4155: IF (NOT l_array_header_events.EXISTS(line_record.event_id)) AND (NOT l_array_duplicate_checker.EXISTS(line_record.event_id)) THEN
4156: fnd_file.put_line(fnd_file.log, 'Event_id = ' || line_record.event_id);
4157: l_array_duplicate_checker(line_record.event_id) := line_record.event_id;
4158: END IF;
4159: END LOOP;
4160:
4157: l_array_duplicate_checker(line_record.event_id) := line_record.event_id;
4158: END IF;
4159: END LOOP;
4160:
4161: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
4162: fnd_file.put_line(fnd_file.LOG, ' ');
4163:
4164:
4165: xla_exceptions_pkg.raise_message
4158: END IF;
4159: END LOOP;
4160:
4161: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
4162: fnd_file.put_line(fnd_file.LOG, ' ');
4163:
4164:
4165: xla_exceptions_pkg.raise_message
4166: (p_location => 'XLA_00240_AAD_S_000003_PKG.EventType_8');
5394:
5395: l_first_event_id := l_array_header_events(l_array_header_events.FIRST);
5396: l_last_event_id := l_array_header_events(l_array_header_events.LAST);
5397:
5398: fnd_file.put_line(fnd_file.LOG, ' ');
5399: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
5400: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );
5401: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');
5402:
5395: l_first_event_id := l_array_header_events(l_array_header_events.FIRST);
5396: l_last_event_id := l_array_header_events(l_array_header_events.LAST);
5397:
5398: fnd_file.put_line(fnd_file.LOG, ' ');
5399: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
5400: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );
5401: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');
5402:
5403: FOR line_record IN line_cur(l_first_event_id, l_last_event_id)
5396: l_last_event_id := l_array_header_events(l_array_header_events.LAST);
5397:
5398: fnd_file.put_line(fnd_file.LOG, ' ');
5399: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
5400: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );
5401: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');
5402:
5403: FOR line_record IN line_cur(l_first_event_id, l_last_event_id)
5404: LOOP
5397:
5398: fnd_file.put_line(fnd_file.LOG, ' ');
5399: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
5400: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );
5401: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');
5402:
5403: FOR line_record IN line_cur(l_first_event_id, l_last_event_id)
5404: LOOP
5405: IF (NOT l_array_header_events.EXISTS(line_record.event_id)) AND (NOT l_array_duplicate_checker.EXISTS(line_record.event_id)) THEN
5402:
5403: FOR line_record IN line_cur(l_first_event_id, l_last_event_id)
5404: LOOP
5405: IF (NOT l_array_header_events.EXISTS(line_record.event_id)) AND (NOT l_array_duplicate_checker.EXISTS(line_record.event_id)) THEN
5406: fnd_file.put_line(fnd_file.log, 'Event_id = ' || line_record.event_id);
5407: l_array_duplicate_checker(line_record.event_id) := line_record.event_id;
5408: END IF;
5409: END LOOP;
5410:
5407: l_array_duplicate_checker(line_record.event_id) := line_record.event_id;
5408: END IF;
5409: END LOOP;
5410:
5411: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
5412: fnd_file.put_line(fnd_file.LOG, ' ');
5413:
5414:
5415: xla_exceptions_pkg.raise_message
5408: END IF;
5409: END LOOP;
5410:
5411: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
5412: fnd_file.put_line(fnd_file.LOG, ' ');
5413:
5414:
5415: xla_exceptions_pkg.raise_message
5416: (p_location => 'XLA_00240_AAD_S_000003_PKG.EventType_9');