155703:
155704: l_first_event_id := l_array_header_events(l_array_header_events.FIRST);
155705: l_last_event_id := l_array_header_events(l_array_header_events.LAST);
155706:
155707: fnd_file.put_line(fnd_file.LOG, ' ');
155708: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
155709: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );
155710: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');
155711:
155704: l_first_event_id := l_array_header_events(l_array_header_events.FIRST);
155705: l_last_event_id := l_array_header_events(l_array_header_events.LAST);
155706:
155707: fnd_file.put_line(fnd_file.LOG, ' ');
155708: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
155709: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );
155710: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');
155711:
155712: FOR line_record IN line_cur(l_first_event_id, l_last_event_id)
155705: l_last_event_id := l_array_header_events(l_array_header_events.LAST);
155706:
155707: fnd_file.put_line(fnd_file.LOG, ' ');
155708: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
155709: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );
155710: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');
155711:
155712: FOR line_record IN line_cur(l_first_event_id, l_last_event_id)
155713: LOOP
155706:
155707: fnd_file.put_line(fnd_file.LOG, ' ');
155708: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
155709: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );
155710: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');
155711:
155712: FOR line_record IN line_cur(l_first_event_id, l_last_event_id)
155713: LOOP
155714: IF (NOT l_array_header_events.EXISTS(line_record.event_id)) AND (NOT l_array_duplicate_checker.EXISTS(line_record.event_id)) THEN
155711:
155712: FOR line_record IN line_cur(l_first_event_id, l_last_event_id)
155713: LOOP
155714: IF (NOT l_array_header_events.EXISTS(line_record.event_id)) AND (NOT l_array_duplicate_checker.EXISTS(line_record.event_id)) THEN
155715: fnd_file.put_line(fnd_file.log, 'Event_id = ' || line_record.event_id);
155716: l_array_duplicate_checker(line_record.event_id) := line_record.event_id;
155717: END IF;
155718: END LOOP;
155719:
155716: l_array_duplicate_checker(line_record.event_id) := line_record.event_id;
155717: END IF;
155718: END LOOP;
155719:
155720: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
155721: fnd_file.put_line(fnd_file.LOG, ' ');
155722:
155723:
155724: xla_exceptions_pkg.raise_message
155717: END IF;
155718: END LOOP;
155719:
155720: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
155721: fnd_file.put_line(fnd_file.LOG, ' ');
155722:
155723:
155724: xla_exceptions_pkg.raise_message
155725: (p_location => 'XLA_00200_AAD_S_000012_PKG.EventClass_248');
158898:
158899: l_first_event_id := l_array_header_events(l_array_header_events.FIRST);
158900: l_last_event_id := l_array_header_events(l_array_header_events.LAST);
158901:
158902: fnd_file.put_line(fnd_file.LOG, ' ');
158903: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
158904: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );
158905: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');
158906:
158899: l_first_event_id := l_array_header_events(l_array_header_events.FIRST);
158900: l_last_event_id := l_array_header_events(l_array_header_events.LAST);
158901:
158902: fnd_file.put_line(fnd_file.LOG, ' ');
158903: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
158904: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );
158905: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');
158906:
158907: FOR line_record IN line_cur(l_first_event_id, l_last_event_id)
158900: l_last_event_id := l_array_header_events(l_array_header_events.LAST);
158901:
158902: fnd_file.put_line(fnd_file.LOG, ' ');
158903: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
158904: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );
158905: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');
158906:
158907: FOR line_record IN line_cur(l_first_event_id, l_last_event_id)
158908: LOOP
158901:
158902: fnd_file.put_line(fnd_file.LOG, ' ');
158903: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
158904: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );
158905: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');
158906:
158907: FOR line_record IN line_cur(l_first_event_id, l_last_event_id)
158908: LOOP
158909: IF (NOT l_array_header_events.EXISTS(line_record.event_id)) AND (NOT l_array_duplicate_checker.EXISTS(line_record.event_id)) THEN
158906:
158907: FOR line_record IN line_cur(l_first_event_id, l_last_event_id)
158908: LOOP
158909: IF (NOT l_array_header_events.EXISTS(line_record.event_id)) AND (NOT l_array_duplicate_checker.EXISTS(line_record.event_id)) THEN
158910: fnd_file.put_line(fnd_file.log, 'Event_id = ' || line_record.event_id);
158911: l_array_duplicate_checker(line_record.event_id) := line_record.event_id;
158912: END IF;
158913: END LOOP;
158914:
158911: l_array_duplicate_checker(line_record.event_id) := line_record.event_id;
158912: END IF;
158913: END LOOP;
158914:
158915: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
158916: fnd_file.put_line(fnd_file.LOG, ' ');
158917:
158918:
158919: xla_exceptions_pkg.raise_message
158912: END IF;
158913: END LOOP;
158914:
158915: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
158916: fnd_file.put_line(fnd_file.LOG, ' ');
158917:
158918:
158919: xla_exceptions_pkg.raise_message
158920: (p_location => 'XLA_00200_AAD_S_000012_PKG.EventClass_249');
161218:
161219: l_first_event_id := l_array_header_events(l_array_header_events.FIRST);
161220: l_last_event_id := l_array_header_events(l_array_header_events.LAST);
161221:
161222: fnd_file.put_line(fnd_file.LOG, ' ');
161223: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
161224: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );
161225: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');
161226:
161219: l_first_event_id := l_array_header_events(l_array_header_events.FIRST);
161220: l_last_event_id := l_array_header_events(l_array_header_events.LAST);
161221:
161222: fnd_file.put_line(fnd_file.LOG, ' ');
161223: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
161224: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );
161225: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');
161226:
161227: FOR line_record IN line_cur(l_first_event_id, l_last_event_id)
161220: l_last_event_id := l_array_header_events(l_array_header_events.LAST);
161221:
161222: fnd_file.put_line(fnd_file.LOG, ' ');
161223: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
161224: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );
161225: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');
161226:
161227: FOR line_record IN line_cur(l_first_event_id, l_last_event_id)
161228: LOOP
161221:
161222: fnd_file.put_line(fnd_file.LOG, ' ');
161223: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
161224: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );
161225: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');
161226:
161227: FOR line_record IN line_cur(l_first_event_id, l_last_event_id)
161228: LOOP
161229: IF (NOT l_array_header_events.EXISTS(line_record.event_id)) AND (NOT l_array_duplicate_checker.EXISTS(line_record.event_id)) THEN
161226:
161227: FOR line_record IN line_cur(l_first_event_id, l_last_event_id)
161228: LOOP
161229: IF (NOT l_array_header_events.EXISTS(line_record.event_id)) AND (NOT l_array_duplicate_checker.EXISTS(line_record.event_id)) THEN
161230: fnd_file.put_line(fnd_file.log, 'Event_id = ' || line_record.event_id);
161231: l_array_duplicate_checker(line_record.event_id) := line_record.event_id;
161232: END IF;
161233: END LOOP;
161234:
161231: l_array_duplicate_checker(line_record.event_id) := line_record.event_id;
161232: END IF;
161233: END LOOP;
161234:
161235: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
161236: fnd_file.put_line(fnd_file.LOG, ' ');
161237:
161238:
161239: xla_exceptions_pkg.raise_message
161232: END IF;
161233: END LOOP;
161234:
161235: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
161236: fnd_file.put_line(fnd_file.LOG, ' ');
161237:
161238:
161239: xla_exceptions_pkg.raise_message
161240: (p_location => 'XLA_00200_AAD_S_000012_PKG.EventClass_250');
164554:
164555: l_first_event_id := l_array_header_events(l_array_header_events.FIRST);
164556: l_last_event_id := l_array_header_events(l_array_header_events.LAST);
164557:
164558: fnd_file.put_line(fnd_file.LOG, ' ');
164559: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
164560: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );
164561: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');
164562:
164555: l_first_event_id := l_array_header_events(l_array_header_events.FIRST);
164556: l_last_event_id := l_array_header_events(l_array_header_events.LAST);
164557:
164558: fnd_file.put_line(fnd_file.LOG, ' ');
164559: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
164560: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );
164561: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');
164562:
164563: FOR line_record IN line_cur(l_first_event_id, l_last_event_id)
164556: l_last_event_id := l_array_header_events(l_array_header_events.LAST);
164557:
164558: fnd_file.put_line(fnd_file.LOG, ' ');
164559: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
164560: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );
164561: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');
164562:
164563: FOR line_record IN line_cur(l_first_event_id, l_last_event_id)
164564: LOOP
164557:
164558: fnd_file.put_line(fnd_file.LOG, ' ');
164559: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
164560: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );
164561: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');
164562:
164563: FOR line_record IN line_cur(l_first_event_id, l_last_event_id)
164564: LOOP
164565: IF (NOT l_array_header_events.EXISTS(line_record.event_id)) AND (NOT l_array_duplicate_checker.EXISTS(line_record.event_id)) THEN
164562:
164563: FOR line_record IN line_cur(l_first_event_id, l_last_event_id)
164564: LOOP
164565: IF (NOT l_array_header_events.EXISTS(line_record.event_id)) AND (NOT l_array_duplicate_checker.EXISTS(line_record.event_id)) THEN
164566: fnd_file.put_line(fnd_file.log, 'Event_id = ' || line_record.event_id);
164567: l_array_duplicate_checker(line_record.event_id) := line_record.event_id;
164568: END IF;
164569: END LOOP;
164570:
164567: l_array_duplicate_checker(line_record.event_id) := line_record.event_id;
164568: END IF;
164569: END LOOP;
164570:
164571: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
164572: fnd_file.put_line(fnd_file.LOG, ' ');
164573:
164574:
164575: xla_exceptions_pkg.raise_message
164568: END IF;
164569: END LOOP;
164570:
164571: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
164572: fnd_file.put_line(fnd_file.LOG, ' ');
164573:
164574:
164575: xla_exceptions_pkg.raise_message
164576: (p_location => 'XLA_00200_AAD_S_000012_PKG.EventClass_251');
168348:
168349: l_first_event_id := l_array_header_events(l_array_header_events.FIRST);
168350: l_last_event_id := l_array_header_events(l_array_header_events.LAST);
168351:
168352: fnd_file.put_line(fnd_file.LOG, ' ');
168353: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
168354: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );
168355: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');
168356:
168349: l_first_event_id := l_array_header_events(l_array_header_events.FIRST);
168350: l_last_event_id := l_array_header_events(l_array_header_events.LAST);
168351:
168352: fnd_file.put_line(fnd_file.LOG, ' ');
168353: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
168354: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );
168355: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');
168356:
168357: FOR line_record IN line_cur(l_first_event_id, l_last_event_id)
168350: l_last_event_id := l_array_header_events(l_array_header_events.LAST);
168351:
168352: fnd_file.put_line(fnd_file.LOG, ' ');
168353: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
168354: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );
168355: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');
168356:
168357: FOR line_record IN line_cur(l_first_event_id, l_last_event_id)
168358: LOOP
168351:
168352: fnd_file.put_line(fnd_file.LOG, ' ');
168353: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
168354: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );
168355: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');
168356:
168357: FOR line_record IN line_cur(l_first_event_id, l_last_event_id)
168358: LOOP
168359: IF (NOT l_array_header_events.EXISTS(line_record.event_id)) AND (NOT l_array_duplicate_checker.EXISTS(line_record.event_id)) THEN
168356:
168357: FOR line_record IN line_cur(l_first_event_id, l_last_event_id)
168358: LOOP
168359: IF (NOT l_array_header_events.EXISTS(line_record.event_id)) AND (NOT l_array_duplicate_checker.EXISTS(line_record.event_id)) THEN
168360: fnd_file.put_line(fnd_file.log, 'Event_id = ' || line_record.event_id);
168361: l_array_duplicate_checker(line_record.event_id) := line_record.event_id;
168362: END IF;
168363: END LOOP;
168364:
168361: l_array_duplicate_checker(line_record.event_id) := line_record.event_id;
168362: END IF;
168363: END LOOP;
168364:
168365: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
168366: fnd_file.put_line(fnd_file.LOG, ' ');
168367:
168368:
168369: xla_exceptions_pkg.raise_message
168362: END IF;
168363: END LOOP;
168364:
168365: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
168366: fnd_file.put_line(fnd_file.LOG, ' ');
168367:
168368:
168369: xla_exceptions_pkg.raise_message
168370: (p_location => 'XLA_00200_AAD_S_000012_PKG.EventClass_252');
170715:
170716: l_first_event_id := l_array_header_events(l_array_header_events.FIRST);
170717: l_last_event_id := l_array_header_events(l_array_header_events.LAST);
170718:
170719: fnd_file.put_line(fnd_file.LOG, ' ');
170720: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
170721: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );
170722: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');
170723:
170716: l_first_event_id := l_array_header_events(l_array_header_events.FIRST);
170717: l_last_event_id := l_array_header_events(l_array_header_events.LAST);
170718:
170719: fnd_file.put_line(fnd_file.LOG, ' ');
170720: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
170721: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );
170722: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');
170723:
170724: FOR line_record IN line_cur(l_first_event_id, l_last_event_id)
170717: l_last_event_id := l_array_header_events(l_array_header_events.LAST);
170718:
170719: fnd_file.put_line(fnd_file.LOG, ' ');
170720: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
170721: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );
170722: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');
170723:
170724: FOR line_record IN line_cur(l_first_event_id, l_last_event_id)
170725: LOOP
170718:
170719: fnd_file.put_line(fnd_file.LOG, ' ');
170720: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
170721: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );
170722: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');
170723:
170724: FOR line_record IN line_cur(l_first_event_id, l_last_event_id)
170725: LOOP
170726: IF (NOT l_array_header_events.EXISTS(line_record.event_id)) AND (NOT l_array_duplicate_checker.EXISTS(line_record.event_id)) THEN
170723:
170724: FOR line_record IN line_cur(l_first_event_id, l_last_event_id)
170725: LOOP
170726: IF (NOT l_array_header_events.EXISTS(line_record.event_id)) AND (NOT l_array_duplicate_checker.EXISTS(line_record.event_id)) THEN
170727: fnd_file.put_line(fnd_file.log, 'Event_id = ' || line_record.event_id);
170728: l_array_duplicate_checker(line_record.event_id) := line_record.event_id;
170729: END IF;
170730: END LOOP;
170731:
170728: l_array_duplicate_checker(line_record.event_id) := line_record.event_id;
170729: END IF;
170730: END LOOP;
170731:
170732: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
170733: fnd_file.put_line(fnd_file.LOG, ' ');
170734:
170735:
170736: xla_exceptions_pkg.raise_message
170729: END IF;
170730: END LOOP;
170731:
170732: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
170733: fnd_file.put_line(fnd_file.LOG, ' ');
170734:
170735:
170736: xla_exceptions_pkg.raise_message
170737: (p_location => 'XLA_00200_AAD_S_000012_PKG.EventClass_253');
173942:
173943: l_first_event_id := l_array_header_events(l_array_header_events.FIRST);
173944: l_last_event_id := l_array_header_events(l_array_header_events.LAST);
173945:
173946: fnd_file.put_line(fnd_file.LOG, ' ');
173947: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
173948: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );
173949: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');
173950:
173943: l_first_event_id := l_array_header_events(l_array_header_events.FIRST);
173944: l_last_event_id := l_array_header_events(l_array_header_events.LAST);
173945:
173946: fnd_file.put_line(fnd_file.LOG, ' ');
173947: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
173948: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );
173949: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');
173950:
173951: FOR line_record IN line_cur(l_first_event_id, l_last_event_id)
173944: l_last_event_id := l_array_header_events(l_array_header_events.LAST);
173945:
173946: fnd_file.put_line(fnd_file.LOG, ' ');
173947: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
173948: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );
173949: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');
173950:
173951: FOR line_record IN line_cur(l_first_event_id, l_last_event_id)
173952: LOOP
173945:
173946: fnd_file.put_line(fnd_file.LOG, ' ');
173947: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
173948: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );
173949: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');
173950:
173951: FOR line_record IN line_cur(l_first_event_id, l_last_event_id)
173952: LOOP
173953: IF (NOT l_array_header_events.EXISTS(line_record.event_id)) AND (NOT l_array_duplicate_checker.EXISTS(line_record.event_id)) THEN
173950:
173951: FOR line_record IN line_cur(l_first_event_id, l_last_event_id)
173952: LOOP
173953: IF (NOT l_array_header_events.EXISTS(line_record.event_id)) AND (NOT l_array_duplicate_checker.EXISTS(line_record.event_id)) THEN
173954: fnd_file.put_line(fnd_file.log, 'Event_id = ' || line_record.event_id);
173955: l_array_duplicate_checker(line_record.event_id) := line_record.event_id;
173956: END IF;
173957: END LOOP;
173958:
173955: l_array_duplicate_checker(line_record.event_id) := line_record.event_id;
173956: END IF;
173957: END LOOP;
173958:
173959: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
173960: fnd_file.put_line(fnd_file.LOG, ' ');
173961:
173962:
173963: xla_exceptions_pkg.raise_message
173956: END IF;
173957: END LOOP;
173958:
173959: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
173960: fnd_file.put_line(fnd_file.LOG, ' ');
173961:
173962:
173963: xla_exceptions_pkg.raise_message
173964: (p_location => 'XLA_00200_AAD_S_000012_PKG.EventClass_254');
177032:
177033: l_first_event_id := l_array_header_events(l_array_header_events.FIRST);
177034: l_last_event_id := l_array_header_events(l_array_header_events.LAST);
177035:
177036: fnd_file.put_line(fnd_file.LOG, ' ');
177037: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
177038: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );
177039: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');
177040:
177033: l_first_event_id := l_array_header_events(l_array_header_events.FIRST);
177034: l_last_event_id := l_array_header_events(l_array_header_events.LAST);
177035:
177036: fnd_file.put_line(fnd_file.LOG, ' ');
177037: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
177038: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );
177039: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');
177040:
177041: FOR line_record IN line_cur(l_first_event_id, l_last_event_id)
177034: l_last_event_id := l_array_header_events(l_array_header_events.LAST);
177035:
177036: fnd_file.put_line(fnd_file.LOG, ' ');
177037: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
177038: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );
177039: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');
177040:
177041: FOR line_record IN line_cur(l_first_event_id, l_last_event_id)
177042: LOOP
177035:
177036: fnd_file.put_line(fnd_file.LOG, ' ');
177037: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
177038: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );
177039: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');
177040:
177041: FOR line_record IN line_cur(l_first_event_id, l_last_event_id)
177042: LOOP
177043: IF (NOT l_array_header_events.EXISTS(line_record.event_id)) AND (NOT l_array_duplicate_checker.EXISTS(line_record.event_id)) THEN
177040:
177041: FOR line_record IN line_cur(l_first_event_id, l_last_event_id)
177042: LOOP
177043: IF (NOT l_array_header_events.EXISTS(line_record.event_id)) AND (NOT l_array_duplicate_checker.EXISTS(line_record.event_id)) THEN
177044: fnd_file.put_line(fnd_file.log, 'Event_id = ' || line_record.event_id);
177045: l_array_duplicate_checker(line_record.event_id) := line_record.event_id;
177046: END IF;
177047: END LOOP;
177048:
177045: l_array_duplicate_checker(line_record.event_id) := line_record.event_id;
177046: END IF;
177047: END LOOP;
177048:
177049: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
177050: fnd_file.put_line(fnd_file.LOG, ' ');
177051:
177052:
177053: xla_exceptions_pkg.raise_message
177046: END IF;
177047: END LOOP;
177048:
177049: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
177050: fnd_file.put_line(fnd_file.LOG, ' ');
177051:
177052:
177053: xla_exceptions_pkg.raise_message
177054: (p_location => 'XLA_00200_AAD_S_000012_PKG.EventClass_255');
179496:
179497: l_first_event_id := l_array_header_events(l_array_header_events.FIRST);
179498: l_last_event_id := l_array_header_events(l_array_header_events.LAST);
179499:
179500: fnd_file.put_line(fnd_file.LOG, ' ');
179501: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
179502: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );
179503: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');
179504:
179497: l_first_event_id := l_array_header_events(l_array_header_events.FIRST);
179498: l_last_event_id := l_array_header_events(l_array_header_events.LAST);
179499:
179500: fnd_file.put_line(fnd_file.LOG, ' ');
179501: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
179502: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );
179503: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');
179504:
179505: FOR line_record IN line_cur(l_first_event_id, l_last_event_id)
179498: l_last_event_id := l_array_header_events(l_array_header_events.LAST);
179499:
179500: fnd_file.put_line(fnd_file.LOG, ' ');
179501: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
179502: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );
179503: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');
179504:
179505: FOR line_record IN line_cur(l_first_event_id, l_last_event_id)
179506: LOOP
179499:
179500: fnd_file.put_line(fnd_file.LOG, ' ');
179501: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
179502: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );
179503: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');
179504:
179505: FOR line_record IN line_cur(l_first_event_id, l_last_event_id)
179506: LOOP
179507: IF (NOT l_array_header_events.EXISTS(line_record.event_id)) AND (NOT l_array_duplicate_checker.EXISTS(line_record.event_id)) THEN
179504:
179505: FOR line_record IN line_cur(l_first_event_id, l_last_event_id)
179506: LOOP
179507: IF (NOT l_array_header_events.EXISTS(line_record.event_id)) AND (NOT l_array_duplicate_checker.EXISTS(line_record.event_id)) THEN
179508: fnd_file.put_line(fnd_file.log, 'Event_id = ' || line_record.event_id);
179509: l_array_duplicate_checker(line_record.event_id) := line_record.event_id;
179510: END IF;
179511: END LOOP;
179512:
179509: l_array_duplicate_checker(line_record.event_id) := line_record.event_id;
179510: END IF;
179511: END LOOP;
179512:
179513: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
179514: fnd_file.put_line(fnd_file.LOG, ' ');
179515:
179516:
179517: xla_exceptions_pkg.raise_message
179510: END IF;
179511: END LOOP;
179512:
179513: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
179514: fnd_file.put_line(fnd_file.LOG, ' ');
179515:
179516:
179517: xla_exceptions_pkg.raise_message
179518: (p_location => 'XLA_00200_AAD_S_000012_PKG.EventClass_256');