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_INDEX_RATES_PUB dependencies on FND_LOG

Line 90: if (p_msg_level >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then

86: *=======================================================================*/
87: Procedure LogMessage(p_msg_level IN NUMBER, p_msg in varchar2)
88: IS
89: BEGIN
90: if (p_msg_level >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
91:
92: FND_LOG.STRING(p_msg_level, G_PKG_NAME, p_msg);
93:
94: end if;

Line 92: FND_LOG.STRING(p_msg_level, G_PKG_NAME, p_msg);

88: IS
89: BEGIN
90: if (p_msg_level >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
91:
92: FND_LOG.STRING(p_msg_level, G_PKG_NAME, p_msg);
93:
94: end if;
95:
96: if (FND_GLOBAL.Conc_Request_Id is not null) then

Line 102: if (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then

98: end if;
99:
100: EXCEPTION
101: WHEN OTHERS THEN
102: if (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
103: FND_LOG.STRING(FND_LOG.LEVEL_UNEXPECTED, G_PKG_NAME, 'ERROR in LogMessage while logging '|| p_msg || ' : ' || sqlerrm);
104: end if;
105: END;
106:

Line 103: FND_LOG.STRING(FND_LOG.LEVEL_UNEXPECTED, G_PKG_NAME, 'ERROR in LogMessage while logging '|| p_msg || ' : ' || sqlerrm);

99:
100: EXCEPTION
101: WHEN OTHERS THEN
102: if (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
103: FND_LOG.STRING(FND_LOG.LEVEL_UNEXPECTED, G_PKG_NAME, 'ERROR in LogMessage while logging '|| p_msg || ' : ' || sqlerrm);
104: end if;
105: END;
106:
107:

Line 136: logMessage(FND_LOG.LEVEL_STATEMENT, 'Date ' || p_date || ' = payment ' || l_pay_num);

132: end if;
133: end loop;
134: end if;
135:
136: logMessage(FND_LOG.LEVEL_STATEMENT, 'Date ' || p_date || ' = payment ' || l_pay_num);
137: return l_pay_num;
138:
139: end;
140:

Line 164: -- logMessage(FND_LOG.LEVEL_STATEMENT, p_target || ' of installment ' || p_installment || ' = ' || l_return_date);

160: exit;
161: end if;
162: end loop;
163:
164: -- logMessage(FND_LOG.LEVEL_STATEMENT, p_target || ' of installment ' || p_installment || ' = ' || l_return_date);
165: return l_return_date;
166:
167: end;
168:

Line 195: logMessage(FND_LOG.LEVEL_PROCEDURE, l_api_name || ' +');

191: ';
192:
193: begin
194:
195: logMessage(FND_LOG.LEVEL_PROCEDURE, l_api_name || ' +');
196:
197: logMessage(FND_LOG.LEVEL_STATEMENT, 'Input parameters:');
198: logMessage(FND_LOG.LEVEL_STATEMENT, 'p_initial_rate = ' || p_initial_rate);
199: logMessage(FND_LOG.LEVEL_STATEMENT, 'p_last_period_rate = ' || p_last_period_rate);

Line 197: logMessage(FND_LOG.LEVEL_STATEMENT, 'Input parameters:');

193: begin
194:
195: logMessage(FND_LOG.LEVEL_PROCEDURE, l_api_name || ' +');
196:
197: logMessage(FND_LOG.LEVEL_STATEMENT, 'Input parameters:');
198: logMessage(FND_LOG.LEVEL_STATEMENT, 'p_initial_rate = ' || p_initial_rate);
199: logMessage(FND_LOG.LEVEL_STATEMENT, 'p_last_period_rate = ' || p_last_period_rate);
200: logMessage(FND_LOG.LEVEL_STATEMENT, 'p_max_period_adjustment = ' || p_max_period_adjustment);
201: logMessage(FND_LOG.LEVEL_STATEMENT, 'p_max_lifetime_adjustment = ' || p_max_lifetime_adjustment);

Line 198: logMessage(FND_LOG.LEVEL_STATEMENT, 'p_initial_rate = ' || p_initial_rate);

194:
195: logMessage(FND_LOG.LEVEL_PROCEDURE, l_api_name || ' +');
196:
197: logMessage(FND_LOG.LEVEL_STATEMENT, 'Input parameters:');
198: logMessage(FND_LOG.LEVEL_STATEMENT, 'p_initial_rate = ' || p_initial_rate);
199: logMessage(FND_LOG.LEVEL_STATEMENT, 'p_last_period_rate = ' || p_last_period_rate);
200: logMessage(FND_LOG.LEVEL_STATEMENT, 'p_max_period_adjustment = ' || p_max_period_adjustment);
201: logMessage(FND_LOG.LEVEL_STATEMENT, 'p_max_lifetime_adjustment = ' || p_max_lifetime_adjustment);
202: logMessage(FND_LOG.LEVEL_STATEMENT, 'p_ceiling_rate = ' || p_ceiling_rate);

Line 199: logMessage(FND_LOG.LEVEL_STATEMENT, 'p_last_period_rate = ' || p_last_period_rate);

195: logMessage(FND_LOG.LEVEL_PROCEDURE, l_api_name || ' +');
196:
197: logMessage(FND_LOG.LEVEL_STATEMENT, 'Input parameters:');
198: logMessage(FND_LOG.LEVEL_STATEMENT, 'p_initial_rate = ' || p_initial_rate);
199: logMessage(FND_LOG.LEVEL_STATEMENT, 'p_last_period_rate = ' || p_last_period_rate);
200: logMessage(FND_LOG.LEVEL_STATEMENT, 'p_max_period_adjustment = ' || p_max_period_adjustment);
201: logMessage(FND_LOG.LEVEL_STATEMENT, 'p_max_lifetime_adjustment = ' || p_max_lifetime_adjustment);
202: logMessage(FND_LOG.LEVEL_STATEMENT, 'p_ceiling_rate = ' || p_ceiling_rate);
203: logMessage(FND_LOG.LEVEL_STATEMENT, 'p_floor_rate = ' || p_floor_rate);

Line 200: logMessage(FND_LOG.LEVEL_STATEMENT, 'p_max_period_adjustment = ' || p_max_period_adjustment);

196:
197: logMessage(FND_LOG.LEVEL_STATEMENT, 'Input parameters:');
198: logMessage(FND_LOG.LEVEL_STATEMENT, 'p_initial_rate = ' || p_initial_rate);
199: logMessage(FND_LOG.LEVEL_STATEMENT, 'p_last_period_rate = ' || p_last_period_rate);
200: logMessage(FND_LOG.LEVEL_STATEMENT, 'p_max_period_adjustment = ' || p_max_period_adjustment);
201: logMessage(FND_LOG.LEVEL_STATEMENT, 'p_max_lifetime_adjustment = ' || p_max_lifetime_adjustment);
202: logMessage(FND_LOG.LEVEL_STATEMENT, 'p_ceiling_rate = ' || p_ceiling_rate);
203: logMessage(FND_LOG.LEVEL_STATEMENT, 'p_floor_rate = ' || p_floor_rate);
204: logMessage(FND_LOG.LEVEL_STATEMENT, 'x_interest_rate = ' || x_interest_rate);

Line 201: logMessage(FND_LOG.LEVEL_STATEMENT, 'p_max_lifetime_adjustment = ' || p_max_lifetime_adjustment);

197: logMessage(FND_LOG.LEVEL_STATEMENT, 'Input parameters:');
198: logMessage(FND_LOG.LEVEL_STATEMENT, 'p_initial_rate = ' || p_initial_rate);
199: logMessage(FND_LOG.LEVEL_STATEMENT, 'p_last_period_rate = ' || p_last_period_rate);
200: logMessage(FND_LOG.LEVEL_STATEMENT, 'p_max_period_adjustment = ' || p_max_period_adjustment);
201: logMessage(FND_LOG.LEVEL_STATEMENT, 'p_max_lifetime_adjustment = ' || p_max_lifetime_adjustment);
202: logMessage(FND_LOG.LEVEL_STATEMENT, 'p_ceiling_rate = ' || p_ceiling_rate);
203: logMessage(FND_LOG.LEVEL_STATEMENT, 'p_floor_rate = ' || p_floor_rate);
204: logMessage(FND_LOG.LEVEL_STATEMENT, 'x_interest_rate = ' || x_interest_rate);
205:

Line 202: logMessage(FND_LOG.LEVEL_STATEMENT, 'p_ceiling_rate = ' || p_ceiling_rate);

198: logMessage(FND_LOG.LEVEL_STATEMENT, 'p_initial_rate = ' || p_initial_rate);
199: logMessage(FND_LOG.LEVEL_STATEMENT, 'p_last_period_rate = ' || p_last_period_rate);
200: logMessage(FND_LOG.LEVEL_STATEMENT, 'p_max_period_adjustment = ' || p_max_period_adjustment);
201: logMessage(FND_LOG.LEVEL_STATEMENT, 'p_max_lifetime_adjustment = ' || p_max_lifetime_adjustment);
202: logMessage(FND_LOG.LEVEL_STATEMENT, 'p_ceiling_rate = ' || p_ceiling_rate);
203: logMessage(FND_LOG.LEVEL_STATEMENT, 'p_floor_rate = ' || p_floor_rate);
204: logMessage(FND_LOG.LEVEL_STATEMENT, 'x_interest_rate = ' || x_interest_rate);
205:
206: -- need to check for NULLs

Line 203: logMessage(FND_LOG.LEVEL_STATEMENT, 'p_floor_rate = ' || p_floor_rate);

199: logMessage(FND_LOG.LEVEL_STATEMENT, 'p_last_period_rate = ' || p_last_period_rate);
200: logMessage(FND_LOG.LEVEL_STATEMENT, 'p_max_period_adjustment = ' || p_max_period_adjustment);
201: logMessage(FND_LOG.LEVEL_STATEMENT, 'p_max_lifetime_adjustment = ' || p_max_lifetime_adjustment);
202: logMessage(FND_LOG.LEVEL_STATEMENT, 'p_ceiling_rate = ' || p_ceiling_rate);
203: logMessage(FND_LOG.LEVEL_STATEMENT, 'p_floor_rate = ' || p_floor_rate);
204: logMessage(FND_LOG.LEVEL_STATEMENT, 'x_interest_rate = ' || x_interest_rate);
205:
206: -- need to check for NULLs
207: l_sign1 := 1;

Line 204: logMessage(FND_LOG.LEVEL_STATEMENT, 'x_interest_rate = ' || x_interest_rate);

200: logMessage(FND_LOG.LEVEL_STATEMENT, 'p_max_period_adjustment = ' || p_max_period_adjustment);
201: logMessage(FND_LOG.LEVEL_STATEMENT, 'p_max_lifetime_adjustment = ' || p_max_lifetime_adjustment);
202: logMessage(FND_LOG.LEVEL_STATEMENT, 'p_ceiling_rate = ' || p_ceiling_rate);
203: logMessage(FND_LOG.LEVEL_STATEMENT, 'p_floor_rate = ' || p_floor_rate);
204: logMessage(FND_LOG.LEVEL_STATEMENT, 'x_interest_rate = ' || x_interest_rate);
205:
206: -- need to check for NULLs
207: l_sign1 := 1;
208: l_sign2 := 1;

Line 213: logMessage(FND_LOG.LEVEL_STATEMENT, 'l_rate_diff = ' || l_rate_diff);

209:
210: l_new_rate := x_interest_rate;
211:
212: l_rate_diff := ABS(l_new_rate - p_last_period_rate);
213: logMessage(FND_LOG.LEVEL_STATEMENT, 'l_rate_diff = ' || l_rate_diff);
214:
215: -- rate differentials go both ways
216: if l_new_rate < p_last_period_rate then
217: l_sign1 := -1;

Line 223: logMessage(FND_LOG.LEVEL_STATEMENT, 'l_new_rate = ' || l_new_rate);

219:
220: if p_max_period_adjustment is not null and l_rate_diff > p_max_period_adjustment then
221: l_new_rate1 := l_new_rate;
222: l_new_rate := p_last_period_rate + (p_max_period_adjustment * l_sign1);
223: logMessage(FND_LOG.LEVEL_STATEMENT, 'l_new_rate = ' || l_new_rate);
224: l_adjustment_reason :=
225: 'Difference between previous period rate ' || p_last_period_rate ||
226: '% and new rate ' || l_new_rate1 || '% is greater than max period adjustment differential of ' || p_max_period_adjustment ||
227: '%. Adjusting new rate to ' || l_new_rate || '%.';

Line 228: logMessage(FND_LOG.LEVEL_STATEMENT, l_adjustment_reason);

224: l_adjustment_reason :=
225: 'Difference between previous period rate ' || p_last_period_rate ||
226: '% and new rate ' || l_new_rate1 || '% is greater than max period adjustment differential of ' || p_max_period_adjustment ||
227: '%. Adjusting new rate to ' || l_new_rate || '%.';
228: logMessage(FND_LOG.LEVEL_STATEMENT, l_adjustment_reason);
229: end if;
230:
231: l_life_rate_diff := ABS(l_new_rate - p_initial_rate);
232: logMessage(FND_LOG.LEVEL_STATEMENT, 'l_life_rate_diff = ' || l_life_rate_diff);

Line 232: logMessage(FND_LOG.LEVEL_STATEMENT, 'l_life_rate_diff = ' || l_life_rate_diff);

228: logMessage(FND_LOG.LEVEL_STATEMENT, l_adjustment_reason);
229: end if;
230:
231: l_life_rate_diff := ABS(l_new_rate - p_initial_rate);
232: logMessage(FND_LOG.LEVEL_STATEMENT, 'l_life_rate_diff = ' || l_life_rate_diff);
233:
234: -- rate differentials go both ways
235: if l_new_rate < p_initial_rate then
236: l_sign2 := -1;

Line 242: logMessage(FND_LOG.LEVEL_STATEMENT, 'l_new_rate = ' || l_new_rate);

238:
239: if p_max_lifetime_adjustment is not null and l_life_rate_diff > p_max_lifetime_adjustment then
240: l_new_rate1 := l_new_rate;
241: l_new_rate := p_initial_rate + (p_max_lifetime_adjustment * l_sign2);
242: logMessage(FND_LOG.LEVEL_STATEMENT, 'l_new_rate = ' || l_new_rate);
243:
244: if l_adjustment_reason is not null then
245: l_adjustment_reason := l_adjustment_reason || l_new_line;
246: end if;

Line 251: logMessage(FND_LOG.LEVEL_STATEMENT, l_adjustment_reason);

247: l_adjustment_reason := l_adjustment_reason ||
248: 'Difference between initial rate ' || p_initial_rate ||
249: '% and new rate ' || l_new_rate1 || '% is greater than life adjustment differential of ' || p_max_lifetime_adjustment ||
250: '. Adjusting new rate to ' || l_new_rate || '%.';
251: logMessage(FND_LOG.LEVEL_STATEMENT, l_adjustment_reason);
252: end if;
253:
254: if p_floor_rate is not null and l_new_rate < p_floor_rate then
255: l_new_rate1 := l_new_rate;

Line 257: logMessage(FND_LOG.LEVEL_STATEMENT, 'l_new_rate = ' || l_new_rate);

253:
254: if p_floor_rate is not null and l_new_rate < p_floor_rate then
255: l_new_rate1 := l_new_rate;
256: l_new_rate := p_floor_rate;
257: logMessage(FND_LOG.LEVEL_STATEMENT, 'l_new_rate = ' || l_new_rate);
258:
259: if l_adjustment_reason is not null then
260: l_adjustment_reason := l_adjustment_reason || l_new_line;
261: end if;

Line 265: logMessage(FND_LOG.LEVEL_STATEMENT, l_adjustment_reason);

261: end if;
262: l_adjustment_reason := l_adjustment_reason ||
263: 'New rate ' || l_new_rate1 || '% is below floor of ' || p_floor_rate ||
264: '. Adjusting new rate to ' || l_new_rate || '%.';
265: logMessage(FND_LOG.LEVEL_STATEMENT, l_adjustment_reason);
266: end if;
267:
268: if p_ceiling_rate is not null and l_new_rate > p_ceiling_rate then
269: l_new_rate1 := l_new_rate;

Line 271: logMessage(FND_LOG.LEVEL_STATEMENT, 'l_new_rate = ' || l_new_rate);

267:
268: if p_ceiling_rate is not null and l_new_rate > p_ceiling_rate then
269: l_new_rate1 := l_new_rate;
270: l_new_rate := p_ceiling_rate;
271: logMessage(FND_LOG.LEVEL_STATEMENT, 'l_new_rate = ' || l_new_rate);
272:
273: if l_adjustment_reason is not null then
274: l_adjustment_reason := l_adjustment_reason || l_new_line;
275: end if;

Line 279: logMessage(FND_LOG.LEVEL_STATEMENT, l_adjustment_reason);

275: end if;
276: l_adjustment_reason := l_adjustment_reason ||
277: 'New rate ' || l_new_rate1 || '% is above ceiling of ' || p_ceiling_rate ||
278: '. Adjusting new rate to ' || l_new_rate || '%.';
279: logMessage(FND_LOG.LEVEL_STATEMENT, l_adjustment_reason);
280: end if;
281:
282: logMessage(FND_LOG.LEVEL_PROCEDURE, 'l_new_rate = ' || l_new_rate);
283: logMessage(FND_LOG.LEVEL_PROCEDURE, l_api_name || ' -');

Line 282: logMessage(FND_LOG.LEVEL_PROCEDURE, 'l_new_rate = ' || l_new_rate);

278: '. Adjusting new rate to ' || l_new_rate || '%.';
279: logMessage(FND_LOG.LEVEL_STATEMENT, l_adjustment_reason);
280: end if;
281:
282: logMessage(FND_LOG.LEVEL_PROCEDURE, 'l_new_rate = ' || l_new_rate);
283: logMessage(FND_LOG.LEVEL_PROCEDURE, l_api_name || ' -');
284:
285: x_interest_rate := l_new_rate;
286: x_adjustment_reason := l_adjustment_reason;

Line 283: logMessage(FND_LOG.LEVEL_PROCEDURE, l_api_name || ' -');

279: logMessage(FND_LOG.LEVEL_STATEMENT, l_adjustment_reason);
280: end if;
281:
282: logMessage(FND_LOG.LEVEL_PROCEDURE, 'l_new_rate = ' || l_new_rate);
283: logMessage(FND_LOG.LEVEL_PROCEDURE, l_api_name || ' -');
284:
285: x_interest_rate := l_new_rate;
286: x_adjustment_reason := l_adjustment_reason;
287:

Line 364: LogMessage(FND_LOG.level_unexpected, ' ');

360: AND PHASE = p_phase
361: order by begin_installment_number;
362:
363: BEGIN
364: LogMessage(FND_LOG.level_unexpected, ' ');
365: LogMessage(FND_LOG.LEVEL_PROCEDURE, l_api_name || ' +');
366:
367: -- Standard start of API savepoint
368: SAVEPOINT PROCESS_SINGLE_LOAN;

Line 365: LogMessage(FND_LOG.LEVEL_PROCEDURE, l_api_name || ' +');

361: order by begin_installment_number;
362:
363: BEGIN
364: LogMessage(FND_LOG.level_unexpected, ' ');
365: LogMessage(FND_LOG.LEVEL_PROCEDURE, l_api_name || ' +');
366:
367: -- Standard start of API savepoint
368: SAVEPOINT PROCESS_SINGLE_LOAN;
369: LogMessage(FND_LOG.LEVEL_STATEMENT, 'Established savepoint');

Line 369: LogMessage(FND_LOG.LEVEL_STATEMENT, 'Established savepoint');

365: LogMessage(FND_LOG.LEVEL_PROCEDURE, l_api_name || ' +');
366:
367: -- Standard start of API savepoint
368: SAVEPOINT PROCESS_SINGLE_LOAN;
369: LogMessage(FND_LOG.LEVEL_STATEMENT, 'Established savepoint');
370:
371: -- Standard call to check for call compatibility
372: IF NOT FND_API.Compatible_API_Call(l_api_version, p_api_version, l_api_name, G_PKG_NAME) THEN
373: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 390: LogMessage(FND_LOG.level_unexpected, 'Processing loan ' || P_LOAN_REC.LOAN_NUMBER);

386: -- init
387: l_RATE_LINES_TBL := P_RATE_LINES_TBL;
388: l_rates_count := l_RATE_LINES_TBL.count;
389:
390: LogMessage(FND_LOG.level_unexpected, 'Processing loan ' || P_LOAN_REC.LOAN_NUMBER);
391: LogMessage(FND_LOG.level_unexpected, 'loan_id = ' || P_LOAN_REC.LOAN_ID);
392: LogMessage(FND_LOG.level_unexpected, 'term_id = ' || P_LOAN_REC.TERM_ID);
393: LogMessage(FND_LOG.level_unexpected, 'last_billed_installment = ' || P_LOAN_REC.LAST_BILLED_INSTALLMENT);
394: LogMessage(FND_LOG.level_unexpected, 'loan_status = ' || P_LOAN_REC.LOAN_STATUS);

Line 391: LogMessage(FND_LOG.level_unexpected, 'loan_id = ' || P_LOAN_REC.LOAN_ID);

387: l_RATE_LINES_TBL := P_RATE_LINES_TBL;
388: l_rates_count := l_RATE_LINES_TBL.count;
389:
390: LogMessage(FND_LOG.level_unexpected, 'Processing loan ' || P_LOAN_REC.LOAN_NUMBER);
391: LogMessage(FND_LOG.level_unexpected, 'loan_id = ' || P_LOAN_REC.LOAN_ID);
392: LogMessage(FND_LOG.level_unexpected, 'term_id = ' || P_LOAN_REC.TERM_ID);
393: LogMessage(FND_LOG.level_unexpected, 'last_billed_installment = ' || P_LOAN_REC.LAST_BILLED_INSTALLMENT);
394: LogMessage(FND_LOG.level_unexpected, 'loan_status = ' || P_LOAN_REC.LOAN_STATUS);
395: LogMessage(FND_LOG.level_unexpected, 'CURRENT_PHASE = ' || P_LOAN_REC.CURRENT_PHASE);

Line 392: LogMessage(FND_LOG.level_unexpected, 'term_id = ' || P_LOAN_REC.TERM_ID);

388: l_rates_count := l_RATE_LINES_TBL.count;
389:
390: LogMessage(FND_LOG.level_unexpected, 'Processing loan ' || P_LOAN_REC.LOAN_NUMBER);
391: LogMessage(FND_LOG.level_unexpected, 'loan_id = ' || P_LOAN_REC.LOAN_ID);
392: LogMessage(FND_LOG.level_unexpected, 'term_id = ' || P_LOAN_REC.TERM_ID);
393: LogMessage(FND_LOG.level_unexpected, 'last_billed_installment = ' || P_LOAN_REC.LAST_BILLED_INSTALLMENT);
394: LogMessage(FND_LOG.level_unexpected, 'loan_status = ' || P_LOAN_REC.LOAN_STATUS);
395: LogMessage(FND_LOG.level_unexpected, 'CURRENT_PHASE = ' || P_LOAN_REC.CURRENT_PHASE);
396: LogMessage(FND_LOG.level_unexpected, 'percent_increase = ' || P_LOAN_REC.percent_increase);

Line 393: LogMessage(FND_LOG.level_unexpected, 'last_billed_installment = ' || P_LOAN_REC.LAST_BILLED_INSTALLMENT);

389:
390: LogMessage(FND_LOG.level_unexpected, 'Processing loan ' || P_LOAN_REC.LOAN_NUMBER);
391: LogMessage(FND_LOG.level_unexpected, 'loan_id = ' || P_LOAN_REC.LOAN_ID);
392: LogMessage(FND_LOG.level_unexpected, 'term_id = ' || P_LOAN_REC.TERM_ID);
393: LogMessage(FND_LOG.level_unexpected, 'last_billed_installment = ' || P_LOAN_REC.LAST_BILLED_INSTALLMENT);
394: LogMessage(FND_LOG.level_unexpected, 'loan_status = ' || P_LOAN_REC.LOAN_STATUS);
395: LogMessage(FND_LOG.level_unexpected, 'CURRENT_PHASE = ' || P_LOAN_REC.CURRENT_PHASE);
396: LogMessage(FND_LOG.level_unexpected, 'percent_increase = ' || P_LOAN_REC.percent_increase);
397: LogMessage(FND_LOG.level_unexpected, 'percent_increase_life = ' || P_LOAN_REC.percent_increase_life);

Line 394: LogMessage(FND_LOG.level_unexpected, 'loan_status = ' || P_LOAN_REC.LOAN_STATUS);

390: LogMessage(FND_LOG.level_unexpected, 'Processing loan ' || P_LOAN_REC.LOAN_NUMBER);
391: LogMessage(FND_LOG.level_unexpected, 'loan_id = ' || P_LOAN_REC.LOAN_ID);
392: LogMessage(FND_LOG.level_unexpected, 'term_id = ' || P_LOAN_REC.TERM_ID);
393: LogMessage(FND_LOG.level_unexpected, 'last_billed_installment = ' || P_LOAN_REC.LAST_BILLED_INSTALLMENT);
394: LogMessage(FND_LOG.level_unexpected, 'loan_status = ' || P_LOAN_REC.LOAN_STATUS);
395: LogMessage(FND_LOG.level_unexpected, 'CURRENT_PHASE = ' || P_LOAN_REC.CURRENT_PHASE);
396: LogMessage(FND_LOG.level_unexpected, 'percent_increase = ' || P_LOAN_REC.percent_increase);
397: LogMessage(FND_LOG.level_unexpected, 'percent_increase_life = ' || P_LOAN_REC.percent_increase_life);
398: LogMessage(FND_LOG.level_unexpected, 'floor_rate = ' || P_LOAN_REC.floor_rate);

Line 395: LogMessage(FND_LOG.level_unexpected, 'CURRENT_PHASE = ' || P_LOAN_REC.CURRENT_PHASE);

391: LogMessage(FND_LOG.level_unexpected, 'loan_id = ' || P_LOAN_REC.LOAN_ID);
392: LogMessage(FND_LOG.level_unexpected, 'term_id = ' || P_LOAN_REC.TERM_ID);
393: LogMessage(FND_LOG.level_unexpected, 'last_billed_installment = ' || P_LOAN_REC.LAST_BILLED_INSTALLMENT);
394: LogMessage(FND_LOG.level_unexpected, 'loan_status = ' || P_LOAN_REC.LOAN_STATUS);
395: LogMessage(FND_LOG.level_unexpected, 'CURRENT_PHASE = ' || P_LOAN_REC.CURRENT_PHASE);
396: LogMessage(FND_LOG.level_unexpected, 'percent_increase = ' || P_LOAN_REC.percent_increase);
397: LogMessage(FND_LOG.level_unexpected, 'percent_increase_life = ' || P_LOAN_REC.percent_increase_life);
398: LogMessage(FND_LOG.level_unexpected, 'floor_rate = ' || P_LOAN_REC.floor_rate);
399: LogMessage(FND_LOG.level_unexpected, 'ceiling_rate = ' || P_LOAN_REC.ceiling_rate);

Line 396: LogMessage(FND_LOG.level_unexpected, 'percent_increase = ' || P_LOAN_REC.percent_increase);

392: LogMessage(FND_LOG.level_unexpected, 'term_id = ' || P_LOAN_REC.TERM_ID);
393: LogMessage(FND_LOG.level_unexpected, 'last_billed_installment = ' || P_LOAN_REC.LAST_BILLED_INSTALLMENT);
394: LogMessage(FND_LOG.level_unexpected, 'loan_status = ' || P_LOAN_REC.LOAN_STATUS);
395: LogMessage(FND_LOG.level_unexpected, 'CURRENT_PHASE = ' || P_LOAN_REC.CURRENT_PHASE);
396: LogMessage(FND_LOG.level_unexpected, 'percent_increase = ' || P_LOAN_REC.percent_increase);
397: LogMessage(FND_LOG.level_unexpected, 'percent_increase_life = ' || P_LOAN_REC.percent_increase_life);
398: LogMessage(FND_LOG.level_unexpected, 'floor_rate = ' || P_LOAN_REC.floor_rate);
399: LogMessage(FND_LOG.level_unexpected, 'ceiling_rate = ' || P_LOAN_REC.ceiling_rate);
400:

Line 397: LogMessage(FND_LOG.level_unexpected, 'percent_increase_life = ' || P_LOAN_REC.percent_increase_life);

393: LogMessage(FND_LOG.level_unexpected, 'last_billed_installment = ' || P_LOAN_REC.LAST_BILLED_INSTALLMENT);
394: LogMessage(FND_LOG.level_unexpected, 'loan_status = ' || P_LOAN_REC.LOAN_STATUS);
395: LogMessage(FND_LOG.level_unexpected, 'CURRENT_PHASE = ' || P_LOAN_REC.CURRENT_PHASE);
396: LogMessage(FND_LOG.level_unexpected, 'percent_increase = ' || P_LOAN_REC.percent_increase);
397: LogMessage(FND_LOG.level_unexpected, 'percent_increase_life = ' || P_LOAN_REC.percent_increase_life);
398: LogMessage(FND_LOG.level_unexpected, 'floor_rate = ' || P_LOAN_REC.floor_rate);
399: LogMessage(FND_LOG.level_unexpected, 'ceiling_rate = ' || P_LOAN_REC.ceiling_rate);
400:
401: l_start_from_installment := P_LOAN_REC.LAST_BILLED_INSTALLMENT + 1;

Line 398: LogMessage(FND_LOG.level_unexpected, 'floor_rate = ' || P_LOAN_REC.floor_rate);

394: LogMessage(FND_LOG.level_unexpected, 'loan_status = ' || P_LOAN_REC.LOAN_STATUS);
395: LogMessage(FND_LOG.level_unexpected, 'CURRENT_PHASE = ' || P_LOAN_REC.CURRENT_PHASE);
396: LogMessage(FND_LOG.level_unexpected, 'percent_increase = ' || P_LOAN_REC.percent_increase);
397: LogMessage(FND_LOG.level_unexpected, 'percent_increase_life = ' || P_LOAN_REC.percent_increase_life);
398: LogMessage(FND_LOG.level_unexpected, 'floor_rate = ' || P_LOAN_REC.floor_rate);
399: LogMessage(FND_LOG.level_unexpected, 'ceiling_rate = ' || P_LOAN_REC.ceiling_rate);
400:
401: l_start_from_installment := P_LOAN_REC.LAST_BILLED_INSTALLMENT + 1;
402: LogMessage(FND_LOG.level_unexpected, 'l_start_from_installment = ' || l_start_from_installment);

Line 399: LogMessage(FND_LOG.level_unexpected, 'ceiling_rate = ' || P_LOAN_REC.ceiling_rate);

395: LogMessage(FND_LOG.level_unexpected, 'CURRENT_PHASE = ' || P_LOAN_REC.CURRENT_PHASE);
396: LogMessage(FND_LOG.level_unexpected, 'percent_increase = ' || P_LOAN_REC.percent_increase);
397: LogMessage(FND_LOG.level_unexpected, 'percent_increase_life = ' || P_LOAN_REC.percent_increase_life);
398: LogMessage(FND_LOG.level_unexpected, 'floor_rate = ' || P_LOAN_REC.floor_rate);
399: LogMessage(FND_LOG.level_unexpected, 'ceiling_rate = ' || P_LOAN_REC.ceiling_rate);
400:
401: l_start_from_installment := P_LOAN_REC.LAST_BILLED_INSTALLMENT + 1;
402: LogMessage(FND_LOG.level_unexpected, 'l_start_from_installment = ' || l_start_from_installment);
403:

Line 402: LogMessage(FND_LOG.level_unexpected, 'l_start_from_installment = ' || l_start_from_installment);

398: LogMessage(FND_LOG.level_unexpected, 'floor_rate = ' || P_LOAN_REC.floor_rate);
399: LogMessage(FND_LOG.level_unexpected, 'ceiling_rate = ' || P_LOAN_REC.ceiling_rate);
400:
401: l_start_from_installment := P_LOAN_REC.LAST_BILLED_INSTALLMENT + 1;
402: LogMessage(FND_LOG.level_unexpected, 'l_start_from_installment = ' || l_start_from_installment);
403:
404: LogMessage(FND_LOG.LEVEL_STATEMENT, 'Calling LNS_FIN_UTILS.buildPaymentScheduleExt...');
405: l_pay_schedule := LNS_FIN_UTILS.buildPaymentScheduleExt(P_LOAN_REC.LOAN_ID, P_LOAN_REC.CURRENT_PHASE);
406:

Line 404: LogMessage(FND_LOG.LEVEL_STATEMENT, 'Calling LNS_FIN_UTILS.buildPaymentScheduleExt...');

400:
401: l_start_from_installment := P_LOAN_REC.LAST_BILLED_INSTALLMENT + 1;
402: LogMessage(FND_LOG.level_unexpected, 'l_start_from_installment = ' || l_start_from_installment);
403:
404: LogMessage(FND_LOG.LEVEL_STATEMENT, 'Calling LNS_FIN_UTILS.buildPaymentScheduleExt...');
405: l_pay_schedule := LNS_FIN_UTILS.buildPaymentScheduleExt(P_LOAN_REC.LOAN_ID, P_LOAN_REC.CURRENT_PHASE);
406:
407: i := 0;
408: l_RATE_SCHEDS_TBL.delete;

Line 409: LogMessage(FND_LOG.LEVEL_STATEMENT, 'Current loan rate schedule:');

405: l_pay_schedule := LNS_FIN_UTILS.buildPaymentScheduleExt(P_LOAN_REC.LOAN_ID, P_LOAN_REC.CURRENT_PHASE);
406:
407: i := 0;
408: l_RATE_SCHEDS_TBL.delete;
409: LogMessage(FND_LOG.LEVEL_STATEMENT, 'Current loan rate schedule:');
410: LogMessage(FND_LOG.LEVEL_STATEMENT, 'From_date To_Date From_Inst To_Inst Rate+Spread=Current_Rate IO Rate_sched_id');
411: LogMessage(FND_LOG.LEVEL_STATEMENT, '--------- ------- --------- ------- ------------------------ -- -------------');
412: open c_get_rate_sch_info(P_LOAN_REC.TERM_ID, P_LOAN_REC.CURRENT_PHASE);
413: LOOP

Line 410: LogMessage(FND_LOG.LEVEL_STATEMENT, 'From_date To_Date From_Inst To_Inst Rate+Spread=Current_Rate IO Rate_sched_id');

406:
407: i := 0;
408: l_RATE_SCHEDS_TBL.delete;
409: LogMessage(FND_LOG.LEVEL_STATEMENT, 'Current loan rate schedule:');
410: LogMessage(FND_LOG.LEVEL_STATEMENT, 'From_date To_Date From_Inst To_Inst Rate+Spread=Current_Rate IO Rate_sched_id');
411: LogMessage(FND_LOG.LEVEL_STATEMENT, '--------- ------- --------- ------- ------------------------ -- -------------');
412: open c_get_rate_sch_info(P_LOAN_REC.TERM_ID, P_LOAN_REC.CURRENT_PHASE);
413: LOOP
414:

Line 411: LogMessage(FND_LOG.LEVEL_STATEMENT, '--------- ------- --------- ------- ------------------------ -- -------------');

407: i := 0;
408: l_RATE_SCHEDS_TBL.delete;
409: LogMessage(FND_LOG.LEVEL_STATEMENT, 'Current loan rate schedule:');
410: LogMessage(FND_LOG.LEVEL_STATEMENT, 'From_date To_Date From_Inst To_Inst Rate+Spread=Current_Rate IO Rate_sched_id');
411: LogMessage(FND_LOG.LEVEL_STATEMENT, '--------- ------- --------- ------- ------------------------ -- -------------');
412: open c_get_rate_sch_info(P_LOAN_REC.TERM_ID, P_LOAN_REC.CURRENT_PHASE);
413: LOOP
414:
415: fetch c_get_rate_sch_info into

Line 435: LogMessage(FND_LOG.LEVEL_STATEMENT,

431: l_RATE_SCHEDS_TBL(i).END_DATE := payNumToDate(l_pay_schedule,
432: l_RATE_SCHEDS_TBL(i).END_INSTALLMENT_NUMBER,
433: 'END');
434:
435: LogMessage(FND_LOG.LEVEL_STATEMENT,
436: l_RATE_SCHEDS_TBL(i).BEGIN_DATE || ' ' ||
437: l_RATE_SCHEDS_TBL(i).END_DATE || ' ' ||
438: l_RATE_SCHEDS_TBL(i).BEGIN_INSTALLMENT_NUMBER || ' ' ||
439: l_RATE_SCHEDS_TBL(i).END_INSTALLMENT_NUMBER || ' ' ||

Line 451: LogMessage(FND_LOG.LEVEL_STATEMENT, 'Adjusting index rate lines for this loan...');

447:
448: END LOOP;
449: close c_get_rate_sch_info;
450:
451: LogMessage(FND_LOG.LEVEL_STATEMENT, 'Adjusting index rate lines for this loan...');
452: l_TEMP_ADJ_RATES_TBL.delete;
453: y := 0;
454: for k in 1..l_rates_count loop
455: l_temp_pay_num := dateToPayNum(l_pay_schedule, l_RATE_LINES_TBL(k).START_DATE_ACTIVE);

Line 486: LogMessage(FND_LOG.LEVEL_STATEMENT, 'Adjusted index rate lines:');

482: l_ADJ_RATES_TBL(i) := l_TEMP_ADJ_RATES_TBL(k);
483: end if;
484: end loop;
485:
486: LogMessage(FND_LOG.LEVEL_STATEMENT, 'Adjusted index rate lines:');
487: LogMessage(FND_LOG.LEVEL_STATEMENT, 'From To Rate');
488: LogMessage(FND_LOG.LEVEL_STATEMENT, '---- --- ----');
489: for k in 1..l_ADJ_RATES_TBL.count loop
490: LogMessage(FND_LOG.LEVEL_STATEMENT, l_ADJ_RATES_TBL(k).FROM_INSTALLMENT || ' ' || l_ADJ_RATES_TBL(k).TO_INSTALLMENT || ' ' || l_ADJ_RATES_TBL(k).INTEREST_RATE);

Line 487: LogMessage(FND_LOG.LEVEL_STATEMENT, 'From To Rate');

483: end if;
484: end loop;
485:
486: LogMessage(FND_LOG.LEVEL_STATEMENT, 'Adjusted index rate lines:');
487: LogMessage(FND_LOG.LEVEL_STATEMENT, 'From To Rate');
488: LogMessage(FND_LOG.LEVEL_STATEMENT, '---- --- ----');
489: for k in 1..l_ADJ_RATES_TBL.count loop
490: LogMessage(FND_LOG.LEVEL_STATEMENT, l_ADJ_RATES_TBL(k).FROM_INSTALLMENT || ' ' || l_ADJ_RATES_TBL(k).TO_INSTALLMENT || ' ' || l_ADJ_RATES_TBL(k).INTEREST_RATE);
491: end loop;

Line 488: LogMessage(FND_LOG.LEVEL_STATEMENT, '---- --- ----');

484: end loop;
485:
486: LogMessage(FND_LOG.LEVEL_STATEMENT, 'Adjusted index rate lines:');
487: LogMessage(FND_LOG.LEVEL_STATEMENT, 'From To Rate');
488: LogMessage(FND_LOG.LEVEL_STATEMENT, '---- --- ----');
489: for k in 1..l_ADJ_RATES_TBL.count loop
490: LogMessage(FND_LOG.LEVEL_STATEMENT, l_ADJ_RATES_TBL(k).FROM_INSTALLMENT || ' ' || l_ADJ_RATES_TBL(k).TO_INSTALLMENT || ' ' || l_ADJ_RATES_TBL(k).INTEREST_RATE);
491: end loop;
492:

Line 490: LogMessage(FND_LOG.LEVEL_STATEMENT, l_ADJ_RATES_TBL(k).FROM_INSTALLMENT || ' ' || l_ADJ_RATES_TBL(k).TO_INSTALLMENT || ' ' || l_ADJ_RATES_TBL(k).INTEREST_RATE);

486: LogMessage(FND_LOG.LEVEL_STATEMENT, 'Adjusted index rate lines:');
487: LogMessage(FND_LOG.LEVEL_STATEMENT, 'From To Rate');
488: LogMessage(FND_LOG.LEVEL_STATEMENT, '---- --- ----');
489: for k in 1..l_ADJ_RATES_TBL.count loop
490: LogMessage(FND_LOG.LEVEL_STATEMENT, l_ADJ_RATES_TBL(k).FROM_INSTALLMENT || ' ' || l_ADJ_RATES_TBL(k).TO_INSTALLMENT || ' ' || l_ADJ_RATES_TBL(k).INTEREST_RATE);
491: end loop;
492:
493: if l_ADJ_RATES_TBL.count = 0 then
494: LogMessage(FND_LOG.LEVEL_STATEMENT, 'Adjusted index rate table is empty. Nothing to Merge. Exiting.');

Line 494: LogMessage(FND_LOG.LEVEL_STATEMENT, 'Adjusted index rate table is empty. Nothing to Merge. Exiting.');

490: LogMessage(FND_LOG.LEVEL_STATEMENT, l_ADJ_RATES_TBL(k).FROM_INSTALLMENT || ' ' || l_ADJ_RATES_TBL(k).TO_INSTALLMENT || ' ' || l_ADJ_RATES_TBL(k).INTEREST_RATE);
491: end loop;
492:
493: if l_ADJ_RATES_TBL.count = 0 then
494: LogMessage(FND_LOG.LEVEL_STATEMENT, 'Adjusted index rate table is empty. Nothing to Merge. Exiting.');
495: return;
496: end if;
497:
498: LogMessage(FND_LOG.LEVEL_STATEMENT, 'Merging rate schedule with adjusted index rate lines...');

Line 498: LogMessage(FND_LOG.LEVEL_STATEMENT, 'Merging rate schedule with adjusted index rate lines...');

494: LogMessage(FND_LOG.LEVEL_STATEMENT, 'Adjusted index rate table is empty. Nothing to Merge. Exiting.');
495: return;
496: end if;
497:
498: LogMessage(FND_LOG.LEVEL_STATEMENT, 'Merging rate schedule with adjusted index rate lines...');
499:
500: rate_sched_count := 1;
501: index_rate_count := 1;
502: merged_count := 1;

Line 530: logMessage(FND_LOG.LEVEL_STATEMENT, '---------------');

526: else
527: l_index_rate := l_ADJ_RATES_TBL(l_ADJ_RATES_TBL.count).INTEREST_RATE;
528: end if;
529:
530: logMessage(FND_LOG.LEVEL_STATEMENT, '---------------');
531: logMessage(FND_LOG.LEVEL_STATEMENT, 'Loop ' || merged_count);
532: logMessage(FND_LOG.LEVEL_STATEMENT, 'rate_sched_count = ' || rate_sched_count);
533: logMessage(FND_LOG.LEVEL_STATEMENT, 'index_rate_count = ' || index_rate_count);
534: logMessage(FND_LOG.LEVEL_STATEMENT, 'rate_sched: ' || l_rate_sched_from || ' - ' || l_rate_sched_to);

Line 531: logMessage(FND_LOG.LEVEL_STATEMENT, 'Loop ' || merged_count);

527: l_index_rate := l_ADJ_RATES_TBL(l_ADJ_RATES_TBL.count).INTEREST_RATE;
528: end if;
529:
530: logMessage(FND_LOG.LEVEL_STATEMENT, '---------------');
531: logMessage(FND_LOG.LEVEL_STATEMENT, 'Loop ' || merged_count);
532: logMessage(FND_LOG.LEVEL_STATEMENT, 'rate_sched_count = ' || rate_sched_count);
533: logMessage(FND_LOG.LEVEL_STATEMENT, 'index_rate_count = ' || index_rate_count);
534: logMessage(FND_LOG.LEVEL_STATEMENT, 'rate_sched: ' || l_rate_sched_from || ' - ' || l_rate_sched_to);
535: logMessage(FND_LOG.LEVEL_STATEMENT, 'index: ' || l_index_from || ' - ' || l_index_to);

Line 532: logMessage(FND_LOG.LEVEL_STATEMENT, 'rate_sched_count = ' || rate_sched_count);

528: end if;
529:
530: logMessage(FND_LOG.LEVEL_STATEMENT, '---------------');
531: logMessage(FND_LOG.LEVEL_STATEMENT, 'Loop ' || merged_count);
532: logMessage(FND_LOG.LEVEL_STATEMENT, 'rate_sched_count = ' || rate_sched_count);
533: logMessage(FND_LOG.LEVEL_STATEMENT, 'index_rate_count = ' || index_rate_count);
534: logMessage(FND_LOG.LEVEL_STATEMENT, 'rate_sched: ' || l_rate_sched_from || ' - ' || l_rate_sched_to);
535: logMessage(FND_LOG.LEVEL_STATEMENT, 'index: ' || l_index_from || ' - ' || l_index_to);
536:

Line 533: logMessage(FND_LOG.LEVEL_STATEMENT, 'index_rate_count = ' || index_rate_count);

529:
530: logMessage(FND_LOG.LEVEL_STATEMENT, '---------------');
531: logMessage(FND_LOG.LEVEL_STATEMENT, 'Loop ' || merged_count);
532: logMessage(FND_LOG.LEVEL_STATEMENT, 'rate_sched_count = ' || rate_sched_count);
533: logMessage(FND_LOG.LEVEL_STATEMENT, 'index_rate_count = ' || index_rate_count);
534: logMessage(FND_LOG.LEVEL_STATEMENT, 'rate_sched: ' || l_rate_sched_from || ' - ' || l_rate_sched_to);
535: logMessage(FND_LOG.LEVEL_STATEMENT, 'index: ' || l_index_from || ' - ' || l_index_to);
536:
537: if (l_rate_sched_from is not null and l_rate_sched_to is not null and

Line 534: logMessage(FND_LOG.LEVEL_STATEMENT, 'rate_sched: ' || l_rate_sched_from || ' - ' || l_rate_sched_to);

530: logMessage(FND_LOG.LEVEL_STATEMENT, '---------------');
531: logMessage(FND_LOG.LEVEL_STATEMENT, 'Loop ' || merged_count);
532: logMessage(FND_LOG.LEVEL_STATEMENT, 'rate_sched_count = ' || rate_sched_count);
533: logMessage(FND_LOG.LEVEL_STATEMENT, 'index_rate_count = ' || index_rate_count);
534: logMessage(FND_LOG.LEVEL_STATEMENT, 'rate_sched: ' || l_rate_sched_from || ' - ' || l_rate_sched_to);
535: logMessage(FND_LOG.LEVEL_STATEMENT, 'index: ' || l_index_from || ' - ' || l_index_to);
536:
537: if (l_rate_sched_from is not null and l_rate_sched_to is not null and
538: l_index_from is not null and l_index_from is not null)

Line 535: logMessage(FND_LOG.LEVEL_STATEMENT, 'index: ' || l_index_from || ' - ' || l_index_to);

531: logMessage(FND_LOG.LEVEL_STATEMENT, 'Loop ' || merged_count);
532: logMessage(FND_LOG.LEVEL_STATEMENT, 'rate_sched_count = ' || rate_sched_count);
533: logMessage(FND_LOG.LEVEL_STATEMENT, 'index_rate_count = ' || index_rate_count);
534: logMessage(FND_LOG.LEVEL_STATEMENT, 'rate_sched: ' || l_rate_sched_from || ' - ' || l_rate_sched_to);
535: logMessage(FND_LOG.LEVEL_STATEMENT, 'index: ' || l_index_from || ' - ' || l_index_to);
536:
537: if (l_rate_sched_from is not null and l_rate_sched_to is not null and
538: l_index_from is not null and l_index_from is not null)
539: then

Line 545: logMessage(FND_LOG.LEVEL_STATEMENT, 'if 1 - updating');

541: if (l_rate_sched_from between l_index_from and l_index_to) then
542:
543: if l_rate_sched_to > l_index_to then
544:
545: logMessage(FND_LOG.LEVEL_STATEMENT, 'if 1 - updating');
546: l_merged_rates_tbl(merged_count) := l_RATE_SCHEDS_TBL(rate_sched_count);
547: l_merged_rates_tbl(merged_count).END_INSTALLMENT_NUMBER := l_index_to;
548: l_merged_rates_tbl(merged_count).INDEX_RATE := l_index_rate;
549: l_merged_rates_tbl(merged_count).CURRENT_INTEREST_RATE := l_index_rate + nvl(l_merged_rates_tbl(merged_count).SPREAD, 0);

Line 560: logMessage(FND_LOG.LEVEL_STATEMENT, 'if 21 - skipping');

556: l_merged_rates_tbl(merged_count) := l_RATE_SCHEDS_TBL(rate_sched_count);
557:
558: if l_RATE_SCHEDS_TBL(rate_sched_count).INDEX_RATE = l_index_rate then
559:
560: logMessage(FND_LOG.LEVEL_STATEMENT, 'if 21 - skipping');
561: l_merged_rates_tbl(merged_count).ACTION := 'SKIP';
562:
563: else
564:

Line 565: logMessage(FND_LOG.LEVEL_STATEMENT, 'if 22 - updating');

561: l_merged_rates_tbl(merged_count).ACTION := 'SKIP';
562:
563: else
564:
565: logMessage(FND_LOG.LEVEL_STATEMENT, 'if 22 - updating');
566: l_merged_rates_tbl(merged_count).INDEX_RATE := l_index_rate;
567: l_merged_rates_tbl(merged_count).CURRENT_INTEREST_RATE := l_index_rate + nvl(l_merged_rates_tbl(merged_count).SPREAD, 0);
568: l_merged_rates_tbl(merged_count).ACTION := 'UPDATE';
569:

Line 579: logMessage(FND_LOG.LEVEL_STATEMENT, 'if 31 - skipping');

575: l_merged_rates_tbl(merged_count) := l_RATE_SCHEDS_TBL(rate_sched_count);
576:
577: if l_RATE_SCHEDS_TBL(rate_sched_count).INDEX_RATE = l_index_rate then
578:
579: logMessage(FND_LOG.LEVEL_STATEMENT, 'if 31 - skipping');
580: l_merged_rates_tbl(merged_count).ACTION := 'SKIP';
581:
582: else
583:

Line 584: logMessage(FND_LOG.LEVEL_STATEMENT, 'if 32 - updating');

580: l_merged_rates_tbl(merged_count).ACTION := 'SKIP';
581:
582: else
583:
584: logMessage(FND_LOG.LEVEL_STATEMENT, 'if 32 - updating');
585: l_merged_rates_tbl(merged_count).INDEX_RATE := l_index_rate;
586: l_merged_rates_tbl(merged_count).CURRENT_INTEREST_RATE := l_index_rate + nvl(l_merged_rates_tbl(merged_count).SPREAD, 0);
587: l_merged_rates_tbl(merged_count).ACTION := 'UPDATE';
588:

Line 628: logMessage(FND_LOG.LEVEL_STATEMENT, 'if 41 - skipping');

624: elsif (l_rate_sched_from < l_index_from) then
625:
626: if l_rate_sched_to < l_index_from then
627: l_merged_rates_tbl(merged_count) := l_RATE_SCHEDS_TBL(rate_sched_count);
628: logMessage(FND_LOG.LEVEL_STATEMENT, 'if 41 - skipping');
629: l_merged_rates_tbl(merged_count).ACTION := 'SKIP';
630: rate_sched_count := rate_sched_count + 1;
631:
632: elsif l_rate_sched_to >= l_index_from then

Line 641: logMessage(FND_LOG.LEVEL_STATEMENT, 'if 42 - skipping');

637: index_rate_count < l_ADJ_RATES_TBL.count
638: then
639:
640: l_merged_rates_tbl(merged_count) := l_RATE_SCHEDS_TBL(rate_sched_count);
641: logMessage(FND_LOG.LEVEL_STATEMENT, 'if 42 - skipping');
642: l_merged_rates_tbl(merged_count).ACTION := 'SKIP';
643: rate_sched_count := rate_sched_count + 1;
644: index_rate_count := index_rate_count + 1;
645:

Line 659: logMessage(FND_LOG.LEVEL_STATEMENT, 'if 43 - updating');

655: l_prev_io := l_merged_rates_tbl(merged_count).INTEREST_ONLY_FLAG;
656: l_update1 := false;
657:
658: if l_RATE_SCHEDS_TBL(rate_sched_count).INDEX_RATE = l_index_rate then
659: logMessage(FND_LOG.LEVEL_STATEMENT, 'if 43 - updating');
660: l_merged_rates_tbl(merged_count).END_INSTALLMENT_NUMBER := l_index_to;
661: l_do_insert := false;
662: index_rate_count := index_rate_count + 1;
663: else

Line 664: logMessage(FND_LOG.LEVEL_STATEMENT, 'if 44 - updating');

660: l_merged_rates_tbl(merged_count).END_INSTALLMENT_NUMBER := l_index_to;
661: l_do_insert := false;
662: index_rate_count := index_rate_count + 1;
663: else
664: logMessage(FND_LOG.LEVEL_STATEMENT, 'if 44 - updating');
665: l_merged_rates_tbl(merged_count).END_INSTALLMENT_NUMBER := l_index_from-1;
666: l_do_insert := true;
667: merged_count := merged_count + 1;
668: end if;

Line 685: logMessage(FND_LOG.LEVEL_STATEMENT, 'if 45 - inserting');

681: l_merged_rates_tbl(merged_count).ACTION := 'INSERT';
682:
683: if l_rate_sched_to > l_index_to then
684:
685: logMessage(FND_LOG.LEVEL_STATEMENT, 'if 45 - inserting');
686: l_merged_rates_tbl(merged_count).END_INSTALLMENT_NUMBER := l_index_to;
687: index_rate_count := index_rate_count + 1;
688:
689: elsif l_rate_sched_to < l_index_to then

Line 691: logMessage(FND_LOG.LEVEL_STATEMENT, 'if 46 - inserting');

687: index_rate_count := index_rate_count + 1;
688:
689: elsif l_rate_sched_to < l_index_to then
690:
691: logMessage(FND_LOG.LEVEL_STATEMENT, 'if 46 - inserting');
692: l_merged_rates_tbl(merged_count).END_INSTALLMENT_NUMBER := l_rate_sched_to;
693: rate_sched_count := rate_sched_count + 1;
694:
695: else -- l_rate_sched_to = l_index_to

Line 697: logMessage(FND_LOG.LEVEL_STATEMENT, 'if 47 - inserting');

693: rate_sched_count := rate_sched_count + 1;
694:
695: else -- l_rate_sched_to = l_index_to
696:
697: logMessage(FND_LOG.LEVEL_STATEMENT, 'if 47 - inserting');
698: l_merged_rates_tbl(merged_count).END_INSTALLMENT_NUMBER := l_rate_sched_to;
699: rate_sched_count := rate_sched_count + 1;
700: index_rate_count := index_rate_count + 1;
701:

Line 736: logMessage(FND_LOG.LEVEL_STATEMENT, 'if 5 - going to next index rate record');

732: merged_count := merged_count + 1;
733:
734: elsif (l_rate_sched_from > l_index_to) then
735:
736: logMessage(FND_LOG.LEVEL_STATEMENT, 'if 5 - going to next index rate record');
737: index_rate_count := index_rate_count + 1;
738:
739: end if;
740:

Line 745: logMessage(FND_LOG.LEVEL_STATEMENT, 'if 6 - exiting loop');

741: elsif (l_rate_sched_from is null or l_rate_sched_to is null or
742: l_index_from is null or l_index_from is null)
743: then
744:
745: logMessage(FND_LOG.LEVEL_STATEMENT, 'if 6 - exiting loop');
746: exit;
747:
748: end if;
749:

Line 752: LogMessage(FND_LOG.LEVEL_UNEXPECTED, 'New rate schedule:');

748: end if;
749:
750: end loop;
751:
752: LogMessage(FND_LOG.LEVEL_UNEXPECTED, 'New rate schedule:');
753: LogMessage(FND_LOG.LEVEL_UNEXPECTED, 'From_date To_Date From_Inst To_Inst Rate+Spread=Current_Rate IO Rate_sched_id');
754: LogMessage(FND_LOG.LEVEL_UNEXPECTED, '--------- ------- --------- ------- ------------------------ -- -------------');
755: for k in 1..l_merged_rates_tbl.count loop
756:

Line 753: LogMessage(FND_LOG.LEVEL_UNEXPECTED, 'From_date To_Date From_Inst To_Inst Rate+Spread=Current_Rate IO Rate_sched_id');

749:
750: end loop;
751:
752: LogMessage(FND_LOG.LEVEL_UNEXPECTED, 'New rate schedule:');
753: LogMessage(FND_LOG.LEVEL_UNEXPECTED, 'From_date To_Date From_Inst To_Inst Rate+Spread=Current_Rate IO Rate_sched_id');
754: LogMessage(FND_LOG.LEVEL_UNEXPECTED, '--------- ------- --------- ------- ------------------------ -- -------------');
755: for k in 1..l_merged_rates_tbl.count loop
756:
757: if l_merged_rates_tbl(k).ACTION = 'UPDATE' then

Line 754: LogMessage(FND_LOG.LEVEL_UNEXPECTED, '--------- ------- --------- ------- ------------------------ -- -------------');

750: end loop;
751:
752: LogMessage(FND_LOG.LEVEL_UNEXPECTED, 'New rate schedule:');
753: LogMessage(FND_LOG.LEVEL_UNEXPECTED, 'From_date To_Date From_Inst To_Inst Rate+Spread=Current_Rate IO Rate_sched_id');
754: LogMessage(FND_LOG.LEVEL_UNEXPECTED, '--------- ------- --------- ------- ------------------------ -- -------------');
755: for k in 1..l_merged_rates_tbl.count loop
756:
757: if l_merged_rates_tbl(k).ACTION = 'UPDATE' then
758:

Line 814: LogMessage(FND_LOG.LEVEL_UNEXPECTED,

810: );
811:
812: end if;
813:
814: LogMessage(FND_LOG.LEVEL_UNEXPECTED,
815: l_merged_rates_tbl(k).BEGIN_DATE || ' ' ||
816: l_merged_rates_tbl(k).END_DATE || ' ' ||
817: l_merged_rates_tbl(k).BEGIN_INSTALLMENT_NUMBER || ' ' ||
818: l_merged_rates_tbl(k).END_INSTALLMENT_NUMBER || ' ' ||

Line 828: LogMessage(FND_LOG.LEVEL_STATEMENT, 'Commited');

824: end loop;
825:
826: if P_COMMIT = FND_API.G_TRUE then
827: COMMIT WORK;
828: LogMessage(FND_LOG.LEVEL_STATEMENT, 'Commited');
829: end if;
830:
831: -- END OF BODY OF API
832: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 840: LogMessage(FND_LOG.LEVEL_UNEXPECTED, 'Successfully processed loan ' || P_LOAN_REC.LOAN_NUMBER);

836: p_encoded => FND_API.G_FALSE,
837: p_count => x_msg_count,
838: p_data => x_msg_data);
839:
840: LogMessage(FND_LOG.LEVEL_UNEXPECTED, 'Successfully processed loan ' || P_LOAN_REC.LOAN_NUMBER);
841: LogMessage(FND_LOG.LEVEL_PROCEDURE, l_api_name || ' -');
842:
843: EXCEPTION
844: WHEN FND_API.G_EXC_ERROR THEN

Line 841: LogMessage(FND_LOG.LEVEL_PROCEDURE, l_api_name || ' -');

837: p_count => x_msg_count,
838: p_data => x_msg_data);
839:
840: LogMessage(FND_LOG.LEVEL_UNEXPECTED, 'Successfully processed loan ' || P_LOAN_REC.LOAN_NUMBER);
841: LogMessage(FND_LOG.LEVEL_PROCEDURE, l_api_name || ' -');
842:
843: EXCEPTION
844: WHEN FND_API.G_EXC_ERROR THEN
845: ROLLBACK TO PROCESS_SINGLE_LOAN;

Line 848: LogMessage(FND_LOG.LEVEL_ERROR, 'Rollbacked');

844: WHEN FND_API.G_EXC_ERROR THEN
845: ROLLBACK TO PROCESS_SINGLE_LOAN;
846: x_return_status := FND_API.G_RET_STS_ERROR;
847: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
848: LogMessage(FND_LOG.LEVEL_ERROR, 'Rollbacked');
849: LogMessage(FND_LOG.LEVEL_ERROR, 'Failed to process loan ' || P_LOAN_REC.LOAN_NUMBER);
850:
851: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
852: ROLLBACK TO PROCESS_SINGLE_LOAN;

Line 849: LogMessage(FND_LOG.LEVEL_ERROR, 'Failed to process loan ' || P_LOAN_REC.LOAN_NUMBER);

845: ROLLBACK TO PROCESS_SINGLE_LOAN;
846: x_return_status := FND_API.G_RET_STS_ERROR;
847: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
848: LogMessage(FND_LOG.LEVEL_ERROR, 'Rollbacked');
849: LogMessage(FND_LOG.LEVEL_ERROR, 'Failed to process loan ' || P_LOAN_REC.LOAN_NUMBER);
850:
851: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
852: ROLLBACK TO PROCESS_SINGLE_LOAN;
853: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 855: LogMessage(FND_LOG.LEVEL_ERROR, 'Rollbacked');

851: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
852: ROLLBACK TO PROCESS_SINGLE_LOAN;
853: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
854: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
855: LogMessage(FND_LOG.LEVEL_ERROR, 'Rollbacked');
856: LogMessage(FND_LOG.LEVEL_ERROR, 'Failed to process loan ' || P_LOAN_REC.LOAN_NUMBER);
857:
858: WHEN OTHERS THEN
859: ROLLBACK TO PROCESS_SINGLE_LOAN;

Line 856: LogMessage(FND_LOG.LEVEL_ERROR, 'Failed to process loan ' || P_LOAN_REC.LOAN_NUMBER);

852: ROLLBACK TO PROCESS_SINGLE_LOAN;
853: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
854: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
855: LogMessage(FND_LOG.LEVEL_ERROR, 'Rollbacked');
856: LogMessage(FND_LOG.LEVEL_ERROR, 'Failed to process loan ' || P_LOAN_REC.LOAN_NUMBER);
857:
858: WHEN OTHERS THEN
859: ROLLBACK TO PROCESS_SINGLE_LOAN;
860: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 865: LogMessage(FND_LOG.LEVEL_ERROR, 'Rollbacked');

861: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)THEN
862: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
863: END IF;
864: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
865: LogMessage(FND_LOG.LEVEL_ERROR, 'Rollbacked');
866: LogMessage(FND_LOG.LEVEL_ERROR, 'Failed to process loan ' || P_LOAN_REC.LOAN_NUMBER);
867:
868: END;
869:

Line 866: LogMessage(FND_LOG.LEVEL_ERROR, 'Failed to process loan ' || P_LOAN_REC.LOAN_NUMBER);

862: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
863: END IF;
864: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
865: LogMessage(FND_LOG.LEVEL_ERROR, 'Rollbacked');
866: LogMessage(FND_LOG.LEVEL_ERROR, 'Failed to process loan ' || P_LOAN_REC.LOAN_NUMBER);
867:
868: END;
869:
870:

Line 974: LogMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME || '.' || l_api_name || ' +');

970: order by start_date_active;
971:
972: BEGIN
973:
974: LogMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME || '.' || l_api_name || ' +');
975:
976: -- Standard start of API savepoint
977: SAVEPOINT UPDATE_FLOATING_RATE_LOANS_PVT;
978: LogMessage(FND_LOG.LEVEL_STATEMENT, 'Established savepoint');

Line 978: LogMessage(FND_LOG.LEVEL_STATEMENT, 'Established savepoint');

974: LogMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME || '.' || l_api_name || ' +');
975:
976: -- Standard start of API savepoint
977: SAVEPOINT UPDATE_FLOATING_RATE_LOANS_PVT;
978: LogMessage(FND_LOG.LEVEL_STATEMENT, 'Established savepoint');
979:
980: /* init variables */
981: l_Count := 0;
982: l_success_count := 0;

Line 985: LogMessage(FND_LOG.level_unexpected, 'Input Parameters:');

981: l_Count := 0;
982: l_success_count := 0;
983: l_failure_count := 0;
984:
985: LogMessage(FND_LOG.level_unexpected, 'Input Parameters:');
986: LogMessage(FND_LOG.level_unexpected, 'Index: ' || P_INDEX_RATE_ID);
987:
988: --Obtain rate setup info based on user input parameters
989: LogMessage(FND_LOG.LEVEL_STATEMENT, 'Searching for index rates...');

Line 986: LogMessage(FND_LOG.level_unexpected, 'Index: ' || P_INDEX_RATE_ID);

982: l_success_count := 0;
983: l_failure_count := 0;
984:
985: LogMessage(FND_LOG.level_unexpected, 'Input Parameters:');
986: LogMessage(FND_LOG.level_unexpected, 'Index: ' || P_INDEX_RATE_ID);
987:
988: --Obtain rate setup info based on user input parameters
989: LogMessage(FND_LOG.LEVEL_STATEMENT, 'Searching for index rates...');
990: open c_get_int_rates(P_INDEX_RATE_ID);

Line 989: LogMessage(FND_LOG.LEVEL_STATEMENT, 'Searching for index rates...');

985: LogMessage(FND_LOG.level_unexpected, 'Input Parameters:');
986: LogMessage(FND_LOG.level_unexpected, 'Index: ' || P_INDEX_RATE_ID);
987:
988: --Obtain rate setup info based on user input parameters
989: LogMessage(FND_LOG.LEVEL_STATEMENT, 'Searching for index rates...');
990: open c_get_int_rates(P_INDEX_RATE_ID);
991: LOOP
992:
993: fetch c_get_int_rates into

Line 999: LogMessage(FND_LOG.level_unexpected, ' ');

995: l_setup_rate_name,
996: l_setup_rate_desc;
997: exit when c_get_int_rates%NOTFOUND;
998:
999: LogMessage(FND_LOG.level_unexpected, ' ');
1000: LogMessage(FND_LOG.level_unexpected, 'Index rate - ' || l_setup_rate_name || ' (' || l_setup_int_rate || ')');
1001:
1002: j := 0;
1003: l_RATE_LINES_TBL.delete;

Line 1000: LogMessage(FND_LOG.level_unexpected, 'Index rate - ' || l_setup_rate_name || ' (' || l_setup_int_rate || ')');

996: l_setup_rate_desc;
997: exit when c_get_int_rates%NOTFOUND;
998:
999: LogMessage(FND_LOG.level_unexpected, ' ');
1000: LogMessage(FND_LOG.level_unexpected, 'Index rate - ' || l_setup_rate_name || ' (' || l_setup_int_rate || ')');
1001:
1002: j := 0;
1003: l_RATE_LINES_TBL.delete;
1004: open c_get_int_lines(l_setup_int_rate);

Line 1017: LogMessage(FND_LOG.level_unexpected, l_RATE_LINES_TBL(j).START_DATE_ACTIVE || ' - ' || l_RATE_LINES_TBL(j).END_DATE_ACTIVE || ': ' || l_RATE_LINES_TBL(j).INTEREST_RATE || ' (id=' || l_RATE_LINES_TBL(j).INTEREST_RATE_LINE_ID || ')');

1013: exit when c_get_int_lines%NOTFOUND;
1014:
1015: j := j + 1;
1016: l_RATE_LINES_TBL(j) := l_RATE_LINE_REC;
1017: LogMessage(FND_LOG.level_unexpected, l_RATE_LINES_TBL(j).START_DATE_ACTIVE || ' - ' || l_RATE_LINES_TBL(j).END_DATE_ACTIVE || ': ' || l_RATE_LINES_TBL(j).INTEREST_RATE || ' (id=' || l_RATE_LINES_TBL(j).INTEREST_RATE_LINE_ID || ')');
1018:
1019: END LOOP;
1020: close c_get_int_lines;
1021:

Line 1063: LogMessage(FND_LOG.LEVEL_STATEMENT, ' ');

1059:
1060: END LOOP;
1061: close c_get_int_rates;
1062:
1063: LogMessage(FND_LOG.LEVEL_STATEMENT, ' ');
1064: LogMessage(FND_LOG.level_unexpected, '----------------------------------');
1065: LogMessage(FND_LOG.level_unexpected, 'Total Processed: ' || l_Count || ' loan(s)');
1066: LogMessage(FND_LOG.level_unexpected, 'Failed: ' || l_failure_count || ' loan(s)');
1067: LogMessage(FND_LOG.level_unexpected, 'Succeeded: ' || l_success_count || ' loan(s)');

Line 1064: LogMessage(FND_LOG.level_unexpected, '----------------------------------');

1060: END LOOP;
1061: close c_get_int_rates;
1062:
1063: LogMessage(FND_LOG.LEVEL_STATEMENT, ' ');
1064: LogMessage(FND_LOG.level_unexpected, '----------------------------------');
1065: LogMessage(FND_LOG.level_unexpected, 'Total Processed: ' || l_Count || ' loan(s)');
1066: LogMessage(FND_LOG.level_unexpected, 'Failed: ' || l_failure_count || ' loan(s)');
1067: LogMessage(FND_LOG.level_unexpected, 'Succeeded: ' || l_success_count || ' loan(s)');
1068:

Line 1065: LogMessage(FND_LOG.level_unexpected, 'Total Processed: ' || l_Count || ' loan(s)');

1061: close c_get_int_rates;
1062:
1063: LogMessage(FND_LOG.LEVEL_STATEMENT, ' ');
1064: LogMessage(FND_LOG.level_unexpected, '----------------------------------');
1065: LogMessage(FND_LOG.level_unexpected, 'Total Processed: ' || l_Count || ' loan(s)');
1066: LogMessage(FND_LOG.level_unexpected, 'Failed: ' || l_failure_count || ' loan(s)');
1067: LogMessage(FND_LOG.level_unexpected, 'Succeeded: ' || l_success_count || ' loan(s)');
1068:
1069: RETCODE := FND_API.G_RET_STS_SUCCESS;

Line 1066: LogMessage(FND_LOG.level_unexpected, 'Failed: ' || l_failure_count || ' loan(s)');

1062:
1063: LogMessage(FND_LOG.LEVEL_STATEMENT, ' ');
1064: LogMessage(FND_LOG.level_unexpected, '----------------------------------');
1065: LogMessage(FND_LOG.level_unexpected, 'Total Processed: ' || l_Count || ' loan(s)');
1066: LogMessage(FND_LOG.level_unexpected, 'Failed: ' || l_failure_count || ' loan(s)');
1067: LogMessage(FND_LOG.level_unexpected, 'Succeeded: ' || l_success_count || ' loan(s)');
1068:
1069: RETCODE := FND_API.G_RET_STS_SUCCESS;
1070: if l_Count = 0 then

Line 1067: LogMessage(FND_LOG.level_unexpected, 'Succeeded: ' || l_success_count || ' loan(s)');

1063: LogMessage(FND_LOG.LEVEL_STATEMENT, ' ');
1064: LogMessage(FND_LOG.level_unexpected, '----------------------------------');
1065: LogMessage(FND_LOG.level_unexpected, 'Total Processed: ' || l_Count || ' loan(s)');
1066: LogMessage(FND_LOG.level_unexpected, 'Failed: ' || l_failure_count || ' loan(s)');
1067: LogMessage(FND_LOG.level_unexpected, 'Succeeded: ' || l_success_count || ' loan(s)');
1068:
1069: RETCODE := FND_API.G_RET_STS_SUCCESS;
1070: if l_Count = 0 then
1071: ERRBUF := 'No floating rate loans were found.';

Line 1075: LogMessage(FND_LOG.level_unexpected, ERRBUF);

1071: ERRBUF := 'No floating rate loans were found.';
1072: l_return := FND_CONCURRENT.SET_COMPLETION_STATUS(
1073: status => 'WARNING',
1074: message => ERRBUF);
1075: LogMessage(FND_LOG.level_unexpected, ERRBUF);
1076: elsif l_failure_count > 0 then
1077: ERRBUF := 'Not all floating rate loans were updated successfully. Please review log file.';
1078: l_return := FND_CONCURRENT.SET_COMPLETION_STATUS(
1079: status => 'WARNING',

Line 1081: LogMessage(FND_LOG.level_unexpected, ERRBUF);

1077: ERRBUF := 'Not all floating rate loans were updated successfully. Please review log file.';
1078: l_return := FND_CONCURRENT.SET_COMPLETION_STATUS(
1079: status => 'WARNING',
1080: message => ERRBUF);
1081: LogMessage(FND_LOG.level_unexpected, ERRBUF);
1082: end if;
1083:
1084: LogMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME || '.' || l_api_name || ' -');
1085:

Line 1084: LogMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME || '.' || l_api_name || ' -');

1080: message => ERRBUF);
1081: LogMessage(FND_LOG.level_unexpected, ERRBUF);
1082: end if;
1083:
1084: LogMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME || '.' || l_api_name || ' -');
1085:
1086: EXCEPTION
1087: WHEN OTHERS THEN
1088: ERRBUF := 'Update of floating rate loans has failed. Please review log file.';

Line 1093: LogMessage(FND_LOG.level_unexpected, ERRBUF);

1089: l_return := FND_CONCURRENT.SET_COMPLETION_STATUS(
1090: status => 'ERROR',
1091: message => ERRBUF);
1092: RETCODE := FND_API.G_RET_STS_ERROR;
1093: LogMessage(FND_LOG.level_unexpected, ERRBUF);
1094:
1095: END UPDATE_FLOATING_RATE_LOANS;
1096:
1097:

Line 1164: LogMessage(FND_LOG.level_unexpected, ' ');

1160: WHERE interest_rate_id = indexRateId
1161: order by start_date_active;
1162:
1163: BEGIN
1164: LogMessage(FND_LOG.level_unexpected, ' ');
1165: LogMessage(FND_LOG.LEVEL_PROCEDURE, l_api_name || ' +');
1166:
1167: -- Standard start of API savepoint
1168: SAVEPOINT UPDATE_LOAN_FLOATING_RATE;

Line 1165: LogMessage(FND_LOG.LEVEL_PROCEDURE, l_api_name || ' +');

1161: order by start_date_active;
1162:
1163: BEGIN
1164: LogMessage(FND_LOG.level_unexpected, ' ');
1165: LogMessage(FND_LOG.LEVEL_PROCEDURE, l_api_name || ' +');
1166:
1167: -- Standard start of API savepoint
1168: SAVEPOINT UPDATE_LOAN_FLOATING_RATE;
1169: LogMessage(FND_LOG.LEVEL_STATEMENT, 'Established savepoint');

Line 1169: LogMessage(FND_LOG.LEVEL_STATEMENT, 'Established savepoint');

1165: LogMessage(FND_LOG.LEVEL_PROCEDURE, l_api_name || ' +');
1166:
1167: -- Standard start of API savepoint
1168: SAVEPOINT UPDATE_LOAN_FLOATING_RATE;
1169: LogMessage(FND_LOG.LEVEL_STATEMENT, 'Established savepoint');
1170:
1171: -- Standard call to check for call compatibility
1172: IF NOT FND_API.Compatible_API_Call(l_api_version, p_api_version, l_api_name, G_PKG_NAME) THEN
1173: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 1186: LogMessage(FND_LOG.level_unexpected, 'Input Parameters:');

1182: x_return_status := FND_API.G_RET_STS_SUCCESS;
1183:
1184: -- START OF BODY OF API
1185:
1186: LogMessage(FND_LOG.level_unexpected, 'Input Parameters:');
1187: LogMessage(FND_LOG.level_unexpected, 'P_LOAN_ID: ' || P_LOAN_ID);
1188:
1189: open c_get_loan_info(P_LOAN_ID);
1190: fetch c_get_loan_info into

Line 1187: LogMessage(FND_LOG.level_unexpected, 'P_LOAN_ID: ' || P_LOAN_ID);

1183:
1184: -- START OF BODY OF API
1185:
1186: LogMessage(FND_LOG.level_unexpected, 'Input Parameters:');
1187: LogMessage(FND_LOG.level_unexpected, 'P_LOAN_ID: ' || P_LOAN_ID);
1188:
1189: open c_get_loan_info(P_LOAN_ID);
1190: fetch c_get_loan_info into
1191: l_LOAN_REC.loan_id,

Line 1207: LogMessage(FND_LOG.level_unexpected, 'Index rate ' || l_interest_rate_name || ':');

1203: close c_get_loan_info;
1204:
1205: j := 0;
1206: l_RATE_LINES_TBL.delete;
1207: LogMessage(FND_LOG.level_unexpected, 'Index rate ' || l_interest_rate_name || ':');
1208: open c_get_int_lines(l_index_rate_id);
1209: LOOP
1210:
1211: fetch c_get_int_lines into

Line 1221: LogMessage(FND_LOG.level_unexpected, l_RATE_LINES_TBL(j).START_DATE_ACTIVE || ' - ' || l_RATE_LINES_TBL(j).END_DATE_ACTIVE || ': ' || l_RATE_LINES_TBL(j).INTEREST_RATE || ' (id=' || l_RATE_LINES_TBL(j).INTEREST_RATE_LINE_ID || ')');

1217: exit when c_get_int_lines%NOTFOUND;
1218:
1219: j := j + 1;
1220: l_RATE_LINES_TBL(j) := l_RATE_LINE_REC;
1221: LogMessage(FND_LOG.level_unexpected, l_RATE_LINES_TBL(j).START_DATE_ACTIVE || ' - ' || l_RATE_LINES_TBL(j).END_DATE_ACTIVE || ': ' || l_RATE_LINES_TBL(j).INTEREST_RATE || ' (id=' || l_RATE_LINES_TBL(j).INTEREST_RATE_LINE_ID || ')');
1222:
1223: END LOOP;
1224: close c_get_int_lines;
1225:

Line 1243: LogMessage(FND_LOG.LEVEL_STATEMENT, 'Commited');

1239: end if;
1240:
1241: if P_COMMIT = FND_API.G_TRUE then
1242: COMMIT WORK;
1243: LogMessage(FND_LOG.LEVEL_STATEMENT, 'Commited');
1244: end if;
1245:
1246: -- END OF BODY OF API
1247: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 1255: LogMessage(FND_LOG.LEVEL_UNEXPECTED, 'Successfully processed loan ' || l_LOAN_REC.LOAN_NUMBER);

1251: p_encoded => FND_API.G_FALSE,
1252: p_count => x_msg_count,
1253: p_data => x_msg_data);
1254:
1255: LogMessage(FND_LOG.LEVEL_UNEXPECTED, 'Successfully processed loan ' || l_LOAN_REC.LOAN_NUMBER);
1256: LogMessage(FND_LOG.LEVEL_PROCEDURE, l_api_name || ' -');
1257:
1258: EXCEPTION
1259: WHEN FND_API.G_EXC_ERROR THEN

Line 1256: LogMessage(FND_LOG.LEVEL_PROCEDURE, l_api_name || ' -');

1252: p_count => x_msg_count,
1253: p_data => x_msg_data);
1254:
1255: LogMessage(FND_LOG.LEVEL_UNEXPECTED, 'Successfully processed loan ' || l_LOAN_REC.LOAN_NUMBER);
1256: LogMessage(FND_LOG.LEVEL_PROCEDURE, l_api_name || ' -');
1257:
1258: EXCEPTION
1259: WHEN FND_API.G_EXC_ERROR THEN
1260: ROLLBACK TO UPDATE_LOAN_FLOATING_RATE;

Line 1263: LogMessage(FND_LOG.LEVEL_ERROR, 'Rollbacked');

1259: WHEN FND_API.G_EXC_ERROR THEN
1260: ROLLBACK TO UPDATE_LOAN_FLOATING_RATE;
1261: x_return_status := FND_API.G_RET_STS_ERROR;
1262: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
1263: LogMessage(FND_LOG.LEVEL_ERROR, 'Rollbacked');
1264: LogMessage(FND_LOG.LEVEL_ERROR, 'Failed to process loan ' || l_LOAN_REC.LOAN_NUMBER);
1265:
1266: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1267: ROLLBACK TO UPDATE_LOAN_FLOATING_RATE;

Line 1264: LogMessage(FND_LOG.LEVEL_ERROR, 'Failed to process loan ' || l_LOAN_REC.LOAN_NUMBER);

1260: ROLLBACK TO UPDATE_LOAN_FLOATING_RATE;
1261: x_return_status := FND_API.G_RET_STS_ERROR;
1262: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
1263: LogMessage(FND_LOG.LEVEL_ERROR, 'Rollbacked');
1264: LogMessage(FND_LOG.LEVEL_ERROR, 'Failed to process loan ' || l_LOAN_REC.LOAN_NUMBER);
1265:
1266: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1267: ROLLBACK TO UPDATE_LOAN_FLOATING_RATE;
1268: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 1270: LogMessage(FND_LOG.LEVEL_ERROR, 'Rollbacked');

1266: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1267: ROLLBACK TO UPDATE_LOAN_FLOATING_RATE;
1268: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1269: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
1270: LogMessage(FND_LOG.LEVEL_ERROR, 'Rollbacked');
1271: LogMessage(FND_LOG.LEVEL_ERROR, 'Failed to process loan ' || l_LOAN_REC.LOAN_NUMBER);
1272:
1273: WHEN OTHERS THEN
1274: ROLLBACK TO UPDATE_LOAN_FLOATING_RATE;

Line 1271: LogMessage(FND_LOG.LEVEL_ERROR, 'Failed to process loan ' || l_LOAN_REC.LOAN_NUMBER);

1267: ROLLBACK TO UPDATE_LOAN_FLOATING_RATE;
1268: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1269: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
1270: LogMessage(FND_LOG.LEVEL_ERROR, 'Rollbacked');
1271: LogMessage(FND_LOG.LEVEL_ERROR, 'Failed to process loan ' || l_LOAN_REC.LOAN_NUMBER);
1272:
1273: WHEN OTHERS THEN
1274: ROLLBACK TO UPDATE_LOAN_FLOATING_RATE;
1275: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 1280: LogMessage(FND_LOG.LEVEL_ERROR, 'Rollbacked');

1276: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)THEN
1277: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
1278: END IF;
1279: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
1280: LogMessage(FND_LOG.LEVEL_ERROR, 'Rollbacked');
1281: LogMessage(FND_LOG.LEVEL_ERROR, 'Failed to process loan ' || l_LOAN_REC.LOAN_NUMBER);
1282:
1283: END;
1284:

Line 1281: LogMessage(FND_LOG.LEVEL_ERROR, 'Failed to process loan ' || l_LOAN_REC.LOAN_NUMBER);

1277: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
1278: END IF;
1279: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
1280: LogMessage(FND_LOG.LEVEL_ERROR, 'Rollbacked');
1281: LogMessage(FND_LOG.LEVEL_ERROR, 'Failed to process loan ' || l_LOAN_REC.LOAN_NUMBER);
1282:
1283: END;
1284:
1285: