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_00222_AAD_S_000009_PKG dependencies on FND_FILE

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

68934:
68935: l_first_event_id := l_array_header_events(l_array_header_events.FIRST);
68936: l_last_event_id := l_array_header_events(l_array_header_events.LAST);
68937:
68938: fnd_file.put_line(fnd_file.LOG, ' ');
68939: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
68940: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );
68941: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');
68942:

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

68935: l_first_event_id := l_array_header_events(l_array_header_events.FIRST);
68936: l_last_event_id := l_array_header_events(l_array_header_events.LAST);
68937:
68938: fnd_file.put_line(fnd_file.LOG, ' ');
68939: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
68940: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );
68941: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');
68942:
68943: FOR line_record IN line_cur(l_first_event_id, l_last_event_id)

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

68936: l_last_event_id := l_array_header_events(l_array_header_events.LAST);
68937:
68938: fnd_file.put_line(fnd_file.LOG, ' ');
68939: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
68940: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );
68941: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');
68942:
68943: FOR line_record IN line_cur(l_first_event_id, l_last_event_id)
68944: LOOP

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

68937:
68938: fnd_file.put_line(fnd_file.LOG, ' ');
68939: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
68940: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );
68941: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');
68942:
68943: FOR line_record IN line_cur(l_first_event_id, l_last_event_id)
68944: LOOP
68945: IF (NOT l_array_header_events.EXISTS(line_record.event_id)) AND (NOT l_array_duplicate_checker.EXISTS(line_record.event_id)) THEN

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

68942:
68943: FOR line_record IN line_cur(l_first_event_id, l_last_event_id)
68944: LOOP
68945: IF (NOT l_array_header_events.EXISTS(line_record.event_id)) AND (NOT l_array_duplicate_checker.EXISTS(line_record.event_id)) THEN
68946: fnd_file.put_line(fnd_file.log, 'Event_id = ' || line_record.event_id);
68947: l_array_duplicate_checker(line_record.event_id) := line_record.event_id;
68948: END IF;
68949: END LOOP;
68950:

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

68947: l_array_duplicate_checker(line_record.event_id) := line_record.event_id;
68948: END IF;
68949: END LOOP;
68950:
68951: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
68952: fnd_file.put_line(fnd_file.LOG, ' ');
68953:
68954:
68955: xla_exceptions_pkg.raise_message

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

68948: END IF;
68949: END LOOP;
68950:
68951: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
68952: fnd_file.put_line(fnd_file.LOG, ' ');
68953:
68954:
68955: xla_exceptions_pkg.raise_message
68956: (p_location => 'XLA_00222_AAD_S_000009_PKG.EventClass_138');

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

70180:
70181: l_first_event_id := l_array_header_events(l_array_header_events.FIRST);
70182: l_last_event_id := l_array_header_events(l_array_header_events.LAST);
70183:
70184: fnd_file.put_line(fnd_file.LOG, ' ');
70185: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
70186: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );
70187: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');
70188:

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

70181: l_first_event_id := l_array_header_events(l_array_header_events.FIRST);
70182: l_last_event_id := l_array_header_events(l_array_header_events.LAST);
70183:
70184: fnd_file.put_line(fnd_file.LOG, ' ');
70185: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
70186: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );
70187: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');
70188:
70189: FOR line_record IN line_cur(l_first_event_id, l_last_event_id)

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

70182: l_last_event_id := l_array_header_events(l_array_header_events.LAST);
70183:
70184: fnd_file.put_line(fnd_file.LOG, ' ');
70185: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
70186: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );
70187: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');
70188:
70189: FOR line_record IN line_cur(l_first_event_id, l_last_event_id)
70190: LOOP

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

70183:
70184: fnd_file.put_line(fnd_file.LOG, ' ');
70185: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
70186: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );
70187: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');
70188:
70189: FOR line_record IN line_cur(l_first_event_id, l_last_event_id)
70190: LOOP
70191: IF (NOT l_array_header_events.EXISTS(line_record.event_id)) AND (NOT l_array_duplicate_checker.EXISTS(line_record.event_id)) THEN

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

70188:
70189: FOR line_record IN line_cur(l_first_event_id, l_last_event_id)
70190: LOOP
70191: IF (NOT l_array_header_events.EXISTS(line_record.event_id)) AND (NOT l_array_duplicate_checker.EXISTS(line_record.event_id)) THEN
70192: fnd_file.put_line(fnd_file.log, 'Event_id = ' || line_record.event_id);
70193: l_array_duplicate_checker(line_record.event_id) := line_record.event_id;
70194: END IF;
70195: END LOOP;
70196:

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

70193: l_array_duplicate_checker(line_record.event_id) := line_record.event_id;
70194: END IF;
70195: END LOOP;
70196:
70197: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
70198: fnd_file.put_line(fnd_file.LOG, ' ');
70199:
70200:
70201: xla_exceptions_pkg.raise_message

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

70194: END IF;
70195: END LOOP;
70196:
70197: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
70198: fnd_file.put_line(fnd_file.LOG, ' ');
70199:
70200:
70201: xla_exceptions_pkg.raise_message
70202: (p_location => 'XLA_00222_AAD_S_000009_PKG.EventClass_139');

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

71799:
71800: l_first_event_id := l_array_header_events(l_array_header_events.FIRST);
71801: l_last_event_id := l_array_header_events(l_array_header_events.LAST);
71802:
71803: fnd_file.put_line(fnd_file.LOG, ' ');
71804: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
71805: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );
71806: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');
71807:

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

71800: l_first_event_id := l_array_header_events(l_array_header_events.FIRST);
71801: l_last_event_id := l_array_header_events(l_array_header_events.LAST);
71802:
71803: fnd_file.put_line(fnd_file.LOG, ' ');
71804: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
71805: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );
71806: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');
71807:
71808: FOR line_record IN line_cur(l_first_event_id, l_last_event_id)

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

71801: l_last_event_id := l_array_header_events(l_array_header_events.LAST);
71802:
71803: fnd_file.put_line(fnd_file.LOG, ' ');
71804: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
71805: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );
71806: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');
71807:
71808: FOR line_record IN line_cur(l_first_event_id, l_last_event_id)
71809: LOOP

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

71802:
71803: fnd_file.put_line(fnd_file.LOG, ' ');
71804: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
71805: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );
71806: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');
71807:
71808: FOR line_record IN line_cur(l_first_event_id, l_last_event_id)
71809: LOOP
71810: IF (NOT l_array_header_events.EXISTS(line_record.event_id)) AND (NOT l_array_duplicate_checker.EXISTS(line_record.event_id)) THEN

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

71807:
71808: FOR line_record IN line_cur(l_first_event_id, l_last_event_id)
71809: LOOP
71810: IF (NOT l_array_header_events.EXISTS(line_record.event_id)) AND (NOT l_array_duplicate_checker.EXISTS(line_record.event_id)) THEN
71811: fnd_file.put_line(fnd_file.log, 'Event_id = ' || line_record.event_id);
71812: l_array_duplicate_checker(line_record.event_id) := line_record.event_id;
71813: END IF;
71814: END LOOP;
71815:

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

71812: l_array_duplicate_checker(line_record.event_id) := line_record.event_id;
71813: END IF;
71814: END LOOP;
71815:
71816: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
71817: fnd_file.put_line(fnd_file.LOG, ' ');
71818:
71819:
71820: xla_exceptions_pkg.raise_message

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

71813: END IF;
71814: END LOOP;
71815:
71816: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
71817: fnd_file.put_line(fnd_file.LOG, ' ');
71818:
71819:
71820: xla_exceptions_pkg.raise_message
71821: (p_location => 'XLA_00222_AAD_S_000009_PKG.EventClass_140');

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

73270:
73271: l_first_event_id := l_array_header_events(l_array_header_events.FIRST);
73272: l_last_event_id := l_array_header_events(l_array_header_events.LAST);
73273:
73274: fnd_file.put_line(fnd_file.LOG, ' ');
73275: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
73276: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );
73277: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');
73278:

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

73271: l_first_event_id := l_array_header_events(l_array_header_events.FIRST);
73272: l_last_event_id := l_array_header_events(l_array_header_events.LAST);
73273:
73274: fnd_file.put_line(fnd_file.LOG, ' ');
73275: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
73276: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );
73277: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');
73278:
73279: FOR line_record IN line_cur(l_first_event_id, l_last_event_id)

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

73272: l_last_event_id := l_array_header_events(l_array_header_events.LAST);
73273:
73274: fnd_file.put_line(fnd_file.LOG, ' ');
73275: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
73276: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );
73277: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');
73278:
73279: FOR line_record IN line_cur(l_first_event_id, l_last_event_id)
73280: LOOP

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

73273:
73274: fnd_file.put_line(fnd_file.LOG, ' ');
73275: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
73276: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );
73277: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');
73278:
73279: FOR line_record IN line_cur(l_first_event_id, l_last_event_id)
73280: LOOP
73281: IF (NOT l_array_header_events.EXISTS(line_record.event_id)) AND (NOT l_array_duplicate_checker.EXISTS(line_record.event_id)) THEN

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

73278:
73279: FOR line_record IN line_cur(l_first_event_id, l_last_event_id)
73280: LOOP
73281: IF (NOT l_array_header_events.EXISTS(line_record.event_id)) AND (NOT l_array_duplicate_checker.EXISTS(line_record.event_id)) THEN
73282: fnd_file.put_line(fnd_file.log, 'Event_id = ' || line_record.event_id);
73283: l_array_duplicate_checker(line_record.event_id) := line_record.event_id;
73284: END IF;
73285: END LOOP;
73286:

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

73283: l_array_duplicate_checker(line_record.event_id) := line_record.event_id;
73284: END IF;
73285: END LOOP;
73286:
73287: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
73288: fnd_file.put_line(fnd_file.LOG, ' ');
73289:
73290:
73291: xla_exceptions_pkg.raise_message

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

73284: END IF;
73285: END LOOP;
73286:
73287: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
73288: fnd_file.put_line(fnd_file.LOG, ' ');
73289:
73290:
73291: xla_exceptions_pkg.raise_message
73292: (p_location => 'XLA_00222_AAD_S_000009_PKG.EventClass_141');

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

74516:
74517: l_first_event_id := l_array_header_events(l_array_header_events.FIRST);
74518: l_last_event_id := l_array_header_events(l_array_header_events.LAST);
74519:
74520: fnd_file.put_line(fnd_file.LOG, ' ');
74521: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
74522: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );
74523: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');
74524:

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

74517: l_first_event_id := l_array_header_events(l_array_header_events.FIRST);
74518: l_last_event_id := l_array_header_events(l_array_header_events.LAST);
74519:
74520: fnd_file.put_line(fnd_file.LOG, ' ');
74521: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
74522: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );
74523: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');
74524:
74525: FOR line_record IN line_cur(l_first_event_id, l_last_event_id)

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

74518: l_last_event_id := l_array_header_events(l_array_header_events.LAST);
74519:
74520: fnd_file.put_line(fnd_file.LOG, ' ');
74521: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
74522: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );
74523: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');
74524:
74525: FOR line_record IN line_cur(l_first_event_id, l_last_event_id)
74526: LOOP

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

74519:
74520: fnd_file.put_line(fnd_file.LOG, ' ');
74521: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
74522: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );
74523: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');
74524:
74525: FOR line_record IN line_cur(l_first_event_id, l_last_event_id)
74526: LOOP
74527: IF (NOT l_array_header_events.EXISTS(line_record.event_id)) AND (NOT l_array_duplicate_checker.EXISTS(line_record.event_id)) THEN

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

74524:
74525: FOR line_record IN line_cur(l_first_event_id, l_last_event_id)
74526: LOOP
74527: IF (NOT l_array_header_events.EXISTS(line_record.event_id)) AND (NOT l_array_duplicate_checker.EXISTS(line_record.event_id)) THEN
74528: fnd_file.put_line(fnd_file.log, 'Event_id = ' || line_record.event_id);
74529: l_array_duplicate_checker(line_record.event_id) := line_record.event_id;
74530: END IF;
74531: END LOOP;
74532:

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

74529: l_array_duplicate_checker(line_record.event_id) := line_record.event_id;
74530: END IF;
74531: END LOOP;
74532:
74533: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
74534: fnd_file.put_line(fnd_file.LOG, ' ');
74535:
74536:
74537: xla_exceptions_pkg.raise_message

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

74530: END IF;
74531: END LOOP;
74532:
74533: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
74534: fnd_file.put_line(fnd_file.LOG, ' ');
74535:
74536:
74537: xla_exceptions_pkg.raise_message
74538: (p_location => 'XLA_00222_AAD_S_000009_PKG.EventClass_142');

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

75762:
75763: l_first_event_id := l_array_header_events(l_array_header_events.FIRST);
75764: l_last_event_id := l_array_header_events(l_array_header_events.LAST);
75765:
75766: fnd_file.put_line(fnd_file.LOG, ' ');
75767: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
75768: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );
75769: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');
75770:

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

75763: l_first_event_id := l_array_header_events(l_array_header_events.FIRST);
75764: l_last_event_id := l_array_header_events(l_array_header_events.LAST);
75765:
75766: fnd_file.put_line(fnd_file.LOG, ' ');
75767: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
75768: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );
75769: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');
75770:
75771: FOR line_record IN line_cur(l_first_event_id, l_last_event_id)

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

75764: l_last_event_id := l_array_header_events(l_array_header_events.LAST);
75765:
75766: fnd_file.put_line(fnd_file.LOG, ' ');
75767: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
75768: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );
75769: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');
75770:
75771: FOR line_record IN line_cur(l_first_event_id, l_last_event_id)
75772: LOOP

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

75765:
75766: fnd_file.put_line(fnd_file.LOG, ' ');
75767: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
75768: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );
75769: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');
75770:
75771: FOR line_record IN line_cur(l_first_event_id, l_last_event_id)
75772: LOOP
75773: IF (NOT l_array_header_events.EXISTS(line_record.event_id)) AND (NOT l_array_duplicate_checker.EXISTS(line_record.event_id)) THEN

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

75770:
75771: FOR line_record IN line_cur(l_first_event_id, l_last_event_id)
75772: LOOP
75773: IF (NOT l_array_header_events.EXISTS(line_record.event_id)) AND (NOT l_array_duplicate_checker.EXISTS(line_record.event_id)) THEN
75774: fnd_file.put_line(fnd_file.log, 'Event_id = ' || line_record.event_id);
75775: l_array_duplicate_checker(line_record.event_id) := line_record.event_id;
75776: END IF;
75777: END LOOP;
75778:

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

75775: l_array_duplicate_checker(line_record.event_id) := line_record.event_id;
75776: END IF;
75777: END LOOP;
75778:
75779: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
75780: fnd_file.put_line(fnd_file.LOG, ' ');
75781:
75782:
75783: xla_exceptions_pkg.raise_message

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

75776: END IF;
75777: END LOOP;
75778:
75779: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
75780: fnd_file.put_line(fnd_file.LOG, ' ');
75781:
75782:
75783: xla_exceptions_pkg.raise_message
75784: (p_location => 'XLA_00222_AAD_S_000009_PKG.EventClass_143');

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

77345:
77346: l_first_event_id := l_array_header_events(l_array_header_events.FIRST);
77347: l_last_event_id := l_array_header_events(l_array_header_events.LAST);
77348:
77349: fnd_file.put_line(fnd_file.LOG, ' ');
77350: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
77351: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );
77352: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');
77353:

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

77346: l_first_event_id := l_array_header_events(l_array_header_events.FIRST);
77347: l_last_event_id := l_array_header_events(l_array_header_events.LAST);
77348:
77349: fnd_file.put_line(fnd_file.LOG, ' ');
77350: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
77351: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );
77352: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');
77353:
77354: FOR line_record IN line_cur(l_first_event_id, l_last_event_id)

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

77347: l_last_event_id := l_array_header_events(l_array_header_events.LAST);
77348:
77349: fnd_file.put_line(fnd_file.LOG, ' ');
77350: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
77351: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );
77352: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');
77353:
77354: FOR line_record IN line_cur(l_first_event_id, l_last_event_id)
77355: LOOP

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

77348:
77349: fnd_file.put_line(fnd_file.LOG, ' ');
77350: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
77351: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );
77352: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');
77353:
77354: FOR line_record IN line_cur(l_first_event_id, l_last_event_id)
77355: LOOP
77356: IF (NOT l_array_header_events.EXISTS(line_record.event_id)) AND (NOT l_array_duplicate_checker.EXISTS(line_record.event_id)) THEN

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

77353:
77354: FOR line_record IN line_cur(l_first_event_id, l_last_event_id)
77355: LOOP
77356: IF (NOT l_array_header_events.EXISTS(line_record.event_id)) AND (NOT l_array_duplicate_checker.EXISTS(line_record.event_id)) THEN
77357: fnd_file.put_line(fnd_file.log, 'Event_id = ' || line_record.event_id);
77358: l_array_duplicate_checker(line_record.event_id) := line_record.event_id;
77359: END IF;
77360: END LOOP;
77361:

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

77358: l_array_duplicate_checker(line_record.event_id) := line_record.event_id;
77359: END IF;
77360: END LOOP;
77361:
77362: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
77363: fnd_file.put_line(fnd_file.LOG, ' ');
77364:
77365:
77366: xla_exceptions_pkg.raise_message

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

77359: END IF;
77360: END LOOP;
77361:
77362: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
77363: fnd_file.put_line(fnd_file.LOG, ' ');
77364:
77365:
77366: xla_exceptions_pkg.raise_message
77367: (p_location => 'XLA_00222_AAD_S_000009_PKG.EventClass_144');

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

79184:
79185: l_first_event_id := l_array_header_events(l_array_header_events.FIRST);
79186: l_last_event_id := l_array_header_events(l_array_header_events.LAST);
79187:
79188: fnd_file.put_line(fnd_file.LOG, ' ');
79189: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
79190: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );
79191: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');
79192:

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

79185: l_first_event_id := l_array_header_events(l_array_header_events.FIRST);
79186: l_last_event_id := l_array_header_events(l_array_header_events.LAST);
79187:
79188: fnd_file.put_line(fnd_file.LOG, ' ');
79189: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
79190: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );
79191: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');
79192:
79193: FOR line_record IN line_cur(l_first_event_id, l_last_event_id)

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

79186: l_last_event_id := l_array_header_events(l_array_header_events.LAST);
79187:
79188: fnd_file.put_line(fnd_file.LOG, ' ');
79189: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
79190: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );
79191: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');
79192:
79193: FOR line_record IN line_cur(l_first_event_id, l_last_event_id)
79194: LOOP

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

79187:
79188: fnd_file.put_line(fnd_file.LOG, ' ');
79189: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
79190: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );
79191: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');
79192:
79193: FOR line_record IN line_cur(l_first_event_id, l_last_event_id)
79194: LOOP
79195: IF (NOT l_array_header_events.EXISTS(line_record.event_id)) AND (NOT l_array_duplicate_checker.EXISTS(line_record.event_id)) THEN

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

79192:
79193: FOR line_record IN line_cur(l_first_event_id, l_last_event_id)
79194: LOOP
79195: IF (NOT l_array_header_events.EXISTS(line_record.event_id)) AND (NOT l_array_duplicate_checker.EXISTS(line_record.event_id)) THEN
79196: fnd_file.put_line(fnd_file.log, 'Event_id = ' || line_record.event_id);
79197: l_array_duplicate_checker(line_record.event_id) := line_record.event_id;
79198: END IF;
79199: END LOOP;
79200:

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

79197: l_array_duplicate_checker(line_record.event_id) := line_record.event_id;
79198: END IF;
79199: END LOOP;
79200:
79201: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
79202: fnd_file.put_line(fnd_file.LOG, ' ');
79203:
79204:
79205: xla_exceptions_pkg.raise_message

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

79198: END IF;
79199: END LOOP;
79200:
79201: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
79202: fnd_file.put_line(fnd_file.LOG, ' ');
79203:
79204:
79205: xla_exceptions_pkg.raise_message
79206: (p_location => 'XLA_00222_AAD_S_000009_PKG.EventClass_145');

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

82469:
82470: l_first_event_id := l_array_header_events(l_array_header_events.FIRST);
82471: l_last_event_id := l_array_header_events(l_array_header_events.LAST);
82472:
82473: fnd_file.put_line(fnd_file.LOG, ' ');
82474: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
82475: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );
82476: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');
82477:

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

82470: l_first_event_id := l_array_header_events(l_array_header_events.FIRST);
82471: l_last_event_id := l_array_header_events(l_array_header_events.LAST);
82472:
82473: fnd_file.put_line(fnd_file.LOG, ' ');
82474: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
82475: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );
82476: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');
82477:
82478: FOR line_record IN line_cur(l_first_event_id, l_last_event_id)

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

82471: l_last_event_id := l_array_header_events(l_array_header_events.LAST);
82472:
82473: fnd_file.put_line(fnd_file.LOG, ' ');
82474: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
82475: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );
82476: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');
82477:
82478: FOR line_record IN line_cur(l_first_event_id, l_last_event_id)
82479: LOOP

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

82472:
82473: fnd_file.put_line(fnd_file.LOG, ' ');
82474: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
82475: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );
82476: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');
82477:
82478: FOR line_record IN line_cur(l_first_event_id, l_last_event_id)
82479: LOOP
82480: IF (NOT l_array_header_events.EXISTS(line_record.event_id)) AND (NOT l_array_duplicate_checker.EXISTS(line_record.event_id)) THEN

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

82477:
82478: FOR line_record IN line_cur(l_first_event_id, l_last_event_id)
82479: LOOP
82480: IF (NOT l_array_header_events.EXISTS(line_record.event_id)) AND (NOT l_array_duplicate_checker.EXISTS(line_record.event_id)) THEN
82481: fnd_file.put_line(fnd_file.log, 'Event_id = ' || line_record.event_id);
82482: l_array_duplicate_checker(line_record.event_id) := line_record.event_id;
82483: END IF;
82484: END LOOP;
82485:

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

82482: l_array_duplicate_checker(line_record.event_id) := line_record.event_id;
82483: END IF;
82484: END LOOP;
82485:
82486: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
82487: fnd_file.put_line(fnd_file.LOG, ' ');
82488:
82489:
82490: xla_exceptions_pkg.raise_message

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

82483: END IF;
82484: END LOOP;
82485:
82486: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
82487: fnd_file.put_line(fnd_file.LOG, ' ');
82488:
82489:
82490: xla_exceptions_pkg.raise_message
82491: (p_location => 'XLA_00222_AAD_S_000009_PKG.EventClass_146');