DBA Data[Home] [Help]

APPS.XLA_00222_AAD_S_000007_PKG dependencies on FND_FILE

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

54318:
54319: l_first_event_id := l_array_header_events(l_array_header_events.FIRST);
54320: l_last_event_id := l_array_header_events(l_array_header_events.LAST);
54321:
54322: fnd_file.put_line(fnd_file.LOG, ' ');
54323: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
54324: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );
54325: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');
54326:

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

54319: l_first_event_id := l_array_header_events(l_array_header_events.FIRST);
54320: l_last_event_id := l_array_header_events(l_array_header_events.LAST);
54321:
54322: fnd_file.put_line(fnd_file.LOG, ' ');
54323: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
54324: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );
54325: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');
54326:
54327: FOR line_record IN line_cur(l_first_event_id, l_last_event_id)

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

54320: l_last_event_id := l_array_header_events(l_array_header_events.LAST);
54321:
54322: fnd_file.put_line(fnd_file.LOG, ' ');
54323: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
54324: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );
54325: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');
54326:
54327: FOR line_record IN line_cur(l_first_event_id, l_last_event_id)
54328: LOOP

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

54321:
54322: fnd_file.put_line(fnd_file.LOG, ' ');
54323: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
54324: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );
54325: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');
54326:
54327: FOR line_record IN line_cur(l_first_event_id, l_last_event_id)
54328: LOOP
54329: IF (NOT l_array_header_events.EXISTS(line_record.event_id)) AND (NOT l_array_duplicate_checker.EXISTS(line_record.event_id)) THEN

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

54326:
54327: FOR line_record IN line_cur(l_first_event_id, l_last_event_id)
54328: LOOP
54329: IF (NOT l_array_header_events.EXISTS(line_record.event_id)) AND (NOT l_array_duplicate_checker.EXISTS(line_record.event_id)) THEN
54330: fnd_file.put_line(fnd_file.log, 'Event_id = ' || line_record.event_id);
54331: l_array_duplicate_checker(line_record.event_id) := line_record.event_id;
54332: END IF;
54333: END LOOP;
54334:

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

54331: l_array_duplicate_checker(line_record.event_id) := line_record.event_id;
54332: END IF;
54333: END LOOP;
54334:
54335: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
54336: fnd_file.put_line(fnd_file.LOG, ' ');
54337:
54338:
54339: xla_exceptions_pkg.raise_message

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

54332: END IF;
54333: END LOOP;
54334:
54335: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
54336: fnd_file.put_line(fnd_file.LOG, ' ');
54337:
54338:
54339: xla_exceptions_pkg.raise_message
54340: (p_location => 'XLA_00222_AAD_S_000007_PKG.EventClass_104');

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

55564:
55565: l_first_event_id := l_array_header_events(l_array_header_events.FIRST);
55566: l_last_event_id := l_array_header_events(l_array_header_events.LAST);
55567:
55568: fnd_file.put_line(fnd_file.LOG, ' ');
55569: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
55570: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );
55571: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');
55572:

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

55565: l_first_event_id := l_array_header_events(l_array_header_events.FIRST);
55566: l_last_event_id := l_array_header_events(l_array_header_events.LAST);
55567:
55568: fnd_file.put_line(fnd_file.LOG, ' ');
55569: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
55570: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );
55571: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');
55572:
55573: FOR line_record IN line_cur(l_first_event_id, l_last_event_id)

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

55566: l_last_event_id := l_array_header_events(l_array_header_events.LAST);
55567:
55568: fnd_file.put_line(fnd_file.LOG, ' ');
55569: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
55570: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );
55571: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');
55572:
55573: FOR line_record IN line_cur(l_first_event_id, l_last_event_id)
55574: LOOP

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

55567:
55568: fnd_file.put_line(fnd_file.LOG, ' ');
55569: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
55570: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );
55571: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');
55572:
55573: FOR line_record IN line_cur(l_first_event_id, l_last_event_id)
55574: LOOP
55575: IF (NOT l_array_header_events.EXISTS(line_record.event_id)) AND (NOT l_array_duplicate_checker.EXISTS(line_record.event_id)) THEN

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

55572:
55573: FOR line_record IN line_cur(l_first_event_id, l_last_event_id)
55574: LOOP
55575: IF (NOT l_array_header_events.EXISTS(line_record.event_id)) AND (NOT l_array_duplicate_checker.EXISTS(line_record.event_id)) THEN
55576: fnd_file.put_line(fnd_file.log, 'Event_id = ' || line_record.event_id);
55577: l_array_duplicate_checker(line_record.event_id) := line_record.event_id;
55578: END IF;
55579: END LOOP;
55580:

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

55577: l_array_duplicate_checker(line_record.event_id) := line_record.event_id;
55578: END IF;
55579: END LOOP;
55580:
55581: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
55582: fnd_file.put_line(fnd_file.LOG, ' ');
55583:
55584:
55585: xla_exceptions_pkg.raise_message

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

55578: END IF;
55579: END LOOP;
55580:
55581: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
55582: fnd_file.put_line(fnd_file.LOG, ' ');
55583:
55584:
55585: xla_exceptions_pkg.raise_message
55586: (p_location => 'XLA_00222_AAD_S_000007_PKG.EventClass_105');

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

57183:
57184: l_first_event_id := l_array_header_events(l_array_header_events.FIRST);
57185: l_last_event_id := l_array_header_events(l_array_header_events.LAST);
57186:
57187: fnd_file.put_line(fnd_file.LOG, ' ');
57188: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
57189: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );
57190: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');
57191:

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

57184: l_first_event_id := l_array_header_events(l_array_header_events.FIRST);
57185: l_last_event_id := l_array_header_events(l_array_header_events.LAST);
57186:
57187: fnd_file.put_line(fnd_file.LOG, ' ');
57188: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
57189: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );
57190: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');
57191:
57192: FOR line_record IN line_cur(l_first_event_id, l_last_event_id)

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

57185: l_last_event_id := l_array_header_events(l_array_header_events.LAST);
57186:
57187: fnd_file.put_line(fnd_file.LOG, ' ');
57188: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
57189: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );
57190: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');
57191:
57192: FOR line_record IN line_cur(l_first_event_id, l_last_event_id)
57193: LOOP

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

57186:
57187: fnd_file.put_line(fnd_file.LOG, ' ');
57188: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
57189: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );
57190: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');
57191:
57192: FOR line_record IN line_cur(l_first_event_id, l_last_event_id)
57193: LOOP
57194: IF (NOT l_array_header_events.EXISTS(line_record.event_id)) AND (NOT l_array_duplicate_checker.EXISTS(line_record.event_id)) THEN

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

57191:
57192: FOR line_record IN line_cur(l_first_event_id, l_last_event_id)
57193: LOOP
57194: IF (NOT l_array_header_events.EXISTS(line_record.event_id)) AND (NOT l_array_duplicate_checker.EXISTS(line_record.event_id)) THEN
57195: fnd_file.put_line(fnd_file.log, 'Event_id = ' || line_record.event_id);
57196: l_array_duplicate_checker(line_record.event_id) := line_record.event_id;
57197: END IF;
57198: END LOOP;
57199:

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

57196: l_array_duplicate_checker(line_record.event_id) := line_record.event_id;
57197: END IF;
57198: END LOOP;
57199:
57200: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
57201: fnd_file.put_line(fnd_file.LOG, ' ');
57202:
57203:
57204: xla_exceptions_pkg.raise_message

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

57197: END IF;
57198: END LOOP;
57199:
57200: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
57201: fnd_file.put_line(fnd_file.LOG, ' ');
57202:
57203:
57204: xla_exceptions_pkg.raise_message
57205: (p_location => 'XLA_00222_AAD_S_000007_PKG.EventClass_106');

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

58654:
58655: l_first_event_id := l_array_header_events(l_array_header_events.FIRST);
58656: l_last_event_id := l_array_header_events(l_array_header_events.LAST);
58657:
58658: fnd_file.put_line(fnd_file.LOG, ' ');
58659: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
58660: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );
58661: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');
58662:

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

58655: l_first_event_id := l_array_header_events(l_array_header_events.FIRST);
58656: l_last_event_id := l_array_header_events(l_array_header_events.LAST);
58657:
58658: fnd_file.put_line(fnd_file.LOG, ' ');
58659: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
58660: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );
58661: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');
58662:
58663: FOR line_record IN line_cur(l_first_event_id, l_last_event_id)

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

58656: l_last_event_id := l_array_header_events(l_array_header_events.LAST);
58657:
58658: fnd_file.put_line(fnd_file.LOG, ' ');
58659: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
58660: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );
58661: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');
58662:
58663: FOR line_record IN line_cur(l_first_event_id, l_last_event_id)
58664: LOOP

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

58657:
58658: fnd_file.put_line(fnd_file.LOG, ' ');
58659: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
58660: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );
58661: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');
58662:
58663: FOR line_record IN line_cur(l_first_event_id, l_last_event_id)
58664: LOOP
58665: IF (NOT l_array_header_events.EXISTS(line_record.event_id)) AND (NOT l_array_duplicate_checker.EXISTS(line_record.event_id)) THEN

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

58662:
58663: FOR line_record IN line_cur(l_first_event_id, l_last_event_id)
58664: LOOP
58665: IF (NOT l_array_header_events.EXISTS(line_record.event_id)) AND (NOT l_array_duplicate_checker.EXISTS(line_record.event_id)) THEN
58666: fnd_file.put_line(fnd_file.log, 'Event_id = ' || line_record.event_id);
58667: l_array_duplicate_checker(line_record.event_id) := line_record.event_id;
58668: END IF;
58669: END LOOP;
58670:

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

58667: l_array_duplicate_checker(line_record.event_id) := line_record.event_id;
58668: END IF;
58669: END LOOP;
58670:
58671: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
58672: fnd_file.put_line(fnd_file.LOG, ' ');
58673:
58674:
58675: xla_exceptions_pkg.raise_message

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

58668: END IF;
58669: END LOOP;
58670:
58671: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
58672: fnd_file.put_line(fnd_file.LOG, ' ');
58673:
58674:
58675: xla_exceptions_pkg.raise_message
58676: (p_location => 'XLA_00222_AAD_S_000007_PKG.EventClass_107');

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

59900:
59901: l_first_event_id := l_array_header_events(l_array_header_events.FIRST);
59902: l_last_event_id := l_array_header_events(l_array_header_events.LAST);
59903:
59904: fnd_file.put_line(fnd_file.LOG, ' ');
59905: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
59906: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );
59907: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');
59908:

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

59901: l_first_event_id := l_array_header_events(l_array_header_events.FIRST);
59902: l_last_event_id := l_array_header_events(l_array_header_events.LAST);
59903:
59904: fnd_file.put_line(fnd_file.LOG, ' ');
59905: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
59906: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );
59907: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');
59908:
59909: FOR line_record IN line_cur(l_first_event_id, l_last_event_id)

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

59902: l_last_event_id := l_array_header_events(l_array_header_events.LAST);
59903:
59904: fnd_file.put_line(fnd_file.LOG, ' ');
59905: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
59906: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );
59907: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');
59908:
59909: FOR line_record IN line_cur(l_first_event_id, l_last_event_id)
59910: LOOP

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

59903:
59904: fnd_file.put_line(fnd_file.LOG, ' ');
59905: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
59906: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );
59907: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');
59908:
59909: FOR line_record IN line_cur(l_first_event_id, l_last_event_id)
59910: LOOP
59911: IF (NOT l_array_header_events.EXISTS(line_record.event_id)) AND (NOT l_array_duplicate_checker.EXISTS(line_record.event_id)) THEN

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

59908:
59909: FOR line_record IN line_cur(l_first_event_id, l_last_event_id)
59910: LOOP
59911: IF (NOT l_array_header_events.EXISTS(line_record.event_id)) AND (NOT l_array_duplicate_checker.EXISTS(line_record.event_id)) THEN
59912: fnd_file.put_line(fnd_file.log, 'Event_id = ' || line_record.event_id);
59913: l_array_duplicate_checker(line_record.event_id) := line_record.event_id;
59914: END IF;
59915: END LOOP;
59916:

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

59913: l_array_duplicate_checker(line_record.event_id) := line_record.event_id;
59914: END IF;
59915: END LOOP;
59916:
59917: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
59918: fnd_file.put_line(fnd_file.LOG, ' ');
59919:
59920:
59921: xla_exceptions_pkg.raise_message

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

59914: END IF;
59915: END LOOP;
59916:
59917: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
59918: fnd_file.put_line(fnd_file.LOG, ' ');
59919:
59920:
59921: xla_exceptions_pkg.raise_message
59922: (p_location => 'XLA_00222_AAD_S_000007_PKG.EventClass_108');

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

61146:
61147: l_first_event_id := l_array_header_events(l_array_header_events.FIRST);
61148: l_last_event_id := l_array_header_events(l_array_header_events.LAST);
61149:
61150: fnd_file.put_line(fnd_file.LOG, ' ');
61151: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
61152: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );
61153: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');
61154:

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

61147: l_first_event_id := l_array_header_events(l_array_header_events.FIRST);
61148: l_last_event_id := l_array_header_events(l_array_header_events.LAST);
61149:
61150: fnd_file.put_line(fnd_file.LOG, ' ');
61151: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
61152: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );
61153: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');
61154:
61155: FOR line_record IN line_cur(l_first_event_id, l_last_event_id)

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

61148: l_last_event_id := l_array_header_events(l_array_header_events.LAST);
61149:
61150: fnd_file.put_line(fnd_file.LOG, ' ');
61151: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
61152: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );
61153: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');
61154:
61155: FOR line_record IN line_cur(l_first_event_id, l_last_event_id)
61156: LOOP

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

61149:
61150: fnd_file.put_line(fnd_file.LOG, ' ');
61151: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
61152: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );
61153: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');
61154:
61155: FOR line_record IN line_cur(l_first_event_id, l_last_event_id)
61156: LOOP
61157: IF (NOT l_array_header_events.EXISTS(line_record.event_id)) AND (NOT l_array_duplicate_checker.EXISTS(line_record.event_id)) THEN

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

61154:
61155: FOR line_record IN line_cur(l_first_event_id, l_last_event_id)
61156: LOOP
61157: IF (NOT l_array_header_events.EXISTS(line_record.event_id)) AND (NOT l_array_duplicate_checker.EXISTS(line_record.event_id)) THEN
61158: fnd_file.put_line(fnd_file.log, 'Event_id = ' || line_record.event_id);
61159: l_array_duplicate_checker(line_record.event_id) := line_record.event_id;
61160: END IF;
61161: END LOOP;
61162:

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

61159: l_array_duplicate_checker(line_record.event_id) := line_record.event_id;
61160: END IF;
61161: END LOOP;
61162:
61163: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
61164: fnd_file.put_line(fnd_file.LOG, ' ');
61165:
61166:
61167: xla_exceptions_pkg.raise_message

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

61160: END IF;
61161: END LOOP;
61162:
61163: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
61164: fnd_file.put_line(fnd_file.LOG, ' ');
61165:
61166:
61167: xla_exceptions_pkg.raise_message
61168: (p_location => 'XLA_00222_AAD_S_000007_PKG.EventClass_109');

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

62629:
62630: l_first_event_id := l_array_header_events(l_array_header_events.FIRST);
62631: l_last_event_id := l_array_header_events(l_array_header_events.LAST);
62632:
62633: fnd_file.put_line(fnd_file.LOG, ' ');
62634: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
62635: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );
62636: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');
62637:

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

62630: l_first_event_id := l_array_header_events(l_array_header_events.FIRST);
62631: l_last_event_id := l_array_header_events(l_array_header_events.LAST);
62632:
62633: fnd_file.put_line(fnd_file.LOG, ' ');
62634: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
62635: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );
62636: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');
62637:
62638: FOR line_record IN line_cur(l_first_event_id, l_last_event_id)

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

62631: l_last_event_id := l_array_header_events(l_array_header_events.LAST);
62632:
62633: fnd_file.put_line(fnd_file.LOG, ' ');
62634: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
62635: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );
62636: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');
62637:
62638: FOR line_record IN line_cur(l_first_event_id, l_last_event_id)
62639: LOOP

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

62632:
62633: fnd_file.put_line(fnd_file.LOG, ' ');
62634: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
62635: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );
62636: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');
62637:
62638: FOR line_record IN line_cur(l_first_event_id, l_last_event_id)
62639: LOOP
62640: IF (NOT l_array_header_events.EXISTS(line_record.event_id)) AND (NOT l_array_duplicate_checker.EXISTS(line_record.event_id)) THEN

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

62637:
62638: FOR line_record IN line_cur(l_first_event_id, l_last_event_id)
62639: LOOP
62640: IF (NOT l_array_header_events.EXISTS(line_record.event_id)) AND (NOT l_array_duplicate_checker.EXISTS(line_record.event_id)) THEN
62641: fnd_file.put_line(fnd_file.log, 'Event_id = ' || line_record.event_id);
62642: l_array_duplicate_checker(line_record.event_id) := line_record.event_id;
62643: END IF;
62644: END LOOP;
62645:

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

62642: l_array_duplicate_checker(line_record.event_id) := line_record.event_id;
62643: END IF;
62644: END LOOP;
62645:
62646: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
62647: fnd_file.put_line(fnd_file.LOG, ' ');
62648:
62649:
62650: xla_exceptions_pkg.raise_message

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

62643: END IF;
62644: END LOOP;
62645:
62646: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
62647: fnd_file.put_line(fnd_file.LOG, ' ');
62648:
62649:
62650: xla_exceptions_pkg.raise_message
62651: (p_location => 'XLA_00222_AAD_S_000007_PKG.EventClass_110');

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

64158:
64159: l_first_event_id := l_array_header_events(l_array_header_events.FIRST);
64160: l_last_event_id := l_array_header_events(l_array_header_events.LAST);
64161:
64162: fnd_file.put_line(fnd_file.LOG, ' ');
64163: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
64164: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );
64165: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');
64166:

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

64159: l_first_event_id := l_array_header_events(l_array_header_events.FIRST);
64160: l_last_event_id := l_array_header_events(l_array_header_events.LAST);
64161:
64162: fnd_file.put_line(fnd_file.LOG, ' ');
64163: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
64164: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );
64165: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');
64166:
64167: FOR line_record IN line_cur(l_first_event_id, l_last_event_id)

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

64160: l_last_event_id := l_array_header_events(l_array_header_events.LAST);
64161:
64162: fnd_file.put_line(fnd_file.LOG, ' ');
64163: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
64164: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );
64165: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');
64166:
64167: FOR line_record IN line_cur(l_first_event_id, l_last_event_id)
64168: LOOP

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

64161:
64162: fnd_file.put_line(fnd_file.LOG, ' ');
64163: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
64164: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );
64165: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');
64166:
64167: FOR line_record IN line_cur(l_first_event_id, l_last_event_id)
64168: LOOP
64169: IF (NOT l_array_header_events.EXISTS(line_record.event_id)) AND (NOT l_array_duplicate_checker.EXISTS(line_record.event_id)) THEN

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

64166:
64167: FOR line_record IN line_cur(l_first_event_id, l_last_event_id)
64168: LOOP
64169: IF (NOT l_array_header_events.EXISTS(line_record.event_id)) AND (NOT l_array_duplicate_checker.EXISTS(line_record.event_id)) THEN
64170: fnd_file.put_line(fnd_file.log, 'Event_id = ' || line_record.event_id);
64171: l_array_duplicate_checker(line_record.event_id) := line_record.event_id;
64172: END IF;
64173: END LOOP;
64174:

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

64171: l_array_duplicate_checker(line_record.event_id) := line_record.event_id;
64172: END IF;
64173: END LOOP;
64174:
64175: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
64176: fnd_file.put_line(fnd_file.LOG, ' ');
64177:
64178:
64179: xla_exceptions_pkg.raise_message

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

64172: END IF;
64173: END LOOP;
64174:
64175: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
64176: fnd_file.put_line(fnd_file.LOG, ' ');
64177:
64178:
64179: xla_exceptions_pkg.raise_message
64180: (p_location => 'XLA_00222_AAD_S_000007_PKG.EventClass_111');

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

67038:
67039: l_first_event_id := l_array_header_events(l_array_header_events.FIRST);
67040: l_last_event_id := l_array_header_events(l_array_header_events.LAST);
67041:
67042: fnd_file.put_line(fnd_file.LOG, ' ');
67043: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
67044: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );
67045: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');
67046:

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

67039: l_first_event_id := l_array_header_events(l_array_header_events.FIRST);
67040: l_last_event_id := l_array_header_events(l_array_header_events.LAST);
67041:
67042: fnd_file.put_line(fnd_file.LOG, ' ');
67043: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
67044: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );
67045: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');
67046:
67047: FOR line_record IN line_cur(l_first_event_id, l_last_event_id)

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

67040: l_last_event_id := l_array_header_events(l_array_header_events.LAST);
67041:
67042: fnd_file.put_line(fnd_file.LOG, ' ');
67043: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
67044: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );
67045: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');
67046:
67047: FOR line_record IN line_cur(l_first_event_id, l_last_event_id)
67048: LOOP

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

67041:
67042: fnd_file.put_line(fnd_file.LOG, ' ');
67043: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
67044: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );
67045: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');
67046:
67047: FOR line_record IN line_cur(l_first_event_id, l_last_event_id)
67048: LOOP
67049: IF (NOT l_array_header_events.EXISTS(line_record.event_id)) AND (NOT l_array_duplicate_checker.EXISTS(line_record.event_id)) THEN

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

67046:
67047: FOR line_record IN line_cur(l_first_event_id, l_last_event_id)
67048: LOOP
67049: IF (NOT l_array_header_events.EXISTS(line_record.event_id)) AND (NOT l_array_duplicate_checker.EXISTS(line_record.event_id)) THEN
67050: fnd_file.put_line(fnd_file.log, 'Event_id = ' || line_record.event_id);
67051: l_array_duplicate_checker(line_record.event_id) := line_record.event_id;
67052: END IF;
67053: END LOOP;
67054:

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

67051: l_array_duplicate_checker(line_record.event_id) := line_record.event_id;
67052: END IF;
67053: END LOOP;
67054:
67055: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
67056: fnd_file.put_line(fnd_file.LOG, ' ');
67057:
67058:
67059: xla_exceptions_pkg.raise_message

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

67052: END IF;
67053: END LOOP;
67054:
67055: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
67056: fnd_file.put_line(fnd_file.LOG, ' ');
67057:
67058:
67059: xla_exceptions_pkg.raise_message
67060: (p_location => 'XLA_00222_AAD_S_000007_PKG.EventClass_112');