[Home] [Help]
144:
145: else
146: FND_MESSAGE.Set_Name('LNS', 'LNS_INVALID_INTERVAL');
147: FND_MESSAGE.SET_TOKEN('INTERVAL',p_interval_type);
148: FND_MSG_PUB.Add;
149: RAISE FND_API.G_EXC_ERROR;
150: end if;
151:
152: l_multiplier := l_multiplier * p_direction;
223: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, l_api_name || ': p_day_count_method: ' || p_day_count_method);
224:
225: if p_end_date < p_start_date then
226: FND_MESSAGE.Set_Name('LNS', 'LNS_PERIOD_INVALID');
227: FND_MSG_PUB.Add;
228: RAISE FND_API.G_EXC_ERROR;
229: end if;
230:
231: if p_end_date is null then
229: end if;
230:
231: if p_end_date is null then
232: FND_MESSAGE.Set_Name('LNS', 'LNS_NO_END_DATE');
233: FND_MSG_PUB.Add;
234: RAISE FND_API.G_EXC_ERROR;
235: end if;
236:
237: if p_start_date is null then
235: end if;
236:
237: if p_start_date is null then
238: FND_MESSAGE.Set_Name('LNS', 'LNS_NO_START_DATE');
239: FND_MSG_PUB.Add;
240: RAISE FND_API.G_EXC_ERROR;
241: end if;
242:
243: if p_day_count_method is null then
241: end if;
242:
243: if p_day_count_method is null then
244: FND_MESSAGE.Set_Name('LNS', 'LNS_NO_COUNT_METHOD');
245: FND_MSG_PUB.Add;
246: RAISE FND_API.G_EXC_ERROR;
247: end if;
248:
249: l_day1 := to_number(to_char(p_start_date, 'DD'));
397: end if;
398:
399: else
400: FND_MESSAGE.Set_Name('LNS', 'LNS_NO_YEAR');
401: FND_MSG_PUB.Add;
402: RAISE FND_API.G_EXC_ERROR;
403: end if;
404:
405: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, l_api_name || ': days in year is: ' || l_days_in_year);
445: else l_return := false;
446: end if;
447: else
448: FND_MESSAGE.Set_Name('LNS', 'LNS_NO_YEAR');
449: FND_MSG_PUB.Add;
450: RAISE FND_API.G_EXC_ERROR;
451: end if;
452: return l_return;
453:
917: if l_term is null or l_term_period is null or l_frequency is null
918: or p_start_date is null then
919: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - CANNOT COMPUTE MATURITY DATE');
920: FND_MESSAGE.Set_Name('LNS', 'LNS_MATURITY_DATE_INVALID');
921: FND_MSG_PUB.Add;
922: RAISE FND_API.G_EXC_ERROR;
923: end if;
924:
925: -- Bug#6634845
2148:
2149: exception
2150: when others then
2151: FND_MESSAGE.Set_Name('LNS', 'LNS_CANNOT_DETERMINE_RATE');
2152: FND_MSG_PUB.Add;
2153: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, 'LNS_CANNOT_DETERMINE_RATE - END');
2154: --RAISE FND_API.G_EXC_ERROR;
2155: end;
2156: return l_active_rate;
2200: return l_rate;
2201:
2202: --exception when no_data_found then
2203: -- FND_MESSAGE.SET_NAME('LNS', 'LNS_RATES_ERROR');
2204: -- FND_MSG_PUB.ADD;
2205: end;
2206:
2207:
2208: /*=========================================================================
2698: END IF;
2699:
2700: -- Initialize message list if p_init_msg_list is set to TRUE
2701: IF FND_API.To_Boolean(p_init_msg_list) THEN
2702: FND_MSG_PUB.initialize;
2703: END IF;
2704:
2705: -- Initialize API return status to success
2706: l_return_status := FND_API.G_RET_STS_SUCCESS;
2714: if P_LOAN_ID is null then
2715: FND_MESSAGE.SET_NAME('LNS', 'LNS_INVALID_VALUE');
2716: FND_MESSAGE.SET_TOKEN('PARAMETER', 'LOAN_ID');
2717: FND_MESSAGE.SET_TOKEN('VALUE', P_LOAN_ID);
2718: FND_MSG_PUB.ADD;
2719: RAISE FND_API.G_EXC_ERROR;
2720: end if;
2721: if P_SCHEDULE_TYPE is null then
2722: FND_MESSAGE.SET_NAME('LNS', 'LNS_INVALID_VALUE');
2721: if P_SCHEDULE_TYPE is null then
2722: FND_MESSAGE.SET_NAME('LNS', 'LNS_INVALID_VALUE');
2723: FND_MESSAGE.SET_TOKEN('PARAMETER', 'P_SCHEDULE_TYPE');
2724: FND_MESSAGE.SET_TOKEN('VALUE', P_SCHEDULE_TYPE);
2725: FND_MSG_PUB.ADD;
2726: RAISE FND_API.G_EXC_ERROR;
2727: end if;
2728:
2729: /* init statement xml */
2751: x_msg_data => l_msg_data);
2752:
2753: LogMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'l_return_status: ' || l_return_status);
2754: IF l_return_status <> 'S' THEN
2755: LogMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'ERROR: ' || FND_MSG_PUB.Get(p_encoded => 'F'));
2756: RAISE FND_API.G_EXC_ERROR;
2757: END IF;
2758:
2759: LogMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'Building CLOB...');
2787: x_msg_data => l_msg_data);
2788:
2789: LogMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'l_return_status: ' || l_return_status);
2790: IF l_return_status <> 'S' THEN
2791: LogMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'ERROR: ' || FND_MSG_PUB.Get(p_encoded => 'F'));
2792: RAISE FND_API.G_EXC_ERROR;
2793: END IF;
2794:
2795: LogMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'Building CLOB...');
2819: -- END OF BODY OF API
2820: x_return_status := FND_API.G_RET_STS_SUCCESS;
2821:
2822: -- Standard call to get message count and if count is 1, get message info
2823: FND_MSG_PUB.Count_And_Get(
2824: p_encoded => FND_API.G_FALSE,
2825: p_count => x_msg_count,
2826: p_data => x_msg_data);
2827:
2830: EXCEPTION
2831: WHEN FND_API.G_EXC_ERROR THEN
2832: ROLLBACK TO getAmortSchedCSV;
2833: x_return_status := FND_API.G_RET_STS_ERROR;
2834: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
2835: LogMessage(FND_LOG.LEVEL_UNEXPECTED, G_PKG_NAME, 'Rollbacked');
2836: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2837: ROLLBACK TO getAmortSchedCSV;
2838: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2835: LogMessage(FND_LOG.LEVEL_UNEXPECTED, G_PKG_NAME, 'Rollbacked');
2836: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2837: ROLLBACK TO getAmortSchedCSV;
2838: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2839: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
2840: LogMessage(FND_LOG.LEVEL_UNEXPECTED, G_PKG_NAME, 'Rollbacked');
2841: WHEN OTHERS THEN
2842: ROLLBACK TO getAmortSchedCSV;
2843: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2840: LogMessage(FND_LOG.LEVEL_UNEXPECTED, G_PKG_NAME, 'Rollbacked');
2841: WHEN OTHERS THEN
2842: ROLLBACK TO getAmortSchedCSV;
2843: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2844: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
2845: LogMessage(FND_LOG.LEVEL_UNEXPECTED, G_PKG_NAME, 'Rollbacked');
2846: END;
2847:
2848: