eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.CE_INTEREST_CALC dependencies on STANDARD

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 779: cep_standard.debug('EXCEPTION: get_interest_rate');

775: END IF;
776:
777: EXCEPTION
778: WHEN OTHERS THEN
779: cep_standard.debug('EXCEPTION: get_interest_rate');
780: RAISE;
781: END get_interest_rate;
782:
783: /* --------------------------------------------------------------------

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 825: cep_standard.debug('delete p_interest_acct_type BANK_ACCOUNT');

821: -- bug 5493399
822: --IF (p_interest_acct_type = 'BANK_ACCOUNT') THEN
823: IF (p_interest_acct_type in ('BANK_ACCOUNT', 'TREASURY')) THEN
824: IF l_DEBUG in ('Y', 'C') THEN
825: cep_standard.debug('delete p_interest_acct_type BANK_ACCOUNT');
826: END IF;
827: DELETE CE_INT_CALC_DETAILS_GT
828: WHERE INTEREST_SCHEDULE_ID = p_interest_schedule_id
829: and BANK_ACCOUNT_ID = p_bank_account_id

Line 833: cep_standard.debug('delete p_interest_acct_type NOTIONAL');

829: and BANK_ACCOUNT_ID = p_bank_account_id
830: AND INTEREST_ACCT_TYPE = p_interest_acct_type;
831: ELSIF (p_interest_acct_type = 'NOTIONAL') THEN
832: IF l_DEBUG in ('Y', 'C') THEN
833: cep_standard.debug('delete p_interest_acct_type NOTIONAL');
834: END IF;
835: DELETE CE_INT_CALC_DETAILS_GT
836: WHERE INTEREST_SCHEDULE_ID = p_interest_schedule_id
837: --and BANK_ACCOUNT_ID = p_bank_account_id

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 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 932: cep_standard.debug('y_bank_account_id = '|| y_bank_account_id);

928: END IF;
929:
930:
931: IF l_DEBUG in ('Y', 'C') THEN
932: cep_standard.debug('y_bank_account_id = '|| y_bank_account_id);
933: cep_standard.debug('y_balance_date_from = '|| y_balance_date_from);
934: cep_standard.debug('y_int_calc_balance = '|| y_int_calc_balance);
935: cep_standard.debug('y_interest_rate = '|| y_interest_rate);
936: cep_standard.debug('y_first_row = '|| y_first_row);

Line 933: cep_standard.debug('y_balance_date_from = '|| y_balance_date_from);

929:
930:
931: IF l_DEBUG in ('Y', 'C') THEN
932: cep_standard.debug('y_bank_account_id = '|| y_bank_account_id);
933: cep_standard.debug('y_balance_date_from = '|| y_balance_date_from);
934: cep_standard.debug('y_int_calc_balance = '|| y_int_calc_balance);
935: cep_standard.debug('y_interest_rate = '|| y_interest_rate);
936: cep_standard.debug('y_first_row = '|| y_first_row);
937: cep_standard.debug('y_record_from = '|| y_record_from);

Line 934: cep_standard.debug('y_int_calc_balance = '|| y_int_calc_balance);

930:
931: IF l_DEBUG in ('Y', 'C') THEN
932: cep_standard.debug('y_bank_account_id = '|| y_bank_account_id);
933: cep_standard.debug('y_balance_date_from = '|| y_balance_date_from);
934: cep_standard.debug('y_int_calc_balance = '|| y_int_calc_balance);
935: cep_standard.debug('y_interest_rate = '|| y_interest_rate);
936: cep_standard.debug('y_first_row = '|| y_first_row);
937: cep_standard.debug('y_record_from = '|| y_record_from);
938: END IF;

Line 935: cep_standard.debug('y_interest_rate = '|| y_interest_rate);

931: IF l_DEBUG in ('Y', 'C') THEN
932: cep_standard.debug('y_bank_account_id = '|| y_bank_account_id);
933: cep_standard.debug('y_balance_date_from = '|| y_balance_date_from);
934: cep_standard.debug('y_int_calc_balance = '|| y_int_calc_balance);
935: cep_standard.debug('y_interest_rate = '|| y_interest_rate);
936: cep_standard.debug('y_first_row = '|| y_first_row);
937: cep_standard.debug('y_record_from = '|| y_record_from);
938: END IF;
939: insert into CE_INT_CALC_DETAILS_GT

Line 936: cep_standard.debug('y_first_row = '|| y_first_row);

932: cep_standard.debug('y_bank_account_id = '|| y_bank_account_id);
933: cep_standard.debug('y_balance_date_from = '|| y_balance_date_from);
934: cep_standard.debug('y_int_calc_balance = '|| y_int_calc_balance);
935: cep_standard.debug('y_interest_rate = '|| y_interest_rate);
936: cep_standard.debug('y_first_row = '|| y_first_row);
937: cep_standard.debug('y_record_from = '|| y_record_from);
938: END IF;
939: insert into CE_INT_CALC_DETAILS_GT
940: (INTEREST_CALC_DETAIL_ID,

Line 937: cep_standard.debug('y_record_from = '|| y_record_from);

933: cep_standard.debug('y_balance_date_from = '|| y_balance_date_from);
934: cep_standard.debug('y_int_calc_balance = '|| y_int_calc_balance);
935: cep_standard.debug('y_interest_rate = '|| y_interest_rate);
936: cep_standard.debug('y_first_row = '|| y_first_row);
937: cep_standard.debug('y_record_from = '|| y_record_from);
938: END IF;
939: insert into CE_INT_CALC_DETAILS_GT
940: (INTEREST_CALC_DETAIL_ID,
941: INTEREST_SCHEDULE_ID, BANK_ACCOUNT_ID, FROM_DATE, TO_DATE,

Line 956: cep_standard.debug('insert into CE_INT_CALC_DETAILS_GT completed ');

952: p_interest_acct_type, p_cashpool_id,
953: sysdate, -1, sysdate, -1, null);
954:
955: IF l_DEBUG in ('Y', 'C') THEN
956: cep_standard.debug('insert into CE_INT_CALC_DETAILS_GT completed ');
957: END IF;
958: END LOOP; --balance_info
959: p_row_count := balance_info%ROWCOUNT;
960: IF l_DEBUG in ('Y', 'C') THEN

Line 961: cep_standard.debug('p_row_count = '|| p_row_count );

957: END IF;
958: END LOOP; --balance_info
959: p_row_count := balance_info%ROWCOUNT;
960: IF l_DEBUG in ('Y', 'C') THEN
961: cep_standard.debug('p_row_count = '|| p_row_count );
962: END IF;
963:
964: CLOSE balance_info;
965:

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 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 1056: cep_standard.debug('y_bank_account_id = '|| y_bank_account_id);

1052: END IF;
1053:
1054:
1055: IF l_DEBUG in ('Y', 'C') THEN
1056: cep_standard.debug('y_bank_account_id = '|| y_bank_account_id);
1057: cep_standard.debug('y_balance_date_from = '|| y_balance_date_from);
1058: cep_standard.debug('y_int_calc_balance = '|| y_int_calc_balance);
1059: cep_standard.debug('y_interest_rate = '|| y_interest_rate);
1060: cep_standard.debug('y_first_row = '|| y_first_row);

Line 1057: cep_standard.debug('y_balance_date_from = '|| y_balance_date_from);

1053:
1054:
1055: IF l_DEBUG in ('Y', 'C') THEN
1056: cep_standard.debug('y_bank_account_id = '|| y_bank_account_id);
1057: cep_standard.debug('y_balance_date_from = '|| y_balance_date_from);
1058: cep_standard.debug('y_int_calc_balance = '|| y_int_calc_balance);
1059: cep_standard.debug('y_interest_rate = '|| y_interest_rate);
1060: cep_standard.debug('y_first_row = '|| y_first_row);
1061: cep_standard.debug('y_record_from = '|| y_record_from);

Line 1058: cep_standard.debug('y_int_calc_balance = '|| y_int_calc_balance);

1054:
1055: IF l_DEBUG in ('Y', 'C') THEN
1056: cep_standard.debug('y_bank_account_id = '|| y_bank_account_id);
1057: cep_standard.debug('y_balance_date_from = '|| y_balance_date_from);
1058: cep_standard.debug('y_int_calc_balance = '|| y_int_calc_balance);
1059: cep_standard.debug('y_interest_rate = '|| y_interest_rate);
1060: cep_standard.debug('y_first_row = '|| y_first_row);
1061: cep_standard.debug('y_record_from = '|| y_record_from);
1062: END IF;

Line 1059: cep_standard.debug('y_interest_rate = '|| y_interest_rate);

1055: IF l_DEBUG in ('Y', 'C') THEN
1056: cep_standard.debug('y_bank_account_id = '|| y_bank_account_id);
1057: cep_standard.debug('y_balance_date_from = '|| y_balance_date_from);
1058: cep_standard.debug('y_int_calc_balance = '|| y_int_calc_balance);
1059: cep_standard.debug('y_interest_rate = '|| y_interest_rate);
1060: cep_standard.debug('y_first_row = '|| y_first_row);
1061: cep_standard.debug('y_record_from = '|| y_record_from);
1062: END IF;
1063: insert into CE_INT_CALC_DETAILS_GT

Line 1060: cep_standard.debug('y_first_row = '|| y_first_row);

1056: cep_standard.debug('y_bank_account_id = '|| y_bank_account_id);
1057: cep_standard.debug('y_balance_date_from = '|| y_balance_date_from);
1058: cep_standard.debug('y_int_calc_balance = '|| y_int_calc_balance);
1059: cep_standard.debug('y_interest_rate = '|| y_interest_rate);
1060: cep_standard.debug('y_first_row = '|| y_first_row);
1061: cep_standard.debug('y_record_from = '|| y_record_from);
1062: END IF;
1063: insert into CE_INT_CALC_DETAILS_GT
1064: (INTEREST_CALC_DETAIL_ID,

Line 1061: cep_standard.debug('y_record_from = '|| y_record_from);

1057: cep_standard.debug('y_balance_date_from = '|| y_balance_date_from);
1058: cep_standard.debug('y_int_calc_balance = '|| y_int_calc_balance);
1059: cep_standard.debug('y_interest_rate = '|| y_interest_rate);
1060: cep_standard.debug('y_first_row = '|| y_first_row);
1061: cep_standard.debug('y_record_from = '|| y_record_from);
1062: END IF;
1063: insert into CE_INT_CALC_DETAILS_GT
1064: (INTEREST_CALC_DETAIL_ID,
1065: INTEREST_SCHEDULE_ID, BANK_ACCOUNT_ID, FROM_DATE, TO_DATE,

Line 1080: cep_standard.debug('insert into CE_INT_CALC_DETAILS_GT completed ');

1076: p_interest_acct_type, p_cashpool_id,
1077: sysdate, -1, sysdate, -1, null);
1078:
1079: IF l_DEBUG in ('Y', 'C') THEN
1080: cep_standard.debug('insert into CE_INT_CALC_DETAILS_GT completed ');
1081: END IF;
1082: END LOOP; --balance_pool_info
1083: p_row_count := balance_pool_info%ROWCOUNT;
1084: IF l_DEBUG in ('Y', 'C') THEN

Line 1085: cep_standard.debug('p_row_count = '|| p_row_count );

1081: END IF;
1082: END LOOP; --balance_pool_info
1083: p_row_count := balance_pool_info%ROWCOUNT;
1084: IF l_DEBUG in ('Y', 'C') THEN
1085: cep_standard.debug('p_row_count = '|| p_row_count );
1086: END IF;
1087:
1088: CLOSE balance_pool_info;
1089:

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 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 1183: cep_standard.debug('y_bank_account_id = '|| y_bank_account_id);

1179: END IF;
1180:
1181:
1182: IF l_DEBUG in ('Y', 'C') THEN
1183: cep_standard.debug('y_bank_account_id = '|| y_bank_account_id);
1184: cep_standard.debug('y_balance_date_from = '|| y_balance_date_from);
1185: cep_standard.debug('y_int_calc_balance = '|| y_int_calc_balance);
1186: cep_standard.debug('y_balance_range_id = '|| y_balance_range_id);
1187: cep_standard.debug('y_interest_rate = '|| y_interest_rate );

Line 1184: cep_standard.debug('y_balance_date_from = '|| y_balance_date_from);

1180:
1181:
1182: IF l_DEBUG in ('Y', 'C') THEN
1183: cep_standard.debug('y_bank_account_id = '|| y_bank_account_id);
1184: cep_standard.debug('y_balance_date_from = '|| y_balance_date_from);
1185: cep_standard.debug('y_int_calc_balance = '|| y_int_calc_balance);
1186: cep_standard.debug('y_balance_range_id = '|| y_balance_range_id);
1187: cep_standard.debug('y_interest_rate = '|| y_interest_rate );
1188:

Line 1185: cep_standard.debug('y_int_calc_balance = '|| y_int_calc_balance);

1181:
1182: IF l_DEBUG in ('Y', 'C') THEN
1183: cep_standard.debug('y_bank_account_id = '|| y_bank_account_id);
1184: cep_standard.debug('y_balance_date_from = '|| y_balance_date_from);
1185: cep_standard.debug('y_int_calc_balance = '|| y_int_calc_balance);
1186: cep_standard.debug('y_balance_range_id = '|| y_balance_range_id);
1187: cep_standard.debug('y_interest_rate = '|| y_interest_rate );
1188:
1189: END IF;

Line 1186: cep_standard.debug('y_balance_range_id = '|| y_balance_range_id);

1182: IF l_DEBUG in ('Y', 'C') THEN
1183: cep_standard.debug('y_bank_account_id = '|| y_bank_account_id);
1184: cep_standard.debug('y_balance_date_from = '|| y_balance_date_from);
1185: cep_standard.debug('y_int_calc_balance = '|| y_int_calc_balance);
1186: cep_standard.debug('y_balance_range_id = '|| y_balance_range_id);
1187: cep_standard.debug('y_interest_rate = '|| y_interest_rate );
1188:
1189: END IF;
1190: insert into CE_INT_CALC_DETAILS_GT

Line 1187: cep_standard.debug('y_interest_rate = '|| y_interest_rate );

1183: cep_standard.debug('y_bank_account_id = '|| y_bank_account_id);
1184: cep_standard.debug('y_balance_date_from = '|| y_balance_date_from);
1185: cep_standard.debug('y_int_calc_balance = '|| y_int_calc_balance);
1186: cep_standard.debug('y_balance_range_id = '|| y_balance_range_id);
1187: cep_standard.debug('y_interest_rate = '|| y_interest_rate );
1188:
1189: END IF;
1190: insert into CE_INT_CALC_DETAILS_GT
1191: (INTEREST_CALC_DETAIL_ID,

Line 1209: cep_standard.debug('p_row_count = '|| p_row_count );

1205:
1206: END LOOP; --interest_info
1207: p_row_count := interest_info%ROWCOUNT;
1208: IF l_DEBUG in ('Y', 'C') THEN
1209: cep_standard.debug('p_row_count = '|| p_row_count );
1210: END IF;
1211:
1212: CLOSE interest_info;
1213:

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 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 1309: cep_standard.debug('y_bank_account_id = '|| y_bank_account_id);

1305: END IF;
1306:
1307:
1308: IF l_DEBUG in ('Y', 'C') THEN
1309: cep_standard.debug('y_bank_account_id = '|| y_bank_account_id);
1310: cep_standard.debug('y_balance_date_from = '|| y_balance_date_from);
1311: cep_standard.debug('y_int_calc_balance = '|| y_int_calc_balance);
1312: cep_standard.debug('y_balance_range_id = '|| y_balance_range_id);
1313: cep_standard.debug('y_interest_rate = '|| y_interest_rate );

Line 1310: cep_standard.debug('y_balance_date_from = '|| y_balance_date_from);

1306:
1307:
1308: IF l_DEBUG in ('Y', 'C') THEN
1309: cep_standard.debug('y_bank_account_id = '|| y_bank_account_id);
1310: cep_standard.debug('y_balance_date_from = '|| y_balance_date_from);
1311: cep_standard.debug('y_int_calc_balance = '|| y_int_calc_balance);
1312: cep_standard.debug('y_balance_range_id = '|| y_balance_range_id);
1313: cep_standard.debug('y_interest_rate = '|| y_interest_rate );
1314:

Line 1311: cep_standard.debug('y_int_calc_balance = '|| y_int_calc_balance);

1307:
1308: IF l_DEBUG in ('Y', 'C') THEN
1309: cep_standard.debug('y_bank_account_id = '|| y_bank_account_id);
1310: cep_standard.debug('y_balance_date_from = '|| y_balance_date_from);
1311: cep_standard.debug('y_int_calc_balance = '|| y_int_calc_balance);
1312: cep_standard.debug('y_balance_range_id = '|| y_balance_range_id);
1313: cep_standard.debug('y_interest_rate = '|| y_interest_rate );
1314:
1315: END IF;

Line 1312: cep_standard.debug('y_balance_range_id = '|| y_balance_range_id);

1308: IF l_DEBUG in ('Y', 'C') THEN
1309: cep_standard.debug('y_bank_account_id = '|| y_bank_account_id);
1310: cep_standard.debug('y_balance_date_from = '|| y_balance_date_from);
1311: cep_standard.debug('y_int_calc_balance = '|| y_int_calc_balance);
1312: cep_standard.debug('y_balance_range_id = '|| y_balance_range_id);
1313: cep_standard.debug('y_interest_rate = '|| y_interest_rate );
1314:
1315: END IF;
1316: insert into CE_INT_CALC_DETAILS_GT

Line 1313: cep_standard.debug('y_interest_rate = '|| y_interest_rate );

1309: cep_standard.debug('y_bank_account_id = '|| y_bank_account_id);
1310: cep_standard.debug('y_balance_date_from = '|| y_balance_date_from);
1311: cep_standard.debug('y_int_calc_balance = '|| y_int_calc_balance);
1312: cep_standard.debug('y_balance_range_id = '|| y_balance_range_id);
1313: cep_standard.debug('y_interest_rate = '|| y_interest_rate );
1314:
1315: END IF;
1316: insert into CE_INT_CALC_DETAILS_GT
1317: (INTEREST_CALC_DETAIL_ID,

Line 1335: cep_standard.debug('p_row_count = '|| p_row_count );

1331:
1332: END LOOP; --interest_pool_info
1333: p_row_count := interest_pool_info%ROWCOUNT;
1334: IF l_DEBUG in ('Y', 'C') THEN
1335: cep_standard.debug('p_row_count = '|| p_row_count );
1336: END IF;
1337:
1338: CLOSE interest_pool_info;
1339:

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 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 1407: cep_standard.debug('y_bank_account_id = '|| y_bank_account_id);

1403: --y_rownum := x_rownum;
1404: --y_first_row := x_first_row;
1405:
1406: IF l_DEBUG in ('Y', 'C') THEN
1407: cep_standard.debug('y_bank_account_id = '|| y_bank_account_id);
1408: cep_standard.debug('y_balance_date_from = '|| y_balance_date_from);
1409: cep_standard.debug('y_int_calc_balance = '|| y_int_calc_balance);
1410: cep_standard.debug('y_interest_rate = '|| y_interest_rate );
1411: cep_standard.debug('y_interest_calc_detail_id = '|| y_interest_calc_detail_id);

Line 1408: cep_standard.debug('y_balance_date_from = '|| y_balance_date_from);

1404: --y_first_row := x_first_row;
1405:
1406: IF l_DEBUG in ('Y', 'C') THEN
1407: cep_standard.debug('y_bank_account_id = '|| y_bank_account_id);
1408: cep_standard.debug('y_balance_date_from = '|| y_balance_date_from);
1409: cep_standard.debug('y_int_calc_balance = '|| y_int_calc_balance);
1410: cep_standard.debug('y_interest_rate = '|| y_interest_rate );
1411: cep_standard.debug('y_interest_calc_detail_id = '|| y_interest_calc_detail_id);
1412:

Line 1409: cep_standard.debug('y_int_calc_balance = '|| y_int_calc_balance);

1405:
1406: IF l_DEBUG in ('Y', 'C') THEN
1407: cep_standard.debug('y_bank_account_id = '|| y_bank_account_id);
1408: cep_standard.debug('y_balance_date_from = '|| y_balance_date_from);
1409: cep_standard.debug('y_int_calc_balance = '|| y_int_calc_balance);
1410: cep_standard.debug('y_interest_rate = '|| y_interest_rate );
1411: cep_standard.debug('y_interest_calc_detail_id = '|| y_interest_calc_detail_id);
1412:
1413: END IF;

Line 1410: cep_standard.debug('y_interest_rate = '|| y_interest_rate );

1406: IF l_DEBUG in ('Y', 'C') THEN
1407: cep_standard.debug('y_bank_account_id = '|| y_bank_account_id);
1408: cep_standard.debug('y_balance_date_from = '|| y_balance_date_from);
1409: cep_standard.debug('y_int_calc_balance = '|| y_int_calc_balance);
1410: cep_standard.debug('y_interest_rate = '|| y_interest_rate );
1411: cep_standard.debug('y_interest_calc_detail_id = '|| y_interest_calc_detail_id);
1412:
1413: END IF;
1414:

Line 1411: cep_standard.debug('y_interest_calc_detail_id = '|| y_interest_calc_detail_id);

1407: cep_standard.debug('y_bank_account_id = '|| y_bank_account_id);
1408: cep_standard.debug('y_balance_date_from = '|| y_balance_date_from);
1409: cep_standard.debug('y_int_calc_balance = '|| y_int_calc_balance);
1410: cep_standard.debug('y_interest_rate = '|| y_interest_rate );
1411: cep_standard.debug('y_interest_calc_detail_id = '|| y_interest_calc_detail_id);
1412:
1413: END IF;
1414:
1415: update CE_INT_CALC_DETAILS_GT

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 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 1501: cep_standard.debug('y_balance_range_id = '|| y_balance_range_id );

1497: y_interest_rate := x_interest_rate;
1498: y_interest_calc_detail_id := x_interest_calc_detail_id ;
1499:
1500: IF l_DEBUG in ('Y', 'C') THEN
1501: cep_standard.debug('y_balance_range_id = '|| y_balance_range_id );
1502: cep_standard.debug('y_interest_rate = '|| y_interest_rate);
1503: cep_standard.debug('y_interest_calc_detail_id = '|| y_interest_calc_detail_id);
1504: END IF;
1505:

Line 1502: cep_standard.debug('y_interest_rate = '|| y_interest_rate);

1498: y_interest_calc_detail_id := x_interest_calc_detail_id ;
1499:
1500: IF l_DEBUG in ('Y', 'C') THEN
1501: cep_standard.debug('y_balance_range_id = '|| y_balance_range_id );
1502: cep_standard.debug('y_interest_rate = '|| y_interest_rate);
1503: cep_standard.debug('y_interest_calc_detail_id = '|| y_interest_calc_detail_id);
1504: END IF;
1505:
1506: update CE_INT_CALC_DETAILS_GT

Line 1503: cep_standard.debug('y_interest_calc_detail_id = '|| y_interest_calc_detail_id);

1499:
1500: IF l_DEBUG in ('Y', 'C') THEN
1501: cep_standard.debug('y_balance_range_id = '|| y_balance_range_id );
1502: cep_standard.debug('y_interest_rate = '|| y_interest_rate);
1503: cep_standard.debug('y_interest_calc_detail_id = '|| y_interest_calc_detail_id);
1504: END IF;
1505:
1506: update CE_INT_CALC_DETAILS_GT
1507: set BALANCE_RANGE_ID = y_balance_range_id,

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 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 1601: cep_standard.debug('y_balance_date_from = '|| y_balance_date_from);

1597: END IF;
1598:
1599:
1600: IF l_DEBUG in ('Y', 'C') THEN
1601: cep_standard.debug('y_balance_date_from = '|| y_balance_date_from);
1602: cep_standard.debug('y_end_date = '|| y_end_date);
1603: cep_standard.debug('y_interest_calc_detail_id = '|| y_interest_calc_detail_id);
1604: cep_standard.debug(' i = '|| i);
1605:

Line 1602: cep_standard.debug('y_end_date = '|| y_end_date);

1598:
1599:
1600: IF l_DEBUG in ('Y', 'C') THEN
1601: cep_standard.debug('y_balance_date_from = '|| y_balance_date_from);
1602: cep_standard.debug('y_end_date = '|| y_end_date);
1603: cep_standard.debug('y_interest_calc_detail_id = '|| y_interest_calc_detail_id);
1604: cep_standard.debug(' i = '|| i);
1605:
1606: END IF;

Line 1603: cep_standard.debug('y_interest_calc_detail_id = '|| y_interest_calc_detail_id);

1599:
1600: IF l_DEBUG in ('Y', 'C') THEN
1601: cep_standard.debug('y_balance_date_from = '|| y_balance_date_from);
1602: cep_standard.debug('y_end_date = '|| y_end_date);
1603: cep_standard.debug('y_interest_calc_detail_id = '|| y_interest_calc_detail_id);
1604: cep_standard.debug(' i = '|| i);
1605:
1606: END IF;
1607:

Line 1604: cep_standard.debug(' i = '|| i);

1600: IF l_DEBUG in ('Y', 'C') THEN
1601: cep_standard.debug('y_balance_date_from = '|| y_balance_date_from);
1602: cep_standard.debug('y_end_date = '|| y_end_date);
1603: cep_standard.debug('y_interest_calc_detail_id = '|| y_interest_calc_detail_id);
1604: cep_standard.debug(' i = '|| i);
1605:
1606: END IF;
1607:
1608: update CE_INT_CALC_DETAILS_GT

Line 1619: cep_standard.debug('x_previous_date_from = '|| x_previous_date_from);

1615:
1616: x_previous_date_from := x_balance_date_from;
1617:
1618: IF l_DEBUG in ('Y', 'C') THEN
1619: cep_standard.debug('x_previous_date_from = '|| x_previous_date_from);
1620:
1621: END IF;
1622:
1623: END LOOP; --end_date_cur

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 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 1697: cep_standard.debug('y_interest_calc_detail_id = '|| y_interest_calc_detail_id);

1693: y_rownum := x_rownum;
1694: y_interest_calc_detail_id := x_interest_calc_detail_id ;
1695:
1696: IF l_DEBUG in ('Y', 'C') THEN
1697: cep_standard.debug('y_interest_calc_detail_id = '|| y_interest_calc_detail_id);
1698: END IF;
1699:
1700: update CE_INT_CALC_DETAILS_GT
1701: set INTEREST_RATE = p_interest_rate

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 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 1800: cep_standard.debug('p_from_date='||p_from_date||', p_to_date='||p_to_date);

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,
1804: INTEREST_INCLUDES,

Line 1835: cep_standard.debug('x_basis = '|| x_basis);

1831: WHERE INTEREST_SCHEDULE_ID = p_interest_schedule_id
1832: AND FROM_BALANCE_AMOUNT > 0;
1833:
1834: IF l_DEBUG in ('Y', 'C') THEN
1835: cep_standard.debug('x_basis = '|| x_basis);
1836: cep_standard.debug('x_interest_includes = '|| x_interest_includes );
1837: cep_standard.debug('x_interest_rounding = '|| x_interest_rounding );
1838: cep_standard.debug('x_day_count_basis = '|| x_day_count_basis );
1839: cep_standard.debug('precision = '|| precision);

Line 1836: cep_standard.debug('x_interest_includes = '|| x_interest_includes );

1832: AND FROM_BALANCE_AMOUNT > 0;
1833:
1834: IF l_DEBUG in ('Y', 'C') THEN
1835: cep_standard.debug('x_basis = '|| x_basis);
1836: cep_standard.debug('x_interest_includes = '|| x_interest_includes );
1837: cep_standard.debug('x_interest_rounding = '|| x_interest_rounding );
1838: cep_standard.debug('x_day_count_basis = '|| x_day_count_basis );
1839: cep_standard.debug('precision = '|| precision);
1840: cep_standard.debug('ext_precision = '|| ext_precision);

Line 1837: cep_standard.debug('x_interest_rounding = '|| x_interest_rounding );

1833:
1834: IF l_DEBUG in ('Y', 'C') THEN
1835: cep_standard.debug('x_basis = '|| x_basis);
1836: cep_standard.debug('x_interest_includes = '|| x_interest_includes );
1837: cep_standard.debug('x_interest_rounding = '|| x_interest_rounding );
1838: cep_standard.debug('x_day_count_basis = '|| x_day_count_basis );
1839: cep_standard.debug('precision = '|| precision);
1840: cep_standard.debug('ext_precision = '|| ext_precision);
1841: cep_standard.debug('min_acct_unit = '|| min_acct_unit);

Line 1838: cep_standard.debug('x_day_count_basis = '|| x_day_count_basis );

1834: IF l_DEBUG in ('Y', 'C') THEN
1835: cep_standard.debug('x_basis = '|| x_basis);
1836: cep_standard.debug('x_interest_includes = '|| x_interest_includes );
1837: cep_standard.debug('x_interest_rounding = '|| x_interest_rounding );
1838: cep_standard.debug('x_day_count_basis = '|| x_day_count_basis );
1839: cep_standard.debug('precision = '|| precision);
1840: cep_standard.debug('ext_precision = '|| ext_precision);
1841: cep_standard.debug('min_acct_unit = '|| min_acct_unit);
1842:

Line 1839: cep_standard.debug('precision = '|| precision);

1835: cep_standard.debug('x_basis = '|| x_basis);
1836: cep_standard.debug('x_interest_includes = '|| x_interest_includes );
1837: cep_standard.debug('x_interest_rounding = '|| x_interest_rounding );
1838: cep_standard.debug('x_day_count_basis = '|| x_day_count_basis );
1839: cep_standard.debug('precision = '|| precision);
1840: cep_standard.debug('ext_precision = '|| ext_precision);
1841: cep_standard.debug('min_acct_unit = '|| min_acct_unit);
1842:
1843: cep_standard.debug('x_add_min_pre_amt = '|| x_add_min_pre_amt);

Line 1840: cep_standard.debug('ext_precision = '|| ext_precision);

1836: cep_standard.debug('x_interest_includes = '|| x_interest_includes );
1837: cep_standard.debug('x_interest_rounding = '|| x_interest_rounding );
1838: cep_standard.debug('x_day_count_basis = '|| x_day_count_basis );
1839: cep_standard.debug('precision = '|| precision);
1840: cep_standard.debug('ext_precision = '|| ext_precision);
1841: cep_standard.debug('min_acct_unit = '|| min_acct_unit);
1842:
1843: cep_standard.debug('x_add_min_pre_amt = '|| x_add_min_pre_amt);
1844:

Line 1841: cep_standard.debug('min_acct_unit = '|| min_acct_unit);

1837: cep_standard.debug('x_interest_rounding = '|| x_interest_rounding );
1838: cep_standard.debug('x_day_count_basis = '|| x_day_count_basis );
1839: cep_standard.debug('precision = '|| precision);
1840: cep_standard.debug('ext_precision = '|| ext_precision);
1841: cep_standard.debug('min_acct_unit = '|| min_acct_unit);
1842:
1843: cep_standard.debug('x_add_min_pre_amt = '|| x_add_min_pre_amt);
1844:
1845: cep_standard.debug('x_min_balance_date = '|| x_min_balance_date);

Line 1843: cep_standard.debug('x_add_min_pre_amt = '|| x_add_min_pre_amt);

1839: cep_standard.debug('precision = '|| precision);
1840: cep_standard.debug('ext_precision = '|| ext_precision);
1841: cep_standard.debug('min_acct_unit = '|| min_acct_unit);
1842:
1843: cep_standard.debug('x_add_min_pre_amt = '|| x_add_min_pre_amt);
1844:
1845: cep_standard.debug('x_min_balance_date = '|| x_min_balance_date);
1846: cep_standard.debug('x_max_balance_date = '|| x_max_balance_date);
1847:

Line 1845: cep_standard.debug('x_min_balance_date = '|| x_min_balance_date);

1841: cep_standard.debug('min_acct_unit = '|| min_acct_unit);
1842:
1843: cep_standard.debug('x_add_min_pre_amt = '|| x_add_min_pre_amt);
1844:
1845: cep_standard.debug('x_min_balance_date = '|| x_min_balance_date);
1846: cep_standard.debug('x_max_balance_date = '|| x_max_balance_date);
1847:
1848: END IF;
1849:

Line 1846: cep_standard.debug('x_max_balance_date = '|| x_max_balance_date);

1842:
1843: cep_standard.debug('x_add_min_pre_amt = '|| x_add_min_pre_amt);
1844:
1845: cep_standard.debug('x_min_balance_date = '|| x_min_balance_date);
1846: cep_standard.debug('x_max_balance_date = '|| x_max_balance_date);
1847:
1848: END IF;
1849:
1850: /*

Line 1981: cep_standard.debug('---------- new balance range ------------');

1977:
1978: END IF; --(x_day_count_basis = 'ACTUAL/ACTUAL')
1979:
1980: IF l_DEBUG in ('Y', 'C') THEN
1981: cep_standard.debug('---------- new balance range ------------');
1982: cep_standard.debug('x_balance_date_from = '|| x_balance_date_from);
1983: cep_standard.debug('x_balance_date_to = '|| x_balance_date_to);
1984: cep_standard.debug('x_int_calc_balance = '|| x_int_calc_balance );
1985: cep_standard.debug('x_interest_rate = '|| x_interest_rate );

Line 1982: cep_standard.debug('x_balance_date_from = '|| x_balance_date_from);

1978: END IF; --(x_day_count_basis = 'ACTUAL/ACTUAL')
1979:
1980: IF l_DEBUG in ('Y', 'C') THEN
1981: cep_standard.debug('---------- new balance range ------------');
1982: cep_standard.debug('x_balance_date_from = '|| x_balance_date_from);
1983: cep_standard.debug('x_balance_date_to = '|| x_balance_date_to);
1984: cep_standard.debug('x_int_calc_balance = '|| x_int_calc_balance );
1985: cep_standard.debug('x_interest_rate = '|| x_interest_rate );
1986: cep_standard.debug('x_add_days = '|| x_add_days);

Line 1983: cep_standard.debug('x_balance_date_to = '|| x_balance_date_to);

1979:
1980: IF l_DEBUG in ('Y', 'C') THEN
1981: cep_standard.debug('---------- new balance range ------------');
1982: cep_standard.debug('x_balance_date_from = '|| x_balance_date_from);
1983: cep_standard.debug('x_balance_date_to = '|| x_balance_date_to);
1984: cep_standard.debug('x_int_calc_balance = '|| x_int_calc_balance );
1985: cep_standard.debug('x_interest_rate = '|| x_interest_rate );
1986: cep_standard.debug('x_add_days = '|| x_add_days);
1987: cep_standard.debug('x_days_over_year = '|| x_days_over_year);

Line 1984: cep_standard.debug('x_int_calc_balance = '|| x_int_calc_balance );

1980: IF l_DEBUG in ('Y', 'C') THEN
1981: cep_standard.debug('---------- new balance range ------------');
1982: cep_standard.debug('x_balance_date_from = '|| x_balance_date_from);
1983: cep_standard.debug('x_balance_date_to = '|| x_balance_date_to);
1984: cep_standard.debug('x_int_calc_balance = '|| x_int_calc_balance );
1985: cep_standard.debug('x_interest_rate = '|| x_interest_rate );
1986: cep_standard.debug('x_add_days = '|| x_add_days);
1987: cep_standard.debug('x_days_over_year = '|| x_days_over_year);
1988: cep_standard.debug('x_days = '|| x_days);

Line 1985: cep_standard.debug('x_interest_rate = '|| x_interest_rate );

1981: cep_standard.debug('---------- new balance range ------------');
1982: cep_standard.debug('x_balance_date_from = '|| x_balance_date_from);
1983: cep_standard.debug('x_balance_date_to = '|| x_balance_date_to);
1984: cep_standard.debug('x_int_calc_balance = '|| x_int_calc_balance );
1985: cep_standard.debug('x_interest_rate = '|| x_interest_rate );
1986: cep_standard.debug('x_add_days = '|| x_add_days);
1987: cep_standard.debug('x_days_over_year = '|| x_days_over_year);
1988: cep_standard.debug('x_days = '|| x_days);
1989: END IF;

Line 1986: cep_standard.debug('x_add_days = '|| x_add_days);

1982: cep_standard.debug('x_balance_date_from = '|| x_balance_date_from);
1983: cep_standard.debug('x_balance_date_to = '|| x_balance_date_to);
1984: cep_standard.debug('x_int_calc_balance = '|| x_int_calc_balance );
1985: cep_standard.debug('x_interest_rate = '|| x_interest_rate );
1986: cep_standard.debug('x_add_days = '|| x_add_days);
1987: cep_standard.debug('x_days_over_year = '|| x_days_over_year);
1988: cep_standard.debug('x_days = '|| x_days);
1989: END IF;
1990: --------------------------------------------------------------------------------------------

Line 1987: cep_standard.debug('x_days_over_year = '|| x_days_over_year);

1983: cep_standard.debug('x_balance_date_to = '|| x_balance_date_to);
1984: cep_standard.debug('x_int_calc_balance = '|| x_int_calc_balance );
1985: cep_standard.debug('x_interest_rate = '|| x_interest_rate );
1986: cep_standard.debug('x_add_days = '|| x_add_days);
1987: cep_standard.debug('x_days_over_year = '|| x_days_over_year);
1988: cep_standard.debug('x_days = '|| x_days);
1989: END IF;
1990: --------------------------------------------------------------------------------------------
1991: --x_days := (x_balance_date_to - x_balance_date_from + x_add_days );

Line 1988: cep_standard.debug('x_days = '|| x_days);

1984: cep_standard.debug('x_int_calc_balance = '|| x_int_calc_balance );
1985: cep_standard.debug('x_interest_rate = '|| x_interest_rate );
1986: cep_standard.debug('x_add_days = '|| x_add_days);
1987: cep_standard.debug('x_days_over_year = '|| x_days_over_year);
1988: cep_standard.debug('x_days = '|| x_days);
1989: END IF;
1990: --------------------------------------------------------------------------------------------
1991: --x_days := (x_balance_date_to - x_balance_date_from + x_add_days );
1992:

Line 2001: cep_standard.debug('l_amount = '|| l_amount);

1997: ELSE -- STEP
1998:
1999: l_amount := x_int_calc_balance; --l_balance;
2000: IF l_DEBUG in ('Y', 'C') THEN
2001: cep_standard.debug('l_amount = '|| l_amount);
2002: END IF;
2003:
2004: if l_amount <= 0 then
2005:

Line 2007: cep_standard.debug('open DR_RANGE');

2003:
2004: if l_amount <= 0 then
2005:
2006: IF l_DEBUG in ('Y', 'C') THEN
2007: cep_standard.debug('open DR_RANGE');
2008: END IF;
2009:
2010: --open DR_RANGE(p_from_date , p_to_date ,
2011: open DR_RANGE(x_balance_date_from, x_balance_date_to ,

Line 2020: cep_standard.debug('-------------');

2016: fetch DR_RANGE INTO l_min,l_max,l_rate;
2017: EXIT WHEN DR_RANGE%NOTFOUND;
2018:
2019: IF l_DEBUG in ('Y', 'C') THEN
2020: cep_standard.debug('-------------');
2021: cep_standard.debug('l_min = '|| l_min );
2022: cep_standard.debug('l_max = '|| l_max );
2023: cep_standard.debug('l_rate = '|| l_rate );
2024: END IF;

Line 2021: cep_standard.debug('l_min = '|| l_min );

2017: EXIT WHEN DR_RANGE%NOTFOUND;
2018:
2019: IF l_DEBUG in ('Y', 'C') THEN
2020: cep_standard.debug('-------------');
2021: cep_standard.debug('l_min = '|| l_min );
2022: cep_standard.debug('l_max = '|| l_max );
2023: cep_standard.debug('l_rate = '|| l_rate );
2024: END IF;
2025:

Line 2022: cep_standard.debug('l_max = '|| l_max );

2018:
2019: IF l_DEBUG in ('Y', 'C') THEN
2020: cep_standard.debug('-------------');
2021: cep_standard.debug('l_min = '|| l_min );
2022: cep_standard.debug('l_max = '|| l_max );
2023: cep_standard.debug('l_rate = '|| l_rate );
2024: END IF;
2025:
2026:

Line 2023: cep_standard.debug('l_rate = '|| l_rate );

2019: IF l_DEBUG in ('Y', 'C') THEN
2020: cep_standard.debug('-------------');
2021: cep_standard.debug('l_min = '|| l_min );
2022: cep_standard.debug('l_max = '|| l_max );
2023: cep_standard.debug('l_rate = '|| l_rate );
2024: END IF;
2025:
2026:
2027: if l_max > 0 then

Line 2035: cep_standard.debug('new l_min = '|| l_min );

2031: l_min := l_amount;
2032: end if;
2033:
2034: IF l_DEBUG in ('Y', 'C') THEN
2035: cep_standard.debug('new l_min = '|| l_min );
2036: cep_standard.debug('new l_max = '|| l_max );
2037:
2038: END IF;
2039:

Line 2036: cep_standard.debug('new l_max = '|| l_max );

2032: end if;
2033:
2034: IF l_DEBUG in ('Y', 'C') THEN
2035: cep_standard.debug('new l_min = '|| l_min );
2036: cep_standard.debug('new l_max = '|| l_max );
2037:
2038: END IF;
2039:
2040: l_diff := (l_amount - l_max) - (l_amount - l_min);

Line 2043: cep_standard.debug('l_diff = '|| l_diff );

2039:
2040: l_diff := (l_amount - l_max) - (l_amount - l_min);
2041:
2042: IF l_DEBUG in ('Y', 'C') THEN
2043: cep_standard.debug('l_diff = '|| l_diff );
2044: cep_standard.debug('current l_wavg = '|| l_wavg );
2045: cep_standard.debug('current l_count = '|| l_count );
2046: END IF;
2047:

Line 2044: cep_standard.debug('current l_wavg = '|| l_wavg );

2040: l_diff := (l_amount - l_max) - (l_amount - l_min);
2041:
2042: IF l_DEBUG in ('Y', 'C') THEN
2043: cep_standard.debug('l_diff = '|| l_diff );
2044: cep_standard.debug('current l_wavg = '|| l_wavg );
2045: cep_standard.debug('current l_count = '|| l_count );
2046: END IF;
2047:
2048: l_wavg := l_wavg + (l_diff * l_rate);

Line 2045: cep_standard.debug('current l_count = '|| l_count );

2041:
2042: IF l_DEBUG in ('Y', 'C') THEN
2043: cep_standard.debug('l_diff = '|| l_diff );
2044: cep_standard.debug('current l_wavg = '|| l_wavg );
2045: cep_standard.debug('current l_count = '|| l_count );
2046: END IF;
2047:
2048: l_wavg := l_wavg + (l_diff * l_rate);
2049: l_count := l_count + 1;

Line 2052: cep_standard.debug('l_min = '|| l_min );

2048: l_wavg := l_wavg + (l_diff * l_rate);
2049: l_count := l_count + 1;
2050:
2051: IF l_DEBUG in ('Y', 'C') THEN
2052: cep_standard.debug('l_min = '|| l_min );
2053: cep_standard.debug('l_max = '|| l_max );
2054: cep_standard.debug('l_rate = '|| l_rate );
2055: cep_standard.debug('l_diff = '|| l_diff );
2056: cep_standard.debug('l_wavg = '|| l_wavg );

Line 2053: cep_standard.debug('l_max = '|| l_max );

2049: l_count := l_count + 1;
2050:
2051: IF l_DEBUG in ('Y', 'C') THEN
2052: cep_standard.debug('l_min = '|| l_min );
2053: cep_standard.debug('l_max = '|| l_max );
2054: cep_standard.debug('l_rate = '|| l_rate );
2055: cep_standard.debug('l_diff = '|| l_diff );
2056: cep_standard.debug('l_wavg = '|| l_wavg );
2057: END IF;

Line 2054: cep_standard.debug('l_rate = '|| l_rate );

2050:
2051: IF l_DEBUG in ('Y', 'C') THEN
2052: cep_standard.debug('l_min = '|| l_min );
2053: cep_standard.debug('l_max = '|| l_max );
2054: cep_standard.debug('l_rate = '|| l_rate );
2055: cep_standard.debug('l_diff = '|| l_diff );
2056: cep_standard.debug('l_wavg = '|| l_wavg );
2057: END IF;
2058:

Line 2055: cep_standard.debug('l_diff = '|| l_diff );

2051: IF l_DEBUG in ('Y', 'C') THEN
2052: cep_standard.debug('l_min = '|| l_min );
2053: cep_standard.debug('l_max = '|| l_max );
2054: cep_standard.debug('l_rate = '|| l_rate );
2055: cep_standard.debug('l_diff = '|| l_diff );
2056: cep_standard.debug('l_wavg = '|| l_wavg );
2057: END IF;
2058:
2059: END LOOP;

Line 2056: cep_standard.debug('l_wavg = '|| l_wavg );

2052: cep_standard.debug('l_min = '|| l_min );
2053: cep_standard.debug('l_max = '|| l_max );
2054: cep_standard.debug('l_rate = '|| l_rate );
2055: cep_standard.debug('l_diff = '|| l_diff );
2056: cep_standard.debug('l_wavg = '|| l_wavg );
2057: END IF;
2058:
2059: END LOOP;
2060: close DR_RANGE;

Line 2069: cep_standard.debug('-------------');

2065: l_int_rate := round(l_wavg /x_int_calc_balance,5);
2066: end if;
2067:
2068: IF l_DEBUG in ('Y', 'C') THEN
2069: cep_standard.debug('-------------');
2070: cep_standard.debug('l_int_rate = '|| l_int_rate);
2071: END IF;
2072:
2073: else

Line 2070: cep_standard.debug('l_int_rate = '|| l_int_rate);

2066: end if;
2067:
2068: IF l_DEBUG in ('Y', 'C') THEN
2069: cep_standard.debug('-------------');
2070: cep_standard.debug('l_int_rate = '|| l_int_rate);
2071: END IF;
2072:
2073: else
2074: IF l_DEBUG in ('Y', 'C') THEN

Line 2075: cep_standard.debug('open CR_RANGE');

2071: END IF;
2072:
2073: else
2074: IF l_DEBUG in ('Y', 'C') THEN
2075: cep_standard.debug('open CR_RANGE');
2076: END IF;
2077:
2078: --open CR_RANGE(p_from_date , p_to_date ,
2079: open CR_RANGE(x_balance_date_from, x_balance_date_to ,

Line 2088: cep_standard.debug('-------------');

2084: fetch CR_RANGE INTO l_min,l_max,l_rate;
2085: EXIT WHEN CR_RANGE%NOTFOUND;
2086:
2087: IF l_DEBUG in ('Y', 'C') THEN
2088: cep_standard.debug('-------------');
2089: cep_standard.debug('l_min = '|| l_min );
2090: cep_standard.debug('l_max = '|| l_max );
2091: cep_standard.debug('l_rate = '|| l_rate );
2092: END IF;

Line 2089: cep_standard.debug('l_min = '|| l_min );

2085: EXIT WHEN CR_RANGE%NOTFOUND;
2086:
2087: IF l_DEBUG in ('Y', 'C') THEN
2088: cep_standard.debug('-------------');
2089: cep_standard.debug('l_min = '|| l_min );
2090: cep_standard.debug('l_max = '|| l_max );
2091: cep_standard.debug('l_rate = '|| l_rate );
2092: END IF;
2093:

Line 2090: cep_standard.debug('l_max = '|| l_max );

2086:
2087: IF l_DEBUG in ('Y', 'C') THEN
2088: cep_standard.debug('-------------');
2089: cep_standard.debug('l_min = '|| l_min );
2090: cep_standard.debug('l_max = '|| l_max );
2091: cep_standard.debug('l_rate = '|| l_rate );
2092: END IF;
2093:
2094: if l_min < 0 then

Line 2091: cep_standard.debug('l_rate = '|| l_rate );

2087: IF l_DEBUG in ('Y', 'C') THEN
2088: cep_standard.debug('-------------');
2089: cep_standard.debug('l_min = '|| l_min );
2090: cep_standard.debug('l_max = '|| l_max );
2091: cep_standard.debug('l_rate = '|| l_rate );
2092: END IF;
2093:
2094: if l_min < 0 then
2095: l_min := 0;

Line 2102: cep_standard.debug('new l_min = '|| l_min );

2098: l_max := l_amount;
2099: end if;
2100:
2101: IF l_DEBUG in ('Y', 'C') THEN
2102: cep_standard.debug('new l_min = '|| l_min );
2103: cep_standard.debug('new l_max = '|| l_max );
2104:
2105: END IF;
2106:

Line 2103: cep_standard.debug('new l_max = '|| l_max );

2099: end if;
2100:
2101: IF l_DEBUG in ('Y', 'C') THEN
2102: cep_standard.debug('new l_min = '|| l_min );
2103: cep_standard.debug('new l_max = '|| l_max );
2104:
2105: END IF;
2106:
2107: l_diff := (((l_amount - l_min) - (l_amount - l_max)) + x_add_min_pre_amt);

Line 2110: cep_standard.debug('l_diff = '|| l_diff );

2106:
2107: l_diff := (((l_amount - l_min) - (l_amount - l_max)) + x_add_min_pre_amt);
2108:
2109: IF l_DEBUG in ('Y', 'C') THEN
2110: cep_standard.debug('l_diff = '|| l_diff );
2111: cep_standard.debug('current l_wavg = '|| l_wavg );
2112: cep_standard.debug('current l_count = '|| l_count );
2113: END IF;
2114:

Line 2111: cep_standard.debug('current l_wavg = '|| l_wavg );

2107: l_diff := (((l_amount - l_min) - (l_amount - l_max)) + x_add_min_pre_amt);
2108:
2109: IF l_DEBUG in ('Y', 'C') THEN
2110: cep_standard.debug('l_diff = '|| l_diff );
2111: cep_standard.debug('current l_wavg = '|| l_wavg );
2112: cep_standard.debug('current l_count = '|| l_count );
2113: END IF;
2114:
2115: l_wavg := l_wavg + (l_diff * l_rate);

Line 2112: cep_standard.debug('current l_count = '|| l_count );

2108:
2109: IF l_DEBUG in ('Y', 'C') THEN
2110: cep_standard.debug('l_diff = '|| l_diff );
2111: cep_standard.debug('current l_wavg = '|| l_wavg );
2112: cep_standard.debug('current l_count = '|| l_count );
2113: END IF;
2114:
2115: l_wavg := l_wavg + (l_diff * l_rate);
2116: l_count := l_count + 1;

Line 2119: cep_standard.debug('new l_wavg = '|| l_wavg );

2115: l_wavg := l_wavg + (l_diff * l_rate);
2116: l_count := l_count + 1;
2117:
2118: IF l_DEBUG in ('Y', 'C') THEN
2119: cep_standard.debug('new l_wavg = '|| l_wavg );
2120: cep_standard.debug('new l_count = '|| l_count );
2121: END IF;
2122:
2123: END LOOP;

Line 2120: cep_standard.debug('new l_count = '|| l_count );

2116: l_count := l_count + 1;
2117:
2118: IF l_DEBUG in ('Y', 'C') THEN
2119: cep_standard.debug('new l_wavg = '|| l_wavg );
2120: cep_standard.debug('new l_count = '|| l_count );
2121: END IF;
2122:
2123: END LOOP;
2124: close CR_RANGE;

Line 2132: cep_standard.debug('-------------');

2128: l_int_rate := round(l_wavg /x_int_calc_balance,5);
2129: end if;
2130:
2131: IF l_DEBUG in ('Y', 'C') THEN
2132: cep_standard.debug('-------------');
2133: cep_standard.debug('l_int_rate = '|| l_int_rate);
2134: END IF;
2135:
2136: end if;

Line 2133: cep_standard.debug('l_int_rate = '|| l_int_rate);

2129: end if;
2130:
2131: IF l_DEBUG in ('Y', 'C') THEN
2132: cep_standard.debug('-------------');
2133: cep_standard.debug('l_int_rate = '|| l_int_rate);
2134: END IF;
2135:
2136: end if;
2137:

Line 2153: cep_standard.debug('l_wavg = '|| l_wavg );

2149: x_interest_amount_round := roundup(x_interest_amount, precision) ;
2150: END IF;
2151:
2152: IF l_DEBUG in ('Y', 'C') THEN
2153: cep_standard.debug('l_wavg = '|| l_wavg );
2154: cep_standard.debug('x_interest_amount = '|| x_interest_amount );
2155: cep_standard.debug('x_interest_amount_round = '|| x_interest_amount_round );
2156: cep_standard.debug('x_new_interest_rate = '|| x_new_interest_rate );
2157: END IF;

Line 2154: cep_standard.debug('x_interest_amount = '|| x_interest_amount );

2150: END IF;
2151:
2152: IF l_DEBUG in ('Y', 'C') THEN
2153: cep_standard.debug('l_wavg = '|| l_wavg );
2154: cep_standard.debug('x_interest_amount = '|| x_interest_amount );
2155: cep_standard.debug('x_interest_amount_round = '|| x_interest_amount_round );
2156: cep_standard.debug('x_new_interest_rate = '|| x_new_interest_rate );
2157: END IF;
2158:

Line 2155: cep_standard.debug('x_interest_amount_round = '|| x_interest_amount_round );

2151:
2152: IF l_DEBUG in ('Y', 'C') THEN
2153: cep_standard.debug('l_wavg = '|| l_wavg );
2154: cep_standard.debug('x_interest_amount = '|| x_interest_amount );
2155: cep_standard.debug('x_interest_amount_round = '|| x_interest_amount_round );
2156: cep_standard.debug('x_new_interest_rate = '|| x_new_interest_rate );
2157: END IF;
2158:
2159: IF (x_basis = 'STEP') THEN

Line 2156: cep_standard.debug('x_new_interest_rate = '|| x_new_interest_rate );

2152: IF l_DEBUG in ('Y', 'C') THEN
2153: cep_standard.debug('l_wavg = '|| l_wavg );
2154: cep_standard.debug('x_interest_amount = '|| x_interest_amount );
2155: cep_standard.debug('x_interest_amount_round = '|| x_interest_amount_round );
2156: cep_standard.debug('x_new_interest_rate = '|| x_new_interest_rate );
2157: END IF;
2158:
2159: IF (x_basis = 'STEP') THEN
2160: --x_new_interest_rate := (x_interest_amount/(nvl((x_int_calc_balance * x_days_over_year),1) * 100));

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 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 2245: cep_standard.debug('p_from_date ='||p_from_date || ', p_to_date ='||p_to_date );

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 );
2249:

Line 2246: cep_standard.debug(' p_bank_account_id ='||p_bank_account_id ||

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 );
2249:
2250: END IF;

Line 2259: cep_standard.debug(' TREASURY');

2255: FND_MESSAGE.set_name( 'CE','CE_FROM_GREATER_TO_DATE');
2256: fnd_msg_pub.add;
2257: ELSE
2258: IF (p_interest_acct_type = 'TREASURY') THEN
2259: cep_standard.debug(' TREASURY');
2260: IF (p_bank_account_id is not null) THEN
2261: cep_standard.debug(' p_bank_account_id is not null');
2262: SELECT INTEREST_SCHEDULE_ID
2263: INTO P_INTEREST_SCHEDULE_ID

Line 2261: cep_standard.debug(' p_bank_account_id is not null');

2257: ELSE
2258: IF (p_interest_acct_type = 'TREASURY') THEN
2259: cep_standard.debug(' TREASURY');
2260: IF (p_bank_account_id is not null) THEN
2261: cep_standard.debug(' p_bank_account_id is not null');
2262: SELECT INTEREST_SCHEDULE_ID
2263: INTO P_INTEREST_SCHEDULE_ID
2264: FROM CE_BANK_ACCOUNTS
2265: WHERE BANK_ACCOUNT_ID = p_bank_account_id;

Line 2267: cep_standard.debug(' p_interest_schedule_id ='||p_interest_schedule_id );

2263: INTO P_INTEREST_SCHEDULE_ID
2264: FROM CE_BANK_ACCOUNTS
2265: WHERE BANK_ACCOUNT_ID = p_bank_account_id;
2266:
2267: cep_standard.debug(' p_interest_schedule_id ='||p_interest_schedule_id );
2268:
2269: IF (P_INTEREST_SCHEDULE_ID is not null) THEN
2270: delete_schedule_account( p_interest_schedule_id ,
2271: p_bank_account_id,

Line 2282: cep_standard.debug('p_row_count = '|| p_row_count );

2278: p_interest_schedule_id, p_bank_account_id,
2279: p_interest_acct_type, p_cashpool_id, p_row_count );
2280:
2281: IF l_DEBUG in ('Y', 'C') THEN
2282: cep_standard.debug('p_row_count = '|| p_row_count );
2283: END IF;
2284:
2285: IF (p_row_count > 0) THEN
2286: /*

Line 2314: cep_standard.debug(' p_interest_amount ='||p_interest_amount );

2310: and TO_DATE <= p_to_date
2311: and CASHPOOL_ID is null;
2312:
2313: IF l_DEBUG in ('Y', 'C') THEN
2314: cep_standard.debug(' p_interest_amount ='||p_interest_amount );
2315: END IF;
2316:
2317: END IF;
2318: ELSE

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 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 2394: cep_standard.debug('p_from_date = '||p_from_date||', p_to_date = '||p_to_date);

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 ||
2398: ', p_cashpool_id ='||p_cashpool_id );

Line 2395: cep_standard.debug('p_interest_schedule_id ='|| p_interest_schedule_id ||

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 ||
2398: ', p_cashpool_id ='||p_cashpool_id );
2399:

Line 2449: -- cep_standard.debug('x_bank_account_id = '|| x_bank_account_id );

2445: --FETCH cashpool_accts_cur INTO x_bank_account_id;
2446: --EXIT WHEN cashpool_accts_cur%NOTFOUND OR cashpool_accts_cur%NOTFOUND IS NULL;
2447:
2448: --IF l_DEBUG in ('Y', 'C') THEN
2449: -- cep_standard.debug('x_bank_account_id = '|| x_bank_account_id );
2450: --END IF;
2451:
2452: -- found available balances for each cashpool
2453: get_balance_pool_info(p_from_date , p_to_date,

Line 2458: cep_standard.debug('p_row_count = '|| p_row_count );

2454: p_interest_schedule_id, p_bank_account_id,
2455: p_interest_acct_type, p_cashpool_id, p_row_count );
2456:
2457: IF l_DEBUG in ('Y', 'C') THEN
2458: cep_standard.debug('p_row_count = '|| p_row_count );
2459: END IF;
2460: IF (p_row_count > 0) THEN
2461:
2462: set_range_and_rate(p_from_date , p_to_date,

Line 2535: cep_standard.debug('p_num_of_range '|| p_num_of_range );

2531: END IF;
2532: end if; --p_cashpool_id is null
2533:
2534: IF l_DEBUG in ('Y', 'C') THEN
2535: cep_standard.debug('p_num_of_range '|| p_num_of_range );
2536: END IF;
2537:
2538: END IF;
2539: IF l_DEBUG in ('Y', 'C') THEN

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;