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
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',
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;
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;
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:
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:
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: