68054:
68055: l_first_event_id := l_array_header_events(l_array_header_events.FIRST);
68056: l_last_event_id := l_array_header_events(l_array_header_events.LAST);
68057:
68058: fnd_file.put_line(fnd_file.LOG, ' ');
68059: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
68060: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );
68061: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');
68062:
68055: l_first_event_id := l_array_header_events(l_array_header_events.FIRST);
68056: l_last_event_id := l_array_header_events(l_array_header_events.LAST);
68057:
68058: fnd_file.put_line(fnd_file.LOG, ' ');
68059: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
68060: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );
68061: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');
68062:
68063: FOR line_record IN line_cur(l_first_event_id, l_last_event_id)
68056: l_last_event_id := l_array_header_events(l_array_header_events.LAST);
68057:
68058: fnd_file.put_line(fnd_file.LOG, ' ');
68059: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
68060: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );
68061: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');
68062:
68063: FOR line_record IN line_cur(l_first_event_id, l_last_event_id)
68064: LOOP
68057:
68058: fnd_file.put_line(fnd_file.LOG, ' ');
68059: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
68060: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );
68061: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');
68062:
68063: FOR line_record IN line_cur(l_first_event_id, l_last_event_id)
68064: LOOP
68065: IF (NOT l_array_header_events.EXISTS(line_record.event_id)) AND (NOT l_array_duplicate_checker.EXISTS(line_record.event_id)) THEN
68062:
68063: FOR line_record IN line_cur(l_first_event_id, l_last_event_id)
68064: LOOP
68065: IF (NOT l_array_header_events.EXISTS(line_record.event_id)) AND (NOT l_array_duplicate_checker.EXISTS(line_record.event_id)) THEN
68066: fnd_file.put_line(fnd_file.log, 'Event_id = ' || line_record.event_id);
68067: l_array_duplicate_checker(line_record.event_id) := line_record.event_id;
68068: END IF;
68069: END LOOP;
68070:
68067: l_array_duplicate_checker(line_record.event_id) := line_record.event_id;
68068: END IF;
68069: END LOOP;
68070:
68071: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
68072: fnd_file.put_line(fnd_file.LOG, ' ');
68073:
68074:
68075: xla_exceptions_pkg.raise_message
68068: END IF;
68069: END LOOP;
68070:
68071: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
68072: fnd_file.put_line(fnd_file.LOG, ' ');
68073:
68074:
68075: xla_exceptions_pkg.raise_message
68076: (p_location => 'XLA_00222_AAD_S_000005_PKG.EventClass_134');
69300:
69301: l_first_event_id := l_array_header_events(l_array_header_events.FIRST);
69302: l_last_event_id := l_array_header_events(l_array_header_events.LAST);
69303:
69304: fnd_file.put_line(fnd_file.LOG, ' ');
69305: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
69306: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );
69307: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');
69308:
69301: l_first_event_id := l_array_header_events(l_array_header_events.FIRST);
69302: l_last_event_id := l_array_header_events(l_array_header_events.LAST);
69303:
69304: fnd_file.put_line(fnd_file.LOG, ' ');
69305: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
69306: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );
69307: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');
69308:
69309: FOR line_record IN line_cur(l_first_event_id, l_last_event_id)
69302: l_last_event_id := l_array_header_events(l_array_header_events.LAST);
69303:
69304: fnd_file.put_line(fnd_file.LOG, ' ');
69305: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
69306: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );
69307: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');
69308:
69309: FOR line_record IN line_cur(l_first_event_id, l_last_event_id)
69310: LOOP
69303:
69304: fnd_file.put_line(fnd_file.LOG, ' ');
69305: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
69306: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );
69307: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');
69308:
69309: FOR line_record IN line_cur(l_first_event_id, l_last_event_id)
69310: LOOP
69311: IF (NOT l_array_header_events.EXISTS(line_record.event_id)) AND (NOT l_array_duplicate_checker.EXISTS(line_record.event_id)) THEN
69308:
69309: FOR line_record IN line_cur(l_first_event_id, l_last_event_id)
69310: LOOP
69311: IF (NOT l_array_header_events.EXISTS(line_record.event_id)) AND (NOT l_array_duplicate_checker.EXISTS(line_record.event_id)) THEN
69312: fnd_file.put_line(fnd_file.log, 'Event_id = ' || line_record.event_id);
69313: l_array_duplicate_checker(line_record.event_id) := line_record.event_id;
69314: END IF;
69315: END LOOP;
69316:
69313: l_array_duplicate_checker(line_record.event_id) := line_record.event_id;
69314: END IF;
69315: END LOOP;
69316:
69317: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
69318: fnd_file.put_line(fnd_file.LOG, ' ');
69319:
69320:
69321: xla_exceptions_pkg.raise_message
69314: END IF;
69315: END LOOP;
69316:
69317: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
69318: fnd_file.put_line(fnd_file.LOG, ' ');
69319:
69320:
69321: xla_exceptions_pkg.raise_message
69322: (p_location => 'XLA_00222_AAD_S_000005_PKG.EventClass_135');
71032:
71033: l_first_event_id := l_array_header_events(l_array_header_events.FIRST);
71034: l_last_event_id := l_array_header_events(l_array_header_events.LAST);
71035:
71036: fnd_file.put_line(fnd_file.LOG, ' ');
71037: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
71038: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );
71039: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');
71040:
71033: l_first_event_id := l_array_header_events(l_array_header_events.FIRST);
71034: l_last_event_id := l_array_header_events(l_array_header_events.LAST);
71035:
71036: fnd_file.put_line(fnd_file.LOG, ' ');
71037: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
71038: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );
71039: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');
71040:
71041: FOR line_record IN line_cur(l_first_event_id, l_last_event_id)
71034: l_last_event_id := l_array_header_events(l_array_header_events.LAST);
71035:
71036: fnd_file.put_line(fnd_file.LOG, ' ');
71037: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
71038: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );
71039: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');
71040:
71041: FOR line_record IN line_cur(l_first_event_id, l_last_event_id)
71042: LOOP
71035:
71036: fnd_file.put_line(fnd_file.LOG, ' ');
71037: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
71038: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );
71039: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');
71040:
71041: FOR line_record IN line_cur(l_first_event_id, l_last_event_id)
71042: LOOP
71043: IF (NOT l_array_header_events.EXISTS(line_record.event_id)) AND (NOT l_array_duplicate_checker.EXISTS(line_record.event_id)) THEN
71040:
71041: FOR line_record IN line_cur(l_first_event_id, l_last_event_id)
71042: LOOP
71043: IF (NOT l_array_header_events.EXISTS(line_record.event_id)) AND (NOT l_array_duplicate_checker.EXISTS(line_record.event_id)) THEN
71044: fnd_file.put_line(fnd_file.log, 'Event_id = ' || line_record.event_id);
71045: l_array_duplicate_checker(line_record.event_id) := line_record.event_id;
71046: END IF;
71047: END LOOP;
71048:
71045: l_array_duplicate_checker(line_record.event_id) := line_record.event_id;
71046: END IF;
71047: END LOOP;
71048:
71049: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
71050: fnd_file.put_line(fnd_file.LOG, ' ');
71051:
71052:
71053: xla_exceptions_pkg.raise_message
71046: END IF;
71047: END LOOP;
71048:
71049: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
71050: fnd_file.put_line(fnd_file.LOG, ' ');
71051:
71052:
71053: xla_exceptions_pkg.raise_message
71054: (p_location => 'XLA_00222_AAD_S_000005_PKG.EventClass_136');
72513:
72514: l_first_event_id := l_array_header_events(l_array_header_events.FIRST);
72515: l_last_event_id := l_array_header_events(l_array_header_events.LAST);
72516:
72517: fnd_file.put_line(fnd_file.LOG, ' ');
72518: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
72519: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );
72520: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');
72521:
72514: l_first_event_id := l_array_header_events(l_array_header_events.FIRST);
72515: l_last_event_id := l_array_header_events(l_array_header_events.LAST);
72516:
72517: fnd_file.put_line(fnd_file.LOG, ' ');
72518: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
72519: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );
72520: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');
72521:
72522: FOR line_record IN line_cur(l_first_event_id, l_last_event_id)
72515: l_last_event_id := l_array_header_events(l_array_header_events.LAST);
72516:
72517: fnd_file.put_line(fnd_file.LOG, ' ');
72518: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
72519: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );
72520: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');
72521:
72522: FOR line_record IN line_cur(l_first_event_id, l_last_event_id)
72523: LOOP
72516:
72517: fnd_file.put_line(fnd_file.LOG, ' ');
72518: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
72519: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );
72520: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');
72521:
72522: FOR line_record IN line_cur(l_first_event_id, l_last_event_id)
72523: LOOP
72524: IF (NOT l_array_header_events.EXISTS(line_record.event_id)) AND (NOT l_array_duplicate_checker.EXISTS(line_record.event_id)) THEN
72521:
72522: FOR line_record IN line_cur(l_first_event_id, l_last_event_id)
72523: LOOP
72524: IF (NOT l_array_header_events.EXISTS(line_record.event_id)) AND (NOT l_array_duplicate_checker.EXISTS(line_record.event_id)) THEN
72525: fnd_file.put_line(fnd_file.log, 'Event_id = ' || line_record.event_id);
72526: l_array_duplicate_checker(line_record.event_id) := line_record.event_id;
72527: END IF;
72528: END LOOP;
72529:
72526: l_array_duplicate_checker(line_record.event_id) := line_record.event_id;
72527: END IF;
72528: END LOOP;
72529:
72530: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
72531: fnd_file.put_line(fnd_file.LOG, ' ');
72532:
72533:
72534: xla_exceptions_pkg.raise_message
72527: END IF;
72528: END LOOP;
72529:
72530: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
72531: fnd_file.put_line(fnd_file.LOG, ' ');
72532:
72533:
72534: xla_exceptions_pkg.raise_message
72535: (p_location => 'XLA_00222_AAD_S_000005_PKG.EventClass_137');
73759:
73760: l_first_event_id := l_array_header_events(l_array_header_events.FIRST);
73761: l_last_event_id := l_array_header_events(l_array_header_events.LAST);
73762:
73763: fnd_file.put_line(fnd_file.LOG, ' ');
73764: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
73765: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );
73766: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');
73767:
73760: l_first_event_id := l_array_header_events(l_array_header_events.FIRST);
73761: l_last_event_id := l_array_header_events(l_array_header_events.LAST);
73762:
73763: fnd_file.put_line(fnd_file.LOG, ' ');
73764: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
73765: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );
73766: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');
73767:
73768: FOR line_record IN line_cur(l_first_event_id, l_last_event_id)
73761: l_last_event_id := l_array_header_events(l_array_header_events.LAST);
73762:
73763: fnd_file.put_line(fnd_file.LOG, ' ');
73764: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
73765: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );
73766: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');
73767:
73768: FOR line_record IN line_cur(l_first_event_id, l_last_event_id)
73769: LOOP
73762:
73763: fnd_file.put_line(fnd_file.LOG, ' ');
73764: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
73765: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );
73766: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');
73767:
73768: FOR line_record IN line_cur(l_first_event_id, l_last_event_id)
73769: LOOP
73770: IF (NOT l_array_header_events.EXISTS(line_record.event_id)) AND (NOT l_array_duplicate_checker.EXISTS(line_record.event_id)) THEN
73767:
73768: FOR line_record IN line_cur(l_first_event_id, l_last_event_id)
73769: LOOP
73770: IF (NOT l_array_header_events.EXISTS(line_record.event_id)) AND (NOT l_array_duplicate_checker.EXISTS(line_record.event_id)) THEN
73771: fnd_file.put_line(fnd_file.log, 'Event_id = ' || line_record.event_id);
73772: l_array_duplicate_checker(line_record.event_id) := line_record.event_id;
73773: END IF;
73774: END LOOP;
73775:
73772: l_array_duplicate_checker(line_record.event_id) := line_record.event_id;
73773: END IF;
73774: END LOOP;
73775:
73776: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
73777: fnd_file.put_line(fnd_file.LOG, ' ');
73778:
73779:
73780: xla_exceptions_pkg.raise_message
73773: END IF;
73774: END LOOP;
73775:
73776: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
73777: fnd_file.put_line(fnd_file.LOG, ' ');
73778:
73779:
73780: xla_exceptions_pkg.raise_message
73781: (p_location => 'XLA_00222_AAD_S_000005_PKG.EventClass_138');
75005:
75006: l_first_event_id := l_array_header_events(l_array_header_events.FIRST);
75007: l_last_event_id := l_array_header_events(l_array_header_events.LAST);
75008:
75009: fnd_file.put_line(fnd_file.LOG, ' ');
75010: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
75011: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );
75012: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');
75013:
75006: l_first_event_id := l_array_header_events(l_array_header_events.FIRST);
75007: l_last_event_id := l_array_header_events(l_array_header_events.LAST);
75008:
75009: fnd_file.put_line(fnd_file.LOG, ' ');
75010: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
75011: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );
75012: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');
75013:
75014: FOR line_record IN line_cur(l_first_event_id, l_last_event_id)
75007: l_last_event_id := l_array_header_events(l_array_header_events.LAST);
75008:
75009: fnd_file.put_line(fnd_file.LOG, ' ');
75010: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
75011: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );
75012: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');
75013:
75014: FOR line_record IN line_cur(l_first_event_id, l_last_event_id)
75015: LOOP
75008:
75009: fnd_file.put_line(fnd_file.LOG, ' ');
75010: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
75011: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );
75012: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');
75013:
75014: FOR line_record IN line_cur(l_first_event_id, l_last_event_id)
75015: LOOP
75016: IF (NOT l_array_header_events.EXISTS(line_record.event_id)) AND (NOT l_array_duplicate_checker.EXISTS(line_record.event_id)) THEN
75013:
75014: FOR line_record IN line_cur(l_first_event_id, l_last_event_id)
75015: LOOP
75016: IF (NOT l_array_header_events.EXISTS(line_record.event_id)) AND (NOT l_array_duplicate_checker.EXISTS(line_record.event_id)) THEN
75017: fnd_file.put_line(fnd_file.log, 'Event_id = ' || line_record.event_id);
75018: l_array_duplicate_checker(line_record.event_id) := line_record.event_id;
75019: END IF;
75020: END LOOP;
75021:
75018: l_array_duplicate_checker(line_record.event_id) := line_record.event_id;
75019: END IF;
75020: END LOOP;
75021:
75022: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
75023: fnd_file.put_line(fnd_file.LOG, ' ');
75024:
75025:
75026: xla_exceptions_pkg.raise_message
75019: END IF;
75020: END LOOP;
75021:
75022: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
75023: fnd_file.put_line(fnd_file.LOG, ' ');
75024:
75025:
75026: xla_exceptions_pkg.raise_message
75027: (p_location => 'XLA_00222_AAD_S_000005_PKG.EventClass_139');
76707:
76708: l_first_event_id := l_array_header_events(l_array_header_events.FIRST);
76709: l_last_event_id := l_array_header_events(l_array_header_events.LAST);
76710:
76711: fnd_file.put_line(fnd_file.LOG, ' ');
76712: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
76713: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );
76714: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');
76715:
76708: l_first_event_id := l_array_header_events(l_array_header_events.FIRST);
76709: l_last_event_id := l_array_header_events(l_array_header_events.LAST);
76710:
76711: fnd_file.put_line(fnd_file.LOG, ' ');
76712: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
76713: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );
76714: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');
76715:
76716: FOR line_record IN line_cur(l_first_event_id, l_last_event_id)
76709: l_last_event_id := l_array_header_events(l_array_header_events.LAST);
76710:
76711: fnd_file.put_line(fnd_file.LOG, ' ');
76712: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
76713: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );
76714: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');
76715:
76716: FOR line_record IN line_cur(l_first_event_id, l_last_event_id)
76717: LOOP
76710:
76711: fnd_file.put_line(fnd_file.LOG, ' ');
76712: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
76713: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );
76714: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');
76715:
76716: FOR line_record IN line_cur(l_first_event_id, l_last_event_id)
76717: LOOP
76718: IF (NOT l_array_header_events.EXISTS(line_record.event_id)) AND (NOT l_array_duplicate_checker.EXISTS(line_record.event_id)) THEN
76715:
76716: FOR line_record IN line_cur(l_first_event_id, l_last_event_id)
76717: LOOP
76718: IF (NOT l_array_header_events.EXISTS(line_record.event_id)) AND (NOT l_array_duplicate_checker.EXISTS(line_record.event_id)) THEN
76719: fnd_file.put_line(fnd_file.log, 'Event_id = ' || line_record.event_id);
76720: l_array_duplicate_checker(line_record.event_id) := line_record.event_id;
76721: END IF;
76722: END LOOP;
76723:
76720: l_array_duplicate_checker(line_record.event_id) := line_record.event_id;
76721: END IF;
76722: END LOOP;
76723:
76724: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
76725: fnd_file.put_line(fnd_file.LOG, ' ');
76726:
76727:
76728: xla_exceptions_pkg.raise_message
76721: END IF;
76722: END LOOP;
76723:
76724: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
76725: fnd_file.put_line(fnd_file.LOG, ' ');
76726:
76727:
76728: xla_exceptions_pkg.raise_message
76729: (p_location => 'XLA_00222_AAD_S_000005_PKG.EventClass_140');
78414:
78415: l_first_event_id := l_array_header_events(l_array_header_events.FIRST);
78416: l_last_event_id := l_array_header_events(l_array_header_events.LAST);
78417:
78418: fnd_file.put_line(fnd_file.LOG, ' ');
78419: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
78420: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );
78421: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');
78422:
78415: l_first_event_id := l_array_header_events(l_array_header_events.FIRST);
78416: l_last_event_id := l_array_header_events(l_array_header_events.LAST);
78417:
78418: fnd_file.put_line(fnd_file.LOG, ' ');
78419: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
78420: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );
78421: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');
78422:
78423: FOR line_record IN line_cur(l_first_event_id, l_last_event_id)
78416: l_last_event_id := l_array_header_events(l_array_header_events.LAST);
78417:
78418: fnd_file.put_line(fnd_file.LOG, ' ');
78419: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
78420: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );
78421: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');
78422:
78423: FOR line_record IN line_cur(l_first_event_id, l_last_event_id)
78424: LOOP
78417:
78418: fnd_file.put_line(fnd_file.LOG, ' ');
78419: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
78420: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );
78421: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');
78422:
78423: FOR line_record IN line_cur(l_first_event_id, l_last_event_id)
78424: LOOP
78425: IF (NOT l_array_header_events.EXISTS(line_record.event_id)) AND (NOT l_array_duplicate_checker.EXISTS(line_record.event_id)) THEN
78422:
78423: FOR line_record IN line_cur(l_first_event_id, l_last_event_id)
78424: LOOP
78425: IF (NOT l_array_header_events.EXISTS(line_record.event_id)) AND (NOT l_array_duplicate_checker.EXISTS(line_record.event_id)) THEN
78426: fnd_file.put_line(fnd_file.log, 'Event_id = ' || line_record.event_id);
78427: l_array_duplicate_checker(line_record.event_id) := line_record.event_id;
78428: END IF;
78429: END LOOP;
78430:
78427: l_array_duplicate_checker(line_record.event_id) := line_record.event_id;
78428: END IF;
78429: END LOOP;
78430:
78431: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
78432: fnd_file.put_line(fnd_file.LOG, ' ');
78433:
78434:
78435: xla_exceptions_pkg.raise_message
78428: END IF;
78429: END LOOP;
78430:
78431: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
78432: fnd_file.put_line(fnd_file.LOG, ' ');
78433:
78434:
78435: xla_exceptions_pkg.raise_message
78436: (p_location => 'XLA_00222_AAD_S_000005_PKG.EventClass_141');
81419:
81420: l_first_event_id := l_array_header_events(l_array_header_events.FIRST);
81421: l_last_event_id := l_array_header_events(l_array_header_events.LAST);
81422:
81423: fnd_file.put_line(fnd_file.LOG, ' ');
81424: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
81425: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );
81426: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');
81427:
81420: l_first_event_id := l_array_header_events(l_array_header_events.FIRST);
81421: l_last_event_id := l_array_header_events(l_array_header_events.LAST);
81422:
81423: fnd_file.put_line(fnd_file.LOG, ' ');
81424: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
81425: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );
81426: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');
81427:
81428: FOR line_record IN line_cur(l_first_event_id, l_last_event_id)
81421: l_last_event_id := l_array_header_events(l_array_header_events.LAST);
81422:
81423: fnd_file.put_line(fnd_file.LOG, ' ');
81424: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
81425: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );
81426: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');
81427:
81428: FOR line_record IN line_cur(l_first_event_id, l_last_event_id)
81429: LOOP
81422:
81423: fnd_file.put_line(fnd_file.LOG, ' ');
81424: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
81425: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );
81426: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');
81427:
81428: FOR line_record IN line_cur(l_first_event_id, l_last_event_id)
81429: LOOP
81430: IF (NOT l_array_header_events.EXISTS(line_record.event_id)) AND (NOT l_array_duplicate_checker.EXISTS(line_record.event_id)) THEN
81427:
81428: FOR line_record IN line_cur(l_first_event_id, l_last_event_id)
81429: LOOP
81430: IF (NOT l_array_header_events.EXISTS(line_record.event_id)) AND (NOT l_array_duplicate_checker.EXISTS(line_record.event_id)) THEN
81431: fnd_file.put_line(fnd_file.log, 'Event_id = ' || line_record.event_id);
81432: l_array_duplicate_checker(line_record.event_id) := line_record.event_id;
81433: END IF;
81434: END LOOP;
81435:
81432: l_array_duplicate_checker(line_record.event_id) := line_record.event_id;
81433: END IF;
81434: END LOOP;
81435:
81436: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
81437: fnd_file.put_line(fnd_file.LOG, ' ');
81438:
81439:
81440: xla_exceptions_pkg.raise_message
81433: END IF;
81434: END LOOP;
81435:
81436: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
81437: fnd_file.put_line(fnd_file.LOG, ' ');
81438:
81439:
81440: xla_exceptions_pkg.raise_message
81441: (p_location => 'XLA_00222_AAD_S_000005_PKG.EventClass_142');