DBA Data[Home] [Help]

APPS.AP_WEB_MANAGEMENT_REPORTS_PKG dependencies on AP_WEB_DB_UTIL_PKG

Line 25: AP_WEB_DB_UTIL_PKG.RaiseException ('AP_WEB_MANAGEMENT_REPORTS_PKG.GetBaseCurrencyInfo',

21: FROM ap_system_parameters;
22:
23: EXCEPTION
24: WHEN TOO_MANY_ROWS THEN
25: AP_WEB_DB_UTIL_PKG.RaiseException ('AP_WEB_MANAGEMENT_REPORTS_PKG.GetBaseCurrencyInfo',
26: SQLERRM);
27:
28: APP_EXCEPTION.RAISE_EXCEPTION;
29: WHEN NO_DATA_FOUND THEN

Line 30: AP_WEB_DB_UTIL_PKG.RaiseException ('AP_WEB_MANAGEMENT_REPORTS_PKG.GetBaseCurrencyInfo',

26: SQLERRM);
27:
28: APP_EXCEPTION.RAISE_EXCEPTION;
29: WHEN NO_DATA_FOUND THEN
30: AP_WEB_DB_UTIL_PKG.RaiseException ('AP_WEB_MANAGEMENT_REPORTS_PKG.GetBaseCurrencyInfo',
31: SQLERRM);
32: APP_EXCEPTION.RAISE_EXCEPTION;
33: WHEN OTHERS THEN
34: AP_WEB_DB_UTIL_PKG.RaiseException ('AP_WEB_MANAGEMENT_REPORTS_PKG.GetBaseCurrencyInfo',

Line 34: AP_WEB_DB_UTIL_PKG.RaiseException ('AP_WEB_MANAGEMENT_REPORTS_PKG.GetBaseCurrencyInfo',

30: AP_WEB_DB_UTIL_PKG.RaiseException ('AP_WEB_MANAGEMENT_REPORTS_PKG.GetBaseCurrencyInfo',
31: SQLERRM);
32: APP_EXCEPTION.RAISE_EXCEPTION;
33: WHEN OTHERS THEN
34: AP_WEB_DB_UTIL_PKG.RaiseException ('AP_WEB_MANAGEMENT_REPORTS_PKG.GetBaseCurrencyInfo',
35: SQLERRM);
36: APP_EXCEPTION.RAISE_EXCEPTION;
37:
38: END GetBaseCurrencyInfo;

Line 81: AP_WEB_DB_UTIL_PKG.RaiseException ('OIE_MANAGEMENT_REPORTS_PKG',

77: P_EndDate := rec.end_date;
78: END LOOP;
79:
80: IF ( P_StartDate IS NULL OR P_EndDate IS NULL ) THEN
81: AP_WEB_DB_UTIL_PKG.RaiseException ('OIE_MANAGEMENT_REPORTS_PKG',
82: 'Date Range not defined.',
83: 'OIE_REPORTING_INVALID_DATE');
84: APP_EXCEPTION.RAISE_EXCEPTION;
85: END IF;

Line 842: AP_WEB_DB_UTIL_PKG.RaiseException ('AP_WEB_MANAGEMENT_REPORTING_PKG.ManagerHierarchySearch',

838: COMMIT;
839:
840: EXCEPTION
841: WHEN OTHERS THEN
842: AP_WEB_DB_UTIL_PKG.RaiseException ('AP_WEB_MANAGEMENT_REPORTING_PKG.ManagerHierarchySearch',
843: SQLERRM);
844: APP_EXCEPTION.RAISE_EXCEPTION;
845: -- dbms_output.put_line('EXCEPTION: '||SQLERRM) ;
846:

Line 1415: AP_WEB_DB_UTIL_PKG.RaiseException ('AP_WEB_MANAGEMENT_REPORTING_PKG.ExpenseCategorySearch',

1411: COMMIT;
1412:
1413: EXCEPTION
1414: WHEN OTHERS THEN
1415: AP_WEB_DB_UTIL_PKG.RaiseException ('AP_WEB_MANAGEMENT_REPORTING_PKG.ExpenseCategorySearch',
1416: SQLERRM);
1417: APP_EXCEPTION.RAISE_EXCEPTION;
1418: -- dbms_output.put_line('EXCEPTION: '||SQLERRM) ;
1419:

Line 1913: AP_WEB_DB_UTIL_PKG.RaiseException ('AP_WEB_MANAGEMENT_REPORTING_PKG.ViolationTypeSearch',

1909: COMMIT;
1910:
1911: EXCEPTION
1912: WHEN OTHERS THEN
1913: AP_WEB_DB_UTIL_PKG.RaiseException ('AP_WEB_MANAGEMENT_REPORTING_PKG.ViolationTypeSearch',
1914: SQLERRM);
1915: APP_EXCEPTION.RAISE_EXCEPTION;
1916: -- dbms_output.put_line('EXCEPTION: '||SQLERRM) ;
1917: