APPS.XLA_00140_AAD_S_000002_PKG dependencies on FND_FILE

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

180516:
180517: l_first_event_id := l_array_header_events(l_array_header_events.FIRST);
180518: l_last_event_id := l_array_header_events(l_array_header_events.LAST);
180519:
180520: fnd_file.put_line(fnd_file.LOG, ' ');
180521: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
180522: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );
180523: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');
180524:

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

180517: l_first_event_id := l_array_header_events(l_array_header_events.FIRST);
180518: l_last_event_id := l_array_header_events(l_array_header_events.LAST);
180519:
180520: fnd_file.put_line(fnd_file.LOG, ' ');
180521: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
180522: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );
180523: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');
180524:
180525: FOR line_record IN line_cur(l_first_event_id, l_last_event_id)

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

180518: l_last_event_id := l_array_header_events(l_array_header_events.LAST);
180519:
180520: fnd_file.put_line(fnd_file.LOG, ' ');
180521: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
180522: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );
180523: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');
180524:
180525: FOR line_record IN line_cur(l_first_event_id, l_last_event_id)
180526: LOOP

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

180519:
180520: fnd_file.put_line(fnd_file.LOG, ' ');
180521: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
180522: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );
180523: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');
180524:
180525: FOR line_record IN line_cur(l_first_event_id, l_last_event_id)
180526: LOOP
180527: IF (NOT l_array_header_events.EXISTS(line_record.event_id)) AND (NOT l_array_duplicate_checker.EXISTS(line_record.event_id)) THEN

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

180524:
180525: FOR line_record IN line_cur(l_first_event_id, l_last_event_id)
180526: LOOP
180527: IF (NOT l_array_header_events.EXISTS(line_record.event_id)) AND (NOT l_array_duplicate_checker.EXISTS(line_record.event_id)) THEN
180528: fnd_file.put_line(fnd_file.log, 'Event_id = ' || line_record.event_id);
180529: l_array_duplicate_checker(line_record.event_id) := line_record.event_id;
180530: END IF;
180531: END LOOP;
180532:

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

180529: l_array_duplicate_checker(line_record.event_id) := line_record.event_id;
180530: END IF;
180531: END LOOP;
180532:
180533: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
180534: fnd_file.put_line(fnd_file.LOG, ' ');
180535:
180536:
180537: xla_exceptions_pkg.raise_message

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

180530: END IF;
180531: END LOOP;
180532:
180533: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
180534: fnd_file.put_line(fnd_file.LOG, ' ');
180535:
180536:
180537: xla_exceptions_pkg.raise_message
180538: (p_location => 'XLA_00140_AAD_S_000002_PKG.EventClass_407');

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

182012:
182013: l_first_event_id := l_array_header_events(l_array_header_events.FIRST);
182014: l_last_event_id := l_array_header_events(l_array_header_events.LAST);
182015:
182016: fnd_file.put_line(fnd_file.LOG, ' ');
182017: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
182018: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );
182019: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');
182020:

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

182013: l_first_event_id := l_array_header_events(l_array_header_events.FIRST);
182014: l_last_event_id := l_array_header_events(l_array_header_events.LAST);
182015:
182016: fnd_file.put_line(fnd_file.LOG, ' ');
182017: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
182018: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );
182019: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');
182020:
182021: FOR line_record IN line_cur(l_first_event_id, l_last_event_id)

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

182014: l_last_event_id := l_array_header_events(l_array_header_events.LAST);
182015:
182016: fnd_file.put_line(fnd_file.LOG, ' ');
182017: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
182018: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );
182019: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');
182020:
182021: FOR line_record IN line_cur(l_first_event_id, l_last_event_id)
182022: LOOP

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

182015:
182016: fnd_file.put_line(fnd_file.LOG, ' ');
182017: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
182018: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );
182019: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');
182020:
182021: FOR line_record IN line_cur(l_first_event_id, l_last_event_id)
182022: LOOP
182023: IF (NOT l_array_header_events.EXISTS(line_record.event_id)) AND (NOT l_array_duplicate_checker.EXISTS(line_record.event_id)) THEN

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

182020:
182021: FOR line_record IN line_cur(l_first_event_id, l_last_event_id)
182022: LOOP
182023: IF (NOT l_array_header_events.EXISTS(line_record.event_id)) AND (NOT l_array_duplicate_checker.EXISTS(line_record.event_id)) THEN
182024: fnd_file.put_line(fnd_file.log, 'Event_id = ' || line_record.event_id);
182025: l_array_duplicate_checker(line_record.event_id) := line_record.event_id;
182026: END IF;
182027: END LOOP;
182028:

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

182025: l_array_duplicate_checker(line_record.event_id) := line_record.event_id;
182026: END IF;
182027: END LOOP;
182028:
182029: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
182030: fnd_file.put_line(fnd_file.LOG, ' ');
182031:
182032:
182033: xla_exceptions_pkg.raise_message

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

182026: END IF;
182027: END LOOP;
182028:
182029: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
182030: fnd_file.put_line(fnd_file.LOG, ' ');
182031:
182032:
182033: xla_exceptions_pkg.raise_message
182034: (p_location => 'XLA_00140_AAD_S_000002_PKG.EventClass_408');

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

183429:
183430: l_first_event_id := l_array_header_events(l_array_header_events.FIRST);
183431: l_last_event_id := l_array_header_events(l_array_header_events.LAST);
183432:
183433: fnd_file.put_line(fnd_file.LOG, ' ');
183434: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
183435: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );
183436: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');
183437:

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

183430: l_first_event_id := l_array_header_events(l_array_header_events.FIRST);
183431: l_last_event_id := l_array_header_events(l_array_header_events.LAST);
183432:
183433: fnd_file.put_line(fnd_file.LOG, ' ');
183434: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
183435: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );
183436: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');
183437:
183438: FOR line_record IN line_cur(l_first_event_id, l_last_event_id)

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

183431: l_last_event_id := l_array_header_events(l_array_header_events.LAST);
183432:
183433: fnd_file.put_line(fnd_file.LOG, ' ');
183434: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
183435: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );
183436: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');
183437:
183438: FOR line_record IN line_cur(l_first_event_id, l_last_event_id)
183439: LOOP

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

183432:
183433: fnd_file.put_line(fnd_file.LOG, ' ');
183434: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
183435: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );
183436: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');
183437:
183438: FOR line_record IN line_cur(l_first_event_id, l_last_event_id)
183439: LOOP
183440: IF (NOT l_array_header_events.EXISTS(line_record.event_id)) AND (NOT l_array_duplicate_checker.EXISTS(line_record.event_id)) THEN

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

183437:
183438: FOR line_record IN line_cur(l_first_event_id, l_last_event_id)
183439: LOOP
183440: IF (NOT l_array_header_events.EXISTS(line_record.event_id)) AND (NOT l_array_duplicate_checker.EXISTS(line_record.event_id)) THEN
183441: fnd_file.put_line(fnd_file.log, 'Event_id = ' || line_record.event_id);
183442: l_array_duplicate_checker(line_record.event_id) := line_record.event_id;
183443: END IF;
183444: END LOOP;
183445:

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

183442: l_array_duplicate_checker(line_record.event_id) := line_record.event_id;
183443: END IF;
183444: END LOOP;
183445:
183446: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
183447: fnd_file.put_line(fnd_file.LOG, ' ');
183448:
183449:
183450: xla_exceptions_pkg.raise_message

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

183443: END IF;
183444: END LOOP;
183445:
183446: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
183447: fnd_file.put_line(fnd_file.LOG, ' ');
183448:
183449:
183450: xla_exceptions_pkg.raise_message
183451: (p_location => 'XLA_00140_AAD_S_000002_PKG.EventType_409');

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

184983:
184984: l_first_event_id := l_array_header_events(l_array_header_events.FIRST);
184985: l_last_event_id := l_array_header_events(l_array_header_events.LAST);
184986:
184987: fnd_file.put_line(fnd_file.LOG, ' ');
184988: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
184989: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );
184990: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');
184991:

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

184984: l_first_event_id := l_array_header_events(l_array_header_events.FIRST);
184985: l_last_event_id := l_array_header_events(l_array_header_events.LAST);
184986:
184987: fnd_file.put_line(fnd_file.LOG, ' ');
184988: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
184989: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );
184990: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');
184991:
184992: FOR line_record IN line_cur(l_first_event_id, l_last_event_id)

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

184985: l_last_event_id := l_array_header_events(l_array_header_events.LAST);
184986:
184987: fnd_file.put_line(fnd_file.LOG, ' ');
184988: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
184989: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );
184990: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');
184991:
184992: FOR line_record IN line_cur(l_first_event_id, l_last_event_id)
184993: LOOP

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

184986:
184987: fnd_file.put_line(fnd_file.LOG, ' ');
184988: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
184989: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );
184990: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');
184991:
184992: FOR line_record IN line_cur(l_first_event_id, l_last_event_id)
184993: LOOP
184994: IF (NOT l_array_header_events.EXISTS(line_record.event_id)) AND (NOT l_array_duplicate_checker.EXISTS(line_record.event_id)) THEN

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

184991:
184992: FOR line_record IN line_cur(l_first_event_id, l_last_event_id)
184993: LOOP
184994: IF (NOT l_array_header_events.EXISTS(line_record.event_id)) AND (NOT l_array_duplicate_checker.EXISTS(line_record.event_id)) THEN
184995: fnd_file.put_line(fnd_file.log, 'Event_id = ' || line_record.event_id);
184996: l_array_duplicate_checker(line_record.event_id) := line_record.event_id;
184997: END IF;
184998: END LOOP;
184999:

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

184996: l_array_duplicate_checker(line_record.event_id) := line_record.event_id;
184997: END IF;
184998: END LOOP;
184999:
185000: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
185001: fnd_file.put_line(fnd_file.LOG, ' ');
185002:
185003:
185004: xla_exceptions_pkg.raise_message

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

184997: END IF;
184998: END LOOP;
184999:
185000: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
185001: fnd_file.put_line(fnd_file.LOG, ' ');
185002:
185003:
185004: xla_exceptions_pkg.raise_message
185005: (p_location => 'XLA_00140_AAD_S_000002_PKG.EventClass_410');

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

186202:
186203: l_first_event_id := l_array_header_events(l_array_header_events.FIRST);
186204: l_last_event_id := l_array_header_events(l_array_header_events.LAST);
186205:
186206: fnd_file.put_line(fnd_file.LOG, ' ');
186207: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
186208: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );
186209: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');
186210:

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

186203: l_first_event_id := l_array_header_events(l_array_header_events.FIRST);
186204: l_last_event_id := l_array_header_events(l_array_header_events.LAST);
186205:
186206: fnd_file.put_line(fnd_file.LOG, ' ');
186207: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
186208: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );
186209: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');
186210:
186211: FOR line_record IN line_cur(l_first_event_id, l_last_event_id)

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

186204: l_last_event_id := l_array_header_events(l_array_header_events.LAST);
186205:
186206: fnd_file.put_line(fnd_file.LOG, ' ');
186207: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
186208: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );
186209: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');
186210:
186211: FOR line_record IN line_cur(l_first_event_id, l_last_event_id)
186212: LOOP

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

186205:
186206: fnd_file.put_line(fnd_file.LOG, ' ');
186207: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
186208: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );
186209: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');
186210:
186211: FOR line_record IN line_cur(l_first_event_id, l_last_event_id)
186212: LOOP
186213: IF (NOT l_array_header_events.EXISTS(line_record.event_id)) AND (NOT l_array_duplicate_checker.EXISTS(line_record.event_id)) THEN

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

186210:
186211: FOR line_record IN line_cur(l_first_event_id, l_last_event_id)
186212: LOOP
186213: IF (NOT l_array_header_events.EXISTS(line_record.event_id)) AND (NOT l_array_duplicate_checker.EXISTS(line_record.event_id)) THEN
186214: fnd_file.put_line(fnd_file.log, 'Event_id = ' || line_record.event_id);
186215: l_array_duplicate_checker(line_record.event_id) := line_record.event_id;
186216: END IF;
186217: END LOOP;
186218:

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

186215: l_array_duplicate_checker(line_record.event_id) := line_record.event_id;
186216: END IF;
186217: END LOOP;
186218:
186219: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
186220: fnd_file.put_line(fnd_file.LOG, ' ');
186221:
186222:
186223: xla_exceptions_pkg.raise_message

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

186216: END IF;
186217: END LOOP;
186218:
186219: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
186220: fnd_file.put_line(fnd_file.LOG, ' ');
186221:
186222:
186223: xla_exceptions_pkg.raise_message
186224: (p_location => 'XLA_00140_AAD_S_000002_PKG.EventClass_411');

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

187421:
187422: l_first_event_id := l_array_header_events(l_array_header_events.FIRST);
187423: l_last_event_id := l_array_header_events(l_array_header_events.LAST);
187424:
187425: fnd_file.put_line(fnd_file.LOG, ' ');
187426: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
187427: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );
187428: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');
187429:

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

187422: l_first_event_id := l_array_header_events(l_array_header_events.FIRST);
187423: l_last_event_id := l_array_header_events(l_array_header_events.LAST);
187424:
187425: fnd_file.put_line(fnd_file.LOG, ' ');
187426: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
187427: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );
187428: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');
187429:
187430: FOR line_record IN line_cur(l_first_event_id, l_last_event_id)

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

187423: l_last_event_id := l_array_header_events(l_array_header_events.LAST);
187424:
187425: fnd_file.put_line(fnd_file.LOG, ' ');
187426: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
187427: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );
187428: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');
187429:
187430: FOR line_record IN line_cur(l_first_event_id, l_last_event_id)
187431: LOOP

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

187424:
187425: fnd_file.put_line(fnd_file.LOG, ' ');
187426: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
187427: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );
187428: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');
187429:
187430: FOR line_record IN line_cur(l_first_event_id, l_last_event_id)
187431: LOOP
187432: IF (NOT l_array_header_events.EXISTS(line_record.event_id)) AND (NOT l_array_duplicate_checker.EXISTS(line_record.event_id)) THEN

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

187429:
187430: FOR line_record IN line_cur(l_first_event_id, l_last_event_id)
187431: LOOP
187432: IF (NOT l_array_header_events.EXISTS(line_record.event_id)) AND (NOT l_array_duplicate_checker.EXISTS(line_record.event_id)) THEN
187433: fnd_file.put_line(fnd_file.log, 'Event_id = ' || line_record.event_id);
187434: l_array_duplicate_checker(line_record.event_id) := line_record.event_id;
187435: END IF;
187436: END LOOP;
187437:

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

187434: l_array_duplicate_checker(line_record.event_id) := line_record.event_id;
187435: END IF;
187436: END LOOP;
187437:
187438: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
187439: fnd_file.put_line(fnd_file.LOG, ' ');
187440:
187441:
187442: xla_exceptions_pkg.raise_message

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

187435: END IF;
187436: END LOOP;
187437:
187438: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
187439: fnd_file.put_line(fnd_file.LOG, ' ');
187440:
187441:
187442: xla_exceptions_pkg.raise_message
187443: (p_location => 'XLA_00140_AAD_S_000002_PKG.EventClass_412');

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

188701:
188702: l_first_event_id := l_array_header_events(l_array_header_events.FIRST);
188703: l_last_event_id := l_array_header_events(l_array_header_events.LAST);
188704:
188705: fnd_file.put_line(fnd_file.LOG, ' ');
188706: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
188707: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );
188708: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');
188709:

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

188702: l_first_event_id := l_array_header_events(l_array_header_events.FIRST);
188703: l_last_event_id := l_array_header_events(l_array_header_events.LAST);
188704:
188705: fnd_file.put_line(fnd_file.LOG, ' ');
188706: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
188707: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );
188708: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');
188709:
188710: FOR line_record IN line_cur(l_first_event_id, l_last_event_id)

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

188703: l_last_event_id := l_array_header_events(l_array_header_events.LAST);
188704:
188705: fnd_file.put_line(fnd_file.LOG, ' ');
188706: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
188707: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );
188708: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');
188709:
188710: FOR line_record IN line_cur(l_first_event_id, l_last_event_id)
188711: LOOP

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

188704:
188705: fnd_file.put_line(fnd_file.LOG, ' ');
188706: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
188707: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );
188708: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');
188709:
188710: FOR line_record IN line_cur(l_first_event_id, l_last_event_id)
188711: LOOP
188712: IF (NOT l_array_header_events.EXISTS(line_record.event_id)) AND (NOT l_array_duplicate_checker.EXISTS(line_record.event_id)) THEN

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

188709:
188710: FOR line_record IN line_cur(l_first_event_id, l_last_event_id)
188711: LOOP
188712: IF (NOT l_array_header_events.EXISTS(line_record.event_id)) AND (NOT l_array_duplicate_checker.EXISTS(line_record.event_id)) THEN
188713: fnd_file.put_line(fnd_file.log, 'Event_id = ' || line_record.event_id);
188714: l_array_duplicate_checker(line_record.event_id) := line_record.event_id;
188715: END IF;
188716: END LOOP;
188717:

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

188714: l_array_duplicate_checker(line_record.event_id) := line_record.event_id;
188715: END IF;
188716: END LOOP;
188717:
188718: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
188719: fnd_file.put_line(fnd_file.LOG, ' ');
188720:
188721:
188722: xla_exceptions_pkg.raise_message

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

188715: END IF;
188716: END LOOP;
188717:
188718: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
188719: fnd_file.put_line(fnd_file.LOG, ' ');
188720:
188721:
188722: xla_exceptions_pkg.raise_message
188723: (p_location => 'XLA_00140_AAD_S_000002_PKG.EventClass_413');

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

190317:
190318: l_first_event_id := l_array_header_events(l_array_header_events.FIRST);
190319: l_last_event_id := l_array_header_events(l_array_header_events.LAST);
190320:
190321: fnd_file.put_line(fnd_file.LOG, ' ');
190322: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
190323: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );
190324: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');
190325:

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

190318: l_first_event_id := l_array_header_events(l_array_header_events.FIRST);
190319: l_last_event_id := l_array_header_events(l_array_header_events.LAST);
190320:
190321: fnd_file.put_line(fnd_file.LOG, ' ');
190322: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
190323: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );
190324: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');
190325:
190326: FOR line_record IN line_cur(l_first_event_id, l_last_event_id)

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

190319: l_last_event_id := l_array_header_events(l_array_header_events.LAST);
190320:
190321: fnd_file.put_line(fnd_file.LOG, ' ');
190322: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
190323: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );
190324: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');
190325:
190326: FOR line_record IN line_cur(l_first_event_id, l_last_event_id)
190327: LOOP

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

190320:
190321: fnd_file.put_line(fnd_file.LOG, ' ');
190322: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
190323: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );
190324: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');
190325:
190326: FOR line_record IN line_cur(l_first_event_id, l_last_event_id)
190327: LOOP
190328: IF (NOT l_array_header_events.EXISTS(line_record.event_id)) AND (NOT l_array_duplicate_checker.EXISTS(line_record.event_id)) THEN

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

190325:
190326: FOR line_record IN line_cur(l_first_event_id, l_last_event_id)
190327: LOOP
190328: IF (NOT l_array_header_events.EXISTS(line_record.event_id)) AND (NOT l_array_duplicate_checker.EXISTS(line_record.event_id)) THEN
190329: fnd_file.put_line(fnd_file.log, 'Event_id = ' || line_record.event_id);
190330: l_array_duplicate_checker(line_record.event_id) := line_record.event_id;
190331: END IF;
190332: END LOOP;
190333:

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

190330: l_array_duplicate_checker(line_record.event_id) := line_record.event_id;
190331: END IF;
190332: END LOOP;
190333:
190334: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
190335: fnd_file.put_line(fnd_file.LOG, ' ');
190336:
190337:
190338: xla_exceptions_pkg.raise_message

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

190331: END IF;
190332: END LOOP;
190333:
190334: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
190335: fnd_file.put_line(fnd_file.LOG, ' ');
190336:
190337:
190338: xla_exceptions_pkg.raise_message
190339: (p_location => 'XLA_00140_AAD_S_000002_PKG.EventType_414');

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

191943:
191944: l_first_event_id := l_array_header_events(l_array_header_events.FIRST);
191945: l_last_event_id := l_array_header_events(l_array_header_events.LAST);
191946:
191947: fnd_file.put_line(fnd_file.LOG, ' ');
191948: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
191949: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );
191950: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');
191951:

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

191944: l_first_event_id := l_array_header_events(l_array_header_events.FIRST);
191945: l_last_event_id := l_array_header_events(l_array_header_events.LAST);
191946:
191947: fnd_file.put_line(fnd_file.LOG, ' ');
191948: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
191949: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );
191950: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');
191951:
191952: FOR line_record IN line_cur(l_first_event_id, l_last_event_id)

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

191945: l_last_event_id := l_array_header_events(l_array_header_events.LAST);
191946:
191947: fnd_file.put_line(fnd_file.LOG, ' ');
191948: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
191949: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );
191950: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');
191951:
191952: FOR line_record IN line_cur(l_first_event_id, l_last_event_id)
191953: LOOP

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

191946:
191947: fnd_file.put_line(fnd_file.LOG, ' ');
191948: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
191949: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );
191950: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');
191951:
191952: FOR line_record IN line_cur(l_first_event_id, l_last_event_id)
191953: LOOP
191954: IF (NOT l_array_header_events.EXISTS(line_record.event_id)) AND (NOT l_array_duplicate_checker.EXISTS(line_record.event_id)) THEN

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

191951:
191952: FOR line_record IN line_cur(l_first_event_id, l_last_event_id)
191953: LOOP
191954: IF (NOT l_array_header_events.EXISTS(line_record.event_id)) AND (NOT l_array_duplicate_checker.EXISTS(line_record.event_id)) THEN
191955: fnd_file.put_line(fnd_file.log, 'Event_id = ' || line_record.event_id);
191956: l_array_duplicate_checker(line_record.event_id) := line_record.event_id;
191957: END IF;
191958: END LOOP;
191959:

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

191956: l_array_duplicate_checker(line_record.event_id) := line_record.event_id;
191957: END IF;
191958: END LOOP;
191959:
191960: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
191961: fnd_file.put_line(fnd_file.LOG, ' ');
191962:
191963:
191964: xla_exceptions_pkg.raise_message

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

191957: END IF;
191958: END LOOP;
191959:
191960: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
191961: fnd_file.put_line(fnd_file.LOG, ' ');
191962:
191963:
191964: xla_exceptions_pkg.raise_message
191965: (p_location => 'XLA_00140_AAD_S_000002_PKG.EventType_415');

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

193162:
193163: l_first_event_id := l_array_header_events(l_array_header_events.FIRST);
193164: l_last_event_id := l_array_header_events(l_array_header_events.LAST);
193165:
193166: fnd_file.put_line(fnd_file.LOG, ' ');
193167: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
193168: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );
193169: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');
193170:

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

193163: l_first_event_id := l_array_header_events(l_array_header_events.FIRST);
193164: l_last_event_id := l_array_header_events(l_array_header_events.LAST);
193165:
193166: fnd_file.put_line(fnd_file.LOG, ' ');
193167: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
193168: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );
193169: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');
193170:
193171: FOR line_record IN line_cur(l_first_event_id, l_last_event_id)

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

193164: l_last_event_id := l_array_header_events(l_array_header_events.LAST);
193165:
193166: fnd_file.put_line(fnd_file.LOG, ' ');
193167: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
193168: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );
193169: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');
193170:
193171: FOR line_record IN line_cur(l_first_event_id, l_last_event_id)
193172: LOOP

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

193165:
193166: fnd_file.put_line(fnd_file.LOG, ' ');
193167: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
193168: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );
193169: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');
193170:
193171: FOR line_record IN line_cur(l_first_event_id, l_last_event_id)
193172: LOOP
193173: IF (NOT l_array_header_events.EXISTS(line_record.event_id)) AND (NOT l_array_duplicate_checker.EXISTS(line_record.event_id)) THEN

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

193170:
193171: FOR line_record IN line_cur(l_first_event_id, l_last_event_id)
193172: LOOP
193173: IF (NOT l_array_header_events.EXISTS(line_record.event_id)) AND (NOT l_array_duplicate_checker.EXISTS(line_record.event_id)) THEN
193174: fnd_file.put_line(fnd_file.log, 'Event_id = ' || line_record.event_id);
193175: l_array_duplicate_checker(line_record.event_id) := line_record.event_id;
193176: END IF;
193177: END LOOP;
193178:

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

193175: l_array_duplicate_checker(line_record.event_id) := line_record.event_id;
193176: END IF;
193177: END LOOP;
193178:
193179: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
193180: fnd_file.put_line(fnd_file.LOG, ' ');
193181:
193182:
193183: xla_exceptions_pkg.raise_message

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

193176: END IF;
193177: END LOOP;
193178:
193179: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
193180: fnd_file.put_line(fnd_file.LOG, ' ');
193181:
193182:
193183: xla_exceptions_pkg.raise_message
193184: (p_location => 'XLA_00140_AAD_S_000002_PKG.EventClass_416');

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

194611:
194612: l_first_event_id := l_array_header_events(l_array_header_events.FIRST);
194613: l_last_event_id := l_array_header_events(l_array_header_events.LAST);
194614:
194615: fnd_file.put_line(fnd_file.LOG, ' ');
194616: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
194617: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );
194618: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');
194619:

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

194612: l_first_event_id := l_array_header_events(l_array_header_events.FIRST);
194613: l_last_event_id := l_array_header_events(l_array_header_events.LAST);
194614:
194615: fnd_file.put_line(fnd_file.LOG, ' ');
194616: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
194617: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );
194618: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');
194619:
194620: FOR line_record IN line_cur(l_first_event_id, l_last_event_id)

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

194613: l_last_event_id := l_array_header_events(l_array_header_events.LAST);
194614:
194615: fnd_file.put_line(fnd_file.LOG, ' ');
194616: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
194617: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );
194618: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');
194619:
194620: FOR line_record IN line_cur(l_first_event_id, l_last_event_id)
194621: LOOP

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

194614:
194615: fnd_file.put_line(fnd_file.LOG, ' ');
194616: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
194617: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );
194618: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');
194619:
194620: FOR line_record IN line_cur(l_first_event_id, l_last_event_id)
194621: LOOP
194622: IF (NOT l_array_header_events.EXISTS(line_record.event_id)) AND (NOT l_array_duplicate_checker.EXISTS(line_record.event_id)) THEN

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

194619:
194620: FOR line_record IN line_cur(l_first_event_id, l_last_event_id)
194621: LOOP
194622: IF (NOT l_array_header_events.EXISTS(line_record.event_id)) AND (NOT l_array_duplicate_checker.EXISTS(line_record.event_id)) THEN
194623: fnd_file.put_line(fnd_file.log, 'Event_id = ' || line_record.event_id);
194624: l_array_duplicate_checker(line_record.event_id) := line_record.event_id;
194625: END IF;
194626: END LOOP;
194627:

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

194624: l_array_duplicate_checker(line_record.event_id) := line_record.event_id;
194625: END IF;
194626: END LOOP;
194627:
194628: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
194629: fnd_file.put_line(fnd_file.LOG, ' ');
194630:
194631:
194632: xla_exceptions_pkg.raise_message

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

194625: END IF;
194626: END LOOP;
194627:
194628: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
194629: fnd_file.put_line(fnd_file.LOG, ' ');
194630:
194631:
194632: xla_exceptions_pkg.raise_message
194633: (p_location => 'XLA_00140_AAD_S_000002_PKG.EventClass_417');

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

195979:
195980: l_first_event_id := l_array_header_events(l_array_header_events.FIRST);
195981: l_last_event_id := l_array_header_events(l_array_header_events.LAST);
195982:
195983: fnd_file.put_line(fnd_file.LOG, ' ');
195984: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
195985: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );
195986: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');
195987:

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

195980: l_first_event_id := l_array_header_events(l_array_header_events.FIRST);
195981: l_last_event_id := l_array_header_events(l_array_header_events.LAST);
195982:
195983: fnd_file.put_line(fnd_file.LOG, ' ');
195984: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
195985: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );
195986: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');
195987:
195988: FOR line_record IN line_cur(l_first_event_id, l_last_event_id)

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

195981: l_last_event_id := l_array_header_events(l_array_header_events.LAST);
195982:
195983: fnd_file.put_line(fnd_file.LOG, ' ');
195984: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
195985: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );
195986: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');
195987:
195988: FOR line_record IN line_cur(l_first_event_id, l_last_event_id)
195989: LOOP

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

195982:
195983: fnd_file.put_line(fnd_file.LOG, ' ');
195984: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
195985: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );
195986: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');
195987:
195988: FOR line_record IN line_cur(l_first_event_id, l_last_event_id)
195989: LOOP
195990: IF (NOT l_array_header_events.EXISTS(line_record.event_id)) AND (NOT l_array_duplicate_checker.EXISTS(line_record.event_id)) THEN

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

195987:
195988: FOR line_record IN line_cur(l_first_event_id, l_last_event_id)
195989: LOOP
195990: IF (NOT l_array_header_events.EXISTS(line_record.event_id)) AND (NOT l_array_duplicate_checker.EXISTS(line_record.event_id)) THEN
195991: fnd_file.put_line(fnd_file.log, 'Event_id = ' || line_record.event_id);
195992: l_array_duplicate_checker(line_record.event_id) := line_record.event_id;
195993: END IF;
195994: END LOOP;
195995:

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

195992: l_array_duplicate_checker(line_record.event_id) := line_record.event_id;
195993: END IF;
195994: END LOOP;
195995:
195996: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
195997: fnd_file.put_line(fnd_file.LOG, ' ');
195998:
195999:
196000: xla_exceptions_pkg.raise_message

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

195993: END IF;
195994: END LOOP;
195995:
195996: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
195997: fnd_file.put_line(fnd_file.LOG, ' ');
195998:
195999:
196000: xla_exceptions_pkg.raise_message
196001: (p_location => 'XLA_00140_AAD_S_000002_PKG.EventClass_418');

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

197348:
197349: l_first_event_id := l_array_header_events(l_array_header_events.FIRST);
197350: l_last_event_id := l_array_header_events(l_array_header_events.LAST);
197351:
197352: fnd_file.put_line(fnd_file.LOG, ' ');
197353: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
197354: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );
197355: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');
197356:

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

197349: l_first_event_id := l_array_header_events(l_array_header_events.FIRST);
197350: l_last_event_id := l_array_header_events(l_array_header_events.LAST);
197351:
197352: fnd_file.put_line(fnd_file.LOG, ' ');
197353: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
197354: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );
197355: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');
197356:
197357: FOR line_record IN line_cur(l_first_event_id, l_last_event_id)

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

197350: l_last_event_id := l_array_header_events(l_array_header_events.LAST);
197351:
197352: fnd_file.put_line(fnd_file.LOG, ' ');
197353: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
197354: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );
197355: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');
197356:
197357: FOR line_record IN line_cur(l_first_event_id, l_last_event_id)
197358: LOOP

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

197351:
197352: fnd_file.put_line(fnd_file.LOG, ' ');
197353: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
197354: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );
197355: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');
197356:
197357: FOR line_record IN line_cur(l_first_event_id, l_last_event_id)
197358: LOOP
197359: IF (NOT l_array_header_events.EXISTS(line_record.event_id)) AND (NOT l_array_duplicate_checker.EXISTS(line_record.event_id)) THEN

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

197356:
197357: FOR line_record IN line_cur(l_first_event_id, l_last_event_id)
197358: LOOP
197359: IF (NOT l_array_header_events.EXISTS(line_record.event_id)) AND (NOT l_array_duplicate_checker.EXISTS(line_record.event_id)) THEN
197360: fnd_file.put_line(fnd_file.log, 'Event_id = ' || line_record.event_id);
197361: l_array_duplicate_checker(line_record.event_id) := line_record.event_id;
197362: END IF;
197363: END LOOP;
197364:

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

197361: l_array_duplicate_checker(line_record.event_id) := line_record.event_id;
197362: END IF;
197363: END LOOP;
197364:
197365: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
197366: fnd_file.put_line(fnd_file.LOG, ' ');
197367:
197368:
197369: xla_exceptions_pkg.raise_message

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

197362: END IF;
197363: END LOOP;
197364:
197365: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
197366: fnd_file.put_line(fnd_file.LOG, ' ');
197367:
197368:
197369: xla_exceptions_pkg.raise_message
197370: (p_location => 'XLA_00140_AAD_S_000002_PKG.EventClass_419');

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

198581:
198582: l_first_event_id := l_array_header_events(l_array_header_events.FIRST);
198583: l_last_event_id := l_array_header_events(l_array_header_events.LAST);
198584:
198585: fnd_file.put_line(fnd_file.LOG, ' ');
198586: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
198587: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );
198588: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');
198589:

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

198582: l_first_event_id := l_array_header_events(l_array_header_events.FIRST);
198583: l_last_event_id := l_array_header_events(l_array_header_events.LAST);
198584:
198585: fnd_file.put_line(fnd_file.LOG, ' ');
198586: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
198587: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );
198588: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');
198589:
198590: FOR line_record IN line_cur(l_first_event_id, l_last_event_id)

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

198583: l_last_event_id := l_array_header_events(l_array_header_events.LAST);
198584:
198585: fnd_file.put_line(fnd_file.LOG, ' ');
198586: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
198587: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );
198588: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');
198589:
198590: FOR line_record IN line_cur(l_first_event_id, l_last_event_id)
198591: LOOP

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

198584:
198585: fnd_file.put_line(fnd_file.LOG, ' ');
198586: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
198587: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );
198588: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');
198589:
198590: FOR line_record IN line_cur(l_first_event_id, l_last_event_id)
198591: LOOP
198592: IF (NOT l_array_header_events.EXISTS(line_record.event_id)) AND (NOT l_array_duplicate_checker.EXISTS(line_record.event_id)) THEN

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

198589:
198590: FOR line_record IN line_cur(l_first_event_id, l_last_event_id)
198591: LOOP
198592: IF (NOT l_array_header_events.EXISTS(line_record.event_id)) AND (NOT l_array_duplicate_checker.EXISTS(line_record.event_id)) THEN
198593: fnd_file.put_line(fnd_file.log, 'Event_id = ' || line_record.event_id);
198594: l_array_duplicate_checker(line_record.event_id) := line_record.event_id;
198595: END IF;
198596: END LOOP;
198597:

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

198594: l_array_duplicate_checker(line_record.event_id) := line_record.event_id;
198595: END IF;
198596: END LOOP;
198597:
198598: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
198599: fnd_file.put_line(fnd_file.LOG, ' ');
198600:
198601:
198602: xla_exceptions_pkg.raise_message

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

198595: END IF;
198596: END LOOP;
198597:
198598: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
198599: fnd_file.put_line(fnd_file.LOG, ' ');
198600:
198601:
198602: xla_exceptions_pkg.raise_message
198603: (p_location => 'XLA_00140_AAD_S_000002_PKG.EventClass_420');

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

199801:
199802: l_first_event_id := l_array_header_events(l_array_header_events.FIRST);
199803: l_last_event_id := l_array_header_events(l_array_header_events.LAST);
199804:
199805: fnd_file.put_line(fnd_file.LOG, ' ');
199806: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
199807: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );
199808: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');
199809:

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

199802: l_first_event_id := l_array_header_events(l_array_header_events.FIRST);
199803: l_last_event_id := l_array_header_events(l_array_header_events.LAST);
199804:
199805: fnd_file.put_line(fnd_file.LOG, ' ');
199806: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
199807: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );
199808: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');
199809:
199810: FOR line_record IN line_cur(l_first_event_id, l_last_event_id)

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

199803: l_last_event_id := l_array_header_events(l_array_header_events.LAST);
199804:
199805: fnd_file.put_line(fnd_file.LOG, ' ');
199806: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
199807: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );
199808: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');
199809:
199810: FOR line_record IN line_cur(l_first_event_id, l_last_event_id)
199811: LOOP

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

199804:
199805: fnd_file.put_line(fnd_file.LOG, ' ');
199806: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
199807: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );
199808: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');
199809:
199810: FOR line_record IN line_cur(l_first_event_id, l_last_event_id)
199811: LOOP
199812: IF (NOT l_array_header_events.EXISTS(line_record.event_id)) AND (NOT l_array_duplicate_checker.EXISTS(line_record.event_id)) THEN

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

199809:
199810: FOR line_record IN line_cur(l_first_event_id, l_last_event_id)
199811: LOOP
199812: IF (NOT l_array_header_events.EXISTS(line_record.event_id)) AND (NOT l_array_duplicate_checker.EXISTS(line_record.event_id)) THEN
199813: fnd_file.put_line(fnd_file.log, 'Event_id = ' || line_record.event_id);
199814: l_array_duplicate_checker(line_record.event_id) := line_record.event_id;
199815: END IF;
199816: END LOOP;
199817:

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

199814: l_array_duplicate_checker(line_record.event_id) := line_record.event_id;
199815: END IF;
199816: END LOOP;
199817:
199818: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
199819: fnd_file.put_line(fnd_file.LOG, ' ');
199820:
199821:
199822: xla_exceptions_pkg.raise_message

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

199815: END IF;
199816: END LOOP;
199817:
199818: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
199819: fnd_file.put_line(fnd_file.LOG, ' ');
199820:
199821:
199822: xla_exceptions_pkg.raise_message
199823: (p_location => 'XLA_00140_AAD_S_000002_PKG.EventClass_421');

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

201323:
201324: l_first_event_id := l_array_header_events(l_array_header_events.FIRST);
201325: l_last_event_id := l_array_header_events(l_array_header_events.LAST);
201326:
201327: fnd_file.put_line(fnd_file.LOG, ' ');
201328: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
201329: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );
201330: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');
201331:

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

201324: l_first_event_id := l_array_header_events(l_array_header_events.FIRST);
201325: l_last_event_id := l_array_header_events(l_array_header_events.LAST);
201326:
201327: fnd_file.put_line(fnd_file.LOG, ' ');
201328: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
201329: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );
201330: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');
201331:
201332: FOR line_record IN line_cur(l_first_event_id, l_last_event_id)

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

201325: l_last_event_id := l_array_header_events(l_array_header_events.LAST);
201326:
201327: fnd_file.put_line(fnd_file.LOG, ' ');
201328: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
201329: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );
201330: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');
201331:
201332: FOR line_record IN line_cur(l_first_event_id, l_last_event_id)
201333: LOOP

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

201326:
201327: fnd_file.put_line(fnd_file.LOG, ' ');
201328: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
201329: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );
201330: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');
201331:
201332: FOR line_record IN line_cur(l_first_event_id, l_last_event_id)
201333: LOOP
201334: IF (NOT l_array_header_events.EXISTS(line_record.event_id)) AND (NOT l_array_duplicate_checker.EXISTS(line_record.event_id)) THEN

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

201331:
201332: FOR line_record IN line_cur(l_first_event_id, l_last_event_id)
201333: LOOP
201334: IF (NOT l_array_header_events.EXISTS(line_record.event_id)) AND (NOT l_array_duplicate_checker.EXISTS(line_record.event_id)) THEN
201335: fnd_file.put_line(fnd_file.log, 'Event_id = ' || line_record.event_id);
201336: l_array_duplicate_checker(line_record.event_id) := line_record.event_id;
201337: END IF;
201338: END LOOP;
201339:

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

201336: l_array_duplicate_checker(line_record.event_id) := line_record.event_id;
201337: END IF;
201338: END LOOP;
201339:
201340: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
201341: fnd_file.put_line(fnd_file.LOG, ' ');
201342:
201343:
201344: xla_exceptions_pkg.raise_message

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

201337: END IF;
201338: END LOOP;
201339:
201340: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
201341: fnd_file.put_line(fnd_file.LOG, ' ');
201342:
201343:
201344: xla_exceptions_pkg.raise_message
201345: (p_location => 'XLA_00140_AAD_S_000002_PKG.EventClass_422');

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

203178:
203179: l_first_event_id := l_array_header_events(l_array_header_events.FIRST);
203180: l_last_event_id := l_array_header_events(l_array_header_events.LAST);
203181:
203182: fnd_file.put_line(fnd_file.LOG, ' ');
203183: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
203184: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );
203185: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');
203186:

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

203179: l_first_event_id := l_array_header_events(l_array_header_events.FIRST);
203180: l_last_event_id := l_array_header_events(l_array_header_events.LAST);
203181:
203182: fnd_file.put_line(fnd_file.LOG, ' ');
203183: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
203184: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );
203185: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');
203186:
203187: FOR line_record IN line_cur(l_first_event_id, l_last_event_id)

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

203180: l_last_event_id := l_array_header_events(l_array_header_events.LAST);
203181:
203182: fnd_file.put_line(fnd_file.LOG, ' ');
203183: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
203184: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );
203185: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');
203186:
203187: FOR line_record IN line_cur(l_first_event_id, l_last_event_id)
203188: LOOP

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

203181:
203182: fnd_file.put_line(fnd_file.LOG, ' ');
203183: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
203184: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );
203185: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');
203186:
203187: FOR line_record IN line_cur(l_first_event_id, l_last_event_id)
203188: LOOP
203189: IF (NOT l_array_header_events.EXISTS(line_record.event_id)) AND (NOT l_array_duplicate_checker.EXISTS(line_record.event_id)) THEN

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

203186:
203187: FOR line_record IN line_cur(l_first_event_id, l_last_event_id)
203188: LOOP
203189: IF (NOT l_array_header_events.EXISTS(line_record.event_id)) AND (NOT l_array_duplicate_checker.EXISTS(line_record.event_id)) THEN
203190: fnd_file.put_line(fnd_file.log, 'Event_id = ' || line_record.event_id);
203191: l_array_duplicate_checker(line_record.event_id) := line_record.event_id;
203192: END IF;
203193: END LOOP;
203194:

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

203191: l_array_duplicate_checker(line_record.event_id) := line_record.event_id;
203192: END IF;
203193: END LOOP;
203194:
203195: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
203196: fnd_file.put_line(fnd_file.LOG, ' ');
203197:
203198:
203199: xla_exceptions_pkg.raise_message

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

203192: END IF;
203193: END LOOP;
203194:
203195: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
203196: fnd_file.put_line(fnd_file.LOG, ' ');
203197:
203198:
203199: xla_exceptions_pkg.raise_message
203200: (p_location => 'XLA_00140_AAD_S_000002_PKG.EventType_423');

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

204478:
204479: l_first_event_id := l_array_header_events(l_array_header_events.FIRST);
204480: l_last_event_id := l_array_header_events(l_array_header_events.LAST);
204481:
204482: fnd_file.put_line(fnd_file.LOG, ' ');
204483: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
204484: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );
204485: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');
204486:

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

204479: l_first_event_id := l_array_header_events(l_array_header_events.FIRST);
204480: l_last_event_id := l_array_header_events(l_array_header_events.LAST);
204481:
204482: fnd_file.put_line(fnd_file.LOG, ' ');
204483: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
204484: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );
204485: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');
204486:
204487: FOR line_record IN line_cur(l_first_event_id, l_last_event_id)

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

204480: l_last_event_id := l_array_header_events(l_array_header_events.LAST);
204481:
204482: fnd_file.put_line(fnd_file.LOG, ' ');
204483: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
204484: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );
204485: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');
204486:
204487: FOR line_record IN line_cur(l_first_event_id, l_last_event_id)
204488: LOOP

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

204481:
204482: fnd_file.put_line(fnd_file.LOG, ' ');
204483: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
204484: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );
204485: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');
204486:
204487: FOR line_record IN line_cur(l_first_event_id, l_last_event_id)
204488: LOOP
204489: IF (NOT l_array_header_events.EXISTS(line_record.event_id)) AND (NOT l_array_duplicate_checker.EXISTS(line_record.event_id)) THEN

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

204486:
204487: FOR line_record IN line_cur(l_first_event_id, l_last_event_id)
204488: LOOP
204489: IF (NOT l_array_header_events.EXISTS(line_record.event_id)) AND (NOT l_array_duplicate_checker.EXISTS(line_record.event_id)) THEN
204490: fnd_file.put_line(fnd_file.log, 'Event_id = ' || line_record.event_id);
204491: l_array_duplicate_checker(line_record.event_id) := line_record.event_id;
204492: END IF;
204493: END LOOP;
204494:

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

204491: l_array_duplicate_checker(line_record.event_id) := line_record.event_id;
204492: END IF;
204493: END LOOP;
204494:
204495: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
204496: fnd_file.put_line(fnd_file.LOG, ' ');
204497:
204498:
204499: xla_exceptions_pkg.raise_message

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

204492: END IF;
204493: END LOOP;
204494:
204495: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
204496: fnd_file.put_line(fnd_file.LOG, ' ');
204497:
204498:
204499: xla_exceptions_pkg.raise_message
204500: (p_location => 'XLA_00140_AAD_S_000002_PKG.EventClass_424');

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

206276:
206277: l_first_event_id := l_array_header_events(l_array_header_events.FIRST);
206278: l_last_event_id := l_array_header_events(l_array_header_events.LAST);
206279:
206280: fnd_file.put_line(fnd_file.LOG, ' ');
206281: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
206282: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );
206283: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');
206284:

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

206277: l_first_event_id := l_array_header_events(l_array_header_events.FIRST);
206278: l_last_event_id := l_array_header_events(l_array_header_events.LAST);
206279:
206280: fnd_file.put_line(fnd_file.LOG, ' ');
206281: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
206282: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );
206283: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');
206284:
206285: FOR line_record IN line_cur(l_first_event_id, l_last_event_id)

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

206278: l_last_event_id := l_array_header_events(l_array_header_events.LAST);
206279:
206280: fnd_file.put_line(fnd_file.LOG, ' ');
206281: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
206282: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );
206283: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');
206284:
206285: FOR line_record IN line_cur(l_first_event_id, l_last_event_id)
206286: LOOP

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

206279:
206280: fnd_file.put_line(fnd_file.LOG, ' ');
206281: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
206282: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );
206283: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');
206284:
206285: FOR line_record IN line_cur(l_first_event_id, l_last_event_id)
206286: LOOP
206287: IF (NOT l_array_header_events.EXISTS(line_record.event_id)) AND (NOT l_array_duplicate_checker.EXISTS(line_record.event_id)) THEN

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

206284:
206285: FOR line_record IN line_cur(l_first_event_id, l_last_event_id)
206286: LOOP
206287: IF (NOT l_array_header_events.EXISTS(line_record.event_id)) AND (NOT l_array_duplicate_checker.EXISTS(line_record.event_id)) THEN
206288: fnd_file.put_line(fnd_file.log, 'Event_id = ' || line_record.event_id);
206289: l_array_duplicate_checker(line_record.event_id) := line_record.event_id;
206290: END IF;
206291: END LOOP;
206292:

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

206289: l_array_duplicate_checker(line_record.event_id) := line_record.event_id;
206290: END IF;
206291: END LOOP;
206292:
206293: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
206294: fnd_file.put_line(fnd_file.LOG, ' ');
206295:
206296:
206297: xla_exceptions_pkg.raise_message

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

206290: END IF;
206291: END LOOP;
206292:
206293: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
206294: fnd_file.put_line(fnd_file.LOG, ' ');
206295:
206296:
206297: xla_exceptions_pkg.raise_message
206298: (p_location => 'XLA_00140_AAD_S_000002_PKG.EventType_425');

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

207535:
207536: l_first_event_id := l_array_header_events(l_array_header_events.FIRST);
207537: l_last_event_id := l_array_header_events(l_array_header_events.LAST);
207538:
207539: fnd_file.put_line(fnd_file.LOG, ' ');
207540: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
207541: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );
207542: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');
207543:

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

207536: l_first_event_id := l_array_header_events(l_array_header_events.FIRST);
207537: l_last_event_id := l_array_header_events(l_array_header_events.LAST);
207538:
207539: fnd_file.put_line(fnd_file.LOG, ' ');
207540: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
207541: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );
207542: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');
207543:
207544: FOR line_record IN line_cur(l_first_event_id, l_last_event_id)

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

207537: l_last_event_id := l_array_header_events(l_array_header_events.LAST);
207538:
207539: fnd_file.put_line(fnd_file.LOG, ' ');
207540: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
207541: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );
207542: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');
207543:
207544: FOR line_record IN line_cur(l_first_event_id, l_last_event_id)
207545: LOOP

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

207538:
207539: fnd_file.put_line(fnd_file.LOG, ' ');
207540: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
207541: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );
207542: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');
207543:
207544: FOR line_record IN line_cur(l_first_event_id, l_last_event_id)
207545: LOOP
207546: IF (NOT l_array_header_events.EXISTS(line_record.event_id)) AND (NOT l_array_duplicate_checker.EXISTS(line_record.event_id)) THEN

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

207543:
207544: FOR line_record IN line_cur(l_first_event_id, l_last_event_id)
207545: LOOP
207546: IF (NOT l_array_header_events.EXISTS(line_record.event_id)) AND (NOT l_array_duplicate_checker.EXISTS(line_record.event_id)) THEN
207547: fnd_file.put_line(fnd_file.log, 'Event_id = ' || line_record.event_id);
207548: l_array_duplicate_checker(line_record.event_id) := line_record.event_id;
207549: END IF;
207550: END LOOP;
207551:

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

207548: l_array_duplicate_checker(line_record.event_id) := line_record.event_id;
207549: END IF;
207550: END LOOP;
207551:
207552: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
207553: fnd_file.put_line(fnd_file.LOG, ' ');
207554:
207555:
207556: xla_exceptions_pkg.raise_message

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

207549: END IF;
207550: END LOOP;
207551:
207552: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
207553: fnd_file.put_line(fnd_file.LOG, ' ');
207554:
207555:
207556: xla_exceptions_pkg.raise_message
207557: (p_location => 'XLA_00140_AAD_S_000002_PKG.EventClass_426');

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

208953:
208954: l_first_event_id := l_array_header_events(l_array_header_events.FIRST);
208955: l_last_event_id := l_array_header_events(l_array_header_events.LAST);
208956:
208957: fnd_file.put_line(fnd_file.LOG, ' ');
208958: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
208959: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );
208960: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');
208961:

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

208954: l_first_event_id := l_array_header_events(l_array_header_events.FIRST);
208955: l_last_event_id := l_array_header_events(l_array_header_events.LAST);
208956:
208957: fnd_file.put_line(fnd_file.LOG, ' ');
208958: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
208959: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );
208960: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');
208961:
208962: FOR line_record IN line_cur(l_first_event_id, l_last_event_id)

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

208955: l_last_event_id := l_array_header_events(l_array_header_events.LAST);
208956:
208957: fnd_file.put_line(fnd_file.LOG, ' ');
208958: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
208959: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );
208960: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');
208961:
208962: FOR line_record IN line_cur(l_first_event_id, l_last_event_id)
208963: LOOP

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

208956:
208957: fnd_file.put_line(fnd_file.LOG, ' ');
208958: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
208959: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );
208960: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');
208961:
208962: FOR line_record IN line_cur(l_first_event_id, l_last_event_id)
208963: LOOP
208964: IF (NOT l_array_header_events.EXISTS(line_record.event_id)) AND (NOT l_array_duplicate_checker.EXISTS(line_record.event_id)) THEN

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

208961:
208962: FOR line_record IN line_cur(l_first_event_id, l_last_event_id)
208963: LOOP
208964: IF (NOT l_array_header_events.EXISTS(line_record.event_id)) AND (NOT l_array_duplicate_checker.EXISTS(line_record.event_id)) THEN
208965: fnd_file.put_line(fnd_file.log, 'Event_id = ' || line_record.event_id);
208966: l_array_duplicate_checker(line_record.event_id) := line_record.event_id;
208967: END IF;
208968: END LOOP;
208969:

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

208966: l_array_duplicate_checker(line_record.event_id) := line_record.event_id;
208967: END IF;
208968: END LOOP;
208969:
208970: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
208971: fnd_file.put_line(fnd_file.LOG, ' ');
208972:
208973:
208974: xla_exceptions_pkg.raise_message

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

208967: END IF;
208968: END LOOP;
208969:
208970: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
208971: fnd_file.put_line(fnd_file.LOG, ' ');
208972:
208973:
208974: xla_exceptions_pkg.raise_message
208975: (p_location => 'XLA_00140_AAD_S_000002_PKG.EventClass_427');

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

210370:
210371: l_first_event_id := l_array_header_events(l_array_header_events.FIRST);
210372: l_last_event_id := l_array_header_events(l_array_header_events.LAST);
210373:
210374: fnd_file.put_line(fnd_file.LOG, ' ');
210375: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
210376: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );
210377: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');
210378:

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

210371: l_first_event_id := l_array_header_events(l_array_header_events.FIRST);
210372: l_last_event_id := l_array_header_events(l_array_header_events.LAST);
210373:
210374: fnd_file.put_line(fnd_file.LOG, ' ');
210375: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
210376: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );
210377: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');
210378:
210379: FOR line_record IN line_cur(l_first_event_id, l_last_event_id)

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

210372: l_last_event_id := l_array_header_events(l_array_header_events.LAST);
210373:
210374: fnd_file.put_line(fnd_file.LOG, ' ');
210375: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
210376: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );
210377: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');
210378:
210379: FOR line_record IN line_cur(l_first_event_id, l_last_event_id)
210380: LOOP

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

210373:
210374: fnd_file.put_line(fnd_file.LOG, ' ');
210375: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
210376: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );
210377: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');
210378:
210379: FOR line_record IN line_cur(l_first_event_id, l_last_event_id)
210380: LOOP
210381: IF (NOT l_array_header_events.EXISTS(line_record.event_id)) AND (NOT l_array_duplicate_checker.EXISTS(line_record.event_id)) THEN

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

210378:
210379: FOR line_record IN line_cur(l_first_event_id, l_last_event_id)
210380: LOOP
210381: IF (NOT l_array_header_events.EXISTS(line_record.event_id)) AND (NOT l_array_duplicate_checker.EXISTS(line_record.event_id)) THEN
210382: fnd_file.put_line(fnd_file.log, 'Event_id = ' || line_record.event_id);
210383: l_array_duplicate_checker(line_record.event_id) := line_record.event_id;
210384: END IF;
210385: END LOOP;
210386:

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

210383: l_array_duplicate_checker(line_record.event_id) := line_record.event_id;
210384: END IF;
210385: END LOOP;
210386:
210387: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
210388: fnd_file.put_line(fnd_file.LOG, ' ');
210389:
210390:
210391: xla_exceptions_pkg.raise_message

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

210384: END IF;
210385: END LOOP;
210386:
210387: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
210388: fnd_file.put_line(fnd_file.LOG, ' ');
210389:
210390:
210391: xla_exceptions_pkg.raise_message
210392: (p_location => 'XLA_00140_AAD_S_000002_PKG.EventType_428');

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

212271:
212272: l_first_event_id := l_array_header_events(l_array_header_events.FIRST);
212273: l_last_event_id := l_array_header_events(l_array_header_events.LAST);
212274:
212275: fnd_file.put_line(fnd_file.LOG, ' ');
212276: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
212277: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );
212278: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');
212279:

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

212272: l_first_event_id := l_array_header_events(l_array_header_events.FIRST);
212273: l_last_event_id := l_array_header_events(l_array_header_events.LAST);
212274:
212275: fnd_file.put_line(fnd_file.LOG, ' ');
212276: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
212277: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );
212278: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');
212279:
212280: FOR line_record IN line_cur(l_first_event_id, l_last_event_id)

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

212273: l_last_event_id := l_array_header_events(l_array_header_events.LAST);
212274:
212275: fnd_file.put_line(fnd_file.LOG, ' ');
212276: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
212277: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );
212278: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');
212279:
212280: FOR line_record IN line_cur(l_first_event_id, l_last_event_id)
212281: LOOP

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

212274:
212275: fnd_file.put_line(fnd_file.LOG, ' ');
212276: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
212277: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );
212278: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');
212279:
212280: FOR line_record IN line_cur(l_first_event_id, l_last_event_id)
212281: LOOP
212282: IF (NOT l_array_header_events.EXISTS(line_record.event_id)) AND (NOT l_array_duplicate_checker.EXISTS(line_record.event_id)) THEN

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

212279:
212280: FOR line_record IN line_cur(l_first_event_id, l_last_event_id)
212281: LOOP
212282: IF (NOT l_array_header_events.EXISTS(line_record.event_id)) AND (NOT l_array_duplicate_checker.EXISTS(line_record.event_id)) THEN
212283: fnd_file.put_line(fnd_file.log, 'Event_id = ' || line_record.event_id);
212284: l_array_duplicate_checker(line_record.event_id) := line_record.event_id;
212285: END IF;
212286: END LOOP;
212287:

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

212284: l_array_duplicate_checker(line_record.event_id) := line_record.event_id;
212285: END IF;
212286: END LOOP;
212287:
212288: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
212289: fnd_file.put_line(fnd_file.LOG, ' ');
212290:
212291:
212292: xla_exceptions_pkg.raise_message

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

212285: END IF;
212286: END LOOP;
212287:
212288: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
212289: fnd_file.put_line(fnd_file.LOG, ' ');
212290:
212291:
212292: xla_exceptions_pkg.raise_message
212293: (p_location => 'XLA_00140_AAD_S_000002_PKG.EventClass_429');

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

213530:
213531: l_first_event_id := l_array_header_events(l_array_header_events.FIRST);
213532: l_last_event_id := l_array_header_events(l_array_header_events.LAST);
213533:
213534: fnd_file.put_line(fnd_file.LOG, ' ');
213535: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
213536: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );
213537: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');
213538:

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

213531: l_first_event_id := l_array_header_events(l_array_header_events.FIRST);
213532: l_last_event_id := l_array_header_events(l_array_header_events.LAST);
213533:
213534: fnd_file.put_line(fnd_file.LOG, ' ');
213535: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
213536: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );
213537: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');
213538:
213539: FOR line_record IN line_cur(l_first_event_id, l_last_event_id)

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

213532: l_last_event_id := l_array_header_events(l_array_header_events.LAST);
213533:
213534: fnd_file.put_line(fnd_file.LOG, ' ');
213535: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
213536: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );
213537: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');
213538:
213539: FOR line_record IN line_cur(l_first_event_id, l_last_event_id)
213540: LOOP

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

213533:
213534: fnd_file.put_line(fnd_file.LOG, ' ');
213535: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
213536: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );
213537: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');
213538:
213539: FOR line_record IN line_cur(l_first_event_id, l_last_event_id)
213540: LOOP
213541: IF (NOT l_array_header_events.EXISTS(line_record.event_id)) AND (NOT l_array_duplicate_checker.EXISTS(line_record.event_id)) THEN

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

213538:
213539: FOR line_record IN line_cur(l_first_event_id, l_last_event_id)
213540: LOOP
213541: IF (NOT l_array_header_events.EXISTS(line_record.event_id)) AND (NOT l_array_duplicate_checker.EXISTS(line_record.event_id)) THEN
213542: fnd_file.put_line(fnd_file.log, 'Event_id = ' || line_record.event_id);
213543: l_array_duplicate_checker(line_record.event_id) := line_record.event_id;
213544: END IF;
213545: END LOOP;
213546:

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

213543: l_array_duplicate_checker(line_record.event_id) := line_record.event_id;
213544: END IF;
213545: END LOOP;
213546:
213547: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
213548: fnd_file.put_line(fnd_file.LOG, ' ');
213549:
213550:
213551: xla_exceptions_pkg.raise_message

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

213544: END IF;
213545: END LOOP;
213546:
213547: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
213548: fnd_file.put_line(fnd_file.LOG, ' ');
213549:
213550:
213551: xla_exceptions_pkg.raise_message
213552: (p_location => 'XLA_00140_AAD_S_000002_PKG.EventClass_430');

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

215282:
215283: l_first_event_id := l_array_header_events(l_array_header_events.FIRST);
215284: l_last_event_id := l_array_header_events(l_array_header_events.LAST);
215285:
215286: fnd_file.put_line(fnd_file.LOG, ' ');
215287: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
215288: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );
215289: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');
215290:

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

215283: l_first_event_id := l_array_header_events(l_array_header_events.FIRST);
215284: l_last_event_id := l_array_header_events(l_array_header_events.LAST);
215285:
215286: fnd_file.put_line(fnd_file.LOG, ' ');
215287: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
215288: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );
215289: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');
215290:
215291: FOR line_record IN line_cur(l_first_event_id, l_last_event_id)

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

215284: l_last_event_id := l_array_header_events(l_array_header_events.LAST);
215285:
215286: fnd_file.put_line(fnd_file.LOG, ' ');
215287: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
215288: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );
215289: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');
215290:
215291: FOR line_record IN line_cur(l_first_event_id, l_last_event_id)
215292: LOOP

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

215285:
215286: fnd_file.put_line(fnd_file.LOG, ' ');
215287: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
215288: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );
215289: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');
215290:
215291: FOR line_record IN line_cur(l_first_event_id, l_last_event_id)
215292: LOOP
215293: IF (NOT l_array_header_events.EXISTS(line_record.event_id)) AND (NOT l_array_duplicate_checker.EXISTS(line_record.event_id)) THEN

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

215290:
215291: FOR line_record IN line_cur(l_first_event_id, l_last_event_id)
215292: LOOP
215293: IF (NOT l_array_header_events.EXISTS(line_record.event_id)) AND (NOT l_array_duplicate_checker.EXISTS(line_record.event_id)) THEN
215294: fnd_file.put_line(fnd_file.log, 'Event_id = ' || line_record.event_id);
215295: l_array_duplicate_checker(line_record.event_id) := line_record.event_id;
215296: END IF;
215297: END LOOP;
215298:

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

215295: l_array_duplicate_checker(line_record.event_id) := line_record.event_id;
215296: END IF;
215297: END LOOP;
215298:
215299: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
215300: fnd_file.put_line(fnd_file.LOG, ' ');
215301:
215302:
215303: xla_exceptions_pkg.raise_message

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

215296: END IF;
215297: END LOOP;
215298:
215299: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
215300: fnd_file.put_line(fnd_file.LOG, ' ');
215301:
215302:
215303: xla_exceptions_pkg.raise_message
215304: (p_location => 'XLA_00140_AAD_S_000002_PKG.EventClass_431');

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

217034:
217035: l_first_event_id := l_array_header_events(l_array_header_events.FIRST);
217036: l_last_event_id := l_array_header_events(l_array_header_events.LAST);
217037:
217038: fnd_file.put_line(fnd_file.LOG, ' ');
217039: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
217040: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );
217041: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');
217042:

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

217035: l_first_event_id := l_array_header_events(l_array_header_events.FIRST);
217036: l_last_event_id := l_array_header_events(l_array_header_events.LAST);
217037:
217038: fnd_file.put_line(fnd_file.LOG, ' ');
217039: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
217040: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );
217041: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');
217042:
217043: FOR line_record IN line_cur(l_first_event_id, l_last_event_id)

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

217036: l_last_event_id := l_array_header_events(l_array_header_events.LAST);
217037:
217038: fnd_file.put_line(fnd_file.LOG, ' ');
217039: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
217040: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );
217041: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');
217042:
217043: FOR line_record IN line_cur(l_first_event_id, l_last_event_id)
217044: LOOP

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

217037:
217038: fnd_file.put_line(fnd_file.LOG, ' ');
217039: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
217040: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );
217041: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');
217042:
217043: FOR line_record IN line_cur(l_first_event_id, l_last_event_id)
217044: LOOP
217045: IF (NOT l_array_header_events.EXISTS(line_record.event_id)) AND (NOT l_array_duplicate_checker.EXISTS(line_record.event_id)) THEN

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

217042:
217043: FOR line_record IN line_cur(l_first_event_id, l_last_event_id)
217044: LOOP
217045: IF (NOT l_array_header_events.EXISTS(line_record.event_id)) AND (NOT l_array_duplicate_checker.EXISTS(line_record.event_id)) THEN
217046: fnd_file.put_line(fnd_file.log, 'Event_id = ' || line_record.event_id);
217047: l_array_duplicate_checker(line_record.event_id) := line_record.event_id;
217048: END IF;
217049: END LOOP;
217050:

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

217047: l_array_duplicate_checker(line_record.event_id) := line_record.event_id;
217048: END IF;
217049: END LOOP;
217050:
217051: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
217052: fnd_file.put_line(fnd_file.LOG, ' ');
217053:
217054:
217055: xla_exceptions_pkg.raise_message

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

217048: END IF;
217049: END LOOP;
217050:
217051: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
217052: fnd_file.put_line(fnd_file.LOG, ' ');
217053:
217054:
217055: xla_exceptions_pkg.raise_message
217056: (p_location => 'XLA_00140_AAD_S_000002_PKG.EventClass_432');

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

218241:
218242: l_first_event_id := l_array_header_events(l_array_header_events.FIRST);
218243: l_last_event_id := l_array_header_events(l_array_header_events.LAST);
218244:
218245: fnd_file.put_line(fnd_file.LOG, ' ');
218246: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
218247: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );
218248: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');
218249:

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

218242: l_first_event_id := l_array_header_events(l_array_header_events.FIRST);
218243: l_last_event_id := l_array_header_events(l_array_header_events.LAST);
218244:
218245: fnd_file.put_line(fnd_file.LOG, ' ');
218246: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
218247: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );
218248: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');
218249:
218250: FOR line_record IN line_cur(l_first_event_id, l_last_event_id)

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

218243: l_last_event_id := l_array_header_events(l_array_header_events.LAST);
218244:
218245: fnd_file.put_line(fnd_file.LOG, ' ');
218246: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
218247: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );
218248: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');
218249:
218250: FOR line_record IN line_cur(l_first_event_id, l_last_event_id)
218251: LOOP

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

218244:
218245: fnd_file.put_line(fnd_file.LOG, ' ');
218246: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
218247: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );
218248: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');
218249:
218250: FOR line_record IN line_cur(l_first_event_id, l_last_event_id)
218251: LOOP
218252: IF (NOT l_array_header_events.EXISTS(line_record.event_id)) AND (NOT l_array_duplicate_checker.EXISTS(line_record.event_id)) THEN

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

218249:
218250: FOR line_record IN line_cur(l_first_event_id, l_last_event_id)
218251: LOOP
218252: IF (NOT l_array_header_events.EXISTS(line_record.event_id)) AND (NOT l_array_duplicate_checker.EXISTS(line_record.event_id)) THEN
218253: fnd_file.put_line(fnd_file.log, 'Event_id = ' || line_record.event_id);
218254: l_array_duplicate_checker(line_record.event_id) := line_record.event_id;
218255: END IF;
218256: END LOOP;
218257:

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

218254: l_array_duplicate_checker(line_record.event_id) := line_record.event_id;
218255: END IF;
218256: END LOOP;
218257:
218258: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
218259: fnd_file.put_line(fnd_file.LOG, ' ');
218260:
218261:
218262: xla_exceptions_pkg.raise_message

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

218255: END IF;
218256: END LOOP;
218257:
218258: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
218259: fnd_file.put_line(fnd_file.LOG, ' ');
218260:
218261:
218262: xla_exceptions_pkg.raise_message
218263: (p_location => 'XLA_00140_AAD_S_000002_PKG.EventClass_433');