54047:
54048: l_first_event_id := l_array_header_events(l_array_header_events.FIRST);
54049: l_last_event_id := l_array_header_events(l_array_header_events.LAST);
54050:
54051: fnd_file.put_line(fnd_file.LOG, ' ');
54052: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
54053: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );
54054: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');
54055:
54048: l_first_event_id := l_array_header_events(l_array_header_events.FIRST);
54049: l_last_event_id := l_array_header_events(l_array_header_events.LAST);
54050:
54051: fnd_file.put_line(fnd_file.LOG, ' ');
54052: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
54053: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );
54054: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');
54055:
54056: FOR line_record IN line_cur(l_first_event_id, l_last_event_id)
54049: l_last_event_id := l_array_header_events(l_array_header_events.LAST);
54050:
54051: fnd_file.put_line(fnd_file.LOG, ' ');
54052: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
54053: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );
54054: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');
54055:
54056: FOR line_record IN line_cur(l_first_event_id, l_last_event_id)
54057: LOOP
54050:
54051: fnd_file.put_line(fnd_file.LOG, ' ');
54052: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
54053: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );
54054: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');
54055:
54056: FOR line_record IN line_cur(l_first_event_id, l_last_event_id)
54057: LOOP
54058: IF (NOT l_array_header_events.EXISTS(line_record.event_id)) AND (NOT l_array_duplicate_checker.EXISTS(line_record.event_id)) THEN
54055:
54056: FOR line_record IN line_cur(l_first_event_id, l_last_event_id)
54057: LOOP
54058: IF (NOT l_array_header_events.EXISTS(line_record.event_id)) AND (NOT l_array_duplicate_checker.EXISTS(line_record.event_id)) THEN
54059: fnd_file.put_line(fnd_file.log, 'Event_id = ' || line_record.event_id);
54060: l_array_duplicate_checker(line_record.event_id) := line_record.event_id;
54061: END IF;
54062: END LOOP;
54063:
54060: l_array_duplicate_checker(line_record.event_id) := line_record.event_id;
54061: END IF;
54062: END LOOP;
54063:
54064: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
54065: fnd_file.put_line(fnd_file.LOG, ' ');
54066:
54067:
54068: xla_exceptions_pkg.raise_message
54061: END IF;
54062: END LOOP;
54063:
54064: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
54065: fnd_file.put_line(fnd_file.LOG, ' ');
54066:
54067:
54068: xla_exceptions_pkg.raise_message
54069: (p_location => 'XLA_00222_AAD_S_000008_PKG.EventClass_102');
55293:
55294: l_first_event_id := l_array_header_events(l_array_header_events.FIRST);
55295: l_last_event_id := l_array_header_events(l_array_header_events.LAST);
55296:
55297: fnd_file.put_line(fnd_file.LOG, ' ');
55298: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
55299: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );
55300: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');
55301:
55294: l_first_event_id := l_array_header_events(l_array_header_events.FIRST);
55295: l_last_event_id := l_array_header_events(l_array_header_events.LAST);
55296:
55297: fnd_file.put_line(fnd_file.LOG, ' ');
55298: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
55299: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );
55300: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');
55301:
55302: FOR line_record IN line_cur(l_first_event_id, l_last_event_id)
55295: l_last_event_id := l_array_header_events(l_array_header_events.LAST);
55296:
55297: fnd_file.put_line(fnd_file.LOG, ' ');
55298: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
55299: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );
55300: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');
55301:
55302: FOR line_record IN line_cur(l_first_event_id, l_last_event_id)
55303: LOOP
55296:
55297: fnd_file.put_line(fnd_file.LOG, ' ');
55298: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
55299: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );
55300: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');
55301:
55302: FOR line_record IN line_cur(l_first_event_id, l_last_event_id)
55303: LOOP
55304: IF (NOT l_array_header_events.EXISTS(line_record.event_id)) AND (NOT l_array_duplicate_checker.EXISTS(line_record.event_id)) THEN
55301:
55302: FOR line_record IN line_cur(l_first_event_id, l_last_event_id)
55303: LOOP
55304: IF (NOT l_array_header_events.EXISTS(line_record.event_id)) AND (NOT l_array_duplicate_checker.EXISTS(line_record.event_id)) THEN
55305: fnd_file.put_line(fnd_file.log, 'Event_id = ' || line_record.event_id);
55306: l_array_duplicate_checker(line_record.event_id) := line_record.event_id;
55307: END IF;
55308: END LOOP;
55309:
55306: l_array_duplicate_checker(line_record.event_id) := line_record.event_id;
55307: END IF;
55308: END LOOP;
55309:
55310: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
55311: fnd_file.put_line(fnd_file.LOG, ' ');
55312:
55313:
55314: xla_exceptions_pkg.raise_message
55307: END IF;
55308: END LOOP;
55309:
55310: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
55311: fnd_file.put_line(fnd_file.LOG, ' ');
55312:
55313:
55314: xla_exceptions_pkg.raise_message
55315: (p_location => 'XLA_00222_AAD_S_000008_PKG.EventClass_103');
56912:
56913: l_first_event_id := l_array_header_events(l_array_header_events.FIRST);
56914: l_last_event_id := l_array_header_events(l_array_header_events.LAST);
56915:
56916: fnd_file.put_line(fnd_file.LOG, ' ');
56917: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
56918: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );
56919: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');
56920:
56913: l_first_event_id := l_array_header_events(l_array_header_events.FIRST);
56914: l_last_event_id := l_array_header_events(l_array_header_events.LAST);
56915:
56916: fnd_file.put_line(fnd_file.LOG, ' ');
56917: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
56918: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );
56919: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');
56920:
56921: FOR line_record IN line_cur(l_first_event_id, l_last_event_id)
56914: l_last_event_id := l_array_header_events(l_array_header_events.LAST);
56915:
56916: fnd_file.put_line(fnd_file.LOG, ' ');
56917: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
56918: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );
56919: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');
56920:
56921: FOR line_record IN line_cur(l_first_event_id, l_last_event_id)
56922: LOOP
56915:
56916: fnd_file.put_line(fnd_file.LOG, ' ');
56917: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
56918: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );
56919: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');
56920:
56921: FOR line_record IN line_cur(l_first_event_id, l_last_event_id)
56922: LOOP
56923: IF (NOT l_array_header_events.EXISTS(line_record.event_id)) AND (NOT l_array_duplicate_checker.EXISTS(line_record.event_id)) THEN
56920:
56921: FOR line_record IN line_cur(l_first_event_id, l_last_event_id)
56922: LOOP
56923: IF (NOT l_array_header_events.EXISTS(line_record.event_id)) AND (NOT l_array_duplicate_checker.EXISTS(line_record.event_id)) THEN
56924: fnd_file.put_line(fnd_file.log, 'Event_id = ' || line_record.event_id);
56925: l_array_duplicate_checker(line_record.event_id) := line_record.event_id;
56926: END IF;
56927: END LOOP;
56928:
56925: l_array_duplicate_checker(line_record.event_id) := line_record.event_id;
56926: END IF;
56927: END LOOP;
56928:
56929: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
56930: fnd_file.put_line(fnd_file.LOG, ' ');
56931:
56932:
56933: xla_exceptions_pkg.raise_message
56926: END IF;
56927: END LOOP;
56928:
56929: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
56930: fnd_file.put_line(fnd_file.LOG, ' ');
56931:
56932:
56933: xla_exceptions_pkg.raise_message
56934: (p_location => 'XLA_00222_AAD_S_000008_PKG.EventClass_104');
58383:
58384: l_first_event_id := l_array_header_events(l_array_header_events.FIRST);
58385: l_last_event_id := l_array_header_events(l_array_header_events.LAST);
58386:
58387: fnd_file.put_line(fnd_file.LOG, ' ');
58388: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
58389: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );
58390: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');
58391:
58384: l_first_event_id := l_array_header_events(l_array_header_events.FIRST);
58385: l_last_event_id := l_array_header_events(l_array_header_events.LAST);
58386:
58387: fnd_file.put_line(fnd_file.LOG, ' ');
58388: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
58389: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );
58390: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');
58391:
58392: FOR line_record IN line_cur(l_first_event_id, l_last_event_id)
58385: l_last_event_id := l_array_header_events(l_array_header_events.LAST);
58386:
58387: fnd_file.put_line(fnd_file.LOG, ' ');
58388: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
58389: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );
58390: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');
58391:
58392: FOR line_record IN line_cur(l_first_event_id, l_last_event_id)
58393: LOOP
58386:
58387: fnd_file.put_line(fnd_file.LOG, ' ');
58388: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
58389: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );
58390: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');
58391:
58392: FOR line_record IN line_cur(l_first_event_id, l_last_event_id)
58393: LOOP
58394: IF (NOT l_array_header_events.EXISTS(line_record.event_id)) AND (NOT l_array_duplicate_checker.EXISTS(line_record.event_id)) THEN
58391:
58392: FOR line_record IN line_cur(l_first_event_id, l_last_event_id)
58393: LOOP
58394: IF (NOT l_array_header_events.EXISTS(line_record.event_id)) AND (NOT l_array_duplicate_checker.EXISTS(line_record.event_id)) THEN
58395: fnd_file.put_line(fnd_file.log, 'Event_id = ' || line_record.event_id);
58396: l_array_duplicate_checker(line_record.event_id) := line_record.event_id;
58397: END IF;
58398: END LOOP;
58399:
58396: l_array_duplicate_checker(line_record.event_id) := line_record.event_id;
58397: END IF;
58398: END LOOP;
58399:
58400: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
58401: fnd_file.put_line(fnd_file.LOG, ' ');
58402:
58403:
58404: xla_exceptions_pkg.raise_message
58397: END IF;
58398: END LOOP;
58399:
58400: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
58401: fnd_file.put_line(fnd_file.LOG, ' ');
58402:
58403:
58404: xla_exceptions_pkg.raise_message
58405: (p_location => 'XLA_00222_AAD_S_000008_PKG.EventClass_105');
59629:
59630: l_first_event_id := l_array_header_events(l_array_header_events.FIRST);
59631: l_last_event_id := l_array_header_events(l_array_header_events.LAST);
59632:
59633: fnd_file.put_line(fnd_file.LOG, ' ');
59634: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
59635: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );
59636: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');
59637:
59630: l_first_event_id := l_array_header_events(l_array_header_events.FIRST);
59631: l_last_event_id := l_array_header_events(l_array_header_events.LAST);
59632:
59633: fnd_file.put_line(fnd_file.LOG, ' ');
59634: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
59635: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );
59636: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');
59637:
59638: FOR line_record IN line_cur(l_first_event_id, l_last_event_id)
59631: l_last_event_id := l_array_header_events(l_array_header_events.LAST);
59632:
59633: fnd_file.put_line(fnd_file.LOG, ' ');
59634: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
59635: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );
59636: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');
59637:
59638: FOR line_record IN line_cur(l_first_event_id, l_last_event_id)
59639: LOOP
59632:
59633: fnd_file.put_line(fnd_file.LOG, ' ');
59634: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
59635: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );
59636: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');
59637:
59638: FOR line_record IN line_cur(l_first_event_id, l_last_event_id)
59639: LOOP
59640: IF (NOT l_array_header_events.EXISTS(line_record.event_id)) AND (NOT l_array_duplicate_checker.EXISTS(line_record.event_id)) THEN
59637:
59638: FOR line_record IN line_cur(l_first_event_id, l_last_event_id)
59639: LOOP
59640: IF (NOT l_array_header_events.EXISTS(line_record.event_id)) AND (NOT l_array_duplicate_checker.EXISTS(line_record.event_id)) THEN
59641: fnd_file.put_line(fnd_file.log, 'Event_id = ' || line_record.event_id);
59642: l_array_duplicate_checker(line_record.event_id) := line_record.event_id;
59643: END IF;
59644: END LOOP;
59645:
59642: l_array_duplicate_checker(line_record.event_id) := line_record.event_id;
59643: END IF;
59644: END LOOP;
59645:
59646: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
59647: fnd_file.put_line(fnd_file.LOG, ' ');
59648:
59649:
59650: xla_exceptions_pkg.raise_message
59643: END IF;
59644: END LOOP;
59645:
59646: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
59647: fnd_file.put_line(fnd_file.LOG, ' ');
59648:
59649:
59650: xla_exceptions_pkg.raise_message
59651: (p_location => 'XLA_00222_AAD_S_000008_PKG.EventClass_106');
60875:
60876: l_first_event_id := l_array_header_events(l_array_header_events.FIRST);
60877: l_last_event_id := l_array_header_events(l_array_header_events.LAST);
60878:
60879: fnd_file.put_line(fnd_file.LOG, ' ');
60880: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
60881: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );
60882: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');
60883:
60876: l_first_event_id := l_array_header_events(l_array_header_events.FIRST);
60877: l_last_event_id := l_array_header_events(l_array_header_events.LAST);
60878:
60879: fnd_file.put_line(fnd_file.LOG, ' ');
60880: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
60881: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );
60882: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');
60883:
60884: FOR line_record IN line_cur(l_first_event_id, l_last_event_id)
60877: l_last_event_id := l_array_header_events(l_array_header_events.LAST);
60878:
60879: fnd_file.put_line(fnd_file.LOG, ' ');
60880: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
60881: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );
60882: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');
60883:
60884: FOR line_record IN line_cur(l_first_event_id, l_last_event_id)
60885: LOOP
60878:
60879: fnd_file.put_line(fnd_file.LOG, ' ');
60880: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
60881: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );
60882: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');
60883:
60884: FOR line_record IN line_cur(l_first_event_id, l_last_event_id)
60885: LOOP
60886: IF (NOT l_array_header_events.EXISTS(line_record.event_id)) AND (NOT l_array_duplicate_checker.EXISTS(line_record.event_id)) THEN
60883:
60884: FOR line_record IN line_cur(l_first_event_id, l_last_event_id)
60885: LOOP
60886: IF (NOT l_array_header_events.EXISTS(line_record.event_id)) AND (NOT l_array_duplicate_checker.EXISTS(line_record.event_id)) THEN
60887: fnd_file.put_line(fnd_file.log, 'Event_id = ' || line_record.event_id);
60888: l_array_duplicate_checker(line_record.event_id) := line_record.event_id;
60889: END IF;
60890: END LOOP;
60891:
60888: l_array_duplicate_checker(line_record.event_id) := line_record.event_id;
60889: END IF;
60890: END LOOP;
60891:
60892: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
60893: fnd_file.put_line(fnd_file.LOG, ' ');
60894:
60895:
60896: xla_exceptions_pkg.raise_message
60889: END IF;
60890: END LOOP;
60891:
60892: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
60893: fnd_file.put_line(fnd_file.LOG, ' ');
60894:
60895:
60896: xla_exceptions_pkg.raise_message
60897: (p_location => 'XLA_00222_AAD_S_000008_PKG.EventClass_107');
62358:
62359: l_first_event_id := l_array_header_events(l_array_header_events.FIRST);
62360: l_last_event_id := l_array_header_events(l_array_header_events.LAST);
62361:
62362: fnd_file.put_line(fnd_file.LOG, ' ');
62363: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
62364: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );
62365: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');
62366:
62359: l_first_event_id := l_array_header_events(l_array_header_events.FIRST);
62360: l_last_event_id := l_array_header_events(l_array_header_events.LAST);
62361:
62362: fnd_file.put_line(fnd_file.LOG, ' ');
62363: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
62364: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );
62365: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');
62366:
62367: FOR line_record IN line_cur(l_first_event_id, l_last_event_id)
62360: l_last_event_id := l_array_header_events(l_array_header_events.LAST);
62361:
62362: fnd_file.put_line(fnd_file.LOG, ' ');
62363: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
62364: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );
62365: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');
62366:
62367: FOR line_record IN line_cur(l_first_event_id, l_last_event_id)
62368: LOOP
62361:
62362: fnd_file.put_line(fnd_file.LOG, ' ');
62363: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
62364: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );
62365: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');
62366:
62367: FOR line_record IN line_cur(l_first_event_id, l_last_event_id)
62368: LOOP
62369: IF (NOT l_array_header_events.EXISTS(line_record.event_id)) AND (NOT l_array_duplicate_checker.EXISTS(line_record.event_id)) THEN
62366:
62367: FOR line_record IN line_cur(l_first_event_id, l_last_event_id)
62368: LOOP
62369: IF (NOT l_array_header_events.EXISTS(line_record.event_id)) AND (NOT l_array_duplicate_checker.EXISTS(line_record.event_id)) THEN
62370: fnd_file.put_line(fnd_file.log, 'Event_id = ' || line_record.event_id);
62371: l_array_duplicate_checker(line_record.event_id) := line_record.event_id;
62372: END IF;
62373: END LOOP;
62374:
62371: l_array_duplicate_checker(line_record.event_id) := line_record.event_id;
62372: END IF;
62373: END LOOP;
62374:
62375: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
62376: fnd_file.put_line(fnd_file.LOG, ' ');
62377:
62378:
62379: xla_exceptions_pkg.raise_message
62372: END IF;
62373: END LOOP;
62374:
62375: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
62376: fnd_file.put_line(fnd_file.LOG, ' ');
62377:
62378:
62379: xla_exceptions_pkg.raise_message
62380: (p_location => 'XLA_00222_AAD_S_000008_PKG.EventClass_108');
63887:
63888: l_first_event_id := l_array_header_events(l_array_header_events.FIRST);
63889: l_last_event_id := l_array_header_events(l_array_header_events.LAST);
63890:
63891: fnd_file.put_line(fnd_file.LOG, ' ');
63892: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
63893: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );
63894: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');
63895:
63888: l_first_event_id := l_array_header_events(l_array_header_events.FIRST);
63889: l_last_event_id := l_array_header_events(l_array_header_events.LAST);
63890:
63891: fnd_file.put_line(fnd_file.LOG, ' ');
63892: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
63893: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );
63894: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');
63895:
63896: FOR line_record IN line_cur(l_first_event_id, l_last_event_id)
63889: l_last_event_id := l_array_header_events(l_array_header_events.LAST);
63890:
63891: fnd_file.put_line(fnd_file.LOG, ' ');
63892: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
63893: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );
63894: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');
63895:
63896: FOR line_record IN line_cur(l_first_event_id, l_last_event_id)
63897: LOOP
63890:
63891: fnd_file.put_line(fnd_file.LOG, ' ');
63892: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
63893: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );
63894: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');
63895:
63896: FOR line_record IN line_cur(l_first_event_id, l_last_event_id)
63897: LOOP
63898: IF (NOT l_array_header_events.EXISTS(line_record.event_id)) AND (NOT l_array_duplicate_checker.EXISTS(line_record.event_id)) THEN
63895:
63896: FOR line_record IN line_cur(l_first_event_id, l_last_event_id)
63897: LOOP
63898: IF (NOT l_array_header_events.EXISTS(line_record.event_id)) AND (NOT l_array_duplicate_checker.EXISTS(line_record.event_id)) THEN
63899: fnd_file.put_line(fnd_file.log, 'Event_id = ' || line_record.event_id);
63900: l_array_duplicate_checker(line_record.event_id) := line_record.event_id;
63901: END IF;
63902: END LOOP;
63903:
63900: l_array_duplicate_checker(line_record.event_id) := line_record.event_id;
63901: END IF;
63902: END LOOP;
63903:
63904: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
63905: fnd_file.put_line(fnd_file.LOG, ' ');
63906:
63907:
63908: xla_exceptions_pkg.raise_message
63901: END IF;
63902: END LOOP;
63903:
63904: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
63905: fnd_file.put_line(fnd_file.LOG, ' ');
63906:
63907:
63908: xla_exceptions_pkg.raise_message
63909: (p_location => 'XLA_00222_AAD_S_000008_PKG.EventClass_109');
66711:
66712: l_first_event_id := l_array_header_events(l_array_header_events.FIRST);
66713: l_last_event_id := l_array_header_events(l_array_header_events.LAST);
66714:
66715: fnd_file.put_line(fnd_file.LOG, ' ');
66716: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
66717: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );
66718: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');
66719:
66712: l_first_event_id := l_array_header_events(l_array_header_events.FIRST);
66713: l_last_event_id := l_array_header_events(l_array_header_events.LAST);
66714:
66715: fnd_file.put_line(fnd_file.LOG, ' ');
66716: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
66717: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );
66718: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');
66719:
66720: FOR line_record IN line_cur(l_first_event_id, l_last_event_id)
66713: l_last_event_id := l_array_header_events(l_array_header_events.LAST);
66714:
66715: fnd_file.put_line(fnd_file.LOG, ' ');
66716: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
66717: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );
66718: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');
66719:
66720: FOR line_record IN line_cur(l_first_event_id, l_last_event_id)
66721: LOOP
66714:
66715: fnd_file.put_line(fnd_file.LOG, ' ');
66716: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
66717: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );
66718: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');
66719:
66720: FOR line_record IN line_cur(l_first_event_id, l_last_event_id)
66721: LOOP
66722: IF (NOT l_array_header_events.EXISTS(line_record.event_id)) AND (NOT l_array_duplicate_checker.EXISTS(line_record.event_id)) THEN
66719:
66720: FOR line_record IN line_cur(l_first_event_id, l_last_event_id)
66721: LOOP
66722: IF (NOT l_array_header_events.EXISTS(line_record.event_id)) AND (NOT l_array_duplicate_checker.EXISTS(line_record.event_id)) THEN
66723: fnd_file.put_line(fnd_file.log, 'Event_id = ' || line_record.event_id);
66724: l_array_duplicate_checker(line_record.event_id) := line_record.event_id;
66725: END IF;
66726: END LOOP;
66727:
66724: l_array_duplicate_checker(line_record.event_id) := line_record.event_id;
66725: END IF;
66726: END LOOP;
66727:
66728: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
66729: fnd_file.put_line(fnd_file.LOG, ' ');
66730:
66731:
66732: xla_exceptions_pkg.raise_message
66725: END IF;
66726: END LOOP;
66727:
66728: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
66729: fnd_file.put_line(fnd_file.LOG, ' ');
66730:
66731:
66732: xla_exceptions_pkg.raise_message
66733: (p_location => 'XLA_00222_AAD_S_000008_PKG.EventClass_110');