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 2006/02/24 07:06:17 sbalaji noship $ */
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 807: AP_WEB_DB_UTIL_PKG.RaiseException('AP_WEB_CUST_AME_PKG.getJobSupervisorApprover',

803: end if;
804:
805: EXCEPTION
806: WHEN OTHERS THEN
807: AP_WEB_DB_UTIL_PKG.RaiseException('AP_WEB_CUST_AME_PKG.getJobSupervisorApprover',
808: l_debug_info);
809: APP_EXCEPTION.RAISE_EXCEPTION;
810: END getJobSupervisorApprover;
811:

Line 812: END AP_WEB_CUST_AME_PKG;

808: l_debug_info);
809: APP_EXCEPTION.RAISE_EXCEPTION;
810: END getJobSupervisorApprover;
811:
812: END AP_WEB_CUST_AME_PKG;