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.10 2010/08/01 12:48:36 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 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 913: 'Location: AP_WEB_AUDIT_QUEUE_UTILS.reassign_orphaned_reports()'||fnd_global.newline||

909:
910: EXCEPTION
911: WHEN OTHERS THEN
912: l_sqlerrm := sqlerrm(sqlcode) || fnd_global.newline ||
913: 'Location: AP_WEB_AUDIT_QUEUE_UTILS.reassign_orphaned_reports()'||fnd_global.newline||
914: 'Time: '||to_char(sysdate, 'DD-MON-RRRR HH:MI:SS');
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);

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

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

946: WHERE
947: u.user_id = l_auditor_id
948: AND u.user_id = g.user_id
949: AND g.responsibility_id = r.responsibility_id
950: AND AP_WEB_AUDIT_QUEUE_UTILS.IS_FUNCTION_ON_MENU(r.menu_id, f.function_id, 'Y') = 'Y'
951: AND f.function_name = 'OIE_AUD_AUDIT') sp
952: WHERE sp.security_profile_id = l_security_profile_id;
953:
954: IF (l_num = 0) THEN

Line 963: END AP_WEB_AUDIT_QUEUE_UTILS;

959:
960: END validate_auditors;
961:
962:
963: END AP_WEB_AUDIT_QUEUE_UTILS;