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

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

147141:
147142: l_first_event_id := l_array_header_events(l_array_header_events.FIRST);
147143: l_last_event_id := l_array_header_events(l_array_header_events.LAST);
147144:
147145: fnd_file.put_line(fnd_file.LOG, ' ');
147146: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
147147: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );
147148: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');
147149:

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

147142: l_first_event_id := l_array_header_events(l_array_header_events.FIRST);
147143: l_last_event_id := l_array_header_events(l_array_header_events.LAST);
147144:
147145: fnd_file.put_line(fnd_file.LOG, ' ');
147146: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
147147: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );
147148: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');
147149:
147150: FOR line_record IN line_cur(l_first_event_id, l_last_event_id)

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

147143: l_last_event_id := l_array_header_events(l_array_header_events.LAST);
147144:
147145: fnd_file.put_line(fnd_file.LOG, ' ');
147146: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
147147: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );
147148: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');
147149:
147150: FOR line_record IN line_cur(l_first_event_id, l_last_event_id)
147151: LOOP

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

147144:
147145: fnd_file.put_line(fnd_file.LOG, ' ');
147146: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
147147: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );
147148: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');
147149:
147150: FOR line_record IN line_cur(l_first_event_id, l_last_event_id)
147151: LOOP
147152: IF (NOT l_array_header_events.EXISTS(line_record.event_id)) AND (NOT l_array_duplicate_checker.EXISTS(line_record.event_id)) THEN

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

147149:
147150: FOR line_record IN line_cur(l_first_event_id, l_last_event_id)
147151: LOOP
147152: IF (NOT l_array_header_events.EXISTS(line_record.event_id)) AND (NOT l_array_duplicate_checker.EXISTS(line_record.event_id)) THEN
147153: fnd_file.put_line(fnd_file.log, 'Event_id = ' || line_record.event_id);
147154: l_array_duplicate_checker(line_record.event_id) := line_record.event_id;
147155: END IF;
147156: END LOOP;
147157:

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

147154: l_array_duplicate_checker(line_record.event_id) := line_record.event_id;
147155: END IF;
147156: END LOOP;
147157:
147158: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
147159: fnd_file.put_line(fnd_file.LOG, ' ');
147160:
147161:
147162: xla_exceptions_pkg.raise_message

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

147155: END IF;
147156: END LOOP;
147157:
147158: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
147159: fnd_file.put_line(fnd_file.LOG, ' ');
147160:
147161:
147162: xla_exceptions_pkg.raise_message
147163: (p_location => 'XLA_00200_AAD_S_000002_PKG.EventClass_230');

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

150382:
150383: l_first_event_id := l_array_header_events(l_array_header_events.FIRST);
150384: l_last_event_id := l_array_header_events(l_array_header_events.LAST);
150385:
150386: fnd_file.put_line(fnd_file.LOG, ' ');
150387: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
150388: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );
150389: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');
150390:

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

150383: l_first_event_id := l_array_header_events(l_array_header_events.FIRST);
150384: l_last_event_id := l_array_header_events(l_array_header_events.LAST);
150385:
150386: fnd_file.put_line(fnd_file.LOG, ' ');
150387: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
150388: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );
150389: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');
150390:
150391: FOR line_record IN line_cur(l_first_event_id, l_last_event_id)

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

150384: l_last_event_id := l_array_header_events(l_array_header_events.LAST);
150385:
150386: fnd_file.put_line(fnd_file.LOG, ' ');
150387: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
150388: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );
150389: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');
150390:
150391: FOR line_record IN line_cur(l_first_event_id, l_last_event_id)
150392: LOOP

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

150385:
150386: fnd_file.put_line(fnd_file.LOG, ' ');
150387: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
150388: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );
150389: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');
150390:
150391: FOR line_record IN line_cur(l_first_event_id, l_last_event_id)
150392: LOOP
150393: IF (NOT l_array_header_events.EXISTS(line_record.event_id)) AND (NOT l_array_duplicate_checker.EXISTS(line_record.event_id)) THEN

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

150390:
150391: FOR line_record IN line_cur(l_first_event_id, l_last_event_id)
150392: LOOP
150393: IF (NOT l_array_header_events.EXISTS(line_record.event_id)) AND (NOT l_array_duplicate_checker.EXISTS(line_record.event_id)) THEN
150394: fnd_file.put_line(fnd_file.log, 'Event_id = ' || line_record.event_id);
150395: l_array_duplicate_checker(line_record.event_id) := line_record.event_id;
150396: END IF;
150397: END LOOP;
150398:

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

150395: l_array_duplicate_checker(line_record.event_id) := line_record.event_id;
150396: END IF;
150397: END LOOP;
150398:
150399: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
150400: fnd_file.put_line(fnd_file.LOG, ' ');
150401:
150402:
150403: xla_exceptions_pkg.raise_message

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

150396: END IF;
150397: END LOOP;
150398:
150399: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
150400: fnd_file.put_line(fnd_file.LOG, ' ');
150401:
150402:
150403: xla_exceptions_pkg.raise_message
150404: (p_location => 'XLA_00200_AAD_S_000002_PKG.EventClass_231');

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

152756:
152757: l_first_event_id := l_array_header_events(l_array_header_events.FIRST);
152758: l_last_event_id := l_array_header_events(l_array_header_events.LAST);
152759:
152760: fnd_file.put_line(fnd_file.LOG, ' ');
152761: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
152762: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );
152763: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');
152764:

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

152757: l_first_event_id := l_array_header_events(l_array_header_events.FIRST);
152758: l_last_event_id := l_array_header_events(l_array_header_events.LAST);
152759:
152760: fnd_file.put_line(fnd_file.LOG, ' ');
152761: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
152762: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );
152763: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');
152764:
152765: FOR line_record IN line_cur(l_first_event_id, l_last_event_id)

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

152758: l_last_event_id := l_array_header_events(l_array_header_events.LAST);
152759:
152760: fnd_file.put_line(fnd_file.LOG, ' ');
152761: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
152762: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );
152763: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');
152764:
152765: FOR line_record IN line_cur(l_first_event_id, l_last_event_id)
152766: LOOP

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

152759:
152760: fnd_file.put_line(fnd_file.LOG, ' ');
152761: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
152762: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );
152763: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');
152764:
152765: FOR line_record IN line_cur(l_first_event_id, l_last_event_id)
152766: LOOP
152767: IF (NOT l_array_header_events.EXISTS(line_record.event_id)) AND (NOT l_array_duplicate_checker.EXISTS(line_record.event_id)) THEN

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

152764:
152765: FOR line_record IN line_cur(l_first_event_id, l_last_event_id)
152766: LOOP
152767: IF (NOT l_array_header_events.EXISTS(line_record.event_id)) AND (NOT l_array_duplicate_checker.EXISTS(line_record.event_id)) THEN
152768: fnd_file.put_line(fnd_file.log, 'Event_id = ' || line_record.event_id);
152769: l_array_duplicate_checker(line_record.event_id) := line_record.event_id;
152770: END IF;
152771: END LOOP;
152772:

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

152769: l_array_duplicate_checker(line_record.event_id) := line_record.event_id;
152770: END IF;
152771: END LOOP;
152772:
152773: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
152774: fnd_file.put_line(fnd_file.LOG, ' ');
152775:
152776:
152777: xla_exceptions_pkg.raise_message

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

152770: END IF;
152771: END LOOP;
152772:
152773: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
152774: fnd_file.put_line(fnd_file.LOG, ' ');
152775:
152776:
152777: xla_exceptions_pkg.raise_message
152778: (p_location => 'XLA_00200_AAD_S_000002_PKG.EventClass_232');

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

156138:
156139: l_first_event_id := l_array_header_events(l_array_header_events.FIRST);
156140: l_last_event_id := l_array_header_events(l_array_header_events.LAST);
156141:
156142: fnd_file.put_line(fnd_file.LOG, ' ');
156143: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
156144: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );
156145: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');
156146:

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

156139: l_first_event_id := l_array_header_events(l_array_header_events.FIRST);
156140: l_last_event_id := l_array_header_events(l_array_header_events.LAST);
156141:
156142: fnd_file.put_line(fnd_file.LOG, ' ');
156143: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
156144: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );
156145: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');
156146:
156147: FOR line_record IN line_cur(l_first_event_id, l_last_event_id)

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

156140: l_last_event_id := l_array_header_events(l_array_header_events.LAST);
156141:
156142: fnd_file.put_line(fnd_file.LOG, ' ');
156143: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
156144: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );
156145: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');
156146:
156147: FOR line_record IN line_cur(l_first_event_id, l_last_event_id)
156148: LOOP

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

156141:
156142: fnd_file.put_line(fnd_file.LOG, ' ');
156143: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
156144: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );
156145: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');
156146:
156147: FOR line_record IN line_cur(l_first_event_id, l_last_event_id)
156148: LOOP
156149: IF (NOT l_array_header_events.EXISTS(line_record.event_id)) AND (NOT l_array_duplicate_checker.EXISTS(line_record.event_id)) THEN

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

156146:
156147: FOR line_record IN line_cur(l_first_event_id, l_last_event_id)
156148: LOOP
156149: IF (NOT l_array_header_events.EXISTS(line_record.event_id)) AND (NOT l_array_duplicate_checker.EXISTS(line_record.event_id)) THEN
156150: fnd_file.put_line(fnd_file.log, 'Event_id = ' || line_record.event_id);
156151: l_array_duplicate_checker(line_record.event_id) := line_record.event_id;
156152: END IF;
156153: END LOOP;
156154:

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

156151: l_array_duplicate_checker(line_record.event_id) := line_record.event_id;
156152: END IF;
156153: END LOOP;
156154:
156155: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
156156: fnd_file.put_line(fnd_file.LOG, ' ');
156157:
156158:
156159: xla_exceptions_pkg.raise_message

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

156152: END IF;
156153: END LOOP;
156154:
156155: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
156156: fnd_file.put_line(fnd_file.LOG, ' ');
156157:
156158:
156159: xla_exceptions_pkg.raise_message
156160: (p_location => 'XLA_00200_AAD_S_000002_PKG.EventClass_233');

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

159296:
159297: l_first_event_id := l_array_header_events(l_array_header_events.FIRST);
159298: l_last_event_id := l_array_header_events(l_array_header_events.LAST);
159299:
159300: fnd_file.put_line(fnd_file.LOG, ' ');
159301: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
159302: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );
159303: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');
159304:

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

159297: l_first_event_id := l_array_header_events(l_array_header_events.FIRST);
159298: l_last_event_id := l_array_header_events(l_array_header_events.LAST);
159299:
159300: fnd_file.put_line(fnd_file.LOG, ' ');
159301: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
159302: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );
159303: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');
159304:
159305: FOR line_record IN line_cur(l_first_event_id, l_last_event_id)

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

159298: l_last_event_id := l_array_header_events(l_array_header_events.LAST);
159299:
159300: fnd_file.put_line(fnd_file.LOG, ' ');
159301: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
159302: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );
159303: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');
159304:
159305: FOR line_record IN line_cur(l_first_event_id, l_last_event_id)
159306: LOOP

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

159299:
159300: fnd_file.put_line(fnd_file.LOG, ' ');
159301: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
159302: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );
159303: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');
159304:
159305: FOR line_record IN line_cur(l_first_event_id, l_last_event_id)
159306: LOOP
159307: IF (NOT l_array_header_events.EXISTS(line_record.event_id)) AND (NOT l_array_duplicate_checker.EXISTS(line_record.event_id)) THEN

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

159304:
159305: FOR line_record IN line_cur(l_first_event_id, l_last_event_id)
159306: LOOP
159307: IF (NOT l_array_header_events.EXISTS(line_record.event_id)) AND (NOT l_array_duplicate_checker.EXISTS(line_record.event_id)) THEN
159308: fnd_file.put_line(fnd_file.log, 'Event_id = ' || line_record.event_id);
159309: l_array_duplicate_checker(line_record.event_id) := line_record.event_id;
159310: END IF;
159311: END LOOP;
159312:

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

159309: l_array_duplicate_checker(line_record.event_id) := line_record.event_id;
159310: END IF;
159311: END LOOP;
159312:
159313: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
159314: fnd_file.put_line(fnd_file.LOG, ' ');
159315:
159316:
159317: xla_exceptions_pkg.raise_message

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

159310: END IF;
159311: END LOOP;
159312:
159313: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
159314: fnd_file.put_line(fnd_file.LOG, ' ');
159315:
159316:
159317: xla_exceptions_pkg.raise_message
159318: (p_location => 'XLA_00200_AAD_S_000002_PKG.EventClass_234');

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

161717:
161718: l_first_event_id := l_array_header_events(l_array_header_events.FIRST);
161719: l_last_event_id := l_array_header_events(l_array_header_events.LAST);
161720:
161721: fnd_file.put_line(fnd_file.LOG, ' ');
161722: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
161723: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );
161724: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');
161725:

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

161718: l_first_event_id := l_array_header_events(l_array_header_events.FIRST);
161719: l_last_event_id := l_array_header_events(l_array_header_events.LAST);
161720:
161721: fnd_file.put_line(fnd_file.LOG, ' ');
161722: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
161723: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );
161724: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');
161725:
161726: FOR line_record IN line_cur(l_first_event_id, l_last_event_id)

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

161719: l_last_event_id := l_array_header_events(l_array_header_events.LAST);
161720:
161721: fnd_file.put_line(fnd_file.LOG, ' ');
161722: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
161723: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );
161724: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');
161725:
161726: FOR line_record IN line_cur(l_first_event_id, l_last_event_id)
161727: LOOP

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

161720:
161721: fnd_file.put_line(fnd_file.LOG, ' ');
161722: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
161723: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );
161724: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');
161725:
161726: FOR line_record IN line_cur(l_first_event_id, l_last_event_id)
161727: LOOP
161728: IF (NOT l_array_header_events.EXISTS(line_record.event_id)) AND (NOT l_array_duplicate_checker.EXISTS(line_record.event_id)) THEN

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

161725:
161726: FOR line_record IN line_cur(l_first_event_id, l_last_event_id)
161727: LOOP
161728: IF (NOT l_array_header_events.EXISTS(line_record.event_id)) AND (NOT l_array_duplicate_checker.EXISTS(line_record.event_id)) THEN
161729: fnd_file.put_line(fnd_file.log, 'Event_id = ' || line_record.event_id);
161730: l_array_duplicate_checker(line_record.event_id) := line_record.event_id;
161731: END IF;
161732: END LOOP;
161733:

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

161730: l_array_duplicate_checker(line_record.event_id) := line_record.event_id;
161731: END IF;
161732: END LOOP;
161733:
161734: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
161735: fnd_file.put_line(fnd_file.LOG, ' ');
161736:
161737:
161738: xla_exceptions_pkg.raise_message

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

161731: END IF;
161732: END LOOP;
161733:
161734: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
161735: fnd_file.put_line(fnd_file.LOG, ' ');
161736:
161737:
161738: xla_exceptions_pkg.raise_message
161739: (p_location => 'XLA_00200_AAD_S_000002_PKG.EventClass_235');

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

164998:
164999: l_first_event_id := l_array_header_events(l_array_header_events.FIRST);
165000: l_last_event_id := l_array_header_events(l_array_header_events.LAST);
165001:
165002: fnd_file.put_line(fnd_file.LOG, ' ');
165003: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
165004: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );
165005: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');
165006:

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

164999: l_first_event_id := l_array_header_events(l_array_header_events.FIRST);
165000: l_last_event_id := l_array_header_events(l_array_header_events.LAST);
165001:
165002: fnd_file.put_line(fnd_file.LOG, ' ');
165003: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
165004: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );
165005: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');
165006:
165007: FOR line_record IN line_cur(l_first_event_id, l_last_event_id)

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

165000: l_last_event_id := l_array_header_events(l_array_header_events.LAST);
165001:
165002: fnd_file.put_line(fnd_file.LOG, ' ');
165003: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
165004: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );
165005: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');
165006:
165007: FOR line_record IN line_cur(l_first_event_id, l_last_event_id)
165008: LOOP

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

165001:
165002: fnd_file.put_line(fnd_file.LOG, ' ');
165003: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
165004: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );
165005: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');
165006:
165007: FOR line_record IN line_cur(l_first_event_id, l_last_event_id)
165008: LOOP
165009: IF (NOT l_array_header_events.EXISTS(line_record.event_id)) AND (NOT l_array_duplicate_checker.EXISTS(line_record.event_id)) THEN

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

165006:
165007: FOR line_record IN line_cur(l_first_event_id, l_last_event_id)
165008: LOOP
165009: IF (NOT l_array_header_events.EXISTS(line_record.event_id)) AND (NOT l_array_duplicate_checker.EXISTS(line_record.event_id)) THEN
165010: fnd_file.put_line(fnd_file.log, 'Event_id = ' || line_record.event_id);
165011: l_array_duplicate_checker(line_record.event_id) := line_record.event_id;
165012: END IF;
165013: END LOOP;
165014:

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

165011: l_array_duplicate_checker(line_record.event_id) := line_record.event_id;
165012: END IF;
165013: END LOOP;
165014:
165015: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
165016: fnd_file.put_line(fnd_file.LOG, ' ');
165017:
165018:
165019: xla_exceptions_pkg.raise_message

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

165012: END IF;
165013: END LOOP;
165014:
165015: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
165016: fnd_file.put_line(fnd_file.LOG, ' ');
165017:
165018:
165019: xla_exceptions_pkg.raise_message
165020: (p_location => 'XLA_00200_AAD_S_000002_PKG.EventClass_236');

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

168142:
168143: l_first_event_id := l_array_header_events(l_array_header_events.FIRST);
168144: l_last_event_id := l_array_header_events(l_array_header_events.LAST);
168145:
168146: fnd_file.put_line(fnd_file.LOG, ' ');
168147: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
168148: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );
168149: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');
168150:

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

168143: l_first_event_id := l_array_header_events(l_array_header_events.FIRST);
168144: l_last_event_id := l_array_header_events(l_array_header_events.LAST);
168145:
168146: fnd_file.put_line(fnd_file.LOG, ' ');
168147: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
168148: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );
168149: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');
168150:
168151: FOR line_record IN line_cur(l_first_event_id, l_last_event_id)

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

168144: l_last_event_id := l_array_header_events(l_array_header_events.LAST);
168145:
168146: fnd_file.put_line(fnd_file.LOG, ' ');
168147: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
168148: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );
168149: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');
168150:
168151: FOR line_record IN line_cur(l_first_event_id, l_last_event_id)
168152: LOOP

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

168145:
168146: fnd_file.put_line(fnd_file.LOG, ' ');
168147: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
168148: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );
168149: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');
168150:
168151: FOR line_record IN line_cur(l_first_event_id, l_last_event_id)
168152: LOOP
168153: IF (NOT l_array_header_events.EXISTS(line_record.event_id)) AND (NOT l_array_duplicate_checker.EXISTS(line_record.event_id)) THEN

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

168150:
168151: FOR line_record IN line_cur(l_first_event_id, l_last_event_id)
168152: LOOP
168153: IF (NOT l_array_header_events.EXISTS(line_record.event_id)) AND (NOT l_array_duplicate_checker.EXISTS(line_record.event_id)) THEN
168154: fnd_file.put_line(fnd_file.log, 'Event_id = ' || line_record.event_id);
168155: l_array_duplicate_checker(line_record.event_id) := line_record.event_id;
168156: END IF;
168157: END LOOP;
168158:

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

168155: l_array_duplicate_checker(line_record.event_id) := line_record.event_id;
168156: END IF;
168157: END LOOP;
168158:
168159: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
168160: fnd_file.put_line(fnd_file.LOG, ' ');
168161:
168162:
168163: xla_exceptions_pkg.raise_message

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

168156: END IF;
168157: END LOOP;
168158:
168159: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
168160: fnd_file.put_line(fnd_file.LOG, ' ');
168161:
168162:
168163: xla_exceptions_pkg.raise_message
168164: (p_location => 'XLA_00200_AAD_S_000002_PKG.EventClass_237');

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

170660:
170661: l_first_event_id := l_array_header_events(l_array_header_events.FIRST);
170662: l_last_event_id := l_array_header_events(l_array_header_events.LAST);
170663:
170664: fnd_file.put_line(fnd_file.LOG, ' ');
170665: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
170666: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );
170667: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');
170668:

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

170661: l_first_event_id := l_array_header_events(l_array_header_events.FIRST);
170662: l_last_event_id := l_array_header_events(l_array_header_events.LAST);
170663:
170664: fnd_file.put_line(fnd_file.LOG, ' ');
170665: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
170666: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );
170667: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');
170668:
170669: FOR line_record IN line_cur(l_first_event_id, l_last_event_id)

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

170662: l_last_event_id := l_array_header_events(l_array_header_events.LAST);
170663:
170664: fnd_file.put_line(fnd_file.LOG, ' ');
170665: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
170666: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );
170667: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');
170668:
170669: FOR line_record IN line_cur(l_first_event_id, l_last_event_id)
170670: LOOP

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

170663:
170664: fnd_file.put_line(fnd_file.LOG, ' ');
170665: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
170666: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );
170667: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');
170668:
170669: FOR line_record IN line_cur(l_first_event_id, l_last_event_id)
170670: LOOP
170671: IF (NOT l_array_header_events.EXISTS(line_record.event_id)) AND (NOT l_array_duplicate_checker.EXISTS(line_record.event_id)) THEN

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

170668:
170669: FOR line_record IN line_cur(l_first_event_id, l_last_event_id)
170670: LOOP
170671: IF (NOT l_array_header_events.EXISTS(line_record.event_id)) AND (NOT l_array_duplicate_checker.EXISTS(line_record.event_id)) THEN
170672: fnd_file.put_line(fnd_file.log, 'Event_id = ' || line_record.event_id);
170673: l_array_duplicate_checker(line_record.event_id) := line_record.event_id;
170674: END IF;
170675: END LOOP;
170676:

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

170673: l_array_duplicate_checker(line_record.event_id) := line_record.event_id;
170674: END IF;
170675: END LOOP;
170676:
170677: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
170678: fnd_file.put_line(fnd_file.LOG, ' ');
170679:
170680:
170681: xla_exceptions_pkg.raise_message

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

170674: END IF;
170675: END LOOP;
170676:
170677: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
170678: fnd_file.put_line(fnd_file.LOG, ' ');
170679:
170680:
170681: xla_exceptions_pkg.raise_message
170682: (p_location => 'XLA_00200_AAD_S_000002_PKG.EventClass_238');