eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.XLA_00555_AAD_S_000001_PKG dependencies on FND_FILE

Line 120616: fnd_file.put_line(fnd_file.LOG, ' ');

120612:
120613: l_first_event_id := l_array_header_events(l_array_header_events.FIRST);
120614: l_last_event_id := l_array_header_events(l_array_header_events.LAST);
120615:
120616: fnd_file.put_line(fnd_file.LOG, ' ');
120617: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
120618: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );
120619: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');
120620:

Line 120617: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');

120613: l_first_event_id := l_array_header_events(l_array_header_events.FIRST);
120614: l_last_event_id := l_array_header_events(l_array_header_events.LAST);
120615:
120616: fnd_file.put_line(fnd_file.LOG, ' ');
120617: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
120618: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );
120619: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');
120620:
120621: FOR line_record IN line_cur(l_first_event_id, l_last_event_id)

Line 120618: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );

120614: l_last_event_id := l_array_header_events(l_array_header_events.LAST);
120615:
120616: fnd_file.put_line(fnd_file.LOG, ' ');
120617: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
120618: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );
120619: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');
120620:
120621: FOR line_record IN line_cur(l_first_event_id, l_last_event_id)
120622: LOOP

Line 120619: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');

120615:
120616: fnd_file.put_line(fnd_file.LOG, ' ');
120617: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
120618: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );
120619: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');
120620:
120621: FOR line_record IN line_cur(l_first_event_id, l_last_event_id)
120622: LOOP
120623: IF (NOT l_array_header_events.EXISTS(line_record.event_id)) AND (NOT l_array_duplicate_checker.EXISTS(line_record.event_id)) THEN

Line 120624: fnd_file.put_line(fnd_file.log, 'Event_id = ' || line_record.event_id);

120620:
120621: FOR line_record IN line_cur(l_first_event_id, l_last_event_id)
120622: LOOP
120623: IF (NOT l_array_header_events.EXISTS(line_record.event_id)) AND (NOT l_array_duplicate_checker.EXISTS(line_record.event_id)) THEN
120624: fnd_file.put_line(fnd_file.log, 'Event_id = ' || line_record.event_id);
120625: l_array_duplicate_checker(line_record.event_id) := line_record.event_id;
120626: END IF;
120627: END LOOP;
120628:

Line 120629: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');

120625: l_array_duplicate_checker(line_record.event_id) := line_record.event_id;
120626: END IF;
120627: END LOOP;
120628:
120629: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
120630: fnd_file.put_line(fnd_file.LOG, ' ');
120631:
120632:
120633: xla_exceptions_pkg.raise_message

Line 120630: fnd_file.put_line(fnd_file.LOG, ' ');

120626: END IF;
120627: END LOOP;
120628:
120629: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
120630: fnd_file.put_line(fnd_file.LOG, ' ');
120631:
120632:
120633: xla_exceptions_pkg.raise_message
120634: (p_location => 'XLA_00555_AAD_S_000001_PKG.EventType_248');

Line 121794: fnd_file.put_line(fnd_file.LOG, ' ');

121790:
121791: l_first_event_id := l_array_header_events(l_array_header_events.FIRST);
121792: l_last_event_id := l_array_header_events(l_array_header_events.LAST);
121793:
121794: fnd_file.put_line(fnd_file.LOG, ' ');
121795: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
121796: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );
121797: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');
121798:

Line 121795: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');

121791: l_first_event_id := l_array_header_events(l_array_header_events.FIRST);
121792: l_last_event_id := l_array_header_events(l_array_header_events.LAST);
121793:
121794: fnd_file.put_line(fnd_file.LOG, ' ');
121795: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
121796: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );
121797: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');
121798:
121799: FOR line_record IN line_cur(l_first_event_id, l_last_event_id)

Line 121796: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );

121792: l_last_event_id := l_array_header_events(l_array_header_events.LAST);
121793:
121794: fnd_file.put_line(fnd_file.LOG, ' ');
121795: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
121796: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );
121797: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');
121798:
121799: FOR line_record IN line_cur(l_first_event_id, l_last_event_id)
121800: LOOP

Line 121797: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');

121793:
121794: fnd_file.put_line(fnd_file.LOG, ' ');
121795: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
121796: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );
121797: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');
121798:
121799: FOR line_record IN line_cur(l_first_event_id, l_last_event_id)
121800: LOOP
121801: IF (NOT l_array_header_events.EXISTS(line_record.event_id)) AND (NOT l_array_duplicate_checker.EXISTS(line_record.event_id)) THEN

Line 121802: fnd_file.put_line(fnd_file.log, 'Event_id = ' || line_record.event_id);

121798:
121799: FOR line_record IN line_cur(l_first_event_id, l_last_event_id)
121800: LOOP
121801: IF (NOT l_array_header_events.EXISTS(line_record.event_id)) AND (NOT l_array_duplicate_checker.EXISTS(line_record.event_id)) THEN
121802: fnd_file.put_line(fnd_file.log, 'Event_id = ' || line_record.event_id);
121803: l_array_duplicate_checker(line_record.event_id) := line_record.event_id;
121804: END IF;
121805: END LOOP;
121806:

Line 121807: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');

121803: l_array_duplicate_checker(line_record.event_id) := line_record.event_id;
121804: END IF;
121805: END LOOP;
121806:
121807: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
121808: fnd_file.put_line(fnd_file.LOG, ' ');
121809:
121810:
121811: xla_exceptions_pkg.raise_message

Line 121808: fnd_file.put_line(fnd_file.LOG, ' ');

121804: END IF;
121805: END LOOP;
121806:
121807: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
121808: fnd_file.put_line(fnd_file.LOG, ' ');
121809:
121810:
121811: xla_exceptions_pkg.raise_message
121812: (p_location => 'XLA_00555_AAD_S_000001_PKG.EventType_249');

Line 123000: fnd_file.put_line(fnd_file.LOG, ' ');

122996:
122997: l_first_event_id := l_array_header_events(l_array_header_events.FIRST);
122998: l_last_event_id := l_array_header_events(l_array_header_events.LAST);
122999:
123000: fnd_file.put_line(fnd_file.LOG, ' ');
123001: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
123002: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );
123003: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');
123004:

Line 123001: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');

122997: l_first_event_id := l_array_header_events(l_array_header_events.FIRST);
122998: l_last_event_id := l_array_header_events(l_array_header_events.LAST);
122999:
123000: fnd_file.put_line(fnd_file.LOG, ' ');
123001: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
123002: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );
123003: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');
123004:
123005: FOR line_record IN line_cur(l_first_event_id, l_last_event_id)

Line 123002: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );

122998: l_last_event_id := l_array_header_events(l_array_header_events.LAST);
122999:
123000: fnd_file.put_line(fnd_file.LOG, ' ');
123001: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
123002: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );
123003: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');
123004:
123005: FOR line_record IN line_cur(l_first_event_id, l_last_event_id)
123006: LOOP

Line 123003: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');

122999:
123000: fnd_file.put_line(fnd_file.LOG, ' ');
123001: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
123002: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );
123003: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');
123004:
123005: FOR line_record IN line_cur(l_first_event_id, l_last_event_id)
123006: LOOP
123007: IF (NOT l_array_header_events.EXISTS(line_record.event_id)) AND (NOT l_array_duplicate_checker.EXISTS(line_record.event_id)) THEN

Line 123008: fnd_file.put_line(fnd_file.log, 'Event_id = ' || line_record.event_id);

123004:
123005: FOR line_record IN line_cur(l_first_event_id, l_last_event_id)
123006: LOOP
123007: IF (NOT l_array_header_events.EXISTS(line_record.event_id)) AND (NOT l_array_duplicate_checker.EXISTS(line_record.event_id)) THEN
123008: fnd_file.put_line(fnd_file.log, 'Event_id = ' || line_record.event_id);
123009: l_array_duplicate_checker(line_record.event_id) := line_record.event_id;
123010: END IF;
123011: END LOOP;
123012:

Line 123013: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');

123009: l_array_duplicate_checker(line_record.event_id) := line_record.event_id;
123010: END IF;
123011: END LOOP;
123012:
123013: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
123014: fnd_file.put_line(fnd_file.LOG, ' ');
123015:
123016:
123017: xla_exceptions_pkg.raise_message

Line 123014: fnd_file.put_line(fnd_file.LOG, ' ');

123010: END IF;
123011: END LOOP;
123012:
123013: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
123014: fnd_file.put_line(fnd_file.LOG, ' ');
123015:
123016:
123017: xla_exceptions_pkg.raise_message
123018: (p_location => 'XLA_00555_AAD_S_000001_PKG.EventType_250');

Line 124262: fnd_file.put_line(fnd_file.LOG, ' ');

124258:
124259: l_first_event_id := l_array_header_events(l_array_header_events.FIRST);
124260: l_last_event_id := l_array_header_events(l_array_header_events.LAST);
124261:
124262: fnd_file.put_line(fnd_file.LOG, ' ');
124263: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
124264: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );
124265: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');
124266:

Line 124263: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');

124259: l_first_event_id := l_array_header_events(l_array_header_events.FIRST);
124260: l_last_event_id := l_array_header_events(l_array_header_events.LAST);
124261:
124262: fnd_file.put_line(fnd_file.LOG, ' ');
124263: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
124264: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );
124265: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');
124266:
124267: FOR line_record IN line_cur(l_first_event_id, l_last_event_id)

Line 124264: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );

124260: l_last_event_id := l_array_header_events(l_array_header_events.LAST);
124261:
124262: fnd_file.put_line(fnd_file.LOG, ' ');
124263: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
124264: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );
124265: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');
124266:
124267: FOR line_record IN line_cur(l_first_event_id, l_last_event_id)
124268: LOOP

Line 124265: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');

124261:
124262: fnd_file.put_line(fnd_file.LOG, ' ');
124263: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
124264: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );
124265: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');
124266:
124267: FOR line_record IN line_cur(l_first_event_id, l_last_event_id)
124268: LOOP
124269: IF (NOT l_array_header_events.EXISTS(line_record.event_id)) AND (NOT l_array_duplicate_checker.EXISTS(line_record.event_id)) THEN

Line 124270: fnd_file.put_line(fnd_file.log, 'Event_id = ' || line_record.event_id);

124266:
124267: FOR line_record IN line_cur(l_first_event_id, l_last_event_id)
124268: LOOP
124269: IF (NOT l_array_header_events.EXISTS(line_record.event_id)) AND (NOT l_array_duplicate_checker.EXISTS(line_record.event_id)) THEN
124270: fnd_file.put_line(fnd_file.log, 'Event_id = ' || line_record.event_id);
124271: l_array_duplicate_checker(line_record.event_id) := line_record.event_id;
124272: END IF;
124273: END LOOP;
124274:

Line 124275: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');

124271: l_array_duplicate_checker(line_record.event_id) := line_record.event_id;
124272: END IF;
124273: END LOOP;
124274:
124275: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
124276: fnd_file.put_line(fnd_file.LOG, ' ');
124277:
124278:
124279: xla_exceptions_pkg.raise_message

Line 124276: fnd_file.put_line(fnd_file.LOG, ' ');

124272: END IF;
124273: END LOOP;
124274:
124275: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
124276: fnd_file.put_line(fnd_file.LOG, ' ');
124277:
124278:
124279: xla_exceptions_pkg.raise_message
124280: (p_location => 'XLA_00555_AAD_S_000001_PKG.EventType_251');

Line 125664: fnd_file.put_line(fnd_file.LOG, ' ');

125660:
125661: l_first_event_id := l_array_header_events(l_array_header_events.FIRST);
125662: l_last_event_id := l_array_header_events(l_array_header_events.LAST);
125663:
125664: fnd_file.put_line(fnd_file.LOG, ' ');
125665: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
125666: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );
125667: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');
125668:

Line 125665: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');

125661: l_first_event_id := l_array_header_events(l_array_header_events.FIRST);
125662: l_last_event_id := l_array_header_events(l_array_header_events.LAST);
125663:
125664: fnd_file.put_line(fnd_file.LOG, ' ');
125665: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
125666: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );
125667: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');
125668:
125669: FOR line_record IN line_cur(l_first_event_id, l_last_event_id)

Line 125666: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );

125662: l_last_event_id := l_array_header_events(l_array_header_events.LAST);
125663:
125664: fnd_file.put_line(fnd_file.LOG, ' ');
125665: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
125666: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );
125667: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');
125668:
125669: FOR line_record IN line_cur(l_first_event_id, l_last_event_id)
125670: LOOP

Line 125667: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');

125663:
125664: fnd_file.put_line(fnd_file.LOG, ' ');
125665: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
125666: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );
125667: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');
125668:
125669: FOR line_record IN line_cur(l_first_event_id, l_last_event_id)
125670: LOOP
125671: IF (NOT l_array_header_events.EXISTS(line_record.event_id)) AND (NOT l_array_duplicate_checker.EXISTS(line_record.event_id)) THEN

Line 125672: fnd_file.put_line(fnd_file.log, 'Event_id = ' || line_record.event_id);

125668:
125669: FOR line_record IN line_cur(l_first_event_id, l_last_event_id)
125670: LOOP
125671: IF (NOT l_array_header_events.EXISTS(line_record.event_id)) AND (NOT l_array_duplicate_checker.EXISTS(line_record.event_id)) THEN
125672: fnd_file.put_line(fnd_file.log, 'Event_id = ' || line_record.event_id);
125673: l_array_duplicate_checker(line_record.event_id) := line_record.event_id;
125674: END IF;
125675: END LOOP;
125676:

Line 125677: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');

125673: l_array_duplicate_checker(line_record.event_id) := line_record.event_id;
125674: END IF;
125675: END LOOP;
125676:
125677: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
125678: fnd_file.put_line(fnd_file.LOG, ' ');
125679:
125680:
125681: xla_exceptions_pkg.raise_message

Line 125678: fnd_file.put_line(fnd_file.LOG, ' ');

125674: END IF;
125675: END LOOP;
125676:
125677: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
125678: fnd_file.put_line(fnd_file.LOG, ' ');
125679:
125680:
125681: xla_exceptions_pkg.raise_message
125682: (p_location => 'XLA_00555_AAD_S_000001_PKG.EventType_252');

Line 126842: fnd_file.put_line(fnd_file.LOG, ' ');

126838:
126839: l_first_event_id := l_array_header_events(l_array_header_events.FIRST);
126840: l_last_event_id := l_array_header_events(l_array_header_events.LAST);
126841:
126842: fnd_file.put_line(fnd_file.LOG, ' ');
126843: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
126844: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );
126845: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');
126846:

Line 126843: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');

126839: l_first_event_id := l_array_header_events(l_array_header_events.FIRST);
126840: l_last_event_id := l_array_header_events(l_array_header_events.LAST);
126841:
126842: fnd_file.put_line(fnd_file.LOG, ' ');
126843: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
126844: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );
126845: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');
126846:
126847: FOR line_record IN line_cur(l_first_event_id, l_last_event_id)

Line 126844: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );

126840: l_last_event_id := l_array_header_events(l_array_header_events.LAST);
126841:
126842: fnd_file.put_line(fnd_file.LOG, ' ');
126843: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
126844: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );
126845: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');
126846:
126847: FOR line_record IN line_cur(l_first_event_id, l_last_event_id)
126848: LOOP

Line 126845: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');

126841:
126842: fnd_file.put_line(fnd_file.LOG, ' ');
126843: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
126844: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );
126845: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');
126846:
126847: FOR line_record IN line_cur(l_first_event_id, l_last_event_id)
126848: LOOP
126849: IF (NOT l_array_header_events.EXISTS(line_record.event_id)) AND (NOT l_array_duplicate_checker.EXISTS(line_record.event_id)) THEN

Line 126850: fnd_file.put_line(fnd_file.log, 'Event_id = ' || line_record.event_id);

126846:
126847: FOR line_record IN line_cur(l_first_event_id, l_last_event_id)
126848: LOOP
126849: IF (NOT l_array_header_events.EXISTS(line_record.event_id)) AND (NOT l_array_duplicate_checker.EXISTS(line_record.event_id)) THEN
126850: fnd_file.put_line(fnd_file.log, 'Event_id = ' || line_record.event_id);
126851: l_array_duplicate_checker(line_record.event_id) := line_record.event_id;
126852: END IF;
126853: END LOOP;
126854:

Line 126855: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');

126851: l_array_duplicate_checker(line_record.event_id) := line_record.event_id;
126852: END IF;
126853: END LOOP;
126854:
126855: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
126856: fnd_file.put_line(fnd_file.LOG, ' ');
126857:
126858:
126859: xla_exceptions_pkg.raise_message

Line 126856: fnd_file.put_line(fnd_file.LOG, ' ');

126852: END IF;
126853: END LOOP;
126854:
126855: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
126856: fnd_file.put_line(fnd_file.LOG, ' ');
126857:
126858:
126859: xla_exceptions_pkg.raise_message
126860: (p_location => 'XLA_00555_AAD_S_000001_PKG.EventType_253');

Line 128048: fnd_file.put_line(fnd_file.LOG, ' ');

128044:
128045: l_first_event_id := l_array_header_events(l_array_header_events.FIRST);
128046: l_last_event_id := l_array_header_events(l_array_header_events.LAST);
128047:
128048: fnd_file.put_line(fnd_file.LOG, ' ');
128049: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
128050: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );
128051: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');
128052:

Line 128049: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');

128045: l_first_event_id := l_array_header_events(l_array_header_events.FIRST);
128046: l_last_event_id := l_array_header_events(l_array_header_events.LAST);
128047:
128048: fnd_file.put_line(fnd_file.LOG, ' ');
128049: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
128050: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );
128051: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');
128052:
128053: FOR line_record IN line_cur(l_first_event_id, l_last_event_id)

Line 128050: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );

128046: l_last_event_id := l_array_header_events(l_array_header_events.LAST);
128047:
128048: fnd_file.put_line(fnd_file.LOG, ' ');
128049: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
128050: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );
128051: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');
128052:
128053: FOR line_record IN line_cur(l_first_event_id, l_last_event_id)
128054: LOOP

Line 128051: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');

128047:
128048: fnd_file.put_line(fnd_file.LOG, ' ');
128049: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
128050: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );
128051: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');
128052:
128053: FOR line_record IN line_cur(l_first_event_id, l_last_event_id)
128054: LOOP
128055: IF (NOT l_array_header_events.EXISTS(line_record.event_id)) AND (NOT l_array_duplicate_checker.EXISTS(line_record.event_id)) THEN

Line 128056: fnd_file.put_line(fnd_file.log, 'Event_id = ' || line_record.event_id);

128052:
128053: FOR line_record IN line_cur(l_first_event_id, l_last_event_id)
128054: LOOP
128055: IF (NOT l_array_header_events.EXISTS(line_record.event_id)) AND (NOT l_array_duplicate_checker.EXISTS(line_record.event_id)) THEN
128056: fnd_file.put_line(fnd_file.log, 'Event_id = ' || line_record.event_id);
128057: l_array_duplicate_checker(line_record.event_id) := line_record.event_id;
128058: END IF;
128059: END LOOP;
128060:

Line 128061: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');

128057: l_array_duplicate_checker(line_record.event_id) := line_record.event_id;
128058: END IF;
128059: END LOOP;
128060:
128061: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
128062: fnd_file.put_line(fnd_file.LOG, ' ');
128063:
128064:
128065: xla_exceptions_pkg.raise_message

Line 128062: fnd_file.put_line(fnd_file.LOG, ' ');

128058: END IF;
128059: END LOOP;
128060:
128061: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
128062: fnd_file.put_line(fnd_file.LOG, ' ');
128063:
128064:
128065: xla_exceptions_pkg.raise_message
128066: (p_location => 'XLA_00555_AAD_S_000001_PKG.EventType_254');

Line 129254: fnd_file.put_line(fnd_file.LOG, ' ');

129250:
129251: l_first_event_id := l_array_header_events(l_array_header_events.FIRST);
129252: l_last_event_id := l_array_header_events(l_array_header_events.LAST);
129253:
129254: fnd_file.put_line(fnd_file.LOG, ' ');
129255: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
129256: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );
129257: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');
129258:

Line 129255: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');

129251: l_first_event_id := l_array_header_events(l_array_header_events.FIRST);
129252: l_last_event_id := l_array_header_events(l_array_header_events.LAST);
129253:
129254: fnd_file.put_line(fnd_file.LOG, ' ');
129255: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
129256: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );
129257: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');
129258:
129259: FOR line_record IN line_cur(l_first_event_id, l_last_event_id)

Line 129256: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );

129252: l_last_event_id := l_array_header_events(l_array_header_events.LAST);
129253:
129254: fnd_file.put_line(fnd_file.LOG, ' ');
129255: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
129256: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );
129257: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');
129258:
129259: FOR line_record IN line_cur(l_first_event_id, l_last_event_id)
129260: LOOP

Line 129257: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');

129253:
129254: fnd_file.put_line(fnd_file.LOG, ' ');
129255: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
129256: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );
129257: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');
129258:
129259: FOR line_record IN line_cur(l_first_event_id, l_last_event_id)
129260: LOOP
129261: IF (NOT l_array_header_events.EXISTS(line_record.event_id)) AND (NOT l_array_duplicate_checker.EXISTS(line_record.event_id)) THEN

Line 129262: fnd_file.put_line(fnd_file.log, 'Event_id = ' || line_record.event_id);

129258:
129259: FOR line_record IN line_cur(l_first_event_id, l_last_event_id)
129260: LOOP
129261: IF (NOT l_array_header_events.EXISTS(line_record.event_id)) AND (NOT l_array_duplicate_checker.EXISTS(line_record.event_id)) THEN
129262: fnd_file.put_line(fnd_file.log, 'Event_id = ' || line_record.event_id);
129263: l_array_duplicate_checker(line_record.event_id) := line_record.event_id;
129264: END IF;
129265: END LOOP;
129266:

Line 129267: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');

129263: l_array_duplicate_checker(line_record.event_id) := line_record.event_id;
129264: END IF;
129265: END LOOP;
129266:
129267: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
129268: fnd_file.put_line(fnd_file.LOG, ' ');
129269:
129270:
129271: xla_exceptions_pkg.raise_message

Line 129268: fnd_file.put_line(fnd_file.LOG, ' ');

129264: END IF;
129265: END LOOP;
129266:
129267: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
129268: fnd_file.put_line(fnd_file.LOG, ' ');
129269:
129270:
129271: xla_exceptions_pkg.raise_message
129272: (p_location => 'XLA_00555_AAD_S_000001_PKG.EventType_255');

Line 130432: fnd_file.put_line(fnd_file.LOG, ' ');

130428:
130429: l_first_event_id := l_array_header_events(l_array_header_events.FIRST);
130430: l_last_event_id := l_array_header_events(l_array_header_events.LAST);
130431:
130432: fnd_file.put_line(fnd_file.LOG, ' ');
130433: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
130434: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );
130435: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');
130436:

Line 130433: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');

130429: l_first_event_id := l_array_header_events(l_array_header_events.FIRST);
130430: l_last_event_id := l_array_header_events(l_array_header_events.LAST);
130431:
130432: fnd_file.put_line(fnd_file.LOG, ' ');
130433: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
130434: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );
130435: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');
130436:
130437: FOR line_record IN line_cur(l_first_event_id, l_last_event_id)

Line 130434: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );

130430: l_last_event_id := l_array_header_events(l_array_header_events.LAST);
130431:
130432: fnd_file.put_line(fnd_file.LOG, ' ');
130433: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
130434: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );
130435: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');
130436:
130437: FOR line_record IN line_cur(l_first_event_id, l_last_event_id)
130438: LOOP

Line 130435: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');

130431:
130432: fnd_file.put_line(fnd_file.LOG, ' ');
130433: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
130434: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );
130435: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');
130436:
130437: FOR line_record IN line_cur(l_first_event_id, l_last_event_id)
130438: LOOP
130439: IF (NOT l_array_header_events.EXISTS(line_record.event_id)) AND (NOT l_array_duplicate_checker.EXISTS(line_record.event_id)) THEN

Line 130440: fnd_file.put_line(fnd_file.log, 'Event_id = ' || line_record.event_id);

130436:
130437: FOR line_record IN line_cur(l_first_event_id, l_last_event_id)
130438: LOOP
130439: IF (NOT l_array_header_events.EXISTS(line_record.event_id)) AND (NOT l_array_duplicate_checker.EXISTS(line_record.event_id)) THEN
130440: fnd_file.put_line(fnd_file.log, 'Event_id = ' || line_record.event_id);
130441: l_array_duplicate_checker(line_record.event_id) := line_record.event_id;
130442: END IF;
130443: END LOOP;
130444:

Line 130445: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');

130441: l_array_duplicate_checker(line_record.event_id) := line_record.event_id;
130442: END IF;
130443: END LOOP;
130444:
130445: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
130446: fnd_file.put_line(fnd_file.LOG, ' ');
130447:
130448:
130449: xla_exceptions_pkg.raise_message

Line 130446: fnd_file.put_line(fnd_file.LOG, ' ');

130442: END IF;
130443: END LOOP;
130444:
130445: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
130446: fnd_file.put_line(fnd_file.LOG, ' ');
130447:
130448:
130449: xla_exceptions_pkg.raise_message
130450: (p_location => 'XLA_00555_AAD_S_000001_PKG.EventType_256');

Line 131610: fnd_file.put_line(fnd_file.LOG, ' ');

131606:
131607: l_first_event_id := l_array_header_events(l_array_header_events.FIRST);
131608: l_last_event_id := l_array_header_events(l_array_header_events.LAST);
131609:
131610: fnd_file.put_line(fnd_file.LOG, ' ');
131611: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
131612: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );
131613: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');
131614:

Line 131611: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');

131607: l_first_event_id := l_array_header_events(l_array_header_events.FIRST);
131608: l_last_event_id := l_array_header_events(l_array_header_events.LAST);
131609:
131610: fnd_file.put_line(fnd_file.LOG, ' ');
131611: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
131612: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );
131613: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');
131614:
131615: FOR line_record IN line_cur(l_first_event_id, l_last_event_id)

Line 131612: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );

131608: l_last_event_id := l_array_header_events(l_array_header_events.LAST);
131609:
131610: fnd_file.put_line(fnd_file.LOG, ' ');
131611: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
131612: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );
131613: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');
131614:
131615: FOR line_record IN line_cur(l_first_event_id, l_last_event_id)
131616: LOOP

Line 131613: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');

131609:
131610: fnd_file.put_line(fnd_file.LOG, ' ');
131611: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
131612: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );
131613: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');
131614:
131615: FOR line_record IN line_cur(l_first_event_id, l_last_event_id)
131616: LOOP
131617: IF (NOT l_array_header_events.EXISTS(line_record.event_id)) AND (NOT l_array_duplicate_checker.EXISTS(line_record.event_id)) THEN

Line 131618: fnd_file.put_line(fnd_file.log, 'Event_id = ' || line_record.event_id);

131614:
131615: FOR line_record IN line_cur(l_first_event_id, l_last_event_id)
131616: LOOP
131617: IF (NOT l_array_header_events.EXISTS(line_record.event_id)) AND (NOT l_array_duplicate_checker.EXISTS(line_record.event_id)) THEN
131618: fnd_file.put_line(fnd_file.log, 'Event_id = ' || line_record.event_id);
131619: l_array_duplicate_checker(line_record.event_id) := line_record.event_id;
131620: END IF;
131621: END LOOP;
131622:

Line 131623: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');

131619: l_array_duplicate_checker(line_record.event_id) := line_record.event_id;
131620: END IF;
131621: END LOOP;
131622:
131623: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
131624: fnd_file.put_line(fnd_file.LOG, ' ');
131625:
131626:
131627: xla_exceptions_pkg.raise_message

Line 131624: fnd_file.put_line(fnd_file.LOG, ' ');

131620: END IF;
131621: END LOOP;
131622:
131623: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
131624: fnd_file.put_line(fnd_file.LOG, ' ');
131625:
131626:
131627: xla_exceptions_pkg.raise_message
131628: (p_location => 'XLA_00555_AAD_S_000001_PKG.EventType_257');

Line 132844: fnd_file.put_line(fnd_file.LOG, ' ');

132840:
132841: l_first_event_id := l_array_header_events(l_array_header_events.FIRST);
132842: l_last_event_id := l_array_header_events(l_array_header_events.LAST);
132843:
132844: fnd_file.put_line(fnd_file.LOG, ' ');
132845: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
132846: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );
132847: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');
132848:

Line 132845: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');

132841: l_first_event_id := l_array_header_events(l_array_header_events.FIRST);
132842: l_last_event_id := l_array_header_events(l_array_header_events.LAST);
132843:
132844: fnd_file.put_line(fnd_file.LOG, ' ');
132845: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
132846: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );
132847: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');
132848:
132849: FOR line_record IN line_cur(l_first_event_id, l_last_event_id)

Line 132846: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );

132842: l_last_event_id := l_array_header_events(l_array_header_events.LAST);
132843:
132844: fnd_file.put_line(fnd_file.LOG, ' ');
132845: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
132846: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );
132847: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');
132848:
132849: FOR line_record IN line_cur(l_first_event_id, l_last_event_id)
132850: LOOP

Line 132847: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');

132843:
132844: fnd_file.put_line(fnd_file.LOG, ' ');
132845: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
132846: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );
132847: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');
132848:
132849: FOR line_record IN line_cur(l_first_event_id, l_last_event_id)
132850: LOOP
132851: IF (NOT l_array_header_events.EXISTS(line_record.event_id)) AND (NOT l_array_duplicate_checker.EXISTS(line_record.event_id)) THEN

Line 132852: fnd_file.put_line(fnd_file.log, 'Event_id = ' || line_record.event_id);

132848:
132849: FOR line_record IN line_cur(l_first_event_id, l_last_event_id)
132850: LOOP
132851: IF (NOT l_array_header_events.EXISTS(line_record.event_id)) AND (NOT l_array_duplicate_checker.EXISTS(line_record.event_id)) THEN
132852: fnd_file.put_line(fnd_file.log, 'Event_id = ' || line_record.event_id);
132853: l_array_duplicate_checker(line_record.event_id) := line_record.event_id;
132854: END IF;
132855: END LOOP;
132856:

Line 132857: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');

132853: l_array_duplicate_checker(line_record.event_id) := line_record.event_id;
132854: END IF;
132855: END LOOP;
132856:
132857: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
132858: fnd_file.put_line(fnd_file.LOG, ' ');
132859:
132860:
132861: xla_exceptions_pkg.raise_message

Line 132858: fnd_file.put_line(fnd_file.LOG, ' ');

132854: END IF;
132855: END LOOP;
132856:
132857: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
132858: fnd_file.put_line(fnd_file.LOG, ' ');
132859:
132860:
132861: xla_exceptions_pkg.raise_message
132862: (p_location => 'XLA_00555_AAD_S_000001_PKG.EventType_258');

Line 134050: fnd_file.put_line(fnd_file.LOG, ' ');

134046:
134047: l_first_event_id := l_array_header_events(l_array_header_events.FIRST);
134048: l_last_event_id := l_array_header_events(l_array_header_events.LAST);
134049:
134050: fnd_file.put_line(fnd_file.LOG, ' ');
134051: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
134052: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );
134053: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');
134054:

Line 134051: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');

134047: l_first_event_id := l_array_header_events(l_array_header_events.FIRST);
134048: l_last_event_id := l_array_header_events(l_array_header_events.LAST);
134049:
134050: fnd_file.put_line(fnd_file.LOG, ' ');
134051: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
134052: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );
134053: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');
134054:
134055: FOR line_record IN line_cur(l_first_event_id, l_last_event_id)

Line 134052: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );

134048: l_last_event_id := l_array_header_events(l_array_header_events.LAST);
134049:
134050: fnd_file.put_line(fnd_file.LOG, ' ');
134051: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
134052: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );
134053: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');
134054:
134055: FOR line_record IN line_cur(l_first_event_id, l_last_event_id)
134056: LOOP

Line 134053: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');

134049:
134050: fnd_file.put_line(fnd_file.LOG, ' ');
134051: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
134052: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );
134053: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');
134054:
134055: FOR line_record IN line_cur(l_first_event_id, l_last_event_id)
134056: LOOP
134057: IF (NOT l_array_header_events.EXISTS(line_record.event_id)) AND (NOT l_array_duplicate_checker.EXISTS(line_record.event_id)) THEN

Line 134058: fnd_file.put_line(fnd_file.log, 'Event_id = ' || line_record.event_id);

134054:
134055: FOR line_record IN line_cur(l_first_event_id, l_last_event_id)
134056: LOOP
134057: IF (NOT l_array_header_events.EXISTS(line_record.event_id)) AND (NOT l_array_duplicate_checker.EXISTS(line_record.event_id)) THEN
134058: fnd_file.put_line(fnd_file.log, 'Event_id = ' || line_record.event_id);
134059: l_array_duplicate_checker(line_record.event_id) := line_record.event_id;
134060: END IF;
134061: END LOOP;
134062:

Line 134063: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');

134059: l_array_duplicate_checker(line_record.event_id) := line_record.event_id;
134060: END IF;
134061: END LOOP;
134062:
134063: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
134064: fnd_file.put_line(fnd_file.LOG, ' ');
134065:
134066:
134067: xla_exceptions_pkg.raise_message

Line 134064: fnd_file.put_line(fnd_file.LOG, ' ');

134060: END IF;
134061: END LOOP;
134062:
134063: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
134064: fnd_file.put_line(fnd_file.LOG, ' ');
134065:
134066:
134067: xla_exceptions_pkg.raise_message
134068: (p_location => 'XLA_00555_AAD_S_000001_PKG.EventType_259');

Line 135312: fnd_file.put_line(fnd_file.LOG, ' ');

135308:
135309: l_first_event_id := l_array_header_events(l_array_header_events.FIRST);
135310: l_last_event_id := l_array_header_events(l_array_header_events.LAST);
135311:
135312: fnd_file.put_line(fnd_file.LOG, ' ');
135313: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
135314: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );
135315: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');
135316:

Line 135313: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');

135309: l_first_event_id := l_array_header_events(l_array_header_events.FIRST);
135310: l_last_event_id := l_array_header_events(l_array_header_events.LAST);
135311:
135312: fnd_file.put_line(fnd_file.LOG, ' ');
135313: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
135314: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );
135315: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');
135316:
135317: FOR line_record IN line_cur(l_first_event_id, l_last_event_id)

Line 135314: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );

135310: l_last_event_id := l_array_header_events(l_array_header_events.LAST);
135311:
135312: fnd_file.put_line(fnd_file.LOG, ' ');
135313: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
135314: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );
135315: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');
135316:
135317: FOR line_record IN line_cur(l_first_event_id, l_last_event_id)
135318: LOOP

Line 135315: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');

135311:
135312: fnd_file.put_line(fnd_file.LOG, ' ');
135313: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
135314: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );
135315: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');
135316:
135317: FOR line_record IN line_cur(l_first_event_id, l_last_event_id)
135318: LOOP
135319: IF (NOT l_array_header_events.EXISTS(line_record.event_id)) AND (NOT l_array_duplicate_checker.EXISTS(line_record.event_id)) THEN

Line 135320: fnd_file.put_line(fnd_file.log, 'Event_id = ' || line_record.event_id);

135316:
135317: FOR line_record IN line_cur(l_first_event_id, l_last_event_id)
135318: LOOP
135319: IF (NOT l_array_header_events.EXISTS(line_record.event_id)) AND (NOT l_array_duplicate_checker.EXISTS(line_record.event_id)) THEN
135320: fnd_file.put_line(fnd_file.log, 'Event_id = ' || line_record.event_id);
135321: l_array_duplicate_checker(line_record.event_id) := line_record.event_id;
135322: END IF;
135323: END LOOP;
135324:

Line 135325: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');

135321: l_array_duplicate_checker(line_record.event_id) := line_record.event_id;
135322: END IF;
135323: END LOOP;
135324:
135325: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
135326: fnd_file.put_line(fnd_file.LOG, ' ');
135327:
135328:
135329: xla_exceptions_pkg.raise_message

Line 135326: fnd_file.put_line(fnd_file.LOG, ' ');

135322: END IF;
135323: END LOOP;
135324:
135325: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
135326: fnd_file.put_line(fnd_file.LOG, ' ');
135327:
135328:
135329: xla_exceptions_pkg.raise_message
135330: (p_location => 'XLA_00555_AAD_S_000001_PKG.EventType_260');

Line 136546: fnd_file.put_line(fnd_file.LOG, ' ');

136542:
136543: l_first_event_id := l_array_header_events(l_array_header_events.FIRST);
136544: l_last_event_id := l_array_header_events(l_array_header_events.LAST);
136545:
136546: fnd_file.put_line(fnd_file.LOG, ' ');
136547: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
136548: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );
136549: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');
136550:

Line 136547: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');

136543: l_first_event_id := l_array_header_events(l_array_header_events.FIRST);
136544: l_last_event_id := l_array_header_events(l_array_header_events.LAST);
136545:
136546: fnd_file.put_line(fnd_file.LOG, ' ');
136547: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
136548: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );
136549: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');
136550:
136551: FOR line_record IN line_cur(l_first_event_id, l_last_event_id)

Line 136548: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );

136544: l_last_event_id := l_array_header_events(l_array_header_events.LAST);
136545:
136546: fnd_file.put_line(fnd_file.LOG, ' ');
136547: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
136548: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );
136549: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');
136550:
136551: FOR line_record IN line_cur(l_first_event_id, l_last_event_id)
136552: LOOP

Line 136549: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');

136545:
136546: fnd_file.put_line(fnd_file.LOG, ' ');
136547: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
136548: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );
136549: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');
136550:
136551: FOR line_record IN line_cur(l_first_event_id, l_last_event_id)
136552: LOOP
136553: IF (NOT l_array_header_events.EXISTS(line_record.event_id)) AND (NOT l_array_duplicate_checker.EXISTS(line_record.event_id)) THEN

Line 136554: fnd_file.put_line(fnd_file.log, 'Event_id = ' || line_record.event_id);

136550:
136551: FOR line_record IN line_cur(l_first_event_id, l_last_event_id)
136552: LOOP
136553: IF (NOT l_array_header_events.EXISTS(line_record.event_id)) AND (NOT l_array_duplicate_checker.EXISTS(line_record.event_id)) THEN
136554: fnd_file.put_line(fnd_file.log, 'Event_id = ' || line_record.event_id);
136555: l_array_duplicate_checker(line_record.event_id) := line_record.event_id;
136556: END IF;
136557: END LOOP;
136558:

Line 136559: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');

136555: l_array_duplicate_checker(line_record.event_id) := line_record.event_id;
136556: END IF;
136557: END LOOP;
136558:
136559: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
136560: fnd_file.put_line(fnd_file.LOG, ' ');
136561:
136562:
136563: xla_exceptions_pkg.raise_message

Line 136560: fnd_file.put_line(fnd_file.LOG, ' ');

136556: END IF;
136557: END LOOP;
136558:
136559: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
136560: fnd_file.put_line(fnd_file.LOG, ' ');
136561:
136562:
136563: xla_exceptions_pkg.raise_message
136564: (p_location => 'XLA_00555_AAD_S_000001_PKG.EventType_261');

Line 137724: fnd_file.put_line(fnd_file.LOG, ' ');

137720:
137721: l_first_event_id := l_array_header_events(l_array_header_events.FIRST);
137722: l_last_event_id := l_array_header_events(l_array_header_events.LAST);
137723:
137724: fnd_file.put_line(fnd_file.LOG, ' ');
137725: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
137726: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );
137727: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');
137728:

Line 137725: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');

137721: l_first_event_id := l_array_header_events(l_array_header_events.FIRST);
137722: l_last_event_id := l_array_header_events(l_array_header_events.LAST);
137723:
137724: fnd_file.put_line(fnd_file.LOG, ' ');
137725: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
137726: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );
137727: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');
137728:
137729: FOR line_record IN line_cur(l_first_event_id, l_last_event_id)

Line 137726: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );

137722: l_last_event_id := l_array_header_events(l_array_header_events.LAST);
137723:
137724: fnd_file.put_line(fnd_file.LOG, ' ');
137725: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
137726: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );
137727: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');
137728:
137729: FOR line_record IN line_cur(l_first_event_id, l_last_event_id)
137730: LOOP

Line 137727: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');

137723:
137724: fnd_file.put_line(fnd_file.LOG, ' ');
137725: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
137726: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );
137727: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');
137728:
137729: FOR line_record IN line_cur(l_first_event_id, l_last_event_id)
137730: LOOP
137731: IF (NOT l_array_header_events.EXISTS(line_record.event_id)) AND (NOT l_array_duplicate_checker.EXISTS(line_record.event_id)) THEN

Line 137732: fnd_file.put_line(fnd_file.log, 'Event_id = ' || line_record.event_id);

137728:
137729: FOR line_record IN line_cur(l_first_event_id, l_last_event_id)
137730: LOOP
137731: IF (NOT l_array_header_events.EXISTS(line_record.event_id)) AND (NOT l_array_duplicate_checker.EXISTS(line_record.event_id)) THEN
137732: fnd_file.put_line(fnd_file.log, 'Event_id = ' || line_record.event_id);
137733: l_array_duplicate_checker(line_record.event_id) := line_record.event_id;
137734: END IF;
137735: END LOOP;
137736:

Line 137737: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');

137733: l_array_duplicate_checker(line_record.event_id) := line_record.event_id;
137734: END IF;
137735: END LOOP;
137736:
137737: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
137738: fnd_file.put_line(fnd_file.LOG, ' ');
137739:
137740:
137741: xla_exceptions_pkg.raise_message

Line 137738: fnd_file.put_line(fnd_file.LOG, ' ');

137734: END IF;
137735: END LOOP;
137736:
137737: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
137738: fnd_file.put_line(fnd_file.LOG, ' ');
137739:
137740:
137741: xla_exceptions_pkg.raise_message
137742: (p_location => 'XLA_00555_AAD_S_000001_PKG.EventType_262');

Line 138902: fnd_file.put_line(fnd_file.LOG, ' ');

138898:
138899: l_first_event_id := l_array_header_events(l_array_header_events.FIRST);
138900: l_last_event_id := l_array_header_events(l_array_header_events.LAST);
138901:
138902: fnd_file.put_line(fnd_file.LOG, ' ');
138903: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
138904: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );
138905: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');
138906:

Line 138903: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');

138899: l_first_event_id := l_array_header_events(l_array_header_events.FIRST);
138900: l_last_event_id := l_array_header_events(l_array_header_events.LAST);
138901:
138902: fnd_file.put_line(fnd_file.LOG, ' ');
138903: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
138904: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );
138905: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');
138906:
138907: FOR line_record IN line_cur(l_first_event_id, l_last_event_id)

Line 138904: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );

138900: l_last_event_id := l_array_header_events(l_array_header_events.LAST);
138901:
138902: fnd_file.put_line(fnd_file.LOG, ' ');
138903: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
138904: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );
138905: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');
138906:
138907: FOR line_record IN line_cur(l_first_event_id, l_last_event_id)
138908: LOOP

Line 138905: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');

138901:
138902: fnd_file.put_line(fnd_file.LOG, ' ');
138903: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
138904: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );
138905: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');
138906:
138907: FOR line_record IN line_cur(l_first_event_id, l_last_event_id)
138908: LOOP
138909: IF (NOT l_array_header_events.EXISTS(line_record.event_id)) AND (NOT l_array_duplicate_checker.EXISTS(line_record.event_id)) THEN

Line 138910: fnd_file.put_line(fnd_file.log, 'Event_id = ' || line_record.event_id);

138906:
138907: FOR line_record IN line_cur(l_first_event_id, l_last_event_id)
138908: LOOP
138909: IF (NOT l_array_header_events.EXISTS(line_record.event_id)) AND (NOT l_array_duplicate_checker.EXISTS(line_record.event_id)) THEN
138910: fnd_file.put_line(fnd_file.log, 'Event_id = ' || line_record.event_id);
138911: l_array_duplicate_checker(line_record.event_id) := line_record.event_id;
138912: END IF;
138913: END LOOP;
138914:

Line 138915: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');

138911: l_array_duplicate_checker(line_record.event_id) := line_record.event_id;
138912: END IF;
138913: END LOOP;
138914:
138915: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
138916: fnd_file.put_line(fnd_file.LOG, ' ');
138917:
138918:
138919: xla_exceptions_pkg.raise_message

Line 138916: fnd_file.put_line(fnd_file.LOG, ' ');

138912: END IF;
138913: END LOOP;
138914:
138915: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
138916: fnd_file.put_line(fnd_file.LOG, ' ');
138917:
138918:
138919: xla_exceptions_pkg.raise_message
138920: (p_location => 'XLA_00555_AAD_S_000001_PKG.EventType_263');

Line 140080: fnd_file.put_line(fnd_file.LOG, ' ');

140076:
140077: l_first_event_id := l_array_header_events(l_array_header_events.FIRST);
140078: l_last_event_id := l_array_header_events(l_array_header_events.LAST);
140079:
140080: fnd_file.put_line(fnd_file.LOG, ' ');
140081: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
140082: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );
140083: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');
140084:

Line 140081: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');

140077: l_first_event_id := l_array_header_events(l_array_header_events.FIRST);
140078: l_last_event_id := l_array_header_events(l_array_header_events.LAST);
140079:
140080: fnd_file.put_line(fnd_file.LOG, ' ');
140081: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
140082: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );
140083: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');
140084:
140085: FOR line_record IN line_cur(l_first_event_id, l_last_event_id)

Line 140082: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );

140078: l_last_event_id := l_array_header_events(l_array_header_events.LAST);
140079:
140080: fnd_file.put_line(fnd_file.LOG, ' ');
140081: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
140082: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );
140083: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');
140084:
140085: FOR line_record IN line_cur(l_first_event_id, l_last_event_id)
140086: LOOP

Line 140083: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');

140079:
140080: fnd_file.put_line(fnd_file.LOG, ' ');
140081: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
140082: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );
140083: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');
140084:
140085: FOR line_record IN line_cur(l_first_event_id, l_last_event_id)
140086: LOOP
140087: IF (NOT l_array_header_events.EXISTS(line_record.event_id)) AND (NOT l_array_duplicate_checker.EXISTS(line_record.event_id)) THEN

Line 140088: fnd_file.put_line(fnd_file.log, 'Event_id = ' || line_record.event_id);

140084:
140085: FOR line_record IN line_cur(l_first_event_id, l_last_event_id)
140086: LOOP
140087: IF (NOT l_array_header_events.EXISTS(line_record.event_id)) AND (NOT l_array_duplicate_checker.EXISTS(line_record.event_id)) THEN
140088: fnd_file.put_line(fnd_file.log, 'Event_id = ' || line_record.event_id);
140089: l_array_duplicate_checker(line_record.event_id) := line_record.event_id;
140090: END IF;
140091: END LOOP;
140092:

Line 140093: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');

140089: l_array_duplicate_checker(line_record.event_id) := line_record.event_id;
140090: END IF;
140091: END LOOP;
140092:
140093: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
140094: fnd_file.put_line(fnd_file.LOG, ' ');
140095:
140096:
140097: xla_exceptions_pkg.raise_message

Line 140094: fnd_file.put_line(fnd_file.LOG, ' ');

140090: END IF;
140091: END LOOP;
140092:
140093: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
140094: fnd_file.put_line(fnd_file.LOG, ' ');
140095:
140096:
140097: xla_exceptions_pkg.raise_message
140098: (p_location => 'XLA_00555_AAD_S_000001_PKG.EventType_264');

Line 141370: fnd_file.put_line(fnd_file.LOG, ' ');

141366:
141367: l_first_event_id := l_array_header_events(l_array_header_events.FIRST);
141368: l_last_event_id := l_array_header_events(l_array_header_events.LAST);
141369:
141370: fnd_file.put_line(fnd_file.LOG, ' ');
141371: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
141372: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );
141373: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');
141374:

Line 141371: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');

141367: l_first_event_id := l_array_header_events(l_array_header_events.FIRST);
141368: l_last_event_id := l_array_header_events(l_array_header_events.LAST);
141369:
141370: fnd_file.put_line(fnd_file.LOG, ' ');
141371: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
141372: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );
141373: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');
141374:
141375: FOR line_record IN line_cur(l_first_event_id, l_last_event_id)

Line 141372: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );

141368: l_last_event_id := l_array_header_events(l_array_header_events.LAST);
141369:
141370: fnd_file.put_line(fnd_file.LOG, ' ');
141371: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
141372: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );
141373: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');
141374:
141375: FOR line_record IN line_cur(l_first_event_id, l_last_event_id)
141376: LOOP

Line 141373: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');

141369:
141370: fnd_file.put_line(fnd_file.LOG, ' ');
141371: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
141372: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );
141373: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');
141374:
141375: FOR line_record IN line_cur(l_first_event_id, l_last_event_id)
141376: LOOP
141377: IF (NOT l_array_header_events.EXISTS(line_record.event_id)) AND (NOT l_array_duplicate_checker.EXISTS(line_record.event_id)) THEN

Line 141378: fnd_file.put_line(fnd_file.log, 'Event_id = ' || line_record.event_id);

141374:
141375: FOR line_record IN line_cur(l_first_event_id, l_last_event_id)
141376: LOOP
141377: IF (NOT l_array_header_events.EXISTS(line_record.event_id)) AND (NOT l_array_duplicate_checker.EXISTS(line_record.event_id)) THEN
141378: fnd_file.put_line(fnd_file.log, 'Event_id = ' || line_record.event_id);
141379: l_array_duplicate_checker(line_record.event_id) := line_record.event_id;
141380: END IF;
141381: END LOOP;
141382:

Line 141383: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');

141379: l_array_duplicate_checker(line_record.event_id) := line_record.event_id;
141380: END IF;
141381: END LOOP;
141382:
141383: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
141384: fnd_file.put_line(fnd_file.LOG, ' ');
141385:
141386:
141387: xla_exceptions_pkg.raise_message

Line 141384: fnd_file.put_line(fnd_file.LOG, ' ');

141380: END IF;
141381: END LOOP;
141382:
141383: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
141384: fnd_file.put_line(fnd_file.LOG, ' ');
141385:
141386:
141387: xla_exceptions_pkg.raise_message
141388: (p_location => 'XLA_00555_AAD_S_000001_PKG.EventType_265');

Line 142632: fnd_file.put_line(fnd_file.LOG, ' ');

142628:
142629: l_first_event_id := l_array_header_events(l_array_header_events.FIRST);
142630: l_last_event_id := l_array_header_events(l_array_header_events.LAST);
142631:
142632: fnd_file.put_line(fnd_file.LOG, ' ');
142633: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
142634: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );
142635: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');
142636:

Line 142633: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');

142629: l_first_event_id := l_array_header_events(l_array_header_events.FIRST);
142630: l_last_event_id := l_array_header_events(l_array_header_events.LAST);
142631:
142632: fnd_file.put_line(fnd_file.LOG, ' ');
142633: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
142634: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );
142635: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');
142636:
142637: FOR line_record IN line_cur(l_first_event_id, l_last_event_id)

Line 142634: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );

142630: l_last_event_id := l_array_header_events(l_array_header_events.LAST);
142631:
142632: fnd_file.put_line(fnd_file.LOG, ' ');
142633: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
142634: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );
142635: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');
142636:
142637: FOR line_record IN line_cur(l_first_event_id, l_last_event_id)
142638: LOOP

Line 142635: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');

142631:
142632: fnd_file.put_line(fnd_file.LOG, ' ');
142633: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
142634: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );
142635: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');
142636:
142637: FOR line_record IN line_cur(l_first_event_id, l_last_event_id)
142638: LOOP
142639: IF (NOT l_array_header_events.EXISTS(line_record.event_id)) AND (NOT l_array_duplicate_checker.EXISTS(line_record.event_id)) THEN

Line 142640: fnd_file.put_line(fnd_file.log, 'Event_id = ' || line_record.event_id);

142636:
142637: FOR line_record IN line_cur(l_first_event_id, l_last_event_id)
142638: LOOP
142639: IF (NOT l_array_header_events.EXISTS(line_record.event_id)) AND (NOT l_array_duplicate_checker.EXISTS(line_record.event_id)) THEN
142640: fnd_file.put_line(fnd_file.log, 'Event_id = ' || line_record.event_id);
142641: l_array_duplicate_checker(line_record.event_id) := line_record.event_id;
142642: END IF;
142643: END LOOP;
142644:

Line 142645: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');

142641: l_array_duplicate_checker(line_record.event_id) := line_record.event_id;
142642: END IF;
142643: END LOOP;
142644:
142645: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
142646: fnd_file.put_line(fnd_file.LOG, ' ');
142647:
142648:
142649: xla_exceptions_pkg.raise_message

Line 142646: fnd_file.put_line(fnd_file.LOG, ' ');

142642: END IF;
142643: END LOOP;
142644:
142645: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
142646: fnd_file.put_line(fnd_file.LOG, ' ');
142647:
142648:
142649: xla_exceptions_pkg.raise_message
142650: (p_location => 'XLA_00555_AAD_S_000001_PKG.EventType_266');

Line 143894: fnd_file.put_line(fnd_file.LOG, ' ');

143890:
143891: l_first_event_id := l_array_header_events(l_array_header_events.FIRST);
143892: l_last_event_id := l_array_header_events(l_array_header_events.LAST);
143893:
143894: fnd_file.put_line(fnd_file.LOG, ' ');
143895: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
143896: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );
143897: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');
143898:

Line 143895: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');

143891: l_first_event_id := l_array_header_events(l_array_header_events.FIRST);
143892: l_last_event_id := l_array_header_events(l_array_header_events.LAST);
143893:
143894: fnd_file.put_line(fnd_file.LOG, ' ');
143895: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
143896: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );
143897: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');
143898:
143899: FOR line_record IN line_cur(l_first_event_id, l_last_event_id)

Line 143896: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );

143892: l_last_event_id := l_array_header_events(l_array_header_events.LAST);
143893:
143894: fnd_file.put_line(fnd_file.LOG, ' ');
143895: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
143896: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );
143897: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');
143898:
143899: FOR line_record IN line_cur(l_first_event_id, l_last_event_id)
143900: LOOP

Line 143897: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');

143893:
143894: fnd_file.put_line(fnd_file.LOG, ' ');
143895: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
143896: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );
143897: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');
143898:
143899: FOR line_record IN line_cur(l_first_event_id, l_last_event_id)
143900: LOOP
143901: IF (NOT l_array_header_events.EXISTS(line_record.event_id)) AND (NOT l_array_duplicate_checker.EXISTS(line_record.event_id)) THEN

Line 143902: fnd_file.put_line(fnd_file.log, 'Event_id = ' || line_record.event_id);

143898:
143899: FOR line_record IN line_cur(l_first_event_id, l_last_event_id)
143900: LOOP
143901: IF (NOT l_array_header_events.EXISTS(line_record.event_id)) AND (NOT l_array_duplicate_checker.EXISTS(line_record.event_id)) THEN
143902: fnd_file.put_line(fnd_file.log, 'Event_id = ' || line_record.event_id);
143903: l_array_duplicate_checker(line_record.event_id) := line_record.event_id;
143904: END IF;
143905: END LOOP;
143906:

Line 143907: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');

143903: l_array_duplicate_checker(line_record.event_id) := line_record.event_id;
143904: END IF;
143905: END LOOP;
143906:
143907: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
143908: fnd_file.put_line(fnd_file.LOG, ' ');
143909:
143910:
143911: xla_exceptions_pkg.raise_message

Line 143908: fnd_file.put_line(fnd_file.LOG, ' ');

143904: END IF;
143905: END LOOP;
143906:
143907: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
143908: fnd_file.put_line(fnd_file.LOG, ' ');
143909:
143910:
143911: xla_exceptions_pkg.raise_message
143912: (p_location => 'XLA_00555_AAD_S_000001_PKG.EventType_267');

Line 145156: fnd_file.put_line(fnd_file.LOG, ' ');

145152:
145153: l_first_event_id := l_array_header_events(l_array_header_events.FIRST);
145154: l_last_event_id := l_array_header_events(l_array_header_events.LAST);
145155:
145156: fnd_file.put_line(fnd_file.LOG, ' ');
145157: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
145158: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );
145159: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');
145160:

Line 145157: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');

145153: l_first_event_id := l_array_header_events(l_array_header_events.FIRST);
145154: l_last_event_id := l_array_header_events(l_array_header_events.LAST);
145155:
145156: fnd_file.put_line(fnd_file.LOG, ' ');
145157: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
145158: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );
145159: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');
145160:
145161: FOR line_record IN line_cur(l_first_event_id, l_last_event_id)

Line 145158: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );

145154: l_last_event_id := l_array_header_events(l_array_header_events.LAST);
145155:
145156: fnd_file.put_line(fnd_file.LOG, ' ');
145157: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
145158: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );
145159: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');
145160:
145161: FOR line_record IN line_cur(l_first_event_id, l_last_event_id)
145162: LOOP

Line 145159: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');

145155:
145156: fnd_file.put_line(fnd_file.LOG, ' ');
145157: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
145158: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );
145159: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');
145160:
145161: FOR line_record IN line_cur(l_first_event_id, l_last_event_id)
145162: LOOP
145163: IF (NOT l_array_header_events.EXISTS(line_record.event_id)) AND (NOT l_array_duplicate_checker.EXISTS(line_record.event_id)) THEN

Line 145164: fnd_file.put_line(fnd_file.log, 'Event_id = ' || line_record.event_id);

145160:
145161: FOR line_record IN line_cur(l_first_event_id, l_last_event_id)
145162: LOOP
145163: IF (NOT l_array_header_events.EXISTS(line_record.event_id)) AND (NOT l_array_duplicate_checker.EXISTS(line_record.event_id)) THEN
145164: fnd_file.put_line(fnd_file.log, 'Event_id = ' || line_record.event_id);
145165: l_array_duplicate_checker(line_record.event_id) := line_record.event_id;
145166: END IF;
145167: END LOOP;
145168:

Line 145169: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');

145165: l_array_duplicate_checker(line_record.event_id) := line_record.event_id;
145166: END IF;
145167: END LOOP;
145168:
145169: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
145170: fnd_file.put_line(fnd_file.LOG, ' ');
145171:
145172:
145173: xla_exceptions_pkg.raise_message

Line 145170: fnd_file.put_line(fnd_file.LOG, ' ');

145166: END IF;
145167: END LOOP;
145168:
145169: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
145170: fnd_file.put_line(fnd_file.LOG, ' ');
145171:
145172:
145173: xla_exceptions_pkg.raise_message
145174: (p_location => 'XLA_00555_AAD_S_000001_PKG.EventType_268');

Line 146362: fnd_file.put_line(fnd_file.LOG, ' ');

146358:
146359: l_first_event_id := l_array_header_events(l_array_header_events.FIRST);
146360: l_last_event_id := l_array_header_events(l_array_header_events.LAST);
146361:
146362: fnd_file.put_line(fnd_file.LOG, ' ');
146363: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
146364: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );
146365: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');
146366:

Line 146363: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');

146359: l_first_event_id := l_array_header_events(l_array_header_events.FIRST);
146360: l_last_event_id := l_array_header_events(l_array_header_events.LAST);
146361:
146362: fnd_file.put_line(fnd_file.LOG, ' ');
146363: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
146364: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );
146365: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');
146366:
146367: FOR line_record IN line_cur(l_first_event_id, l_last_event_id)

Line 146364: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );

146360: l_last_event_id := l_array_header_events(l_array_header_events.LAST);
146361:
146362: fnd_file.put_line(fnd_file.LOG, ' ');
146363: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
146364: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );
146365: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');
146366:
146367: FOR line_record IN line_cur(l_first_event_id, l_last_event_id)
146368: LOOP

Line 146365: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');

146361:
146362: fnd_file.put_line(fnd_file.LOG, ' ');
146363: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
146364: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );
146365: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');
146366:
146367: FOR line_record IN line_cur(l_first_event_id, l_last_event_id)
146368: LOOP
146369: IF (NOT l_array_header_events.EXISTS(line_record.event_id)) AND (NOT l_array_duplicate_checker.EXISTS(line_record.event_id)) THEN

Line 146370: fnd_file.put_line(fnd_file.log, 'Event_id = ' || line_record.event_id);

146366:
146367: FOR line_record IN line_cur(l_first_event_id, l_last_event_id)
146368: LOOP
146369: IF (NOT l_array_header_events.EXISTS(line_record.event_id)) AND (NOT l_array_duplicate_checker.EXISTS(line_record.event_id)) THEN
146370: fnd_file.put_line(fnd_file.log, 'Event_id = ' || line_record.event_id);
146371: l_array_duplicate_checker(line_record.event_id) := line_record.event_id;
146372: END IF;
146373: END LOOP;
146374:

Line 146375: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');

146371: l_array_duplicate_checker(line_record.event_id) := line_record.event_id;
146372: END IF;
146373: END LOOP;
146374:
146375: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
146376: fnd_file.put_line(fnd_file.LOG, ' ');
146377:
146378:
146379: xla_exceptions_pkg.raise_message

Line 146376: fnd_file.put_line(fnd_file.LOG, ' ');

146372: END IF;
146373: END LOOP;
146374:
146375: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
146376: fnd_file.put_line(fnd_file.LOG, ' ');
146377:
146378:
146379: xla_exceptions_pkg.raise_message
146380: (p_location => 'XLA_00555_AAD_S_000001_PKG.EventType_269');

Line 147568: fnd_file.put_line(fnd_file.LOG, ' ');

147564:
147565: l_first_event_id := l_array_header_events(l_array_header_events.FIRST);
147566: l_last_event_id := l_array_header_events(l_array_header_events.LAST);
147567:
147568: fnd_file.put_line(fnd_file.LOG, ' ');
147569: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
147570: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );
147571: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');
147572:

Line 147569: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');

147565: l_first_event_id := l_array_header_events(l_array_header_events.FIRST);
147566: l_last_event_id := l_array_header_events(l_array_header_events.LAST);
147567:
147568: fnd_file.put_line(fnd_file.LOG, ' ');
147569: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
147570: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );
147571: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');
147572:
147573: FOR line_record IN line_cur(l_first_event_id, l_last_event_id)

Line 147570: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );

147566: l_last_event_id := l_array_header_events(l_array_header_events.LAST);
147567:
147568: fnd_file.put_line(fnd_file.LOG, ' ');
147569: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
147570: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );
147571: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');
147572:
147573: FOR line_record IN line_cur(l_first_event_id, l_last_event_id)
147574: LOOP

Line 147571: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');

147567:
147568: fnd_file.put_line(fnd_file.LOG, ' ');
147569: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
147570: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );
147571: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');
147572:
147573: FOR line_record IN line_cur(l_first_event_id, l_last_event_id)
147574: LOOP
147575: IF (NOT l_array_header_events.EXISTS(line_record.event_id)) AND (NOT l_array_duplicate_checker.EXISTS(line_record.event_id)) THEN

Line 147576: fnd_file.put_line(fnd_file.log, 'Event_id = ' || line_record.event_id);

147572:
147573: FOR line_record IN line_cur(l_first_event_id, l_last_event_id)
147574: LOOP
147575: IF (NOT l_array_header_events.EXISTS(line_record.event_id)) AND (NOT l_array_duplicate_checker.EXISTS(line_record.event_id)) THEN
147576: fnd_file.put_line(fnd_file.log, 'Event_id = ' || line_record.event_id);
147577: l_array_duplicate_checker(line_record.event_id) := line_record.event_id;
147578: END IF;
147579: END LOOP;
147580:

Line 147581: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');

147577: l_array_duplicate_checker(line_record.event_id) := line_record.event_id;
147578: END IF;
147579: END LOOP;
147580:
147581: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
147582: fnd_file.put_line(fnd_file.LOG, ' ');
147583:
147584:
147585: xla_exceptions_pkg.raise_message

Line 147582: fnd_file.put_line(fnd_file.LOG, ' ');

147578: END IF;
147579: END LOOP;
147580:
147581: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
147582: fnd_file.put_line(fnd_file.LOG, ' ');
147583:
147584:
147585: xla_exceptions_pkg.raise_message
147586: (p_location => 'XLA_00555_AAD_S_000001_PKG.EventType_270');

Line 148886: fnd_file.put_line(fnd_file.LOG, ' ');

148882:
148883: l_first_event_id := l_array_header_events(l_array_header_events.FIRST);
148884: l_last_event_id := l_array_header_events(l_array_header_events.LAST);
148885:
148886: fnd_file.put_line(fnd_file.LOG, ' ');
148887: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
148888: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );
148889: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');
148890:

Line 148887: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');

148883: l_first_event_id := l_array_header_events(l_array_header_events.FIRST);
148884: l_last_event_id := l_array_header_events(l_array_header_events.LAST);
148885:
148886: fnd_file.put_line(fnd_file.LOG, ' ');
148887: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
148888: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );
148889: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');
148890:
148891: FOR line_record IN line_cur(l_first_event_id, l_last_event_id)

Line 148888: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );

148884: l_last_event_id := l_array_header_events(l_array_header_events.LAST);
148885:
148886: fnd_file.put_line(fnd_file.LOG, ' ');
148887: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
148888: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );
148889: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');
148890:
148891: FOR line_record IN line_cur(l_first_event_id, l_last_event_id)
148892: LOOP

Line 148889: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');

148885:
148886: fnd_file.put_line(fnd_file.LOG, ' ');
148887: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
148888: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );
148889: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');
148890:
148891: FOR line_record IN line_cur(l_first_event_id, l_last_event_id)
148892: LOOP
148893: IF (NOT l_array_header_events.EXISTS(line_record.event_id)) AND (NOT l_array_duplicate_checker.EXISTS(line_record.event_id)) THEN

Line 148894: fnd_file.put_line(fnd_file.log, 'Event_id = ' || line_record.event_id);

148890:
148891: FOR line_record IN line_cur(l_first_event_id, l_last_event_id)
148892: LOOP
148893: IF (NOT l_array_header_events.EXISTS(line_record.event_id)) AND (NOT l_array_duplicate_checker.EXISTS(line_record.event_id)) THEN
148894: fnd_file.put_line(fnd_file.log, 'Event_id = ' || line_record.event_id);
148895: l_array_duplicate_checker(line_record.event_id) := line_record.event_id;
148896: END IF;
148897: END LOOP;
148898:

Line 148899: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');

148895: l_array_duplicate_checker(line_record.event_id) := line_record.event_id;
148896: END IF;
148897: END LOOP;
148898:
148899: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
148900: fnd_file.put_line(fnd_file.LOG, ' ');
148901:
148902:
148903: xla_exceptions_pkg.raise_message

Line 148900: fnd_file.put_line(fnd_file.LOG, ' ');

148896: END IF;
148897: END LOOP;
148898:
148899: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
148900: fnd_file.put_line(fnd_file.LOG, ' ');
148901:
148902:
148903: xla_exceptions_pkg.raise_message
148904: (p_location => 'XLA_00555_AAD_S_000001_PKG.EventType_271');

Line 150148: fnd_file.put_line(fnd_file.LOG, ' ');

150144:
150145: l_first_event_id := l_array_header_events(l_array_header_events.FIRST);
150146: l_last_event_id := l_array_header_events(l_array_header_events.LAST);
150147:
150148: fnd_file.put_line(fnd_file.LOG, ' ');
150149: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
150150: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );
150151: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');
150152:

Line 150149: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');

150145: l_first_event_id := l_array_header_events(l_array_header_events.FIRST);
150146: l_last_event_id := l_array_header_events(l_array_header_events.LAST);
150147:
150148: fnd_file.put_line(fnd_file.LOG, ' ');
150149: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
150150: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );
150151: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');
150152:
150153: FOR line_record IN line_cur(l_first_event_id, l_last_event_id)

Line 150150: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );

150146: l_last_event_id := l_array_header_events(l_array_header_events.LAST);
150147:
150148: fnd_file.put_line(fnd_file.LOG, ' ');
150149: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
150150: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );
150151: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');
150152:
150153: FOR line_record IN line_cur(l_first_event_id, l_last_event_id)
150154: LOOP

Line 150151: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');

150147:
150148: fnd_file.put_line(fnd_file.LOG, ' ');
150149: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
150150: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );
150151: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');
150152:
150153: FOR line_record IN line_cur(l_first_event_id, l_last_event_id)
150154: LOOP
150155: IF (NOT l_array_header_events.EXISTS(line_record.event_id)) AND (NOT l_array_duplicate_checker.EXISTS(line_record.event_id)) THEN

Line 150156: fnd_file.put_line(fnd_file.log, 'Event_id = ' || line_record.event_id);

150152:
150153: FOR line_record IN line_cur(l_first_event_id, l_last_event_id)
150154: LOOP
150155: IF (NOT l_array_header_events.EXISTS(line_record.event_id)) AND (NOT l_array_duplicate_checker.EXISTS(line_record.event_id)) THEN
150156: fnd_file.put_line(fnd_file.log, 'Event_id = ' || line_record.event_id);
150157: l_array_duplicate_checker(line_record.event_id) := line_record.event_id;
150158: END IF;
150159: END LOOP;
150160:

Line 150161: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');

150157: l_array_duplicate_checker(line_record.event_id) := line_record.event_id;
150158: END IF;
150159: END LOOP;
150160:
150161: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
150162: fnd_file.put_line(fnd_file.LOG, ' ');
150163:
150164:
150165: xla_exceptions_pkg.raise_message

Line 150162: fnd_file.put_line(fnd_file.LOG, ' ');

150158: END IF;
150159: END LOOP;
150160:
150161: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
150162: fnd_file.put_line(fnd_file.LOG, ' ');
150163:
150164:
150165: xla_exceptions_pkg.raise_message
150166: (p_location => 'XLA_00555_AAD_S_000001_PKG.EventType_272');

Line 151410: fnd_file.put_line(fnd_file.LOG, ' ');

151406:
151407: l_first_event_id := l_array_header_events(l_array_header_events.FIRST);
151408: l_last_event_id := l_array_header_events(l_array_header_events.LAST);
151409:
151410: fnd_file.put_line(fnd_file.LOG, ' ');
151411: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
151412: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );
151413: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');
151414:

Line 151411: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');

151407: l_first_event_id := l_array_header_events(l_array_header_events.FIRST);
151408: l_last_event_id := l_array_header_events(l_array_header_events.LAST);
151409:
151410: fnd_file.put_line(fnd_file.LOG, ' ');
151411: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
151412: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );
151413: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');
151414:
151415: FOR line_record IN line_cur(l_first_event_id, l_last_event_id)

Line 151412: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );

151408: l_last_event_id := l_array_header_events(l_array_header_events.LAST);
151409:
151410: fnd_file.put_line(fnd_file.LOG, ' ');
151411: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
151412: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );
151413: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');
151414:
151415: FOR line_record IN line_cur(l_first_event_id, l_last_event_id)
151416: LOOP

Line 151413: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');

151409:
151410: fnd_file.put_line(fnd_file.LOG, ' ');
151411: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
151412: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );
151413: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');
151414:
151415: FOR line_record IN line_cur(l_first_event_id, l_last_event_id)
151416: LOOP
151417: IF (NOT l_array_header_events.EXISTS(line_record.event_id)) AND (NOT l_array_duplicate_checker.EXISTS(line_record.event_id)) THEN

Line 151418: fnd_file.put_line(fnd_file.log, 'Event_id = ' || line_record.event_id);

151414:
151415: FOR line_record IN line_cur(l_first_event_id, l_last_event_id)
151416: LOOP
151417: IF (NOT l_array_header_events.EXISTS(line_record.event_id)) AND (NOT l_array_duplicate_checker.EXISTS(line_record.event_id)) THEN
151418: fnd_file.put_line(fnd_file.log, 'Event_id = ' || line_record.event_id);
151419: l_array_duplicate_checker(line_record.event_id) := line_record.event_id;
151420: END IF;
151421: END LOOP;
151422:

Line 151423: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');

151419: l_array_duplicate_checker(line_record.event_id) := line_record.event_id;
151420: END IF;
151421: END LOOP;
151422:
151423: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
151424: fnd_file.put_line(fnd_file.LOG, ' ');
151425:
151426:
151427: xla_exceptions_pkg.raise_message

Line 151424: fnd_file.put_line(fnd_file.LOG, ' ');

151420: END IF;
151421: END LOOP;
151422:
151423: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
151424: fnd_file.put_line(fnd_file.LOG, ' ');
151425:
151426:
151427: xla_exceptions_pkg.raise_message
151428: (p_location => 'XLA_00555_AAD_S_000001_PKG.EventType_273');

Line 152672: fnd_file.put_line(fnd_file.LOG, ' ');

152668:
152669: l_first_event_id := l_array_header_events(l_array_header_events.FIRST);
152670: l_last_event_id := l_array_header_events(l_array_header_events.LAST);
152671:
152672: fnd_file.put_line(fnd_file.LOG, ' ');
152673: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
152674: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );
152675: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');
152676:

Line 152673: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');

152669: l_first_event_id := l_array_header_events(l_array_header_events.FIRST);
152670: l_last_event_id := l_array_header_events(l_array_header_events.LAST);
152671:
152672: fnd_file.put_line(fnd_file.LOG, ' ');
152673: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
152674: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );
152675: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');
152676:
152677: FOR line_record IN line_cur(l_first_event_id, l_last_event_id)

Line 152674: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );

152670: l_last_event_id := l_array_header_events(l_array_header_events.LAST);
152671:
152672: fnd_file.put_line(fnd_file.LOG, ' ');
152673: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
152674: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );
152675: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');
152676:
152677: FOR line_record IN line_cur(l_first_event_id, l_last_event_id)
152678: LOOP

Line 152675: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');

152671:
152672: fnd_file.put_line(fnd_file.LOG, ' ');
152673: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
152674: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );
152675: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');
152676:
152677: FOR line_record IN line_cur(l_first_event_id, l_last_event_id)
152678: LOOP
152679: IF (NOT l_array_header_events.EXISTS(line_record.event_id)) AND (NOT l_array_duplicate_checker.EXISTS(line_record.event_id)) THEN

Line 152680: fnd_file.put_line(fnd_file.log, 'Event_id = ' || line_record.event_id);

152676:
152677: FOR line_record IN line_cur(l_first_event_id, l_last_event_id)
152678: LOOP
152679: IF (NOT l_array_header_events.EXISTS(line_record.event_id)) AND (NOT l_array_duplicate_checker.EXISTS(line_record.event_id)) THEN
152680: fnd_file.put_line(fnd_file.log, 'Event_id = ' || line_record.event_id);
152681: l_array_duplicate_checker(line_record.event_id) := line_record.event_id;
152682: END IF;
152683: END LOOP;
152684:

Line 152685: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');

152681: l_array_duplicate_checker(line_record.event_id) := line_record.event_id;
152682: END IF;
152683: END LOOP;
152684:
152685: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
152686: fnd_file.put_line(fnd_file.LOG, ' ');
152687:
152688:
152689: xla_exceptions_pkg.raise_message

Line 152686: fnd_file.put_line(fnd_file.LOG, ' ');

152682: END IF;
152683: END LOOP;
152684:
152685: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
152686: fnd_file.put_line(fnd_file.LOG, ' ');
152687:
152688:
152689: xla_exceptions_pkg.raise_message
152690: (p_location => 'XLA_00555_AAD_S_000001_PKG.EventType_274');

Line 153850: fnd_file.put_line(fnd_file.LOG, ' ');

153846:
153847: l_first_event_id := l_array_header_events(l_array_header_events.FIRST);
153848: l_last_event_id := l_array_header_events(l_array_header_events.LAST);
153849:
153850: fnd_file.put_line(fnd_file.LOG, ' ');
153851: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
153852: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );
153853: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');
153854:

Line 153851: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');

153847: l_first_event_id := l_array_header_events(l_array_header_events.FIRST);
153848: l_last_event_id := l_array_header_events(l_array_header_events.LAST);
153849:
153850: fnd_file.put_line(fnd_file.LOG, ' ');
153851: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
153852: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );
153853: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');
153854:
153855: FOR line_record IN line_cur(l_first_event_id, l_last_event_id)

Line 153852: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );

153848: l_last_event_id := l_array_header_events(l_array_header_events.LAST);
153849:
153850: fnd_file.put_line(fnd_file.LOG, ' ');
153851: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
153852: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );
153853: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');
153854:
153855: FOR line_record IN line_cur(l_first_event_id, l_last_event_id)
153856: LOOP

Line 153853: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');

153849:
153850: fnd_file.put_line(fnd_file.LOG, ' ');
153851: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
153852: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );
153853: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');
153854:
153855: FOR line_record IN line_cur(l_first_event_id, l_last_event_id)
153856: LOOP
153857: IF (NOT l_array_header_events.EXISTS(line_record.event_id)) AND (NOT l_array_duplicate_checker.EXISTS(line_record.event_id)) THEN

Line 153858: fnd_file.put_line(fnd_file.log, 'Event_id = ' || line_record.event_id);

153854:
153855: FOR line_record IN line_cur(l_first_event_id, l_last_event_id)
153856: LOOP
153857: IF (NOT l_array_header_events.EXISTS(line_record.event_id)) AND (NOT l_array_duplicate_checker.EXISTS(line_record.event_id)) THEN
153858: fnd_file.put_line(fnd_file.log, 'Event_id = ' || line_record.event_id);
153859: l_array_duplicate_checker(line_record.event_id) := line_record.event_id;
153860: END IF;
153861: END LOOP;
153862:

Line 153863: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');

153859: l_array_duplicate_checker(line_record.event_id) := line_record.event_id;
153860: END IF;
153861: END LOOP;
153862:
153863: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
153864: fnd_file.put_line(fnd_file.LOG, ' ');
153865:
153866:
153867: xla_exceptions_pkg.raise_message

Line 153864: fnd_file.put_line(fnd_file.LOG, ' ');

153860: END IF;
153861: END LOOP;
153862:
153863: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
153864: fnd_file.put_line(fnd_file.LOG, ' ');
153865:
153866:
153867: xla_exceptions_pkg.raise_message
153868: (p_location => 'XLA_00555_AAD_S_000001_PKG.EventType_275');

Line 155056: fnd_file.put_line(fnd_file.LOG, ' ');

155052:
155053: l_first_event_id := l_array_header_events(l_array_header_events.FIRST);
155054: l_last_event_id := l_array_header_events(l_array_header_events.LAST);
155055:
155056: fnd_file.put_line(fnd_file.LOG, ' ');
155057: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
155058: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );
155059: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');
155060:

Line 155057: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');

155053: l_first_event_id := l_array_header_events(l_array_header_events.FIRST);
155054: l_last_event_id := l_array_header_events(l_array_header_events.LAST);
155055:
155056: fnd_file.put_line(fnd_file.LOG, ' ');
155057: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
155058: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );
155059: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');
155060:
155061: FOR line_record IN line_cur(l_first_event_id, l_last_event_id)

Line 155058: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );

155054: l_last_event_id := l_array_header_events(l_array_header_events.LAST);
155055:
155056: fnd_file.put_line(fnd_file.LOG, ' ');
155057: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
155058: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );
155059: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');
155060:
155061: FOR line_record IN line_cur(l_first_event_id, l_last_event_id)
155062: LOOP

Line 155059: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');

155055:
155056: fnd_file.put_line(fnd_file.LOG, ' ');
155057: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
155058: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );
155059: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');
155060:
155061: FOR line_record IN line_cur(l_first_event_id, l_last_event_id)
155062: LOOP
155063: IF (NOT l_array_header_events.EXISTS(line_record.event_id)) AND (NOT l_array_duplicate_checker.EXISTS(line_record.event_id)) THEN

Line 155064: fnd_file.put_line(fnd_file.log, 'Event_id = ' || line_record.event_id);

155060:
155061: FOR line_record IN line_cur(l_first_event_id, l_last_event_id)
155062: LOOP
155063: IF (NOT l_array_header_events.EXISTS(line_record.event_id)) AND (NOT l_array_duplicate_checker.EXISTS(line_record.event_id)) THEN
155064: fnd_file.put_line(fnd_file.log, 'Event_id = ' || line_record.event_id);
155065: l_array_duplicate_checker(line_record.event_id) := line_record.event_id;
155066: END IF;
155067: END LOOP;
155068:

Line 155069: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');

155065: l_array_duplicate_checker(line_record.event_id) := line_record.event_id;
155066: END IF;
155067: END LOOP;
155068:
155069: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
155070: fnd_file.put_line(fnd_file.LOG, ' ');
155071:
155072:
155073: xla_exceptions_pkg.raise_message

Line 155070: fnd_file.put_line(fnd_file.LOG, ' ');

155066: END IF;
155067: END LOOP;
155068:
155069: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
155070: fnd_file.put_line(fnd_file.LOG, ' ');
155071:
155072:
155073: xla_exceptions_pkg.raise_message
155074: (p_location => 'XLA_00555_AAD_S_000001_PKG.EventType_276');

Line 156290: fnd_file.put_line(fnd_file.LOG, ' ');

156286:
156287: l_first_event_id := l_array_header_events(l_array_header_events.FIRST);
156288: l_last_event_id := l_array_header_events(l_array_header_events.LAST);
156289:
156290: fnd_file.put_line(fnd_file.LOG, ' ');
156291: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
156292: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );
156293: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');
156294:

Line 156291: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');

156287: l_first_event_id := l_array_header_events(l_array_header_events.FIRST);
156288: l_last_event_id := l_array_header_events(l_array_header_events.LAST);
156289:
156290: fnd_file.put_line(fnd_file.LOG, ' ');
156291: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
156292: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );
156293: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');
156294:
156295: FOR line_record IN line_cur(l_first_event_id, l_last_event_id)

Line 156292: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );

156288: l_last_event_id := l_array_header_events(l_array_header_events.LAST);
156289:
156290: fnd_file.put_line(fnd_file.LOG, ' ');
156291: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
156292: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );
156293: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');
156294:
156295: FOR line_record IN line_cur(l_first_event_id, l_last_event_id)
156296: LOOP

Line 156293: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');

156289:
156290: fnd_file.put_line(fnd_file.LOG, ' ');
156291: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
156292: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );
156293: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');
156294:
156295: FOR line_record IN line_cur(l_first_event_id, l_last_event_id)
156296: LOOP
156297: IF (NOT l_array_header_events.EXISTS(line_record.event_id)) AND (NOT l_array_duplicate_checker.EXISTS(line_record.event_id)) THEN

Line 156298: fnd_file.put_line(fnd_file.log, 'Event_id = ' || line_record.event_id);

156294:
156295: FOR line_record IN line_cur(l_first_event_id, l_last_event_id)
156296: LOOP
156297: IF (NOT l_array_header_events.EXISTS(line_record.event_id)) AND (NOT l_array_duplicate_checker.EXISTS(line_record.event_id)) THEN
156298: fnd_file.put_line(fnd_file.log, 'Event_id = ' || line_record.event_id);
156299: l_array_duplicate_checker(line_record.event_id) := line_record.event_id;
156300: END IF;
156301: END LOOP;
156302:

Line 156303: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');

156299: l_array_duplicate_checker(line_record.event_id) := line_record.event_id;
156300: END IF;
156301: END LOOP;
156302:
156303: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
156304: fnd_file.put_line(fnd_file.LOG, ' ');
156305:
156306:
156307: xla_exceptions_pkg.raise_message

Line 156304: fnd_file.put_line(fnd_file.LOG, ' ');

156300: END IF;
156301: END LOOP;
156302:
156303: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
156304: fnd_file.put_line(fnd_file.LOG, ' ');
156305:
156306:
156307: xla_exceptions_pkg.raise_message
156308: (p_location => 'XLA_00555_AAD_S_000001_PKG.EventType_277');

Line 157580: fnd_file.put_line(fnd_file.LOG, ' ');

157576:
157577: l_first_event_id := l_array_header_events(l_array_header_events.FIRST);
157578: l_last_event_id := l_array_header_events(l_array_header_events.LAST);
157579:
157580: fnd_file.put_line(fnd_file.LOG, ' ');
157581: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
157582: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );
157583: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');
157584:

Line 157581: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');

157577: l_first_event_id := l_array_header_events(l_array_header_events.FIRST);
157578: l_last_event_id := l_array_header_events(l_array_header_events.LAST);
157579:
157580: fnd_file.put_line(fnd_file.LOG, ' ');
157581: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
157582: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );
157583: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');
157584:
157585: FOR line_record IN line_cur(l_first_event_id, l_last_event_id)

Line 157582: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );

157578: l_last_event_id := l_array_header_events(l_array_header_events.LAST);
157579:
157580: fnd_file.put_line(fnd_file.LOG, ' ');
157581: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
157582: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );
157583: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');
157584:
157585: FOR line_record IN line_cur(l_first_event_id, l_last_event_id)
157586: LOOP

Line 157583: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');

157579:
157580: fnd_file.put_line(fnd_file.LOG, ' ');
157581: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
157582: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );
157583: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');
157584:
157585: FOR line_record IN line_cur(l_first_event_id, l_last_event_id)
157586: LOOP
157587: IF (NOT l_array_header_events.EXISTS(line_record.event_id)) AND (NOT l_array_duplicate_checker.EXISTS(line_record.event_id)) THEN

Line 157588: fnd_file.put_line(fnd_file.log, 'Event_id = ' || line_record.event_id);

157584:
157585: FOR line_record IN line_cur(l_first_event_id, l_last_event_id)
157586: LOOP
157587: IF (NOT l_array_header_events.EXISTS(line_record.event_id)) AND (NOT l_array_duplicate_checker.EXISTS(line_record.event_id)) THEN
157588: fnd_file.put_line(fnd_file.log, 'Event_id = ' || line_record.event_id);
157589: l_array_duplicate_checker(line_record.event_id) := line_record.event_id;
157590: END IF;
157591: END LOOP;
157592:

Line 157593: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');

157589: l_array_duplicate_checker(line_record.event_id) := line_record.event_id;
157590: END IF;
157591: END LOOP;
157592:
157593: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
157594: fnd_file.put_line(fnd_file.LOG, ' ');
157595:
157596:
157597: xla_exceptions_pkg.raise_message

Line 157594: fnd_file.put_line(fnd_file.LOG, ' ');

157590: END IF;
157591: END LOOP;
157592:
157593: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
157594: fnd_file.put_line(fnd_file.LOG, ' ');
157595:
157596:
157597: xla_exceptions_pkg.raise_message
157598: (p_location => 'XLA_00555_AAD_S_000001_PKG.EventType_278');

Line 158758: fnd_file.put_line(fnd_file.LOG, ' ');

158754:
158755: l_first_event_id := l_array_header_events(l_array_header_events.FIRST);
158756: l_last_event_id := l_array_header_events(l_array_header_events.LAST);
158757:
158758: fnd_file.put_line(fnd_file.LOG, ' ');
158759: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
158760: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );
158761: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');
158762:

Line 158759: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');

158755: l_first_event_id := l_array_header_events(l_array_header_events.FIRST);
158756: l_last_event_id := l_array_header_events(l_array_header_events.LAST);
158757:
158758: fnd_file.put_line(fnd_file.LOG, ' ');
158759: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
158760: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );
158761: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');
158762:
158763: FOR line_record IN line_cur(l_first_event_id, l_last_event_id)

Line 158760: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );

158756: l_last_event_id := l_array_header_events(l_array_header_events.LAST);
158757:
158758: fnd_file.put_line(fnd_file.LOG, ' ');
158759: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
158760: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );
158761: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');
158762:
158763: FOR line_record IN line_cur(l_first_event_id, l_last_event_id)
158764: LOOP

Line 158761: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');

158757:
158758: fnd_file.put_line(fnd_file.LOG, ' ');
158759: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
158760: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );
158761: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');
158762:
158763: FOR line_record IN line_cur(l_first_event_id, l_last_event_id)
158764: LOOP
158765: IF (NOT l_array_header_events.EXISTS(line_record.event_id)) AND (NOT l_array_duplicate_checker.EXISTS(line_record.event_id)) THEN

Line 158766: fnd_file.put_line(fnd_file.log, 'Event_id = ' || line_record.event_id);

158762:
158763: FOR line_record IN line_cur(l_first_event_id, l_last_event_id)
158764: LOOP
158765: IF (NOT l_array_header_events.EXISTS(line_record.event_id)) AND (NOT l_array_duplicate_checker.EXISTS(line_record.event_id)) THEN
158766: fnd_file.put_line(fnd_file.log, 'Event_id = ' || line_record.event_id);
158767: l_array_duplicate_checker(line_record.event_id) := line_record.event_id;
158768: END IF;
158769: END LOOP;
158770:

Line 158771: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');

158767: l_array_duplicate_checker(line_record.event_id) := line_record.event_id;
158768: END IF;
158769: END LOOP;
158770:
158771: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
158772: fnd_file.put_line(fnd_file.LOG, ' ');
158773:
158774:
158775: xla_exceptions_pkg.raise_message

Line 158772: fnd_file.put_line(fnd_file.LOG, ' ');

158768: END IF;
158769: END LOOP;
158770:
158771: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
158772: fnd_file.put_line(fnd_file.LOG, ' ');
158773:
158774:
158775: xla_exceptions_pkg.raise_message
158776: (p_location => 'XLA_00555_AAD_S_000001_PKG.EventType_279');

Line 159936: fnd_file.put_line(fnd_file.LOG, ' ');

159932:
159933: l_first_event_id := l_array_header_events(l_array_header_events.FIRST);
159934: l_last_event_id := l_array_header_events(l_array_header_events.LAST);
159935:
159936: fnd_file.put_line(fnd_file.LOG, ' ');
159937: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
159938: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );
159939: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');
159940:

Line 159937: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');

159933: l_first_event_id := l_array_header_events(l_array_header_events.FIRST);
159934: l_last_event_id := l_array_header_events(l_array_header_events.LAST);
159935:
159936: fnd_file.put_line(fnd_file.LOG, ' ');
159937: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
159938: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );
159939: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');
159940:
159941: FOR line_record IN line_cur(l_first_event_id, l_last_event_id)

Line 159938: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );

159934: l_last_event_id := l_array_header_events(l_array_header_events.LAST);
159935:
159936: fnd_file.put_line(fnd_file.LOG, ' ');
159937: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
159938: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );
159939: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');
159940:
159941: FOR line_record IN line_cur(l_first_event_id, l_last_event_id)
159942: LOOP

Line 159939: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');

159935:
159936: fnd_file.put_line(fnd_file.LOG, ' ');
159937: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
159938: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );
159939: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');
159940:
159941: FOR line_record IN line_cur(l_first_event_id, l_last_event_id)
159942: LOOP
159943: IF (NOT l_array_header_events.EXISTS(line_record.event_id)) AND (NOT l_array_duplicate_checker.EXISTS(line_record.event_id)) THEN

Line 159944: fnd_file.put_line(fnd_file.log, 'Event_id = ' || line_record.event_id);

159940:
159941: FOR line_record IN line_cur(l_first_event_id, l_last_event_id)
159942: LOOP
159943: IF (NOT l_array_header_events.EXISTS(line_record.event_id)) AND (NOT l_array_duplicate_checker.EXISTS(line_record.event_id)) THEN
159944: fnd_file.put_line(fnd_file.log, 'Event_id = ' || line_record.event_id);
159945: l_array_duplicate_checker(line_record.event_id) := line_record.event_id;
159946: END IF;
159947: END LOOP;
159948:

Line 159949: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');

159945: l_array_duplicate_checker(line_record.event_id) := line_record.event_id;
159946: END IF;
159947: END LOOP;
159948:
159949: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
159950: fnd_file.put_line(fnd_file.LOG, ' ');
159951:
159952:
159953: xla_exceptions_pkg.raise_message

Line 159950: fnd_file.put_line(fnd_file.LOG, ' ');

159946: END IF;
159947: END LOOP;
159948:
159949: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
159950: fnd_file.put_line(fnd_file.LOG, ' ');
159951:
159952:
159953: xla_exceptions_pkg.raise_message
159954: (p_location => 'XLA_00555_AAD_S_000001_PKG.EventType_280');

Line 161142: fnd_file.put_line(fnd_file.LOG, ' ');

161138:
161139: l_first_event_id := l_array_header_events(l_array_header_events.FIRST);
161140: l_last_event_id := l_array_header_events(l_array_header_events.LAST);
161141:
161142: fnd_file.put_line(fnd_file.LOG, ' ');
161143: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
161144: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );
161145: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');
161146:

Line 161143: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');

161139: l_first_event_id := l_array_header_events(l_array_header_events.FIRST);
161140: l_last_event_id := l_array_header_events(l_array_header_events.LAST);
161141:
161142: fnd_file.put_line(fnd_file.LOG, ' ');
161143: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
161144: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );
161145: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');
161146:
161147: FOR line_record IN line_cur(l_first_event_id, l_last_event_id)

Line 161144: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );

161140: l_last_event_id := l_array_header_events(l_array_header_events.LAST);
161141:
161142: fnd_file.put_line(fnd_file.LOG, ' ');
161143: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
161144: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );
161145: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');
161146:
161147: FOR line_record IN line_cur(l_first_event_id, l_last_event_id)
161148: LOOP

Line 161145: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');

161141:
161142: fnd_file.put_line(fnd_file.LOG, ' ');
161143: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
161144: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );
161145: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');
161146:
161147: FOR line_record IN line_cur(l_first_event_id, l_last_event_id)
161148: LOOP
161149: IF (NOT l_array_header_events.EXISTS(line_record.event_id)) AND (NOT l_array_duplicate_checker.EXISTS(line_record.event_id)) THEN

Line 161150: fnd_file.put_line(fnd_file.log, 'Event_id = ' || line_record.event_id);

161146:
161147: FOR line_record IN line_cur(l_first_event_id, l_last_event_id)
161148: LOOP
161149: IF (NOT l_array_header_events.EXISTS(line_record.event_id)) AND (NOT l_array_duplicate_checker.EXISTS(line_record.event_id)) THEN
161150: fnd_file.put_line(fnd_file.log, 'Event_id = ' || line_record.event_id);
161151: l_array_duplicate_checker(line_record.event_id) := line_record.event_id;
161152: END IF;
161153: END LOOP;
161154:

Line 161155: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');

161151: l_array_duplicate_checker(line_record.event_id) := line_record.event_id;
161152: END IF;
161153: END LOOP;
161154:
161155: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
161156: fnd_file.put_line(fnd_file.LOG, ' ');
161157:
161158:
161159: xla_exceptions_pkg.raise_message

Line 161156: fnd_file.put_line(fnd_file.LOG, ' ');

161152: END IF;
161153: END LOOP;
161154:
161155: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
161156: fnd_file.put_line(fnd_file.LOG, ' ');
161157:
161158:
161159: xla_exceptions_pkg.raise_message
161160: (p_location => 'XLA_00555_AAD_S_000001_PKG.EventType_281');

Line 162348: fnd_file.put_line(fnd_file.LOG, ' ');

162344:
162345: l_first_event_id := l_array_header_events(l_array_header_events.FIRST);
162346: l_last_event_id := l_array_header_events(l_array_header_events.LAST);
162347:
162348: fnd_file.put_line(fnd_file.LOG, ' ');
162349: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
162350: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );
162351: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');
162352:

Line 162349: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');

162345: l_first_event_id := l_array_header_events(l_array_header_events.FIRST);
162346: l_last_event_id := l_array_header_events(l_array_header_events.LAST);
162347:
162348: fnd_file.put_line(fnd_file.LOG, ' ');
162349: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
162350: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );
162351: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');
162352:
162353: FOR line_record IN line_cur(l_first_event_id, l_last_event_id)

Line 162350: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );

162346: l_last_event_id := l_array_header_events(l_array_header_events.LAST);
162347:
162348: fnd_file.put_line(fnd_file.LOG, ' ');
162349: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
162350: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );
162351: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');
162352:
162353: FOR line_record IN line_cur(l_first_event_id, l_last_event_id)
162354: LOOP

Line 162351: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');

162347:
162348: fnd_file.put_line(fnd_file.LOG, ' ');
162349: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
162350: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );
162351: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');
162352:
162353: FOR line_record IN line_cur(l_first_event_id, l_last_event_id)
162354: LOOP
162355: IF (NOT l_array_header_events.EXISTS(line_record.event_id)) AND (NOT l_array_duplicate_checker.EXISTS(line_record.event_id)) THEN

Line 162356: fnd_file.put_line(fnd_file.log, 'Event_id = ' || line_record.event_id);

162352:
162353: FOR line_record IN line_cur(l_first_event_id, l_last_event_id)
162354: LOOP
162355: IF (NOT l_array_header_events.EXISTS(line_record.event_id)) AND (NOT l_array_duplicate_checker.EXISTS(line_record.event_id)) THEN
162356: fnd_file.put_line(fnd_file.log, 'Event_id = ' || line_record.event_id);
162357: l_array_duplicate_checker(line_record.event_id) := line_record.event_id;
162358: END IF;
162359: END LOOP;
162360:

Line 162361: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');

162357: l_array_duplicate_checker(line_record.event_id) := line_record.event_id;
162358: END IF;
162359: END LOOP;
162360:
162361: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
162362: fnd_file.put_line(fnd_file.LOG, ' ');
162363:
162364:
162365: xla_exceptions_pkg.raise_message

Line 162362: fnd_file.put_line(fnd_file.LOG, ' ');

162358: END IF;
162359: END LOOP;
162360:
162361: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
162362: fnd_file.put_line(fnd_file.LOG, ' ');
162363:
162364:
162365: xla_exceptions_pkg.raise_message
162366: (p_location => 'XLA_00555_AAD_S_000001_PKG.EventType_282');

Line 163554: fnd_file.put_line(fnd_file.LOG, ' ');

163550:
163551: l_first_event_id := l_array_header_events(l_array_header_events.FIRST);
163552: l_last_event_id := l_array_header_events(l_array_header_events.LAST);
163553:
163554: fnd_file.put_line(fnd_file.LOG, ' ');
163555: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
163556: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );
163557: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');
163558:

Line 163555: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');

163551: l_first_event_id := l_array_header_events(l_array_header_events.FIRST);
163552: l_last_event_id := l_array_header_events(l_array_header_events.LAST);
163553:
163554: fnd_file.put_line(fnd_file.LOG, ' ');
163555: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
163556: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );
163557: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');
163558:
163559: FOR line_record IN line_cur(l_first_event_id, l_last_event_id)

Line 163556: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );

163552: l_last_event_id := l_array_header_events(l_array_header_events.LAST);
163553:
163554: fnd_file.put_line(fnd_file.LOG, ' ');
163555: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
163556: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );
163557: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');
163558:
163559: FOR line_record IN line_cur(l_first_event_id, l_last_event_id)
163560: LOOP

Line 163557: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');

163553:
163554: fnd_file.put_line(fnd_file.LOG, ' ');
163555: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
163556: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );
163557: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');
163558:
163559: FOR line_record IN line_cur(l_first_event_id, l_last_event_id)
163560: LOOP
163561: IF (NOT l_array_header_events.EXISTS(line_record.event_id)) AND (NOT l_array_duplicate_checker.EXISTS(line_record.event_id)) THEN

Line 163562: fnd_file.put_line(fnd_file.log, 'Event_id = ' || line_record.event_id);

163558:
163559: FOR line_record IN line_cur(l_first_event_id, l_last_event_id)
163560: LOOP
163561: IF (NOT l_array_header_events.EXISTS(line_record.event_id)) AND (NOT l_array_duplicate_checker.EXISTS(line_record.event_id)) THEN
163562: fnd_file.put_line(fnd_file.log, 'Event_id = ' || line_record.event_id);
163563: l_array_duplicate_checker(line_record.event_id) := line_record.event_id;
163564: END IF;
163565: END LOOP;
163566:

Line 163567: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');

163563: l_array_duplicate_checker(line_record.event_id) := line_record.event_id;
163564: END IF;
163565: END LOOP;
163566:
163567: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
163568: fnd_file.put_line(fnd_file.LOG, ' ');
163569:
163570:
163571: xla_exceptions_pkg.raise_message

Line 163568: fnd_file.put_line(fnd_file.LOG, ' ');

163564: END IF;
163565: END LOOP;
163566:
163567: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
163568: fnd_file.put_line(fnd_file.LOG, ' ');
163569:
163570:
163571: xla_exceptions_pkg.raise_message
163572: (p_location => 'XLA_00555_AAD_S_000001_PKG.EventType_283');

Line 164760: fnd_file.put_line(fnd_file.LOG, ' ');

164756:
164757: l_first_event_id := l_array_header_events(l_array_header_events.FIRST);
164758: l_last_event_id := l_array_header_events(l_array_header_events.LAST);
164759:
164760: fnd_file.put_line(fnd_file.LOG, ' ');
164761: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
164762: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );
164763: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');
164764:

Line 164761: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');

164757: l_first_event_id := l_array_header_events(l_array_header_events.FIRST);
164758: l_last_event_id := l_array_header_events(l_array_header_events.LAST);
164759:
164760: fnd_file.put_line(fnd_file.LOG, ' ');
164761: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
164762: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );
164763: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');
164764:
164765: FOR line_record IN line_cur(l_first_event_id, l_last_event_id)

Line 164762: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );

164758: l_last_event_id := l_array_header_events(l_array_header_events.LAST);
164759:
164760: fnd_file.put_line(fnd_file.LOG, ' ');
164761: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
164762: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );
164763: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');
164764:
164765: FOR line_record IN line_cur(l_first_event_id, l_last_event_id)
164766: LOOP

Line 164763: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');

164759:
164760: fnd_file.put_line(fnd_file.LOG, ' ');
164761: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
164762: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );
164763: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');
164764:
164765: FOR line_record IN line_cur(l_first_event_id, l_last_event_id)
164766: LOOP
164767: IF (NOT l_array_header_events.EXISTS(line_record.event_id)) AND (NOT l_array_duplicate_checker.EXISTS(line_record.event_id)) THEN

Line 164768: fnd_file.put_line(fnd_file.log, 'Event_id = ' || line_record.event_id);

164764:
164765: FOR line_record IN line_cur(l_first_event_id, l_last_event_id)
164766: LOOP
164767: IF (NOT l_array_header_events.EXISTS(line_record.event_id)) AND (NOT l_array_duplicate_checker.EXISTS(line_record.event_id)) THEN
164768: fnd_file.put_line(fnd_file.log, 'Event_id = ' || line_record.event_id);
164769: l_array_duplicate_checker(line_record.event_id) := line_record.event_id;
164770: END IF;
164771: END LOOP;
164772:

Line 164773: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');

164769: l_array_duplicate_checker(line_record.event_id) := line_record.event_id;
164770: END IF;
164771: END LOOP;
164772:
164773: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
164774: fnd_file.put_line(fnd_file.LOG, ' ');
164775:
164776:
164777: xla_exceptions_pkg.raise_message

Line 164774: fnd_file.put_line(fnd_file.LOG, ' ');

164770: END IF;
164771: END LOOP;
164772:
164773: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
164774: fnd_file.put_line(fnd_file.LOG, ' ');
164775:
164776:
164777: xla_exceptions_pkg.raise_message
164778: (p_location => 'XLA_00555_AAD_S_000001_PKG.EventType_284');

Line 165966: fnd_file.put_line(fnd_file.LOG, ' ');

165962:
165963: l_first_event_id := l_array_header_events(l_array_header_events.FIRST);
165964: l_last_event_id := l_array_header_events(l_array_header_events.LAST);
165965:
165966: fnd_file.put_line(fnd_file.LOG, ' ');
165967: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
165968: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );
165969: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');
165970:

Line 165967: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');

165963: l_first_event_id := l_array_header_events(l_array_header_events.FIRST);
165964: l_last_event_id := l_array_header_events(l_array_header_events.LAST);
165965:
165966: fnd_file.put_line(fnd_file.LOG, ' ');
165967: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
165968: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );
165969: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');
165970:
165971: FOR line_record IN line_cur(l_first_event_id, l_last_event_id)

Line 165968: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );

165964: l_last_event_id := l_array_header_events(l_array_header_events.LAST);
165965:
165966: fnd_file.put_line(fnd_file.LOG, ' ');
165967: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
165968: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );
165969: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');
165970:
165971: FOR line_record IN line_cur(l_first_event_id, l_last_event_id)
165972: LOOP

Line 165969: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');

165965:
165966: fnd_file.put_line(fnd_file.LOG, ' ');
165967: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
165968: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );
165969: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');
165970:
165971: FOR line_record IN line_cur(l_first_event_id, l_last_event_id)
165972: LOOP
165973: IF (NOT l_array_header_events.EXISTS(line_record.event_id)) AND (NOT l_array_duplicate_checker.EXISTS(line_record.event_id)) THEN

Line 165974: fnd_file.put_line(fnd_file.log, 'Event_id = ' || line_record.event_id);

165970:
165971: FOR line_record IN line_cur(l_first_event_id, l_last_event_id)
165972: LOOP
165973: IF (NOT l_array_header_events.EXISTS(line_record.event_id)) AND (NOT l_array_duplicate_checker.EXISTS(line_record.event_id)) THEN
165974: fnd_file.put_line(fnd_file.log, 'Event_id = ' || line_record.event_id);
165975: l_array_duplicate_checker(line_record.event_id) := line_record.event_id;
165976: END IF;
165977: END LOOP;
165978:

Line 165979: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');

165975: l_array_duplicate_checker(line_record.event_id) := line_record.event_id;
165976: END IF;
165977: END LOOP;
165978:
165979: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
165980: fnd_file.put_line(fnd_file.LOG, ' ');
165981:
165982:
165983: xla_exceptions_pkg.raise_message

Line 165980: fnd_file.put_line(fnd_file.LOG, ' ');

165976: END IF;
165977: END LOOP;
165978:
165979: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
165980: fnd_file.put_line(fnd_file.LOG, ' ');
165981:
165982:
165983: xla_exceptions_pkg.raise_message
165984: (p_location => 'XLA_00555_AAD_S_000001_PKG.EventType_285');

Line 167172: fnd_file.put_line(fnd_file.LOG, ' ');

167168:
167169: l_first_event_id := l_array_header_events(l_array_header_events.FIRST);
167170: l_last_event_id := l_array_header_events(l_array_header_events.LAST);
167171:
167172: fnd_file.put_line(fnd_file.LOG, ' ');
167173: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
167174: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );
167175: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');
167176:

Line 167173: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');

167169: l_first_event_id := l_array_header_events(l_array_header_events.FIRST);
167170: l_last_event_id := l_array_header_events(l_array_header_events.LAST);
167171:
167172: fnd_file.put_line(fnd_file.LOG, ' ');
167173: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
167174: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );
167175: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');
167176:
167177: FOR line_record IN line_cur(l_first_event_id, l_last_event_id)

Line 167174: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );

167170: l_last_event_id := l_array_header_events(l_array_header_events.LAST);
167171:
167172: fnd_file.put_line(fnd_file.LOG, ' ');
167173: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
167174: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );
167175: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');
167176:
167177: FOR line_record IN line_cur(l_first_event_id, l_last_event_id)
167178: LOOP

Line 167175: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');

167171:
167172: fnd_file.put_line(fnd_file.LOG, ' ');
167173: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
167174: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );
167175: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');
167176:
167177: FOR line_record IN line_cur(l_first_event_id, l_last_event_id)
167178: LOOP
167179: IF (NOT l_array_header_events.EXISTS(line_record.event_id)) AND (NOT l_array_duplicate_checker.EXISTS(line_record.event_id)) THEN

Line 167180: fnd_file.put_line(fnd_file.log, 'Event_id = ' || line_record.event_id);

167176:
167177: FOR line_record IN line_cur(l_first_event_id, l_last_event_id)
167178: LOOP
167179: IF (NOT l_array_header_events.EXISTS(line_record.event_id)) AND (NOT l_array_duplicate_checker.EXISTS(line_record.event_id)) THEN
167180: fnd_file.put_line(fnd_file.log, 'Event_id = ' || line_record.event_id);
167181: l_array_duplicate_checker(line_record.event_id) := line_record.event_id;
167182: END IF;
167183: END LOOP;
167184:

Line 167185: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');

167181: l_array_duplicate_checker(line_record.event_id) := line_record.event_id;
167182: END IF;
167183: END LOOP;
167184:
167185: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
167186: fnd_file.put_line(fnd_file.LOG, ' ');
167187:
167188:
167189: xla_exceptions_pkg.raise_message

Line 167186: fnd_file.put_line(fnd_file.LOG, ' ');

167182: END IF;
167183: END LOOP;
167184:
167185: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
167186: fnd_file.put_line(fnd_file.LOG, ' ');
167187:
167188:
167189: xla_exceptions_pkg.raise_message
167190: (p_location => 'XLA_00555_AAD_S_000001_PKG.EventType_286');

Line 168378: fnd_file.put_line(fnd_file.LOG, ' ');

168374:
168375: l_first_event_id := l_array_header_events(l_array_header_events.FIRST);
168376: l_last_event_id := l_array_header_events(l_array_header_events.LAST);
168377:
168378: fnd_file.put_line(fnd_file.LOG, ' ');
168379: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
168380: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );
168381: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');
168382:

Line 168379: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');

168375: l_first_event_id := l_array_header_events(l_array_header_events.FIRST);
168376: l_last_event_id := l_array_header_events(l_array_header_events.LAST);
168377:
168378: fnd_file.put_line(fnd_file.LOG, ' ');
168379: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
168380: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );
168381: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');
168382:
168383: FOR line_record IN line_cur(l_first_event_id, l_last_event_id)

Line 168380: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );

168376: l_last_event_id := l_array_header_events(l_array_header_events.LAST);
168377:
168378: fnd_file.put_line(fnd_file.LOG, ' ');
168379: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
168380: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );
168381: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');
168382:
168383: FOR line_record IN line_cur(l_first_event_id, l_last_event_id)
168384: LOOP

Line 168381: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');

168377:
168378: fnd_file.put_line(fnd_file.LOG, ' ');
168379: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
168380: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );
168381: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');
168382:
168383: FOR line_record IN line_cur(l_first_event_id, l_last_event_id)
168384: LOOP
168385: IF (NOT l_array_header_events.EXISTS(line_record.event_id)) AND (NOT l_array_duplicate_checker.EXISTS(line_record.event_id)) THEN

Line 168386: fnd_file.put_line(fnd_file.log, 'Event_id = ' || line_record.event_id);

168382:
168383: FOR line_record IN line_cur(l_first_event_id, l_last_event_id)
168384: LOOP
168385: IF (NOT l_array_header_events.EXISTS(line_record.event_id)) AND (NOT l_array_duplicate_checker.EXISTS(line_record.event_id)) THEN
168386: fnd_file.put_line(fnd_file.log, 'Event_id = ' || line_record.event_id);
168387: l_array_duplicate_checker(line_record.event_id) := line_record.event_id;
168388: END IF;
168389: END LOOP;
168390:

Line 168391: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');

168387: l_array_duplicate_checker(line_record.event_id) := line_record.event_id;
168388: END IF;
168389: END LOOP;
168390:
168391: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
168392: fnd_file.put_line(fnd_file.LOG, ' ');
168393:
168394:
168395: xla_exceptions_pkg.raise_message

Line 168392: fnd_file.put_line(fnd_file.LOG, ' ');

168388: END IF;
168389: END LOOP;
168390:
168391: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
168392: fnd_file.put_line(fnd_file.LOG, ' ');
168393:
168394:
168395: xla_exceptions_pkg.raise_message
168396: (p_location => 'XLA_00555_AAD_S_000001_PKG.EventType_287');

Line 169584: fnd_file.put_line(fnd_file.LOG, ' ');

169580:
169581: l_first_event_id := l_array_header_events(l_array_header_events.FIRST);
169582: l_last_event_id := l_array_header_events(l_array_header_events.LAST);
169583:
169584: fnd_file.put_line(fnd_file.LOG, ' ');
169585: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
169586: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );
169587: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');
169588:

Line 169585: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');

169581: l_first_event_id := l_array_header_events(l_array_header_events.FIRST);
169582: l_last_event_id := l_array_header_events(l_array_header_events.LAST);
169583:
169584: fnd_file.put_line(fnd_file.LOG, ' ');
169585: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
169586: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );
169587: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');
169588:
169589: FOR line_record IN line_cur(l_first_event_id, l_last_event_id)

Line 169586: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );

169582: l_last_event_id := l_array_header_events(l_array_header_events.LAST);
169583:
169584: fnd_file.put_line(fnd_file.LOG, ' ');
169585: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
169586: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );
169587: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');
169588:
169589: FOR line_record IN line_cur(l_first_event_id, l_last_event_id)
169590: LOOP

Line 169587: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');

169583:
169584: fnd_file.put_line(fnd_file.LOG, ' ');
169585: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
169586: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );
169587: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');
169588:
169589: FOR line_record IN line_cur(l_first_event_id, l_last_event_id)
169590: LOOP
169591: IF (NOT l_array_header_events.EXISTS(line_record.event_id)) AND (NOT l_array_duplicate_checker.EXISTS(line_record.event_id)) THEN

Line 169592: fnd_file.put_line(fnd_file.log, 'Event_id = ' || line_record.event_id);

169588:
169589: FOR line_record IN line_cur(l_first_event_id, l_last_event_id)
169590: LOOP
169591: IF (NOT l_array_header_events.EXISTS(line_record.event_id)) AND (NOT l_array_duplicate_checker.EXISTS(line_record.event_id)) THEN
169592: fnd_file.put_line(fnd_file.log, 'Event_id = ' || line_record.event_id);
169593: l_array_duplicate_checker(line_record.event_id) := line_record.event_id;
169594: END IF;
169595: END LOOP;
169596:

Line 169597: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');

169593: l_array_duplicate_checker(line_record.event_id) := line_record.event_id;
169594: END IF;
169595: END LOOP;
169596:
169597: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
169598: fnd_file.put_line(fnd_file.LOG, ' ');
169599:
169600:
169601: xla_exceptions_pkg.raise_message

Line 169598: fnd_file.put_line(fnd_file.LOG, ' ');

169594: END IF;
169595: END LOOP;
169596:
169597: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
169598: fnd_file.put_line(fnd_file.LOG, ' ');
169599:
169600:
169601: xla_exceptions_pkg.raise_message
169602: (p_location => 'XLA_00555_AAD_S_000001_PKG.EventType_288');

Line 170762: fnd_file.put_line(fnd_file.LOG, ' ');

170758:
170759: l_first_event_id := l_array_header_events(l_array_header_events.FIRST);
170760: l_last_event_id := l_array_header_events(l_array_header_events.LAST);
170761:
170762: fnd_file.put_line(fnd_file.LOG, ' ');
170763: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
170764: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );
170765: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');
170766:

Line 170763: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');

170759: l_first_event_id := l_array_header_events(l_array_header_events.FIRST);
170760: l_last_event_id := l_array_header_events(l_array_header_events.LAST);
170761:
170762: fnd_file.put_line(fnd_file.LOG, ' ');
170763: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
170764: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );
170765: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');
170766:
170767: FOR line_record IN line_cur(l_first_event_id, l_last_event_id)

Line 170764: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );

170760: l_last_event_id := l_array_header_events(l_array_header_events.LAST);
170761:
170762: fnd_file.put_line(fnd_file.LOG, ' ');
170763: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
170764: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );
170765: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');
170766:
170767: FOR line_record IN line_cur(l_first_event_id, l_last_event_id)
170768: LOOP

Line 170765: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');

170761:
170762: fnd_file.put_line(fnd_file.LOG, ' ');
170763: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
170764: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );
170765: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');
170766:
170767: FOR line_record IN line_cur(l_first_event_id, l_last_event_id)
170768: LOOP
170769: IF (NOT l_array_header_events.EXISTS(line_record.event_id)) AND (NOT l_array_duplicate_checker.EXISTS(line_record.event_id)) THEN

Line 170770: fnd_file.put_line(fnd_file.log, 'Event_id = ' || line_record.event_id);

170766:
170767: FOR line_record IN line_cur(l_first_event_id, l_last_event_id)
170768: LOOP
170769: IF (NOT l_array_header_events.EXISTS(line_record.event_id)) AND (NOT l_array_duplicate_checker.EXISTS(line_record.event_id)) THEN
170770: fnd_file.put_line(fnd_file.log, 'Event_id = ' || line_record.event_id);
170771: l_array_duplicate_checker(line_record.event_id) := line_record.event_id;
170772: END IF;
170773: END LOOP;
170774:

Line 170775: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');

170771: l_array_duplicate_checker(line_record.event_id) := line_record.event_id;
170772: END IF;
170773: END LOOP;
170774:
170775: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
170776: fnd_file.put_line(fnd_file.LOG, ' ');
170777:
170778:
170779: xla_exceptions_pkg.raise_message

Line 170776: fnd_file.put_line(fnd_file.LOG, ' ');

170772: END IF;
170773: END LOOP;
170774:
170775: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
170776: fnd_file.put_line(fnd_file.LOG, ' ');
170777:
170778:
170779: xla_exceptions_pkg.raise_message
170780: (p_location => 'XLA_00555_AAD_S_000001_PKG.EventType_289');

Line 171968: fnd_file.put_line(fnd_file.LOG, ' ');

171964:
171965: l_first_event_id := l_array_header_events(l_array_header_events.FIRST);
171966: l_last_event_id := l_array_header_events(l_array_header_events.LAST);
171967:
171968: fnd_file.put_line(fnd_file.LOG, ' ');
171969: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
171970: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );
171971: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');
171972:

Line 171969: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');

171965: l_first_event_id := l_array_header_events(l_array_header_events.FIRST);
171966: l_last_event_id := l_array_header_events(l_array_header_events.LAST);
171967:
171968: fnd_file.put_line(fnd_file.LOG, ' ');
171969: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
171970: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );
171971: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');
171972:
171973: FOR line_record IN line_cur(l_first_event_id, l_last_event_id)

Line 171970: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );

171966: l_last_event_id := l_array_header_events(l_array_header_events.LAST);
171967:
171968: fnd_file.put_line(fnd_file.LOG, ' ');
171969: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
171970: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );
171971: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');
171972:
171973: FOR line_record IN line_cur(l_first_event_id, l_last_event_id)
171974: LOOP

Line 171971: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');

171967:
171968: fnd_file.put_line(fnd_file.LOG, ' ');
171969: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
171970: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );
171971: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');
171972:
171973: FOR line_record IN line_cur(l_first_event_id, l_last_event_id)
171974: LOOP
171975: IF (NOT l_array_header_events.EXISTS(line_record.event_id)) AND (NOT l_array_duplicate_checker.EXISTS(line_record.event_id)) THEN

Line 171976: fnd_file.put_line(fnd_file.log, 'Event_id = ' || line_record.event_id);

171972:
171973: FOR line_record IN line_cur(l_first_event_id, l_last_event_id)
171974: LOOP
171975: IF (NOT l_array_header_events.EXISTS(line_record.event_id)) AND (NOT l_array_duplicate_checker.EXISTS(line_record.event_id)) THEN
171976: fnd_file.put_line(fnd_file.log, 'Event_id = ' || line_record.event_id);
171977: l_array_duplicate_checker(line_record.event_id) := line_record.event_id;
171978: END IF;
171979: END LOOP;
171980:

Line 171981: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');

171977: l_array_duplicate_checker(line_record.event_id) := line_record.event_id;
171978: END IF;
171979: END LOOP;
171980:
171981: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
171982: fnd_file.put_line(fnd_file.LOG, ' ');
171983:
171984:
171985: xla_exceptions_pkg.raise_message

Line 171982: fnd_file.put_line(fnd_file.LOG, ' ');

171978: END IF;
171979: END LOOP;
171980:
171981: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
171982: fnd_file.put_line(fnd_file.LOG, ' ');
171983:
171984:
171985: xla_exceptions_pkg.raise_message
171986: (p_location => 'XLA_00555_AAD_S_000001_PKG.EventType_290');

Line 173146: fnd_file.put_line(fnd_file.LOG, ' ');

173142:
173143: l_first_event_id := l_array_header_events(l_array_header_events.FIRST);
173144: l_last_event_id := l_array_header_events(l_array_header_events.LAST);
173145:
173146: fnd_file.put_line(fnd_file.LOG, ' ');
173147: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
173148: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );
173149: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');
173150:

Line 173147: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');

173143: l_first_event_id := l_array_header_events(l_array_header_events.FIRST);
173144: l_last_event_id := l_array_header_events(l_array_header_events.LAST);
173145:
173146: fnd_file.put_line(fnd_file.LOG, ' ');
173147: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
173148: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );
173149: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');
173150:
173151: FOR line_record IN line_cur(l_first_event_id, l_last_event_id)

Line 173148: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );

173144: l_last_event_id := l_array_header_events(l_array_header_events.LAST);
173145:
173146: fnd_file.put_line(fnd_file.LOG, ' ');
173147: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
173148: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );
173149: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');
173150:
173151: FOR line_record IN line_cur(l_first_event_id, l_last_event_id)
173152: LOOP

Line 173149: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');

173145:
173146: fnd_file.put_line(fnd_file.LOG, ' ');
173147: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
173148: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );
173149: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');
173150:
173151: FOR line_record IN line_cur(l_first_event_id, l_last_event_id)
173152: LOOP
173153: IF (NOT l_array_header_events.EXISTS(line_record.event_id)) AND (NOT l_array_duplicate_checker.EXISTS(line_record.event_id)) THEN

Line 173154: fnd_file.put_line(fnd_file.log, 'Event_id = ' || line_record.event_id);

173150:
173151: FOR line_record IN line_cur(l_first_event_id, l_last_event_id)
173152: LOOP
173153: IF (NOT l_array_header_events.EXISTS(line_record.event_id)) AND (NOT l_array_duplicate_checker.EXISTS(line_record.event_id)) THEN
173154: fnd_file.put_line(fnd_file.log, 'Event_id = ' || line_record.event_id);
173155: l_array_duplicate_checker(line_record.event_id) := line_record.event_id;
173156: END IF;
173157: END LOOP;
173158:

Line 173159: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');

173155: l_array_duplicate_checker(line_record.event_id) := line_record.event_id;
173156: END IF;
173157: END LOOP;
173158:
173159: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
173160: fnd_file.put_line(fnd_file.LOG, ' ');
173161:
173162:
173163: xla_exceptions_pkg.raise_message

Line 173160: fnd_file.put_line(fnd_file.LOG, ' ');

173156: END IF;
173157: END LOOP;
173158:
173159: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
173160: fnd_file.put_line(fnd_file.LOG, ' ');
173161:
173162:
173163: xla_exceptions_pkg.raise_message
173164: (p_location => 'XLA_00555_AAD_S_000001_PKG.EventType_291');

Line 174312: fnd_file.put_line(fnd_file.LOG, ' ');

174308:
174309: l_first_event_id := l_array_header_events(l_array_header_events.FIRST);
174310: l_last_event_id := l_array_header_events(l_array_header_events.LAST);
174311:
174312: fnd_file.put_line(fnd_file.LOG, ' ');
174313: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
174314: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );
174315: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');
174316:

Line 174313: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');

174309: l_first_event_id := l_array_header_events(l_array_header_events.FIRST);
174310: l_last_event_id := l_array_header_events(l_array_header_events.LAST);
174311:
174312: fnd_file.put_line(fnd_file.LOG, ' ');
174313: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
174314: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );
174315: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');
174316:
174317: FOR line_record IN line_cur(l_first_event_id, l_last_event_id)

Line 174314: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );

174310: l_last_event_id := l_array_header_events(l_array_header_events.LAST);
174311:
174312: fnd_file.put_line(fnd_file.LOG, ' ');
174313: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
174314: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );
174315: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');
174316:
174317: FOR line_record IN line_cur(l_first_event_id, l_last_event_id)
174318: LOOP

Line 174315: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');

174311:
174312: fnd_file.put_line(fnd_file.LOG, ' ');
174313: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
174314: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );
174315: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');
174316:
174317: FOR line_record IN line_cur(l_first_event_id, l_last_event_id)
174318: LOOP
174319: IF (NOT l_array_header_events.EXISTS(line_record.event_id)) AND (NOT l_array_duplicate_checker.EXISTS(line_record.event_id)) THEN

Line 174320: fnd_file.put_line(fnd_file.log, 'Event_id = ' || line_record.event_id);

174316:
174317: FOR line_record IN line_cur(l_first_event_id, l_last_event_id)
174318: LOOP
174319: IF (NOT l_array_header_events.EXISTS(line_record.event_id)) AND (NOT l_array_duplicate_checker.EXISTS(line_record.event_id)) THEN
174320: fnd_file.put_line(fnd_file.log, 'Event_id = ' || line_record.event_id);
174321: l_array_duplicate_checker(line_record.event_id) := line_record.event_id;
174322: END IF;
174323: END LOOP;
174324:

Line 174325: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');

174321: l_array_duplicate_checker(line_record.event_id) := line_record.event_id;
174322: END IF;
174323: END LOOP;
174324:
174325: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
174326: fnd_file.put_line(fnd_file.LOG, ' ');
174327:
174328:
174329: xla_exceptions_pkg.raise_message

Line 174326: fnd_file.put_line(fnd_file.LOG, ' ');

174322: END IF;
174323: END LOOP;
174324:
174325: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
174326: fnd_file.put_line(fnd_file.LOG, ' ');
174327:
174328:
174329: xla_exceptions_pkg.raise_message
174330: (p_location => 'XLA_00555_AAD_S_000001_PKG.EventClass_292');

Line 175602: fnd_file.put_line(fnd_file.LOG, ' ');

175598:
175599: l_first_event_id := l_array_header_events(l_array_header_events.FIRST);
175600: l_last_event_id := l_array_header_events(l_array_header_events.LAST);
175601:
175602: fnd_file.put_line(fnd_file.LOG, ' ');
175603: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
175604: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );
175605: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');
175606:

Line 175603: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');

175599: l_first_event_id := l_array_header_events(l_array_header_events.FIRST);
175600: l_last_event_id := l_array_header_events(l_array_header_events.LAST);
175601:
175602: fnd_file.put_line(fnd_file.LOG, ' ');
175603: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
175604: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );
175605: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');
175606:
175607: FOR line_record IN line_cur(l_first_event_id, l_last_event_id)

Line 175604: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );

175600: l_last_event_id := l_array_header_events(l_array_header_events.LAST);
175601:
175602: fnd_file.put_line(fnd_file.LOG, ' ');
175603: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
175604: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );
175605: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');
175606:
175607: FOR line_record IN line_cur(l_first_event_id, l_last_event_id)
175608: LOOP

Line 175605: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');

175601:
175602: fnd_file.put_line(fnd_file.LOG, ' ');
175603: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
175604: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );
175605: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');
175606:
175607: FOR line_record IN line_cur(l_first_event_id, l_last_event_id)
175608: LOOP
175609: IF (NOT l_array_header_events.EXISTS(line_record.event_id)) AND (NOT l_array_duplicate_checker.EXISTS(line_record.event_id)) THEN

Line 175610: fnd_file.put_line(fnd_file.log, 'Event_id = ' || line_record.event_id);

175606:
175607: FOR line_record IN line_cur(l_first_event_id, l_last_event_id)
175608: LOOP
175609: IF (NOT l_array_header_events.EXISTS(line_record.event_id)) AND (NOT l_array_duplicate_checker.EXISTS(line_record.event_id)) THEN
175610: fnd_file.put_line(fnd_file.log, 'Event_id = ' || line_record.event_id);
175611: l_array_duplicate_checker(line_record.event_id) := line_record.event_id;
175612: END IF;
175613: END LOOP;
175614:

Line 175615: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');

175611: l_array_duplicate_checker(line_record.event_id) := line_record.event_id;
175612: END IF;
175613: END LOOP;
175614:
175615: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
175616: fnd_file.put_line(fnd_file.LOG, ' ');
175617:
175618:
175619: xla_exceptions_pkg.raise_message

Line 175616: fnd_file.put_line(fnd_file.LOG, ' ');

175612: END IF;
175613: END LOOP;
175614:
175615: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
175616: fnd_file.put_line(fnd_file.LOG, ' ');
175617:
175618:
175619: xla_exceptions_pkg.raise_message
175620: (p_location => 'XLA_00555_AAD_S_000001_PKG.EventType_293');

Line 176892: fnd_file.put_line(fnd_file.LOG, ' ');

176888:
176889: l_first_event_id := l_array_header_events(l_array_header_events.FIRST);
176890: l_last_event_id := l_array_header_events(l_array_header_events.LAST);
176891:
176892: fnd_file.put_line(fnd_file.LOG, ' ');
176893: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
176894: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );
176895: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');
176896:

Line 176893: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');

176889: l_first_event_id := l_array_header_events(l_array_header_events.FIRST);
176890: l_last_event_id := l_array_header_events(l_array_header_events.LAST);
176891:
176892: fnd_file.put_line(fnd_file.LOG, ' ');
176893: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
176894: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );
176895: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');
176896:
176897: FOR line_record IN line_cur(l_first_event_id, l_last_event_id)

Line 176894: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );

176890: l_last_event_id := l_array_header_events(l_array_header_events.LAST);
176891:
176892: fnd_file.put_line(fnd_file.LOG, ' ');
176893: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
176894: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );
176895: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');
176896:
176897: FOR line_record IN line_cur(l_first_event_id, l_last_event_id)
176898: LOOP

Line 176895: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');

176891:
176892: fnd_file.put_line(fnd_file.LOG, ' ');
176893: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
176894: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );
176895: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');
176896:
176897: FOR line_record IN line_cur(l_first_event_id, l_last_event_id)
176898: LOOP
176899: IF (NOT l_array_header_events.EXISTS(line_record.event_id)) AND (NOT l_array_duplicate_checker.EXISTS(line_record.event_id)) THEN

Line 176900: fnd_file.put_line(fnd_file.log, 'Event_id = ' || line_record.event_id);

176896:
176897: FOR line_record IN line_cur(l_first_event_id, l_last_event_id)
176898: LOOP
176899: IF (NOT l_array_header_events.EXISTS(line_record.event_id)) AND (NOT l_array_duplicate_checker.EXISTS(line_record.event_id)) THEN
176900: fnd_file.put_line(fnd_file.log, 'Event_id = ' || line_record.event_id);
176901: l_array_duplicate_checker(line_record.event_id) := line_record.event_id;
176902: END IF;
176903: END LOOP;
176904:

Line 176905: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');

176901: l_array_duplicate_checker(line_record.event_id) := line_record.event_id;
176902: END IF;
176903: END LOOP;
176904:
176905: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
176906: fnd_file.put_line(fnd_file.LOG, ' ');
176907:
176908:
176909: xla_exceptions_pkg.raise_message

Line 176906: fnd_file.put_line(fnd_file.LOG, ' ');

176902: END IF;
176903: END LOOP;
176904:
176905: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
176906: fnd_file.put_line(fnd_file.LOG, ' ');
176907:
176908:
176909: xla_exceptions_pkg.raise_message
176910: (p_location => 'XLA_00555_AAD_S_000001_PKG.EventType_294');

Line 178098: fnd_file.put_line(fnd_file.LOG, ' ');

178094:
178095: l_first_event_id := l_array_header_events(l_array_header_events.FIRST);
178096: l_last_event_id := l_array_header_events(l_array_header_events.LAST);
178097:
178098: fnd_file.put_line(fnd_file.LOG, ' ');
178099: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
178100: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );
178101: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');
178102:

Line 178099: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');

178095: l_first_event_id := l_array_header_events(l_array_header_events.FIRST);
178096: l_last_event_id := l_array_header_events(l_array_header_events.LAST);
178097:
178098: fnd_file.put_line(fnd_file.LOG, ' ');
178099: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
178100: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );
178101: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');
178102:
178103: FOR line_record IN line_cur(l_first_event_id, l_last_event_id)

Line 178100: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );

178096: l_last_event_id := l_array_header_events(l_array_header_events.LAST);
178097:
178098: fnd_file.put_line(fnd_file.LOG, ' ');
178099: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
178100: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );
178101: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');
178102:
178103: FOR line_record IN line_cur(l_first_event_id, l_last_event_id)
178104: LOOP

Line 178101: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');

178097:
178098: fnd_file.put_line(fnd_file.LOG, ' ');
178099: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
178100: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );
178101: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');
178102:
178103: FOR line_record IN line_cur(l_first_event_id, l_last_event_id)
178104: LOOP
178105: IF (NOT l_array_header_events.EXISTS(line_record.event_id)) AND (NOT l_array_duplicate_checker.EXISTS(line_record.event_id)) THEN

Line 178106: fnd_file.put_line(fnd_file.log, 'Event_id = ' || line_record.event_id);

178102:
178103: FOR line_record IN line_cur(l_first_event_id, l_last_event_id)
178104: LOOP
178105: IF (NOT l_array_header_events.EXISTS(line_record.event_id)) AND (NOT l_array_duplicate_checker.EXISTS(line_record.event_id)) THEN
178106: fnd_file.put_line(fnd_file.log, 'Event_id = ' || line_record.event_id);
178107: l_array_duplicate_checker(line_record.event_id) := line_record.event_id;
178108: END IF;
178109: END LOOP;
178110:

Line 178111: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');

178107: l_array_duplicate_checker(line_record.event_id) := line_record.event_id;
178108: END IF;
178109: END LOOP;
178110:
178111: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
178112: fnd_file.put_line(fnd_file.LOG, ' ');
178113:
178114:
178115: xla_exceptions_pkg.raise_message

Line 178112: fnd_file.put_line(fnd_file.LOG, ' ');

178108: END IF;
178109: END LOOP;
178110:
178111: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
178112: fnd_file.put_line(fnd_file.LOG, ' ');
178113:
178114:
178115: xla_exceptions_pkg.raise_message
178116: (p_location => 'XLA_00555_AAD_S_000001_PKG.EventType_295');

Line 179276: fnd_file.put_line(fnd_file.LOG, ' ');

179272:
179273: l_first_event_id := l_array_header_events(l_array_header_events.FIRST);
179274: l_last_event_id := l_array_header_events(l_array_header_events.LAST);
179275:
179276: fnd_file.put_line(fnd_file.LOG, ' ');
179277: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
179278: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );
179279: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');
179280:

Line 179277: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');

179273: l_first_event_id := l_array_header_events(l_array_header_events.FIRST);
179274: l_last_event_id := l_array_header_events(l_array_header_events.LAST);
179275:
179276: fnd_file.put_line(fnd_file.LOG, ' ');
179277: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
179278: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );
179279: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');
179280:
179281: FOR line_record IN line_cur(l_first_event_id, l_last_event_id)

Line 179278: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );

179274: l_last_event_id := l_array_header_events(l_array_header_events.LAST);
179275:
179276: fnd_file.put_line(fnd_file.LOG, ' ');
179277: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
179278: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );
179279: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');
179280:
179281: FOR line_record IN line_cur(l_first_event_id, l_last_event_id)
179282: LOOP

Line 179279: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');

179275:
179276: fnd_file.put_line(fnd_file.LOG, ' ');
179277: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
179278: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );
179279: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');
179280:
179281: FOR line_record IN line_cur(l_first_event_id, l_last_event_id)
179282: LOOP
179283: IF (NOT l_array_header_events.EXISTS(line_record.event_id)) AND (NOT l_array_duplicate_checker.EXISTS(line_record.event_id)) THEN

Line 179284: fnd_file.put_line(fnd_file.log, 'Event_id = ' || line_record.event_id);

179280:
179281: FOR line_record IN line_cur(l_first_event_id, l_last_event_id)
179282: LOOP
179283: IF (NOT l_array_header_events.EXISTS(line_record.event_id)) AND (NOT l_array_duplicate_checker.EXISTS(line_record.event_id)) THEN
179284: fnd_file.put_line(fnd_file.log, 'Event_id = ' || line_record.event_id);
179285: l_array_duplicate_checker(line_record.event_id) := line_record.event_id;
179286: END IF;
179287: END LOOP;
179288:

Line 179289: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');

179285: l_array_duplicate_checker(line_record.event_id) := line_record.event_id;
179286: END IF;
179287: END LOOP;
179288:
179289: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
179290: fnd_file.put_line(fnd_file.LOG, ' ');
179291:
179292:
179293: xla_exceptions_pkg.raise_message

Line 179290: fnd_file.put_line(fnd_file.LOG, ' ');

179286: END IF;
179287: END LOOP;
179288:
179289: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
179290: fnd_file.put_line(fnd_file.LOG, ' ');
179291:
179292:
179293: xla_exceptions_pkg.raise_message
179294: (p_location => 'XLA_00555_AAD_S_000001_PKG.EventType_296');

Line 180454: fnd_file.put_line(fnd_file.LOG, ' ');

180450:
180451: l_first_event_id := l_array_header_events(l_array_header_events.FIRST);
180452: l_last_event_id := l_array_header_events(l_array_header_events.LAST);
180453:
180454: fnd_file.put_line(fnd_file.LOG, ' ');
180455: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
180456: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );
180457: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');
180458:

Line 180455: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');

180451: l_first_event_id := l_array_header_events(l_array_header_events.FIRST);
180452: l_last_event_id := l_array_header_events(l_array_header_events.LAST);
180453:
180454: fnd_file.put_line(fnd_file.LOG, ' ');
180455: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
180456: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );
180457: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');
180458:
180459: FOR line_record IN line_cur(l_first_event_id, l_last_event_id)

Line 180456: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );

180452: l_last_event_id := l_array_header_events(l_array_header_events.LAST);
180453:
180454: fnd_file.put_line(fnd_file.LOG, ' ');
180455: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
180456: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );
180457: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');
180458:
180459: FOR line_record IN line_cur(l_first_event_id, l_last_event_id)
180460: LOOP

Line 180457: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');

180453:
180454: fnd_file.put_line(fnd_file.LOG, ' ');
180455: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
180456: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );
180457: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');
180458:
180459: FOR line_record IN line_cur(l_first_event_id, l_last_event_id)
180460: LOOP
180461: IF (NOT l_array_header_events.EXISTS(line_record.event_id)) AND (NOT l_array_duplicate_checker.EXISTS(line_record.event_id)) THEN

Line 180462: fnd_file.put_line(fnd_file.log, 'Event_id = ' || line_record.event_id);

180458:
180459: FOR line_record IN line_cur(l_first_event_id, l_last_event_id)
180460: LOOP
180461: IF (NOT l_array_header_events.EXISTS(line_record.event_id)) AND (NOT l_array_duplicate_checker.EXISTS(line_record.event_id)) THEN
180462: fnd_file.put_line(fnd_file.log, 'Event_id = ' || line_record.event_id);
180463: l_array_duplicate_checker(line_record.event_id) := line_record.event_id;
180464: END IF;
180465: END LOOP;
180466:

Line 180467: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');

180463: l_array_duplicate_checker(line_record.event_id) := line_record.event_id;
180464: END IF;
180465: END LOOP;
180466:
180467: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
180468: fnd_file.put_line(fnd_file.LOG, ' ');
180469:
180470:
180471: xla_exceptions_pkg.raise_message

Line 180468: fnd_file.put_line(fnd_file.LOG, ' ');

180464: END IF;
180465: END LOOP;
180466:
180467: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
180468: fnd_file.put_line(fnd_file.LOG, ' ');
180469:
180470:
180471: xla_exceptions_pkg.raise_message
180472: (p_location => 'XLA_00555_AAD_S_000001_PKG.EventType_297');

Line 181744: fnd_file.put_line(fnd_file.LOG, ' ');

181740:
181741: l_first_event_id := l_array_header_events(l_array_header_events.FIRST);
181742: l_last_event_id := l_array_header_events(l_array_header_events.LAST);
181743:
181744: fnd_file.put_line(fnd_file.LOG, ' ');
181745: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
181746: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );
181747: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');
181748:

Line 181745: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');

181741: l_first_event_id := l_array_header_events(l_array_header_events.FIRST);
181742: l_last_event_id := l_array_header_events(l_array_header_events.LAST);
181743:
181744: fnd_file.put_line(fnd_file.LOG, ' ');
181745: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
181746: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );
181747: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');
181748:
181749: FOR line_record IN line_cur(l_first_event_id, l_last_event_id)

Line 181746: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );

181742: l_last_event_id := l_array_header_events(l_array_header_events.LAST);
181743:
181744: fnd_file.put_line(fnd_file.LOG, ' ');
181745: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
181746: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );
181747: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');
181748:
181749: FOR line_record IN line_cur(l_first_event_id, l_last_event_id)
181750: LOOP

Line 181747: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');

181743:
181744: fnd_file.put_line(fnd_file.LOG, ' ');
181745: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
181746: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );
181747: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');
181748:
181749: FOR line_record IN line_cur(l_first_event_id, l_last_event_id)
181750: LOOP
181751: IF (NOT l_array_header_events.EXISTS(line_record.event_id)) AND (NOT l_array_duplicate_checker.EXISTS(line_record.event_id)) THEN

Line 181752: fnd_file.put_line(fnd_file.log, 'Event_id = ' || line_record.event_id);

181748:
181749: FOR line_record IN line_cur(l_first_event_id, l_last_event_id)
181750: LOOP
181751: IF (NOT l_array_header_events.EXISTS(line_record.event_id)) AND (NOT l_array_duplicate_checker.EXISTS(line_record.event_id)) THEN
181752: fnd_file.put_line(fnd_file.log, 'Event_id = ' || line_record.event_id);
181753: l_array_duplicate_checker(line_record.event_id) := line_record.event_id;
181754: END IF;
181755: END LOOP;
181756:

Line 181757: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');

181753: l_array_duplicate_checker(line_record.event_id) := line_record.event_id;
181754: END IF;
181755: END LOOP;
181756:
181757: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
181758: fnd_file.put_line(fnd_file.LOG, ' ');
181759:
181760:
181761: xla_exceptions_pkg.raise_message

Line 181758: fnd_file.put_line(fnd_file.LOG, ' ');

181754: END IF;
181755: END LOOP;
181756:
181757: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
181758: fnd_file.put_line(fnd_file.LOG, ' ');
181759:
181760:
181761: xla_exceptions_pkg.raise_message
181762: (p_location => 'XLA_00555_AAD_S_000001_PKG.EventType_298');

Line 182922: fnd_file.put_line(fnd_file.LOG, ' ');

182918:
182919: l_first_event_id := l_array_header_events(l_array_header_events.FIRST);
182920: l_last_event_id := l_array_header_events(l_array_header_events.LAST);
182921:
182922: fnd_file.put_line(fnd_file.LOG, ' ');
182923: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
182924: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );
182925: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');
182926:

Line 182923: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');

182919: l_first_event_id := l_array_header_events(l_array_header_events.FIRST);
182920: l_last_event_id := l_array_header_events(l_array_header_events.LAST);
182921:
182922: fnd_file.put_line(fnd_file.LOG, ' ');
182923: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
182924: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );
182925: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');
182926:
182927: FOR line_record IN line_cur(l_first_event_id, l_last_event_id)

Line 182924: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );

182920: l_last_event_id := l_array_header_events(l_array_header_events.LAST);
182921:
182922: fnd_file.put_line(fnd_file.LOG, ' ');
182923: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
182924: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );
182925: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');
182926:
182927: FOR line_record IN line_cur(l_first_event_id, l_last_event_id)
182928: LOOP

Line 182925: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');

182921:
182922: fnd_file.put_line(fnd_file.LOG, ' ');
182923: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
182924: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );
182925: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');
182926:
182927: FOR line_record IN line_cur(l_first_event_id, l_last_event_id)
182928: LOOP
182929: IF (NOT l_array_header_events.EXISTS(line_record.event_id)) AND (NOT l_array_duplicate_checker.EXISTS(line_record.event_id)) THEN

Line 182930: fnd_file.put_line(fnd_file.log, 'Event_id = ' || line_record.event_id);

182926:
182927: FOR line_record IN line_cur(l_first_event_id, l_last_event_id)
182928: LOOP
182929: IF (NOT l_array_header_events.EXISTS(line_record.event_id)) AND (NOT l_array_duplicate_checker.EXISTS(line_record.event_id)) THEN
182930: fnd_file.put_line(fnd_file.log, 'Event_id = ' || line_record.event_id);
182931: l_array_duplicate_checker(line_record.event_id) := line_record.event_id;
182932: END IF;
182933: END LOOP;
182934:

Line 182935: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');

182931: l_array_duplicate_checker(line_record.event_id) := line_record.event_id;
182932: END IF;
182933: END LOOP;
182934:
182935: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
182936: fnd_file.put_line(fnd_file.LOG, ' ');
182937:
182938:
182939: xla_exceptions_pkg.raise_message

Line 182936: fnd_file.put_line(fnd_file.LOG, ' ');

182932: END IF;
182933: END LOOP;
182934:
182935: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
182936: fnd_file.put_line(fnd_file.LOG, ' ');
182937:
182938:
182939: xla_exceptions_pkg.raise_message
182940: (p_location => 'XLA_00555_AAD_S_000001_PKG.EventType_299');

Line 184128: fnd_file.put_line(fnd_file.LOG, ' ');

184124:
184125: l_first_event_id := l_array_header_events(l_array_header_events.FIRST);
184126: l_last_event_id := l_array_header_events(l_array_header_events.LAST);
184127:
184128: fnd_file.put_line(fnd_file.LOG, ' ');
184129: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
184130: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );
184131: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');
184132:

Line 184129: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');

184125: l_first_event_id := l_array_header_events(l_array_header_events.FIRST);
184126: l_last_event_id := l_array_header_events(l_array_header_events.LAST);
184127:
184128: fnd_file.put_line(fnd_file.LOG, ' ');
184129: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
184130: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );
184131: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');
184132:
184133: FOR line_record IN line_cur(l_first_event_id, l_last_event_id)

Line 184130: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );

184126: l_last_event_id := l_array_header_events(l_array_header_events.LAST);
184127:
184128: fnd_file.put_line(fnd_file.LOG, ' ');
184129: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
184130: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );
184131: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');
184132:
184133: FOR line_record IN line_cur(l_first_event_id, l_last_event_id)
184134: LOOP

Line 184131: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');

184127:
184128: fnd_file.put_line(fnd_file.LOG, ' ');
184129: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
184130: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );
184131: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');
184132:
184133: FOR line_record IN line_cur(l_first_event_id, l_last_event_id)
184134: LOOP
184135: IF (NOT l_array_header_events.EXISTS(line_record.event_id)) AND (NOT l_array_duplicate_checker.EXISTS(line_record.event_id)) THEN

Line 184136: fnd_file.put_line(fnd_file.log, 'Event_id = ' || line_record.event_id);

184132:
184133: FOR line_record IN line_cur(l_first_event_id, l_last_event_id)
184134: LOOP
184135: IF (NOT l_array_header_events.EXISTS(line_record.event_id)) AND (NOT l_array_duplicate_checker.EXISTS(line_record.event_id)) THEN
184136: fnd_file.put_line(fnd_file.log, 'Event_id = ' || line_record.event_id);
184137: l_array_duplicate_checker(line_record.event_id) := line_record.event_id;
184138: END IF;
184139: END LOOP;
184140:

Line 184141: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');

184137: l_array_duplicate_checker(line_record.event_id) := line_record.event_id;
184138: END IF;
184139: END LOOP;
184140:
184141: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
184142: fnd_file.put_line(fnd_file.LOG, ' ');
184143:
184144:
184145: xla_exceptions_pkg.raise_message

Line 184142: fnd_file.put_line(fnd_file.LOG, ' ');

184138: END IF;
184139: END LOOP;
184140:
184141: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
184142: fnd_file.put_line(fnd_file.LOG, ' ');
184143:
184144:
184145: xla_exceptions_pkg.raise_message
184146: (p_location => 'XLA_00555_AAD_S_000001_PKG.EventClass_300');

Line 185306: fnd_file.put_line(fnd_file.LOG, ' ');

185302:
185303: l_first_event_id := l_array_header_events(l_array_header_events.FIRST);
185304: l_last_event_id := l_array_header_events(l_array_header_events.LAST);
185305:
185306: fnd_file.put_line(fnd_file.LOG, ' ');
185307: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
185308: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );
185309: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');
185310:

Line 185307: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');

185303: l_first_event_id := l_array_header_events(l_array_header_events.FIRST);
185304: l_last_event_id := l_array_header_events(l_array_header_events.LAST);
185305:
185306: fnd_file.put_line(fnd_file.LOG, ' ');
185307: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
185308: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );
185309: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');
185310:
185311: FOR line_record IN line_cur(l_first_event_id, l_last_event_id)

Line 185308: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );

185304: l_last_event_id := l_array_header_events(l_array_header_events.LAST);
185305:
185306: fnd_file.put_line(fnd_file.LOG, ' ');
185307: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
185308: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );
185309: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');
185310:
185311: FOR line_record IN line_cur(l_first_event_id, l_last_event_id)
185312: LOOP

Line 185309: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');

185305:
185306: fnd_file.put_line(fnd_file.LOG, ' ');
185307: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
185308: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );
185309: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');
185310:
185311: FOR line_record IN line_cur(l_first_event_id, l_last_event_id)
185312: LOOP
185313: IF (NOT l_array_header_events.EXISTS(line_record.event_id)) AND (NOT l_array_duplicate_checker.EXISTS(line_record.event_id)) THEN

Line 185314: fnd_file.put_line(fnd_file.log, 'Event_id = ' || line_record.event_id);

185310:
185311: FOR line_record IN line_cur(l_first_event_id, l_last_event_id)
185312: LOOP
185313: IF (NOT l_array_header_events.EXISTS(line_record.event_id)) AND (NOT l_array_duplicate_checker.EXISTS(line_record.event_id)) THEN
185314: fnd_file.put_line(fnd_file.log, 'Event_id = ' || line_record.event_id);
185315: l_array_duplicate_checker(line_record.event_id) := line_record.event_id;
185316: END IF;
185317: END LOOP;
185318:

Line 185319: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');

185315: l_array_duplicate_checker(line_record.event_id) := line_record.event_id;
185316: END IF;
185317: END LOOP;
185318:
185319: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
185320: fnd_file.put_line(fnd_file.LOG, ' ');
185321:
185322:
185323: xla_exceptions_pkg.raise_message

Line 185320: fnd_file.put_line(fnd_file.LOG, ' ');

185316: END IF;
185317: END LOOP;
185318:
185319: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
185320: fnd_file.put_line(fnd_file.LOG, ' ');
185321:
185322:
185323: xla_exceptions_pkg.raise_message
185324: (p_location => 'XLA_00555_AAD_S_000001_PKG.EventType_301');

Line 186484: fnd_file.put_line(fnd_file.LOG, ' ');

186480:
186481: l_first_event_id := l_array_header_events(l_array_header_events.FIRST);
186482: l_last_event_id := l_array_header_events(l_array_header_events.LAST);
186483:
186484: fnd_file.put_line(fnd_file.LOG, ' ');
186485: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
186486: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );
186487: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');
186488:

Line 186485: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');

186481: l_first_event_id := l_array_header_events(l_array_header_events.FIRST);
186482: l_last_event_id := l_array_header_events(l_array_header_events.LAST);
186483:
186484: fnd_file.put_line(fnd_file.LOG, ' ');
186485: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
186486: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );
186487: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');
186488:
186489: FOR line_record IN line_cur(l_first_event_id, l_last_event_id)

Line 186486: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );

186482: l_last_event_id := l_array_header_events(l_array_header_events.LAST);
186483:
186484: fnd_file.put_line(fnd_file.LOG, ' ');
186485: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
186486: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );
186487: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');
186488:
186489: FOR line_record IN line_cur(l_first_event_id, l_last_event_id)
186490: LOOP

Line 186487: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');

186483:
186484: fnd_file.put_line(fnd_file.LOG, ' ');
186485: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
186486: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );
186487: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');
186488:
186489: FOR line_record IN line_cur(l_first_event_id, l_last_event_id)
186490: LOOP
186491: IF (NOT l_array_header_events.EXISTS(line_record.event_id)) AND (NOT l_array_duplicate_checker.EXISTS(line_record.event_id)) THEN

Line 186492: fnd_file.put_line(fnd_file.log, 'Event_id = ' || line_record.event_id);

186488:
186489: FOR line_record IN line_cur(l_first_event_id, l_last_event_id)
186490: LOOP
186491: IF (NOT l_array_header_events.EXISTS(line_record.event_id)) AND (NOT l_array_duplicate_checker.EXISTS(line_record.event_id)) THEN
186492: fnd_file.put_line(fnd_file.log, 'Event_id = ' || line_record.event_id);
186493: l_array_duplicate_checker(line_record.event_id) := line_record.event_id;
186494: END IF;
186495: END LOOP;
186496:

Line 186497: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');

186493: l_array_duplicate_checker(line_record.event_id) := line_record.event_id;
186494: END IF;
186495: END LOOP;
186496:
186497: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
186498: fnd_file.put_line(fnd_file.LOG, ' ');
186499:
186500:
186501: xla_exceptions_pkg.raise_message

Line 186498: fnd_file.put_line(fnd_file.LOG, ' ');

186494: END IF;
186495: END LOOP;
186496:
186497: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
186498: fnd_file.put_line(fnd_file.LOG, ' ');
186499:
186500:
186501: xla_exceptions_pkg.raise_message
186502: (p_location => 'XLA_00555_AAD_S_000001_PKG.EventType_302');

Line 187731: fnd_file.put_line(fnd_file.LOG, ' ');

187727:
187728: l_first_event_id := l_array_header_events(l_array_header_events.FIRST);
187729: l_last_event_id := l_array_header_events(l_array_header_events.LAST);
187730:
187731: fnd_file.put_line(fnd_file.LOG, ' ');
187732: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
187733: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );
187734: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');
187735:

Line 187732: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');

187728: l_first_event_id := l_array_header_events(l_array_header_events.FIRST);
187729: l_last_event_id := l_array_header_events(l_array_header_events.LAST);
187730:
187731: fnd_file.put_line(fnd_file.LOG, ' ');
187732: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
187733: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );
187734: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');
187735:
187736: FOR line_record IN line_cur(l_first_event_id, l_last_event_id)

Line 187733: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );

187729: l_last_event_id := l_array_header_events(l_array_header_events.LAST);
187730:
187731: fnd_file.put_line(fnd_file.LOG, ' ');
187732: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
187733: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );
187734: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');
187735:
187736: FOR line_record IN line_cur(l_first_event_id, l_last_event_id)
187737: LOOP

Line 187734: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');

187730:
187731: fnd_file.put_line(fnd_file.LOG, ' ');
187732: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
187733: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );
187734: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');
187735:
187736: FOR line_record IN line_cur(l_first_event_id, l_last_event_id)
187737: LOOP
187738: IF (NOT l_array_header_events.EXISTS(line_record.event_id)) AND (NOT l_array_duplicate_checker.EXISTS(line_record.event_id)) THEN

Line 187739: fnd_file.put_line(fnd_file.log, 'Event_id = ' || line_record.event_id);

187735:
187736: FOR line_record IN line_cur(l_first_event_id, l_last_event_id)
187737: LOOP
187738: IF (NOT l_array_header_events.EXISTS(line_record.event_id)) AND (NOT l_array_duplicate_checker.EXISTS(line_record.event_id)) THEN
187739: fnd_file.put_line(fnd_file.log, 'Event_id = ' || line_record.event_id);
187740: l_array_duplicate_checker(line_record.event_id) := line_record.event_id;
187741: END IF;
187742: END LOOP;
187743:

Line 187744: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');

187740: l_array_duplicate_checker(line_record.event_id) := line_record.event_id;
187741: END IF;
187742: END LOOP;
187743:
187744: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
187745: fnd_file.put_line(fnd_file.LOG, ' ');
187746:
187747:
187748: xla_exceptions_pkg.raise_message

Line 187745: fnd_file.put_line(fnd_file.LOG, ' ');

187741: END IF;
187742: END LOOP;
187743:
187744: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
187745: fnd_file.put_line(fnd_file.LOG, ' ');
187746:
187747:
187748: xla_exceptions_pkg.raise_message
187749: (p_location => 'XLA_00555_AAD_S_000001_PKG.EventClass_303');

Line 189021: fnd_file.put_line(fnd_file.LOG, ' ');

189017:
189018: l_first_event_id := l_array_header_events(l_array_header_events.FIRST);
189019: l_last_event_id := l_array_header_events(l_array_header_events.LAST);
189020:
189021: fnd_file.put_line(fnd_file.LOG, ' ');
189022: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
189023: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );
189024: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');
189025:

Line 189022: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');

189018: l_first_event_id := l_array_header_events(l_array_header_events.FIRST);
189019: l_last_event_id := l_array_header_events(l_array_header_events.LAST);
189020:
189021: fnd_file.put_line(fnd_file.LOG, ' ');
189022: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
189023: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );
189024: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');
189025:
189026: FOR line_record IN line_cur(l_first_event_id, l_last_event_id)

Line 189023: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );

189019: l_last_event_id := l_array_header_events(l_array_header_events.LAST);
189020:
189021: fnd_file.put_line(fnd_file.LOG, ' ');
189022: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
189023: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );
189024: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');
189025:
189026: FOR line_record IN line_cur(l_first_event_id, l_last_event_id)
189027: LOOP

Line 189024: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');

189020:
189021: fnd_file.put_line(fnd_file.LOG, ' ');
189022: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
189023: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );
189024: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');
189025:
189026: FOR line_record IN line_cur(l_first_event_id, l_last_event_id)
189027: LOOP
189028: IF (NOT l_array_header_events.EXISTS(line_record.event_id)) AND (NOT l_array_duplicate_checker.EXISTS(line_record.event_id)) THEN

Line 189029: fnd_file.put_line(fnd_file.log, 'Event_id = ' || line_record.event_id);

189025:
189026: FOR line_record IN line_cur(l_first_event_id, l_last_event_id)
189027: LOOP
189028: IF (NOT l_array_header_events.EXISTS(line_record.event_id)) AND (NOT l_array_duplicate_checker.EXISTS(line_record.event_id)) THEN
189029: fnd_file.put_line(fnd_file.log, 'Event_id = ' || line_record.event_id);
189030: l_array_duplicate_checker(line_record.event_id) := line_record.event_id;
189031: END IF;
189032: END LOOP;
189033:

Line 189034: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');

189030: l_array_duplicate_checker(line_record.event_id) := line_record.event_id;
189031: END IF;
189032: END LOOP;
189033:
189034: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
189035: fnd_file.put_line(fnd_file.LOG, ' ');
189036:
189037:
189038: xla_exceptions_pkg.raise_message

Line 189035: fnd_file.put_line(fnd_file.LOG, ' ');

189031: END IF;
189032: END LOOP;
189033:
189034: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
189035: fnd_file.put_line(fnd_file.LOG, ' ');
189036:
189037:
189038: xla_exceptions_pkg.raise_message
189039: (p_location => 'XLA_00555_AAD_S_000001_PKG.EventType_304');

Line 190283: fnd_file.put_line(fnd_file.LOG, ' ');

190279:
190280: l_first_event_id := l_array_header_events(l_array_header_events.FIRST);
190281: l_last_event_id := l_array_header_events(l_array_header_events.LAST);
190282:
190283: fnd_file.put_line(fnd_file.LOG, ' ');
190284: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
190285: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );
190286: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');
190287:

Line 190284: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');

190280: l_first_event_id := l_array_header_events(l_array_header_events.FIRST);
190281: l_last_event_id := l_array_header_events(l_array_header_events.LAST);
190282:
190283: fnd_file.put_line(fnd_file.LOG, ' ');
190284: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
190285: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );
190286: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');
190287:
190288: FOR line_record IN line_cur(l_first_event_id, l_last_event_id)

Line 190285: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );

190281: l_last_event_id := l_array_header_events(l_array_header_events.LAST);
190282:
190283: fnd_file.put_line(fnd_file.LOG, ' ');
190284: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
190285: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );
190286: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');
190287:
190288: FOR line_record IN line_cur(l_first_event_id, l_last_event_id)
190289: LOOP

Line 190286: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');

190282:
190283: fnd_file.put_line(fnd_file.LOG, ' ');
190284: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
190285: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );
190286: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');
190287:
190288: FOR line_record IN line_cur(l_first_event_id, l_last_event_id)
190289: LOOP
190290: IF (NOT l_array_header_events.EXISTS(line_record.event_id)) AND (NOT l_array_duplicate_checker.EXISTS(line_record.event_id)) THEN

Line 190291: fnd_file.put_line(fnd_file.log, 'Event_id = ' || line_record.event_id);

190287:
190288: FOR line_record IN line_cur(l_first_event_id, l_last_event_id)
190289: LOOP
190290: IF (NOT l_array_header_events.EXISTS(line_record.event_id)) AND (NOT l_array_duplicate_checker.EXISTS(line_record.event_id)) THEN
190291: fnd_file.put_line(fnd_file.log, 'Event_id = ' || line_record.event_id);
190292: l_array_duplicate_checker(line_record.event_id) := line_record.event_id;
190293: END IF;
190294: END LOOP;
190295:

Line 190296: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');

190292: l_array_duplicate_checker(line_record.event_id) := line_record.event_id;
190293: END IF;
190294: END LOOP;
190295:
190296: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
190297: fnd_file.put_line(fnd_file.LOG, ' ');
190298:
190299:
190300: xla_exceptions_pkg.raise_message

Line 190297: fnd_file.put_line(fnd_file.LOG, ' ');

190293: END IF;
190294: END LOOP;
190295:
190296: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
190297: fnd_file.put_line(fnd_file.LOG, ' ');
190298:
190299:
190300: xla_exceptions_pkg.raise_message
190301: (p_location => 'XLA_00555_AAD_S_000001_PKG.EventType_305');