64365:
64366: l_first_event_id := l_array_header_events(l_array_header_events.FIRST);
64367: l_last_event_id := l_array_header_events(l_array_header_events.LAST);
64368:
64369: fnd_file.put_line(fnd_file.LOG, ' ');
64370: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
64371: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );
64372: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');
64373:
64366: l_first_event_id := l_array_header_events(l_array_header_events.FIRST);
64367: l_last_event_id := l_array_header_events(l_array_header_events.LAST);
64368:
64369: fnd_file.put_line(fnd_file.LOG, ' ');
64370: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
64371: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );
64372: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');
64373:
64374: FOR line_record IN line_cur(l_first_event_id, l_last_event_id)
64367: l_last_event_id := l_array_header_events(l_array_header_events.LAST);
64368:
64369: fnd_file.put_line(fnd_file.LOG, ' ');
64370: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
64371: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );
64372: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');
64373:
64374: FOR line_record IN line_cur(l_first_event_id, l_last_event_id)
64375: LOOP
64368:
64369: fnd_file.put_line(fnd_file.LOG, ' ');
64370: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
64371: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );
64372: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');
64373:
64374: FOR line_record IN line_cur(l_first_event_id, l_last_event_id)
64375: LOOP
64376: IF (NOT l_array_header_events.EXISTS(line_record.event_id)) AND (NOT l_array_duplicate_checker.EXISTS(line_record.event_id)) THEN
64373:
64374: FOR line_record IN line_cur(l_first_event_id, l_last_event_id)
64375: LOOP
64376: IF (NOT l_array_header_events.EXISTS(line_record.event_id)) AND (NOT l_array_duplicate_checker.EXISTS(line_record.event_id)) THEN
64377: fnd_file.put_line(fnd_file.log, 'Event_id = ' || line_record.event_id);
64378: l_array_duplicate_checker(line_record.event_id) := line_record.event_id;
64379: END IF;
64380: END LOOP;
64381:
64378: l_array_duplicate_checker(line_record.event_id) := line_record.event_id;
64379: END IF;
64380: END LOOP;
64381:
64382: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
64383: fnd_file.put_line(fnd_file.LOG, ' ');
64384:
64385:
64386: xla_exceptions_pkg.raise_message
64379: END IF;
64380: END LOOP;
64381:
64382: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
64383: fnd_file.put_line(fnd_file.LOG, ' ');
64384:
64385:
64386: xla_exceptions_pkg.raise_message
64387: (p_location => 'XLA_00222_AAD_S_000017_PKG.EventClass_126');
65722:
65723: l_first_event_id := l_array_header_events(l_array_header_events.FIRST);
65724: l_last_event_id := l_array_header_events(l_array_header_events.LAST);
65725:
65726: fnd_file.put_line(fnd_file.LOG, ' ');
65727: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
65728: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );
65729: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');
65730:
65723: l_first_event_id := l_array_header_events(l_array_header_events.FIRST);
65724: l_last_event_id := l_array_header_events(l_array_header_events.LAST);
65725:
65726: fnd_file.put_line(fnd_file.LOG, ' ');
65727: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
65728: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );
65729: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');
65730:
65731: FOR line_record IN line_cur(l_first_event_id, l_last_event_id)
65724: l_last_event_id := l_array_header_events(l_array_header_events.LAST);
65725:
65726: fnd_file.put_line(fnd_file.LOG, ' ');
65727: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
65728: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );
65729: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');
65730:
65731: FOR line_record IN line_cur(l_first_event_id, l_last_event_id)
65732: LOOP
65725:
65726: fnd_file.put_line(fnd_file.LOG, ' ');
65727: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
65728: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );
65729: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');
65730:
65731: FOR line_record IN line_cur(l_first_event_id, l_last_event_id)
65732: LOOP
65733: IF (NOT l_array_header_events.EXISTS(line_record.event_id)) AND (NOT l_array_duplicate_checker.EXISTS(line_record.event_id)) THEN
65730:
65731: FOR line_record IN line_cur(l_first_event_id, l_last_event_id)
65732: LOOP
65733: IF (NOT l_array_header_events.EXISTS(line_record.event_id)) AND (NOT l_array_duplicate_checker.EXISTS(line_record.event_id)) THEN
65734: fnd_file.put_line(fnd_file.log, 'Event_id = ' || line_record.event_id);
65735: l_array_duplicate_checker(line_record.event_id) := line_record.event_id;
65736: END IF;
65737: END LOOP;
65738:
65735: l_array_duplicate_checker(line_record.event_id) := line_record.event_id;
65736: END IF;
65737: END LOOP;
65738:
65739: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
65740: fnd_file.put_line(fnd_file.LOG, ' ');
65741:
65742:
65743: xla_exceptions_pkg.raise_message
65736: END IF;
65737: END LOOP;
65738:
65739: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
65740: fnd_file.put_line(fnd_file.LOG, ' ');
65741:
65742:
65743: xla_exceptions_pkg.raise_message
65744: (p_location => 'XLA_00222_AAD_S_000017_PKG.EventClass_127');
66968:
66969: l_first_event_id := l_array_header_events(l_array_header_events.FIRST);
66970: l_last_event_id := l_array_header_events(l_array_header_events.LAST);
66971:
66972: fnd_file.put_line(fnd_file.LOG, ' ');
66973: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
66974: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );
66975: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');
66976:
66969: l_first_event_id := l_array_header_events(l_array_header_events.FIRST);
66970: l_last_event_id := l_array_header_events(l_array_header_events.LAST);
66971:
66972: fnd_file.put_line(fnd_file.LOG, ' ');
66973: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
66974: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );
66975: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');
66976:
66977: FOR line_record IN line_cur(l_first_event_id, l_last_event_id)
66970: l_last_event_id := l_array_header_events(l_array_header_events.LAST);
66971:
66972: fnd_file.put_line(fnd_file.LOG, ' ');
66973: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
66974: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );
66975: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');
66976:
66977: FOR line_record IN line_cur(l_first_event_id, l_last_event_id)
66978: LOOP
66971:
66972: fnd_file.put_line(fnd_file.LOG, ' ');
66973: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
66974: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );
66975: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');
66976:
66977: FOR line_record IN line_cur(l_first_event_id, l_last_event_id)
66978: LOOP
66979: IF (NOT l_array_header_events.EXISTS(line_record.event_id)) AND (NOT l_array_duplicate_checker.EXISTS(line_record.event_id)) THEN
66976:
66977: FOR line_record IN line_cur(l_first_event_id, l_last_event_id)
66978: LOOP
66979: IF (NOT l_array_header_events.EXISTS(line_record.event_id)) AND (NOT l_array_duplicate_checker.EXISTS(line_record.event_id)) THEN
66980: fnd_file.put_line(fnd_file.log, 'Event_id = ' || line_record.event_id);
66981: l_array_duplicate_checker(line_record.event_id) := line_record.event_id;
66982: END IF;
66983: END LOOP;
66984:
66981: l_array_duplicate_checker(line_record.event_id) := line_record.event_id;
66982: END IF;
66983: END LOOP;
66984:
66985: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
66986: fnd_file.put_line(fnd_file.LOG, ' ');
66987:
66988:
66989: xla_exceptions_pkg.raise_message
66982: END IF;
66983: END LOOP;
66984:
66985: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
66986: fnd_file.put_line(fnd_file.LOG, ' ');
66987:
66988:
66989: xla_exceptions_pkg.raise_message
66990: (p_location => 'XLA_00222_AAD_S_000017_PKG.EventClass_128');
68653:
68654: l_first_event_id := l_array_header_events(l_array_header_events.FIRST);
68655: l_last_event_id := l_array_header_events(l_array_header_events.LAST);
68656:
68657: fnd_file.put_line(fnd_file.LOG, ' ');
68658: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
68659: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );
68660: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');
68661:
68654: l_first_event_id := l_array_header_events(l_array_header_events.FIRST);
68655: l_last_event_id := l_array_header_events(l_array_header_events.LAST);
68656:
68657: fnd_file.put_line(fnd_file.LOG, ' ');
68658: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
68659: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );
68660: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');
68661:
68662: FOR line_record IN line_cur(l_first_event_id, l_last_event_id)
68655: l_last_event_id := l_array_header_events(l_array_header_events.LAST);
68656:
68657: fnd_file.put_line(fnd_file.LOG, ' ');
68658: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
68659: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );
68660: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');
68661:
68662: FOR line_record IN line_cur(l_first_event_id, l_last_event_id)
68663: LOOP
68656:
68657: fnd_file.put_line(fnd_file.LOG, ' ');
68658: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
68659: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );
68660: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');
68661:
68662: FOR line_record IN line_cur(l_first_event_id, l_last_event_id)
68663: LOOP
68664: IF (NOT l_array_header_events.EXISTS(line_record.event_id)) AND (NOT l_array_duplicate_checker.EXISTS(line_record.event_id)) THEN
68661:
68662: FOR line_record IN line_cur(l_first_event_id, l_last_event_id)
68663: LOOP
68664: IF (NOT l_array_header_events.EXISTS(line_record.event_id)) AND (NOT l_array_duplicate_checker.EXISTS(line_record.event_id)) THEN
68665: fnd_file.put_line(fnd_file.log, 'Event_id = ' || line_record.event_id);
68666: l_array_duplicate_checker(line_record.event_id) := line_record.event_id;
68667: END IF;
68668: END LOOP;
68669:
68666: l_array_duplicate_checker(line_record.event_id) := line_record.event_id;
68667: END IF;
68668: END LOOP;
68669:
68670: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
68671: fnd_file.put_line(fnd_file.LOG, ' ');
68672:
68673:
68674: xla_exceptions_pkg.raise_message
68667: END IF;
68668: END LOOP;
68669:
68670: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
68671: fnd_file.put_line(fnd_file.LOG, ' ');
68672:
68673:
68674: xla_exceptions_pkg.raise_message
68675: (p_location => 'XLA_00222_AAD_S_000017_PKG.EventClass_129');
70369:
70370: l_first_event_id := l_array_header_events(l_array_header_events.FIRST);
70371: l_last_event_id := l_array_header_events(l_array_header_events.LAST);
70372:
70373: fnd_file.put_line(fnd_file.LOG, ' ');
70374: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
70375: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );
70376: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');
70377:
70370: l_first_event_id := l_array_header_events(l_array_header_events.FIRST);
70371: l_last_event_id := l_array_header_events(l_array_header_events.LAST);
70372:
70373: fnd_file.put_line(fnd_file.LOG, ' ');
70374: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
70375: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );
70376: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');
70377:
70378: FOR line_record IN line_cur(l_first_event_id, l_last_event_id)
70371: l_last_event_id := l_array_header_events(l_array_header_events.LAST);
70372:
70373: fnd_file.put_line(fnd_file.LOG, ' ');
70374: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
70375: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );
70376: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');
70377:
70378: FOR line_record IN line_cur(l_first_event_id, l_last_event_id)
70379: LOOP
70372:
70373: fnd_file.put_line(fnd_file.LOG, ' ');
70374: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
70375: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );
70376: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');
70377:
70378: FOR line_record IN line_cur(l_first_event_id, l_last_event_id)
70379: LOOP
70380: IF (NOT l_array_header_events.EXISTS(line_record.event_id)) AND (NOT l_array_duplicate_checker.EXISTS(line_record.event_id)) THEN
70377:
70378: FOR line_record IN line_cur(l_first_event_id, l_last_event_id)
70379: LOOP
70380: IF (NOT l_array_header_events.EXISTS(line_record.event_id)) AND (NOT l_array_duplicate_checker.EXISTS(line_record.event_id)) THEN
70381: fnd_file.put_line(fnd_file.log, 'Event_id = ' || line_record.event_id);
70382: l_array_duplicate_checker(line_record.event_id) := line_record.event_id;
70383: END IF;
70384: END LOOP;
70385:
70382: l_array_duplicate_checker(line_record.event_id) := line_record.event_id;
70383: END IF;
70384: END LOOP;
70385:
70386: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
70387: fnd_file.put_line(fnd_file.LOG, ' ');
70388:
70389:
70390: xla_exceptions_pkg.raise_message
70383: END IF;
70384: END LOOP;
70385:
70386: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
70387: fnd_file.put_line(fnd_file.LOG, ' ');
70388:
70389:
70390: xla_exceptions_pkg.raise_message
70391: (p_location => 'XLA_00222_AAD_S_000017_PKG.EventClass_130');
71829:
71830: l_first_event_id := l_array_header_events(l_array_header_events.FIRST);
71831: l_last_event_id := l_array_header_events(l_array_header_events.LAST);
71832:
71833: fnd_file.put_line(fnd_file.LOG, ' ');
71834: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
71835: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );
71836: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');
71837:
71830: l_first_event_id := l_array_header_events(l_array_header_events.FIRST);
71831: l_last_event_id := l_array_header_events(l_array_header_events.LAST);
71832:
71833: fnd_file.put_line(fnd_file.LOG, ' ');
71834: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
71835: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );
71836: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');
71837:
71838: FOR line_record IN line_cur(l_first_event_id, l_last_event_id)
71831: l_last_event_id := l_array_header_events(l_array_header_events.LAST);
71832:
71833: fnd_file.put_line(fnd_file.LOG, ' ');
71834: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
71835: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );
71836: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');
71837:
71838: FOR line_record IN line_cur(l_first_event_id, l_last_event_id)
71839: LOOP
71832:
71833: fnd_file.put_line(fnd_file.LOG, ' ');
71834: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
71835: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );
71836: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');
71837:
71838: FOR line_record IN line_cur(l_first_event_id, l_last_event_id)
71839: LOOP
71840: IF (NOT l_array_header_events.EXISTS(line_record.event_id)) AND (NOT l_array_duplicate_checker.EXISTS(line_record.event_id)) THEN
71837:
71838: FOR line_record IN line_cur(l_first_event_id, l_last_event_id)
71839: LOOP
71840: IF (NOT l_array_header_events.EXISTS(line_record.event_id)) AND (NOT l_array_duplicate_checker.EXISTS(line_record.event_id)) THEN
71841: fnd_file.put_line(fnd_file.log, 'Event_id = ' || line_record.event_id);
71842: l_array_duplicate_checker(line_record.event_id) := line_record.event_id;
71843: END IF;
71844: END LOOP;
71845:
71842: l_array_duplicate_checker(line_record.event_id) := line_record.event_id;
71843: END IF;
71844: END LOOP;
71845:
71846: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
71847: fnd_file.put_line(fnd_file.LOG, ' ');
71848:
71849:
71850: xla_exceptions_pkg.raise_message
71843: END IF;
71844: END LOOP;
71845:
71846: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
71847: fnd_file.put_line(fnd_file.LOG, ' ');
71848:
71849:
71850: xla_exceptions_pkg.raise_message
71851: (p_location => 'XLA_00222_AAD_S_000017_PKG.EventClass_131');
73075:
73076: l_first_event_id := l_array_header_events(l_array_header_events.FIRST);
73077: l_last_event_id := l_array_header_events(l_array_header_events.LAST);
73078:
73079: fnd_file.put_line(fnd_file.LOG, ' ');
73080: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
73081: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );
73082: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');
73083:
73076: l_first_event_id := l_array_header_events(l_array_header_events.FIRST);
73077: l_last_event_id := l_array_header_events(l_array_header_events.LAST);
73078:
73079: fnd_file.put_line(fnd_file.LOG, ' ');
73080: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
73081: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );
73082: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');
73083:
73084: FOR line_record IN line_cur(l_first_event_id, l_last_event_id)
73077: l_last_event_id := l_array_header_events(l_array_header_events.LAST);
73078:
73079: fnd_file.put_line(fnd_file.LOG, ' ');
73080: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
73081: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );
73082: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');
73083:
73084: FOR line_record IN line_cur(l_first_event_id, l_last_event_id)
73085: LOOP
73078:
73079: fnd_file.put_line(fnd_file.LOG, ' ');
73080: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
73081: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );
73082: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');
73083:
73084: FOR line_record IN line_cur(l_first_event_id, l_last_event_id)
73085: LOOP
73086: IF (NOT l_array_header_events.EXISTS(line_record.event_id)) AND (NOT l_array_duplicate_checker.EXISTS(line_record.event_id)) THEN
73083:
73084: FOR line_record IN line_cur(l_first_event_id, l_last_event_id)
73085: LOOP
73086: IF (NOT l_array_header_events.EXISTS(line_record.event_id)) AND (NOT l_array_duplicate_checker.EXISTS(line_record.event_id)) THEN
73087: fnd_file.put_line(fnd_file.log, 'Event_id = ' || line_record.event_id);
73088: l_array_duplicate_checker(line_record.event_id) := line_record.event_id;
73089: END IF;
73090: END LOOP;
73091:
73088: l_array_duplicate_checker(line_record.event_id) := line_record.event_id;
73089: END IF;
73090: END LOOP;
73091:
73092: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
73093: fnd_file.put_line(fnd_file.LOG, ' ');
73094:
73095:
73096: xla_exceptions_pkg.raise_message
73089: END IF;
73090: END LOOP;
73091:
73092: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
73093: fnd_file.put_line(fnd_file.LOG, ' ');
73094:
73095:
73096: xla_exceptions_pkg.raise_message
73097: (p_location => 'XLA_00222_AAD_S_000017_PKG.EventClass_132');
74815:
74816: l_first_event_id := l_array_header_events(l_array_header_events.FIRST);
74817: l_last_event_id := l_array_header_events(l_array_header_events.LAST);
74818:
74819: fnd_file.put_line(fnd_file.LOG, ' ');
74820: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
74821: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );
74822: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');
74823:
74816: l_first_event_id := l_array_header_events(l_array_header_events.FIRST);
74817: l_last_event_id := l_array_header_events(l_array_header_events.LAST);
74818:
74819: fnd_file.put_line(fnd_file.LOG, ' ');
74820: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
74821: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );
74822: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');
74823:
74824: FOR line_record IN line_cur(l_first_event_id, l_last_event_id)
74817: l_last_event_id := l_array_header_events(l_array_header_events.LAST);
74818:
74819: fnd_file.put_line(fnd_file.LOG, ' ');
74820: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
74821: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );
74822: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');
74823:
74824: FOR line_record IN line_cur(l_first_event_id, l_last_event_id)
74825: LOOP
74818:
74819: fnd_file.put_line(fnd_file.LOG, ' ');
74820: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
74821: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );
74822: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');
74823:
74824: FOR line_record IN line_cur(l_first_event_id, l_last_event_id)
74825: LOOP
74826: IF (NOT l_array_header_events.EXISTS(line_record.event_id)) AND (NOT l_array_duplicate_checker.EXISTS(line_record.event_id)) THEN
74823:
74824: FOR line_record IN line_cur(l_first_event_id, l_last_event_id)
74825: LOOP
74826: IF (NOT l_array_header_events.EXISTS(line_record.event_id)) AND (NOT l_array_duplicate_checker.EXISTS(line_record.event_id)) THEN
74827: fnd_file.put_line(fnd_file.log, 'Event_id = ' || line_record.event_id);
74828: l_array_duplicate_checker(line_record.event_id) := line_record.event_id;
74829: END IF;
74830: END LOOP;
74831:
74828: l_array_duplicate_checker(line_record.event_id) := line_record.event_id;
74829: END IF;
74830: END LOOP;
74831:
74832: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
74833: fnd_file.put_line(fnd_file.LOG, ' ');
74834:
74835:
74836: xla_exceptions_pkg.raise_message
74829: END IF;
74830: END LOOP;
74831:
74832: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
74833: fnd_file.put_line(fnd_file.LOG, ' ');
74834:
74835:
74836: xla_exceptions_pkg.raise_message
74837: (p_location => 'XLA_00222_AAD_S_000017_PKG.EventClass_133');
76061:
76062: l_first_event_id := l_array_header_events(l_array_header_events.FIRST);
76063: l_last_event_id := l_array_header_events(l_array_header_events.LAST);
76064:
76065: fnd_file.put_line(fnd_file.LOG, ' ');
76066: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
76067: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );
76068: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');
76069:
76062: l_first_event_id := l_array_header_events(l_array_header_events.FIRST);
76063: l_last_event_id := l_array_header_events(l_array_header_events.LAST);
76064:
76065: fnd_file.put_line(fnd_file.LOG, ' ');
76066: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
76067: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );
76068: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');
76069:
76070: FOR line_record IN line_cur(l_first_event_id, l_last_event_id)
76063: l_last_event_id := l_array_header_events(l_array_header_events.LAST);
76064:
76065: fnd_file.put_line(fnd_file.LOG, ' ');
76066: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
76067: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );
76068: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');
76069:
76070: FOR line_record IN line_cur(l_first_event_id, l_last_event_id)
76071: LOOP
76064:
76065: fnd_file.put_line(fnd_file.LOG, ' ');
76066: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
76067: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );
76068: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');
76069:
76070: FOR line_record IN line_cur(l_first_event_id, l_last_event_id)
76071: LOOP
76072: IF (NOT l_array_header_events.EXISTS(line_record.event_id)) AND (NOT l_array_duplicate_checker.EXISTS(line_record.event_id)) THEN
76069:
76070: FOR line_record IN line_cur(l_first_event_id, l_last_event_id)
76071: LOOP
76072: IF (NOT l_array_header_events.EXISTS(line_record.event_id)) AND (NOT l_array_duplicate_checker.EXISTS(line_record.event_id)) THEN
76073: fnd_file.put_line(fnd_file.log, 'Event_id = ' || line_record.event_id);
76074: l_array_duplicate_checker(line_record.event_id) := line_record.event_id;
76075: END IF;
76076: END LOOP;
76077:
76074: l_array_duplicate_checker(line_record.event_id) := line_record.event_id;
76075: END IF;
76076: END LOOP;
76077:
76078: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
76079: fnd_file.put_line(fnd_file.LOG, ' ');
76080:
76081:
76082: xla_exceptions_pkg.raise_message
76075: END IF;
76076: END LOOP;
76077:
76078: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
76079: fnd_file.put_line(fnd_file.LOG, ' ');
76080:
76081:
76082: xla_exceptions_pkg.raise_message
76083: (p_location => 'XLA_00222_AAD_S_000017_PKG.EventClass_134');
77631:
77632: l_first_event_id := l_array_header_events(l_array_header_events.FIRST);
77633: l_last_event_id := l_array_header_events(l_array_header_events.LAST);
77634:
77635: fnd_file.put_line(fnd_file.LOG, ' ');
77636: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
77637: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );
77638: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');
77639:
77632: l_first_event_id := l_array_header_events(l_array_header_events.FIRST);
77633: l_last_event_id := l_array_header_events(l_array_header_events.LAST);
77634:
77635: fnd_file.put_line(fnd_file.LOG, ' ');
77636: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
77637: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );
77638: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');
77639:
77640: FOR line_record IN line_cur(l_first_event_id, l_last_event_id)
77633: l_last_event_id := l_array_header_events(l_array_header_events.LAST);
77634:
77635: fnd_file.put_line(fnd_file.LOG, ' ');
77636: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
77637: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );
77638: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');
77639:
77640: FOR line_record IN line_cur(l_first_event_id, l_last_event_id)
77641: LOOP
77634:
77635: fnd_file.put_line(fnd_file.LOG, ' ');
77636: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
77637: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );
77638: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');
77639:
77640: FOR line_record IN line_cur(l_first_event_id, l_last_event_id)
77641: LOOP
77642: IF (NOT l_array_header_events.EXISTS(line_record.event_id)) AND (NOT l_array_duplicate_checker.EXISTS(line_record.event_id)) THEN
77639:
77640: FOR line_record IN line_cur(l_first_event_id, l_last_event_id)
77641: LOOP
77642: IF (NOT l_array_header_events.EXISTS(line_record.event_id)) AND (NOT l_array_duplicate_checker.EXISTS(line_record.event_id)) THEN
77643: fnd_file.put_line(fnd_file.log, 'Event_id = ' || line_record.event_id);
77644: l_array_duplicate_checker(line_record.event_id) := line_record.event_id;
77645: END IF;
77646: END LOOP;
77647:
77644: l_array_duplicate_checker(line_record.event_id) := line_record.event_id;
77645: END IF;
77646: END LOOP;
77647:
77648: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
77649: fnd_file.put_line(fnd_file.LOG, ' ');
77650:
77651:
77652: xla_exceptions_pkg.raise_message
77645: END IF;
77646: END LOOP;
77647:
77648: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
77649: fnd_file.put_line(fnd_file.LOG, ' ');
77650:
77651:
77652: xla_exceptions_pkg.raise_message
77653: (p_location => 'XLA_00222_AAD_S_000017_PKG.EventClass_135');
79134:
79135: l_first_event_id := l_array_header_events(l_array_header_events.FIRST);
79136: l_last_event_id := l_array_header_events(l_array_header_events.LAST);
79137:
79138: fnd_file.put_line(fnd_file.LOG, ' ');
79139: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
79140: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );
79141: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');
79142:
79135: l_first_event_id := l_array_header_events(l_array_header_events.FIRST);
79136: l_last_event_id := l_array_header_events(l_array_header_events.LAST);
79137:
79138: fnd_file.put_line(fnd_file.LOG, ' ');
79139: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
79140: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );
79141: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');
79142:
79143: FOR line_record IN line_cur(l_first_event_id, l_last_event_id)
79136: l_last_event_id := l_array_header_events(l_array_header_events.LAST);
79137:
79138: fnd_file.put_line(fnd_file.LOG, ' ');
79139: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
79140: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );
79141: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');
79142:
79143: FOR line_record IN line_cur(l_first_event_id, l_last_event_id)
79144: LOOP
79137:
79138: fnd_file.put_line(fnd_file.LOG, ' ');
79139: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
79140: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );
79141: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');
79142:
79143: FOR line_record IN line_cur(l_first_event_id, l_last_event_id)
79144: LOOP
79145: IF (NOT l_array_header_events.EXISTS(line_record.event_id)) AND (NOT l_array_duplicate_checker.EXISTS(line_record.event_id)) THEN
79142:
79143: FOR line_record IN line_cur(l_first_event_id, l_last_event_id)
79144: LOOP
79145: IF (NOT l_array_header_events.EXISTS(line_record.event_id)) AND (NOT l_array_duplicate_checker.EXISTS(line_record.event_id)) THEN
79146: fnd_file.put_line(fnd_file.log, 'Event_id = ' || line_record.event_id);
79147: l_array_duplicate_checker(line_record.event_id) := line_record.event_id;
79148: END IF;
79149: END LOOP;
79150:
79147: l_array_duplicate_checker(line_record.event_id) := line_record.event_id;
79148: END IF;
79149: END LOOP;
79150:
79151: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
79152: fnd_file.put_line(fnd_file.LOG, ' ');
79153:
79154:
79155: xla_exceptions_pkg.raise_message
79148: END IF;
79149: END LOOP;
79150:
79151: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
79152: fnd_file.put_line(fnd_file.LOG, ' ');
79153:
79154:
79155: xla_exceptions_pkg.raise_message
79156: (p_location => 'XLA_00222_AAD_S_000017_PKG.EventClass_136');
81723:
81724: l_first_event_id := l_array_header_events(l_array_header_events.FIRST);
81725: l_last_event_id := l_array_header_events(l_array_header_events.LAST);
81726:
81727: fnd_file.put_line(fnd_file.LOG, ' ');
81728: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
81729: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );
81730: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');
81731:
81724: l_first_event_id := l_array_header_events(l_array_header_events.FIRST);
81725: l_last_event_id := l_array_header_events(l_array_header_events.LAST);
81726:
81727: fnd_file.put_line(fnd_file.LOG, ' ');
81728: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
81729: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );
81730: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');
81731:
81732: FOR line_record IN line_cur(l_first_event_id, l_last_event_id)
81725: l_last_event_id := l_array_header_events(l_array_header_events.LAST);
81726:
81727: fnd_file.put_line(fnd_file.LOG, ' ');
81728: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
81729: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );
81730: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');
81731:
81732: FOR line_record IN line_cur(l_first_event_id, l_last_event_id)
81733: LOOP
81726:
81727: fnd_file.put_line(fnd_file.LOG, ' ');
81728: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
81729: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );
81730: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');
81731:
81732: FOR line_record IN line_cur(l_first_event_id, l_last_event_id)
81733: LOOP
81734: IF (NOT l_array_header_events.EXISTS(line_record.event_id)) AND (NOT l_array_duplicate_checker.EXISTS(line_record.event_id)) THEN
81731:
81732: FOR line_record IN line_cur(l_first_event_id, l_last_event_id)
81733: LOOP
81734: IF (NOT l_array_header_events.EXISTS(line_record.event_id)) AND (NOT l_array_duplicate_checker.EXISTS(line_record.event_id)) THEN
81735: fnd_file.put_line(fnd_file.log, 'Event_id = ' || line_record.event_id);
81736: l_array_duplicate_checker(line_record.event_id) := line_record.event_id;
81737: END IF;
81738: END LOOP;
81739:
81736: l_array_duplicate_checker(line_record.event_id) := line_record.event_id;
81737: END IF;
81738: END LOOP;
81739:
81740: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
81741: fnd_file.put_line(fnd_file.LOG, ' ');
81742:
81743:
81744: xla_exceptions_pkg.raise_message
81737: END IF;
81738: END LOOP;
81739:
81740: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
81741: fnd_file.put_line(fnd_file.LOG, ' ');
81742:
81743:
81744: xla_exceptions_pkg.raise_message
81745: (p_location => 'XLA_00222_AAD_S_000017_PKG.EventClass_137');