14:
15: EXCEPTION
16: WHEN OTHERS THEN
17: AP_WEB_DB_UTIL_PKG.RaiseException('deleteViolationEntry');
18: APP_EXCEPTION.RAISE_EXCEPTION;
19: END deleteViolationEntry;
20:
21: -------------------------------------------------------------------------------
22: FUNCTION updateViolationsHeaderId(
40: WHEN NO_DATA_FOUND THEN
41: return FALSE;
42: WHEN OTHERS THEN
43: AP_WEB_DB_UTIL_PKG.RaiseException('updateViolationsHeaderId');
44: APP_EXCEPTION.RAISE_EXCEPTION;
45: return FALSE;
46: END updateViolationsHeaderId;
47:
48: --------------------------------------------------------------------------------
78: WHEN NO_DATA_FOUND THEN
79: NULL;
80: WHEN OTHERS THEN
81: AP_WEB_DB_UTIL_PKG.RaiseException('SetVioPolicyShortpaidReportID');
82: APP_EXCEPTION.RAISE_EXCEPTION;
83: END SetVioPolicyShortpaidReportID;
84: --------------------------------------------------------------------------------
85: PROCEDURE SetVioReceiptShortpaidReportID(
86: p_orig_expense_report_id IN AP_EXPENSE_REPORT_HEADERS.report_header_id%TYPE,
118: WHEN NO_DATA_FOUND THEN
119: NULL;
120: WHEN OTHERS THEN
121: AP_WEB_DB_UTIL_PKG.RaiseException('SetVioReceiptShortpaidReportID');
122: APP_EXCEPTION.RAISE_EXCEPTION;
123: END SetVioReceiptShortpaidReportID;
124: --------------------------------------------------------------------------------
125:
126: PROCEDURE SetViolationBothpaidReportID(
144: WHEN NO_DATA_FOUND THEN
145: NULL;
146: WHEN OTHERS THEN
147: AP_WEB_DB_UTIL_PKG.RaiseException('SetViolationBothpaidReportID');
148: APP_EXCEPTION.RAISE_EXCEPTION;
149: END SetViolationBothpaidReportID;
150: --------------------------------------------------------------------------------
151:
152: END AP_WEB_DB_VIOLATIONS_PKG;