DBA Data[Home] [Help]

APPS.QP_PURGE_ENTITY dependencies on FND_FILE

Line 469: fnd_file.put_line(FND_FILE.LOG,'Purge completed successfully');

465:
466:
467: commit;
468:
469: fnd_file.put_line(FND_FILE.LOG,'Purge completed successfully');
470:
471: --Call INSERT_CRITERIA to insert records into QP_ARCH_CRITERIA_HEADERS and QP_ARCH_CRITERIA_LINES
472:
473: INSERT_CRITERIA(p_archive_name,p_entity_type,p_source_system_code,p_entity,

Line 489: fnd_file.put_line(FND_FILE.LOG,'No Data Found - 0 Records Deleted');

485: INSERT_CRITERIA(p_archive_name,p_entity_type,p_source_system_code,p_entity,
486: p_archive_start_date,p_archive_end_date,
487: l_user_id,l_conc_request_id,'W');
488:
489: fnd_file.put_line(FND_FILE.LOG,'No Data Found - 0 Records Deleted');
490: errbuf := 'No Data Found - 0 Records Deleted';
491: retcode := 1;
492:
493: WHEN OTHERS THEN

Line 501: fnd_file.put_line(FND_FILE.LOG,'Error in Purge Entity Routine ');

497: INSERT_CRITERIA(p_archive_name,p_entity_type,p_source_system_code,p_entity,
498: p_archive_start_date,p_archive_end_date,
499: l_user_id,l_conc_request_id,'F');
500:
501: fnd_file.put_line(FND_FILE.LOG,'Error in Purge Entity Routine ');
502: fnd_file.put_line(FND_FILE.LOG,substr(sqlerrm,1,300));
503: retcode := 2;
504:
505: END Purge_entity;

Line 502: fnd_file.put_line(FND_FILE.LOG,substr(sqlerrm,1,300));

498: p_archive_start_date,p_archive_end_date,
499: l_user_id,l_conc_request_id,'F');
500:
501: fnd_file.put_line(FND_FILE.LOG,'Error in Purge Entity Routine ');
502: fnd_file.put_line(FND_FILE.LOG,substr(sqlerrm,1,300));
503: retcode := 2;
504:
505: END Purge_entity;
506: