DBA Data[Home] [Help]

APPS.XLA_00200_AAD_S_000011_PKG dependencies on FND_FILE

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

98543:
98544: l_first_event_id := l_array_header_events(l_array_header_events.FIRST);
98545: l_last_event_id := l_array_header_events(l_array_header_events.LAST);
98546:
98547: fnd_file.put_line(fnd_file.LOG, ' ');
98548: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
98549: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );
98550: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');
98551:

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

98544: l_first_event_id := l_array_header_events(l_array_header_events.FIRST);
98545: l_last_event_id := l_array_header_events(l_array_header_events.LAST);
98546:
98547: fnd_file.put_line(fnd_file.LOG, ' ');
98548: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
98549: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );
98550: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');
98551:
98552: FOR line_record IN line_cur(l_first_event_id, l_last_event_id)

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

98545: l_last_event_id := l_array_header_events(l_array_header_events.LAST);
98546:
98547: fnd_file.put_line(fnd_file.LOG, ' ');
98548: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
98549: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );
98550: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');
98551:
98552: FOR line_record IN line_cur(l_first_event_id, l_last_event_id)
98553: LOOP

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

98546:
98547: fnd_file.put_line(fnd_file.LOG, ' ');
98548: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
98549: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );
98550: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');
98551:
98552: FOR line_record IN line_cur(l_first_event_id, l_last_event_id)
98553: LOOP
98554: IF (NOT l_array_header_events.EXISTS(line_record.event_id)) AND (NOT l_array_duplicate_checker.EXISTS(line_record.event_id)) THEN

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

98551:
98552: FOR line_record IN line_cur(l_first_event_id, l_last_event_id)
98553: LOOP
98554: IF (NOT l_array_header_events.EXISTS(line_record.event_id)) AND (NOT l_array_duplicate_checker.EXISTS(line_record.event_id)) THEN
98555: fnd_file.put_line(fnd_file.log, 'Event_id = ' || line_record.event_id);
98556: l_array_duplicate_checker(line_record.event_id) := line_record.event_id;
98557: END IF;
98558: END LOOP;
98559:

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

98556: l_array_duplicate_checker(line_record.event_id) := line_record.event_id;
98557: END IF;
98558: END LOOP;
98559:
98560: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
98561: fnd_file.put_line(fnd_file.LOG, ' ');
98562:
98563:
98564: xla_exceptions_pkg.raise_message

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

98557: END IF;
98558: END LOOP;
98559:
98560: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
98561: fnd_file.put_line(fnd_file.LOG, ' ');
98562:
98563:
98564: xla_exceptions_pkg.raise_message
98565: (p_location => 'XLA_00200_AAD_S_000011_PKG.EventClass_166');

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

101978:
101979: l_first_event_id := l_array_header_events(l_array_header_events.FIRST);
101980: l_last_event_id := l_array_header_events(l_array_header_events.LAST);
101981:
101982: fnd_file.put_line(fnd_file.LOG, ' ');
101983: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
101984: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );
101985: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');
101986:

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

101979: l_first_event_id := l_array_header_events(l_array_header_events.FIRST);
101980: l_last_event_id := l_array_header_events(l_array_header_events.LAST);
101981:
101982: fnd_file.put_line(fnd_file.LOG, ' ');
101983: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
101984: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );
101985: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');
101986:
101987: FOR line_record IN line_cur(l_first_event_id, l_last_event_id)

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

101980: l_last_event_id := l_array_header_events(l_array_header_events.LAST);
101981:
101982: fnd_file.put_line(fnd_file.LOG, ' ');
101983: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
101984: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );
101985: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');
101986:
101987: FOR line_record IN line_cur(l_first_event_id, l_last_event_id)
101988: LOOP

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

101981:
101982: fnd_file.put_line(fnd_file.LOG, ' ');
101983: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
101984: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );
101985: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');
101986:
101987: FOR line_record IN line_cur(l_first_event_id, l_last_event_id)
101988: LOOP
101989: IF (NOT l_array_header_events.EXISTS(line_record.event_id)) AND (NOT l_array_duplicate_checker.EXISTS(line_record.event_id)) THEN

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

101986:
101987: FOR line_record IN line_cur(l_first_event_id, l_last_event_id)
101988: LOOP
101989: IF (NOT l_array_header_events.EXISTS(line_record.event_id)) AND (NOT l_array_duplicate_checker.EXISTS(line_record.event_id)) THEN
101990: fnd_file.put_line(fnd_file.log, 'Event_id = ' || line_record.event_id);
101991: l_array_duplicate_checker(line_record.event_id) := line_record.event_id;
101992: END IF;
101993: END LOOP;
101994:

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

101991: l_array_duplicate_checker(line_record.event_id) := line_record.event_id;
101992: END IF;
101993: END LOOP;
101994:
101995: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
101996: fnd_file.put_line(fnd_file.LOG, ' ');
101997:
101998:
101999: xla_exceptions_pkg.raise_message

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

101992: END IF;
101993: END LOOP;
101994:
101995: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
101996: fnd_file.put_line(fnd_file.LOG, ' ');
101997:
101998:
101999: xla_exceptions_pkg.raise_message
102000: (p_location => 'XLA_00200_AAD_S_000011_PKG.EventClass_167');

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

106104:
106105: l_first_event_id := l_array_header_events(l_array_header_events.FIRST);
106106: l_last_event_id := l_array_header_events(l_array_header_events.LAST);
106107:
106108: fnd_file.put_line(fnd_file.LOG, ' ');
106109: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
106110: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );
106111: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');
106112:

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

106105: l_first_event_id := l_array_header_events(l_array_header_events.FIRST);
106106: l_last_event_id := l_array_header_events(l_array_header_events.LAST);
106107:
106108: fnd_file.put_line(fnd_file.LOG, ' ');
106109: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
106110: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );
106111: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');
106112:
106113: FOR line_record IN line_cur(l_first_event_id, l_last_event_id)

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

106106: l_last_event_id := l_array_header_events(l_array_header_events.LAST);
106107:
106108: fnd_file.put_line(fnd_file.LOG, ' ');
106109: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
106110: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );
106111: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');
106112:
106113: FOR line_record IN line_cur(l_first_event_id, l_last_event_id)
106114: LOOP

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

106107:
106108: fnd_file.put_line(fnd_file.LOG, ' ');
106109: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
106110: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );
106111: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');
106112:
106113: FOR line_record IN line_cur(l_first_event_id, l_last_event_id)
106114: LOOP
106115: IF (NOT l_array_header_events.EXISTS(line_record.event_id)) AND (NOT l_array_duplicate_checker.EXISTS(line_record.event_id)) THEN

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

106112:
106113: FOR line_record IN line_cur(l_first_event_id, l_last_event_id)
106114: LOOP
106115: IF (NOT l_array_header_events.EXISTS(line_record.event_id)) AND (NOT l_array_duplicate_checker.EXISTS(line_record.event_id)) THEN
106116: fnd_file.put_line(fnd_file.log, 'Event_id = ' || line_record.event_id);
106117: l_array_duplicate_checker(line_record.event_id) := line_record.event_id;
106118: END IF;
106119: END LOOP;
106120:

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

106117: l_array_duplicate_checker(line_record.event_id) := line_record.event_id;
106118: END IF;
106119: END LOOP;
106120:
106121: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
106122: fnd_file.put_line(fnd_file.LOG, ' ');
106123:
106124:
106125: xla_exceptions_pkg.raise_message

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

106118: END IF;
106119: END LOOP;
106120:
106121: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
106122: fnd_file.put_line(fnd_file.LOG, ' ');
106123:
106124:
106125: xla_exceptions_pkg.raise_message
106126: (p_location => 'XLA_00200_AAD_S_000011_PKG.EventClass_168');

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

109667:
109668: l_first_event_id := l_array_header_events(l_array_header_events.FIRST);
109669: l_last_event_id := l_array_header_events(l_array_header_events.LAST);
109670:
109671: fnd_file.put_line(fnd_file.LOG, ' ');
109672: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
109673: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );
109674: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');
109675:

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

109668: l_first_event_id := l_array_header_events(l_array_header_events.FIRST);
109669: l_last_event_id := l_array_header_events(l_array_header_events.LAST);
109670:
109671: fnd_file.put_line(fnd_file.LOG, ' ');
109672: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
109673: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );
109674: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');
109675:
109676: FOR line_record IN line_cur(l_first_event_id, l_last_event_id)

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

109669: l_last_event_id := l_array_header_events(l_array_header_events.LAST);
109670:
109671: fnd_file.put_line(fnd_file.LOG, ' ');
109672: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
109673: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );
109674: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');
109675:
109676: FOR line_record IN line_cur(l_first_event_id, l_last_event_id)
109677: LOOP

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

109670:
109671: fnd_file.put_line(fnd_file.LOG, ' ');
109672: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
109673: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );
109674: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');
109675:
109676: FOR line_record IN line_cur(l_first_event_id, l_last_event_id)
109677: LOOP
109678: IF (NOT l_array_header_events.EXISTS(line_record.event_id)) AND (NOT l_array_duplicate_checker.EXISTS(line_record.event_id)) THEN

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

109675:
109676: FOR line_record IN line_cur(l_first_event_id, l_last_event_id)
109677: LOOP
109678: IF (NOT l_array_header_events.EXISTS(line_record.event_id)) AND (NOT l_array_duplicate_checker.EXISTS(line_record.event_id)) THEN
109679: fnd_file.put_line(fnd_file.log, 'Event_id = ' || line_record.event_id);
109680: l_array_duplicate_checker(line_record.event_id) := line_record.event_id;
109681: END IF;
109682: END LOOP;
109683:

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

109680: l_array_duplicate_checker(line_record.event_id) := line_record.event_id;
109681: END IF;
109682: END LOOP;
109683:
109684: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
109685: fnd_file.put_line(fnd_file.LOG, ' ');
109686:
109687:
109688: xla_exceptions_pkg.raise_message

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

109681: END IF;
109682: END LOOP;
109683:
109684: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
109685: fnd_file.put_line(fnd_file.LOG, ' ');
109686:
109687:
109688: xla_exceptions_pkg.raise_message
109689: (p_location => 'XLA_00200_AAD_S_000011_PKG.EventClass_169');

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

112501:
112502: l_first_event_id := l_array_header_events(l_array_header_events.FIRST);
112503: l_last_event_id := l_array_header_events(l_array_header_events.LAST);
112504:
112505: fnd_file.put_line(fnd_file.LOG, ' ');
112506: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
112507: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );
112508: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');
112509:

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

112502: l_first_event_id := l_array_header_events(l_array_header_events.FIRST);
112503: l_last_event_id := l_array_header_events(l_array_header_events.LAST);
112504:
112505: fnd_file.put_line(fnd_file.LOG, ' ');
112506: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
112507: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );
112508: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');
112509:
112510: FOR line_record IN line_cur(l_first_event_id, l_last_event_id)

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

112503: l_last_event_id := l_array_header_events(l_array_header_events.LAST);
112504:
112505: fnd_file.put_line(fnd_file.LOG, ' ');
112506: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
112507: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );
112508: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');
112509:
112510: FOR line_record IN line_cur(l_first_event_id, l_last_event_id)
112511: LOOP

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

112504:
112505: fnd_file.put_line(fnd_file.LOG, ' ');
112506: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
112507: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );
112508: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');
112509:
112510: FOR line_record IN line_cur(l_first_event_id, l_last_event_id)
112511: LOOP
112512: IF (NOT l_array_header_events.EXISTS(line_record.event_id)) AND (NOT l_array_duplicate_checker.EXISTS(line_record.event_id)) THEN

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

112509:
112510: FOR line_record IN line_cur(l_first_event_id, l_last_event_id)
112511: LOOP
112512: IF (NOT l_array_header_events.EXISTS(line_record.event_id)) AND (NOT l_array_duplicate_checker.EXISTS(line_record.event_id)) THEN
112513: fnd_file.put_line(fnd_file.log, 'Event_id = ' || line_record.event_id);
112514: l_array_duplicate_checker(line_record.event_id) := line_record.event_id;
112515: END IF;
112516: END LOOP;
112517:

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

112514: l_array_duplicate_checker(line_record.event_id) := line_record.event_id;
112515: END IF;
112516: END LOOP;
112517:
112518: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
112519: fnd_file.put_line(fnd_file.LOG, ' ');
112520:
112521:
112522: xla_exceptions_pkg.raise_message

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

112515: END IF;
112516: END LOOP;
112517:
112518: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
112519: fnd_file.put_line(fnd_file.LOG, ' ');
112520:
112521:
112522: xla_exceptions_pkg.raise_message
112523: (p_location => 'XLA_00200_AAD_S_000011_PKG.EventClass_170');