231603:
231604: l_first_event_id := l_array_header_events(l_array_header_events.FIRST);
231605: l_last_event_id := l_array_header_events(l_array_header_events.LAST);
231606:
231607: fnd_file.put_line(fnd_file.LOG, ' ');
231608: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
231609: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );
231610: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');
231611:
231604: l_first_event_id := l_array_header_events(l_array_header_events.FIRST);
231605: l_last_event_id := l_array_header_events(l_array_header_events.LAST);
231606:
231607: fnd_file.put_line(fnd_file.LOG, ' ');
231608: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
231609: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );
231610: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');
231611:
231612: FOR line_record IN line_cur(l_first_event_id, l_last_event_id)
231605: l_last_event_id := l_array_header_events(l_array_header_events.LAST);
231606:
231607: fnd_file.put_line(fnd_file.LOG, ' ');
231608: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
231609: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );
231610: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');
231611:
231612: FOR line_record IN line_cur(l_first_event_id, l_last_event_id)
231613: LOOP
231606:
231607: fnd_file.put_line(fnd_file.LOG, ' ');
231608: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
231609: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );
231610: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');
231611:
231612: FOR line_record IN line_cur(l_first_event_id, l_last_event_id)
231613: LOOP
231614: IF (NOT l_array_header_events.EXISTS(line_record.event_id)) AND (NOT l_array_duplicate_checker.EXISTS(line_record.event_id)) THEN
231611:
231612: FOR line_record IN line_cur(l_first_event_id, l_last_event_id)
231613: LOOP
231614: IF (NOT l_array_header_events.EXISTS(line_record.event_id)) AND (NOT l_array_duplicate_checker.EXISTS(line_record.event_id)) THEN
231615: fnd_file.put_line(fnd_file.log, 'Event_id = ' || line_record.event_id);
231616: l_array_duplicate_checker(line_record.event_id) := line_record.event_id;
231617: END IF;
231618: END LOOP;
231619:
231616: l_array_duplicate_checker(line_record.event_id) := line_record.event_id;
231617: END IF;
231618: END LOOP;
231619:
231620: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
231621: fnd_file.put_line(fnd_file.LOG, ' ');
231622:
231623:
231624: xla_exceptions_pkg.raise_message
231617: END IF;
231618: END LOOP;
231619:
231620: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
231621: fnd_file.put_line(fnd_file.LOG, ' ');
231622:
231623:
231624: xla_exceptions_pkg.raise_message
231625: (p_location => 'XLA_00140_AAD_S_000018_PKG.EventClass_507');
233533:
233534: l_first_event_id := l_array_header_events(l_array_header_events.FIRST);
233535: l_last_event_id := l_array_header_events(l_array_header_events.LAST);
233536:
233537: fnd_file.put_line(fnd_file.LOG, ' ');
233538: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
233539: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );
233540: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');
233541:
233534: l_first_event_id := l_array_header_events(l_array_header_events.FIRST);
233535: l_last_event_id := l_array_header_events(l_array_header_events.LAST);
233536:
233537: fnd_file.put_line(fnd_file.LOG, ' ');
233538: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
233539: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );
233540: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');
233541:
233542: FOR line_record IN line_cur(l_first_event_id, l_last_event_id)
233535: l_last_event_id := l_array_header_events(l_array_header_events.LAST);
233536:
233537: fnd_file.put_line(fnd_file.LOG, ' ');
233538: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
233539: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );
233540: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');
233541:
233542: FOR line_record IN line_cur(l_first_event_id, l_last_event_id)
233543: LOOP
233536:
233537: fnd_file.put_line(fnd_file.LOG, ' ');
233538: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
233539: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );
233540: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');
233541:
233542: FOR line_record IN line_cur(l_first_event_id, l_last_event_id)
233543: LOOP
233544: IF (NOT l_array_header_events.EXISTS(line_record.event_id)) AND (NOT l_array_duplicate_checker.EXISTS(line_record.event_id)) THEN
233541:
233542: FOR line_record IN line_cur(l_first_event_id, l_last_event_id)
233543: LOOP
233544: IF (NOT l_array_header_events.EXISTS(line_record.event_id)) AND (NOT l_array_duplicate_checker.EXISTS(line_record.event_id)) THEN
233545: fnd_file.put_line(fnd_file.log, 'Event_id = ' || line_record.event_id);
233546: l_array_duplicate_checker(line_record.event_id) := line_record.event_id;
233547: END IF;
233548: END LOOP;
233549:
233546: l_array_duplicate_checker(line_record.event_id) := line_record.event_id;
233547: END IF;
233548: END LOOP;
233549:
233550: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
233551: fnd_file.put_line(fnd_file.LOG, ' ');
233552:
233553:
233554: xla_exceptions_pkg.raise_message
233547: END IF;
233548: END LOOP;
233549:
233550: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
233551: fnd_file.put_line(fnd_file.LOG, ' ');
233552:
233553:
233554: xla_exceptions_pkg.raise_message
233555: (p_location => 'XLA_00140_AAD_S_000018_PKG.EventClass_508');
234950:
234951: l_first_event_id := l_array_header_events(l_array_header_events.FIRST);
234952: l_last_event_id := l_array_header_events(l_array_header_events.LAST);
234953:
234954: fnd_file.put_line(fnd_file.LOG, ' ');
234955: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
234956: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );
234957: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');
234958:
234951: l_first_event_id := l_array_header_events(l_array_header_events.FIRST);
234952: l_last_event_id := l_array_header_events(l_array_header_events.LAST);
234953:
234954: fnd_file.put_line(fnd_file.LOG, ' ');
234955: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
234956: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );
234957: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');
234958:
234959: FOR line_record IN line_cur(l_first_event_id, l_last_event_id)
234952: l_last_event_id := l_array_header_events(l_array_header_events.LAST);
234953:
234954: fnd_file.put_line(fnd_file.LOG, ' ');
234955: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
234956: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );
234957: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');
234958:
234959: FOR line_record IN line_cur(l_first_event_id, l_last_event_id)
234960: LOOP
234953:
234954: fnd_file.put_line(fnd_file.LOG, ' ');
234955: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
234956: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );
234957: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');
234958:
234959: FOR line_record IN line_cur(l_first_event_id, l_last_event_id)
234960: LOOP
234961: IF (NOT l_array_header_events.EXISTS(line_record.event_id)) AND (NOT l_array_duplicate_checker.EXISTS(line_record.event_id)) THEN
234958:
234959: FOR line_record IN line_cur(l_first_event_id, l_last_event_id)
234960: LOOP
234961: IF (NOT l_array_header_events.EXISTS(line_record.event_id)) AND (NOT l_array_duplicate_checker.EXISTS(line_record.event_id)) THEN
234962: fnd_file.put_line(fnd_file.log, 'Event_id = ' || line_record.event_id);
234963: l_array_duplicate_checker(line_record.event_id) := line_record.event_id;
234964: END IF;
234965: END LOOP;
234966:
234963: l_array_duplicate_checker(line_record.event_id) := line_record.event_id;
234964: END IF;
234965: END LOOP;
234966:
234967: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
234968: fnd_file.put_line(fnd_file.LOG, ' ');
234969:
234970:
234971: xla_exceptions_pkg.raise_message
234964: END IF;
234965: END LOOP;
234966:
234967: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
234968: fnd_file.put_line(fnd_file.LOG, ' ');
234969:
234970:
234971: xla_exceptions_pkg.raise_message
234972: (p_location => 'XLA_00140_AAD_S_000018_PKG.EventType_509');
236938:
236939: l_first_event_id := l_array_header_events(l_array_header_events.FIRST);
236940: l_last_event_id := l_array_header_events(l_array_header_events.LAST);
236941:
236942: fnd_file.put_line(fnd_file.LOG, ' ');
236943: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
236944: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );
236945: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');
236946:
236939: l_first_event_id := l_array_header_events(l_array_header_events.FIRST);
236940: l_last_event_id := l_array_header_events(l_array_header_events.LAST);
236941:
236942: fnd_file.put_line(fnd_file.LOG, ' ');
236943: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
236944: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );
236945: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');
236946:
236947: FOR line_record IN line_cur(l_first_event_id, l_last_event_id)
236940: l_last_event_id := l_array_header_events(l_array_header_events.LAST);
236941:
236942: fnd_file.put_line(fnd_file.LOG, ' ');
236943: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
236944: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );
236945: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');
236946:
236947: FOR line_record IN line_cur(l_first_event_id, l_last_event_id)
236948: LOOP
236941:
236942: fnd_file.put_line(fnd_file.LOG, ' ');
236943: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
236944: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );
236945: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');
236946:
236947: FOR line_record IN line_cur(l_first_event_id, l_last_event_id)
236948: LOOP
236949: IF (NOT l_array_header_events.EXISTS(line_record.event_id)) AND (NOT l_array_duplicate_checker.EXISTS(line_record.event_id)) THEN
236946:
236947: FOR line_record IN line_cur(l_first_event_id, l_last_event_id)
236948: LOOP
236949: IF (NOT l_array_header_events.EXISTS(line_record.event_id)) AND (NOT l_array_duplicate_checker.EXISTS(line_record.event_id)) THEN
236950: fnd_file.put_line(fnd_file.log, 'Event_id = ' || line_record.event_id);
236951: l_array_duplicate_checker(line_record.event_id) := line_record.event_id;
236952: END IF;
236953: END LOOP;
236954:
236951: l_array_duplicate_checker(line_record.event_id) := line_record.event_id;
236952: END IF;
236953: END LOOP;
236954:
236955: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
236956: fnd_file.put_line(fnd_file.LOG, ' ');
236957:
236958:
236959: xla_exceptions_pkg.raise_message
236952: END IF;
236953: END LOOP;
236954:
236955: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
236956: fnd_file.put_line(fnd_file.LOG, ' ');
236957:
236958:
236959: xla_exceptions_pkg.raise_message
236960: (p_location => 'XLA_00140_AAD_S_000018_PKG.EventClass_510');
238157:
238158: l_first_event_id := l_array_header_events(l_array_header_events.FIRST);
238159: l_last_event_id := l_array_header_events(l_array_header_events.LAST);
238160:
238161: fnd_file.put_line(fnd_file.LOG, ' ');
238162: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
238163: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );
238164: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');
238165:
238158: l_first_event_id := l_array_header_events(l_array_header_events.FIRST);
238159: l_last_event_id := l_array_header_events(l_array_header_events.LAST);
238160:
238161: fnd_file.put_line(fnd_file.LOG, ' ');
238162: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
238163: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );
238164: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');
238165:
238166: FOR line_record IN line_cur(l_first_event_id, l_last_event_id)
238159: l_last_event_id := l_array_header_events(l_array_header_events.LAST);
238160:
238161: fnd_file.put_line(fnd_file.LOG, ' ');
238162: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
238163: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );
238164: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');
238165:
238166: FOR line_record IN line_cur(l_first_event_id, l_last_event_id)
238167: LOOP
238160:
238161: fnd_file.put_line(fnd_file.LOG, ' ');
238162: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
238163: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );
238164: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');
238165:
238166: FOR line_record IN line_cur(l_first_event_id, l_last_event_id)
238167: LOOP
238168: IF (NOT l_array_header_events.EXISTS(line_record.event_id)) AND (NOT l_array_duplicate_checker.EXISTS(line_record.event_id)) THEN
238165:
238166: FOR line_record IN line_cur(l_first_event_id, l_last_event_id)
238167: LOOP
238168: IF (NOT l_array_header_events.EXISTS(line_record.event_id)) AND (NOT l_array_duplicate_checker.EXISTS(line_record.event_id)) THEN
238169: fnd_file.put_line(fnd_file.log, 'Event_id = ' || line_record.event_id);
238170: l_array_duplicate_checker(line_record.event_id) := line_record.event_id;
238171: END IF;
238172: END LOOP;
238173:
238170: l_array_duplicate_checker(line_record.event_id) := line_record.event_id;
238171: END IF;
238172: END LOOP;
238173:
238174: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
238175: fnd_file.put_line(fnd_file.LOG, ' ');
238176:
238177:
238178: xla_exceptions_pkg.raise_message
238171: END IF;
238172: END LOOP;
238173:
238174: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
238175: fnd_file.put_line(fnd_file.LOG, ' ');
238176:
238177:
238178: xla_exceptions_pkg.raise_message
238179: (p_location => 'XLA_00140_AAD_S_000018_PKG.EventClass_511');
239376:
239377: l_first_event_id := l_array_header_events(l_array_header_events.FIRST);
239378: l_last_event_id := l_array_header_events(l_array_header_events.LAST);
239379:
239380: fnd_file.put_line(fnd_file.LOG, ' ');
239381: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
239382: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );
239383: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');
239384:
239377: l_first_event_id := l_array_header_events(l_array_header_events.FIRST);
239378: l_last_event_id := l_array_header_events(l_array_header_events.LAST);
239379:
239380: fnd_file.put_line(fnd_file.LOG, ' ');
239381: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
239382: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );
239383: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');
239384:
239385: FOR line_record IN line_cur(l_first_event_id, l_last_event_id)
239378: l_last_event_id := l_array_header_events(l_array_header_events.LAST);
239379:
239380: fnd_file.put_line(fnd_file.LOG, ' ');
239381: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
239382: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );
239383: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');
239384:
239385: FOR line_record IN line_cur(l_first_event_id, l_last_event_id)
239386: LOOP
239379:
239380: fnd_file.put_line(fnd_file.LOG, ' ');
239381: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
239382: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );
239383: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');
239384:
239385: FOR line_record IN line_cur(l_first_event_id, l_last_event_id)
239386: LOOP
239387: IF (NOT l_array_header_events.EXISTS(line_record.event_id)) AND (NOT l_array_duplicate_checker.EXISTS(line_record.event_id)) THEN
239384:
239385: FOR line_record IN line_cur(l_first_event_id, l_last_event_id)
239386: LOOP
239387: IF (NOT l_array_header_events.EXISTS(line_record.event_id)) AND (NOT l_array_duplicate_checker.EXISTS(line_record.event_id)) THEN
239388: fnd_file.put_line(fnd_file.log, 'Event_id = ' || line_record.event_id);
239389: l_array_duplicate_checker(line_record.event_id) := line_record.event_id;
239390: END IF;
239391: END LOOP;
239392:
239389: l_array_duplicate_checker(line_record.event_id) := line_record.event_id;
239390: END IF;
239391: END LOOP;
239392:
239393: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
239394: fnd_file.put_line(fnd_file.LOG, ' ');
239395:
239396:
239397: xla_exceptions_pkg.raise_message
239390: END IF;
239391: END LOOP;
239392:
239393: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
239394: fnd_file.put_line(fnd_file.LOG, ' ');
239395:
239396:
239397: xla_exceptions_pkg.raise_message
239398: (p_location => 'XLA_00140_AAD_S_000018_PKG.EventClass_512');
240656:
240657: l_first_event_id := l_array_header_events(l_array_header_events.FIRST);
240658: l_last_event_id := l_array_header_events(l_array_header_events.LAST);
240659:
240660: fnd_file.put_line(fnd_file.LOG, ' ');
240661: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
240662: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );
240663: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');
240664:
240657: l_first_event_id := l_array_header_events(l_array_header_events.FIRST);
240658: l_last_event_id := l_array_header_events(l_array_header_events.LAST);
240659:
240660: fnd_file.put_line(fnd_file.LOG, ' ');
240661: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
240662: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );
240663: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');
240664:
240665: FOR line_record IN line_cur(l_first_event_id, l_last_event_id)
240658: l_last_event_id := l_array_header_events(l_array_header_events.LAST);
240659:
240660: fnd_file.put_line(fnd_file.LOG, ' ');
240661: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
240662: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );
240663: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');
240664:
240665: FOR line_record IN line_cur(l_first_event_id, l_last_event_id)
240666: LOOP
240659:
240660: fnd_file.put_line(fnd_file.LOG, ' ');
240661: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
240662: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );
240663: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');
240664:
240665: FOR line_record IN line_cur(l_first_event_id, l_last_event_id)
240666: LOOP
240667: IF (NOT l_array_header_events.EXISTS(line_record.event_id)) AND (NOT l_array_duplicate_checker.EXISTS(line_record.event_id)) THEN
240664:
240665: FOR line_record IN line_cur(l_first_event_id, l_last_event_id)
240666: LOOP
240667: IF (NOT l_array_header_events.EXISTS(line_record.event_id)) AND (NOT l_array_duplicate_checker.EXISTS(line_record.event_id)) THEN
240668: fnd_file.put_line(fnd_file.log, 'Event_id = ' || line_record.event_id);
240669: l_array_duplicate_checker(line_record.event_id) := line_record.event_id;
240670: END IF;
240671: END LOOP;
240672:
240669: l_array_duplicate_checker(line_record.event_id) := line_record.event_id;
240670: END IF;
240671: END LOOP;
240672:
240673: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
240674: fnd_file.put_line(fnd_file.LOG, ' ');
240675:
240676:
240677: xla_exceptions_pkg.raise_message
240670: END IF;
240671: END LOOP;
240672:
240673: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
240674: fnd_file.put_line(fnd_file.LOG, ' ');
240675:
240676:
240677: xla_exceptions_pkg.raise_message
240678: (p_location => 'XLA_00140_AAD_S_000018_PKG.EventClass_513');
242272:
242273: l_first_event_id := l_array_header_events(l_array_header_events.FIRST);
242274: l_last_event_id := l_array_header_events(l_array_header_events.LAST);
242275:
242276: fnd_file.put_line(fnd_file.LOG, ' ');
242277: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
242278: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );
242279: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');
242280:
242273: l_first_event_id := l_array_header_events(l_array_header_events.FIRST);
242274: l_last_event_id := l_array_header_events(l_array_header_events.LAST);
242275:
242276: fnd_file.put_line(fnd_file.LOG, ' ');
242277: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
242278: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );
242279: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');
242280:
242281: FOR line_record IN line_cur(l_first_event_id, l_last_event_id)
242274: l_last_event_id := l_array_header_events(l_array_header_events.LAST);
242275:
242276: fnd_file.put_line(fnd_file.LOG, ' ');
242277: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
242278: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );
242279: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');
242280:
242281: FOR line_record IN line_cur(l_first_event_id, l_last_event_id)
242282: LOOP
242275:
242276: fnd_file.put_line(fnd_file.LOG, ' ');
242277: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
242278: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );
242279: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');
242280:
242281: FOR line_record IN line_cur(l_first_event_id, l_last_event_id)
242282: LOOP
242283: IF (NOT l_array_header_events.EXISTS(line_record.event_id)) AND (NOT l_array_duplicate_checker.EXISTS(line_record.event_id)) THEN
242280:
242281: FOR line_record IN line_cur(l_first_event_id, l_last_event_id)
242282: LOOP
242283: IF (NOT l_array_header_events.EXISTS(line_record.event_id)) AND (NOT l_array_duplicate_checker.EXISTS(line_record.event_id)) THEN
242284: fnd_file.put_line(fnd_file.log, 'Event_id = ' || line_record.event_id);
242285: l_array_duplicate_checker(line_record.event_id) := line_record.event_id;
242286: END IF;
242287: END LOOP;
242288:
242285: l_array_duplicate_checker(line_record.event_id) := line_record.event_id;
242286: END IF;
242287: END LOOP;
242288:
242289: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
242290: fnd_file.put_line(fnd_file.LOG, ' ');
242291:
242292:
242293: xla_exceptions_pkg.raise_message
242286: END IF;
242287: END LOOP;
242288:
242289: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
242290: fnd_file.put_line(fnd_file.LOG, ' ');
242291:
242292:
242293: xla_exceptions_pkg.raise_message
242294: (p_location => 'XLA_00140_AAD_S_000018_PKG.EventType_514');
243898:
243899: l_first_event_id := l_array_header_events(l_array_header_events.FIRST);
243900: l_last_event_id := l_array_header_events(l_array_header_events.LAST);
243901:
243902: fnd_file.put_line(fnd_file.LOG, ' ');
243903: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
243904: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );
243905: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');
243906:
243899: l_first_event_id := l_array_header_events(l_array_header_events.FIRST);
243900: l_last_event_id := l_array_header_events(l_array_header_events.LAST);
243901:
243902: fnd_file.put_line(fnd_file.LOG, ' ');
243903: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
243904: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );
243905: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');
243906:
243907: FOR line_record IN line_cur(l_first_event_id, l_last_event_id)
243900: l_last_event_id := l_array_header_events(l_array_header_events.LAST);
243901:
243902: fnd_file.put_line(fnd_file.LOG, ' ');
243903: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
243904: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );
243905: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');
243906:
243907: FOR line_record IN line_cur(l_first_event_id, l_last_event_id)
243908: LOOP
243901:
243902: fnd_file.put_line(fnd_file.LOG, ' ');
243903: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
243904: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );
243905: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');
243906:
243907: FOR line_record IN line_cur(l_first_event_id, l_last_event_id)
243908: LOOP
243909: IF (NOT l_array_header_events.EXISTS(line_record.event_id)) AND (NOT l_array_duplicate_checker.EXISTS(line_record.event_id)) THEN
243906:
243907: FOR line_record IN line_cur(l_first_event_id, l_last_event_id)
243908: LOOP
243909: IF (NOT l_array_header_events.EXISTS(line_record.event_id)) AND (NOT l_array_duplicate_checker.EXISTS(line_record.event_id)) THEN
243910: fnd_file.put_line(fnd_file.log, 'Event_id = ' || line_record.event_id);
243911: l_array_duplicate_checker(line_record.event_id) := line_record.event_id;
243912: END IF;
243913: END LOOP;
243914:
243911: l_array_duplicate_checker(line_record.event_id) := line_record.event_id;
243912: END IF;
243913: END LOOP;
243914:
243915: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
243916: fnd_file.put_line(fnd_file.LOG, ' ');
243917:
243918:
243919: xla_exceptions_pkg.raise_message
243912: END IF;
243913: END LOOP;
243914:
243915: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
243916: fnd_file.put_line(fnd_file.LOG, ' ');
243917:
243918:
243919: xla_exceptions_pkg.raise_message
243920: (p_location => 'XLA_00140_AAD_S_000018_PKG.EventType_515');
245117:
245118: l_first_event_id := l_array_header_events(l_array_header_events.FIRST);
245119: l_last_event_id := l_array_header_events(l_array_header_events.LAST);
245120:
245121: fnd_file.put_line(fnd_file.LOG, ' ');
245122: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
245123: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );
245124: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');
245125:
245118: l_first_event_id := l_array_header_events(l_array_header_events.FIRST);
245119: l_last_event_id := l_array_header_events(l_array_header_events.LAST);
245120:
245121: fnd_file.put_line(fnd_file.LOG, ' ');
245122: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
245123: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );
245124: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');
245125:
245126: FOR line_record IN line_cur(l_first_event_id, l_last_event_id)
245119: l_last_event_id := l_array_header_events(l_array_header_events.LAST);
245120:
245121: fnd_file.put_line(fnd_file.LOG, ' ');
245122: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
245123: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );
245124: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');
245125:
245126: FOR line_record IN line_cur(l_first_event_id, l_last_event_id)
245127: LOOP
245120:
245121: fnd_file.put_line(fnd_file.LOG, ' ');
245122: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
245123: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );
245124: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');
245125:
245126: FOR line_record IN line_cur(l_first_event_id, l_last_event_id)
245127: LOOP
245128: IF (NOT l_array_header_events.EXISTS(line_record.event_id)) AND (NOT l_array_duplicate_checker.EXISTS(line_record.event_id)) THEN
245125:
245126: FOR line_record IN line_cur(l_first_event_id, l_last_event_id)
245127: LOOP
245128: IF (NOT l_array_header_events.EXISTS(line_record.event_id)) AND (NOT l_array_duplicate_checker.EXISTS(line_record.event_id)) THEN
245129: fnd_file.put_line(fnd_file.log, 'Event_id = ' || line_record.event_id);
245130: l_array_duplicate_checker(line_record.event_id) := line_record.event_id;
245131: END IF;
245132: END LOOP;
245133:
245130: l_array_duplicate_checker(line_record.event_id) := line_record.event_id;
245131: END IF;
245132: END LOOP;
245133:
245134: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
245135: fnd_file.put_line(fnd_file.LOG, ' ');
245136:
245137:
245138: xla_exceptions_pkg.raise_message
245131: END IF;
245132: END LOOP;
245133:
245134: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
245135: fnd_file.put_line(fnd_file.LOG, ' ');
245136:
245137:
245138: xla_exceptions_pkg.raise_message
245139: (p_location => 'XLA_00140_AAD_S_000018_PKG.EventClass_516');
246566:
246567: l_first_event_id := l_array_header_events(l_array_header_events.FIRST);
246568: l_last_event_id := l_array_header_events(l_array_header_events.LAST);
246569:
246570: fnd_file.put_line(fnd_file.LOG, ' ');
246571: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
246572: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );
246573: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');
246574:
246567: l_first_event_id := l_array_header_events(l_array_header_events.FIRST);
246568: l_last_event_id := l_array_header_events(l_array_header_events.LAST);
246569:
246570: fnd_file.put_line(fnd_file.LOG, ' ');
246571: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
246572: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );
246573: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');
246574:
246575: FOR line_record IN line_cur(l_first_event_id, l_last_event_id)
246568: l_last_event_id := l_array_header_events(l_array_header_events.LAST);
246569:
246570: fnd_file.put_line(fnd_file.LOG, ' ');
246571: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
246572: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );
246573: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');
246574:
246575: FOR line_record IN line_cur(l_first_event_id, l_last_event_id)
246576: LOOP
246569:
246570: fnd_file.put_line(fnd_file.LOG, ' ');
246571: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
246572: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );
246573: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');
246574:
246575: FOR line_record IN line_cur(l_first_event_id, l_last_event_id)
246576: LOOP
246577: IF (NOT l_array_header_events.EXISTS(line_record.event_id)) AND (NOT l_array_duplicate_checker.EXISTS(line_record.event_id)) THEN
246574:
246575: FOR line_record IN line_cur(l_first_event_id, l_last_event_id)
246576: LOOP
246577: IF (NOT l_array_header_events.EXISTS(line_record.event_id)) AND (NOT l_array_duplicate_checker.EXISTS(line_record.event_id)) THEN
246578: fnd_file.put_line(fnd_file.log, 'Event_id = ' || line_record.event_id);
246579: l_array_duplicate_checker(line_record.event_id) := line_record.event_id;
246580: END IF;
246581: END LOOP;
246582:
246579: l_array_duplicate_checker(line_record.event_id) := line_record.event_id;
246580: END IF;
246581: END LOOP;
246582:
246583: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
246584: fnd_file.put_line(fnd_file.LOG, ' ');
246585:
246586:
246587: xla_exceptions_pkg.raise_message
246580: END IF;
246581: END LOOP;
246582:
246583: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
246584: fnd_file.put_line(fnd_file.LOG, ' ');
246585:
246586:
246587: xla_exceptions_pkg.raise_message
246588: (p_location => 'XLA_00140_AAD_S_000018_PKG.EventClass_517');
247934:
247935: l_first_event_id := l_array_header_events(l_array_header_events.FIRST);
247936: l_last_event_id := l_array_header_events(l_array_header_events.LAST);
247937:
247938: fnd_file.put_line(fnd_file.LOG, ' ');
247939: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
247940: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );
247941: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');
247942:
247935: l_first_event_id := l_array_header_events(l_array_header_events.FIRST);
247936: l_last_event_id := l_array_header_events(l_array_header_events.LAST);
247937:
247938: fnd_file.put_line(fnd_file.LOG, ' ');
247939: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
247940: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );
247941: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');
247942:
247943: FOR line_record IN line_cur(l_first_event_id, l_last_event_id)
247936: l_last_event_id := l_array_header_events(l_array_header_events.LAST);
247937:
247938: fnd_file.put_line(fnd_file.LOG, ' ');
247939: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
247940: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );
247941: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');
247942:
247943: FOR line_record IN line_cur(l_first_event_id, l_last_event_id)
247944: LOOP
247937:
247938: fnd_file.put_line(fnd_file.LOG, ' ');
247939: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
247940: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );
247941: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');
247942:
247943: FOR line_record IN line_cur(l_first_event_id, l_last_event_id)
247944: LOOP
247945: IF (NOT l_array_header_events.EXISTS(line_record.event_id)) AND (NOT l_array_duplicate_checker.EXISTS(line_record.event_id)) THEN
247942:
247943: FOR line_record IN line_cur(l_first_event_id, l_last_event_id)
247944: LOOP
247945: IF (NOT l_array_header_events.EXISTS(line_record.event_id)) AND (NOT l_array_duplicate_checker.EXISTS(line_record.event_id)) THEN
247946: fnd_file.put_line(fnd_file.log, 'Event_id = ' || line_record.event_id);
247947: l_array_duplicate_checker(line_record.event_id) := line_record.event_id;
247948: END IF;
247949: END LOOP;
247950:
247947: l_array_duplicate_checker(line_record.event_id) := line_record.event_id;
247948: END IF;
247949: END LOOP;
247950:
247951: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
247952: fnd_file.put_line(fnd_file.LOG, ' ');
247953:
247954:
247955: xla_exceptions_pkg.raise_message
247948: END IF;
247949: END LOOP;
247950:
247951: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
247952: fnd_file.put_line(fnd_file.LOG, ' ');
247953:
247954:
247955: xla_exceptions_pkg.raise_message
247956: (p_location => 'XLA_00140_AAD_S_000018_PKG.EventClass_518');
249303:
249304: l_first_event_id := l_array_header_events(l_array_header_events.FIRST);
249305: l_last_event_id := l_array_header_events(l_array_header_events.LAST);
249306:
249307: fnd_file.put_line(fnd_file.LOG, ' ');
249308: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
249309: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );
249310: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');
249311:
249304: l_first_event_id := l_array_header_events(l_array_header_events.FIRST);
249305: l_last_event_id := l_array_header_events(l_array_header_events.LAST);
249306:
249307: fnd_file.put_line(fnd_file.LOG, ' ');
249308: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
249309: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );
249310: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');
249311:
249312: FOR line_record IN line_cur(l_first_event_id, l_last_event_id)
249305: l_last_event_id := l_array_header_events(l_array_header_events.LAST);
249306:
249307: fnd_file.put_line(fnd_file.LOG, ' ');
249308: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
249309: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );
249310: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');
249311:
249312: FOR line_record IN line_cur(l_first_event_id, l_last_event_id)
249313: LOOP
249306:
249307: fnd_file.put_line(fnd_file.LOG, ' ');
249308: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
249309: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );
249310: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');
249311:
249312: FOR line_record IN line_cur(l_first_event_id, l_last_event_id)
249313: LOOP
249314: IF (NOT l_array_header_events.EXISTS(line_record.event_id)) AND (NOT l_array_duplicate_checker.EXISTS(line_record.event_id)) THEN
249311:
249312: FOR line_record IN line_cur(l_first_event_id, l_last_event_id)
249313: LOOP
249314: IF (NOT l_array_header_events.EXISTS(line_record.event_id)) AND (NOT l_array_duplicate_checker.EXISTS(line_record.event_id)) THEN
249315: fnd_file.put_line(fnd_file.log, 'Event_id = ' || line_record.event_id);
249316: l_array_duplicate_checker(line_record.event_id) := line_record.event_id;
249317: END IF;
249318: END LOOP;
249319:
249316: l_array_duplicate_checker(line_record.event_id) := line_record.event_id;
249317: END IF;
249318: END LOOP;
249319:
249320: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
249321: fnd_file.put_line(fnd_file.LOG, ' ');
249322:
249323:
249324: xla_exceptions_pkg.raise_message
249317: END IF;
249318: END LOOP;
249319:
249320: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
249321: fnd_file.put_line(fnd_file.LOG, ' ');
249322:
249323:
249324: xla_exceptions_pkg.raise_message
249325: (p_location => 'XLA_00140_AAD_S_000018_PKG.EventClass_519');
250536:
250537: l_first_event_id := l_array_header_events(l_array_header_events.FIRST);
250538: l_last_event_id := l_array_header_events(l_array_header_events.LAST);
250539:
250540: fnd_file.put_line(fnd_file.LOG, ' ');
250541: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
250542: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );
250543: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');
250544:
250537: l_first_event_id := l_array_header_events(l_array_header_events.FIRST);
250538: l_last_event_id := l_array_header_events(l_array_header_events.LAST);
250539:
250540: fnd_file.put_line(fnd_file.LOG, ' ');
250541: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
250542: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );
250543: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');
250544:
250545: FOR line_record IN line_cur(l_first_event_id, l_last_event_id)
250538: l_last_event_id := l_array_header_events(l_array_header_events.LAST);
250539:
250540: fnd_file.put_line(fnd_file.LOG, ' ');
250541: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
250542: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );
250543: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');
250544:
250545: FOR line_record IN line_cur(l_first_event_id, l_last_event_id)
250546: LOOP
250539:
250540: fnd_file.put_line(fnd_file.LOG, ' ');
250541: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
250542: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );
250543: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');
250544:
250545: FOR line_record IN line_cur(l_first_event_id, l_last_event_id)
250546: LOOP
250547: IF (NOT l_array_header_events.EXISTS(line_record.event_id)) AND (NOT l_array_duplicate_checker.EXISTS(line_record.event_id)) THEN
250544:
250545: FOR line_record IN line_cur(l_first_event_id, l_last_event_id)
250546: LOOP
250547: IF (NOT l_array_header_events.EXISTS(line_record.event_id)) AND (NOT l_array_duplicate_checker.EXISTS(line_record.event_id)) THEN
250548: fnd_file.put_line(fnd_file.log, 'Event_id = ' || line_record.event_id);
250549: l_array_duplicate_checker(line_record.event_id) := line_record.event_id;
250550: END IF;
250551: END LOOP;
250552:
250549: l_array_duplicate_checker(line_record.event_id) := line_record.event_id;
250550: END IF;
250551: END LOOP;
250552:
250553: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
250554: fnd_file.put_line(fnd_file.LOG, ' ');
250555:
250556:
250557: xla_exceptions_pkg.raise_message
250550: END IF;
250551: END LOOP;
250552:
250553: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
250554: fnd_file.put_line(fnd_file.LOG, ' ');
250555:
250556:
250557: xla_exceptions_pkg.raise_message
250558: (p_location => 'XLA_00140_AAD_S_000018_PKG.EventClass_520');
251756:
251757: l_first_event_id := l_array_header_events(l_array_header_events.FIRST);
251758: l_last_event_id := l_array_header_events(l_array_header_events.LAST);
251759:
251760: fnd_file.put_line(fnd_file.LOG, ' ');
251761: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
251762: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );
251763: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');
251764:
251757: l_first_event_id := l_array_header_events(l_array_header_events.FIRST);
251758: l_last_event_id := l_array_header_events(l_array_header_events.LAST);
251759:
251760: fnd_file.put_line(fnd_file.LOG, ' ');
251761: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
251762: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );
251763: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');
251764:
251765: FOR line_record IN line_cur(l_first_event_id, l_last_event_id)
251758: l_last_event_id := l_array_header_events(l_array_header_events.LAST);
251759:
251760: fnd_file.put_line(fnd_file.LOG, ' ');
251761: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
251762: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );
251763: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');
251764:
251765: FOR line_record IN line_cur(l_first_event_id, l_last_event_id)
251766: LOOP
251759:
251760: fnd_file.put_line(fnd_file.LOG, ' ');
251761: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
251762: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );
251763: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');
251764:
251765: FOR line_record IN line_cur(l_first_event_id, l_last_event_id)
251766: LOOP
251767: IF (NOT l_array_header_events.EXISTS(line_record.event_id)) AND (NOT l_array_duplicate_checker.EXISTS(line_record.event_id)) THEN
251764:
251765: FOR line_record IN line_cur(l_first_event_id, l_last_event_id)
251766: LOOP
251767: IF (NOT l_array_header_events.EXISTS(line_record.event_id)) AND (NOT l_array_duplicate_checker.EXISTS(line_record.event_id)) THEN
251768: fnd_file.put_line(fnd_file.log, 'Event_id = ' || line_record.event_id);
251769: l_array_duplicate_checker(line_record.event_id) := line_record.event_id;
251770: END IF;
251771: END LOOP;
251772:
251769: l_array_duplicate_checker(line_record.event_id) := line_record.event_id;
251770: END IF;
251771: END LOOP;
251772:
251773: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
251774: fnd_file.put_line(fnd_file.LOG, ' ');
251775:
251776:
251777: xla_exceptions_pkg.raise_message
251770: END IF;
251771: END LOOP;
251772:
251773: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
251774: fnd_file.put_line(fnd_file.LOG, ' ');
251775:
251776:
251777: xla_exceptions_pkg.raise_message
251778: (p_location => 'XLA_00140_AAD_S_000018_PKG.EventClass_521');
253745:
253746: l_first_event_id := l_array_header_events(l_array_header_events.FIRST);
253747: l_last_event_id := l_array_header_events(l_array_header_events.LAST);
253748:
253749: fnd_file.put_line(fnd_file.LOG, ' ');
253750: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
253751: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );
253752: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');
253753:
253746: l_first_event_id := l_array_header_events(l_array_header_events.FIRST);
253747: l_last_event_id := l_array_header_events(l_array_header_events.LAST);
253748:
253749: fnd_file.put_line(fnd_file.LOG, ' ');
253750: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
253751: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );
253752: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');
253753:
253754: FOR line_record IN line_cur(l_first_event_id, l_last_event_id)
253747: l_last_event_id := l_array_header_events(l_array_header_events.LAST);
253748:
253749: fnd_file.put_line(fnd_file.LOG, ' ');
253750: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
253751: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );
253752: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');
253753:
253754: FOR line_record IN line_cur(l_first_event_id, l_last_event_id)
253755: LOOP
253748:
253749: fnd_file.put_line(fnd_file.LOG, ' ');
253750: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
253751: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );
253752: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');
253753:
253754: FOR line_record IN line_cur(l_first_event_id, l_last_event_id)
253755: LOOP
253756: IF (NOT l_array_header_events.EXISTS(line_record.event_id)) AND (NOT l_array_duplicate_checker.EXISTS(line_record.event_id)) THEN
253753:
253754: FOR line_record IN line_cur(l_first_event_id, l_last_event_id)
253755: LOOP
253756: IF (NOT l_array_header_events.EXISTS(line_record.event_id)) AND (NOT l_array_duplicate_checker.EXISTS(line_record.event_id)) THEN
253757: fnd_file.put_line(fnd_file.log, 'Event_id = ' || line_record.event_id);
253758: l_array_duplicate_checker(line_record.event_id) := line_record.event_id;
253759: END IF;
253760: END LOOP;
253761:
253758: l_array_duplicate_checker(line_record.event_id) := line_record.event_id;
253759: END IF;
253760: END LOOP;
253761:
253762: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
253763: fnd_file.put_line(fnd_file.LOG, ' ');
253764:
253765:
253766: xla_exceptions_pkg.raise_message
253759: END IF;
253760: END LOOP;
253761:
253762: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
253763: fnd_file.put_line(fnd_file.LOG, ' ');
253764:
253765:
253766: xla_exceptions_pkg.raise_message
253767: (p_location => 'XLA_00140_AAD_S_000018_PKG.EventClass_522');
255278:
255279: l_first_event_id := l_array_header_events(l_array_header_events.FIRST);
255280: l_last_event_id := l_array_header_events(l_array_header_events.LAST);
255281:
255282: fnd_file.put_line(fnd_file.LOG, ' ');
255283: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
255284: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );
255285: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');
255286:
255279: l_first_event_id := l_array_header_events(l_array_header_events.FIRST);
255280: l_last_event_id := l_array_header_events(l_array_header_events.LAST);
255281:
255282: fnd_file.put_line(fnd_file.LOG, ' ');
255283: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
255284: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );
255285: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');
255286:
255287: FOR line_record IN line_cur(l_first_event_id, l_last_event_id)
255280: l_last_event_id := l_array_header_events(l_array_header_events.LAST);
255281:
255282: fnd_file.put_line(fnd_file.LOG, ' ');
255283: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
255284: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );
255285: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');
255286:
255287: FOR line_record IN line_cur(l_first_event_id, l_last_event_id)
255288: LOOP
255281:
255282: fnd_file.put_line(fnd_file.LOG, ' ');
255283: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
255284: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );
255285: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');
255286:
255287: FOR line_record IN line_cur(l_first_event_id, l_last_event_id)
255288: LOOP
255289: IF (NOT l_array_header_events.EXISTS(line_record.event_id)) AND (NOT l_array_duplicate_checker.EXISTS(line_record.event_id)) THEN
255286:
255287: FOR line_record IN line_cur(l_first_event_id, l_last_event_id)
255288: LOOP
255289: IF (NOT l_array_header_events.EXISTS(line_record.event_id)) AND (NOT l_array_duplicate_checker.EXISTS(line_record.event_id)) THEN
255290: fnd_file.put_line(fnd_file.log, 'Event_id = ' || line_record.event_id);
255291: l_array_duplicate_checker(line_record.event_id) := line_record.event_id;
255292: END IF;
255293: END LOOP;
255294:
255291: l_array_duplicate_checker(line_record.event_id) := line_record.event_id;
255292: END IF;
255293: END LOOP;
255294:
255295: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
255296: fnd_file.put_line(fnd_file.LOG, ' ');
255297:
255298:
255299: xla_exceptions_pkg.raise_message
255292: END IF;
255293: END LOOP;
255294:
255295: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
255296: fnd_file.put_line(fnd_file.LOG, ' ');
255297:
255298:
255299: xla_exceptions_pkg.raise_message
255300: (p_location => 'XLA_00140_AAD_S_000018_PKG.EventClass_523');
257567:
257568: l_first_event_id := l_array_header_events(l_array_header_events.FIRST);
257569: l_last_event_id := l_array_header_events(l_array_header_events.LAST);
257570:
257571: fnd_file.put_line(fnd_file.LOG, ' ');
257572: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
257573: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );
257574: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');
257575:
257568: l_first_event_id := l_array_header_events(l_array_header_events.FIRST);
257569: l_last_event_id := l_array_header_events(l_array_header_events.LAST);
257570:
257571: fnd_file.put_line(fnd_file.LOG, ' ');
257572: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
257573: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );
257574: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');
257575:
257576: FOR line_record IN line_cur(l_first_event_id, l_last_event_id)
257569: l_last_event_id := l_array_header_events(l_array_header_events.LAST);
257570:
257571: fnd_file.put_line(fnd_file.LOG, ' ');
257572: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
257573: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );
257574: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');
257575:
257576: FOR line_record IN line_cur(l_first_event_id, l_last_event_id)
257577: LOOP
257570:
257571: fnd_file.put_line(fnd_file.LOG, ' ');
257572: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
257573: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );
257574: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');
257575:
257576: FOR line_record IN line_cur(l_first_event_id, l_last_event_id)
257577: LOOP
257578: IF (NOT l_array_header_events.EXISTS(line_record.event_id)) AND (NOT l_array_duplicate_checker.EXISTS(line_record.event_id)) THEN
257575:
257576: FOR line_record IN line_cur(l_first_event_id, l_last_event_id)
257577: LOOP
257578: IF (NOT l_array_header_events.EXISTS(line_record.event_id)) AND (NOT l_array_duplicate_checker.EXISTS(line_record.event_id)) THEN
257579: fnd_file.put_line(fnd_file.log, 'Event_id = ' || line_record.event_id);
257580: l_array_duplicate_checker(line_record.event_id) := line_record.event_id;
257581: END IF;
257582: END LOOP;
257583:
257580: l_array_duplicate_checker(line_record.event_id) := line_record.event_id;
257581: END IF;
257582: END LOOP;
257583:
257584: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
257585: fnd_file.put_line(fnd_file.LOG, ' ');
257586:
257587:
257588: xla_exceptions_pkg.raise_message
257581: END IF;
257582: END LOOP;
257583:
257584: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
257585: fnd_file.put_line(fnd_file.LOG, ' ');
257586:
257587:
257588: xla_exceptions_pkg.raise_message
257589: (p_location => 'XLA_00140_AAD_S_000018_PKG.EventType_524');
258867:
258868: l_first_event_id := l_array_header_events(l_array_header_events.FIRST);
258869: l_last_event_id := l_array_header_events(l_array_header_events.LAST);
258870:
258871: fnd_file.put_line(fnd_file.LOG, ' ');
258872: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
258873: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );
258874: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');
258875:
258868: l_first_event_id := l_array_header_events(l_array_header_events.FIRST);
258869: l_last_event_id := l_array_header_events(l_array_header_events.LAST);
258870:
258871: fnd_file.put_line(fnd_file.LOG, ' ');
258872: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
258873: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );
258874: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');
258875:
258876: FOR line_record IN line_cur(l_first_event_id, l_last_event_id)
258869: l_last_event_id := l_array_header_events(l_array_header_events.LAST);
258870:
258871: fnd_file.put_line(fnd_file.LOG, ' ');
258872: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
258873: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );
258874: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');
258875:
258876: FOR line_record IN line_cur(l_first_event_id, l_last_event_id)
258877: LOOP
258870:
258871: fnd_file.put_line(fnd_file.LOG, ' ');
258872: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
258873: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );
258874: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');
258875:
258876: FOR line_record IN line_cur(l_first_event_id, l_last_event_id)
258877: LOOP
258878: IF (NOT l_array_header_events.EXISTS(line_record.event_id)) AND (NOT l_array_duplicate_checker.EXISTS(line_record.event_id)) THEN
258875:
258876: FOR line_record IN line_cur(l_first_event_id, l_last_event_id)
258877: LOOP
258878: IF (NOT l_array_header_events.EXISTS(line_record.event_id)) AND (NOT l_array_duplicate_checker.EXISTS(line_record.event_id)) THEN
258879: fnd_file.put_line(fnd_file.log, 'Event_id = ' || line_record.event_id);
258880: l_array_duplicate_checker(line_record.event_id) := line_record.event_id;
258881: END IF;
258882: END LOOP;
258883:
258880: l_array_duplicate_checker(line_record.event_id) := line_record.event_id;
258881: END IF;
258882: END LOOP;
258883:
258884: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
258885: fnd_file.put_line(fnd_file.LOG, ' ');
258886:
258887:
258888: xla_exceptions_pkg.raise_message
258881: END IF;
258882: END LOOP;
258883:
258884: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
258885: fnd_file.put_line(fnd_file.LOG, ' ');
258886:
258887:
258888: xla_exceptions_pkg.raise_message
258889: (p_location => 'XLA_00140_AAD_S_000018_PKG.EventClass_525');
261099:
261100: l_first_event_id := l_array_header_events(l_array_header_events.FIRST);
261101: l_last_event_id := l_array_header_events(l_array_header_events.LAST);
261102:
261103: fnd_file.put_line(fnd_file.LOG, ' ');
261104: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
261105: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );
261106: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');
261107:
261100: l_first_event_id := l_array_header_events(l_array_header_events.FIRST);
261101: l_last_event_id := l_array_header_events(l_array_header_events.LAST);
261102:
261103: fnd_file.put_line(fnd_file.LOG, ' ');
261104: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
261105: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );
261106: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');
261107:
261108: FOR line_record IN line_cur(l_first_event_id, l_last_event_id)
261101: l_last_event_id := l_array_header_events(l_array_header_events.LAST);
261102:
261103: fnd_file.put_line(fnd_file.LOG, ' ');
261104: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
261105: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );
261106: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');
261107:
261108: FOR line_record IN line_cur(l_first_event_id, l_last_event_id)
261109: LOOP
261102:
261103: fnd_file.put_line(fnd_file.LOG, ' ');
261104: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
261105: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );
261106: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');
261107:
261108: FOR line_record IN line_cur(l_first_event_id, l_last_event_id)
261109: LOOP
261110: IF (NOT l_array_header_events.EXISTS(line_record.event_id)) AND (NOT l_array_duplicate_checker.EXISTS(line_record.event_id)) THEN
261107:
261108: FOR line_record IN line_cur(l_first_event_id, l_last_event_id)
261109: LOOP
261110: IF (NOT l_array_header_events.EXISTS(line_record.event_id)) AND (NOT l_array_duplicate_checker.EXISTS(line_record.event_id)) THEN
261111: fnd_file.put_line(fnd_file.log, 'Event_id = ' || line_record.event_id);
261112: l_array_duplicate_checker(line_record.event_id) := line_record.event_id;
261113: END IF;
261114: END LOOP;
261115:
261112: l_array_duplicate_checker(line_record.event_id) := line_record.event_id;
261113: END IF;
261114: END LOOP;
261115:
261116: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
261117: fnd_file.put_line(fnd_file.LOG, ' ');
261118:
261119:
261120: xla_exceptions_pkg.raise_message
261113: END IF;
261114: END LOOP;
261115:
261116: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
261117: fnd_file.put_line(fnd_file.LOG, ' ');
261118:
261119:
261120: xla_exceptions_pkg.raise_message
261121: (p_location => 'XLA_00140_AAD_S_000018_PKG.EventType_526');
262358:
262359: l_first_event_id := l_array_header_events(l_array_header_events.FIRST);
262360: l_last_event_id := l_array_header_events(l_array_header_events.LAST);
262361:
262362: fnd_file.put_line(fnd_file.LOG, ' ');
262363: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
262364: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );
262365: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');
262366:
262359: l_first_event_id := l_array_header_events(l_array_header_events.FIRST);
262360: l_last_event_id := l_array_header_events(l_array_header_events.LAST);
262361:
262362: fnd_file.put_line(fnd_file.LOG, ' ');
262363: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
262364: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );
262365: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');
262366:
262367: FOR line_record IN line_cur(l_first_event_id, l_last_event_id)
262360: l_last_event_id := l_array_header_events(l_array_header_events.LAST);
262361:
262362: fnd_file.put_line(fnd_file.LOG, ' ');
262363: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
262364: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );
262365: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');
262366:
262367: FOR line_record IN line_cur(l_first_event_id, l_last_event_id)
262368: LOOP
262361:
262362: fnd_file.put_line(fnd_file.LOG, ' ');
262363: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
262364: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );
262365: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');
262366:
262367: FOR line_record IN line_cur(l_first_event_id, l_last_event_id)
262368: LOOP
262369: IF (NOT l_array_header_events.EXISTS(line_record.event_id)) AND (NOT l_array_duplicate_checker.EXISTS(line_record.event_id)) THEN
262366:
262367: FOR line_record IN line_cur(l_first_event_id, l_last_event_id)
262368: LOOP
262369: IF (NOT l_array_header_events.EXISTS(line_record.event_id)) AND (NOT l_array_duplicate_checker.EXISTS(line_record.event_id)) THEN
262370: fnd_file.put_line(fnd_file.log, 'Event_id = ' || line_record.event_id);
262371: l_array_duplicate_checker(line_record.event_id) := line_record.event_id;
262372: END IF;
262373: END LOOP;
262374:
262371: l_array_duplicate_checker(line_record.event_id) := line_record.event_id;
262372: END IF;
262373: END LOOP;
262374:
262375: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
262376: fnd_file.put_line(fnd_file.LOG, ' ');
262377:
262378:
262379: xla_exceptions_pkg.raise_message
262372: END IF;
262373: END LOOP;
262374:
262375: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
262376: fnd_file.put_line(fnd_file.LOG, ' ');
262377:
262378:
262379: xla_exceptions_pkg.raise_message
262380: (p_location => 'XLA_00140_AAD_S_000018_PKG.EventClass_527');
263776:
263777: l_first_event_id := l_array_header_events(l_array_header_events.FIRST);
263778: l_last_event_id := l_array_header_events(l_array_header_events.LAST);
263779:
263780: fnd_file.put_line(fnd_file.LOG, ' ');
263781: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
263782: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );
263783: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');
263784:
263777: l_first_event_id := l_array_header_events(l_array_header_events.FIRST);
263778: l_last_event_id := l_array_header_events(l_array_header_events.LAST);
263779:
263780: fnd_file.put_line(fnd_file.LOG, ' ');
263781: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
263782: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );
263783: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');
263784:
263785: FOR line_record IN line_cur(l_first_event_id, l_last_event_id)
263778: l_last_event_id := l_array_header_events(l_array_header_events.LAST);
263779:
263780: fnd_file.put_line(fnd_file.LOG, ' ');
263781: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
263782: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );
263783: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');
263784:
263785: FOR line_record IN line_cur(l_first_event_id, l_last_event_id)
263786: LOOP
263779:
263780: fnd_file.put_line(fnd_file.LOG, ' ');
263781: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
263782: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );
263783: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');
263784:
263785: FOR line_record IN line_cur(l_first_event_id, l_last_event_id)
263786: LOOP
263787: IF (NOT l_array_header_events.EXISTS(line_record.event_id)) AND (NOT l_array_duplicate_checker.EXISTS(line_record.event_id)) THEN
263784:
263785: FOR line_record IN line_cur(l_first_event_id, l_last_event_id)
263786: LOOP
263787: IF (NOT l_array_header_events.EXISTS(line_record.event_id)) AND (NOT l_array_duplicate_checker.EXISTS(line_record.event_id)) THEN
263788: fnd_file.put_line(fnd_file.log, 'Event_id = ' || line_record.event_id);
263789: l_array_duplicate_checker(line_record.event_id) := line_record.event_id;
263790: END IF;
263791: END LOOP;
263792:
263789: l_array_duplicate_checker(line_record.event_id) := line_record.event_id;
263790: END IF;
263791: END LOOP;
263792:
263793: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
263794: fnd_file.put_line(fnd_file.LOG, ' ');
263795:
263796:
263797: xla_exceptions_pkg.raise_message
263790: END IF;
263791: END LOOP;
263792:
263793: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
263794: fnd_file.put_line(fnd_file.LOG, ' ');
263795:
263796:
263797: xla_exceptions_pkg.raise_message
263798: (p_location => 'XLA_00140_AAD_S_000018_PKG.EventClass_528');
265193:
265194: l_first_event_id := l_array_header_events(l_array_header_events.FIRST);
265195: l_last_event_id := l_array_header_events(l_array_header_events.LAST);
265196:
265197: fnd_file.put_line(fnd_file.LOG, ' ');
265198: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
265199: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );
265200: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');
265201:
265194: l_first_event_id := l_array_header_events(l_array_header_events.FIRST);
265195: l_last_event_id := l_array_header_events(l_array_header_events.LAST);
265196:
265197: fnd_file.put_line(fnd_file.LOG, ' ');
265198: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
265199: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );
265200: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');
265201:
265202: FOR line_record IN line_cur(l_first_event_id, l_last_event_id)
265195: l_last_event_id := l_array_header_events(l_array_header_events.LAST);
265196:
265197: fnd_file.put_line(fnd_file.LOG, ' ');
265198: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
265199: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );
265200: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');
265201:
265202: FOR line_record IN line_cur(l_first_event_id, l_last_event_id)
265203: LOOP
265196:
265197: fnd_file.put_line(fnd_file.LOG, ' ');
265198: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
265199: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );
265200: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');
265201:
265202: FOR line_record IN line_cur(l_first_event_id, l_last_event_id)
265203: LOOP
265204: IF (NOT l_array_header_events.EXISTS(line_record.event_id)) AND (NOT l_array_duplicate_checker.EXISTS(line_record.event_id)) THEN
265201:
265202: FOR line_record IN line_cur(l_first_event_id, l_last_event_id)
265203: LOOP
265204: IF (NOT l_array_header_events.EXISTS(line_record.event_id)) AND (NOT l_array_duplicate_checker.EXISTS(line_record.event_id)) THEN
265205: fnd_file.put_line(fnd_file.log, 'Event_id = ' || line_record.event_id);
265206: l_array_duplicate_checker(line_record.event_id) := line_record.event_id;
265207: END IF;
265208: END LOOP;
265209:
265206: l_array_duplicate_checker(line_record.event_id) := line_record.event_id;
265207: END IF;
265208: END LOOP;
265209:
265210: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
265211: fnd_file.put_line(fnd_file.LOG, ' ');
265212:
265213:
265214: xla_exceptions_pkg.raise_message
265207: END IF;
265208: END LOOP;
265209:
265210: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
265211: fnd_file.put_line(fnd_file.LOG, ' ');
265212:
265213:
265214: xla_exceptions_pkg.raise_message
265215: (p_location => 'XLA_00140_AAD_S_000018_PKG.EventType_529');
267094:
267095: l_first_event_id := l_array_header_events(l_array_header_events.FIRST);
267096: l_last_event_id := l_array_header_events(l_array_header_events.LAST);
267097:
267098: fnd_file.put_line(fnd_file.LOG, ' ');
267099: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
267100: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );
267101: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');
267102:
267095: l_first_event_id := l_array_header_events(l_array_header_events.FIRST);
267096: l_last_event_id := l_array_header_events(l_array_header_events.LAST);
267097:
267098: fnd_file.put_line(fnd_file.LOG, ' ');
267099: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
267100: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );
267101: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');
267102:
267103: FOR line_record IN line_cur(l_first_event_id, l_last_event_id)
267096: l_last_event_id := l_array_header_events(l_array_header_events.LAST);
267097:
267098: fnd_file.put_line(fnd_file.LOG, ' ');
267099: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
267100: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );
267101: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');
267102:
267103: FOR line_record IN line_cur(l_first_event_id, l_last_event_id)
267104: LOOP
267097:
267098: fnd_file.put_line(fnd_file.LOG, ' ');
267099: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
267100: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );
267101: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');
267102:
267103: FOR line_record IN line_cur(l_first_event_id, l_last_event_id)
267104: LOOP
267105: IF (NOT l_array_header_events.EXISTS(line_record.event_id)) AND (NOT l_array_duplicate_checker.EXISTS(line_record.event_id)) THEN
267102:
267103: FOR line_record IN line_cur(l_first_event_id, l_last_event_id)
267104: LOOP
267105: IF (NOT l_array_header_events.EXISTS(line_record.event_id)) AND (NOT l_array_duplicate_checker.EXISTS(line_record.event_id)) THEN
267106: fnd_file.put_line(fnd_file.log, 'Event_id = ' || line_record.event_id);
267107: l_array_duplicate_checker(line_record.event_id) := line_record.event_id;
267108: END IF;
267109: END LOOP;
267110:
267107: l_array_duplicate_checker(line_record.event_id) := line_record.event_id;
267108: END IF;
267109: END LOOP;
267110:
267111: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
267112: fnd_file.put_line(fnd_file.LOG, ' ');
267113:
267114:
267115: xla_exceptions_pkg.raise_message
267108: END IF;
267109: END LOOP;
267110:
267111: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
267112: fnd_file.put_line(fnd_file.LOG, ' ');
267113:
267114:
267115: xla_exceptions_pkg.raise_message
267116: (p_location => 'XLA_00140_AAD_S_000018_PKG.EventClass_530');
268353:
268354: l_first_event_id := l_array_header_events(l_array_header_events.FIRST);
268355: l_last_event_id := l_array_header_events(l_array_header_events.LAST);
268356:
268357: fnd_file.put_line(fnd_file.LOG, ' ');
268358: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
268359: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );
268360: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');
268361:
268354: l_first_event_id := l_array_header_events(l_array_header_events.FIRST);
268355: l_last_event_id := l_array_header_events(l_array_header_events.LAST);
268356:
268357: fnd_file.put_line(fnd_file.LOG, ' ');
268358: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
268359: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );
268360: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');
268361:
268362: FOR line_record IN line_cur(l_first_event_id, l_last_event_id)
268355: l_last_event_id := l_array_header_events(l_array_header_events.LAST);
268356:
268357: fnd_file.put_line(fnd_file.LOG, ' ');
268358: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
268359: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );
268360: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');
268361:
268362: FOR line_record IN line_cur(l_first_event_id, l_last_event_id)
268363: LOOP
268356:
268357: fnd_file.put_line(fnd_file.LOG, ' ');
268358: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
268359: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );
268360: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');
268361:
268362: FOR line_record IN line_cur(l_first_event_id, l_last_event_id)
268363: LOOP
268364: IF (NOT l_array_header_events.EXISTS(line_record.event_id)) AND (NOT l_array_duplicate_checker.EXISTS(line_record.event_id)) THEN
268361:
268362: FOR line_record IN line_cur(l_first_event_id, l_last_event_id)
268363: LOOP
268364: IF (NOT l_array_header_events.EXISTS(line_record.event_id)) AND (NOT l_array_duplicate_checker.EXISTS(line_record.event_id)) THEN
268365: fnd_file.put_line(fnd_file.log, 'Event_id = ' || line_record.event_id);
268366: l_array_duplicate_checker(line_record.event_id) := line_record.event_id;
268367: END IF;
268368: END LOOP;
268369:
268366: l_array_duplicate_checker(line_record.event_id) := line_record.event_id;
268367: END IF;
268368: END LOOP;
268369:
268370: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
268371: fnd_file.put_line(fnd_file.LOG, ' ');
268372:
268373:
268374: xla_exceptions_pkg.raise_message
268367: END IF;
268368: END LOOP;
268369:
268370: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
268371: fnd_file.put_line(fnd_file.LOG, ' ');
268372:
268373:
268374: xla_exceptions_pkg.raise_message
268375: (p_location => 'XLA_00140_AAD_S_000018_PKG.EventClass_531');
270539:
270540: l_first_event_id := l_array_header_events(l_array_header_events.FIRST);
270541: l_last_event_id := l_array_header_events(l_array_header_events.LAST);
270542:
270543: fnd_file.put_line(fnd_file.LOG, ' ');
270544: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
270545: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );
270546: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');
270547:
270540: l_first_event_id := l_array_header_events(l_array_header_events.FIRST);
270541: l_last_event_id := l_array_header_events(l_array_header_events.LAST);
270542:
270543: fnd_file.put_line(fnd_file.LOG, ' ');
270544: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
270545: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );
270546: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');
270547:
270548: FOR line_record IN line_cur(l_first_event_id, l_last_event_id)
270541: l_last_event_id := l_array_header_events(l_array_header_events.LAST);
270542:
270543: fnd_file.put_line(fnd_file.LOG, ' ');
270544: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
270545: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );
270546: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');
270547:
270548: FOR line_record IN line_cur(l_first_event_id, l_last_event_id)
270549: LOOP
270542:
270543: fnd_file.put_line(fnd_file.LOG, ' ');
270544: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
270545: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );
270546: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');
270547:
270548: FOR line_record IN line_cur(l_first_event_id, l_last_event_id)
270549: LOOP
270550: IF (NOT l_array_header_events.EXISTS(line_record.event_id)) AND (NOT l_array_duplicate_checker.EXISTS(line_record.event_id)) THEN
270547:
270548: FOR line_record IN line_cur(l_first_event_id, l_last_event_id)
270549: LOOP
270550: IF (NOT l_array_header_events.EXISTS(line_record.event_id)) AND (NOT l_array_duplicate_checker.EXISTS(line_record.event_id)) THEN
270551: fnd_file.put_line(fnd_file.log, 'Event_id = ' || line_record.event_id);
270552: l_array_duplicate_checker(line_record.event_id) := line_record.event_id;
270553: END IF;
270554: END LOOP;
270555:
270552: l_array_duplicate_checker(line_record.event_id) := line_record.event_id;
270553: END IF;
270554: END LOOP;
270555:
270556: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
270557: fnd_file.put_line(fnd_file.LOG, ' ');
270558:
270559:
270560: xla_exceptions_pkg.raise_message
270553: END IF;
270554: END LOOP;
270555:
270556: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
270557: fnd_file.put_line(fnd_file.LOG, ' ');
270558:
270559:
270560: xla_exceptions_pkg.raise_message
270561: (p_location => 'XLA_00140_AAD_S_000018_PKG.EventClass_532');
272291:
272292: l_first_event_id := l_array_header_events(l_array_header_events.FIRST);
272293: l_last_event_id := l_array_header_events(l_array_header_events.LAST);
272294:
272295: fnd_file.put_line(fnd_file.LOG, ' ');
272296: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
272297: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );
272298: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');
272299:
272292: l_first_event_id := l_array_header_events(l_array_header_events.FIRST);
272293: l_last_event_id := l_array_header_events(l_array_header_events.LAST);
272294:
272295: fnd_file.put_line(fnd_file.LOG, ' ');
272296: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
272297: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );
272298: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');
272299:
272300: FOR line_record IN line_cur(l_first_event_id, l_last_event_id)
272293: l_last_event_id := l_array_header_events(l_array_header_events.LAST);
272294:
272295: fnd_file.put_line(fnd_file.LOG, ' ');
272296: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
272297: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );
272298: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');
272299:
272300: FOR line_record IN line_cur(l_first_event_id, l_last_event_id)
272301: LOOP
272294:
272295: fnd_file.put_line(fnd_file.LOG, ' ');
272296: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
272297: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );
272298: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');
272299:
272300: FOR line_record IN line_cur(l_first_event_id, l_last_event_id)
272301: LOOP
272302: IF (NOT l_array_header_events.EXISTS(line_record.event_id)) AND (NOT l_array_duplicate_checker.EXISTS(line_record.event_id)) THEN
272299:
272300: FOR line_record IN line_cur(l_first_event_id, l_last_event_id)
272301: LOOP
272302: IF (NOT l_array_header_events.EXISTS(line_record.event_id)) AND (NOT l_array_duplicate_checker.EXISTS(line_record.event_id)) THEN
272303: fnd_file.put_line(fnd_file.log, 'Event_id = ' || line_record.event_id);
272304: l_array_duplicate_checker(line_record.event_id) := line_record.event_id;
272305: END IF;
272306: END LOOP;
272307:
272304: l_array_duplicate_checker(line_record.event_id) := line_record.event_id;
272305: END IF;
272306: END LOOP;
272307:
272308: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
272309: fnd_file.put_line(fnd_file.LOG, ' ');
272310:
272311:
272312: xla_exceptions_pkg.raise_message
272305: END IF;
272306: END LOOP;
272307:
272308: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
272309: fnd_file.put_line(fnd_file.LOG, ' ');
272310:
272311:
272312: xla_exceptions_pkg.raise_message
272313: (p_location => 'XLA_00140_AAD_S_000018_PKG.EventClass_533');
273498:
273499: l_first_event_id := l_array_header_events(l_array_header_events.FIRST);
273500: l_last_event_id := l_array_header_events(l_array_header_events.LAST);
273501:
273502: fnd_file.put_line(fnd_file.LOG, ' ');
273503: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
273504: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );
273505: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');
273506:
273499: l_first_event_id := l_array_header_events(l_array_header_events.FIRST);
273500: l_last_event_id := l_array_header_events(l_array_header_events.LAST);
273501:
273502: fnd_file.put_line(fnd_file.LOG, ' ');
273503: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
273504: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );
273505: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');
273506:
273507: FOR line_record IN line_cur(l_first_event_id, l_last_event_id)
273500: l_last_event_id := l_array_header_events(l_array_header_events.LAST);
273501:
273502: fnd_file.put_line(fnd_file.LOG, ' ');
273503: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
273504: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );
273505: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');
273506:
273507: FOR line_record IN line_cur(l_first_event_id, l_last_event_id)
273508: LOOP
273501:
273502: fnd_file.put_line(fnd_file.LOG, ' ');
273503: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
273504: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );
273505: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');
273506:
273507: FOR line_record IN line_cur(l_first_event_id, l_last_event_id)
273508: LOOP
273509: IF (NOT l_array_header_events.EXISTS(line_record.event_id)) AND (NOT l_array_duplicate_checker.EXISTS(line_record.event_id)) THEN
273506:
273507: FOR line_record IN line_cur(l_first_event_id, l_last_event_id)
273508: LOOP
273509: IF (NOT l_array_header_events.EXISTS(line_record.event_id)) AND (NOT l_array_duplicate_checker.EXISTS(line_record.event_id)) THEN
273510: fnd_file.put_line(fnd_file.log, 'Event_id = ' || line_record.event_id);
273511: l_array_duplicate_checker(line_record.event_id) := line_record.event_id;
273512: END IF;
273513: END LOOP;
273514:
273511: l_array_duplicate_checker(line_record.event_id) := line_record.event_id;
273512: END IF;
273513: END LOOP;
273514:
273515: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
273516: fnd_file.put_line(fnd_file.LOG, ' ');
273517:
273518:
273519: xla_exceptions_pkg.raise_message
273512: END IF;
273513: END LOOP;
273514:
273515: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
273516: fnd_file.put_line(fnd_file.LOG, ' ');
273517:
273518:
273519: xla_exceptions_pkg.raise_message
273520: (p_location => 'XLA_00140_AAD_S_000018_PKG.EventClass_534');