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
356: WHEN NO_DATA_FOUND THEN
357: NULL;
358: WHEN OTHERS THEN
359: AP_WEB_DB_UTIL_PKG.RaiseException('DuplicateDistributions');
360: APP_EXCEPTION.RAISE_EXCEPTION;
361: END DuplicateDistributions;
362:
363: --------------------------------------------------------------------------------
364: PROCEDURE updateAccountValues(
397: WHEN NO_DATA_FOUND THEN
398: RETURN;
399: WHEN OTHERS THEN
400: AP_WEB_DB_UTIL_PKG.RaiseException('updateAccountValues');
401: APP_EXCEPTION.RAISE_EXCEPTION;
402: END;
403:
404: end if;
405:
472:
473: EXCEPTION
474: WHEN OTHERS THEN
475: AP_WEB_DB_UTIL_PKG.RaiseException('updateAccountValues');
476: APP_EXCEPTION.RAISE_EXCEPTION;
477: END updateAccountValues;
478:
479: --------------------------------------------------------------------------------
480: PROCEDURE updateAccountValuesForForms(
514: WHEN NO_DATA_FOUND THEN
515: RETURN;
516: WHEN OTHERS THEN
517: AP_WEB_DB_UTIL_PKG.RaiseException('updateAccountValues');
518: APP_EXCEPTION.RAISE_EXCEPTION;
519: END;
520:
521: end if;
522:
590:
591: EXCEPTION
592: WHEN OTHERS THEN
593: AP_WEB_DB_UTIL_PKG.RaiseException('updateAccountValuesForForms');
594: APP_EXCEPTION.RAISE_EXCEPTION;
595: END updateAccountValuesForForms;
596:
597: --------------------------------------------------------------------------------
598: PROCEDURE updateDistAccountValues(
687:
688: EXCEPTION
689: WHEN OTHERS THEN
690: AP_WEB_DB_UTIL_PKG.RaiseException('updateDistAccountValues');
691: APP_EXCEPTION.RAISE_EXCEPTION;
692: END updateDistAccountValues;
693:
694: --------------------------------------------------------------------------------
695: PROCEDURE updateDistAcctValuesForForms(
722: WHEN NO_DATA_FOUND THEN
723: l_dist_id := null;
724: WHEN OTHERS THEN
725: AP_WEB_DB_UTIL_PKG.RaiseException('updateAccountValues');
726: APP_EXCEPTION.RAISE_EXCEPTION;
727: END;
728:
729: updateAccountValuesForForms(p_report_header_id, l_report_line_id, l_dist_id, l_line_ccid, l_line_amount);
730:
860:
861: EXCEPTION
862: WHEN OTHERS THEN
863: AP_WEB_DB_UTIL_PKG.RaiseException('AddDistributionLine');
864: APP_EXCEPTION.RAISE_EXCEPTION;
865: END AddDistributionLine;
866:
867: --------------------------------------------------------------------------------
868: PROCEDURE AddDistributionLine(
1266: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
1267: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', 'AddDistributionLine');
1268: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',l_debug_info);
1269: END IF;
1270: APP_EXCEPTION.RAISE_EXCEPTION;
1271: END AddDistributionLine;
1272: --------------------------------------------------------------------------------
1273:
1274:
1297: return FALSE;
1298:
1299: WHEN OTHERS THEN
1300: AP_WEB_DB_UTIL_PKG.RaiseException( 'ContainsProjectRelatedDist' );
1301: APP_EXCEPTION.RAISE_EXCEPTION;
1302: return FALSE;
1303: END ContainsProjectRelatedDist;
1304:
1305:
1328: return FALSE;
1329: WHEN OTHERS THEN
1330: AP_WEB_DB_UTIL_PKG.RaiseException( 'ContainsNonProjectRelatedDist' );
1331:
1332: APP_EXCEPTION.RAISE_EXCEPTION;
1333: return FALSE;
1334: END ContainsNonProjectRelatedDist;
1335:
1336: