DBA Data[Home] [Help]

APPS.AP_WEB_AUDIT_QUEUE_UTILS dependencies on FND_FILE

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

873:
874: l_sqlerrm VARCHAR2(2000);
875: l_subject VARCHAR2(200);
876: BEGIN
877: fnd_file.put_line(fnd_file.log, 'starting AP_WEB_AUDIT_QUEUE_UTILS.reassign_orphaned_reports()');
878:
879: validate_auditors();
880:
881: open_orphaned_reports_cursor(p_expense_report_cur => l_expense_report_cur);

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

887: transfer_report(l_auditor_id, l_next_auditor_id, l_expense_report_id);
888:
889: END LOOP;
890: retcode := 0; -- SUCCESS
891: fnd_file.put_line(fnd_file.log, 'ending AP_WEB_AUDIT_QUEUE_UTILS.reassign_orphaned_reports()');
892:
893: EXCEPTION
894: WHEN OTHERS THEN
895: l_sqlerrm := sqlerrm(sqlcode) || fnd_global.newline ||

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

898: retcode := 2; -- ERROR
899: fnd_message.set_name('SQLAP','OIE_AUD_REASSIGN_ORPH_ERROR');
900: fnd_message.set_token('REQUEST_ID', fnd_global.conc_request_id);
901: l_subject := fnd_message.get;
902: fnd_file.put_line(fnd_file.log, 'AP_WEB_AUDIT_QUEUE_UTILS.reassign_orphaned_reports()EXCEPTION:'||l_sqlerrm);
903:
904: END reassign_orphaned_reports;
905:
906: PROCEDURE validate_auditors IS