APPS.AP_WEB_AUDIT_QUEUE_UTILS dependencies on FND_GLOBAL

Line 156: FND_GLOBAL.USER_ID,

152: VALUES ( p_report_header_id,
153: p_auditor_id,
154: report_weight(p_report_header_id),
155: sysdate,
156: FND_GLOBAL.USER_ID,
157: null,
158: sysdate,
159: FND_GLOBAL.USER_ID);
160: --------------------------------------------------------------------------

Line 159: FND_GLOBAL.USER_ID);

155: sysdate,
156: FND_GLOBAL.USER_ID,
157: null,
158: sysdate,
159: FND_GLOBAL.USER_ID);
160: --------------------------------------------------------------------------
161: ELSIF (l_auditor_id <> p_auditor_id) THEN
162: -- report in queue but needs to be reassigned to p_auditor_id
163: transfer_report(l_auditor_id, p_auditor_id, p_report_header_id);

Line 724: last_updated_by = FND_GLOBAL.USER_ID

720:
721: UPDATE ap_aud_queues SET auditor_id = p_next_auditor_id,
722: last_update_login = null,
723: last_update_date = sysdate,
724: last_updated_by = FND_GLOBAL.USER_ID
725: WHERE auditor_id = p_auditor_id AND expense_report_id = p_expense_report_id;
726: COMMIT;
727:
728: END IF;

Line 895: l_sqlerrm := sqlerrm(sqlcode) || fnd_global.newline ||

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 ||
896: 'Location: AP_WEB_AUDIT_QUEUE_UTILS.reassign_orphaned_reports()'||fnd_global.newline||
897: 'Time: '||to_char(sysdate, 'DD-MON-RRRR HH:MI:SS');
898: retcode := 2; -- ERROR
899: fnd_message.set_name('SQLAP','OIE_AUD_REASSIGN_ORPH_ERROR');

Line 896: 'Location: AP_WEB_AUDIT_QUEUE_UTILS.reassign_orphaned_reports()'||fnd_global.newline||

892:
893: EXCEPTION
894: WHEN OTHERS THEN
895: l_sqlerrm := sqlerrm(sqlcode) || fnd_global.newline ||
896: 'Location: AP_WEB_AUDIT_QUEUE_UTILS.reassign_orphaned_reports()'||fnd_global.newline||
897: 'Time: '||to_char(sysdate, 'DD-MON-RRRR HH:MI:SS');
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);

Line 900: fnd_message.set_token('REQUEST_ID', fnd_global.conc_request_id);

896: 'Location: AP_WEB_AUDIT_QUEUE_UTILS.reassign_orphaned_reports()'||fnd_global.newline||
897: 'Time: '||to_char(sysdate, 'DD-MON-RRRR HH:MI:SS');
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;