67882:
67883: l_first_event_id := l_array_header_events(l_array_header_events.FIRST);
67884: l_last_event_id := l_array_header_events(l_array_header_events.LAST);
67885:
67886: fnd_file.put_line(fnd_file.LOG, ' ');
67887: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
67888: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );
67889: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');
67890:
67883: l_first_event_id := l_array_header_events(l_array_header_events.FIRST);
67884: l_last_event_id := l_array_header_events(l_array_header_events.LAST);
67885:
67886: fnd_file.put_line(fnd_file.LOG, ' ');
67887: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
67888: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );
67889: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');
67890:
67891: FOR line_record IN line_cur(l_first_event_id, l_last_event_id)
67884: l_last_event_id := l_array_header_events(l_array_header_events.LAST);
67885:
67886: fnd_file.put_line(fnd_file.LOG, ' ');
67887: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
67888: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );
67889: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');
67890:
67891: FOR line_record IN line_cur(l_first_event_id, l_last_event_id)
67892: LOOP
67885:
67886: fnd_file.put_line(fnd_file.LOG, ' ');
67887: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
67888: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );
67889: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');
67890:
67891: FOR line_record IN line_cur(l_first_event_id, l_last_event_id)
67892: LOOP
67893: IF (NOT l_array_header_events.EXISTS(line_record.event_id)) AND (NOT l_array_duplicate_checker.EXISTS(line_record.event_id)) THEN
67890:
67891: FOR line_record IN line_cur(l_first_event_id, l_last_event_id)
67892: LOOP
67893: IF (NOT l_array_header_events.EXISTS(line_record.event_id)) AND (NOT l_array_duplicate_checker.EXISTS(line_record.event_id)) THEN
67894: fnd_file.put_line(fnd_file.log, 'Event_id = ' || line_record.event_id);
67895: l_array_duplicate_checker(line_record.event_id) := line_record.event_id;
67896: END IF;
67897: END LOOP;
67898:
67895: l_array_duplicate_checker(line_record.event_id) := line_record.event_id;
67896: END IF;
67897: END LOOP;
67898:
67899: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
67900: fnd_file.put_line(fnd_file.LOG, ' ');
67901:
67902:
67903: xla_exceptions_pkg.raise_message
67896: END IF;
67897: END LOOP;
67898:
67899: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
67900: fnd_file.put_line(fnd_file.LOG, ' ');
67901:
67902:
67903: xla_exceptions_pkg.raise_message
67904: (p_location => 'XLA_00222_AAD_S_000002_PKG.EventClass_143');
69269:
69270: l_first_event_id := l_array_header_events(l_array_header_events.FIRST);
69271: l_last_event_id := l_array_header_events(l_array_header_events.LAST);
69272:
69273: fnd_file.put_line(fnd_file.LOG, ' ');
69274: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
69275: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );
69276: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');
69277:
69270: l_first_event_id := l_array_header_events(l_array_header_events.FIRST);
69271: l_last_event_id := l_array_header_events(l_array_header_events.LAST);
69272:
69273: fnd_file.put_line(fnd_file.LOG, ' ');
69274: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
69275: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );
69276: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');
69277:
69278: FOR line_record IN line_cur(l_first_event_id, l_last_event_id)
69271: l_last_event_id := l_array_header_events(l_array_header_events.LAST);
69272:
69273: fnd_file.put_line(fnd_file.LOG, ' ');
69274: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
69275: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );
69276: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');
69277:
69278: FOR line_record IN line_cur(l_first_event_id, l_last_event_id)
69279: LOOP
69272:
69273: fnd_file.put_line(fnd_file.LOG, ' ');
69274: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
69275: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );
69276: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');
69277:
69278: FOR line_record IN line_cur(l_first_event_id, l_last_event_id)
69279: LOOP
69280: IF (NOT l_array_header_events.EXISTS(line_record.event_id)) AND (NOT l_array_duplicate_checker.EXISTS(line_record.event_id)) THEN
69277:
69278: FOR line_record IN line_cur(l_first_event_id, l_last_event_id)
69279: LOOP
69280: IF (NOT l_array_header_events.EXISTS(line_record.event_id)) AND (NOT l_array_duplicate_checker.EXISTS(line_record.event_id)) THEN
69281: fnd_file.put_line(fnd_file.log, 'Event_id = ' || line_record.event_id);
69282: l_array_duplicate_checker(line_record.event_id) := line_record.event_id;
69283: END IF;
69284: END LOOP;
69285:
69282: l_array_duplicate_checker(line_record.event_id) := line_record.event_id;
69283: END IF;
69284: END LOOP;
69285:
69286: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
69287: fnd_file.put_line(fnd_file.LOG, ' ');
69288:
69289:
69290: xla_exceptions_pkg.raise_message
69283: END IF;
69284: END LOOP;
69285:
69286: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
69287: fnd_file.put_line(fnd_file.LOG, ' ');
69288:
69289:
69290: xla_exceptions_pkg.raise_message
69291: (p_location => 'XLA_00222_AAD_S_000002_PKG.EventClass_144');
70547:
70548: l_first_event_id := l_array_header_events(l_array_header_events.FIRST);
70549: l_last_event_id := l_array_header_events(l_array_header_events.LAST);
70550:
70551: fnd_file.put_line(fnd_file.LOG, ' ');
70552: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
70553: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );
70554: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');
70555:
70548: l_first_event_id := l_array_header_events(l_array_header_events.FIRST);
70549: l_last_event_id := l_array_header_events(l_array_header_events.LAST);
70550:
70551: fnd_file.put_line(fnd_file.LOG, ' ');
70552: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
70553: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );
70554: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');
70555:
70556: FOR line_record IN line_cur(l_first_event_id, l_last_event_id)
70549: l_last_event_id := l_array_header_events(l_array_header_events.LAST);
70550:
70551: fnd_file.put_line(fnd_file.LOG, ' ');
70552: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
70553: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );
70554: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');
70555:
70556: FOR line_record IN line_cur(l_first_event_id, l_last_event_id)
70557: LOOP
70550:
70551: fnd_file.put_line(fnd_file.LOG, ' ');
70552: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
70553: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );
70554: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');
70555:
70556: FOR line_record IN line_cur(l_first_event_id, l_last_event_id)
70557: LOOP
70558: IF (NOT l_array_header_events.EXISTS(line_record.event_id)) AND (NOT l_array_duplicate_checker.EXISTS(line_record.event_id)) THEN
70555:
70556: FOR line_record IN line_cur(l_first_event_id, l_last_event_id)
70557: LOOP
70558: IF (NOT l_array_header_events.EXISTS(line_record.event_id)) AND (NOT l_array_duplicate_checker.EXISTS(line_record.event_id)) THEN
70559: fnd_file.put_line(fnd_file.log, 'Event_id = ' || line_record.event_id);
70560: l_array_duplicate_checker(line_record.event_id) := line_record.event_id;
70561: END IF;
70562: END LOOP;
70563:
70560: l_array_duplicate_checker(line_record.event_id) := line_record.event_id;
70561: END IF;
70562: END LOOP;
70563:
70564: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
70565: fnd_file.put_line(fnd_file.LOG, ' ');
70566:
70567:
70568: xla_exceptions_pkg.raise_message
70561: END IF;
70562: END LOOP;
70563:
70564: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
70565: fnd_file.put_line(fnd_file.LOG, ' ');
70566:
70567:
70568: xla_exceptions_pkg.raise_message
70569: (p_location => 'XLA_00222_AAD_S_000002_PKG.EventClass_145');
72313:
72314: l_first_event_id := l_array_header_events(l_array_header_events.FIRST);
72315: l_last_event_id := l_array_header_events(l_array_header_events.LAST);
72316:
72317: fnd_file.put_line(fnd_file.LOG, ' ');
72318: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
72319: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );
72320: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');
72321:
72314: l_first_event_id := l_array_header_events(l_array_header_events.FIRST);
72315: l_last_event_id := l_array_header_events(l_array_header_events.LAST);
72316:
72317: fnd_file.put_line(fnd_file.LOG, ' ');
72318: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
72319: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );
72320: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');
72321:
72322: FOR line_record IN line_cur(l_first_event_id, l_last_event_id)
72315: l_last_event_id := l_array_header_events(l_array_header_events.LAST);
72316:
72317: fnd_file.put_line(fnd_file.LOG, ' ');
72318: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
72319: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );
72320: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');
72321:
72322: FOR line_record IN line_cur(l_first_event_id, l_last_event_id)
72323: LOOP
72316:
72317: fnd_file.put_line(fnd_file.LOG, ' ');
72318: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
72319: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );
72320: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');
72321:
72322: FOR line_record IN line_cur(l_first_event_id, l_last_event_id)
72323: LOOP
72324: IF (NOT l_array_header_events.EXISTS(line_record.event_id)) AND (NOT l_array_duplicate_checker.EXISTS(line_record.event_id)) THEN
72321:
72322: FOR line_record IN line_cur(l_first_event_id, l_last_event_id)
72323: LOOP
72324: IF (NOT l_array_header_events.EXISTS(line_record.event_id)) AND (NOT l_array_duplicate_checker.EXISTS(line_record.event_id)) THEN
72325: fnd_file.put_line(fnd_file.log, 'Event_id = ' || line_record.event_id);
72326: l_array_duplicate_checker(line_record.event_id) := line_record.event_id;
72327: END IF;
72328: END LOOP;
72329:
72326: l_array_duplicate_checker(line_record.event_id) := line_record.event_id;
72327: END IF;
72328: END LOOP;
72329:
72330: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
72331: fnd_file.put_line(fnd_file.LOG, ' ');
72332:
72333:
72334: xla_exceptions_pkg.raise_message
72327: END IF;
72328: END LOOP;
72329:
72330: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
72331: fnd_file.put_line(fnd_file.LOG, ' ');
72332:
72333:
72334: xla_exceptions_pkg.raise_message
72335: (p_location => 'XLA_00222_AAD_S_000002_PKG.EventClass_146');
74086:
74087: l_first_event_id := l_array_header_events(l_array_header_events.FIRST);
74088: l_last_event_id := l_array_header_events(l_array_header_events.LAST);
74089:
74090: fnd_file.put_line(fnd_file.LOG, ' ');
74091: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
74092: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );
74093: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');
74094:
74087: l_first_event_id := l_array_header_events(l_array_header_events.FIRST);
74088: l_last_event_id := l_array_header_events(l_array_header_events.LAST);
74089:
74090: fnd_file.put_line(fnd_file.LOG, ' ');
74091: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
74092: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );
74093: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');
74094:
74095: FOR line_record IN line_cur(l_first_event_id, l_last_event_id)
74088: l_last_event_id := l_array_header_events(l_array_header_events.LAST);
74089:
74090: fnd_file.put_line(fnd_file.LOG, ' ');
74091: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
74092: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );
74093: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');
74094:
74095: FOR line_record IN line_cur(l_first_event_id, l_last_event_id)
74096: LOOP
74089:
74090: fnd_file.put_line(fnd_file.LOG, ' ');
74091: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
74092: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );
74093: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');
74094:
74095: FOR line_record IN line_cur(l_first_event_id, l_last_event_id)
74096: LOOP
74097: IF (NOT l_array_header_events.EXISTS(line_record.event_id)) AND (NOT l_array_duplicate_checker.EXISTS(line_record.event_id)) THEN
74094:
74095: FOR line_record IN line_cur(l_first_event_id, l_last_event_id)
74096: LOOP
74097: IF (NOT l_array_header_events.EXISTS(line_record.event_id)) AND (NOT l_array_duplicate_checker.EXISTS(line_record.event_id)) THEN
74098: fnd_file.put_line(fnd_file.log, 'Event_id = ' || line_record.event_id);
74099: l_array_duplicate_checker(line_record.event_id) := line_record.event_id;
74100: END IF;
74101: END LOOP;
74102:
74099: l_array_duplicate_checker(line_record.event_id) := line_record.event_id;
74100: END IF;
74101: END LOOP;
74102:
74103: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
74104: fnd_file.put_line(fnd_file.LOG, ' ');
74105:
74106:
74107: xla_exceptions_pkg.raise_message
74100: END IF;
74101: END LOOP;
74102:
74103: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
74104: fnd_file.put_line(fnd_file.LOG, ' ');
74105:
74106:
74107: xla_exceptions_pkg.raise_message
74108: (p_location => 'XLA_00222_AAD_S_000002_PKG.EventClass_147');
75599:
75600: l_first_event_id := l_array_header_events(l_array_header_events.FIRST);
75601: l_last_event_id := l_array_header_events(l_array_header_events.LAST);
75602:
75603: fnd_file.put_line(fnd_file.LOG, ' ');
75604: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
75605: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );
75606: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');
75607:
75600: l_first_event_id := l_array_header_events(l_array_header_events.FIRST);
75601: l_last_event_id := l_array_header_events(l_array_header_events.LAST);
75602:
75603: fnd_file.put_line(fnd_file.LOG, ' ');
75604: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
75605: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );
75606: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');
75607:
75608: FOR line_record IN line_cur(l_first_event_id, l_last_event_id)
75601: l_last_event_id := l_array_header_events(l_array_header_events.LAST);
75602:
75603: fnd_file.put_line(fnd_file.LOG, ' ');
75604: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
75605: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );
75606: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');
75607:
75608: FOR line_record IN line_cur(l_first_event_id, l_last_event_id)
75609: LOOP
75602:
75603: fnd_file.put_line(fnd_file.LOG, ' ');
75604: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
75605: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );
75606: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');
75607:
75608: FOR line_record IN line_cur(l_first_event_id, l_last_event_id)
75609: LOOP
75610: IF (NOT l_array_header_events.EXISTS(line_record.event_id)) AND (NOT l_array_duplicate_checker.EXISTS(line_record.event_id)) THEN
75607:
75608: FOR line_record IN line_cur(l_first_event_id, l_last_event_id)
75609: LOOP
75610: IF (NOT l_array_header_events.EXISTS(line_record.event_id)) AND (NOT l_array_duplicate_checker.EXISTS(line_record.event_id)) THEN
75611: fnd_file.put_line(fnd_file.log, 'Event_id = ' || line_record.event_id);
75612: l_array_duplicate_checker(line_record.event_id) := line_record.event_id;
75613: END IF;
75614: END LOOP;
75615:
75612: l_array_duplicate_checker(line_record.event_id) := line_record.event_id;
75613: END IF;
75614: END LOOP;
75615:
75616: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
75617: fnd_file.put_line(fnd_file.LOG, ' ');
75618:
75619:
75620: xla_exceptions_pkg.raise_message
75613: END IF;
75614: END LOOP;
75615:
75616: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
75617: fnd_file.put_line(fnd_file.LOG, ' ');
75618:
75619:
75620: xla_exceptions_pkg.raise_message
75621: (p_location => 'XLA_00222_AAD_S_000002_PKG.EventClass_148');
76877:
76878: l_first_event_id := l_array_header_events(l_array_header_events.FIRST);
76879: l_last_event_id := l_array_header_events(l_array_header_events.LAST);
76880:
76881: fnd_file.put_line(fnd_file.LOG, ' ');
76882: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
76883: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );
76884: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');
76885:
76878: l_first_event_id := l_array_header_events(l_array_header_events.FIRST);
76879: l_last_event_id := l_array_header_events(l_array_header_events.LAST);
76880:
76881: fnd_file.put_line(fnd_file.LOG, ' ');
76882: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
76883: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );
76884: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');
76885:
76886: FOR line_record IN line_cur(l_first_event_id, l_last_event_id)
76879: l_last_event_id := l_array_header_events(l_array_header_events.LAST);
76880:
76881: fnd_file.put_line(fnd_file.LOG, ' ');
76882: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
76883: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );
76884: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');
76885:
76886: FOR line_record IN line_cur(l_first_event_id, l_last_event_id)
76887: LOOP
76880:
76881: fnd_file.put_line(fnd_file.LOG, ' ');
76882: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
76883: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );
76884: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');
76885:
76886: FOR line_record IN line_cur(l_first_event_id, l_last_event_id)
76887: LOOP
76888: IF (NOT l_array_header_events.EXISTS(line_record.event_id)) AND (NOT l_array_duplicate_checker.EXISTS(line_record.event_id)) THEN
76885:
76886: FOR line_record IN line_cur(l_first_event_id, l_last_event_id)
76887: LOOP
76888: IF (NOT l_array_header_events.EXISTS(line_record.event_id)) AND (NOT l_array_duplicate_checker.EXISTS(line_record.event_id)) THEN
76889: fnd_file.put_line(fnd_file.log, 'Event_id = ' || line_record.event_id);
76890: l_array_duplicate_checker(line_record.event_id) := line_record.event_id;
76891: END IF;
76892: END LOOP;
76893:
76890: l_array_duplicate_checker(line_record.event_id) := line_record.event_id;
76891: END IF;
76892: END LOOP;
76893:
76894: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
76895: fnd_file.put_line(fnd_file.LOG, ' ');
76896:
76897:
76898: xla_exceptions_pkg.raise_message
76891: END IF;
76892: END LOOP;
76893:
76894: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
76895: fnd_file.put_line(fnd_file.LOG, ' ');
76896:
76897:
76898: xla_exceptions_pkg.raise_message
76899: (p_location => 'XLA_00222_AAD_S_000002_PKG.EventClass_149');
78698:
78699: l_first_event_id := l_array_header_events(l_array_header_events.FIRST);
78700: l_last_event_id := l_array_header_events(l_array_header_events.LAST);
78701:
78702: fnd_file.put_line(fnd_file.LOG, ' ');
78703: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
78704: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );
78705: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');
78706:
78699: l_first_event_id := l_array_header_events(l_array_header_events.FIRST);
78700: l_last_event_id := l_array_header_events(l_array_header_events.LAST);
78701:
78702: fnd_file.put_line(fnd_file.LOG, ' ');
78703: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
78704: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );
78705: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');
78706:
78707: FOR line_record IN line_cur(l_first_event_id, l_last_event_id)
78700: l_last_event_id := l_array_header_events(l_array_header_events.LAST);
78701:
78702: fnd_file.put_line(fnd_file.LOG, ' ');
78703: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
78704: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );
78705: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');
78706:
78707: FOR line_record IN line_cur(l_first_event_id, l_last_event_id)
78708: LOOP
78701:
78702: fnd_file.put_line(fnd_file.LOG, ' ');
78703: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
78704: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );
78705: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');
78706:
78707: FOR line_record IN line_cur(l_first_event_id, l_last_event_id)
78708: LOOP
78709: IF (NOT l_array_header_events.EXISTS(line_record.event_id)) AND (NOT l_array_duplicate_checker.EXISTS(line_record.event_id)) THEN
78706:
78707: FOR line_record IN line_cur(l_first_event_id, l_last_event_id)
78708: LOOP
78709: IF (NOT l_array_header_events.EXISTS(line_record.event_id)) AND (NOT l_array_duplicate_checker.EXISTS(line_record.event_id)) THEN
78710: fnd_file.put_line(fnd_file.log, 'Event_id = ' || line_record.event_id);
78711: l_array_duplicate_checker(line_record.event_id) := line_record.event_id;
78712: END IF;
78713: END LOOP;
78714:
78711: l_array_duplicate_checker(line_record.event_id) := line_record.event_id;
78712: END IF;
78713: END LOOP;
78714:
78715: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
78716: fnd_file.put_line(fnd_file.LOG, ' ');
78717:
78718:
78719: xla_exceptions_pkg.raise_message
78712: END IF;
78713: END LOOP;
78714:
78715: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
78716: fnd_file.put_line(fnd_file.LOG, ' ');
78717:
78718:
78719: xla_exceptions_pkg.raise_message
78720: (p_location => 'XLA_00222_AAD_S_000002_PKG.EventClass_150');
79976:
79977: l_first_event_id := l_array_header_events(l_array_header_events.FIRST);
79978: l_last_event_id := l_array_header_events(l_array_header_events.LAST);
79979:
79980: fnd_file.put_line(fnd_file.LOG, ' ');
79981: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
79982: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );
79983: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');
79984:
79977: l_first_event_id := l_array_header_events(l_array_header_events.FIRST);
79978: l_last_event_id := l_array_header_events(l_array_header_events.LAST);
79979:
79980: fnd_file.put_line(fnd_file.LOG, ' ');
79981: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
79982: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );
79983: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');
79984:
79985: FOR line_record IN line_cur(l_first_event_id, l_last_event_id)
79978: l_last_event_id := l_array_header_events(l_array_header_events.LAST);
79979:
79980: fnd_file.put_line(fnd_file.LOG, ' ');
79981: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
79982: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );
79983: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');
79984:
79985: FOR line_record IN line_cur(l_first_event_id, l_last_event_id)
79986: LOOP
79979:
79980: fnd_file.put_line(fnd_file.LOG, ' ');
79981: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
79982: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );
79983: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');
79984:
79985: FOR line_record IN line_cur(l_first_event_id, l_last_event_id)
79986: LOOP
79987: IF (NOT l_array_header_events.EXISTS(line_record.event_id)) AND (NOT l_array_duplicate_checker.EXISTS(line_record.event_id)) THEN
79984:
79985: FOR line_record IN line_cur(l_first_event_id, l_last_event_id)
79986: LOOP
79987: IF (NOT l_array_header_events.EXISTS(line_record.event_id)) AND (NOT l_array_duplicate_checker.EXISTS(line_record.event_id)) THEN
79988: fnd_file.put_line(fnd_file.log, 'Event_id = ' || line_record.event_id);
79989: l_array_duplicate_checker(line_record.event_id) := line_record.event_id;
79990: END IF;
79991: END LOOP;
79992:
79989: l_array_duplicate_checker(line_record.event_id) := line_record.event_id;
79990: END IF;
79991: END LOOP;
79992:
79993: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
79994: fnd_file.put_line(fnd_file.LOG, ' ');
79995:
79996:
79997: xla_exceptions_pkg.raise_message
79990: END IF;
79991: END LOOP;
79992:
79993: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
79994: fnd_file.put_line(fnd_file.LOG, ' ');
79995:
79996:
79997: xla_exceptions_pkg.raise_message
79998: (p_location => 'XLA_00222_AAD_S_000002_PKG.EventClass_151');
81600:
81601: l_first_event_id := l_array_header_events(l_array_header_events.FIRST);
81602: l_last_event_id := l_array_header_events(l_array_header_events.LAST);
81603:
81604: fnd_file.put_line(fnd_file.LOG, ' ');
81605: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
81606: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );
81607: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');
81608:
81601: l_first_event_id := l_array_header_events(l_array_header_events.FIRST);
81602: l_last_event_id := l_array_header_events(l_array_header_events.LAST);
81603:
81604: fnd_file.put_line(fnd_file.LOG, ' ');
81605: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
81606: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );
81607: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');
81608:
81609: FOR line_record IN line_cur(l_first_event_id, l_last_event_id)
81602: l_last_event_id := l_array_header_events(l_array_header_events.LAST);
81603:
81604: fnd_file.put_line(fnd_file.LOG, ' ');
81605: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
81606: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );
81607: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');
81608:
81609: FOR line_record IN line_cur(l_first_event_id, l_last_event_id)
81610: LOOP
81603:
81604: fnd_file.put_line(fnd_file.LOG, ' ');
81605: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
81606: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );
81607: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');
81608:
81609: FOR line_record IN line_cur(l_first_event_id, l_last_event_id)
81610: LOOP
81611: IF (NOT l_array_header_events.EXISTS(line_record.event_id)) AND (NOT l_array_duplicate_checker.EXISTS(line_record.event_id)) THEN
81608:
81609: FOR line_record IN line_cur(l_first_event_id, l_last_event_id)
81610: LOOP
81611: IF (NOT l_array_header_events.EXISTS(line_record.event_id)) AND (NOT l_array_duplicate_checker.EXISTS(line_record.event_id)) THEN
81612: fnd_file.put_line(fnd_file.log, 'Event_id = ' || line_record.event_id);
81613: l_array_duplicate_checker(line_record.event_id) := line_record.event_id;
81614: END IF;
81615: END LOOP;
81616:
81613: l_array_duplicate_checker(line_record.event_id) := line_record.event_id;
81614: END IF;
81615: END LOOP;
81616:
81617: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
81618: fnd_file.put_line(fnd_file.LOG, ' ');
81619:
81620:
81621: xla_exceptions_pkg.raise_message
81614: END IF;
81615: END LOOP;
81616:
81617: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
81618: fnd_file.put_line(fnd_file.LOG, ' ');
81619:
81620:
81621: xla_exceptions_pkg.raise_message
81622: (p_location => 'XLA_00222_AAD_S_000002_PKG.EventClass_152');
83067:
83068: l_first_event_id := l_array_header_events(l_array_header_events.FIRST);
83069: l_last_event_id := l_array_header_events(l_array_header_events.LAST);
83070:
83071: fnd_file.put_line(fnd_file.LOG, ' ');
83072: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
83073: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );
83074: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');
83075:
83068: l_first_event_id := l_array_header_events(l_array_header_events.FIRST);
83069: l_last_event_id := l_array_header_events(l_array_header_events.LAST);
83070:
83071: fnd_file.put_line(fnd_file.LOG, ' ');
83072: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
83073: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );
83074: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');
83075:
83076: FOR line_record IN line_cur(l_first_event_id, l_last_event_id)
83069: l_last_event_id := l_array_header_events(l_array_header_events.LAST);
83070:
83071: fnd_file.put_line(fnd_file.LOG, ' ');
83072: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
83073: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );
83074: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');
83075:
83076: FOR line_record IN line_cur(l_first_event_id, l_last_event_id)
83077: LOOP
83070:
83071: fnd_file.put_line(fnd_file.LOG, ' ');
83072: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
83073: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );
83074: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');
83075:
83076: FOR line_record IN line_cur(l_first_event_id, l_last_event_id)
83077: LOOP
83078: IF (NOT l_array_header_events.EXISTS(line_record.event_id)) AND (NOT l_array_duplicate_checker.EXISTS(line_record.event_id)) THEN
83075:
83076: FOR line_record IN line_cur(l_first_event_id, l_last_event_id)
83077: LOOP
83078: IF (NOT l_array_header_events.EXISTS(line_record.event_id)) AND (NOT l_array_duplicate_checker.EXISTS(line_record.event_id)) THEN
83079: fnd_file.put_line(fnd_file.log, 'Event_id = ' || line_record.event_id);
83080: l_array_duplicate_checker(line_record.event_id) := line_record.event_id;
83081: END IF;
83082: END LOOP;
83083:
83080: l_array_duplicate_checker(line_record.event_id) := line_record.event_id;
83081: END IF;
83082: END LOOP;
83083:
83084: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
83085: fnd_file.put_line(fnd_file.LOG, ' ');
83086:
83087:
83088: xla_exceptions_pkg.raise_message
83081: END IF;
83082: END LOOP;
83083:
83084: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
83085: fnd_file.put_line(fnd_file.LOG, ' ');
83086:
83087:
83088: xla_exceptions_pkg.raise_message
83089: (p_location => 'XLA_00222_AAD_S_000002_PKG.EventClass_153');
85726:
85727: l_first_event_id := l_array_header_events(l_array_header_events.FIRST);
85728: l_last_event_id := l_array_header_events(l_array_header_events.LAST);
85729:
85730: fnd_file.put_line(fnd_file.LOG, ' ');
85731: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
85732: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );
85733: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');
85734:
85727: l_first_event_id := l_array_header_events(l_array_header_events.FIRST);
85728: l_last_event_id := l_array_header_events(l_array_header_events.LAST);
85729:
85730: fnd_file.put_line(fnd_file.LOG, ' ');
85731: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
85732: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );
85733: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');
85734:
85735: FOR line_record IN line_cur(l_first_event_id, l_last_event_id)
85728: l_last_event_id := l_array_header_events(l_array_header_events.LAST);
85729:
85730: fnd_file.put_line(fnd_file.LOG, ' ');
85731: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
85732: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );
85733: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');
85734:
85735: FOR line_record IN line_cur(l_first_event_id, l_last_event_id)
85736: LOOP
85729:
85730: fnd_file.put_line(fnd_file.LOG, ' ');
85731: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
85732: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );
85733: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');
85734:
85735: FOR line_record IN line_cur(l_first_event_id, l_last_event_id)
85736: LOOP
85737: IF (NOT l_array_header_events.EXISTS(line_record.event_id)) AND (NOT l_array_duplicate_checker.EXISTS(line_record.event_id)) THEN
85734:
85735: FOR line_record IN line_cur(l_first_event_id, l_last_event_id)
85736: LOOP
85737: IF (NOT l_array_header_events.EXISTS(line_record.event_id)) AND (NOT l_array_duplicate_checker.EXISTS(line_record.event_id)) THEN
85738: fnd_file.put_line(fnd_file.log, 'Event_id = ' || line_record.event_id);
85739: l_array_duplicate_checker(line_record.event_id) := line_record.event_id;
85740: END IF;
85741: END LOOP;
85742:
85739: l_array_duplicate_checker(line_record.event_id) := line_record.event_id;
85740: END IF;
85741: END LOOP;
85742:
85743: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
85744: fnd_file.put_line(fnd_file.LOG, ' ');
85745:
85746:
85747: xla_exceptions_pkg.raise_message
85740: END IF;
85741: END LOOP;
85742:
85743: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
85744: fnd_file.put_line(fnd_file.LOG, ' ');
85745:
85746:
85747: xla_exceptions_pkg.raise_message
85748: (p_location => 'XLA_00222_AAD_S_000002_PKG.EventClass_154');