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: PROCEDURE deleteDupViolationEntry(
166:
167: EXCEPTION
168: WHEN OTHERS THEN
169: AP_WEB_DB_UTIL_PKG.RaiseException('deleteDupViolationEntry');
170: APP_EXCEPTION.RAISE_EXCEPTION;
171:
172: END deleteDupViolationEntry;
173: --------------------------------------------------------------------------------
174: