48: EXCEPTION
49: WHEN NO_DATA_FOUND THEN
50: return FALSE;
51: WHEN OTHERS THEN
52: AP_WEB_DB_UTIL_PKG.RaiseException('foundCCID');
53: APP_EXCEPTION.RAISE_EXCEPTION;
54: return FALSE;
55: END foundCCID;
56:
72: EXCEPTION
73: WHEN NO_DATA_FOUND THEN
74: return FALSE;
75: WHEN OTHERS THEN
76: AP_WEB_DB_UTIL_PKG.RaiseException('foundDistributions');
77: APP_EXCEPTION.RAISE_EXCEPTION;
78: return FALSE;
79: END foundDistributions;
80:
97: EXCEPTION
98: WHEN NO_DATA_FOUND THEN
99: return FALSE;
100: WHEN OTHERS THEN
101: AP_WEB_DB_UTIL_PKG.RaiseException('SetDistCCID');
102: APP_EXCEPTION.RAISE_EXCEPTION;
103: return FALSE;
104: END SetDistCCID;
105:
123: EXCEPTION
124: WHEN NO_DATA_FOUND THEN
125: return FALSE;
126: WHEN OTHERS THEN
127: AP_WEB_DB_UTIL_PKG.RaiseException('UpdateDistCCID');
128: APP_EXCEPTION.RAISE_EXCEPTION;
129: return FALSE;
130: END UpdateDistCCID;
131:
165: EXCEPTION
166: WHEN NO_DATA_FOUND THEN
167: NULL;
168: WHEN OTHERS THEN
169: AP_WEB_DB_UTIL_PKG.RaiseException('ReportDistributions');
170: APP_EXCEPTION.RAISE_EXCEPTION;
171: END DeleteReportDistributions;
172:
173:
205: WHEN NO_DATA_FOUND THEN
206: AddDistributionLine( p_report_line_id => p_target_report_line_id);
207: RETURN;
208: WHEN OTHERS THEN
209: AP_WEB_DB_UTIL_PKG.RaiseException('MoveDistributions');
210: APP_EXCEPTION.RAISE_EXCEPTION;
211: END;
212:
213:
224: EXCEPTION
225: WHEN NO_DATA_FOUND THEN
226: NULL;
227: WHEN OTHERS THEN
228: AP_WEB_DB_UTIL_PKG.RaiseException('MoveDistributions');
229: APP_EXCEPTION.RAISE_EXCEPTION;
230: END MoveDistributions;
231:
232: -------------------------------------------------------------------
356: EXCEPTION
357: WHEN NO_DATA_FOUND THEN
358: NULL;
359: WHEN OTHERS THEN
360: AP_WEB_DB_UTIL_PKG.RaiseException('DuplicateDistributions');
361: APP_EXCEPTION.RAISE_EXCEPTION;
362: END DuplicateDistributions;
363:
364: --------------------------------------------------------------------------------
397: EXCEPTION
398: WHEN NO_DATA_FOUND THEN
399: RETURN;
400: WHEN OTHERS THEN
401: AP_WEB_DB_UTIL_PKG.RaiseException('updateAccountValues');
402: APP_EXCEPTION.RAISE_EXCEPTION;
403: END;
404:
405: end if;
474: AND report_header_id = p_report_header_id;
475:
476: EXCEPTION
477: WHEN OTHERS THEN
478: AP_WEB_DB_UTIL_PKG.RaiseException('updateAccountValues');
479: APP_EXCEPTION.RAISE_EXCEPTION;
480: END updateAccountValues;
481:
482: --------------------------------------------------------------------------------
516: EXCEPTION
517: WHEN NO_DATA_FOUND THEN
518: RETURN;
519: WHEN OTHERS THEN
520: AP_WEB_DB_UTIL_PKG.RaiseException('updateAccountValues');
521: APP_EXCEPTION.RAISE_EXCEPTION;
522: END;
523:
524: end if;
594: AND report_header_id = p_report_header_id;
595:
596: EXCEPTION
597: WHEN OTHERS THEN
598: AP_WEB_DB_UTIL_PKG.RaiseException('updateAccountValuesForForms');
599: APP_EXCEPTION.RAISE_EXCEPTION;
600: END updateAccountValuesForForms;
601:
602: --------------------------------------------------------------------------------
693: CLOSE dist_lines_c;
694:
695: EXCEPTION
696: WHEN OTHERS THEN
697: AP_WEB_DB_UTIL_PKG.RaiseException('updateDistAccountValues');
698: APP_EXCEPTION.RAISE_EXCEPTION;
699: END updateDistAccountValues;
700:
701: --------------------------------------------------------------------------------
728: EXCEPTION
729: WHEN NO_DATA_FOUND THEN
730: l_dist_id := null;
731: WHEN OTHERS THEN
732: AP_WEB_DB_UTIL_PKG.RaiseException('updateAccountValues');
733: APP_EXCEPTION.RAISE_EXCEPTION;
734: END;
735:
736: updateAccountValuesForForms(p_report_header_id, l_report_line_id, l_dist_id, l_line_ccid, l_line_amount);
868:
869:
870: EXCEPTION
871: WHEN OTHERS THEN
872: AP_WEB_DB_UTIL_PKG.RaiseException('AddDistributionLine');
873: APP_EXCEPTION.RAISE_EXCEPTION;
874: END AddDistributionLine;
875:
876: --------------------------------------------------------------------------------
1335: WHEN NO_DATA_FOUND THEN
1336: return FALSE;
1337:
1338: WHEN OTHERS THEN
1339: AP_WEB_DB_UTIL_PKG.RaiseException( 'ContainsProjectRelatedDist' );
1340: APP_EXCEPTION.RAISE_EXCEPTION;
1341: return FALSE;
1342: END ContainsProjectRelatedDist;
1343:
1365: return TRUE;
1366: WHEN NO_DATA_FOUND THEN
1367: return FALSE;
1368: WHEN OTHERS THEN
1369: AP_WEB_DB_UTIL_PKG.RaiseException( 'ContainsNonProjectRelatedDist' );
1370:
1371: APP_EXCEPTION.RAISE_EXCEPTION;
1372: return FALSE;
1373: END ContainsNonProjectRelatedDist;
1417: end if;
1418: END IF;
1419: exception
1420: when others then
1421: AP_WEB_DB_UTIL_PKG.RaiseException('ResplitDistAmounts');
1422: APP_EXCEPTION.RAISE_EXCEPTION;
1423: END ResplitDistAmounts;
1424:
1425: -- Bug: 7395568