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

Line 24: IF log_level >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN

20: is
21:
22: begin
23:
24: IF log_level >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
25: FND_LOG.STRING(log_level, module, message);
26: END IF;
27:
28: end;

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

21:
22: begin
23:
24: IF log_level >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
25: FND_LOG.STRING(log_level, module, message);
26: END IF;
27:
28: end;
29:

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

204:
205: begin
206: l_api_name := 'processPayoff';
207: l_api_version_number := 1;
208: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - BEGIN');
209:
210: -- Standard Start of API savepoint
211: SAVEPOINT processPayoff;
212:

Line 246: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - receipts passed ' || l_cash_receipts_count);

242: s := 0;
243: b_recalculate_interest := true;
244: l_final_balance := -1; --this is for final balance check
245:
246: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - receipts passed ' || l_cash_receipts_count);
247: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - Payoff loanID ' || p_loan_id);
248: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - Payoff date ' || p_payoff_date);
249: open loans_cur(p_loan_id);
250: fetch loans_cur into

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

243: b_recalculate_interest := true;
244: l_final_balance := -1; --this is for final balance check
245:
246: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - receipts passed ' || l_cash_receipts_count);
247: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - Payoff loanID ' || p_loan_id);
248: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - Payoff date ' || p_payoff_date);
249: open loans_cur(p_loan_id);
250: fetch loans_cur into
251: l_loan_currency

Line 248: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - Payoff date ' || p_payoff_date);

244: l_final_balance := -1; --this is for final balance check
245:
246: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - receipts passed ' || l_cash_receipts_count);
247: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - Payoff loanID ' || p_loan_id);
248: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - Payoff date ' || p_payoff_date);
249: open loans_cur(p_loan_id);
250: fetch loans_cur into
251: l_loan_currency
252: ,l_loan_exchange_rate

Line 261: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - LOAN CURRENCY ' || l_loan_currency);

257:
258: open c_sob_currency;
259: fetch c_sob_currency into l_sob_currency;
260: close c_sob_currency;
261: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - LOAN CURRENCY ' || l_loan_currency);
262: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - loan_exchange_rate ' || l_loan_exchange_rate);
263:
264: /*
265: -- if loan status is not valid, exit

Line 262: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - loan_exchange_rate ' || l_loan_exchange_rate);

258: open c_sob_currency;
259: fetch c_sob_currency into l_sob_currency;
260: close c_sob_currency;
261: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - LOAN CURRENCY ' || l_loan_currency);
262: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - loan_exchange_rate ' || l_loan_exchange_rate);
263:
264: /*
265: -- if loan status is not valid, exit
266: l_loan_details := lns_financials.getLoanDetails(p_loan_id => p_loan_id

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

272: ,x_return_status => l_return_status
273: ,x_msg_count => l_msg_count
274: ,x_msg_data => l_msg_data);
275: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
276: LogMessage(FND_LOG.LEVEL_UNEXPECTED, G_PKG_NAME, l_api_name || FND_MSG_PUB.Get(p_encoded => 'F'));
277: RAISE FND_API.G_EXC_ERROR;
278: END IF;
279: */
280: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - calculating Payoff ');

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

276: LogMessage(FND_LOG.LEVEL_UNEXPECTED, G_PKG_NAME, l_api_name || FND_MSG_PUB.Get(p_encoded => 'F'));
277: RAISE FND_API.G_EXC_ERROR;
278: END IF;
279: */
280: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - calculating Payoff ');
281: lns_financials.calculatePayoff(p_api_version => 1.0
282: ,p_init_msg_list => p_init_msg_list
283: ,p_loan_id => p_loan_id
284: ,p_payoff_date => p_payoff_date

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

289:
290: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
291: FND_MESSAGE.SET_NAME('LNS', 'LNS_CALCULATE_PAYOFF_ERROR');
292: FND_MSG_PUB.Add;
293: LogMessage(FND_LOG.LEVEL_UNEXPECTED, G_PKG_NAME, l_api_name || FND_MSG_PUB.Get(p_encoded => 'F'));
294: RAISE FND_API.G_EXC_ERROR;
295: END IF;
296:
297: --2. create payoff document(s) in receivables

Line 299: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - Building Invoice header/lines');

295: END IF;
296:
297: --2. create payoff document(s) in receivables
298: -- build the header for the loan document(s) to be created
299: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - Building Invoice header/lines');
300: l_bill_headers_tbl(1).HEADER_ID := 101;
301: l_bill_headers_tbl(1).LOAN_ID := p_loan_id;
302: l_bill_headers_tbl(1).ASSOC_PAYMENT_NUM := LNS_BILLING_UTIL_PUB.LAST_PAYMENT_NUMBER(p_loan_id);
303: l_bill_headers_tbl(1).DUE_DATE := p_payoff_date;

Line 308: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - purpose ' || l_payoff_tbl2(i).payoff_purpose);

304:
305: -- now build the lines for the loan document(s) to be created
306: for i in 1..l_payoff_tbl2.count
307: loop
308: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - purpose ' || l_payoff_tbl2(i).payoff_purpose);
309: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - amount ' || l_payoff_tbl2(i).unbilled_amount);
310:
311: if l_payoff_tbl2(i).unbilled_amount > 0 and l_payoff_tbl2(i).payoff_purpose <> 'FEE' then
312: s := s + 1;

Line 309: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - amount ' || l_payoff_tbl2(i).unbilled_amount);

305: -- now build the lines for the loan document(s) to be created
306: for i in 1..l_payoff_tbl2.count
307: loop
308: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - purpose ' || l_payoff_tbl2(i).payoff_purpose);
309: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - amount ' || l_payoff_tbl2(i).unbilled_amount);
310:
311: if l_payoff_tbl2(i).unbilled_amount > 0 and l_payoff_tbl2(i).payoff_purpose <> 'FEE' then
312: s := s + 1;
313: l_bill_lines_tbl(s).LINE_ID := i;

Line 333: logMessage(FND_LOG.LEVEL_UNEXPECTED, G_PKG_NAME, l_api_name || ' - fee found');

329: l_bill_lines_tbl(s).LINE_AMOUNT := l_fee_amount;
330: l_bill_lines_tbl(s).LINE_TYPE := l_payoff_tbl2(i).payoff_purpose;
331: l_bill_lines_tbl(s).LINE_DESC := l_fee_name;
332: --l_invoices_tbl(i).INSTALLMENT_NUMBER := l_fee_installment;
333: logMessage(FND_LOG.LEVEL_UNEXPECTED, G_PKG_NAME, l_api_name || ' - fee found');
334: end loop;
335: close c_fees;
336:
337: elsif l_payoff_tbl2(i).unbilled_amount < 0 and l_payoff_tbl2(i).payoff_purpose = 'INT' then

Line 340: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - interest credit is due');

336:
337: elsif l_payoff_tbl2(i).unbilled_amount < 0 and l_payoff_tbl2(i).payoff_purpose = 'INT' then
338:
339: -- we have an interest credit due we will credit out the interest on the last amortization
340: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - interest credit is due');
341: -- 1. check to see if documents have been paid,
342: -- unapply all cash from receivable applications
343: open c_applications(p_loan_id);
344: loop

Line 363: LogMessage(FND_LOG.LEVEL_UNEXPECTED, G_PKG_NAME, l_api_name || ' - unapplying cash from pay_sched_id: ' || l_rec_application_id);

359:
360: exit when c_applications%notfound;
361:
362: -- 2. if so, unapply all cash_receipts from document
363: LogMessage(FND_LOG.LEVEL_UNEXPECTED, G_PKG_NAME, l_api_name || ' - unapplying cash from pay_sched_id: ' || l_rec_application_id);
364: ar_receipt_api_pub.unapply(p_api_version => 1.0
365: ,p_init_msg_list => p_init_msg_list
366: ,p_commit => FND_API.G_FALSE
367: ,p_receivable_application_id => l_rec_application_id

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

373: FND_MESSAGE.SET_NAME('LNS', 'LNS_UNAPPLY_CASH_ERROR');
374: FND_MESSAGE.SET_TOKEN('PARAMETER', 'RECEIPT_NUMBER');
375: FND_MESSAGE.SET_TOKEN('VALUE', l_receipt_number);
376: FND_MSG_PUB.Add;
377: logMessage(FND_LOG.LEVEL_UNEXPECTED, G_PKG_NAME, FND_MSG_PUB.Get(p_encoded => 'F'));
378: RAISE FND_API.G_EXC_ERROR;
379: end if;
380:
381:

Line 382: logMessage(FND_LOG.LEVEL_UNEXPECTED, G_PKG_NAME, l_api_name || ' - unapplied cash successfully');

378: RAISE FND_API.G_EXC_ERROR;
379: end if;
380:
381:
382: logMessage(FND_LOG.LEVEL_UNEXPECTED, G_PKG_NAME, l_api_name || ' - unapplied cash successfully');
383: -- 2a. keep unapplied cash_receipts in memory to use for payoff
384: -- bug #4191794
385: -- if this cash receipt_id exists in the set of selected cash receipts then
386: -- we will have to add it back to existing cash_receipt_id

Line 389: logMessage(FND_LOG.LEVEL_UNEXPECTED, G_PKG_NAME, l_api_name || ' - check existing cr_id: ' || l_cash_receipt_ids(j).cash_receipt_id);

385: -- if this cash receipt_id exists in the set of selected cash receipts then
386: -- we will have to add it back to existing cash_receipt_id
387: l_bool_match := false;
388: for j in 1..l_cash_receipt_ids.count loop
389: logMessage(FND_LOG.LEVEL_UNEXPECTED, G_PKG_NAME, l_api_name || ' - check existing cr_id: ' || l_cash_receipt_ids(j).cash_receipt_id);
390: if l_cash_receipt_id = l_cash_receipt_ids(j).cash_receipt_id then
391: l_cash_receipt_ids(j).receipt_amount := l_cash_receipt_ids(j).receipt_amount + l_amount_applied;
392: l_bool_match := true;
393: logMessage(FND_LOG.LEVEL_UNEXPECTED, G_PKG_NAME, l_api_name || ' - matched existing cr_id: ' || l_cash_receipt_ids(j).cash_receipt_id);

Line 393: logMessage(FND_LOG.LEVEL_UNEXPECTED, G_PKG_NAME, l_api_name || ' - matched existing cr_id: ' || l_cash_receipt_ids(j).cash_receipt_id);

389: logMessage(FND_LOG.LEVEL_UNEXPECTED, G_PKG_NAME, l_api_name || ' - check existing cr_id: ' || l_cash_receipt_ids(j).cash_receipt_id);
390: if l_cash_receipt_id = l_cash_receipt_ids(j).cash_receipt_id then
391: l_cash_receipt_ids(j).receipt_amount := l_cash_receipt_ids(j).receipt_amount + l_amount_applied;
392: l_bool_match := true;
393: logMessage(FND_LOG.LEVEL_UNEXPECTED, G_PKG_NAME, l_api_name || ' - matched existing cr_id: ' || l_cash_receipt_ids(j).cash_receipt_id);
394: exit;
395: end if;
396: end loop;
397:

Line 399: logMessage(FND_LOG.LEVEL_UNEXPECTED, G_PKG_NAME, l_api_name || ' - receipts count is: ' || l_cash_receipts_count);

395: end if;
396: end loop;
397:
398: if not l_bool_match then
399: logMessage(FND_LOG.LEVEL_UNEXPECTED, G_PKG_NAME, l_api_name || ' - receipts count is: ' || l_cash_receipts_count);
400: logMessage(FND_LOG.LEVEL_UNEXPECTED, G_PKG_NAME, l_api_name || ' - adding applied cr_id: ' || l_cash_receipt_id);
401: logMessage(FND_LOG.LEVEL_UNEXPECTED, G_PKG_NAME, l_api_name || ' - cr_id amount: ' || l_amount_applied);
402: logMessage(FND_LOG.LEVEL_UNEXPECTED, G_PKG_NAME, l_api_name || ' - cr_id currency: ' || l_loan_currency);
403: l_cash_receipts_count := l_cash_receipts_count + 1;

Line 400: logMessage(FND_LOG.LEVEL_UNEXPECTED, G_PKG_NAME, l_api_name || ' - adding applied cr_id: ' || l_cash_receipt_id);

396: end loop;
397:
398: if not l_bool_match then
399: logMessage(FND_LOG.LEVEL_UNEXPECTED, G_PKG_NAME, l_api_name || ' - receipts count is: ' || l_cash_receipts_count);
400: logMessage(FND_LOG.LEVEL_UNEXPECTED, G_PKG_NAME, l_api_name || ' - adding applied cr_id: ' || l_cash_receipt_id);
401: logMessage(FND_LOG.LEVEL_UNEXPECTED, G_PKG_NAME, l_api_name || ' - cr_id amount: ' || l_amount_applied);
402: logMessage(FND_LOG.LEVEL_UNEXPECTED, G_PKG_NAME, l_api_name || ' - cr_id currency: ' || l_loan_currency);
403: l_cash_receipts_count := l_cash_receipts_count + 1;
404: l_cash_receipt_ids(l_cash_receipts_count).CASH_RECEIPT_ID := l_cash_receipt_id;

Line 401: logMessage(FND_LOG.LEVEL_UNEXPECTED, G_PKG_NAME, l_api_name || ' - cr_id amount: ' || l_amount_applied);

397:
398: if not l_bool_match then
399: logMessage(FND_LOG.LEVEL_UNEXPECTED, G_PKG_NAME, l_api_name || ' - receipts count is: ' || l_cash_receipts_count);
400: logMessage(FND_LOG.LEVEL_UNEXPECTED, G_PKG_NAME, l_api_name || ' - adding applied cr_id: ' || l_cash_receipt_id);
401: logMessage(FND_LOG.LEVEL_UNEXPECTED, G_PKG_NAME, l_api_name || ' - cr_id amount: ' || l_amount_applied);
402: logMessage(FND_LOG.LEVEL_UNEXPECTED, G_PKG_NAME, l_api_name || ' - cr_id currency: ' || l_loan_currency);
403: l_cash_receipts_count := l_cash_receipts_count + 1;
404: l_cash_receipt_ids(l_cash_receipts_count).CASH_RECEIPT_ID := l_cash_receipt_id;
405: l_cash_receipt_ids(l_cash_receipts_count).RECEIPT_AMOUNT := l_amount_applied;

Line 402: logMessage(FND_LOG.LEVEL_UNEXPECTED, G_PKG_NAME, l_api_name || ' - cr_id currency: ' || l_loan_currency);

398: if not l_bool_match then
399: logMessage(FND_LOG.LEVEL_UNEXPECTED, G_PKG_NAME, l_api_name || ' - receipts count is: ' || l_cash_receipts_count);
400: logMessage(FND_LOG.LEVEL_UNEXPECTED, G_PKG_NAME, l_api_name || ' - adding applied cr_id: ' || l_cash_receipt_id);
401: logMessage(FND_LOG.LEVEL_UNEXPECTED, G_PKG_NAME, l_api_name || ' - cr_id amount: ' || l_amount_applied);
402: logMessage(FND_LOG.LEVEL_UNEXPECTED, G_PKG_NAME, l_api_name || ' - cr_id currency: ' || l_loan_currency);
403: l_cash_receipts_count := l_cash_receipts_count + 1;
404: l_cash_receipt_ids(l_cash_receipts_count).CASH_RECEIPT_ID := l_cash_receipt_id;
405: l_cash_receipt_ids(l_cash_receipts_count).RECEIPT_AMOUNT := l_amount_applied;
406: l_cash_receipt_ids(l_cash_receipts_count).RECEIPT_CURRENCY := l_loan_currency;

Line 414: logMessage(FND_LOG.LEVEL_UNEXPECTED, G_PKG_NAME, l_api_name || ' - added cash rec id ' || l_cash_receipt_id);

410: l_cash_receipt_ids(l_cash_receipts_count).EXCHANGE_DATE := l_rec_exchange_date;
411: l_cash_receipt_ids(l_cash_receipts_count).EXCHANGE_RATE_TYPE := l_rec_exchange_rate_type;
412: end if;
413: end if;
414: logMessage(FND_LOG.LEVEL_UNEXPECTED, G_PKG_NAME, l_api_name || ' - added cash rec id ' || l_cash_receipt_id);
415: logMessage(FND_LOG.LEVEL_UNEXPECTED, G_PKG_NAME, l_api_name || ' - added cash amount ' || l_amount_applied || ' ' || l_currency_code);
416:
417: end loop; --end unapplication loop
418:

Line 415: logMessage(FND_LOG.LEVEL_UNEXPECTED, G_PKG_NAME, l_api_name || ' - added cash amount ' || l_amount_applied || ' ' || l_currency_code);

411: l_cash_receipt_ids(l_cash_receipts_count).EXCHANGE_RATE_TYPE := l_rec_exchange_rate_type;
412: end if;
413: end if;
414: logMessage(FND_LOG.LEVEL_UNEXPECTED, G_PKG_NAME, l_api_name || ' - added cash rec id ' || l_cash_receipt_id);
415: logMessage(FND_LOG.LEVEL_UNEXPECTED, G_PKG_NAME, l_api_name || ' - added cash amount ' || l_amount_applied || ' ' || l_currency_code);
416:
417: end loop; --end unapplication loop
418:
419: -- 3. credit document

Line 420: logMessage(FND_LOG.LEVEL_UNEXPECTED, G_PKG_NAME, l_api_name || ' - crediting final interest document');

416:
417: end loop; --end unapplication loop
418:
419: -- 3. credit document
420: logMessage(FND_LOG.LEVEL_UNEXPECTED, G_PKG_NAME, l_api_name || ' - crediting final interest document');
421: /*=======================================================================*/
422: LNS_BILLING_BATCH_PUB.CREDIT_AMORTIZATION_PARTIAL(P_API_VERSION => 1.0
423: ,P_INIT_MSG_LIST => p_init_msg_list
424: ,P_COMMIT => FND_API.G_FALSE

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

431:
432: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
433: FND_MESSAGE.SET_NAME('LNS', 'LNS_CREDIT_MEMO_ERROR');
434: FND_MSG_PUB.Add;
435: LogMessage(FND_LOG.LEVEL_UNEXPECTED, G_PKG_NAME, FND_MSG_PUB.Get(p_encoded => 'F'));
436: RAISE FND_API.G_EXC_ERROR;
437: end if;
438:
439: -- 4. create new interest and principal document for difference

Line 440: logMessage(FND_LOG.LEVEL_UNEXPECTED, G_PKG_NAME, l_api_name || ' - RECALCULATING INTEREST');

436: RAISE FND_API.G_EXC_ERROR;
437: end if;
438:
439: -- 4. create new interest and principal document for difference
440: logMessage(FND_LOG.LEVEL_UNEXPECTED, G_PKG_NAME, l_api_name || ' - RECALCULATING INTEREST');
441: if b_recalculate_interest then
442: logMessage(FND_LOG.LEVEL_UNEXPECTED, G_PKG_NAME, l_api_name || ' - l_interest_trx_Id: ' || l_interest_trx_Id);
443: logMessage(FND_LOG.LEVEL_UNEXPECTED, G_PKG_NAME, l_api_name || ' - l_customer_trx_id: ' || l_customer_trx_id);
444:

Line 442: logMessage(FND_LOG.LEVEL_UNEXPECTED, G_PKG_NAME, l_api_name || ' - l_interest_trx_Id: ' || l_interest_trx_Id);

438:
439: -- 4. create new interest and principal document for difference
440: logMessage(FND_LOG.LEVEL_UNEXPECTED, G_PKG_NAME, l_api_name || ' - RECALCULATING INTEREST');
441: if b_recalculate_interest then
442: logMessage(FND_LOG.LEVEL_UNEXPECTED, G_PKG_NAME, l_api_name || ' - l_interest_trx_Id: ' || l_interest_trx_Id);
443: logMessage(FND_LOG.LEVEL_UNEXPECTED, G_PKG_NAME, l_api_name || ' - l_customer_trx_id: ' || l_customer_trx_id);
444:
445: if l_interest_trx_id = l_customer_trx_id then
446: logMessage(FND_LOG.LEVEL_UNEXPECTED, G_PKG_NAME, l_api_name || ' - RECALCULATED INTEREST DUE: ' || l_new_interest);

Line 443: logMessage(FND_LOG.LEVEL_UNEXPECTED, G_PKG_NAME, l_api_name || ' - l_customer_trx_id: ' || l_customer_trx_id);

439: -- 4. create new interest and principal document for difference
440: logMessage(FND_LOG.LEVEL_UNEXPECTED, G_PKG_NAME, l_api_name || ' - RECALCULATING INTEREST');
441: if b_recalculate_interest then
442: logMessage(FND_LOG.LEVEL_UNEXPECTED, G_PKG_NAME, l_api_name || ' - l_interest_trx_Id: ' || l_interest_trx_Id);
443: logMessage(FND_LOG.LEVEL_UNEXPECTED, G_PKG_NAME, l_api_name || ' - l_customer_trx_id: ' || l_customer_trx_id);
444:
445: if l_interest_trx_id = l_customer_trx_id then
446: logMessage(FND_LOG.LEVEL_UNEXPECTED, G_PKG_NAME, l_api_name || ' - RECALCULATED INTEREST DUE: ' || l_new_interest);
447:

Line 446: logMessage(FND_LOG.LEVEL_UNEXPECTED, G_PKG_NAME, l_api_name || ' - RECALCULATED INTEREST DUE: ' || l_new_interest);

442: logMessage(FND_LOG.LEVEL_UNEXPECTED, G_PKG_NAME, l_api_name || ' - l_interest_trx_Id: ' || l_interest_trx_Id);
443: logMessage(FND_LOG.LEVEL_UNEXPECTED, G_PKG_NAME, l_api_name || ' - l_customer_trx_id: ' || l_customer_trx_id);
444:
445: if l_interest_trx_id = l_customer_trx_id then
446: logMessage(FND_LOG.LEVEL_UNEXPECTED, G_PKG_NAME, l_api_name || ' - RECALCULATED INTEREST DUE: ' || l_new_interest);
447:
448: -- over interest charge had previous applications
449: select amount_due_original + l_payoff_tbl2(i).unbilled_amount
450: into l_new_interest

Line 469: logMessage(FND_LOG.LEVEL_UNEXPECTED, G_PKG_NAME, l_api_name || ' - RECALCULATED INTEREST DUE: ' || l_new_interest);

465: end if;
466: b_recalculate_interest := false;
467: end if;
468:
469: logMessage(FND_LOG.LEVEL_UNEXPECTED, G_PKG_NAME, l_api_name || ' - RECALCULATED INTEREST DUE: ' || l_new_interest);
470:
471: -- we will only create a new interest document IF there is an interest amount due
472: if l_new_interest > 0 then
473: s := s + 1;

Line 484: logMessage(FND_LOG.LEVEL_UNEXPECTED, G_PKG_NAME, l_api_name || ' - billing lines' || l_bill_lines_tbl.count);

480: end if;
481:
482: end loop;
483:
484: logMessage(FND_LOG.LEVEL_UNEXPECTED, G_PKG_NAME, l_api_name || ' - billing lines' || l_bill_lines_tbl.count);
485: if l_bill_lines_tbl.count >= 1 then
486:
487: -- we have at least 1 invoice to create with amount > 0
488: -- must pass false for commit here or else payoff documents will exist in receivables

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

498:
499: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
500: FND_MESSAGE.SET_NAME('LNS', 'LNS_INVOICE_CREATION_ERROR');
501: FND_MSG_PUB.Add;
502: logMessage(FND_LOG.LEVEL_UNEXPECTED, G_PKG_NAME, FND_MSG_PUB.Get(p_encoded => 'F'));
503: RAISE FND_API.G_EXC_ERROR;
504: END IF;
505:
506: end if;

Line 510: logMessage(FND_LOG.LEVEL_UNEXPECTED, G_PKG_NAME, l_api_name || ' - getting loan invoices');

506: end if;
507:
508: --3. getLoanInvoices (should return newly created documents)
509: -- pass payoff_date = null to avoid recalculating payoff amounts
510: logMessage(FND_LOG.LEVEL_UNEXPECTED, G_PKG_NAME, l_api_name || ' - getting loan invoices');
511: lns_payoff_pub.getLoanInvoices(p_api_version => 1
512: ,p_init_msg_list => p_init_msg_list
513: ,p_loan_ID => p_loan_id
514: ,p_payoff_date => null

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

519:
520: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
521: FND_MESSAGE.SET_NAME('LNS', 'LNS_INVOICE_SUMMARY_ERROR');
522: FND_MSG_PUB.Add;
523: LogMessage(FND_LOG.LEVEL_UNEXPECTED, G_PKG_NAME, FND_MSG_PUB.Get(p_encoded => 'F'));
524: RAISE FND_API.G_EXC_ERROR;
525: END IF;
526:
527: logMessage(FND_LOG.LEVEL_UNEXPECTED, G_PKG_NAME, l_api_name || ' - # of unpaid invoices to process = ' || l_invoices_tbl.count);

Line 527: logMessage(FND_LOG.LEVEL_UNEXPECTED, G_PKG_NAME, l_api_name || ' - # of unpaid invoices to process = ' || l_invoices_tbl.count);

523: LogMessage(FND_LOG.LEVEL_UNEXPECTED, G_PKG_NAME, FND_MSG_PUB.Get(p_encoded => 'F'));
524: RAISE FND_API.G_EXC_ERROR;
525: END IF;
526:
527: logMessage(FND_LOG.LEVEL_UNEXPECTED, G_PKG_NAME, l_api_name || ' - # of unpaid invoices to process = ' || l_invoices_tbl.count);
528:
529: --4. check if sum of receipts covers the remaining loan amount
530: -- if we need to do multi-currency, the receipt amounts should be
531: -- converted to loan_currency before making comparison

Line 541: logMessage(FND_LOG.LEVEL_UNEXPECTED, G_PKG_NAME, l_api_name || ' - receipt currency: ' || l_cash_receipt_ids(j).receipt_currency);

537:
538: for j in 1..l_cash_receipt_ids.count
539: loop
540:
541: logMessage(FND_LOG.LEVEL_UNEXPECTED, G_PKG_NAME, l_api_name || ' - receipt currency: ' || l_cash_receipt_ids(j).receipt_currency);
542: logMessage(FND_LOG.LEVEL_UNEXPECTED, G_PKG_NAME, l_api_name || ' - receipt amount: ' || l_cash_receipt_ids(j).receipt_amount);
543: logMessage(FND_LOG.LEVEL_UNEXPECTED, G_PKG_NAME, l_api_name || ' - xchg rate: ' || l_cash_receipt_ids(j).exchange_rate);
544:
545: open c_receipt_number(l_cash_receipt_ids(j).cash_receipt_id);

Line 542: logMessage(FND_LOG.LEVEL_UNEXPECTED, G_PKG_NAME, l_api_name || ' - receipt amount: ' || l_cash_receipt_ids(j).receipt_amount);

538: for j in 1..l_cash_receipt_ids.count
539: loop
540:
541: logMessage(FND_LOG.LEVEL_UNEXPECTED, G_PKG_NAME, l_api_name || ' - receipt currency: ' || l_cash_receipt_ids(j).receipt_currency);
542: logMessage(FND_LOG.LEVEL_UNEXPECTED, G_PKG_NAME, l_api_name || ' - receipt amount: ' || l_cash_receipt_ids(j).receipt_amount);
543: logMessage(FND_LOG.LEVEL_UNEXPECTED, G_PKG_NAME, l_api_name || ' - xchg rate: ' || l_cash_receipt_ids(j).exchange_rate);
544:
545: open c_receipt_number(l_cash_receipt_ids(j).cash_receipt_id);
546: fetch c_receipt_number into l_receipt_number, l_receipt_currency_orig;

Line 543: logMessage(FND_LOG.LEVEL_UNEXPECTED, G_PKG_NAME, l_api_name || ' - xchg rate: ' || l_cash_receipt_ids(j).exchange_rate);

539: loop
540:
541: logMessage(FND_LOG.LEVEL_UNEXPECTED, G_PKG_NAME, l_api_name || ' - receipt currency: ' || l_cash_receipt_ids(j).receipt_currency);
542: logMessage(FND_LOG.LEVEL_UNEXPECTED, G_PKG_NAME, l_api_name || ' - receipt amount: ' || l_cash_receipt_ids(j).receipt_amount);
543: logMessage(FND_LOG.LEVEL_UNEXPECTED, G_PKG_NAME, l_api_name || ' - xchg rate: ' || l_cash_receipt_ids(j).exchange_rate);
544:
545: open c_receipt_number(l_cash_receipt_ids(j).cash_receipt_id);
546: fetch c_receipt_number into l_receipt_number, l_receipt_currency_orig;
547: close c_receipt_number ;

Line 555: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - cash receipts to process: ' || l_cash_receipt_ids.count);

551: l_total_receipts_amount := l_total_receipts_amount + l_cash_receipt_ids(j).receipt_amount;
552:
553: end loop;
554:
555: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - cash receipts to process: ' || l_cash_receipt_ids.count);
556: logMessage(FND_LOG.LEVEL_UNEXPECTED, G_PKG_NAME, l_api_name || ' - total receipts: ' || l_total_receipts_amount);
557: logMessage(FND_LOG.LEVEL_UNEXPECTED, G_PKG_NAME, l_api_name || ' - total payoff amount: ' || l_total_payoff_amount);
558:
559: if l_total_receipts_amount < l_total_payoff_amount then

Line 556: logMessage(FND_LOG.LEVEL_UNEXPECTED, G_PKG_NAME, l_api_name || ' - total receipts: ' || l_total_receipts_amount);

552:
553: end loop;
554:
555: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - cash receipts to process: ' || l_cash_receipt_ids.count);
556: logMessage(FND_LOG.LEVEL_UNEXPECTED, G_PKG_NAME, l_api_name || ' - total receipts: ' || l_total_receipts_amount);
557: logMessage(FND_LOG.LEVEL_UNEXPECTED, G_PKG_NAME, l_api_name || ' - total payoff amount: ' || l_total_payoff_amount);
558:
559: if l_total_receipts_amount < l_total_payoff_amount then
560: FND_MESSAGE.SET_NAME('LNS', 'LNS_PAYOFF_SHORT_CASH');

Line 557: logMessage(FND_LOG.LEVEL_UNEXPECTED, G_PKG_NAME, l_api_name || ' - total payoff amount: ' || l_total_payoff_amount);

553: end loop;
554:
555: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - cash receipts to process: ' || l_cash_receipt_ids.count);
556: logMessage(FND_LOG.LEVEL_UNEXPECTED, G_PKG_NAME, l_api_name || ' - total receipts: ' || l_total_receipts_amount);
557: logMessage(FND_LOG.LEVEL_UNEXPECTED, G_PKG_NAME, l_api_name || ' - total payoff amount: ' || l_total_payoff_amount);
558:
559: if l_total_receipts_amount < l_total_payoff_amount then
560: FND_MESSAGE.SET_NAME('LNS', 'LNS_PAYOFF_SHORT_CASH');
561: FND_MSG_PUB.Add;

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

558:
559: if l_total_receipts_amount < l_total_payoff_amount then
560: FND_MESSAGE.SET_NAME('LNS', 'LNS_PAYOFF_SHORT_CASH');
561: FND_MSG_PUB.Add;
562: LogMessage(FND_LOG.LEVEL_UNEXPECTED, G_PKG_NAME, FND_MSG_PUB.Get(p_encoded => 'F'));
563: RAISE FND_API.G_EXC_ERROR;
564: end if;
565:
566: --5. apply cash

Line 567: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - step 5');

563: RAISE FND_API.G_EXC_ERROR;
564: end if;
565:
566: --5. apply cash
567: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - step 5');
568: for k in 1..l_invoices_tbl.count
569: loop
570: -- find the first cash receipt that has not been applied previously to the invoice
571: -- if the amount of the receipt is > invoice then move on

Line 575: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' --------- next invoice ----------');

571: -- if the amount of the receipt is > invoice then move on
572: -- else find the next receipt that has not been applied previously to the invoice
573: j := 1;
574: l_invoice_amount_remaining := l_invoices_tbl(k).REMAINING_AMOUNT;
575: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' --------- next invoice ----------');
576: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - payment_schedule_id: ' || l_invoices_tbl(k).payment_schedule_id );
577: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - invoice remaining amount: ' || l_invoices_tbl(k).REMAINING_AMOUNT);
578:
579: --l_receipt_amount_remaining := l_cash_receipt_ids(j).RECEIPT_AMOUNT;

Line 576: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - payment_schedule_id: ' || l_invoices_tbl(k).payment_schedule_id );

572: -- else find the next receipt that has not been applied previously to the invoice
573: j := 1;
574: l_invoice_amount_remaining := l_invoices_tbl(k).REMAINING_AMOUNT;
575: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' --------- next invoice ----------');
576: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - payment_schedule_id: ' || l_invoices_tbl(k).payment_schedule_id );
577: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - invoice remaining amount: ' || l_invoices_tbl(k).REMAINING_AMOUNT);
578:
579: --l_receipt_amount_remaining := l_cash_receipt_ids(j).RECEIPT_AMOUNT;
580: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - receipt amount: # ' || j || ' =' ||l_cash_receipt_ids(j).RECEIPT_AMOUNT);

Line 577: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - invoice remaining amount: ' || l_invoices_tbl(k).REMAINING_AMOUNT);

573: j := 1;
574: l_invoice_amount_remaining := l_invoices_tbl(k).REMAINING_AMOUNT;
575: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' --------- next invoice ----------');
576: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - payment_schedule_id: ' || l_invoices_tbl(k).payment_schedule_id );
577: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - invoice remaining amount: ' || l_invoices_tbl(k).REMAINING_AMOUNT);
578:
579: --l_receipt_amount_remaining := l_cash_receipt_ids(j).RECEIPT_AMOUNT;
580: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - receipt amount: # ' || j || ' =' ||l_cash_receipt_ids(j).RECEIPT_AMOUNT);
581:

Line 580: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - receipt amount: # ' || j || ' =' ||l_cash_receipt_ids(j).RECEIPT_AMOUNT);

576: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - payment_schedule_id: ' || l_invoices_tbl(k).payment_schedule_id );
577: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - invoice remaining amount: ' || l_invoices_tbl(k).REMAINING_AMOUNT);
578:
579: --l_receipt_amount_remaining := l_cash_receipt_ids(j).RECEIPT_AMOUNT;
580: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - receipt amount: # ' || j || ' =' ||l_cash_receipt_ids(j).RECEIPT_AMOUNT);
581:
582: while l_invoices_tbl(k).REMAINING_AMOUNT > 0
583: loop
584: -- skip the receipts already exhausted

Line 590: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - receipt amount remaining: ' || j || '# =' ||l_receipt_amount_remaining);

586: exit when l_cash_receipt_ids(j).RECEIPT_AMOUNT > 0;
587: j := j + 1;
588: end loop;
589: l_receipt_amount_remaining := l_cash_receipt_ids(j).RECEIPT_AMOUNT;
590: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - receipt amount remaining: ' || j || '# =' ||l_receipt_amount_remaining);
591:
592: Begin
593: select 'X'
594: into l_found

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

610: -- we have gone thru all the cash receipts and there is not enough
611: -- open receipts in the list to cover this invoice
612: FND_MESSAGE.SET_NAME('LNS', 'LNS_ALL_RECEIPTS_EXHAUSTED');
613: FND_MSG_PUB.Add;
614: LogMessage(FND_LOG.LEVEL_UNEXPECTED, G_PKG_NAME, FND_MSG_PUB.Get(p_encoded => 'F'));
615: RAISE FND_API.G_EXC_ERROR;
616: end if;
617:
618: else

Line 631: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - receipt currency orig: ' || l_cash_receipt_ids(j).original_currency || ' receipt currency passed: ' || l_cash_receipt_ids(j).receipt_currency);

627: if l_cash_receipt_ids(j).original_currency = l_cash_receipt_ids(j).receipt_currency then
628: l_trans_to_receipt_rate := null;
629: l_receipt_amount_from := null;
630: else
631: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - receipt currency orig: ' || l_cash_receipt_ids(j).original_currency || ' receipt currency passed: ' || l_cash_receipt_ids(j).receipt_currency);
632: if l_cash_receipt_ids(j).exchange_rate is not null then
633: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - using receipt exchange rate ' || l_cash_receipt_ids(j).exchange_rate);
634: l_trans_to_receipt_rate := l_cash_receipt_ids(j).exchange_rate;
635: else

Line 633: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - using receipt exchange rate ' || l_cash_receipt_ids(j).exchange_rate);

629: l_receipt_amount_from := null;
630: else
631: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - receipt currency orig: ' || l_cash_receipt_ids(j).original_currency || ' receipt currency passed: ' || l_cash_receipt_ids(j).receipt_currency);
632: if l_cash_receipt_ids(j).exchange_rate is not null then
633: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - using receipt exchange rate ' || l_cash_receipt_ids(j).exchange_rate);
634: l_trans_to_receipt_rate := l_cash_receipt_ids(j).exchange_rate;
635: else
636: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - using loan exchange rate ' || l_loan_exchange_rate);
637: l_trans_to_receipt_rate := l_loan_exchange_rate;

Line 636: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - using loan exchange rate ' || l_loan_exchange_rate);

632: if l_cash_receipt_ids(j).exchange_rate is not null then
633: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - using receipt exchange rate ' || l_cash_receipt_ids(j).exchange_rate);
634: l_trans_to_receipt_rate := l_cash_receipt_ids(j).exchange_rate;
635: else
636: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - using loan exchange rate ' || l_loan_exchange_rate);
637: l_trans_to_receipt_rate := l_loan_exchange_rate;
638: end if;
639: l_receipt_amount_from := l_amount_to_apply * l_trans_to_receipt_rate;
640: end if;

Line 642: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - applying cash : ' || l_amount_to_apply);

638: end if;
639: l_receipt_amount_from := l_amount_to_apply * l_trans_to_receipt_rate;
640: end if;
641:
642: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - applying cash : ' || l_amount_to_apply);
643: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - applying cash from: ' || l_receipt_amount_from);
644: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - exchange rate: ' || l_trans_to_receipt_rate);
645:
646: lns_payoff_pub.apply_receipt(p_cash_receipt_id => l_cash_receipt_ids(j).CASH_RECEIPT_ID

Line 643: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - applying cash from: ' || l_receipt_amount_from);

639: l_receipt_amount_from := l_amount_to_apply * l_trans_to_receipt_rate;
640: end if;
641:
642: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - applying cash : ' || l_amount_to_apply);
643: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - applying cash from: ' || l_receipt_amount_from);
644: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - exchange rate: ' || l_trans_to_receipt_rate);
645:
646: lns_payoff_pub.apply_receipt(p_cash_receipt_id => l_cash_receipt_ids(j).CASH_RECEIPT_ID
647: ,p_payment_schedule_id => l_invoices_tbl(k).payment_schedule_id

Line 644: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - exchange rate: ' || l_trans_to_receipt_rate);

640: end if;
641:
642: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - applying cash : ' || l_amount_to_apply);
643: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - applying cash from: ' || l_receipt_amount_from);
644: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - exchange rate: ' || l_trans_to_receipt_rate);
645:
646: lns_payoff_pub.apply_receipt(p_cash_receipt_id => l_cash_receipt_ids(j).CASH_RECEIPT_ID
647: ,p_payment_schedule_id => l_invoices_tbl(k).payment_schedule_id
648: ,p_apply_amount => l_amount_to_apply -- in loan currency

Line 656: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - apply cash status: ' || l_return_status);

652: ,x_return_status => l_return_status
653: ,x_msg_count => l_msg_count
654: ,x_msg_data => l_msg_data);
655:
656: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - apply cash status: ' || l_return_status);
657: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
658: FND_MESSAGE.SET_NAME('LNS', 'LNS_APPLY_CASH_ERROR');
659: FND_MESSAGE.SET_TOKEN('PARAMETER', 'RECEIPT_NUMBER');
660: FND_MESSAGE.SET_TOKEN('VALUE', l_cash_receipt_ids(j).receipt_number);

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

658: FND_MESSAGE.SET_NAME('LNS', 'LNS_APPLY_CASH_ERROR');
659: FND_MESSAGE.SET_TOKEN('PARAMETER', 'RECEIPT_NUMBER');
660: FND_MESSAGE.SET_TOKEN('VALUE', l_cash_receipt_ids(j).receipt_number);
661: FND_MSG_PUB.Add;
662: LogMessage(FND_LOG.LEVEL_UNEXPECTED, G_PKG_NAME, FND_MSG_PUB.Get(p_encoded => 'F'));
663: RAISE FND_API.G_EXC_ERROR;
664: END IF;
665:
666: l_invoice_amount_remaining := l_invoice_amount_remaining - l_amount_to_apply;

Line 673: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - l_invoice_amount_remaining : ' || l_invoice_amount_remaining);

669: l_cash_receipt_ids(j).RECEIPT_AMOUNT := l_cash_receipt_ids(j).RECEIPT_AMOUNT - l_amount_to_apply;
670: l_amount_to_apply := 0;
671:
672: l_found := null;
673: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - l_invoice_amount_remaining : ' || l_invoice_amount_remaining);
674: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - l_receipt_amount_remaining : ' || l_receipt_amount_remaining);
675: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - l_invoices_tbl(k).REMAINING_AMOUNT : ' || l_invoices_tbl(k).REMAINING_AMOUNT);
676: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - l_cash_receipt_ids(j).RECEIPT_AMOUNT : ' || l_cash_receipt_ids(j).RECEIPT_AMOUNT);
677: end if;

Line 674: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - l_receipt_amount_remaining : ' || l_receipt_amount_remaining);

670: l_amount_to_apply := 0;
671:
672: l_found := null;
673: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - l_invoice_amount_remaining : ' || l_invoice_amount_remaining);
674: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - l_receipt_amount_remaining : ' || l_receipt_amount_remaining);
675: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - l_invoices_tbl(k).REMAINING_AMOUNT : ' || l_invoices_tbl(k).REMAINING_AMOUNT);
676: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - l_cash_receipt_ids(j).RECEIPT_AMOUNT : ' || l_cash_receipt_ids(j).RECEIPT_AMOUNT);
677: end if;
678: j := j + 1;

Line 675: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - l_invoices_tbl(k).REMAINING_AMOUNT : ' || l_invoices_tbl(k).REMAINING_AMOUNT);

671:
672: l_found := null;
673: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - l_invoice_amount_remaining : ' || l_invoice_amount_remaining);
674: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - l_receipt_amount_remaining : ' || l_receipt_amount_remaining);
675: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - l_invoices_tbl(k).REMAINING_AMOUNT : ' || l_invoices_tbl(k).REMAINING_AMOUNT);
676: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - l_cash_receipt_ids(j).RECEIPT_AMOUNT : ' || l_cash_receipt_ids(j).RECEIPT_AMOUNT);
677: end if;
678: j := j + 1;
679:

Line 676: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - l_cash_receipt_ids(j).RECEIPT_AMOUNT : ' || l_cash_receipt_ids(j).RECEIPT_AMOUNT);

672: l_found := null;
673: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - l_invoice_amount_remaining : ' || l_invoice_amount_remaining);
674: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - l_receipt_amount_remaining : ' || l_receipt_amount_remaining);
675: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - l_invoices_tbl(k).REMAINING_AMOUNT : ' || l_invoices_tbl(k).REMAINING_AMOUNT);
676: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - l_cash_receipt_ids(j).RECEIPT_AMOUNT : ' || l_cash_receipt_ids(j).RECEIPT_AMOUNT);
677: end if;
678: j := j + 1;
679:
680: end loop;

Line 685: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - calling LNS_BILLING_BATCH_PUB.processPaidLoans');

681:
682: end loop;
683: -- end of step 5
684:
685: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - calling LNS_BILLING_BATCH_PUB.processPaidLoans');
686: LNS_BILLING_BATCH_PUB.PROCESS_PAID_LOANS(P_API_VERSION => 1.0
687: ,P_INIT_MSG_LIST => FND_API.G_FALSE
688: ,P_COMMIT => FND_API.G_FALSE
689: ,P_VALIDATION_LEVEL => 100

Line 695: LogMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, l_api_name || ' - LNS_BILLING_BATCH_PUB.processPaidLoans return status: ' || l_return_status);

691: ,P_PAYOFF_DATE => p_payoff_date
692: ,x_return_status => l_return_status
693: ,x_msg_count => l_msg_count
694: ,x_msg_data => l_msg_data);
695: LogMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, l_api_name || ' - LNS_BILLING_BATCH_PUB.processPaidLoans return status: ' || l_return_status);
696: IF l_return_status = FND_API.G_RET_STS_SUCCESS THEN
697: COMMIT WORK;
698: else
699: RAISE FND_API.G_EXC_ERROR;

Line 706: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, l_api_name || ' - Getting final balance');

702:
703: -- one last check on the final balance before we mark the loan as
704: -- PAID OFF
705: /*
706: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, l_api_name || ' - Getting final balance');
707: begin
708: -- changes as per scherkas 11-16-2005
709: select total_principal_balance into l_final_balance
710: from LNS_PAYMENTS_SUMMARY_V

Line 716: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, l_api_name || ' - final balance: ' || l_final_balance);

712: Exception
713: when no_data_found then
714: null;
715: end;
716: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, l_api_name || ' - final balance: ' || l_final_balance);
717:
718: if l_final_balance = 0 then
719: open c_loans_obj_vers(p_loan_id);
720: fetch c_loans_obj_vers into l_object_version;

Line 724: --LogMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, l_api_name || ' - get_object_version' || l_object_version);

720: fetch c_loans_obj_vers into l_object_version;
721: close c_loans_obj_vers;
722:
723: --6. if success then update loan_stats = 'PAIDOFF'
724: --LogMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, l_api_name || ' - get_object_version' || l_object_version);
725: l_loan_header_rec.loan_id := p_loan_id;
726: l_loan_header_rec.LOAN_STATUS := 'PAIDOFF';
727: l_loan_header_rec.SECONDARY_STATUS := null;
728:

Line 730: LogMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, l_api_name || ' - Updating loan header info w following values:');

726: l_loan_header_rec.LOAN_STATUS := 'PAIDOFF';
727: l_loan_header_rec.SECONDARY_STATUS := null;
728:
729:
730: LogMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, l_api_name || ' - Updating loan header info w following values:');
731: LogMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, l_api_name || ' - LOAN_STATUS: ' || l_loan_header_rec.LOAN_STATUS);
732: LogMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, l_api_name || ' - get_object_version' || l_object_version);
733: --l_loan_header_rec.object_version := l_object_version;
734:

Line 731: LogMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, l_api_name || ' - LOAN_STATUS: ' || l_loan_header_rec.LOAN_STATUS);

727: l_loan_header_rec.SECONDARY_STATUS := null;
728:
729:
730: LogMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, l_api_name || ' - Updating loan header info w following values:');
731: LogMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, l_api_name || ' - LOAN_STATUS: ' || l_loan_header_rec.LOAN_STATUS);
732: LogMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, l_api_name || ' - get_object_version' || l_object_version);
733: --l_loan_header_rec.object_version := l_object_version;
734:
735: LNS_LOAN_HEADER_PUB.UPDATE_LOAN(P_OBJECT_VERSION_NUMBER => l_object_version,

Line 732: LogMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, l_api_name || ' - get_object_version' || l_object_version);

728:
729:
730: LogMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, l_api_name || ' - Updating loan header info w following values:');
731: LogMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, l_api_name || ' - LOAN_STATUS: ' || l_loan_header_rec.LOAN_STATUS);
732: LogMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, l_api_name || ' - get_object_version' || l_object_version);
733: --l_loan_header_rec.object_version := l_object_version;
734:
735: LNS_LOAN_HEADER_PUB.UPDATE_LOAN(P_OBJECT_VERSION_NUMBER => l_object_version,
736: P_LOAN_HEADER_REC => l_loan_header_rec,

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

739: X_MSG_COUNT => l_msg_count,
740: X_MSG_DATA => l_msg_data);
741: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
742: FND_MESSAGE.SET_NAME('LNS', 'LNS_UPDATE_HEADER_ERROR');
743: LogMessage(FND_LOG.LEVEL_UNEXPECTED, G_PKG_NAME, FND_MSG_PUB.Get(p_encoded => 'F'));
744: RAISE FND_API.G_EXC_ERROR;
745:
746: update lns_fee_schedules
747: set billed_flag = 'Y'

Line 755: LogMessage(FND_LOG.LEVEL_UNEXPECTED, G_PKG_NAME, l_api_name || ' - updating fee assignments');

751: and object_version_number = object_version_number + 1;
752:
753: Else
754: --FND_MESSAGE.SET_NAME('LNS', 'LNS_PAYOFF_SUCCESS');
755: LogMessage(FND_LOG.LEVEL_UNEXPECTED, G_PKG_NAME, l_api_name || ' - updating fee assignments');
756: -- end date the active fees on the loan as FDD section 4.1.3
757: update lns_fee_assignments
758: set end_date_active = p_payoff_date
759: where loan_id = p_loan_id

Line 766: LogMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, l_api_name || ' - header update status: ' || l_return_status);

762: COMMIT WORK;
763:
764: END IF;
765:
766: LogMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, l_api_name || ' - header update status: ' || l_return_status);
767:
768: else
769: FND_MESSAGE.SET_NAME('LNS', 'LNS_FINAL_BALANCE_ERROR');
770: FND_MSG_PUB.Add;

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

767:
768: else
769: FND_MESSAGE.SET_NAME('LNS', 'LNS_FINAL_BALANCE_ERROR');
770: FND_MSG_PUB.Add;
771: LogMessage(FND_LOG.LEVEL_UNEXPECTED, G_PKG_NAME, FND_MSG_PUB.Get(p_encoded => 'F'));
772: RAISE FND_API.G_EXC_ERROR;
773: end if;
774: */
775: -- ---------------------------------------------------------------------

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

777: --
778:
779: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
780:
781: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - END');
782:
783: EXCEPTION
784: WHEN FND_API.G_EXC_ERROR THEN
785: ROLLBACK TO processPayoff;

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

786: x_return_status := FND_API.G_RET_STS_ERROR;
787: x_msg_count := l_msg_count;
788: x_msg_data := l_msg_data;
789: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
790: logMessage(FND_LOG.LEVEL_ERROR, G_PKG_NAME, sqlerrm);
791:
792: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
793: ROLLBACK TO processPayoff;
794: x_return_status := FND_API.G_RET_STS_ERROR;

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

794: x_return_status := FND_API.G_RET_STS_ERROR;
795: x_msg_count := l_msg_count;
796: x_msg_data := l_msg_data;
797: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
798: logMessage(FND_LOG.LEVEL_ERROR, G_PKG_NAME, sqlerrm);
799:
800: WHEN OTHERS THEN
801: ROLLBACK TO processPayoff;
802: x_return_status := FND_API.G_RET_STS_ERROR;

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

802: x_return_status := FND_API.G_RET_STS_ERROR;
803: x_msg_count := l_msg_count;
804: x_msg_data := l_msg_data;
805: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
806: logMessage(FND_LOG.LEVEL_ERROR, G_PKG_NAME, sqlerrm);
807:
808: end processPayoff;
809:
810:

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

924: begin
925:
926: l_api_name := 'getLoanInvoices';
927: l_api_version_number := 1;
928: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - BEGIN');
929:
930: -- Standard Start of API savepoint
931: SAVEPOINT getLoanInvoices;
932:

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

964: ,l_purpose;
965:
966: EXIT WHEN c_loanInvoices%NOTFOUND;
967:
968: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - installment #: ' || l_installment);
969: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - l_cust_trx_id: ' || l_cust_trx_id);
970: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - l_remaining_amt: ' || l_remaining_amt);
971: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - l_due_date: ' || l_due_date);
972: l_invoices_tbl(i).CUST_TRX_ID := l_cust_trx_id;

Line 969: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - l_cust_trx_id: ' || l_cust_trx_id);

965:
966: EXIT WHEN c_loanInvoices%NOTFOUND;
967:
968: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - installment #: ' || l_installment);
969: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - l_cust_trx_id: ' || l_cust_trx_id);
970: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - l_remaining_amt: ' || l_remaining_amt);
971: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - l_due_date: ' || l_due_date);
972: l_invoices_tbl(i).CUST_TRX_ID := l_cust_trx_id;
973: l_invoices_tbl(i).PAYMENT_SCHEDULE_ID:= l_payment_schedule_id;

Line 970: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - l_remaining_amt: ' || l_remaining_amt);

966: EXIT WHEN c_loanInvoices%NOTFOUND;
967:
968: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - installment #: ' || l_installment);
969: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - l_cust_trx_id: ' || l_cust_trx_id);
970: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - l_remaining_amt: ' || l_remaining_amt);
971: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - l_due_date: ' || l_due_date);
972: l_invoices_tbl(i).CUST_TRX_ID := l_cust_trx_id;
973: l_invoices_tbl(i).PAYMENT_SCHEDULE_ID:= l_payment_schedule_id;
974: l_invoices_tbl(i).INSTALLMENT_NUMBER := l_installment;

Line 971: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - l_due_date: ' || l_due_date);

967:
968: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - installment #: ' || l_installment);
969: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - l_cust_trx_id: ' || l_cust_trx_id);
970: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - l_remaining_amt: ' || l_remaining_amt);
971: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - l_due_date: ' || l_due_date);
972: l_invoices_tbl(i).CUST_TRX_ID := l_cust_trx_id;
973: l_invoices_tbl(i).PAYMENT_SCHEDULE_ID:= l_payment_schedule_id;
974: l_invoices_tbl(i).INSTALLMENT_NUMBER := l_installment;
975: l_invoices_tbl(i).INVOICE_NUMBER := l_invoice_number;

Line 986: logMessage(FND_LOG.LEVEL_UNEXPECTED, G_PKG_NAME, l_api_name || ' - getting addition TO BE CREATED documents');

982: END LOOP;
983: close c_loanInvoices;
984: -- get the additional records "to be created"
985: if p_payoff_date is not null then
986: logMessage(FND_LOG.LEVEL_UNEXPECTED, G_PKG_NAME, l_api_name || ' - getting addition TO BE CREATED documents');
987: --dbms_output.put_line('calculating payoof amounts');
988: lns_financials.calculatePayoff(p_api_version => 1.0
989: ,p_init_msg_list => p_init_msg_list
990: ,p_loan_id => p_loan_id

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

994: ,x_msg_count => l_msg_count
995: ,x_msg_data => l_msg_data);
996: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
997: --FND_MESSAGE.SET_NAME('LNS', 'LNS_UPDATE_HEADER_ERROR');
998: LogMessage(FND_LOG.LEVEL_UNEXPECTED, G_PKG_NAME, FND_MSG_PUB.Get(p_encoded => 'F'));
999: RAISE FND_API.G_EXC_ERROR;
1000: END IF;
1001:
1002: logMessage(FND_LOG.LEVEL_UNEXPECTED, G_PKG_NAME, l_api_name || ' - payoff tbl count ' || l_payoff_tbl2.count);

Line 1002: logMessage(FND_LOG.LEVEL_UNEXPECTED, G_PKG_NAME, l_api_name || ' - payoff tbl count ' || l_payoff_tbl2.count);

998: LogMessage(FND_LOG.LEVEL_UNEXPECTED, G_PKG_NAME, FND_MSG_PUB.Get(p_encoded => 'F'));
999: RAISE FND_API.G_EXC_ERROR;
1000: END IF;
1001:
1002: logMessage(FND_LOG.LEVEL_UNEXPECTED, G_PKG_NAME, l_api_name || ' - payoff tbl count ' || l_payoff_tbl2.count);
1003:
1004: open c_loanInfo(p_loan_id);
1005: fetch c_loanInfo into l_invoice_number, l_installment;
1006: close c_loanInfo;

Line 1011: logMessage(FND_LOG.LEVEL_UNEXPECTED, G_PKG_NAME, l_api_name || l_payoff_tbl2(k).payoff_purpose);

1007:
1008: for k in 1..l_payoff_tbl2.count
1009: loop
1010:
1011: logMessage(FND_LOG.LEVEL_UNEXPECTED, G_PKG_NAME, l_api_name || l_payoff_tbl2(k).payoff_purpose);
1012: logMessage(FND_LOG.LEVEL_UNEXPECTED, G_PKG_NAME, l_api_name || l_payoff_tbl2(k).unbilled_amount);
1013:
1014: i := l_invoices_tbl.count;
1015: if l_payoff_tbl2(k).unbilled_amount > 0 and l_payoff_tbl2(k).PAYOFF_PURPOSE <> 'FEE' then

Line 1012: logMessage(FND_LOG.LEVEL_UNEXPECTED, G_PKG_NAME, l_api_name || l_payoff_tbl2(k).unbilled_amount);

1008: for k in 1..l_payoff_tbl2.count
1009: loop
1010:
1011: logMessage(FND_LOG.LEVEL_UNEXPECTED, G_PKG_NAME, l_api_name || l_payoff_tbl2(k).payoff_purpose);
1012: logMessage(FND_LOG.LEVEL_UNEXPECTED, G_PKG_NAME, l_api_name || l_payoff_tbl2(k).unbilled_amount);
1013:
1014: i := l_invoices_tbl.count;
1015: if l_payoff_tbl2(k).unbilled_amount > 0 and l_payoff_tbl2(k).PAYOFF_PURPOSE <> 'FEE' then
1016: i := i + 1;

Line 1029: logMessage(FND_LOG.LEVEL_UNEXPECTED, G_PKG_NAME, l_api_name || ' - getting last interest documents ');

1025:
1026:
1027: elsif l_payoff_tbl2(k).unbilled_amount < 0 and l_payoff_tbl2(k).PAYOFF_PURPOSE = 'INT' then
1028:
1029: logMessage(FND_LOG.LEVEL_UNEXPECTED, G_PKG_NAME, l_api_name || ' - getting last interest documents ');
1030: i := l_invoices_tbl.count;
1031: -- find the last interest installment we will create a credit memo in that amount
1032: -- and we will create an invoice of INT type with
1033: open c_lastInterestAmount(p_loan_id);

Line 1070: logMessage(FND_LOG.LEVEL_UNEXPECTED, G_PKG_NAME, l_api_name || ' - getting last fees ');

1066: end if;
1067:
1068: end loop;
1069:
1070: logMessage(FND_LOG.LEVEL_UNEXPECTED, G_PKG_NAME, l_api_name || ' - getting last fees ');
1071: i := l_invoices_tbl.count;
1072: open c_fees(p_loan_id);
1073: loop
1074: i := i + 1;

Line 1087: logMessage(FND_LOG.LEVEL_UNEXPECTED, G_PKG_NAME, l_api_name || ' - fee found');

1083: l_invoices_tbl(i).TRANSACTION_TYPE := lns_utility_pub.getDocumentName('FEE');
1084: l_invoices_tbl(i).REMAINING_AMOUNT := l_fee_amount;
1085: l_invoices_tbl(i).PURPOSE := lns_utility_pub.get_lookup_meaning('PAYMENT_APPLICATION_TYPE', 'FEE');
1086: l_invoices_tbl(i).BILLED_FLAG := 'N';
1087: logMessage(FND_LOG.LEVEL_UNEXPECTED, G_PKG_NAME, l_api_name || ' - fee found');
1088: end loop;
1089: close c_fees;
1090:
1091: end if;

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

1096: --
1097:
1098: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
1099:
1100: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - END');
1101:
1102: EXCEPTION
1103: WHEN FND_API.G_EXC_ERROR THEN
1104: ROLLBACK TO getLoanInvoices;

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

1105: x_return_status := FND_API.G_RET_STS_ERROR;
1106: x_msg_count := l_msg_count;
1107: x_msg_data := l_msg_data;
1108: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
1109: logMessage(FND_LOG.LEVEL_ERROR, G_PKG_NAME, sqlerrm);
1110:
1111: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1112: ROLLBACK TO getLoanInvoices;
1113: x_return_status := FND_API.G_RET_STS_ERROR;

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

1113: x_return_status := FND_API.G_RET_STS_ERROR;
1114: x_msg_count := l_msg_count;
1115: x_msg_data := l_msg_data;
1116: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
1117: logMessage(FND_LOG.LEVEL_ERROR, G_PKG_NAME, sqlerrm);
1118:
1119: WHEN OTHERS THEN
1120: ROLLBACK TO getLoanInvoices;
1121: x_return_status := FND_API.G_RET_STS_ERROR;

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

1121: x_return_status := FND_API.G_RET_STS_ERROR;
1122: x_msg_count := l_msg_count;
1123: x_msg_data := l_msg_data;
1124: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
1125: logMessage(FND_LOG.LEVEL_ERROR, G_PKG_NAME, sqlerrm);
1126:
1127: end getLoanInvoices;
1128:
1129: /*========================================================================

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

1200:
1201: BEGIN
1202:
1203: l_api_name := 'apply_receipt';
1204: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - BEGIN');
1205:
1206: -- Standard Start of API savepoint
1207: SAVEPOINT APPLY_RECEIPT;
1208:

Line 1215: LogMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, l_api_name || ' Applying cash receipt ' || P_CASH_RECEIPT_ID);

1211:
1212: --
1213: -- Api body
1214: -- --------------------------------------------------------------------
1215: LogMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, l_api_name || ' Applying cash receipt ' || P_CASH_RECEIPT_ID);
1216: LogMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, l_api_name || ' P_PS_ID: ' || P_PAYMENT_SCHEDULE_ID);
1217: --LogMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'P_TRX_LINE_ID: ' || P_TRX_LINE_ID);
1218: LogMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, l_api_name || ' P_APPLY_AMOUNT: ' || P_APPLY_AMOUNT);
1219: LogMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, l_api_name || ' P_APPLY_AMOUNT_FROM: ' || P_APPLY_AMOUNT_FROM);

Line 1216: LogMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, l_api_name || ' P_PS_ID: ' || P_PAYMENT_SCHEDULE_ID);

1212: --
1213: -- Api body
1214: -- --------------------------------------------------------------------
1215: LogMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, l_api_name || ' Applying cash receipt ' || P_CASH_RECEIPT_ID);
1216: LogMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, l_api_name || ' P_PS_ID: ' || P_PAYMENT_SCHEDULE_ID);
1217: --LogMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'P_TRX_LINE_ID: ' || P_TRX_LINE_ID);
1218: LogMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, l_api_name || ' P_APPLY_AMOUNT: ' || P_APPLY_AMOUNT);
1219: LogMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, l_api_name || ' P_APPLY_AMOUNT_FROM: ' || P_APPLY_AMOUNT_FROM);
1220: LogMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, l_api_name || ' p_trans_to_receipt_rate: ' || p_trans_to_receipt_rate);

Line 1217: --LogMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'P_TRX_LINE_ID: ' || P_TRX_LINE_ID);

1213: -- Api body
1214: -- --------------------------------------------------------------------
1215: LogMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, l_api_name || ' Applying cash receipt ' || P_CASH_RECEIPT_ID);
1216: LogMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, l_api_name || ' P_PS_ID: ' || P_PAYMENT_SCHEDULE_ID);
1217: --LogMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'P_TRX_LINE_ID: ' || P_TRX_LINE_ID);
1218: LogMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, l_api_name || ' P_APPLY_AMOUNT: ' || P_APPLY_AMOUNT);
1219: LogMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, l_api_name || ' P_APPLY_AMOUNT_FROM: ' || P_APPLY_AMOUNT_FROM);
1220: LogMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, l_api_name || ' p_trans_to_receipt_rate: ' || p_trans_to_receipt_rate);
1221:

Line 1218: LogMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, l_api_name || ' P_APPLY_AMOUNT: ' || P_APPLY_AMOUNT);

1214: -- --------------------------------------------------------------------
1215: LogMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, l_api_name || ' Applying cash receipt ' || P_CASH_RECEIPT_ID);
1216: LogMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, l_api_name || ' P_PS_ID: ' || P_PAYMENT_SCHEDULE_ID);
1217: --LogMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'P_TRX_LINE_ID: ' || P_TRX_LINE_ID);
1218: LogMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, l_api_name || ' P_APPLY_AMOUNT: ' || P_APPLY_AMOUNT);
1219: LogMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, l_api_name || ' P_APPLY_AMOUNT_FROM: ' || P_APPLY_AMOUNT_FROM);
1220: LogMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, l_api_name || ' p_trans_to_receipt_rate: ' || p_trans_to_receipt_rate);
1221:
1222: /* verify input data */

Line 1219: LogMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, l_api_name || ' P_APPLY_AMOUNT_FROM: ' || P_APPLY_AMOUNT_FROM);

1215: LogMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, l_api_name || ' Applying cash receipt ' || P_CASH_RECEIPT_ID);
1216: LogMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, l_api_name || ' P_PS_ID: ' || P_PAYMENT_SCHEDULE_ID);
1217: --LogMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'P_TRX_LINE_ID: ' || P_TRX_LINE_ID);
1218: LogMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, l_api_name || ' P_APPLY_AMOUNT: ' || P_APPLY_AMOUNT);
1219: LogMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, l_api_name || ' P_APPLY_AMOUNT_FROM: ' || P_APPLY_AMOUNT_FROM);
1220: LogMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, l_api_name || ' p_trans_to_receipt_rate: ' || p_trans_to_receipt_rate);
1221:
1222: /* verify input data */
1223: if P_CASH_RECEIPT_ID is null then

Line 1220: LogMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, l_api_name || ' p_trans_to_receipt_rate: ' || p_trans_to_receipt_rate);

1216: LogMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, l_api_name || ' P_PS_ID: ' || P_PAYMENT_SCHEDULE_ID);
1217: --LogMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'P_TRX_LINE_ID: ' || P_TRX_LINE_ID);
1218: LogMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, l_api_name || ' P_APPLY_AMOUNT: ' || P_APPLY_AMOUNT);
1219: LogMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, l_api_name || ' P_APPLY_AMOUNT_FROM: ' || P_APPLY_AMOUNT_FROM);
1220: LogMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, l_api_name || ' p_trans_to_receipt_rate: ' || p_trans_to_receipt_rate);
1221:
1222: /* verify input data */
1223: if P_CASH_RECEIPT_ID is null then
1224: FND_MESSAGE.SET_NAME('LNS', 'LNS_CR_NOT_SET');

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

1222: /* verify input data */
1223: if P_CASH_RECEIPT_ID is null then
1224: FND_MESSAGE.SET_NAME('LNS', 'LNS_CR_NOT_SET');
1225: FND_MSG_PUB.Add;
1226: LogMessage(FND_LOG.LEVEL_UNEXPECTED, G_PKG_NAME, FND_MSG_PUB.Get(p_encoded => 'F'));
1227: RAISE FND_API.G_EXC_ERROR;
1228: end if;
1229:
1230: if P_APPLY_AMOUNT is null or P_APPLY_AMOUNT <= 0 then

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

1229:
1230: if P_APPLY_AMOUNT is null or P_APPLY_AMOUNT <= 0 then
1231: FND_MESSAGE.SET_NAME('LNS', 'LNS_AMOUNT_NOT_SET');
1232: FND_MSG_PUB.Add;
1233: LogMessage(FND_LOG.LEVEL_UNEXPECTED, G_PKG_NAME, FND_MSG_PUB.Get(p_encoded => 'F'));
1234: RAISE FND_API.G_EXC_ERROR;
1235: end if;
1236:
1237: /* verifying requested qpply amount */

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

1240:
1241: if receipt_cur%NOTFOUND then
1242: FND_MESSAGE.SET_NAME('LNS', 'LNS_NO_CR_FOUND');
1243: FND_MSG_PUB.Add;
1244: LogMessage(FND_LOG.LEVEL_UNEXPECTED, G_PKG_NAME, FND_MSG_PUB.Get(p_encoded => 'F'));
1245: RAISE FND_API.G_EXC_ERROR;
1246: end if;
1247:
1248: close receipt_cur;

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

1249: /*
1250: if l_receipt_rem_amount < P_APPLY_AMOUNT then
1251: FND_MESSAGE.SET_NAME('LNS', 'LNS_NO_CR_FUNDS');
1252: FND_MSG_PUB.Add;
1253: LogMessage(FND_LOG.LEVEL_UNEXPECTED, G_PKG_NAME, FND_MSG_PUB.Get(p_encoded => 'F'));
1254: RAISE FND_API.G_EXC_ERROR;
1255: end if;
1256: */
1257: select

Line 1272: LogMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, l_api_name || ' due_date: ' || l_due_date);

1268: l_apply_date := l_due_Date;
1269: else
1270: l_apply_date := p_apply_date;
1271: end if;
1272: LogMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, l_api_name || ' due_date: ' || l_due_date);
1273: LogMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, l_api_name || ' apply_date: ' || l_apply_date);
1274:
1275: /* Applying cash receipt to invoice */
1276: AR_RECEIPT_API_PUB.APPLY(P_API_VERSION => 1.0

Line 1273: LogMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, l_api_name || ' apply_date: ' || l_apply_date);

1269: else
1270: l_apply_date := p_apply_date;
1271: end if;
1272: LogMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, l_api_name || ' due_date: ' || l_due_date);
1273: LogMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, l_api_name || ' apply_date: ' || l_apply_date);
1274:
1275: /* Applying cash receipt to invoice */
1276: AR_RECEIPT_API_PUB.APPLY(P_API_VERSION => 1.0
1277: ,P_INIT_MSG_LIST => FND_API.G_FALSE

Line 1290: LogMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, l_api_name || ' return_status: ' || l_return_status);

1286: ,p_amount_applied => P_APPLY_AMOUNT
1287: ,p_amount_applied_from => p_apply_amount_from
1288: ,p_trans_to_receipt_rate => p_trans_to_receipt_rate);
1289:
1290: LogMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, l_api_name || ' return_status: ' || l_return_status);
1291: LogMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, l_api_name || ' msg_data: ' || substr(l_msg_data,1,225));
1292:
1293: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1294: FND_MESSAGE.SET_NAME('LNS', 'LNS_APPL_CR_FAIL');

Line 1291: LogMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, l_api_name || ' msg_data: ' || substr(l_msg_data,1,225));

1287: ,p_amount_applied_from => p_apply_amount_from
1288: ,p_trans_to_receipt_rate => p_trans_to_receipt_rate);
1289:
1290: LogMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, l_api_name || ' return_status: ' || l_return_status);
1291: LogMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, l_api_name || ' msg_data: ' || substr(l_msg_data,1,225));
1292:
1293: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1294: FND_MESSAGE.SET_NAME('LNS', 'LNS_APPL_CR_FAIL');
1295: FND_MSG_PUB.Add;

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

1292:
1293: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1294: FND_MESSAGE.SET_NAME('LNS', 'LNS_APPL_CR_FAIL');
1295: FND_MSG_PUB.Add;
1296: LogMessage(FND_LOG.LEVEL_UNEXPECTED, G_PKG_NAME, FND_MSG_PUB.Get(p_encoded => 'F'));
1297: RAISE FND_API.G_EXC_ERROR;
1298: ELSE
1299: null;
1300: --LogMessage(FND_LOG.LEVEL_UNEXPECTED, G_PKG_NAME, 'Successfully applied cash receipt to trx ' || P_TRX_ID || ' line ' || P_TRX_LINE_ID);

Line 1300: --LogMessage(FND_LOG.LEVEL_UNEXPECTED, G_PKG_NAME, 'Successfully applied cash receipt to trx ' || P_TRX_ID || ' line ' || P_TRX_LINE_ID);

1296: LogMessage(FND_LOG.LEVEL_UNEXPECTED, G_PKG_NAME, FND_MSG_PUB.Get(p_encoded => 'F'));
1297: RAISE FND_API.G_EXC_ERROR;
1298: ELSE
1299: null;
1300: --LogMessage(FND_LOG.LEVEL_UNEXPECTED, G_PKG_NAME, 'Successfully applied cash receipt to trx ' || P_TRX_ID || ' line ' || P_TRX_LINE_ID);
1301: END IF;
1302: -- END OF BODY OF API
1303:
1304: LogMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - END');

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

1300: --LogMessage(FND_LOG.LEVEL_UNEXPECTED, G_PKG_NAME, 'Successfully applied cash receipt to trx ' || P_TRX_ID || ' line ' || P_TRX_LINE_ID);
1301: END IF;
1302: -- END OF BODY OF API
1303:
1304: LogMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - END');
1305:
1306: EXCEPTION
1307: WHEN FND_API.G_EXC_ERROR THEN
1308: ROLLBACK TO APPLY_RECEIPT;

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

1309: x_return_status := FND_API.G_RET_STS_ERROR;
1310: x_msg_count := l_msg_count;
1311: x_msg_data := l_msg_data;
1312: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
1313: logMessage(FND_LOG.LEVEL_ERROR, G_PKG_NAME, sqlerrm);
1314:
1315: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1316: ROLLBACK TO APPLY_RECEIPT;
1317: x_return_status := FND_API.G_RET_STS_ERROR;

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

1317: x_return_status := FND_API.G_RET_STS_ERROR;
1318: x_msg_count := l_msg_count;
1319: x_msg_data := l_msg_data;
1320: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
1321: logMessage(FND_LOG.LEVEL_ERROR, G_PKG_NAME, sqlerrm);
1322:
1323: WHEN OTHERS THEN
1324: ROLLBACK TO APPLY_RECEIPT;
1325: x_return_status := FND_API.G_RET_STS_ERROR;

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

1325: x_return_status := FND_API.G_RET_STS_ERROR;
1326: x_msg_count := l_msg_count;
1327: x_msg_data := l_msg_data;
1328: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
1329: logMessage(FND_LOG.LEVEL_ERROR, G_PKG_NAME, sqlerrm);
1330: END;
1331:
1332: /*=========================================================================
1333: || PUBLIC FUNCTION getConvertedReceiptAmount