APPS.XLA_00707_AAD_S_000007_PKG dependencies on FND_FILE

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

139333:
139334: l_first_event_id := l_array_header_events(l_array_header_events.FIRST);
139335: l_last_event_id := l_array_header_events(l_array_header_events.LAST);
139336:
139337: fnd_file.put_line(fnd_file.LOG, ' ');
139338: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
139339: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );
139340: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');
139341:

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

139334: l_first_event_id := l_array_header_events(l_array_header_events.FIRST);
139335: l_last_event_id := l_array_header_events(l_array_header_events.LAST);
139336:
139337: fnd_file.put_line(fnd_file.LOG, ' ');
139338: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
139339: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );
139340: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');
139341:
139342: FOR line_record IN line_cur(l_first_event_id, l_last_event_id)

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

139335: l_last_event_id := l_array_header_events(l_array_header_events.LAST);
139336:
139337: fnd_file.put_line(fnd_file.LOG, ' ');
139338: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
139339: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );
139340: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');
139341:
139342: FOR line_record IN line_cur(l_first_event_id, l_last_event_id)
139343: LOOP

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

139336:
139337: fnd_file.put_line(fnd_file.LOG, ' ');
139338: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
139339: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );
139340: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');
139341:
139342: FOR line_record IN line_cur(l_first_event_id, l_last_event_id)
139343: LOOP
139344: IF (NOT l_array_header_events.EXISTS(line_record.event_id)) AND (NOT l_array_duplicate_checker.EXISTS(line_record.event_id)) THEN

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

139341:
139342: FOR line_record IN line_cur(l_first_event_id, l_last_event_id)
139343: LOOP
139344: IF (NOT l_array_header_events.EXISTS(line_record.event_id)) AND (NOT l_array_duplicate_checker.EXISTS(line_record.event_id)) THEN
139345: fnd_file.put_line(fnd_file.log, 'Event_id = ' || line_record.event_id);
139346: l_array_duplicate_checker(line_record.event_id) := line_record.event_id;
139347: END IF;
139348: END LOOP;
139349:

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

139346: l_array_duplicate_checker(line_record.event_id) := line_record.event_id;
139347: END IF;
139348: END LOOP;
139349:
139350: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
139351: fnd_file.put_line(fnd_file.LOG, ' ');
139352:
139353:
139354: xla_exceptions_pkg.raise_message

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

139347: END IF;
139348: END LOOP;
139349:
139350: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
139351: fnd_file.put_line(fnd_file.LOG, ' ');
139352:
139353:
139354: xla_exceptions_pkg.raise_message
139355: (p_location => 'XLA_00707_AAD_S_000007_PKG.EventClass_250');

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

140620:
140621: l_first_event_id := l_array_header_events(l_array_header_events.FIRST);
140622: l_last_event_id := l_array_header_events(l_array_header_events.LAST);
140623:
140624: fnd_file.put_line(fnd_file.LOG, ' ');
140625: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
140626: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );
140627: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');
140628:

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

140621: l_first_event_id := l_array_header_events(l_array_header_events.FIRST);
140622: l_last_event_id := l_array_header_events(l_array_header_events.LAST);
140623:
140624: fnd_file.put_line(fnd_file.LOG, ' ');
140625: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
140626: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );
140627: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');
140628:
140629: FOR line_record IN line_cur(l_first_event_id, l_last_event_id)

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

140622: l_last_event_id := l_array_header_events(l_array_header_events.LAST);
140623:
140624: fnd_file.put_line(fnd_file.LOG, ' ');
140625: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
140626: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );
140627: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');
140628:
140629: FOR line_record IN line_cur(l_first_event_id, l_last_event_id)
140630: LOOP

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

140623:
140624: fnd_file.put_line(fnd_file.LOG, ' ');
140625: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
140626: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );
140627: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');
140628:
140629: FOR line_record IN line_cur(l_first_event_id, l_last_event_id)
140630: LOOP
140631: IF (NOT l_array_header_events.EXISTS(line_record.event_id)) AND (NOT l_array_duplicate_checker.EXISTS(line_record.event_id)) THEN

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

140628:
140629: FOR line_record IN line_cur(l_first_event_id, l_last_event_id)
140630: LOOP
140631: IF (NOT l_array_header_events.EXISTS(line_record.event_id)) AND (NOT l_array_duplicate_checker.EXISTS(line_record.event_id)) THEN
140632: fnd_file.put_line(fnd_file.log, 'Event_id = ' || line_record.event_id);
140633: l_array_duplicate_checker(line_record.event_id) := line_record.event_id;
140634: END IF;
140635: END LOOP;
140636:

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

140633: l_array_duplicate_checker(line_record.event_id) := line_record.event_id;
140634: END IF;
140635: END LOOP;
140636:
140637: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
140638: fnd_file.put_line(fnd_file.LOG, ' ');
140639:
140640:
140641: xla_exceptions_pkg.raise_message

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

140634: END IF;
140635: END LOOP;
140636:
140637: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
140638: fnd_file.put_line(fnd_file.LOG, ' ');
140639:
140640:
140641: xla_exceptions_pkg.raise_message
140642: (p_location => 'XLA_00707_AAD_S_000007_PKG.EventClass_251');

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

141914:
141915: l_first_event_id := l_array_header_events(l_array_header_events.FIRST);
141916: l_last_event_id := l_array_header_events(l_array_header_events.LAST);
141917:
141918: fnd_file.put_line(fnd_file.LOG, ' ');
141919: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
141920: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );
141921: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');
141922:

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

141915: l_first_event_id := l_array_header_events(l_array_header_events.FIRST);
141916: l_last_event_id := l_array_header_events(l_array_header_events.LAST);
141917:
141918: fnd_file.put_line(fnd_file.LOG, ' ');
141919: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
141920: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );
141921: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');
141922:
141923: FOR line_record IN line_cur(l_first_event_id, l_last_event_id)

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

141916: l_last_event_id := l_array_header_events(l_array_header_events.LAST);
141917:
141918: fnd_file.put_line(fnd_file.LOG, ' ');
141919: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
141920: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );
141921: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');
141922:
141923: FOR line_record IN line_cur(l_first_event_id, l_last_event_id)
141924: LOOP

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

141917:
141918: fnd_file.put_line(fnd_file.LOG, ' ');
141919: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
141920: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );
141921: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');
141922:
141923: FOR line_record IN line_cur(l_first_event_id, l_last_event_id)
141924: LOOP
141925: IF (NOT l_array_header_events.EXISTS(line_record.event_id)) AND (NOT l_array_duplicate_checker.EXISTS(line_record.event_id)) THEN

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

141922:
141923: FOR line_record IN line_cur(l_first_event_id, l_last_event_id)
141924: LOOP
141925: IF (NOT l_array_header_events.EXISTS(line_record.event_id)) AND (NOT l_array_duplicate_checker.EXISTS(line_record.event_id)) THEN
141926: fnd_file.put_line(fnd_file.log, 'Event_id = ' || line_record.event_id);
141927: l_array_duplicate_checker(line_record.event_id) := line_record.event_id;
141928: END IF;
141929: END LOOP;
141930:

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

141927: l_array_duplicate_checker(line_record.event_id) := line_record.event_id;
141928: END IF;
141929: END LOOP;
141930:
141931: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
141932: fnd_file.put_line(fnd_file.LOG, ' ');
141933:
141934:
141935: xla_exceptions_pkg.raise_message

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

141928: END IF;
141929: END LOOP;
141930:
141931: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
141932: fnd_file.put_line(fnd_file.LOG, ' ');
141933:
141934:
141935: xla_exceptions_pkg.raise_message
141936: (p_location => 'XLA_00707_AAD_S_000007_PKG.EventClass_252');

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

143255:
143256: l_first_event_id := l_array_header_events(l_array_header_events.FIRST);
143257: l_last_event_id := l_array_header_events(l_array_header_events.LAST);
143258:
143259: fnd_file.put_line(fnd_file.LOG, ' ');
143260: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
143261: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );
143262: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');
143263:

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

143256: l_first_event_id := l_array_header_events(l_array_header_events.FIRST);
143257: l_last_event_id := l_array_header_events(l_array_header_events.LAST);
143258:
143259: fnd_file.put_line(fnd_file.LOG, ' ');
143260: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
143261: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );
143262: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');
143263:
143264: FOR line_record IN line_cur(l_first_event_id, l_last_event_id)

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

143257: l_last_event_id := l_array_header_events(l_array_header_events.LAST);
143258:
143259: fnd_file.put_line(fnd_file.LOG, ' ');
143260: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
143261: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );
143262: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');
143263:
143264: FOR line_record IN line_cur(l_first_event_id, l_last_event_id)
143265: LOOP

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

143258:
143259: fnd_file.put_line(fnd_file.LOG, ' ');
143260: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
143261: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );
143262: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');
143263:
143264: FOR line_record IN line_cur(l_first_event_id, l_last_event_id)
143265: LOOP
143266: IF (NOT l_array_header_events.EXISTS(line_record.event_id)) AND (NOT l_array_duplicate_checker.EXISTS(line_record.event_id)) THEN

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

143263:
143264: FOR line_record IN line_cur(l_first_event_id, l_last_event_id)
143265: LOOP
143266: IF (NOT l_array_header_events.EXISTS(line_record.event_id)) AND (NOT l_array_duplicate_checker.EXISTS(line_record.event_id)) THEN
143267: fnd_file.put_line(fnd_file.log, 'Event_id = ' || line_record.event_id);
143268: l_array_duplicate_checker(line_record.event_id) := line_record.event_id;
143269: END IF;
143270: END LOOP;
143271:

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

143268: l_array_duplicate_checker(line_record.event_id) := line_record.event_id;
143269: END IF;
143270: END LOOP;
143271:
143272: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
143273: fnd_file.put_line(fnd_file.LOG, ' ');
143274:
143275:
143276: xla_exceptions_pkg.raise_message

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

143269: END IF;
143270: END LOOP;
143271:
143272: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
143273: fnd_file.put_line(fnd_file.LOG, ' ');
143274:
143275:
143276: xla_exceptions_pkg.raise_message
143277: (p_location => 'XLA_00707_AAD_S_000007_PKG.EventClass_253');

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

144865:
144866: l_first_event_id := l_array_header_events(l_array_header_events.FIRST);
144867: l_last_event_id := l_array_header_events(l_array_header_events.LAST);
144868:
144869: fnd_file.put_line(fnd_file.LOG, ' ');
144870: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
144871: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );
144872: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');
144873:

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

144866: l_first_event_id := l_array_header_events(l_array_header_events.FIRST);
144867: l_last_event_id := l_array_header_events(l_array_header_events.LAST);
144868:
144869: fnd_file.put_line(fnd_file.LOG, ' ');
144870: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
144871: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );
144872: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');
144873:
144874: FOR line_record IN line_cur(l_first_event_id, l_last_event_id)

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

144867: l_last_event_id := l_array_header_events(l_array_header_events.LAST);
144868:
144869: fnd_file.put_line(fnd_file.LOG, ' ');
144870: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
144871: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );
144872: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');
144873:
144874: FOR line_record IN line_cur(l_first_event_id, l_last_event_id)
144875: LOOP

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

144868:
144869: fnd_file.put_line(fnd_file.LOG, ' ');
144870: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
144871: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );
144872: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');
144873:
144874: FOR line_record IN line_cur(l_first_event_id, l_last_event_id)
144875: LOOP
144876: IF (NOT l_array_header_events.EXISTS(line_record.event_id)) AND (NOT l_array_duplicate_checker.EXISTS(line_record.event_id)) THEN

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

144873:
144874: FOR line_record IN line_cur(l_first_event_id, l_last_event_id)
144875: LOOP
144876: IF (NOT l_array_header_events.EXISTS(line_record.event_id)) AND (NOT l_array_duplicate_checker.EXISTS(line_record.event_id)) THEN
144877: fnd_file.put_line(fnd_file.log, 'Event_id = ' || line_record.event_id);
144878: l_array_duplicate_checker(line_record.event_id) := line_record.event_id;
144879: END IF;
144880: END LOOP;
144881:

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

144878: l_array_duplicate_checker(line_record.event_id) := line_record.event_id;
144879: END IF;
144880: END LOOP;
144881:
144882: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
144883: fnd_file.put_line(fnd_file.LOG, ' ');
144884:
144885:
144886: xla_exceptions_pkg.raise_message

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

144879: END IF;
144880: END LOOP;
144881:
144882: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
144883: fnd_file.put_line(fnd_file.LOG, ' ');
144884:
144885:
144886: xla_exceptions_pkg.raise_message
144887: (p_location => 'XLA_00707_AAD_S_000007_PKG.EventClass_254');

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

146275:
146276: l_first_event_id := l_array_header_events(l_array_header_events.FIRST);
146277: l_last_event_id := l_array_header_events(l_array_header_events.LAST);
146278:
146279: fnd_file.put_line(fnd_file.LOG, ' ');
146280: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
146281: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );
146282: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');
146283:

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

146276: l_first_event_id := l_array_header_events(l_array_header_events.FIRST);
146277: l_last_event_id := l_array_header_events(l_array_header_events.LAST);
146278:
146279: fnd_file.put_line(fnd_file.LOG, ' ');
146280: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
146281: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );
146282: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');
146283:
146284: FOR line_record IN line_cur(l_first_event_id, l_last_event_id)

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

146277: l_last_event_id := l_array_header_events(l_array_header_events.LAST);
146278:
146279: fnd_file.put_line(fnd_file.LOG, ' ');
146280: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
146281: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );
146282: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');
146283:
146284: FOR line_record IN line_cur(l_first_event_id, l_last_event_id)
146285: LOOP

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

146278:
146279: fnd_file.put_line(fnd_file.LOG, ' ');
146280: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
146281: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );
146282: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');
146283:
146284: FOR line_record IN line_cur(l_first_event_id, l_last_event_id)
146285: LOOP
146286: IF (NOT l_array_header_events.EXISTS(line_record.event_id)) AND (NOT l_array_duplicate_checker.EXISTS(line_record.event_id)) THEN

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

146283:
146284: FOR line_record IN line_cur(l_first_event_id, l_last_event_id)
146285: LOOP
146286: IF (NOT l_array_header_events.EXISTS(line_record.event_id)) AND (NOT l_array_duplicate_checker.EXISTS(line_record.event_id)) THEN
146287: fnd_file.put_line(fnd_file.log, 'Event_id = ' || line_record.event_id);
146288: l_array_duplicate_checker(line_record.event_id) := line_record.event_id;
146289: END IF;
146290: END LOOP;
146291:

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

146288: l_array_duplicate_checker(line_record.event_id) := line_record.event_id;
146289: END IF;
146290: END LOOP;
146291:
146292: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
146293: fnd_file.put_line(fnd_file.LOG, ' ');
146294:
146295:
146296: xla_exceptions_pkg.raise_message

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

146289: END IF;
146290: END LOOP;
146291:
146292: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
146293: fnd_file.put_line(fnd_file.LOG, ' ');
146294:
146295:
146296: xla_exceptions_pkg.raise_message
146297: (p_location => 'XLA_00707_AAD_S_000007_PKG.EventClass_255');

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

147846:
147847: l_first_event_id := l_array_header_events(l_array_header_events.FIRST);
147848: l_last_event_id := l_array_header_events(l_array_header_events.LAST);
147849:
147850: fnd_file.put_line(fnd_file.LOG, ' ');
147851: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
147852: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );
147853: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');
147854:

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

147847: l_first_event_id := l_array_header_events(l_array_header_events.FIRST);
147848: l_last_event_id := l_array_header_events(l_array_header_events.LAST);
147849:
147850: fnd_file.put_line(fnd_file.LOG, ' ');
147851: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
147852: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );
147853: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');
147854:
147855: FOR line_record IN line_cur(l_first_event_id, l_last_event_id)

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

147848: l_last_event_id := l_array_header_events(l_array_header_events.LAST);
147849:
147850: fnd_file.put_line(fnd_file.LOG, ' ');
147851: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
147852: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );
147853: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');
147854:
147855: FOR line_record IN line_cur(l_first_event_id, l_last_event_id)
147856: LOOP

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

147849:
147850: fnd_file.put_line(fnd_file.LOG, ' ');
147851: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
147852: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );
147853: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');
147854:
147855: FOR line_record IN line_cur(l_first_event_id, l_last_event_id)
147856: LOOP
147857: IF (NOT l_array_header_events.EXISTS(line_record.event_id)) AND (NOT l_array_duplicate_checker.EXISTS(line_record.event_id)) THEN

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

147854:
147855: FOR line_record IN line_cur(l_first_event_id, l_last_event_id)
147856: LOOP
147857: IF (NOT l_array_header_events.EXISTS(line_record.event_id)) AND (NOT l_array_duplicate_checker.EXISTS(line_record.event_id)) THEN
147858: fnd_file.put_line(fnd_file.log, 'Event_id = ' || line_record.event_id);
147859: l_array_duplicate_checker(line_record.event_id) := line_record.event_id;
147860: END IF;
147861: END LOOP;
147862:

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

147859: l_array_duplicate_checker(line_record.event_id) := line_record.event_id;
147860: END IF;
147861: END LOOP;
147862:
147863: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
147864: fnd_file.put_line(fnd_file.LOG, ' ');
147865:
147866:
147867: xla_exceptions_pkg.raise_message

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

147860: END IF;
147861: END LOOP;
147862:
147863: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
147864: fnd_file.put_line(fnd_file.LOG, ' ');
147865:
147866:
147867: xla_exceptions_pkg.raise_message
147868: (p_location => 'XLA_00707_AAD_S_000007_PKG.EventClass_256');

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

149198:
149199: l_first_event_id := l_array_header_events(l_array_header_events.FIRST);
149200: l_last_event_id := l_array_header_events(l_array_header_events.LAST);
149201:
149202: fnd_file.put_line(fnd_file.LOG, ' ');
149203: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
149204: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );
149205: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');
149206:

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

149199: l_first_event_id := l_array_header_events(l_array_header_events.FIRST);
149200: l_last_event_id := l_array_header_events(l_array_header_events.LAST);
149201:
149202: fnd_file.put_line(fnd_file.LOG, ' ');
149203: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
149204: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );
149205: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');
149206:
149207: FOR line_record IN line_cur(l_first_event_id, l_last_event_id)

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

149200: l_last_event_id := l_array_header_events(l_array_header_events.LAST);
149201:
149202: fnd_file.put_line(fnd_file.LOG, ' ');
149203: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
149204: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );
149205: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');
149206:
149207: FOR line_record IN line_cur(l_first_event_id, l_last_event_id)
149208: LOOP

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

149201:
149202: fnd_file.put_line(fnd_file.LOG, ' ');
149203: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
149204: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );
149205: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');
149206:
149207: FOR line_record IN line_cur(l_first_event_id, l_last_event_id)
149208: LOOP
149209: IF (NOT l_array_header_events.EXISTS(line_record.event_id)) AND (NOT l_array_duplicate_checker.EXISTS(line_record.event_id)) THEN

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

149206:
149207: FOR line_record IN line_cur(l_first_event_id, l_last_event_id)
149208: LOOP
149209: IF (NOT l_array_header_events.EXISTS(line_record.event_id)) AND (NOT l_array_duplicate_checker.EXISTS(line_record.event_id)) THEN
149210: fnd_file.put_line(fnd_file.log, 'Event_id = ' || line_record.event_id);
149211: l_array_duplicate_checker(line_record.event_id) := line_record.event_id;
149212: END IF;
149213: END LOOP;
149214:

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

149211: l_array_duplicate_checker(line_record.event_id) := line_record.event_id;
149212: END IF;
149213: END LOOP;
149214:
149215: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
149216: fnd_file.put_line(fnd_file.LOG, ' ');
149217:
149218:
149219: xla_exceptions_pkg.raise_message

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

149212: END IF;
149213: END LOOP;
149214:
149215: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
149216: fnd_file.put_line(fnd_file.LOG, ' ');
149217:
149218:
149219: xla_exceptions_pkg.raise_message
149220: (p_location => 'XLA_00707_AAD_S_000007_PKG.EventClass_257');

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

150434:
150435: l_first_event_id := l_array_header_events(l_array_header_events.FIRST);
150436: l_last_event_id := l_array_header_events(l_array_header_events.LAST);
150437:
150438: fnd_file.put_line(fnd_file.LOG, ' ');
150439: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
150440: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );
150441: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');
150442:

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

150435: l_first_event_id := l_array_header_events(l_array_header_events.FIRST);
150436: l_last_event_id := l_array_header_events(l_array_header_events.LAST);
150437:
150438: fnd_file.put_line(fnd_file.LOG, ' ');
150439: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
150440: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );
150441: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');
150442:
150443: FOR line_record IN line_cur(l_first_event_id, l_last_event_id)

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

150436: l_last_event_id := l_array_header_events(l_array_header_events.LAST);
150437:
150438: fnd_file.put_line(fnd_file.LOG, ' ');
150439: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
150440: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );
150441: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');
150442:
150443: FOR line_record IN line_cur(l_first_event_id, l_last_event_id)
150444: LOOP

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

150437:
150438: fnd_file.put_line(fnd_file.LOG, ' ');
150439: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
150440: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );
150441: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');
150442:
150443: FOR line_record IN line_cur(l_first_event_id, l_last_event_id)
150444: LOOP
150445: IF (NOT l_array_header_events.EXISTS(line_record.event_id)) AND (NOT l_array_duplicate_checker.EXISTS(line_record.event_id)) THEN

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

150442:
150443: FOR line_record IN line_cur(l_first_event_id, l_last_event_id)
150444: LOOP
150445: IF (NOT l_array_header_events.EXISTS(line_record.event_id)) AND (NOT l_array_duplicate_checker.EXISTS(line_record.event_id)) THEN
150446: fnd_file.put_line(fnd_file.log, 'Event_id = ' || line_record.event_id);
150447: l_array_duplicate_checker(line_record.event_id) := line_record.event_id;
150448: END IF;
150449: END LOOP;
150450:

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

150447: l_array_duplicate_checker(line_record.event_id) := line_record.event_id;
150448: END IF;
150449: END LOOP;
150450:
150451: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
150452: fnd_file.put_line(fnd_file.LOG, ' ');
150453:
150454:
150455: xla_exceptions_pkg.raise_message

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

150448: END IF;
150449: END LOOP;
150450:
150451: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
150452: fnd_file.put_line(fnd_file.LOG, ' ');
150453:
150454:
150455: xla_exceptions_pkg.raise_message
150456: (p_location => 'XLA_00707_AAD_S_000007_PKG.EventClass_258');

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

151810:
151811: l_first_event_id := l_array_header_events(l_array_header_events.FIRST);
151812: l_last_event_id := l_array_header_events(l_array_header_events.LAST);
151813:
151814: fnd_file.put_line(fnd_file.LOG, ' ');
151815: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
151816: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );
151817: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');
151818:

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

151811: l_first_event_id := l_array_header_events(l_array_header_events.FIRST);
151812: l_last_event_id := l_array_header_events(l_array_header_events.LAST);
151813:
151814: fnd_file.put_line(fnd_file.LOG, ' ');
151815: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
151816: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );
151817: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');
151818:
151819: FOR line_record IN line_cur(l_first_event_id, l_last_event_id)

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

151812: l_last_event_id := l_array_header_events(l_array_header_events.LAST);
151813:
151814: fnd_file.put_line(fnd_file.LOG, ' ');
151815: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
151816: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );
151817: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');
151818:
151819: FOR line_record IN line_cur(l_first_event_id, l_last_event_id)
151820: LOOP

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

151813:
151814: fnd_file.put_line(fnd_file.LOG, ' ');
151815: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
151816: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );
151817: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');
151818:
151819: FOR line_record IN line_cur(l_first_event_id, l_last_event_id)
151820: LOOP
151821: IF (NOT l_array_header_events.EXISTS(line_record.event_id)) AND (NOT l_array_duplicate_checker.EXISTS(line_record.event_id)) THEN

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

151818:
151819: FOR line_record IN line_cur(l_first_event_id, l_last_event_id)
151820: LOOP
151821: IF (NOT l_array_header_events.EXISTS(line_record.event_id)) AND (NOT l_array_duplicate_checker.EXISTS(line_record.event_id)) THEN
151822: fnd_file.put_line(fnd_file.log, 'Event_id = ' || line_record.event_id);
151823: l_array_duplicate_checker(line_record.event_id) := line_record.event_id;
151824: END IF;
151825: END LOOP;
151826:

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

151823: l_array_duplicate_checker(line_record.event_id) := line_record.event_id;
151824: END IF;
151825: END LOOP;
151826:
151827: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
151828: fnd_file.put_line(fnd_file.LOG, ' ');
151829:
151830:
151831: xla_exceptions_pkg.raise_message

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

151824: END IF;
151825: END LOOP;
151826:
151827: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
151828: fnd_file.put_line(fnd_file.LOG, ' ');
151829:
151830:
151831: xla_exceptions_pkg.raise_message
151832: (p_location => 'XLA_00707_AAD_S_000007_PKG.EventClass_259');

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

153220:
153221: l_first_event_id := l_array_header_events(l_array_header_events.FIRST);
153222: l_last_event_id := l_array_header_events(l_array_header_events.LAST);
153223:
153224: fnd_file.put_line(fnd_file.LOG, ' ');
153225: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
153226: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );
153227: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');
153228:

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

153221: l_first_event_id := l_array_header_events(l_array_header_events.FIRST);
153222: l_last_event_id := l_array_header_events(l_array_header_events.LAST);
153223:
153224: fnd_file.put_line(fnd_file.LOG, ' ');
153225: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
153226: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );
153227: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');
153228:
153229: FOR line_record IN line_cur(l_first_event_id, l_last_event_id)

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

153222: l_last_event_id := l_array_header_events(l_array_header_events.LAST);
153223:
153224: fnd_file.put_line(fnd_file.LOG, ' ');
153225: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
153226: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );
153227: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');
153228:
153229: FOR line_record IN line_cur(l_first_event_id, l_last_event_id)
153230: LOOP

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

153223:
153224: fnd_file.put_line(fnd_file.LOG, ' ');
153225: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
153226: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );
153227: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');
153228:
153229: FOR line_record IN line_cur(l_first_event_id, l_last_event_id)
153230: LOOP
153231: IF (NOT l_array_header_events.EXISTS(line_record.event_id)) AND (NOT l_array_duplicate_checker.EXISTS(line_record.event_id)) THEN

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

153228:
153229: FOR line_record IN line_cur(l_first_event_id, l_last_event_id)
153230: LOOP
153231: IF (NOT l_array_header_events.EXISTS(line_record.event_id)) AND (NOT l_array_duplicate_checker.EXISTS(line_record.event_id)) THEN
153232: fnd_file.put_line(fnd_file.log, 'Event_id = ' || line_record.event_id);
153233: l_array_duplicate_checker(line_record.event_id) := line_record.event_id;
153234: END IF;
153235: END LOOP;
153236:

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

153233: l_array_duplicate_checker(line_record.event_id) := line_record.event_id;
153234: END IF;
153235: END LOOP;
153236:
153237: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
153238: fnd_file.put_line(fnd_file.LOG, ' ');
153239:
153240:
153241: xla_exceptions_pkg.raise_message

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

153234: END IF;
153235: END LOOP;
153236:
153237: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
153238: fnd_file.put_line(fnd_file.LOG, ' ');
153239:
153240:
153241: xla_exceptions_pkg.raise_message
153242: (p_location => 'XLA_00707_AAD_S_000007_PKG.EventClass_260');

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

154543:
154544: l_first_event_id := l_array_header_events(l_array_header_events.FIRST);
154545: l_last_event_id := l_array_header_events(l_array_header_events.LAST);
154546:
154547: fnd_file.put_line(fnd_file.LOG, ' ');
154548: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
154549: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );
154550: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');
154551:

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

154544: l_first_event_id := l_array_header_events(l_array_header_events.FIRST);
154545: l_last_event_id := l_array_header_events(l_array_header_events.LAST);
154546:
154547: fnd_file.put_line(fnd_file.LOG, ' ');
154548: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
154549: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );
154550: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');
154551:
154552: FOR line_record IN line_cur(l_first_event_id, l_last_event_id)

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

154545: l_last_event_id := l_array_header_events(l_array_header_events.LAST);
154546:
154547: fnd_file.put_line(fnd_file.LOG, ' ');
154548: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
154549: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );
154550: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');
154551:
154552: FOR line_record IN line_cur(l_first_event_id, l_last_event_id)
154553: LOOP

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

154546:
154547: fnd_file.put_line(fnd_file.LOG, ' ');
154548: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
154549: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );
154550: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');
154551:
154552: FOR line_record IN line_cur(l_first_event_id, l_last_event_id)
154553: LOOP
154554: IF (NOT l_array_header_events.EXISTS(line_record.event_id)) AND (NOT l_array_duplicate_checker.EXISTS(line_record.event_id)) THEN

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

154551:
154552: FOR line_record IN line_cur(l_first_event_id, l_last_event_id)
154553: LOOP
154554: IF (NOT l_array_header_events.EXISTS(line_record.event_id)) AND (NOT l_array_duplicate_checker.EXISTS(line_record.event_id)) THEN
154555: fnd_file.put_line(fnd_file.log, 'Event_id = ' || line_record.event_id);
154556: l_array_duplicate_checker(line_record.event_id) := line_record.event_id;
154557: END IF;
154558: END LOOP;
154559:

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

154556: l_array_duplicate_checker(line_record.event_id) := line_record.event_id;
154557: END IF;
154558: END LOOP;
154559:
154560: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
154561: fnd_file.put_line(fnd_file.LOG, ' ');
154562:
154563:
154564: xla_exceptions_pkg.raise_message

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

154557: END IF;
154558: END LOOP;
154559:
154560: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
154561: fnd_file.put_line(fnd_file.LOG, ' ');
154562:
154563:
154564: xla_exceptions_pkg.raise_message
154565: (p_location => 'XLA_00707_AAD_S_000007_PKG.EventClass_261');

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

155779:
155780: l_first_event_id := l_array_header_events(l_array_header_events.FIRST);
155781: l_last_event_id := l_array_header_events(l_array_header_events.LAST);
155782:
155783: fnd_file.put_line(fnd_file.LOG, ' ');
155784: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
155785: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );
155786: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');
155787:

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

155780: l_first_event_id := l_array_header_events(l_array_header_events.FIRST);
155781: l_last_event_id := l_array_header_events(l_array_header_events.LAST);
155782:
155783: fnd_file.put_line(fnd_file.LOG, ' ');
155784: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
155785: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );
155786: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');
155787:
155788: FOR line_record IN line_cur(l_first_event_id, l_last_event_id)

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

155781: l_last_event_id := l_array_header_events(l_array_header_events.LAST);
155782:
155783: fnd_file.put_line(fnd_file.LOG, ' ');
155784: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
155785: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );
155786: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');
155787:
155788: FOR line_record IN line_cur(l_first_event_id, l_last_event_id)
155789: LOOP

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

155782:
155783: fnd_file.put_line(fnd_file.LOG, ' ');
155784: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
155785: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );
155786: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');
155787:
155788: FOR line_record IN line_cur(l_first_event_id, l_last_event_id)
155789: LOOP
155790: IF (NOT l_array_header_events.EXISTS(line_record.event_id)) AND (NOT l_array_duplicate_checker.EXISTS(line_record.event_id)) THEN

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

155787:
155788: FOR line_record IN line_cur(l_first_event_id, l_last_event_id)
155789: LOOP
155790: IF (NOT l_array_header_events.EXISTS(line_record.event_id)) AND (NOT l_array_duplicate_checker.EXISTS(line_record.event_id)) THEN
155791: fnd_file.put_line(fnd_file.log, 'Event_id = ' || line_record.event_id);
155792: l_array_duplicate_checker(line_record.event_id) := line_record.event_id;
155793: END IF;
155794: END LOOP;
155795:

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

155792: l_array_duplicate_checker(line_record.event_id) := line_record.event_id;
155793: END IF;
155794: END LOOP;
155795:
155796: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
155797: fnd_file.put_line(fnd_file.LOG, ' ');
155798:
155799:
155800: xla_exceptions_pkg.raise_message

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

155793: END IF;
155794: END LOOP;
155795:
155796: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
155797: fnd_file.put_line(fnd_file.LOG, ' ');
155798:
155799:
155800: xla_exceptions_pkg.raise_message
155801: (p_location => 'XLA_00707_AAD_S_000007_PKG.EventClass_262');

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

157073:
157074: l_first_event_id := l_array_header_events(l_array_header_events.FIRST);
157075: l_last_event_id := l_array_header_events(l_array_header_events.LAST);
157076:
157077: fnd_file.put_line(fnd_file.LOG, ' ');
157078: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
157079: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );
157080: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');
157081:

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

157074: l_first_event_id := l_array_header_events(l_array_header_events.FIRST);
157075: l_last_event_id := l_array_header_events(l_array_header_events.LAST);
157076:
157077: fnd_file.put_line(fnd_file.LOG, ' ');
157078: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
157079: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );
157080: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');
157081:
157082: FOR line_record IN line_cur(l_first_event_id, l_last_event_id)

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

157075: l_last_event_id := l_array_header_events(l_array_header_events.LAST);
157076:
157077: fnd_file.put_line(fnd_file.LOG, ' ');
157078: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
157079: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );
157080: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');
157081:
157082: FOR line_record IN line_cur(l_first_event_id, l_last_event_id)
157083: LOOP

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

157076:
157077: fnd_file.put_line(fnd_file.LOG, ' ');
157078: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
157079: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );
157080: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');
157081:
157082: FOR line_record IN line_cur(l_first_event_id, l_last_event_id)
157083: LOOP
157084: IF (NOT l_array_header_events.EXISTS(line_record.event_id)) AND (NOT l_array_duplicate_checker.EXISTS(line_record.event_id)) THEN

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

157081:
157082: FOR line_record IN line_cur(l_first_event_id, l_last_event_id)
157083: LOOP
157084: IF (NOT l_array_header_events.EXISTS(line_record.event_id)) AND (NOT l_array_duplicate_checker.EXISTS(line_record.event_id)) THEN
157085: fnd_file.put_line(fnd_file.log, 'Event_id = ' || line_record.event_id);
157086: l_array_duplicate_checker(line_record.event_id) := line_record.event_id;
157087: END IF;
157088: END LOOP;
157089:

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

157086: l_array_duplicate_checker(line_record.event_id) := line_record.event_id;
157087: END IF;
157088: END LOOP;
157089:
157090: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
157091: fnd_file.put_line(fnd_file.LOG, ' ');
157092:
157093:
157094: xla_exceptions_pkg.raise_message

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

157087: END IF;
157088: END LOOP;
157089:
157090: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
157091: fnd_file.put_line(fnd_file.LOG, ' ');
157092:
157093:
157094: xla_exceptions_pkg.raise_message
157095: (p_location => 'XLA_00707_AAD_S_000007_PKG.EventClass_263');

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

158332:
158333: l_first_event_id := l_array_header_events(l_array_header_events.FIRST);
158334: l_last_event_id := l_array_header_events(l_array_header_events.LAST);
158335:
158336: fnd_file.put_line(fnd_file.LOG, ' ');
158337: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
158338: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );
158339: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');
158340:

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

158333: l_first_event_id := l_array_header_events(l_array_header_events.FIRST);
158334: l_last_event_id := l_array_header_events(l_array_header_events.LAST);
158335:
158336: fnd_file.put_line(fnd_file.LOG, ' ');
158337: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
158338: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );
158339: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');
158340:
158341: FOR line_record IN line_cur(l_first_event_id, l_last_event_id)

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

158334: l_last_event_id := l_array_header_events(l_array_header_events.LAST);
158335:
158336: fnd_file.put_line(fnd_file.LOG, ' ');
158337: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
158338: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );
158339: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');
158340:
158341: FOR line_record IN line_cur(l_first_event_id, l_last_event_id)
158342: LOOP

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

158335:
158336: fnd_file.put_line(fnd_file.LOG, ' ');
158337: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
158338: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );
158339: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');
158340:
158341: FOR line_record IN line_cur(l_first_event_id, l_last_event_id)
158342: LOOP
158343: IF (NOT l_array_header_events.EXISTS(line_record.event_id)) AND (NOT l_array_duplicate_checker.EXISTS(line_record.event_id)) THEN

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

158340:
158341: FOR line_record IN line_cur(l_first_event_id, l_last_event_id)
158342: LOOP
158343: IF (NOT l_array_header_events.EXISTS(line_record.event_id)) AND (NOT l_array_duplicate_checker.EXISTS(line_record.event_id)) THEN
158344: fnd_file.put_line(fnd_file.log, 'Event_id = ' || line_record.event_id);
158345: l_array_duplicate_checker(line_record.event_id) := line_record.event_id;
158346: END IF;
158347: END LOOP;
158348:

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

158345: l_array_duplicate_checker(line_record.event_id) := line_record.event_id;
158346: END IF;
158347: END LOOP;
158348:
158349: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
158350: fnd_file.put_line(fnd_file.LOG, ' ');
158351:
158352:
158353: xla_exceptions_pkg.raise_message

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

158346: END IF;
158347: END LOOP;
158348:
158349: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
158350: fnd_file.put_line(fnd_file.LOG, ' ');
158351:
158352:
158353: xla_exceptions_pkg.raise_message
158354: (p_location => 'XLA_00707_AAD_S_000007_PKG.EventClass_264');

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

159547:
159548: l_first_event_id := l_array_header_events(l_array_header_events.FIRST);
159549: l_last_event_id := l_array_header_events(l_array_header_events.LAST);
159550:
159551: fnd_file.put_line(fnd_file.LOG, ' ');
159552: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
159553: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );
159554: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');
159555:

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

159548: l_first_event_id := l_array_header_events(l_array_header_events.FIRST);
159549: l_last_event_id := l_array_header_events(l_array_header_events.LAST);
159550:
159551: fnd_file.put_line(fnd_file.LOG, ' ');
159552: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
159553: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );
159554: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');
159555:
159556: FOR line_record IN line_cur(l_first_event_id, l_last_event_id)

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

159549: l_last_event_id := l_array_header_events(l_array_header_events.LAST);
159550:
159551: fnd_file.put_line(fnd_file.LOG, ' ');
159552: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
159553: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );
159554: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');
159555:
159556: FOR line_record IN line_cur(l_first_event_id, l_last_event_id)
159557: LOOP

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

159550:
159551: fnd_file.put_line(fnd_file.LOG, ' ');
159552: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
159553: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );
159554: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');
159555:
159556: FOR line_record IN line_cur(l_first_event_id, l_last_event_id)
159557: LOOP
159558: IF (NOT l_array_header_events.EXISTS(line_record.event_id)) AND (NOT l_array_duplicate_checker.EXISTS(line_record.event_id)) THEN

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

159555:
159556: FOR line_record IN line_cur(l_first_event_id, l_last_event_id)
159557: LOOP
159558: IF (NOT l_array_header_events.EXISTS(line_record.event_id)) AND (NOT l_array_duplicate_checker.EXISTS(line_record.event_id)) THEN
159559: fnd_file.put_line(fnd_file.log, 'Event_id = ' || line_record.event_id);
159560: l_array_duplicate_checker(line_record.event_id) := line_record.event_id;
159561: END IF;
159562: END LOOP;
159563:

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

159560: l_array_duplicate_checker(line_record.event_id) := line_record.event_id;
159561: END IF;
159562: END LOOP;
159563:
159564: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
159565: fnd_file.put_line(fnd_file.LOG, ' ');
159566:
159567:
159568: xla_exceptions_pkg.raise_message

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

159561: END IF;
159562: END LOOP;
159563:
159564: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
159565: fnd_file.put_line(fnd_file.LOG, ' ');
159566:
159567:
159568: xla_exceptions_pkg.raise_message
159569: (p_location => 'XLA_00707_AAD_S_000007_PKG.EventClass_265');

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

160870:
160871: l_first_event_id := l_array_header_events(l_array_header_events.FIRST);
160872: l_last_event_id := l_array_header_events(l_array_header_events.LAST);
160873:
160874: fnd_file.put_line(fnd_file.LOG, ' ');
160875: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
160876: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );
160877: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');
160878:

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

160871: l_first_event_id := l_array_header_events(l_array_header_events.FIRST);
160872: l_last_event_id := l_array_header_events(l_array_header_events.LAST);
160873:
160874: fnd_file.put_line(fnd_file.LOG, ' ');
160875: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
160876: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );
160877: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');
160878:
160879: FOR line_record IN line_cur(l_first_event_id, l_last_event_id)

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

160872: l_last_event_id := l_array_header_events(l_array_header_events.LAST);
160873:
160874: fnd_file.put_line(fnd_file.LOG, ' ');
160875: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
160876: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );
160877: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');
160878:
160879: FOR line_record IN line_cur(l_first_event_id, l_last_event_id)
160880: LOOP

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

160873:
160874: fnd_file.put_line(fnd_file.LOG, ' ');
160875: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
160876: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );
160877: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');
160878:
160879: FOR line_record IN line_cur(l_first_event_id, l_last_event_id)
160880: LOOP
160881: IF (NOT l_array_header_events.EXISTS(line_record.event_id)) AND (NOT l_array_duplicate_checker.EXISTS(line_record.event_id)) THEN

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

160878:
160879: FOR line_record IN line_cur(l_first_event_id, l_last_event_id)
160880: LOOP
160881: IF (NOT l_array_header_events.EXISTS(line_record.event_id)) AND (NOT l_array_duplicate_checker.EXISTS(line_record.event_id)) THEN
160882: fnd_file.put_line(fnd_file.log, 'Event_id = ' || line_record.event_id);
160883: l_array_duplicate_checker(line_record.event_id) := line_record.event_id;
160884: END IF;
160885: END LOOP;
160886:

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

160883: l_array_duplicate_checker(line_record.event_id) := line_record.event_id;
160884: END IF;
160885: END LOOP;
160886:
160887: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
160888: fnd_file.put_line(fnd_file.LOG, ' ');
160889:
160890:
160891: xla_exceptions_pkg.raise_message

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

160884: END IF;
160885: END LOOP;
160886:
160887: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
160888: fnd_file.put_line(fnd_file.LOG, ' ');
160889:
160890:
160891: xla_exceptions_pkg.raise_message
160892: (p_location => 'XLA_00707_AAD_S_000007_PKG.EventClass_266');

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

162106:
162107: l_first_event_id := l_array_header_events(l_array_header_events.FIRST);
162108: l_last_event_id := l_array_header_events(l_array_header_events.LAST);
162109:
162110: fnd_file.put_line(fnd_file.LOG, ' ');
162111: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
162112: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );
162113: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');
162114:

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

162107: l_first_event_id := l_array_header_events(l_array_header_events.FIRST);
162108: l_last_event_id := l_array_header_events(l_array_header_events.LAST);
162109:
162110: fnd_file.put_line(fnd_file.LOG, ' ');
162111: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
162112: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );
162113: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');
162114:
162115: FOR line_record IN line_cur(l_first_event_id, l_last_event_id)

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

162108: l_last_event_id := l_array_header_events(l_array_header_events.LAST);
162109:
162110: fnd_file.put_line(fnd_file.LOG, ' ');
162111: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
162112: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );
162113: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');
162114:
162115: FOR line_record IN line_cur(l_first_event_id, l_last_event_id)
162116: LOOP

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

162109:
162110: fnd_file.put_line(fnd_file.LOG, ' ');
162111: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
162112: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );
162113: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');
162114:
162115: FOR line_record IN line_cur(l_first_event_id, l_last_event_id)
162116: LOOP
162117: IF (NOT l_array_header_events.EXISTS(line_record.event_id)) AND (NOT l_array_duplicate_checker.EXISTS(line_record.event_id)) THEN

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

162114:
162115: FOR line_record IN line_cur(l_first_event_id, l_last_event_id)
162116: LOOP
162117: IF (NOT l_array_header_events.EXISTS(line_record.event_id)) AND (NOT l_array_duplicate_checker.EXISTS(line_record.event_id)) THEN
162118: fnd_file.put_line(fnd_file.log, 'Event_id = ' || line_record.event_id);
162119: l_array_duplicate_checker(line_record.event_id) := line_record.event_id;
162120: END IF;
162121: END LOOP;
162122:

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

162119: l_array_duplicate_checker(line_record.event_id) := line_record.event_id;
162120: END IF;
162121: END LOOP;
162122:
162123: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
162124: fnd_file.put_line(fnd_file.LOG, ' ');
162125:
162126:
162127: xla_exceptions_pkg.raise_message

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

162120: END IF;
162121: END LOOP;
162122:
162123: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
162124: fnd_file.put_line(fnd_file.LOG, ' ');
162125:
162126:
162127: xla_exceptions_pkg.raise_message
162128: (p_location => 'XLA_00707_AAD_S_000007_PKG.EventClass_267');

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

163417:
163418: l_first_event_id := l_array_header_events(l_array_header_events.FIRST);
163419: l_last_event_id := l_array_header_events(l_array_header_events.LAST);
163420:
163421: fnd_file.put_line(fnd_file.LOG, ' ');
163422: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
163423: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );
163424: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');
163425:

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

163418: l_first_event_id := l_array_header_events(l_array_header_events.FIRST);
163419: l_last_event_id := l_array_header_events(l_array_header_events.LAST);
163420:
163421: fnd_file.put_line(fnd_file.LOG, ' ');
163422: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
163423: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );
163424: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');
163425:
163426: FOR line_record IN line_cur(l_first_event_id, l_last_event_id)

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

163419: l_last_event_id := l_array_header_events(l_array_header_events.LAST);
163420:
163421: fnd_file.put_line(fnd_file.LOG, ' ');
163422: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
163423: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );
163424: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');
163425:
163426: FOR line_record IN line_cur(l_first_event_id, l_last_event_id)
163427: LOOP

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

163420:
163421: fnd_file.put_line(fnd_file.LOG, ' ');
163422: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
163423: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );
163424: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');
163425:
163426: FOR line_record IN line_cur(l_first_event_id, l_last_event_id)
163427: LOOP
163428: IF (NOT l_array_header_events.EXISTS(line_record.event_id)) AND (NOT l_array_duplicate_checker.EXISTS(line_record.event_id)) THEN

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

163425:
163426: FOR line_record IN line_cur(l_first_event_id, l_last_event_id)
163427: LOOP
163428: IF (NOT l_array_header_events.EXISTS(line_record.event_id)) AND (NOT l_array_duplicate_checker.EXISTS(line_record.event_id)) THEN
163429: fnd_file.put_line(fnd_file.log, 'Event_id = ' || line_record.event_id);
163430: l_array_duplicate_checker(line_record.event_id) := line_record.event_id;
163431: END IF;
163432: END LOOP;
163433:

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

163430: l_array_duplicate_checker(line_record.event_id) := line_record.event_id;
163431: END IF;
163432: END LOOP;
163433:
163434: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
163435: fnd_file.put_line(fnd_file.LOG, ' ');
163436:
163437:
163438: xla_exceptions_pkg.raise_message

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

163431: END IF;
163432: END LOOP;
163433:
163434: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
163435: fnd_file.put_line(fnd_file.LOG, ' ');
163436:
163437:
163438: xla_exceptions_pkg.raise_message
163439: (p_location => 'XLA_00707_AAD_S_000007_PKG.EventClass_268');

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

164804:
164805: l_first_event_id := l_array_header_events(l_array_header_events.FIRST);
164806: l_last_event_id := l_array_header_events(l_array_header_events.LAST);
164807:
164808: fnd_file.put_line(fnd_file.LOG, ' ');
164809: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
164810: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );
164811: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');
164812:

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

164805: l_first_event_id := l_array_header_events(l_array_header_events.FIRST);
164806: l_last_event_id := l_array_header_events(l_array_header_events.LAST);
164807:
164808: fnd_file.put_line(fnd_file.LOG, ' ');
164809: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
164810: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );
164811: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');
164812:
164813: FOR line_record IN line_cur(l_first_event_id, l_last_event_id)

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

164806: l_last_event_id := l_array_header_events(l_array_header_events.LAST);
164807:
164808: fnd_file.put_line(fnd_file.LOG, ' ');
164809: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
164810: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );
164811: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');
164812:
164813: FOR line_record IN line_cur(l_first_event_id, l_last_event_id)
164814: LOOP

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

164807:
164808: fnd_file.put_line(fnd_file.LOG, ' ');
164809: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
164810: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );
164811: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');
164812:
164813: FOR line_record IN line_cur(l_first_event_id, l_last_event_id)
164814: LOOP
164815: IF (NOT l_array_header_events.EXISTS(line_record.event_id)) AND (NOT l_array_duplicate_checker.EXISTS(line_record.event_id)) THEN

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

164812:
164813: FOR line_record IN line_cur(l_first_event_id, l_last_event_id)
164814: LOOP
164815: IF (NOT l_array_header_events.EXISTS(line_record.event_id)) AND (NOT l_array_duplicate_checker.EXISTS(line_record.event_id)) THEN
164816: fnd_file.put_line(fnd_file.log, 'Event_id = ' || line_record.event_id);
164817: l_array_duplicate_checker(line_record.event_id) := line_record.event_id;
164818: END IF;
164819: END LOOP;
164820:

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

164817: l_array_duplicate_checker(line_record.event_id) := line_record.event_id;
164818: END IF;
164819: END LOOP;
164820:
164821: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
164822: fnd_file.put_line(fnd_file.LOG, ' ');
164823:
164824:
164825: xla_exceptions_pkg.raise_message

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

164818: END IF;
164819: END LOOP;
164820:
164821: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
164822: fnd_file.put_line(fnd_file.LOG, ' ');
164823:
164824:
164825: xla_exceptions_pkg.raise_message
164826: (p_location => 'XLA_00707_AAD_S_000007_PKG.EventClass_269');

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

166375:
166376: l_first_event_id := l_array_header_events(l_array_header_events.FIRST);
166377: l_last_event_id := l_array_header_events(l_array_header_events.LAST);
166378:
166379: fnd_file.put_line(fnd_file.LOG, ' ');
166380: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
166381: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );
166382: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');
166383:

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

166376: l_first_event_id := l_array_header_events(l_array_header_events.FIRST);
166377: l_last_event_id := l_array_header_events(l_array_header_events.LAST);
166378:
166379: fnd_file.put_line(fnd_file.LOG, ' ');
166380: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
166381: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );
166382: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');
166383:
166384: FOR line_record IN line_cur(l_first_event_id, l_last_event_id)

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

166377: l_last_event_id := l_array_header_events(l_array_header_events.LAST);
166378:
166379: fnd_file.put_line(fnd_file.LOG, ' ');
166380: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
166381: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );
166382: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');
166383:
166384: FOR line_record IN line_cur(l_first_event_id, l_last_event_id)
166385: LOOP

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

166378:
166379: fnd_file.put_line(fnd_file.LOG, ' ');
166380: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
166381: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );
166382: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');
166383:
166384: FOR line_record IN line_cur(l_first_event_id, l_last_event_id)
166385: LOOP
166386: IF (NOT l_array_header_events.EXISTS(line_record.event_id)) AND (NOT l_array_duplicate_checker.EXISTS(line_record.event_id)) THEN

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

166383:
166384: FOR line_record IN line_cur(l_first_event_id, l_last_event_id)
166385: LOOP
166386: IF (NOT l_array_header_events.EXISTS(line_record.event_id)) AND (NOT l_array_duplicate_checker.EXISTS(line_record.event_id)) THEN
166387: fnd_file.put_line(fnd_file.log, 'Event_id = ' || line_record.event_id);
166388: l_array_duplicate_checker(line_record.event_id) := line_record.event_id;
166389: END IF;
166390: END LOOP;
166391:

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

166388: l_array_duplicate_checker(line_record.event_id) := line_record.event_id;
166389: END IF;
166390: END LOOP;
166391:
166392: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
166393: fnd_file.put_line(fnd_file.LOG, ' ');
166394:
166395:
166396: xla_exceptions_pkg.raise_message

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

166389: END IF;
166390: END LOOP;
166391:
166392: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
166393: fnd_file.put_line(fnd_file.LOG, ' ');
166394:
166395:
166396: xla_exceptions_pkg.raise_message
166397: (p_location => 'XLA_00707_AAD_S_000007_PKG.EventClass_270');

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

167702:
167703: l_first_event_id := l_array_header_events(l_array_header_events.FIRST);
167704: l_last_event_id := l_array_header_events(l_array_header_events.LAST);
167705:
167706: fnd_file.put_line(fnd_file.LOG, ' ');
167707: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
167708: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );
167709: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');
167710:

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

167703: l_first_event_id := l_array_header_events(l_array_header_events.FIRST);
167704: l_last_event_id := l_array_header_events(l_array_header_events.LAST);
167705:
167706: fnd_file.put_line(fnd_file.LOG, ' ');
167707: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
167708: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );
167709: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');
167710:
167711: FOR line_record IN line_cur(l_first_event_id, l_last_event_id)

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

167704: l_last_event_id := l_array_header_events(l_array_header_events.LAST);
167705:
167706: fnd_file.put_line(fnd_file.LOG, ' ');
167707: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
167708: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );
167709: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');
167710:
167711: FOR line_record IN line_cur(l_first_event_id, l_last_event_id)
167712: LOOP

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

167705:
167706: fnd_file.put_line(fnd_file.LOG, ' ');
167707: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
167708: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );
167709: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');
167710:
167711: FOR line_record IN line_cur(l_first_event_id, l_last_event_id)
167712: LOOP
167713: IF (NOT l_array_header_events.EXISTS(line_record.event_id)) AND (NOT l_array_duplicate_checker.EXISTS(line_record.event_id)) THEN

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

167710:
167711: FOR line_record IN line_cur(l_first_event_id, l_last_event_id)
167712: LOOP
167713: IF (NOT l_array_header_events.EXISTS(line_record.event_id)) AND (NOT l_array_duplicate_checker.EXISTS(line_record.event_id)) THEN
167714: fnd_file.put_line(fnd_file.log, 'Event_id = ' || line_record.event_id);
167715: l_array_duplicate_checker(line_record.event_id) := line_record.event_id;
167716: END IF;
167717: END LOOP;
167718:

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

167715: l_array_duplicate_checker(line_record.event_id) := line_record.event_id;
167716: END IF;
167717: END LOOP;
167718:
167719: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
167720: fnd_file.put_line(fnd_file.LOG, ' ');
167721:
167722:
167723: xla_exceptions_pkg.raise_message

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

167716: END IF;
167717: END LOOP;
167718:
167719: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
167720: fnd_file.put_line(fnd_file.LOG, ' ');
167721:
167722:
167723: xla_exceptions_pkg.raise_message
167724: (p_location => 'XLA_00707_AAD_S_000007_PKG.EventClass_271');

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

168929:
168930: l_first_event_id := l_array_header_events(l_array_header_events.FIRST);
168931: l_last_event_id := l_array_header_events(l_array_header_events.LAST);
168932:
168933: fnd_file.put_line(fnd_file.LOG, ' ');
168934: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
168935: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );
168936: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');
168937:

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

168930: l_first_event_id := l_array_header_events(l_array_header_events.FIRST);
168931: l_last_event_id := l_array_header_events(l_array_header_events.LAST);
168932:
168933: fnd_file.put_line(fnd_file.LOG, ' ');
168934: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
168935: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );
168936: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');
168937:
168938: FOR line_record IN line_cur(l_first_event_id, l_last_event_id)

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

168931: l_last_event_id := l_array_header_events(l_array_header_events.LAST);
168932:
168933: fnd_file.put_line(fnd_file.LOG, ' ');
168934: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
168935: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );
168936: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');
168937:
168938: FOR line_record IN line_cur(l_first_event_id, l_last_event_id)
168939: LOOP

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

168932:
168933: fnd_file.put_line(fnd_file.LOG, ' ');
168934: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
168935: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );
168936: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');
168937:
168938: FOR line_record IN line_cur(l_first_event_id, l_last_event_id)
168939: LOOP
168940: IF (NOT l_array_header_events.EXISTS(line_record.event_id)) AND (NOT l_array_duplicate_checker.EXISTS(line_record.event_id)) THEN

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

168937:
168938: FOR line_record IN line_cur(l_first_event_id, l_last_event_id)
168939: LOOP
168940: IF (NOT l_array_header_events.EXISTS(line_record.event_id)) AND (NOT l_array_duplicate_checker.EXISTS(line_record.event_id)) THEN
168941: fnd_file.put_line(fnd_file.log, 'Event_id = ' || line_record.event_id);
168942: l_array_duplicate_checker(line_record.event_id) := line_record.event_id;
168943: END IF;
168944: END LOOP;
168945:

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

168942: l_array_duplicate_checker(line_record.event_id) := line_record.event_id;
168943: END IF;
168944: END LOOP;
168945:
168946: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
168947: fnd_file.put_line(fnd_file.LOG, ' ');
168948:
168949:
168950: xla_exceptions_pkg.raise_message

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

168943: END IF;
168944: END LOOP;
168945:
168946: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
168947: fnd_file.put_line(fnd_file.LOG, ' ');
168948:
168949:
168950: xla_exceptions_pkg.raise_message
168951: (p_location => 'XLA_00707_AAD_S_000007_PKG.EventClass_272');

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

170198:
170199: l_first_event_id := l_array_header_events(l_array_header_events.FIRST);
170200: l_last_event_id := l_array_header_events(l_array_header_events.LAST);
170201:
170202: fnd_file.put_line(fnd_file.LOG, ' ');
170203: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
170204: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );
170205: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');
170206:

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

170199: l_first_event_id := l_array_header_events(l_array_header_events.FIRST);
170200: l_last_event_id := l_array_header_events(l_array_header_events.LAST);
170201:
170202: fnd_file.put_line(fnd_file.LOG, ' ');
170203: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
170204: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );
170205: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');
170206:
170207: FOR line_record IN line_cur(l_first_event_id, l_last_event_id)

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

170200: l_last_event_id := l_array_header_events(l_array_header_events.LAST);
170201:
170202: fnd_file.put_line(fnd_file.LOG, ' ');
170203: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
170204: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );
170205: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');
170206:
170207: FOR line_record IN line_cur(l_first_event_id, l_last_event_id)
170208: LOOP

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

170201:
170202: fnd_file.put_line(fnd_file.LOG, ' ');
170203: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
170204: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );
170205: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');
170206:
170207: FOR line_record IN line_cur(l_first_event_id, l_last_event_id)
170208: LOOP
170209: IF (NOT l_array_header_events.EXISTS(line_record.event_id)) AND (NOT l_array_duplicate_checker.EXISTS(line_record.event_id)) THEN

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

170206:
170207: FOR line_record IN line_cur(l_first_event_id, l_last_event_id)
170208: LOOP
170209: IF (NOT l_array_header_events.EXISTS(line_record.event_id)) AND (NOT l_array_duplicate_checker.EXISTS(line_record.event_id)) THEN
170210: fnd_file.put_line(fnd_file.log, 'Event_id = ' || line_record.event_id);
170211: l_array_duplicate_checker(line_record.event_id) := line_record.event_id;
170212: END IF;
170213: END LOOP;
170214:

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

170211: l_array_duplicate_checker(line_record.event_id) := line_record.event_id;
170212: END IF;
170213: END LOOP;
170214:
170215: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
170216: fnd_file.put_line(fnd_file.LOG, ' ');
170217:
170218:
170219: xla_exceptions_pkg.raise_message

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

170212: END IF;
170213: END LOOP;
170214:
170215: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
170216: fnd_file.put_line(fnd_file.LOG, ' ');
170217:
170218:
170219: xla_exceptions_pkg.raise_message
170220: (p_location => 'XLA_00707_AAD_S_000007_PKG.EventClass_273');

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

171492:
171493: l_first_event_id := l_array_header_events(l_array_header_events.FIRST);
171494: l_last_event_id := l_array_header_events(l_array_header_events.LAST);
171495:
171496: fnd_file.put_line(fnd_file.LOG, ' ');
171497: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
171498: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );
171499: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');
171500:

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

171493: l_first_event_id := l_array_header_events(l_array_header_events.FIRST);
171494: l_last_event_id := l_array_header_events(l_array_header_events.LAST);
171495:
171496: fnd_file.put_line(fnd_file.LOG, ' ');
171497: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
171498: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );
171499: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');
171500:
171501: FOR line_record IN line_cur(l_first_event_id, l_last_event_id)

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

171494: l_last_event_id := l_array_header_events(l_array_header_events.LAST);
171495:
171496: fnd_file.put_line(fnd_file.LOG, ' ');
171497: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
171498: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );
171499: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');
171500:
171501: FOR line_record IN line_cur(l_first_event_id, l_last_event_id)
171502: LOOP

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

171495:
171496: fnd_file.put_line(fnd_file.LOG, ' ');
171497: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
171498: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );
171499: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');
171500:
171501: FOR line_record IN line_cur(l_first_event_id, l_last_event_id)
171502: LOOP
171503: IF (NOT l_array_header_events.EXISTS(line_record.event_id)) AND (NOT l_array_duplicate_checker.EXISTS(line_record.event_id)) THEN

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

171500:
171501: FOR line_record IN line_cur(l_first_event_id, l_last_event_id)
171502: LOOP
171503: IF (NOT l_array_header_events.EXISTS(line_record.event_id)) AND (NOT l_array_duplicate_checker.EXISTS(line_record.event_id)) THEN
171504: fnd_file.put_line(fnd_file.log, 'Event_id = ' || line_record.event_id);
171505: l_array_duplicate_checker(line_record.event_id) := line_record.event_id;
171506: END IF;
171507: END LOOP;
171508:

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

171505: l_array_duplicate_checker(line_record.event_id) := line_record.event_id;
171506: END IF;
171507: END LOOP;
171508:
171509: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
171510: fnd_file.put_line(fnd_file.LOG, ' ');
171511:
171512:
171513: xla_exceptions_pkg.raise_message

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

171506: END IF;
171507: END LOOP;
171508:
171509: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
171510: fnd_file.put_line(fnd_file.LOG, ' ');
171511:
171512:
171513: xla_exceptions_pkg.raise_message
171514: (p_location => 'XLA_00707_AAD_S_000007_PKG.EventClass_274');

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

172786:
172787: l_first_event_id := l_array_header_events(l_array_header_events.FIRST);
172788: l_last_event_id := l_array_header_events(l_array_header_events.LAST);
172789:
172790: fnd_file.put_line(fnd_file.LOG, ' ');
172791: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
172792: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );
172793: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');
172794:

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

172787: l_first_event_id := l_array_header_events(l_array_header_events.FIRST);
172788: l_last_event_id := l_array_header_events(l_array_header_events.LAST);
172789:
172790: fnd_file.put_line(fnd_file.LOG, ' ');
172791: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
172792: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );
172793: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');
172794:
172795: FOR line_record IN line_cur(l_first_event_id, l_last_event_id)

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

172788: l_last_event_id := l_array_header_events(l_array_header_events.LAST);
172789:
172790: fnd_file.put_line(fnd_file.LOG, ' ');
172791: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
172792: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );
172793: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');
172794:
172795: FOR line_record IN line_cur(l_first_event_id, l_last_event_id)
172796: LOOP

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

172789:
172790: fnd_file.put_line(fnd_file.LOG, ' ');
172791: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
172792: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );
172793: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');
172794:
172795: FOR line_record IN line_cur(l_first_event_id, l_last_event_id)
172796: LOOP
172797: IF (NOT l_array_header_events.EXISTS(line_record.event_id)) AND (NOT l_array_duplicate_checker.EXISTS(line_record.event_id)) THEN

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

172794:
172795: FOR line_record IN line_cur(l_first_event_id, l_last_event_id)
172796: LOOP
172797: IF (NOT l_array_header_events.EXISTS(line_record.event_id)) AND (NOT l_array_duplicate_checker.EXISTS(line_record.event_id)) THEN
172798: fnd_file.put_line(fnd_file.log, 'Event_id = ' || line_record.event_id);
172799: l_array_duplicate_checker(line_record.event_id) := line_record.event_id;
172800: END IF;
172801: END LOOP;
172802:

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

172799: l_array_duplicate_checker(line_record.event_id) := line_record.event_id;
172800: END IF;
172801: END LOOP;
172802:
172803: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
172804: fnd_file.put_line(fnd_file.LOG, ' ');
172805:
172806:
172807: xla_exceptions_pkg.raise_message

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

172800: END IF;
172801: END LOOP;
172802:
172803: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
172804: fnd_file.put_line(fnd_file.LOG, ' ');
172805:
172806:
172807: xla_exceptions_pkg.raise_message
172808: (p_location => 'XLA_00707_AAD_S_000007_PKG.EventType_275');

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

174022:
174023: l_first_event_id := l_array_header_events(l_array_header_events.FIRST);
174024: l_last_event_id := l_array_header_events(l_array_header_events.LAST);
174025:
174026: fnd_file.put_line(fnd_file.LOG, ' ');
174027: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
174028: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );
174029: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');
174030:

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

174023: l_first_event_id := l_array_header_events(l_array_header_events.FIRST);
174024: l_last_event_id := l_array_header_events(l_array_header_events.LAST);
174025:
174026: fnd_file.put_line(fnd_file.LOG, ' ');
174027: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
174028: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );
174029: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');
174030:
174031: FOR line_record IN line_cur(l_first_event_id, l_last_event_id)

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

174024: l_last_event_id := l_array_header_events(l_array_header_events.LAST);
174025:
174026: fnd_file.put_line(fnd_file.LOG, ' ');
174027: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
174028: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );
174029: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');
174030:
174031: FOR line_record IN line_cur(l_first_event_id, l_last_event_id)
174032: LOOP

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

174025:
174026: fnd_file.put_line(fnd_file.LOG, ' ');
174027: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
174028: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );
174029: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');
174030:
174031: FOR line_record IN line_cur(l_first_event_id, l_last_event_id)
174032: LOOP
174033: IF (NOT l_array_header_events.EXISTS(line_record.event_id)) AND (NOT l_array_duplicate_checker.EXISTS(line_record.event_id)) THEN

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

174030:
174031: FOR line_record IN line_cur(l_first_event_id, l_last_event_id)
174032: LOOP
174033: IF (NOT l_array_header_events.EXISTS(line_record.event_id)) AND (NOT l_array_duplicate_checker.EXISTS(line_record.event_id)) THEN
174034: fnd_file.put_line(fnd_file.log, 'Event_id = ' || line_record.event_id);
174035: l_array_duplicate_checker(line_record.event_id) := line_record.event_id;
174036: END IF;
174037: END LOOP;
174038:

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

174035: l_array_duplicate_checker(line_record.event_id) := line_record.event_id;
174036: END IF;
174037: END LOOP;
174038:
174039: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
174040: fnd_file.put_line(fnd_file.LOG, ' ');
174041:
174042:
174043: xla_exceptions_pkg.raise_message

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

174036: END IF;
174037: END LOOP;
174038:
174039: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
174040: fnd_file.put_line(fnd_file.LOG, ' ');
174041:
174042:
174043: xla_exceptions_pkg.raise_message
174044: (p_location => 'XLA_00707_AAD_S_000007_PKG.EventType_276');

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

175432:
175433: l_first_event_id := l_array_header_events(l_array_header_events.FIRST);
175434: l_last_event_id := l_array_header_events(l_array_header_events.LAST);
175435:
175436: fnd_file.put_line(fnd_file.LOG, ' ');
175437: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
175438: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );
175439: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');
175440:

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

175433: l_first_event_id := l_array_header_events(l_array_header_events.FIRST);
175434: l_last_event_id := l_array_header_events(l_array_header_events.LAST);
175435:
175436: fnd_file.put_line(fnd_file.LOG, ' ');
175437: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
175438: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );
175439: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');
175440:
175441: FOR line_record IN line_cur(l_first_event_id, l_last_event_id)

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

175434: l_last_event_id := l_array_header_events(l_array_header_events.LAST);
175435:
175436: fnd_file.put_line(fnd_file.LOG, ' ');
175437: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
175438: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );
175439: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');
175440:
175441: FOR line_record IN line_cur(l_first_event_id, l_last_event_id)
175442: LOOP

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

175435:
175436: fnd_file.put_line(fnd_file.LOG, ' ');
175437: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
175438: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );
175439: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');
175440:
175441: FOR line_record IN line_cur(l_first_event_id, l_last_event_id)
175442: LOOP
175443: IF (NOT l_array_header_events.EXISTS(line_record.event_id)) AND (NOT l_array_duplicate_checker.EXISTS(line_record.event_id)) THEN

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

175440:
175441: FOR line_record IN line_cur(l_first_event_id, l_last_event_id)
175442: LOOP
175443: IF (NOT l_array_header_events.EXISTS(line_record.event_id)) AND (NOT l_array_duplicate_checker.EXISTS(line_record.event_id)) THEN
175444: fnd_file.put_line(fnd_file.log, 'Event_id = ' || line_record.event_id);
175445: l_array_duplicate_checker(line_record.event_id) := line_record.event_id;
175446: END IF;
175447: END LOOP;
175448:

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

175445: l_array_duplicate_checker(line_record.event_id) := line_record.event_id;
175446: END IF;
175447: END LOOP;
175448:
175449: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
175450: fnd_file.put_line(fnd_file.LOG, ' ');
175451:
175452:
175453: xla_exceptions_pkg.raise_message

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

175446: END IF;
175447: END LOOP;
175448:
175449: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
175450: fnd_file.put_line(fnd_file.LOG, ' ');
175451:
175452:
175453: xla_exceptions_pkg.raise_message
175454: (p_location => 'XLA_00707_AAD_S_000007_PKG.EventType_277');

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

176842:
176843: l_first_event_id := l_array_header_events(l_array_header_events.FIRST);
176844: l_last_event_id := l_array_header_events(l_array_header_events.LAST);
176845:
176846: fnd_file.put_line(fnd_file.LOG, ' ');
176847: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
176848: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );
176849: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');
176850:

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

176843: l_first_event_id := l_array_header_events(l_array_header_events.FIRST);
176844: l_last_event_id := l_array_header_events(l_array_header_events.LAST);
176845:
176846: fnd_file.put_line(fnd_file.LOG, ' ');
176847: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
176848: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );
176849: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');
176850:
176851: FOR line_record IN line_cur(l_first_event_id, l_last_event_id)

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

176844: l_last_event_id := l_array_header_events(l_array_header_events.LAST);
176845:
176846: fnd_file.put_line(fnd_file.LOG, ' ');
176847: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
176848: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );
176849: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');
176850:
176851: FOR line_record IN line_cur(l_first_event_id, l_last_event_id)
176852: LOOP

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

176845:
176846: fnd_file.put_line(fnd_file.LOG, ' ');
176847: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
176848: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );
176849: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');
176850:
176851: FOR line_record IN line_cur(l_first_event_id, l_last_event_id)
176852: LOOP
176853: IF (NOT l_array_header_events.EXISTS(line_record.event_id)) AND (NOT l_array_duplicate_checker.EXISTS(line_record.event_id)) THEN

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

176850:
176851: FOR line_record IN line_cur(l_first_event_id, l_last_event_id)
176852: LOOP
176853: IF (NOT l_array_header_events.EXISTS(line_record.event_id)) AND (NOT l_array_duplicate_checker.EXISTS(line_record.event_id)) THEN
176854: fnd_file.put_line(fnd_file.log, 'Event_id = ' || line_record.event_id);
176855: l_array_duplicate_checker(line_record.event_id) := line_record.event_id;
176856: END IF;
176857: END LOOP;
176858:

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

176855: l_array_duplicate_checker(line_record.event_id) := line_record.event_id;
176856: END IF;
176857: END LOOP;
176858:
176859: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
176860: fnd_file.put_line(fnd_file.LOG, ' ');
176861:
176862:
176863: xla_exceptions_pkg.raise_message

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

176856: END IF;
176857: END LOOP;
176858:
176859: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
176860: fnd_file.put_line(fnd_file.LOG, ' ');
176861:
176862:
176863: xla_exceptions_pkg.raise_message
176864: (p_location => 'XLA_00707_AAD_S_000007_PKG.EventType_278');

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

178252:
178253: l_first_event_id := l_array_header_events(l_array_header_events.FIRST);
178254: l_last_event_id := l_array_header_events(l_array_header_events.LAST);
178255:
178256: fnd_file.put_line(fnd_file.LOG, ' ');
178257: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
178258: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );
178259: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');
178260:

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

178253: l_first_event_id := l_array_header_events(l_array_header_events.FIRST);
178254: l_last_event_id := l_array_header_events(l_array_header_events.LAST);
178255:
178256: fnd_file.put_line(fnd_file.LOG, ' ');
178257: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
178258: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );
178259: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');
178260:
178261: FOR line_record IN line_cur(l_first_event_id, l_last_event_id)

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

178254: l_last_event_id := l_array_header_events(l_array_header_events.LAST);
178255:
178256: fnd_file.put_line(fnd_file.LOG, ' ');
178257: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
178258: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );
178259: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');
178260:
178261: FOR line_record IN line_cur(l_first_event_id, l_last_event_id)
178262: LOOP

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

178255:
178256: fnd_file.put_line(fnd_file.LOG, ' ');
178257: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
178258: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );
178259: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');
178260:
178261: FOR line_record IN line_cur(l_first_event_id, l_last_event_id)
178262: LOOP
178263: IF (NOT l_array_header_events.EXISTS(line_record.event_id)) AND (NOT l_array_duplicate_checker.EXISTS(line_record.event_id)) THEN

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

178260:
178261: FOR line_record IN line_cur(l_first_event_id, l_last_event_id)
178262: LOOP
178263: IF (NOT l_array_header_events.EXISTS(line_record.event_id)) AND (NOT l_array_duplicate_checker.EXISTS(line_record.event_id)) THEN
178264: fnd_file.put_line(fnd_file.log, 'Event_id = ' || line_record.event_id);
178265: l_array_duplicate_checker(line_record.event_id) := line_record.event_id;
178266: END IF;
178267: END LOOP;
178268:

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

178265: l_array_duplicate_checker(line_record.event_id) := line_record.event_id;
178266: END IF;
178267: END LOOP;
178268:
178269: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
178270: fnd_file.put_line(fnd_file.LOG, ' ');
178271:
178272:
178273: xla_exceptions_pkg.raise_message

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

178266: END IF;
178267: END LOOP;
178268:
178269: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
178270: fnd_file.put_line(fnd_file.LOG, ' ');
178271:
178272:
178273: xla_exceptions_pkg.raise_message
178274: (p_location => 'XLA_00707_AAD_S_000007_PKG.EventType_279');

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

179662:
179663: l_first_event_id := l_array_header_events(l_array_header_events.FIRST);
179664: l_last_event_id := l_array_header_events(l_array_header_events.LAST);
179665:
179666: fnd_file.put_line(fnd_file.LOG, ' ');
179667: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
179668: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );
179669: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');
179670:

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

179663: l_first_event_id := l_array_header_events(l_array_header_events.FIRST);
179664: l_last_event_id := l_array_header_events(l_array_header_events.LAST);
179665:
179666: fnd_file.put_line(fnd_file.LOG, ' ');
179667: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
179668: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );
179669: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');
179670:
179671: FOR line_record IN line_cur(l_first_event_id, l_last_event_id)

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

179664: l_last_event_id := l_array_header_events(l_array_header_events.LAST);
179665:
179666: fnd_file.put_line(fnd_file.LOG, ' ');
179667: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
179668: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );
179669: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');
179670:
179671: FOR line_record IN line_cur(l_first_event_id, l_last_event_id)
179672: LOOP

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

179665:
179666: fnd_file.put_line(fnd_file.LOG, ' ');
179667: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
179668: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );
179669: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');
179670:
179671: FOR line_record IN line_cur(l_first_event_id, l_last_event_id)
179672: LOOP
179673: IF (NOT l_array_header_events.EXISTS(line_record.event_id)) AND (NOT l_array_duplicate_checker.EXISTS(line_record.event_id)) THEN

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

179670:
179671: FOR line_record IN line_cur(l_first_event_id, l_last_event_id)
179672: LOOP
179673: IF (NOT l_array_header_events.EXISTS(line_record.event_id)) AND (NOT l_array_duplicate_checker.EXISTS(line_record.event_id)) THEN
179674: fnd_file.put_line(fnd_file.log, 'Event_id = ' || line_record.event_id);
179675: l_array_duplicate_checker(line_record.event_id) := line_record.event_id;
179676: END IF;
179677: END LOOP;
179678:

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

179675: l_array_duplicate_checker(line_record.event_id) := line_record.event_id;
179676: END IF;
179677: END LOOP;
179678:
179679: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
179680: fnd_file.put_line(fnd_file.LOG, ' ');
179681:
179682:
179683: xla_exceptions_pkg.raise_message

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

179676: END IF;
179677: END LOOP;
179678:
179679: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
179680: fnd_file.put_line(fnd_file.LOG, ' ');
179681:
179682:
179683: xla_exceptions_pkg.raise_message
179684: (p_location => 'XLA_00707_AAD_S_000007_PKG.EventType_280');

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

181072:
181073: l_first_event_id := l_array_header_events(l_array_header_events.FIRST);
181074: l_last_event_id := l_array_header_events(l_array_header_events.LAST);
181075:
181076: fnd_file.put_line(fnd_file.LOG, ' ');
181077: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
181078: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );
181079: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');
181080:

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

181073: l_first_event_id := l_array_header_events(l_array_header_events.FIRST);
181074: l_last_event_id := l_array_header_events(l_array_header_events.LAST);
181075:
181076: fnd_file.put_line(fnd_file.LOG, ' ');
181077: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
181078: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );
181079: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');
181080:
181081: FOR line_record IN line_cur(l_first_event_id, l_last_event_id)

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

181074: l_last_event_id := l_array_header_events(l_array_header_events.LAST);
181075:
181076: fnd_file.put_line(fnd_file.LOG, ' ');
181077: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
181078: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );
181079: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');
181080:
181081: FOR line_record IN line_cur(l_first_event_id, l_last_event_id)
181082: LOOP

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

181075:
181076: fnd_file.put_line(fnd_file.LOG, ' ');
181077: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
181078: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );
181079: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');
181080:
181081: FOR line_record IN line_cur(l_first_event_id, l_last_event_id)
181082: LOOP
181083: IF (NOT l_array_header_events.EXISTS(line_record.event_id)) AND (NOT l_array_duplicate_checker.EXISTS(line_record.event_id)) THEN

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

181080:
181081: FOR line_record IN line_cur(l_first_event_id, l_last_event_id)
181082: LOOP
181083: IF (NOT l_array_header_events.EXISTS(line_record.event_id)) AND (NOT l_array_duplicate_checker.EXISTS(line_record.event_id)) THEN
181084: fnd_file.put_line(fnd_file.log, 'Event_id = ' || line_record.event_id);
181085: l_array_duplicate_checker(line_record.event_id) := line_record.event_id;
181086: END IF;
181087: END LOOP;
181088:

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

181085: l_array_duplicate_checker(line_record.event_id) := line_record.event_id;
181086: END IF;
181087: END LOOP;
181088:
181089: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
181090: fnd_file.put_line(fnd_file.LOG, ' ');
181091:
181092:
181093: xla_exceptions_pkg.raise_message

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

181086: END IF;
181087: END LOOP;
181088:
181089: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
181090: fnd_file.put_line(fnd_file.LOG, ' ');
181091:
181092:
181093: xla_exceptions_pkg.raise_message
181094: (p_location => 'XLA_00707_AAD_S_000007_PKG.EventType_281');

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

182482:
182483: l_first_event_id := l_array_header_events(l_array_header_events.FIRST);
182484: l_last_event_id := l_array_header_events(l_array_header_events.LAST);
182485:
182486: fnd_file.put_line(fnd_file.LOG, ' ');
182487: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
182488: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );
182489: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');
182490:

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

182483: l_first_event_id := l_array_header_events(l_array_header_events.FIRST);
182484: l_last_event_id := l_array_header_events(l_array_header_events.LAST);
182485:
182486: fnd_file.put_line(fnd_file.LOG, ' ');
182487: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
182488: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );
182489: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');
182490:
182491: FOR line_record IN line_cur(l_first_event_id, l_last_event_id)

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

182484: l_last_event_id := l_array_header_events(l_array_header_events.LAST);
182485:
182486: fnd_file.put_line(fnd_file.LOG, ' ');
182487: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
182488: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );
182489: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');
182490:
182491: FOR line_record IN line_cur(l_first_event_id, l_last_event_id)
182492: LOOP

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

182485:
182486: fnd_file.put_line(fnd_file.LOG, ' ');
182487: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
182488: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );
182489: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');
182490:
182491: FOR line_record IN line_cur(l_first_event_id, l_last_event_id)
182492: LOOP
182493: IF (NOT l_array_header_events.EXISTS(line_record.event_id)) AND (NOT l_array_duplicate_checker.EXISTS(line_record.event_id)) THEN

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

182490:
182491: FOR line_record IN line_cur(l_first_event_id, l_last_event_id)
182492: LOOP
182493: IF (NOT l_array_header_events.EXISTS(line_record.event_id)) AND (NOT l_array_duplicate_checker.EXISTS(line_record.event_id)) THEN
182494: fnd_file.put_line(fnd_file.log, 'Event_id = ' || line_record.event_id);
182495: l_array_duplicate_checker(line_record.event_id) := line_record.event_id;
182496: END IF;
182497: END LOOP;
182498:

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

182495: l_array_duplicate_checker(line_record.event_id) := line_record.event_id;
182496: END IF;
182497: END LOOP;
182498:
182499: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
182500: fnd_file.put_line(fnd_file.LOG, ' ');
182501:
182502:
182503: xla_exceptions_pkg.raise_message

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

182496: END IF;
182497: END LOOP;
182498:
182499: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
182500: fnd_file.put_line(fnd_file.LOG, ' ');
182501:
182502:
182503: xla_exceptions_pkg.raise_message
182504: (p_location => 'XLA_00707_AAD_S_000007_PKG.EventType_282');

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

183718:
183719: l_first_event_id := l_array_header_events(l_array_header_events.FIRST);
183720: l_last_event_id := l_array_header_events(l_array_header_events.LAST);
183721:
183722: fnd_file.put_line(fnd_file.LOG, ' ');
183723: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
183724: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );
183725: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');
183726:

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

183719: l_first_event_id := l_array_header_events(l_array_header_events.FIRST);
183720: l_last_event_id := l_array_header_events(l_array_header_events.LAST);
183721:
183722: fnd_file.put_line(fnd_file.LOG, ' ');
183723: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
183724: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );
183725: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');
183726:
183727: FOR line_record IN line_cur(l_first_event_id, l_last_event_id)

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

183720: l_last_event_id := l_array_header_events(l_array_header_events.LAST);
183721:
183722: fnd_file.put_line(fnd_file.LOG, ' ');
183723: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
183724: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );
183725: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');
183726:
183727: FOR line_record IN line_cur(l_first_event_id, l_last_event_id)
183728: LOOP

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

183721:
183722: fnd_file.put_line(fnd_file.LOG, ' ');
183723: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
183724: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );
183725: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');
183726:
183727: FOR line_record IN line_cur(l_first_event_id, l_last_event_id)
183728: LOOP
183729: IF (NOT l_array_header_events.EXISTS(line_record.event_id)) AND (NOT l_array_duplicate_checker.EXISTS(line_record.event_id)) THEN

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

183726:
183727: FOR line_record IN line_cur(l_first_event_id, l_last_event_id)
183728: LOOP
183729: IF (NOT l_array_header_events.EXISTS(line_record.event_id)) AND (NOT l_array_duplicate_checker.EXISTS(line_record.event_id)) THEN
183730: fnd_file.put_line(fnd_file.log, 'Event_id = ' || line_record.event_id);
183731: l_array_duplicate_checker(line_record.event_id) := line_record.event_id;
183732: END IF;
183733: END LOOP;
183734:

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

183731: l_array_duplicate_checker(line_record.event_id) := line_record.event_id;
183732: END IF;
183733: END LOOP;
183734:
183735: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
183736: fnd_file.put_line(fnd_file.LOG, ' ');
183737:
183738:
183739: xla_exceptions_pkg.raise_message

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

183732: END IF;
183733: END LOOP;
183734:
183735: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
183736: fnd_file.put_line(fnd_file.LOG, ' ');
183737:
183738:
183739: xla_exceptions_pkg.raise_message
183740: (p_location => 'XLA_00707_AAD_S_000007_PKG.EventType_283');

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

185128:
185129: l_first_event_id := l_array_header_events(l_array_header_events.FIRST);
185130: l_last_event_id := l_array_header_events(l_array_header_events.LAST);
185131:
185132: fnd_file.put_line(fnd_file.LOG, ' ');
185133: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
185134: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );
185135: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');
185136:

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

185129: l_first_event_id := l_array_header_events(l_array_header_events.FIRST);
185130: l_last_event_id := l_array_header_events(l_array_header_events.LAST);
185131:
185132: fnd_file.put_line(fnd_file.LOG, ' ');
185133: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
185134: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );
185135: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');
185136:
185137: FOR line_record IN line_cur(l_first_event_id, l_last_event_id)

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

185130: l_last_event_id := l_array_header_events(l_array_header_events.LAST);
185131:
185132: fnd_file.put_line(fnd_file.LOG, ' ');
185133: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
185134: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );
185135: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');
185136:
185137: FOR line_record IN line_cur(l_first_event_id, l_last_event_id)
185138: LOOP

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

185131:
185132: fnd_file.put_line(fnd_file.LOG, ' ');
185133: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
185134: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );
185135: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');
185136:
185137: FOR line_record IN line_cur(l_first_event_id, l_last_event_id)
185138: LOOP
185139: IF (NOT l_array_header_events.EXISTS(line_record.event_id)) AND (NOT l_array_duplicate_checker.EXISTS(line_record.event_id)) THEN

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

185136:
185137: FOR line_record IN line_cur(l_first_event_id, l_last_event_id)
185138: LOOP
185139: IF (NOT l_array_header_events.EXISTS(line_record.event_id)) AND (NOT l_array_duplicate_checker.EXISTS(line_record.event_id)) THEN
185140: fnd_file.put_line(fnd_file.log, 'Event_id = ' || line_record.event_id);
185141: l_array_duplicate_checker(line_record.event_id) := line_record.event_id;
185142: END IF;
185143: END LOOP;
185144:

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

185141: l_array_duplicate_checker(line_record.event_id) := line_record.event_id;
185142: END IF;
185143: END LOOP;
185144:
185145: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
185146: fnd_file.put_line(fnd_file.LOG, ' ');
185147:
185148:
185149: xla_exceptions_pkg.raise_message

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

185142: END IF;
185143: END LOOP;
185144:
185145: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
185146: fnd_file.put_line(fnd_file.LOG, ' ');
185147:
185148:
185149: xla_exceptions_pkg.raise_message
185150: (p_location => 'XLA_00707_AAD_S_000007_PKG.EventType_284');

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

186538:
186539: l_first_event_id := l_array_header_events(l_array_header_events.FIRST);
186540: l_last_event_id := l_array_header_events(l_array_header_events.LAST);
186541:
186542: fnd_file.put_line(fnd_file.LOG, ' ');
186543: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
186544: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );
186545: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');
186546:

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

186539: l_first_event_id := l_array_header_events(l_array_header_events.FIRST);
186540: l_last_event_id := l_array_header_events(l_array_header_events.LAST);
186541:
186542: fnd_file.put_line(fnd_file.LOG, ' ');
186543: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
186544: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );
186545: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');
186546:
186547: FOR line_record IN line_cur(l_first_event_id, l_last_event_id)

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

186540: l_last_event_id := l_array_header_events(l_array_header_events.LAST);
186541:
186542: fnd_file.put_line(fnd_file.LOG, ' ');
186543: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
186544: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );
186545: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');
186546:
186547: FOR line_record IN line_cur(l_first_event_id, l_last_event_id)
186548: LOOP

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

186541:
186542: fnd_file.put_line(fnd_file.LOG, ' ');
186543: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
186544: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );
186545: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');
186546:
186547: FOR line_record IN line_cur(l_first_event_id, l_last_event_id)
186548: LOOP
186549: IF (NOT l_array_header_events.EXISTS(line_record.event_id)) AND (NOT l_array_duplicate_checker.EXISTS(line_record.event_id)) THEN

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

186546:
186547: FOR line_record IN line_cur(l_first_event_id, l_last_event_id)
186548: LOOP
186549: IF (NOT l_array_header_events.EXISTS(line_record.event_id)) AND (NOT l_array_duplicate_checker.EXISTS(line_record.event_id)) THEN
186550: fnd_file.put_line(fnd_file.log, 'Event_id = ' || line_record.event_id);
186551: l_array_duplicate_checker(line_record.event_id) := line_record.event_id;
186552: END IF;
186553: END LOOP;
186554:

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

186551: l_array_duplicate_checker(line_record.event_id) := line_record.event_id;
186552: END IF;
186553: END LOOP;
186554:
186555: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
186556: fnd_file.put_line(fnd_file.LOG, ' ');
186557:
186558:
186559: xla_exceptions_pkg.raise_message

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

186552: END IF;
186553: END LOOP;
186554:
186555: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
186556: fnd_file.put_line(fnd_file.LOG, ' ');
186557:
186558:
186559: xla_exceptions_pkg.raise_message
186560: (p_location => 'XLA_00707_AAD_S_000007_PKG.EventType_285');

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

187861:
187862: l_first_event_id := l_array_header_events(l_array_header_events.FIRST);
187863: l_last_event_id := l_array_header_events(l_array_header_events.LAST);
187864:
187865: fnd_file.put_line(fnd_file.LOG, ' ');
187866: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
187867: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );
187868: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');
187869:

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

187862: l_first_event_id := l_array_header_events(l_array_header_events.FIRST);
187863: l_last_event_id := l_array_header_events(l_array_header_events.LAST);
187864:
187865: fnd_file.put_line(fnd_file.LOG, ' ');
187866: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
187867: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );
187868: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');
187869:
187870: FOR line_record IN line_cur(l_first_event_id, l_last_event_id)

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

187863: l_last_event_id := l_array_header_events(l_array_header_events.LAST);
187864:
187865: fnd_file.put_line(fnd_file.LOG, ' ');
187866: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
187867: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );
187868: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');
187869:
187870: FOR line_record IN line_cur(l_first_event_id, l_last_event_id)
187871: LOOP

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

187864:
187865: fnd_file.put_line(fnd_file.LOG, ' ');
187866: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
187867: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );
187868: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');
187869:
187870: FOR line_record IN line_cur(l_first_event_id, l_last_event_id)
187871: LOOP
187872: IF (NOT l_array_header_events.EXISTS(line_record.event_id)) AND (NOT l_array_duplicate_checker.EXISTS(line_record.event_id)) THEN

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

187869:
187870: FOR line_record IN line_cur(l_first_event_id, l_last_event_id)
187871: LOOP
187872: IF (NOT l_array_header_events.EXISTS(line_record.event_id)) AND (NOT l_array_duplicate_checker.EXISTS(line_record.event_id)) THEN
187873: fnd_file.put_line(fnd_file.log, 'Event_id = ' || line_record.event_id);
187874: l_array_duplicate_checker(line_record.event_id) := line_record.event_id;
187875: END IF;
187876: END LOOP;
187877:

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

187874: l_array_duplicate_checker(line_record.event_id) := line_record.event_id;
187875: END IF;
187876: END LOOP;
187877:
187878: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
187879: fnd_file.put_line(fnd_file.LOG, ' ');
187880:
187881:
187882: xla_exceptions_pkg.raise_message

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

187875: END IF;
187876: END LOOP;
187877:
187878: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
187879: fnd_file.put_line(fnd_file.LOG, ' ');
187880:
187881:
187882: xla_exceptions_pkg.raise_message
187883: (p_location => 'XLA_00707_AAD_S_000007_PKG.EventType_286');

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

189184:
189185: l_first_event_id := l_array_header_events(l_array_header_events.FIRST);
189186: l_last_event_id := l_array_header_events(l_array_header_events.LAST);
189187:
189188: fnd_file.put_line(fnd_file.LOG, ' ');
189189: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
189190: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );
189191: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');
189192:

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

189185: l_first_event_id := l_array_header_events(l_array_header_events.FIRST);
189186: l_last_event_id := l_array_header_events(l_array_header_events.LAST);
189187:
189188: fnd_file.put_line(fnd_file.LOG, ' ');
189189: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
189190: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );
189191: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');
189192:
189193: FOR line_record IN line_cur(l_first_event_id, l_last_event_id)

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

189186: l_last_event_id := l_array_header_events(l_array_header_events.LAST);
189187:
189188: fnd_file.put_line(fnd_file.LOG, ' ');
189189: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
189190: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );
189191: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');
189192:
189193: FOR line_record IN line_cur(l_first_event_id, l_last_event_id)
189194: LOOP

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

189187:
189188: fnd_file.put_line(fnd_file.LOG, ' ');
189189: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
189190: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );
189191: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');
189192:
189193: FOR line_record IN line_cur(l_first_event_id, l_last_event_id)
189194: LOOP
189195: IF (NOT l_array_header_events.EXISTS(line_record.event_id)) AND (NOT l_array_duplicate_checker.EXISTS(line_record.event_id)) THEN

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

189192:
189193: FOR line_record IN line_cur(l_first_event_id, l_last_event_id)
189194: LOOP
189195: IF (NOT l_array_header_events.EXISTS(line_record.event_id)) AND (NOT l_array_duplicate_checker.EXISTS(line_record.event_id)) THEN
189196: fnd_file.put_line(fnd_file.log, 'Event_id = ' || line_record.event_id);
189197: l_array_duplicate_checker(line_record.event_id) := line_record.event_id;
189198: END IF;
189199: END LOOP;
189200:

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

189197: l_array_duplicate_checker(line_record.event_id) := line_record.event_id;
189198: END IF;
189199: END LOOP;
189200:
189201: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
189202: fnd_file.put_line(fnd_file.LOG, ' ');
189203:
189204:
189205: xla_exceptions_pkg.raise_message

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

189198: END IF;
189199: END LOOP;
189200:
189201: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
189202: fnd_file.put_line(fnd_file.LOG, ' ');
189203:
189204:
189205: xla_exceptions_pkg.raise_message
189206: (p_location => 'XLA_00707_AAD_S_000007_PKG.EventType_287');

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

190449:
190450: l_first_event_id := l_array_header_events(l_array_header_events.FIRST);
190451: l_last_event_id := l_array_header_events(l_array_header_events.LAST);
190452:
190453: fnd_file.put_line(fnd_file.LOG, ' ');
190454: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
190455: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );
190456: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');
190457:

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

190450: l_first_event_id := l_array_header_events(l_array_header_events.FIRST);
190451: l_last_event_id := l_array_header_events(l_array_header_events.LAST);
190452:
190453: fnd_file.put_line(fnd_file.LOG, ' ');
190454: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
190455: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );
190456: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');
190457:
190458: FOR line_record IN line_cur(l_first_event_id, l_last_event_id)

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

190451: l_last_event_id := l_array_header_events(l_array_header_events.LAST);
190452:
190453: fnd_file.put_line(fnd_file.LOG, ' ');
190454: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
190455: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );
190456: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');
190457:
190458: FOR line_record IN line_cur(l_first_event_id, l_last_event_id)
190459: LOOP

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

190452:
190453: fnd_file.put_line(fnd_file.LOG, ' ');
190454: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
190455: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );
190456: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');
190457:
190458: FOR line_record IN line_cur(l_first_event_id, l_last_event_id)
190459: LOOP
190460: IF (NOT l_array_header_events.EXISTS(line_record.event_id)) AND (NOT l_array_duplicate_checker.EXISTS(line_record.event_id)) THEN

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

190457:
190458: FOR line_record IN line_cur(l_first_event_id, l_last_event_id)
190459: LOOP
190460: IF (NOT l_array_header_events.EXISTS(line_record.event_id)) AND (NOT l_array_duplicate_checker.EXISTS(line_record.event_id)) THEN
190461: fnd_file.put_line(fnd_file.log, 'Event_id = ' || line_record.event_id);
190462: l_array_duplicate_checker(line_record.event_id) := line_record.event_id;
190463: END IF;
190464: END LOOP;
190465:

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

190462: l_array_duplicate_checker(line_record.event_id) := line_record.event_id;
190463: END IF;
190464: END LOOP;
190465:
190466: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
190467: fnd_file.put_line(fnd_file.LOG, ' ');
190468:
190469:
190470: xla_exceptions_pkg.raise_message

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

190463: END IF;
190464: END LOOP;
190465:
190466: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
190467: fnd_file.put_line(fnd_file.LOG, ' ');
190468:
190469:
190470: xla_exceptions_pkg.raise_message
190471: (p_location => 'XLA_00707_AAD_S_000007_PKG.EventType_288');

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

191685:
191686: l_first_event_id := l_array_header_events(l_array_header_events.FIRST);
191687: l_last_event_id := l_array_header_events(l_array_header_events.LAST);
191688:
191689: fnd_file.put_line(fnd_file.LOG, ' ');
191690: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
191691: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );
191692: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');
191693:

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

191686: l_first_event_id := l_array_header_events(l_array_header_events.FIRST);
191687: l_last_event_id := l_array_header_events(l_array_header_events.LAST);
191688:
191689: fnd_file.put_line(fnd_file.LOG, ' ');
191690: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
191691: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );
191692: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');
191693:
191694: FOR line_record IN line_cur(l_first_event_id, l_last_event_id)

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

191687: l_last_event_id := l_array_header_events(l_array_header_events.LAST);
191688:
191689: fnd_file.put_line(fnd_file.LOG, ' ');
191690: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
191691: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );
191692: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');
191693:
191694: FOR line_record IN line_cur(l_first_event_id, l_last_event_id)
191695: LOOP

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

191688:
191689: fnd_file.put_line(fnd_file.LOG, ' ');
191690: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
191691: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );
191692: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');
191693:
191694: FOR line_record IN line_cur(l_first_event_id, l_last_event_id)
191695: LOOP
191696: IF (NOT l_array_header_events.EXISTS(line_record.event_id)) AND (NOT l_array_duplicate_checker.EXISTS(line_record.event_id)) THEN

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

191693:
191694: FOR line_record IN line_cur(l_first_event_id, l_last_event_id)
191695: LOOP
191696: IF (NOT l_array_header_events.EXISTS(line_record.event_id)) AND (NOT l_array_duplicate_checker.EXISTS(line_record.event_id)) THEN
191697: fnd_file.put_line(fnd_file.log, 'Event_id = ' || line_record.event_id);
191698: l_array_duplicate_checker(line_record.event_id) := line_record.event_id;
191699: END IF;
191700: END LOOP;
191701:

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

191698: l_array_duplicate_checker(line_record.event_id) := line_record.event_id;
191699: END IF;
191700: END LOOP;
191701:
191702: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
191703: fnd_file.put_line(fnd_file.LOG, ' ');
191704:
191705:
191706: xla_exceptions_pkg.raise_message

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

191699: END IF;
191700: END LOOP;
191701:
191702: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
191703: fnd_file.put_line(fnd_file.LOG, ' ');
191704:
191705:
191706: xla_exceptions_pkg.raise_message
191707: (p_location => 'XLA_00707_AAD_S_000007_PKG.EventType_289');

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

192921:
192922: l_first_event_id := l_array_header_events(l_array_header_events.FIRST);
192923: l_last_event_id := l_array_header_events(l_array_header_events.LAST);
192924:
192925: fnd_file.put_line(fnd_file.LOG, ' ');
192926: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
192927: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );
192928: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');
192929:

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

192922: l_first_event_id := l_array_header_events(l_array_header_events.FIRST);
192923: l_last_event_id := l_array_header_events(l_array_header_events.LAST);
192924:
192925: fnd_file.put_line(fnd_file.LOG, ' ');
192926: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
192927: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );
192928: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');
192929:
192930: FOR line_record IN line_cur(l_first_event_id, l_last_event_id)

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

192923: l_last_event_id := l_array_header_events(l_array_header_events.LAST);
192924:
192925: fnd_file.put_line(fnd_file.LOG, ' ');
192926: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
192927: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );
192928: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');
192929:
192930: FOR line_record IN line_cur(l_first_event_id, l_last_event_id)
192931: LOOP

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

192924:
192925: fnd_file.put_line(fnd_file.LOG, ' ');
192926: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
192927: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );
192928: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');
192929:
192930: FOR line_record IN line_cur(l_first_event_id, l_last_event_id)
192931: LOOP
192932: IF (NOT l_array_header_events.EXISTS(line_record.event_id)) AND (NOT l_array_duplicate_checker.EXISTS(line_record.event_id)) THEN

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

192929:
192930: FOR line_record IN line_cur(l_first_event_id, l_last_event_id)
192931: LOOP
192932: IF (NOT l_array_header_events.EXISTS(line_record.event_id)) AND (NOT l_array_duplicate_checker.EXISTS(line_record.event_id)) THEN
192933: fnd_file.put_line(fnd_file.log, 'Event_id = ' || line_record.event_id);
192934: l_array_duplicate_checker(line_record.event_id) := line_record.event_id;
192935: END IF;
192936: END LOOP;
192937:

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

192934: l_array_duplicate_checker(line_record.event_id) := line_record.event_id;
192935: END IF;
192936: END LOOP;
192937:
192938: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
192939: fnd_file.put_line(fnd_file.LOG, ' ');
192940:
192941:
192942: xla_exceptions_pkg.raise_message

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

192935: END IF;
192936: END LOOP;
192937:
192938: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
192939: fnd_file.put_line(fnd_file.LOG, ' ');
192940:
192941:
192942: xla_exceptions_pkg.raise_message
192943: (p_location => 'XLA_00707_AAD_S_000007_PKG.EventType_290');

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

194157:
194158: l_first_event_id := l_array_header_events(l_array_header_events.FIRST);
194159: l_last_event_id := l_array_header_events(l_array_header_events.LAST);
194160:
194161: fnd_file.put_line(fnd_file.LOG, ' ');
194162: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
194163: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );
194164: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');
194165:

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

194158: l_first_event_id := l_array_header_events(l_array_header_events.FIRST);
194159: l_last_event_id := l_array_header_events(l_array_header_events.LAST);
194160:
194161: fnd_file.put_line(fnd_file.LOG, ' ');
194162: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
194163: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );
194164: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');
194165:
194166: FOR line_record IN line_cur(l_first_event_id, l_last_event_id)

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

194159: l_last_event_id := l_array_header_events(l_array_header_events.LAST);
194160:
194161: fnd_file.put_line(fnd_file.LOG, ' ');
194162: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
194163: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );
194164: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');
194165:
194166: FOR line_record IN line_cur(l_first_event_id, l_last_event_id)
194167: LOOP

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

194160:
194161: fnd_file.put_line(fnd_file.LOG, ' ');
194162: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
194163: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );
194164: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');
194165:
194166: FOR line_record IN line_cur(l_first_event_id, l_last_event_id)
194167: LOOP
194168: IF (NOT l_array_header_events.EXISTS(line_record.event_id)) AND (NOT l_array_duplicate_checker.EXISTS(line_record.event_id)) THEN

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

194165:
194166: FOR line_record IN line_cur(l_first_event_id, l_last_event_id)
194167: LOOP
194168: IF (NOT l_array_header_events.EXISTS(line_record.event_id)) AND (NOT l_array_duplicate_checker.EXISTS(line_record.event_id)) THEN
194169: fnd_file.put_line(fnd_file.log, 'Event_id = ' || line_record.event_id);
194170: l_array_duplicate_checker(line_record.event_id) := line_record.event_id;
194171: END IF;
194172: END LOOP;
194173:

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

194170: l_array_duplicate_checker(line_record.event_id) := line_record.event_id;
194171: END IF;
194172: END LOOP;
194173:
194174: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
194175: fnd_file.put_line(fnd_file.LOG, ' ');
194176:
194177:
194178: xla_exceptions_pkg.raise_message

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

194171: END IF;
194172: END LOOP;
194173:
194174: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
194175: fnd_file.put_line(fnd_file.LOG, ' ');
194176:
194177:
194178: xla_exceptions_pkg.raise_message
194179: (p_location => 'XLA_00707_AAD_S_000007_PKG.EventType_291');

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

195368:
195369: l_first_event_id := l_array_header_events(l_array_header_events.FIRST);
195370: l_last_event_id := l_array_header_events(l_array_header_events.LAST);
195371:
195372: fnd_file.put_line(fnd_file.LOG, ' ');
195373: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
195374: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );
195375: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');
195376:

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

195369: l_first_event_id := l_array_header_events(l_array_header_events.FIRST);
195370: l_last_event_id := l_array_header_events(l_array_header_events.LAST);
195371:
195372: fnd_file.put_line(fnd_file.LOG, ' ');
195373: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
195374: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );
195375: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');
195376:
195377: FOR line_record IN line_cur(l_first_event_id, l_last_event_id)

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

195370: l_last_event_id := l_array_header_events(l_array_header_events.LAST);
195371:
195372: fnd_file.put_line(fnd_file.LOG, ' ');
195373: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
195374: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );
195375: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');
195376:
195377: FOR line_record IN line_cur(l_first_event_id, l_last_event_id)
195378: LOOP

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

195371:
195372: fnd_file.put_line(fnd_file.LOG, ' ');
195373: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
195374: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );
195375: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');
195376:
195377: FOR line_record IN line_cur(l_first_event_id, l_last_event_id)
195378: LOOP
195379: IF (NOT l_array_header_events.EXISTS(line_record.event_id)) AND (NOT l_array_duplicate_checker.EXISTS(line_record.event_id)) THEN

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

195376:
195377: FOR line_record IN line_cur(l_first_event_id, l_last_event_id)
195378: LOOP
195379: IF (NOT l_array_header_events.EXISTS(line_record.event_id)) AND (NOT l_array_duplicate_checker.EXISTS(line_record.event_id)) THEN
195380: fnd_file.put_line(fnd_file.log, 'Event_id = ' || line_record.event_id);
195381: l_array_duplicate_checker(line_record.event_id) := line_record.event_id;
195382: END IF;
195383: END LOOP;
195384:

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

195381: l_array_duplicate_checker(line_record.event_id) := line_record.event_id;
195382: END IF;
195383: END LOOP;
195384:
195385: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
195386: fnd_file.put_line(fnd_file.LOG, ' ');
195387:
195388:
195389: xla_exceptions_pkg.raise_message

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

195382: END IF;
195383: END LOOP;
195384:
195385: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
195386: fnd_file.put_line(fnd_file.LOG, ' ');
195387:
195388:
195389: xla_exceptions_pkg.raise_message
195390: (p_location => 'XLA_00707_AAD_S_000007_PKG.EventClass_292');

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

196579:
196580: l_first_event_id := l_array_header_events(l_array_header_events.FIRST);
196581: l_last_event_id := l_array_header_events(l_array_header_events.LAST);
196582:
196583: fnd_file.put_line(fnd_file.LOG, ' ');
196584: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
196585: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );
196586: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');
196587:

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

196580: l_first_event_id := l_array_header_events(l_array_header_events.FIRST);
196581: l_last_event_id := l_array_header_events(l_array_header_events.LAST);
196582:
196583: fnd_file.put_line(fnd_file.LOG, ' ');
196584: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
196585: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );
196586: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');
196587:
196588: FOR line_record IN line_cur(l_first_event_id, l_last_event_id)

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

196581: l_last_event_id := l_array_header_events(l_array_header_events.LAST);
196582:
196583: fnd_file.put_line(fnd_file.LOG, ' ');
196584: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
196585: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );
196586: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');
196587:
196588: FOR line_record IN line_cur(l_first_event_id, l_last_event_id)
196589: LOOP

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

196582:
196583: fnd_file.put_line(fnd_file.LOG, ' ');
196584: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
196585: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );
196586: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');
196587:
196588: FOR line_record IN line_cur(l_first_event_id, l_last_event_id)
196589: LOOP
196590: IF (NOT l_array_header_events.EXISTS(line_record.event_id)) AND (NOT l_array_duplicate_checker.EXISTS(line_record.event_id)) THEN

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

196587:
196588: FOR line_record IN line_cur(l_first_event_id, l_last_event_id)
196589: LOOP
196590: IF (NOT l_array_header_events.EXISTS(line_record.event_id)) AND (NOT l_array_duplicate_checker.EXISTS(line_record.event_id)) THEN
196591: fnd_file.put_line(fnd_file.log, 'Event_id = ' || line_record.event_id);
196592: l_array_duplicate_checker(line_record.event_id) := line_record.event_id;
196593: END IF;
196594: END LOOP;
196595:

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

196592: l_array_duplicate_checker(line_record.event_id) := line_record.event_id;
196593: END IF;
196594: END LOOP;
196595:
196596: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
196597: fnd_file.put_line(fnd_file.LOG, ' ');
196598:
196599:
196600: xla_exceptions_pkg.raise_message

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

196593: END IF;
196594: END LOOP;
196595:
196596: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
196597: fnd_file.put_line(fnd_file.LOG, ' ');
196598:
196599:
196600: xla_exceptions_pkg.raise_message
196601: (p_location => 'XLA_00707_AAD_S_000007_PKG.EventClass_293');

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

197790:
197791: l_first_event_id := l_array_header_events(l_array_header_events.FIRST);
197792: l_last_event_id := l_array_header_events(l_array_header_events.LAST);
197793:
197794: fnd_file.put_line(fnd_file.LOG, ' ');
197795: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
197796: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );
197797: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');
197798:

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

197791: l_first_event_id := l_array_header_events(l_array_header_events.FIRST);
197792: l_last_event_id := l_array_header_events(l_array_header_events.LAST);
197793:
197794: fnd_file.put_line(fnd_file.LOG, ' ');
197795: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
197796: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );
197797: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');
197798:
197799: FOR line_record IN line_cur(l_first_event_id, l_last_event_id)

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

197792: l_last_event_id := l_array_header_events(l_array_header_events.LAST);
197793:
197794: fnd_file.put_line(fnd_file.LOG, ' ');
197795: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
197796: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );
197797: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');
197798:
197799: FOR line_record IN line_cur(l_first_event_id, l_last_event_id)
197800: LOOP

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

197793:
197794: fnd_file.put_line(fnd_file.LOG, ' ');
197795: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
197796: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );
197797: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');
197798:
197799: FOR line_record IN line_cur(l_first_event_id, l_last_event_id)
197800: LOOP
197801: IF (NOT l_array_header_events.EXISTS(line_record.event_id)) AND (NOT l_array_duplicate_checker.EXISTS(line_record.event_id)) THEN

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

197798:
197799: FOR line_record IN line_cur(l_first_event_id, l_last_event_id)
197800: LOOP
197801: IF (NOT l_array_header_events.EXISTS(line_record.event_id)) AND (NOT l_array_duplicate_checker.EXISTS(line_record.event_id)) THEN
197802: fnd_file.put_line(fnd_file.log, 'Event_id = ' || line_record.event_id);
197803: l_array_duplicate_checker(line_record.event_id) := line_record.event_id;
197804: END IF;
197805: END LOOP;
197806:

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

197803: l_array_duplicate_checker(line_record.event_id) := line_record.event_id;
197804: END IF;
197805: END LOOP;
197806:
197807: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
197808: fnd_file.put_line(fnd_file.LOG, ' ');
197809:
197810:
197811: xla_exceptions_pkg.raise_message

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

197804: END IF;
197805: END LOOP;
197806:
197807: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
197808: fnd_file.put_line(fnd_file.LOG, ' ');
197809:
197810:
197811: xla_exceptions_pkg.raise_message
197812: (p_location => 'XLA_00707_AAD_S_000007_PKG.EventClass_294');

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

199084:
199085: l_first_event_id := l_array_header_events(l_array_header_events.FIRST);
199086: l_last_event_id := l_array_header_events(l_array_header_events.LAST);
199087:
199088: fnd_file.put_line(fnd_file.LOG, ' ');
199089: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
199090: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );
199091: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');
199092:

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

199085: l_first_event_id := l_array_header_events(l_array_header_events.FIRST);
199086: l_last_event_id := l_array_header_events(l_array_header_events.LAST);
199087:
199088: fnd_file.put_line(fnd_file.LOG, ' ');
199089: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
199090: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );
199091: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');
199092:
199093: FOR line_record IN line_cur(l_first_event_id, l_last_event_id)

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

199086: l_last_event_id := l_array_header_events(l_array_header_events.LAST);
199087:
199088: fnd_file.put_line(fnd_file.LOG, ' ');
199089: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
199090: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );
199091: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');
199092:
199093: FOR line_record IN line_cur(l_first_event_id, l_last_event_id)
199094: LOOP

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

199087:
199088: fnd_file.put_line(fnd_file.LOG, ' ');
199089: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
199090: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );
199091: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');
199092:
199093: FOR line_record IN line_cur(l_first_event_id, l_last_event_id)
199094: LOOP
199095: IF (NOT l_array_header_events.EXISTS(line_record.event_id)) AND (NOT l_array_duplicate_checker.EXISTS(line_record.event_id)) THEN

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

199092:
199093: FOR line_record IN line_cur(l_first_event_id, l_last_event_id)
199094: LOOP
199095: IF (NOT l_array_header_events.EXISTS(line_record.event_id)) AND (NOT l_array_duplicate_checker.EXISTS(line_record.event_id)) THEN
199096: fnd_file.put_line(fnd_file.log, 'Event_id = ' || line_record.event_id);
199097: l_array_duplicate_checker(line_record.event_id) := line_record.event_id;
199098: END IF;
199099: END LOOP;
199100:

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

199097: l_array_duplicate_checker(line_record.event_id) := line_record.event_id;
199098: END IF;
199099: END LOOP;
199100:
199101: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
199102: fnd_file.put_line(fnd_file.LOG, ' ');
199103:
199104:
199105: xla_exceptions_pkg.raise_message

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

199098: END IF;
199099: END LOOP;
199100:
199101: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
199102: fnd_file.put_line(fnd_file.LOG, ' ');
199103:
199104:
199105: xla_exceptions_pkg.raise_message
199106: (p_location => 'XLA_00707_AAD_S_000007_PKG.EventClass_295');