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

Line 26: IF log_level >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN

22: ,message in varchar2)
23: is
24:
25: begin
26: IF log_level >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
27: FND_LOG.STRING(log_level, module, message);
28: END IF;
29:
30: EXCEPTION

Line 27: FND_LOG.STRING(log_level, module, message);

23: is
24:
25: begin
26: IF log_level >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
27: FND_LOG.STRING(log_level, module, message);
28: END IF;
29:
30: EXCEPTION
31: WHEN OTHERS THEN

Line 32: LogMessage(FND_LOG.LEVEL_UNEXPECTED, G_PKG_NAME, 'ERROR: ' || sqlerrm);

28: END IF;
29:
30: EXCEPTION
31: WHEN OTHERS THEN
32: LogMessage(FND_LOG.LEVEL_UNEXPECTED, G_PKG_NAME, 'ERROR: ' || sqlerrm);
33: end;
34:
35: /*
36: function loanHasAssignment(p_loan_id IN NUMBER

Line 177: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - BEGIN');

173:
174:
175: begin
176: l_api_name := 'processDisbursementFees';
177: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - BEGIN');
178: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - loan_id ' || p_loan_id);
179: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - p_phase' || p_phase);
180: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - p_disb_head_id' || p_disb_head_id);
181:

Line 178: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - loan_id ' || p_loan_id);

174:
175: begin
176: l_api_name := 'processDisbursementFees';
177: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - BEGIN');
178: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - loan_id ' || p_loan_id);
179: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - p_phase' || p_phase);
180: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - p_disb_head_id' || p_disb_head_id);
181:
182: -- Standard Start of API savepoint

Line 179: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - p_phase' || p_phase);

175: begin
176: l_api_name := 'processDisbursementFees';
177: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - BEGIN');
178: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - loan_id ' || p_loan_id);
179: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - p_phase' || p_phase);
180: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - p_disb_head_id' || p_disb_head_id);
181:
182: -- Standard Start of API savepoint
183: SAVEPOINT processDisbursementFees;

Line 180: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - p_disb_head_id' || p_disb_head_id);

176: l_api_name := 'processDisbursementFees';
177: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - BEGIN');
178: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - loan_id ' || p_loan_id);
179: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - p_phase' || p_phase);
180: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - p_disb_head_id' || p_disb_head_id);
181:
182: -- Standard Start of API savepoint
183: SAVEPOINT processDisbursementFees;
184:

Line 225: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - fee #: ' || i);

221: l_write_fee_tbl(i).fee_description := l_fee_description;
222: l_write_fee_tbl(i).disb_header_id := p_disb_head_id;
223: l_write_fee_tbl(i).phase := l_phase;
224:
225: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - fee #: ' || i);
226: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - fee id: ' || l_fee_id);
227: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - fee amount: ' || l_fee_amount);
228: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - l_fee_description: ' || l_fee_description);
229: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - l_fee_basis ' || l_fee_basis);

Line 226: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - fee id: ' || l_fee_id);

222: l_write_fee_tbl(i).disb_header_id := p_disb_head_id;
223: l_write_fee_tbl(i).phase := l_phase;
224:
225: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - fee #: ' || i);
226: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - fee id: ' || l_fee_id);
227: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - fee amount: ' || l_fee_amount);
228: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - l_fee_description: ' || l_fee_description);
229: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - l_fee_basis ' || l_fee_basis);
230: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - l_fee_installment ' || l_fee_installment);

Line 227: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - fee amount: ' || l_fee_amount);

223: l_write_fee_tbl(i).phase := l_phase;
224:
225: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - fee #: ' || i);
226: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - fee id: ' || l_fee_id);
227: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - fee amount: ' || l_fee_amount);
228: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - l_fee_description: ' || l_fee_description);
229: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - l_fee_basis ' || l_fee_basis);
230: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - l_fee_installment ' || l_fee_installment);
231: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - l_phase ' || l_phase);

Line 228: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - l_fee_description: ' || l_fee_description);

224:
225: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - fee #: ' || i);
226: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - fee id: ' || l_fee_id);
227: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - fee amount: ' || l_fee_amount);
228: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - l_fee_description: ' || l_fee_description);
229: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - l_fee_basis ' || l_fee_basis);
230: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - l_fee_installment ' || l_fee_installment);
231: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - l_phase ' || l_phase);
232:

Line 229: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - l_fee_basis ' || l_fee_basis);

225: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - fee #: ' || i);
226: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - fee id: ' || l_fee_id);
227: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - fee amount: ' || l_fee_amount);
228: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - l_fee_description: ' || l_fee_description);
229: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - l_fee_basis ' || l_fee_basis);
230: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - l_fee_installment ' || l_fee_installment);
231: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - l_phase ' || l_phase);
232:
233: END LOOP;

Line 230: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - l_fee_installment ' || l_fee_installment);

226: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - fee id: ' || l_fee_id);
227: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - fee amount: ' || l_fee_amount);
228: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - l_fee_description: ' || l_fee_description);
229: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - l_fee_basis ' || l_fee_basis);
230: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - l_fee_installment ' || l_fee_installment);
231: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - l_phase ' || l_phase);
232:
233: END LOOP;
234:

Line 231: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - l_phase ' || l_phase);

227: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - fee amount: ' || l_fee_amount);
228: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - l_fee_description: ' || l_fee_description);
229: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - l_fee_basis ' || l_fee_basis);
230: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - l_fee_installment ' || l_fee_installment);
231: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - l_phase ' || l_phase);
232:
233: END LOOP;
234:
235:

Line 267: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - fee #: ' || i);

263: l_write_fee_tbl(i).fee_description := l_fee_description;
264: l_write_fee_tbl(i).disb_header_id := p_disb_head_id;
265: l_write_fee_tbl(i).phase := p_phase;
266:
267: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - fee #: ' || i);
268: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - fee id: ' || l_fee_id);
269: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - fee amount: ' || l_fee_amount);
270: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - l_fee_description: ' || l_fee_description);
271: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - l_fee_basis ' || l_fee_basis);

Line 268: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - fee id: ' || l_fee_id);

264: l_write_fee_tbl(i).disb_header_id := p_disb_head_id;
265: l_write_fee_tbl(i).phase := p_phase;
266:
267: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - fee #: ' || i);
268: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - fee id: ' || l_fee_id);
269: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - fee amount: ' || l_fee_amount);
270: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - l_fee_description: ' || l_fee_description);
271: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - l_fee_basis ' || l_fee_basis);
272:

Line 269: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - fee amount: ' || l_fee_amount);

265: l_write_fee_tbl(i).phase := p_phase;
266:
267: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - fee #: ' || i);
268: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - fee id: ' || l_fee_id);
269: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - fee amount: ' || l_fee_amount);
270: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - l_fee_description: ' || l_fee_description);
271: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - l_fee_basis ' || l_fee_basis);
272:
273: l_fee_amount := null;

Line 270: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - l_fee_description: ' || l_fee_description);

266:
267: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - fee #: ' || i);
268: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - fee id: ' || l_fee_id);
269: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - fee amount: ' || l_fee_amount);
270: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - l_fee_description: ' || l_fee_description);
271: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - l_fee_basis ' || l_fee_basis);
272:
273: l_fee_amount := null;
274: l_fee_id := null;

Line 271: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - l_fee_basis ' || l_fee_basis);

267: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - fee #: ' || i);
268: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - fee id: ' || l_fee_id);
269: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - fee amount: ' || l_fee_amount);
270: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - l_fee_description: ' || l_fee_description);
271: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - l_fee_basis ' || l_fee_basis);
272:
273: l_fee_amount := null;
274: l_fee_id := null;
275: l_fee_basis := null;

Line 282: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - i ' || i);

278: CLOSE c_ConversionFees;
279: */
280: -- end if; -- if p_phase = 'OPEN'
281:
282: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - i ' || i);
283: if l_write_fee_tbl.count > 0 then
284: -- 3. writeFees to the fee schedule
285: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - writing fees schedule');
286: lns_fee_engine.writeFeeSchedule(p_init_msg_list => p_init_msg_list

Line 285: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - writing fees schedule');

281:
282: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - i ' || i);
283: if l_write_fee_tbl.count > 0 then
284: -- 3. writeFees to the fee schedule
285: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - writing fees schedule');
286: lns_fee_engine.writeFeeSchedule(p_init_msg_list => p_init_msg_list
287: ,p_commit => p_commit
288: ,p_loan_id => p_loan_id
289: ,p_fees_tbl => l_write_fee_tbl

Line 293: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - writing fees schedule status ' || l_return_status);

289: ,p_fees_tbl => l_write_fee_tbl
290: ,x_return_status => l_return_status
291: ,x_msg_count => l_msg_count
292: ,x_msg_data => l_msg_data);
293: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - writing fees schedule status ' || l_return_status);
294:
295: end if; -- l_write_fee_tb.count > 0
296:
297:

Line 306: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - END');

302: COMMIT WORK;
303: END IF;
304: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
305:
306: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - END');
307:
308: EXCEPTION
309: WHEN FND_API.G_EXC_ERROR THEN
310: x_return_status := FND_API.G_RET_STS_ERROR;

Line 314: logMessage(FND_LOG.LEVEL_ERROR, G_PKG_NAME, sqlerrm);

310: x_return_status := FND_API.G_RET_STS_ERROR;
311: x_msg_count := l_msg_count;
312: x_msg_data := l_msg_data;
313: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
314: logMessage(FND_LOG.LEVEL_ERROR, G_PKG_NAME, sqlerrm);
315: ROLLBACK TO processDisbursementFees;
316:
317: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
318: x_return_status := FND_API.G_RET_STS_ERROR;

Line 322: logMessage(FND_LOG.LEVEL_ERROR, G_PKG_NAME, sqlerrm);

318: x_return_status := FND_API.G_RET_STS_ERROR;
319: x_msg_count := l_msg_count;
320: x_msg_data := l_msg_data;
321: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
322: logMessage(FND_LOG.LEVEL_ERROR, G_PKG_NAME, sqlerrm);
323: ROLLBACK TO processDisbursementFees;
324:
325: WHEN OTHERS THEN
326: x_return_status := FND_API.G_RET_STS_ERROR;

Line 330: logMessage(FND_LOG.LEVEL_ERROR, G_PKG_NAME, sqlerrm);

326: x_return_status := FND_API.G_RET_STS_ERROR;
327: x_msg_count := l_msg_count;
328: x_msg_data := l_msg_data;
329: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
330: logMessage(FND_LOG.LEVEL_ERROR, G_PKG_NAME, sqlerrm);
331: ROLLBACK TO processDisbursementFees;
332:
333: end processDisbursementFees;
334:

Line 414: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - BEGIN');

410: and nvl(sched.phase, 'TERM') = nvl(c_phase, 'TERM');
411:
412: begin
413: l_api_name := 'reprocessFees';
414: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - BEGIN');
415: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - loan_id ' || p_loan_id);
416: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - installment' || p_installment_number);
417:
418: -- Standard Start of API savepoint

Line 415: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - loan_id ' || p_loan_id);

411:
412: begin
413: l_api_name := 'reprocessFees';
414: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - BEGIN');
415: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - loan_id ' || p_loan_id);
416: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - installment' || p_installment_number);
417:
418: -- Standard Start of API savepoint
419: SAVEPOINT reprocessFees;

Line 416: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - installment' || p_installment_number);

412: begin
413: l_api_name := 'reprocessFees';
414: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - BEGIN');
415: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - loan_id ' || p_loan_id);
416: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - installment' || p_installment_number);
417:
418: -- Standard Start of API savepoint
419: SAVEPOINT reprocessFees;
420:

Line 435: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - about to reprocess late fees');

431: -- ---------------------------------------------------------------------
432: -- initialize any variables here
433: i := 0;
434:
435: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - about to reprocess late fees');
436:
437: l_phase := nvl(p_phase, 'TERM');
438:
439: -- processing late fees will rewrite them to fee_schedules

Line 448: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - reprocess late fees status ' || l_return_status);

444: ,x_return_status => l_return_status
445: ,x_msg_count => l_msg_count
446: ,x_msg_data => l_msg_data);
447:
448: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - reprocess late fees status ' || l_return_status);
449: -- we will rewrite any previously written manual fees onto the fee schedule
450: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - finding manual and origination fees');
451: OPEN c_manual_fees(p_loan_id, p_installment_number, l_phase);
452: LOOP

Line 450: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - finding manual and origination fees');

446: ,x_msg_data => l_msg_data);
447:
448: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - reprocess late fees status ' || l_return_status);
449: -- we will rewrite any previously written manual fees onto the fee schedule
450: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - finding manual and origination fees');
451: OPEN c_manual_fees(p_loan_id, p_installment_number, l_phase);
452: LOOP
453: i := i + 1;
454: FETCH c_manual_fees INTO

Line 471: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - fee #: ' || i);

467: l_write_fee_tbl(i).fee_installment := p_installment_number;
468: l_write_fee_tbl(i).fee_description := l_fee_description;
469: l_write_fee_tbl(i).phase := l_phase;
470:
471: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - fee #: ' || i);
472: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - fee id: ' || l_fee_id);
473: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - fee amount: ' || l_fee_amount);
474: END LOOP;
475:

Line 472: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - fee id: ' || l_fee_id);

468: l_write_fee_tbl(i).fee_description := l_fee_description;
469: l_write_fee_tbl(i).phase := l_phase;
470:
471: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - fee #: ' || i);
472: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - fee id: ' || l_fee_id);
473: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - fee amount: ' || l_fee_amount);
474: END LOOP;
475:
476: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - writing fees schedule');

Line 473: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - fee amount: ' || l_fee_amount);

469: l_write_fee_tbl(i).phase := l_phase;
470:
471: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - fee #: ' || i);
472: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - fee id: ' || l_fee_id);
473: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - fee amount: ' || l_fee_amount);
474: END LOOP;
475:
476: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - writing fees schedule');
477: lns_fee_engine.writeFeeSchedule(p_init_msg_list => p_init_msg_list

Line 476: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - writing fees schedule');

472: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - fee id: ' || l_fee_id);
473: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - fee amount: ' || l_fee_amount);
474: END LOOP;
475:
476: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - writing fees schedule');
477: lns_fee_engine.writeFeeSchedule(p_init_msg_list => p_init_msg_list
478: ,p_commit => p_commit
479: ,p_loan_id => p_loan_id
480: ,p_fees_tbl => l_write_fee_tbl

Line 484: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - writing fees schedule status ' || l_return_status);

480: ,p_fees_tbl => l_write_fee_tbl
481: ,x_return_status => l_return_status
482: ,x_msg_count => l_msg_count
483: ,x_msg_data => l_msg_data);
484: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - writing fees schedule status ' || l_return_status);
485:
486: -- ---------------------------------------------------------------------
487: -- End of API body
488: -- ---------------------------------------------------------------------

Line 491: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - END');

487: -- End of API body
488: -- ---------------------------------------------------------------------
489: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
490:
491: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - END');
492:
493: EXCEPTION
494: WHEN FND_API.G_EXC_ERROR THEN
495: x_return_status := FND_API.G_RET_STS_ERROR;

Line 499: logMessage(FND_LOG.LEVEL_ERROR, G_PKG_NAME, sqlerrm);

495: x_return_status := FND_API.G_RET_STS_ERROR;
496: x_msg_count := l_msg_count;
497: x_msg_data := l_msg_data;
498: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
499: logMessage(FND_LOG.LEVEL_ERROR, G_PKG_NAME, sqlerrm);
500: ROLLBACK TO reprocessFees;
501:
502: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
503: x_return_status := FND_API.G_RET_STS_ERROR;

Line 507: logMessage(FND_LOG.LEVEL_ERROR, G_PKG_NAME, sqlerrm);

503: x_return_status := FND_API.G_RET_STS_ERROR;
504: x_msg_count := l_msg_count;
505: x_msg_data := l_msg_data;
506: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
507: logMessage(FND_LOG.LEVEL_ERROR, G_PKG_NAME, sqlerrm);
508: ROLLBACK TO reprocessFees;
509:
510: WHEN OTHERS THEN
511: x_return_status := FND_API.G_RET_STS_ERROR;

Line 515: logMessage(FND_LOG.LEVEL_ERROR, G_PKG_NAME, sqlerrm);

511: x_return_status := FND_API.G_RET_STS_ERROR;
512: x_msg_count := l_msg_count;
513: x_msg_data := l_msg_data;
514: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
515: logMessage(FND_LOG.LEVEL_ERROR, G_PKG_NAME, sqlerrm);
516: ROLLBACK TO reprocessFees;
517:
518: end reprocessFees;
519:

Line 626: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - no fee structures found');

622: return l_fee_struct_tbl;
623:
624: exception
625: when no_data_found then
626: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - no fee structures found');
627: end getFeeStructures;
628:
629: /*=========================================================================
630: || PUBLIC FUNCTION getFeeStructures LNS.B

Line 736: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - p_loan_id ' || p_loan_id);

732: and assgn.billing_option = nvl(p_billing_option, assgn.billing_option);
733:
734: begin
735: l_api_name := 'getFeeStructures';
736: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - p_loan_id ' || p_loan_id);
737: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - fee_category ' || p_fee_category);
738: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - fee_type ' || p_fee_type);
739: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - p_installment ' || p_installment);
740: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - p_phase ' || p_phase);

Line 737: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - fee_category ' || p_fee_category);

733:
734: begin
735: l_api_name := 'getFeeStructures';
736: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - p_loan_id ' || p_loan_id);
737: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - fee_category ' || p_fee_category);
738: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - fee_type ' || p_fee_type);
739: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - p_installment ' || p_installment);
740: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - p_phase ' || p_phase);
741: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - p_fee_id ' || p_fee_id);

Line 738: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - fee_type ' || p_fee_type);

734: begin
735: l_api_name := 'getFeeStructures';
736: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - p_loan_id ' || p_loan_id);
737: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - fee_category ' || p_fee_category);
738: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - fee_type ' || p_fee_type);
739: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - p_installment ' || p_installment);
740: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - p_phase ' || p_phase);
741: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - p_fee_id ' || p_fee_id);
742: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - p_billing_option ' || p_billing_option);

Line 739: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - p_installment ' || p_installment);

735: l_api_name := 'getFeeStructures';
736: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - p_loan_id ' || p_loan_id);
737: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - fee_category ' || p_fee_category);
738: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - fee_type ' || p_fee_type);
739: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - p_installment ' || p_installment);
740: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - p_phase ' || p_phase);
741: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - p_fee_id ' || p_fee_id);
742: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - p_billing_option ' || p_billing_option);
743:

Line 740: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - p_phase ' || p_phase);

736: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - p_loan_id ' || p_loan_id);
737: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - fee_category ' || p_fee_category);
738: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - fee_type ' || p_fee_type);
739: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - p_installment ' || p_installment);
740: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - p_phase ' || p_phase);
741: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - p_fee_id ' || p_fee_id);
742: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - p_billing_option ' || p_billing_option);
743:
744: l_phase := nvl(p_phase, 'TERM');

Line 741: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - p_fee_id ' || p_fee_id);

737: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - fee_category ' || p_fee_category);
738: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - fee_type ' || p_fee_type);
739: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - p_installment ' || p_installment);
740: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - p_phase ' || p_phase);
741: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - p_fee_id ' || p_fee_id);
742: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - p_billing_option ' || p_billing_option);
743:
744: l_phase := nvl(p_phase, 'TERM');
745:

Line 742: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - p_billing_option ' || p_billing_option);

738: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - fee_type ' || p_fee_type);
739: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - p_installment ' || p_installment);
740: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - p_phase ' || p_phase);
741: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - p_fee_id ' || p_fee_id);
742: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - p_billing_option ' || p_billing_option);
743:
744: l_phase := nvl(p_phase, 'TERM');
745:
746: open c_fees(p_loan_id, p_fee_id, p_fee_category, p_fee_type, p_installment, l_phase, p_billing_option);

Line 791: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, ' ');

787: l_fee_struct_tbl(i).disb_header_id := l_disb_header_id;
788: l_fee_struct_tbl(i).phase := l_phase;
789: l_fee_struct_tbl(i).CUSTOM_PROCEDURE := l_CUSTOM_PROCEDURE;
790:
791: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, ' ');
792: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, l_api_name || ' - structure #' || i);
793: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, l_api_name || ' - l_fee_struct_tbl(i).fee_id = ' || l_fee_struct_tbl(i).fee_id);
794: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, l_api_name || ' - l_fee_struct_tbl(i).fee_name = ' || l_fee_struct_tbl(i).fee_name);
795: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, l_api_name || ' - l_fee_struct_tbl(i).fee_type = ' || l_fee_struct_tbl(i).fee_type);

Line 792: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, l_api_name || ' - structure #' || i);

788: l_fee_struct_tbl(i).phase := l_phase;
789: l_fee_struct_tbl(i).CUSTOM_PROCEDURE := l_CUSTOM_PROCEDURE;
790:
791: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, ' ');
792: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, l_api_name || ' - structure #' || i);
793: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, l_api_name || ' - l_fee_struct_tbl(i).fee_id = ' || l_fee_struct_tbl(i).fee_id);
794: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, l_api_name || ' - l_fee_struct_tbl(i).fee_name = ' || l_fee_struct_tbl(i).fee_name);
795: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, l_api_name || ' - l_fee_struct_tbl(i).fee_type = ' || l_fee_struct_tbl(i).fee_type);
796: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, l_api_name || ' - l_fee_struct_tbl(i).fee_category = ' || l_fee_struct_tbl(i).fee_category);

Line 793: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, l_api_name || ' - l_fee_struct_tbl(i).fee_id = ' || l_fee_struct_tbl(i).fee_id);

789: l_fee_struct_tbl(i).CUSTOM_PROCEDURE := l_CUSTOM_PROCEDURE;
790:
791: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, ' ');
792: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, l_api_name || ' - structure #' || i);
793: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, l_api_name || ' - l_fee_struct_tbl(i).fee_id = ' || l_fee_struct_tbl(i).fee_id);
794: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, l_api_name || ' - l_fee_struct_tbl(i).fee_name = ' || l_fee_struct_tbl(i).fee_name);
795: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, l_api_name || ' - l_fee_struct_tbl(i).fee_type = ' || l_fee_struct_tbl(i).fee_type);
796: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, l_api_name || ' - l_fee_struct_tbl(i).fee_category = ' || l_fee_struct_tbl(i).fee_category);
797: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, l_api_name || ' - l_fee_struct_tbl(i).fee_description = ' || l_fee_struct_tbl(i).fee_description);

Line 794: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, l_api_name || ' - l_fee_struct_tbl(i).fee_name = ' || l_fee_struct_tbl(i).fee_name);

790:
791: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, ' ');
792: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, l_api_name || ' - structure #' || i);
793: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, l_api_name || ' - l_fee_struct_tbl(i).fee_id = ' || l_fee_struct_tbl(i).fee_id);
794: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, l_api_name || ' - l_fee_struct_tbl(i).fee_name = ' || l_fee_struct_tbl(i).fee_name);
795: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, l_api_name || ' - l_fee_struct_tbl(i).fee_type = ' || l_fee_struct_tbl(i).fee_type);
796: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, l_api_name || ' - l_fee_struct_tbl(i).fee_category = ' || l_fee_struct_tbl(i).fee_category);
797: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, l_api_name || ' - l_fee_struct_tbl(i).fee_description = ' || l_fee_struct_tbl(i).fee_description);
798: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, l_api_name || ' - l_fee_struct_tbl(i).fee_amount = ' || l_fee_struct_tbl(i).fee_amount);

Line 795: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, l_api_name || ' - l_fee_struct_tbl(i).fee_type = ' || l_fee_struct_tbl(i).fee_type);

791: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, ' ');
792: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, l_api_name || ' - structure #' || i);
793: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, l_api_name || ' - l_fee_struct_tbl(i).fee_id = ' || l_fee_struct_tbl(i).fee_id);
794: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, l_api_name || ' - l_fee_struct_tbl(i).fee_name = ' || l_fee_struct_tbl(i).fee_name);
795: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, l_api_name || ' - l_fee_struct_tbl(i).fee_type = ' || l_fee_struct_tbl(i).fee_type);
796: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, l_api_name || ' - l_fee_struct_tbl(i).fee_category = ' || l_fee_struct_tbl(i).fee_category);
797: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, l_api_name || ' - l_fee_struct_tbl(i).fee_description = ' || l_fee_struct_tbl(i).fee_description);
798: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, l_api_name || ' - l_fee_struct_tbl(i).fee_amount = ' || l_fee_struct_tbl(i).fee_amount);
799: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, l_api_name || ' - l_fee_struct_tbl(i).fee_basis = ' || l_fee_struct_tbl(i).fee_basis);

Line 796: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, l_api_name || ' - l_fee_struct_tbl(i).fee_category = ' || l_fee_struct_tbl(i).fee_category);

792: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, l_api_name || ' - structure #' || i);
793: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, l_api_name || ' - l_fee_struct_tbl(i).fee_id = ' || l_fee_struct_tbl(i).fee_id);
794: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, l_api_name || ' - l_fee_struct_tbl(i).fee_name = ' || l_fee_struct_tbl(i).fee_name);
795: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, l_api_name || ' - l_fee_struct_tbl(i).fee_type = ' || l_fee_struct_tbl(i).fee_type);
796: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, l_api_name || ' - l_fee_struct_tbl(i).fee_category = ' || l_fee_struct_tbl(i).fee_category);
797: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, l_api_name || ' - l_fee_struct_tbl(i).fee_description = ' || l_fee_struct_tbl(i).fee_description);
798: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, l_api_name || ' - l_fee_struct_tbl(i).fee_amount = ' || l_fee_struct_tbl(i).fee_amount);
799: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, l_api_name || ' - l_fee_struct_tbl(i).fee_basis = ' || l_fee_struct_tbl(i).fee_basis);
800: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, l_api_name || ' - l_fee_struct_tbl(i).fee_basis_rule = ' || l_fee_struct_tbl(i).fee_basis_rule);

Line 797: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, l_api_name || ' - l_fee_struct_tbl(i).fee_description = ' || l_fee_struct_tbl(i).fee_description);

793: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, l_api_name || ' - l_fee_struct_tbl(i).fee_id = ' || l_fee_struct_tbl(i).fee_id);
794: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, l_api_name || ' - l_fee_struct_tbl(i).fee_name = ' || l_fee_struct_tbl(i).fee_name);
795: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, l_api_name || ' - l_fee_struct_tbl(i).fee_type = ' || l_fee_struct_tbl(i).fee_type);
796: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, l_api_name || ' - l_fee_struct_tbl(i).fee_category = ' || l_fee_struct_tbl(i).fee_category);
797: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, l_api_name || ' - l_fee_struct_tbl(i).fee_description = ' || l_fee_struct_tbl(i).fee_description);
798: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, l_api_name || ' - l_fee_struct_tbl(i).fee_amount = ' || l_fee_struct_tbl(i).fee_amount);
799: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, l_api_name || ' - l_fee_struct_tbl(i).fee_basis = ' || l_fee_struct_tbl(i).fee_basis);
800: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, l_api_name || ' - l_fee_struct_tbl(i).fee_basis_rule = ' || l_fee_struct_tbl(i).fee_basis_rule);
801: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, l_api_name || ' - l_fee_struct_tbl(i).fee_billing_option = ' || l_fee_struct_tbl(i).fee_billing_option);

Line 798: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, l_api_name || ' - l_fee_struct_tbl(i).fee_amount = ' || l_fee_struct_tbl(i).fee_amount);

794: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, l_api_name || ' - l_fee_struct_tbl(i).fee_name = ' || l_fee_struct_tbl(i).fee_name);
795: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, l_api_name || ' - l_fee_struct_tbl(i).fee_type = ' || l_fee_struct_tbl(i).fee_type);
796: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, l_api_name || ' - l_fee_struct_tbl(i).fee_category = ' || l_fee_struct_tbl(i).fee_category);
797: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, l_api_name || ' - l_fee_struct_tbl(i).fee_description = ' || l_fee_struct_tbl(i).fee_description);
798: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, l_api_name || ' - l_fee_struct_tbl(i).fee_amount = ' || l_fee_struct_tbl(i).fee_amount);
799: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, l_api_name || ' - l_fee_struct_tbl(i).fee_basis = ' || l_fee_struct_tbl(i).fee_basis);
800: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, l_api_name || ' - l_fee_struct_tbl(i).fee_basis_rule = ' || l_fee_struct_tbl(i).fee_basis_rule);
801: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, l_api_name || ' - l_fee_struct_tbl(i).fee_billing_option = ' || l_fee_struct_tbl(i).fee_billing_option);
802: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, l_api_name || ' - l_fee_struct_tbl(i).fee_rate_type = ' || l_fee_struct_tbl(i).fee_rate_type);

Line 799: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, l_api_name || ' - l_fee_struct_tbl(i).fee_basis = ' || l_fee_struct_tbl(i).fee_basis);

795: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, l_api_name || ' - l_fee_struct_tbl(i).fee_type = ' || l_fee_struct_tbl(i).fee_type);
796: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, l_api_name || ' - l_fee_struct_tbl(i).fee_category = ' || l_fee_struct_tbl(i).fee_category);
797: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, l_api_name || ' - l_fee_struct_tbl(i).fee_description = ' || l_fee_struct_tbl(i).fee_description);
798: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, l_api_name || ' - l_fee_struct_tbl(i).fee_amount = ' || l_fee_struct_tbl(i).fee_amount);
799: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, l_api_name || ' - l_fee_struct_tbl(i).fee_basis = ' || l_fee_struct_tbl(i).fee_basis);
800: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, l_api_name || ' - l_fee_struct_tbl(i).fee_basis_rule = ' || l_fee_struct_tbl(i).fee_basis_rule);
801: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, l_api_name || ' - l_fee_struct_tbl(i).fee_billing_option = ' || l_fee_struct_tbl(i).fee_billing_option);
802: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, l_api_name || ' - l_fee_struct_tbl(i).fee_rate_type = ' || l_fee_struct_tbl(i).fee_rate_type);
803: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, l_api_name || ' - l_fee_struct_tbl(i).number_grace_days = ' || l_fee_struct_tbl(i).number_grace_days);

Line 800: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, l_api_name || ' - l_fee_struct_tbl(i).fee_basis_rule = ' || l_fee_struct_tbl(i).fee_basis_rule);

796: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, l_api_name || ' - l_fee_struct_tbl(i).fee_category = ' || l_fee_struct_tbl(i).fee_category);
797: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, l_api_name || ' - l_fee_struct_tbl(i).fee_description = ' || l_fee_struct_tbl(i).fee_description);
798: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, l_api_name || ' - l_fee_struct_tbl(i).fee_amount = ' || l_fee_struct_tbl(i).fee_amount);
799: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, l_api_name || ' - l_fee_struct_tbl(i).fee_basis = ' || l_fee_struct_tbl(i).fee_basis);
800: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, l_api_name || ' - l_fee_struct_tbl(i).fee_basis_rule = ' || l_fee_struct_tbl(i).fee_basis_rule);
801: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, l_api_name || ' - l_fee_struct_tbl(i).fee_billing_option = ' || l_fee_struct_tbl(i).fee_billing_option);
802: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, l_api_name || ' - l_fee_struct_tbl(i).fee_rate_type = ' || l_fee_struct_tbl(i).fee_rate_type);
803: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, l_api_name || ' - l_fee_struct_tbl(i).number_grace_days = ' || l_fee_struct_tbl(i).number_grace_days);
804: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, l_api_name || ' - l_fee_struct_tbl(i).minimum_overdue_amount = ' || l_fee_struct_tbl(i).minimum_overdue_amount);

Line 801: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, l_api_name || ' - l_fee_struct_tbl(i).fee_billing_option = ' || l_fee_struct_tbl(i).fee_billing_option);

797: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, l_api_name || ' - l_fee_struct_tbl(i).fee_description = ' || l_fee_struct_tbl(i).fee_description);
798: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, l_api_name || ' - l_fee_struct_tbl(i).fee_amount = ' || l_fee_struct_tbl(i).fee_amount);
799: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, l_api_name || ' - l_fee_struct_tbl(i).fee_basis = ' || l_fee_struct_tbl(i).fee_basis);
800: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, l_api_name || ' - l_fee_struct_tbl(i).fee_basis_rule = ' || l_fee_struct_tbl(i).fee_basis_rule);
801: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, l_api_name || ' - l_fee_struct_tbl(i).fee_billing_option = ' || l_fee_struct_tbl(i).fee_billing_option);
802: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, l_api_name || ' - l_fee_struct_tbl(i).fee_rate_type = ' || l_fee_struct_tbl(i).fee_rate_type);
803: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, l_api_name || ' - l_fee_struct_tbl(i).number_grace_days = ' || l_fee_struct_tbl(i).number_grace_days);
804: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, l_api_name || ' - l_fee_struct_tbl(i).minimum_overdue_amount = ' || l_fee_struct_tbl(i).minimum_overdue_amount);
805: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, l_api_name || ' - l_fee_struct_tbl(i).fee_from_installment = ' || l_fee_struct_tbl(i).fee_from_installment);

Line 802: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, l_api_name || ' - l_fee_struct_tbl(i).fee_rate_type = ' || l_fee_struct_tbl(i).fee_rate_type);

798: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, l_api_name || ' - l_fee_struct_tbl(i).fee_amount = ' || l_fee_struct_tbl(i).fee_amount);
799: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, l_api_name || ' - l_fee_struct_tbl(i).fee_basis = ' || l_fee_struct_tbl(i).fee_basis);
800: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, l_api_name || ' - l_fee_struct_tbl(i).fee_basis_rule = ' || l_fee_struct_tbl(i).fee_basis_rule);
801: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, l_api_name || ' - l_fee_struct_tbl(i).fee_billing_option = ' || l_fee_struct_tbl(i).fee_billing_option);
802: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, l_api_name || ' - l_fee_struct_tbl(i).fee_rate_type = ' || l_fee_struct_tbl(i).fee_rate_type);
803: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, l_api_name || ' - l_fee_struct_tbl(i).number_grace_days = ' || l_fee_struct_tbl(i).number_grace_days);
804: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, l_api_name || ' - l_fee_struct_tbl(i).minimum_overdue_amount = ' || l_fee_struct_tbl(i).minimum_overdue_amount);
805: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, l_api_name || ' - l_fee_struct_tbl(i).fee_from_installment = ' || l_fee_struct_tbl(i).fee_from_installment);
806: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, l_api_name || ' - l_fee_struct_tbl(i).fee_to_installment = ' || l_fee_struct_tbl(i).fee_to_installment);

Line 803: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, l_api_name || ' - l_fee_struct_tbl(i).number_grace_days = ' || l_fee_struct_tbl(i).number_grace_days);

799: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, l_api_name || ' - l_fee_struct_tbl(i).fee_basis = ' || l_fee_struct_tbl(i).fee_basis);
800: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, l_api_name || ' - l_fee_struct_tbl(i).fee_basis_rule = ' || l_fee_struct_tbl(i).fee_basis_rule);
801: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, l_api_name || ' - l_fee_struct_tbl(i).fee_billing_option = ' || l_fee_struct_tbl(i).fee_billing_option);
802: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, l_api_name || ' - l_fee_struct_tbl(i).fee_rate_type = ' || l_fee_struct_tbl(i).fee_rate_type);
803: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, l_api_name || ' - l_fee_struct_tbl(i).number_grace_days = ' || l_fee_struct_tbl(i).number_grace_days);
804: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, l_api_name || ' - l_fee_struct_tbl(i).minimum_overdue_amount = ' || l_fee_struct_tbl(i).minimum_overdue_amount);
805: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, l_api_name || ' - l_fee_struct_tbl(i).fee_from_installment = ' || l_fee_struct_tbl(i).fee_from_installment);
806: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, l_api_name || ' - l_fee_struct_tbl(i).fee_to_installment = ' || l_fee_struct_tbl(i).fee_to_installment);
807: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, l_api_name || ' - l_fee_struct_tbl(i).fee_editable_flag = ' || l_fee_struct_tbl(i).fee_editable_flag);

Line 804: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, l_api_name || ' - l_fee_struct_tbl(i).minimum_overdue_amount = ' || l_fee_struct_tbl(i).minimum_overdue_amount);

800: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, l_api_name || ' - l_fee_struct_tbl(i).fee_basis_rule = ' || l_fee_struct_tbl(i).fee_basis_rule);
801: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, l_api_name || ' - l_fee_struct_tbl(i).fee_billing_option = ' || l_fee_struct_tbl(i).fee_billing_option);
802: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, l_api_name || ' - l_fee_struct_tbl(i).fee_rate_type = ' || l_fee_struct_tbl(i).fee_rate_type);
803: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, l_api_name || ' - l_fee_struct_tbl(i).number_grace_days = ' || l_fee_struct_tbl(i).number_grace_days);
804: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, l_api_name || ' - l_fee_struct_tbl(i).minimum_overdue_amount = ' || l_fee_struct_tbl(i).minimum_overdue_amount);
805: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, l_api_name || ' - l_fee_struct_tbl(i).fee_from_installment = ' || l_fee_struct_tbl(i).fee_from_installment);
806: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, l_api_name || ' - l_fee_struct_tbl(i).fee_to_installment = ' || l_fee_struct_tbl(i).fee_to_installment);
807: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, l_api_name || ' - l_fee_struct_tbl(i).fee_editable_flag = ' || l_fee_struct_tbl(i).fee_editable_flag);
808: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, l_api_name || ' - l_fee_struct_tbl(i).disb_header_id = ' || l_fee_struct_tbl(i).disb_header_id);

Line 805: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, l_api_name || ' - l_fee_struct_tbl(i).fee_from_installment = ' || l_fee_struct_tbl(i).fee_from_installment);

801: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, l_api_name || ' - l_fee_struct_tbl(i).fee_billing_option = ' || l_fee_struct_tbl(i).fee_billing_option);
802: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, l_api_name || ' - l_fee_struct_tbl(i).fee_rate_type = ' || l_fee_struct_tbl(i).fee_rate_type);
803: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, l_api_name || ' - l_fee_struct_tbl(i).number_grace_days = ' || l_fee_struct_tbl(i).number_grace_days);
804: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, l_api_name || ' - l_fee_struct_tbl(i).minimum_overdue_amount = ' || l_fee_struct_tbl(i).minimum_overdue_amount);
805: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, l_api_name || ' - l_fee_struct_tbl(i).fee_from_installment = ' || l_fee_struct_tbl(i).fee_from_installment);
806: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, l_api_name || ' - l_fee_struct_tbl(i).fee_to_installment = ' || l_fee_struct_tbl(i).fee_to_installment);
807: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, l_api_name || ' - l_fee_struct_tbl(i).fee_editable_flag = ' || l_fee_struct_tbl(i).fee_editable_flag);
808: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, l_api_name || ' - l_fee_struct_tbl(i).disb_header_id = ' || l_fee_struct_tbl(i).disb_header_id);
809: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, l_api_name || ' - l_fee_struct_tbl(i).phase = ' || l_fee_struct_tbl(i).phase);

Line 806: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, l_api_name || ' - l_fee_struct_tbl(i).fee_to_installment = ' || l_fee_struct_tbl(i).fee_to_installment);

802: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, l_api_name || ' - l_fee_struct_tbl(i).fee_rate_type = ' || l_fee_struct_tbl(i).fee_rate_type);
803: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, l_api_name || ' - l_fee_struct_tbl(i).number_grace_days = ' || l_fee_struct_tbl(i).number_grace_days);
804: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, l_api_name || ' - l_fee_struct_tbl(i).minimum_overdue_amount = ' || l_fee_struct_tbl(i).minimum_overdue_amount);
805: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, l_api_name || ' - l_fee_struct_tbl(i).fee_from_installment = ' || l_fee_struct_tbl(i).fee_from_installment);
806: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, l_api_name || ' - l_fee_struct_tbl(i).fee_to_installment = ' || l_fee_struct_tbl(i).fee_to_installment);
807: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, l_api_name || ' - l_fee_struct_tbl(i).fee_editable_flag = ' || l_fee_struct_tbl(i).fee_editable_flag);
808: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, l_api_name || ' - l_fee_struct_tbl(i).disb_header_id = ' || l_fee_struct_tbl(i).disb_header_id);
809: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, l_api_name || ' - l_fee_struct_tbl(i).phase = ' || l_fee_struct_tbl(i).phase);
810: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, l_api_name || ' - l_fee_struct_tbl(i).CUSTOM_PROCEDURE = ' || l_fee_struct_tbl(i).CUSTOM_PROCEDURE);

Line 807: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, l_api_name || ' - l_fee_struct_tbl(i).fee_editable_flag = ' || l_fee_struct_tbl(i).fee_editable_flag);

803: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, l_api_name || ' - l_fee_struct_tbl(i).number_grace_days = ' || l_fee_struct_tbl(i).number_grace_days);
804: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, l_api_name || ' - l_fee_struct_tbl(i).minimum_overdue_amount = ' || l_fee_struct_tbl(i).minimum_overdue_amount);
805: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, l_api_name || ' - l_fee_struct_tbl(i).fee_from_installment = ' || l_fee_struct_tbl(i).fee_from_installment);
806: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, l_api_name || ' - l_fee_struct_tbl(i).fee_to_installment = ' || l_fee_struct_tbl(i).fee_to_installment);
807: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, l_api_name || ' - l_fee_struct_tbl(i).fee_editable_flag = ' || l_fee_struct_tbl(i).fee_editable_flag);
808: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, l_api_name || ' - l_fee_struct_tbl(i).disb_header_id = ' || l_fee_struct_tbl(i).disb_header_id);
809: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, l_api_name || ' - l_fee_struct_tbl(i).phase = ' || l_fee_struct_tbl(i).phase);
810: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, l_api_name || ' - l_fee_struct_tbl(i).CUSTOM_PROCEDURE = ' || l_fee_struct_tbl(i).CUSTOM_PROCEDURE);
811:

Line 808: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, l_api_name || ' - l_fee_struct_tbl(i).disb_header_id = ' || l_fee_struct_tbl(i).disb_header_id);

804: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, l_api_name || ' - l_fee_struct_tbl(i).minimum_overdue_amount = ' || l_fee_struct_tbl(i).minimum_overdue_amount);
805: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, l_api_name || ' - l_fee_struct_tbl(i).fee_from_installment = ' || l_fee_struct_tbl(i).fee_from_installment);
806: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, l_api_name || ' - l_fee_struct_tbl(i).fee_to_installment = ' || l_fee_struct_tbl(i).fee_to_installment);
807: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, l_api_name || ' - l_fee_struct_tbl(i).fee_editable_flag = ' || l_fee_struct_tbl(i).fee_editable_flag);
808: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, l_api_name || ' - l_fee_struct_tbl(i).disb_header_id = ' || l_fee_struct_tbl(i).disb_header_id);
809: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, l_api_name || ' - l_fee_struct_tbl(i).phase = ' || l_fee_struct_tbl(i).phase);
810: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, l_api_name || ' - l_fee_struct_tbl(i).CUSTOM_PROCEDURE = ' || l_fee_struct_tbl(i).CUSTOM_PROCEDURE);
811:
812: end loop;

Line 809: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, l_api_name || ' - l_fee_struct_tbl(i).phase = ' || l_fee_struct_tbl(i).phase);

805: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, l_api_name || ' - l_fee_struct_tbl(i).fee_from_installment = ' || l_fee_struct_tbl(i).fee_from_installment);
806: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, l_api_name || ' - l_fee_struct_tbl(i).fee_to_installment = ' || l_fee_struct_tbl(i).fee_to_installment);
807: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, l_api_name || ' - l_fee_struct_tbl(i).fee_editable_flag = ' || l_fee_struct_tbl(i).fee_editable_flag);
808: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, l_api_name || ' - l_fee_struct_tbl(i).disb_header_id = ' || l_fee_struct_tbl(i).disb_header_id);
809: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, l_api_name || ' - l_fee_struct_tbl(i).phase = ' || l_fee_struct_tbl(i).phase);
810: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, l_api_name || ' - l_fee_struct_tbl(i).CUSTOM_PROCEDURE = ' || l_fee_struct_tbl(i).CUSTOM_PROCEDURE);
811:
812: end loop;
813: close c_fees;

Line 810: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, l_api_name || ' - l_fee_struct_tbl(i).CUSTOM_PROCEDURE = ' || l_fee_struct_tbl(i).CUSTOM_PROCEDURE);

806: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, l_api_name || ' - l_fee_struct_tbl(i).fee_to_installment = ' || l_fee_struct_tbl(i).fee_to_installment);
807: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, l_api_name || ' - l_fee_struct_tbl(i).fee_editable_flag = ' || l_fee_struct_tbl(i).fee_editable_flag);
808: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, l_api_name || ' - l_fee_struct_tbl(i).disb_header_id = ' || l_fee_struct_tbl(i).disb_header_id);
809: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, l_api_name || ' - l_fee_struct_tbl(i).phase = ' || l_fee_struct_tbl(i).phase);
810: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, l_api_name || ' - l_fee_struct_tbl(i).CUSTOM_PROCEDURE = ' || l_fee_struct_tbl(i).CUSTOM_PROCEDURE);
811:
812: end loop;
813: close c_fees;
814:

Line 819: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - no fee structures found');

815: return l_fee_struct_tbl;
816:
817: exception
818: when no_data_found then
819: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - no fee structures found');
820: end getFeeStructures;
821:
822: /*=========================================================================
823: || PUBLIC FUNCTION getDisbursementFeeStructures R12

Line 909: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - p_installment_no ' || p_installment_no);

905: and nvl(assgn.phase, 'TERM') = c_phase;
906:
907: begin
908: l_api_name := 'getDisbursementFeeStructures';
909: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - p_installment_no ' || p_installment_no);
910: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - p_phase ' || p_phase);
911: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - p_loan_id ' || p_loan_id);
912: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - p_disb_header_id ' || p_disb_header_id);
913: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - p_fee_id ' || p_fee_id);

Line 910: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - p_phase ' || p_phase);

906:
907: begin
908: l_api_name := 'getDisbursementFeeStructures';
909: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - p_installment_no ' || p_installment_no);
910: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - p_phase ' || p_phase);
911: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - p_loan_id ' || p_loan_id);
912: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - p_disb_header_id ' || p_disb_header_id);
913: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - p_fee_id ' || p_fee_id);
914:

Line 911: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - p_loan_id ' || p_loan_id);

907: begin
908: l_api_name := 'getDisbursementFeeStructures';
909: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - p_installment_no ' || p_installment_no);
910: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - p_phase ' || p_phase);
911: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - p_loan_id ' || p_loan_id);
912: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - p_disb_header_id ' || p_disb_header_id);
913: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - p_fee_id ' || p_fee_id);
914:
915: l_phase := nvl(p_phase, 'TERM');

Line 912: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - p_disb_header_id ' || p_disb_header_id);

908: l_api_name := 'getDisbursementFeeStructures';
909: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - p_installment_no ' || p_installment_no);
910: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - p_phase ' || p_phase);
911: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - p_loan_id ' || p_loan_id);
912: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - p_disb_header_id ' || p_disb_header_id);
913: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - p_fee_id ' || p_fee_id);
914:
915: l_phase := nvl(p_phase, 'TERM');
916:

Line 913: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - p_fee_id ' || p_fee_id);

909: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - p_installment_no ' || p_installment_no);
910: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - p_phase ' || p_phase);
911: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - p_loan_id ' || p_loan_id);
912: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - p_disb_header_id ' || p_disb_header_id);
913: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - p_fee_id ' || p_fee_id);
914:
915: l_phase := nvl(p_phase, 'TERM');
916:
917:

Line 960: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - no fee structures found');

956: return l_fee_struct_tbl;
957:
958: exception
959: when no_data_found then
960: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - no fee structures found');
961: end getDisbursementFeeStructures;
962:
963:
964: /*=========================================================================

Line 1026: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - p_fee_id ' || p_fee_id);

1022: begin
1023:
1024: l_amount := 0;
1025: l_api_name := 'calculateFee';
1026: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - p_fee_id ' || p_fee_id);
1027: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - p_disb_header_id ' || p_disb_header_id );
1028: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - calculating ' || p_loan_id);
1029:
1030: open c_origLoanAmt(p_loan_id);

Line 1027: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - p_disb_header_id ' || p_disb_header_id );

1023:
1024: l_amount := 0;
1025: l_api_name := 'calculateFee';
1026: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - p_fee_id ' || p_fee_id);
1027: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - p_disb_header_id ' || p_disb_header_id );
1028: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - calculating ' || p_loan_id);
1029:
1030: open c_origLoanAmt(p_loan_id);
1031: fetch c_origLoanAmt into l_original_loan_amount, l_phase;

Line 1028: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - calculating ' || p_loan_id);

1024: l_amount := 0;
1025: l_api_name := 'calculateFee';
1026: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - p_fee_id ' || p_fee_id);
1027: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - p_disb_header_id ' || p_disb_header_id );
1028: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - calculating ' || p_loan_id);
1029:
1030: open c_origLoanAmt(p_loan_id);
1031: fetch c_origLoanAmt into l_original_loan_amount, l_phase;
1032: close c_origLoanAmt;

Line 1042: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - getting DIsb fee structures');

1038: ,p_phase => l_phase);
1039:
1040: elsif p_disb_header_id is not null then
1041:
1042: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - getting DIsb fee structures');
1043: l_orig_fee_structures := lns_fee_engine.getDisbursementFeeStructures(p_loan_id => null
1044: ,p_installment_no => null
1045: -- Bug#9255294, Change after adding new column phase in disbHdr table
1046: ,p_phase => l_phase

Line 1049: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - struct count is ' || l_orig_fee_structures.count);

1045: -- Bug#9255294, Change after adding new column phase in disbHdr table
1046: ,p_phase => l_phase
1047: ,p_disb_header_id => p_disb_header_id
1048: ,p_fee_id => p_fee_id);
1049: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - struct count is ' || l_orig_fee_structures.count);
1050:
1051: l_fee_basis_tbl(1).fee_basis_name := 'ORIG_LOAN';
1052: l_fee_basis_tbl(1).fee_basis_amount := l_original_loan_amount;
1053: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - orig_loan ' || l_original_loan_amount);

Line 1053: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - orig_loan ' || l_original_loan_amount);

1049: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - struct count is ' || l_orig_fee_structures.count);
1050:
1051: l_fee_basis_tbl(1).fee_basis_name := 'ORIG_LOAN';
1052: l_fee_basis_tbl(1).fee_basis_amount := l_original_loan_amount;
1053: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - orig_loan ' || l_original_loan_amount);
1054:
1055: IF l_orig_fee_structures.count = 0 THEN
1056: -- this fee has not yet been assigned to the loan, we need to get the fee structure from LNS_FEES, NOT
1057: -- FROM LNS_FEE_ASSIGNMENTS

Line 1058: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - fee is unassigned ');

1054:
1055: IF l_orig_fee_structures.count = 0 THEN
1056: -- this fee has not yet been assigned to the loan, we need to get the fee structure from LNS_FEES, NOT
1057: -- FROM LNS_FEE_ASSIGNMENTS
1058: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - fee is unassigned ');
1059: l_orig_fee_structures := getFeeStructures(p_fee_id => p_fee_id);
1060: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - structs ' || l_orig_fee_structures.count);
1061:
1062: l_installment := l_orig_fee_structures(1).fee_from_installment;

Line 1060: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - structs ' || l_orig_fee_structures.count);

1056: -- this fee has not yet been assigned to the loan, we need to get the fee structure from LNS_FEES, NOT
1057: -- FROM LNS_FEE_ASSIGNMENTS
1058: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - fee is unassigned ');
1059: l_orig_fee_structures := getFeeStructures(p_fee_id => p_fee_id);
1060: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - structs ' || l_orig_fee_structures.count);
1061:
1062: l_installment := l_orig_fee_structures(1).fee_from_installment;
1063:
1064: open c_disbAmount(p_disb_header_id);

Line 1070: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - disb amount ' || l_disb_amount);

1066: close c_disbAmount;
1067:
1068: l_fee_basis_tbl(2).fee_basis_name := 'IND_DISB_AMT';
1069: l_fee_basis_tbl(2).fee_basis_amount := l_disb_amount;
1070: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - disb amount ' || l_disb_amount);
1071: ELSE
1072: l_fee_basis_tbl(2).fee_basis_name := 'IND_DISB_AMT';
1073: l_fee_basis_tbl(2).fee_basis_amount := l_orig_fee_structures(1).DISBURSEMENT_AMOUNT;
1074: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - disb amount ' || l_orig_fee_structures(1).DISBURSEMENT_AMOUNT);

Line 1074: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - disb amount ' || l_orig_fee_structures(1).DISBURSEMENT_AMOUNT);

1070: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - disb amount ' || l_disb_amount);
1071: ELSE
1072: l_fee_basis_tbl(2).fee_basis_name := 'IND_DISB_AMT';
1073: l_fee_basis_tbl(2).fee_basis_amount := l_orig_fee_structures(1).DISBURSEMENT_AMOUNT;
1074: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - disb amount ' || l_orig_fee_structures(1).DISBURSEMENT_AMOUNT);
1075:
1076: begin
1077: open c_from_installment(p_fee_id, p_disb_header_id, l_phase);
1078: fetch c_from_installment into l_installment;

Line 1080: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - l_installment ' || l_installment);

1076: begin
1077: open c_from_installment(p_fee_id, p_disb_header_id, l_phase);
1078: fetch c_from_installment into l_installment;
1079: close c_from_installment;
1080: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - l_installment ' || l_installment);
1081: exception
1082: when no_data_found then
1083: l_installment := 0;
1084: end;

Line 1089: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - calculating fees');

1085:
1086: END IF;
1087:
1088:
1089: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - calculating fees');
1090: calculateFees(p_loan_id => p_loan_id
1091: ,p_fee_basis_tbl => l_fee_basis_tbl
1092: ,p_installment => l_installment
1093: ,p_fee_structures => l_orig_fee_structures

Line 1098: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - fees count is ' || l_fee_calc_tbl.count);

1094: ,x_fees_tbl => l_fee_calc_tbl
1095: ,x_return_status => l_return_status
1096: ,x_msg_count => l_msg_count
1097: ,x_msg_data => l_msg_data);
1098: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - fees count is ' || l_fee_calc_tbl.count);
1099: for k in 1..l_fee_calc_tbl.count
1100: loop
1101: l_amount := l_amount + l_fee_calc_tbl(k).FEE_AMOUNT;
1102: end loop;

Line 1104: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - fee total is ' || l_amount);

1100: loop
1101: l_amount := l_amount + l_fee_calc_tbl(k).FEE_AMOUNT;
1102: end loop;
1103:
1104: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - fee total is ' || l_amount);
1105:
1106: end if;
1107:
1108: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - fee total is ' || l_amount);

Line 1108: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - fee total is ' || l_amount);

1104: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - fee total is ' || l_amount);
1105:
1106: end if;
1107:
1108: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - fee total is ' || l_amount);
1109: return l_amount;
1110:
1111: exception
1112: when others then

Line 1177: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - l_loan_status = ' || l_loan_status);

1173:
1174: select lh.loan_status into l_loan_status
1175: from lns_loan_headers_all lh
1176: where lh.loan_id = P_LOAN_ID;
1177: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - l_loan_status = ' || l_loan_status);
1178:
1179: if(l_loan_status = 'INCOMPLETE' or l_loan_status = 'PENDING') then
1180: l_based_on_terms := 'ORIGINAL';
1181: else

Line 1184: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - l_based_on_terms = ' || l_based_on_terms);

1180: l_based_on_terms := 'ORIGINAL';
1181: else
1182: l_based_on_terms := 'CURRENT';
1183: end if;
1184: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - l_based_on_terms = ' || l_based_on_terms);
1185:
1186: l_phase := nvl(p_phase, 'TERM');
1187: -- compute the installment based on p_fee_assignment_id
1188: l_fee_structures := lns_fee_engine.getFeeStructures(p_loan_id => p_loan_id

Line 1194: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - structs ' || l_fee_structures.count);

1190: ,p_fee_type => null
1191: ,p_installment => null
1192: ,p_phase => l_phase
1193: ,p_fee_id => p_fee_id);
1194: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - structs ' || l_fee_structures.count);
1195:
1196: if l_fee_structures.count = 0 then
1197: -- this fee has not yet been assigned to the loan, we need to get the fee structure from LNS_FEES, NOT LNS_FEE_ASSIGNMENTS
1198: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - fee is unassigned ');

Line 1198: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - fee is unassigned ');

1194: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - structs ' || l_fee_structures.count);
1195:
1196: if l_fee_structures.count = 0 then
1197: -- this fee has not yet been assigned to the loan, we need to get the fee structure from LNS_FEES, NOT LNS_FEE_ASSIGNMENTS
1198: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - fee is unassigned ');
1199: l_fee_structures := getFeeStructures(p_fee_id => p_fee_id);
1200: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - structs ' || l_fee_structures.count);
1201: l_installment := l_fee_structures(1).fee_from_installment;
1202: else

Line 1200: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - structs ' || l_fee_structures.count);

1196: if l_fee_structures.count = 0 then
1197: -- this fee has not yet been assigned to the loan, we need to get the fee structure from LNS_FEES, NOT LNS_FEE_ASSIGNMENTS
1198: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - fee is unassigned ');
1199: l_fee_structures := getFeeStructures(p_fee_id => p_fee_id);
1200: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - structs ' || l_fee_structures.count);
1201: l_installment := l_fee_structures(1).fee_from_installment;
1202: else
1203: -- the fee has been assigned to the loan, get the fee_installment from the assignments table
1204:

Line 1209: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - l_installment ' || l_installment);

1205: begin
1206: open c_from_installment(p_fee_id, p_loan_id, l_phase);
1207: fetch c_from_installment into l_installment;
1208: close c_from_installment;
1209: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - l_installment ' || l_installment);
1210: exception
1211: when
1212: no_data_found then
1213: l_installment := 0;

Line 1218: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - getting details');

1214: end;
1215: end if;
1216:
1217: -- build the fee bases
1218: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - getting details');
1219: l_loan_details := lns_financials.getLoanDetails(p_loan_id, l_based_on_terms, l_phase);
1220:
1221: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - l_installment ' || l_installment);
1222:

Line 1221: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - l_installment ' || l_installment);

1217: -- build the fee bases
1218: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - getting details');
1219: l_loan_details := lns_financials.getLoanDetails(p_loan_id, l_based_on_terms, l_phase);
1220:
1221: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - l_installment ' || l_installment);
1222:
1223: l_fee_basis_tbl(1).fee_basis_name := 'TOTAL_BAL';
1224: l_fee_basis_tbl(1).fee_basis_amount := l_loan_details.remaining_balance;
1225: l_fee_basis_tbl(2).fee_basis_name := 'ORIG_LOAN';

Line 1242: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - calculating fees');

1238: l_fee_basis_tbl(8).fee_basis_amount := l_loan_details.UNPAID_INTEREST;
1239: l_fee_basis_tbl(9).fee_basis_name := 'CURR_LOAN';
1240: l_fee_basis_tbl(9).fee_basis_amount := l_loan_details.requested_amount + l_loan_details.ADD_REQUESTED_AMOUNT;
1241:
1242: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - calculating fees');
1243: calculateFees(p_loan_id => p_loan_id
1244: ,p_fee_basis_tbl => l_fee_basis_tbl
1245: ,p_installment => l_installment
1246: ,p_fee_structures => l_fee_structures

Line 1252: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - fees count is ' || l_fee_calc_tbl.count);

1248: ,x_return_status => l_return_status
1249: ,x_msg_count => l_msg_count
1250: ,x_msg_data => l_msg_data);
1251:
1252: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - fees count is ' || l_fee_calc_tbl.count);
1253: for k in 1..l_fee_calc_tbl.count
1254: loop
1255: l_calc_fee := l_calc_fee + l_fee_calc_tbl(k).FEE_AMOUNT;
1256: end loop;

Line 1258: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - fee total is ' || l_calc_fee);

1254: loop
1255: l_calc_fee := l_calc_fee + l_fee_calc_tbl(k).FEE_AMOUNT;
1256: end loop;
1257:
1258: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - fee total is ' || l_calc_fee);
1259: return l_calc_fee;
1260:
1261: exception
1262: when others then

Line 1263: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - ERROR ' || sqlerrm);

1259: return l_calc_fee;
1260:
1261: exception
1262: when others then
1263: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - ERROR ' || sqlerrm);
1264: return -1;
1265:
1266: end calculateFee;
1267:

Line 1328: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - BEGIN');

1324: l_intervals := 1;
1325: x_return_status := FND_API.G_RET_STS_SUCCESS;
1326:
1327: -- first figure out if fee applies to the current installment
1328: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - BEGIN');
1329: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, l_api_name || ' - p_loan_id = ' || p_loan_id);
1330: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, l_api_name || ' - p_installment = ' || p_installment);
1331: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, l_api_name || ' - # fee structures ' || p_fee_structures.count);
1332: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, l_api_name || ' - # fee basis ' || p_fee_basis_tbl.count);

Line 1329: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, l_api_name || ' - p_loan_id = ' || p_loan_id);

1325: x_return_status := FND_API.G_RET_STS_SUCCESS;
1326:
1327: -- first figure out if fee applies to the current installment
1328: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - BEGIN');
1329: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, l_api_name || ' - p_loan_id = ' || p_loan_id);
1330: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, l_api_name || ' - p_installment = ' || p_installment);
1331: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, l_api_name || ' - # fee structures ' || p_fee_structures.count);
1332: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, l_api_name || ' - # fee basis ' || p_fee_basis_tbl.count);
1333:

Line 1330: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, l_api_name || ' - p_installment = ' || p_installment);

1326:
1327: -- first figure out if fee applies to the current installment
1328: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - BEGIN');
1329: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, l_api_name || ' - p_loan_id = ' || p_loan_id);
1330: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, l_api_name || ' - p_installment = ' || p_installment);
1331: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, l_api_name || ' - # fee structures ' || p_fee_structures.count);
1332: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, l_api_name || ' - # fee basis ' || p_fee_basis_tbl.count);
1333:
1334: open c_precision(p_loan_id);

Line 1331: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, l_api_name || ' - # fee structures ' || p_fee_structures.count);

1327: -- first figure out if fee applies to the current installment
1328: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - BEGIN');
1329: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, l_api_name || ' - p_loan_id = ' || p_loan_id);
1330: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, l_api_name || ' - p_installment = ' || p_installment);
1331: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, l_api_name || ' - # fee structures ' || p_fee_structures.count);
1332: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, l_api_name || ' - # fee basis ' || p_fee_basis_tbl.count);
1333:
1334: open c_precision(p_loan_id);
1335: fetch c_precision into l_precision;

Line 1332: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, l_api_name || ' - # fee basis ' || p_fee_basis_tbl.count);

1328: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - BEGIN');
1329: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, l_api_name || ' - p_loan_id = ' || p_loan_id);
1330: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, l_api_name || ' - p_installment = ' || p_installment);
1331: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, l_api_name || ' - # fee structures ' || p_fee_structures.count);
1332: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, l_api_name || ' - # fee basis ' || p_fee_basis_tbl.count);
1333:
1334: open c_precision(p_loan_id);
1335: fetch c_precision into l_precision;
1336: close c_precision;

Line 1338: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, l_api_name || ' - # fee precision ' || l_precision);

1334: open c_precision(p_loan_id);
1335: fetch c_precision into l_precision;
1336: close c_precision;
1337:
1338: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, l_api_name || ' - # fee precision ' || l_precision);
1339:
1340: for f in 1..p_fee_structures.count loop
1341: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, l_api_name || ' -------- STRUCTURE ' || f);
1342: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, l_api_name || ' - from inst = ' || p_fee_structures(f).fee_from_installment);

Line 1341: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, l_api_name || ' -------- STRUCTURE ' || f);

1337:
1338: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, l_api_name || ' - # fee precision ' || l_precision);
1339:
1340: for f in 1..p_fee_structures.count loop
1341: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, l_api_name || ' -------- STRUCTURE ' || f);
1342: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, l_api_name || ' - from inst = ' || p_fee_structures(f).fee_from_installment);
1343: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, l_api_name || ' - to inst = ' || p_fee_structures(f).fee_to_installment);
1344: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, l_api_name || ' - basis = ' || p_fee_structures(f).fee_basis);
1345: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, l_api_name || ' - billing option = ' || p_fee_structures(f).fee_billing_option);

Line 1342: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, l_api_name || ' - from inst = ' || p_fee_structures(f).fee_from_installment);

1338: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, l_api_name || ' - # fee precision ' || l_precision);
1339:
1340: for f in 1..p_fee_structures.count loop
1341: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, l_api_name || ' -------- STRUCTURE ' || f);
1342: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, l_api_name || ' - from inst = ' || p_fee_structures(f).fee_from_installment);
1343: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, l_api_name || ' - to inst = ' || p_fee_structures(f).fee_to_installment);
1344: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, l_api_name || ' - basis = ' || p_fee_structures(f).fee_basis);
1345: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, l_api_name || ' - billing option = ' || p_fee_structures(f).fee_billing_option);
1346: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, l_api_name || ' - rate = ' || p_fee_structures(f).fee_rate_type);

Line 1343: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, l_api_name || ' - to inst = ' || p_fee_structures(f).fee_to_installment);

1339:
1340: for f in 1..p_fee_structures.count loop
1341: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, l_api_name || ' -------- STRUCTURE ' || f);
1342: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, l_api_name || ' - from inst = ' || p_fee_structures(f).fee_from_installment);
1343: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, l_api_name || ' - to inst = ' || p_fee_structures(f).fee_to_installment);
1344: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, l_api_name || ' - basis = ' || p_fee_structures(f).fee_basis);
1345: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, l_api_name || ' - billing option = ' || p_fee_structures(f).fee_billing_option);
1346: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, l_api_name || ' - rate = ' || p_fee_structures(f).fee_rate_type);
1347: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, l_api_name || ' - phase = ' || p_fee_structures(f).phase);

Line 1344: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, l_api_name || ' - basis = ' || p_fee_structures(f).fee_basis);

1340: for f in 1..p_fee_structures.count loop
1341: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, l_api_name || ' -------- STRUCTURE ' || f);
1342: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, l_api_name || ' - from inst = ' || p_fee_structures(f).fee_from_installment);
1343: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, l_api_name || ' - to inst = ' || p_fee_structures(f).fee_to_installment);
1344: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, l_api_name || ' - basis = ' || p_fee_structures(f).fee_basis);
1345: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, l_api_name || ' - billing option = ' || p_fee_structures(f).fee_billing_option);
1346: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, l_api_name || ' - rate = ' || p_fee_structures(f).fee_rate_type);
1347: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, l_api_name || ' - phase = ' || p_fee_structures(f).phase);
1348: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, l_api_name || ' - CUSTOM_PROCEDURE = ' || p_fee_structures(f).CUSTOM_PROCEDURE);

Line 1345: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, l_api_name || ' - billing option = ' || p_fee_structures(f).fee_billing_option);

1341: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, l_api_name || ' -------- STRUCTURE ' || f);
1342: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, l_api_name || ' - from inst = ' || p_fee_structures(f).fee_from_installment);
1343: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, l_api_name || ' - to inst = ' || p_fee_structures(f).fee_to_installment);
1344: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, l_api_name || ' - basis = ' || p_fee_structures(f).fee_basis);
1345: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, l_api_name || ' - billing option = ' || p_fee_structures(f).fee_billing_option);
1346: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, l_api_name || ' - rate = ' || p_fee_structures(f).fee_rate_type);
1347: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, l_api_name || ' - phase = ' || p_fee_structures(f).phase);
1348: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, l_api_name || ' - CUSTOM_PROCEDURE = ' || p_fee_structures(f).CUSTOM_PROCEDURE);
1349:

Line 1346: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, l_api_name || ' - rate = ' || p_fee_structures(f).fee_rate_type);

1342: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, l_api_name || ' - from inst = ' || p_fee_structures(f).fee_from_installment);
1343: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, l_api_name || ' - to inst = ' || p_fee_structures(f).fee_to_installment);
1344: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, l_api_name || ' - basis = ' || p_fee_structures(f).fee_basis);
1345: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, l_api_name || ' - billing option = ' || p_fee_structures(f).fee_billing_option);
1346: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, l_api_name || ' - rate = ' || p_fee_structures(f).fee_rate_type);
1347: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, l_api_name || ' - phase = ' || p_fee_structures(f).phase);
1348: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, l_api_name || ' - CUSTOM_PROCEDURE = ' || p_fee_structures(f).CUSTOM_PROCEDURE);
1349:
1350: l_fee := 0;

Line 1347: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, l_api_name || ' - phase = ' || p_fee_structures(f).phase);

1343: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, l_api_name || ' - to inst = ' || p_fee_structures(f).fee_to_installment);
1344: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, l_api_name || ' - basis = ' || p_fee_structures(f).fee_basis);
1345: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, l_api_name || ' - billing option = ' || p_fee_structures(f).fee_billing_option);
1346: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, l_api_name || ' - rate = ' || p_fee_structures(f).fee_rate_type);
1347: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, l_api_name || ' - phase = ' || p_fee_structures(f).phase);
1348: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, l_api_name || ' - CUSTOM_PROCEDURE = ' || p_fee_structures(f).CUSTOM_PROCEDURE);
1349:
1350: l_fee := 0;
1351:

Line 1348: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, l_api_name || ' - CUSTOM_PROCEDURE = ' || p_fee_structures(f).CUSTOM_PROCEDURE);

1344: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, l_api_name || ' - basis = ' || p_fee_structures(f).fee_basis);
1345: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, l_api_name || ' - billing option = ' || p_fee_structures(f).fee_billing_option);
1346: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, l_api_name || ' - rate = ' || p_fee_structures(f).fee_rate_type);
1347: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, l_api_name || ' - phase = ' || p_fee_structures(f).phase);
1348: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, l_api_name || ' - CUSTOM_PROCEDURE = ' || p_fee_structures(f).CUSTOM_PROCEDURE);
1349:
1350: l_fee := 0;
1351:
1352: if p_installment >= p_fee_structures(f).fee_from_installment and

Line 1355: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, l_api_name || ' - fees ' || f || ' applies to this installment ');

1351:
1352: if p_installment >= p_fee_structures(f).fee_from_installment and
1353: p_installment <= p_fee_structures(f).fee_to_installment then
1354:
1355: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, l_api_name || ' - fees ' || f || ' applies to this installment ');
1356:
1357: if p_fee_structures(f).fee_billing_option = 'EQUALLY' then
1358: l_intervals := p_fee_structures(f).fee_to_installment - p_fee_structures(f).fee_from_installment + 1;
1359: end if;

Line 1364: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, l_api_name || ' - amount = : ' || p_fee_structures(f).fee_amount);

1360:
1361: if p_fee_structures(f).fee_rate_type = 'FIXED' then
1362:
1363: if p_installment = p_fee_structures(f).fee_to_installment then
1364: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, l_api_name || ' - amount = : ' || p_fee_structures(f).fee_amount);
1365: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, l_api_name || ' - raw: ' || p_fee_structures(f).fee_amount / l_intervals);
1366: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, l_api_name || ' - raw2 - ' || round((p_fee_structures(f).fee_amount / l_intervals),2) * (l_intervals - 1));
1367: l_fee := p_fee_structures(f).fee_amount - round((p_fee_structures(f).fee_amount / l_intervals),l_precision) * (l_intervals - 1);
1368: else

Line 1365: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, l_api_name || ' - raw: ' || p_fee_structures(f).fee_amount / l_intervals);

1361: if p_fee_structures(f).fee_rate_type = 'FIXED' then
1362:
1363: if p_installment = p_fee_structures(f).fee_to_installment then
1364: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, l_api_name || ' - amount = : ' || p_fee_structures(f).fee_amount);
1365: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, l_api_name || ' - raw: ' || p_fee_structures(f).fee_amount / l_intervals);
1366: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, l_api_name || ' - raw2 - ' || round((p_fee_structures(f).fee_amount / l_intervals),2) * (l_intervals - 1));
1367: l_fee := p_fee_structures(f).fee_amount - round((p_fee_structures(f).fee_amount / l_intervals),l_precision) * (l_intervals - 1);
1368: else
1369: l_fee := round(p_fee_structures(f).fee_amount / l_intervals, l_precision);

Line 1366: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, l_api_name || ' - raw2 - ' || round((p_fee_structures(f).fee_amount / l_intervals),2) * (l_intervals - 1));

1362:
1363: if p_installment = p_fee_structures(f).fee_to_installment then
1364: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, l_api_name || ' - amount = : ' || p_fee_structures(f).fee_amount);
1365: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, l_api_name || ' - raw: ' || p_fee_structures(f).fee_amount / l_intervals);
1366: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, l_api_name || ' - raw2 - ' || round((p_fee_structures(f).fee_amount / l_intervals),2) * (l_intervals - 1));
1367: l_fee := p_fee_structures(f).fee_amount - round((p_fee_structures(f).fee_amount / l_intervals),l_precision) * (l_intervals - 1);
1368: else
1369: l_fee := round(p_fee_structures(f).fee_amount / l_intervals, l_precision);
1370: end if;

Line 1378: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - fee basis = ' || p_fee_basis_tbl(k).fee_basis_name);

1374: begin
1375: k := 0;
1376: LOOP
1377: k := k + 1;
1378: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - fee basis = ' || p_fee_basis_tbl(k).fee_basis_name);
1379: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - fee basis amount = ' || p_fee_basis_tbl(k).fee_basis_amount);
1380: EXIT WHEN p_fee_basis_tbl(k).fee_basis_name = p_fee_structures(f).fee_basis;
1381: END LOOP;
1382: --logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, l_api_name || ' - fee basis ' || p_fee_basis_tbl(k).fee_basis_name);

Line 1379: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - fee basis amount = ' || p_fee_basis_tbl(k).fee_basis_amount);

1375: k := 0;
1376: LOOP
1377: k := k + 1;
1378: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - fee basis = ' || p_fee_basis_tbl(k).fee_basis_name);
1379: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - fee basis amount = ' || p_fee_basis_tbl(k).fee_basis_amount);
1380: EXIT WHEN p_fee_basis_tbl(k).fee_basis_name = p_fee_structures(f).fee_basis;
1381: END LOOP;
1382: --logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, l_api_name || ' - fee basis ' || p_fee_basis_tbl(k).fee_basis_name);
1383: --logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, l_api_name || ' - fee basis amount ' || p_fee_basis_tbl(k).fee_basis_amount);

Line 1382: --logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, l_api_name || ' - fee basis ' || p_fee_basis_tbl(k).fee_basis_name);

1378: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - fee basis = ' || p_fee_basis_tbl(k).fee_basis_name);
1379: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - fee basis amount = ' || p_fee_basis_tbl(k).fee_basis_amount);
1380: EXIT WHEN p_fee_basis_tbl(k).fee_basis_name = p_fee_structures(f).fee_basis;
1381: END LOOP;
1382: --logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, l_api_name || ' - fee basis ' || p_fee_basis_tbl(k).fee_basis_name);
1383: --logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, l_api_name || ' - fee basis amount ' || p_fee_basis_tbl(k).fee_basis_amount);
1384:
1385: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - BASISES MATCH!');
1386: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - percent = ' || p_fee_structures(f).fee_amount);

Line 1383: --logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, l_api_name || ' - fee basis amount ' || p_fee_basis_tbl(k).fee_basis_amount);

1379: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - fee basis amount = ' || p_fee_basis_tbl(k).fee_basis_amount);
1380: EXIT WHEN p_fee_basis_tbl(k).fee_basis_name = p_fee_structures(f).fee_basis;
1381: END LOOP;
1382: --logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, l_api_name || ' - fee basis ' || p_fee_basis_tbl(k).fee_basis_name);
1383: --logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, l_api_name || ' - fee basis amount ' || p_fee_basis_tbl(k).fee_basis_amount);
1384:
1385: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - BASISES MATCH!');
1386: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - percent = ' || p_fee_structures(f).fee_amount);
1387: l_basis_amount := p_fee_basis_tbl(k).fee_basis_amount;

Line 1385: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - BASISES MATCH!');

1381: END LOOP;
1382: --logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, l_api_name || ' - fee basis ' || p_fee_basis_tbl(k).fee_basis_name);
1383: --logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, l_api_name || ' - fee basis amount ' || p_fee_basis_tbl(k).fee_basis_amount);
1384:
1385: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - BASISES MATCH!');
1386: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - percent = ' || p_fee_structures(f).fee_amount);
1387: l_basis_amount := p_fee_basis_tbl(k).fee_basis_amount;
1388:
1389: if p_installment = p_fee_structures(f).fee_to_installment then

Line 1386: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - percent = ' || p_fee_structures(f).fee_amount);

1382: --logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, l_api_name || ' - fee basis ' || p_fee_basis_tbl(k).fee_basis_name);
1383: --logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, l_api_name || ' - fee basis amount ' || p_fee_basis_tbl(k).fee_basis_amount);
1384:
1385: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - BASISES MATCH!');
1386: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - percent = ' || p_fee_structures(f).fee_amount);
1387: l_basis_amount := p_fee_basis_tbl(k).fee_basis_amount;
1388:
1389: if p_installment = p_fee_structures(f).fee_to_installment then
1390: l_fee := (p_fee_structures(f).fee_amount * l_basis_amount) - round((p_fee_structures(f).fee_amount / l_intervals),l_precision) * (l_intervals - 1);

Line 1397: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - in exception');

1393: end if;
1394:
1395: exception
1396: when no_data_found then
1397: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - in exception');
1398: l_fee := 0;
1399: --FND_MESSAGE.SET_NAME('LNS', 'LNS_FEE_CALC_ERROR');
1400: --FND_MSG_PUB.ADD;
1401: --RAISE FND_API.G_EXC_ERROR;

Line 1407: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, l_api_name || ' - l_plsql_block = ' || l_plsql_block);

1403:
1404: elsif p_fee_structures(f).fee_rate_type = 'CUSTOM' then
1405:
1406: l_plsql_block := 'BEGIN ' || p_fee_structures(f).CUSTOM_PROCEDURE || '(:1, :2, :3, :4, :5); END;';
1407: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, l_api_name || ' - l_plsql_block = ' || l_plsql_block);
1408:
1409: BEGIN
1410:
1411: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, l_api_name || ' - Calling...');

Line 1411: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, l_api_name || ' - Calling...');

1407: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, l_api_name || ' - l_plsql_block = ' || l_plsql_block);
1408:
1409: BEGIN
1410:
1411: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, l_api_name || ' - Calling...');
1412:
1413: EXECUTE IMMEDIATE l_plsql_block
1414: USING
1415: IN p_loan_id,

Line 1421: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - Done');

1417: IN p_installment,
1418: OUT l_fee,
1419: OUT l_error;
1420:
1421: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - Done');
1422:
1423: EXCEPTION
1424: WHEN OTHERS THEN
1425: FND_MESSAGE.SET_NAME('LNS', 'LNS_CUSTOM_FEE_FAILED');

Line 1429: LogMessage(FND_LOG.LEVEL_UNEXPECTED, G_PKG_NAME, FND_MSG_PUB.Get(p_encoded => 'F'));

1425: FND_MESSAGE.SET_NAME('LNS', 'LNS_CUSTOM_FEE_FAILED');
1426: FND_MESSAGE.SET_TOKEN('FEE_NAME' ,p_fee_structures(f).FEE_NAME);
1427: FND_MESSAGE.SET_TOKEN('ERROR_MESG' ,SQLERRM);
1428: FND_MSG_PUB.ADD;
1429: LogMessage(FND_LOG.LEVEL_UNEXPECTED, G_PKG_NAME, FND_MSG_PUB.Get(p_encoded => 'F'));
1430: l_fee := 0;
1431: END;
1432:
1433: LogMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, l_api_name || ' - l_fee = ' || l_fee);

Line 1433: LogMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, l_api_name || ' - l_fee = ' || l_fee);

1429: LogMessage(FND_LOG.LEVEL_UNEXPECTED, G_PKG_NAME, FND_MSG_PUB.Get(p_encoded => 'F'));
1430: l_fee := 0;
1431: END;
1432:
1433: LogMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, l_api_name || ' - l_fee = ' || l_fee);
1434: LogMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, l_api_name || ' - l_error = ' || l_error);
1435:
1436: if l_error is not null then
1437: FND_MESSAGE.SET_NAME('LNS', 'LNS_CUSTOM_FEE_FAILED');

Line 1434: LogMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, l_api_name || ' - l_error = ' || l_error);

1430: l_fee := 0;
1431: END;
1432:
1433: LogMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, l_api_name || ' - l_fee = ' || l_fee);
1434: LogMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, l_api_name || ' - l_error = ' || l_error);
1435:
1436: if l_error is not null then
1437: FND_MESSAGE.SET_NAME('LNS', 'LNS_CUSTOM_FEE_FAILED');
1438: FND_MESSAGE.SET_TOKEN('FEE_NAME' ,p_fee_structures(f).FEE_NAME);

Line 1441: LogMessage(FND_LOG.LEVEL_UNEXPECTED, G_PKG_NAME, FND_MSG_PUB.Get(p_encoded => 'F'));

1437: FND_MESSAGE.SET_NAME('LNS', 'LNS_CUSTOM_FEE_FAILED');
1438: FND_MESSAGE.SET_TOKEN('FEE_NAME' ,p_fee_structures(f).FEE_NAME);
1439: FND_MESSAGE.SET_TOKEN('ERROR_MESG' ,l_error);
1440: FND_MSG_PUB.ADD;
1441: LogMessage(FND_LOG.LEVEL_UNEXPECTED, G_PKG_NAME, FND_MSG_PUB.Get(p_encoded => 'F'));
1442: l_fee := 0;
1443: end if;
1444:
1445: end if;

Line 1467: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - fee amount = ' || l_fee);

1463: l_fees_tbl(f).FEE_DELETABLE_FLAG := 'N'; --from getFeeStructures
1464: l_fees_tbl(f).FEE_EDITABLE_FLAG := 'N'; --from getFeeStructures
1465: l_total_fees := l_total_fees + l_fees_tbl(f).fee_amount;
1466:
1467: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - fee amount = ' || l_fee);
1468:
1469: end loop;
1470:
1471: x_fees_tbl := l_fees_tbl;

Line 1472: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - calculated fees: ' || l_total_fees);

1468:
1469: end loop;
1470:
1471: x_fees_tbl := l_fees_tbl;
1472: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - calculated fees: ' || l_total_fees);
1473:
1474: end calculateFees;
1475:
1476: /*=========================================================================

Line 1596: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - BEGIN');

1592:
1593: begin
1594:
1595: l_api_name := 'getFeeSchedule';
1596: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - BEGIN');
1597:
1598: -- Standard Start of API savepoint
1599: SAVEPOINT getFees;
1600:

Line 1651: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - fee #: ' || i);

1647: l_fee_rec.fee_editable_flag := l_fee_editable_flag;
1648: l_fee_rec.fee_billing_option := l_fee_billing_option;
1649: l_fee_rec.phase := l_phase;
1650:
1651: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - fee #: ' || i);
1652: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - fee schedule id: ' || l_fee_rec.fee_schedule_id);
1653: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - fee id: ' || l_fee_rec.fee_id);
1654: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - fee amount: ' || l_fee_rec.fee_amount);
1655: x_fees_tbl(i) := l_fee_rec;

Line 1652: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - fee schedule id: ' || l_fee_rec.fee_schedule_id);

1648: l_fee_rec.fee_billing_option := l_fee_billing_option;
1649: l_fee_rec.phase := l_phase;
1650:
1651: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - fee #: ' || i);
1652: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - fee schedule id: ' || l_fee_rec.fee_schedule_id);
1653: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - fee id: ' || l_fee_rec.fee_id);
1654: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - fee amount: ' || l_fee_rec.fee_amount);
1655: x_fees_tbl(i) := l_fee_rec;
1656: END LOOP;

Line 1653: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - fee id: ' || l_fee_rec.fee_id);

1649: l_fee_rec.phase := l_phase;
1650:
1651: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - fee #: ' || i);
1652: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - fee schedule id: ' || l_fee_rec.fee_schedule_id);
1653: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - fee id: ' || l_fee_rec.fee_id);
1654: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - fee amount: ' || l_fee_rec.fee_amount);
1655: x_fees_tbl(i) := l_fee_rec;
1656: END LOOP;
1657: elsif p_disb_header_id is not null then

Line 1654: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - fee amount: ' || l_fee_rec.fee_amount);

1650:
1651: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - fee #: ' || i);
1652: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - fee schedule id: ' || l_fee_rec.fee_schedule_id);
1653: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - fee id: ' || l_fee_rec.fee_id);
1654: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - fee amount: ' || l_fee_rec.fee_amount);
1655: x_fees_tbl(i) := l_fee_rec;
1656: END LOOP;
1657: elsif p_disb_header_id is not null then
1658: OPEN c_feeSchedule(p_disb_header_id, l_phase);

Line 1688: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - fee #: ' || i);

1684: --l_fee_rec.fee_deletable_flag := l_fee_deletable_flag;
1685: --l_fee_rec.fee_editable_flag := l_fee_editable_flag;
1686: l_fee_rec.phase := l_phase;
1687:
1688: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - fee #: ' || i);
1689: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - fee schedule id: ' || l_fee_rec.fee_schedule_id);
1690: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - fee id: ' || l_fee_rec.fee_id);
1691: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - fee amount: ' || l_fee_rec.fee_amount);
1692: x_fees_tbl(i) := l_fee_rec;

Line 1689: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - fee schedule id: ' || l_fee_rec.fee_schedule_id);

1685: --l_fee_rec.fee_editable_flag := l_fee_editable_flag;
1686: l_fee_rec.phase := l_phase;
1687:
1688: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - fee #: ' || i);
1689: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - fee schedule id: ' || l_fee_rec.fee_schedule_id);
1690: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - fee id: ' || l_fee_rec.fee_id);
1691: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - fee amount: ' || l_fee_rec.fee_amount);
1692: x_fees_tbl(i) := l_fee_rec;
1693: END LOOP;

Line 1690: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - fee id: ' || l_fee_rec.fee_id);

1686: l_fee_rec.phase := l_phase;
1687:
1688: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - fee #: ' || i);
1689: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - fee schedule id: ' || l_fee_rec.fee_schedule_id);
1690: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - fee id: ' || l_fee_rec.fee_id);
1691: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - fee amount: ' || l_fee_rec.fee_amount);
1692: x_fees_tbl(i) := l_fee_rec;
1693: END LOOP;
1694: end if;

Line 1691: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - fee amount: ' || l_fee_rec.fee_amount);

1687:
1688: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - fee #: ' || i);
1689: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - fee schedule id: ' || l_fee_rec.fee_schedule_id);
1690: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - fee id: ' || l_fee_rec.fee_id);
1691: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - fee amount: ' || l_fee_rec.fee_amount);
1692: x_fees_tbl(i) := l_fee_rec;
1693: END LOOP;
1694: end if;
1695:

Line 1701: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - END');

1697: -- End of API body
1698: -- ---------------------------------------------------------------------
1699: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
1700:
1701: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - END');
1702:
1703: EXCEPTION
1704: WHEN FND_API.G_EXC_ERROR THEN
1705: x_return_status := FND_API.G_RET_STS_ERROR;

Line 1709: logMessage(FND_LOG.LEVEL_ERROR, G_PKG_NAME, sqlerrm);

1705: x_return_status := FND_API.G_RET_STS_ERROR;
1706: x_msg_count := l_msg_count;
1707: x_msg_data := l_msg_data;
1708: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
1709: logMessage(FND_LOG.LEVEL_ERROR, G_PKG_NAME, sqlerrm);
1710: ROLLBACK TO getFees;
1711:
1712: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1713: x_return_status := FND_API.G_RET_STS_ERROR;

Line 1717: logMessage(FND_LOG.LEVEL_ERROR, G_PKG_NAME, sqlerrm);

1713: x_return_status := FND_API.G_RET_STS_ERROR;
1714: x_msg_count := l_msg_count;
1715: x_msg_data := l_msg_data;
1716: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
1717: logMessage(FND_LOG.LEVEL_ERROR, G_PKG_NAME, sqlerrm);
1718: ROLLBACK TO getFees;
1719:
1720: WHEN OTHERS THEN
1721: x_return_status := FND_API.G_RET_STS_ERROR;

Line 1725: logMessage(FND_LOG.LEVEL_ERROR, G_PKG_NAME, sqlerrm);

1721: x_return_status := FND_API.G_RET_STS_ERROR;
1722: x_msg_count := l_msg_count;
1723: x_msg_data := l_msg_data;
1724: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
1725: logMessage(FND_LOG.LEVEL_ERROR, G_PKG_NAME, sqlerrm);
1726: ROLLBACK TO getFees;
1727: end getFeeSchedule;
1728:
1729: procedure getFeeDetails(p_init_msg_list in varchar2

Line 1852: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - BEGIN');

1848:
1849: BEGIN
1850:
1851: l_api_name := 'getFeeDetails';
1852: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - BEGIN');
1853:
1854: -- Standard Start of API savepoint
1855: SAVEPOINT getFeeDetails;
1856:

Line 1872: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - Input:');

1868:
1869: i := 0;
1870: allFeeCount := 0;
1871:
1872: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - Input:');
1873: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - p_loan_id is: ' || p_loan_id);
1874: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - p_installment is: ' || p_installment);
1875: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - p_based_on_terms: ' || p_based_on_terms);
1876: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - fee_basis passed is: ' || p_fee_basis_tbl.count);

Line 1873: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - p_loan_id is: ' || p_loan_id);

1869: i := 0;
1870: allFeeCount := 0;
1871:
1872: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - Input:');
1873: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - p_loan_id is: ' || p_loan_id);
1874: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - p_installment is: ' || p_installment);
1875: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - p_based_on_terms: ' || p_based_on_terms);
1876: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - fee_basis passed is: ' || p_fee_basis_tbl.count);
1877: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - p_phase is: ' || p_phase);

Line 1874: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - p_installment is: ' || p_installment);

1870: allFeeCount := 0;
1871:
1872: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - Input:');
1873: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - p_loan_id is: ' || p_loan_id);
1874: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - p_installment is: ' || p_installment);
1875: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - p_based_on_terms: ' || p_based_on_terms);
1876: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - fee_basis passed is: ' || p_fee_basis_tbl.count);
1877: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - p_phase is: ' || p_phase);
1878:

Line 1875: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - p_based_on_terms: ' || p_based_on_terms);

1871:
1872: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - Input:');
1873: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - p_loan_id is: ' || p_loan_id);
1874: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - p_installment is: ' || p_installment);
1875: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - p_based_on_terms: ' || p_based_on_terms);
1876: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - fee_basis passed is: ' || p_fee_basis_tbl.count);
1877: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - p_phase is: ' || p_phase);
1878:
1879: l_phase := nvl(p_phase, 'TERM');

Line 1876: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - fee_basis passed is: ' || p_fee_basis_tbl.count);

1872: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - Input:');
1873: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - p_loan_id is: ' || p_loan_id);
1874: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - p_installment is: ' || p_installment);
1875: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - p_based_on_terms: ' || p_based_on_terms);
1876: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - fee_basis passed is: ' || p_fee_basis_tbl.count);
1877: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - p_phase is: ' || p_phase);
1878:
1879: l_phase := nvl(p_phase, 'TERM');
1880: l_loan_id := p_loan_id;

Line 1877: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - p_phase is: ' || p_phase);

1873: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - p_loan_id is: ' || p_loan_id);
1874: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - p_installment is: ' || p_installment);
1875: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - p_based_on_terms: ' || p_based_on_terms);
1876: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - fee_basis passed is: ' || p_fee_basis_tbl.count);
1877: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - p_phase is: ' || p_phase);
1878:
1879: l_phase := nvl(p_phase, 'TERM');
1880: l_loan_id := p_loan_id;
1881: l_fee_basis_tbl := p_fee_basis_tbl;

Line 1889: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - processing late fees');

1885: from dual;
1886:
1887: if (l_last_installment+1) = p_installment then
1888:
1889: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - processing late fees');
1890: lns_fee_engine.processLateFees(p_loan_id => l_loan_id
1891: ,p_init_msg_list => 'F'
1892: ,p_commit => 'F'
1893: ,p_phase => l_phase

Line 1898: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - l_return_status = ' || l_return_status);

1894: ,x_return_status => l_return_status
1895: ,x_msg_count => l_msg_count
1896: ,x_msg_data => l_msg_data);
1897:
1898: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - l_return_status = ' || l_return_status);
1899: if l_return_status <> FND_API.G_RET_STS_SUCCESS then
1900: FND_MESSAGE.SET_NAME('LNS', 'LNS_PROCESS_FEE_ERROR');
1901: FND_MSG_PUB.ADD;
1902: RAISE FND_API.G_EXC_ERROR;

Line 1909: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - cursor c_schd_fees');

1905: end if;
1906:
1907: -- Get Scheduled fees
1908: IF p_based_on_terms = 'CURRENT' THEN
1909: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - cursor c_schd_fees');
1910: OPEN c_schd_fees(l_loan_id, p_installment, l_phase);
1911: LOOP
1912: i := i + 1;
1913: FETCH c_schd_fees INTO

Line 1929: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - fee #: ' || i);

1925: ,l_all_fees_tbl(i).fee_billing_option
1926: ,l_all_fees_tbl(i).phase;
1927: EXIT WHEN c_schd_fees%NOTFOUND;
1928:
1929: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - fee #: ' || i);
1930: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - fee schedule id: ' || l_all_fees_tbl(i).fee_schedule_id);
1931: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - fee id: ' || l_all_fees_tbl(i).fee_id);
1932: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - fee amount: ' || l_all_fees_tbl(i).fee_amount);
1933:

Line 1930: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - fee schedule id: ' || l_all_fees_tbl(i).fee_schedule_id);

1926: ,l_all_fees_tbl(i).phase;
1927: EXIT WHEN c_schd_fees%NOTFOUND;
1928:
1929: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - fee #: ' || i);
1930: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - fee schedule id: ' || l_all_fees_tbl(i).fee_schedule_id);
1931: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - fee id: ' || l_all_fees_tbl(i).fee_id);
1932: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - fee amount: ' || l_all_fees_tbl(i).fee_amount);
1933:
1934: END LOOP;

Line 1931: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - fee id: ' || l_all_fees_tbl(i).fee_id);

1927: EXIT WHEN c_schd_fees%NOTFOUND;
1928:
1929: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - fee #: ' || i);
1930: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - fee schedule id: ' || l_all_fees_tbl(i).fee_schedule_id);
1931: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - fee id: ' || l_all_fees_tbl(i).fee_id);
1932: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - fee amount: ' || l_all_fees_tbl(i).fee_amount);
1933:
1934: END LOOP;
1935:

Line 1932: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - fee amount: ' || l_all_fees_tbl(i).fee_amount);

1928:
1929: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - fee #: ' || i);
1930: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - fee schedule id: ' || l_all_fees_tbl(i).fee_schedule_id);
1931: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - fee id: ' || l_all_fees_tbl(i).fee_id);
1932: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - fee amount: ' || l_all_fees_tbl(i).fee_amount);
1933:
1934: END LOOP;
1935:
1936: CLOSE c_schd_fees;

Line 1938: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - cursor c_schd_fees1');

1934: END LOOP;
1935:
1936: CLOSE c_schd_fees;
1937: ELSE
1938: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - cursor c_schd_fees1');
1939: OPEN c_schd_fees1(l_loan_id, p_installment, l_phase);
1940: LOOP
1941: i := i + 1;
1942: FETCH c_schd_fees1 INTO

Line 1958: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - fee #: ' || i);

1954: ,l_all_fees_tbl(i).fee_billing_option
1955: ,l_all_fees_tbl(i).phase;
1956: EXIT WHEN c_schd_fees1%NOTFOUND;
1957:
1958: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - fee #: ' || i);
1959: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - fee schedule id: ' || l_all_fees_tbl(i).fee_schedule_id);
1960: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - fee id: ' || l_all_fees_tbl(i).fee_id);
1961: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - fee amount: ' || l_all_fees_tbl(i).fee_amount);
1962:

Line 1959: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - fee schedule id: ' || l_all_fees_tbl(i).fee_schedule_id);

1955: ,l_all_fees_tbl(i).phase;
1956: EXIT WHEN c_schd_fees1%NOTFOUND;
1957:
1958: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - fee #: ' || i);
1959: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - fee schedule id: ' || l_all_fees_tbl(i).fee_schedule_id);
1960: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - fee id: ' || l_all_fees_tbl(i).fee_id);
1961: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - fee amount: ' || l_all_fees_tbl(i).fee_amount);
1962:
1963: END LOOP;

Line 1960: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - fee id: ' || l_all_fees_tbl(i).fee_id);

1956: EXIT WHEN c_schd_fees1%NOTFOUND;
1957:
1958: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - fee #: ' || i);
1959: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - fee schedule id: ' || l_all_fees_tbl(i).fee_schedule_id);
1960: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - fee id: ' || l_all_fees_tbl(i).fee_id);
1961: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - fee amount: ' || l_all_fees_tbl(i).fee_amount);
1962:
1963: END LOOP;
1964:

Line 1961: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - fee amount: ' || l_all_fees_tbl(i).fee_amount);

1957:
1958: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - fee #: ' || i);
1959: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - fee schedule id: ' || l_all_fees_tbl(i).fee_schedule_id);
1960: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - fee id: ' || l_all_fees_tbl(i).fee_id);
1961: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - fee amount: ' || l_all_fees_tbl(i).fee_amount);
1962:
1963: END LOOP;
1964:
1965: CLOSE c_schd_fees1;

Line 1969: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, l_api_name || ': Total fees are ' || allFeeCount);

1965: CLOSE c_schd_fees1;
1966: END IF;
1967:
1968: allFeeCount := l_all_fees_tbl.count;
1969: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, l_api_name || ': Total fees are ' || allFeeCount);
1970:
1971:
1972: --------------------
1973: -- recurring fees

Line 1975: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, l_api_name || '- getting recurring fee structures');

1971:
1972: --------------------
1973: -- recurring fees
1974: --------------------
1975: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, l_api_name || '- getting recurring fee structures');
1976: l_recur_fee_structures := lns_fee_engine.getFeeStructures(p_loan_id => l_loan_id
1977: ,p_fee_category => 'RECUR'
1978: ,p_fee_type => null
1979: ,p_installment => p_installment

Line 1982: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, l_api_name || ': Recurring fee structures count = ' || l_recur_fee_structures.count);

1978: ,p_fee_type => null
1979: ,p_installment => p_installment
1980: ,p_phase => l_phase
1981: ,p_fee_id => null);
1982: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, l_api_name || ': Recurring fee structures count = ' || l_recur_fee_structures.count);
1983:
1984: -- filtering out recurring fees based on input details
1985: n := 0;
1986: for m in 1..l_recur_fee_structures.count loop

Line 1989: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, l_api_name || ' ');

1985: n := 0;
1986: for m in 1..l_recur_fee_structures.count loop
1987:
1988: l_schd := null;
1989: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, l_api_name || ' ');
1990: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, l_api_name || ' Recurring fee ' || m);
1991: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, l_api_name || ' l_loan_id = ' || l_loan_id);
1992: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, l_api_name || ' fee_id = ' || l_recur_fee_structures(m).FEE_ID);
1993: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, l_api_name || ' p_installment = ' || p_installment);

Line 1990: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, l_api_name || ' Recurring fee ' || m);

1986: for m in 1..l_recur_fee_structures.count loop
1987:
1988: l_schd := null;
1989: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, l_api_name || ' ');
1990: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, l_api_name || ' Recurring fee ' || m);
1991: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, l_api_name || ' l_loan_id = ' || l_loan_id);
1992: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, l_api_name || ' fee_id = ' || l_recur_fee_structures(m).FEE_ID);
1993: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, l_api_name || ' p_installment = ' || p_installment);
1994: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, l_api_name || ' l_phase = ' || l_phase);

Line 1991: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, l_api_name || ' l_loan_id = ' || l_loan_id);

1987:
1988: l_schd := null;
1989: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, l_api_name || ' ');
1990: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, l_api_name || ' Recurring fee ' || m);
1991: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, l_api_name || ' l_loan_id = ' || l_loan_id);
1992: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, l_api_name || ' fee_id = ' || l_recur_fee_structures(m).FEE_ID);
1993: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, l_api_name || ' p_installment = ' || p_installment);
1994: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, l_api_name || ' l_phase = ' || l_phase);
1995: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, l_api_name || ' disb_header_id = ' || l_recur_fee_structures(m).disb_header_id);

Line 1992: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, l_api_name || ' fee_id = ' || l_recur_fee_structures(m).FEE_ID);

1988: l_schd := null;
1989: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, l_api_name || ' ');
1990: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, l_api_name || ' Recurring fee ' || m);
1991: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, l_api_name || ' l_loan_id = ' || l_loan_id);
1992: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, l_api_name || ' fee_id = ' || l_recur_fee_structures(m).FEE_ID);
1993: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, l_api_name || ' p_installment = ' || p_installment);
1994: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, l_api_name || ' l_phase = ' || l_phase);
1995: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, l_api_name || ' disb_header_id = ' || l_recur_fee_structures(m).disb_header_id);
1996:

Line 1993: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, l_api_name || ' p_installment = ' || p_installment);

1989: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, l_api_name || ' ');
1990: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, l_api_name || ' Recurring fee ' || m);
1991: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, l_api_name || ' l_loan_id = ' || l_loan_id);
1992: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, l_api_name || ' fee_id = ' || l_recur_fee_structures(m).FEE_ID);
1993: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, l_api_name || ' p_installment = ' || p_installment);
1994: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, l_api_name || ' l_phase = ' || l_phase);
1995: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, l_api_name || ' disb_header_id = ' || l_recur_fee_structures(m).disb_header_id);
1996:
1997: -- filtering out fees based on p_based_on_terms

Line 1994: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, l_api_name || ' l_phase = ' || l_phase);

1990: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, l_api_name || ' Recurring fee ' || m);
1991: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, l_api_name || ' l_loan_id = ' || l_loan_id);
1992: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, l_api_name || ' fee_id = ' || l_recur_fee_structures(m).FEE_ID);
1993: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, l_api_name || ' p_installment = ' || p_installment);
1994: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, l_api_name || ' l_phase = ' || l_phase);
1995: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, l_api_name || ' disb_header_id = ' || l_recur_fee_structures(m).disb_header_id);
1996:
1997: -- filtering out fees based on p_based_on_terms
1998: IF p_based_on_terms = 'CURRENT' THEN

Line 1995: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, l_api_name || ' disb_header_id = ' || l_recur_fee_structures(m).disb_header_id);

1991: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, l_api_name || ' l_loan_id = ' || l_loan_id);
1992: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, l_api_name || ' fee_id = ' || l_recur_fee_structures(m).FEE_ID);
1993: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, l_api_name || ' p_installment = ' || p_installment);
1994: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, l_api_name || ' l_phase = ' || l_phase);
1995: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, l_api_name || ' disb_header_id = ' || l_recur_fee_structures(m).disb_header_id);
1996:
1997: -- filtering out fees based on p_based_on_terms
1998: IF p_based_on_terms = 'CURRENT' THEN
1999: OPEN cur_fee_schd_inst_exist(l_loan_id, l_recur_fee_structures(m).fee_id, p_installment, l_phase, l_recur_fee_structures(m).disb_header_id);

Line 2005: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, l_api_name || ' Adding ' || l_recur_fee_structures(m).FEE_ID);

2001: CLOSE cur_fee_schd_inst_exist;
2002: END IF;
2003:
2004: if l_schd is null then
2005: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, l_api_name || ' Adding ' || l_recur_fee_structures(m).FEE_ID);
2006: n := n + 1;
2007: l_new_recur_fee_structures(n) := l_recur_fee_structures(m);
2008: else
2009: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, l_api_name || ' Filtering out ' || l_recur_fee_structures(m).FEE_ID);

Line 2009: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, l_api_name || ' Filtering out ' || l_recur_fee_structures(m).FEE_ID);

2005: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, l_api_name || ' Adding ' || l_recur_fee_structures(m).FEE_ID);
2006: n := n + 1;
2007: l_new_recur_fee_structures(n) := l_recur_fee_structures(m);
2008: else
2009: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, l_api_name || ' Filtering out ' || l_recur_fee_structures(m).FEE_ID);
2010: end if;
2011: end loop;
2012:
2013: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, l_api_name || ': Recurring fee structures count is ' || l_new_recur_fee_structures.count);

Line 2013: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, l_api_name || ': Recurring fee structures count is ' || l_new_recur_fee_structures.count);

2009: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, l_api_name || ' Filtering out ' || l_recur_fee_structures(m).FEE_ID);
2010: end if;
2011: end loop;
2012:
2013: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, l_api_name || ': Recurring fee structures count is ' || l_new_recur_fee_structures.count);
2014:
2015: l_recur_fees_tbl.delete;
2016: if l_new_recur_fee_structures.count > 0 then
2017: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, l_api_name || ': Calling calculateFees for recurring fees...');

Line 2017: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, l_api_name || ': Calling calculateFees for recurring fees...');

2013: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, l_api_name || ': Recurring fee structures count is ' || l_new_recur_fee_structures.count);
2014:
2015: l_recur_fees_tbl.delete;
2016: if l_new_recur_fee_structures.count > 0 then
2017: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, l_api_name || ': Calling calculateFees for recurring fees...');
2018: lns_fee_engine.calculateFees(p_loan_id => l_loan_id
2019: ,p_installment => p_installment
2020: ,p_fee_basis_tbl => l_fee_basis_tbl
2021: ,p_fee_structures => l_new_recur_fee_structures

Line 2026: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, l_api_name || ': calculated recurring fees ' || l_recur_fees_tbl.count);

2022: ,x_fees_tbl => l_recur_fees_tbl
2023: ,x_return_status => l_return_status
2024: ,x_msg_count => l_msg_count
2025: ,x_msg_data => l_msg_data);
2026: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, l_api_name || ': calculated recurring fees ' || l_recur_fees_tbl.count);
2027: end if;
2028:
2029: FOR k in 1..l_recur_fees_tbl.count LOOP
2030: l_all_fees_tbl(allFeeCount + k) := l_recur_fees_tbl(k);

Line 2034: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, l_api_name || ': Total fees are ' || allFeeCount);

2030: l_all_fees_tbl(allFeeCount + k) := l_recur_fees_tbl(k);
2031: END LOOP;
2032:
2033: allFeeCount := l_all_fees_tbl.count;
2034: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, l_api_name || ': Total fees are ' || allFeeCount);
2035:
2036: --------------------
2037: -- origination fees
2038: --------------------

Line 2039: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, l_api_name || '- getting origination fee structures');

2035:
2036: --------------------
2037: -- origination fees
2038: --------------------
2039: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, l_api_name || '- getting origination fee structures');
2040: l_orig_fee_structures := lns_fee_engine.getFeeStructures(p_loan_id => l_loan_id
2041: ,p_fee_category => 'EVENT'
2042: ,p_fee_type => 'EVENT_ORIGINATION'
2043: ,p_installment => p_installment

Line 2047: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, l_api_name || ': origination fee structures count is ' || l_orig_fee_structures.count);

2043: ,p_installment => p_installment
2044: ,p_phase => l_phase
2045: ,p_fee_id => null);
2046:
2047: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, l_api_name || ': origination fee structures count is ' || l_orig_fee_structures.count);
2048:
2049: n := 0;
2050: for m in 1..l_orig_fee_structures.count loop
2051:

Line 2053: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, l_api_name || ' ');

2049: n := 0;
2050: for m in 1..l_orig_fee_structures.count loop
2051:
2052: l_schd := null;
2053: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, l_api_name || ' ');
2054: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, l_api_name || ' Origination fee ' || m);
2055: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, l_api_name || ' l_loan_id = ' || l_loan_id);
2056: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, l_api_name || ' fee_id = ' || l_orig_fee_structures(m).FEE_ID);
2057: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, l_api_name || ' p_installment = ' || p_installment);

Line 2054: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, l_api_name || ' Origination fee ' || m);

2050: for m in 1..l_orig_fee_structures.count loop
2051:
2052: l_schd := null;
2053: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, l_api_name || ' ');
2054: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, l_api_name || ' Origination fee ' || m);
2055: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, l_api_name || ' l_loan_id = ' || l_loan_id);
2056: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, l_api_name || ' fee_id = ' || l_orig_fee_structures(m).FEE_ID);
2057: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, l_api_name || ' p_installment = ' || p_installment);
2058: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, l_api_name || ' l_phase = ' || l_phase);

Line 2055: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, l_api_name || ' l_loan_id = ' || l_loan_id);

2051:
2052: l_schd := null;
2053: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, l_api_name || ' ');
2054: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, l_api_name || ' Origination fee ' || m);
2055: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, l_api_name || ' l_loan_id = ' || l_loan_id);
2056: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, l_api_name || ' fee_id = ' || l_orig_fee_structures(m).FEE_ID);
2057: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, l_api_name || ' p_installment = ' || p_installment);
2058: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, l_api_name || ' l_phase = ' || l_phase);
2059: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, l_api_name || ' disb_header_id = ' || l_orig_fee_structures(m).disb_header_id);

Line 2056: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, l_api_name || ' fee_id = ' || l_orig_fee_structures(m).FEE_ID);

2052: l_schd := null;
2053: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, l_api_name || ' ');
2054: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, l_api_name || ' Origination fee ' || m);
2055: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, l_api_name || ' l_loan_id = ' || l_loan_id);
2056: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, l_api_name || ' fee_id = ' || l_orig_fee_structures(m).FEE_ID);
2057: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, l_api_name || ' p_installment = ' || p_installment);
2058: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, l_api_name || ' l_phase = ' || l_phase);
2059: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, l_api_name || ' disb_header_id = ' || l_orig_fee_structures(m).disb_header_id);
2060:

Line 2057: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, l_api_name || ' p_installment = ' || p_installment);

2053: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, l_api_name || ' ');
2054: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, l_api_name || ' Origination fee ' || m);
2055: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, l_api_name || ' l_loan_id = ' || l_loan_id);
2056: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, l_api_name || ' fee_id = ' || l_orig_fee_structures(m).FEE_ID);
2057: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, l_api_name || ' p_installment = ' || p_installment);
2058: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, l_api_name || ' l_phase = ' || l_phase);
2059: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, l_api_name || ' disb_header_id = ' || l_orig_fee_structures(m).disb_header_id);
2060:
2061: -- filtering out fees based on p_based_on_terms

Line 2058: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, l_api_name || ' l_phase = ' || l_phase);

2054: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, l_api_name || ' Origination fee ' || m);
2055: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, l_api_name || ' l_loan_id = ' || l_loan_id);
2056: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, l_api_name || ' fee_id = ' || l_orig_fee_structures(m).FEE_ID);
2057: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, l_api_name || ' p_installment = ' || p_installment);
2058: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, l_api_name || ' l_phase = ' || l_phase);
2059: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, l_api_name || ' disb_header_id = ' || l_orig_fee_structures(m).disb_header_id);
2060:
2061: -- filtering out fees based on p_based_on_terms
2062: IF p_based_on_terms = 'CURRENT' THEN

Line 2059: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, l_api_name || ' disb_header_id = ' || l_orig_fee_structures(m).disb_header_id);

2055: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, l_api_name || ' l_loan_id = ' || l_loan_id);
2056: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, l_api_name || ' fee_id = ' || l_orig_fee_structures(m).FEE_ID);
2057: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, l_api_name || ' p_installment = ' || p_installment);
2058: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, l_api_name || ' l_phase = ' || l_phase);
2059: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, l_api_name || ' disb_header_id = ' || l_orig_fee_structures(m).disb_header_id);
2060:
2061: -- filtering out fees based on p_based_on_terms
2062: IF p_based_on_terms = 'CURRENT' THEN
2063: OPEN cur_fee_schd_inst_exist(l_loan_id, l_orig_fee_structures(m).fee_id, p_installment, l_phase, l_orig_fee_structures(m).disb_header_id);

Line 2069: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, l_api_name || ' Adding ' || l_orig_fee_structures(m).FEE_ID);

2065: CLOSE cur_fee_schd_inst_exist;
2066: END IF;
2067:
2068: if l_schd is null then
2069: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, l_api_name || ' Adding ' || l_orig_fee_structures(m).FEE_ID);
2070: n := n + 1;
2071: l_new_orig_fee_structures(n) := l_orig_fee_structures(m);
2072: else
2073: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, l_api_name || ' Filtering out ' || l_orig_fee_structures(m).FEE_ID);

Line 2073: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, l_api_name || ' Filtering out ' || l_orig_fee_structures(m).FEE_ID);

2069: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, l_api_name || ' Adding ' || l_orig_fee_structures(m).FEE_ID);
2070: n := n + 1;
2071: l_new_orig_fee_structures(n) := l_orig_fee_structures(m);
2072: else
2073: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, l_api_name || ' Filtering out ' || l_orig_fee_structures(m).FEE_ID);
2074: end if;
2075: end loop;
2076:
2077: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, l_api_name || ': Origination fee structures count is ' || l_new_orig_fee_structures.count);

Line 2077: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, l_api_name || ': Origination fee structures count is ' || l_new_orig_fee_structures.count);

2073: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, l_api_name || ' Filtering out ' || l_orig_fee_structures(m).FEE_ID);
2074: end if;
2075: end loop;
2076:
2077: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, l_api_name || ': Origination fee structures count is ' || l_new_orig_fee_structures.count);
2078:
2079: l_orig_fees_tbl.delete;
2080: if l_new_orig_fee_structures.count > 0 then
2081: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, l_api_name || ': Calling calculateFees for origination fees...');

Line 2081: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, l_api_name || ': Calling calculateFees for origination fees...');

2077: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, l_api_name || ': Origination fee structures count is ' || l_new_orig_fee_structures.count);
2078:
2079: l_orig_fees_tbl.delete;
2080: if l_new_orig_fee_structures.count > 0 then
2081: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, l_api_name || ': Calling calculateFees for origination fees...');
2082: lns_fee_engine.calculateFees(p_loan_id => l_loan_id
2083: ,p_installment => p_installment
2084: ,p_fee_basis_tbl => l_fee_basis_tbl
2085: ,p_fee_structures => l_new_orig_fee_structures

Line 2090: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, l_api_name || ': calculated funding fees ' || l_orig_fees_tbl.count);

2086: ,x_fees_tbl => l_orig_fees_tbl
2087: ,x_return_status => l_return_status
2088: ,x_msg_count => l_msg_count
2089: ,x_msg_data => l_msg_data);
2090: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, l_api_name || ': calculated funding fees ' || l_orig_fees_tbl.count);
2091: end if;
2092:
2093: FOR k in 1..l_orig_fees_tbl.count LOOP
2094: l_all_fees_tbl(allFeeCount + k) := l_orig_fees_tbl(k);

Line 2103: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, l_api_name || '- getting memo fee structures');

2099:
2100: IF p_based_on_terms <> 'CURRENT' THEN
2101:
2102: -- memo fees
2103: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, l_api_name || '- getting memo fee structures');
2104: l_memo_fee_structures := lns_fee_engine.getFeeStructures(p_loan_id => l_loan_id
2105: ,p_fee_category => 'MEMO'
2106: ,p_fee_type => null
2107: ,p_installment => p_installment

Line 2110: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, l_api_name || ': memo fee structures count = ' || l_memo_fee_structures.count);

2106: ,p_fee_type => null
2107: ,p_installment => p_installment
2108: ,p_phase => l_phase
2109: ,p_fee_id => null);
2110: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, l_api_name || ': memo fee structures count = ' || l_memo_fee_structures.count);
2111:
2112: l_memo_fees_tbl.delete;
2113: if l_memo_fee_structures.count > 0 then
2114: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, l_api_name || ': Calling calculateFees for memo fees...');

Line 2114: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, l_api_name || ': Calling calculateFees for memo fees...');

2110: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, l_api_name || ': memo fee structures count = ' || l_memo_fee_structures.count);
2111:
2112: l_memo_fees_tbl.delete;
2113: if l_memo_fee_structures.count > 0 then
2114: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, l_api_name || ': Calling calculateFees for memo fees...');
2115: lns_fee_engine.calculateFees(p_loan_id => l_loan_id
2116: ,p_installment => p_installment
2117: ,p_fee_basis_tbl => l_fee_basis_tbl
2118: ,p_fee_structures => l_memo_fee_structures

Line 2124: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, l_api_name || ': calculated memo fees = ' || l_memo_fees_tbl.count);

2120: ,x_return_status => l_return_status
2121: ,x_msg_count => l_msg_count
2122: ,x_msg_data => l_msg_data);
2123:
2124: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, l_api_name || ': calculated memo fees = ' || l_memo_fees_tbl.count);
2125: end if;
2126:
2127: FOR k in 1..l_memo_fees_tbl.count LOOP
2128: l_all_fees_tbl(allFeeCount + k) := l_memo_fees_tbl(k);

Line 2132: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, l_api_name || ': Total Scheduled Unbilled fees are ' || allFeeCount);

2128: l_all_fees_tbl(allFeeCount + k) := l_memo_fees_tbl(k);
2129: END LOOP;
2130:
2131: allFeeCount := l_all_fees_tbl.count;
2132: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, l_api_name || ': Total Scheduled Unbilled fees are ' || allFeeCount);
2133:
2134:
2135: -- funding fees
2136: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, l_api_name || '- getting funding fee structures');

Line 2136: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, l_api_name || '- getting funding fee structures');

2132: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, l_api_name || ': Total Scheduled Unbilled fees are ' || allFeeCount);
2133:
2134:
2135: -- funding fees
2136: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, l_api_name || '- getting funding fee structures');
2137: l_funding_fee_structures := lns_fee_engine.getFeeStructures(p_loan_id => l_loan_id
2138: ,p_fee_category => 'EVENT'
2139: ,p_fee_type => 'EVENT_FUNDING'
2140: ,p_installment => p_installment

Line 2144: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, l_api_name || ': funding fee structures count is ' || l_funding_fee_structures.count);

2140: ,p_installment => p_installment
2141: ,p_phase => l_phase
2142: ,p_fee_id => null);
2143:
2144: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, l_api_name || ': funding fee structures count is ' || l_funding_fee_structures.count);
2145:
2146: -- filtering out fees based on p_based_on_terms
2147: n := 0;
2148: for m in 1..l_funding_fee_structures.count loop

Line 2151: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, l_api_name || ' l_loan_id = ' || l_loan_id);

2147: n := 0;
2148: for m in 1..l_funding_fee_structures.count loop
2149:
2150: l_schd := null;
2151: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, l_api_name || ' l_loan_id = ' || l_loan_id);
2152: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, l_api_name || ' fee_id = ' || l_funding_fee_structures(m).FEE_ID);
2153: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, l_api_name || ' p_installment = ' || p_installment);
2154: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, l_api_name || ' l_phase = ' || l_phase);
2155: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, l_api_name || ' disb_header_id = ' || l_funding_fee_structures(m).disb_header_id);

Line 2152: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, l_api_name || ' fee_id = ' || l_funding_fee_structures(m).FEE_ID);

2148: for m in 1..l_funding_fee_structures.count loop
2149:
2150: l_schd := null;
2151: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, l_api_name || ' l_loan_id = ' || l_loan_id);
2152: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, l_api_name || ' fee_id = ' || l_funding_fee_structures(m).FEE_ID);
2153: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, l_api_name || ' p_installment = ' || p_installment);
2154: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, l_api_name || ' l_phase = ' || l_phase);
2155: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, l_api_name || ' disb_header_id = ' || l_funding_fee_structures(m).disb_header_id);
2156:

Line 2153: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, l_api_name || ' p_installment = ' || p_installment);

2149:
2150: l_schd := null;
2151: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, l_api_name || ' l_loan_id = ' || l_loan_id);
2152: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, l_api_name || ' fee_id = ' || l_funding_fee_structures(m).FEE_ID);
2153: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, l_api_name || ' p_installment = ' || p_installment);
2154: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, l_api_name || ' l_phase = ' || l_phase);
2155: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, l_api_name || ' disb_header_id = ' || l_funding_fee_structures(m).disb_header_id);
2156:
2157: OPEN cur_fee_schd_inst_exist(l_loan_id, l_funding_fee_structures(m).fee_id, p_installment, l_phase, l_funding_fee_structures(m).disb_header_id);

Line 2154: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, l_api_name || ' l_phase = ' || l_phase);

2150: l_schd := null;
2151: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, l_api_name || ' l_loan_id = ' || l_loan_id);
2152: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, l_api_name || ' fee_id = ' || l_funding_fee_structures(m).FEE_ID);
2153: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, l_api_name || ' p_installment = ' || p_installment);
2154: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, l_api_name || ' l_phase = ' || l_phase);
2155: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, l_api_name || ' disb_header_id = ' || l_funding_fee_structures(m).disb_header_id);
2156:
2157: OPEN cur_fee_schd_inst_exist(l_loan_id, l_funding_fee_structures(m).fee_id, p_installment, l_phase, l_funding_fee_structures(m).disb_header_id);
2158: FETCH cur_fee_schd_inst_exist into l_schd;

Line 2155: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, l_api_name || ' disb_header_id = ' || l_funding_fee_structures(m).disb_header_id);

2151: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, l_api_name || ' l_loan_id = ' || l_loan_id);
2152: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, l_api_name || ' fee_id = ' || l_funding_fee_structures(m).FEE_ID);
2153: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, l_api_name || ' p_installment = ' || p_installment);
2154: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, l_api_name || ' l_phase = ' || l_phase);
2155: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, l_api_name || ' disb_header_id = ' || l_funding_fee_structures(m).disb_header_id);
2156:
2157: OPEN cur_fee_schd_inst_exist(l_loan_id, l_funding_fee_structures(m).fee_id, p_installment, l_phase, l_funding_fee_structures(m).disb_header_id);
2158: FETCH cur_fee_schd_inst_exist into l_schd;
2159: CLOSE cur_fee_schd_inst_exist;

Line 2162: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, l_api_name || ' Fee ' || l_funding_fee_structures(m).FEE_ID || ' is not scheduled yet');

2158: FETCH cur_fee_schd_inst_exist into l_schd;
2159: CLOSE cur_fee_schd_inst_exist;
2160:
2161: if l_schd is null then
2162: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, l_api_name || ' Fee ' || l_funding_fee_structures(m).FEE_ID || ' is not scheduled yet');
2163: n := n + 1;
2164: l_new_fund_fee_structures(n) := l_funding_fee_structures(m);
2165: else
2166: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, l_api_name || ' Fee ' || l_funding_fee_structures(m).FEE_ID || ' is already scheduled for installment '||p_installment);

Line 2166: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, l_api_name || ' Fee ' || l_funding_fee_structures(m).FEE_ID || ' is already scheduled for installment '||p_installment);

2162: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, l_api_name || ' Fee ' || l_funding_fee_structures(m).FEE_ID || ' is not scheduled yet');
2163: n := n + 1;
2164: l_new_fund_fee_structures(n) := l_funding_fee_structures(m);
2165: else
2166: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, l_api_name || ' Fee ' || l_funding_fee_structures(m).FEE_ID || ' is already scheduled for installment '||p_installment);
2167: end if;
2168: end loop;
2169:
2170: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, l_api_name || ': Unscheduled funding fee structures count is ' || l_new_fund_fee_structures.count);

Line 2170: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, l_api_name || ': Unscheduled funding fee structures count is ' || l_new_fund_fee_structures.count);

2166: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, l_api_name || ' Fee ' || l_funding_fee_structures(m).FEE_ID || ' is already scheduled for installment '||p_installment);
2167: end if;
2168: end loop;
2169:
2170: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, l_api_name || ': Unscheduled funding fee structures count is ' || l_new_fund_fee_structures.count);
2171:
2172: l_funding_fees_tbl.delete;
2173: if l_new_fund_fee_structures.count > 0 then
2174: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, l_api_name || ': Calling calculateFees for funding fees...');

Line 2174: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, l_api_name || ': Calling calculateFees for funding fees...');

2170: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, l_api_name || ': Unscheduled funding fee structures count is ' || l_new_fund_fee_structures.count);
2171:
2172: l_funding_fees_tbl.delete;
2173: if l_new_fund_fee_structures.count > 0 then
2174: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, l_api_name || ': Calling calculateFees for funding fees...');
2175: lns_fee_engine.calculateFees(p_loan_id => l_loan_id
2176: ,p_installment => p_installment
2177: ,p_fee_basis_tbl => l_fee_basis_tbl
2178: ,p_fee_structures => l_new_fund_fee_structures

Line 2183: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, l_api_name || ': calculated funding fees ' || l_funding_fees_tbl.count);

2179: ,x_fees_tbl => l_funding_fees_tbl
2180: ,x_return_status => l_return_status
2181: ,x_msg_count => l_msg_count
2182: ,x_msg_data => l_msg_data);
2183: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, l_api_name || ': calculated funding fees ' || l_funding_fees_tbl.count);
2184: end if;
2185:
2186: FOR k in 1..l_funding_fees_tbl.count LOOP
2187: l_all_fees_tbl(allFeeCount + k) := l_funding_fees_tbl(k);

Line 2193: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, l_api_name || ': Total Fees for installment '||p_installment||' are '|| allFeeCount);

2189:
2190: allFeeCount := l_all_fees_tbl.count;
2191: END IF; -- if based_on_terms = 'CURRENT'
2192:
2193: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, l_api_name || ': Total Fees for installment '||p_installment||' are '|| allFeeCount);
2194:
2195: x_fees_tbl := l_all_fees_tbl;
2196:
2197: -- ---------------------------------------------------------------------

Line 2202: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - END');

2198: -- End of API body
2199: -- ---------------------------------------------------------------------
2200: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
2201:
2202: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - END');
2203:
2204: EXCEPTION
2205: WHEN FND_API.G_EXC_ERROR THEN
2206: x_return_status := FND_API.G_RET_STS_ERROR;

Line 2210: logMessage(FND_LOG.LEVEL_ERROR, G_PKG_NAME, sqlerrm);

2206: x_return_status := FND_API.G_RET_STS_ERROR;
2207: x_msg_count := l_msg_count;
2208: x_msg_data := l_msg_data;
2209: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
2210: logMessage(FND_LOG.LEVEL_ERROR, G_PKG_NAME, sqlerrm);
2211: ROLLBACK TO getFeeDetails;
2212:
2213: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2214: x_return_status := FND_API.G_RET_STS_ERROR;

Line 2218: logMessage(FND_LOG.LEVEL_ERROR, G_PKG_NAME, sqlerrm);

2214: x_return_status := FND_API.G_RET_STS_ERROR;
2215: x_msg_count := l_msg_count;
2216: x_msg_data := l_msg_data;
2217: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
2218: logMessage(FND_LOG.LEVEL_ERROR, G_PKG_NAME, sqlerrm);
2219: ROLLBACK TO getFeeDetails;
2220:
2221: WHEN OTHERS THEN
2222: x_return_status := FND_API.G_RET_STS_ERROR;

Line 2226: logMessage(FND_LOG.LEVEL_ERROR, G_PKG_NAME, sqlerrm);

2222: x_return_status := FND_API.G_RET_STS_ERROR;
2223: x_msg_count := l_msg_count;
2224: x_msg_data := l_msg_data;
2225: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
2226: logMessage(FND_LOG.LEVEL_ERROR, G_PKG_NAME, sqlerrm);
2227: ROLLBACK TO getFeeDetails;
2228:
2229: END getFeeDetails;
2230:

Line 2300: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - BEGIN');

2296: and lnh.loan_currency = fndc.currency_code;
2297: begin
2298:
2299: l_api_name := 'updateFeeSchedule';
2300: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - BEGIN');
2301:
2302: -- Standard Start of API savepoint
2303: SAVEPOINT updateFeeSchedule;
2304:

Line 2345: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - found ' || i || 'fee structures');

2341: close c_phase;
2342:
2343: l_loan_details := lns_financials.getLoanDetails(p_loan_id, 'CURRENT', l_phase);
2344: i := p_fees_tbl.count;
2345: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - found ' || i || 'fee structures');
2346:
2347: -- validate all structures
2348: for k in 1..i loop
2349:

Line 2400: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, 'Fee_schedule_id is '||p_fees_tbl(k).FEE_SCHEDULE_ID);

2396: end if;
2397:
2398: end if;
2399:
2400: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, 'Fee_schedule_id is '||p_fees_tbl(k).FEE_SCHEDULE_ID);
2401:
2402: if p_fees_tbl(k).FEE_SCHEDULE_ID is null then
2403: -- we have an origination fee
2404: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, 'p_loan_id : '||p_loan_id||' and fee_id : '||p_fees_tbl(k).FEE_ID);

Line 2404: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, 'p_loan_id : '||p_loan_id||' and fee_id : '||p_fees_tbl(k).FEE_ID);

2400: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, 'Fee_schedule_id is '||p_fees_tbl(k).FEE_SCHEDULE_ID);
2401:
2402: if p_fees_tbl(k).FEE_SCHEDULE_ID is null then
2403: -- we have an origination fee
2404: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, 'p_loan_id : '||p_loan_id||' and fee_id : '||p_fees_tbl(k).FEE_ID);
2405: open c_fee_schedule_id(p_loan_id, p_fees_tbl(k).FEE_ID);
2406: fetch c_fee_schedule_id into l_fee_schedule_id;
2407: close c_fee_schedule_id;
2408:

Line 2414: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, 'Fee_schedule_id is '||p_fees_tbl(k).FEE_SCHEDULE_ID);

2410: l_fee_schedule_id := p_fees_tbl(k).FEE_SCHEDULE_ID;
2411:
2412: end if;
2413:
2414: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, 'Fee_schedule_id is '||p_fees_tbl(k).FEE_SCHEDULE_ID);
2415:
2416: -- fee structure has been validated write to the fee schedule
2417: LNS_FEE_SCHEDULES_PKG.UPDATE_ROW(P_FEE_SCHEDULE_ID => l_fee_schedule_id
2418: ,P_FEE_ID => p_fees_tbl(k).FEE_ID

Line 2446: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - END');

2442: END IF;
2443:
2444: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
2445:
2446: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - END');
2447:
2448: EXCEPTION
2449: WHEN FND_API.G_EXC_ERROR THEN
2450: x_return_status := FND_API.G_RET_STS_ERROR;

Line 2454: logMessage(FND_LOG.LEVEL_ERROR, G_PKG_NAME, sqlerrm);

2450: x_return_status := FND_API.G_RET_STS_ERROR;
2451: x_msg_count := l_msg_count;
2452: x_msg_data := l_msg_data;
2453: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
2454: logMessage(FND_LOG.LEVEL_ERROR, G_PKG_NAME, sqlerrm);
2455: ROLLBACK TO updateFeeSchedule;
2456:
2457: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2458: x_return_status := FND_API.G_RET_STS_ERROR;

Line 2462: logMessage(FND_LOG.LEVEL_ERROR, G_PKG_NAME, sqlerrm);

2458: x_return_status := FND_API.G_RET_STS_ERROR;
2459: x_msg_count := l_msg_count;
2460: x_msg_data := l_msg_data;
2461: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
2462: logMessage(FND_LOG.LEVEL_ERROR, G_PKG_NAME, sqlerrm);
2463: ROLLBACK TO updateFeeSchedule;
2464:
2465: WHEN OTHERS THEN
2466: x_return_status := FND_API.G_RET_STS_ERROR;

Line 2470: logMessage(FND_LOG.LEVEL_ERROR, G_PKG_NAME, sqlerrm);

2466: x_return_status := FND_API.G_RET_STS_ERROR;
2467: x_msg_count := l_msg_count;
2468: x_msg_data := l_msg_data;
2469: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
2470: logMessage(FND_LOG.LEVEL_ERROR, G_PKG_NAME, sqlerrm);
2471: ROLLBACK TO updateFeeSchedule;
2472:
2473: end updateFeeSchedule;
2474:

Line 2526: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - BEGIN');

2522:
2523: begin
2524:
2525: l_api_name := 'writeFeeSchedule';
2526: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - BEGIN');
2527:
2528: -- Standard Start of API savepoint
2529: SAVEPOINT writeFeeSchedule;
2530:

Line 2566: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - found ' || i || 'fee structures');

2562: close c_phase;
2563:
2564: l_loan_details := lns_financials.getLoanDetails(p_loan_id, 'CURRENT', l_phase);
2565: i := p_fees_tbl.count;
2566: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - found ' || i || 'fee structures');
2567:
2568: -- validate all structures
2569: for k in 1..i loop
2570:

Line 2623: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - validation bypassed');

2619: end if;
2620:
2621: end if;
2622: else
2623: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - validation bypassed');
2624: end if; -- disb_header_id
2625: --
2626: select lns_fee_schedule_s.nextval
2627: into l_fee_schedule_id

Line 2665: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - END');

2661: END IF;
2662:
2663: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
2664:
2665: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - END');
2666:
2667: EXCEPTION
2668: WHEN FND_API.G_EXC_ERROR THEN
2669: x_return_status := FND_API.G_RET_STS_ERROR;

Line 2673: logMessage(FND_LOG.LEVEL_ERROR, G_PKG_NAME, sqlerrm);

2669: x_return_status := FND_API.G_RET_STS_ERROR;
2670: x_msg_count := l_msg_count;
2671: x_msg_data := l_msg_data;
2672: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
2673: logMessage(FND_LOG.LEVEL_ERROR, G_PKG_NAME, sqlerrm);
2674: ROLLBACK TO writeFeeSchedule;
2675:
2676: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2677: x_return_status := FND_API.G_RET_STS_ERROR;

Line 2681: logMessage(FND_LOG.LEVEL_ERROR, G_PKG_NAME, sqlerrm);

2677: x_return_status := FND_API.G_RET_STS_ERROR;
2678: x_msg_count := l_msg_count;
2679: x_msg_data := l_msg_data;
2680: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
2681: logMessage(FND_LOG.LEVEL_ERROR, G_PKG_NAME, sqlerrm);
2682: ROLLBACK TO writeFeeSchedule;
2683:
2684: WHEN OTHERS THEN
2685: x_return_status := FND_API.G_RET_STS_ERROR;

Line 2689: logMessage(FND_LOG.LEVEL_ERROR, G_PKG_NAME, sqlerrm);

2685: x_return_status := FND_API.G_RET_STS_ERROR;
2686: x_msg_count := l_msg_count;
2687: x_msg_data := l_msg_data;
2688: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
2689: logMessage(FND_LOG.LEVEL_ERROR, G_PKG_NAME, sqlerrm);
2690: ROLLBACK TO writeFeeSchedule;
2691:
2692: end writeFeeSchedule;
2693:

Line 2784: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - BEGIN');

2780: and am.payment_number = c_installment));
2781: begin
2782:
2783: l_api_name := 'processFees';
2784: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - BEGIN');
2785:
2786: -- Standard Start of API savepoint
2787: SAVEPOINT processFees;
2788:

Line 2808: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - p_fee_structures.count = ' || p_fee_structures.count);

2804: 1. getFeeStructures for a particular event(s)
2805: 2. calculate for installment
2806: 3. write to schedule
2807: */
2808: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - p_fee_structures.count = ' || p_fee_structures.count);
2809: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - p_fee_basis_tbl.count = ' || p_fee_basis_tbl.count);
2810:
2811: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - p_loan_id = ' || p_loan_id);
2812: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - p_installment_number = ' || p_installment_number);

Line 2809: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - p_fee_basis_tbl.count = ' || p_fee_basis_tbl.count);

2805: 2. calculate for installment
2806: 3. write to schedule
2807: */
2808: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - p_fee_structures.count = ' || p_fee_structures.count);
2809: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - p_fee_basis_tbl.count = ' || p_fee_basis_tbl.count);
2810:
2811: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - p_loan_id = ' || p_loan_id);
2812: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - p_installment_number = ' || p_installment_number);
2813: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - fee_category = ' || p_fee_structures(1).fee_category);

Line 2811: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - p_loan_id = ' || p_loan_id);

2807: */
2808: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - p_fee_structures.count = ' || p_fee_structures.count);
2809: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - p_fee_basis_tbl.count = ' || p_fee_basis_tbl.count);
2810:
2811: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - p_loan_id = ' || p_loan_id);
2812: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - p_installment_number = ' || p_installment_number);
2813: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - fee_category = ' || p_fee_structures(1).fee_category);
2814: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - fee_type = ' || p_fee_structures(1).fee_type);
2815: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - phase = ' || p_fee_structures(1).phase);

Line 2812: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - p_installment_number = ' || p_installment_number);

2808: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - p_fee_structures.count = ' || p_fee_structures.count);
2809: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - p_fee_basis_tbl.count = ' || p_fee_basis_tbl.count);
2810:
2811: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - p_loan_id = ' || p_loan_id);
2812: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - p_installment_number = ' || p_installment_number);
2813: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - fee_category = ' || p_fee_structures(1).fee_category);
2814: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - fee_type = ' || p_fee_structures(1).fee_type);
2815: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - phase = ' || p_fee_structures(1).phase);
2816: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - FEE_BILLING_OPTION = ' || p_fee_structures(1).FEE_BILLING_OPTION);

Line 2813: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - fee_category = ' || p_fee_structures(1).fee_category);

2809: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - p_fee_basis_tbl.count = ' || p_fee_basis_tbl.count);
2810:
2811: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - p_loan_id = ' || p_loan_id);
2812: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - p_installment_number = ' || p_installment_number);
2813: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - fee_category = ' || p_fee_structures(1).fee_category);
2814: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - fee_type = ' || p_fee_structures(1).fee_type);
2815: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - phase = ' || p_fee_structures(1).phase);
2816: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - FEE_BILLING_OPTION = ' || p_fee_structures(1).FEE_BILLING_OPTION);
2817:

Line 2814: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - fee_type = ' || p_fee_structures(1).fee_type);

2810:
2811: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - p_loan_id = ' || p_loan_id);
2812: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - p_installment_number = ' || p_installment_number);
2813: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - fee_category = ' || p_fee_structures(1).fee_category);
2814: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - fee_type = ' || p_fee_structures(1).fee_type);
2815: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - phase = ' || p_fee_structures(1).phase);
2816: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - FEE_BILLING_OPTION = ' || p_fee_structures(1).FEE_BILLING_OPTION);
2817:
2818: open c_processed(p_loan_id,

Line 2815: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - phase = ' || p_fee_structures(1).phase);

2811: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - p_loan_id = ' || p_loan_id);
2812: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - p_installment_number = ' || p_installment_number);
2813: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - fee_category = ' || p_fee_structures(1).fee_category);
2814: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - fee_type = ' || p_fee_structures(1).fee_type);
2815: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - phase = ' || p_fee_structures(1).phase);
2816: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - FEE_BILLING_OPTION = ' || p_fee_structures(1).FEE_BILLING_OPTION);
2817:
2818: open c_processed(p_loan_id,
2819: p_installment_number,

Line 2816: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - FEE_BILLING_OPTION = ' || p_fee_structures(1).FEE_BILLING_OPTION);

2812: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - p_installment_number = ' || p_installment_number);
2813: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - fee_category = ' || p_fee_structures(1).fee_category);
2814: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - fee_type = ' || p_fee_structures(1).fee_type);
2815: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - phase = ' || p_fee_structures(1).phase);
2816: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - FEE_BILLING_OPTION = ' || p_fee_structures(1).FEE_BILLING_OPTION);
2817:
2818: open c_processed(p_loan_id,
2819: p_installment_number,
2820: p_fee_structures(1).fee_category,

Line 2827: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - fees already processed ' || l_processed_fees);

2823: p_fee_structures(1).FEE_BILLING_OPTION);
2824: fetch c_processed into l_processed_fees;
2825: close c_processed;
2826:
2827: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - fees already processed ' || l_processed_fees);
2828:
2829: if l_processed_fees = 0 then
2830: for i in 1..p_fee_structures.count loop
2831:

Line 2842: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - fee category ' || l_fee_category);

2838: FND_MSG_PUB.ADD;
2839: RAISE FND_API.G_EXC_ERROR;
2840: end if;
2841:
2842: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - fee category ' || l_fee_category);
2843: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - fee type ' || l_fee_type);
2844: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - phase ' || l_phase);
2845:
2846: l_fee_structures := lns_fee_engine.getFeeStructures(p_loan_id => p_loan_id

Line 2843: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - fee type ' || l_fee_type);

2839: RAISE FND_API.G_EXC_ERROR;
2840: end if;
2841:
2842: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - fee category ' || l_fee_category);
2843: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - fee type ' || l_fee_type);
2844: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - phase ' || l_phase);
2845:
2846: l_fee_structures := lns_fee_engine.getFeeStructures(p_loan_id => p_loan_id
2847: ,p_fee_category => l_fee_category

Line 2844: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - phase ' || l_phase);

2840: end if;
2841:
2842: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - fee category ' || l_fee_category);
2843: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - fee type ' || l_fee_type);
2844: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - phase ' || l_phase);
2845:
2846: l_fee_structures := lns_fee_engine.getFeeStructures(p_loan_id => p_loan_id
2847: ,p_fee_category => l_fee_category
2848: ,p_fee_type => l_fee_type

Line 2853: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - fee structures count is ' || l_fee_structures.count);

2849: ,p_installment => p_installment_number
2850: ,p_phase => l_phase
2851: ,p_fee_id => null
2852: ,p_billing_option => p_fee_structures(i).FEE_BILLING_OPTION);
2853: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - fee structures count is ' || l_fee_structures.count);
2854:
2855: lns_fee_engine.calculateFees(p_loan_id => p_loan_id
2856: ,p_fee_basis_tbl => p_fee_basis_tbl
2857: ,p_installment => p_installment_number

Line 2873: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - fee calc table count is ' || l_fee_calc_tbl.count);

2869: -- Bug#8830789 - To restrict the insertion of duplicate feeSchedule record for the same FeeId and installment of a loan.
2870: -- Delete the existed record and insert the new record
2871: -- Note:- Manual Fee doesn't be scheduled so no ManualFee records exist in FeeSchedule table.
2872:
2873: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - fee calc table count is ' || l_fee_calc_tbl.count);
2874: writeCount := 0;
2875: updateCount := 0;
2876: l_write_fee_calc_tbl.delete;
2877: l_update_fee_calc_tbl.delete;

Line 2893: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - No records in feeShcd table for ' ||l_fee_calc_tbl(f).FEE_ID||' at installment '|| l_fee_calc_tbl(f).fee_installment);

2889: AND active_flag = 'Y'
2890: AND billed_flag = 'N';
2891: EXCEPTION
2892: WHEN NO_DATA_FOUND THEN
2893: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - No records in feeShcd table for ' ||l_fee_calc_tbl(f).FEE_ID||' at installment '|| l_fee_calc_tbl(f).fee_installment);
2894: l_fee_schedule_id := NULL;
2895: END;
2896:
2897: IF l_fee_schedule_id IS NULL THEN

Line 2900: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - Inserting calculated fee with fee_id as ' ||l_fee_calc_tbl(f).FEE_ID);

2896:
2897: IF l_fee_schedule_id IS NULL THEN
2898: -- Insert the FeeSchedule Record
2899:
2900: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - Inserting calculated fee with fee_id as ' ||l_fee_calc_tbl(f).FEE_ID);
2901: writeCount := writeCount + 1;
2902: l_write_fee_calc_tbl(writeCount) := l_fee_calc_tbl(f);
2903:
2904: ELSE

Line 2908: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' -The feeSchd '||l_fee_schedule_id||' is already billed. So dont update the record' );

2904: ELSE
2905: -- Update the existed FeeSchedule record
2906:
2907: IF l_billed_flag = 'Y' THEN
2908: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' -The feeSchd '||l_fee_schedule_id||' is already billed. So dont update the record' );
2909: ELSE
2910: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - Updating calculated fee for fee_schedule_id '||l_fee_schedule_id);
2911: updateCount := updateCount + 1;
2912: l_update_fee_calc_tbl(updateCount) := l_fee_calc_tbl(f);

Line 2910: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - Updating calculated fee for fee_schedule_id '||l_fee_schedule_id);

2906:
2907: IF l_billed_flag = 'Y' THEN
2908: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' -The feeSchd '||l_fee_schedule_id||' is already billed. So dont update the record' );
2909: ELSE
2910: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - Updating calculated fee for fee_schedule_id '||l_fee_schedule_id);
2911: updateCount := updateCount + 1;
2912: l_update_fee_calc_tbl(updateCount) := l_fee_calc_tbl(f);
2913: l_update_fee_calc_tbl(updateCount).FEE_SCHEDULE_ID := l_fee_schedule_id;
2914: END IF;

Line 2918: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' Total No of New Records are '||writeCount );

2914: END IF;
2915: END IF;
2916: END LOOP;
2917:
2918: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' Total No of New Records are '||writeCount );
2919: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' Total No of Updatable Records are '||updateCount );
2920:
2921: IF (writeCount > 0) THEN
2922: lns_fee_engine.writeFeeSchedule(p_init_msg_list => p_init_msg_list

Line 2919: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' Total No of Updatable Records are '||updateCount );

2915: END IF;
2916: END LOOP;
2917:
2918: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' Total No of New Records are '||writeCount );
2919: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' Total No of Updatable Records are '||updateCount );
2920:
2921: IF (writeCount > 0) THEN
2922: lns_fee_engine.writeFeeSchedule(p_init_msg_list => p_init_msg_list
2923: ,p_commit => p_commit

Line 2969: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - END');

2965: END IF;
2966:
2967: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
2968:
2969: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - END');
2970:
2971: EXCEPTION
2972: WHEN FND_API.G_EXC_ERROR THEN
2973: x_return_status := FND_API.G_RET_STS_ERROR;

Line 2977: logMessage(FND_LOG.LEVEL_ERROR, G_PKG_NAME, sqlerrm);

2973: x_return_status := FND_API.G_RET_STS_ERROR;
2974: x_msg_count := l_msg_count;
2975: x_msg_data := l_msg_data;
2976: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
2977: logMessage(FND_LOG.LEVEL_ERROR, G_PKG_NAME, sqlerrm);
2978: ROLLBACK TO processFees;
2979:
2980: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2981: x_return_status := FND_API.G_RET_STS_ERROR;

Line 2985: logMessage(FND_LOG.LEVEL_ERROR, G_PKG_NAME, sqlerrm);

2981: x_return_status := FND_API.G_RET_STS_ERROR;
2982: x_msg_count := l_msg_count;
2983: x_msg_data := l_msg_data;
2984: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
2985: logMessage(FND_LOG.LEVEL_ERROR, G_PKG_NAME, sqlerrm);
2986: ROLLBACK TO processFees;
2987:
2988: WHEN OTHERS THEN
2989: x_return_status := FND_API.G_RET_STS_ERROR;

Line 2993: logMessage(FND_LOG.LEVEL_ERROR, G_PKG_NAME, sqlerrm);

2989: x_return_status := FND_API.G_RET_STS_ERROR;
2990: x_msg_count := l_msg_count;
2991: x_msg_data := l_msg_data;
2992: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
2993: logMessage(FND_LOG.LEVEL_ERROR, G_PKG_NAME, sqlerrm);
2994: ROLLBACK TO processFees;
2995:
2996: end processFees;
2997:

Line 3053: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - BEGIN');

3049:
3050: begin
3051:
3052: l_api_name := 'waiveFee';
3053: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - BEGIN');
3054:
3055: -- Standard Start of API savepoint
3056: SAVEPOINT waiveFee;
3057:

Line 3103: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - amount to waive ' || p_waive_amount);

3099: FND_MSG_PUB.ADD;
3100: RAISE FND_API.G_EXC_ERROR;
3101: end if;
3102:
3103: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - amount to waive ' || p_waive_amount);
3104:
3105: if p_waive_amount is null then
3106: FND_MESSAGE.SET_NAME('LNS', 'LNS_WAIVE_AMOUNT_INVALID');
3107: FND_MSG_PUB.ADD;

Line 3114: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - amount remain ' || l_fee_amount_remaining);

3110: open c_fee_waive_amount(p_fee_schedule_id);
3111: fetch c_fee_waive_amount into l_fee_amount_remaining, l_waived_amount;
3112: close c_fee_waive_amount;
3113:
3114: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - amount remain ' || l_fee_amount_remaining);
3115: if p_waive_amount > l_fee_amount_remaining or p_waive_amount < 0 then
3116: FND_MESSAGE.SET_NAME('LNS', 'LNS_WAIVE_AMOUNT_INVALID');
3117: FND_MSG_PUB.ADD;
3118: RAISE FND_API.G_EXC_ERROR;

Line 3154: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - END');

3150: END IF;
3151:
3152: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
3153:
3154: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - END');
3155:
3156: EXCEPTION
3157: WHEN FND_API.G_EXC_ERROR THEN
3158: x_return_status := FND_API.G_RET_STS_ERROR;

Line 3162: logMessage(FND_LOG.LEVEL_ERROR, G_PKG_NAME, sqlerrm);

3158: x_return_status := FND_API.G_RET_STS_ERROR;
3159: x_msg_count := l_msg_count;
3160: x_msg_data := l_msg_data;
3161: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
3162: logMessage(FND_LOG.LEVEL_ERROR, G_PKG_NAME, sqlerrm);
3163: ROLLBACK TO waiveFee;
3164:
3165: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3166: x_return_status := FND_API.G_RET_STS_ERROR;

Line 3170: logMessage(FND_LOG.LEVEL_ERROR, G_PKG_NAME, sqlerrm);

3166: x_return_status := FND_API.G_RET_STS_ERROR;
3167: x_msg_count := l_msg_count;
3168: x_msg_data := l_msg_data;
3169: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
3170: logMessage(FND_LOG.LEVEL_ERROR, G_PKG_NAME, sqlerrm);
3171: ROLLBACK TO waiveFee;
3172:
3173: WHEN OTHERS THEN
3174: x_return_status := FND_API.G_RET_STS_ERROR;

Line 3178: logMessage(FND_LOG.LEVEL_ERROR, G_PKG_NAME, sqlerrm);

3174: x_return_status := FND_API.G_RET_STS_ERROR;
3175: x_msg_count := l_msg_count;
3176: x_msg_data := l_msg_data;
3177: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
3178: logMessage(FND_LOG.LEVEL_ERROR, G_PKG_NAME, sqlerrm);
3179: ROLLBACK TO waiveFee;
3180:
3181: end waiveFee;
3182:

Line 3234: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - fee_category ' || p_fee_category);

3230: ' Where sched.loan_id = :p_loan_id ' ||
3231: ' and sched.billed_flag = :p_billed_flag ' ||
3232: ' and sched.active_flag = ''Y'' ';
3233:
3234: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - fee_category ' || p_fee_category);
3235: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - fee_tpye ' || p_fee_type);
3236: if p_fee_category is not null then
3237: vPLSQL := vPLSQL || ' AND fees.fee_category = ''' || p_fee_category || '''';
3238: end if;

Line 3235: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - fee_tpye ' || p_fee_type);

3231: ' and sched.billed_flag = :p_billed_flag ' ||
3232: ' and sched.active_flag = ''Y'' ';
3233:
3234: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - fee_category ' || p_fee_category);
3235: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - fee_tpye ' || p_fee_type);
3236: if p_fee_category is not null then
3237: vPLSQL := vPLSQL || ' AND fees.fee_category = ''' || p_fee_category || '''';
3238: end if;
3239:

Line 3245: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - include p_memo_fees ' || p_memo_fees);

3241: vPLSQL := vPLSQL || ' AND fees.fee_type = ''' || p_fee_type || '''';
3242: end if;
3243:
3244: /*
3245: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - include p_memo_fees ' || p_memo_fees);
3246: if p_memo_fees = 'Y' then
3247: vPLSQL := vPLSQL || ' AND fees.fee_category = ''MEMO''';
3248: else
3249: vPLSQL := vPLSQL || ' AND fees.fee_category <> ''MEMO''';

Line 3252: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - sql ' || vPLSQL);

3248: else
3249: vPLSQL := vPLSQL || ' AND fees.fee_category <> ''MEMO''';
3250: end if;
3251: */
3252: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - sql ' || vPLSQL);
3253: open sql_cur for
3254: vPLSQL
3255: using p_waived_flag, p_loan_id, p_billed_flag;
3256: fetch sql_cur into l_total;

Line 3352: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - BEGIN');

3348:
3349: begin
3350:
3351: l_api_name := 'processLateFees';
3352: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - BEGIN');
3353:
3354: -- Standard Start of API savepoint
3355: SAVEPOINT processLateFees;
3356:

Line 3378: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, l_api_name || ' - p_loan_id = ' || p_loan_id);

3374: l_update_fee_calc_tbl.delete;
3375:
3376: l_phase := nvl(p_phase, 'TERM');
3377:
3378: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, l_api_name || ' - p_loan_id = ' || p_loan_id);
3379: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, l_api_name || ' - l_phase = ' || l_phase);
3380:
3381: l_loan_details := lns_financials.getLoanDetails(p_loan_id, 'CURRENT', l_phase);
3382:

Line 3379: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, l_api_name || ' - l_phase = ' || l_phase);

3375:
3376: l_phase := nvl(p_phase, 'TERM');
3377:
3378: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, l_api_name || ' - p_loan_id = ' || p_loan_id);
3379: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, l_api_name || ' - l_phase = ' || l_phase);
3380:
3381: l_loan_details := lns_financials.getLoanDetails(p_loan_id, 'CURRENT', l_phase);
3382:
3383: l_last_installment := l_loan_details.last_installment_billed;

Line 3385: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, l_api_name || ' - l_last_installment = ' || l_last_installment);

3381: l_loan_details := lns_financials.getLoanDetails(p_loan_id, 'CURRENT', l_phase);
3382:
3383: l_last_installment := l_loan_details.last_installment_billed;
3384: l_current_installment := l_last_installment + 1;
3385: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, l_api_name || ' - l_last_installment = ' || l_last_installment);
3386: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, l_api_name || ' - l_current_installment = ' || l_current_installment);
3387:
3388: if l_last_installment > 0 then
3389:

Line 3386: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, l_api_name || ' - l_current_installment = ' || l_current_installment);

3382:
3383: l_last_installment := l_loan_details.last_installment_billed;
3384: l_current_installment := l_last_installment + 1;
3385: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, l_api_name || ' - l_last_installment = ' || l_last_installment);
3386: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, l_api_name || ' - l_current_installment = ' || l_current_installment);
3387:
3388: if l_last_installment > 0 then
3389:
3390: open last_instal_cur(p_loan_id, l_last_installment);

Line 3393: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, l_api_name || ' - l_due_date = ' || l_due_date);

3389:
3390: open last_instal_cur(p_loan_id, l_last_installment);
3391: fetch last_instal_cur into l_due_date;
3392: close last_instal_cur;
3393: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, l_api_name || ' - l_due_date = ' || l_due_date);
3394:
3395: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, l_api_name || ' - Calling getFeeStructures...');
3396: l_late_fee_structures := lns_fee_engine.getFeeStructures(p_loan_id => p_loan_id
3397: ,p_fee_category => 'EVENT'

Line 3395: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, l_api_name || ' - Calling getFeeStructures...');

3391: fetch last_instal_cur into l_due_date;
3392: close last_instal_cur;
3393: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, l_api_name || ' - l_due_date = ' || l_due_date);
3394:
3395: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, l_api_name || ' - Calling getFeeStructures...');
3396: l_late_fee_structures := lns_fee_engine.getFeeStructures(p_loan_id => p_loan_id
3397: ,p_fee_category => 'EVENT'
3398: ,p_fee_type => 'EVENT_LATE_CHARGE'
3399: ,p_installment => null

Line 3402: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, l_api_name || ' - after getFeeStructures api');

3398: ,p_fee_type => 'EVENT_LATE_CHARGE'
3399: ,p_installment => null
3400: ,p_phase => l_phase
3401: ,p_fee_id => null);
3402: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, l_api_name || ' - after getFeeStructures api');
3403: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, l_api_name || ' - l_late_fee_structures.count = ' || l_late_fee_structures.count);
3404:
3405: for x in 1..l_late_fee_structures.count loop
3406:

Line 3403: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, l_api_name || ' - l_late_fee_structures.count = ' || l_late_fee_structures.count);

3399: ,p_installment => null
3400: ,p_phase => l_phase
3401: ,p_fee_id => null);
3402: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, l_api_name || ' - after getFeeStructures api');
3403: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, l_api_name || ' - l_late_fee_structures.count = ' || l_late_fee_structures.count);
3404:
3405: for x in 1..l_late_fee_structures.count loop
3406:
3407: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, l_api_name || ' ');

Line 3407: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, l_api_name || ' ');

3403: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, l_api_name || ' - l_late_fee_structures.count = ' || l_late_fee_structures.count);
3404:
3405: for x in 1..l_late_fee_structures.count loop
3406:
3407: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, l_api_name || ' ');
3408: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, l_api_name || ' ' || l_late_fee_structures(x).fee_name);
3409:
3410: l_late_date := l_due_date + l_late_fee_structures(x).NUMBER_GRACE_DAYS;
3411: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, l_api_name || ' - l_late_date = ' || l_late_date);

Line 3408: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, l_api_name || ' ' || l_late_fee_structures(x).fee_name);

3404:
3405: for x in 1..l_late_fee_structures.count loop
3406:
3407: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, l_api_name || ' ');
3408: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, l_api_name || ' ' || l_late_fee_structures(x).fee_name);
3409:
3410: l_late_date := l_due_date + l_late_fee_structures(x).NUMBER_GRACE_DAYS;
3411: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, l_api_name || ' - l_late_date = ' || l_late_date);
3412:

Line 3411: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, l_api_name || ' - l_late_date = ' || l_late_date);

3407: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, l_api_name || ' ');
3408: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, l_api_name || ' ' || l_late_fee_structures(x).fee_name);
3409:
3410: l_late_date := l_due_date + l_late_fee_structures(x).NUMBER_GRACE_DAYS;
3411: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, l_api_name || ' - l_late_date = ' || l_late_date);
3412:
3413: open c_prin_overdue(p_loan_id, l_late_date);
3414: fetch c_prin_overdue into l_prin_overdue;
3415: close c_prin_overdue;

Line 3416: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, l_api_name || ' - l_prin_overdue = ' || l_prin_overdue);

3412:
3413: open c_prin_overdue(p_loan_id, l_late_date);
3414: fetch c_prin_overdue into l_prin_overdue;
3415: close c_prin_overdue;
3416: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, l_api_name || ' - l_prin_overdue = ' || l_prin_overdue);
3417:
3418: open c_int_overdue(p_loan_id, l_late_date);
3419: fetch c_int_overdue into l_int_overdue;
3420: close c_int_overdue;

Line 3421: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, l_api_name || ' - l_int_overdue = ' || l_int_overdue);

3417:
3418: open c_int_overdue(p_loan_id, l_late_date);
3419: fetch c_int_overdue into l_int_overdue;
3420: close c_int_overdue;
3421: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, l_api_name || ' - l_int_overdue = ' || l_int_overdue);
3422:
3423: l_fee_basis_tbl(1).fee_basis_name := 'OVERDUE_PRIN_INT';
3424: l_fee_basis_tbl(1).fee_basis_amount := l_prin_overdue + l_int_overdue;
3425: l_fee_basis_tbl(2).fee_basis_name := 'OVERDUE_INT';

Line 3444: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, l_api_name || ' - l_amount_overdue = ' || l_amount_overdue);

3440: end if;
3441:
3442: l_late_fee_structure(1) := l_late_fee_structures(x);
3443:
3444: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, l_api_name || ' - l_amount_overdue = ' || l_amount_overdue);
3445: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, l_api_name || ' - minimum_overdue_amount = ' || l_late_fee_structure(1).minimum_overdue_amount);
3446:
3447: if l_amount_overdue > l_late_fee_structure(1).minimum_overdue_amount and l_amount_overdue > 0 then
3448:

Line 3445: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, l_api_name || ' - minimum_overdue_amount = ' || l_late_fee_structure(1).minimum_overdue_amount);

3441:
3442: l_late_fee_structure(1) := l_late_fee_structures(x);
3443:
3444: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, l_api_name || ' - l_amount_overdue = ' || l_amount_overdue);
3445: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, l_api_name || ' - minimum_overdue_amount = ' || l_late_fee_structure(1).minimum_overdue_amount);
3446:
3447: if l_amount_overdue > l_late_fee_structure(1).minimum_overdue_amount and l_amount_overdue > 0 then
3448:
3449: i := i + 1;

Line 3450: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, l_api_name || ' - Calling calculateFees...');

3446:
3447: if l_amount_overdue > l_late_fee_structure(1).minimum_overdue_amount and l_amount_overdue > 0 then
3448:
3449: i := i + 1;
3450: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, l_api_name || ' - Calling calculateFees...');
3451: lns_fee_engine.calculateFees(p_loan_id => p_loan_id
3452: ,p_fee_basis_tbl => l_fee_basis_tbl
3453: ,p_installment => l_current_installment
3454: ,p_fee_structures => l_late_fee_structure

Line 3459: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, l_api_name || ' - l_return_status = ' || l_return_status);

3455: ,x_fees_tbl => l_fee_calc_tbl
3456: ,x_return_status => l_return_status
3457: ,x_msg_count => l_msg_count
3458: ,x_msg_data => l_msg_data);
3459: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, l_api_name || ' - l_return_status = ' || l_return_status);
3460: if l_return_status <> FND_API.G_RET_STS_SUCCESS then
3461: FND_MESSAGE.SET_NAME('LNS', 'LNS_FEE_CALCULATION_FAILURE');
3462: FND_MSG_PUB.ADD;
3463: RAISE FND_API.G_EXC_ERROR;

Line 3477: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, l_api_name || ' - No records in feeShcd table for ' ||l_fee_calc_tbl(1).FEE_ID||' at installment '|| l_fee_calc_tbl(1).fee_installment);

3473: AND active_flag = 'Y'
3474: AND billed_flag = 'N';
3475: EXCEPTION
3476: WHEN NO_DATA_FOUND THEN
3477: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, l_api_name || ' - No records in feeShcd table for ' ||l_fee_calc_tbl(1).FEE_ID||' at installment '|| l_fee_calc_tbl(1).fee_installment);
3478: l_fee_schedule_id := NULL;
3479: END;
3480:
3481: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, l_api_name || ' - l_fee_schedule_id = ' || l_fee_schedule_id);

Line 3481: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, l_api_name || ' - l_fee_schedule_id = ' || l_fee_schedule_id);

3477: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, l_api_name || ' - No records in feeShcd table for ' ||l_fee_calc_tbl(1).FEE_ID||' at installment '|| l_fee_calc_tbl(1).fee_installment);
3478: l_fee_schedule_id := NULL;
3479: END;
3480:
3481: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, l_api_name || ' - l_fee_schedule_id = ' || l_fee_schedule_id);
3482: IF l_fee_schedule_id IS NULL THEN
3483: -- Insert the FeeSchedule Record
3484:
3485: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, l_api_name || ' - Inserting fee with fee_id = ' || l_fee_calc_tbl(1).FEE_ID);

Line 3485: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, l_api_name || ' - Inserting fee with fee_id = ' || l_fee_calc_tbl(1).FEE_ID);

3481: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, l_api_name || ' - l_fee_schedule_id = ' || l_fee_schedule_id);
3482: IF l_fee_schedule_id IS NULL THEN
3483: -- Insert the FeeSchedule Record
3484:
3485: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, l_api_name || ' - Inserting fee with fee_id = ' || l_fee_calc_tbl(1).FEE_ID);
3486: writeCount := writeCount + 1;
3487: l_write_fee_calc_tbl(writeCount) := l_fee_calc_tbl(1);
3488:
3489: ELSE

Line 3492: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, l_api_name || ' - Updating fee for fee_schedule_id = ' || l_fee_schedule_id);

3488:
3489: ELSE
3490: -- Update the existed FeeSchedule record
3491:
3492: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, l_api_name || ' - Updating fee for fee_schedule_id = ' || l_fee_schedule_id);
3493: updateCount := updateCount + 1;
3494: l_update_fee_calc_tbl(updateCount) := l_fee_calc_tbl(1);
3495: l_update_fee_calc_tbl(updateCount).FEE_SCHEDULE_ID := l_fee_schedule_id;
3496:

Line 3500: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, l_api_name || ' - Deleting fee with fee_id = ' || l_late_fee_structure(1).fee_id);

3496:
3497: END IF;
3498:
3499: else
3500: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, l_api_name || ' - Deleting fee with fee_id = ' || l_late_fee_structure(1).fee_id);
3501:
3502: delete from lns_fee_schedules
3503: WHERE loan_id = p_loan_id
3504: AND fee_id = l_late_fee_structure(1).fee_id

Line 3515: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, l_api_name || ' Total No of New Records = ' || writeCount );

3511: end if;
3512:
3513: end loop;
3514:
3515: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, l_api_name || ' Total No of New Records = ' || writeCount );
3516: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, l_api_name || ' Total No of Updatable Records = ' || updateCount );
3517: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, l_api_name || ' Total No of Deleted Records = ' || deleteCount );
3518:
3519: IF (writeCount > 0) THEN

Line 3516: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, l_api_name || ' Total No of Updatable Records = ' || updateCount );

3512:
3513: end loop;
3514:
3515: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, l_api_name || ' Total No of New Records = ' || writeCount );
3516: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, l_api_name || ' Total No of Updatable Records = ' || updateCount );
3517: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, l_api_name || ' Total No of Deleted Records = ' || deleteCount );
3518:
3519: IF (writeCount > 0) THEN
3520: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, l_api_name || ' Calling writeFeeSchedule...');

Line 3517: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, l_api_name || ' Total No of Deleted Records = ' || deleteCount );

3513: end loop;
3514:
3515: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, l_api_name || ' Total No of New Records = ' || writeCount );
3516: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, l_api_name || ' Total No of Updatable Records = ' || updateCount );
3517: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, l_api_name || ' Total No of Deleted Records = ' || deleteCount );
3518:
3519: IF (writeCount > 0) THEN
3520: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, l_api_name || ' Calling writeFeeSchedule...');
3521: lns_fee_engine.writeFeeSchedule(p_init_msg_list => p_init_msg_list

Line 3520: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, l_api_name || ' Calling writeFeeSchedule...');

3516: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, l_api_name || ' Total No of Updatable Records = ' || updateCount );
3517: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, l_api_name || ' Total No of Deleted Records = ' || deleteCount );
3518:
3519: IF (writeCount > 0) THEN
3520: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, l_api_name || ' Calling writeFeeSchedule...');
3521: lns_fee_engine.writeFeeSchedule(p_init_msg_list => p_init_msg_list
3522: ,p_commit => p_commit
3523: ,p_loan_id => p_loan_id
3524: ,p_fees_tbl => l_write_fee_calc_tbl

Line 3537: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, l_api_name || ' Calling updateFeeSchedule...');

3533:
3534: END IF;
3535:
3536: IF (updateCount > 0) THEN
3537: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, l_api_name || ' Calling updateFeeSchedule...');
3538: lns_fee_engine.updateFeeSchedule(p_init_msg_list => p_init_msg_list
3539: ,p_commit => p_commit
3540: ,p_loan_id => p_loan_id
3541: ,p_fees_tbl => l_update_fee_calc_tbl

Line 3563: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - END');

3559: END IF;
3560:
3561: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
3562:
3563: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - END');
3564:
3565: EXCEPTION
3566: WHEN FND_API.G_EXC_ERROR THEN
3567: x_return_status := FND_API.G_RET_STS_ERROR;

Line 3571: logMessage(FND_LOG.LEVEL_ERROR, G_PKG_NAME, sqlerrm);

3567: x_return_status := FND_API.G_RET_STS_ERROR;
3568: x_msg_count := l_msg_count;
3569: x_msg_data := l_msg_data;
3570: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
3571: logMessage(FND_LOG.LEVEL_ERROR, G_PKG_NAME, sqlerrm);
3572: ROLLBACK TO processLateFees;
3573:
3574: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3575: x_return_status := FND_API.G_RET_STS_ERROR;

Line 3579: logMessage(FND_LOG.LEVEL_ERROR, G_PKG_NAME, sqlerrm);

3575: x_return_status := FND_API.G_RET_STS_ERROR;
3576: x_msg_count := l_msg_count;
3577: x_msg_data := l_msg_data;
3578: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
3579: logMessage(FND_LOG.LEVEL_ERROR, G_PKG_NAME, sqlerrm);
3580: ROLLBACK TO processLateFees;
3581:
3582: WHEN OTHERS THEN
3583: x_return_status := FND_API.G_RET_STS_ERROR;

Line 3587: logMessage(FND_LOG.LEVEL_ERROR, G_PKG_NAME, sqlerrm);

3583: x_return_status := FND_API.G_RET_STS_ERROR;
3584: x_msg_count := l_msg_count;
3585: x_msg_data := l_msg_data;
3586: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
3587: logMessage(FND_LOG.LEVEL_ERROR, G_PKG_NAME, sqlerrm);
3588: ROLLBACK TO processLateFees;
3589:
3590:
3591: end processLateFees;

Line 3846: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - BEGIN');

3842:
3843: begin
3844:
3845: l_api_name := 'getSubmitForApprFeeSchedule';
3846: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - BEGIN');
3847:
3848: -- Standard Start of API savepoint
3849: SAVEPOINT getSubmitForApprFeeSchedule;
3850:

Line 3864: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, 'The p_billed_flag is :'||p_billed_flag);

3860: -- Api body
3861: -- ---------------------------------------------------------------------
3862: -- initialize any variables here
3863: i := 0;
3864: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, 'The p_billed_flag is :'||p_billed_flag);
3865: OPEN c_submit_appr_fees(p_loan_id, 0, p_billed_flag);
3866: LOOP
3867:
3868: FETCH c_submit_appr_fees INTO

Line 3897: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - SubmtApproval fee #: ' || i);

3893: l_fee_rec.fee_deletable_flag := l_fee_deletable_flag;
3894: l_fee_rec.fee_editable_flag := l_fee_editable_flag;
3895: l_fee_rec.phase := l_phase;
3896:
3897: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - SubmtApproval fee #: ' || i);
3898: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - fee schedule id: ' || l_fee_rec.fee_schedule_id);
3899: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - fee id: ' || l_fee_rec.fee_id);
3900: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - fee amount: ' || l_fee_rec.fee_amount);
3901: x_fees_tbl(i) := l_fee_rec;

Line 3898: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - fee schedule id: ' || l_fee_rec.fee_schedule_id);

3894: l_fee_rec.fee_editable_flag := l_fee_editable_flag;
3895: l_fee_rec.phase := l_phase;
3896:
3897: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - SubmtApproval fee #: ' || i);
3898: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - fee schedule id: ' || l_fee_rec.fee_schedule_id);
3899: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - fee id: ' || l_fee_rec.fee_id);
3900: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - fee amount: ' || l_fee_rec.fee_amount);
3901: x_fees_tbl(i) := l_fee_rec;
3902: END LOOP;

Line 3899: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - fee id: ' || l_fee_rec.fee_id);

3895: l_fee_rec.phase := l_phase;
3896:
3897: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - SubmtApproval fee #: ' || i);
3898: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - fee schedule id: ' || l_fee_rec.fee_schedule_id);
3899: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - fee id: ' || l_fee_rec.fee_id);
3900: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - fee amount: ' || l_fee_rec.fee_amount);
3901: x_fees_tbl(i) := l_fee_rec;
3902: END LOOP;
3903:

Line 3900: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - fee amount: ' || l_fee_rec.fee_amount);

3896:
3897: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - SubmtApproval fee #: ' || i);
3898: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - fee schedule id: ' || l_fee_rec.fee_schedule_id);
3899: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - fee id: ' || l_fee_rec.fee_id);
3900: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - fee amount: ' || l_fee_rec.fee_amount);
3901: x_fees_tbl(i) := l_fee_rec;
3902: END LOOP;
3903:
3904: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - Total No. of SubmitApproval Fees are: ' || i);

Line 3904: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - Total No. of SubmitApproval Fees are: ' || i);

3900: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - fee amount: ' || l_fee_rec.fee_amount);
3901: x_fees_tbl(i) := l_fee_rec;
3902: END LOOP;
3903:
3904: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - Total No. of SubmitApproval Fees are: ' || i);
3905:
3906: -- ---------------------------------------------------------------------
3907: -- End of API body
3908: -- ---------------------------------------------------------------------

Line 3911: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - END');

3907: -- End of API body
3908: -- ---------------------------------------------------------------------
3909: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
3910:
3911: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - END');
3912:
3913: EXCEPTION
3914: WHEN FND_API.G_EXC_ERROR THEN
3915: x_return_status := FND_API.G_RET_STS_ERROR;

Line 3919: logMessage(FND_LOG.LEVEL_ERROR, G_PKG_NAME, sqlerrm);

3915: x_return_status := FND_API.G_RET_STS_ERROR;
3916: x_msg_count := l_msg_count;
3917: x_msg_data := l_msg_data;
3918: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
3919: logMessage(FND_LOG.LEVEL_ERROR, G_PKG_NAME, sqlerrm);
3920: ROLLBACK TO getSubmitForApprFeeSchedule;
3921:
3922: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3923: x_return_status := FND_API.G_RET_STS_ERROR;

Line 3927: logMessage(FND_LOG.LEVEL_ERROR, G_PKG_NAME, sqlerrm);

3923: x_return_status := FND_API.G_RET_STS_ERROR;
3924: x_msg_count := l_msg_count;
3925: x_msg_data := l_msg_data;
3926: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
3927: logMessage(FND_LOG.LEVEL_ERROR, G_PKG_NAME, sqlerrm);
3928: ROLLBACK TO getSubmitForApprFeeSchedule;
3929:
3930: WHEN OTHERS THEN
3931: x_return_status := FND_API.G_RET_STS_ERROR;

Line 3935: logMessage(FND_LOG.LEVEL_ERROR, G_PKG_NAME, sqlerrm);

3931: x_return_status := FND_API.G_RET_STS_ERROR;
3932: x_msg_count := l_msg_count;
3933: x_msg_data := l_msg_data;
3934: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
3935: logMessage(FND_LOG.LEVEL_ERROR, G_PKG_NAME, sqlerrm);
3936: ROLLBACK TO getSubmitForApprFeeSchedule;
3937:
3938: end getSubmitForApprFeeSchedule;
3939:

Line 3980: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - BEGIN');

3976: begin
3977:
3978: l_api_name := 'SET_DISB_FEES_INSTALL';
3979:
3980: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - BEGIN');
3981:
3982: -- Standard Start of API savepoint
3983: SAVEPOINT SET_DISB_FEES_INSTALL;
3984:

Line 3999: LogMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, 'Updating the feeAssignment installments of disb_hdr_id: '||p_disb_header_id);

3995: -- ---------------------------------------------------------------------
3996: -- initialize any variables here
3997:
3998: -- Update the feeInstallment of the fundignFees of this disbursement
3999: LogMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, 'Updating the feeAssignment installments of disb_hdr_id: '||p_disb_header_id);
4000:
4001: l_inst_no := LNS_FIN_UTILS.getNextInstForDisbursement(p_disb_header_id);
4002:
4003: LogMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, 'Installment No is : '||l_inst_no);

Line 4003: LogMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, 'Installment No is : '||l_inst_no);

3999: LogMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, 'Updating the feeAssignment installments of disb_hdr_id: '||p_disb_header_id);
4000:
4001: l_inst_no := LNS_FIN_UTILS.getNextInstForDisbursement(p_disb_header_id);
4002:
4003: LogMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, 'Installment No is : '||l_inst_no);
4004:
4005: IF (l_inst_no IS NULL OR l_inst_no = -1) THEN
4006: LogMessage(FND_LOG.LEVEL_UNEXPECTED, G_PKG_NAME, 'Call to LNS_FIN_UTIL.getNextInstForDisbursement failed');
4007: ELSE

Line 4006: LogMessage(FND_LOG.LEVEL_UNEXPECTED, G_PKG_NAME, 'Call to LNS_FIN_UTIL.getNextInstForDisbursement failed');

4002:
4003: LogMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, 'Installment No is : '||l_inst_no);
4004:
4005: IF (l_inst_no IS NULL OR l_inst_no = -1) THEN
4006: LogMessage(FND_LOG.LEVEL_UNEXPECTED, G_PKG_NAME, 'Call to LNS_FIN_UTIL.getNextInstForDisbursement failed');
4007: ELSE
4008:
4009: UPDATE lns_fee_assignments
4010: SET begin_installment_number = l_inst_no

Line 4018: LogMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, 'Updated feeAssignments '||SQL%ROWCOUNT);

4014: ,last_update_date = LNS_UTILITY_PUB.last_update_date
4015: ,last_update_login = LNS_UTILITY_PUB.last_update_login
4016: WHERE disb_header_id =p_disb_header_id;
4017:
4018: LogMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, 'Updated feeAssignments '||SQL%ROWCOUNT);
4019:
4020: END IF;
4021:
4022: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - END');

Line 4022: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - END');

4018: LogMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, 'Updated feeAssignments '||SQL%ROWCOUNT);
4019:
4020: END IF;
4021:
4022: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - END');
4023:
4024: EXCEPTION
4025: WHEN FND_API.G_EXC_ERROR THEN
4026: x_return_status := FND_API.G_RET_STS_ERROR;

Line 4030: logMessage(FND_LOG.LEVEL_ERROR, G_PKG_NAME, sqlerrm);

4026: x_return_status := FND_API.G_RET_STS_ERROR;
4027: x_msg_count := l_msg_count;
4028: x_msg_data := l_msg_data;
4029: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
4030: logMessage(FND_LOG.LEVEL_ERROR, G_PKG_NAME, sqlerrm);
4031: ROLLBACK TO SET_DISB_FEES_INSTALL;
4032:
4033: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4034: x_return_status := FND_API.G_RET_STS_ERROR;

Line 4038: logMessage(FND_LOG.LEVEL_ERROR, G_PKG_NAME, sqlerrm);

4034: x_return_status := FND_API.G_RET_STS_ERROR;
4035: x_msg_count := l_msg_count;
4036: x_msg_data := l_msg_data;
4037: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
4038: logMessage(FND_LOG.LEVEL_ERROR, G_PKG_NAME, sqlerrm);
4039: ROLLBACK TO SET_DISB_FEES_INSTALL;
4040:
4041: WHEN OTHERS THEN
4042: x_return_status := FND_API.G_RET_STS_ERROR;

Line 4046: logMessage(FND_LOG.LEVEL_ERROR, G_PKG_NAME, sqlerrm);

4042: x_return_status := FND_API.G_RET_STS_ERROR;
4043: x_msg_count := l_msg_count;
4044: x_msg_data := l_msg_data;
4045: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
4046: logMessage(FND_LOG.LEVEL_ERROR, G_PKG_NAME, sqlerrm);
4047: ROLLBACK TO SET_DISB_FEES_INSTALL;
4048:
4049:
4050: END SET_DISB_FEES_INSTALL;