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:
57:
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:
81:
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:
106:
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:
132: -----------------------------------------------------------------------------
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:
174: -------------------------------------------------------------------
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:
214: -- For the given line, move its distributions from original ER
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: -------------------------------------------------------------------
233: -- Name: DuplicateDistributions
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: --------------------------------------------------------------------------------
365: PROCEDURE updateAccountValues(
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;
406:
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: --------------------------------------------------------------------------------
483: PROCEDURE updateAccountValuesForForms(
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;
525:
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: --------------------------------------------------------------------------------
603: PROCEDURE updateDistAccountValues(
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: --------------------------------------------------------------------------------
702: PROCEDURE updateDistAcctValuesForForms(
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);
737:
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: --------------------------------------------------------------------------------
877: PROCEDURE AddDistributionLine(
1305: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
1306: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', 'AddDistributionLine');
1307: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',l_debug_info);
1308: END IF;
1309: APP_EXCEPTION.RAISE_EXCEPTION;
1310: END AddDistributionLine;
1311: --------------------------------------------------------------------------------
1312:
1313:
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:
1344:
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;
1374:
1375: PROCEDURE ResplitDistAmounts(p_report_line_id IN NUMBER,
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
1426: ---------------------------------------------------------------------------------------