119688:
119689: l_first_event_id := l_array_header_events(l_array_header_events.FIRST);
119690: l_last_event_id := l_array_header_events(l_array_header_events.LAST);
119691:
119692: fnd_file.put_line(fnd_file.LOG, ' ');
119693: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
119694: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );
119695: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');
119696:
119689: l_first_event_id := l_array_header_events(l_array_header_events.FIRST);
119690: l_last_event_id := l_array_header_events(l_array_header_events.LAST);
119691:
119692: fnd_file.put_line(fnd_file.LOG, ' ');
119693: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
119694: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );
119695: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');
119696:
119697: FOR line_record IN line_cur(l_first_event_id, l_last_event_id)
119690: l_last_event_id := l_array_header_events(l_array_header_events.LAST);
119691:
119692: fnd_file.put_line(fnd_file.LOG, ' ');
119693: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
119694: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );
119695: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');
119696:
119697: FOR line_record IN line_cur(l_first_event_id, l_last_event_id)
119698: LOOP
119691:
119692: fnd_file.put_line(fnd_file.LOG, ' ');
119693: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
119694: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );
119695: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');
119696:
119697: FOR line_record IN line_cur(l_first_event_id, l_last_event_id)
119698: LOOP
119699: IF (NOT l_array_header_events.EXISTS(line_record.event_id)) AND (NOT l_array_duplicate_checker.EXISTS(line_record.event_id)) THEN
119696:
119697: FOR line_record IN line_cur(l_first_event_id, l_last_event_id)
119698: LOOP
119699: IF (NOT l_array_header_events.EXISTS(line_record.event_id)) AND (NOT l_array_duplicate_checker.EXISTS(line_record.event_id)) THEN
119700: fnd_file.put_line(fnd_file.log, 'Event_id = ' || line_record.event_id);
119701: l_array_duplicate_checker(line_record.event_id) := line_record.event_id;
119702: END IF;
119703: END LOOP;
119704:
119701: l_array_duplicate_checker(line_record.event_id) := line_record.event_id;
119702: END IF;
119703: END LOOP;
119704:
119705: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
119706: fnd_file.put_line(fnd_file.LOG, ' ');
119707:
119708:
119709: xla_exceptions_pkg.raise_message
119702: END IF;
119703: END LOOP;
119704:
119705: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
119706: fnd_file.put_line(fnd_file.LOG, ' ');
119707:
119708:
119709: xla_exceptions_pkg.raise_message
119710: (p_location => 'XLA_00200_AAD_S_000010_PKG.EventClass_204');
120945:
120946: l_first_event_id := l_array_header_events(l_array_header_events.FIRST);
120947: l_last_event_id := l_array_header_events(l_array_header_events.LAST);
120948:
120949: fnd_file.put_line(fnd_file.LOG, ' ');
120950: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
120951: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );
120952: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');
120953:
120946: l_first_event_id := l_array_header_events(l_array_header_events.FIRST);
120947: l_last_event_id := l_array_header_events(l_array_header_events.LAST);
120948:
120949: fnd_file.put_line(fnd_file.LOG, ' ');
120950: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
120951: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );
120952: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');
120953:
120954: FOR line_record IN line_cur(l_first_event_id, l_last_event_id)
120947: l_last_event_id := l_array_header_events(l_array_header_events.LAST);
120948:
120949: fnd_file.put_line(fnd_file.LOG, ' ');
120950: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
120951: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );
120952: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');
120953:
120954: FOR line_record IN line_cur(l_first_event_id, l_last_event_id)
120955: LOOP
120948:
120949: fnd_file.put_line(fnd_file.LOG, ' ');
120950: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
120951: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );
120952: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');
120953:
120954: FOR line_record IN line_cur(l_first_event_id, l_last_event_id)
120955: LOOP
120956: IF (NOT l_array_header_events.EXISTS(line_record.event_id)) AND (NOT l_array_duplicate_checker.EXISTS(line_record.event_id)) THEN
120953:
120954: FOR line_record IN line_cur(l_first_event_id, l_last_event_id)
120955: LOOP
120956: IF (NOT l_array_header_events.EXISTS(line_record.event_id)) AND (NOT l_array_duplicate_checker.EXISTS(line_record.event_id)) THEN
120957: fnd_file.put_line(fnd_file.log, 'Event_id = ' || line_record.event_id);
120958: l_array_duplicate_checker(line_record.event_id) := line_record.event_id;
120959: END IF;
120960: END LOOP;
120961:
120958: l_array_duplicate_checker(line_record.event_id) := line_record.event_id;
120959: END IF;
120960: END LOOP;
120961:
120962: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
120963: fnd_file.put_line(fnd_file.LOG, ' ');
120964:
120965:
120966: xla_exceptions_pkg.raise_message
120959: END IF;
120960: END LOOP;
120961:
120962: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
120963: fnd_file.put_line(fnd_file.LOG, ' ');
120964:
120965:
120966: xla_exceptions_pkg.raise_message
120967: (p_location => 'XLA_00200_AAD_S_000010_PKG.EventClass_205');
122934:
122935: l_first_event_id := l_array_header_events(l_array_header_events.FIRST);
122936: l_last_event_id := l_array_header_events(l_array_header_events.LAST);
122937:
122938: fnd_file.put_line(fnd_file.LOG, ' ');
122939: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
122940: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );
122941: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');
122942:
122935: l_first_event_id := l_array_header_events(l_array_header_events.FIRST);
122936: l_last_event_id := l_array_header_events(l_array_header_events.LAST);
122937:
122938: fnd_file.put_line(fnd_file.LOG, ' ');
122939: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
122940: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );
122941: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');
122942:
122943: FOR line_record IN line_cur(l_first_event_id, l_last_event_id)
122936: l_last_event_id := l_array_header_events(l_array_header_events.LAST);
122937:
122938: fnd_file.put_line(fnd_file.LOG, ' ');
122939: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
122940: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );
122941: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');
122942:
122943: FOR line_record IN line_cur(l_first_event_id, l_last_event_id)
122944: LOOP
122937:
122938: fnd_file.put_line(fnd_file.LOG, ' ');
122939: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
122940: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );
122941: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');
122942:
122943: FOR line_record IN line_cur(l_first_event_id, l_last_event_id)
122944: LOOP
122945: IF (NOT l_array_header_events.EXISTS(line_record.event_id)) AND (NOT l_array_duplicate_checker.EXISTS(line_record.event_id)) THEN
122942:
122943: FOR line_record IN line_cur(l_first_event_id, l_last_event_id)
122944: LOOP
122945: IF (NOT l_array_header_events.EXISTS(line_record.event_id)) AND (NOT l_array_duplicate_checker.EXISTS(line_record.event_id)) THEN
122946: fnd_file.put_line(fnd_file.log, 'Event_id = ' || line_record.event_id);
122947: l_array_duplicate_checker(line_record.event_id) := line_record.event_id;
122948: END IF;
122949: END LOOP;
122950:
122947: l_array_duplicate_checker(line_record.event_id) := line_record.event_id;
122948: END IF;
122949: END LOOP;
122950:
122951: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
122952: fnd_file.put_line(fnd_file.LOG, ' ');
122953:
122954:
122955: xla_exceptions_pkg.raise_message
122948: END IF;
122949: END LOOP;
122950:
122951: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
122952: fnd_file.put_line(fnd_file.LOG, ' ');
122953:
122954:
122955: xla_exceptions_pkg.raise_message
122956: (p_location => 'XLA_00200_AAD_S_000010_PKG.EventClass_206');
124191:
124192: l_first_event_id := l_array_header_events(l_array_header_events.FIRST);
124193: l_last_event_id := l_array_header_events(l_array_header_events.LAST);
124194:
124195: fnd_file.put_line(fnd_file.LOG, ' ');
124196: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
124197: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );
124198: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');
124199:
124192: l_first_event_id := l_array_header_events(l_array_header_events.FIRST);
124193: l_last_event_id := l_array_header_events(l_array_header_events.LAST);
124194:
124195: fnd_file.put_line(fnd_file.LOG, ' ');
124196: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
124197: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );
124198: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');
124199:
124200: FOR line_record IN line_cur(l_first_event_id, l_last_event_id)
124193: l_last_event_id := l_array_header_events(l_array_header_events.LAST);
124194:
124195: fnd_file.put_line(fnd_file.LOG, ' ');
124196: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
124197: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );
124198: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');
124199:
124200: FOR line_record IN line_cur(l_first_event_id, l_last_event_id)
124201: LOOP
124194:
124195: fnd_file.put_line(fnd_file.LOG, ' ');
124196: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
124197: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );
124198: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');
124199:
124200: FOR line_record IN line_cur(l_first_event_id, l_last_event_id)
124201: LOOP
124202: IF (NOT l_array_header_events.EXISTS(line_record.event_id)) AND (NOT l_array_duplicate_checker.EXISTS(line_record.event_id)) THEN
124199:
124200: FOR line_record IN line_cur(l_first_event_id, l_last_event_id)
124201: LOOP
124202: IF (NOT l_array_header_events.EXISTS(line_record.event_id)) AND (NOT l_array_duplicate_checker.EXISTS(line_record.event_id)) THEN
124203: fnd_file.put_line(fnd_file.log, 'Event_id = ' || line_record.event_id);
124204: l_array_duplicate_checker(line_record.event_id) := line_record.event_id;
124205: END IF;
124206: END LOOP;
124207:
124204: l_array_duplicate_checker(line_record.event_id) := line_record.event_id;
124205: END IF;
124206: END LOOP;
124207:
124208: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
124209: fnd_file.put_line(fnd_file.LOG, ' ');
124210:
124211:
124212: xla_exceptions_pkg.raise_message
124205: END IF;
124206: END LOOP;
124207:
124208: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
124209: fnd_file.put_line(fnd_file.LOG, ' ');
124210:
124211:
124212: xla_exceptions_pkg.raise_message
124213: (p_location => 'XLA_00200_AAD_S_000010_PKG.EventClass_207');
125303:
125304: l_first_event_id := l_array_header_events(l_array_header_events.FIRST);
125305: l_last_event_id := l_array_header_events(l_array_header_events.LAST);
125306:
125307: fnd_file.put_line(fnd_file.LOG, ' ');
125308: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
125309: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );
125310: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');
125311:
125304: l_first_event_id := l_array_header_events(l_array_header_events.FIRST);
125305: l_last_event_id := l_array_header_events(l_array_header_events.LAST);
125306:
125307: fnd_file.put_line(fnd_file.LOG, ' ');
125308: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
125309: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );
125310: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');
125311:
125312: FOR line_record IN line_cur(l_first_event_id, l_last_event_id)
125305: l_last_event_id := l_array_header_events(l_array_header_events.LAST);
125306:
125307: fnd_file.put_line(fnd_file.LOG, ' ');
125308: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
125309: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );
125310: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');
125311:
125312: FOR line_record IN line_cur(l_first_event_id, l_last_event_id)
125313: LOOP
125306:
125307: fnd_file.put_line(fnd_file.LOG, ' ');
125308: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
125309: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );
125310: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');
125311:
125312: FOR line_record IN line_cur(l_first_event_id, l_last_event_id)
125313: LOOP
125314: IF (NOT l_array_header_events.EXISTS(line_record.event_id)) AND (NOT l_array_duplicate_checker.EXISTS(line_record.event_id)) THEN
125311:
125312: FOR line_record IN line_cur(l_first_event_id, l_last_event_id)
125313: LOOP
125314: IF (NOT l_array_header_events.EXISTS(line_record.event_id)) AND (NOT l_array_duplicate_checker.EXISTS(line_record.event_id)) THEN
125315: fnd_file.put_line(fnd_file.log, 'Event_id = ' || line_record.event_id);
125316: l_array_duplicate_checker(line_record.event_id) := line_record.event_id;
125317: END IF;
125318: END LOOP;
125319:
125316: l_array_duplicate_checker(line_record.event_id) := line_record.event_id;
125317: END IF;
125318: END LOOP;
125319:
125320: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
125321: fnd_file.put_line(fnd_file.LOG, ' ');
125322:
125323:
125324: xla_exceptions_pkg.raise_message
125317: END IF;
125318: END LOOP;
125319:
125320: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
125321: fnd_file.put_line(fnd_file.LOG, ' ');
125322:
125323:
125324: xla_exceptions_pkg.raise_message
125325: (p_location => 'XLA_00200_AAD_S_000010_PKG.EventClass_208');
129398:
129399: l_first_event_id := l_array_header_events(l_array_header_events.FIRST);
129400: l_last_event_id := l_array_header_events(l_array_header_events.LAST);
129401:
129402: fnd_file.put_line(fnd_file.LOG, ' ');
129403: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
129404: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );
129405: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');
129406:
129399: l_first_event_id := l_array_header_events(l_array_header_events.FIRST);
129400: l_last_event_id := l_array_header_events(l_array_header_events.LAST);
129401:
129402: fnd_file.put_line(fnd_file.LOG, ' ');
129403: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
129404: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );
129405: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');
129406:
129407: FOR line_record IN line_cur(l_first_event_id, l_last_event_id)
129400: l_last_event_id := l_array_header_events(l_array_header_events.LAST);
129401:
129402: fnd_file.put_line(fnd_file.LOG, ' ');
129403: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
129404: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );
129405: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');
129406:
129407: FOR line_record IN line_cur(l_first_event_id, l_last_event_id)
129408: LOOP
129401:
129402: fnd_file.put_line(fnd_file.LOG, ' ');
129403: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
129404: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );
129405: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');
129406:
129407: FOR line_record IN line_cur(l_first_event_id, l_last_event_id)
129408: LOOP
129409: IF (NOT l_array_header_events.EXISTS(line_record.event_id)) AND (NOT l_array_duplicate_checker.EXISTS(line_record.event_id)) THEN
129406:
129407: FOR line_record IN line_cur(l_first_event_id, l_last_event_id)
129408: LOOP
129409: IF (NOT l_array_header_events.EXISTS(line_record.event_id)) AND (NOT l_array_duplicate_checker.EXISTS(line_record.event_id)) THEN
129410: fnd_file.put_line(fnd_file.log, 'Event_id = ' || line_record.event_id);
129411: l_array_duplicate_checker(line_record.event_id) := line_record.event_id;
129412: END IF;
129413: END LOOP;
129414:
129411: l_array_duplicate_checker(line_record.event_id) := line_record.event_id;
129412: END IF;
129413: END LOOP;
129414:
129415: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
129416: fnd_file.put_line(fnd_file.LOG, ' ');
129417:
129418:
129419: xla_exceptions_pkg.raise_message
129412: END IF;
129413: END LOOP;
129414:
129415: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
129416: fnd_file.put_line(fnd_file.LOG, ' ');
129417:
129418:
129419: xla_exceptions_pkg.raise_message
129420: (p_location => 'XLA_00200_AAD_S_000010_PKG.EventClass_209');
133589:
133590: l_first_event_id := l_array_header_events(l_array_header_events.FIRST);
133591: l_last_event_id := l_array_header_events(l_array_header_events.LAST);
133592:
133593: fnd_file.put_line(fnd_file.LOG, ' ');
133594: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
133595: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );
133596: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');
133597:
133590: l_first_event_id := l_array_header_events(l_array_header_events.FIRST);
133591: l_last_event_id := l_array_header_events(l_array_header_events.LAST);
133592:
133593: fnd_file.put_line(fnd_file.LOG, ' ');
133594: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
133595: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );
133596: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');
133597:
133598: FOR line_record IN line_cur(l_first_event_id, l_last_event_id)
133591: l_last_event_id := l_array_header_events(l_array_header_events.LAST);
133592:
133593: fnd_file.put_line(fnd_file.LOG, ' ');
133594: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
133595: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );
133596: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');
133597:
133598: FOR line_record IN line_cur(l_first_event_id, l_last_event_id)
133599: LOOP
133592:
133593: fnd_file.put_line(fnd_file.LOG, ' ');
133594: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
133595: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );
133596: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');
133597:
133598: FOR line_record IN line_cur(l_first_event_id, l_last_event_id)
133599: LOOP
133600: IF (NOT l_array_header_events.EXISTS(line_record.event_id)) AND (NOT l_array_duplicate_checker.EXISTS(line_record.event_id)) THEN
133597:
133598: FOR line_record IN line_cur(l_first_event_id, l_last_event_id)
133599: LOOP
133600: IF (NOT l_array_header_events.EXISTS(line_record.event_id)) AND (NOT l_array_duplicate_checker.EXISTS(line_record.event_id)) THEN
133601: fnd_file.put_line(fnd_file.log, 'Event_id = ' || line_record.event_id);
133602: l_array_duplicate_checker(line_record.event_id) := line_record.event_id;
133603: END IF;
133604: END LOOP;
133605:
133602: l_array_duplicate_checker(line_record.event_id) := line_record.event_id;
133603: END IF;
133604: END LOOP;
133605:
133606: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
133607: fnd_file.put_line(fnd_file.LOG, ' ');
133608:
133609:
133610: xla_exceptions_pkg.raise_message
133603: END IF;
133604: END LOOP;
133605:
133606: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
133607: fnd_file.put_line(fnd_file.LOG, ' ');
133608:
133609:
133610: xla_exceptions_pkg.raise_message
133611: (p_location => 'XLA_00200_AAD_S_000010_PKG.EventClass_210');
134846:
134847: l_first_event_id := l_array_header_events(l_array_header_events.FIRST);
134848: l_last_event_id := l_array_header_events(l_array_header_events.LAST);
134849:
134850: fnd_file.put_line(fnd_file.LOG, ' ');
134851: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
134852: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );
134853: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');
134854:
134847: l_first_event_id := l_array_header_events(l_array_header_events.FIRST);
134848: l_last_event_id := l_array_header_events(l_array_header_events.LAST);
134849:
134850: fnd_file.put_line(fnd_file.LOG, ' ');
134851: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
134852: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );
134853: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');
134854:
134855: FOR line_record IN line_cur(l_first_event_id, l_last_event_id)
134848: l_last_event_id := l_array_header_events(l_array_header_events.LAST);
134849:
134850: fnd_file.put_line(fnd_file.LOG, ' ');
134851: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
134852: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );
134853: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');
134854:
134855: FOR line_record IN line_cur(l_first_event_id, l_last_event_id)
134856: LOOP
134849:
134850: fnd_file.put_line(fnd_file.LOG, ' ');
134851: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
134852: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );
134853: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');
134854:
134855: FOR line_record IN line_cur(l_first_event_id, l_last_event_id)
134856: LOOP
134857: IF (NOT l_array_header_events.EXISTS(line_record.event_id)) AND (NOT l_array_duplicate_checker.EXISTS(line_record.event_id)) THEN
134854:
134855: FOR line_record IN line_cur(l_first_event_id, l_last_event_id)
134856: LOOP
134857: IF (NOT l_array_header_events.EXISTS(line_record.event_id)) AND (NOT l_array_duplicate_checker.EXISTS(line_record.event_id)) THEN
134858: fnd_file.put_line(fnd_file.log, 'Event_id = ' || line_record.event_id);
134859: l_array_duplicate_checker(line_record.event_id) := line_record.event_id;
134860: END IF;
134861: END LOOP;
134862:
134859: l_array_duplicate_checker(line_record.event_id) := line_record.event_id;
134860: END IF;
134861: END LOOP;
134862:
134863: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
134864: fnd_file.put_line(fnd_file.LOG, ' ');
134865:
134866:
134867: xla_exceptions_pkg.raise_message
134860: END IF;
134861: END LOOP;
134862:
134863: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
134864: fnd_file.put_line(fnd_file.LOG, ' ');
134865:
134866:
134867: xla_exceptions_pkg.raise_message
134868: (p_location => 'XLA_00200_AAD_S_000010_PKG.EventClass_211');
135958:
135959: l_first_event_id := l_array_header_events(l_array_header_events.FIRST);
135960: l_last_event_id := l_array_header_events(l_array_header_events.LAST);
135961:
135962: fnd_file.put_line(fnd_file.LOG, ' ');
135963: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
135964: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );
135965: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');
135966:
135959: l_first_event_id := l_array_header_events(l_array_header_events.FIRST);
135960: l_last_event_id := l_array_header_events(l_array_header_events.LAST);
135961:
135962: fnd_file.put_line(fnd_file.LOG, ' ');
135963: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
135964: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );
135965: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');
135966:
135967: FOR line_record IN line_cur(l_first_event_id, l_last_event_id)
135960: l_last_event_id := l_array_header_events(l_array_header_events.LAST);
135961:
135962: fnd_file.put_line(fnd_file.LOG, ' ');
135963: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
135964: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );
135965: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');
135966:
135967: FOR line_record IN line_cur(l_first_event_id, l_last_event_id)
135968: LOOP
135961:
135962: fnd_file.put_line(fnd_file.LOG, ' ');
135963: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
135964: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );
135965: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');
135966:
135967: FOR line_record IN line_cur(l_first_event_id, l_last_event_id)
135968: LOOP
135969: IF (NOT l_array_header_events.EXISTS(line_record.event_id)) AND (NOT l_array_duplicate_checker.EXISTS(line_record.event_id)) THEN
135966:
135967: FOR line_record IN line_cur(l_first_event_id, l_last_event_id)
135968: LOOP
135969: IF (NOT l_array_header_events.EXISTS(line_record.event_id)) AND (NOT l_array_duplicate_checker.EXISTS(line_record.event_id)) THEN
135970: fnd_file.put_line(fnd_file.log, 'Event_id = ' || line_record.event_id);
135971: l_array_duplicate_checker(line_record.event_id) := line_record.event_id;
135972: END IF;
135973: END LOOP;
135974:
135971: l_array_duplicate_checker(line_record.event_id) := line_record.event_id;
135972: END IF;
135973: END LOOP;
135974:
135975: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
135976: fnd_file.put_line(fnd_file.LOG, ' ');
135977:
135978:
135979: xla_exceptions_pkg.raise_message
135972: END IF;
135973: END LOOP;
135974:
135975: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
135976: fnd_file.put_line(fnd_file.LOG, ' ');
135977:
135978:
135979: xla_exceptions_pkg.raise_message
135980: (p_location => 'XLA_00200_AAD_S_000010_PKG.EventClass_212');
137070:
137071: l_first_event_id := l_array_header_events(l_array_header_events.FIRST);
137072: l_last_event_id := l_array_header_events(l_array_header_events.LAST);
137073:
137074: fnd_file.put_line(fnd_file.LOG, ' ');
137075: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
137076: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );
137077: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');
137078:
137071: l_first_event_id := l_array_header_events(l_array_header_events.FIRST);
137072: l_last_event_id := l_array_header_events(l_array_header_events.LAST);
137073:
137074: fnd_file.put_line(fnd_file.LOG, ' ');
137075: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
137076: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );
137077: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');
137078:
137079: FOR line_record IN line_cur(l_first_event_id, l_last_event_id)
137072: l_last_event_id := l_array_header_events(l_array_header_events.LAST);
137073:
137074: fnd_file.put_line(fnd_file.LOG, ' ');
137075: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
137076: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );
137077: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');
137078:
137079: FOR line_record IN line_cur(l_first_event_id, l_last_event_id)
137080: LOOP
137073:
137074: fnd_file.put_line(fnd_file.LOG, ' ');
137075: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
137076: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );
137077: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');
137078:
137079: FOR line_record IN line_cur(l_first_event_id, l_last_event_id)
137080: LOOP
137081: IF (NOT l_array_header_events.EXISTS(line_record.event_id)) AND (NOT l_array_duplicate_checker.EXISTS(line_record.event_id)) THEN
137078:
137079: FOR line_record IN line_cur(l_first_event_id, l_last_event_id)
137080: LOOP
137081: IF (NOT l_array_header_events.EXISTS(line_record.event_id)) AND (NOT l_array_duplicate_checker.EXISTS(line_record.event_id)) THEN
137082: fnd_file.put_line(fnd_file.log, 'Event_id = ' || line_record.event_id);
137083: l_array_duplicate_checker(line_record.event_id) := line_record.event_id;
137084: END IF;
137085: END LOOP;
137086:
137083: l_array_duplicate_checker(line_record.event_id) := line_record.event_id;
137084: END IF;
137085: END LOOP;
137086:
137087: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
137088: fnd_file.put_line(fnd_file.LOG, ' ');
137089:
137090:
137091: xla_exceptions_pkg.raise_message
137084: END IF;
137085: END LOOP;
137086:
137087: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
137088: fnd_file.put_line(fnd_file.LOG, ' ');
137089:
137090:
137091: xla_exceptions_pkg.raise_message
137092: (p_location => 'XLA_00200_AAD_S_000010_PKG.EventClass_213');
141277:
141278: l_first_event_id := l_array_header_events(l_array_header_events.FIRST);
141279: l_last_event_id := l_array_header_events(l_array_header_events.LAST);
141280:
141281: fnd_file.put_line(fnd_file.LOG, ' ');
141282: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
141283: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );
141284: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');
141285:
141278: l_first_event_id := l_array_header_events(l_array_header_events.FIRST);
141279: l_last_event_id := l_array_header_events(l_array_header_events.LAST);
141280:
141281: fnd_file.put_line(fnd_file.LOG, ' ');
141282: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
141283: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );
141284: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');
141285:
141286: FOR line_record IN line_cur(l_first_event_id, l_last_event_id)
141279: l_last_event_id := l_array_header_events(l_array_header_events.LAST);
141280:
141281: fnd_file.put_line(fnd_file.LOG, ' ');
141282: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
141283: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );
141284: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');
141285:
141286: FOR line_record IN line_cur(l_first_event_id, l_last_event_id)
141287: LOOP
141280:
141281: fnd_file.put_line(fnd_file.LOG, ' ');
141282: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
141283: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );
141284: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');
141285:
141286: FOR line_record IN line_cur(l_first_event_id, l_last_event_id)
141287: LOOP
141288: IF (NOT l_array_header_events.EXISTS(line_record.event_id)) AND (NOT l_array_duplicate_checker.EXISTS(line_record.event_id)) THEN
141285:
141286: FOR line_record IN line_cur(l_first_event_id, l_last_event_id)
141287: LOOP
141288: IF (NOT l_array_header_events.EXISTS(line_record.event_id)) AND (NOT l_array_duplicate_checker.EXISTS(line_record.event_id)) THEN
141289: fnd_file.put_line(fnd_file.log, 'Event_id = ' || line_record.event_id);
141290: l_array_duplicate_checker(line_record.event_id) := line_record.event_id;
141291: END IF;
141292: END LOOP;
141293:
141290: l_array_duplicate_checker(line_record.event_id) := line_record.event_id;
141291: END IF;
141292: END LOOP;
141293:
141294: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
141295: fnd_file.put_line(fnd_file.LOG, ' ');
141296:
141297:
141298: xla_exceptions_pkg.raise_message
141291: END IF;
141292: END LOOP;
141293:
141294: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
141295: fnd_file.put_line(fnd_file.LOG, ' ');
141296:
141297:
141298: xla_exceptions_pkg.raise_message
141299: (p_location => 'XLA_00200_AAD_S_000010_PKG.EventClass_214');
144696:
144697: l_first_event_id := l_array_header_events(l_array_header_events.FIRST);
144698: l_last_event_id := l_array_header_events(l_array_header_events.LAST);
144699:
144700: fnd_file.put_line(fnd_file.LOG, ' ');
144701: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
144702: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );
144703: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');
144704:
144697: l_first_event_id := l_array_header_events(l_array_header_events.FIRST);
144698: l_last_event_id := l_array_header_events(l_array_header_events.LAST);
144699:
144700: fnd_file.put_line(fnd_file.LOG, ' ');
144701: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
144702: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );
144703: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');
144704:
144705: FOR line_record IN line_cur(l_first_event_id, l_last_event_id)
144698: l_last_event_id := l_array_header_events(l_array_header_events.LAST);
144699:
144700: fnd_file.put_line(fnd_file.LOG, ' ');
144701: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
144702: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );
144703: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');
144704:
144705: FOR line_record IN line_cur(l_first_event_id, l_last_event_id)
144706: LOOP
144699:
144700: fnd_file.put_line(fnd_file.LOG, ' ');
144701: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
144702: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );
144703: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');
144704:
144705: FOR line_record IN line_cur(l_first_event_id, l_last_event_id)
144706: LOOP
144707: IF (NOT l_array_header_events.EXISTS(line_record.event_id)) AND (NOT l_array_duplicate_checker.EXISTS(line_record.event_id)) THEN
144704:
144705: FOR line_record IN line_cur(l_first_event_id, l_last_event_id)
144706: LOOP
144707: IF (NOT l_array_header_events.EXISTS(line_record.event_id)) AND (NOT l_array_duplicate_checker.EXISTS(line_record.event_id)) THEN
144708: fnd_file.put_line(fnd_file.log, 'Event_id = ' || line_record.event_id);
144709: l_array_duplicate_checker(line_record.event_id) := line_record.event_id;
144710: END IF;
144711: END LOOP;
144712:
144709: l_array_duplicate_checker(line_record.event_id) := line_record.event_id;
144710: END IF;
144711: END LOOP;
144712:
144713: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
144714: fnd_file.put_line(fnd_file.LOG, ' ');
144715:
144716:
144717: xla_exceptions_pkg.raise_message
144710: END IF;
144711: END LOOP;
144712:
144713: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
144714: fnd_file.put_line(fnd_file.LOG, ' ');
144715:
144716:
144717: xla_exceptions_pkg.raise_message
144718: (p_location => 'XLA_00200_AAD_S_000010_PKG.EventClass_215');