APPS.AP_WEB_AUDIT_QUEUE_UTILS dependencies on AP_WEB_AUDIT_QUEUE_UTILS

Line 1: PACKAGE BODY AP_WEB_AUDIT_QUEUE_UTILS AS

1: PACKAGE BODY AP_WEB_AUDIT_QUEUE_UTILS AS
2: /* $Header: apwaudqb.pls 120.7.12010000.2 2008/08/06 07:42:41 rveliche ship $ */
3:
4: /*=======================================================================+
5: | Global Constants

Line 8: G_PKG_NAME CONSTANT VARCHAR2(30) := 'AP_WEB_AUDIT_QUEUE_UTILS';

4: /*=======================================================================+
5: | Global Constants
6: +=======================================================================*/
7:
8: G_PKG_NAME CONSTANT VARCHAR2(30) := 'AP_WEB_AUDIT_QUEUE_UTILS';
9:
10: ------------------------------------------------------------------------
11: -- Local Procedure Signature
12: ------------------------------------------------------------------------

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 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 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

Line 933: AND AP_WEB_AUDIT_QUEUE_UTILS.IS_FUNCTION_ON_MENU(r.menu_id, f.function_id, 'Y') = 'Y'

929: WHERE
930: u.user_id = l_auditor_id
931: AND u.user_id = g.user_id
932: AND g.responsibility_id = r.responsibility_id
933: AND AP_WEB_AUDIT_QUEUE_UTILS.IS_FUNCTION_ON_MENU(r.menu_id, f.function_id, 'Y') = 'Y'
934: AND f.function_name = 'OIE_AUD_AUDIT') sp
935: WHERE sp.security_profile_id = l_security_profile_id;
936:
937: IF (l_num = 0) THEN

Line 946: END AP_WEB_AUDIT_QUEUE_UTILS;

942:
943: END validate_auditors;
944:
945:
946: END AP_WEB_AUDIT_QUEUE_UTILS;