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.LNS_FIN_UTILS dependencies on FND_API

Line 149: RAISE FND_API.G_EXC_ERROR;

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;
153:

Line 228: RAISE FND_API.G_EXC_ERROR;

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
232: FND_MESSAGE.Set_Name('LNS', 'LNS_NO_END_DATE');

Line 234: RAISE FND_API.G_EXC_ERROR;

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
238: FND_MESSAGE.Set_Name('LNS', 'LNS_NO_START_DATE');

Line 240: RAISE FND_API.G_EXC_ERROR;

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
244: FND_MESSAGE.Set_Name('LNS', 'LNS_NO_COUNT_METHOD');

Line 246: RAISE FND_API.G_EXC_ERROR;

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'));
250: l_month1 := to_number(to_char(p_start_date, 'MM'));

Line 402: RAISE FND_API.G_EXC_ERROR;

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);
406: return l_days_in_year;

Line 450: RAISE FND_API.G_EXC_ERROR;

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:
454: end isLeapYear;

Line 922: RAISE FND_API.G_EXC_ERROR;

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
926:

Line 2154: --RAISE FND_API.G_EXC_ERROR;

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;
2157:
2158: end getActiveRate;

Line 2696: IF NOT FND_API.Compatible_API_Call(l_api_version, p_api_version, l_api_name, G_PKG_NAME) THEN

2692: SAVEPOINT getAmortSchedCSV;
2693: LogMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'Savepoint is established');
2694:
2695: -- Standard call to check for call compatibility
2696: IF NOT FND_API.Compatible_API_Call(l_api_version, p_api_version, l_api_name, G_PKG_NAME) THEN
2697: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2698: END IF;
2699:
2700: -- Initialize message list if p_init_msg_list is set to TRUE

Line 2697: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2693: LogMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'Savepoint is established');
2694:
2695: -- Standard call to check for call compatibility
2696: IF NOT FND_API.Compatible_API_Call(l_api_version, p_api_version, l_api_name, G_PKG_NAME) THEN
2697: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
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

Line 2701: IF FND_API.To_Boolean(p_init_msg_list) THEN

2697: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
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

Line 2706: l_return_status := FND_API.G_RET_STS_SUCCESS;

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;
2707:
2708: -- START OF BODY OF API
2709: LogMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'Input:');
2710: LogMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'P_LOAN_ID: ' || P_LOAN_ID);

Line 2719: RAISE FND_API.G_EXC_ERROR;

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');
2723: FND_MESSAGE.SET_TOKEN('PARAMETER', 'P_SCHEDULE_TYPE');

Line 2726: RAISE FND_API.G_EXC_ERROR;

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 */
2730: DBMS_LOB.createtemporary(X_CSV_CLOB, FALSE, DBMS_LOB.CALL);

Line 2744: P_INIT_MSG_LIST => FND_API.G_TRUE,

2740:
2741: LogMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'Calling LNS_FINANCIALS.runAmortization...');
2742: LNS_FINANCIALS.runAmortization(
2743: P_API_VERSION => 1.0,
2744: P_INIT_MSG_LIST => FND_API.G_TRUE,
2745: P_COMMIT => FND_API.G_FALSE,
2746: P_LOAN_ID => P_LOAN_ID,
2747: P_BASED_ON_TERMS => P_SCHEDULE_TYPE,
2748: x_amort_tbl => l_amort_tbl,

Line 2745: P_COMMIT => FND_API.G_FALSE,

2741: LogMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'Calling LNS_FINANCIALS.runAmortization...');
2742: LNS_FINANCIALS.runAmortization(
2743: P_API_VERSION => 1.0,
2744: P_INIT_MSG_LIST => FND_API.G_TRUE,
2745: P_COMMIT => FND_API.G_FALSE,
2746: P_LOAN_ID => P_LOAN_ID,
2747: P_BASED_ON_TERMS => P_SCHEDULE_TYPE,
2748: x_amort_tbl => l_amort_tbl,
2749: x_return_status => l_return_status,

Line 2756: RAISE FND_API.G_EXC_ERROR;

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...');
2760: FOR i IN 1 .. l_amort_tbl.count LOOP

Line 2780: P_INIT_MSG_LIST => FND_API.G_TRUE,

2776:
2777: LogMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'Calling LNS_CUSTOM_PUB.getRetainedSchedule...');
2778: LNS_CUSTOM_PUB.getRetainedSchedule(
2779: P_API_VERSION => 1.0,
2780: P_INIT_MSG_LIST => FND_API.G_TRUE,
2781: P_COMMIT => FND_API.G_FALSE,
2782: P_VALIDATION_LEVEL => FND_API.G_VALID_LEVEL_FULL,
2783: X_CUSTOM_SET_REC => l_CUSTOM_SET_REC,
2784: X_CUSTOM_TBL => l_custom_tbl,

Line 2781: P_COMMIT => FND_API.G_FALSE,

2777: LogMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'Calling LNS_CUSTOM_PUB.getRetainedSchedule...');
2778: LNS_CUSTOM_PUB.getRetainedSchedule(
2779: P_API_VERSION => 1.0,
2780: P_INIT_MSG_LIST => FND_API.G_TRUE,
2781: P_COMMIT => FND_API.G_FALSE,
2782: P_VALIDATION_LEVEL => FND_API.G_VALID_LEVEL_FULL,
2783: X_CUSTOM_SET_REC => l_CUSTOM_SET_REC,
2784: X_CUSTOM_TBL => l_custom_tbl,
2785: x_return_status => l_return_status,

Line 2782: P_VALIDATION_LEVEL => FND_API.G_VALID_LEVEL_FULL,

2778: LNS_CUSTOM_PUB.getRetainedSchedule(
2779: P_API_VERSION => 1.0,
2780: P_INIT_MSG_LIST => FND_API.G_TRUE,
2781: P_COMMIT => FND_API.G_FALSE,
2782: P_VALIDATION_LEVEL => FND_API.G_VALID_LEVEL_FULL,
2783: X_CUSTOM_SET_REC => l_CUSTOM_SET_REC,
2784: X_CUSTOM_TBL => l_custom_tbl,
2785: x_return_status => l_return_status,
2786: x_msg_count => l_msg_count,

Line 2792: RAISE FND_API.G_EXC_ERROR;

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...');
2796: FOR i IN 1 .. l_custom_tbl.count LOOP

Line 2814: if P_COMMIT = FND_API.G_TRUE then

2810:
2811: end if;
2812:
2813: -- END OF BODY OF API
2814: if P_COMMIT = FND_API.G_TRUE then
2815: COMMIT WORK;
2816: LogMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'Commited');
2817: end if;
2818:

Line 2820: x_return_status := FND_API.G_RET_STS_SUCCESS;

2816: LogMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'Commited');
2817: end if;
2818:
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,

Line 2824: p_encoded => FND_API.G_FALSE,

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:
2828: LogMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, G_PKG_NAME || '.' || l_api_name || ' -');

Line 2831: WHEN FND_API.G_EXC_ERROR THEN

2827:
2828: LogMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, G_PKG_NAME || '.' || l_api_name || ' -');
2829:
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');

Line 2833: x_return_status := FND_API.G_RET_STS_ERROR;

2829:
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;

Line 2836: WHEN FND_API.G_EXC_UNEXPECTED_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;
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');

Line 2838: x_return_status := FND_API.G_RET_STS_UNEXP_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;
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;

Line 2843: 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;
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: