APPS.XLA_00707_AAD_S_000005_PKG dependencies on FND_FILE

Line 144329: fnd_file.put_line(fnd_file.LOG, ' ');

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:

Line 144330: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');

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)

Line 144331: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );

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

Line 144332: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');

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

Line 144337: fnd_file.put_line(fnd_file.log, 'Event_id = ' || line_record.event_id);

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:

Line 144342: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');

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

Line 144343: fnd_file.put_line(fnd_file.LOG, ' ');

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');

Line 145616: fnd_file.put_line(fnd_file.LOG, ' ');

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:

Line 145617: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');

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)

Line 145618: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );

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

Line 145619: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');

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

Line 145624: fnd_file.put_line(fnd_file.log, 'Event_id = ' || line_record.event_id);

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:

Line 145629: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');

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

Line 145630: fnd_file.put_line(fnd_file.LOG, ' ');

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');

Line 146910: fnd_file.put_line(fnd_file.LOG, ' ');

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:

Line 146911: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');

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)

Line 146912: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );

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

Line 146913: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');

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

Line 146918: fnd_file.put_line(fnd_file.log, 'Event_id = ' || line_record.event_id);

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:

Line 146923: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');

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

Line 146924: fnd_file.put_line(fnd_file.LOG, ' ');

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');

Line 148251: fnd_file.put_line(fnd_file.LOG, ' ');

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:

Line 148252: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');

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)

Line 148253: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );

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

Line 148254: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');

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

Line 148259: fnd_file.put_line(fnd_file.log, 'Event_id = ' || line_record.event_id);

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:

Line 148264: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');

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

Line 148265: fnd_file.put_line(fnd_file.LOG, ' ');

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');

Line 149861: fnd_file.put_line(fnd_file.LOG, ' ');

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:

Line 149862: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');

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)

Line 149863: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );

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

Line 149864: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');

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

Line 149869: fnd_file.put_line(fnd_file.log, 'Event_id = ' || line_record.event_id);

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:

Line 149874: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');

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

Line 149875: fnd_file.put_line(fnd_file.LOG, ' ');

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');

Line 151271: fnd_file.put_line(fnd_file.LOG, ' ');

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:

Line 151272: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');

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)

Line 151273: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );

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

Line 151274: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');

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

Line 151279: fnd_file.put_line(fnd_file.log, 'Event_id = ' || line_record.event_id);

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:

Line 151284: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');

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

Line 151285: fnd_file.put_line(fnd_file.LOG, ' ');

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');

Line 152842: fnd_file.put_line(fnd_file.LOG, ' ');

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:

Line 152843: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');

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)

Line 152844: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );

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

Line 152845: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');

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

Line 152850: fnd_file.put_line(fnd_file.log, 'Event_id = ' || line_record.event_id);

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:

Line 152855: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');

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

Line 152856: fnd_file.put_line(fnd_file.LOG, ' ');

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');

Line 154194: fnd_file.put_line(fnd_file.LOG, ' ');

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:

Line 154195: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');

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)

Line 154196: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );

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

Line 154197: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');

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

Line 154202: fnd_file.put_line(fnd_file.log, 'Event_id = ' || line_record.event_id);

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:

Line 154207: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');

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

Line 154208: fnd_file.put_line(fnd_file.LOG, ' ');

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');

Line 155430: fnd_file.put_line(fnd_file.LOG, ' ');

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:

Line 155431: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');

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)

Line 155432: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );

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

Line 155433: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');

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

Line 155438: fnd_file.put_line(fnd_file.log, 'Event_id = ' || line_record.event_id);

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:

Line 155443: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');

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

Line 155444: fnd_file.put_line(fnd_file.LOG, ' ');

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');

Line 156806: fnd_file.put_line(fnd_file.LOG, ' ');

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:

Line 156807: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');

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)

Line 156808: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );

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

Line 156809: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');

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

Line 156814: fnd_file.put_line(fnd_file.log, 'Event_id = ' || line_record.event_id);

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:

Line 156819: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');

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

Line 156820: fnd_file.put_line(fnd_file.LOG, ' ');

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');

Line 158216: fnd_file.put_line(fnd_file.LOG, ' ');

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:

Line 158217: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');

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)

Line 158218: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );

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

Line 158219: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');

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

Line 158224: fnd_file.put_line(fnd_file.log, 'Event_id = ' || line_record.event_id);

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:

Line 158229: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');

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

Line 158230: fnd_file.put_line(fnd_file.LOG, ' ');

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');

Line 159539: fnd_file.put_line(fnd_file.LOG, ' ');

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:

Line 159540: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');

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)

Line 159541: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );

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

Line 159542: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');

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

Line 159547: fnd_file.put_line(fnd_file.log, 'Event_id = ' || line_record.event_id);

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:

Line 159552: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');

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

Line 159553: fnd_file.put_line(fnd_file.LOG, ' ');

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');

Line 160775: fnd_file.put_line(fnd_file.LOG, ' ');

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:

Line 160776: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');

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)

Line 160777: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );

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

Line 160778: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');

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

Line 160783: fnd_file.put_line(fnd_file.log, 'Event_id = ' || line_record.event_id);

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:

Line 160788: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');

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

Line 160789: fnd_file.put_line(fnd_file.LOG, ' ');

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');

Line 162069: fnd_file.put_line(fnd_file.LOG, ' ');

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:

Line 162070: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');

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)

Line 162071: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );

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

Line 162072: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');

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

Line 162077: fnd_file.put_line(fnd_file.log, 'Event_id = ' || line_record.event_id);

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:

Line 162082: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');

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

Line 162083: fnd_file.put_line(fnd_file.LOG, ' ');

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');

Line 163328: fnd_file.put_line(fnd_file.LOG, ' ');

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:

Line 163329: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');

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)

Line 163330: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );

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

Line 163331: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');

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

Line 163336: fnd_file.put_line(fnd_file.log, 'Event_id = ' || line_record.event_id);

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:

Line 163341: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');

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

Line 163342: fnd_file.put_line(fnd_file.LOG, ' ');

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');

Line 164543: fnd_file.put_line(fnd_file.LOG, ' ');

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:

Line 164544: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');

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)

Line 164545: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );

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

Line 164546: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');

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

Line 164551: fnd_file.put_line(fnd_file.log, 'Event_id = ' || line_record.event_id);

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:

Line 164556: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');

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

Line 164557: fnd_file.put_line(fnd_file.LOG, ' ');

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');

Line 165866: fnd_file.put_line(fnd_file.LOG, ' ');

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:

Line 165867: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');

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)

Line 165868: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );

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

Line 165869: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');

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

Line 165874: fnd_file.put_line(fnd_file.log, 'Event_id = ' || line_record.event_id);

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:

Line 165879: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');

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

Line 165880: fnd_file.put_line(fnd_file.LOG, ' ');

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');

Line 167073: fnd_file.put_line(fnd_file.LOG, ' ');

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:

Line 167074: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');

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)

Line 167075: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );

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

Line 167076: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');

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

Line 167081: fnd_file.put_line(fnd_file.log, 'Event_id = ' || line_record.event_id);

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:

Line 167086: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');

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

Line 167087: fnd_file.put_line(fnd_file.LOG, ' ');

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');

Line 168309: fnd_file.put_line(fnd_file.LOG, ' ');

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:

Line 168310: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');

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)

Line 168311: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );

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

Line 168312: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');

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

Line 168317: fnd_file.put_line(fnd_file.log, 'Event_id = ' || line_record.event_id);

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:

Line 168322: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');

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

Line 168323: fnd_file.put_line(fnd_file.LOG, ' ');

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');

Line 169603: fnd_file.put_line(fnd_file.LOG, ' ');

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:

Line 169604: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');

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)

Line 169605: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );

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

Line 169606: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');

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

Line 169611: fnd_file.put_line(fnd_file.log, 'Event_id = ' || line_record.event_id);

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:

Line 169616: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');

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

Line 169617: fnd_file.put_line(fnd_file.LOG, ' ');

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');

Line 170914: fnd_file.put_line(fnd_file.LOG, ' ');

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:

Line 170915: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');

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)

Line 170916: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );

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

Line 170917: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');

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

Line 170922: fnd_file.put_line(fnd_file.log, 'Event_id = ' || line_record.event_id);

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:

Line 170927: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');

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

Line 170928: fnd_file.put_line(fnd_file.LOG, ' ');

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');

Line 172301: fnd_file.put_line(fnd_file.LOG, ' ');

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:

Line 172302: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');

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)

Line 172303: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );

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

Line 172304: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');

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

Line 172309: fnd_file.put_line(fnd_file.log, 'Event_id = ' || line_record.event_id);

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:

Line 172314: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');

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

Line 172315: fnd_file.put_line(fnd_file.LOG, ' ');

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');

Line 173872: fnd_file.put_line(fnd_file.LOG, ' ');

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:

Line 173873: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');

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)

Line 173874: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );

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

Line 173875: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');

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

Line 173880: fnd_file.put_line(fnd_file.log, 'Event_id = ' || line_record.event_id);

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:

Line 173885: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');

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

Line 173886: fnd_file.put_line(fnd_file.LOG, ' ');

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');

Line 175199: fnd_file.put_line(fnd_file.LOG, ' ');

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:

Line 175200: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');

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)

Line 175201: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );

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

Line 175202: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');

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

Line 175207: fnd_file.put_line(fnd_file.log, 'Event_id = ' || line_record.event_id);

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:

Line 175212: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');

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

Line 175213: fnd_file.put_line(fnd_file.LOG, ' ');

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');

Line 176406: fnd_file.put_line(fnd_file.LOG, ' ');

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:

Line 176407: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');

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)

Line 176408: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );

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

Line 176409: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');

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

Line 176414: fnd_file.put_line(fnd_file.log, 'Event_id = ' || line_record.event_id);

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:

Line 176419: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');

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

Line 176420: fnd_file.put_line(fnd_file.LOG, ' ');

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');

Line 177633: fnd_file.put_line(fnd_file.LOG, ' ');

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:

Line 177634: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');

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)

Line 177635: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );

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

Line 177636: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');

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

Line 177641: fnd_file.put_line(fnd_file.log, 'Event_id = ' || line_record.event_id);

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:

Line 177646: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');

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

Line 177647: fnd_file.put_line(fnd_file.LOG, ' ');

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');

Line 178902: fnd_file.put_line(fnd_file.LOG, ' ');

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:

Line 178903: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');

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)

Line 178904: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );

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

Line 178905: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');

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

Line 178910: fnd_file.put_line(fnd_file.log, 'Event_id = ' || line_record.event_id);

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:

Line 178915: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');

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

Line 178916: fnd_file.put_line(fnd_file.LOG, ' ');

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');

Line 180196: fnd_file.put_line(fnd_file.LOG, ' ');

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:

Line 180197: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');

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)

Line 180198: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );

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

Line 180199: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');

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

Line 180204: fnd_file.put_line(fnd_file.log, 'Event_id = ' || line_record.event_id);

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:

Line 180209: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');

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

Line 180210: fnd_file.put_line(fnd_file.LOG, ' ');

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');

Line 181490: fnd_file.put_line(fnd_file.LOG, ' ');

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:

Line 181491: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');

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)

Line 181492: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );

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

Line 181493: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');

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

Line 181498: fnd_file.put_line(fnd_file.log, 'Event_id = ' || line_record.event_id);

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:

Line 181503: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');

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

Line 181504: fnd_file.put_line(fnd_file.LOG, ' ');

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');

Line 182726: fnd_file.put_line(fnd_file.LOG, ' ');

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:

Line 182727: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');

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)

Line 182728: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );

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

Line 182729: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');

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

Line 182734: fnd_file.put_line(fnd_file.log, 'Event_id = ' || line_record.event_id);

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:

Line 182739: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');

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

Line 182740: fnd_file.put_line(fnd_file.LOG, ' ');

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');

Line 184136: fnd_file.put_line(fnd_file.LOG, ' ');

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:

Line 184137: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');

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)

Line 184138: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );

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

Line 184139: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');

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

Line 184144: fnd_file.put_line(fnd_file.log, 'Event_id = ' || line_record.event_id);

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:

Line 184149: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');

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

Line 184150: fnd_file.put_line(fnd_file.LOG, ' ');

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');

Line 185546: fnd_file.put_line(fnd_file.LOG, ' ');

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:

Line 185547: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');

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)

Line 185548: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );

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

Line 185549: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');

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

Line 185554: fnd_file.put_line(fnd_file.log, 'Event_id = ' || line_record.event_id);

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:

Line 185559: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');

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

Line 185560: fnd_file.put_line(fnd_file.LOG, ' ');

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');

Line 186956: fnd_file.put_line(fnd_file.LOG, ' ');

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:

Line 186957: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');

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)

Line 186958: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );

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

Line 186959: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');

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

Line 186964: fnd_file.put_line(fnd_file.log, 'Event_id = ' || line_record.event_id);

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:

Line 186969: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');

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

Line 186970: fnd_file.put_line(fnd_file.LOG, ' ');

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');

Line 188366: fnd_file.put_line(fnd_file.LOG, ' ');

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:

Line 188367: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');

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)

Line 188368: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );

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

Line 188369: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');

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

Line 188374: fnd_file.put_line(fnd_file.log, 'Event_id = ' || line_record.event_id);

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:

Line 188379: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');

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

Line 188380: fnd_file.put_line(fnd_file.LOG, ' ');

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');

Line 189776: fnd_file.put_line(fnd_file.LOG, ' ');

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:

Line 189777: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');

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)

Line 189778: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );

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

Line 189779: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');

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

Line 189784: fnd_file.put_line(fnd_file.log, 'Event_id = ' || line_record.event_id);

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:

Line 189789: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');

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

Line 189790: fnd_file.put_line(fnd_file.LOG, ' ');

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');

Line 191186: fnd_file.put_line(fnd_file.LOG, ' ');

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:

Line 191187: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');

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)

Line 191188: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );

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

Line 191189: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');

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

Line 191194: fnd_file.put_line(fnd_file.log, 'Event_id = ' || line_record.event_id);

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:

Line 191199: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');

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

Line 191200: fnd_file.put_line(fnd_file.LOG, ' ');

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');

Line 192422: fnd_file.put_line(fnd_file.LOG, ' ');

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:

Line 192423: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');

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)

Line 192424: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );

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

Line 192425: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');

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

Line 192430: fnd_file.put_line(fnd_file.log, 'Event_id = ' || line_record.event_id);

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:

Line 192435: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');

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

Line 192436: fnd_file.put_line(fnd_file.LOG, ' ');

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');

Line 193832: fnd_file.put_line(fnd_file.LOG, ' ');

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:

Line 193833: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');

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)

Line 193834: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );

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

Line 193835: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');

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

Line 193840: fnd_file.put_line(fnd_file.log, 'Event_id = ' || line_record.event_id);

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:

Line 193845: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');

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

Line 193846: fnd_file.put_line(fnd_file.LOG, ' ');

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');

Line 195242: fnd_file.put_line(fnd_file.LOG, ' ');

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:

Line 195243: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');

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)

Line 195244: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );

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

Line 195245: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');

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

Line 195250: fnd_file.put_line(fnd_file.log, 'Event_id = ' || line_record.event_id);

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:

Line 195255: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');

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

Line 195256: fnd_file.put_line(fnd_file.LOG, ' ');

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');

Line 196565: fnd_file.put_line(fnd_file.LOG, ' ');

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:

Line 196566: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');

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)

Line 196567: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );

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

Line 196568: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');

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

Line 196573: fnd_file.put_line(fnd_file.log, 'Event_id = ' || line_record.event_id);

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:

Line 196578: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');

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

Line 196579: fnd_file.put_line(fnd_file.LOG, ' ');

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');

Line 197888: fnd_file.put_line(fnd_file.LOG, ' ');

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:

Line 197889: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');

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)

Line 197890: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );

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

Line 197891: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');

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

Line 197896: fnd_file.put_line(fnd_file.log, 'Event_id = ' || line_record.event_id);

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:

Line 197901: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');

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

Line 197902: fnd_file.put_line(fnd_file.LOG, ' ');

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');

Line 199153: fnd_file.put_line(fnd_file.LOG, ' ');

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:

Line 199154: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');

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)

Line 199155: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );

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

Line 199156: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');

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

Line 199161: fnd_file.put_line(fnd_file.log, 'Event_id = ' || line_record.event_id);

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:

Line 199166: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');

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

Line 199167: fnd_file.put_line(fnd_file.LOG, ' ');

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');

Line 200389: fnd_file.put_line(fnd_file.LOG, ' ');

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:

Line 200390: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');

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)

Line 200391: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );

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

Line 200392: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');

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

Line 200397: fnd_file.put_line(fnd_file.log, 'Event_id = ' || line_record.event_id);

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:

Line 200402: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');

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

Line 200403: fnd_file.put_line(fnd_file.LOG, ' ');

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');

Line 201625: fnd_file.put_line(fnd_file.LOG, ' ');

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:

Line 201626: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');

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)

Line 201627: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );

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

Line 201628: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');

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

Line 201633: fnd_file.put_line(fnd_file.log, 'Event_id = ' || line_record.event_id);

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:

Line 201638: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');

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

Line 201639: fnd_file.put_line(fnd_file.LOG, ' ');

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');

Line 202861: fnd_file.put_line(fnd_file.LOG, ' ');

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:

Line 202862: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');

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)

Line 202863: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );

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

Line 202864: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');

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

Line 202869: fnd_file.put_line(fnd_file.log, 'Event_id = ' || line_record.event_id);

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:

Line 202874: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');

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

Line 202875: fnd_file.put_line(fnd_file.LOG, ' ');

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');

Line 204072: fnd_file.put_line(fnd_file.LOG, ' ');

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:

Line 204073: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');

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)

Line 204074: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );

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

Line 204075: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');

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

Line 204080: fnd_file.put_line(fnd_file.log, 'Event_id = ' || line_record.event_id);

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:

Line 204085: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');

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

Line 204086: fnd_file.put_line(fnd_file.LOG, ' ');

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');

Line 205283: fnd_file.put_line(fnd_file.LOG, ' ');

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:

Line 205284: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');

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)

Line 205285: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );

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

Line 205286: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');

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

Line 205291: fnd_file.put_line(fnd_file.log, 'Event_id = ' || line_record.event_id);

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:

Line 205296: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');

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

Line 205297: fnd_file.put_line(fnd_file.LOG, ' ');

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');

Line 206494: fnd_file.put_line(fnd_file.LOG, ' ');

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:

Line 206495: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');

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)

Line 206496: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );

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

Line 206497: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');

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

Line 206502: fnd_file.put_line(fnd_file.log, 'Event_id = ' || line_record.event_id);

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:

Line 206507: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');

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

Line 206508: fnd_file.put_line(fnd_file.LOG, ' ');

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');

Line 207788: fnd_file.put_line(fnd_file.LOG, ' ');

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:

Line 207789: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');

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)

Line 207790: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );

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

Line 207791: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');

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

Line 207796: fnd_file.put_line(fnd_file.log, 'Event_id = ' || line_record.event_id);

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:

Line 207801: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');

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

Line 207802: fnd_file.put_line(fnd_file.LOG, ' ');

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');