39: FND_MESSAGE.SET_TOKEN ('CALLING_FN','CHECK_PAYMENT_SCHEDULE');
40: FND_MSG_PUB.ADD;
41: RETURN (FALSE);
42: WHEN OTHERS THEN
43: FA_SRVR_MSG.ADD_SQL_ERROR('CHECK_PAYMENT_SCHEDULE', p_log_level_rec => p_log_level_rec);
44: RETURN (FALSE);
45: END CHECK_PAYMENT_SCHEDULE;
46:
47: -------------------------------------------
72: FND_MESSAGE.SET_TOKEN ('CALLING_FN','CHECK_CURRENCY_CODE');
73: FND_MSG_PUB.ADD;
74: RETURN (FALSE);
75: WHEN OTHERS THEN
76: FA_SRVR_MSG.ADD_SQL_ERROR('CHECK_CURRENCY_CODE', p_log_level_rec => p_log_level_rec);
77: RETURN (FALSE);
78: END CHECK_CURRENCY_CODE;
79:
80: -------------------------------------------
106: FND_MESSAGE.SET_TOKEN ('CALLING_FN','CHECK_LEASE_FREQUENCY');
107: FND_MSG_PUB.ADD;
108: RETURN (FALSE);
109: WHEN OTHERS THEN
110: FA_SRVR_MSG.ADD_SQL_ERROR('CHECK_LEASE_FREQUENCY', p_log_level_rec => p_log_level_rec);
111: RETURN (FALSE);
112: END CHECK_LEASE_FREQUENCY;
113:
114: -------------------------------------------
165: RETURN(L_RETURN_FLAG);
166:
167: EXCEPTION
168: WHEN OTHERS THEN
169: FA_SRVR_MSG.ADD_SQL_ERROR('CHECK_START_DATE', p_log_level_rec => p_log_level_rec);
170: RETURN (FALSE);
171: END CHECK_START_DATE;
172:
173: -------------------------------------------
194: RETURN(L_RETURN_FLAG);
195:
196: EXCEPTION
197: WHEN OTHERS THEN
198: FA_SRVR_MSG.ADD_SQL_ERROR('CHECK_PAYMENT_AMOUNT', p_log_level_rec => p_log_level_rec);
199: RETURN (FALSE);
200: END CHECK_PAYMENT_AMOUNT;
201:
202: -------------------------------------------
232: RETURN(L_RETURN_FLAG);
233:
234: EXCEPTION
235: WHEN OTHERS THEN
236: FA_SRVR_MSG.ADD_SQL_ERROR('CHECK_NO_OF_PAYMENTS', p_log_level_rec => p_log_level_rec);
237: RETURN (FALSE);
238: END CHECK_NO_OF_PAYMENTS ;
239:
240: -------------------------------------------
277: RETURN(L_RETURN_FLAG);
278:
279: EXCEPTION
280: WHEN OTHERS THEN
281: FA_SRVR_MSG.ADD_SQL_ERROR('CHECK_PERIODS', p_log_level_rec => p_log_level_rec);
282: RETURN (FALSE);
283: END CHECK_PERIODS;
284:
285: -------------------------------------------
302:
303: RETURN L_END_DATE;
304: EXCEPTION
305: WHEN OTHERS THEN
306: FA_SRVR_MSG.ADD_SQL_ERROR('CALC_END_DATE', p_log_level_rec => p_log_level_rec);
307: RETURN (NULL);
308: END CALC_END_DATE;
309:
310: -------------------------------------------
367: FND_MESSAGE.SET_TOKEN ('CALLING_FN','VALIDATE_SCHEDULE_ID');
368: FND_MSG_PUB.ADD;
369: RETURN (FALSE);
370: WHEN OTHERS THEN
371: FA_SRVR_MSG.ADD_SQL_ERROR('VALIDATE_SCHEDULE_ID', p_log_level_rec => p_log_level_rec);
372: RETURN (FALSE);
373: END VALIDATE_SCHEDULE_ID;
374:
375: -------------------------------------------
399: RETURN(INTEREST_AMOUNT);
400:
401: EXCEPTION
402: WHEN OTHERS THEN
403: FA_SRVR_MSG.ADD_SQL_ERROR('CALCULATE_INTEREST', p_log_level_rec => p_log_level_rec);
404: RETURN (NULL);
405: END CALCULATE_INTEREST;
406:
407: -------------------------------------------
427: RETURN (MIN_NUMBER);
428:
429: EXCEPTION
430: WHEN OTHERS THEN
431: FA_SRVR_MSG.ADD_SQL_ERROR('AMINIMUM2', p_log_level_rec => p_log_level_rec);
432: RETURN (NULL);
433: END AMINIMUM2;
434:
435: -------------------------------------------
461: RETURN (MIN_NUMBER);
462:
463: EXCEPTION
464: WHEN OTHERS THEN
465: FA_SRVR_MSG.ADD_SQL_ERROR('AMINIMUM3', p_log_level_rec => p_log_level_rec);
466: RETURN (NULL);
467: END AMINIMUM3;
468:
469: -------------------------------------------
494:
495:
496: EXCEPTION
497: WHEN OTHERS THEN
498: FA_SRVR_MSG.ADD_SQL_ERROR('LUMP_SUM', p_log_level_rec => p_log_level_rec);
499: RETURN (NULL);
500: END LUMP_SUM;
501:
502: -------------------------------------------
534:
535: RETURN(H_ROW_PV);
536: EXCEPTION
537: WHEN OTHERS THEN
538: FA_SRVR_MSG.ADD_SQL_ERROR('ORDINARY_ANNUITY', p_log_level_rec => p_log_level_rec);
539: RETURN (NULL);
540: --
541: END ORDINARY_ANNUITY;
542:
576: H_ROW_PV := ROUND(H_ROW_PV, P_CURRENCY_PRECISION);
577: RETURN(H_ROW_PV);
578: EXCEPTION
579: WHEN OTHERS THEN
580: FA_SRVR_MSG.ADD_SQL_ERROR('ANNUITY_DUE', p_log_level_rec => p_log_level_rec);
581: RETURN (NULL);
582: END ANNUITY_DUE;
583:
584: -------------------------------------------
702: END LOOP;
703:
704: EXCEPTION
705: WHEN OTHERS THEN
706: FA_SRVR_MSG.ADD_SQL_ERROR('PRESENT_VALUE_CALC', p_log_level_rec => p_log_level_rec);
707: END PRESENT_VALUE_CALC;
708:
709: ------------------------------------------------------------
710: -- VALIDATE ALL THE SUPPLIED DATA
886: EXCEPTION
887: WHEN VALUE_ERROR_EXCEPTION THEN
888: RETURN (FALSE);
889: WHEN OTHERS THEN
890: FA_SRVR_MSG.ADD_SQL_ERROR('VALIDATE_PAYMENTS', p_log_level_rec => p_log_level_rec);
891: RETURN (FALSE);
892: END VALIDATE_PAYMENTS;
893:
894: FUNCTION AMORTIZE(
1110: EXCEPTION
1111: WHEN VALUE_ERROR_EXCEPTION THEN
1112: RETURN (FALSE);
1113: WHEN OTHERS THEN
1114: FA_SRVR_MSG.ADD_SQL_ERROR('AMORTIZE', p_log_level_rec => p_log_level_rec);
1115: RETURN (FALSE);
1116: END AMORTIZE;
1117:
1118: END FA_LEASE_SCHEDULE_PVT;