70175:
70176: l_first_event_id := l_array_header_events(l_array_header_events.FIRST);
70177: l_last_event_id := l_array_header_events(l_array_header_events.LAST);
70178:
70179: fnd_file.put_line(fnd_file.LOG, ' ');
70180: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
70181: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );
70182: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');
70183:
70176: l_first_event_id := l_array_header_events(l_array_header_events.FIRST);
70177: l_last_event_id := l_array_header_events(l_array_header_events.LAST);
70178:
70179: fnd_file.put_line(fnd_file.LOG, ' ');
70180: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
70181: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );
70182: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');
70183:
70184: FOR line_record IN line_cur(l_first_event_id, l_last_event_id)
70177: l_last_event_id := l_array_header_events(l_array_header_events.LAST);
70178:
70179: fnd_file.put_line(fnd_file.LOG, ' ');
70180: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
70181: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );
70182: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');
70183:
70184: FOR line_record IN line_cur(l_first_event_id, l_last_event_id)
70185: LOOP
70178:
70179: fnd_file.put_line(fnd_file.LOG, ' ');
70180: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
70181: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );
70182: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');
70183:
70184: FOR line_record IN line_cur(l_first_event_id, l_last_event_id)
70185: LOOP
70186: IF (NOT l_array_header_events.EXISTS(line_record.event_id)) AND (NOT l_array_duplicate_checker.EXISTS(line_record.event_id)) THEN
70183:
70184: FOR line_record IN line_cur(l_first_event_id, l_last_event_id)
70185: LOOP
70186: IF (NOT l_array_header_events.EXISTS(line_record.event_id)) AND (NOT l_array_duplicate_checker.EXISTS(line_record.event_id)) THEN
70187: fnd_file.put_line(fnd_file.log, 'Event_id = ' || line_record.event_id);
70188: l_array_duplicate_checker(line_record.event_id) := line_record.event_id;
70189: END IF;
70190: END LOOP;
70191:
70188: l_array_duplicate_checker(line_record.event_id) := line_record.event_id;
70189: END IF;
70190: END LOOP;
70191:
70192: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
70193: fnd_file.put_line(fnd_file.LOG, ' ');
70194:
70195:
70196: xla_exceptions_pkg.raise_message
70189: END IF;
70190: END LOOP;
70191:
70192: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
70193: fnd_file.put_line(fnd_file.LOG, ' ');
70194:
70195:
70196: xla_exceptions_pkg.raise_message
70197: (p_location => 'XLA_00222_AAD_S_000006_PKG.EventClass_136');
71421:
71422: l_first_event_id := l_array_header_events(l_array_header_events.FIRST);
71423: l_last_event_id := l_array_header_events(l_array_header_events.LAST);
71424:
71425: fnd_file.put_line(fnd_file.LOG, ' ');
71426: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
71427: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );
71428: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');
71429:
71422: l_first_event_id := l_array_header_events(l_array_header_events.FIRST);
71423: l_last_event_id := l_array_header_events(l_array_header_events.LAST);
71424:
71425: fnd_file.put_line(fnd_file.LOG, ' ');
71426: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
71427: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );
71428: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');
71429:
71430: FOR line_record IN line_cur(l_first_event_id, l_last_event_id)
71423: l_last_event_id := l_array_header_events(l_array_header_events.LAST);
71424:
71425: fnd_file.put_line(fnd_file.LOG, ' ');
71426: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
71427: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );
71428: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');
71429:
71430: FOR line_record IN line_cur(l_first_event_id, l_last_event_id)
71431: LOOP
71424:
71425: fnd_file.put_line(fnd_file.LOG, ' ');
71426: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
71427: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );
71428: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');
71429:
71430: FOR line_record IN line_cur(l_first_event_id, l_last_event_id)
71431: LOOP
71432: IF (NOT l_array_header_events.EXISTS(line_record.event_id)) AND (NOT l_array_duplicate_checker.EXISTS(line_record.event_id)) THEN
71429:
71430: FOR line_record IN line_cur(l_first_event_id, l_last_event_id)
71431: LOOP
71432: IF (NOT l_array_header_events.EXISTS(line_record.event_id)) AND (NOT l_array_duplicate_checker.EXISTS(line_record.event_id)) THEN
71433: fnd_file.put_line(fnd_file.log, 'Event_id = ' || line_record.event_id);
71434: l_array_duplicate_checker(line_record.event_id) := line_record.event_id;
71435: END IF;
71436: END LOOP;
71437:
71434: l_array_duplicate_checker(line_record.event_id) := line_record.event_id;
71435: END IF;
71436: END LOOP;
71437:
71438: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
71439: fnd_file.put_line(fnd_file.LOG, ' ');
71440:
71441:
71442: xla_exceptions_pkg.raise_message
71435: END IF;
71436: END LOOP;
71437:
71438: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
71439: fnd_file.put_line(fnd_file.LOG, ' ');
71440:
71441:
71442: xla_exceptions_pkg.raise_message
71443: (p_location => 'XLA_00222_AAD_S_000006_PKG.EventClass_137');
73040:
73041: l_first_event_id := l_array_header_events(l_array_header_events.FIRST);
73042: l_last_event_id := l_array_header_events(l_array_header_events.LAST);
73043:
73044: fnd_file.put_line(fnd_file.LOG, ' ');
73045: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
73046: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );
73047: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');
73048:
73041: l_first_event_id := l_array_header_events(l_array_header_events.FIRST);
73042: l_last_event_id := l_array_header_events(l_array_header_events.LAST);
73043:
73044: fnd_file.put_line(fnd_file.LOG, ' ');
73045: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
73046: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );
73047: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');
73048:
73049: FOR line_record IN line_cur(l_first_event_id, l_last_event_id)
73042: l_last_event_id := l_array_header_events(l_array_header_events.LAST);
73043:
73044: fnd_file.put_line(fnd_file.LOG, ' ');
73045: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
73046: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );
73047: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');
73048:
73049: FOR line_record IN line_cur(l_first_event_id, l_last_event_id)
73050: LOOP
73043:
73044: fnd_file.put_line(fnd_file.LOG, ' ');
73045: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
73046: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );
73047: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');
73048:
73049: FOR line_record IN line_cur(l_first_event_id, l_last_event_id)
73050: LOOP
73051: IF (NOT l_array_header_events.EXISTS(line_record.event_id)) AND (NOT l_array_duplicate_checker.EXISTS(line_record.event_id)) THEN
73048:
73049: FOR line_record IN line_cur(l_first_event_id, l_last_event_id)
73050: LOOP
73051: IF (NOT l_array_header_events.EXISTS(line_record.event_id)) AND (NOT l_array_duplicate_checker.EXISTS(line_record.event_id)) THEN
73052: fnd_file.put_line(fnd_file.log, 'Event_id = ' || line_record.event_id);
73053: l_array_duplicate_checker(line_record.event_id) := line_record.event_id;
73054: END IF;
73055: END LOOP;
73056:
73053: l_array_duplicate_checker(line_record.event_id) := line_record.event_id;
73054: END IF;
73055: END LOOP;
73056:
73057: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
73058: fnd_file.put_line(fnd_file.LOG, ' ');
73059:
73060:
73061: xla_exceptions_pkg.raise_message
73054: END IF;
73055: END LOOP;
73056:
73057: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
73058: fnd_file.put_line(fnd_file.LOG, ' ');
73059:
73060:
73061: xla_exceptions_pkg.raise_message
73062: (p_location => 'XLA_00222_AAD_S_000006_PKG.EventClass_138');
74511:
74512: l_first_event_id := l_array_header_events(l_array_header_events.FIRST);
74513: l_last_event_id := l_array_header_events(l_array_header_events.LAST);
74514:
74515: fnd_file.put_line(fnd_file.LOG, ' ');
74516: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
74517: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );
74518: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');
74519:
74512: l_first_event_id := l_array_header_events(l_array_header_events.FIRST);
74513: l_last_event_id := l_array_header_events(l_array_header_events.LAST);
74514:
74515: fnd_file.put_line(fnd_file.LOG, ' ');
74516: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
74517: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );
74518: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');
74519:
74520: FOR line_record IN line_cur(l_first_event_id, l_last_event_id)
74513: l_last_event_id := l_array_header_events(l_array_header_events.LAST);
74514:
74515: fnd_file.put_line(fnd_file.LOG, ' ');
74516: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
74517: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );
74518: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');
74519:
74520: FOR line_record IN line_cur(l_first_event_id, l_last_event_id)
74521: LOOP
74514:
74515: fnd_file.put_line(fnd_file.LOG, ' ');
74516: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
74517: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );
74518: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');
74519:
74520: FOR line_record IN line_cur(l_first_event_id, l_last_event_id)
74521: LOOP
74522: IF (NOT l_array_header_events.EXISTS(line_record.event_id)) AND (NOT l_array_duplicate_checker.EXISTS(line_record.event_id)) THEN
74519:
74520: FOR line_record IN line_cur(l_first_event_id, l_last_event_id)
74521: LOOP
74522: IF (NOT l_array_header_events.EXISTS(line_record.event_id)) AND (NOT l_array_duplicate_checker.EXISTS(line_record.event_id)) THEN
74523: fnd_file.put_line(fnd_file.log, 'Event_id = ' || line_record.event_id);
74524: l_array_duplicate_checker(line_record.event_id) := line_record.event_id;
74525: END IF;
74526: END LOOP;
74527:
74524: l_array_duplicate_checker(line_record.event_id) := line_record.event_id;
74525: END IF;
74526: END LOOP;
74527:
74528: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
74529: fnd_file.put_line(fnd_file.LOG, ' ');
74530:
74531:
74532: xla_exceptions_pkg.raise_message
74525: END IF;
74526: END LOOP;
74527:
74528: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
74529: fnd_file.put_line(fnd_file.LOG, ' ');
74530:
74531:
74532: xla_exceptions_pkg.raise_message
74533: (p_location => 'XLA_00222_AAD_S_000006_PKG.EventClass_139');
75757:
75758: l_first_event_id := l_array_header_events(l_array_header_events.FIRST);
75759: l_last_event_id := l_array_header_events(l_array_header_events.LAST);
75760:
75761: fnd_file.put_line(fnd_file.LOG, ' ');
75762: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
75763: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );
75764: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');
75765:
75758: l_first_event_id := l_array_header_events(l_array_header_events.FIRST);
75759: l_last_event_id := l_array_header_events(l_array_header_events.LAST);
75760:
75761: fnd_file.put_line(fnd_file.LOG, ' ');
75762: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
75763: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );
75764: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');
75765:
75766: FOR line_record IN line_cur(l_first_event_id, l_last_event_id)
75759: l_last_event_id := l_array_header_events(l_array_header_events.LAST);
75760:
75761: fnd_file.put_line(fnd_file.LOG, ' ');
75762: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
75763: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );
75764: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');
75765:
75766: FOR line_record IN line_cur(l_first_event_id, l_last_event_id)
75767: LOOP
75760:
75761: fnd_file.put_line(fnd_file.LOG, ' ');
75762: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
75763: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );
75764: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');
75765:
75766: FOR line_record IN line_cur(l_first_event_id, l_last_event_id)
75767: LOOP
75768: IF (NOT l_array_header_events.EXISTS(line_record.event_id)) AND (NOT l_array_duplicate_checker.EXISTS(line_record.event_id)) THEN
75765:
75766: FOR line_record IN line_cur(l_first_event_id, l_last_event_id)
75767: LOOP
75768: IF (NOT l_array_header_events.EXISTS(line_record.event_id)) AND (NOT l_array_duplicate_checker.EXISTS(line_record.event_id)) THEN
75769: fnd_file.put_line(fnd_file.log, 'Event_id = ' || line_record.event_id);
75770: l_array_duplicate_checker(line_record.event_id) := line_record.event_id;
75771: END IF;
75772: END LOOP;
75773:
75770: l_array_duplicate_checker(line_record.event_id) := line_record.event_id;
75771: END IF;
75772: END LOOP;
75773:
75774: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
75775: fnd_file.put_line(fnd_file.LOG, ' ');
75776:
75777:
75778: xla_exceptions_pkg.raise_message
75771: END IF;
75772: END LOOP;
75773:
75774: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
75775: fnd_file.put_line(fnd_file.LOG, ' ');
75776:
75777:
75778: xla_exceptions_pkg.raise_message
75779: (p_location => 'XLA_00222_AAD_S_000006_PKG.EventClass_140');
77003:
77004: l_first_event_id := l_array_header_events(l_array_header_events.FIRST);
77005: l_last_event_id := l_array_header_events(l_array_header_events.LAST);
77006:
77007: fnd_file.put_line(fnd_file.LOG, ' ');
77008: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
77009: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );
77010: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');
77011:
77004: l_first_event_id := l_array_header_events(l_array_header_events.FIRST);
77005: l_last_event_id := l_array_header_events(l_array_header_events.LAST);
77006:
77007: fnd_file.put_line(fnd_file.LOG, ' ');
77008: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
77009: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );
77010: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');
77011:
77012: FOR line_record IN line_cur(l_first_event_id, l_last_event_id)
77005: l_last_event_id := l_array_header_events(l_array_header_events.LAST);
77006:
77007: fnd_file.put_line(fnd_file.LOG, ' ');
77008: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
77009: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );
77010: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');
77011:
77012: FOR line_record IN line_cur(l_first_event_id, l_last_event_id)
77013: LOOP
77006:
77007: fnd_file.put_line(fnd_file.LOG, ' ');
77008: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
77009: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );
77010: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');
77011:
77012: FOR line_record IN line_cur(l_first_event_id, l_last_event_id)
77013: LOOP
77014: IF (NOT l_array_header_events.EXISTS(line_record.event_id)) AND (NOT l_array_duplicate_checker.EXISTS(line_record.event_id)) THEN
77011:
77012: FOR line_record IN line_cur(l_first_event_id, l_last_event_id)
77013: LOOP
77014: IF (NOT l_array_header_events.EXISTS(line_record.event_id)) AND (NOT l_array_duplicate_checker.EXISTS(line_record.event_id)) THEN
77015: fnd_file.put_line(fnd_file.log, 'Event_id = ' || line_record.event_id);
77016: l_array_duplicate_checker(line_record.event_id) := line_record.event_id;
77017: END IF;
77018: END LOOP;
77019:
77016: l_array_duplicate_checker(line_record.event_id) := line_record.event_id;
77017: END IF;
77018: END LOOP;
77019:
77020: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
77021: fnd_file.put_line(fnd_file.LOG, ' ');
77022:
77023:
77024: xla_exceptions_pkg.raise_message
77017: END IF;
77018: END LOOP;
77019:
77020: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
77021: fnd_file.put_line(fnd_file.LOG, ' ');
77022:
77023:
77024: xla_exceptions_pkg.raise_message
77025: (p_location => 'XLA_00222_AAD_S_000006_PKG.EventClass_141');
78588:
78589: l_first_event_id := l_array_header_events(l_array_header_events.FIRST);
78590: l_last_event_id := l_array_header_events(l_array_header_events.LAST);
78591:
78592: fnd_file.put_line(fnd_file.LOG, ' ');
78593: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
78594: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );
78595: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');
78596:
78589: l_first_event_id := l_array_header_events(l_array_header_events.FIRST);
78590: l_last_event_id := l_array_header_events(l_array_header_events.LAST);
78591:
78592: fnd_file.put_line(fnd_file.LOG, ' ');
78593: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
78594: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );
78595: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');
78596:
78597: FOR line_record IN line_cur(l_first_event_id, l_last_event_id)
78590: l_last_event_id := l_array_header_events(l_array_header_events.LAST);
78591:
78592: fnd_file.put_line(fnd_file.LOG, ' ');
78593: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
78594: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );
78595: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');
78596:
78597: FOR line_record IN line_cur(l_first_event_id, l_last_event_id)
78598: LOOP
78591:
78592: fnd_file.put_line(fnd_file.LOG, ' ');
78593: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
78594: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );
78595: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');
78596:
78597: FOR line_record IN line_cur(l_first_event_id, l_last_event_id)
78598: LOOP
78599: IF (NOT l_array_header_events.EXISTS(line_record.event_id)) AND (NOT l_array_duplicate_checker.EXISTS(line_record.event_id)) THEN
78596:
78597: FOR line_record IN line_cur(l_first_event_id, l_last_event_id)
78598: LOOP
78599: IF (NOT l_array_header_events.EXISTS(line_record.event_id)) AND (NOT l_array_duplicate_checker.EXISTS(line_record.event_id)) THEN
78600: fnd_file.put_line(fnd_file.log, 'Event_id = ' || line_record.event_id);
78601: l_array_duplicate_checker(line_record.event_id) := line_record.event_id;
78602: END IF;
78603: END LOOP;
78604:
78601: l_array_duplicate_checker(line_record.event_id) := line_record.event_id;
78602: END IF;
78603: END LOOP;
78604:
78605: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
78606: fnd_file.put_line(fnd_file.LOG, ' ');
78607:
78608:
78609: xla_exceptions_pkg.raise_message
78602: END IF;
78603: END LOOP;
78604:
78605: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
78606: fnd_file.put_line(fnd_file.LOG, ' ');
78607:
78608:
78609: xla_exceptions_pkg.raise_message
78610: (p_location => 'XLA_00222_AAD_S_000006_PKG.EventClass_142');
80435:
80436: l_first_event_id := l_array_header_events(l_array_header_events.FIRST);
80437: l_last_event_id := l_array_header_events(l_array_header_events.LAST);
80438:
80439: fnd_file.put_line(fnd_file.LOG, ' ');
80440: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
80441: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );
80442: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');
80443:
80436: l_first_event_id := l_array_header_events(l_array_header_events.FIRST);
80437: l_last_event_id := l_array_header_events(l_array_header_events.LAST);
80438:
80439: fnd_file.put_line(fnd_file.LOG, ' ');
80440: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
80441: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );
80442: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');
80443:
80444: FOR line_record IN line_cur(l_first_event_id, l_last_event_id)
80437: l_last_event_id := l_array_header_events(l_array_header_events.LAST);
80438:
80439: fnd_file.put_line(fnd_file.LOG, ' ');
80440: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
80441: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );
80442: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');
80443:
80444: FOR line_record IN line_cur(l_first_event_id, l_last_event_id)
80445: LOOP
80438:
80439: fnd_file.put_line(fnd_file.LOG, ' ');
80440: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
80441: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );
80442: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');
80443:
80444: FOR line_record IN line_cur(l_first_event_id, l_last_event_id)
80445: LOOP
80446: IF (NOT l_array_header_events.EXISTS(line_record.event_id)) AND (NOT l_array_duplicate_checker.EXISTS(line_record.event_id)) THEN
80443:
80444: FOR line_record IN line_cur(l_first_event_id, l_last_event_id)
80445: LOOP
80446: IF (NOT l_array_header_events.EXISTS(line_record.event_id)) AND (NOT l_array_duplicate_checker.EXISTS(line_record.event_id)) THEN
80447: fnd_file.put_line(fnd_file.log, 'Event_id = ' || line_record.event_id);
80448: l_array_duplicate_checker(line_record.event_id) := line_record.event_id;
80449: END IF;
80450: END LOOP;
80451:
80448: l_array_duplicate_checker(line_record.event_id) := line_record.event_id;
80449: END IF;
80450: END LOOP;
80451:
80452: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
80453: fnd_file.put_line(fnd_file.LOG, ' ');
80454:
80455:
80456: xla_exceptions_pkg.raise_message
80449: END IF;
80450: END LOOP;
80451:
80452: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
80453: fnd_file.put_line(fnd_file.LOG, ' ');
80454:
80455:
80456: xla_exceptions_pkg.raise_message
80457: (p_location => 'XLA_00222_AAD_S_000006_PKG.EventClass_143');
83672:
83673: l_first_event_id := l_array_header_events(l_array_header_events.FIRST);
83674: l_last_event_id := l_array_header_events(l_array_header_events.LAST);
83675:
83676: fnd_file.put_line(fnd_file.LOG, ' ');
83677: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
83678: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );
83679: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');
83680:
83673: l_first_event_id := l_array_header_events(l_array_header_events.FIRST);
83674: l_last_event_id := l_array_header_events(l_array_header_events.LAST);
83675:
83676: fnd_file.put_line(fnd_file.LOG, ' ');
83677: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
83678: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );
83679: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');
83680:
83681: FOR line_record IN line_cur(l_first_event_id, l_last_event_id)
83674: l_last_event_id := l_array_header_events(l_array_header_events.LAST);
83675:
83676: fnd_file.put_line(fnd_file.LOG, ' ');
83677: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
83678: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );
83679: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');
83680:
83681: FOR line_record IN line_cur(l_first_event_id, l_last_event_id)
83682: LOOP
83675:
83676: fnd_file.put_line(fnd_file.LOG, ' ');
83677: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
83678: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );
83679: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');
83680:
83681: FOR line_record IN line_cur(l_first_event_id, l_last_event_id)
83682: LOOP
83683: IF (NOT l_array_header_events.EXISTS(line_record.event_id)) AND (NOT l_array_duplicate_checker.EXISTS(line_record.event_id)) THEN
83680:
83681: FOR line_record IN line_cur(l_first_event_id, l_last_event_id)
83682: LOOP
83683: IF (NOT l_array_header_events.EXISTS(line_record.event_id)) AND (NOT l_array_duplicate_checker.EXISTS(line_record.event_id)) THEN
83684: fnd_file.put_line(fnd_file.log, 'Event_id = ' || line_record.event_id);
83685: l_array_duplicate_checker(line_record.event_id) := line_record.event_id;
83686: END IF;
83687: END LOOP;
83688:
83685: l_array_duplicate_checker(line_record.event_id) := line_record.event_id;
83686: END IF;
83687: END LOOP;
83688:
83689: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
83690: fnd_file.put_line(fnd_file.LOG, ' ');
83691:
83692:
83693: xla_exceptions_pkg.raise_message
83686: END IF;
83687: END LOOP;
83688:
83689: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
83690: fnd_file.put_line(fnd_file.LOG, ' ');
83691:
83692:
83693: xla_exceptions_pkg.raise_message
83694: (p_location => 'XLA_00222_AAD_S_000006_PKG.EventClass_144');