7629:
7630: l_first_event_id := l_array_header_events(l_array_header_events.FIRST);
7631: l_last_event_id := l_array_header_events(l_array_header_events.LAST);
7632:
7633: fnd_file.put_line(fnd_file.LOG, ' ');
7634: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
7635: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );
7636: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');
7637:
7630: l_first_event_id := l_array_header_events(l_array_header_events.FIRST);
7631: l_last_event_id := l_array_header_events(l_array_header_events.LAST);
7632:
7633: fnd_file.put_line(fnd_file.LOG, ' ');
7634: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
7635: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );
7636: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');
7637:
7638: FOR line_record IN line_cur(l_first_event_id, l_last_event_id)
7631: l_last_event_id := l_array_header_events(l_array_header_events.LAST);
7632:
7633: fnd_file.put_line(fnd_file.LOG, ' ');
7634: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
7635: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );
7636: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');
7637:
7638: FOR line_record IN line_cur(l_first_event_id, l_last_event_id)
7639: LOOP
7632:
7633: fnd_file.put_line(fnd_file.LOG, ' ');
7634: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
7635: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );
7636: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');
7637:
7638: FOR line_record IN line_cur(l_first_event_id, l_last_event_id)
7639: LOOP
7640: IF (NOT l_array_header_events.EXISTS(line_record.event_id)) AND (NOT l_array_duplicate_checker.EXISTS(line_record.event_id)) THEN
7637:
7638: FOR line_record IN line_cur(l_first_event_id, l_last_event_id)
7639: LOOP
7640: IF (NOT l_array_header_events.EXISTS(line_record.event_id)) AND (NOT l_array_duplicate_checker.EXISTS(line_record.event_id)) THEN
7641: fnd_file.put_line(fnd_file.log, 'Event_id = ' || line_record.event_id);
7642: l_array_duplicate_checker(line_record.event_id) := line_record.event_id;
7643: END IF;
7644: END LOOP;
7645:
7642: l_array_duplicate_checker(line_record.event_id) := line_record.event_id;
7643: END IF;
7644: END LOOP;
7645:
7646: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
7647: fnd_file.put_line(fnd_file.LOG, ' ');
7648:
7649:
7650: xla_exceptions_pkg.raise_message
7643: END IF;
7644: END LOOP;
7645:
7646: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
7647: fnd_file.put_line(fnd_file.LOG, ' ');
7648:
7649:
7650: xla_exceptions_pkg.raise_message
7651: (p_location => 'XLA_09000_AAD_S_000015_PKG.EventClass_18');
8823:
8824: l_first_event_id := l_array_header_events(l_array_header_events.FIRST);
8825: l_last_event_id := l_array_header_events(l_array_header_events.LAST);
8826:
8827: fnd_file.put_line(fnd_file.LOG, ' ');
8828: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
8829: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );
8830: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');
8831:
8824: l_first_event_id := l_array_header_events(l_array_header_events.FIRST);
8825: l_last_event_id := l_array_header_events(l_array_header_events.LAST);
8826:
8827: fnd_file.put_line(fnd_file.LOG, ' ');
8828: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
8829: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );
8830: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');
8831:
8832: FOR line_record IN line_cur(l_first_event_id, l_last_event_id)
8825: l_last_event_id := l_array_header_events(l_array_header_events.LAST);
8826:
8827: fnd_file.put_line(fnd_file.LOG, ' ');
8828: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
8829: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );
8830: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');
8831:
8832: FOR line_record IN line_cur(l_first_event_id, l_last_event_id)
8833: LOOP
8826:
8827: fnd_file.put_line(fnd_file.LOG, ' ');
8828: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
8829: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );
8830: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');
8831:
8832: FOR line_record IN line_cur(l_first_event_id, l_last_event_id)
8833: LOOP
8834: IF (NOT l_array_header_events.EXISTS(line_record.event_id)) AND (NOT l_array_duplicate_checker.EXISTS(line_record.event_id)) THEN
8831:
8832: FOR line_record IN line_cur(l_first_event_id, l_last_event_id)
8833: LOOP
8834: IF (NOT l_array_header_events.EXISTS(line_record.event_id)) AND (NOT l_array_duplicate_checker.EXISTS(line_record.event_id)) THEN
8835: fnd_file.put_line(fnd_file.log, 'Event_id = ' || line_record.event_id);
8836: l_array_duplicate_checker(line_record.event_id) := line_record.event_id;
8837: END IF;
8838: END LOOP;
8839:
8836: l_array_duplicate_checker(line_record.event_id) := line_record.event_id;
8837: END IF;
8838: END LOOP;
8839:
8840: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
8841: fnd_file.put_line(fnd_file.LOG, ' ');
8842:
8843:
8844: xla_exceptions_pkg.raise_message
8837: END IF;
8838: END LOOP;
8839:
8840: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
8841: fnd_file.put_line(fnd_file.LOG, ' ');
8842:
8843:
8844: xla_exceptions_pkg.raise_message
8845: (p_location => 'XLA_09000_AAD_S_000015_PKG.EventType_19');
9986:
9987: l_first_event_id := l_array_header_events(l_array_header_events.FIRST);
9988: l_last_event_id := l_array_header_events(l_array_header_events.LAST);
9989:
9990: fnd_file.put_line(fnd_file.LOG, ' ');
9991: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
9992: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );
9993: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');
9994:
9987: l_first_event_id := l_array_header_events(l_array_header_events.FIRST);
9988: l_last_event_id := l_array_header_events(l_array_header_events.LAST);
9989:
9990: fnd_file.put_line(fnd_file.LOG, ' ');
9991: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
9992: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );
9993: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');
9994:
9995: FOR line_record IN line_cur(l_first_event_id, l_last_event_id)
9988: l_last_event_id := l_array_header_events(l_array_header_events.LAST);
9989:
9990: fnd_file.put_line(fnd_file.LOG, ' ');
9991: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
9992: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );
9993: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');
9994:
9995: FOR line_record IN line_cur(l_first_event_id, l_last_event_id)
9996: LOOP
9989:
9990: fnd_file.put_line(fnd_file.LOG, ' ');
9991: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
9992: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );
9993: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');
9994:
9995: FOR line_record IN line_cur(l_first_event_id, l_last_event_id)
9996: LOOP
9997: IF (NOT l_array_header_events.EXISTS(line_record.event_id)) AND (NOT l_array_duplicate_checker.EXISTS(line_record.event_id)) THEN
9994:
9995: FOR line_record IN line_cur(l_first_event_id, l_last_event_id)
9996: LOOP
9997: IF (NOT l_array_header_events.EXISTS(line_record.event_id)) AND (NOT l_array_duplicate_checker.EXISTS(line_record.event_id)) THEN
9998: fnd_file.put_line(fnd_file.log, 'Event_id = ' || line_record.event_id);
9999: l_array_duplicate_checker(line_record.event_id) := line_record.event_id;
10000: END IF;
10001: END LOOP;
10002:
9999: l_array_duplicate_checker(line_record.event_id) := line_record.event_id;
10000: END IF;
10001: END LOOP;
10002:
10003: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
10004: fnd_file.put_line(fnd_file.LOG, ' ');
10005:
10006:
10007: xla_exceptions_pkg.raise_message
10000: END IF;
10001: END LOOP;
10002:
10003: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
10004: fnd_file.put_line(fnd_file.LOG, ' ');
10005:
10006:
10007: xla_exceptions_pkg.raise_message
10008: (p_location => 'XLA_09000_AAD_S_000015_PKG.EventType_20');
11180:
11181: l_first_event_id := l_array_header_events(l_array_header_events.FIRST);
11182: l_last_event_id := l_array_header_events(l_array_header_events.LAST);
11183:
11184: fnd_file.put_line(fnd_file.LOG, ' ');
11185: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
11186: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );
11187: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');
11188:
11181: l_first_event_id := l_array_header_events(l_array_header_events.FIRST);
11182: l_last_event_id := l_array_header_events(l_array_header_events.LAST);
11183:
11184: fnd_file.put_line(fnd_file.LOG, ' ');
11185: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
11186: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );
11187: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');
11188:
11189: FOR line_record IN line_cur(l_first_event_id, l_last_event_id)
11182: l_last_event_id := l_array_header_events(l_array_header_events.LAST);
11183:
11184: fnd_file.put_line(fnd_file.LOG, ' ');
11185: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
11186: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );
11187: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');
11188:
11189: FOR line_record IN line_cur(l_first_event_id, l_last_event_id)
11190: LOOP
11183:
11184: fnd_file.put_line(fnd_file.LOG, ' ');
11185: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
11186: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );
11187: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');
11188:
11189: FOR line_record IN line_cur(l_first_event_id, l_last_event_id)
11190: LOOP
11191: IF (NOT l_array_header_events.EXISTS(line_record.event_id)) AND (NOT l_array_duplicate_checker.EXISTS(line_record.event_id)) THEN
11188:
11189: FOR line_record IN line_cur(l_first_event_id, l_last_event_id)
11190: LOOP
11191: IF (NOT l_array_header_events.EXISTS(line_record.event_id)) AND (NOT l_array_duplicate_checker.EXISTS(line_record.event_id)) THEN
11192: fnd_file.put_line(fnd_file.log, 'Event_id = ' || line_record.event_id);
11193: l_array_duplicate_checker(line_record.event_id) := line_record.event_id;
11194: END IF;
11195: END LOOP;
11196:
11193: l_array_duplicate_checker(line_record.event_id) := line_record.event_id;
11194: END IF;
11195: END LOOP;
11196:
11197: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
11198: fnd_file.put_line(fnd_file.LOG, ' ');
11199:
11200:
11201: xla_exceptions_pkg.raise_message
11194: END IF;
11195: END LOOP;
11196:
11197: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
11198: fnd_file.put_line(fnd_file.LOG, ' ');
11199:
11200:
11201: xla_exceptions_pkg.raise_message
11202: (p_location => 'XLA_09000_AAD_S_000015_PKG.EventType_21');
12374:
12375: l_first_event_id := l_array_header_events(l_array_header_events.FIRST);
12376: l_last_event_id := l_array_header_events(l_array_header_events.LAST);
12377:
12378: fnd_file.put_line(fnd_file.LOG, ' ');
12379: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
12380: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );
12381: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');
12382:
12375: l_first_event_id := l_array_header_events(l_array_header_events.FIRST);
12376: l_last_event_id := l_array_header_events(l_array_header_events.LAST);
12377:
12378: fnd_file.put_line(fnd_file.LOG, ' ');
12379: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
12380: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );
12381: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');
12382:
12383: FOR line_record IN line_cur(l_first_event_id, l_last_event_id)
12376: l_last_event_id := l_array_header_events(l_array_header_events.LAST);
12377:
12378: fnd_file.put_line(fnd_file.LOG, ' ');
12379: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
12380: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );
12381: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');
12382:
12383: FOR line_record IN line_cur(l_first_event_id, l_last_event_id)
12384: LOOP
12377:
12378: fnd_file.put_line(fnd_file.LOG, ' ');
12379: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
12380: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );
12381: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');
12382:
12383: FOR line_record IN line_cur(l_first_event_id, l_last_event_id)
12384: LOOP
12385: IF (NOT l_array_header_events.EXISTS(line_record.event_id)) AND (NOT l_array_duplicate_checker.EXISTS(line_record.event_id)) THEN
12382:
12383: FOR line_record IN line_cur(l_first_event_id, l_last_event_id)
12384: LOOP
12385: IF (NOT l_array_header_events.EXISTS(line_record.event_id)) AND (NOT l_array_duplicate_checker.EXISTS(line_record.event_id)) THEN
12386: fnd_file.put_line(fnd_file.log, 'Event_id = ' || line_record.event_id);
12387: l_array_duplicate_checker(line_record.event_id) := line_record.event_id;
12388: END IF;
12389: END LOOP;
12390:
12387: l_array_duplicate_checker(line_record.event_id) := line_record.event_id;
12388: END IF;
12389: END LOOP;
12390:
12391: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
12392: fnd_file.put_line(fnd_file.LOG, ' ');
12393:
12394:
12395: xla_exceptions_pkg.raise_message
12388: END IF;
12389: END LOOP;
12390:
12391: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
12392: fnd_file.put_line(fnd_file.LOG, ' ');
12393:
12394:
12395: xla_exceptions_pkg.raise_message
12396: (p_location => 'XLA_09000_AAD_S_000015_PKG.EventType_22');