144325:
144326: l_first_event_id := l_array_header_events(l_array_header_events.FIRST);
144327: l_last_event_id := l_array_header_events(l_array_header_events.LAST);
144328:
144329: fnd_file.put_line(fnd_file.LOG, ' ');
144330: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
144331: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );
144332: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');
144333:
144326: l_first_event_id := l_array_header_events(l_array_header_events.FIRST);
144327: l_last_event_id := l_array_header_events(l_array_header_events.LAST);
144328:
144329: fnd_file.put_line(fnd_file.LOG, ' ');
144330: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
144331: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );
144332: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');
144333:
144334: FOR line_record IN line_cur(l_first_event_id, l_last_event_id)
144327: l_last_event_id := l_array_header_events(l_array_header_events.LAST);
144328:
144329: fnd_file.put_line(fnd_file.LOG, ' ');
144330: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
144331: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );
144332: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');
144333:
144334: FOR line_record IN line_cur(l_first_event_id, l_last_event_id)
144335: LOOP
144328:
144329: fnd_file.put_line(fnd_file.LOG, ' ');
144330: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
144331: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );
144332: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');
144333:
144334: FOR line_record IN line_cur(l_first_event_id, l_last_event_id)
144335: LOOP
144336: IF (NOT l_array_header_events.EXISTS(line_record.event_id)) AND (NOT l_array_duplicate_checker.EXISTS(line_record.event_id)) THEN
144333:
144334: FOR line_record IN line_cur(l_first_event_id, l_last_event_id)
144335: LOOP
144336: IF (NOT l_array_header_events.EXISTS(line_record.event_id)) AND (NOT l_array_duplicate_checker.EXISTS(line_record.event_id)) THEN
144337: fnd_file.put_line(fnd_file.log, 'Event_id = ' || line_record.event_id);
144338: l_array_duplicate_checker(line_record.event_id) := line_record.event_id;
144339: END IF;
144340: END LOOP;
144341:
144338: l_array_duplicate_checker(line_record.event_id) := line_record.event_id;
144339: END IF;
144340: END LOOP;
144341:
144342: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
144343: fnd_file.put_line(fnd_file.LOG, ' ');
144344:
144345:
144346: xla_exceptions_pkg.raise_message
144339: END IF;
144340: END LOOP;
144341:
144342: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
144343: fnd_file.put_line(fnd_file.LOG, ' ');
144344:
144345:
144346: xla_exceptions_pkg.raise_message
144347: (p_location => 'XLA_00707_AAD_S_000005_PKG.EventClass_259');
145612:
145613: l_first_event_id := l_array_header_events(l_array_header_events.FIRST);
145614: l_last_event_id := l_array_header_events(l_array_header_events.LAST);
145615:
145616: fnd_file.put_line(fnd_file.LOG, ' ');
145617: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
145618: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );
145619: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');
145620:
145613: l_first_event_id := l_array_header_events(l_array_header_events.FIRST);
145614: l_last_event_id := l_array_header_events(l_array_header_events.LAST);
145615:
145616: fnd_file.put_line(fnd_file.LOG, ' ');
145617: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
145618: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );
145619: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');
145620:
145621: FOR line_record IN line_cur(l_first_event_id, l_last_event_id)
145614: l_last_event_id := l_array_header_events(l_array_header_events.LAST);
145615:
145616: fnd_file.put_line(fnd_file.LOG, ' ');
145617: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
145618: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );
145619: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');
145620:
145621: FOR line_record IN line_cur(l_first_event_id, l_last_event_id)
145622: LOOP
145615:
145616: fnd_file.put_line(fnd_file.LOG, ' ');
145617: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
145618: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );
145619: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');
145620:
145621: FOR line_record IN line_cur(l_first_event_id, l_last_event_id)
145622: LOOP
145623: IF (NOT l_array_header_events.EXISTS(line_record.event_id)) AND (NOT l_array_duplicate_checker.EXISTS(line_record.event_id)) THEN
145620:
145621: FOR line_record IN line_cur(l_first_event_id, l_last_event_id)
145622: LOOP
145623: IF (NOT l_array_header_events.EXISTS(line_record.event_id)) AND (NOT l_array_duplicate_checker.EXISTS(line_record.event_id)) THEN
145624: fnd_file.put_line(fnd_file.log, 'Event_id = ' || line_record.event_id);
145625: l_array_duplicate_checker(line_record.event_id) := line_record.event_id;
145626: END IF;
145627: END LOOP;
145628:
145625: l_array_duplicate_checker(line_record.event_id) := line_record.event_id;
145626: END IF;
145627: END LOOP;
145628:
145629: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
145630: fnd_file.put_line(fnd_file.LOG, ' ');
145631:
145632:
145633: xla_exceptions_pkg.raise_message
145626: END IF;
145627: END LOOP;
145628:
145629: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
145630: fnd_file.put_line(fnd_file.LOG, ' ');
145631:
145632:
145633: xla_exceptions_pkg.raise_message
145634: (p_location => 'XLA_00707_AAD_S_000005_PKG.EventClass_260');
146906:
146907: l_first_event_id := l_array_header_events(l_array_header_events.FIRST);
146908: l_last_event_id := l_array_header_events(l_array_header_events.LAST);
146909:
146910: fnd_file.put_line(fnd_file.LOG, ' ');
146911: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
146912: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );
146913: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');
146914:
146907: l_first_event_id := l_array_header_events(l_array_header_events.FIRST);
146908: l_last_event_id := l_array_header_events(l_array_header_events.LAST);
146909:
146910: fnd_file.put_line(fnd_file.LOG, ' ');
146911: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
146912: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );
146913: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');
146914:
146915: FOR line_record IN line_cur(l_first_event_id, l_last_event_id)
146908: l_last_event_id := l_array_header_events(l_array_header_events.LAST);
146909:
146910: fnd_file.put_line(fnd_file.LOG, ' ');
146911: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
146912: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );
146913: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');
146914:
146915: FOR line_record IN line_cur(l_first_event_id, l_last_event_id)
146916: LOOP
146909:
146910: fnd_file.put_line(fnd_file.LOG, ' ');
146911: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
146912: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );
146913: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');
146914:
146915: FOR line_record IN line_cur(l_first_event_id, l_last_event_id)
146916: LOOP
146917: IF (NOT l_array_header_events.EXISTS(line_record.event_id)) AND (NOT l_array_duplicate_checker.EXISTS(line_record.event_id)) THEN
146914:
146915: FOR line_record IN line_cur(l_first_event_id, l_last_event_id)
146916: LOOP
146917: IF (NOT l_array_header_events.EXISTS(line_record.event_id)) AND (NOT l_array_duplicate_checker.EXISTS(line_record.event_id)) THEN
146918: fnd_file.put_line(fnd_file.log, 'Event_id = ' || line_record.event_id);
146919: l_array_duplicate_checker(line_record.event_id) := line_record.event_id;
146920: END IF;
146921: END LOOP;
146922:
146919: l_array_duplicate_checker(line_record.event_id) := line_record.event_id;
146920: END IF;
146921: END LOOP;
146922:
146923: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
146924: fnd_file.put_line(fnd_file.LOG, ' ');
146925:
146926:
146927: xla_exceptions_pkg.raise_message
146920: END IF;
146921: END LOOP;
146922:
146923: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
146924: fnd_file.put_line(fnd_file.LOG, ' ');
146925:
146926:
146927: xla_exceptions_pkg.raise_message
146928: (p_location => 'XLA_00707_AAD_S_000005_PKG.EventClass_261');
148247:
148248: l_first_event_id := l_array_header_events(l_array_header_events.FIRST);
148249: l_last_event_id := l_array_header_events(l_array_header_events.LAST);
148250:
148251: fnd_file.put_line(fnd_file.LOG, ' ');
148252: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
148253: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );
148254: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');
148255:
148248: l_first_event_id := l_array_header_events(l_array_header_events.FIRST);
148249: l_last_event_id := l_array_header_events(l_array_header_events.LAST);
148250:
148251: fnd_file.put_line(fnd_file.LOG, ' ');
148252: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
148253: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );
148254: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');
148255:
148256: FOR line_record IN line_cur(l_first_event_id, l_last_event_id)
148249: l_last_event_id := l_array_header_events(l_array_header_events.LAST);
148250:
148251: fnd_file.put_line(fnd_file.LOG, ' ');
148252: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
148253: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );
148254: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');
148255:
148256: FOR line_record IN line_cur(l_first_event_id, l_last_event_id)
148257: LOOP
148250:
148251: fnd_file.put_line(fnd_file.LOG, ' ');
148252: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
148253: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );
148254: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');
148255:
148256: FOR line_record IN line_cur(l_first_event_id, l_last_event_id)
148257: LOOP
148258: IF (NOT l_array_header_events.EXISTS(line_record.event_id)) AND (NOT l_array_duplicate_checker.EXISTS(line_record.event_id)) THEN
148255:
148256: FOR line_record IN line_cur(l_first_event_id, l_last_event_id)
148257: LOOP
148258: IF (NOT l_array_header_events.EXISTS(line_record.event_id)) AND (NOT l_array_duplicate_checker.EXISTS(line_record.event_id)) THEN
148259: fnd_file.put_line(fnd_file.log, 'Event_id = ' || line_record.event_id);
148260: l_array_duplicate_checker(line_record.event_id) := line_record.event_id;
148261: END IF;
148262: END LOOP;
148263:
148260: l_array_duplicate_checker(line_record.event_id) := line_record.event_id;
148261: END IF;
148262: END LOOP;
148263:
148264: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
148265: fnd_file.put_line(fnd_file.LOG, ' ');
148266:
148267:
148268: xla_exceptions_pkg.raise_message
148261: END IF;
148262: END LOOP;
148263:
148264: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
148265: fnd_file.put_line(fnd_file.LOG, ' ');
148266:
148267:
148268: xla_exceptions_pkg.raise_message
148269: (p_location => 'XLA_00707_AAD_S_000005_PKG.EventClass_262');
149857:
149858: l_first_event_id := l_array_header_events(l_array_header_events.FIRST);
149859: l_last_event_id := l_array_header_events(l_array_header_events.LAST);
149860:
149861: fnd_file.put_line(fnd_file.LOG, ' ');
149862: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
149863: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );
149864: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');
149865:
149858: l_first_event_id := l_array_header_events(l_array_header_events.FIRST);
149859: l_last_event_id := l_array_header_events(l_array_header_events.LAST);
149860:
149861: fnd_file.put_line(fnd_file.LOG, ' ');
149862: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
149863: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );
149864: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');
149865:
149866: FOR line_record IN line_cur(l_first_event_id, l_last_event_id)
149859: l_last_event_id := l_array_header_events(l_array_header_events.LAST);
149860:
149861: fnd_file.put_line(fnd_file.LOG, ' ');
149862: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
149863: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );
149864: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');
149865:
149866: FOR line_record IN line_cur(l_first_event_id, l_last_event_id)
149867: LOOP
149860:
149861: fnd_file.put_line(fnd_file.LOG, ' ');
149862: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
149863: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );
149864: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');
149865:
149866: FOR line_record IN line_cur(l_first_event_id, l_last_event_id)
149867: LOOP
149868: IF (NOT l_array_header_events.EXISTS(line_record.event_id)) AND (NOT l_array_duplicate_checker.EXISTS(line_record.event_id)) THEN
149865:
149866: FOR line_record IN line_cur(l_first_event_id, l_last_event_id)
149867: LOOP
149868: IF (NOT l_array_header_events.EXISTS(line_record.event_id)) AND (NOT l_array_duplicate_checker.EXISTS(line_record.event_id)) THEN
149869: fnd_file.put_line(fnd_file.log, 'Event_id = ' || line_record.event_id);
149870: l_array_duplicate_checker(line_record.event_id) := line_record.event_id;
149871: END IF;
149872: END LOOP;
149873:
149870: l_array_duplicate_checker(line_record.event_id) := line_record.event_id;
149871: END IF;
149872: END LOOP;
149873:
149874: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
149875: fnd_file.put_line(fnd_file.LOG, ' ');
149876:
149877:
149878: xla_exceptions_pkg.raise_message
149871: END IF;
149872: END LOOP;
149873:
149874: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
149875: fnd_file.put_line(fnd_file.LOG, ' ');
149876:
149877:
149878: xla_exceptions_pkg.raise_message
149879: (p_location => 'XLA_00707_AAD_S_000005_PKG.EventClass_263');
151267:
151268: l_first_event_id := l_array_header_events(l_array_header_events.FIRST);
151269: l_last_event_id := l_array_header_events(l_array_header_events.LAST);
151270:
151271: fnd_file.put_line(fnd_file.LOG, ' ');
151272: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
151273: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );
151274: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');
151275:
151268: l_first_event_id := l_array_header_events(l_array_header_events.FIRST);
151269: l_last_event_id := l_array_header_events(l_array_header_events.LAST);
151270:
151271: fnd_file.put_line(fnd_file.LOG, ' ');
151272: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
151273: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );
151274: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');
151275:
151276: FOR line_record IN line_cur(l_first_event_id, l_last_event_id)
151269: l_last_event_id := l_array_header_events(l_array_header_events.LAST);
151270:
151271: fnd_file.put_line(fnd_file.LOG, ' ');
151272: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
151273: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );
151274: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');
151275:
151276: FOR line_record IN line_cur(l_first_event_id, l_last_event_id)
151277: LOOP
151270:
151271: fnd_file.put_line(fnd_file.LOG, ' ');
151272: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
151273: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );
151274: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');
151275:
151276: FOR line_record IN line_cur(l_first_event_id, l_last_event_id)
151277: LOOP
151278: IF (NOT l_array_header_events.EXISTS(line_record.event_id)) AND (NOT l_array_duplicate_checker.EXISTS(line_record.event_id)) THEN
151275:
151276: FOR line_record IN line_cur(l_first_event_id, l_last_event_id)
151277: LOOP
151278: IF (NOT l_array_header_events.EXISTS(line_record.event_id)) AND (NOT l_array_duplicate_checker.EXISTS(line_record.event_id)) THEN
151279: fnd_file.put_line(fnd_file.log, 'Event_id = ' || line_record.event_id);
151280: l_array_duplicate_checker(line_record.event_id) := line_record.event_id;
151281: END IF;
151282: END LOOP;
151283:
151280: l_array_duplicate_checker(line_record.event_id) := line_record.event_id;
151281: END IF;
151282: END LOOP;
151283:
151284: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
151285: fnd_file.put_line(fnd_file.LOG, ' ');
151286:
151287:
151288: xla_exceptions_pkg.raise_message
151281: END IF;
151282: END LOOP;
151283:
151284: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
151285: fnd_file.put_line(fnd_file.LOG, ' ');
151286:
151287:
151288: xla_exceptions_pkg.raise_message
151289: (p_location => 'XLA_00707_AAD_S_000005_PKG.EventClass_264');
152838:
152839: l_first_event_id := l_array_header_events(l_array_header_events.FIRST);
152840: l_last_event_id := l_array_header_events(l_array_header_events.LAST);
152841:
152842: fnd_file.put_line(fnd_file.LOG, ' ');
152843: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
152844: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );
152845: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');
152846:
152839: l_first_event_id := l_array_header_events(l_array_header_events.FIRST);
152840: l_last_event_id := l_array_header_events(l_array_header_events.LAST);
152841:
152842: fnd_file.put_line(fnd_file.LOG, ' ');
152843: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
152844: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );
152845: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');
152846:
152847: FOR line_record IN line_cur(l_first_event_id, l_last_event_id)
152840: l_last_event_id := l_array_header_events(l_array_header_events.LAST);
152841:
152842: fnd_file.put_line(fnd_file.LOG, ' ');
152843: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
152844: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );
152845: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');
152846:
152847: FOR line_record IN line_cur(l_first_event_id, l_last_event_id)
152848: LOOP
152841:
152842: fnd_file.put_line(fnd_file.LOG, ' ');
152843: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
152844: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );
152845: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');
152846:
152847: FOR line_record IN line_cur(l_first_event_id, l_last_event_id)
152848: LOOP
152849: IF (NOT l_array_header_events.EXISTS(line_record.event_id)) AND (NOT l_array_duplicate_checker.EXISTS(line_record.event_id)) THEN
152846:
152847: FOR line_record IN line_cur(l_first_event_id, l_last_event_id)
152848: LOOP
152849: IF (NOT l_array_header_events.EXISTS(line_record.event_id)) AND (NOT l_array_duplicate_checker.EXISTS(line_record.event_id)) THEN
152850: fnd_file.put_line(fnd_file.log, 'Event_id = ' || line_record.event_id);
152851: l_array_duplicate_checker(line_record.event_id) := line_record.event_id;
152852: END IF;
152853: END LOOP;
152854:
152851: l_array_duplicate_checker(line_record.event_id) := line_record.event_id;
152852: END IF;
152853: END LOOP;
152854:
152855: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
152856: fnd_file.put_line(fnd_file.LOG, ' ');
152857:
152858:
152859: xla_exceptions_pkg.raise_message
152852: END IF;
152853: END LOOP;
152854:
152855: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
152856: fnd_file.put_line(fnd_file.LOG, ' ');
152857:
152858:
152859: xla_exceptions_pkg.raise_message
152860: (p_location => 'XLA_00707_AAD_S_000005_PKG.EventClass_265');
154190:
154191: l_first_event_id := l_array_header_events(l_array_header_events.FIRST);
154192: l_last_event_id := l_array_header_events(l_array_header_events.LAST);
154193:
154194: fnd_file.put_line(fnd_file.LOG, ' ');
154195: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
154196: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );
154197: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');
154198:
154191: l_first_event_id := l_array_header_events(l_array_header_events.FIRST);
154192: l_last_event_id := l_array_header_events(l_array_header_events.LAST);
154193:
154194: fnd_file.put_line(fnd_file.LOG, ' ');
154195: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
154196: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );
154197: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');
154198:
154199: FOR line_record IN line_cur(l_first_event_id, l_last_event_id)
154192: l_last_event_id := l_array_header_events(l_array_header_events.LAST);
154193:
154194: fnd_file.put_line(fnd_file.LOG, ' ');
154195: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
154196: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );
154197: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');
154198:
154199: FOR line_record IN line_cur(l_first_event_id, l_last_event_id)
154200: LOOP
154193:
154194: fnd_file.put_line(fnd_file.LOG, ' ');
154195: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
154196: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );
154197: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');
154198:
154199: FOR line_record IN line_cur(l_first_event_id, l_last_event_id)
154200: LOOP
154201: IF (NOT l_array_header_events.EXISTS(line_record.event_id)) AND (NOT l_array_duplicate_checker.EXISTS(line_record.event_id)) THEN
154198:
154199: FOR line_record IN line_cur(l_first_event_id, l_last_event_id)
154200: LOOP
154201: IF (NOT l_array_header_events.EXISTS(line_record.event_id)) AND (NOT l_array_duplicate_checker.EXISTS(line_record.event_id)) THEN
154202: fnd_file.put_line(fnd_file.log, 'Event_id = ' || line_record.event_id);
154203: l_array_duplicate_checker(line_record.event_id) := line_record.event_id;
154204: END IF;
154205: END LOOP;
154206:
154203: l_array_duplicate_checker(line_record.event_id) := line_record.event_id;
154204: END IF;
154205: END LOOP;
154206:
154207: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
154208: fnd_file.put_line(fnd_file.LOG, ' ');
154209:
154210:
154211: xla_exceptions_pkg.raise_message
154204: END IF;
154205: END LOOP;
154206:
154207: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
154208: fnd_file.put_line(fnd_file.LOG, ' ');
154209:
154210:
154211: xla_exceptions_pkg.raise_message
154212: (p_location => 'XLA_00707_AAD_S_000005_PKG.EventClass_266');
155426:
155427: l_first_event_id := l_array_header_events(l_array_header_events.FIRST);
155428: l_last_event_id := l_array_header_events(l_array_header_events.LAST);
155429:
155430: fnd_file.put_line(fnd_file.LOG, ' ');
155431: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
155432: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );
155433: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');
155434:
155427: l_first_event_id := l_array_header_events(l_array_header_events.FIRST);
155428: l_last_event_id := l_array_header_events(l_array_header_events.LAST);
155429:
155430: fnd_file.put_line(fnd_file.LOG, ' ');
155431: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
155432: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );
155433: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');
155434:
155435: FOR line_record IN line_cur(l_first_event_id, l_last_event_id)
155428: l_last_event_id := l_array_header_events(l_array_header_events.LAST);
155429:
155430: fnd_file.put_line(fnd_file.LOG, ' ');
155431: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
155432: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );
155433: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');
155434:
155435: FOR line_record IN line_cur(l_first_event_id, l_last_event_id)
155436: LOOP
155429:
155430: fnd_file.put_line(fnd_file.LOG, ' ');
155431: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
155432: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );
155433: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');
155434:
155435: FOR line_record IN line_cur(l_first_event_id, l_last_event_id)
155436: LOOP
155437: IF (NOT l_array_header_events.EXISTS(line_record.event_id)) AND (NOT l_array_duplicate_checker.EXISTS(line_record.event_id)) THEN
155434:
155435: FOR line_record IN line_cur(l_first_event_id, l_last_event_id)
155436: LOOP
155437: IF (NOT l_array_header_events.EXISTS(line_record.event_id)) AND (NOT l_array_duplicate_checker.EXISTS(line_record.event_id)) THEN
155438: fnd_file.put_line(fnd_file.log, 'Event_id = ' || line_record.event_id);
155439: l_array_duplicate_checker(line_record.event_id) := line_record.event_id;
155440: END IF;
155441: END LOOP;
155442:
155439: l_array_duplicate_checker(line_record.event_id) := line_record.event_id;
155440: END IF;
155441: END LOOP;
155442:
155443: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
155444: fnd_file.put_line(fnd_file.LOG, ' ');
155445:
155446:
155447: xla_exceptions_pkg.raise_message
155440: END IF;
155441: END LOOP;
155442:
155443: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
155444: fnd_file.put_line(fnd_file.LOG, ' ');
155445:
155446:
155447: xla_exceptions_pkg.raise_message
155448: (p_location => 'XLA_00707_AAD_S_000005_PKG.EventClass_267');
156802:
156803: l_first_event_id := l_array_header_events(l_array_header_events.FIRST);
156804: l_last_event_id := l_array_header_events(l_array_header_events.LAST);
156805:
156806: fnd_file.put_line(fnd_file.LOG, ' ');
156807: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
156808: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );
156809: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');
156810:
156803: l_first_event_id := l_array_header_events(l_array_header_events.FIRST);
156804: l_last_event_id := l_array_header_events(l_array_header_events.LAST);
156805:
156806: fnd_file.put_line(fnd_file.LOG, ' ');
156807: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
156808: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );
156809: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');
156810:
156811: FOR line_record IN line_cur(l_first_event_id, l_last_event_id)
156804: l_last_event_id := l_array_header_events(l_array_header_events.LAST);
156805:
156806: fnd_file.put_line(fnd_file.LOG, ' ');
156807: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
156808: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );
156809: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');
156810:
156811: FOR line_record IN line_cur(l_first_event_id, l_last_event_id)
156812: LOOP
156805:
156806: fnd_file.put_line(fnd_file.LOG, ' ');
156807: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
156808: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );
156809: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');
156810:
156811: FOR line_record IN line_cur(l_first_event_id, l_last_event_id)
156812: LOOP
156813: IF (NOT l_array_header_events.EXISTS(line_record.event_id)) AND (NOT l_array_duplicate_checker.EXISTS(line_record.event_id)) THEN
156810:
156811: FOR line_record IN line_cur(l_first_event_id, l_last_event_id)
156812: LOOP
156813: IF (NOT l_array_header_events.EXISTS(line_record.event_id)) AND (NOT l_array_duplicate_checker.EXISTS(line_record.event_id)) THEN
156814: fnd_file.put_line(fnd_file.log, 'Event_id = ' || line_record.event_id);
156815: l_array_duplicate_checker(line_record.event_id) := line_record.event_id;
156816: END IF;
156817: END LOOP;
156818:
156815: l_array_duplicate_checker(line_record.event_id) := line_record.event_id;
156816: END IF;
156817: END LOOP;
156818:
156819: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
156820: fnd_file.put_line(fnd_file.LOG, ' ');
156821:
156822:
156823: xla_exceptions_pkg.raise_message
156816: END IF;
156817: END LOOP;
156818:
156819: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
156820: fnd_file.put_line(fnd_file.LOG, ' ');
156821:
156822:
156823: xla_exceptions_pkg.raise_message
156824: (p_location => 'XLA_00707_AAD_S_000005_PKG.EventClass_268');
158212:
158213: l_first_event_id := l_array_header_events(l_array_header_events.FIRST);
158214: l_last_event_id := l_array_header_events(l_array_header_events.LAST);
158215:
158216: fnd_file.put_line(fnd_file.LOG, ' ');
158217: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
158218: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );
158219: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');
158220:
158213: l_first_event_id := l_array_header_events(l_array_header_events.FIRST);
158214: l_last_event_id := l_array_header_events(l_array_header_events.LAST);
158215:
158216: fnd_file.put_line(fnd_file.LOG, ' ');
158217: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
158218: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );
158219: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');
158220:
158221: FOR line_record IN line_cur(l_first_event_id, l_last_event_id)
158214: l_last_event_id := l_array_header_events(l_array_header_events.LAST);
158215:
158216: fnd_file.put_line(fnd_file.LOG, ' ');
158217: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
158218: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );
158219: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');
158220:
158221: FOR line_record IN line_cur(l_first_event_id, l_last_event_id)
158222: LOOP
158215:
158216: fnd_file.put_line(fnd_file.LOG, ' ');
158217: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
158218: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );
158219: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');
158220:
158221: FOR line_record IN line_cur(l_first_event_id, l_last_event_id)
158222: LOOP
158223: IF (NOT l_array_header_events.EXISTS(line_record.event_id)) AND (NOT l_array_duplicate_checker.EXISTS(line_record.event_id)) THEN
158220:
158221: FOR line_record IN line_cur(l_first_event_id, l_last_event_id)
158222: LOOP
158223: IF (NOT l_array_header_events.EXISTS(line_record.event_id)) AND (NOT l_array_duplicate_checker.EXISTS(line_record.event_id)) THEN
158224: fnd_file.put_line(fnd_file.log, 'Event_id = ' || line_record.event_id);
158225: l_array_duplicate_checker(line_record.event_id) := line_record.event_id;
158226: END IF;
158227: END LOOP;
158228:
158225: l_array_duplicate_checker(line_record.event_id) := line_record.event_id;
158226: END IF;
158227: END LOOP;
158228:
158229: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
158230: fnd_file.put_line(fnd_file.LOG, ' ');
158231:
158232:
158233: xla_exceptions_pkg.raise_message
158226: END IF;
158227: END LOOP;
158228:
158229: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
158230: fnd_file.put_line(fnd_file.LOG, ' ');
158231:
158232:
158233: xla_exceptions_pkg.raise_message
158234: (p_location => 'XLA_00707_AAD_S_000005_PKG.EventClass_269');
159535:
159536: l_first_event_id := l_array_header_events(l_array_header_events.FIRST);
159537: l_last_event_id := l_array_header_events(l_array_header_events.LAST);
159538:
159539: fnd_file.put_line(fnd_file.LOG, ' ');
159540: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
159541: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );
159542: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');
159543:
159536: l_first_event_id := l_array_header_events(l_array_header_events.FIRST);
159537: l_last_event_id := l_array_header_events(l_array_header_events.LAST);
159538:
159539: fnd_file.put_line(fnd_file.LOG, ' ');
159540: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
159541: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );
159542: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');
159543:
159544: FOR line_record IN line_cur(l_first_event_id, l_last_event_id)
159537: l_last_event_id := l_array_header_events(l_array_header_events.LAST);
159538:
159539: fnd_file.put_line(fnd_file.LOG, ' ');
159540: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
159541: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );
159542: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');
159543:
159544: FOR line_record IN line_cur(l_first_event_id, l_last_event_id)
159545: LOOP
159538:
159539: fnd_file.put_line(fnd_file.LOG, ' ');
159540: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
159541: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );
159542: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');
159543:
159544: FOR line_record IN line_cur(l_first_event_id, l_last_event_id)
159545: LOOP
159546: IF (NOT l_array_header_events.EXISTS(line_record.event_id)) AND (NOT l_array_duplicate_checker.EXISTS(line_record.event_id)) THEN
159543:
159544: FOR line_record IN line_cur(l_first_event_id, l_last_event_id)
159545: LOOP
159546: IF (NOT l_array_header_events.EXISTS(line_record.event_id)) AND (NOT l_array_duplicate_checker.EXISTS(line_record.event_id)) THEN
159547: fnd_file.put_line(fnd_file.log, 'Event_id = ' || line_record.event_id);
159548: l_array_duplicate_checker(line_record.event_id) := line_record.event_id;
159549: END IF;
159550: END LOOP;
159551:
159548: l_array_duplicate_checker(line_record.event_id) := line_record.event_id;
159549: END IF;
159550: END LOOP;
159551:
159552: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
159553: fnd_file.put_line(fnd_file.LOG, ' ');
159554:
159555:
159556: xla_exceptions_pkg.raise_message
159549: END IF;
159550: END LOOP;
159551:
159552: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
159553: fnd_file.put_line(fnd_file.LOG, ' ');
159554:
159555:
159556: xla_exceptions_pkg.raise_message
159557: (p_location => 'XLA_00707_AAD_S_000005_PKG.EventClass_270');
160771:
160772: l_first_event_id := l_array_header_events(l_array_header_events.FIRST);
160773: l_last_event_id := l_array_header_events(l_array_header_events.LAST);
160774:
160775: fnd_file.put_line(fnd_file.LOG, ' ');
160776: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
160777: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );
160778: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');
160779:
160772: l_first_event_id := l_array_header_events(l_array_header_events.FIRST);
160773: l_last_event_id := l_array_header_events(l_array_header_events.LAST);
160774:
160775: fnd_file.put_line(fnd_file.LOG, ' ');
160776: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
160777: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );
160778: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');
160779:
160780: FOR line_record IN line_cur(l_first_event_id, l_last_event_id)
160773: l_last_event_id := l_array_header_events(l_array_header_events.LAST);
160774:
160775: fnd_file.put_line(fnd_file.LOG, ' ');
160776: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
160777: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );
160778: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');
160779:
160780: FOR line_record IN line_cur(l_first_event_id, l_last_event_id)
160781: LOOP
160774:
160775: fnd_file.put_line(fnd_file.LOG, ' ');
160776: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
160777: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );
160778: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');
160779:
160780: FOR line_record IN line_cur(l_first_event_id, l_last_event_id)
160781: LOOP
160782: IF (NOT l_array_header_events.EXISTS(line_record.event_id)) AND (NOT l_array_duplicate_checker.EXISTS(line_record.event_id)) THEN
160779:
160780: FOR line_record IN line_cur(l_first_event_id, l_last_event_id)
160781: LOOP
160782: IF (NOT l_array_header_events.EXISTS(line_record.event_id)) AND (NOT l_array_duplicate_checker.EXISTS(line_record.event_id)) THEN
160783: fnd_file.put_line(fnd_file.log, 'Event_id = ' || line_record.event_id);
160784: l_array_duplicate_checker(line_record.event_id) := line_record.event_id;
160785: END IF;
160786: END LOOP;
160787:
160784: l_array_duplicate_checker(line_record.event_id) := line_record.event_id;
160785: END IF;
160786: END LOOP;
160787:
160788: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
160789: fnd_file.put_line(fnd_file.LOG, ' ');
160790:
160791:
160792: xla_exceptions_pkg.raise_message
160785: END IF;
160786: END LOOP;
160787:
160788: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
160789: fnd_file.put_line(fnd_file.LOG, ' ');
160790:
160791:
160792: xla_exceptions_pkg.raise_message
160793: (p_location => 'XLA_00707_AAD_S_000005_PKG.EventClass_271');
162065:
162066: l_first_event_id := l_array_header_events(l_array_header_events.FIRST);
162067: l_last_event_id := l_array_header_events(l_array_header_events.LAST);
162068:
162069: fnd_file.put_line(fnd_file.LOG, ' ');
162070: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
162071: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );
162072: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');
162073:
162066: l_first_event_id := l_array_header_events(l_array_header_events.FIRST);
162067: l_last_event_id := l_array_header_events(l_array_header_events.LAST);
162068:
162069: fnd_file.put_line(fnd_file.LOG, ' ');
162070: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
162071: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );
162072: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');
162073:
162074: FOR line_record IN line_cur(l_first_event_id, l_last_event_id)
162067: l_last_event_id := l_array_header_events(l_array_header_events.LAST);
162068:
162069: fnd_file.put_line(fnd_file.LOG, ' ');
162070: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
162071: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );
162072: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');
162073:
162074: FOR line_record IN line_cur(l_first_event_id, l_last_event_id)
162075: LOOP
162068:
162069: fnd_file.put_line(fnd_file.LOG, ' ');
162070: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
162071: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );
162072: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');
162073:
162074: FOR line_record IN line_cur(l_first_event_id, l_last_event_id)
162075: LOOP
162076: IF (NOT l_array_header_events.EXISTS(line_record.event_id)) AND (NOT l_array_duplicate_checker.EXISTS(line_record.event_id)) THEN
162073:
162074: FOR line_record IN line_cur(l_first_event_id, l_last_event_id)
162075: LOOP
162076: IF (NOT l_array_header_events.EXISTS(line_record.event_id)) AND (NOT l_array_duplicate_checker.EXISTS(line_record.event_id)) THEN
162077: fnd_file.put_line(fnd_file.log, 'Event_id = ' || line_record.event_id);
162078: l_array_duplicate_checker(line_record.event_id) := line_record.event_id;
162079: END IF;
162080: END LOOP;
162081:
162078: l_array_duplicate_checker(line_record.event_id) := line_record.event_id;
162079: END IF;
162080: END LOOP;
162081:
162082: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
162083: fnd_file.put_line(fnd_file.LOG, ' ');
162084:
162085:
162086: xla_exceptions_pkg.raise_message
162079: END IF;
162080: END LOOP;
162081:
162082: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
162083: fnd_file.put_line(fnd_file.LOG, ' ');
162084:
162085:
162086: xla_exceptions_pkg.raise_message
162087: (p_location => 'XLA_00707_AAD_S_000005_PKG.EventClass_272');
163324:
163325: l_first_event_id := l_array_header_events(l_array_header_events.FIRST);
163326: l_last_event_id := l_array_header_events(l_array_header_events.LAST);
163327:
163328: fnd_file.put_line(fnd_file.LOG, ' ');
163329: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
163330: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );
163331: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');
163332:
163325: l_first_event_id := l_array_header_events(l_array_header_events.FIRST);
163326: l_last_event_id := l_array_header_events(l_array_header_events.LAST);
163327:
163328: fnd_file.put_line(fnd_file.LOG, ' ');
163329: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
163330: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );
163331: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');
163332:
163333: FOR line_record IN line_cur(l_first_event_id, l_last_event_id)
163326: l_last_event_id := l_array_header_events(l_array_header_events.LAST);
163327:
163328: fnd_file.put_line(fnd_file.LOG, ' ');
163329: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
163330: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );
163331: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');
163332:
163333: FOR line_record IN line_cur(l_first_event_id, l_last_event_id)
163334: LOOP
163327:
163328: fnd_file.put_line(fnd_file.LOG, ' ');
163329: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
163330: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );
163331: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');
163332:
163333: FOR line_record IN line_cur(l_first_event_id, l_last_event_id)
163334: LOOP
163335: IF (NOT l_array_header_events.EXISTS(line_record.event_id)) AND (NOT l_array_duplicate_checker.EXISTS(line_record.event_id)) THEN
163332:
163333: FOR line_record IN line_cur(l_first_event_id, l_last_event_id)
163334: LOOP
163335: IF (NOT l_array_header_events.EXISTS(line_record.event_id)) AND (NOT l_array_duplicate_checker.EXISTS(line_record.event_id)) THEN
163336: fnd_file.put_line(fnd_file.log, 'Event_id = ' || line_record.event_id);
163337: l_array_duplicate_checker(line_record.event_id) := line_record.event_id;
163338: END IF;
163339: END LOOP;
163340:
163337: l_array_duplicate_checker(line_record.event_id) := line_record.event_id;
163338: END IF;
163339: END LOOP;
163340:
163341: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
163342: fnd_file.put_line(fnd_file.LOG, ' ');
163343:
163344:
163345: xla_exceptions_pkg.raise_message
163338: END IF;
163339: END LOOP;
163340:
163341: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
163342: fnd_file.put_line(fnd_file.LOG, ' ');
163343:
163344:
163345: xla_exceptions_pkg.raise_message
163346: (p_location => 'XLA_00707_AAD_S_000005_PKG.EventClass_273');
164539:
164540: l_first_event_id := l_array_header_events(l_array_header_events.FIRST);
164541: l_last_event_id := l_array_header_events(l_array_header_events.LAST);
164542:
164543: fnd_file.put_line(fnd_file.LOG, ' ');
164544: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
164545: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );
164546: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');
164547:
164540: l_first_event_id := l_array_header_events(l_array_header_events.FIRST);
164541: l_last_event_id := l_array_header_events(l_array_header_events.LAST);
164542:
164543: fnd_file.put_line(fnd_file.LOG, ' ');
164544: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
164545: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );
164546: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');
164547:
164548: FOR line_record IN line_cur(l_first_event_id, l_last_event_id)
164541: l_last_event_id := l_array_header_events(l_array_header_events.LAST);
164542:
164543: fnd_file.put_line(fnd_file.LOG, ' ');
164544: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
164545: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );
164546: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');
164547:
164548: FOR line_record IN line_cur(l_first_event_id, l_last_event_id)
164549: LOOP
164542:
164543: fnd_file.put_line(fnd_file.LOG, ' ');
164544: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
164545: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );
164546: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');
164547:
164548: FOR line_record IN line_cur(l_first_event_id, l_last_event_id)
164549: LOOP
164550: IF (NOT l_array_header_events.EXISTS(line_record.event_id)) AND (NOT l_array_duplicate_checker.EXISTS(line_record.event_id)) THEN
164547:
164548: FOR line_record IN line_cur(l_first_event_id, l_last_event_id)
164549: LOOP
164550: IF (NOT l_array_header_events.EXISTS(line_record.event_id)) AND (NOT l_array_duplicate_checker.EXISTS(line_record.event_id)) THEN
164551: fnd_file.put_line(fnd_file.log, 'Event_id = ' || line_record.event_id);
164552: l_array_duplicate_checker(line_record.event_id) := line_record.event_id;
164553: END IF;
164554: END LOOP;
164555:
164552: l_array_duplicate_checker(line_record.event_id) := line_record.event_id;
164553: END IF;
164554: END LOOP;
164555:
164556: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
164557: fnd_file.put_line(fnd_file.LOG, ' ');
164558:
164559:
164560: xla_exceptions_pkg.raise_message
164553: END IF;
164554: END LOOP;
164555:
164556: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
164557: fnd_file.put_line(fnd_file.LOG, ' ');
164558:
164559:
164560: xla_exceptions_pkg.raise_message
164561: (p_location => 'XLA_00707_AAD_S_000005_PKG.EventClass_274');
165862:
165863: l_first_event_id := l_array_header_events(l_array_header_events.FIRST);
165864: l_last_event_id := l_array_header_events(l_array_header_events.LAST);
165865:
165866: fnd_file.put_line(fnd_file.LOG, ' ');
165867: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
165868: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );
165869: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');
165870:
165863: l_first_event_id := l_array_header_events(l_array_header_events.FIRST);
165864: l_last_event_id := l_array_header_events(l_array_header_events.LAST);
165865:
165866: fnd_file.put_line(fnd_file.LOG, ' ');
165867: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
165868: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );
165869: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');
165870:
165871: FOR line_record IN line_cur(l_first_event_id, l_last_event_id)
165864: l_last_event_id := l_array_header_events(l_array_header_events.LAST);
165865:
165866: fnd_file.put_line(fnd_file.LOG, ' ');
165867: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
165868: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );
165869: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');
165870:
165871: FOR line_record IN line_cur(l_first_event_id, l_last_event_id)
165872: LOOP
165865:
165866: fnd_file.put_line(fnd_file.LOG, ' ');
165867: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
165868: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );
165869: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');
165870:
165871: FOR line_record IN line_cur(l_first_event_id, l_last_event_id)
165872: LOOP
165873: IF (NOT l_array_header_events.EXISTS(line_record.event_id)) AND (NOT l_array_duplicate_checker.EXISTS(line_record.event_id)) THEN
165870:
165871: FOR line_record IN line_cur(l_first_event_id, l_last_event_id)
165872: LOOP
165873: IF (NOT l_array_header_events.EXISTS(line_record.event_id)) AND (NOT l_array_duplicate_checker.EXISTS(line_record.event_id)) THEN
165874: fnd_file.put_line(fnd_file.log, 'Event_id = ' || line_record.event_id);
165875: l_array_duplicate_checker(line_record.event_id) := line_record.event_id;
165876: END IF;
165877: END LOOP;
165878:
165875: l_array_duplicate_checker(line_record.event_id) := line_record.event_id;
165876: END IF;
165877: END LOOP;
165878:
165879: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
165880: fnd_file.put_line(fnd_file.LOG, ' ');
165881:
165882:
165883: xla_exceptions_pkg.raise_message
165876: END IF;
165877: END LOOP;
165878:
165879: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
165880: fnd_file.put_line(fnd_file.LOG, ' ');
165881:
165882:
165883: xla_exceptions_pkg.raise_message
165884: (p_location => 'XLA_00707_AAD_S_000005_PKG.EventClass_275');
167069:
167070: l_first_event_id := l_array_header_events(l_array_header_events.FIRST);
167071: l_last_event_id := l_array_header_events(l_array_header_events.LAST);
167072:
167073: fnd_file.put_line(fnd_file.LOG, ' ');
167074: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
167075: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );
167076: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');
167077:
167070: l_first_event_id := l_array_header_events(l_array_header_events.FIRST);
167071: l_last_event_id := l_array_header_events(l_array_header_events.LAST);
167072:
167073: fnd_file.put_line(fnd_file.LOG, ' ');
167074: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
167075: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );
167076: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');
167077:
167078: FOR line_record IN line_cur(l_first_event_id, l_last_event_id)
167071: l_last_event_id := l_array_header_events(l_array_header_events.LAST);
167072:
167073: fnd_file.put_line(fnd_file.LOG, ' ');
167074: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
167075: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );
167076: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');
167077:
167078: FOR line_record IN line_cur(l_first_event_id, l_last_event_id)
167079: LOOP
167072:
167073: fnd_file.put_line(fnd_file.LOG, ' ');
167074: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
167075: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );
167076: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');
167077:
167078: FOR line_record IN line_cur(l_first_event_id, l_last_event_id)
167079: LOOP
167080: IF (NOT l_array_header_events.EXISTS(line_record.event_id)) AND (NOT l_array_duplicate_checker.EXISTS(line_record.event_id)) THEN
167077:
167078: FOR line_record IN line_cur(l_first_event_id, l_last_event_id)
167079: LOOP
167080: IF (NOT l_array_header_events.EXISTS(line_record.event_id)) AND (NOT l_array_duplicate_checker.EXISTS(line_record.event_id)) THEN
167081: fnd_file.put_line(fnd_file.log, 'Event_id = ' || line_record.event_id);
167082: l_array_duplicate_checker(line_record.event_id) := line_record.event_id;
167083: END IF;
167084: END LOOP;
167085:
167082: l_array_duplicate_checker(line_record.event_id) := line_record.event_id;
167083: END IF;
167084: END LOOP;
167085:
167086: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
167087: fnd_file.put_line(fnd_file.LOG, ' ');
167088:
167089:
167090: xla_exceptions_pkg.raise_message
167083: END IF;
167084: END LOOP;
167085:
167086: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
167087: fnd_file.put_line(fnd_file.LOG, ' ');
167088:
167089:
167090: xla_exceptions_pkg.raise_message
167091: (p_location => 'XLA_00707_AAD_S_000005_PKG.EventClass_276');
168305:
168306: l_first_event_id := l_array_header_events(l_array_header_events.FIRST);
168307: l_last_event_id := l_array_header_events(l_array_header_events.LAST);
168308:
168309: fnd_file.put_line(fnd_file.LOG, ' ');
168310: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
168311: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );
168312: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');
168313:
168306: l_first_event_id := l_array_header_events(l_array_header_events.FIRST);
168307: l_last_event_id := l_array_header_events(l_array_header_events.LAST);
168308:
168309: fnd_file.put_line(fnd_file.LOG, ' ');
168310: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
168311: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );
168312: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');
168313:
168314: FOR line_record IN line_cur(l_first_event_id, l_last_event_id)
168307: l_last_event_id := l_array_header_events(l_array_header_events.LAST);
168308:
168309: fnd_file.put_line(fnd_file.LOG, ' ');
168310: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
168311: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );
168312: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');
168313:
168314: FOR line_record IN line_cur(l_first_event_id, l_last_event_id)
168315: LOOP
168308:
168309: fnd_file.put_line(fnd_file.LOG, ' ');
168310: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
168311: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );
168312: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');
168313:
168314: FOR line_record IN line_cur(l_first_event_id, l_last_event_id)
168315: LOOP
168316: IF (NOT l_array_header_events.EXISTS(line_record.event_id)) AND (NOT l_array_duplicate_checker.EXISTS(line_record.event_id)) THEN
168313:
168314: FOR line_record IN line_cur(l_first_event_id, l_last_event_id)
168315: LOOP
168316: IF (NOT l_array_header_events.EXISTS(line_record.event_id)) AND (NOT l_array_duplicate_checker.EXISTS(line_record.event_id)) THEN
168317: fnd_file.put_line(fnd_file.log, 'Event_id = ' || line_record.event_id);
168318: l_array_duplicate_checker(line_record.event_id) := line_record.event_id;
168319: END IF;
168320: END LOOP;
168321:
168318: l_array_duplicate_checker(line_record.event_id) := line_record.event_id;
168319: END IF;
168320: END LOOP;
168321:
168322: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
168323: fnd_file.put_line(fnd_file.LOG, ' ');
168324:
168325:
168326: xla_exceptions_pkg.raise_message
168319: END IF;
168320: END LOOP;
168321:
168322: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
168323: fnd_file.put_line(fnd_file.LOG, ' ');
168324:
168325:
168326: xla_exceptions_pkg.raise_message
168327: (p_location => 'XLA_00707_AAD_S_000005_PKG.EventClass_277');
169599:
169600: l_first_event_id := l_array_header_events(l_array_header_events.FIRST);
169601: l_last_event_id := l_array_header_events(l_array_header_events.LAST);
169602:
169603: fnd_file.put_line(fnd_file.LOG, ' ');
169604: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
169605: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );
169606: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');
169607:
169600: l_first_event_id := l_array_header_events(l_array_header_events.FIRST);
169601: l_last_event_id := l_array_header_events(l_array_header_events.LAST);
169602:
169603: fnd_file.put_line(fnd_file.LOG, ' ');
169604: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
169605: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );
169606: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');
169607:
169608: FOR line_record IN line_cur(l_first_event_id, l_last_event_id)
169601: l_last_event_id := l_array_header_events(l_array_header_events.LAST);
169602:
169603: fnd_file.put_line(fnd_file.LOG, ' ');
169604: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
169605: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );
169606: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');
169607:
169608: FOR line_record IN line_cur(l_first_event_id, l_last_event_id)
169609: LOOP
169602:
169603: fnd_file.put_line(fnd_file.LOG, ' ');
169604: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
169605: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );
169606: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');
169607:
169608: FOR line_record IN line_cur(l_first_event_id, l_last_event_id)
169609: LOOP
169610: IF (NOT l_array_header_events.EXISTS(line_record.event_id)) AND (NOT l_array_duplicate_checker.EXISTS(line_record.event_id)) THEN
169607:
169608: FOR line_record IN line_cur(l_first_event_id, l_last_event_id)
169609: LOOP
169610: IF (NOT l_array_header_events.EXISTS(line_record.event_id)) AND (NOT l_array_duplicate_checker.EXISTS(line_record.event_id)) THEN
169611: fnd_file.put_line(fnd_file.log, 'Event_id = ' || line_record.event_id);
169612: l_array_duplicate_checker(line_record.event_id) := line_record.event_id;
169613: END IF;
169614: END LOOP;
169615:
169612: l_array_duplicate_checker(line_record.event_id) := line_record.event_id;
169613: END IF;
169614: END LOOP;
169615:
169616: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
169617: fnd_file.put_line(fnd_file.LOG, ' ');
169618:
169619:
169620: xla_exceptions_pkg.raise_message
169613: END IF;
169614: END LOOP;
169615:
169616: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
169617: fnd_file.put_line(fnd_file.LOG, ' ');
169618:
169619:
169620: xla_exceptions_pkg.raise_message
169621: (p_location => 'XLA_00707_AAD_S_000005_PKG.EventClass_278');
170910:
170911: l_first_event_id := l_array_header_events(l_array_header_events.FIRST);
170912: l_last_event_id := l_array_header_events(l_array_header_events.LAST);
170913:
170914: fnd_file.put_line(fnd_file.LOG, ' ');
170915: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
170916: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );
170917: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');
170918:
170911: l_first_event_id := l_array_header_events(l_array_header_events.FIRST);
170912: l_last_event_id := l_array_header_events(l_array_header_events.LAST);
170913:
170914: fnd_file.put_line(fnd_file.LOG, ' ');
170915: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
170916: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );
170917: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');
170918:
170919: FOR line_record IN line_cur(l_first_event_id, l_last_event_id)
170912: l_last_event_id := l_array_header_events(l_array_header_events.LAST);
170913:
170914: fnd_file.put_line(fnd_file.LOG, ' ');
170915: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
170916: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );
170917: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');
170918:
170919: FOR line_record IN line_cur(l_first_event_id, l_last_event_id)
170920: LOOP
170913:
170914: fnd_file.put_line(fnd_file.LOG, ' ');
170915: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
170916: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );
170917: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');
170918:
170919: FOR line_record IN line_cur(l_first_event_id, l_last_event_id)
170920: LOOP
170921: IF (NOT l_array_header_events.EXISTS(line_record.event_id)) AND (NOT l_array_duplicate_checker.EXISTS(line_record.event_id)) THEN
170918:
170919: FOR line_record IN line_cur(l_first_event_id, l_last_event_id)
170920: LOOP
170921: IF (NOT l_array_header_events.EXISTS(line_record.event_id)) AND (NOT l_array_duplicate_checker.EXISTS(line_record.event_id)) THEN
170922: fnd_file.put_line(fnd_file.log, 'Event_id = ' || line_record.event_id);
170923: l_array_duplicate_checker(line_record.event_id) := line_record.event_id;
170924: END IF;
170925: END LOOP;
170926:
170923: l_array_duplicate_checker(line_record.event_id) := line_record.event_id;
170924: END IF;
170925: END LOOP;
170926:
170927: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
170928: fnd_file.put_line(fnd_file.LOG, ' ');
170929:
170930:
170931: xla_exceptions_pkg.raise_message
170924: END IF;
170925: END LOOP;
170926:
170927: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
170928: fnd_file.put_line(fnd_file.LOG, ' ');
170929:
170930:
170931: xla_exceptions_pkg.raise_message
170932: (p_location => 'XLA_00707_AAD_S_000005_PKG.EventClass_279');
172297:
172298: l_first_event_id := l_array_header_events(l_array_header_events.FIRST);
172299: l_last_event_id := l_array_header_events(l_array_header_events.LAST);
172300:
172301: fnd_file.put_line(fnd_file.LOG, ' ');
172302: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
172303: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );
172304: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');
172305:
172298: l_first_event_id := l_array_header_events(l_array_header_events.FIRST);
172299: l_last_event_id := l_array_header_events(l_array_header_events.LAST);
172300:
172301: fnd_file.put_line(fnd_file.LOG, ' ');
172302: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
172303: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );
172304: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');
172305:
172306: FOR line_record IN line_cur(l_first_event_id, l_last_event_id)
172299: l_last_event_id := l_array_header_events(l_array_header_events.LAST);
172300:
172301: fnd_file.put_line(fnd_file.LOG, ' ');
172302: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
172303: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );
172304: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');
172305:
172306: FOR line_record IN line_cur(l_first_event_id, l_last_event_id)
172307: LOOP
172300:
172301: fnd_file.put_line(fnd_file.LOG, ' ');
172302: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
172303: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );
172304: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');
172305:
172306: FOR line_record IN line_cur(l_first_event_id, l_last_event_id)
172307: LOOP
172308: IF (NOT l_array_header_events.EXISTS(line_record.event_id)) AND (NOT l_array_duplicate_checker.EXISTS(line_record.event_id)) THEN
172305:
172306: FOR line_record IN line_cur(l_first_event_id, l_last_event_id)
172307: LOOP
172308: IF (NOT l_array_header_events.EXISTS(line_record.event_id)) AND (NOT l_array_duplicate_checker.EXISTS(line_record.event_id)) THEN
172309: fnd_file.put_line(fnd_file.log, 'Event_id = ' || line_record.event_id);
172310: l_array_duplicate_checker(line_record.event_id) := line_record.event_id;
172311: END IF;
172312: END LOOP;
172313:
172310: l_array_duplicate_checker(line_record.event_id) := line_record.event_id;
172311: END IF;
172312: END LOOP;
172313:
172314: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
172315: fnd_file.put_line(fnd_file.LOG, ' ');
172316:
172317:
172318: xla_exceptions_pkg.raise_message
172311: END IF;
172312: END LOOP;
172313:
172314: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
172315: fnd_file.put_line(fnd_file.LOG, ' ');
172316:
172317:
172318: xla_exceptions_pkg.raise_message
172319: (p_location => 'XLA_00707_AAD_S_000005_PKG.EventClass_280');
173868:
173869: l_first_event_id := l_array_header_events(l_array_header_events.FIRST);
173870: l_last_event_id := l_array_header_events(l_array_header_events.LAST);
173871:
173872: fnd_file.put_line(fnd_file.LOG, ' ');
173873: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
173874: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );
173875: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');
173876:
173869: l_first_event_id := l_array_header_events(l_array_header_events.FIRST);
173870: l_last_event_id := l_array_header_events(l_array_header_events.LAST);
173871:
173872: fnd_file.put_line(fnd_file.LOG, ' ');
173873: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
173874: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );
173875: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');
173876:
173877: FOR line_record IN line_cur(l_first_event_id, l_last_event_id)
173870: l_last_event_id := l_array_header_events(l_array_header_events.LAST);
173871:
173872: fnd_file.put_line(fnd_file.LOG, ' ');
173873: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
173874: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );
173875: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');
173876:
173877: FOR line_record IN line_cur(l_first_event_id, l_last_event_id)
173878: LOOP
173871:
173872: fnd_file.put_line(fnd_file.LOG, ' ');
173873: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
173874: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );
173875: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');
173876:
173877: FOR line_record IN line_cur(l_first_event_id, l_last_event_id)
173878: LOOP
173879: IF (NOT l_array_header_events.EXISTS(line_record.event_id)) AND (NOT l_array_duplicate_checker.EXISTS(line_record.event_id)) THEN
173876:
173877: FOR line_record IN line_cur(l_first_event_id, l_last_event_id)
173878: LOOP
173879: IF (NOT l_array_header_events.EXISTS(line_record.event_id)) AND (NOT l_array_duplicate_checker.EXISTS(line_record.event_id)) THEN
173880: fnd_file.put_line(fnd_file.log, 'Event_id = ' || line_record.event_id);
173881: l_array_duplicate_checker(line_record.event_id) := line_record.event_id;
173882: END IF;
173883: END LOOP;
173884:
173881: l_array_duplicate_checker(line_record.event_id) := line_record.event_id;
173882: END IF;
173883: END LOOP;
173884:
173885: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
173886: fnd_file.put_line(fnd_file.LOG, ' ');
173887:
173888:
173889: xla_exceptions_pkg.raise_message
173882: END IF;
173883: END LOOP;
173884:
173885: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
173886: fnd_file.put_line(fnd_file.LOG, ' ');
173887:
173888:
173889: xla_exceptions_pkg.raise_message
173890: (p_location => 'XLA_00707_AAD_S_000005_PKG.EventClass_281');
175195:
175196: l_first_event_id := l_array_header_events(l_array_header_events.FIRST);
175197: l_last_event_id := l_array_header_events(l_array_header_events.LAST);
175198:
175199: fnd_file.put_line(fnd_file.LOG, ' ');
175200: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
175201: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );
175202: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');
175203:
175196: l_first_event_id := l_array_header_events(l_array_header_events.FIRST);
175197: l_last_event_id := l_array_header_events(l_array_header_events.LAST);
175198:
175199: fnd_file.put_line(fnd_file.LOG, ' ');
175200: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
175201: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );
175202: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');
175203:
175204: FOR line_record IN line_cur(l_first_event_id, l_last_event_id)
175197: l_last_event_id := l_array_header_events(l_array_header_events.LAST);
175198:
175199: fnd_file.put_line(fnd_file.LOG, ' ');
175200: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
175201: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );
175202: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');
175203:
175204: FOR line_record IN line_cur(l_first_event_id, l_last_event_id)
175205: LOOP
175198:
175199: fnd_file.put_line(fnd_file.LOG, ' ');
175200: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
175201: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );
175202: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');
175203:
175204: FOR line_record IN line_cur(l_first_event_id, l_last_event_id)
175205: LOOP
175206: IF (NOT l_array_header_events.EXISTS(line_record.event_id)) AND (NOT l_array_duplicate_checker.EXISTS(line_record.event_id)) THEN
175203:
175204: FOR line_record IN line_cur(l_first_event_id, l_last_event_id)
175205: LOOP
175206: IF (NOT l_array_header_events.EXISTS(line_record.event_id)) AND (NOT l_array_duplicate_checker.EXISTS(line_record.event_id)) THEN
175207: fnd_file.put_line(fnd_file.log, 'Event_id = ' || line_record.event_id);
175208: l_array_duplicate_checker(line_record.event_id) := line_record.event_id;
175209: END IF;
175210: END LOOP;
175211:
175208: l_array_duplicate_checker(line_record.event_id) := line_record.event_id;
175209: END IF;
175210: END LOOP;
175211:
175212: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
175213: fnd_file.put_line(fnd_file.LOG, ' ');
175214:
175215:
175216: xla_exceptions_pkg.raise_message
175209: END IF;
175210: END LOOP;
175211:
175212: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
175213: fnd_file.put_line(fnd_file.LOG, ' ');
175214:
175215:
175216: xla_exceptions_pkg.raise_message
175217: (p_location => 'XLA_00707_AAD_S_000005_PKG.EventClass_282');
176402:
176403: l_first_event_id := l_array_header_events(l_array_header_events.FIRST);
176404: l_last_event_id := l_array_header_events(l_array_header_events.LAST);
176405:
176406: fnd_file.put_line(fnd_file.LOG, ' ');
176407: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
176408: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );
176409: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');
176410:
176403: l_first_event_id := l_array_header_events(l_array_header_events.FIRST);
176404: l_last_event_id := l_array_header_events(l_array_header_events.LAST);
176405:
176406: fnd_file.put_line(fnd_file.LOG, ' ');
176407: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
176408: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );
176409: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');
176410:
176411: FOR line_record IN line_cur(l_first_event_id, l_last_event_id)
176404: l_last_event_id := l_array_header_events(l_array_header_events.LAST);
176405:
176406: fnd_file.put_line(fnd_file.LOG, ' ');
176407: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
176408: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );
176409: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');
176410:
176411: FOR line_record IN line_cur(l_first_event_id, l_last_event_id)
176412: LOOP
176405:
176406: fnd_file.put_line(fnd_file.LOG, ' ');
176407: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
176408: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );
176409: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');
176410:
176411: FOR line_record IN line_cur(l_first_event_id, l_last_event_id)
176412: LOOP
176413: IF (NOT l_array_header_events.EXISTS(line_record.event_id)) AND (NOT l_array_duplicate_checker.EXISTS(line_record.event_id)) THEN
176410:
176411: FOR line_record IN line_cur(l_first_event_id, l_last_event_id)
176412: LOOP
176413: IF (NOT l_array_header_events.EXISTS(line_record.event_id)) AND (NOT l_array_duplicate_checker.EXISTS(line_record.event_id)) THEN
176414: fnd_file.put_line(fnd_file.log, 'Event_id = ' || line_record.event_id);
176415: l_array_duplicate_checker(line_record.event_id) := line_record.event_id;
176416: END IF;
176417: END LOOP;
176418:
176415: l_array_duplicate_checker(line_record.event_id) := line_record.event_id;
176416: END IF;
176417: END LOOP;
176418:
176419: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
176420: fnd_file.put_line(fnd_file.LOG, ' ');
176421:
176422:
176423: xla_exceptions_pkg.raise_message
176416: END IF;
176417: END LOOP;
176418:
176419: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
176420: fnd_file.put_line(fnd_file.LOG, ' ');
176421:
176422:
176423: xla_exceptions_pkg.raise_message
176424: (p_location => 'XLA_00707_AAD_S_000005_PKG.EventClass_283');
177629:
177630: l_first_event_id := l_array_header_events(l_array_header_events.FIRST);
177631: l_last_event_id := l_array_header_events(l_array_header_events.LAST);
177632:
177633: fnd_file.put_line(fnd_file.LOG, ' ');
177634: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
177635: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );
177636: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');
177637:
177630: l_first_event_id := l_array_header_events(l_array_header_events.FIRST);
177631: l_last_event_id := l_array_header_events(l_array_header_events.LAST);
177632:
177633: fnd_file.put_line(fnd_file.LOG, ' ');
177634: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
177635: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );
177636: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');
177637:
177638: FOR line_record IN line_cur(l_first_event_id, l_last_event_id)
177631: l_last_event_id := l_array_header_events(l_array_header_events.LAST);
177632:
177633: fnd_file.put_line(fnd_file.LOG, ' ');
177634: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
177635: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );
177636: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');
177637:
177638: FOR line_record IN line_cur(l_first_event_id, l_last_event_id)
177639: LOOP
177632:
177633: fnd_file.put_line(fnd_file.LOG, ' ');
177634: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
177635: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );
177636: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');
177637:
177638: FOR line_record IN line_cur(l_first_event_id, l_last_event_id)
177639: LOOP
177640: IF (NOT l_array_header_events.EXISTS(line_record.event_id)) AND (NOT l_array_duplicate_checker.EXISTS(line_record.event_id)) THEN
177637:
177638: FOR line_record IN line_cur(l_first_event_id, l_last_event_id)
177639: LOOP
177640: IF (NOT l_array_header_events.EXISTS(line_record.event_id)) AND (NOT l_array_duplicate_checker.EXISTS(line_record.event_id)) THEN
177641: fnd_file.put_line(fnd_file.log, 'Event_id = ' || line_record.event_id);
177642: l_array_duplicate_checker(line_record.event_id) := line_record.event_id;
177643: END IF;
177644: END LOOP;
177645:
177642: l_array_duplicate_checker(line_record.event_id) := line_record.event_id;
177643: END IF;
177644: END LOOP;
177645:
177646: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
177647: fnd_file.put_line(fnd_file.LOG, ' ');
177648:
177649:
177650: xla_exceptions_pkg.raise_message
177643: END IF;
177644: END LOOP;
177645:
177646: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
177647: fnd_file.put_line(fnd_file.LOG, ' ');
177648:
177649:
177650: xla_exceptions_pkg.raise_message
177651: (p_location => 'XLA_00707_AAD_S_000005_PKG.EventClass_284');
178898:
178899: l_first_event_id := l_array_header_events(l_array_header_events.FIRST);
178900: l_last_event_id := l_array_header_events(l_array_header_events.LAST);
178901:
178902: fnd_file.put_line(fnd_file.LOG, ' ');
178903: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
178904: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );
178905: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');
178906:
178899: l_first_event_id := l_array_header_events(l_array_header_events.FIRST);
178900: l_last_event_id := l_array_header_events(l_array_header_events.LAST);
178901:
178902: fnd_file.put_line(fnd_file.LOG, ' ');
178903: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
178904: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );
178905: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');
178906:
178907: FOR line_record IN line_cur(l_first_event_id, l_last_event_id)
178900: l_last_event_id := l_array_header_events(l_array_header_events.LAST);
178901:
178902: fnd_file.put_line(fnd_file.LOG, ' ');
178903: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
178904: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );
178905: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');
178906:
178907: FOR line_record IN line_cur(l_first_event_id, l_last_event_id)
178908: LOOP
178901:
178902: fnd_file.put_line(fnd_file.LOG, ' ');
178903: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
178904: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );
178905: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');
178906:
178907: FOR line_record IN line_cur(l_first_event_id, l_last_event_id)
178908: LOOP
178909: IF (NOT l_array_header_events.EXISTS(line_record.event_id)) AND (NOT l_array_duplicate_checker.EXISTS(line_record.event_id)) THEN
178906:
178907: FOR line_record IN line_cur(l_first_event_id, l_last_event_id)
178908: LOOP
178909: IF (NOT l_array_header_events.EXISTS(line_record.event_id)) AND (NOT l_array_duplicate_checker.EXISTS(line_record.event_id)) THEN
178910: fnd_file.put_line(fnd_file.log, 'Event_id = ' || line_record.event_id);
178911: l_array_duplicate_checker(line_record.event_id) := line_record.event_id;
178912: END IF;
178913: END LOOP;
178914:
178911: l_array_duplicate_checker(line_record.event_id) := line_record.event_id;
178912: END IF;
178913: END LOOP;
178914:
178915: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
178916: fnd_file.put_line(fnd_file.LOG, ' ');
178917:
178918:
178919: xla_exceptions_pkg.raise_message
178912: END IF;
178913: END LOOP;
178914:
178915: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
178916: fnd_file.put_line(fnd_file.LOG, ' ');
178917:
178918:
178919: xla_exceptions_pkg.raise_message
178920: (p_location => 'XLA_00707_AAD_S_000005_PKG.EventClass_285');
180192:
180193: l_first_event_id := l_array_header_events(l_array_header_events.FIRST);
180194: l_last_event_id := l_array_header_events(l_array_header_events.LAST);
180195:
180196: fnd_file.put_line(fnd_file.LOG, ' ');
180197: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
180198: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );
180199: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');
180200:
180193: l_first_event_id := l_array_header_events(l_array_header_events.FIRST);
180194: l_last_event_id := l_array_header_events(l_array_header_events.LAST);
180195:
180196: fnd_file.put_line(fnd_file.LOG, ' ');
180197: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
180198: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );
180199: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');
180200:
180201: FOR line_record IN line_cur(l_first_event_id, l_last_event_id)
180194: l_last_event_id := l_array_header_events(l_array_header_events.LAST);
180195:
180196: fnd_file.put_line(fnd_file.LOG, ' ');
180197: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
180198: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );
180199: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');
180200:
180201: FOR line_record IN line_cur(l_first_event_id, l_last_event_id)
180202: LOOP
180195:
180196: fnd_file.put_line(fnd_file.LOG, ' ');
180197: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
180198: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );
180199: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');
180200:
180201: FOR line_record IN line_cur(l_first_event_id, l_last_event_id)
180202: LOOP
180203: IF (NOT l_array_header_events.EXISTS(line_record.event_id)) AND (NOT l_array_duplicate_checker.EXISTS(line_record.event_id)) THEN
180200:
180201: FOR line_record IN line_cur(l_first_event_id, l_last_event_id)
180202: LOOP
180203: IF (NOT l_array_header_events.EXISTS(line_record.event_id)) AND (NOT l_array_duplicate_checker.EXISTS(line_record.event_id)) THEN
180204: fnd_file.put_line(fnd_file.log, 'Event_id = ' || line_record.event_id);
180205: l_array_duplicate_checker(line_record.event_id) := line_record.event_id;
180206: END IF;
180207: END LOOP;
180208:
180205: l_array_duplicate_checker(line_record.event_id) := line_record.event_id;
180206: END IF;
180207: END LOOP;
180208:
180209: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
180210: fnd_file.put_line(fnd_file.LOG, ' ');
180211:
180212:
180213: xla_exceptions_pkg.raise_message
180206: END IF;
180207: END LOOP;
180208:
180209: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
180210: fnd_file.put_line(fnd_file.LOG, ' ');
180211:
180212:
180213: xla_exceptions_pkg.raise_message
180214: (p_location => 'XLA_00707_AAD_S_000005_PKG.EventClass_286');
181486:
181487: l_first_event_id := l_array_header_events(l_array_header_events.FIRST);
181488: l_last_event_id := l_array_header_events(l_array_header_events.LAST);
181489:
181490: fnd_file.put_line(fnd_file.LOG, ' ');
181491: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
181492: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );
181493: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');
181494:
181487: l_first_event_id := l_array_header_events(l_array_header_events.FIRST);
181488: l_last_event_id := l_array_header_events(l_array_header_events.LAST);
181489:
181490: fnd_file.put_line(fnd_file.LOG, ' ');
181491: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
181492: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );
181493: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');
181494:
181495: FOR line_record IN line_cur(l_first_event_id, l_last_event_id)
181488: l_last_event_id := l_array_header_events(l_array_header_events.LAST);
181489:
181490: fnd_file.put_line(fnd_file.LOG, ' ');
181491: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
181492: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );
181493: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');
181494:
181495: FOR line_record IN line_cur(l_first_event_id, l_last_event_id)
181496: LOOP
181489:
181490: fnd_file.put_line(fnd_file.LOG, ' ');
181491: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
181492: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );
181493: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');
181494:
181495: FOR line_record IN line_cur(l_first_event_id, l_last_event_id)
181496: LOOP
181497: IF (NOT l_array_header_events.EXISTS(line_record.event_id)) AND (NOT l_array_duplicate_checker.EXISTS(line_record.event_id)) THEN
181494:
181495: FOR line_record IN line_cur(l_first_event_id, l_last_event_id)
181496: LOOP
181497: IF (NOT l_array_header_events.EXISTS(line_record.event_id)) AND (NOT l_array_duplicate_checker.EXISTS(line_record.event_id)) THEN
181498: fnd_file.put_line(fnd_file.log, 'Event_id = ' || line_record.event_id);
181499: l_array_duplicate_checker(line_record.event_id) := line_record.event_id;
181500: END IF;
181501: END LOOP;
181502:
181499: l_array_duplicate_checker(line_record.event_id) := line_record.event_id;
181500: END IF;
181501: END LOOP;
181502:
181503: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
181504: fnd_file.put_line(fnd_file.LOG, ' ');
181505:
181506:
181507: xla_exceptions_pkg.raise_message
181500: END IF;
181501: END LOOP;
181502:
181503: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
181504: fnd_file.put_line(fnd_file.LOG, ' ');
181505:
181506:
181507: xla_exceptions_pkg.raise_message
181508: (p_location => 'XLA_00707_AAD_S_000005_PKG.EventType_287');
182722:
182723: l_first_event_id := l_array_header_events(l_array_header_events.FIRST);
182724: l_last_event_id := l_array_header_events(l_array_header_events.LAST);
182725:
182726: fnd_file.put_line(fnd_file.LOG, ' ');
182727: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
182728: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );
182729: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');
182730:
182723: l_first_event_id := l_array_header_events(l_array_header_events.FIRST);
182724: l_last_event_id := l_array_header_events(l_array_header_events.LAST);
182725:
182726: fnd_file.put_line(fnd_file.LOG, ' ');
182727: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
182728: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );
182729: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');
182730:
182731: FOR line_record IN line_cur(l_first_event_id, l_last_event_id)
182724: l_last_event_id := l_array_header_events(l_array_header_events.LAST);
182725:
182726: fnd_file.put_line(fnd_file.LOG, ' ');
182727: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
182728: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );
182729: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');
182730:
182731: FOR line_record IN line_cur(l_first_event_id, l_last_event_id)
182732: LOOP
182725:
182726: fnd_file.put_line(fnd_file.LOG, ' ');
182727: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
182728: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );
182729: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');
182730:
182731: FOR line_record IN line_cur(l_first_event_id, l_last_event_id)
182732: LOOP
182733: IF (NOT l_array_header_events.EXISTS(line_record.event_id)) AND (NOT l_array_duplicate_checker.EXISTS(line_record.event_id)) THEN
182730:
182731: FOR line_record IN line_cur(l_first_event_id, l_last_event_id)
182732: LOOP
182733: IF (NOT l_array_header_events.EXISTS(line_record.event_id)) AND (NOT l_array_duplicate_checker.EXISTS(line_record.event_id)) THEN
182734: fnd_file.put_line(fnd_file.log, 'Event_id = ' || line_record.event_id);
182735: l_array_duplicate_checker(line_record.event_id) := line_record.event_id;
182736: END IF;
182737: END LOOP;
182738:
182735: l_array_duplicate_checker(line_record.event_id) := line_record.event_id;
182736: END IF;
182737: END LOOP;
182738:
182739: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
182740: fnd_file.put_line(fnd_file.LOG, ' ');
182741:
182742:
182743: xla_exceptions_pkg.raise_message
182736: END IF;
182737: END LOOP;
182738:
182739: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
182740: fnd_file.put_line(fnd_file.LOG, ' ');
182741:
182742:
182743: xla_exceptions_pkg.raise_message
182744: (p_location => 'XLA_00707_AAD_S_000005_PKG.EventType_288');
184132:
184133: l_first_event_id := l_array_header_events(l_array_header_events.FIRST);
184134: l_last_event_id := l_array_header_events(l_array_header_events.LAST);
184135:
184136: fnd_file.put_line(fnd_file.LOG, ' ');
184137: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
184138: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );
184139: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');
184140:
184133: l_first_event_id := l_array_header_events(l_array_header_events.FIRST);
184134: l_last_event_id := l_array_header_events(l_array_header_events.LAST);
184135:
184136: fnd_file.put_line(fnd_file.LOG, ' ');
184137: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
184138: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );
184139: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');
184140:
184141: FOR line_record IN line_cur(l_first_event_id, l_last_event_id)
184134: l_last_event_id := l_array_header_events(l_array_header_events.LAST);
184135:
184136: fnd_file.put_line(fnd_file.LOG, ' ');
184137: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
184138: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );
184139: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');
184140:
184141: FOR line_record IN line_cur(l_first_event_id, l_last_event_id)
184142: LOOP
184135:
184136: fnd_file.put_line(fnd_file.LOG, ' ');
184137: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
184138: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );
184139: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');
184140:
184141: FOR line_record IN line_cur(l_first_event_id, l_last_event_id)
184142: LOOP
184143: IF (NOT l_array_header_events.EXISTS(line_record.event_id)) AND (NOT l_array_duplicate_checker.EXISTS(line_record.event_id)) THEN
184140:
184141: FOR line_record IN line_cur(l_first_event_id, l_last_event_id)
184142: LOOP
184143: IF (NOT l_array_header_events.EXISTS(line_record.event_id)) AND (NOT l_array_duplicate_checker.EXISTS(line_record.event_id)) THEN
184144: fnd_file.put_line(fnd_file.log, 'Event_id = ' || line_record.event_id);
184145: l_array_duplicate_checker(line_record.event_id) := line_record.event_id;
184146: END IF;
184147: END LOOP;
184148:
184145: l_array_duplicate_checker(line_record.event_id) := line_record.event_id;
184146: END IF;
184147: END LOOP;
184148:
184149: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
184150: fnd_file.put_line(fnd_file.LOG, ' ');
184151:
184152:
184153: xla_exceptions_pkg.raise_message
184146: END IF;
184147: END LOOP;
184148:
184149: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
184150: fnd_file.put_line(fnd_file.LOG, ' ');
184151:
184152:
184153: xla_exceptions_pkg.raise_message
184154: (p_location => 'XLA_00707_AAD_S_000005_PKG.EventType_289');
185542:
185543: l_first_event_id := l_array_header_events(l_array_header_events.FIRST);
185544: l_last_event_id := l_array_header_events(l_array_header_events.LAST);
185545:
185546: fnd_file.put_line(fnd_file.LOG, ' ');
185547: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
185548: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );
185549: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');
185550:
185543: l_first_event_id := l_array_header_events(l_array_header_events.FIRST);
185544: l_last_event_id := l_array_header_events(l_array_header_events.LAST);
185545:
185546: fnd_file.put_line(fnd_file.LOG, ' ');
185547: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
185548: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );
185549: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');
185550:
185551: FOR line_record IN line_cur(l_first_event_id, l_last_event_id)
185544: l_last_event_id := l_array_header_events(l_array_header_events.LAST);
185545:
185546: fnd_file.put_line(fnd_file.LOG, ' ');
185547: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
185548: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );
185549: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');
185550:
185551: FOR line_record IN line_cur(l_first_event_id, l_last_event_id)
185552: LOOP
185545:
185546: fnd_file.put_line(fnd_file.LOG, ' ');
185547: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
185548: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );
185549: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');
185550:
185551: FOR line_record IN line_cur(l_first_event_id, l_last_event_id)
185552: LOOP
185553: IF (NOT l_array_header_events.EXISTS(line_record.event_id)) AND (NOT l_array_duplicate_checker.EXISTS(line_record.event_id)) THEN
185550:
185551: FOR line_record IN line_cur(l_first_event_id, l_last_event_id)
185552: LOOP
185553: IF (NOT l_array_header_events.EXISTS(line_record.event_id)) AND (NOT l_array_duplicate_checker.EXISTS(line_record.event_id)) THEN
185554: fnd_file.put_line(fnd_file.log, 'Event_id = ' || line_record.event_id);
185555: l_array_duplicate_checker(line_record.event_id) := line_record.event_id;
185556: END IF;
185557: END LOOP;
185558:
185555: l_array_duplicate_checker(line_record.event_id) := line_record.event_id;
185556: END IF;
185557: END LOOP;
185558:
185559: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
185560: fnd_file.put_line(fnd_file.LOG, ' ');
185561:
185562:
185563: xla_exceptions_pkg.raise_message
185556: END IF;
185557: END LOOP;
185558:
185559: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
185560: fnd_file.put_line(fnd_file.LOG, ' ');
185561:
185562:
185563: xla_exceptions_pkg.raise_message
185564: (p_location => 'XLA_00707_AAD_S_000005_PKG.EventType_290');
186952:
186953: l_first_event_id := l_array_header_events(l_array_header_events.FIRST);
186954: l_last_event_id := l_array_header_events(l_array_header_events.LAST);
186955:
186956: fnd_file.put_line(fnd_file.LOG, ' ');
186957: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
186958: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );
186959: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');
186960:
186953: l_first_event_id := l_array_header_events(l_array_header_events.FIRST);
186954: l_last_event_id := l_array_header_events(l_array_header_events.LAST);
186955:
186956: fnd_file.put_line(fnd_file.LOG, ' ');
186957: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
186958: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );
186959: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');
186960:
186961: FOR line_record IN line_cur(l_first_event_id, l_last_event_id)
186954: l_last_event_id := l_array_header_events(l_array_header_events.LAST);
186955:
186956: fnd_file.put_line(fnd_file.LOG, ' ');
186957: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
186958: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );
186959: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');
186960:
186961: FOR line_record IN line_cur(l_first_event_id, l_last_event_id)
186962: LOOP
186955:
186956: fnd_file.put_line(fnd_file.LOG, ' ');
186957: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
186958: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );
186959: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');
186960:
186961: FOR line_record IN line_cur(l_first_event_id, l_last_event_id)
186962: LOOP
186963: IF (NOT l_array_header_events.EXISTS(line_record.event_id)) AND (NOT l_array_duplicate_checker.EXISTS(line_record.event_id)) THEN
186960:
186961: FOR line_record IN line_cur(l_first_event_id, l_last_event_id)
186962: LOOP
186963: IF (NOT l_array_header_events.EXISTS(line_record.event_id)) AND (NOT l_array_duplicate_checker.EXISTS(line_record.event_id)) THEN
186964: fnd_file.put_line(fnd_file.log, 'Event_id = ' || line_record.event_id);
186965: l_array_duplicate_checker(line_record.event_id) := line_record.event_id;
186966: END IF;
186967: END LOOP;
186968:
186965: l_array_duplicate_checker(line_record.event_id) := line_record.event_id;
186966: END IF;
186967: END LOOP;
186968:
186969: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
186970: fnd_file.put_line(fnd_file.LOG, ' ');
186971:
186972:
186973: xla_exceptions_pkg.raise_message
186966: END IF;
186967: END LOOP;
186968:
186969: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
186970: fnd_file.put_line(fnd_file.LOG, ' ');
186971:
186972:
186973: xla_exceptions_pkg.raise_message
186974: (p_location => 'XLA_00707_AAD_S_000005_PKG.EventType_291');
188362:
188363: l_first_event_id := l_array_header_events(l_array_header_events.FIRST);
188364: l_last_event_id := l_array_header_events(l_array_header_events.LAST);
188365:
188366: fnd_file.put_line(fnd_file.LOG, ' ');
188367: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
188368: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );
188369: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');
188370:
188363: l_first_event_id := l_array_header_events(l_array_header_events.FIRST);
188364: l_last_event_id := l_array_header_events(l_array_header_events.LAST);
188365:
188366: fnd_file.put_line(fnd_file.LOG, ' ');
188367: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
188368: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );
188369: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');
188370:
188371: FOR line_record IN line_cur(l_first_event_id, l_last_event_id)
188364: l_last_event_id := l_array_header_events(l_array_header_events.LAST);
188365:
188366: fnd_file.put_line(fnd_file.LOG, ' ');
188367: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
188368: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );
188369: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');
188370:
188371: FOR line_record IN line_cur(l_first_event_id, l_last_event_id)
188372: LOOP
188365:
188366: fnd_file.put_line(fnd_file.LOG, ' ');
188367: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
188368: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );
188369: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');
188370:
188371: FOR line_record IN line_cur(l_first_event_id, l_last_event_id)
188372: LOOP
188373: IF (NOT l_array_header_events.EXISTS(line_record.event_id)) AND (NOT l_array_duplicate_checker.EXISTS(line_record.event_id)) THEN
188370:
188371: FOR line_record IN line_cur(l_first_event_id, l_last_event_id)
188372: LOOP
188373: IF (NOT l_array_header_events.EXISTS(line_record.event_id)) AND (NOT l_array_duplicate_checker.EXISTS(line_record.event_id)) THEN
188374: fnd_file.put_line(fnd_file.log, 'Event_id = ' || line_record.event_id);
188375: l_array_duplicate_checker(line_record.event_id) := line_record.event_id;
188376: END IF;
188377: END LOOP;
188378:
188375: l_array_duplicate_checker(line_record.event_id) := line_record.event_id;
188376: END IF;
188377: END LOOP;
188378:
188379: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
188380: fnd_file.put_line(fnd_file.LOG, ' ');
188381:
188382:
188383: xla_exceptions_pkg.raise_message
188376: END IF;
188377: END LOOP;
188378:
188379: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
188380: fnd_file.put_line(fnd_file.LOG, ' ');
188381:
188382:
188383: xla_exceptions_pkg.raise_message
188384: (p_location => 'XLA_00707_AAD_S_000005_PKG.EventType_292');
189772:
189773: l_first_event_id := l_array_header_events(l_array_header_events.FIRST);
189774: l_last_event_id := l_array_header_events(l_array_header_events.LAST);
189775:
189776: fnd_file.put_line(fnd_file.LOG, ' ');
189777: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
189778: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );
189779: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');
189780:
189773: l_first_event_id := l_array_header_events(l_array_header_events.FIRST);
189774: l_last_event_id := l_array_header_events(l_array_header_events.LAST);
189775:
189776: fnd_file.put_line(fnd_file.LOG, ' ');
189777: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
189778: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );
189779: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');
189780:
189781: FOR line_record IN line_cur(l_first_event_id, l_last_event_id)
189774: l_last_event_id := l_array_header_events(l_array_header_events.LAST);
189775:
189776: fnd_file.put_line(fnd_file.LOG, ' ');
189777: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
189778: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );
189779: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');
189780:
189781: FOR line_record IN line_cur(l_first_event_id, l_last_event_id)
189782: LOOP
189775:
189776: fnd_file.put_line(fnd_file.LOG, ' ');
189777: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
189778: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );
189779: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');
189780:
189781: FOR line_record IN line_cur(l_first_event_id, l_last_event_id)
189782: LOOP
189783: IF (NOT l_array_header_events.EXISTS(line_record.event_id)) AND (NOT l_array_duplicate_checker.EXISTS(line_record.event_id)) THEN
189780:
189781: FOR line_record IN line_cur(l_first_event_id, l_last_event_id)
189782: LOOP
189783: IF (NOT l_array_header_events.EXISTS(line_record.event_id)) AND (NOT l_array_duplicate_checker.EXISTS(line_record.event_id)) THEN
189784: fnd_file.put_line(fnd_file.log, 'Event_id = ' || line_record.event_id);
189785: l_array_duplicate_checker(line_record.event_id) := line_record.event_id;
189786: END IF;
189787: END LOOP;
189788:
189785: l_array_duplicate_checker(line_record.event_id) := line_record.event_id;
189786: END IF;
189787: END LOOP;
189788:
189789: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
189790: fnd_file.put_line(fnd_file.LOG, ' ');
189791:
189792:
189793: xla_exceptions_pkg.raise_message
189786: END IF;
189787: END LOOP;
189788:
189789: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
189790: fnd_file.put_line(fnd_file.LOG, ' ');
189791:
189792:
189793: xla_exceptions_pkg.raise_message
189794: (p_location => 'XLA_00707_AAD_S_000005_PKG.EventType_293');
191182:
191183: l_first_event_id := l_array_header_events(l_array_header_events.FIRST);
191184: l_last_event_id := l_array_header_events(l_array_header_events.LAST);
191185:
191186: fnd_file.put_line(fnd_file.LOG, ' ');
191187: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
191188: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );
191189: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');
191190:
191183: l_first_event_id := l_array_header_events(l_array_header_events.FIRST);
191184: l_last_event_id := l_array_header_events(l_array_header_events.LAST);
191185:
191186: fnd_file.put_line(fnd_file.LOG, ' ');
191187: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
191188: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );
191189: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');
191190:
191191: FOR line_record IN line_cur(l_first_event_id, l_last_event_id)
191184: l_last_event_id := l_array_header_events(l_array_header_events.LAST);
191185:
191186: fnd_file.put_line(fnd_file.LOG, ' ');
191187: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
191188: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );
191189: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');
191190:
191191: FOR line_record IN line_cur(l_first_event_id, l_last_event_id)
191192: LOOP
191185:
191186: fnd_file.put_line(fnd_file.LOG, ' ');
191187: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
191188: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );
191189: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');
191190:
191191: FOR line_record IN line_cur(l_first_event_id, l_last_event_id)
191192: LOOP
191193: IF (NOT l_array_header_events.EXISTS(line_record.event_id)) AND (NOT l_array_duplicate_checker.EXISTS(line_record.event_id)) THEN
191190:
191191: FOR line_record IN line_cur(l_first_event_id, l_last_event_id)
191192: LOOP
191193: IF (NOT l_array_header_events.EXISTS(line_record.event_id)) AND (NOT l_array_duplicate_checker.EXISTS(line_record.event_id)) THEN
191194: fnd_file.put_line(fnd_file.log, 'Event_id = ' || line_record.event_id);
191195: l_array_duplicate_checker(line_record.event_id) := line_record.event_id;
191196: END IF;
191197: END LOOP;
191198:
191195: l_array_duplicate_checker(line_record.event_id) := line_record.event_id;
191196: END IF;
191197: END LOOP;
191198:
191199: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
191200: fnd_file.put_line(fnd_file.LOG, ' ');
191201:
191202:
191203: xla_exceptions_pkg.raise_message
191196: END IF;
191197: END LOOP;
191198:
191199: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
191200: fnd_file.put_line(fnd_file.LOG, ' ');
191201:
191202:
191203: xla_exceptions_pkg.raise_message
191204: (p_location => 'XLA_00707_AAD_S_000005_PKG.EventType_294');
192418:
192419: l_first_event_id := l_array_header_events(l_array_header_events.FIRST);
192420: l_last_event_id := l_array_header_events(l_array_header_events.LAST);
192421:
192422: fnd_file.put_line(fnd_file.LOG, ' ');
192423: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
192424: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );
192425: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');
192426:
192419: l_first_event_id := l_array_header_events(l_array_header_events.FIRST);
192420: l_last_event_id := l_array_header_events(l_array_header_events.LAST);
192421:
192422: fnd_file.put_line(fnd_file.LOG, ' ');
192423: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
192424: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );
192425: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');
192426:
192427: FOR line_record IN line_cur(l_first_event_id, l_last_event_id)
192420: l_last_event_id := l_array_header_events(l_array_header_events.LAST);
192421:
192422: fnd_file.put_line(fnd_file.LOG, ' ');
192423: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
192424: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );
192425: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');
192426:
192427: FOR line_record IN line_cur(l_first_event_id, l_last_event_id)
192428: LOOP
192421:
192422: fnd_file.put_line(fnd_file.LOG, ' ');
192423: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
192424: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );
192425: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');
192426:
192427: FOR line_record IN line_cur(l_first_event_id, l_last_event_id)
192428: LOOP
192429: IF (NOT l_array_header_events.EXISTS(line_record.event_id)) AND (NOT l_array_duplicate_checker.EXISTS(line_record.event_id)) THEN
192426:
192427: FOR line_record IN line_cur(l_first_event_id, l_last_event_id)
192428: LOOP
192429: IF (NOT l_array_header_events.EXISTS(line_record.event_id)) AND (NOT l_array_duplicate_checker.EXISTS(line_record.event_id)) THEN
192430: fnd_file.put_line(fnd_file.log, 'Event_id = ' || line_record.event_id);
192431: l_array_duplicate_checker(line_record.event_id) := line_record.event_id;
192432: END IF;
192433: END LOOP;
192434:
192431: l_array_duplicate_checker(line_record.event_id) := line_record.event_id;
192432: END IF;
192433: END LOOP;
192434:
192435: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
192436: fnd_file.put_line(fnd_file.LOG, ' ');
192437:
192438:
192439: xla_exceptions_pkg.raise_message
192432: END IF;
192433: END LOOP;
192434:
192435: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
192436: fnd_file.put_line(fnd_file.LOG, ' ');
192437:
192438:
192439: xla_exceptions_pkg.raise_message
192440: (p_location => 'XLA_00707_AAD_S_000005_PKG.EventType_295');
193828:
193829: l_first_event_id := l_array_header_events(l_array_header_events.FIRST);
193830: l_last_event_id := l_array_header_events(l_array_header_events.LAST);
193831:
193832: fnd_file.put_line(fnd_file.LOG, ' ');
193833: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
193834: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );
193835: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');
193836:
193829: l_first_event_id := l_array_header_events(l_array_header_events.FIRST);
193830: l_last_event_id := l_array_header_events(l_array_header_events.LAST);
193831:
193832: fnd_file.put_line(fnd_file.LOG, ' ');
193833: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
193834: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );
193835: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');
193836:
193837: FOR line_record IN line_cur(l_first_event_id, l_last_event_id)
193830: l_last_event_id := l_array_header_events(l_array_header_events.LAST);
193831:
193832: fnd_file.put_line(fnd_file.LOG, ' ');
193833: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
193834: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );
193835: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');
193836:
193837: FOR line_record IN line_cur(l_first_event_id, l_last_event_id)
193838: LOOP
193831:
193832: fnd_file.put_line(fnd_file.LOG, ' ');
193833: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
193834: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );
193835: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');
193836:
193837: FOR line_record IN line_cur(l_first_event_id, l_last_event_id)
193838: LOOP
193839: IF (NOT l_array_header_events.EXISTS(line_record.event_id)) AND (NOT l_array_duplicate_checker.EXISTS(line_record.event_id)) THEN
193836:
193837: FOR line_record IN line_cur(l_first_event_id, l_last_event_id)
193838: LOOP
193839: IF (NOT l_array_header_events.EXISTS(line_record.event_id)) AND (NOT l_array_duplicate_checker.EXISTS(line_record.event_id)) THEN
193840: fnd_file.put_line(fnd_file.log, 'Event_id = ' || line_record.event_id);
193841: l_array_duplicate_checker(line_record.event_id) := line_record.event_id;
193842: END IF;
193843: END LOOP;
193844:
193841: l_array_duplicate_checker(line_record.event_id) := line_record.event_id;
193842: END IF;
193843: END LOOP;
193844:
193845: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
193846: fnd_file.put_line(fnd_file.LOG, ' ');
193847:
193848:
193849: xla_exceptions_pkg.raise_message
193842: END IF;
193843: END LOOP;
193844:
193845: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
193846: fnd_file.put_line(fnd_file.LOG, ' ');
193847:
193848:
193849: xla_exceptions_pkg.raise_message
193850: (p_location => 'XLA_00707_AAD_S_000005_PKG.EventType_296');
195238:
195239: l_first_event_id := l_array_header_events(l_array_header_events.FIRST);
195240: l_last_event_id := l_array_header_events(l_array_header_events.LAST);
195241:
195242: fnd_file.put_line(fnd_file.LOG, ' ');
195243: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
195244: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );
195245: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');
195246:
195239: l_first_event_id := l_array_header_events(l_array_header_events.FIRST);
195240: l_last_event_id := l_array_header_events(l_array_header_events.LAST);
195241:
195242: fnd_file.put_line(fnd_file.LOG, ' ');
195243: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
195244: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );
195245: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');
195246:
195247: FOR line_record IN line_cur(l_first_event_id, l_last_event_id)
195240: l_last_event_id := l_array_header_events(l_array_header_events.LAST);
195241:
195242: fnd_file.put_line(fnd_file.LOG, ' ');
195243: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
195244: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );
195245: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');
195246:
195247: FOR line_record IN line_cur(l_first_event_id, l_last_event_id)
195248: LOOP
195241:
195242: fnd_file.put_line(fnd_file.LOG, ' ');
195243: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
195244: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );
195245: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');
195246:
195247: FOR line_record IN line_cur(l_first_event_id, l_last_event_id)
195248: LOOP
195249: IF (NOT l_array_header_events.EXISTS(line_record.event_id)) AND (NOT l_array_duplicate_checker.EXISTS(line_record.event_id)) THEN
195246:
195247: FOR line_record IN line_cur(l_first_event_id, l_last_event_id)
195248: LOOP
195249: IF (NOT l_array_header_events.EXISTS(line_record.event_id)) AND (NOT l_array_duplicate_checker.EXISTS(line_record.event_id)) THEN
195250: fnd_file.put_line(fnd_file.log, 'Event_id = ' || line_record.event_id);
195251: l_array_duplicate_checker(line_record.event_id) := line_record.event_id;
195252: END IF;
195253: END LOOP;
195254:
195251: l_array_duplicate_checker(line_record.event_id) := line_record.event_id;
195252: END IF;
195253: END LOOP;
195254:
195255: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
195256: fnd_file.put_line(fnd_file.LOG, ' ');
195257:
195258:
195259: xla_exceptions_pkg.raise_message
195252: END IF;
195253: END LOOP;
195254:
195255: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
195256: fnd_file.put_line(fnd_file.LOG, ' ');
195257:
195258:
195259: xla_exceptions_pkg.raise_message
195260: (p_location => 'XLA_00707_AAD_S_000005_PKG.EventType_297');
196561:
196562: l_first_event_id := l_array_header_events(l_array_header_events.FIRST);
196563: l_last_event_id := l_array_header_events(l_array_header_events.LAST);
196564:
196565: fnd_file.put_line(fnd_file.LOG, ' ');
196566: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
196567: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );
196568: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');
196569:
196562: l_first_event_id := l_array_header_events(l_array_header_events.FIRST);
196563: l_last_event_id := l_array_header_events(l_array_header_events.LAST);
196564:
196565: fnd_file.put_line(fnd_file.LOG, ' ');
196566: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
196567: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );
196568: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');
196569:
196570: FOR line_record IN line_cur(l_first_event_id, l_last_event_id)
196563: l_last_event_id := l_array_header_events(l_array_header_events.LAST);
196564:
196565: fnd_file.put_line(fnd_file.LOG, ' ');
196566: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
196567: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );
196568: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');
196569:
196570: FOR line_record IN line_cur(l_first_event_id, l_last_event_id)
196571: LOOP
196564:
196565: fnd_file.put_line(fnd_file.LOG, ' ');
196566: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
196567: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );
196568: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');
196569:
196570: FOR line_record IN line_cur(l_first_event_id, l_last_event_id)
196571: LOOP
196572: IF (NOT l_array_header_events.EXISTS(line_record.event_id)) AND (NOT l_array_duplicate_checker.EXISTS(line_record.event_id)) THEN
196569:
196570: FOR line_record IN line_cur(l_first_event_id, l_last_event_id)
196571: LOOP
196572: IF (NOT l_array_header_events.EXISTS(line_record.event_id)) AND (NOT l_array_duplicate_checker.EXISTS(line_record.event_id)) THEN
196573: fnd_file.put_line(fnd_file.log, 'Event_id = ' || line_record.event_id);
196574: l_array_duplicate_checker(line_record.event_id) := line_record.event_id;
196575: END IF;
196576: END LOOP;
196577:
196574: l_array_duplicate_checker(line_record.event_id) := line_record.event_id;
196575: END IF;
196576: END LOOP;
196577:
196578: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
196579: fnd_file.put_line(fnd_file.LOG, ' ');
196580:
196581:
196582: xla_exceptions_pkg.raise_message
196575: END IF;
196576: END LOOP;
196577:
196578: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
196579: fnd_file.put_line(fnd_file.LOG, ' ');
196580:
196581:
196582: xla_exceptions_pkg.raise_message
196583: (p_location => 'XLA_00707_AAD_S_000005_PKG.EventType_298');
197884:
197885: l_first_event_id := l_array_header_events(l_array_header_events.FIRST);
197886: l_last_event_id := l_array_header_events(l_array_header_events.LAST);
197887:
197888: fnd_file.put_line(fnd_file.LOG, ' ');
197889: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
197890: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );
197891: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');
197892:
197885: l_first_event_id := l_array_header_events(l_array_header_events.FIRST);
197886: l_last_event_id := l_array_header_events(l_array_header_events.LAST);
197887:
197888: fnd_file.put_line(fnd_file.LOG, ' ');
197889: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
197890: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );
197891: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');
197892:
197893: FOR line_record IN line_cur(l_first_event_id, l_last_event_id)
197886: l_last_event_id := l_array_header_events(l_array_header_events.LAST);
197887:
197888: fnd_file.put_line(fnd_file.LOG, ' ');
197889: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
197890: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );
197891: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');
197892:
197893: FOR line_record IN line_cur(l_first_event_id, l_last_event_id)
197894: LOOP
197887:
197888: fnd_file.put_line(fnd_file.LOG, ' ');
197889: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
197890: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );
197891: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');
197892:
197893: FOR line_record IN line_cur(l_first_event_id, l_last_event_id)
197894: LOOP
197895: IF (NOT l_array_header_events.EXISTS(line_record.event_id)) AND (NOT l_array_duplicate_checker.EXISTS(line_record.event_id)) THEN
197892:
197893: FOR line_record IN line_cur(l_first_event_id, l_last_event_id)
197894: LOOP
197895: IF (NOT l_array_header_events.EXISTS(line_record.event_id)) AND (NOT l_array_duplicate_checker.EXISTS(line_record.event_id)) THEN
197896: fnd_file.put_line(fnd_file.log, 'Event_id = ' || line_record.event_id);
197897: l_array_duplicate_checker(line_record.event_id) := line_record.event_id;
197898: END IF;
197899: END LOOP;
197900:
197897: l_array_duplicate_checker(line_record.event_id) := line_record.event_id;
197898: END IF;
197899: END LOOP;
197900:
197901: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
197902: fnd_file.put_line(fnd_file.LOG, ' ');
197903:
197904:
197905: xla_exceptions_pkg.raise_message
197898: END IF;
197899: END LOOP;
197900:
197901: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
197902: fnd_file.put_line(fnd_file.LOG, ' ');
197903:
197904:
197905: xla_exceptions_pkg.raise_message
197906: (p_location => 'XLA_00707_AAD_S_000005_PKG.EventType_299');
199149:
199150: l_first_event_id := l_array_header_events(l_array_header_events.FIRST);
199151: l_last_event_id := l_array_header_events(l_array_header_events.LAST);
199152:
199153: fnd_file.put_line(fnd_file.LOG, ' ');
199154: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
199155: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );
199156: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');
199157:
199150: l_first_event_id := l_array_header_events(l_array_header_events.FIRST);
199151: l_last_event_id := l_array_header_events(l_array_header_events.LAST);
199152:
199153: fnd_file.put_line(fnd_file.LOG, ' ');
199154: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
199155: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );
199156: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');
199157:
199158: FOR line_record IN line_cur(l_first_event_id, l_last_event_id)
199151: l_last_event_id := l_array_header_events(l_array_header_events.LAST);
199152:
199153: fnd_file.put_line(fnd_file.LOG, ' ');
199154: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
199155: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );
199156: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');
199157:
199158: FOR line_record IN line_cur(l_first_event_id, l_last_event_id)
199159: LOOP
199152:
199153: fnd_file.put_line(fnd_file.LOG, ' ');
199154: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
199155: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );
199156: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');
199157:
199158: FOR line_record IN line_cur(l_first_event_id, l_last_event_id)
199159: LOOP
199160: IF (NOT l_array_header_events.EXISTS(line_record.event_id)) AND (NOT l_array_duplicate_checker.EXISTS(line_record.event_id)) THEN
199157:
199158: FOR line_record IN line_cur(l_first_event_id, l_last_event_id)
199159: LOOP
199160: IF (NOT l_array_header_events.EXISTS(line_record.event_id)) AND (NOT l_array_duplicate_checker.EXISTS(line_record.event_id)) THEN
199161: fnd_file.put_line(fnd_file.log, 'Event_id = ' || line_record.event_id);
199162: l_array_duplicate_checker(line_record.event_id) := line_record.event_id;
199163: END IF;
199164: END LOOP;
199165:
199162: l_array_duplicate_checker(line_record.event_id) := line_record.event_id;
199163: END IF;
199164: END LOOP;
199165:
199166: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
199167: fnd_file.put_line(fnd_file.LOG, ' ');
199168:
199169:
199170: xla_exceptions_pkg.raise_message
199163: END IF;
199164: END LOOP;
199165:
199166: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
199167: fnd_file.put_line(fnd_file.LOG, ' ');
199168:
199169:
199170: xla_exceptions_pkg.raise_message
199171: (p_location => 'XLA_00707_AAD_S_000005_PKG.EventType_300');
200385:
200386: l_first_event_id := l_array_header_events(l_array_header_events.FIRST);
200387: l_last_event_id := l_array_header_events(l_array_header_events.LAST);
200388:
200389: fnd_file.put_line(fnd_file.LOG, ' ');
200390: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
200391: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );
200392: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');
200393:
200386: l_first_event_id := l_array_header_events(l_array_header_events.FIRST);
200387: l_last_event_id := l_array_header_events(l_array_header_events.LAST);
200388:
200389: fnd_file.put_line(fnd_file.LOG, ' ');
200390: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
200391: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );
200392: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');
200393:
200394: FOR line_record IN line_cur(l_first_event_id, l_last_event_id)
200387: l_last_event_id := l_array_header_events(l_array_header_events.LAST);
200388:
200389: fnd_file.put_line(fnd_file.LOG, ' ');
200390: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
200391: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );
200392: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');
200393:
200394: FOR line_record IN line_cur(l_first_event_id, l_last_event_id)
200395: LOOP
200388:
200389: fnd_file.put_line(fnd_file.LOG, ' ');
200390: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
200391: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );
200392: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');
200393:
200394: FOR line_record IN line_cur(l_first_event_id, l_last_event_id)
200395: LOOP
200396: IF (NOT l_array_header_events.EXISTS(line_record.event_id)) AND (NOT l_array_duplicate_checker.EXISTS(line_record.event_id)) THEN
200393:
200394: FOR line_record IN line_cur(l_first_event_id, l_last_event_id)
200395: LOOP
200396: IF (NOT l_array_header_events.EXISTS(line_record.event_id)) AND (NOT l_array_duplicate_checker.EXISTS(line_record.event_id)) THEN
200397: fnd_file.put_line(fnd_file.log, 'Event_id = ' || line_record.event_id);
200398: l_array_duplicate_checker(line_record.event_id) := line_record.event_id;
200399: END IF;
200400: END LOOP;
200401:
200398: l_array_duplicate_checker(line_record.event_id) := line_record.event_id;
200399: END IF;
200400: END LOOP;
200401:
200402: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
200403: fnd_file.put_line(fnd_file.LOG, ' ');
200404:
200405:
200406: xla_exceptions_pkg.raise_message
200399: END IF;
200400: END LOOP;
200401:
200402: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
200403: fnd_file.put_line(fnd_file.LOG, ' ');
200404:
200405:
200406: xla_exceptions_pkg.raise_message
200407: (p_location => 'XLA_00707_AAD_S_000005_PKG.EventType_301');
201621:
201622: l_first_event_id := l_array_header_events(l_array_header_events.FIRST);
201623: l_last_event_id := l_array_header_events(l_array_header_events.LAST);
201624:
201625: fnd_file.put_line(fnd_file.LOG, ' ');
201626: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
201627: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );
201628: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');
201629:
201622: l_first_event_id := l_array_header_events(l_array_header_events.FIRST);
201623: l_last_event_id := l_array_header_events(l_array_header_events.LAST);
201624:
201625: fnd_file.put_line(fnd_file.LOG, ' ');
201626: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
201627: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );
201628: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');
201629:
201630: FOR line_record IN line_cur(l_first_event_id, l_last_event_id)
201623: l_last_event_id := l_array_header_events(l_array_header_events.LAST);
201624:
201625: fnd_file.put_line(fnd_file.LOG, ' ');
201626: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
201627: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );
201628: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');
201629:
201630: FOR line_record IN line_cur(l_first_event_id, l_last_event_id)
201631: LOOP
201624:
201625: fnd_file.put_line(fnd_file.LOG, ' ');
201626: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
201627: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );
201628: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');
201629:
201630: FOR line_record IN line_cur(l_first_event_id, l_last_event_id)
201631: LOOP
201632: IF (NOT l_array_header_events.EXISTS(line_record.event_id)) AND (NOT l_array_duplicate_checker.EXISTS(line_record.event_id)) THEN
201629:
201630: FOR line_record IN line_cur(l_first_event_id, l_last_event_id)
201631: LOOP
201632: IF (NOT l_array_header_events.EXISTS(line_record.event_id)) AND (NOT l_array_duplicate_checker.EXISTS(line_record.event_id)) THEN
201633: fnd_file.put_line(fnd_file.log, 'Event_id = ' || line_record.event_id);
201634: l_array_duplicate_checker(line_record.event_id) := line_record.event_id;
201635: END IF;
201636: END LOOP;
201637:
201634: l_array_duplicate_checker(line_record.event_id) := line_record.event_id;
201635: END IF;
201636: END LOOP;
201637:
201638: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
201639: fnd_file.put_line(fnd_file.LOG, ' ');
201640:
201641:
201642: xla_exceptions_pkg.raise_message
201635: END IF;
201636: END LOOP;
201637:
201638: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
201639: fnd_file.put_line(fnd_file.LOG, ' ');
201640:
201641:
201642: xla_exceptions_pkg.raise_message
201643: (p_location => 'XLA_00707_AAD_S_000005_PKG.EventType_302');
202857:
202858: l_first_event_id := l_array_header_events(l_array_header_events.FIRST);
202859: l_last_event_id := l_array_header_events(l_array_header_events.LAST);
202860:
202861: fnd_file.put_line(fnd_file.LOG, ' ');
202862: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
202863: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );
202864: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');
202865:
202858: l_first_event_id := l_array_header_events(l_array_header_events.FIRST);
202859: l_last_event_id := l_array_header_events(l_array_header_events.LAST);
202860:
202861: fnd_file.put_line(fnd_file.LOG, ' ');
202862: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
202863: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );
202864: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');
202865:
202866: FOR line_record IN line_cur(l_first_event_id, l_last_event_id)
202859: l_last_event_id := l_array_header_events(l_array_header_events.LAST);
202860:
202861: fnd_file.put_line(fnd_file.LOG, ' ');
202862: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
202863: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );
202864: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');
202865:
202866: FOR line_record IN line_cur(l_first_event_id, l_last_event_id)
202867: LOOP
202860:
202861: fnd_file.put_line(fnd_file.LOG, ' ');
202862: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
202863: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );
202864: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');
202865:
202866: FOR line_record IN line_cur(l_first_event_id, l_last_event_id)
202867: LOOP
202868: IF (NOT l_array_header_events.EXISTS(line_record.event_id)) AND (NOT l_array_duplicate_checker.EXISTS(line_record.event_id)) THEN
202865:
202866: FOR line_record IN line_cur(l_first_event_id, l_last_event_id)
202867: LOOP
202868: IF (NOT l_array_header_events.EXISTS(line_record.event_id)) AND (NOT l_array_duplicate_checker.EXISTS(line_record.event_id)) THEN
202869: fnd_file.put_line(fnd_file.log, 'Event_id = ' || line_record.event_id);
202870: l_array_duplicate_checker(line_record.event_id) := line_record.event_id;
202871: END IF;
202872: END LOOP;
202873:
202870: l_array_duplicate_checker(line_record.event_id) := line_record.event_id;
202871: END IF;
202872: END LOOP;
202873:
202874: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
202875: fnd_file.put_line(fnd_file.LOG, ' ');
202876:
202877:
202878: xla_exceptions_pkg.raise_message
202871: END IF;
202872: END LOOP;
202873:
202874: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
202875: fnd_file.put_line(fnd_file.LOG, ' ');
202876:
202877:
202878: xla_exceptions_pkg.raise_message
202879: (p_location => 'XLA_00707_AAD_S_000005_PKG.EventType_303');
204068:
204069: l_first_event_id := l_array_header_events(l_array_header_events.FIRST);
204070: l_last_event_id := l_array_header_events(l_array_header_events.LAST);
204071:
204072: fnd_file.put_line(fnd_file.LOG, ' ');
204073: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
204074: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );
204075: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');
204076:
204069: l_first_event_id := l_array_header_events(l_array_header_events.FIRST);
204070: l_last_event_id := l_array_header_events(l_array_header_events.LAST);
204071:
204072: fnd_file.put_line(fnd_file.LOG, ' ');
204073: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
204074: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );
204075: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');
204076:
204077: FOR line_record IN line_cur(l_first_event_id, l_last_event_id)
204070: l_last_event_id := l_array_header_events(l_array_header_events.LAST);
204071:
204072: fnd_file.put_line(fnd_file.LOG, ' ');
204073: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
204074: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );
204075: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');
204076:
204077: FOR line_record IN line_cur(l_first_event_id, l_last_event_id)
204078: LOOP
204071:
204072: fnd_file.put_line(fnd_file.LOG, ' ');
204073: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
204074: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );
204075: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');
204076:
204077: FOR line_record IN line_cur(l_first_event_id, l_last_event_id)
204078: LOOP
204079: IF (NOT l_array_header_events.EXISTS(line_record.event_id)) AND (NOT l_array_duplicate_checker.EXISTS(line_record.event_id)) THEN
204076:
204077: FOR line_record IN line_cur(l_first_event_id, l_last_event_id)
204078: LOOP
204079: IF (NOT l_array_header_events.EXISTS(line_record.event_id)) AND (NOT l_array_duplicate_checker.EXISTS(line_record.event_id)) THEN
204080: fnd_file.put_line(fnd_file.log, 'Event_id = ' || line_record.event_id);
204081: l_array_duplicate_checker(line_record.event_id) := line_record.event_id;
204082: END IF;
204083: END LOOP;
204084:
204081: l_array_duplicate_checker(line_record.event_id) := line_record.event_id;
204082: END IF;
204083: END LOOP;
204084:
204085: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
204086: fnd_file.put_line(fnd_file.LOG, ' ');
204087:
204088:
204089: xla_exceptions_pkg.raise_message
204082: END IF;
204083: END LOOP;
204084:
204085: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
204086: fnd_file.put_line(fnd_file.LOG, ' ');
204087:
204088:
204089: xla_exceptions_pkg.raise_message
204090: (p_location => 'XLA_00707_AAD_S_000005_PKG.EventClass_304');
205279:
205280: l_first_event_id := l_array_header_events(l_array_header_events.FIRST);
205281: l_last_event_id := l_array_header_events(l_array_header_events.LAST);
205282:
205283: fnd_file.put_line(fnd_file.LOG, ' ');
205284: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
205285: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );
205286: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');
205287:
205280: l_first_event_id := l_array_header_events(l_array_header_events.FIRST);
205281: l_last_event_id := l_array_header_events(l_array_header_events.LAST);
205282:
205283: fnd_file.put_line(fnd_file.LOG, ' ');
205284: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
205285: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );
205286: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');
205287:
205288: FOR line_record IN line_cur(l_first_event_id, l_last_event_id)
205281: l_last_event_id := l_array_header_events(l_array_header_events.LAST);
205282:
205283: fnd_file.put_line(fnd_file.LOG, ' ');
205284: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
205285: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );
205286: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');
205287:
205288: FOR line_record IN line_cur(l_first_event_id, l_last_event_id)
205289: LOOP
205282:
205283: fnd_file.put_line(fnd_file.LOG, ' ');
205284: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
205285: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );
205286: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');
205287:
205288: FOR line_record IN line_cur(l_first_event_id, l_last_event_id)
205289: LOOP
205290: IF (NOT l_array_header_events.EXISTS(line_record.event_id)) AND (NOT l_array_duplicate_checker.EXISTS(line_record.event_id)) THEN
205287:
205288: FOR line_record IN line_cur(l_first_event_id, l_last_event_id)
205289: LOOP
205290: IF (NOT l_array_header_events.EXISTS(line_record.event_id)) AND (NOT l_array_duplicate_checker.EXISTS(line_record.event_id)) THEN
205291: fnd_file.put_line(fnd_file.log, 'Event_id = ' || line_record.event_id);
205292: l_array_duplicate_checker(line_record.event_id) := line_record.event_id;
205293: END IF;
205294: END LOOP;
205295:
205292: l_array_duplicate_checker(line_record.event_id) := line_record.event_id;
205293: END IF;
205294: END LOOP;
205295:
205296: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
205297: fnd_file.put_line(fnd_file.LOG, ' ');
205298:
205299:
205300: xla_exceptions_pkg.raise_message
205293: END IF;
205294: END LOOP;
205295:
205296: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
205297: fnd_file.put_line(fnd_file.LOG, ' ');
205298:
205299:
205300: xla_exceptions_pkg.raise_message
205301: (p_location => 'XLA_00707_AAD_S_000005_PKG.EventClass_305');
206490:
206491: l_first_event_id := l_array_header_events(l_array_header_events.FIRST);
206492: l_last_event_id := l_array_header_events(l_array_header_events.LAST);
206493:
206494: fnd_file.put_line(fnd_file.LOG, ' ');
206495: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
206496: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );
206497: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');
206498:
206491: l_first_event_id := l_array_header_events(l_array_header_events.FIRST);
206492: l_last_event_id := l_array_header_events(l_array_header_events.LAST);
206493:
206494: fnd_file.put_line(fnd_file.LOG, ' ');
206495: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
206496: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );
206497: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');
206498:
206499: FOR line_record IN line_cur(l_first_event_id, l_last_event_id)
206492: l_last_event_id := l_array_header_events(l_array_header_events.LAST);
206493:
206494: fnd_file.put_line(fnd_file.LOG, ' ');
206495: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
206496: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );
206497: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');
206498:
206499: FOR line_record IN line_cur(l_first_event_id, l_last_event_id)
206500: LOOP
206493:
206494: fnd_file.put_line(fnd_file.LOG, ' ');
206495: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
206496: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );
206497: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');
206498:
206499: FOR line_record IN line_cur(l_first_event_id, l_last_event_id)
206500: LOOP
206501: IF (NOT l_array_header_events.EXISTS(line_record.event_id)) AND (NOT l_array_duplicate_checker.EXISTS(line_record.event_id)) THEN
206498:
206499: FOR line_record IN line_cur(l_first_event_id, l_last_event_id)
206500: LOOP
206501: IF (NOT l_array_header_events.EXISTS(line_record.event_id)) AND (NOT l_array_duplicate_checker.EXISTS(line_record.event_id)) THEN
206502: fnd_file.put_line(fnd_file.log, 'Event_id = ' || line_record.event_id);
206503: l_array_duplicate_checker(line_record.event_id) := line_record.event_id;
206504: END IF;
206505: END LOOP;
206506:
206503: l_array_duplicate_checker(line_record.event_id) := line_record.event_id;
206504: END IF;
206505: END LOOP;
206506:
206507: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
206508: fnd_file.put_line(fnd_file.LOG, ' ');
206509:
206510:
206511: xla_exceptions_pkg.raise_message
206504: END IF;
206505: END LOOP;
206506:
206507: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
206508: fnd_file.put_line(fnd_file.LOG, ' ');
206509:
206510:
206511: xla_exceptions_pkg.raise_message
206512: (p_location => 'XLA_00707_AAD_S_000005_PKG.EventClass_306');
207784:
207785: l_first_event_id := l_array_header_events(l_array_header_events.FIRST);
207786: l_last_event_id := l_array_header_events(l_array_header_events.LAST);
207787:
207788: fnd_file.put_line(fnd_file.LOG, ' ');
207789: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
207790: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );
207791: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');
207792:
207785: l_first_event_id := l_array_header_events(l_array_header_events.FIRST);
207786: l_last_event_id := l_array_header_events(l_array_header_events.LAST);
207787:
207788: fnd_file.put_line(fnd_file.LOG, ' ');
207789: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
207790: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );
207791: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');
207792:
207793: FOR line_record IN line_cur(l_first_event_id, l_last_event_id)
207786: l_last_event_id := l_array_header_events(l_array_header_events.LAST);
207787:
207788: fnd_file.put_line(fnd_file.LOG, ' ');
207789: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
207790: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );
207791: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');
207792:
207793: FOR line_record IN line_cur(l_first_event_id, l_last_event_id)
207794: LOOP
207787:
207788: fnd_file.put_line(fnd_file.LOG, ' ');
207789: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
207790: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );
207791: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');
207792:
207793: FOR line_record IN line_cur(l_first_event_id, l_last_event_id)
207794: LOOP
207795: IF (NOT l_array_header_events.EXISTS(line_record.event_id)) AND (NOT l_array_duplicate_checker.EXISTS(line_record.event_id)) THEN
207792:
207793: FOR line_record IN line_cur(l_first_event_id, l_last_event_id)
207794: LOOP
207795: IF (NOT l_array_header_events.EXISTS(line_record.event_id)) AND (NOT l_array_duplicate_checker.EXISTS(line_record.event_id)) THEN
207796: fnd_file.put_line(fnd_file.log, 'Event_id = ' || line_record.event_id);
207797: l_array_duplicate_checker(line_record.event_id) := line_record.event_id;
207798: END IF;
207799: END LOOP;
207800:
207797: l_array_duplicate_checker(line_record.event_id) := line_record.event_id;
207798: END IF;
207799: END LOOP;
207800:
207801: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
207802: fnd_file.put_line(fnd_file.LOG, ' ');
207803:
207804:
207805: xla_exceptions_pkg.raise_message
207798: END IF;
207799: END LOOP;
207800:
207801: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
207802: fnd_file.put_line(fnd_file.LOG, ' ');
207803:
207804:
207805: xla_exceptions_pkg.raise_message
207806: (p_location => 'XLA_00707_AAD_S_000005_PKG.EventClass_307');