DBA Data[Home] [Help]

APPS.EDR_ERES_EVENT_PVT dependencies on FND_FILE

Line 927: fnd_file.put_line(fnd_file.output, fnd_message.get);

923:
924: delete from EDR_ERESMANAGER_T where CREATION_DATE <= L_TEMP_DATE;
925: fnd_message.set_name('EDR', 'EDR_TEMP_ERESMANAGER_CLEANUP');
926: fnd_message.set_token( 'CLN_ERESMANAGER', SQL%ROWCOUNT);
927: fnd_file.put_line(fnd_file.output, fnd_message.get);
928:
929: delete from EDR_PROCESS_ERECORDS_T where CREATION_DATE <= L_TEMP_DATE;
930: fnd_message.set_name('EDR', 'EDR_TEMP_ERECORDS_CLEANUP');
931: fnd_message.set_token( 'CLN_ERECORDS', SQL%ROWCOUNT);

Line 932: fnd_file.put_line(fnd_file.output, fnd_message.get);

928:
929: delete from EDR_PROCESS_ERECORDS_T where CREATION_DATE <= L_TEMP_DATE;
930: fnd_message.set_name('EDR', 'EDR_TEMP_ERECORDS_CLEANUP');
931: fnd_message.set_token( 'CLN_ERECORDS', SQL%ROWCOUNT);
932: fnd_file.put_line(fnd_file.output, fnd_message.get);
933:
934: --Bug 3621309 : Start
935: delete from EDR_RAW_XML_T where CREATION_DATE <= L_TEMP_DATE;
936: fnd_message.set_name('EDR', 'EDR_VALIDATE_TEMP_DATA_CLEANUP');

Line 938: fnd_file.put_line(fnd_file.output, fnd_message.get);

934: --Bug 3621309 : Start
935: delete from EDR_RAW_XML_T where CREATION_DATE <= L_TEMP_DATE;
936: fnd_message.set_name('EDR', 'EDR_VALIDATE_TEMP_DATA_CLEANUP');
937: fnd_message.set_token( 'CLN_ERECORDS', SQL%ROWCOUNT);
938: fnd_file.put_line(fnd_file.output, fnd_message.get);
939: --Bug 3621309 : End
940:
941: end if;
942: end if;

Line 947: fnd_file.put_line(fnd_file.output, fnd_message.get_string('EDR', 'EDR_INVALID_PROFILE_VALUE'));

943:
944: exception
945:
946: when VALUE_ERROR then
947: fnd_file.put_line(fnd_file.output, fnd_message.get_string('EDR', 'EDR_INVALID_PROFILE_VALUE'));
948:
949: END DELETE_ERECORDS;
950:
951: --Bug 3667036: End