DBA Data[Home] [Help]

APPS.XLA_09000_AAD_S_000015_PKG dependencies on FND_FILE

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

7629:
7630: l_first_event_id := l_array_header_events(l_array_header_events.FIRST);
7631: l_last_event_id := l_array_header_events(l_array_header_events.LAST);
7632:
7633: fnd_file.put_line(fnd_file.LOG, ' ');
7634: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
7635: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );
7636: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');
7637:

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

7630: l_first_event_id := l_array_header_events(l_array_header_events.FIRST);
7631: l_last_event_id := l_array_header_events(l_array_header_events.LAST);
7632:
7633: fnd_file.put_line(fnd_file.LOG, ' ');
7634: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
7635: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );
7636: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');
7637:
7638: FOR line_record IN line_cur(l_first_event_id, l_last_event_id)

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

7631: l_last_event_id := l_array_header_events(l_array_header_events.LAST);
7632:
7633: fnd_file.put_line(fnd_file.LOG, ' ');
7634: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
7635: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );
7636: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');
7637:
7638: FOR line_record IN line_cur(l_first_event_id, l_last_event_id)
7639: LOOP

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

7632:
7633: fnd_file.put_line(fnd_file.LOG, ' ');
7634: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
7635: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );
7636: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');
7637:
7638: FOR line_record IN line_cur(l_first_event_id, l_last_event_id)
7639: LOOP
7640: IF (NOT l_array_header_events.EXISTS(line_record.event_id)) AND (NOT l_array_duplicate_checker.EXISTS(line_record.event_id)) THEN

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

7637:
7638: FOR line_record IN line_cur(l_first_event_id, l_last_event_id)
7639: LOOP
7640: IF (NOT l_array_header_events.EXISTS(line_record.event_id)) AND (NOT l_array_duplicate_checker.EXISTS(line_record.event_id)) THEN
7641: fnd_file.put_line(fnd_file.log, 'Event_id = ' || line_record.event_id);
7642: l_array_duplicate_checker(line_record.event_id) := line_record.event_id;
7643: END IF;
7644: END LOOP;
7645:

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

7642: l_array_duplicate_checker(line_record.event_id) := line_record.event_id;
7643: END IF;
7644: END LOOP;
7645:
7646: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
7647: fnd_file.put_line(fnd_file.LOG, ' ');
7648:
7649:
7650: xla_exceptions_pkg.raise_message

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

7643: END IF;
7644: END LOOP;
7645:
7646: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
7647: fnd_file.put_line(fnd_file.LOG, ' ');
7648:
7649:
7650: xla_exceptions_pkg.raise_message
7651: (p_location => 'XLA_09000_AAD_S_000015_PKG.EventClass_18');

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

8823:
8824: l_first_event_id := l_array_header_events(l_array_header_events.FIRST);
8825: l_last_event_id := l_array_header_events(l_array_header_events.LAST);
8826:
8827: fnd_file.put_line(fnd_file.LOG, ' ');
8828: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
8829: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );
8830: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');
8831:

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

8824: l_first_event_id := l_array_header_events(l_array_header_events.FIRST);
8825: l_last_event_id := l_array_header_events(l_array_header_events.LAST);
8826:
8827: fnd_file.put_line(fnd_file.LOG, ' ');
8828: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
8829: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );
8830: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');
8831:
8832: FOR line_record IN line_cur(l_first_event_id, l_last_event_id)

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

8825: l_last_event_id := l_array_header_events(l_array_header_events.LAST);
8826:
8827: fnd_file.put_line(fnd_file.LOG, ' ');
8828: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
8829: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );
8830: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');
8831:
8832: FOR line_record IN line_cur(l_first_event_id, l_last_event_id)
8833: LOOP

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

8826:
8827: fnd_file.put_line(fnd_file.LOG, ' ');
8828: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
8829: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );
8830: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');
8831:
8832: FOR line_record IN line_cur(l_first_event_id, l_last_event_id)
8833: LOOP
8834: IF (NOT l_array_header_events.EXISTS(line_record.event_id)) AND (NOT l_array_duplicate_checker.EXISTS(line_record.event_id)) THEN

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

8831:
8832: FOR line_record IN line_cur(l_first_event_id, l_last_event_id)
8833: LOOP
8834: IF (NOT l_array_header_events.EXISTS(line_record.event_id)) AND (NOT l_array_duplicate_checker.EXISTS(line_record.event_id)) THEN
8835: fnd_file.put_line(fnd_file.log, 'Event_id = ' || line_record.event_id);
8836: l_array_duplicate_checker(line_record.event_id) := line_record.event_id;
8837: END IF;
8838: END LOOP;
8839:

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

8836: l_array_duplicate_checker(line_record.event_id) := line_record.event_id;
8837: END IF;
8838: END LOOP;
8839:
8840: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
8841: fnd_file.put_line(fnd_file.LOG, ' ');
8842:
8843:
8844: xla_exceptions_pkg.raise_message

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

8837: END IF;
8838: END LOOP;
8839:
8840: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
8841: fnd_file.put_line(fnd_file.LOG, ' ');
8842:
8843:
8844: xla_exceptions_pkg.raise_message
8845: (p_location => 'XLA_09000_AAD_S_000015_PKG.EventType_19');

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

9986:
9987: l_first_event_id := l_array_header_events(l_array_header_events.FIRST);
9988: l_last_event_id := l_array_header_events(l_array_header_events.LAST);
9989:
9990: fnd_file.put_line(fnd_file.LOG, ' ');
9991: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
9992: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );
9993: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');
9994:

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

9987: l_first_event_id := l_array_header_events(l_array_header_events.FIRST);
9988: l_last_event_id := l_array_header_events(l_array_header_events.LAST);
9989:
9990: fnd_file.put_line(fnd_file.LOG, ' ');
9991: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
9992: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );
9993: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');
9994:
9995: FOR line_record IN line_cur(l_first_event_id, l_last_event_id)

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

9988: l_last_event_id := l_array_header_events(l_array_header_events.LAST);
9989:
9990: fnd_file.put_line(fnd_file.LOG, ' ');
9991: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
9992: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );
9993: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');
9994:
9995: FOR line_record IN line_cur(l_first_event_id, l_last_event_id)
9996: LOOP

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

9989:
9990: fnd_file.put_line(fnd_file.LOG, ' ');
9991: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
9992: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );
9993: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');
9994:
9995: FOR line_record IN line_cur(l_first_event_id, l_last_event_id)
9996: LOOP
9997: IF (NOT l_array_header_events.EXISTS(line_record.event_id)) AND (NOT l_array_duplicate_checker.EXISTS(line_record.event_id)) THEN

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

9994:
9995: FOR line_record IN line_cur(l_first_event_id, l_last_event_id)
9996: LOOP
9997: IF (NOT l_array_header_events.EXISTS(line_record.event_id)) AND (NOT l_array_duplicate_checker.EXISTS(line_record.event_id)) THEN
9998: fnd_file.put_line(fnd_file.log, 'Event_id = ' || line_record.event_id);
9999: l_array_duplicate_checker(line_record.event_id) := line_record.event_id;
10000: END IF;
10001: END LOOP;
10002:

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

9999: l_array_duplicate_checker(line_record.event_id) := line_record.event_id;
10000: END IF;
10001: END LOOP;
10002:
10003: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
10004: fnd_file.put_line(fnd_file.LOG, ' ');
10005:
10006:
10007: xla_exceptions_pkg.raise_message

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

10000: END IF;
10001: END LOOP;
10002:
10003: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
10004: fnd_file.put_line(fnd_file.LOG, ' ');
10005:
10006:
10007: xla_exceptions_pkg.raise_message
10008: (p_location => 'XLA_09000_AAD_S_000015_PKG.EventType_20');

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

11180:
11181: l_first_event_id := l_array_header_events(l_array_header_events.FIRST);
11182: l_last_event_id := l_array_header_events(l_array_header_events.LAST);
11183:
11184: fnd_file.put_line(fnd_file.LOG, ' ');
11185: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
11186: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );
11187: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');
11188:

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

11181: l_first_event_id := l_array_header_events(l_array_header_events.FIRST);
11182: l_last_event_id := l_array_header_events(l_array_header_events.LAST);
11183:
11184: fnd_file.put_line(fnd_file.LOG, ' ');
11185: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
11186: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );
11187: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');
11188:
11189: FOR line_record IN line_cur(l_first_event_id, l_last_event_id)

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

11182: l_last_event_id := l_array_header_events(l_array_header_events.LAST);
11183:
11184: fnd_file.put_line(fnd_file.LOG, ' ');
11185: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
11186: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );
11187: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');
11188:
11189: FOR line_record IN line_cur(l_first_event_id, l_last_event_id)
11190: LOOP

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

11183:
11184: fnd_file.put_line(fnd_file.LOG, ' ');
11185: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
11186: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );
11187: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');
11188:
11189: FOR line_record IN line_cur(l_first_event_id, l_last_event_id)
11190: LOOP
11191: IF (NOT l_array_header_events.EXISTS(line_record.event_id)) AND (NOT l_array_duplicate_checker.EXISTS(line_record.event_id)) THEN

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

11188:
11189: FOR line_record IN line_cur(l_first_event_id, l_last_event_id)
11190: LOOP
11191: IF (NOT l_array_header_events.EXISTS(line_record.event_id)) AND (NOT l_array_duplicate_checker.EXISTS(line_record.event_id)) THEN
11192: fnd_file.put_line(fnd_file.log, 'Event_id = ' || line_record.event_id);
11193: l_array_duplicate_checker(line_record.event_id) := line_record.event_id;
11194: END IF;
11195: END LOOP;
11196:

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

11193: l_array_duplicate_checker(line_record.event_id) := line_record.event_id;
11194: END IF;
11195: END LOOP;
11196:
11197: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
11198: fnd_file.put_line(fnd_file.LOG, ' ');
11199:
11200:
11201: xla_exceptions_pkg.raise_message

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

11194: END IF;
11195: END LOOP;
11196:
11197: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
11198: fnd_file.put_line(fnd_file.LOG, ' ');
11199:
11200:
11201: xla_exceptions_pkg.raise_message
11202: (p_location => 'XLA_09000_AAD_S_000015_PKG.EventType_21');

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

12374:
12375: l_first_event_id := l_array_header_events(l_array_header_events.FIRST);
12376: l_last_event_id := l_array_header_events(l_array_header_events.LAST);
12377:
12378: fnd_file.put_line(fnd_file.LOG, ' ');
12379: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
12380: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );
12381: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');
12382:

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

12375: l_first_event_id := l_array_header_events(l_array_header_events.FIRST);
12376: l_last_event_id := l_array_header_events(l_array_header_events.LAST);
12377:
12378: fnd_file.put_line(fnd_file.LOG, ' ');
12379: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
12380: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );
12381: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');
12382:
12383: FOR line_record IN line_cur(l_first_event_id, l_last_event_id)

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

12376: l_last_event_id := l_array_header_events(l_array_header_events.LAST);
12377:
12378: fnd_file.put_line(fnd_file.LOG, ' ');
12379: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
12380: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );
12381: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');
12382:
12383: FOR line_record IN line_cur(l_first_event_id, l_last_event_id)
12384: LOOP

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

12377:
12378: fnd_file.put_line(fnd_file.LOG, ' ');
12379: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
12380: fnd_file.put_line(fnd_file.LOG, 'EVENT CLASS CODE = ' || C_EVENT_CLASS_CODE );
12381: fnd_file.put_line(fnd_file.LOG, 'The following events are present in the line extract but MISSING in the header extract: ');
12382:
12383: FOR line_record IN line_cur(l_first_event_id, l_last_event_id)
12384: LOOP
12385: IF (NOT l_array_header_events.EXISTS(line_record.event_id)) AND (NOT l_array_duplicate_checker.EXISTS(line_record.event_id)) THEN

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

12382:
12383: FOR line_record IN line_cur(l_first_event_id, l_last_event_id)
12384: LOOP
12385: IF (NOT l_array_header_events.EXISTS(line_record.event_id)) AND (NOT l_array_duplicate_checker.EXISTS(line_record.event_id)) THEN
12386: fnd_file.put_line(fnd_file.log, 'Event_id = ' || line_record.event_id);
12387: l_array_duplicate_checker(line_record.event_id) := line_record.event_id;
12388: END IF;
12389: END LOOP;
12390:

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

12387: l_array_duplicate_checker(line_record.event_id) := line_record.event_id;
12388: END IF;
12389: END LOOP;
12390:
12391: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
12392: fnd_file.put_line(fnd_file.LOG, ' ');
12393:
12394:
12395: xla_exceptions_pkg.raise_message

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

12388: END IF;
12389: END LOOP;
12390:
12391: fnd_file.put_line(fnd_file.LOG, '***************************************************************************');
12392: fnd_file.put_line(fnd_file.LOG, ' ');
12393:
12394:
12395: xla_exceptions_pkg.raise_message
12396: (p_location => 'XLA_09000_AAD_S_000015_PKG.EventType_22');