38629:
38630: l_first_event_id := l_array_header_events(l_array_header_events.FIRST);
38631: l_last_event_id := l_array_header_events(l_array_header_events.LAST);
38632:
38633: fnd_file.put_line(fnd_file.LOG, ' ');
38634: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
38635: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );
38636: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');
38637:
38630: l_first_event_id := l_array_header_events(l_array_header_events.FIRST);
38631: l_last_event_id := l_array_header_events(l_array_header_events.LAST);
38632:
38633: fnd_file.put_line(fnd_file.LOG, ' ');
38634: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
38635: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );
38636: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');
38637:
38638: FOR line_record IN line_cur(l_first_event_id, l_last_event_id)
38631: l_last_event_id := l_array_header_events(l_array_header_events.LAST);
38632:
38633: fnd_file.put_line(fnd_file.LOG, ' ');
38634: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
38635: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );
38636: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');
38637:
38638: FOR line_record IN line_cur(l_first_event_id, l_last_event_id)
38639: LOOP
38632:
38633: fnd_file.put_line(fnd_file.LOG, ' ');
38634: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
38635: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );
38636: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');
38637:
38638: FOR line_record IN line_cur(l_first_event_id, l_last_event_id)
38639: LOOP
38640: IF (NOT l_array_header_events.EXISTS(line_record.event_id)) AND (NOT l_array_duplicate_checker.EXISTS(line_record.event_id)) THEN
38637:
38638: FOR line_record IN line_cur(l_first_event_id, l_last_event_id)
38639: LOOP
38640: IF (NOT l_array_header_events.EXISTS(line_record.event_id)) AND (NOT l_array_duplicate_checker.EXISTS(line_record.event_id)) THEN
38641: fnd_file.put_line(fnd_file.log, 'Event_id = ' || line_record.event_id);
38642: l_array_duplicate_checker(line_record.event_id) := line_record.event_id;
38643: END IF;
38644: END LOOP;
38645:
38642: l_array_duplicate_checker(line_record.event_id) := line_record.event_id;
38643: END IF;
38644: END LOOP;
38645:
38646: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
38647: fnd_file.put_line(fnd_file.LOG, ' ');
38648:
38649:
38650: xla_exceptions_pkg.raise_message
38643: END IF;
38644: END LOOP;
38645:
38646: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
38647: fnd_file.put_line(fnd_file.LOG, ' ');
38648:
38649:
38650: xla_exceptions_pkg.raise_message
38651: (p_location => 'XLA_00200_AAD_S_000012_BC_PKG.EventClass_60');
40962:
40963: l_first_event_id := l_array_header_events(l_array_header_events.FIRST);
40964: l_last_event_id := l_array_header_events(l_array_header_events.LAST);
40965:
40966: fnd_file.put_line(fnd_file.LOG, ' ');
40967: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
40968: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );
40969: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');
40970:
40963: l_first_event_id := l_array_header_events(l_array_header_events.FIRST);
40964: l_last_event_id := l_array_header_events(l_array_header_events.LAST);
40965:
40966: fnd_file.put_line(fnd_file.LOG, ' ');
40967: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
40968: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );
40969: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');
40970:
40971: FOR line_record IN line_cur(l_first_event_id, l_last_event_id)
40964: l_last_event_id := l_array_header_events(l_array_header_events.LAST);
40965:
40966: fnd_file.put_line(fnd_file.LOG, ' ');
40967: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
40968: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );
40969: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');
40970:
40971: FOR line_record IN line_cur(l_first_event_id, l_last_event_id)
40972: LOOP
40965:
40966: fnd_file.put_line(fnd_file.LOG, ' ');
40967: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
40968: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );
40969: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');
40970:
40971: FOR line_record IN line_cur(l_first_event_id, l_last_event_id)
40972: LOOP
40973: IF (NOT l_array_header_events.EXISTS(line_record.event_id)) AND (NOT l_array_duplicate_checker.EXISTS(line_record.event_id)) THEN
40970:
40971: FOR line_record IN line_cur(l_first_event_id, l_last_event_id)
40972: LOOP
40973: IF (NOT l_array_header_events.EXISTS(line_record.event_id)) AND (NOT l_array_duplicate_checker.EXISTS(line_record.event_id)) THEN
40974: fnd_file.put_line(fnd_file.log, 'Event_id = ' || line_record.event_id);
40975: l_array_duplicate_checker(line_record.event_id) := line_record.event_id;
40976: END IF;
40977: END LOOP;
40978:
40975: l_array_duplicate_checker(line_record.event_id) := line_record.event_id;
40976: END IF;
40977: END LOOP;
40978:
40979: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
40980: fnd_file.put_line(fnd_file.LOG, ' ');
40981:
40982:
40983: xla_exceptions_pkg.raise_message
40976: END IF;
40977: END LOOP;
40978:
40979: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
40980: fnd_file.put_line(fnd_file.LOG, ' ');
40981:
40982:
40983: xla_exceptions_pkg.raise_message
40984: (p_location => 'XLA_00200_AAD_S_000012_BC_PKG.EventClass_61');
43997:
43998: l_first_event_id := l_array_header_events(l_array_header_events.FIRST);
43999: l_last_event_id := l_array_header_events(l_array_header_events.LAST);
44000:
44001: fnd_file.put_line(fnd_file.LOG, ' ');
44002: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
44003: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );
44004: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');
44005:
43998: l_first_event_id := l_array_header_events(l_array_header_events.FIRST);
43999: l_last_event_id := l_array_header_events(l_array_header_events.LAST);
44000:
44001: fnd_file.put_line(fnd_file.LOG, ' ');
44002: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
44003: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );
44004: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');
44005:
44006: FOR line_record IN line_cur(l_first_event_id, l_last_event_id)
43999: l_last_event_id := l_array_header_events(l_array_header_events.LAST);
44000:
44001: fnd_file.put_line(fnd_file.LOG, ' ');
44002: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
44003: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );
44004: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');
44005:
44006: FOR line_record IN line_cur(l_first_event_id, l_last_event_id)
44007: LOOP
44000:
44001: fnd_file.put_line(fnd_file.LOG, ' ');
44002: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
44003: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );
44004: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');
44005:
44006: FOR line_record IN line_cur(l_first_event_id, l_last_event_id)
44007: LOOP
44008: IF (NOT l_array_header_events.EXISTS(line_record.event_id)) AND (NOT l_array_duplicate_checker.EXISTS(line_record.event_id)) THEN
44005:
44006: FOR line_record IN line_cur(l_first_event_id, l_last_event_id)
44007: LOOP
44008: IF (NOT l_array_header_events.EXISTS(line_record.event_id)) AND (NOT l_array_duplicate_checker.EXISTS(line_record.event_id)) THEN
44009: fnd_file.put_line(fnd_file.log, 'Event_id = ' || line_record.event_id);
44010: l_array_duplicate_checker(line_record.event_id) := line_record.event_id;
44011: END IF;
44012: END LOOP;
44013:
44010: l_array_duplicate_checker(line_record.event_id) := line_record.event_id;
44011: END IF;
44012: END LOOP;
44013:
44014: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
44015: fnd_file.put_line(fnd_file.LOG, ' ');
44016:
44017:
44018: xla_exceptions_pkg.raise_message
44011: END IF;
44012: END LOOP;
44013:
44014: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
44015: fnd_file.put_line(fnd_file.LOG, ' ');
44016:
44017:
44018: xla_exceptions_pkg.raise_message
44019: (p_location => 'XLA_00200_AAD_S_000012_BC_PKG.EventClass_62');
45657:
45658: l_first_event_id := l_array_header_events(l_array_header_events.FIRST);
45659: l_last_event_id := l_array_header_events(l_array_header_events.LAST);
45660:
45661: fnd_file.put_line(fnd_file.LOG, ' ');
45662: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
45663: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );
45664: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');
45665:
45658: l_first_event_id := l_array_header_events(l_array_header_events.FIRST);
45659: l_last_event_id := l_array_header_events(l_array_header_events.LAST);
45660:
45661: fnd_file.put_line(fnd_file.LOG, ' ');
45662: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
45663: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );
45664: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');
45665:
45666: FOR line_record IN line_cur(l_first_event_id, l_last_event_id)
45659: l_last_event_id := l_array_header_events(l_array_header_events.LAST);
45660:
45661: fnd_file.put_line(fnd_file.LOG, ' ');
45662: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
45663: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );
45664: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');
45665:
45666: FOR line_record IN line_cur(l_first_event_id, l_last_event_id)
45667: LOOP
45660:
45661: fnd_file.put_line(fnd_file.LOG, ' ');
45662: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
45663: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );
45664: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');
45665:
45666: FOR line_record IN line_cur(l_first_event_id, l_last_event_id)
45667: LOOP
45668: IF (NOT l_array_header_events.EXISTS(line_record.event_id)) AND (NOT l_array_duplicate_checker.EXISTS(line_record.event_id)) THEN
45665:
45666: FOR line_record IN line_cur(l_first_event_id, l_last_event_id)
45667: LOOP
45668: IF (NOT l_array_header_events.EXISTS(line_record.event_id)) AND (NOT l_array_duplicate_checker.EXISTS(line_record.event_id)) THEN
45669: fnd_file.put_line(fnd_file.log, 'Event_id = ' || line_record.event_id);
45670: l_array_duplicate_checker(line_record.event_id) := line_record.event_id;
45671: END IF;
45672: END LOOP;
45673:
45670: l_array_duplicate_checker(line_record.event_id) := line_record.event_id;
45671: END IF;
45672: END LOOP;
45673:
45674: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
45675: fnd_file.put_line(fnd_file.LOG, ' ');
45676:
45677:
45678: xla_exceptions_pkg.raise_message
45671: END IF;
45672: END LOOP;
45673:
45674: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
45675: fnd_file.put_line(fnd_file.LOG, ' ');
45676:
45677:
45678: xla_exceptions_pkg.raise_message
45679: (p_location => 'XLA_00200_AAD_S_000012_BC_PKG.EventClass_63');