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

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

147031:
147032: l_first_event_id := l_array_header_events(l_array_header_events.FIRST);
147033: l_last_event_id := l_array_header_events(l_array_header_events.LAST);
147034:
147035: fnd_file.put_line(fnd_file.LOG, ' ');
147036: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
147037: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );
147038: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');
147039:

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

147032: l_first_event_id := l_array_header_events(l_array_header_events.FIRST);
147033: l_last_event_id := l_array_header_events(l_array_header_events.LAST);
147034:
147035: fnd_file.put_line(fnd_file.LOG, ' ');
147036: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
147037: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );
147038: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');
147039:
147040: FOR line_record IN line_cur(l_first_event_id, l_last_event_id)

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

147033: l_last_event_id := l_array_header_events(l_array_header_events.LAST);
147034:
147035: fnd_file.put_line(fnd_file.LOG, ' ');
147036: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
147037: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );
147038: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');
147039:
147040: FOR line_record IN line_cur(l_first_event_id, l_last_event_id)
147041: LOOP

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

147034:
147035: fnd_file.put_line(fnd_file.LOG, ' ');
147036: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
147037: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );
147038: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');
147039:
147040: FOR line_record IN line_cur(l_first_event_id, l_last_event_id)
147041: LOOP
147042: IF (NOT l_array_header_events.EXISTS(line_record.event_id)) AND (NOT l_array_duplicate_checker.EXISTS(line_record.event_id)) THEN

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

147039:
147040: FOR line_record IN line_cur(l_first_event_id, l_last_event_id)
147041: LOOP
147042: IF (NOT l_array_header_events.EXISTS(line_record.event_id)) AND (NOT l_array_duplicate_checker.EXISTS(line_record.event_id)) THEN
147043: fnd_file.put_line(fnd_file.log, 'Event_id = ' || line_record.event_id);
147044: l_array_duplicate_checker(line_record.event_id) := line_record.event_id;
147045: END IF;
147046: END LOOP;
147047:

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

147044: l_array_duplicate_checker(line_record.event_id) := line_record.event_id;
147045: END IF;
147046: END LOOP;
147047:
147048: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
147049: fnd_file.put_line(fnd_file.LOG, ' ');
147050:
147051:
147052: xla_exceptions_pkg.raise_message

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

147045: END IF;
147046: END LOOP;
147047:
147048: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
147049: fnd_file.put_line(fnd_file.LOG, ' ');
147050:
147051:
147052: xla_exceptions_pkg.raise_message
147053: (p_location => 'XLA_00200_AAD_S_000020_PKG.EventClass_226');

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

150297:
150298: l_first_event_id := l_array_header_events(l_array_header_events.FIRST);
150299: l_last_event_id := l_array_header_events(l_array_header_events.LAST);
150300:
150301: fnd_file.put_line(fnd_file.LOG, ' ');
150302: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
150303: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );
150304: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');
150305:

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

150298: l_first_event_id := l_array_header_events(l_array_header_events.FIRST);
150299: l_last_event_id := l_array_header_events(l_array_header_events.LAST);
150300:
150301: fnd_file.put_line(fnd_file.LOG, ' ');
150302: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
150303: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );
150304: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');
150305:
150306: FOR line_record IN line_cur(l_first_event_id, l_last_event_id)

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

150299: l_last_event_id := l_array_header_events(l_array_header_events.LAST);
150300:
150301: fnd_file.put_line(fnd_file.LOG, ' ');
150302: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
150303: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );
150304: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');
150305:
150306: FOR line_record IN line_cur(l_first_event_id, l_last_event_id)
150307: LOOP

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

150300:
150301: fnd_file.put_line(fnd_file.LOG, ' ');
150302: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
150303: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );
150304: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');
150305:
150306: FOR line_record IN line_cur(l_first_event_id, l_last_event_id)
150307: LOOP
150308: IF (NOT l_array_header_events.EXISTS(line_record.event_id)) AND (NOT l_array_duplicate_checker.EXISTS(line_record.event_id)) THEN

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

150305:
150306: FOR line_record IN line_cur(l_first_event_id, l_last_event_id)
150307: LOOP
150308: IF (NOT l_array_header_events.EXISTS(line_record.event_id)) AND (NOT l_array_duplicate_checker.EXISTS(line_record.event_id)) THEN
150309: fnd_file.put_line(fnd_file.log, 'Event_id = ' || line_record.event_id);
150310: l_array_duplicate_checker(line_record.event_id) := line_record.event_id;
150311: END IF;
150312: END LOOP;
150313:

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

150310: l_array_duplicate_checker(line_record.event_id) := line_record.event_id;
150311: END IF;
150312: END LOOP;
150313:
150314: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
150315: fnd_file.put_line(fnd_file.LOG, ' ');
150316:
150317:
150318: xla_exceptions_pkg.raise_message

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

150311: END IF;
150312: END LOOP;
150313:
150314: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
150315: fnd_file.put_line(fnd_file.LOG, ' ');
150316:
150317:
150318: xla_exceptions_pkg.raise_message
150319: (p_location => 'XLA_00200_AAD_S_000020_PKG.EventClass_227');

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

152695:
152696: l_first_event_id := l_array_header_events(l_array_header_events.FIRST);
152697: l_last_event_id := l_array_header_events(l_array_header_events.LAST);
152698:
152699: fnd_file.put_line(fnd_file.LOG, ' ');
152700: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
152701: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );
152702: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');
152703:

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

152696: l_first_event_id := l_array_header_events(l_array_header_events.FIRST);
152697: l_last_event_id := l_array_header_events(l_array_header_events.LAST);
152698:
152699: fnd_file.put_line(fnd_file.LOG, ' ');
152700: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
152701: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );
152702: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');
152703:
152704: FOR line_record IN line_cur(l_first_event_id, l_last_event_id)

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

152697: l_last_event_id := l_array_header_events(l_array_header_events.LAST);
152698:
152699: fnd_file.put_line(fnd_file.LOG, ' ');
152700: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
152701: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );
152702: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');
152703:
152704: FOR line_record IN line_cur(l_first_event_id, l_last_event_id)
152705: LOOP

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

152698:
152699: fnd_file.put_line(fnd_file.LOG, ' ');
152700: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
152701: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );
152702: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');
152703:
152704: FOR line_record IN line_cur(l_first_event_id, l_last_event_id)
152705: LOOP
152706: IF (NOT l_array_header_events.EXISTS(line_record.event_id)) AND (NOT l_array_duplicate_checker.EXISTS(line_record.event_id)) THEN

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

152703:
152704: FOR line_record IN line_cur(l_first_event_id, l_last_event_id)
152705: LOOP
152706: IF (NOT l_array_header_events.EXISTS(line_record.event_id)) AND (NOT l_array_duplicate_checker.EXISTS(line_record.event_id)) THEN
152707: fnd_file.put_line(fnd_file.log, 'Event_id = ' || line_record.event_id);
152708: l_array_duplicate_checker(line_record.event_id) := line_record.event_id;
152709: END IF;
152710: END LOOP;
152711:

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

152708: l_array_duplicate_checker(line_record.event_id) := line_record.event_id;
152709: END IF;
152710: END LOOP;
152711:
152712: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
152713: fnd_file.put_line(fnd_file.LOG, ' ');
152714:
152715:
152716: xla_exceptions_pkg.raise_message

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

152709: END IF;
152710: END LOOP;
152711:
152712: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
152713: fnd_file.put_line(fnd_file.LOG, ' ');
152714:
152715:
152716: xla_exceptions_pkg.raise_message
152717: (p_location => 'XLA_00200_AAD_S_000020_PKG.EventClass_228');

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

156102:
156103: l_first_event_id := l_array_header_events(l_array_header_events.FIRST);
156104: l_last_event_id := l_array_header_events(l_array_header_events.LAST);
156105:
156106: fnd_file.put_line(fnd_file.LOG, ' ');
156107: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
156108: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );
156109: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');
156110:

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

156103: l_first_event_id := l_array_header_events(l_array_header_events.FIRST);
156104: l_last_event_id := l_array_header_events(l_array_header_events.LAST);
156105:
156106: fnd_file.put_line(fnd_file.LOG, ' ');
156107: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
156108: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );
156109: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');
156110:
156111: FOR line_record IN line_cur(l_first_event_id, l_last_event_id)

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

156104: l_last_event_id := l_array_header_events(l_array_header_events.LAST);
156105:
156106: fnd_file.put_line(fnd_file.LOG, ' ');
156107: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
156108: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );
156109: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');
156110:
156111: FOR line_record IN line_cur(l_first_event_id, l_last_event_id)
156112: LOOP

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

156105:
156106: fnd_file.put_line(fnd_file.LOG, ' ');
156107: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
156108: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );
156109: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');
156110:
156111: FOR line_record IN line_cur(l_first_event_id, l_last_event_id)
156112: LOOP
156113: IF (NOT l_array_header_events.EXISTS(line_record.event_id)) AND (NOT l_array_duplicate_checker.EXISTS(line_record.event_id)) THEN

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

156110:
156111: FOR line_record IN line_cur(l_first_event_id, l_last_event_id)
156112: LOOP
156113: IF (NOT l_array_header_events.EXISTS(line_record.event_id)) AND (NOT l_array_duplicate_checker.EXISTS(line_record.event_id)) THEN
156114: fnd_file.put_line(fnd_file.log, 'Event_id = ' || line_record.event_id);
156115: l_array_duplicate_checker(line_record.event_id) := line_record.event_id;
156116: END IF;
156117: END LOOP;
156118:

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

156115: l_array_duplicate_checker(line_record.event_id) := line_record.event_id;
156116: END IF;
156117: END LOOP;
156118:
156119: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
156120: fnd_file.put_line(fnd_file.LOG, ' ');
156121:
156122:
156123: xla_exceptions_pkg.raise_message

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

156116: END IF;
156117: END LOOP;
156118:
156119: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
156120: fnd_file.put_line(fnd_file.LOG, ' ');
156121:
156122:
156123: xla_exceptions_pkg.raise_message
156124: (p_location => 'XLA_00200_AAD_S_000020_PKG.EventClass_229');

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

159235:
159236: l_first_event_id := l_array_header_events(l_array_header_events.FIRST);
159237: l_last_event_id := l_array_header_events(l_array_header_events.LAST);
159238:
159239: fnd_file.put_line(fnd_file.LOG, ' ');
159240: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
159241: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );
159242: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');
159243:

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

159236: l_first_event_id := l_array_header_events(l_array_header_events.FIRST);
159237: l_last_event_id := l_array_header_events(l_array_header_events.LAST);
159238:
159239: fnd_file.put_line(fnd_file.LOG, ' ');
159240: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
159241: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );
159242: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');
159243:
159244: FOR line_record IN line_cur(l_first_event_id, l_last_event_id)

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

159237: l_last_event_id := l_array_header_events(l_array_header_events.LAST);
159238:
159239: fnd_file.put_line(fnd_file.LOG, ' ');
159240: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
159241: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );
159242: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');
159243:
159244: FOR line_record IN line_cur(l_first_event_id, l_last_event_id)
159245: LOOP

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

159238:
159239: fnd_file.put_line(fnd_file.LOG, ' ');
159240: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
159241: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );
159242: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');
159243:
159244: FOR line_record IN line_cur(l_first_event_id, l_last_event_id)
159245: LOOP
159246: IF (NOT l_array_header_events.EXISTS(line_record.event_id)) AND (NOT l_array_duplicate_checker.EXISTS(line_record.event_id)) THEN

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

159243:
159244: FOR line_record IN line_cur(l_first_event_id, l_last_event_id)
159245: LOOP
159246: IF (NOT l_array_header_events.EXISTS(line_record.event_id)) AND (NOT l_array_duplicate_checker.EXISTS(line_record.event_id)) THEN
159247: fnd_file.put_line(fnd_file.log, 'Event_id = ' || line_record.event_id);
159248: l_array_duplicate_checker(line_record.event_id) := line_record.event_id;
159249: END IF;
159250: END LOOP;
159251:

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

159248: l_array_duplicate_checker(line_record.event_id) := line_record.event_id;
159249: END IF;
159250: END LOOP;
159251:
159252: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
159253: fnd_file.put_line(fnd_file.LOG, ' ');
159254:
159255:
159256: xla_exceptions_pkg.raise_message

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

159249: END IF;
159250: END LOOP;
159251:
159252: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
159253: fnd_file.put_line(fnd_file.LOG, ' ');
159254:
159255:
159256: xla_exceptions_pkg.raise_message
159257: (p_location => 'XLA_00200_AAD_S_000020_PKG.EventClass_230');

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

161522:
161523: l_first_event_id := l_array_header_events(l_array_header_events.FIRST);
161524: l_last_event_id := l_array_header_events(l_array_header_events.LAST);
161525:
161526: fnd_file.put_line(fnd_file.LOG, ' ');
161527: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
161528: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );
161529: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');
161530:

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

161523: l_first_event_id := l_array_header_events(l_array_header_events.FIRST);
161524: l_last_event_id := l_array_header_events(l_array_header_events.LAST);
161525:
161526: fnd_file.put_line(fnd_file.LOG, ' ');
161527: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
161528: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );
161529: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');
161530:
161531: FOR line_record IN line_cur(l_first_event_id, l_last_event_id)

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

161524: l_last_event_id := l_array_header_events(l_array_header_events.LAST);
161525:
161526: fnd_file.put_line(fnd_file.LOG, ' ');
161527: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
161528: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );
161529: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');
161530:
161531: FOR line_record IN line_cur(l_first_event_id, l_last_event_id)
161532: LOOP

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

161525:
161526: fnd_file.put_line(fnd_file.LOG, ' ');
161527: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
161528: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );
161529: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');
161530:
161531: FOR line_record IN line_cur(l_first_event_id, l_last_event_id)
161532: LOOP
161533: IF (NOT l_array_header_events.EXISTS(line_record.event_id)) AND (NOT l_array_duplicate_checker.EXISTS(line_record.event_id)) THEN

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

161530:
161531: FOR line_record IN line_cur(l_first_event_id, l_last_event_id)
161532: LOOP
161533: IF (NOT l_array_header_events.EXISTS(line_record.event_id)) AND (NOT l_array_duplicate_checker.EXISTS(line_record.event_id)) THEN
161534: fnd_file.put_line(fnd_file.log, 'Event_id = ' || line_record.event_id);
161535: l_array_duplicate_checker(line_record.event_id) := line_record.event_id;
161536: END IF;
161537: END LOOP;
161538:

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

161535: l_array_duplicate_checker(line_record.event_id) := line_record.event_id;
161536: END IF;
161537: END LOOP;
161538:
161539: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
161540: fnd_file.put_line(fnd_file.LOG, ' ');
161541:
161542:
161543: xla_exceptions_pkg.raise_message

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

161536: END IF;
161537: END LOOP;
161538:
161539: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
161540: fnd_file.put_line(fnd_file.LOG, ' ');
161541:
161542:
161543: xla_exceptions_pkg.raise_message
161544: (p_location => 'XLA_00200_AAD_S_000020_PKG.EventClass_231');

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

164828:
164829: l_first_event_id := l_array_header_events(l_array_header_events.FIRST);
164830: l_last_event_id := l_array_header_events(l_array_header_events.LAST);
164831:
164832: fnd_file.put_line(fnd_file.LOG, ' ');
164833: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
164834: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );
164835: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');
164836:

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

164829: l_first_event_id := l_array_header_events(l_array_header_events.FIRST);
164830: l_last_event_id := l_array_header_events(l_array_header_events.LAST);
164831:
164832: fnd_file.put_line(fnd_file.LOG, ' ');
164833: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
164834: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );
164835: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');
164836:
164837: FOR line_record IN line_cur(l_first_event_id, l_last_event_id)

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

164830: l_last_event_id := l_array_header_events(l_array_header_events.LAST);
164831:
164832: fnd_file.put_line(fnd_file.LOG, ' ');
164833: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
164834: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );
164835: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');
164836:
164837: FOR line_record IN line_cur(l_first_event_id, l_last_event_id)
164838: LOOP

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

164831:
164832: fnd_file.put_line(fnd_file.LOG, ' ');
164833: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
164834: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );
164835: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');
164836:
164837: FOR line_record IN line_cur(l_first_event_id, l_last_event_id)
164838: LOOP
164839: IF (NOT l_array_header_events.EXISTS(line_record.event_id)) AND (NOT l_array_duplicate_checker.EXISTS(line_record.event_id)) THEN

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

164836:
164837: FOR line_record IN line_cur(l_first_event_id, l_last_event_id)
164838: LOOP
164839: IF (NOT l_array_header_events.EXISTS(line_record.event_id)) AND (NOT l_array_duplicate_checker.EXISTS(line_record.event_id)) THEN
164840: fnd_file.put_line(fnd_file.log, 'Event_id = ' || line_record.event_id);
164841: l_array_duplicate_checker(line_record.event_id) := line_record.event_id;
164842: END IF;
164843: END LOOP;
164844:

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

164841: l_array_duplicate_checker(line_record.event_id) := line_record.event_id;
164842: END IF;
164843: END LOOP;
164844:
164845: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
164846: fnd_file.put_line(fnd_file.LOG, ' ');
164847:
164848:
164849: xla_exceptions_pkg.raise_message

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

164842: END IF;
164843: END LOOP;
164844:
164845: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
164846: fnd_file.put_line(fnd_file.LOG, ' ');
164847:
164848:
164849: xla_exceptions_pkg.raise_message
164850: (p_location => 'XLA_00200_AAD_S_000020_PKG.EventClass_232');

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

167952:
167953: l_first_event_id := l_array_header_events(l_array_header_events.FIRST);
167954: l_last_event_id := l_array_header_events(l_array_header_events.LAST);
167955:
167956: fnd_file.put_line(fnd_file.LOG, ' ');
167957: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
167958: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );
167959: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');
167960:

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

167953: l_first_event_id := l_array_header_events(l_array_header_events.FIRST);
167954: l_last_event_id := l_array_header_events(l_array_header_events.LAST);
167955:
167956: fnd_file.put_line(fnd_file.LOG, ' ');
167957: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
167958: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );
167959: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');
167960:
167961: FOR line_record IN line_cur(l_first_event_id, l_last_event_id)

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

167954: l_last_event_id := l_array_header_events(l_array_header_events.LAST);
167955:
167956: fnd_file.put_line(fnd_file.LOG, ' ');
167957: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
167958: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );
167959: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');
167960:
167961: FOR line_record IN line_cur(l_first_event_id, l_last_event_id)
167962: LOOP

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

167955:
167956: fnd_file.put_line(fnd_file.LOG, ' ');
167957: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
167958: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );
167959: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');
167960:
167961: FOR line_record IN line_cur(l_first_event_id, l_last_event_id)
167962: LOOP
167963: IF (NOT l_array_header_events.EXISTS(line_record.event_id)) AND (NOT l_array_duplicate_checker.EXISTS(line_record.event_id)) THEN

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

167960:
167961: FOR line_record IN line_cur(l_first_event_id, l_last_event_id)
167962: LOOP
167963: IF (NOT l_array_header_events.EXISTS(line_record.event_id)) AND (NOT l_array_duplicate_checker.EXISTS(line_record.event_id)) THEN
167964: fnd_file.put_line(fnd_file.log, 'Event_id = ' || line_record.event_id);
167965: l_array_duplicate_checker(line_record.event_id) := line_record.event_id;
167966: END IF;
167967: END LOOP;
167968:

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

167965: l_array_duplicate_checker(line_record.event_id) := line_record.event_id;
167966: END IF;
167967: END LOOP;
167968:
167969: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
167970: fnd_file.put_line(fnd_file.LOG, ' ');
167971:
167972:
167973: xla_exceptions_pkg.raise_message

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

167966: END IF;
167967: END LOOP;
167968:
167969: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
167970: fnd_file.put_line(fnd_file.LOG, ' ');
167971:
167972:
167973: xla_exceptions_pkg.raise_message
167974: (p_location => 'XLA_00200_AAD_S_000020_PKG.EventClass_233');

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

170494:
170495: l_first_event_id := l_array_header_events(l_array_header_events.FIRST);
170496: l_last_event_id := l_array_header_events(l_array_header_events.LAST);
170497:
170498: fnd_file.put_line(fnd_file.LOG, ' ');
170499: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
170500: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );
170501: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');
170502:

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

170495: l_first_event_id := l_array_header_events(l_array_header_events.FIRST);
170496: l_last_event_id := l_array_header_events(l_array_header_events.LAST);
170497:
170498: fnd_file.put_line(fnd_file.LOG, ' ');
170499: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
170500: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );
170501: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');
170502:
170503: FOR line_record IN line_cur(l_first_event_id, l_last_event_id)

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

170496: l_last_event_id := l_array_header_events(l_array_header_events.LAST);
170497:
170498: fnd_file.put_line(fnd_file.LOG, ' ');
170499: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
170500: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );
170501: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');
170502:
170503: FOR line_record IN line_cur(l_first_event_id, l_last_event_id)
170504: LOOP

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

170497:
170498: fnd_file.put_line(fnd_file.LOG, ' ');
170499: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
170500: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );
170501: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');
170502:
170503: FOR line_record IN line_cur(l_first_event_id, l_last_event_id)
170504: LOOP
170505: IF (NOT l_array_header_events.EXISTS(line_record.event_id)) AND (NOT l_array_duplicate_checker.EXISTS(line_record.event_id)) THEN

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

170502:
170503: FOR line_record IN line_cur(l_first_event_id, l_last_event_id)
170504: LOOP
170505: IF (NOT l_array_header_events.EXISTS(line_record.event_id)) AND (NOT l_array_duplicate_checker.EXISTS(line_record.event_id)) THEN
170506: fnd_file.put_line(fnd_file.log, 'Event_id = ' || line_record.event_id);
170507: l_array_duplicate_checker(line_record.event_id) := line_record.event_id;
170508: END IF;
170509: END LOOP;
170510:

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

170507: l_array_duplicate_checker(line_record.event_id) := line_record.event_id;
170508: END IF;
170509: END LOOP;
170510:
170511: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
170512: fnd_file.put_line(fnd_file.LOG, ' ');
170513:
170514:
170515: xla_exceptions_pkg.raise_message

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

170508: END IF;
170509: END LOOP;
170510:
170511: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
170512: fnd_file.put_line(fnd_file.LOG, ' ');
170513:
170514:
170515: xla_exceptions_pkg.raise_message
170516: (p_location => 'XLA_00200_AAD_S_000020_PKG.EventClass_234');