98543:
98544: l_first_event_id := l_array_header_events(l_array_header_events.FIRST);
98545: l_last_event_id := l_array_header_events(l_array_header_events.LAST);
98546:
98547: fnd_file.put_line(fnd_file.LOG, ' ');
98548: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
98549: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );
98550: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');
98551:
98544: l_first_event_id := l_array_header_events(l_array_header_events.FIRST);
98545: l_last_event_id := l_array_header_events(l_array_header_events.LAST);
98546:
98547: fnd_file.put_line(fnd_file.LOG, ' ');
98548: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
98549: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );
98550: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');
98551:
98552: FOR line_record IN line_cur(l_first_event_id, l_last_event_id)
98545: l_last_event_id := l_array_header_events(l_array_header_events.LAST);
98546:
98547: fnd_file.put_line(fnd_file.LOG, ' ');
98548: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
98549: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );
98550: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');
98551:
98552: FOR line_record IN line_cur(l_first_event_id, l_last_event_id)
98553: LOOP
98546:
98547: fnd_file.put_line(fnd_file.LOG, ' ');
98548: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
98549: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );
98550: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');
98551:
98552: FOR line_record IN line_cur(l_first_event_id, l_last_event_id)
98553: LOOP
98554: IF (NOT l_array_header_events.EXISTS(line_record.event_id)) AND (NOT l_array_duplicate_checker.EXISTS(line_record.event_id)) THEN
98551:
98552: FOR line_record IN line_cur(l_first_event_id, l_last_event_id)
98553: LOOP
98554: IF (NOT l_array_header_events.EXISTS(line_record.event_id)) AND (NOT l_array_duplicate_checker.EXISTS(line_record.event_id)) THEN
98555: fnd_file.put_line(fnd_file.log, 'Event_id = ' || line_record.event_id);
98556: l_array_duplicate_checker(line_record.event_id) := line_record.event_id;
98557: END IF;
98558: END LOOP;
98559:
98556: l_array_duplicate_checker(line_record.event_id) := line_record.event_id;
98557: END IF;
98558: END LOOP;
98559:
98560: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
98561: fnd_file.put_line(fnd_file.LOG, ' ');
98562:
98563:
98564: xla_exceptions_pkg.raise_message
98557: END IF;
98558: END LOOP;
98559:
98560: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
98561: fnd_file.put_line(fnd_file.LOG, ' ');
98562:
98563:
98564: xla_exceptions_pkg.raise_message
98565: (p_location => 'XLA_00200_AAD_S_000011_PKG.EventClass_166');
101978:
101979: l_first_event_id := l_array_header_events(l_array_header_events.FIRST);
101980: l_last_event_id := l_array_header_events(l_array_header_events.LAST);
101981:
101982: fnd_file.put_line(fnd_file.LOG, ' ');
101983: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
101984: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );
101985: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');
101986:
101979: l_first_event_id := l_array_header_events(l_array_header_events.FIRST);
101980: l_last_event_id := l_array_header_events(l_array_header_events.LAST);
101981:
101982: fnd_file.put_line(fnd_file.LOG, ' ');
101983: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
101984: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );
101985: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');
101986:
101987: FOR line_record IN line_cur(l_first_event_id, l_last_event_id)
101980: l_last_event_id := l_array_header_events(l_array_header_events.LAST);
101981:
101982: fnd_file.put_line(fnd_file.LOG, ' ');
101983: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
101984: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );
101985: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');
101986:
101987: FOR line_record IN line_cur(l_first_event_id, l_last_event_id)
101988: LOOP
101981:
101982: fnd_file.put_line(fnd_file.LOG, ' ');
101983: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
101984: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );
101985: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');
101986:
101987: FOR line_record IN line_cur(l_first_event_id, l_last_event_id)
101988: LOOP
101989: IF (NOT l_array_header_events.EXISTS(line_record.event_id)) AND (NOT l_array_duplicate_checker.EXISTS(line_record.event_id)) THEN
101986:
101987: FOR line_record IN line_cur(l_first_event_id, l_last_event_id)
101988: LOOP
101989: IF (NOT l_array_header_events.EXISTS(line_record.event_id)) AND (NOT l_array_duplicate_checker.EXISTS(line_record.event_id)) THEN
101990: fnd_file.put_line(fnd_file.log, 'Event_id = ' || line_record.event_id);
101991: l_array_duplicate_checker(line_record.event_id) := line_record.event_id;
101992: END IF;
101993: END LOOP;
101994:
101991: l_array_duplicate_checker(line_record.event_id) := line_record.event_id;
101992: END IF;
101993: END LOOP;
101994:
101995: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
101996: fnd_file.put_line(fnd_file.LOG, ' ');
101997:
101998:
101999: xla_exceptions_pkg.raise_message
101992: END IF;
101993: END LOOP;
101994:
101995: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
101996: fnd_file.put_line(fnd_file.LOG, ' ');
101997:
101998:
101999: xla_exceptions_pkg.raise_message
102000: (p_location => 'XLA_00200_AAD_S_000011_PKG.EventClass_167');
106104:
106105: l_first_event_id := l_array_header_events(l_array_header_events.FIRST);
106106: l_last_event_id := l_array_header_events(l_array_header_events.LAST);
106107:
106108: fnd_file.put_line(fnd_file.LOG, ' ');
106109: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
106110: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );
106111: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');
106112:
106105: l_first_event_id := l_array_header_events(l_array_header_events.FIRST);
106106: l_last_event_id := l_array_header_events(l_array_header_events.LAST);
106107:
106108: fnd_file.put_line(fnd_file.LOG, ' ');
106109: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
106110: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );
106111: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');
106112:
106113: FOR line_record IN line_cur(l_first_event_id, l_last_event_id)
106106: l_last_event_id := l_array_header_events(l_array_header_events.LAST);
106107:
106108: fnd_file.put_line(fnd_file.LOG, ' ');
106109: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
106110: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );
106111: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');
106112:
106113: FOR line_record IN line_cur(l_first_event_id, l_last_event_id)
106114: LOOP
106107:
106108: fnd_file.put_line(fnd_file.LOG, ' ');
106109: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
106110: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );
106111: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');
106112:
106113: FOR line_record IN line_cur(l_first_event_id, l_last_event_id)
106114: LOOP
106115: IF (NOT l_array_header_events.EXISTS(line_record.event_id)) AND (NOT l_array_duplicate_checker.EXISTS(line_record.event_id)) THEN
106112:
106113: FOR line_record IN line_cur(l_first_event_id, l_last_event_id)
106114: LOOP
106115: IF (NOT l_array_header_events.EXISTS(line_record.event_id)) AND (NOT l_array_duplicate_checker.EXISTS(line_record.event_id)) THEN
106116: fnd_file.put_line(fnd_file.log, 'Event_id = ' || line_record.event_id);
106117: l_array_duplicate_checker(line_record.event_id) := line_record.event_id;
106118: END IF;
106119: END LOOP;
106120:
106117: l_array_duplicate_checker(line_record.event_id) := line_record.event_id;
106118: END IF;
106119: END LOOP;
106120:
106121: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
106122: fnd_file.put_line(fnd_file.LOG, ' ');
106123:
106124:
106125: xla_exceptions_pkg.raise_message
106118: END IF;
106119: END LOOP;
106120:
106121: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
106122: fnd_file.put_line(fnd_file.LOG, ' ');
106123:
106124:
106125: xla_exceptions_pkg.raise_message
106126: (p_location => 'XLA_00200_AAD_S_000011_PKG.EventClass_168');
109667:
109668: l_first_event_id := l_array_header_events(l_array_header_events.FIRST);
109669: l_last_event_id := l_array_header_events(l_array_header_events.LAST);
109670:
109671: fnd_file.put_line(fnd_file.LOG, ' ');
109672: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
109673: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );
109674: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');
109675:
109668: l_first_event_id := l_array_header_events(l_array_header_events.FIRST);
109669: l_last_event_id := l_array_header_events(l_array_header_events.LAST);
109670:
109671: fnd_file.put_line(fnd_file.LOG, ' ');
109672: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
109673: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );
109674: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');
109675:
109676: FOR line_record IN line_cur(l_first_event_id, l_last_event_id)
109669: l_last_event_id := l_array_header_events(l_array_header_events.LAST);
109670:
109671: fnd_file.put_line(fnd_file.LOG, ' ');
109672: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
109673: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );
109674: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');
109675:
109676: FOR line_record IN line_cur(l_first_event_id, l_last_event_id)
109677: LOOP
109670:
109671: fnd_file.put_line(fnd_file.LOG, ' ');
109672: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
109673: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );
109674: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');
109675:
109676: FOR line_record IN line_cur(l_first_event_id, l_last_event_id)
109677: LOOP
109678: IF (NOT l_array_header_events.EXISTS(line_record.event_id)) AND (NOT l_array_duplicate_checker.EXISTS(line_record.event_id)) THEN
109675:
109676: FOR line_record IN line_cur(l_first_event_id, l_last_event_id)
109677: LOOP
109678: IF (NOT l_array_header_events.EXISTS(line_record.event_id)) AND (NOT l_array_duplicate_checker.EXISTS(line_record.event_id)) THEN
109679: fnd_file.put_line(fnd_file.log, 'Event_id = ' || line_record.event_id);
109680: l_array_duplicate_checker(line_record.event_id) := line_record.event_id;
109681: END IF;
109682: END LOOP;
109683:
109680: l_array_duplicate_checker(line_record.event_id) := line_record.event_id;
109681: END IF;
109682: END LOOP;
109683:
109684: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
109685: fnd_file.put_line(fnd_file.LOG, ' ');
109686:
109687:
109688: xla_exceptions_pkg.raise_message
109681: END IF;
109682: END LOOP;
109683:
109684: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
109685: fnd_file.put_line(fnd_file.LOG, ' ');
109686:
109687:
109688: xla_exceptions_pkg.raise_message
109689: (p_location => 'XLA_00200_AAD_S_000011_PKG.EventClass_169');
112501:
112502: l_first_event_id := l_array_header_events(l_array_header_events.FIRST);
112503: l_last_event_id := l_array_header_events(l_array_header_events.LAST);
112504:
112505: fnd_file.put_line(fnd_file.LOG, ' ');
112506: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
112507: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );
112508: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');
112509:
112502: l_first_event_id := l_array_header_events(l_array_header_events.FIRST);
112503: l_last_event_id := l_array_header_events(l_array_header_events.LAST);
112504:
112505: fnd_file.put_line(fnd_file.LOG, ' ');
112506: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
112507: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );
112508: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');
112509:
112510: FOR line_record IN line_cur(l_first_event_id, l_last_event_id)
112503: l_last_event_id := l_array_header_events(l_array_header_events.LAST);
112504:
112505: fnd_file.put_line(fnd_file.LOG, ' ');
112506: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
112507: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );
112508: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');
112509:
112510: FOR line_record IN line_cur(l_first_event_id, l_last_event_id)
112511: LOOP
112504:
112505: fnd_file.put_line(fnd_file.LOG, ' ');
112506: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
112507: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );
112508: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');
112509:
112510: FOR line_record IN line_cur(l_first_event_id, l_last_event_id)
112511: LOOP
112512: IF (NOT l_array_header_events.EXISTS(line_record.event_id)) AND (NOT l_array_duplicate_checker.EXISTS(line_record.event_id)) THEN
112509:
112510: FOR line_record IN line_cur(l_first_event_id, l_last_event_id)
112511: LOOP
112512: IF (NOT l_array_header_events.EXISTS(line_record.event_id)) AND (NOT l_array_duplicate_checker.EXISTS(line_record.event_id)) THEN
112513: fnd_file.put_line(fnd_file.log, 'Event_id = ' || line_record.event_id);
112514: l_array_duplicate_checker(line_record.event_id) := line_record.event_id;
112515: END IF;
112516: END LOOP;
112517:
112514: l_array_duplicate_checker(line_record.event_id) := line_record.event_id;
112515: END IF;
112516: END LOOP;
112517:
112518: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
112519: fnd_file.put_line(fnd_file.LOG, ' ');
112520:
112521:
112522: xla_exceptions_pkg.raise_message
112515: END IF;
112516: END LOOP;
112517:
112518: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
112519: fnd_file.put_line(fnd_file.LOG, ' ');
112520:
112521:
112522: xla_exceptions_pkg.raise_message
112523: (p_location => 'XLA_00200_AAD_S_000011_PKG.EventClass_170');