DBA Data[Home] [Help]

APPS.AP_WEB_AUDIT_QUEUE_UTILS dependencies on FND_FILE

Line 894: fnd_file.put_line(fnd_file.log, 'starting AP_WEB_AUDIT_QUEUE_UTILS.reassign_orphaned_reports()');

890:
891: l_sqlerrm VARCHAR2(2000);
892: l_subject VARCHAR2(200);
893: BEGIN
894: fnd_file.put_line(fnd_file.log, 'starting AP_WEB_AUDIT_QUEUE_UTILS.reassign_orphaned_reports()');
895:
896: validate_auditors();
897:
898: open_orphaned_reports_cursor(p_expense_report_cur => l_expense_report_cur);

Line 908: fnd_file.put_line(fnd_file.log, 'ending AP_WEB_AUDIT_QUEUE_UTILS.reassign_orphaned_reports()');

904: transfer_report(l_auditor_id, l_next_auditor_id, l_expense_report_id);
905:
906: END LOOP;
907: retcode := 0; -- SUCCESS
908: fnd_file.put_line(fnd_file.log, 'ending AP_WEB_AUDIT_QUEUE_UTILS.reassign_orphaned_reports()');
909:
910: EXCEPTION
911: WHEN OTHERS THEN
912: l_sqlerrm := sqlerrm(sqlcode) || fnd_global.newline ||

Line 919: fnd_file.put_line(fnd_file.log, 'AP_WEB_AUDIT_QUEUE_UTILS.reassign_orphaned_reports()EXCEPTION:'||l_sqlerrm);

915: retcode := 2; -- ERROR
916: fnd_message.set_name('SQLAP','OIE_AUD_REASSIGN_ORPH_ERROR');
917: fnd_message.set_token('REQUEST_ID', fnd_global.conc_request_id);
918: l_subject := fnd_message.get;
919: fnd_file.put_line(fnd_file.log, 'AP_WEB_AUDIT_QUEUE_UTILS.reassign_orphaned_reports()EXCEPTION:'||l_sqlerrm);
920:
921: END reassign_orphaned_reports;
922:
923: PROCEDURE validate_auditors IS