DBA Data[Home] [Help]

APPS.CE_INTEREST_CALC dependencies on CE_INTEREST_CALC

Line 1: package body CE_INTEREST_CALC as

1: package body CE_INTEREST_CALC as
2: /* $Header: ceintcab.pls 120.14 2008/04/29 10:06:54 srsampat ship $ */
3:
4: l_DEBUG varchar2(1) := NVL(FND_PROFILE.value('CE_DEBUG'), 'N');
5: -- l_DEBUG varchar2(1) := 'Y';

Line 711: cep_standard.debug('>> CE_INTEREST_CALC.get_interest_rate');

707: p_interest_rate IN OUT NOCOPY NUMBER ) RETURN NUMBER IS
708:
709: BEGIN
710: IF l_DEBUG in ('Y', 'C') THEN
711: cep_standard.debug('>> CE_INTEREST_CALC.get_interest_rate');
712: END IF;
713:
714: BEGIN
715: IF (p_balance_amount > 0) THEN

Line 768: cep_standard.debug('CE_INTEREST_CALC.get_interest_rate p_interest_rate '||p_interest_rate);

764: p_interest_rate := NULL;
765:
766: END;
767: IF l_DEBUG in ('Y', 'C') THEN
768: cep_standard.debug('CE_INTEREST_CALC.get_interest_rate p_interest_rate '||p_interest_rate);
769: END IF;
770:
771: RETURN p_interest_rate;
772:

Line 774: cep_standard.debug('<< CE_INTEREST_CALC.get_interest_rate ');

770:
771: RETURN p_interest_rate;
772:
773: IF l_DEBUG in ('Y', 'C') THEN
774: cep_standard.debug('<< CE_INTEREST_CALC.get_interest_rate ');
775: END IF;
776:
777: EXCEPTION
778: WHEN OTHERS THEN

Line 818: cep_standard.debug('>> CE_INTEREST_CALC.delete_schedule_account');

814: y_days NUMBER;
815: y_rownum NUMBER;
816: BEGIN
817: IF l_DEBUG in ('Y', 'C') THEN
818: cep_standard.debug('>> CE_INTEREST_CALC.delete_schedule_account');
819: END IF;
820:
821: -- bug 5493399
822: --IF (p_interest_acct_type = 'BANK_ACCOUNT') THEN

Line 844: cep_standard.debug('<< CE_INTEREST_CALC.delete_schedule_account');

840: END IF;
841:
842:
843: IF l_DEBUG in ('Y', 'C') THEN
844: cep_standard.debug('<< CE_INTEREST_CALC.delete_schedule_account');
845: END IF;
846:
847: EXCEPTION
848: when others then

Line 850: cep_standard.debug('EXCEPTION: CE_INTEREST_CALC.delete_schedule_account');

846:
847: EXCEPTION
848: when others then
849: IF l_DEBUG in ('Y', 'C') THEN
850: cep_standard.debug('EXCEPTION: CE_INTEREST_CALC.delete_schedule_account');
851: END IF;
852: FND_MESSAGE.Set_Name('CE', 'CE_UNHANDLED_EXCEPTION');
853: FND_MESSAGE.Set_Token('PROCEDURE', 'CE_INTEREST_CALC.delete_schedule_account');
854: fnd_msg_pub.add;

Line 853: FND_MESSAGE.Set_Token('PROCEDURE', 'CE_INTEREST_CALC.delete_schedule_account');

849: IF l_DEBUG in ('Y', 'C') THEN
850: cep_standard.debug('EXCEPTION: CE_INTEREST_CALC.delete_schedule_account');
851: END IF;
852: FND_MESSAGE.Set_Name('CE', 'CE_UNHANDLED_EXCEPTION');
853: FND_MESSAGE.Set_Token('PROCEDURE', 'CE_INTEREST_CALC.delete_schedule_account');
854: fnd_msg_pub.add;
855: END delete_schedule_account;
856:
857: /* --------------------------------------------------------------------

Line 900: cep_standard.debug('>> CE_INTEREST_CALC.get_balance_info');

896:
897:
898: BEGIN
899: IF l_DEBUG in ('Y', 'C') THEN
900: cep_standard.debug('>> CE_INTEREST_CALC.get_balance_info');
901: END IF;
902:
903: OPEN balance_info (p_from_date, p_to_date,p_bank_account_id, p_interest_schedule_id );
904: LOOP

Line 968: cep_standard.debug('<< CE_INTEREST_CALC.get_balance_info');

964: CLOSE balance_info;
965:
966:
967: IF l_DEBUG in ('Y', 'C') THEN
968: cep_standard.debug('<< CE_INTEREST_CALC.get_balance_info');
969: END IF;
970:
971: EXCEPTION
972: when others then

Line 974: cep_standard.debug('EXCEPTION: CE_INTEREST_CALC.get_balance_info');

970:
971: EXCEPTION
972: when others then
973: IF l_DEBUG in ('Y', 'C') THEN
974: cep_standard.debug('EXCEPTION: CE_INTEREST_CALC.get_balance_info');
975: END IF;
976: FND_MESSAGE.Set_Name('CE', 'CE_UNHANDLED_EXCEPTION');
977: FND_MESSAGE.Set_Token('PROCEDURE', 'CE_INTEREST_CALC.get_balance_info');
978: fnd_msg_pub.add;

Line 977: FND_MESSAGE.Set_Token('PROCEDURE', 'CE_INTEREST_CALC.get_balance_info');

973: IF l_DEBUG in ('Y', 'C') THEN
974: cep_standard.debug('EXCEPTION: CE_INTEREST_CALC.get_balance_info');
975: END IF;
976: FND_MESSAGE.Set_Name('CE', 'CE_UNHANDLED_EXCEPTION');
977: FND_MESSAGE.Set_Token('PROCEDURE', 'CE_INTEREST_CALC.get_balance_info');
978: fnd_msg_pub.add;
979: END get_balance_info;
980: /* --------------------------------------------------------------------
981: | PRIVATE PROCEDURE |

Line 1023: cep_standard.debug('>> CE_INTEREST_CALC.get_balance_pool_info');

1019:
1020:
1021: BEGIN
1022: IF l_DEBUG in ('Y', 'C') THEN
1023: cep_standard.debug('>> CE_INTEREST_CALC.get_balance_pool_info');
1024: END IF;
1025:
1026: OPEN balance_pool_info (p_from_date, p_to_date,p_bank_account_id, p_interest_schedule_id,
1027: p_interest_acct_type, p_cashpool_id );

Line 1092: cep_standard.debug('<< CE_INTEREST_CALC.get_balance_pool_info');

1088: CLOSE balance_pool_info;
1089:
1090:
1091: IF l_DEBUG in ('Y', 'C') THEN
1092: cep_standard.debug('<< CE_INTEREST_CALC.get_balance_pool_info');
1093: END IF;
1094:
1095: EXCEPTION
1096: when others then

Line 1098: cep_standard.debug('EXCEPTION: CE_INTEREST_CALC.get_balance_pool_info');

1094:
1095: EXCEPTION
1096: when others then
1097: IF l_DEBUG in ('Y', 'C') THEN
1098: cep_standard.debug('EXCEPTION: CE_INTEREST_CALC.get_balance_pool_info');
1099: END IF;
1100: FND_MESSAGE.Set_Name('CE', 'CE_UNHANDLED_EXCEPTION');
1101: FND_MESSAGE.Set_Token('PROCEDURE', 'CE_INTEREST_CALC.get_balance_pool_info');
1102: fnd_msg_pub.add;

Line 1101: FND_MESSAGE.Set_Token('PROCEDURE', 'CE_INTEREST_CALC.get_balance_pool_info');

1097: IF l_DEBUG in ('Y', 'C') THEN
1098: cep_standard.debug('EXCEPTION: CE_INTEREST_CALC.get_balance_pool_info');
1099: END IF;
1100: FND_MESSAGE.Set_Name('CE', 'CE_UNHANDLED_EXCEPTION');
1101: FND_MESSAGE.Set_Token('PROCEDURE', 'CE_INTEREST_CALC.get_balance_pool_info');
1102: fnd_msg_pub.add;
1103: END get_balance_pool_info;
1104:
1105: /* --------------------------------------------------------------------

Line 1152: cep_standard.debug('>> CE_INTEREST_CALC.get_interest_info');

1148: y_interest_rate NUMBER;
1149:
1150: BEGIN
1151: IF l_DEBUG in ('Y', 'C') THEN
1152: cep_standard.debug('>> CE_INTEREST_CALC.get_interest_info');
1153: END IF;
1154:
1155: OPEN interest_info (p_from_date, p_to_date, p_bank_account_id, p_interest_schedule_id, p_interest_acct_type );
1156: LOOP

Line 1216: cep_standard.debug('<< CE_INTEREST_CALC.get_interest_info');

1212: CLOSE interest_info;
1213:
1214:
1215: IF l_DEBUG in ('Y', 'C') THEN
1216: cep_standard.debug('<< CE_INTEREST_CALC.get_interest_info');
1217: END IF;
1218:
1219: EXCEPTION
1220: when others then

Line 1222: cep_standard.debug('EXCEPTION: CE_INTEREST_CALC.get_interest_info');

1218:
1219: EXCEPTION
1220: when others then
1221: IF l_DEBUG in ('Y', 'C') THEN
1222: cep_standard.debug('EXCEPTION: CE_INTEREST_CALC.get_interest_info');
1223: END IF;
1224: FND_MESSAGE.Set_Name('CE', 'CE_UNHANDLED_EXCEPTION');
1225: FND_MESSAGE.Set_Token('PROCEDURE', 'CE_INTEREST_CALC.get_interest_info');
1226: fnd_msg_pub.add;

Line 1225: FND_MESSAGE.Set_Token('PROCEDURE', 'CE_INTEREST_CALC.get_interest_info');

1221: IF l_DEBUG in ('Y', 'C') THEN
1222: cep_standard.debug('EXCEPTION: CE_INTEREST_CALC.get_interest_info');
1223: END IF;
1224: FND_MESSAGE.Set_Name('CE', 'CE_UNHANDLED_EXCEPTION');
1225: FND_MESSAGE.Set_Token('PROCEDURE', 'CE_INTEREST_CALC.get_interest_info');
1226: fnd_msg_pub.add;
1227:
1228: END get_interest_info;
1229:

Line 1277: cep_standard.debug('>> CE_INTEREST_CALC.get_interest_pool_info');

1273: y_interest_rate NUMBER;
1274:
1275: BEGIN
1276: IF l_DEBUG in ('Y', 'C') THEN
1277: cep_standard.debug('>> CE_INTEREST_CALC.get_interest_pool_info');
1278: END IF;
1279:
1280: OPEN interest_pool_info (p_from_date, p_to_date, p_bank_account_id, p_interest_schedule_id,
1281: p_interest_acct_type, p_cashpool_id );

Line 1342: cep_standard.debug('<< CE_INTEREST_CALC.get_interest_pool_info');

1338: CLOSE interest_pool_info;
1339:
1340:
1341: IF l_DEBUG in ('Y', 'C') THEN
1342: cep_standard.debug('<< CE_INTEREST_CALC.get_interest_pool_info');
1343: END IF;
1344:
1345: EXCEPTION
1346: when others then

Line 1348: cep_standard.debug('EXCEPTION: CE_INTEREST_CALC.get_interest_pool_info');

1344:
1345: EXCEPTION
1346: when others then
1347: IF l_DEBUG in ('Y', 'C') THEN
1348: cep_standard.debug('EXCEPTION: CE_INTEREST_CALC.get_interest_pool_info');
1349: END IF;
1350: FND_MESSAGE.Set_Name('CE', 'CE_UNHANDLED_EXCEPTION');
1351: FND_MESSAGE.Set_Token('PROCEDURE', 'CE_INTEREST_CALC.get_interest_pool_info');
1352: fnd_msg_pub.add;

Line 1351: FND_MESSAGE.Set_Token('PROCEDURE', 'CE_INTEREST_CALC.get_interest_pool_info');

1347: IF l_DEBUG in ('Y', 'C') THEN
1348: cep_standard.debug('EXCEPTION: CE_INTEREST_CALC.get_interest_pool_info');
1349: END IF;
1350: FND_MESSAGE.Set_Name('CE', 'CE_UNHANDLED_EXCEPTION');
1351: FND_MESSAGE.Set_Token('PROCEDURE', 'CE_INTEREST_CALC.get_interest_pool_info');
1352: fnd_msg_pub.add;
1353:
1354: END get_interest_pool_info;
1355:

Line 1388: cep_standard.debug('>> CE_INTEREST_CALC.get_interest_info');

1384: y_interest_calc_detail_id number;
1385:
1386: BEGIN
1387: IF l_DEBUG in ('Y', 'C') THEN
1388: cep_standard.debug('>> CE_INTEREST_CALC.get_interest_info');
1389: END IF;
1390:
1391: OPEN missing_interest_info (p_from_date, p_to_date,p_bank_account_id, p_interest_schedule_id );
1392: LOOP

Line 1430: cep_standard.debug('<< CE_INTEREST_CALC.get_missing_interest_info');

1426: CLOSE missing_interest_info;
1427:
1428:
1429: IF l_DEBUG in ('Y', 'C') THEN
1430: cep_standard.debug('<< CE_INTEREST_CALC.get_missing_interest_info');
1431: END IF;
1432:
1433: EXCEPTION
1434: when others then

Line 1436: cep_standard.debug('EXCEPTION: CE_INTEREST_CALC.get_missing_interest_info');

1432:
1433: EXCEPTION
1434: when others then
1435: IF l_DEBUG in ('Y', 'C') THEN
1436: cep_standard.debug('EXCEPTION: CE_INTEREST_CALC.get_missing_interest_info');
1437: END IF;
1438: FND_MESSAGE.Set_Name('CE', 'CE_UNHANDLED_EXCEPTION');
1439: FND_MESSAGE.Set_Token('PROCEDURE', 'CE_INTEREST_CALC.get_missing_interest_info');
1440: fnd_msg_pub.add;

Line 1439: FND_MESSAGE.Set_Token('PROCEDURE', 'CE_INTEREST_CALC.get_missing_interest_info');

1435: IF l_DEBUG in ('Y', 'C') THEN
1436: cep_standard.debug('EXCEPTION: CE_INTEREST_CALC.get_missing_interest_info');
1437: END IF;
1438: FND_MESSAGE.Set_Name('CE', 'CE_UNHANDLED_EXCEPTION');
1439: FND_MESSAGE.Set_Token('PROCEDURE', 'CE_INTEREST_CALC.get_missing_interest_info');
1440: fnd_msg_pub.add;
1441:
1442: END get_missing_interest_info;
1443:

Line 1485: cep_standard.debug('>> CE_INTEREST_CALC.range_and_rate_cur');

1481: i number := 0;
1482:
1483: BEGIN
1484: IF l_DEBUG in ('Y', 'C') THEN
1485: cep_standard.debug('>> CE_INTEREST_CALC.range_and_rate_cur');
1486: END IF;
1487:
1488: OPEN range_and_rate_cur (p_from_date, p_to_date,p_bank_account_id, p_interest_schedule_id, p_interest_acct_type,p_cashpool_id );
1489: LOOP

Line 1521: cep_standard.debug('<< CE_INTEREST_CALC.set_range_and_rate');

1517: CLOSE range_and_rate_cur;
1518:
1519:
1520: IF l_DEBUG in ('Y', 'C') THEN
1521: cep_standard.debug('<< CE_INTEREST_CALC.set_range_and_rate');
1522: END IF;
1523:
1524: EXCEPTION
1525: when others then

Line 1527: cep_standard.debug('EXCEPTION: CE_INTEREST_CALC.set_range_and_rate');

1523:
1524: EXCEPTION
1525: when others then
1526: IF l_DEBUG in ('Y', 'C') THEN
1527: cep_standard.debug('EXCEPTION: CE_INTEREST_CALC.set_range_and_rate');
1528: END IF;
1529: FND_MESSAGE.Set_Name('CE', 'CE_UNHANDLED_EXCEPTION');
1530: FND_MESSAGE.Set_Token('PROCEDURE', 'CE_INTEREST_CALC.set_range_and_rate');
1531: fnd_msg_pub.add;

Line 1530: FND_MESSAGE.Set_Token('PROCEDURE', 'CE_INTEREST_CALC.set_range_and_rate');

1526: IF l_DEBUG in ('Y', 'C') THEN
1527: cep_standard.debug('EXCEPTION: CE_INTEREST_CALC.set_range_and_rate');
1528: END IF;
1529: FND_MESSAGE.Set_Name('CE', 'CE_UNHANDLED_EXCEPTION');
1530: FND_MESSAGE.Set_Token('PROCEDURE', 'CE_INTEREST_CALC.set_range_and_rate');
1531: fnd_msg_pub.add;
1532:
1533: END set_range_and_rate;
1534:

Line 1572: cep_standard.debug('>> CE_INTEREST_CALC.set_end_date');

1568: p_row_count NUMBER;
1569:
1570: BEGIN
1571: IF l_DEBUG in ('Y', 'C') THEN
1572: cep_standard.debug('>> CE_INTEREST_CALC.set_end_date');
1573: END IF;
1574:
1575: OPEN end_date_cur (p_from_date, p_to_date,p_bank_account_id, p_interest_schedule_id,
1576: p_interest_acct_type, p_cashpool_id );

Line 1629: cep_standard.debug('<< CE_INTEREST_CALC.set_end_date');

1625: CLOSE end_date_cur;
1626:
1627:
1628: IF l_DEBUG in ('Y', 'C') THEN
1629: cep_standard.debug('<< CE_INTEREST_CALC.set_end_date');
1630: END IF;
1631:
1632: EXCEPTION
1633: when others then

Line 1635: cep_standard.debug('EXCEPTION: CE_INTEREST_CALC.set_end_date');

1631:
1632: EXCEPTION
1633: when others then
1634: IF l_DEBUG in ('Y', 'C') THEN
1635: cep_standard.debug('EXCEPTION: CE_INTEREST_CALC.set_end_date');
1636: END IF;
1637: FND_MESSAGE.Set_Name('CE', 'CE_UNHANDLED_EXCEPTION');
1638: FND_MESSAGE.Set_Token('PROCEDURE', 'CE_INTEREST_CALC.set_end_date');
1639: fnd_msg_pub.add;

Line 1638: FND_MESSAGE.Set_Token('PROCEDURE', 'CE_INTEREST_CALC.set_end_date');

1634: IF l_DEBUG in ('Y', 'C') THEN
1635: cep_standard.debug('EXCEPTION: CE_INTEREST_CALC.set_end_date');
1636: END IF;
1637: FND_MESSAGE.Set_Name('CE', 'CE_UNHANDLED_EXCEPTION');
1638: FND_MESSAGE.Set_Token('PROCEDURE', 'CE_INTEREST_CALC.set_end_date');
1639: fnd_msg_pub.add;
1640:
1641: END set_end_date;
1642:

Line 1680: cep_standard.debug('>> CE_INTEREST_CALC.set_int_rate');

1676: i number := 0;
1677:
1678: BEGIN
1679: IF l_DEBUG in ('Y', 'C') THEN
1680: cep_standard.debug('>> CE_INTEREST_CALC.set_int_rate');
1681: END IF;
1682:
1683: OPEN xtr_cur (p_from_date, p_to_date,p_bank_account_id, p_interest_schedule_id,
1684: p_interest_acct_type);

Line 1711: cep_standard.debug('<< CE_INTEREST_CALC.set_int_rate');

1707: CLOSE xtr_cur;
1708:
1709:
1710: IF l_DEBUG in ('Y', 'C') THEN
1711: cep_standard.debug('<< CE_INTEREST_CALC.set_int_rate');
1712: END IF;
1713:
1714: EXCEPTION
1715: when others then

Line 1717: cep_standard.debug('EXCEPTION: CE_INTEREST_CALC.set_int_rate');

1713:
1714: EXCEPTION
1715: when others then
1716: IF l_DEBUG in ('Y', 'C') THEN
1717: cep_standard.debug('EXCEPTION: CE_INTEREST_CALC.set_int_rate');
1718: END IF;
1719: FND_MESSAGE.Set_Name('CE', 'CE_UNHANDLED_EXCEPTION');
1720: FND_MESSAGE.Set_Token('PROCEDURE', 'CE_INTEREST_CALC.set_int_rate');
1721: fnd_msg_pub.add;

Line 1720: FND_MESSAGE.Set_Token('PROCEDURE', 'CE_INTEREST_CALC.set_int_rate');

1716: IF l_DEBUG in ('Y', 'C') THEN
1717: cep_standard.debug('EXCEPTION: CE_INTEREST_CALC.set_int_rate');
1718: END IF;
1719: FND_MESSAGE.Set_Name('CE', 'CE_UNHANDLED_EXCEPTION');
1720: FND_MESSAGE.Set_Token('PROCEDURE', 'CE_INTEREST_CALC.set_int_rate');
1721: fnd_msg_pub.add;
1722:
1723: END set_int_rate;
1724:

Line 1799: cep_standard.debug('>> CE_INTEREST_CALC.calculate_interest');

1795: min_acct_unit NUMBER default NULL;
1796:
1797: BEGIN
1798: IF l_DEBUG in ('Y', 'C') THEN
1799: cep_standard.debug('>> CE_INTEREST_CALC.calculate_interest');
1800: cep_standard.debug('p_from_date='||p_from_date||', p_to_date='||p_to_date);
1801: END IF;
1802:
1803: select DAY_COUNT_BASIS,

Line 2187: cep_standard.debug('<< CE_INTEREST_CALC.calculate_interest');

2183: END LOOP; --calc_detail_cur
2184: CLOSE calc_detail_cur;
2185:
2186: IF l_DEBUG in ('Y', 'C') THEN
2187: cep_standard.debug('<< CE_INTEREST_CALC.calculate_interest');
2188: END IF;
2189:
2190: EXCEPTION
2191: when others then

Line 2193: cep_standard.debug('EXCEPTION: CE_INTEREST_CALC.calculate_interest');

2189:
2190: EXCEPTION
2191: when others then
2192: IF l_DEBUG in ('Y', 'C') THEN
2193: cep_standard.debug('EXCEPTION: CE_INTEREST_CALC.calculate_interest');
2194: END IF;
2195: FND_MESSAGE.Set_Name('CE', 'CE_UNHANDLED_EXCEPTION');
2196: FND_MESSAGE.Set_Token('PROCEDURE', 'CE_INTEREST_CALC.calculate_interest');
2197: fnd_msg_pub.add;

Line 2196: FND_MESSAGE.Set_Token('PROCEDURE', 'CE_INTEREST_CALC.calculate_interest');

2192: IF l_DEBUG in ('Y', 'C') THEN
2193: cep_standard.debug('EXCEPTION: CE_INTEREST_CALC.calculate_interest');
2194: END IF;
2195: FND_MESSAGE.Set_Name('CE', 'CE_UNHANDLED_EXCEPTION');
2196: FND_MESSAGE.Set_Token('PROCEDURE', 'CE_INTEREST_CALC.calculate_interest');
2197: fnd_msg_pub.add;
2198:
2199: END calculate_interest;
2200:

Line 2244: cep_standard.debug('>> CE_INTEREST_CALC.int_cal_xtr');

2240: min_acct_unit NUMBER default NULL;
2241:
2242: BEGIN
2243: IF l_DEBUG in ('Y', 'C') THEN
2244: cep_standard.debug('>> CE_INTEREST_CALC.int_cal_xtr');
2245: cep_standard.debug('p_from_date ='||p_from_date || ', p_to_date ='||p_to_date );
2246: cep_standard.debug(' p_bank_account_id ='||p_bank_account_id ||
2247: ', p_interest_acct_type ='||p_interest_acct_type ||
2248: ', p_interest_rate ='||p_interest_rate );

Line 2334: cep_standard.debug('<< CE_INTEREST_CALC.int_cal_xtr');

2330: END IF;
2331:
2332: END IF;
2333: IF l_DEBUG in ('Y', 'C') THEN
2334: cep_standard.debug('<< CE_INTEREST_CALC.int_cal_xtr');
2335: END IF;
2336:
2337: EXCEPTION
2338: when others then

Line 2340: cep_standard.debug('EXCEPTION: CE_INTEREST_CALC.int_cal_xtr');

2336:
2337: EXCEPTION
2338: when others then
2339: IF l_DEBUG in ('Y', 'C') THEN
2340: cep_standard.debug('EXCEPTION: CE_INTEREST_CALC.int_cal_xtr');
2341: END IF;
2342: FND_MESSAGE.Set_Name('CE', 'CE_UNHANDLED_EXCEPTION');
2343: FND_MESSAGE.Set_Token('PROCEDURE', 'CE_INTEREST_CALC.int_cal_xtr');
2344: fnd_msg_pub.add;

Line 2343: FND_MESSAGE.Set_Token('PROCEDURE', 'CE_INTEREST_CALC.int_cal_xtr');

2339: IF l_DEBUG in ('Y', 'C') THEN
2340: cep_standard.debug('EXCEPTION: CE_INTEREST_CALC.int_cal_xtr');
2341: END IF;
2342: FND_MESSAGE.Set_Name('CE', 'CE_UNHANDLED_EXCEPTION');
2343: FND_MESSAGE.Set_Token('PROCEDURE', 'CE_INTEREST_CALC.int_cal_xtr');
2344: fnd_msg_pub.add;
2345:
2346: END int_cal_xtr;
2347:

Line 2393: cep_standard.debug('>> CE_INTEREST_CALC.int_cal_detail_main');

2389: min_acct_unit NUMBER default NULL;
2390:
2391: BEGIN
2392: IF l_DEBUG in ('Y', 'C') THEN
2393: cep_standard.debug('>> CE_INTEREST_CALC.int_cal_detail_main');
2394: cep_standard.debug('p_from_date = '||p_from_date||', p_to_date = '||p_to_date);
2395: cep_standard.debug('p_interest_schedule_id ='|| p_interest_schedule_id ||
2396: ', p_bank_account_id ='||p_bank_account_id ||
2397: ', p_interest_acct_type ='||p_interest_acct_type ||

Line 2540: cep_standard.debug('<< CE_INTEREST_CALC.int_cal_detail_main');

2536: END IF;
2537:
2538: END IF;
2539: IF l_DEBUG in ('Y', 'C') THEN
2540: cep_standard.debug('<< CE_INTEREST_CALC.int_cal_detail_main');
2541: END IF;
2542:
2543: EXCEPTION
2544: when others then

Line 2546: cep_standard.debug('EXCEPTION: CE_INTEREST_CALC.int_cal_detail_main');

2542:
2543: EXCEPTION
2544: when others then
2545: IF l_DEBUG in ('Y', 'C') THEN
2546: cep_standard.debug('EXCEPTION: CE_INTEREST_CALC.int_cal_detail_main');
2547: END IF;
2548: FND_MESSAGE.Set_Name('CE', 'CE_UNHANDLED_EXCEPTION');
2549: FND_MESSAGE.Set_Token('PROCEDURE', 'CE_INTEREST_CALC.int_cal_detail_main');
2550: fnd_msg_pub.add;

Line 2549: FND_MESSAGE.Set_Token('PROCEDURE', 'CE_INTEREST_CALC.int_cal_detail_main');

2545: IF l_DEBUG in ('Y', 'C') THEN
2546: cep_standard.debug('EXCEPTION: CE_INTEREST_CALC.int_cal_detail_main');
2547: END IF;
2548: FND_MESSAGE.Set_Name('CE', 'CE_UNHANDLED_EXCEPTION');
2549: FND_MESSAGE.Set_Token('PROCEDURE', 'CE_INTEREST_CALC.int_cal_detail_main');
2550: fnd_msg_pub.add;
2551:
2552: END int_cal_detail_main;
2553:

Line 2554: END CE_INTEREST_CALC;

2550: fnd_msg_pub.add;
2551:
2552: END int_cal_detail_main;
2553:
2554: END CE_INTEREST_CALC;