33: return to_char(l_dir_manager_id);
34: end if;
35: EXCEPTION
36: WHEN OTHERS THEN
37: AP_WEB_DB_UTIL_PKG.RaiseException('AP_WEB_CUST_AME_PKG.checkAndGetApprover',
38: l_debugInfo);
39: APP_EXCEPTION.RAISE_EXCEPTION;
40: END;
41:
668: end if;
669:
670: EXCEPTION
671: WHEN OTHERS THEN
672: AP_WEB_DB_UTIL_PKG.RaiseException('AP_WEB_CUST_AME_PKG.getTransactionRequestor',
673: l_debug_info);
674: APP_EXCEPTION.RAISE_EXCEPTION;
675: END getTransactionRequestor;
676:
684: return AP_WEB_AME_PKG.getProjectManagerID(to_number(p_project_id), trunc(sysdate));
685:
686: EXCEPTION
687: WHEN OTHERS THEN
688: AP_WEB_DB_UTIL_PKG.RaiseException('AP_WEB_CUST_AME_PKG.getProjectApprover',
689: l_debug_info);
690: APP_EXCEPTION.RAISE_EXCEPTION;
691: END getProjectApprover;
692:
700: return AP_WEB_AME_PKG.getAwardManagerID(to_number(p_award_id), trunc(sysdate));
701:
702: EXCEPTION
703: WHEN OTHERS THEN
704: AP_WEB_DB_UTIL_PKG.RaiseException('AP_WEB_CUST_AME_PKG.getAwardApprover',
705: l_debug_info);
706: APP_EXCEPTION.RAISE_EXCEPTION;
707: END getAwardApprover;
708:
725: END IF;
726:
727: EXCEPTION
728: WHEN OTHERS THEN
729: AP_WEB_DB_UTIL_PKG.RaiseException('AP_WEB_CUST_AME_PKG.getDistCostCenterApprover',
730: l_debug_info);
731: APP_EXCEPTION.RAISE_EXCEPTION;
732: END getDistCostCenterApprover;
733:
814: end if;
815:
816: EXCEPTION
817: WHEN OTHERS THEN
818: AP_WEB_DB_UTIL_PKG.RaiseException('AP_WEB_CUST_AME_PKG.getJobSupervisorApprover',
819: l_debug_info);
820: APP_EXCEPTION.RAISE_EXCEPTION;
821: END getJobSupervisorApprover;
822: