APPS.AP_WEB_CUST_AME_PKG dependencies on AP_WEB_CUST_AME_PKG

Line 1: PACKAGE BODY AP_WEB_CUST_AME_PKG AS

1: PACKAGE BODY AP_WEB_CUST_AME_PKG AS
2: /* $Header: apwamecb.pls 120.7.12020000.2 2012/07/19 14:31:43 dsadipir ship $ */
3:
4: /*----------------------------------------------------------------------------*
5: Function

Line 37: AP_WEB_DB_UTIL_PKG.RaiseException('AP_WEB_CUST_AME_PKG.checkAndGetApprover',

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:

Line 217: l_cost_center_owner_id := AP_WEB_CUST_AME_PKG.getCustomCostCenterOwner(p_report_header_id, l_cost_center);

213:
214: IF (l_cost_center_manager_id IS NOT NULL) THEN
215: RETURN checkAndGetApprover(l_cost_center_manager_id,l_employee_id);
216: ELSE
217: l_cost_center_owner_id := AP_WEB_CUST_AME_PKG.getCustomCostCenterOwner(p_report_header_id, l_cost_center);
218: RETURN checkAndGetApprover(l_cost_center_owner_id,l_employee_id);
219: END IF;
220:
221: -----------------------------------------------------

Line 552: l_cost_center_approver_id := AP_WEB_CUST_AME_PKG.getCustomCostCenterOwner(p_report_header_id, l_cost_center);

548:
549: l_cost_center_approver_id := getCCBusinessManager(p_report_header_id, l_cost_center);
550:
551: IF (l_cost_center_approver_id IS NULL) THEN
552: l_cost_center_approver_id := AP_WEB_CUST_AME_PKG.getCustomCostCenterOwner(p_report_header_id, l_cost_center);
553: END IF;
554:
555: IF (l_default_cost_center = l_cost_center) THEN
556: -----------------------------------------------------

Line 672: AP_WEB_DB_UTIL_PKG.RaiseException('AP_WEB_CUST_AME_PKG.getTransactionRequestor',

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:

Line 688: AP_WEB_DB_UTIL_PKG.RaiseException('AP_WEB_CUST_AME_PKG.getProjectApprover',

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:

Line 704: AP_WEB_DB_UTIL_PKG.RaiseException('AP_WEB_CUST_AME_PKG.getAwardApprover',

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:

Line 723: l_cost_center_owner_id := to_number(AP_WEB_CUST_AME_PKG.getCustomCostCenterOwner(p_report_header_id, p_cost_center));

719:
720: IF (l_cost_center_manager_id IS NOT NULL) THEN
721: RETURN l_cost_center_manager_id;
722: ELSE
723: l_cost_center_owner_id := to_number(AP_WEB_CUST_AME_PKG.getCustomCostCenterOwner(p_report_header_id, p_cost_center));
724: RETURN l_cost_center_owner_id;
725: END IF;
726:
727: EXCEPTION

Line 729: AP_WEB_DB_UTIL_PKG.RaiseException('AP_WEB_CUST_AME_PKG.getDistCostCenterApprover',

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:

Line 818: AP_WEB_DB_UTIL_PKG.RaiseException('AP_WEB_CUST_AME_PKG.getJobSupervisorApprover',

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:

Line 823: END AP_WEB_CUST_AME_PKG;

819: l_debug_info);
820: APP_EXCEPTION.RAISE_EXCEPTION;
821: END getJobSupervisorApprover;
822:
823: END AP_WEB_CUST_AME_PKG;