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 211: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - BEGIN');

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

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

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

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

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

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

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

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

260:
261: open c_sob_currency;
262: fetch c_sob_currency into l_sob_currency;
263: close c_sob_currency;
264: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, l_api_name || ' - LOAN CURRENCY ' || l_loan_currency);
265: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, l_api_name || ' - loan_exchange_rate ' || l_loan_exchange_rate);
266:
267: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, l_api_name || ' - calculating Payoff ');
268: lns_financials.calculatePayoff(p_api_version => 1.0

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

261: open c_sob_currency;
262: fetch c_sob_currency into l_sob_currency;
263: close c_sob_currency;
264: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, l_api_name || ' - LOAN CURRENCY ' || l_loan_currency);
265: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, l_api_name || ' - loan_exchange_rate ' || l_loan_exchange_rate);
266:
267: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, l_api_name || ' - calculating Payoff ');
268: lns_financials.calculatePayoff(p_api_version => 1.0
269: ,p_init_msg_list => p_init_msg_list

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

263: close c_sob_currency;
264: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, l_api_name || ' - LOAN CURRENCY ' || l_loan_currency);
265: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, l_api_name || ' - loan_exchange_rate ' || l_loan_exchange_rate);
266:
267: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, l_api_name || ' - calculating Payoff ');
268: lns_financials.calculatePayoff(p_api_version => 1.0
269: ,p_init_msg_list => p_init_msg_list
270: ,p_loan_id => p_loan_id
271: ,p_payoff_date => p_payoff_date

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

276:
277: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
278: FND_MESSAGE.SET_NAME('LNS', 'LNS_CALCULATE_PAYOFF_ERROR');
279: FND_MSG_PUB.Add;
280: LogMessage(FND_LOG.LEVEL_UNEXPECTED, G_PKG_NAME, l_api_name || FND_MSG_PUB.Get(p_encoded => 'F'));
281: RAISE FND_API.G_EXC_ERROR;
282: END IF;
283:
284: --2. create payoff document(s) in receivables

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

282: END IF;
283:
284: --2. create payoff document(s) in receivables
285: -- build the header for the loan document(s) to be created
286: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, l_api_name || ' - Building Invoice header/lines');
287: l_bill_headers_tbl(1).HEADER_ID := 101;
288: l_bill_headers_tbl(1).LOAN_ID := p_loan_id;
289: l_bill_headers_tbl(1).ASSOC_PAYMENT_NUM := LNS_BILLING_UTIL_PUB.LAST_PAYMENT_NUMBER(p_loan_id);
290: l_bill_headers_tbl(1).DUE_DATE := p_payoff_date;

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

298: l_bill_lines_tbl(s).LINE_ID := i;
299: l_bill_lines_tbl(s).HEADER_ID := 101;
300: l_bill_lines_tbl(s).LINE_AMOUNT := l_payoff_tbl2(i).unbilled_amount;
301: l_bill_lines_tbl(s).LINE_TYPE := l_payoff_tbl2(i).PAYOFF_PURPOSE;
302: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, l_api_name || ' - purpose ' || l_payoff_tbl2(i).payoff_purpose);
303: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, l_api_name || ' - amount ' || l_payoff_tbl2(i).unbilled_amount);
304:
305: elsif l_payoff_tbl2(i).unbilled_amount > 0 and l_payoff_tbl2(i).payoff_purpose = 'FEE' then
306:

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

299: l_bill_lines_tbl(s).HEADER_ID := 101;
300: l_bill_lines_tbl(s).LINE_AMOUNT := l_payoff_tbl2(i).unbilled_amount;
301: l_bill_lines_tbl(s).LINE_TYPE := l_payoff_tbl2(i).PAYOFF_PURPOSE;
302: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, l_api_name || ' - purpose ' || l_payoff_tbl2(i).payoff_purpose);
303: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, l_api_name || ' - amount ' || l_payoff_tbl2(i).unbilled_amount);
304:
305: elsif l_payoff_tbl2(i).unbilled_amount > 0 and l_payoff_tbl2(i).payoff_purpose = 'FEE' then
306:
307: open c_fees(p_loan_id, l_phase, l_bill_headers_tbl(1).ASSOC_PAYMENT_NUM);

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

314: l_bill_lines_tbl(s).HEADER_ID := 101;
315: l_bill_lines_tbl(s).LINE_AMOUNT := l_fee_amount;
316: l_bill_lines_tbl(s).LINE_TYPE := l_payoff_tbl2(i).payoff_purpose;
317: l_bill_lines_tbl(s).LINE_DESC := l_fee_name;
318: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, l_api_name || ' - purpose ' || l_payoff_tbl2(i).payoff_purpose);
319: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, l_api_name || ' - amount ' || l_payoff_tbl2(i).unbilled_amount);
320: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, l_api_name || ' - fee ' || l_fee_name);
321: end loop;
322: close c_fees;

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

315: l_bill_lines_tbl(s).LINE_AMOUNT := l_fee_amount;
316: l_bill_lines_tbl(s).LINE_TYPE := l_payoff_tbl2(i).payoff_purpose;
317: l_bill_lines_tbl(s).LINE_DESC := l_fee_name;
318: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, l_api_name || ' - purpose ' || l_payoff_tbl2(i).payoff_purpose);
319: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, l_api_name || ' - amount ' || l_payoff_tbl2(i).unbilled_amount);
320: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, l_api_name || ' - fee ' || l_fee_name);
321: end loop;
322: close c_fees;
323: /*

Line 320: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, l_api_name || ' - fee ' || l_fee_name);

316: l_bill_lines_tbl(s).LINE_TYPE := l_payoff_tbl2(i).payoff_purpose;
317: l_bill_lines_tbl(s).LINE_DESC := l_fee_name;
318: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, l_api_name || ' - purpose ' || l_payoff_tbl2(i).payoff_purpose);
319: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, l_api_name || ' - amount ' || l_payoff_tbl2(i).unbilled_amount);
320: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, l_api_name || ' - fee ' || l_fee_name);
321: end loop;
322: close c_fees;
323: /*
324: elsif l_payoff_tbl2(i).unbilled_amount < 0 and l_payoff_tbl2(i).payoff_purpose = 'INT' then

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

323: /*
324: elsif l_payoff_tbl2(i).unbilled_amount < 0 and l_payoff_tbl2(i).payoff_purpose = 'INT' then
325:
326: -- we have an interest credit due we will credit out the interest on the last amortization
327: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - interest credit is due');
328: -- 1. check to see if documents have been paid,
329: -- unapply all cash from receivable applications
330: open c_applications(p_loan_id);
331: loop

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

346:
347: exit when c_applications%notfound;
348:
349: -- 2. if so, unapply all cash_receipts from document
350: LogMessage(FND_LOG.LEVEL_UNEXPECTED, G_PKG_NAME, l_api_name || ' - unapplying cash from pay_sched_id: ' || l_rec_application_id);
351: ar_receipt_api_pub.unapply(p_api_version => 1.0
352: ,p_init_msg_list => p_init_msg_list
353: ,p_commit => FND_API.G_FALSE
354: ,p_receivable_application_id => l_rec_application_id

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

360: FND_MESSAGE.SET_NAME('LNS', 'LNS_UNAPPLY_CASH_ERROR');
361: FND_MESSAGE.SET_TOKEN('PARAMETER', 'RECEIPT_NUMBER');
362: FND_MESSAGE.SET_TOKEN('VALUE', l_receipt_number);
363: FND_MSG_PUB.Add;
364: logMessage(FND_LOG.LEVEL_UNEXPECTED, G_PKG_NAME, FND_MSG_PUB.Get(p_encoded => 'F'));
365: RAISE FND_API.G_EXC_ERROR;
366: end if;
367:
368:

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

365: RAISE FND_API.G_EXC_ERROR;
366: end if;
367:
368:
369: logMessage(FND_LOG.LEVEL_UNEXPECTED, G_PKG_NAME, l_api_name || ' - unapplied cash successfully');
370: -- 2a. keep unapplied cash_receipts in memory to use for payoff
371: -- bug #4191794
372: -- if this cash receipt_id exists in the set of selected cash receipts then
373: -- we will have to add it back to existing cash_receipt_id

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

372: -- if this cash receipt_id exists in the set of selected cash receipts then
373: -- we will have to add it back to existing cash_receipt_id
374: l_bool_match := false;
375: for j in 1..l_cash_receipt_ids.count loop
376: logMessage(FND_LOG.LEVEL_UNEXPECTED, G_PKG_NAME, l_api_name || ' - check existing cr_id: ' || l_cash_receipt_ids(j).cash_receipt_id);
377: if l_cash_receipt_id = l_cash_receipt_ids(j).cash_receipt_id then
378: l_cash_receipt_ids(j).receipt_amount := l_cash_receipt_ids(j).receipt_amount + l_amount_applied;
379: l_bool_match := true;
380: logMessage(FND_LOG.LEVEL_UNEXPECTED, G_PKG_NAME, l_api_name || ' - matched existing cr_id: ' || l_cash_receipt_ids(j).cash_receipt_id);

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

376: logMessage(FND_LOG.LEVEL_UNEXPECTED, G_PKG_NAME, l_api_name || ' - check existing cr_id: ' || l_cash_receipt_ids(j).cash_receipt_id);
377: if l_cash_receipt_id = l_cash_receipt_ids(j).cash_receipt_id then
378: l_cash_receipt_ids(j).receipt_amount := l_cash_receipt_ids(j).receipt_amount + l_amount_applied;
379: l_bool_match := true;
380: logMessage(FND_LOG.LEVEL_UNEXPECTED, G_PKG_NAME, l_api_name || ' - matched existing cr_id: ' || l_cash_receipt_ids(j).cash_receipt_id);
381: exit;
382: end if;
383: end loop;
384:

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

382: end if;
383: end loop;
384:
385: if not l_bool_match then
386: logMessage(FND_LOG.LEVEL_UNEXPECTED, G_PKG_NAME, l_api_name || ' - receipts count is: ' || l_cash_receipts_count);
387: logMessage(FND_LOG.LEVEL_UNEXPECTED, G_PKG_NAME, l_api_name || ' - adding applied cr_id: ' || l_cash_receipt_id);
388: logMessage(FND_LOG.LEVEL_UNEXPECTED, G_PKG_NAME, l_api_name || ' - cr_id amount: ' || l_amount_applied);
389: logMessage(FND_LOG.LEVEL_UNEXPECTED, G_PKG_NAME, l_api_name || ' - cr_id currency: ' || l_loan_currency);
390: l_cash_receipts_count := l_cash_receipts_count + 1;

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

383: end loop;
384:
385: if not l_bool_match then
386: logMessage(FND_LOG.LEVEL_UNEXPECTED, G_PKG_NAME, l_api_name || ' - receipts count is: ' || l_cash_receipts_count);
387: logMessage(FND_LOG.LEVEL_UNEXPECTED, G_PKG_NAME, l_api_name || ' - adding applied cr_id: ' || l_cash_receipt_id);
388: logMessage(FND_LOG.LEVEL_UNEXPECTED, G_PKG_NAME, l_api_name || ' - cr_id amount: ' || l_amount_applied);
389: logMessage(FND_LOG.LEVEL_UNEXPECTED, G_PKG_NAME, l_api_name || ' - cr_id currency: ' || l_loan_currency);
390: l_cash_receipts_count := l_cash_receipts_count + 1;
391: l_cash_receipt_ids(l_cash_receipts_count).CASH_RECEIPT_ID := l_cash_receipt_id;

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

384:
385: if not l_bool_match then
386: logMessage(FND_LOG.LEVEL_UNEXPECTED, G_PKG_NAME, l_api_name || ' - receipts count is: ' || l_cash_receipts_count);
387: logMessage(FND_LOG.LEVEL_UNEXPECTED, G_PKG_NAME, l_api_name || ' - adding applied cr_id: ' || l_cash_receipt_id);
388: logMessage(FND_LOG.LEVEL_UNEXPECTED, G_PKG_NAME, l_api_name || ' - cr_id amount: ' || l_amount_applied);
389: logMessage(FND_LOG.LEVEL_UNEXPECTED, G_PKG_NAME, l_api_name || ' - cr_id currency: ' || l_loan_currency);
390: l_cash_receipts_count := l_cash_receipts_count + 1;
391: l_cash_receipt_ids(l_cash_receipts_count).CASH_RECEIPT_ID := l_cash_receipt_id;
392: l_cash_receipt_ids(l_cash_receipts_count).RECEIPT_AMOUNT := l_amount_applied;

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

385: if not l_bool_match then
386: logMessage(FND_LOG.LEVEL_UNEXPECTED, G_PKG_NAME, l_api_name || ' - receipts count is: ' || l_cash_receipts_count);
387: logMessage(FND_LOG.LEVEL_UNEXPECTED, G_PKG_NAME, l_api_name || ' - adding applied cr_id: ' || l_cash_receipt_id);
388: logMessage(FND_LOG.LEVEL_UNEXPECTED, G_PKG_NAME, l_api_name || ' - cr_id amount: ' || l_amount_applied);
389: logMessage(FND_LOG.LEVEL_UNEXPECTED, G_PKG_NAME, l_api_name || ' - cr_id currency: ' || l_loan_currency);
390: l_cash_receipts_count := l_cash_receipts_count + 1;
391: l_cash_receipt_ids(l_cash_receipts_count).CASH_RECEIPT_ID := l_cash_receipt_id;
392: l_cash_receipt_ids(l_cash_receipts_count).RECEIPT_AMOUNT := l_amount_applied;
393: l_cash_receipt_ids(l_cash_receipts_count).RECEIPT_CURRENCY := l_loan_currency;

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

397: l_cash_receipt_ids(l_cash_receipts_count).EXCHANGE_DATE := l_rec_exchange_date;
398: l_cash_receipt_ids(l_cash_receipts_count).EXCHANGE_RATE_TYPE := l_rec_exchange_rate_type;
399: end if;
400: end if;
401: logMessage(FND_LOG.LEVEL_UNEXPECTED, G_PKG_NAME, l_api_name || ' - added cash rec id ' || l_cash_receipt_id);
402: logMessage(FND_LOG.LEVEL_UNEXPECTED, G_PKG_NAME, l_api_name || ' - added cash amount ' || l_amount_applied || ' ' || l_currency_code);
403:
404: end loop; --end unapplication loop
405:

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

398: l_cash_receipt_ids(l_cash_receipts_count).EXCHANGE_RATE_TYPE := l_rec_exchange_rate_type;
399: end if;
400: end if;
401: logMessage(FND_LOG.LEVEL_UNEXPECTED, G_PKG_NAME, l_api_name || ' - added cash rec id ' || l_cash_receipt_id);
402: logMessage(FND_LOG.LEVEL_UNEXPECTED, G_PKG_NAME, l_api_name || ' - added cash amount ' || l_amount_applied || ' ' || l_currency_code);
403:
404: end loop; --end unapplication loop
405:
406: -- 3. credit document

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

403:
404: end loop; --end unapplication loop
405:
406: -- 3. credit document
407: logMessage(FND_LOG.LEVEL_UNEXPECTED, G_PKG_NAME, l_api_name || ' - crediting final interest document');
408: LNS_BILLING_BATCH_PUB.CREDIT_AMORTIZATION_PARTIAL(P_API_VERSION => 1.0
409: ,P_INIT_MSG_LIST => p_init_msg_list
410: ,P_COMMIT => FND_API.G_FALSE
411: ,P_VALIDATION_LEVEL => FND_API.G_VALID_LEVEL_FULL

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

417:
418: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
419: FND_MESSAGE.SET_NAME('LNS', 'LNS_CREDIT_MEMO_ERROR');
420: FND_MSG_PUB.Add;
421: LogMessage(FND_LOG.LEVEL_UNEXPECTED, G_PKG_NAME, FND_MSG_PUB.Get(p_encoded => 'F'));
422: RAISE FND_API.G_EXC_ERROR;
423: end if;
424:
425: -- 4. create new interest and principal document for difference

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

422: RAISE FND_API.G_EXC_ERROR;
423: end if;
424:
425: -- 4. create new interest and principal document for difference
426: logMessage(FND_LOG.LEVEL_UNEXPECTED, G_PKG_NAME, l_api_name || ' - RECALCULATING INTEREST');
427: if b_recalculate_interest then
428: logMessage(FND_LOG.LEVEL_UNEXPECTED, G_PKG_NAME, l_api_name || ' - l_interest_trx_Id: ' || l_interest_trx_Id);
429: logMessage(FND_LOG.LEVEL_UNEXPECTED, G_PKG_NAME, l_api_name || ' - l_customer_trx_id: ' || l_customer_trx_id);
430:

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

424:
425: -- 4. create new interest and principal document for difference
426: logMessage(FND_LOG.LEVEL_UNEXPECTED, G_PKG_NAME, l_api_name || ' - RECALCULATING INTEREST');
427: if b_recalculate_interest then
428: logMessage(FND_LOG.LEVEL_UNEXPECTED, G_PKG_NAME, l_api_name || ' - l_interest_trx_Id: ' || l_interest_trx_Id);
429: logMessage(FND_LOG.LEVEL_UNEXPECTED, G_PKG_NAME, l_api_name || ' - l_customer_trx_id: ' || l_customer_trx_id);
430:
431: if l_interest_trx_id = l_customer_trx_id then
432: logMessage(FND_LOG.LEVEL_UNEXPECTED, G_PKG_NAME, l_api_name || ' - RECALCULATED INTEREST DUE: ' || l_new_interest);

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

425: -- 4. create new interest and principal document for difference
426: logMessage(FND_LOG.LEVEL_UNEXPECTED, G_PKG_NAME, l_api_name || ' - RECALCULATING INTEREST');
427: if b_recalculate_interest then
428: logMessage(FND_LOG.LEVEL_UNEXPECTED, G_PKG_NAME, l_api_name || ' - l_interest_trx_Id: ' || l_interest_trx_Id);
429: logMessage(FND_LOG.LEVEL_UNEXPECTED, G_PKG_NAME, l_api_name || ' - l_customer_trx_id: ' || l_customer_trx_id);
430:
431: if l_interest_trx_id = l_customer_trx_id then
432: logMessage(FND_LOG.LEVEL_UNEXPECTED, G_PKG_NAME, l_api_name || ' - RECALCULATED INTEREST DUE: ' || l_new_interest);
433:

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

428: logMessage(FND_LOG.LEVEL_UNEXPECTED, G_PKG_NAME, l_api_name || ' - l_interest_trx_Id: ' || l_interest_trx_Id);
429: logMessage(FND_LOG.LEVEL_UNEXPECTED, G_PKG_NAME, l_api_name || ' - l_customer_trx_id: ' || l_customer_trx_id);
430:
431: if l_interest_trx_id = l_customer_trx_id then
432: logMessage(FND_LOG.LEVEL_UNEXPECTED, G_PKG_NAME, l_api_name || ' - RECALCULATED INTEREST DUE: ' || l_new_interest);
433:
434: -- over interest charge had previous applications
435: select amount_due_original + l_payoff_tbl2(i).unbilled_amount
436: into l_new_interest

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

451: end if;
452: b_recalculate_interest := false;
453: end if;
454:
455: logMessage(FND_LOG.LEVEL_UNEXPECTED, G_PKG_NAME, l_api_name || ' - RECALCULATED INTEREST DUE: ' || l_new_interest);
456:
457: -- we will only create a new interest document IF there is an interest amount due
458: if l_new_interest > 0 then
459: s := s + 1;

Line 470: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, l_api_name || ' - billing lines = ' || l_bill_lines_tbl.count);

466: end if;
467:
468: end loop;
469:
470: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, l_api_name || ' - billing lines = ' || l_bill_lines_tbl.count);
471: if l_bill_lines_tbl.count >= 1 then
472:
473: -- we have at least 1 invoice to create with amount > 0
474: -- must pass false for commit here or else payoff documents will exist in receivables

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

484:
485: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
486: FND_MESSAGE.SET_NAME('LNS', 'LNS_INVOICE_CREATION_ERROR');
487: FND_MSG_PUB.Add;
488: logMessage(FND_LOG.LEVEL_UNEXPECTED, G_PKG_NAME, FND_MSG_PUB.Get(p_encoded => 'F'));
489: RAISE FND_API.G_EXC_ERROR;
490: END IF;
491:
492: end if;

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

492: end if;
493:
494: --3. getLoanInvoices (should return newly created documents)
495: -- pass payoff_date = null to avoid recalculating payoff amounts
496: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, l_api_name || ' - getting loan invoices');
497: lns_payoff_pub.getLoanInvoices(p_api_version => 1
498: ,p_init_msg_list => p_init_msg_list
499: ,p_loan_ID => p_loan_id
500: ,p_payoff_date => null

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

505:
506: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
507: FND_MESSAGE.SET_NAME('LNS', 'LNS_INVOICE_SUMMARY_ERROR');
508: FND_MSG_PUB.Add;
509: LogMessage(FND_LOG.LEVEL_UNEXPECTED, G_PKG_NAME, FND_MSG_PUB.Get(p_encoded => 'F'));
510: RAISE FND_API.G_EXC_ERROR;
511: END IF;
512:
513: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, l_api_name || ' - # of unpaid invoices to process = ' || l_invoices_tbl.count);

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

509: LogMessage(FND_LOG.LEVEL_UNEXPECTED, G_PKG_NAME, FND_MSG_PUB.Get(p_encoded => 'F'));
510: RAISE FND_API.G_EXC_ERROR;
511: END IF;
512:
513: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, l_api_name || ' - # of unpaid invoices to process = ' || l_invoices_tbl.count);
514:
515: --4. check if sum of receipts covers the remaining loan amount
516: -- if we need to do multi-currency, the receipt amounts should be
517: -- converted to loan_currency before making comparison

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

523:
524: for j in 1..l_cash_receipt_ids.count
525: loop
526:
527: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, l_api_name || ' - receipt currency: ' || l_cash_receipt_ids(j).receipt_currency);
528: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, l_api_name || ' - receipt amount: ' || l_cash_receipt_ids(j).receipt_amount);
529: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, l_api_name || ' - xchg rate: ' || l_cash_receipt_ids(j).exchange_rate);
530:
531: open c_receipt_number(l_cash_receipt_ids(j).cash_receipt_id);

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

524: for j in 1..l_cash_receipt_ids.count
525: loop
526:
527: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, l_api_name || ' - receipt currency: ' || l_cash_receipt_ids(j).receipt_currency);
528: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, l_api_name || ' - receipt amount: ' || l_cash_receipt_ids(j).receipt_amount);
529: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, l_api_name || ' - xchg rate: ' || l_cash_receipt_ids(j).exchange_rate);
530:
531: open c_receipt_number(l_cash_receipt_ids(j).cash_receipt_id);
532: fetch c_receipt_number into l_receipt_number, l_receipt_currency_orig;

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

525: loop
526:
527: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, l_api_name || ' - receipt currency: ' || l_cash_receipt_ids(j).receipt_currency);
528: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, l_api_name || ' - receipt amount: ' || l_cash_receipt_ids(j).receipt_amount);
529: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, l_api_name || ' - xchg rate: ' || l_cash_receipt_ids(j).exchange_rate);
530:
531: open c_receipt_number(l_cash_receipt_ids(j).cash_receipt_id);
532: fetch c_receipt_number into l_receipt_number, l_receipt_currency_orig;
533: close c_receipt_number ;

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

537: l_total_receipts_amount := l_total_receipts_amount + l_cash_receipt_ids(j).receipt_amount;
538:
539: end loop;
540:
541: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, l_api_name || ' - cash receipts to process: ' || l_cash_receipt_ids.count);
542: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, l_api_name || ' - total receipts: ' || l_total_receipts_amount);
543: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, l_api_name || ' - total payoff amount: ' || l_total_payoff_amount);
544:
545: if l_total_receipts_amount < l_total_payoff_amount then

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

538:
539: end loop;
540:
541: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, l_api_name || ' - cash receipts to process: ' || l_cash_receipt_ids.count);
542: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, l_api_name || ' - total receipts: ' || l_total_receipts_amount);
543: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, l_api_name || ' - total payoff amount: ' || l_total_payoff_amount);
544:
545: if l_total_receipts_amount < l_total_payoff_amount then
546: FND_MESSAGE.SET_NAME('LNS', 'LNS_PAYOFF_SHORT_CASH');

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

539: end loop;
540:
541: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, l_api_name || ' - cash receipts to process: ' || l_cash_receipt_ids.count);
542: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, l_api_name || ' - total receipts: ' || l_total_receipts_amount);
543: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, l_api_name || ' - total payoff amount: ' || l_total_payoff_amount);
544:
545: if l_total_receipts_amount < l_total_payoff_amount then
546: FND_MESSAGE.SET_NAME('LNS', 'LNS_PAYOFF_SHORT_CASH');
547: FND_MSG_PUB.Add;

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

544:
545: if l_total_receipts_amount < l_total_payoff_amount then
546: FND_MESSAGE.SET_NAME('LNS', 'LNS_PAYOFF_SHORT_CASH');
547: FND_MSG_PUB.Add;
548: LogMessage(FND_LOG.LEVEL_UNEXPECTED, G_PKG_NAME, FND_MSG_PUB.Get(p_encoded => 'F'));
549: RAISE FND_API.G_EXC_ERROR;
550: end if;
551:
552: --5. apply cash

Line 553: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, l_api_name || ' - applying receipts...');

549: RAISE FND_API.G_EXC_ERROR;
550: end if;
551:
552: --5. apply cash
553: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, l_api_name || ' - applying receipts...');
554: for k in 1..l_invoices_tbl.count
555: loop
556: -- find the first cash receipt that has not been applied previously to the invoice
557: -- if the amount of the receipt is > invoice then move on

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

557: -- if the amount of the receipt is > invoice then move on
558: -- else find the next receipt that has not been applied previously to the invoice
559: j := 1;
560: l_invoice_amount_remaining := l_invoices_tbl(k).REMAINING_AMOUNT;
561: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, l_api_name || ' --------- next invoice ----------');
562: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, l_api_name || ' - payment_schedule_id: ' || l_invoices_tbl(k).payment_schedule_id );
563: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, l_api_name || ' - invoice remaining amount: ' || l_invoices_tbl(k).REMAINING_AMOUNT);
564:
565: --l_receipt_amount_remaining := l_cash_receipt_ids(j).RECEIPT_AMOUNT;

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

558: -- else find the next receipt that has not been applied previously to the invoice
559: j := 1;
560: l_invoice_amount_remaining := l_invoices_tbl(k).REMAINING_AMOUNT;
561: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, l_api_name || ' --------- next invoice ----------');
562: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, l_api_name || ' - payment_schedule_id: ' || l_invoices_tbl(k).payment_schedule_id );
563: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, l_api_name || ' - invoice remaining amount: ' || l_invoices_tbl(k).REMAINING_AMOUNT);
564:
565: --l_receipt_amount_remaining := l_cash_receipt_ids(j).RECEIPT_AMOUNT;
566: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, l_api_name || ' - receipt amount: # ' || j || ' =' ||l_cash_receipt_ids(j).RECEIPT_AMOUNT);

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

559: j := 1;
560: l_invoice_amount_remaining := l_invoices_tbl(k).REMAINING_AMOUNT;
561: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, l_api_name || ' --------- next invoice ----------');
562: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, l_api_name || ' - payment_schedule_id: ' || l_invoices_tbl(k).payment_schedule_id );
563: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, l_api_name || ' - invoice remaining amount: ' || l_invoices_tbl(k).REMAINING_AMOUNT);
564:
565: --l_receipt_amount_remaining := l_cash_receipt_ids(j).RECEIPT_AMOUNT;
566: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, l_api_name || ' - receipt amount: # ' || j || ' =' ||l_cash_receipt_ids(j).RECEIPT_AMOUNT);
567:

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

562: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, l_api_name || ' - payment_schedule_id: ' || l_invoices_tbl(k).payment_schedule_id );
563: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, l_api_name || ' - invoice remaining amount: ' || l_invoices_tbl(k).REMAINING_AMOUNT);
564:
565: --l_receipt_amount_remaining := l_cash_receipt_ids(j).RECEIPT_AMOUNT;
566: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, l_api_name || ' - receipt amount: # ' || j || ' =' ||l_cash_receipt_ids(j).RECEIPT_AMOUNT);
567:
568: while l_invoices_tbl(k).REMAINING_AMOUNT <> 0
569: loop
570: -- skip the receipts already exhausted

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

572: exit when l_cash_receipt_ids(j).RECEIPT_AMOUNT > 0;
573: j := j + 1;
574: end loop;
575: l_receipt_amount_remaining := l_cash_receipt_ids(j).RECEIPT_AMOUNT;
576: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, l_api_name || ' - receipt amount remaining: ' || j || '# =' ||l_receipt_amount_remaining);
577:
578: Begin
579: select 'X'
580: into l_found

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

593: -- we have gone thru all the cash receipts and there is not enough
594: -- open receipts in the list to cover this invoice
595: FND_MESSAGE.SET_NAME('LNS', 'LNS_ALL_RECEIPTS_EXHAUSTED');
596: FND_MSG_PUB.Add;
597: LogMessage(FND_LOG.LEVEL_UNEXPECTED, G_PKG_NAME, FND_MSG_PUB.Get(p_encoded => 'F'));
598: RAISE FND_API.G_EXC_ERROR;
599: end if;
600:
601: else

Line 614: logMessage(FND_LOG.LEVEL_STATEMENT, 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);

610: if l_cash_receipt_ids(j).original_currency = l_cash_receipt_ids(j).receipt_currency then
611: l_trans_to_receipt_rate := null;
612: l_receipt_amount_from := null;
613: else
614: logMessage(FND_LOG.LEVEL_STATEMENT, 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);
615: if l_cash_receipt_ids(j).exchange_rate is not null then
616: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, l_api_name || ' - using receipt exchange rate ' || l_cash_receipt_ids(j).exchange_rate);
617: l_trans_to_receipt_rate := l_cash_receipt_ids(j).exchange_rate;
618: else

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

612: l_receipt_amount_from := null;
613: else
614: logMessage(FND_LOG.LEVEL_STATEMENT, 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);
615: if l_cash_receipt_ids(j).exchange_rate is not null then
616: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, l_api_name || ' - using receipt exchange rate ' || l_cash_receipt_ids(j).exchange_rate);
617: l_trans_to_receipt_rate := l_cash_receipt_ids(j).exchange_rate;
618: else
619: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, l_api_name || ' - using loan exchange rate ' || l_loan_exchange_rate);
620: l_trans_to_receipt_rate := l_loan_exchange_rate;

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

615: if l_cash_receipt_ids(j).exchange_rate is not null then
616: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, l_api_name || ' - using receipt exchange rate ' || l_cash_receipt_ids(j).exchange_rate);
617: l_trans_to_receipt_rate := l_cash_receipt_ids(j).exchange_rate;
618: else
619: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, l_api_name || ' - using loan exchange rate ' || l_loan_exchange_rate);
620: l_trans_to_receipt_rate := l_loan_exchange_rate;
621: end if;
622: l_receipt_amount_from := l_amount_to_apply * l_trans_to_receipt_rate;
623: end if;

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

621: end if;
622: l_receipt_amount_from := l_amount_to_apply * l_trans_to_receipt_rate;
623: end if;
624:
625: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, l_api_name || ' - applying cash : ' || l_amount_to_apply);
626: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, l_api_name || ' - applying cash from: ' || l_receipt_amount_from);
627: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, l_api_name || ' - exchange rate: ' || l_trans_to_receipt_rate);
628:
629: lns_payoff_pub.apply_receipt(p_cash_receipt_id => l_cash_receipt_ids(j).CASH_RECEIPT_ID

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

622: l_receipt_amount_from := l_amount_to_apply * l_trans_to_receipt_rate;
623: end if;
624:
625: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, l_api_name || ' - applying cash : ' || l_amount_to_apply);
626: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, l_api_name || ' - applying cash from: ' || l_receipt_amount_from);
627: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, l_api_name || ' - exchange rate: ' || l_trans_to_receipt_rate);
628:
629: lns_payoff_pub.apply_receipt(p_cash_receipt_id => l_cash_receipt_ids(j).CASH_RECEIPT_ID
630: ,p_payment_schedule_id => l_invoices_tbl(k).payment_schedule_id

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

623: end if;
624:
625: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, l_api_name || ' - applying cash : ' || l_amount_to_apply);
626: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, l_api_name || ' - applying cash from: ' || l_receipt_amount_from);
627: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, l_api_name || ' - exchange rate: ' || l_trans_to_receipt_rate);
628:
629: lns_payoff_pub.apply_receipt(p_cash_receipt_id => l_cash_receipt_ids(j).CASH_RECEIPT_ID
630: ,p_payment_schedule_id => l_invoices_tbl(k).payment_schedule_id
631: ,p_apply_amount => l_amount_to_apply -- in loan currency

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

635: ,x_return_status => l_return_status
636: ,x_msg_count => l_msg_count
637: ,x_msg_data => l_msg_data);
638:
639: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, l_api_name || ' - apply cash status: ' || l_return_status);
640: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
641: FND_MESSAGE.SET_NAME('LNS', 'LNS_APPLY_CASH_ERROR');
642: FND_MESSAGE.SET_TOKEN('PARAMETER', 'RECEIPT_NUMBER');
643: FND_MESSAGE.SET_TOKEN('VALUE', l_cash_receipt_ids(j).receipt_number);

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

641: FND_MESSAGE.SET_NAME('LNS', 'LNS_APPLY_CASH_ERROR');
642: FND_MESSAGE.SET_TOKEN('PARAMETER', 'RECEIPT_NUMBER');
643: FND_MESSAGE.SET_TOKEN('VALUE', l_cash_receipt_ids(j).receipt_number);
644: FND_MSG_PUB.Add;
645: LogMessage(FND_LOG.LEVEL_UNEXPECTED, G_PKG_NAME, FND_MSG_PUB.Get(p_encoded => 'F'));
646: RAISE FND_API.G_EXC_ERROR;
647: END IF;
648:
649: l_invoice_amount_remaining := l_invoice_amount_remaining - l_amount_to_apply;

Line 656: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, l_api_name || ' - l_invoice_amount_remaining : ' || l_invoice_amount_remaining);

652: l_cash_receipt_ids(j).RECEIPT_AMOUNT := l_cash_receipt_ids(j).RECEIPT_AMOUNT - l_amount_to_apply;
653: l_amount_to_apply := 0;
654:
655: l_found := null;
656: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, l_api_name || ' - l_invoice_amount_remaining : ' || l_invoice_amount_remaining);
657: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, l_api_name || ' - l_receipt_amount_remaining : ' || l_receipt_amount_remaining);
658: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, l_api_name || ' - l_invoices_tbl(k).REMAINING_AMOUNT : ' || l_invoices_tbl(k).REMAINING_AMOUNT);
659: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, l_api_name || ' - l_cash_receipt_ids(j).RECEIPT_AMOUNT : ' || l_cash_receipt_ids(j).RECEIPT_AMOUNT);
660: end if;

Line 657: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, l_api_name || ' - l_receipt_amount_remaining : ' || l_receipt_amount_remaining);

653: l_amount_to_apply := 0;
654:
655: l_found := null;
656: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, l_api_name || ' - l_invoice_amount_remaining : ' || l_invoice_amount_remaining);
657: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, l_api_name || ' - l_receipt_amount_remaining : ' || l_receipt_amount_remaining);
658: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, l_api_name || ' - l_invoices_tbl(k).REMAINING_AMOUNT : ' || l_invoices_tbl(k).REMAINING_AMOUNT);
659: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, l_api_name || ' - l_cash_receipt_ids(j).RECEIPT_AMOUNT : ' || l_cash_receipt_ids(j).RECEIPT_AMOUNT);
660: end if;
661: j := j + 1;

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

654:
655: l_found := null;
656: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, l_api_name || ' - l_invoice_amount_remaining : ' || l_invoice_amount_remaining);
657: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, l_api_name || ' - l_receipt_amount_remaining : ' || l_receipt_amount_remaining);
658: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, l_api_name || ' - l_invoices_tbl(k).REMAINING_AMOUNT : ' || l_invoices_tbl(k).REMAINING_AMOUNT);
659: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, l_api_name || ' - l_cash_receipt_ids(j).RECEIPT_AMOUNT : ' || l_cash_receipt_ids(j).RECEIPT_AMOUNT);
660: end if;
661: j := j + 1;
662:

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

655: l_found := null;
656: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, l_api_name || ' - l_invoice_amount_remaining : ' || l_invoice_amount_remaining);
657: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, l_api_name || ' - l_receipt_amount_remaining : ' || l_receipt_amount_remaining);
658: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, l_api_name || ' - l_invoices_tbl(k).REMAINING_AMOUNT : ' || l_invoices_tbl(k).REMAINING_AMOUNT);
659: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, l_api_name || ' - l_cash_receipt_ids(j).RECEIPT_AMOUNT : ' || l_cash_receipt_ids(j).RECEIPT_AMOUNT);
660: end if;
661: j := j + 1;
662:
663: end loop;

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

664:
665: end loop;
666: -- end of step 5
667:
668: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, l_api_name || ' - calling LNS_BILLING_BATCH_PUB.processPaidLoans');
669: LNS_BILLING_BATCH_PUB.PROCESS_PAID_LOANS(P_API_VERSION => 1.0
670: ,P_INIT_MSG_LIST => FND_API.G_FALSE
671: ,P_COMMIT => FND_API.G_FALSE
672: ,P_VALIDATION_LEVEL => 100

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

674: ,P_PAYOFF_DATE => p_payoff_date
675: ,x_return_status => l_return_status
676: ,x_msg_count => l_msg_count
677: ,x_msg_data => l_msg_data);
678: LogMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, l_api_name || ' - return status: ' || l_return_status);
679: IF l_return_status = FND_API.G_RET_STS_SUCCESS THEN
680: COMMIT WORK;
681: else
682: RAISE FND_API.G_EXC_ERROR;

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

687: --
688:
689: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
690:
691: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - END');
692:
693: EXCEPTION
694: WHEN FND_API.G_EXC_ERROR THEN
695: ROLLBACK TO processPayoff;

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

696: x_return_status := FND_API.G_RET_STS_ERROR;
697: x_msg_count := l_msg_count;
698: x_msg_data := l_msg_data;
699: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
700: logMessage(FND_LOG.LEVEL_ERROR, G_PKG_NAME, sqlerrm);
701:
702: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
703: ROLLBACK TO processPayoff;
704: x_return_status := FND_API.G_RET_STS_ERROR;

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

704: x_return_status := FND_API.G_RET_STS_ERROR;
705: x_msg_count := l_msg_count;
706: x_msg_data := l_msg_data;
707: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
708: logMessage(FND_LOG.LEVEL_ERROR, G_PKG_NAME, sqlerrm);
709:
710: WHEN OTHERS THEN
711: ROLLBACK TO processPayoff;
712: x_return_status := FND_API.G_RET_STS_ERROR;

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

712: x_return_status := FND_API.G_RET_STS_ERROR;
713: x_msg_count := l_msg_count;
714: x_msg_data := l_msg_data;
715: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
716: logMessage(FND_LOG.LEVEL_ERROR, G_PKG_NAME, sqlerrm);
717:
718: end processPayoff;
719:
720:

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

846: begin
847:
848: l_api_name := 'getLoanInvoices';
849: l_api_version_number := 1;
850: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - BEGIN');
851:
852: -- Standard Start of API savepoint
853: SAVEPOINT getLoanInvoices;
854:

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

889: ,l_gl_date;
890:
891: EXIT WHEN c_loanInvoices%NOTFOUND;
892:
893: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - installment #: ' || l_installment);
894: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - l_cust_trx_id: ' || l_cust_trx_id);
895: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - l_remaining_amt: ' || l_remaining_amt);
896: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - l_due_date: ' || l_due_date);
897: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - l_trx_date: ' || l_trx_date);

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

890:
891: EXIT WHEN c_loanInvoices%NOTFOUND;
892:
893: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - installment #: ' || l_installment);
894: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - l_cust_trx_id: ' || l_cust_trx_id);
895: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - l_remaining_amt: ' || l_remaining_amt);
896: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - l_due_date: ' || l_due_date);
897: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - l_trx_date: ' || l_trx_date);
898: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - l_gl_date: ' || l_gl_date);

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

891: EXIT WHEN c_loanInvoices%NOTFOUND;
892:
893: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - installment #: ' || l_installment);
894: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - l_cust_trx_id: ' || l_cust_trx_id);
895: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - l_remaining_amt: ' || l_remaining_amt);
896: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - l_due_date: ' || l_due_date);
897: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - l_trx_date: ' || l_trx_date);
898: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - l_gl_date: ' || l_gl_date);
899: l_invoices_tbl(i).CUST_TRX_ID := l_cust_trx_id;

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

892:
893: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - installment #: ' || l_installment);
894: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - l_cust_trx_id: ' || l_cust_trx_id);
895: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - l_remaining_amt: ' || l_remaining_amt);
896: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - l_due_date: ' || l_due_date);
897: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - l_trx_date: ' || l_trx_date);
898: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - l_gl_date: ' || l_gl_date);
899: l_invoices_tbl(i).CUST_TRX_ID := l_cust_trx_id;
900: l_invoices_tbl(i).PAYMENT_SCHEDULE_ID:= l_payment_schedule_id;

Line 897: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - l_trx_date: ' || l_trx_date);

893: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - installment #: ' || l_installment);
894: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - l_cust_trx_id: ' || l_cust_trx_id);
895: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - l_remaining_amt: ' || l_remaining_amt);
896: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - l_due_date: ' || l_due_date);
897: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - l_trx_date: ' || l_trx_date);
898: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - l_gl_date: ' || l_gl_date);
899: l_invoices_tbl(i).CUST_TRX_ID := l_cust_trx_id;
900: l_invoices_tbl(i).PAYMENT_SCHEDULE_ID:= l_payment_schedule_id;
901: l_invoices_tbl(i).INSTALLMENT_NUMBER := l_installment;

Line 898: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - l_gl_date: ' || l_gl_date);

894: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - l_cust_trx_id: ' || l_cust_trx_id);
895: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - l_remaining_amt: ' || l_remaining_amt);
896: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - l_due_date: ' || l_due_date);
897: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - l_trx_date: ' || l_trx_date);
898: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - l_gl_date: ' || l_gl_date);
899: l_invoices_tbl(i).CUST_TRX_ID := l_cust_trx_id;
900: l_invoices_tbl(i).PAYMENT_SCHEDULE_ID:= l_payment_schedule_id;
901: l_invoices_tbl(i).INSTALLMENT_NUMBER := l_installment;
902: l_invoices_tbl(i).INVOICE_NUMBER := l_invoice_number;

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

912: close c_loanInvoices;
913:
914: -- get the additional records "to be created"
915: if p_payoff_date is not null then
916: logMessage(FND_LOG.LEVEL_UNEXPECTED, G_PKG_NAME, l_api_name || ' - getting addition TO BE CREATED documents');
917: --dbms_output.put_line('calculating payoof amounts');
918: lns_financials.calculatePayoff(p_api_version => 1.0
919: ,p_init_msg_list => p_init_msg_list
920: ,p_loan_id => p_loan_id

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

924: ,x_msg_count => l_msg_count
925: ,x_msg_data => l_msg_data);
926: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
927: --FND_MESSAGE.SET_NAME('LNS', 'LNS_UPDATE_HEADER_ERROR');
928: LogMessage(FND_LOG.LEVEL_UNEXPECTED, G_PKG_NAME, FND_MSG_PUB.Get(p_encoded => 'F'));
929: RAISE FND_API.G_EXC_ERROR;
930: END IF;
931:
932: logMessage(FND_LOG.LEVEL_UNEXPECTED, G_PKG_NAME, l_api_name || ' - payoff tbl count ' || l_payoff_tbl2.count);

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

928: LogMessage(FND_LOG.LEVEL_UNEXPECTED, G_PKG_NAME, FND_MSG_PUB.Get(p_encoded => 'F'));
929: RAISE FND_API.G_EXC_ERROR;
930: END IF;
931:
932: logMessage(FND_LOG.LEVEL_UNEXPECTED, G_PKG_NAME, l_api_name || ' - payoff tbl count ' || l_payoff_tbl2.count);
933:
934: open c_loanInfo(p_loan_id);
935: fetch c_loanInfo into l_invoice_number, l_installment, l_phase;
936: close c_loanInfo;

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

955:
956: for k in 1..l_payoff_tbl2.count
957: loop
958:
959: logMessage(FND_LOG.LEVEL_UNEXPECTED, G_PKG_NAME, l_api_name || l_payoff_tbl2(k).payoff_purpose);
960: logMessage(FND_LOG.LEVEL_UNEXPECTED, G_PKG_NAME, l_api_name || l_payoff_tbl2(k).unbilled_amount);
961:
962: i := l_invoices_tbl.count;
963:

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

956: for k in 1..l_payoff_tbl2.count
957: loop
958:
959: logMessage(FND_LOG.LEVEL_UNEXPECTED, G_PKG_NAME, l_api_name || l_payoff_tbl2(k).payoff_purpose);
960: logMessage(FND_LOG.LEVEL_UNEXPECTED, G_PKG_NAME, l_api_name || l_payoff_tbl2(k).unbilled_amount);
961:
962: i := l_invoices_tbl.count;
963:
964: if l_payoff_tbl2(k).unbilled_amount <> 0 and l_payoff_tbl2(k).PAYOFF_PURPOSE <> 'FEE' then

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

976: l_invoices_tbl(i).BILLED_FLAG := 'N';
977: /*
978: elsif l_payoff_tbl2(k).unbilled_amount < 0 and l_payoff_tbl2(k).PAYOFF_PURPOSE = 'INT' then
979:
980: logMessage(FND_LOG.LEVEL_UNEXPECTED, G_PKG_NAME, l_api_name || ' - getting last interest documents ');
981: i := l_invoices_tbl.count;
982: -- find the last interest installment we will create a credit memo in that amount
983: -- and we will create an invoice of INT type with
984: open c_lastInterestAmount(p_loan_id);

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

1017: end if;
1018:
1019: end loop;
1020:
1021: logMessage(FND_LOG.LEVEL_UNEXPECTED, G_PKG_NAME, l_api_name || ' - getting last fees ');
1022: i := l_invoices_tbl.count;
1023: open c_fees(p_loan_id, l_phase, l_installment);
1024: loop
1025: i := i + 1;

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

1036: l_invoices_tbl(i).TRANSACTION_TYPE := lns_utility_pub.getDocumentName('FEE');
1037: l_invoices_tbl(i).REMAINING_AMOUNT := l_fee_amount;
1038: l_invoices_tbl(i).PURPOSE := lns_utility_pub.get_lookup_meaning('PAYMENT_APPLICATION_TYPE', 'FEE') || ' - ' || l_fee_name;
1039: l_invoices_tbl(i).BILLED_FLAG := 'N';
1040: logMessage(FND_LOG.LEVEL_UNEXPECTED, G_PKG_NAME, l_api_name || ' - fee found');
1041: end loop;
1042: close c_fees;
1043:
1044: end if;

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

1049: --
1050:
1051: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
1052:
1053: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - END');
1054:
1055: EXCEPTION
1056: WHEN FND_API.G_EXC_ERROR THEN
1057: ROLLBACK TO getLoanInvoices;

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

1058: x_return_status := FND_API.G_RET_STS_ERROR;
1059: x_msg_count := l_msg_count;
1060: x_msg_data := l_msg_data;
1061: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
1062: logMessage(FND_LOG.LEVEL_ERROR, G_PKG_NAME, sqlerrm);
1063:
1064: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1065: ROLLBACK TO getLoanInvoices;
1066: x_return_status := FND_API.G_RET_STS_ERROR;

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

1066: x_return_status := FND_API.G_RET_STS_ERROR;
1067: x_msg_count := l_msg_count;
1068: x_msg_data := l_msg_data;
1069: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
1070: logMessage(FND_LOG.LEVEL_ERROR, G_PKG_NAME, sqlerrm);
1071:
1072: WHEN OTHERS THEN
1073: ROLLBACK TO getLoanInvoices;
1074: x_return_status := FND_API.G_RET_STS_ERROR;

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

1074: x_return_status := FND_API.G_RET_STS_ERROR;
1075: x_msg_count := l_msg_count;
1076: x_msg_data := l_msg_data;
1077: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
1078: logMessage(FND_LOG.LEVEL_ERROR, G_PKG_NAME, sqlerrm);
1079:
1080: end getLoanInvoices;
1081:
1082: /*========================================================================

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

1153:
1154: BEGIN
1155:
1156: l_api_name := 'apply_receipt';
1157: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - BEGIN');
1158:
1159: -- Standard Start of API savepoint
1160: SAVEPOINT APPLY_RECEIPT;
1161:

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

1164:
1165: --
1166: -- Api body
1167: -- --------------------------------------------------------------------
1168: LogMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, l_api_name || ' Applying cash receipt ' || P_CASH_RECEIPT_ID);
1169: LogMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, l_api_name || ' P_PS_ID: ' || P_PAYMENT_SCHEDULE_ID);
1170: --LogMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'P_TRX_LINE_ID: ' || P_TRX_LINE_ID);
1171: LogMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, l_api_name || ' P_APPLY_AMOUNT: ' || P_APPLY_AMOUNT);
1172: LogMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, l_api_name || ' P_APPLY_AMOUNT_FROM: ' || P_APPLY_AMOUNT_FROM);

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

1165: --
1166: -- Api body
1167: -- --------------------------------------------------------------------
1168: LogMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, l_api_name || ' Applying cash receipt ' || P_CASH_RECEIPT_ID);
1169: LogMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, l_api_name || ' P_PS_ID: ' || P_PAYMENT_SCHEDULE_ID);
1170: --LogMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'P_TRX_LINE_ID: ' || P_TRX_LINE_ID);
1171: LogMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, l_api_name || ' P_APPLY_AMOUNT: ' || P_APPLY_AMOUNT);
1172: LogMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, l_api_name || ' P_APPLY_AMOUNT_FROM: ' || P_APPLY_AMOUNT_FROM);
1173: LogMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, l_api_name || ' p_trans_to_receipt_rate: ' || p_trans_to_receipt_rate);

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

1166: -- Api body
1167: -- --------------------------------------------------------------------
1168: LogMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, l_api_name || ' Applying cash receipt ' || P_CASH_RECEIPT_ID);
1169: LogMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, l_api_name || ' P_PS_ID: ' || P_PAYMENT_SCHEDULE_ID);
1170: --LogMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'P_TRX_LINE_ID: ' || P_TRX_LINE_ID);
1171: LogMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, l_api_name || ' P_APPLY_AMOUNT: ' || P_APPLY_AMOUNT);
1172: LogMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, l_api_name || ' P_APPLY_AMOUNT_FROM: ' || P_APPLY_AMOUNT_FROM);
1173: LogMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, l_api_name || ' p_trans_to_receipt_rate: ' || p_trans_to_receipt_rate);
1174:

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

1167: -- --------------------------------------------------------------------
1168: LogMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, l_api_name || ' Applying cash receipt ' || P_CASH_RECEIPT_ID);
1169: LogMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, l_api_name || ' P_PS_ID: ' || P_PAYMENT_SCHEDULE_ID);
1170: --LogMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'P_TRX_LINE_ID: ' || P_TRX_LINE_ID);
1171: LogMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, l_api_name || ' P_APPLY_AMOUNT: ' || P_APPLY_AMOUNT);
1172: LogMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, l_api_name || ' P_APPLY_AMOUNT_FROM: ' || P_APPLY_AMOUNT_FROM);
1173: LogMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, l_api_name || ' p_trans_to_receipt_rate: ' || p_trans_to_receipt_rate);
1174:
1175: /* verify input data */

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

1168: LogMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, l_api_name || ' Applying cash receipt ' || P_CASH_RECEIPT_ID);
1169: LogMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, l_api_name || ' P_PS_ID: ' || P_PAYMENT_SCHEDULE_ID);
1170: --LogMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'P_TRX_LINE_ID: ' || P_TRX_LINE_ID);
1171: LogMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, l_api_name || ' P_APPLY_AMOUNT: ' || P_APPLY_AMOUNT);
1172: LogMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, l_api_name || ' P_APPLY_AMOUNT_FROM: ' || P_APPLY_AMOUNT_FROM);
1173: LogMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, l_api_name || ' p_trans_to_receipt_rate: ' || p_trans_to_receipt_rate);
1174:
1175: /* verify input data */
1176: if P_CASH_RECEIPT_ID is null then

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

1169: LogMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, l_api_name || ' P_PS_ID: ' || P_PAYMENT_SCHEDULE_ID);
1170: --LogMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'P_TRX_LINE_ID: ' || P_TRX_LINE_ID);
1171: LogMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, l_api_name || ' P_APPLY_AMOUNT: ' || P_APPLY_AMOUNT);
1172: LogMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, l_api_name || ' P_APPLY_AMOUNT_FROM: ' || P_APPLY_AMOUNT_FROM);
1173: LogMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, l_api_name || ' p_trans_to_receipt_rate: ' || p_trans_to_receipt_rate);
1174:
1175: /* verify input data */
1176: if P_CASH_RECEIPT_ID is null then
1177: FND_MESSAGE.SET_NAME('LNS', 'LNS_CR_NOT_SET');

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

1175: /* verify input data */
1176: if P_CASH_RECEIPT_ID is null then
1177: FND_MESSAGE.SET_NAME('LNS', 'LNS_CR_NOT_SET');
1178: FND_MSG_PUB.Add;
1179: LogMessage(FND_LOG.LEVEL_UNEXPECTED, G_PKG_NAME, FND_MSG_PUB.Get(p_encoded => 'F'));
1180: RAISE FND_API.G_EXC_ERROR;
1181: end if;
1182:
1183: if P_APPLY_AMOUNT is null or P_APPLY_AMOUNT = 0 then

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

1182:
1183: if P_APPLY_AMOUNT is null or P_APPLY_AMOUNT = 0 then
1184: FND_MESSAGE.SET_NAME('LNS', 'LNS_AMOUNT_NOT_SET');
1185: FND_MSG_PUB.Add;
1186: LogMessage(FND_LOG.LEVEL_UNEXPECTED, G_PKG_NAME, FND_MSG_PUB.Get(p_encoded => 'F'));
1187: RAISE FND_API.G_EXC_ERROR;
1188: end if;
1189:
1190: /* verifying requested qpply amount */

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

1193:
1194: if receipt_cur%NOTFOUND then
1195: FND_MESSAGE.SET_NAME('LNS', 'LNS_NO_CR_FOUND');
1196: FND_MSG_PUB.Add;
1197: LogMessage(FND_LOG.LEVEL_UNEXPECTED, G_PKG_NAME, FND_MSG_PUB.Get(p_encoded => 'F'));
1198: RAISE FND_API.G_EXC_ERROR;
1199: end if;
1200:
1201: close receipt_cur;

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

1202: /*
1203: if l_receipt_rem_amount < P_APPLY_AMOUNT then
1204: FND_MESSAGE.SET_NAME('LNS', 'LNS_NO_CR_FUNDS');
1205: FND_MSG_PUB.Add;
1206: LogMessage(FND_LOG.LEVEL_UNEXPECTED, G_PKG_NAME, FND_MSG_PUB.Get(p_encoded => 'F'));
1207: RAISE FND_API.G_EXC_ERROR;
1208: end if;
1209: */
1210: select

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

1221: l_apply_date := l_due_Date;
1222: else
1223: l_apply_date := p_apply_date;
1224: end if;
1225: LogMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, l_api_name || ' due_date: ' || l_due_date);
1226: LogMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, l_api_name || ' apply_date: ' || l_apply_date);
1227:
1228: /* Applying cash receipt to invoice */
1229: AR_RECEIPT_API_PUB.APPLY(P_API_VERSION => 1.0

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

1222: else
1223: l_apply_date := p_apply_date;
1224: end if;
1225: LogMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, l_api_name || ' due_date: ' || l_due_date);
1226: LogMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, l_api_name || ' apply_date: ' || l_apply_date);
1227:
1228: /* Applying cash receipt to invoice */
1229: AR_RECEIPT_API_PUB.APPLY(P_API_VERSION => 1.0
1230: ,P_INIT_MSG_LIST => FND_API.G_TRUE

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

1239: ,p_amount_applied => P_APPLY_AMOUNT
1240: ,p_amount_applied_from => p_apply_amount_from
1241: ,p_trans_to_receipt_rate => p_trans_to_receipt_rate);
1242:
1243: LogMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, l_api_name || ' return_status: ' || l_return_status);
1244: LogMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, l_api_name || ' msg_data: ' || substr(l_msg_data,1,225));
1245:
1246: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1247: FND_MESSAGE.SET_NAME('LNS', 'LNS_APPL_CR_FAIL');

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

1240: ,p_amount_applied_from => p_apply_amount_from
1241: ,p_trans_to_receipt_rate => p_trans_to_receipt_rate);
1242:
1243: LogMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, l_api_name || ' return_status: ' || l_return_status);
1244: LogMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, l_api_name || ' msg_data: ' || substr(l_msg_data,1,225));
1245:
1246: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1247: FND_MESSAGE.SET_NAME('LNS', 'LNS_APPL_CR_FAIL');
1248: FND_MSG_PUB.Add;

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

1245:
1246: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1247: FND_MESSAGE.SET_NAME('LNS', 'LNS_APPL_CR_FAIL');
1248: FND_MSG_PUB.Add;
1249: LogMessage(FND_LOG.LEVEL_UNEXPECTED, G_PKG_NAME, FND_MSG_PUB.Get(p_encoded => 'F'));
1250: RAISE FND_API.G_EXC_ERROR;
1251: ELSE
1252: null;
1253: --LogMessage(FND_LOG.LEVEL_UNEXPECTED, G_PKG_NAME, 'Successfully applied cash receipt to trx ' || P_TRX_ID || ' line ' || P_TRX_LINE_ID);

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

1249: LogMessage(FND_LOG.LEVEL_UNEXPECTED, G_PKG_NAME, FND_MSG_PUB.Get(p_encoded => 'F'));
1250: RAISE FND_API.G_EXC_ERROR;
1251: ELSE
1252: null;
1253: --LogMessage(FND_LOG.LEVEL_UNEXPECTED, G_PKG_NAME, 'Successfully applied cash receipt to trx ' || P_TRX_ID || ' line ' || P_TRX_LINE_ID);
1254: END IF;
1255: -- END OF BODY OF API
1256:
1257: LogMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - END');

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

1253: --LogMessage(FND_LOG.LEVEL_UNEXPECTED, G_PKG_NAME, 'Successfully applied cash receipt to trx ' || P_TRX_ID || ' line ' || P_TRX_LINE_ID);
1254: END IF;
1255: -- END OF BODY OF API
1256:
1257: LogMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - END');
1258:
1259: EXCEPTION
1260: WHEN FND_API.G_EXC_ERROR THEN
1261: ROLLBACK TO APPLY_RECEIPT;

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

1262: x_return_status := FND_API.G_RET_STS_ERROR;
1263: x_msg_count := l_msg_count;
1264: x_msg_data := l_msg_data;
1265: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
1266: logMessage(FND_LOG.LEVEL_ERROR, G_PKG_NAME, sqlerrm);
1267:
1268: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1269: ROLLBACK TO APPLY_RECEIPT;
1270: x_return_status := FND_API.G_RET_STS_ERROR;

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

1270: x_return_status := FND_API.G_RET_STS_ERROR;
1271: x_msg_count := l_msg_count;
1272: x_msg_data := l_msg_data;
1273: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
1274: logMessage(FND_LOG.LEVEL_ERROR, G_PKG_NAME, sqlerrm);
1275:
1276: WHEN OTHERS THEN
1277: ROLLBACK TO APPLY_RECEIPT;
1278: x_return_status := FND_API.G_RET_STS_ERROR;

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

1278: x_return_status := FND_API.G_RET_STS_ERROR;
1279: x_msg_count := l_msg_count;
1280: x_msg_data := l_msg_data;
1281: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
1282: logMessage(FND_LOG.LEVEL_ERROR, G_PKG_NAME, sqlerrm);
1283: END;
1284:
1285: /*=========================================================================
1286: || PUBLIC FUNCTION getConvertedReceiptAmount

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

1527: begin
1528:
1529: l_api_name := 'getInvoicesForLoanCancellation';
1530: l_api_version_number := 1;
1531: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - BEGIN');
1532:
1533: -- Standard Start of API savepoint
1534: SAVEPOINT getInvoicesForLoanCancellation;
1535:

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

1551: --
1552: -- Api body
1553: -- --------------------------------------------------------------------
1554:
1555: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'Input:');
1556: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'P_LOAN_ID = ' || P_LOAN_ID);
1557: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'p_cancellation_date = ' || p_cancellation_date);
1558:
1559: /* verify input parameters */

Line 1556: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'P_LOAN_ID = ' || P_LOAN_ID);

1552: -- Api body
1553: -- --------------------------------------------------------------------
1554:
1555: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'Input:');
1556: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'P_LOAN_ID = ' || P_LOAN_ID);
1557: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'p_cancellation_date = ' || p_cancellation_date);
1558:
1559: /* verify input parameters */
1560: if P_LOAN_ID is null then

Line 1557: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'p_cancellation_date = ' || p_cancellation_date);

1553: -- --------------------------------------------------------------------
1554:
1555: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'Input:');
1556: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'P_LOAN_ID = ' || P_LOAN_ID);
1557: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'p_cancellation_date = ' || p_cancellation_date);
1558:
1559: /* verify input parameters */
1560: if P_LOAN_ID is null then
1561: FND_MESSAGE.SET_NAME('LNS', 'LNS_INVALID_VALUE');

Line 1582: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'l_invoice_number = ' || l_invoice_number);

1578: l_phase,
1579: l_class,
1580: l_funded_amount;
1581: close c_loanInfo;
1582: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'l_invoice_number = ' || l_invoice_number);
1583: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'l_installment = ' || l_installment);
1584: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'l_phase = ' || l_phase);
1585: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'l_class = ' || l_class);
1586: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'l_funded_amount = ' || l_funded_amount);

Line 1583: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'l_installment = ' || l_installment);

1579: l_class,
1580: l_funded_amount;
1581: close c_loanInfo;
1582: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'l_invoice_number = ' || l_invoice_number);
1583: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'l_installment = ' || l_installment);
1584: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'l_phase = ' || l_phase);
1585: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'l_class = ' || l_class);
1586: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'l_funded_amount = ' || l_funded_amount);
1587:

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

1580: l_funded_amount;
1581: close c_loanInfo;
1582: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'l_invoice_number = ' || l_invoice_number);
1583: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'l_installment = ' || l_installment);
1584: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'l_phase = ' || l_phase);
1585: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'l_class = ' || l_class);
1586: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'l_funded_amount = ' || l_funded_amount);
1587:
1588: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'Calling lns_financials.calcLoanRemainingAmounts...');

Line 1585: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'l_class = ' || l_class);

1581: close c_loanInfo;
1582: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'l_invoice_number = ' || l_invoice_number);
1583: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'l_installment = ' || l_installment);
1584: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'l_phase = ' || l_phase);
1585: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'l_class = ' || l_class);
1586: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'l_funded_amount = ' || l_funded_amount);
1587:
1588: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'Calling lns_financials.calcLoanRemainingAmounts...');
1589: lns_financials.calcLoanRemainingAmounts(p_api_version => 1.0

Line 1586: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'l_funded_amount = ' || l_funded_amount);

1582: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'l_invoice_number = ' || l_invoice_number);
1583: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'l_installment = ' || l_installment);
1584: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'l_phase = ' || l_phase);
1585: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'l_class = ' || l_class);
1586: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'l_funded_amount = ' || l_funded_amount);
1587:
1588: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'Calling lns_financials.calcLoanRemainingAmounts...');
1589: lns_financials.calcLoanRemainingAmounts(p_api_version => 1.0
1590: ,p_init_msg_list => FND_API.G_TRUE

Line 1588: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'Calling lns_financials.calcLoanRemainingAmounts...');

1584: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'l_phase = ' || l_phase);
1585: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'l_class = ' || l_class);
1586: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'l_funded_amount = ' || l_funded_amount);
1587:
1588: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'Calling lns_financials.calcLoanRemainingAmounts...');
1589: lns_financials.calcLoanRemainingAmounts(p_api_version => 1.0
1590: ,p_init_msg_list => FND_API.G_TRUE
1591: ,p_loan_id => p_loan_id
1592: ,p_date => p_cancellation_date

Line 1598: LogMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'l_return_status: ' || l_return_status);

1594: ,x_payoff_tbl => l_payoff_tbl2
1595: ,x_return_status => l_return_status
1596: ,x_msg_count => l_msg_count
1597: ,x_msg_data => l_msg_data);
1598: LogMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'l_return_status: ' || l_return_status);
1599: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1600: LogMessage(FND_LOG.LEVEL_UNEXPECTED, G_PKG_NAME, FND_MSG_PUB.Get(p_encoded => 'F'));
1601: RAISE FND_API.G_EXC_ERROR;
1602: END IF;

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

1596: ,x_msg_count => l_msg_count
1597: ,x_msg_data => l_msg_data);
1598: LogMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'l_return_status: ' || l_return_status);
1599: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1600: LogMessage(FND_LOG.LEVEL_UNEXPECTED, G_PKG_NAME, FND_MSG_PUB.Get(p_encoded => 'F'));
1601: RAISE FND_API.G_EXC_ERROR;
1602: END IF;
1603: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'payoff tbl count = ' || l_payoff_tbl2.count);
1604:

Line 1603: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'payoff tbl count = ' || l_payoff_tbl2.count);

1599: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1600: LogMessage(FND_LOG.LEVEL_UNEXPECTED, G_PKG_NAME, FND_MSG_PUB.Get(p_encoded => 'F'));
1601: RAISE FND_API.G_EXC_ERROR;
1602: END IF;
1603: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'payoff tbl count = ' || l_payoff_tbl2.count);
1604:
1605: open precision_cur(P_LOAN_ID);
1606: fetch precision_cur into l_precision;
1607: close precision_cur;

Line 1630: LogMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'Payoff record ' || k);

1626: -- filling up returned table
1627: i := 0;
1628: for k in 1..l_payoff_tbl2.count loop
1629:
1630: LogMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'Payoff record ' || k);
1631: LogMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'PAYOFF_PURPOSE = ' || l_payoff_tbl2(k).PAYOFF_PURPOSE);
1632: LogMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'BILLED_AMOUNT = ' || l_payoff_tbl2(k).BILLED_AMOUNT);
1633: LogMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'UNBILLED_AMOUNT = ' || l_payoff_tbl2(k).UNBILLED_AMOUNT);
1634: LogMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'TOTAL_AMOUNT = ' || l_payoff_tbl2(k).TOTAL_AMOUNT);

Line 1631: LogMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'PAYOFF_PURPOSE = ' || l_payoff_tbl2(k).PAYOFF_PURPOSE);

1627: i := 0;
1628: for k in 1..l_payoff_tbl2.count loop
1629:
1630: LogMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'Payoff record ' || k);
1631: LogMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'PAYOFF_PURPOSE = ' || l_payoff_tbl2(k).PAYOFF_PURPOSE);
1632: LogMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'BILLED_AMOUNT = ' || l_payoff_tbl2(k).BILLED_AMOUNT);
1633: LogMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'UNBILLED_AMOUNT = ' || l_payoff_tbl2(k).UNBILLED_AMOUNT);
1634: LogMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'TOTAL_AMOUNT = ' || l_payoff_tbl2(k).TOTAL_AMOUNT);
1635:

Line 1632: LogMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'BILLED_AMOUNT = ' || l_payoff_tbl2(k).BILLED_AMOUNT);

1628: for k in 1..l_payoff_tbl2.count loop
1629:
1630: LogMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'Payoff record ' || k);
1631: LogMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'PAYOFF_PURPOSE = ' || l_payoff_tbl2(k).PAYOFF_PURPOSE);
1632: LogMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'BILLED_AMOUNT = ' || l_payoff_tbl2(k).BILLED_AMOUNT);
1633: LogMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'UNBILLED_AMOUNT = ' || l_payoff_tbl2(k).UNBILLED_AMOUNT);
1634: LogMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'TOTAL_AMOUNT = ' || l_payoff_tbl2(k).TOTAL_AMOUNT);
1635:
1636: l_sum_amount := 0;

Line 1633: LogMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'UNBILLED_AMOUNT = ' || l_payoff_tbl2(k).UNBILLED_AMOUNT);

1629:
1630: LogMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'Payoff record ' || k);
1631: LogMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'PAYOFF_PURPOSE = ' || l_payoff_tbl2(k).PAYOFF_PURPOSE);
1632: LogMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'BILLED_AMOUNT = ' || l_payoff_tbl2(k).BILLED_AMOUNT);
1633: LogMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'UNBILLED_AMOUNT = ' || l_payoff_tbl2(k).UNBILLED_AMOUNT);
1634: LogMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'TOTAL_AMOUNT = ' || l_payoff_tbl2(k).TOTAL_AMOUNT);
1635:
1636: l_sum_amount := 0;
1637: l_sum_percent := 0;

Line 1634: LogMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'TOTAL_AMOUNT = ' || l_payoff_tbl2(k).TOTAL_AMOUNT);

1630: LogMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'Payoff record ' || k);
1631: LogMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'PAYOFF_PURPOSE = ' || l_payoff_tbl2(k).PAYOFF_PURPOSE);
1632: LogMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'BILLED_AMOUNT = ' || l_payoff_tbl2(k).BILLED_AMOUNT);
1633: LogMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'UNBILLED_AMOUNT = ' || l_payoff_tbl2(k).UNBILLED_AMOUNT);
1634: LogMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'TOTAL_AMOUNT = ' || l_payoff_tbl2(k).TOTAL_AMOUNT);
1635:
1636: l_sum_amount := 0;
1637: l_sum_percent := 0;
1638: if l_payoff_tbl2(k).unbilled_amount <> 0 and

Line 1644: LogMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'l_remaining_prin = ' || l_remaining_prin);

1640: then
1641:
1642: if l_payoff_tbl2(k).PAYOFF_PURPOSE = 'PRIN' and l_class = 'ERS' then
1643: l_remaining_prin := l_payoff_tbl2(k).unbilled_amount;
1644: LogMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'l_remaining_prin = ' || l_remaining_prin);
1645:
1646: open c_get_loan_lines(p_loan_id);
1647: loop
1648: fetch c_get_loan_lines into

Line 1658: LogMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'l_loan_line_id = ' || l_loan_line_id);

1654: l_remaining_amt,
1655: l_installment1;
1656: exit when c_get_loan_lines%notfound;
1657:
1658: LogMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'l_loan_line_id = ' || l_loan_line_id);
1659: LogMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'l_cust_trx_id = ' || l_cust_trx_id);
1660: LogMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'l_payment_schedule_id = ' || l_payment_schedule_id);
1661: LogMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'l_invoice_number1 = ' || l_invoice_number1);
1662: LogMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'l_trans_type = ' || l_trans_type);

Line 1659: LogMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'l_cust_trx_id = ' || l_cust_trx_id);

1655: l_installment1;
1656: exit when c_get_loan_lines%notfound;
1657:
1658: LogMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'l_loan_line_id = ' || l_loan_line_id);
1659: LogMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'l_cust_trx_id = ' || l_cust_trx_id);
1660: LogMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'l_payment_schedule_id = ' || l_payment_schedule_id);
1661: LogMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'l_invoice_number1 = ' || l_invoice_number1);
1662: LogMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'l_trans_type = ' || l_trans_type);
1663: LogMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'l_remaining_amt = ' || l_remaining_amt);

Line 1660: LogMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'l_payment_schedule_id = ' || l_payment_schedule_id);

1656: exit when c_get_loan_lines%notfound;
1657:
1658: LogMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'l_loan_line_id = ' || l_loan_line_id);
1659: LogMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'l_cust_trx_id = ' || l_cust_trx_id);
1660: LogMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'l_payment_schedule_id = ' || l_payment_schedule_id);
1661: LogMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'l_invoice_number1 = ' || l_invoice_number1);
1662: LogMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'l_trans_type = ' || l_trans_type);
1663: LogMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'l_remaining_amt = ' || l_remaining_amt);
1664:

Line 1661: LogMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'l_invoice_number1 = ' || l_invoice_number1);

1657:
1658: LogMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'l_loan_line_id = ' || l_loan_line_id);
1659: LogMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'l_cust_trx_id = ' || l_cust_trx_id);
1660: LogMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'l_payment_schedule_id = ' || l_payment_schedule_id);
1661: LogMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'l_invoice_number1 = ' || l_invoice_number1);
1662: LogMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'l_trans_type = ' || l_trans_type);
1663: LogMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'l_remaining_amt = ' || l_remaining_amt);
1664:
1665: i := i + 1;

Line 1662: LogMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'l_trans_type = ' || l_trans_type);

1658: LogMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'l_loan_line_id = ' || l_loan_line_id);
1659: LogMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'l_cust_trx_id = ' || l_cust_trx_id);
1660: LogMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'l_payment_schedule_id = ' || l_payment_schedule_id);
1661: LogMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'l_invoice_number1 = ' || l_invoice_number1);
1662: LogMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'l_trans_type = ' || l_trans_type);
1663: LogMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'l_remaining_amt = ' || l_remaining_amt);
1664:
1665: i := i + 1;
1666: l_invoices_tbl(i).CUST_TRX_ID := l_cust_trx_id;

Line 1663: LogMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'l_remaining_amt = ' || l_remaining_amt);

1659: LogMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'l_cust_trx_id = ' || l_cust_trx_id);
1660: LogMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'l_payment_schedule_id = ' || l_payment_schedule_id);
1661: LogMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'l_invoice_number1 = ' || l_invoice_number1);
1662: LogMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'l_trans_type = ' || l_trans_type);
1663: LogMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'l_remaining_amt = ' || l_remaining_amt);
1664:
1665: i := i + 1;
1666: l_invoices_tbl(i).CUST_TRX_ID := l_cust_trx_id;
1667: l_invoices_tbl(i).PAYMENT_SCHEDULE_ID := l_payment_schedule_id;

Line 1681: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'Adding original receivable ' || l_invoices_tbl(i).INVOICE_NUMBER ||

1677: l_invoices_tbl(i).LOAN_LINE_ID := l_loan_line_id;
1678: l_invoices_tbl(i).AMOUNT_TO_PROCESS := round(l_remaining_prin * (l_remaining_amt/l_funded_amount), l_precision);
1679: l_invoices_tbl(i).PERCENT_TO_PROCESS := round(l_remaining_amt*100/l_funded_amount, 4);
1680: l_invoices_tbl(i).BILLED_FLAG := 'N';
1681: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'Adding original receivable ' || l_invoices_tbl(i).INVOICE_NUMBER ||
1682: ' for ' || l_invoices_tbl(i).AMOUNT_TO_PROCESS);
1683:
1684: if (l_sum_amount + l_invoices_tbl(i).AMOUNT_TO_PROCESS) > l_payoff_tbl2(k).unbilled_amount then
1685: l_invoices_tbl(i).AMOUNT_TO_PROCESS := l_payoff_tbl2(k).unbilled_amount - l_sum_amount;

Line 1710: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'Adding ' || l_invoices_tbl(i).PURPOSE ||

1706: l_invoices_tbl(i).PURPOSE := lns_utility_pub.get_lookup_meaning('PAYMENT_APPLICATION_TYPE', l_payoff_tbl2(k).PAYOFF_PURPOSE);
1707: l_invoices_tbl(i).PERCENT_TO_PROCESS := 100 - l_sum_percent;
1708: l_invoices_tbl(i).AMOUNT_TO_PROCESS := round((l_payoff_tbl2(k).unbilled_amount-l_sum_amount), l_precision);
1709: l_invoices_tbl(i).BILLED_FLAG := 'N';
1710: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'Adding ' || l_invoices_tbl(i).PURPOSE ||
1711: ' for ' || l_invoices_tbl(i).AMOUNT_TO_PROCESS);
1712:
1713: end if;
1714: end loop;

Line 1737: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'Adding ' || l_invoices_tbl(i).PURPOSE ||

1733: l_invoices_tbl(i).PURPOSE := lns_utility_pub.get_lookup_meaning('PAYMENT_APPLICATION_TYPE', 'FEE') || ' - ' || l_fee_name;
1734: l_invoices_tbl(i).PERCENT_TO_PROCESS := 100;
1735: l_invoices_tbl(i).AMOUNT_TO_PROCESS := round(l_fee_amount, l_precision);
1736: l_invoices_tbl(i).BILLED_FLAG := 'N';
1737: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'Adding ' || l_invoices_tbl(i).PURPOSE ||
1738: ' for ' || l_invoices_tbl(i).AMOUNT_TO_PROCESS);
1739: end loop;
1740: close c_fees;
1741:

Line 1775: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'Adding billed unpaid ' || l_invoices_tbl(i).PURPOSE || ' (Installment ' ||

1771: l_invoices_tbl(i).BILLED_FLAG := 'Y';
1772: l_invoices_tbl(i).DUE_DATE := l_due_date;
1773: l_invoices_tbl(i).TRX_DATE := l_trx_date;
1774: l_invoices_tbl(i).GL_DATE := l_gl_date;
1775: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'Adding billed unpaid ' || l_invoices_tbl(i).PURPOSE || ' (Installment ' ||
1776: l_invoices_tbl(i).INSTALLMENT_NUMBER || ') for ' || l_invoices_tbl(i).REMAINING_AMOUNT);
1777:
1778: END LOOP;
1779: close unpaid_inv_cur;

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

1784: --
1785:
1786: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
1787:
1788: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - END');
1789:
1790: EXCEPTION
1791: WHEN OTHERS THEN
1792: ROLLBACK TO getInvoicesForLoanCancellation;

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

1791: WHEN OTHERS THEN
1792: ROLLBACK TO getInvoicesForLoanCancellation;
1793: x_return_status := FND_API.G_RET_STS_ERROR;
1794: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
1795: logMessage(FND_LOG.LEVEL_ERROR, G_PKG_NAME, sqlerrm);
1796: end;
1797:
1798:
1799:

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

1850:
1851: begin
1852:
1853: l_api_name := 'validateLoanCancelRequest';
1854: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - BEGIN');
1855:
1856: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'Input:');
1857: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'P_LOAN_ID = ' || P_LOAN_ID);
1858: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'p_cancellation_date = ' || p_cancellation_date);

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

1852:
1853: l_api_name := 'validateLoanCancelRequest';
1854: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - BEGIN');
1855:
1856: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'Input:');
1857: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'P_LOAN_ID = ' || P_LOAN_ID);
1858: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'p_cancellation_date = ' || p_cancellation_date);
1859: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'p_LOAN_CANCELLATION_ID = ' || p_LOAN_CANCELLATION_ID);
1860:

Line 1857: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'P_LOAN_ID = ' || P_LOAN_ID);

1853: l_api_name := 'validateLoanCancelRequest';
1854: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - BEGIN');
1855:
1856: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'Input:');
1857: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'P_LOAN_ID = ' || P_LOAN_ID);
1858: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'p_cancellation_date = ' || p_cancellation_date);
1859: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'p_LOAN_CANCELLATION_ID = ' || p_LOAN_CANCELLATION_ID);
1860:
1861: -- verify input parameters

Line 1858: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'p_cancellation_date = ' || p_cancellation_date);

1854: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - BEGIN');
1855:
1856: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'Input:');
1857: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'P_LOAN_ID = ' || P_LOAN_ID);
1858: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'p_cancellation_date = ' || p_cancellation_date);
1859: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'p_LOAN_CANCELLATION_ID = ' || p_LOAN_CANCELLATION_ID);
1860:
1861: -- verify input parameters
1862: if P_LOAN_ID is null then

Line 1859: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'p_LOAN_CANCELLATION_ID = ' || p_LOAN_CANCELLATION_ID);

1855:
1856: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'Input:');
1857: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'P_LOAN_ID = ' || P_LOAN_ID);
1858: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'p_cancellation_date = ' || p_cancellation_date);
1859: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'p_LOAN_CANCELLATION_ID = ' || p_LOAN_CANCELLATION_ID);
1860:
1861: -- verify input parameters
1862: if P_LOAN_ID is null then
1863: FND_MESSAGE.SET_NAME('LNS', 'LNS_INVALID_VALUE');

Line 1881: LogMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'l_loan_status: ' || l_loan_status);

1877: open loan_details_cur(P_LOAN_ID);
1878: fetch loan_details_cur into l_loan_status;
1879: close loan_details_cur;
1880:
1881: LogMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'l_loan_status: ' || l_loan_status);
1882:
1883: if (l_loan_status <> 'ACTIVE' and
1884: l_loan_status <> 'APPROVED' and
1885: l_loan_status <> 'DEFAULT' and

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

1889: then
1890:
1891: FND_MESSAGE.SET_NAME('LNS', 'LNS_CANCEL_INVAL_LN_STATUS');
1892: FND_MSG_PUB.Add;
1893: LogMessage(FND_LOG.LEVEL_UNEXPECTED, G_PKG_NAME, FND_MSG_PUB.Get(p_encoded => 'F'));
1894: RAISE FND_API.G_EXC_ERROR;
1895:
1896: end if;
1897:

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

1902:
1903: if (l_count > 0) then
1904: FND_MESSAGE.SET_NAME('LNS', 'LNS_CANCEL_ALREADY_EXIST');
1905: FND_MSG_PUB.Add;
1906: LogMessage(FND_LOG.LEVEL_UNEXPECTED, G_PKG_NAME, FND_MSG_PUB.Get(p_encoded => 'F'));
1907: RAISE FND_API.G_EXC_ERROR;
1908: end if;
1909: else
1910: open cancel_request_cur(p_LOAN_CANCELLATION_ID);

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

1913:
1914: if (l_status <> 'PENDING') then
1915: FND_MESSAGE.SET_NAME('LNS', 'LNS_CANCEL_INVAL_STATUS');
1916: FND_MSG_PUB.Add;
1917: LogMessage(FND_LOG.LEVEL_UNEXPECTED, G_PKG_NAME, FND_MSG_PUB.Get(p_encoded => 'F'));
1918: RAISE FND_API.G_EXC_ERROR;
1919: end if;
1920:
1921: if trunc(p_cancellation_date) <> trunc(l_CANCELLATION_DATE) then

Line 1931: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'Calling lns_financials.calcLoanRemainingAmounts...');

1927: end if;
1928:
1929: end if;
1930:
1931: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'Calling lns_financials.calcLoanRemainingAmounts...');
1932: lns_financials.calcLoanRemainingAmounts(p_api_version => 1.0
1933: ,p_init_msg_list => FND_API.G_TRUE
1934: ,p_loan_id => p_loan_id
1935: ,p_date => p_cancellation_date

Line 1941: LogMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'l_return_status: ' || l_return_status);

1937: ,x_payoff_tbl => l_payoff_tbl2
1938: ,x_return_status => l_return_status
1939: ,x_msg_count => l_msg_count
1940: ,x_msg_data => l_msg_data);
1941: LogMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'l_return_status: ' || l_return_status);
1942: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1943: LogMessage(FND_LOG.LEVEL_UNEXPECTED, G_PKG_NAME, FND_MSG_PUB.Get(p_encoded => 'F'));
1944: RAISE FND_API.G_EXC_ERROR;
1945: END IF;

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

1939: ,x_msg_count => l_msg_count
1940: ,x_msg_data => l_msg_data);
1941: LogMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'l_return_status: ' || l_return_status);
1942: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1943: LogMessage(FND_LOG.LEVEL_UNEXPECTED, G_PKG_NAME, FND_MSG_PUB.Get(p_encoded => 'F'));
1944: RAISE FND_API.G_EXC_ERROR;
1945: END IF;
1946: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'payoff tbl count = ' || l_payoff_tbl2.count);
1947:

Line 1946: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'payoff tbl count = ' || l_payoff_tbl2.count);

1942: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1943: LogMessage(FND_LOG.LEVEL_UNEXPECTED, G_PKG_NAME, FND_MSG_PUB.Get(p_encoded => 'F'));
1944: RAISE FND_API.G_EXC_ERROR;
1945: END IF;
1946: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'payoff tbl count = ' || l_payoff_tbl2.count);
1947:
1948: for k in 1..l_payoff_tbl2.count loop
1949: if l_payoff_tbl2(k).PAYOFF_PURPOSE = 'PRIN' then
1950: l_payoff_unbilled_prin := l_payoff_tbl2(k).unbilled_amount;

Line 1984: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'l_payoff_unbilled_prin = ' || l_payoff_unbilled_prin);

1980: end if;
1981:
1982: end loop;
1983:
1984: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'l_payoff_unbilled_prin = ' || l_payoff_unbilled_prin);
1985: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'l_unbilled_prin = ' || l_unbilled_prin);
1986: if l_payoff_unbilled_prin <> l_unbilled_prin then
1987: FND_MESSAGE.SET_NAME('LNS', 'LNS_INVALID_VALUE');
1988: FND_MESSAGE.SET_TOKEN('PARAMETER', 'total unbilled principal amount');

Line 1985: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'l_unbilled_prin = ' || l_unbilled_prin);

1981:
1982: end loop;
1983:
1984: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'l_payoff_unbilled_prin = ' || l_payoff_unbilled_prin);
1985: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'l_unbilled_prin = ' || l_unbilled_prin);
1986: if l_payoff_unbilled_prin <> l_unbilled_prin then
1987: FND_MESSAGE.SET_NAME('LNS', 'LNS_INVALID_VALUE');
1988: FND_MESSAGE.SET_TOKEN('PARAMETER', 'total unbilled principal amount');
1989: FND_MESSAGE.SET_TOKEN('VALUE', l_unbilled_prin);

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

1990: FND_MSG_PUB.ADD;
1991: RAISE FND_API.G_EXC_ERROR;
1992: end if;
1993:
1994: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'l_payoff_billed_prin = ' || l_payoff_billed_prin);
1995: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'l_billed_prin = ' || l_billed_prin);
1996: if l_payoff_billed_prin <> l_billed_prin then
1997: FND_MESSAGE.SET_NAME('LNS', 'LNS_INVALID_VALUE');
1998: FND_MESSAGE.SET_TOKEN('PARAMETER', 'total billed unpaid principal amount');

Line 1995: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'l_billed_prin = ' || l_billed_prin);

1991: RAISE FND_API.G_EXC_ERROR;
1992: end if;
1993:
1994: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'l_payoff_billed_prin = ' || l_payoff_billed_prin);
1995: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'l_billed_prin = ' || l_billed_prin);
1996: if l_payoff_billed_prin <> l_billed_prin then
1997: FND_MESSAGE.SET_NAME('LNS', 'LNS_INVALID_VALUE');
1998: FND_MESSAGE.SET_TOKEN('PARAMETER', 'total billed unpaid principal amount');
1999: FND_MESSAGE.SET_TOKEN('VALUE', l_billed_prin);

Line 2004: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'l_payoff_unbilled_int = ' || l_payoff_unbilled_int);

2000: FND_MSG_PUB.ADD;
2001: RAISE FND_API.G_EXC_ERROR;
2002: end if;
2003:
2004: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'l_payoff_unbilled_int = ' || l_payoff_unbilled_int);
2005: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'l_unbilled_int = ' || l_unbilled_int);
2006: if l_payoff_unbilled_int < l_unbilled_int then
2007: FND_MESSAGE.SET_NAME('LNS', 'LNS_INVALID_VALUE');
2008: FND_MESSAGE.SET_TOKEN('PARAMETER', 'total unbilled interest amount');

Line 2005: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'l_unbilled_int = ' || l_unbilled_int);

2001: RAISE FND_API.G_EXC_ERROR;
2002: end if;
2003:
2004: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'l_payoff_unbilled_int = ' || l_payoff_unbilled_int);
2005: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'l_unbilled_int = ' || l_unbilled_int);
2006: if l_payoff_unbilled_int < l_unbilled_int then
2007: FND_MESSAGE.SET_NAME('LNS', 'LNS_INVALID_VALUE');
2008: FND_MESSAGE.SET_TOKEN('PARAMETER', 'total unbilled interest amount');
2009: FND_MESSAGE.SET_TOKEN('VALUE', l_unbilled_int);

Line 2014: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'l_payoff_billed_int = ' || l_payoff_billed_int);

2010: FND_MSG_PUB.ADD;
2011: RAISE FND_API.G_EXC_ERROR;
2012: end if;
2013:
2014: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'l_payoff_billed_int = ' || l_payoff_billed_int);
2015: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'l_billed_int = ' || l_billed_int);
2016: if l_payoff_billed_int <> l_billed_int then
2017: FND_MESSAGE.SET_NAME('LNS', 'LNS_INVALID_VALUE');
2018: FND_MESSAGE.SET_TOKEN('PARAMETER', 'total billed unpaid interest amount');

Line 2015: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'l_billed_int = ' || l_billed_int);

2011: RAISE FND_API.G_EXC_ERROR;
2012: end if;
2013:
2014: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'l_payoff_billed_int = ' || l_payoff_billed_int);
2015: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'l_billed_int = ' || l_billed_int);
2016: if l_payoff_billed_int <> l_billed_int then
2017: FND_MESSAGE.SET_NAME('LNS', 'LNS_INVALID_VALUE');
2018: FND_MESSAGE.SET_TOKEN('PARAMETER', 'total billed unpaid interest amount');
2019: FND_MESSAGE.SET_TOKEN('VALUE', l_billed_int);

Line 2024: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'l_payoff_unbilled_fee = ' || l_payoff_unbilled_fee);

2020: FND_MSG_PUB.ADD;
2021: RAISE FND_API.G_EXC_ERROR;
2022: end if;
2023:
2024: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'l_payoff_unbilled_fee = ' || l_payoff_unbilled_fee);
2025: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'l_unbilled_fee = ' || l_unbilled_fee);
2026: if l_payoff_unbilled_fee < l_unbilled_fee then
2027: FND_MESSAGE.SET_NAME('LNS', 'LNS_INVALID_VALUE');
2028: FND_MESSAGE.SET_TOKEN('PARAMETER', 'total unbilled fee amount');

Line 2025: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'l_unbilled_fee = ' || l_unbilled_fee);

2021: RAISE FND_API.G_EXC_ERROR;
2022: end if;
2023:
2024: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'l_payoff_unbilled_fee = ' || l_payoff_unbilled_fee);
2025: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'l_unbilled_fee = ' || l_unbilled_fee);
2026: if l_payoff_unbilled_fee < l_unbilled_fee then
2027: FND_MESSAGE.SET_NAME('LNS', 'LNS_INVALID_VALUE');
2028: FND_MESSAGE.SET_TOKEN('PARAMETER', 'total unbilled fee amount');
2029: FND_MESSAGE.SET_TOKEN('VALUE', l_unbilled_fee);

Line 2034: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'l_payoff_billed_fee = ' || l_payoff_billed_fee);

2030: FND_MSG_PUB.ADD;
2031: RAISE FND_API.G_EXC_ERROR;
2032: end if;
2033:
2034: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'l_payoff_billed_fee = ' || l_payoff_billed_fee);
2035: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'l_billed_fee = ' || l_billed_fee);
2036: if l_payoff_billed_fee <> l_billed_fee then
2037: FND_MESSAGE.SET_NAME('LNS', 'LNS_INVALID_VALUE');
2038: FND_MESSAGE.SET_TOKEN('PARAMETER', 'total billed unpaid fee amount');

Line 2035: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'l_billed_fee = ' || l_billed_fee);

2031: RAISE FND_API.G_EXC_ERROR;
2032: end if;
2033:
2034: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'l_payoff_billed_fee = ' || l_payoff_billed_fee);
2035: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'l_billed_fee = ' || l_billed_fee);
2036: if l_payoff_billed_fee <> l_billed_fee then
2037: FND_MESSAGE.SET_NAME('LNS', 'LNS_INVALID_VALUE');
2038: FND_MESSAGE.SET_TOKEN('PARAMETER', 'total billed unpaid fee amount');
2039: FND_MESSAGE.SET_TOKEN('VALUE', l_billed_fee);

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

2040: FND_MSG_PUB.ADD;
2041: RAISE FND_API.G_EXC_ERROR;
2042: end if;
2043:
2044: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - END');
2045:
2046: end;
2047:
2048:

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

2106:
2107: begin
2108:
2109: l_api_name := 'validateLoanCancelRequest';
2110: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - BEGIN');
2111:
2112: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'Input:');
2113: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'P_LOAN_CANCELLATION_ID = ' || P_LOAN_CANCELLATION_ID);
2114:

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

2108:
2109: l_api_name := 'validateLoanCancelRequest';
2110: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - BEGIN');
2111:
2112: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'Input:');
2113: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'P_LOAN_CANCELLATION_ID = ' || P_LOAN_CANCELLATION_ID);
2114:
2115: -- verify input parameters
2116: if P_LOAN_CANCELLATION_ID is null then

Line 2113: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'P_LOAN_CANCELLATION_ID = ' || P_LOAN_CANCELLATION_ID);

2109: l_api_name := 'validateLoanCancelRequest';
2110: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - BEGIN');
2111:
2112: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'Input:');
2113: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'P_LOAN_CANCELLATION_ID = ' || P_LOAN_CANCELLATION_ID);
2114:
2115: -- verify input parameters
2116: if P_LOAN_CANCELLATION_ID is null then
2117: FND_MESSAGE.SET_NAME('LNS', 'LNS_INVALID_VALUE');

Line 2131: LogMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'l_LOAN_ID: ' || l_LOAN_ID);

2127: l_STATUS,
2128: l_cancellation_date;
2129: close cancel_request_cur;
2130:
2131: LogMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'l_LOAN_ID: ' || l_LOAN_ID);
2132: LogMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'l_STATUS: ' || l_STATUS);
2133: LogMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'l_cancellation_date: ' || l_cancellation_date);
2134:
2135: open loan_details_cur(l_LOAN_ID);

Line 2132: LogMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'l_STATUS: ' || l_STATUS);

2128: l_cancellation_date;
2129: close cancel_request_cur;
2130:
2131: LogMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'l_LOAN_ID: ' || l_LOAN_ID);
2132: LogMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'l_STATUS: ' || l_STATUS);
2133: LogMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'l_cancellation_date: ' || l_cancellation_date);
2134:
2135: open loan_details_cur(l_LOAN_ID);
2136: fetch loan_details_cur into l_loan_status;

Line 2133: LogMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'l_cancellation_date: ' || l_cancellation_date);

2129: close cancel_request_cur;
2130:
2131: LogMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'l_LOAN_ID: ' || l_LOAN_ID);
2132: LogMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'l_STATUS: ' || l_STATUS);
2133: LogMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'l_cancellation_date: ' || l_cancellation_date);
2134:
2135: open loan_details_cur(l_LOAN_ID);
2136: fetch loan_details_cur into l_loan_status;
2137: close loan_details_cur;

Line 2139: LogMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'l_loan_status: ' || l_loan_status);

2135: open loan_details_cur(l_LOAN_ID);
2136: fetch loan_details_cur into l_loan_status;
2137: close loan_details_cur;
2138:
2139: LogMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'l_loan_status: ' || l_loan_status);
2140:
2141: if (l_loan_status <> 'ACTIVE' and
2142: l_loan_status <> 'APPROVED' and
2143: l_loan_status <> 'DEFAULT' and

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

2147: then
2148:
2149: FND_MESSAGE.SET_NAME('LNS', 'LNS_CANCEL_INVAL_LN_STATUS');
2150: FND_MSG_PUB.Add;
2151: LogMessage(FND_LOG.LEVEL_UNEXPECTED, G_PKG_NAME, FND_MSG_PUB.Get(p_encoded => 'F'));
2152: RAISE FND_API.G_EXC_ERROR;
2153:
2154: end if;
2155:

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

2156: if (l_STATUS <> 'PENDING') then
2157:
2158: FND_MESSAGE.SET_NAME('LNS', 'LNS_CANCEL_INVAL_STATUS');
2159: FND_MSG_PUB.Add;
2160: LogMessage(FND_LOG.LEVEL_UNEXPECTED, G_PKG_NAME, FND_MSG_PUB.Get(p_encoded => 'F'));
2161: RAISE FND_API.G_EXC_ERROR;
2162:
2163: end if;
2164:

Line 2167: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'Calling lns_financials.calcLoanRemainingAmounts...');

2163: end if;
2164:
2165: if (P_ACTION = 'APPROVE') then
2166:
2167: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'Calling lns_financials.calcLoanRemainingAmounts...');
2168: lns_financials.calcLoanRemainingAmounts(p_api_version => 1.0
2169: ,p_init_msg_list => FND_API.G_TRUE
2170: ,p_loan_id => l_LOAN_ID
2171: ,p_date => l_cancellation_date

Line 2177: LogMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'l_return_status: ' || l_return_status);

2173: ,x_payoff_tbl => l_payoff_tbl2
2174: ,x_return_status => l_return_status
2175: ,x_msg_count => l_msg_count
2176: ,x_msg_data => l_msg_data);
2177: LogMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'l_return_status: ' || l_return_status);
2178: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2179: LogMessage(FND_LOG.LEVEL_UNEXPECTED, G_PKG_NAME, FND_MSG_PUB.Get(p_encoded => 'F'));
2180: RAISE FND_API.G_EXC_ERROR;
2181: END IF;

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

2175: ,x_msg_count => l_msg_count
2176: ,x_msg_data => l_msg_data);
2177: LogMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'l_return_status: ' || l_return_status);
2178: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2179: LogMessage(FND_LOG.LEVEL_UNEXPECTED, G_PKG_NAME, FND_MSG_PUB.Get(p_encoded => 'F'));
2180: RAISE FND_API.G_EXC_ERROR;
2181: END IF;
2182: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'payoff tbl count = ' || l_payoff_tbl2.count);
2183:

Line 2182: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'payoff tbl count = ' || l_payoff_tbl2.count);

2178: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2179: LogMessage(FND_LOG.LEVEL_UNEXPECTED, G_PKG_NAME, FND_MSG_PUB.Get(p_encoded => 'F'));
2180: RAISE FND_API.G_EXC_ERROR;
2181: END IF;
2182: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'payoff tbl count = ' || l_payoff_tbl2.count);
2183:
2184: for k in 1..l_payoff_tbl2.count loop
2185: if l_payoff_tbl2(k).PAYOFF_PURPOSE = 'PRIN' then
2186: l_payoff_unbilled_prin := l_payoff_tbl2(k).unbilled_amount;

Line 2229: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'l_payoff_unbilled_prin = ' || l_payoff_unbilled_prin);

2225:
2226: end loop;
2227: close cancel_details_cur;
2228:
2229: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'l_payoff_unbilled_prin = ' || l_payoff_unbilled_prin);
2230: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'l_unbilled_prin = ' || l_unbilled_prin);
2231: if l_payoff_unbilled_prin <> l_unbilled_prin then
2232: FND_MESSAGE.SET_NAME('LNS', 'LNS_INVALID_VALUE');
2233: FND_MESSAGE.SET_TOKEN('PARAMETER', 'total unbilled principal amount');

Line 2230: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'l_unbilled_prin = ' || l_unbilled_prin);

2226: end loop;
2227: close cancel_details_cur;
2228:
2229: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'l_payoff_unbilled_prin = ' || l_payoff_unbilled_prin);
2230: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'l_unbilled_prin = ' || l_unbilled_prin);
2231: if l_payoff_unbilled_prin <> l_unbilled_prin then
2232: FND_MESSAGE.SET_NAME('LNS', 'LNS_INVALID_VALUE');
2233: FND_MESSAGE.SET_TOKEN('PARAMETER', 'total unbilled principal amount');
2234: FND_MESSAGE.SET_TOKEN('VALUE', l_unbilled_prin);

Line 2239: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'l_payoff_billed_prin = ' || l_payoff_billed_prin);

2235: FND_MSG_PUB.ADD;
2236: RAISE FND_API.G_EXC_ERROR;
2237: end if;
2238:
2239: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'l_payoff_billed_prin = ' || l_payoff_billed_prin);
2240: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'l_billed_prin = ' || l_billed_prin);
2241: if l_payoff_billed_prin <> l_billed_prin then
2242: FND_MESSAGE.SET_NAME('LNS', 'LNS_INVALID_VALUE');
2243: FND_MESSAGE.SET_TOKEN('PARAMETER', 'total billed unpaid principal amount');

Line 2240: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'l_billed_prin = ' || l_billed_prin);

2236: RAISE FND_API.G_EXC_ERROR;
2237: end if;
2238:
2239: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'l_payoff_billed_prin = ' || l_payoff_billed_prin);
2240: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'l_billed_prin = ' || l_billed_prin);
2241: if l_payoff_billed_prin <> l_billed_prin then
2242: FND_MESSAGE.SET_NAME('LNS', 'LNS_INVALID_VALUE');
2243: FND_MESSAGE.SET_TOKEN('PARAMETER', 'total billed unpaid principal amount');
2244: FND_MESSAGE.SET_TOKEN('VALUE', l_billed_prin);

Line 2249: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'l_payoff_unbilled_int = ' || l_payoff_unbilled_int);

2245: FND_MSG_PUB.ADD;
2246: RAISE FND_API.G_EXC_ERROR;
2247: end if;
2248:
2249: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'l_payoff_unbilled_int = ' || l_payoff_unbilled_int);
2250: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'l_unbilled_int = ' || l_unbilled_int);
2251: if l_payoff_unbilled_int < l_unbilled_int then
2252: FND_MESSAGE.SET_NAME('LNS', 'LNS_INVALID_VALUE');
2253: FND_MESSAGE.SET_TOKEN('PARAMETER', 'total unbilled interest amount');

Line 2250: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'l_unbilled_int = ' || l_unbilled_int);

2246: RAISE FND_API.G_EXC_ERROR;
2247: end if;
2248:
2249: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'l_payoff_unbilled_int = ' || l_payoff_unbilled_int);
2250: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'l_unbilled_int = ' || l_unbilled_int);
2251: if l_payoff_unbilled_int < l_unbilled_int then
2252: FND_MESSAGE.SET_NAME('LNS', 'LNS_INVALID_VALUE');
2253: FND_MESSAGE.SET_TOKEN('PARAMETER', 'total unbilled interest amount');
2254: FND_MESSAGE.SET_TOKEN('VALUE', l_unbilled_int);

Line 2259: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'l_payoff_billed_int = ' || l_payoff_billed_int);

2255: FND_MSG_PUB.ADD;
2256: RAISE FND_API.G_EXC_ERROR;
2257: end if;
2258:
2259: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'l_payoff_billed_int = ' || l_payoff_billed_int);
2260: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'l_billed_int = ' || l_billed_int);
2261: if l_payoff_billed_int <> l_billed_int then
2262: FND_MESSAGE.SET_NAME('LNS', 'LNS_INVALID_VALUE');
2263: FND_MESSAGE.SET_TOKEN('PARAMETER', 'total billed unpaid interest amount');

Line 2260: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'l_billed_int = ' || l_billed_int);

2256: RAISE FND_API.G_EXC_ERROR;
2257: end if;
2258:
2259: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'l_payoff_billed_int = ' || l_payoff_billed_int);
2260: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'l_billed_int = ' || l_billed_int);
2261: if l_payoff_billed_int <> l_billed_int then
2262: FND_MESSAGE.SET_NAME('LNS', 'LNS_INVALID_VALUE');
2263: FND_MESSAGE.SET_TOKEN('PARAMETER', 'total billed unpaid interest amount');
2264: FND_MESSAGE.SET_TOKEN('VALUE', l_billed_int);

Line 2269: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'l_payoff_unbilled_fee = ' || l_payoff_unbilled_fee);

2265: FND_MSG_PUB.ADD;
2266: RAISE FND_API.G_EXC_ERROR;
2267: end if;
2268:
2269: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'l_payoff_unbilled_fee = ' || l_payoff_unbilled_fee);
2270: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'l_unbilled_fee = ' || l_unbilled_fee);
2271: if l_payoff_unbilled_fee < l_unbilled_fee then
2272: FND_MESSAGE.SET_NAME('LNS', 'LNS_INVALID_VALUE');
2273: FND_MESSAGE.SET_TOKEN('PARAMETER', 'total unbilled fee amount');

Line 2270: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'l_unbilled_fee = ' || l_unbilled_fee);

2266: RAISE FND_API.G_EXC_ERROR;
2267: end if;
2268:
2269: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'l_payoff_unbilled_fee = ' || l_payoff_unbilled_fee);
2270: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'l_unbilled_fee = ' || l_unbilled_fee);
2271: if l_payoff_unbilled_fee < l_unbilled_fee then
2272: FND_MESSAGE.SET_NAME('LNS', 'LNS_INVALID_VALUE');
2273: FND_MESSAGE.SET_TOKEN('PARAMETER', 'total unbilled fee amount');
2274: FND_MESSAGE.SET_TOKEN('VALUE', l_unbilled_fee);

Line 2279: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'l_payoff_billed_fee = ' || l_payoff_billed_fee);

2275: FND_MSG_PUB.ADD;
2276: RAISE FND_API.G_EXC_ERROR;
2277: end if;
2278:
2279: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'l_payoff_billed_fee = ' || l_payoff_billed_fee);
2280: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'l_billed_fee = ' || l_billed_fee);
2281: if l_payoff_billed_fee <> l_billed_fee then
2282: FND_MESSAGE.SET_NAME('LNS', 'LNS_INVALID_VALUE');
2283: FND_MESSAGE.SET_TOKEN('PARAMETER', 'total billed unpaid fee amount');

Line 2280: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'l_billed_fee = ' || l_billed_fee);

2276: RAISE FND_API.G_EXC_ERROR;
2277: end if;
2278:
2279: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'l_payoff_billed_fee = ' || l_payoff_billed_fee);
2280: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'l_billed_fee = ' || l_billed_fee);
2281: if l_payoff_billed_fee <> l_billed_fee then
2282: FND_MESSAGE.SET_NAME('LNS', 'LNS_INVALID_VALUE');
2283: FND_MESSAGE.SET_TOKEN('PARAMETER', 'total billed unpaid fee amount');
2284: FND_MESSAGE.SET_TOKEN('VALUE', l_billed_fee);

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

2286: RAISE FND_API.G_EXC_ERROR;
2287: end if;
2288:
2289: end if;
2290: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - END');
2291:
2292: end;
2293:
2294:

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

2337: begin
2338:
2339: l_api_name := 'saveLoanCancelRequest';
2340: l_api_version_number := 1;
2341: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - BEGIN');
2342:
2343: -- Standard Start of API savepoint
2344: SAVEPOINT saveLoanCancelRequest;
2345:

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

2361: --
2362: -- Api body
2363: -- --------------------------------------------------------------------
2364:
2365: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'Input:');
2366: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'P_LOAN_ID = ' || P_LOAN_ID);
2367: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'p_cancellation_date = ' || p_cancellation_date);
2368: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'p_disable_billing = ' || p_disable_billing);
2369: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'p_description = ' || p_description);

Line 2366: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'P_LOAN_ID = ' || P_LOAN_ID);

2362: -- Api body
2363: -- --------------------------------------------------------------------
2364:
2365: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'Input:');
2366: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'P_LOAN_ID = ' || P_LOAN_ID);
2367: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'p_cancellation_date = ' || p_cancellation_date);
2368: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'p_disable_billing = ' || p_disable_billing);
2369: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'p_description = ' || p_description);
2370: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'p_LOAN_CANCELLATION_ID = ' || p_LOAN_CANCELLATION_ID);

Line 2367: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'p_cancellation_date = ' || p_cancellation_date);

2363: -- --------------------------------------------------------------------
2364:
2365: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'Input:');
2366: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'P_LOAN_ID = ' || P_LOAN_ID);
2367: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'p_cancellation_date = ' || p_cancellation_date);
2368: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'p_disable_billing = ' || p_disable_billing);
2369: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'p_description = ' || p_description);
2370: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'p_LOAN_CANCELLATION_ID = ' || p_LOAN_CANCELLATION_ID);
2371: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'p_action = ' || p_action);

Line 2368: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'p_disable_billing = ' || p_disable_billing);

2364:
2365: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'Input:');
2366: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'P_LOAN_ID = ' || P_LOAN_ID);
2367: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'p_cancellation_date = ' || p_cancellation_date);
2368: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'p_disable_billing = ' || p_disable_billing);
2369: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'p_description = ' || p_description);
2370: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'p_LOAN_CANCELLATION_ID = ' || p_LOAN_CANCELLATION_ID);
2371: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'p_action = ' || p_action);
2372:

Line 2369: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'p_description = ' || p_description);

2365: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'Input:');
2366: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'P_LOAN_ID = ' || P_LOAN_ID);
2367: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'p_cancellation_date = ' || p_cancellation_date);
2368: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'p_disable_billing = ' || p_disable_billing);
2369: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'p_description = ' || p_description);
2370: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'p_LOAN_CANCELLATION_ID = ' || p_LOAN_CANCELLATION_ID);
2371: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'p_action = ' || p_action);
2372:
2373: if p_action = 'INSERT' then

Line 2370: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'p_LOAN_CANCELLATION_ID = ' || p_LOAN_CANCELLATION_ID);

2366: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'P_LOAN_ID = ' || P_LOAN_ID);
2367: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'p_cancellation_date = ' || p_cancellation_date);
2368: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'p_disable_billing = ' || p_disable_billing);
2369: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'p_description = ' || p_description);
2370: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'p_LOAN_CANCELLATION_ID = ' || p_LOAN_CANCELLATION_ID);
2371: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'p_action = ' || p_action);
2372:
2373: if p_action = 'INSERT' then
2374: validateLoanCancelRequest(p_loan_id => P_LOAN_ID

Line 2371: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'p_action = ' || p_action);

2367: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'p_cancellation_date = ' || p_cancellation_date);
2368: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'p_disable_billing = ' || p_disable_billing);
2369: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'p_description = ' || p_description);
2370: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'p_LOAN_CANCELLATION_ID = ' || p_LOAN_CANCELLATION_ID);
2371: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'p_action = ' || p_action);
2372:
2373: if p_action = 'INSERT' then
2374: validateLoanCancelRequest(p_loan_id => P_LOAN_ID
2375: ,p_cancellation_date => p_cancellation_date

Line 2390: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'l_description = ' || l_description);

2386: fetch precision_cur into l_precision;
2387: close precision_cur;
2388:
2389: l_description := substr(p_description, 1, 30);
2390: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'l_description = ' || l_description);
2391:
2392: if p_action = 'INSERT' then
2393: if p_LOAN_CANCELLATION_ID is null then
2394: select LNS_LOAN_CANCELLATIONS_S.NEXTVAL into p_LOAN_CANCELLATION_ID from dual;

Line 2397: LogMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'Inserting into LNS_LOAN_CANCELLATIONS...');

2393: if p_LOAN_CANCELLATION_ID is null then
2394: select LNS_LOAN_CANCELLATIONS_S.NEXTVAL into p_LOAN_CANCELLATION_ID from dual;
2395: end if;
2396:
2397: LogMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'Inserting into LNS_LOAN_CANCELLATIONS...');
2398: insert into LNS_LOAN_CANCELLATIONS
2399: (LOAN_CANCELLATION_ID
2400: ,LOAN_ID
2401: ,DESCRIPTION

Line 2426: LogMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'Done');

2422: ,lns_utility_pub.created_by
2423: ,sysdate
2424: ,lns_utility_pub.last_updated_by
2425: ,lns_utility_pub.LAST_UPDATE_LOGIN);
2426: LogMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'Done');
2427: else
2428: LogMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'Updating into LNS_LOAN_CANCELLATIONS...');
2429: update LNS_LOAN_CANCELLATIONS set
2430: DESCRIPTION = l_description

Line 2428: LogMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'Updating into LNS_LOAN_CANCELLATIONS...');

2424: ,lns_utility_pub.last_updated_by
2425: ,lns_utility_pub.LAST_UPDATE_LOGIN);
2426: LogMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'Done');
2427: else
2428: LogMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'Updating into LNS_LOAN_CANCELLATIONS...');
2429: update LNS_LOAN_CANCELLATIONS set
2430: DESCRIPTION = l_description
2431: ,OBJECT_VERSION_NUMBER = OBJECT_VERSION_NUMBER + 1
2432: ,LAST_UPDATE_DATE = sysdate

Line 2436: LogMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'Done');

2432: ,LAST_UPDATE_DATE = sysdate
2433: ,LAST_UPDATED_BY = LNS_UTILITY_PUB.LAST_UPDATED_BY
2434: ,LAST_UPDATE_LOGIN = LNS_UTILITY_PUB.LAST_UPDATE_LOGIN
2435: where LOAN_CANCELLATION_ID = p_LOAN_CANCELLATION_ID;
2436: LogMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'Done');
2437: end if;
2438:
2439: -- save all cancellation details in table
2440: for i in 1..p_cancel_details_tbl.count loop

Line 2442: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'Invoice #' || i);

2438:
2439: -- save all cancellation details in table
2440: for i in 1..p_cancel_details_tbl.count loop
2441:
2442: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'Invoice #' || i);
2443: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'LOAN_CANCEL_DETAIL_ID = ' || p_cancel_details_tbl(i).LOAN_CANCEL_DETAIL_ID);
2444: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'INVOICE_NUMBER = ' || p_cancel_details_tbl(i).INVOICE_NUMBER);
2445: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'INSTALLMENT_NUMBER = ' || p_cancel_details_tbl(i).INSTALLMENT_NUMBER);
2446: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'TRANSACTION_TYPE = ' || p_cancel_details_tbl(i).TRANSACTION_TYPE);

Line 2443: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'LOAN_CANCEL_DETAIL_ID = ' || p_cancel_details_tbl(i).LOAN_CANCEL_DETAIL_ID);

2439: -- save all cancellation details in table
2440: for i in 1..p_cancel_details_tbl.count loop
2441:
2442: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'Invoice #' || i);
2443: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'LOAN_CANCEL_DETAIL_ID = ' || p_cancel_details_tbl(i).LOAN_CANCEL_DETAIL_ID);
2444: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'INVOICE_NUMBER = ' || p_cancel_details_tbl(i).INVOICE_NUMBER);
2445: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'INSTALLMENT_NUMBER = ' || p_cancel_details_tbl(i).INSTALLMENT_NUMBER);
2446: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'TRANSACTION_TYPE = ' || p_cancel_details_tbl(i).TRANSACTION_TYPE);
2447: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'PURPOSE_CODE = ' || p_cancel_details_tbl(i).PURPOSE_CODE);

Line 2444: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'INVOICE_NUMBER = ' || p_cancel_details_tbl(i).INVOICE_NUMBER);

2440: for i in 1..p_cancel_details_tbl.count loop
2441:
2442: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'Invoice #' || i);
2443: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'LOAN_CANCEL_DETAIL_ID = ' || p_cancel_details_tbl(i).LOAN_CANCEL_DETAIL_ID);
2444: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'INVOICE_NUMBER = ' || p_cancel_details_tbl(i).INVOICE_NUMBER);
2445: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'INSTALLMENT_NUMBER = ' || p_cancel_details_tbl(i).INSTALLMENT_NUMBER);
2446: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'TRANSACTION_TYPE = ' || p_cancel_details_tbl(i).TRANSACTION_TYPE);
2447: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'PURPOSE_CODE = ' || p_cancel_details_tbl(i).PURPOSE_CODE);
2448: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'PURPOSE = ' || p_cancel_details_tbl(i).PURPOSE);

Line 2445: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'INSTALLMENT_NUMBER = ' || p_cancel_details_tbl(i).INSTALLMENT_NUMBER);

2441:
2442: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'Invoice #' || i);
2443: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'LOAN_CANCEL_DETAIL_ID = ' || p_cancel_details_tbl(i).LOAN_CANCEL_DETAIL_ID);
2444: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'INVOICE_NUMBER = ' || p_cancel_details_tbl(i).INVOICE_NUMBER);
2445: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'INSTALLMENT_NUMBER = ' || p_cancel_details_tbl(i).INSTALLMENT_NUMBER);
2446: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'TRANSACTION_TYPE = ' || p_cancel_details_tbl(i).TRANSACTION_TYPE);
2447: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'PURPOSE_CODE = ' || p_cancel_details_tbl(i).PURPOSE_CODE);
2448: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'PURPOSE = ' || p_cancel_details_tbl(i).PURPOSE);
2449: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'REMAINING_AMOUNT = ' || p_cancel_details_tbl(i).REMAINING_AMOUNT);

Line 2446: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'TRANSACTION_TYPE = ' || p_cancel_details_tbl(i).TRANSACTION_TYPE);

2442: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'Invoice #' || i);
2443: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'LOAN_CANCEL_DETAIL_ID = ' || p_cancel_details_tbl(i).LOAN_CANCEL_DETAIL_ID);
2444: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'INVOICE_NUMBER = ' || p_cancel_details_tbl(i).INVOICE_NUMBER);
2445: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'INSTALLMENT_NUMBER = ' || p_cancel_details_tbl(i).INSTALLMENT_NUMBER);
2446: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'TRANSACTION_TYPE = ' || p_cancel_details_tbl(i).TRANSACTION_TYPE);
2447: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'PURPOSE_CODE = ' || p_cancel_details_tbl(i).PURPOSE_CODE);
2448: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'PURPOSE = ' || p_cancel_details_tbl(i).PURPOSE);
2449: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'REMAINING_AMOUNT = ' || p_cancel_details_tbl(i).REMAINING_AMOUNT);
2450: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'PERCENT_TO_PROCESS = ' || p_cancel_details_tbl(i).PERCENT_TO_PROCESS);

Line 2447: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'PURPOSE_CODE = ' || p_cancel_details_tbl(i).PURPOSE_CODE);

2443: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'LOAN_CANCEL_DETAIL_ID = ' || p_cancel_details_tbl(i).LOAN_CANCEL_DETAIL_ID);
2444: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'INVOICE_NUMBER = ' || p_cancel_details_tbl(i).INVOICE_NUMBER);
2445: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'INSTALLMENT_NUMBER = ' || p_cancel_details_tbl(i).INSTALLMENT_NUMBER);
2446: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'TRANSACTION_TYPE = ' || p_cancel_details_tbl(i).TRANSACTION_TYPE);
2447: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'PURPOSE_CODE = ' || p_cancel_details_tbl(i).PURPOSE_CODE);
2448: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'PURPOSE = ' || p_cancel_details_tbl(i).PURPOSE);
2449: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'REMAINING_AMOUNT = ' || p_cancel_details_tbl(i).REMAINING_AMOUNT);
2450: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'PERCENT_TO_PROCESS = ' || p_cancel_details_tbl(i).PERCENT_TO_PROCESS);
2451: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'AMOUNT_TO_PROCESS = ' || p_cancel_details_tbl(i).AMOUNT_TO_PROCESS);

Line 2448: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'PURPOSE = ' || p_cancel_details_tbl(i).PURPOSE);

2444: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'INVOICE_NUMBER = ' || p_cancel_details_tbl(i).INVOICE_NUMBER);
2445: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'INSTALLMENT_NUMBER = ' || p_cancel_details_tbl(i).INSTALLMENT_NUMBER);
2446: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'TRANSACTION_TYPE = ' || p_cancel_details_tbl(i).TRANSACTION_TYPE);
2447: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'PURPOSE_CODE = ' || p_cancel_details_tbl(i).PURPOSE_CODE);
2448: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'PURPOSE = ' || p_cancel_details_tbl(i).PURPOSE);
2449: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'REMAINING_AMOUNT = ' || p_cancel_details_tbl(i).REMAINING_AMOUNT);
2450: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'PERCENT_TO_PROCESS = ' || p_cancel_details_tbl(i).PERCENT_TO_PROCESS);
2451: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'AMOUNT_TO_PROCESS = ' || p_cancel_details_tbl(i).AMOUNT_TO_PROCESS);
2452: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'DUE_DATE = ' || p_cancel_details_tbl(i).DUE_DATE);

Line 2449: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'REMAINING_AMOUNT = ' || p_cancel_details_tbl(i).REMAINING_AMOUNT);

2445: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'INSTALLMENT_NUMBER = ' || p_cancel_details_tbl(i).INSTALLMENT_NUMBER);
2446: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'TRANSACTION_TYPE = ' || p_cancel_details_tbl(i).TRANSACTION_TYPE);
2447: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'PURPOSE_CODE = ' || p_cancel_details_tbl(i).PURPOSE_CODE);
2448: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'PURPOSE = ' || p_cancel_details_tbl(i).PURPOSE);
2449: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'REMAINING_AMOUNT = ' || p_cancel_details_tbl(i).REMAINING_AMOUNT);
2450: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'PERCENT_TO_PROCESS = ' || p_cancel_details_tbl(i).PERCENT_TO_PROCESS);
2451: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'AMOUNT_TO_PROCESS = ' || p_cancel_details_tbl(i).AMOUNT_TO_PROCESS);
2452: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'DUE_DATE = ' || p_cancel_details_tbl(i).DUE_DATE);
2453: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'TRX_DATE = ' || p_cancel_details_tbl(i).TRX_DATE);

Line 2450: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'PERCENT_TO_PROCESS = ' || p_cancel_details_tbl(i).PERCENT_TO_PROCESS);

2446: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'TRANSACTION_TYPE = ' || p_cancel_details_tbl(i).TRANSACTION_TYPE);
2447: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'PURPOSE_CODE = ' || p_cancel_details_tbl(i).PURPOSE_CODE);
2448: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'PURPOSE = ' || p_cancel_details_tbl(i).PURPOSE);
2449: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'REMAINING_AMOUNT = ' || p_cancel_details_tbl(i).REMAINING_AMOUNT);
2450: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'PERCENT_TO_PROCESS = ' || p_cancel_details_tbl(i).PERCENT_TO_PROCESS);
2451: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'AMOUNT_TO_PROCESS = ' || p_cancel_details_tbl(i).AMOUNT_TO_PROCESS);
2452: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'DUE_DATE = ' || p_cancel_details_tbl(i).DUE_DATE);
2453: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'TRX_DATE = ' || p_cancel_details_tbl(i).TRX_DATE);
2454: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'GL_DATE = ' || p_cancel_details_tbl(i).GL_DATE);

Line 2451: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'AMOUNT_TO_PROCESS = ' || p_cancel_details_tbl(i).AMOUNT_TO_PROCESS);

2447: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'PURPOSE_CODE = ' || p_cancel_details_tbl(i).PURPOSE_CODE);
2448: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'PURPOSE = ' || p_cancel_details_tbl(i).PURPOSE);
2449: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'REMAINING_AMOUNT = ' || p_cancel_details_tbl(i).REMAINING_AMOUNT);
2450: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'PERCENT_TO_PROCESS = ' || p_cancel_details_tbl(i).PERCENT_TO_PROCESS);
2451: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'AMOUNT_TO_PROCESS = ' || p_cancel_details_tbl(i).AMOUNT_TO_PROCESS);
2452: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'DUE_DATE = ' || p_cancel_details_tbl(i).DUE_DATE);
2453: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'TRX_DATE = ' || p_cancel_details_tbl(i).TRX_DATE);
2454: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'GL_DATE = ' || p_cancel_details_tbl(i).GL_DATE);
2455: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'LOAN_LINE_ID = ' || p_cancel_details_tbl(i).LOAN_LINE_ID);

Line 2452: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'DUE_DATE = ' || p_cancel_details_tbl(i).DUE_DATE);

2448: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'PURPOSE = ' || p_cancel_details_tbl(i).PURPOSE);
2449: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'REMAINING_AMOUNT = ' || p_cancel_details_tbl(i).REMAINING_AMOUNT);
2450: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'PERCENT_TO_PROCESS = ' || p_cancel_details_tbl(i).PERCENT_TO_PROCESS);
2451: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'AMOUNT_TO_PROCESS = ' || p_cancel_details_tbl(i).AMOUNT_TO_PROCESS);
2452: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'DUE_DATE = ' || p_cancel_details_tbl(i).DUE_DATE);
2453: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'TRX_DATE = ' || p_cancel_details_tbl(i).TRX_DATE);
2454: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'GL_DATE = ' || p_cancel_details_tbl(i).GL_DATE);
2455: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'LOAN_LINE_ID = ' || p_cancel_details_tbl(i).LOAN_LINE_ID);
2456: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'PAYMENT_SCHEDULE_ID = ' || p_cancel_details_tbl(i).PAYMENT_SCHEDULE_ID);

Line 2453: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'TRX_DATE = ' || p_cancel_details_tbl(i).TRX_DATE);

2449: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'REMAINING_AMOUNT = ' || p_cancel_details_tbl(i).REMAINING_AMOUNT);
2450: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'PERCENT_TO_PROCESS = ' || p_cancel_details_tbl(i).PERCENT_TO_PROCESS);
2451: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'AMOUNT_TO_PROCESS = ' || p_cancel_details_tbl(i).AMOUNT_TO_PROCESS);
2452: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'DUE_DATE = ' || p_cancel_details_tbl(i).DUE_DATE);
2453: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'TRX_DATE = ' || p_cancel_details_tbl(i).TRX_DATE);
2454: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'GL_DATE = ' || p_cancel_details_tbl(i).GL_DATE);
2455: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'LOAN_LINE_ID = ' || p_cancel_details_tbl(i).LOAN_LINE_ID);
2456: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'PAYMENT_SCHEDULE_ID = ' || p_cancel_details_tbl(i).PAYMENT_SCHEDULE_ID);
2457: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'CUST_TRX_ID = ' || p_cancel_details_tbl(i).CUST_TRX_ID);

Line 2454: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'GL_DATE = ' || p_cancel_details_tbl(i).GL_DATE);

2450: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'PERCENT_TO_PROCESS = ' || p_cancel_details_tbl(i).PERCENT_TO_PROCESS);
2451: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'AMOUNT_TO_PROCESS = ' || p_cancel_details_tbl(i).AMOUNT_TO_PROCESS);
2452: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'DUE_DATE = ' || p_cancel_details_tbl(i).DUE_DATE);
2453: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'TRX_DATE = ' || p_cancel_details_tbl(i).TRX_DATE);
2454: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'GL_DATE = ' || p_cancel_details_tbl(i).GL_DATE);
2455: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'LOAN_LINE_ID = ' || p_cancel_details_tbl(i).LOAN_LINE_ID);
2456: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'PAYMENT_SCHEDULE_ID = ' || p_cancel_details_tbl(i).PAYMENT_SCHEDULE_ID);
2457: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'CUST_TRX_ID = ' || p_cancel_details_tbl(i).CUST_TRX_ID);
2458: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'BILLED_FLAG = ' || p_cancel_details_tbl(i).BILLED_FLAG);

Line 2455: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'LOAN_LINE_ID = ' || p_cancel_details_tbl(i).LOAN_LINE_ID);

2451: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'AMOUNT_TO_PROCESS = ' || p_cancel_details_tbl(i).AMOUNT_TO_PROCESS);
2452: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'DUE_DATE = ' || p_cancel_details_tbl(i).DUE_DATE);
2453: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'TRX_DATE = ' || p_cancel_details_tbl(i).TRX_DATE);
2454: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'GL_DATE = ' || p_cancel_details_tbl(i).GL_DATE);
2455: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'LOAN_LINE_ID = ' || p_cancel_details_tbl(i).LOAN_LINE_ID);
2456: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'PAYMENT_SCHEDULE_ID = ' || p_cancel_details_tbl(i).PAYMENT_SCHEDULE_ID);
2457: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'CUST_TRX_ID = ' || p_cancel_details_tbl(i).CUST_TRX_ID);
2458: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'BILLED_FLAG = ' || p_cancel_details_tbl(i).BILLED_FLAG);
2459: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'ACTION = ' || p_cancel_details_tbl(i).ACTION);

Line 2456: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'PAYMENT_SCHEDULE_ID = ' || p_cancel_details_tbl(i).PAYMENT_SCHEDULE_ID);

2452: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'DUE_DATE = ' || p_cancel_details_tbl(i).DUE_DATE);
2453: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'TRX_DATE = ' || p_cancel_details_tbl(i).TRX_DATE);
2454: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'GL_DATE = ' || p_cancel_details_tbl(i).GL_DATE);
2455: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'LOAN_LINE_ID = ' || p_cancel_details_tbl(i).LOAN_LINE_ID);
2456: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'PAYMENT_SCHEDULE_ID = ' || p_cancel_details_tbl(i).PAYMENT_SCHEDULE_ID);
2457: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'CUST_TRX_ID = ' || p_cancel_details_tbl(i).CUST_TRX_ID);
2458: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'BILLED_FLAG = ' || p_cancel_details_tbl(i).BILLED_FLAG);
2459: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'ACTION = ' || p_cancel_details_tbl(i).ACTION);
2460:

Line 2457: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'CUST_TRX_ID = ' || p_cancel_details_tbl(i).CUST_TRX_ID);

2453: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'TRX_DATE = ' || p_cancel_details_tbl(i).TRX_DATE);
2454: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'GL_DATE = ' || p_cancel_details_tbl(i).GL_DATE);
2455: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'LOAN_LINE_ID = ' || p_cancel_details_tbl(i).LOAN_LINE_ID);
2456: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'PAYMENT_SCHEDULE_ID = ' || p_cancel_details_tbl(i).PAYMENT_SCHEDULE_ID);
2457: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'CUST_TRX_ID = ' || p_cancel_details_tbl(i).CUST_TRX_ID);
2458: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'BILLED_FLAG = ' || p_cancel_details_tbl(i).BILLED_FLAG);
2459: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'ACTION = ' || p_cancel_details_tbl(i).ACTION);
2460:
2461: if p_action = 'INSERT' then

Line 2458: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'BILLED_FLAG = ' || p_cancel_details_tbl(i).BILLED_FLAG);

2454: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'GL_DATE = ' || p_cancel_details_tbl(i).GL_DATE);
2455: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'LOAN_LINE_ID = ' || p_cancel_details_tbl(i).LOAN_LINE_ID);
2456: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'PAYMENT_SCHEDULE_ID = ' || p_cancel_details_tbl(i).PAYMENT_SCHEDULE_ID);
2457: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'CUST_TRX_ID = ' || p_cancel_details_tbl(i).CUST_TRX_ID);
2458: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'BILLED_FLAG = ' || p_cancel_details_tbl(i).BILLED_FLAG);
2459: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'ACTION = ' || p_cancel_details_tbl(i).ACTION);
2460:
2461: if p_action = 'INSERT' then
2462: if p_cancel_details_tbl(i).LOAN_CANCEL_DETAIL_ID is null then

Line 2459: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'ACTION = ' || p_cancel_details_tbl(i).ACTION);

2455: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'LOAN_LINE_ID = ' || p_cancel_details_tbl(i).LOAN_LINE_ID);
2456: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'PAYMENT_SCHEDULE_ID = ' || p_cancel_details_tbl(i).PAYMENT_SCHEDULE_ID);
2457: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'CUST_TRX_ID = ' || p_cancel_details_tbl(i).CUST_TRX_ID);
2458: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'BILLED_FLAG = ' || p_cancel_details_tbl(i).BILLED_FLAG);
2459: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'ACTION = ' || p_cancel_details_tbl(i).ACTION);
2460:
2461: if p_action = 'INSERT' then
2462: if p_cancel_details_tbl(i).LOAN_CANCEL_DETAIL_ID is null then
2463: select LNS_LOAN_CANCEL_DETAILS_S.NEXTVAL into l_LOAN_CANCEL_DETAIL_ID from dual;

Line 2469: LogMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'Inserting into LNS_LOAN_CANCEL_DETAILS...');

2465: end if;
2466:
2467: p_cancel_details_tbl(i).REMAINING_AMOUNT := round(p_cancel_details_tbl(i).REMAINING_AMOUNT, l_precision);
2468: p_cancel_details_tbl(i).AMOUNT_TO_PROCESS := round(p_cancel_details_tbl(i).AMOUNT_TO_PROCESS, l_precision);
2469: LogMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'Inserting into LNS_LOAN_CANCEL_DETAILS...');
2470: insert into LNS_LOAN_CANCEL_DETAILS
2471: (LOAN_CANCEL_DETAIL_ID
2472: ,LOAN_CANCELLATION_ID
2473: ,LOAN_ID

Line 2526: LogMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'Done');

2522: ,lns_utility_pub.created_by
2523: ,sysdate
2524: ,lns_utility_pub.last_updated_by
2525: ,lns_utility_pub.LAST_UPDATE_LOGIN);
2526: LogMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'Done');
2527: else
2528: LogMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'Updating into LNS_LOAN_CANCEL_DETAILS...');
2529: update LNS_LOAN_CANCEL_DETAILS set
2530: PERCENT_TO_PROCESS = p_cancel_details_tbl(i).PERCENT_TO_PROCESS

Line 2528: LogMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'Updating into LNS_LOAN_CANCEL_DETAILS...');

2524: ,lns_utility_pub.last_updated_by
2525: ,lns_utility_pub.LAST_UPDATE_LOGIN);
2526: LogMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'Done');
2527: else
2528: LogMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'Updating into LNS_LOAN_CANCEL_DETAILS...');
2529: update LNS_LOAN_CANCEL_DETAILS set
2530: PERCENT_TO_PROCESS = p_cancel_details_tbl(i).PERCENT_TO_PROCESS
2531: ,AMOUNT_TO_PROCESS = p_cancel_details_tbl(i).AMOUNT_TO_PROCESS
2532: ,ACTION = p_cancel_details_tbl(i).ACTION

Line 2538: LogMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'Done');

2534: ,LAST_UPDATE_DATE = sysdate
2535: ,LAST_UPDATED_BY = LNS_UTILITY_PUB.LAST_UPDATED_BY
2536: ,LAST_UPDATE_LOGIN = LNS_UTILITY_PUB.LAST_UPDATE_LOGIN
2537: where LOAN_CANCEL_DETAIL_ID = p_cancel_details_tbl(i).LOAN_CANCEL_DETAIL_ID;
2538: LogMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'Done');
2539: end if;
2540:
2541: end loop;
2542:

Line 2556: LogMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'Updating loan header...');

2552:
2553: l_loan_header_rec.loan_id := P_LOAN_ID;
2554: l_loan_header_rec.DISABLE_BILLING_FLAG := 'Y';
2555:
2556: LogMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'Updating loan header...');
2557: LNS_LOAN_HEADER_PUB.UPDATE_LOAN(P_OBJECT_VERSION_NUMBER => l_version_number,
2558: P_LOAN_HEADER_REC => l_loan_header_rec,
2559: P_INIT_MSG_LIST => FND_API.G_FALSE,
2560: X_RETURN_STATUS => l_return_status,

Line 2564: LogMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'l_return_status: ' || l_return_status);

2560: X_RETURN_STATUS => l_return_status,
2561: X_MSG_COUNT => l_msg_count,
2562: X_MSG_DATA => l_msg_data);
2563:
2564: LogMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'l_return_status: ' || l_return_status);
2565:
2566: IF l_return_status = 'S' THEN
2567: LogMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'Successfully update LNS_LOAN_HEADERS_ALL');
2568: ELSE

Line 2567: LogMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'Successfully update LNS_LOAN_HEADERS_ALL');

2563:
2564: LogMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'l_return_status: ' || l_return_status);
2565:
2566: IF l_return_status = 'S' THEN
2567: LogMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'Successfully update LNS_LOAN_HEADERS_ALL');
2568: ELSE
2569: FND_MESSAGE.SET_NAME('LNS', 'LNS_UPD_LOAN_FAIL');
2570: FND_MSG_PUB.Add;
2571: LogMessage(FND_LOG.LEVEL_UNEXPECTED, G_PKG_NAME, FND_MSG_PUB.Get(p_encoded => 'F'));

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

2567: LogMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'Successfully update LNS_LOAN_HEADERS_ALL');
2568: ELSE
2569: FND_MESSAGE.SET_NAME('LNS', 'LNS_UPD_LOAN_FAIL');
2570: FND_MSG_PUB.Add;
2571: LogMessage(FND_LOG.LEVEL_UNEXPECTED, G_PKG_NAME, FND_MSG_PUB.Get(p_encoded => 'F'));
2572: RAISE FND_API.G_EXC_ERROR;
2573: END IF;
2574: end if;
2575:

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

2578: --
2579:
2580: if P_COMMIT = FND_API.G_TRUE then
2581: COMMIT WORK;
2582: LogMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'Commited');
2583: end if;
2584:
2585: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
2586:

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

2583: end if;
2584:
2585: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
2586:
2587: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - END');
2588:
2589: EXCEPTION
2590: WHEN OTHERS THEN
2591: ROLLBACK TO saveLoanCancelRequest;

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

2590: WHEN OTHERS THEN
2591: ROLLBACK TO saveLoanCancelRequest;
2592: x_return_status := FND_API.G_RET_STS_ERROR;
2593: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
2594: logMessage(FND_LOG.LEVEL_ERROR, G_PKG_NAME, sqlerrm);
2595: end;
2596:
2597:
2598:

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

2703: begin
2704:
2705: l_api_name := 'approveLoanCancelRequest';
2706: l_api_version_number := 1;
2707: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - BEGIN');
2708:
2709: -- Standard Start of API savepoint
2710: SAVEPOINT approveLoanCancelRequest;
2711:

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

2727: --
2728: -- Api body
2729: -- --------------------------------------------------------------------
2730:
2731: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'Input:');
2732: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'p_LOAN_CANCELLATION_ID = ' || p_LOAN_CANCELLATION_ID);
2733:
2734: validateLoanCancelRequest(P_LOAN_CANCELLATION_ID => p_LOAN_CANCELLATION_ID
2735: ,p_action => 'APPROVE');

Line 2732: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'p_LOAN_CANCELLATION_ID = ' || p_LOAN_CANCELLATION_ID);

2728: -- Api body
2729: -- --------------------------------------------------------------------
2730:
2731: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'Input:');
2732: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'p_LOAN_CANCELLATION_ID = ' || p_LOAN_CANCELLATION_ID);
2733:
2734: validateLoanCancelRequest(P_LOAN_CANCELLATION_ID => p_LOAN_CANCELLATION_ID
2735: ,p_action => 'APPROVE');
2736:

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

2743: l_loan_class,
2744: l_disable_billing;
2745: close loan_info_cur;
2746:
2747: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'l_loan_id = ' || l_loan_id);
2748: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'l_loan_number = ' || l_loan_number);
2749: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'l_version_number = ' || l_version_number);
2750: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'l_org_id = ' || l_org_id);
2751: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'l_loan_class = ' || l_loan_class);

Line 2748: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'l_loan_number = ' || l_loan_number);

2744: l_disable_billing;
2745: close loan_info_cur;
2746:
2747: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'l_loan_id = ' || l_loan_id);
2748: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'l_loan_number = ' || l_loan_number);
2749: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'l_version_number = ' || l_version_number);
2750: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'l_org_id = ' || l_org_id);
2751: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'l_loan_class = ' || l_loan_class);
2752: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'l_receivables_trx_id = ' || l_receivables_trx_id);

Line 2749: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'l_version_number = ' || l_version_number);

2745: close loan_info_cur;
2746:
2747: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'l_loan_id = ' || l_loan_id);
2748: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'l_loan_number = ' || l_loan_number);
2749: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'l_version_number = ' || l_version_number);
2750: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'l_org_id = ' || l_org_id);
2751: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'l_loan_class = ' || l_loan_class);
2752: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'l_receivables_trx_id = ' || l_receivables_trx_id);
2753:

Line 2750: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'l_org_id = ' || l_org_id);

2746:
2747: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'l_loan_id = ' || l_loan_id);
2748: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'l_loan_number = ' || l_loan_number);
2749: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'l_version_number = ' || l_version_number);
2750: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'l_org_id = ' || l_org_id);
2751: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'l_loan_class = ' || l_loan_class);
2752: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'l_receivables_trx_id = ' || l_receivables_trx_id);
2753:
2754: if l_receivables_trx_id is null then

Line 2751: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'l_loan_class = ' || l_loan_class);

2747: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'l_loan_id = ' || l_loan_id);
2748: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'l_loan_number = ' || l_loan_number);
2749: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'l_version_number = ' || l_version_number);
2750: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'l_org_id = ' || l_org_id);
2751: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'l_loan_class = ' || l_loan_class);
2752: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'l_receivables_trx_id = ' || l_receivables_trx_id);
2753:
2754: if l_receivables_trx_id is null then
2755: -- LogMessage(FND_LOG.LEVEL_UNEXPECTED, 'ERROR: Receivables activity name is not set in the system option.');

Line 2752: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'l_receivables_trx_id = ' || l_receivables_trx_id);

2748: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'l_loan_number = ' || l_loan_number);
2749: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'l_version_number = ' || l_version_number);
2750: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'l_org_id = ' || l_org_id);
2751: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'l_loan_class = ' || l_loan_class);
2752: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'l_receivables_trx_id = ' || l_receivables_trx_id);
2753:
2754: if l_receivables_trx_id is null then
2755: -- LogMessage(FND_LOG.LEVEL_UNEXPECTED, 'ERROR: Receivables activity name is not set in the system option.');
2756: FND_MESSAGE.SET_NAME('LNS', 'LNS_NO_REC_TRX_IN_SYS_OPT');

Line 2755: -- LogMessage(FND_LOG.LEVEL_UNEXPECTED, 'ERROR: Receivables activity name is not set in the system option.');

2751: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'l_loan_class = ' || l_loan_class);
2752: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'l_receivables_trx_id = ' || l_receivables_trx_id);
2753:
2754: if l_receivables_trx_id is null then
2755: -- LogMessage(FND_LOG.LEVEL_UNEXPECTED, 'ERROR: Receivables activity name is not set in the system option.');
2756: FND_MESSAGE.SET_NAME('LNS', 'LNS_NO_REC_TRX_IN_SYS_OPT');
2757: FND_MSG_PUB.Add;
2758: LogMessage(FND_LOG.LEVEL_UNEXPECTED, G_PKG_NAME, FND_MSG_PUB.Get(p_encoded => 'F'));
2759: RAISE FND_API.G_EXC_ERROR;

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

2754: if l_receivables_trx_id is null then
2755: -- LogMessage(FND_LOG.LEVEL_UNEXPECTED, 'ERROR: Receivables activity name is not set in the system option.');
2756: FND_MESSAGE.SET_NAME('LNS', 'LNS_NO_REC_TRX_IN_SYS_OPT');
2757: FND_MSG_PUB.Add;
2758: LogMessage(FND_LOG.LEVEL_UNEXPECTED, G_PKG_NAME, FND_MSG_PUB.Get(p_encoded => 'F'));
2759: RAISE FND_API.G_EXC_ERROR;
2760: end if;
2761:
2762: if l_loan_class = 'DIRECT' then

Line 2764: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'Calling LNS_FUNDING_PUB.APPROVE_CANCEL_REM_DISB...');

2760: end if;
2761:
2762: if l_loan_class = 'DIRECT' then
2763: -- cancel all remaining active disbursements
2764: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'Calling LNS_FUNDING_PUB.APPROVE_CANCEL_REM_DISB...');
2765: LNS_FUNDING_PUB.APPROVE_CANCEL_REM_DISB(
2766: P_API_VERSION => 1.0,
2767: P_INIT_MSG_LIST => FND_API.G_FALSE,
2768: P_COMMIT => FND_API.G_FALSE,

Line 2774: LogMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'l_return_status: ' || l_return_status);

2770: P_LOAN_ID => l_loan_id,
2771: X_RETURN_STATUS => l_return_status,
2772: X_MSG_COUNT => l_msg_count,
2773: X_MSG_DATA => l_msg_data);
2774: LogMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'l_return_status: ' || l_return_status);
2775:
2776: IF l_return_status <> 'S' THEN
2777: RAISE FND_API.G_EXC_ERROR;
2778: END IF;

Line 2781: LogMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'Rejecting all remaining pending orig receivables...');

2777: RAISE FND_API.G_EXC_ERROR;
2778: END IF;
2779: else
2780: -- cancel all remaining pending orig receivables
2781: LogMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'Rejecting all remaining pending orig receivables...');
2782: update LNS_LOAN_LINES set
2783: STATUS = 'REJECTED'
2784: ,LAST_UPDATE_DATE = sysdate
2785: ,LAST_UPDATED_BY = LNS_UTILITY_PUB.LAST_UPDATED_BY

Line 2791: LogMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'Done');

2787: ,APPR_REJECT_DATE = sysdate
2788: ,APPR_REJECT_BY = LNS_UTILITY_PUB.LAST_UPDATED_BY
2789: where LOAN_ID = l_loan_id and
2790: (STATUS is null or STATUS = 'PENDING');
2791: LogMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'Done');
2792: end if;
2793:
2794: i := 0;
2795: open cancel_details_cur(P_LOAN_CANCELLATION_ID);

Line 2836: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'Invoice #' || i);

2832:
2833: y := 0;
2834: for i in 1..l_invoices_tbl.count loop
2835:
2836: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'Invoice #' || i);
2837: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'LOAN_CANCEL_DETAIL_ID = ' || l_invoices_tbl(i).LOAN_CANCEL_DETAIL_ID);
2838: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'PURPOSE_CODE = ' || l_invoices_tbl(i).PURPOSE_CODE);
2839: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'PURPOSE = ' || l_invoices_tbl(i).PURPOSE);
2840: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'PERCENT_TO_PROCESS = ' || l_invoices_tbl(i).PERCENT_TO_PROCESS);

Line 2837: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'LOAN_CANCEL_DETAIL_ID = ' || l_invoices_tbl(i).LOAN_CANCEL_DETAIL_ID);

2833: y := 0;
2834: for i in 1..l_invoices_tbl.count loop
2835:
2836: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'Invoice #' || i);
2837: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'LOAN_CANCEL_DETAIL_ID = ' || l_invoices_tbl(i).LOAN_CANCEL_DETAIL_ID);
2838: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'PURPOSE_CODE = ' || l_invoices_tbl(i).PURPOSE_CODE);
2839: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'PURPOSE = ' || l_invoices_tbl(i).PURPOSE);
2840: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'PERCENT_TO_PROCESS = ' || l_invoices_tbl(i).PERCENT_TO_PROCESS);
2841: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'AMOUNT_TO_PROCESS = ' || l_invoices_tbl(i).AMOUNT_TO_PROCESS);

Line 2838: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'PURPOSE_CODE = ' || l_invoices_tbl(i).PURPOSE_CODE);

2834: for i in 1..l_invoices_tbl.count loop
2835:
2836: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'Invoice #' || i);
2837: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'LOAN_CANCEL_DETAIL_ID = ' || l_invoices_tbl(i).LOAN_CANCEL_DETAIL_ID);
2838: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'PURPOSE_CODE = ' || l_invoices_tbl(i).PURPOSE_CODE);
2839: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'PURPOSE = ' || l_invoices_tbl(i).PURPOSE);
2840: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'PERCENT_TO_PROCESS = ' || l_invoices_tbl(i).PERCENT_TO_PROCESS);
2841: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'AMOUNT_TO_PROCESS = ' || l_invoices_tbl(i).AMOUNT_TO_PROCESS);
2842: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'DUE_DATE = ' || l_invoices_tbl(i).DUE_DATE);

Line 2839: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'PURPOSE = ' || l_invoices_tbl(i).PURPOSE);

2835:
2836: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'Invoice #' || i);
2837: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'LOAN_CANCEL_DETAIL_ID = ' || l_invoices_tbl(i).LOAN_CANCEL_DETAIL_ID);
2838: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'PURPOSE_CODE = ' || l_invoices_tbl(i).PURPOSE_CODE);
2839: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'PURPOSE = ' || l_invoices_tbl(i).PURPOSE);
2840: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'PERCENT_TO_PROCESS = ' || l_invoices_tbl(i).PERCENT_TO_PROCESS);
2841: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'AMOUNT_TO_PROCESS = ' || l_invoices_tbl(i).AMOUNT_TO_PROCESS);
2842: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'DUE_DATE = ' || l_invoices_tbl(i).DUE_DATE);
2843: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'TRX_DATE = ' || l_invoices_tbl(i).TRX_DATE);

Line 2840: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'PERCENT_TO_PROCESS = ' || l_invoices_tbl(i).PERCENT_TO_PROCESS);

2836: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'Invoice #' || i);
2837: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'LOAN_CANCEL_DETAIL_ID = ' || l_invoices_tbl(i).LOAN_CANCEL_DETAIL_ID);
2838: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'PURPOSE_CODE = ' || l_invoices_tbl(i).PURPOSE_CODE);
2839: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'PURPOSE = ' || l_invoices_tbl(i).PURPOSE);
2840: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'PERCENT_TO_PROCESS = ' || l_invoices_tbl(i).PERCENT_TO_PROCESS);
2841: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'AMOUNT_TO_PROCESS = ' || l_invoices_tbl(i).AMOUNT_TO_PROCESS);
2842: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'DUE_DATE = ' || l_invoices_tbl(i).DUE_DATE);
2843: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'TRX_DATE = ' || l_invoices_tbl(i).TRX_DATE);
2844: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'GL_DATE = ' || l_invoices_tbl(i).GL_DATE);

Line 2841: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'AMOUNT_TO_PROCESS = ' || l_invoices_tbl(i).AMOUNT_TO_PROCESS);

2837: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'LOAN_CANCEL_DETAIL_ID = ' || l_invoices_tbl(i).LOAN_CANCEL_DETAIL_ID);
2838: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'PURPOSE_CODE = ' || l_invoices_tbl(i).PURPOSE_CODE);
2839: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'PURPOSE = ' || l_invoices_tbl(i).PURPOSE);
2840: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'PERCENT_TO_PROCESS = ' || l_invoices_tbl(i).PERCENT_TO_PROCESS);
2841: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'AMOUNT_TO_PROCESS = ' || l_invoices_tbl(i).AMOUNT_TO_PROCESS);
2842: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'DUE_DATE = ' || l_invoices_tbl(i).DUE_DATE);
2843: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'TRX_DATE = ' || l_invoices_tbl(i).TRX_DATE);
2844: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'GL_DATE = ' || l_invoices_tbl(i).GL_DATE);
2845: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'BILLED_FLAG = ' || l_invoices_tbl(i).BILLED_FLAG);

Line 2842: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'DUE_DATE = ' || l_invoices_tbl(i).DUE_DATE);

2838: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'PURPOSE_CODE = ' || l_invoices_tbl(i).PURPOSE_CODE);
2839: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'PURPOSE = ' || l_invoices_tbl(i).PURPOSE);
2840: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'PERCENT_TO_PROCESS = ' || l_invoices_tbl(i).PERCENT_TO_PROCESS);
2841: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'AMOUNT_TO_PROCESS = ' || l_invoices_tbl(i).AMOUNT_TO_PROCESS);
2842: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'DUE_DATE = ' || l_invoices_tbl(i).DUE_DATE);
2843: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'TRX_DATE = ' || l_invoices_tbl(i).TRX_DATE);
2844: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'GL_DATE = ' || l_invoices_tbl(i).GL_DATE);
2845: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'BILLED_FLAG = ' || l_invoices_tbl(i).BILLED_FLAG);
2846: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'ACTION = ' || l_invoices_tbl(i).ACTION);

Line 2843: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'TRX_DATE = ' || l_invoices_tbl(i).TRX_DATE);

2839: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'PURPOSE = ' || l_invoices_tbl(i).PURPOSE);
2840: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'PERCENT_TO_PROCESS = ' || l_invoices_tbl(i).PERCENT_TO_PROCESS);
2841: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'AMOUNT_TO_PROCESS = ' || l_invoices_tbl(i).AMOUNT_TO_PROCESS);
2842: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'DUE_DATE = ' || l_invoices_tbl(i).DUE_DATE);
2843: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'TRX_DATE = ' || l_invoices_tbl(i).TRX_DATE);
2844: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'GL_DATE = ' || l_invoices_tbl(i).GL_DATE);
2845: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'BILLED_FLAG = ' || l_invoices_tbl(i).BILLED_FLAG);
2846: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'ACTION = ' || l_invoices_tbl(i).ACTION);
2847: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'CUST_TRX_ID = ' || l_invoices_tbl(i).CUST_TRX_ID);

Line 2844: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'GL_DATE = ' || l_invoices_tbl(i).GL_DATE);

2840: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'PERCENT_TO_PROCESS = ' || l_invoices_tbl(i).PERCENT_TO_PROCESS);
2841: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'AMOUNT_TO_PROCESS = ' || l_invoices_tbl(i).AMOUNT_TO_PROCESS);
2842: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'DUE_DATE = ' || l_invoices_tbl(i).DUE_DATE);
2843: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'TRX_DATE = ' || l_invoices_tbl(i).TRX_DATE);
2844: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'GL_DATE = ' || l_invoices_tbl(i).GL_DATE);
2845: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'BILLED_FLAG = ' || l_invoices_tbl(i).BILLED_FLAG);
2846: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'ACTION = ' || l_invoices_tbl(i).ACTION);
2847: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'CUST_TRX_ID = ' || l_invoices_tbl(i).CUST_TRX_ID);
2848: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'LOAN_LINE_ID = ' || l_invoices_tbl(i).LOAN_LINE_ID);

Line 2845: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'BILLED_FLAG = ' || l_invoices_tbl(i).BILLED_FLAG);

2841: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'AMOUNT_TO_PROCESS = ' || l_invoices_tbl(i).AMOUNT_TO_PROCESS);
2842: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'DUE_DATE = ' || l_invoices_tbl(i).DUE_DATE);
2843: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'TRX_DATE = ' || l_invoices_tbl(i).TRX_DATE);
2844: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'GL_DATE = ' || l_invoices_tbl(i).GL_DATE);
2845: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'BILLED_FLAG = ' || l_invoices_tbl(i).BILLED_FLAG);
2846: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'ACTION = ' || l_invoices_tbl(i).ACTION);
2847: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'CUST_TRX_ID = ' || l_invoices_tbl(i).CUST_TRX_ID);
2848: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'LOAN_LINE_ID = ' || l_invoices_tbl(i).LOAN_LINE_ID);
2849: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'PAYMENT_SCHEDULE_ID = ' || l_invoices_tbl(i).PAYMENT_SCHEDULE_ID);

Line 2846: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'ACTION = ' || l_invoices_tbl(i).ACTION);

2842: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'DUE_DATE = ' || l_invoices_tbl(i).DUE_DATE);
2843: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'TRX_DATE = ' || l_invoices_tbl(i).TRX_DATE);
2844: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'GL_DATE = ' || l_invoices_tbl(i).GL_DATE);
2845: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'BILLED_FLAG = ' || l_invoices_tbl(i).BILLED_FLAG);
2846: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'ACTION = ' || l_invoices_tbl(i).ACTION);
2847: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'CUST_TRX_ID = ' || l_invoices_tbl(i).CUST_TRX_ID);
2848: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'LOAN_LINE_ID = ' || l_invoices_tbl(i).LOAN_LINE_ID);
2849: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'PAYMENT_SCHEDULE_ID = ' || l_invoices_tbl(i).PAYMENT_SCHEDULE_ID);
2850: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'CUST_TRX_ID = ' || l_invoices_tbl(i).CUST_TRX_ID);

Line 2847: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'CUST_TRX_ID = ' || l_invoices_tbl(i).CUST_TRX_ID);

2843: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'TRX_DATE = ' || l_invoices_tbl(i).TRX_DATE);
2844: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'GL_DATE = ' || l_invoices_tbl(i).GL_DATE);
2845: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'BILLED_FLAG = ' || l_invoices_tbl(i).BILLED_FLAG);
2846: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'ACTION = ' || l_invoices_tbl(i).ACTION);
2847: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'CUST_TRX_ID = ' || l_invoices_tbl(i).CUST_TRX_ID);
2848: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'LOAN_LINE_ID = ' || l_invoices_tbl(i).LOAN_LINE_ID);
2849: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'PAYMENT_SCHEDULE_ID = ' || l_invoices_tbl(i).PAYMENT_SCHEDULE_ID);
2850: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'CUST_TRX_ID = ' || l_invoices_tbl(i).CUST_TRX_ID);
2851:

Line 2848: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'LOAN_LINE_ID = ' || l_invoices_tbl(i).LOAN_LINE_ID);

2844: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'GL_DATE = ' || l_invoices_tbl(i).GL_DATE);
2845: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'BILLED_FLAG = ' || l_invoices_tbl(i).BILLED_FLAG);
2846: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'ACTION = ' || l_invoices_tbl(i).ACTION);
2847: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'CUST_TRX_ID = ' || l_invoices_tbl(i).CUST_TRX_ID);
2848: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'LOAN_LINE_ID = ' || l_invoices_tbl(i).LOAN_LINE_ID);
2849: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'PAYMENT_SCHEDULE_ID = ' || l_invoices_tbl(i).PAYMENT_SCHEDULE_ID);
2850: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'CUST_TRX_ID = ' || l_invoices_tbl(i).CUST_TRX_ID);
2851:
2852: if l_invoices_tbl(i).AMOUNT_TO_PROCESS > 0 and

Line 2849: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'PAYMENT_SCHEDULE_ID = ' || l_invoices_tbl(i).PAYMENT_SCHEDULE_ID);

2845: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'BILLED_FLAG = ' || l_invoices_tbl(i).BILLED_FLAG);
2846: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'ACTION = ' || l_invoices_tbl(i).ACTION);
2847: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'CUST_TRX_ID = ' || l_invoices_tbl(i).CUST_TRX_ID);
2848: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'LOAN_LINE_ID = ' || l_invoices_tbl(i).LOAN_LINE_ID);
2849: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'PAYMENT_SCHEDULE_ID = ' || l_invoices_tbl(i).PAYMENT_SCHEDULE_ID);
2850: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'CUST_TRX_ID = ' || l_invoices_tbl(i).CUST_TRX_ID);
2851:
2852: if l_invoices_tbl(i).AMOUNT_TO_PROCESS > 0 and
2853: ((l_invoices_tbl(i).PURPOSE_CODE = 'INT' and l_invoices_tbl(i).BILLED_FLAG = 'N') or

Line 2850: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'CUST_TRX_ID = ' || l_invoices_tbl(i).CUST_TRX_ID);

2846: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'ACTION = ' || l_invoices_tbl(i).ACTION);
2847: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'CUST_TRX_ID = ' || l_invoices_tbl(i).CUST_TRX_ID);
2848: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'LOAN_LINE_ID = ' || l_invoices_tbl(i).LOAN_LINE_ID);
2849: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'PAYMENT_SCHEDULE_ID = ' || l_invoices_tbl(i).PAYMENT_SCHEDULE_ID);
2850: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'CUST_TRX_ID = ' || l_invoices_tbl(i).CUST_TRX_ID);
2851:
2852: if l_invoices_tbl(i).AMOUNT_TO_PROCESS > 0 and
2853: ((l_invoices_tbl(i).PURPOSE_CODE = 'INT' and l_invoices_tbl(i).BILLED_FLAG = 'N') or
2854: (l_invoices_tbl(i).PURPOSE_CODE = 'FEE' and l_invoices_tbl(i).BILLED_FLAG = 'N') or

Line 2872: -- LogMessage(FND_LOG.LEVEL_UNEXPECTED, 'ERROR: Receivables activity name is not set in the system option.');

2868: then
2869:
2870: -- checking for system options values required for adjustment
2871: if l_receivables_trx_id is null then
2872: -- LogMessage(FND_LOG.LEVEL_UNEXPECTED, 'ERROR: Receivables activity name is not set in the system option.');
2873: FND_MESSAGE.SET_NAME('LNS', 'LNS_NO_REC_TRX_IN_SYS_OPT');
2874: FND_MSG_PUB.Add;
2875: LogMessage(FND_LOG.LEVEL_UNEXPECTED, G_PKG_NAME, FND_MSG_PUB.Get(p_encoded => 'F'));
2876: RAISE FND_API.G_EXC_ERROR;

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

2871: if l_receivables_trx_id is null then
2872: -- LogMessage(FND_LOG.LEVEL_UNEXPECTED, 'ERROR: Receivables activity name is not set in the system option.');
2873: FND_MESSAGE.SET_NAME('LNS', 'LNS_NO_REC_TRX_IN_SYS_OPT');
2874: FND_MSG_PUB.Add;
2875: LogMessage(FND_LOG.LEVEL_UNEXPECTED, G_PKG_NAME, FND_MSG_PUB.Get(p_encoded => 'F'));
2876: RAISE FND_API.G_EXC_ERROR;
2877: end if;
2878:
2879: -- do adjustment

Line 2880: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'Calling LNS_BILLING_BATCH_PUB.CREATE_AR_ADJ...');

2876: RAISE FND_API.G_EXC_ERROR;
2877: end if;
2878:
2879: -- do adjustment
2880: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'Calling LNS_BILLING_BATCH_PUB.CREATE_AR_ADJ...');
2881: LNS_BILLING_BATCH_PUB.CREATE_AR_ADJ(P_TYPE => 'INVOICE',
2882: P_PAYMENT_SCHEDULE_ID => l_invoices_tbl(i).PAYMENT_SCHEDULE_ID,
2883: P_RECEIVABLES_TRX_ID => l_receivables_trx_id,
2884: P_AMOUNT => l_invoices_tbl(i).AMOUNT_TO_PROCESS,

Line 2896: LogMessage(FND_LOG.LEVEL_UNEXPECTED, G_PKG_NAME, 'l_adj_number = ' || l_adj_number || ' (l_adj_id = ' || l_adj_id || ')');

2892: X_ADJ_ID => l_adj_id,
2893: X_ADJ_NUMBER => l_adj_number,
2894: P_ORG_ID => l_org_id);
2895:
2896: LogMessage(FND_LOG.LEVEL_UNEXPECTED, G_PKG_NAME, 'l_adj_number = ' || l_adj_number || ' (l_adj_id = ' || l_adj_id || ')');
2897:
2898: if l_adj_id is null and l_adj_number is null then
2899: RAISE FND_API.G_EXC_ERROR;
2900: end if;

Line 2902: LogMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'Updating LNS_LOAN_CANCEL_DETAILS...');

2898: if l_adj_id is null and l_adj_number is null then
2899: RAISE FND_API.G_EXC_ERROR;
2900: end if;
2901:
2902: LogMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'Updating LNS_LOAN_CANCEL_DETAILS...');
2903: update LNS_LOAN_CANCEL_DETAILS set
2904: ADJUSTMENT_NUMBER = l_adj_number
2905: ,ADJUSTMENT_ID = l_adj_id
2906: ,OBJECT_VERSION_NUMBER = OBJECT_VERSION_NUMBER + 1

Line 2911: LogMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'Done');

2907: ,LAST_UPDATE_DATE = sysdate
2908: ,LAST_UPDATED_BY = LNS_UTILITY_PUB.LAST_UPDATED_BY
2909: ,LAST_UPDATE_LOGIN = LNS_UTILITY_PUB.LAST_UPDATE_LOGIN
2910: where LOAN_CANCEL_DETAIL_ID = l_invoices_tbl(i).LOAN_CANCEL_DETAIL_ID;
2911: LogMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'Done');
2912:
2913: end if;
2914:
2915: end loop;

Line 2919: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'Building Invoice header...');

2915: end loop;
2916:
2917: if l_bill_lines_tbl.count > 0 then
2918:
2919: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'Building Invoice header...');
2920: l_bill_headers_tbl(1).HEADER_ID := 101;
2921: l_bill_headers_tbl(1).LOAN_ID := l_loan_id;
2922: l_bill_headers_tbl(1).ASSOC_PAYMENT_NUM := LNS_BILLING_UTIL_PUB.LAST_PAYMENT_NUMBER(l_loan_id);
2923: l_bill_headers_tbl(1).DUE_DATE := l_due_date1;

Line 2926: LogMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'Re-enabling billing...');

2922: l_bill_headers_tbl(1).ASSOC_PAYMENT_NUM := LNS_BILLING_UTIL_PUB.LAST_PAYMENT_NUMBER(l_loan_id);
2923: l_bill_headers_tbl(1).DUE_DATE := l_due_date1;
2924:
2925: if l_disable_billing = 'Y' then
2926: LogMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'Re-enabling billing...');
2927: -- re-enable billing if need to
2928: open loan_version_cur(l_loan_id);
2929: fetch loan_version_cur into l_version_number;
2930: close loan_version_cur;

Line 2942: LogMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'l_return_status: ' || l_return_status);

2938: X_RETURN_STATUS => l_return_status,
2939: X_MSG_COUNT => l_msg_count,
2940: X_MSG_DATA => l_msg_data);
2941:
2942: LogMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'l_return_status: ' || l_return_status);
2943:
2944: IF l_return_status = 'S' THEN
2945: LogMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'Billing is enabled');
2946: ELSE

Line 2945: LogMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'Billing is enabled');

2941:
2942: LogMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'l_return_status: ' || l_return_status);
2943:
2944: IF l_return_status = 'S' THEN
2945: LogMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'Billing is enabled');
2946: ELSE
2947: FND_MESSAGE.SET_NAME('LNS', 'LNS_UPD_LOAN_FAIL');
2948: FND_MSG_PUB.Add;
2949: LogMessage(FND_LOG.LEVEL_UNEXPECTED, G_PKG_NAME, FND_MSG_PUB.Get(p_encoded => 'F'));

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

2945: LogMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'Billing is enabled');
2946: ELSE
2947: FND_MESSAGE.SET_NAME('LNS', 'LNS_UPD_LOAN_FAIL');
2948: FND_MSG_PUB.Add;
2949: LogMessage(FND_LOG.LEVEL_UNEXPECTED, G_PKG_NAME, FND_MSG_PUB.Get(p_encoded => 'F'));
2950: RAISE FND_API.G_EXC_ERROR;
2951: END IF;
2952: end if;
2953:

Line 2954: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'Calling lns_billing_batch_pub.create_offcycle_bills...');

2950: RAISE FND_API.G_EXC_ERROR;
2951: END IF;
2952: end if;
2953:
2954: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'Calling lns_billing_batch_pub.create_offcycle_bills...');
2955: lns_billing_batch_pub.create_offcycle_bills(p_api_version => 1.0
2956: ,p_init_msg_list => FND_API.G_TRUE
2957: ,p_commit => FND_API.G_FALSE
2958: ,p_validation_level => 100

Line 2965: LogMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'l_return_status: ' || l_return_status);

2961: ,x_return_status => l_return_status
2962: ,x_msg_count => l_msg_count
2963: ,x_msg_data => l_msg_data);
2964:
2965: LogMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'l_return_status: ' || l_return_status);
2966: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2967: FND_MESSAGE.SET_NAME('LNS', 'LNS_INVOICE_CREATION_ERROR');
2968: FND_MSG_PUB.Add;
2969: logMessage(FND_LOG.LEVEL_UNEXPECTED, G_PKG_NAME, FND_MSG_PUB.Get(p_encoded => 'F'));

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

2965: LogMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'l_return_status: ' || l_return_status);
2966: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2967: FND_MESSAGE.SET_NAME('LNS', 'LNS_INVOICE_CREATION_ERROR');
2968: FND_MSG_PUB.Add;
2969: logMessage(FND_LOG.LEVEL_UNEXPECTED, G_PKG_NAME, FND_MSG_PUB.Get(p_encoded => 'F'));
2970: RAISE FND_API.G_EXC_ERROR;
2971: END IF;
2972:
2973: -- getting ids for the last billed invoices

Line 2994: LogMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'Setting for newly billed ' || l_invoices_tbl(i).PURPOSE_CODE);

2990: l_invoices_tbl(i).CUST_TRX_ID := l_CUST_TRX_ID;
2991: l_invoices_tbl(i).PAYMENT_SCHEDULE_ID := l_PAYMENT_SCHEDULE_ID;
2992: l_invoices_tbl(i).TRX_DATE := l_trx_date;
2993: l_invoices_tbl(i).GL_DATE := l_gl_date;
2994: LogMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'Setting for newly billed ' || l_invoices_tbl(i).PURPOSE_CODE);
2995: LogMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'CUST_TRX_ID = ' || l_invoices_tbl(i).CUST_TRX_ID);
2996: LogMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'PAYMENT_SCHEDULE_ID = ' || l_invoices_tbl(i).PAYMENT_SCHEDULE_ID);
2997: LogMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'TRX_DATE = ' || l_invoices_tbl(i).TRX_DATE);
2998: LogMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'GL_DATE = ' || l_invoices_tbl(i).GL_DATE);

Line 2995: LogMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'CUST_TRX_ID = ' || l_invoices_tbl(i).CUST_TRX_ID);

2991: l_invoices_tbl(i).PAYMENT_SCHEDULE_ID := l_PAYMENT_SCHEDULE_ID;
2992: l_invoices_tbl(i).TRX_DATE := l_trx_date;
2993: l_invoices_tbl(i).GL_DATE := l_gl_date;
2994: LogMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'Setting for newly billed ' || l_invoices_tbl(i).PURPOSE_CODE);
2995: LogMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'CUST_TRX_ID = ' || l_invoices_tbl(i).CUST_TRX_ID);
2996: LogMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'PAYMENT_SCHEDULE_ID = ' || l_invoices_tbl(i).PAYMENT_SCHEDULE_ID);
2997: LogMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'TRX_DATE = ' || l_invoices_tbl(i).TRX_DATE);
2998: LogMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'GL_DATE = ' || l_invoices_tbl(i).GL_DATE);
2999:

Line 2996: LogMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'PAYMENT_SCHEDULE_ID = ' || l_invoices_tbl(i).PAYMENT_SCHEDULE_ID);

2992: l_invoices_tbl(i).TRX_DATE := l_trx_date;
2993: l_invoices_tbl(i).GL_DATE := l_gl_date;
2994: LogMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'Setting for newly billed ' || l_invoices_tbl(i).PURPOSE_CODE);
2995: LogMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'CUST_TRX_ID = ' || l_invoices_tbl(i).CUST_TRX_ID);
2996: LogMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'PAYMENT_SCHEDULE_ID = ' || l_invoices_tbl(i).PAYMENT_SCHEDULE_ID);
2997: LogMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'TRX_DATE = ' || l_invoices_tbl(i).TRX_DATE);
2998: LogMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'GL_DATE = ' || l_invoices_tbl(i).GL_DATE);
2999:
3000: LogMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'Updating LNS_LOAN_CANCEL_DETAILS...');

Line 2997: LogMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'TRX_DATE = ' || l_invoices_tbl(i).TRX_DATE);

2993: l_invoices_tbl(i).GL_DATE := l_gl_date;
2994: LogMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'Setting for newly billed ' || l_invoices_tbl(i).PURPOSE_CODE);
2995: LogMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'CUST_TRX_ID = ' || l_invoices_tbl(i).CUST_TRX_ID);
2996: LogMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'PAYMENT_SCHEDULE_ID = ' || l_invoices_tbl(i).PAYMENT_SCHEDULE_ID);
2997: LogMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'TRX_DATE = ' || l_invoices_tbl(i).TRX_DATE);
2998: LogMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'GL_DATE = ' || l_invoices_tbl(i).GL_DATE);
2999:
3000: LogMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'Updating LNS_LOAN_CANCEL_DETAILS...');
3001: update LNS_LOAN_CANCEL_DETAILS set

Line 2998: LogMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'GL_DATE = ' || l_invoices_tbl(i).GL_DATE);

2994: LogMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'Setting for newly billed ' || l_invoices_tbl(i).PURPOSE_CODE);
2995: LogMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'CUST_TRX_ID = ' || l_invoices_tbl(i).CUST_TRX_ID);
2996: LogMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'PAYMENT_SCHEDULE_ID = ' || l_invoices_tbl(i).PAYMENT_SCHEDULE_ID);
2997: LogMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'TRX_DATE = ' || l_invoices_tbl(i).TRX_DATE);
2998: LogMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'GL_DATE = ' || l_invoices_tbl(i).GL_DATE);
2999:
3000: LogMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'Updating LNS_LOAN_CANCEL_DETAILS...');
3001: update LNS_LOAN_CANCEL_DETAILS set
3002: CUST_TRX_ID = l_invoices_tbl(i).CUST_TRX_ID

Line 3000: LogMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'Updating LNS_LOAN_CANCEL_DETAILS...');

2996: LogMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'PAYMENT_SCHEDULE_ID = ' || l_invoices_tbl(i).PAYMENT_SCHEDULE_ID);
2997: LogMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'TRX_DATE = ' || l_invoices_tbl(i).TRX_DATE);
2998: LogMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'GL_DATE = ' || l_invoices_tbl(i).GL_DATE);
2999:
3000: LogMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'Updating LNS_LOAN_CANCEL_DETAILS...');
3001: update LNS_LOAN_CANCEL_DETAILS set
3002: CUST_TRX_ID = l_invoices_tbl(i).CUST_TRX_ID
3003: ,PAYMENT_SCHEDULE_ID = l_invoices_tbl(i).PAYMENT_SCHEDULE_ID
3004: ,TRX_DATE = l_invoices_tbl(i).TRX_DATE

Line 3011: LogMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'Done');

3007: ,LAST_UPDATE_DATE = sysdate
3008: ,LAST_UPDATED_BY = LNS_UTILITY_PUB.LAST_UPDATED_BY
3009: ,LAST_UPDATE_LOGIN = LNS_UTILITY_PUB.LAST_UPDATE_LOGIN
3010: where LOAN_CANCEL_DETAIL_ID = l_invoices_tbl(i).LOAN_CANCEL_DETAIL_ID;
3011: LogMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'Done');
3012:
3013: exit;
3014: end if;
3015: end loop;

Line 3033: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'Adjusting down ' || l_invoices_tbl(i).CUST_TRX_ID || '...');

3029:
3030: l_adj_id := null;
3031: l_adj_number := null;
3032:
3033: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'Adjusting down ' || l_invoices_tbl(i).CUST_TRX_ID || '...');
3034: LNS_BILLING_BATCH_PUB.CREATE_AR_ADJ(P_TYPE => 'INVOICE',
3035: P_PAYMENT_SCHEDULE_ID => l_invoices_tbl(i).PAYMENT_SCHEDULE_ID,
3036: P_RECEIVABLES_TRX_ID => l_receivables_trx_id,
3037: P_AMOUNT => -l_invoices_tbl(i).AMOUNT_TO_PROCESS,

Line 3048: LogMessage(FND_LOG.LEVEL_UNEXPECTED, G_PKG_NAME, 'l_adj_number = ' || l_adj_number || ' (l_adj_id = ' || l_adj_id || ')');

3044: P_COMMENTS => 'This adjustment is part of cancellation of loan ' || l_loan_number,
3045: X_ADJ_ID => l_adj_id,
3046: X_ADJ_NUMBER => l_adj_number,
3047: P_ORG_ID => l_org_id);
3048: LogMessage(FND_LOG.LEVEL_UNEXPECTED, G_PKG_NAME, 'l_adj_number = ' || l_adj_number || ' (l_adj_id = ' || l_adj_id || ')');
3049:
3050: if l_adj_id is null and l_adj_number is null then
3051: RAISE FND_API.G_EXC_ERROR;
3052: end if;

Line 3059: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'Crediting ' || l_invoices_tbl(i).CUST_TRX_ID || '...');

3055: l_invoices_tbl(i).ACTION is not null and
3056: l_invoices_tbl(i).ACTION = 'CREDIT'
3057: then
3058:
3059: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'Crediting ' || l_invoices_tbl(i).CUST_TRX_ID || '...');
3060: LogMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'P_CUSTOMER_TRX_ID = ' || l_invoices_tbl(i).CUST_TRX_ID);
3061: LogMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'p_line_amount = ' || -l_invoices_tbl(i).AMOUNT_TO_PROCESS);
3062: AR_CREDIT_MEMO_API_PUB.CREATE_REQUEST(
3063: P_API_VERSION => 1.0,

Line 3060: LogMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'P_CUSTOMER_TRX_ID = ' || l_invoices_tbl(i).CUST_TRX_ID);

3056: l_invoices_tbl(i).ACTION = 'CREDIT'
3057: then
3058:
3059: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'Crediting ' || l_invoices_tbl(i).CUST_TRX_ID || '...');
3060: LogMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'P_CUSTOMER_TRX_ID = ' || l_invoices_tbl(i).CUST_TRX_ID);
3061: LogMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'p_line_amount = ' || -l_invoices_tbl(i).AMOUNT_TO_PROCESS);
3062: AR_CREDIT_MEMO_API_PUB.CREATE_REQUEST(
3063: P_API_VERSION => 1.0,
3064: P_INIT_MSG_LIST => FND_API.G_TRUE,

Line 3061: LogMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'p_line_amount = ' || -l_invoices_tbl(i).AMOUNT_TO_PROCESS);

3057: then
3058:
3059: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'Crediting ' || l_invoices_tbl(i).CUST_TRX_ID || '...');
3060: LogMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'P_CUSTOMER_TRX_ID = ' || l_invoices_tbl(i).CUST_TRX_ID);
3061: LogMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'p_line_amount = ' || -l_invoices_tbl(i).AMOUNT_TO_PROCESS);
3062: AR_CREDIT_MEMO_API_PUB.CREATE_REQUEST(
3063: P_API_VERSION => 1.0,
3064: P_INIT_MSG_LIST => FND_API.G_TRUE,
3065: P_COMMIT => FND_API.G_FALSE,

Line 3082: LogMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'l_return_status: ' || l_return_status);

3078: X_RETURN_STATUS => l_return_status,
3079: X_MSG_COUNT => l_msg_count,
3080: X_MSG_DATA => l_msg_data);
3081:
3082: LogMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'l_return_status: ' || l_return_status);
3083: LogMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'l_msg_data: ' || substr(l_msg_data,1,225));
3084: LogMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'l_request_id: ' || l_request_id);
3085:
3086: IF l_return_status = fnd_api.g_ret_sts_error OR l_return_status = fnd_api.g_ret_sts_unexp_error OR

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

3079: X_MSG_COUNT => l_msg_count,
3080: X_MSG_DATA => l_msg_data);
3081:
3082: LogMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'l_return_status: ' || l_return_status);
3083: LogMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'l_msg_data: ' || substr(l_msg_data,1,225));
3084: LogMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'l_request_id: ' || l_request_id);
3085:
3086: IF l_return_status = fnd_api.g_ret_sts_error OR l_return_status = fnd_api.g_ret_sts_unexp_error OR
3087: l_request_id is null OR l_request_id = -1

Line 3084: LogMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'l_request_id: ' || l_request_id);

3080: X_MSG_DATA => l_msg_data);
3081:
3082: LogMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'l_return_status: ' || l_return_status);
3083: LogMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'l_msg_data: ' || substr(l_msg_data,1,225));
3084: LogMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'l_request_id: ' || l_request_id);
3085:
3086: IF l_return_status = fnd_api.g_ret_sts_error OR l_return_status = fnd_api.g_ret_sts_unexp_error OR
3087: l_request_id is null OR l_request_id = -1
3088: THEN

Line 3096: LogMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'Updating LNS_LOAN_CANCELLATIONS...');

3092:
3093: end loop;
3094:
3095: -- update cancellation record
3096: LogMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'Updating LNS_LOAN_CANCELLATIONS...');
3097: update LNS_LOAN_CANCELLATIONS set
3098: STATUS = 'APPROVED'
3099: ,APPR_REJECT_DATE = sysdate
3100: ,APPR_REJECT_BY = LNS_UTILITY_PUB.USER_ID

Line 3106: LogMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'Done');

3102: ,LAST_UPDATE_DATE = sysdate
3103: ,LAST_UPDATED_BY = LNS_UTILITY_PUB.LAST_UPDATED_BY
3104: ,LAST_UPDATE_LOGIN = LNS_UTILITY_PUB.LAST_UPDATE_LOGIN
3105: where LOAN_CANCELLATION_ID = p_LOAN_CANCELLATION_ID;
3106: LogMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'Done');
3107:
3108: open loan_version_cur(l_loan_id);
3109: fetch loan_version_cur into l_version_number;
3110: close loan_version_cur;

Line 3117: LogMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'Updating loan header...');

3113: l_loan_header_rec.LOAN_STATUS := 'CANCELLED';
3114: l_loan_header_rec.SECONDARY_STATUS := FND_API.G_MISS_CHAR;
3115: l_loan_header_rec.DISABLE_BILLING_FLAG := 'N';
3116:
3117: LogMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'Updating loan header...');
3118: LNS_LOAN_HEADER_PUB.UPDATE_LOAN(P_OBJECT_VERSION_NUMBER => l_version_number,
3119: P_LOAN_HEADER_REC => l_loan_header_rec,
3120: P_INIT_MSG_LIST => FND_API.G_FALSE,
3121: X_RETURN_STATUS => l_return_status,

Line 3125: LogMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'l_return_status: ' || l_return_status);

3121: X_RETURN_STATUS => l_return_status,
3122: X_MSG_COUNT => l_msg_count,
3123: X_MSG_DATA => l_msg_data);
3124:
3125: LogMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'l_return_status: ' || l_return_status);
3126:
3127: IF l_return_status = 'S' THEN
3128: LogMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'Successfully update LNS_LOAN_HEADERS_ALL');
3129: ELSE

Line 3128: LogMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'Successfully update LNS_LOAN_HEADERS_ALL');

3124:
3125: LogMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'l_return_status: ' || l_return_status);
3126:
3127: IF l_return_status = 'S' THEN
3128: LogMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'Successfully update LNS_LOAN_HEADERS_ALL');
3129: ELSE
3130: FND_MESSAGE.SET_NAME('LNS', 'LNS_UPD_LOAN_FAIL');
3131: FND_MSG_PUB.Add;
3132: LogMessage(FND_LOG.LEVEL_UNEXPECTED, G_PKG_NAME, FND_MSG_PUB.Get(p_encoded => 'F'));

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

3128: LogMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'Successfully update LNS_LOAN_HEADERS_ALL');
3129: ELSE
3130: FND_MESSAGE.SET_NAME('LNS', 'LNS_UPD_LOAN_FAIL');
3131: FND_MSG_PUB.Add;
3132: LogMessage(FND_LOG.LEVEL_UNEXPECTED, G_PKG_NAME, FND_MSG_PUB.Get(p_encoded => 'F'));
3133: RAISE FND_API.G_EXC_ERROR;
3134: END IF;
3135:
3136: -- --------------------------------------------------------------------

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

3138: --
3139:
3140: if P_COMMIT = FND_API.G_TRUE then
3141: COMMIT WORK;
3142: LogMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'Commited');
3143: end if;
3144:
3145: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
3146:

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

3143: end if;
3144:
3145: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
3146:
3147: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - END');
3148:
3149: EXCEPTION
3150: WHEN OTHERS THEN
3151: ROLLBACK TO approveLoanCancelRequest;

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

3153: FND_MESSAGE.SET_NAME('LNS', 'LNS_PLSQL_API_ERROR');
3154: FND_MESSAGE.SET_TOKEN('APINAME', l_api_name);
3155: FND_MESSAGE.SET_TOKEN('ERRMSG', sqlerrm);
3156: FND_MSG_PUB.Add;
3157: LogMessage(FND_LOG.LEVEL_UNEXPECTED, G_PKG_NAME, FND_MSG_PUB.Get(p_encoded => 'F'));
3158: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
3159: end;
3160:
3161:

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

3190: begin
3191:
3192: l_api_name := 'rejectLoanCancelRequest';
3193: l_api_version_number := 1;
3194: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - BEGIN');
3195:
3196: -- Standard Start of API savepoint
3197: SAVEPOINT rejectLoanCancelRequest;
3198:

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

3214: --
3215: -- Api body
3216: -- --------------------------------------------------------------------
3217:
3218: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'Input:');
3219: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'p_LOAN_CANCELLATION_ID = ' || p_LOAN_CANCELLATION_ID);
3220:
3221: validateLoanCancelRequest(P_LOAN_CANCELLATION_ID => p_LOAN_CANCELLATION_ID
3222: ,p_action => 'REJECT');

Line 3219: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'p_LOAN_CANCELLATION_ID = ' || p_LOAN_CANCELLATION_ID);

3215: -- Api body
3216: -- --------------------------------------------------------------------
3217:
3218: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'Input:');
3219: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'p_LOAN_CANCELLATION_ID = ' || p_LOAN_CANCELLATION_ID);
3220:
3221: validateLoanCancelRequest(P_LOAN_CANCELLATION_ID => p_LOAN_CANCELLATION_ID
3222: ,p_action => 'REJECT');
3223:

Line 3225: LogMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'Updating LNS_LOAN_CANCELLATIONS...');

3221: validateLoanCancelRequest(P_LOAN_CANCELLATION_ID => p_LOAN_CANCELLATION_ID
3222: ,p_action => 'REJECT');
3223:
3224: -- update cancellation record
3225: LogMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'Updating LNS_LOAN_CANCELLATIONS...');
3226: update LNS_LOAN_CANCELLATIONS set
3227: STATUS = 'REJECTED'
3228: ,APPR_REJECT_DATE = sysdate
3229: ,APPR_REJECT_BY = LNS_UTILITY_PUB.USER_ID

Line 3235: LogMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'Done');

3231: ,LAST_UPDATE_DATE = sysdate
3232: ,LAST_UPDATED_BY = LNS_UTILITY_PUB.LAST_UPDATED_BY
3233: ,LAST_UPDATE_LOGIN = LNS_UTILITY_PUB.LAST_UPDATE_LOGIN
3234: where LOAN_CANCELLATION_ID = p_LOAN_CANCELLATION_ID;
3235: LogMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'Done');
3236:
3237: open loan_version_cur(p_LOAN_CANCELLATION_ID);
3238: fetch loan_version_cur into l_loan_id, l_version_number;
3239: close loan_version_cur;

Line 3244: LogMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'Updating loan header...');

3240:
3241: l_loan_header_rec.loan_id := l_loan_id;
3242: l_loan_header_rec.DISABLE_BILLING_FLAG := 'N';
3243:
3244: LogMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'Updating loan header...');
3245: LNS_LOAN_HEADER_PUB.UPDATE_LOAN(P_OBJECT_VERSION_NUMBER => l_version_number,
3246: P_LOAN_HEADER_REC => l_loan_header_rec,
3247: P_INIT_MSG_LIST => FND_API.G_FALSE,
3248: X_RETURN_STATUS => l_return_status,

Line 3252: LogMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'l_return_status: ' || l_return_status);

3248: X_RETURN_STATUS => l_return_status,
3249: X_MSG_COUNT => l_msg_count,
3250: X_MSG_DATA => l_msg_data);
3251:
3252: LogMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'l_return_status: ' || l_return_status);
3253:
3254: IF l_return_status = 'S' THEN
3255: LogMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'Successfully update LNS_LOAN_HEADERS_ALL');
3256: ELSE

Line 3255: LogMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'Successfully update LNS_LOAN_HEADERS_ALL');

3251:
3252: LogMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'l_return_status: ' || l_return_status);
3253:
3254: IF l_return_status = 'S' THEN
3255: LogMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'Successfully update LNS_LOAN_HEADERS_ALL');
3256: ELSE
3257: FND_MESSAGE.SET_NAME('LNS', 'LNS_UPD_LOAN_FAIL');
3258: FND_MSG_PUB.Add;
3259: LogMessage(FND_LOG.LEVEL_UNEXPECTED, G_PKG_NAME, FND_MSG_PUB.Get(p_encoded => 'F'));

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

3255: LogMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'Successfully update LNS_LOAN_HEADERS_ALL');
3256: ELSE
3257: FND_MESSAGE.SET_NAME('LNS', 'LNS_UPD_LOAN_FAIL');
3258: FND_MSG_PUB.Add;
3259: LogMessage(FND_LOG.LEVEL_UNEXPECTED, G_PKG_NAME, FND_MSG_PUB.Get(p_encoded => 'F'));
3260: RAISE FND_API.G_EXC_ERROR;
3261: END IF;
3262:
3263: -- --------------------------------------------------------------------

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

3265: --
3266:
3267: if P_COMMIT = FND_API.G_TRUE then
3268: COMMIT WORK;
3269: LogMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'Commited');
3270: end if;
3271:
3272: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
3273:

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

3270: end if;
3271:
3272: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
3273:
3274: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - END');
3275:
3276: EXCEPTION
3277: WHEN OTHERS THEN
3278: ROLLBACK TO rejectLoanCancelRequest;

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

3277: WHEN OTHERS THEN
3278: ROLLBACK TO rejectLoanCancelRequest;
3279: x_return_status := FND_API.G_RET_STS_ERROR;
3280: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
3281: logMessage(FND_LOG.LEVEL_ERROR, G_PKG_NAME, sqlerrm);
3282: end;
3283:
3284:
3285:

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

3440: begin
3441:
3442: l_api_name := 'approveLoanSplitRequest';
3443: l_api_version_number := 1;
3444: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - BEGIN');
3445:
3446: -- Standard Start of API savepoint
3447: SAVEPOINT approveLoanSplitRequest;
3448:

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

3464: --
3465: -- Api body
3466: -- --------------------------------------------------------------------
3467:
3468: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'Input:');
3469: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'p_LOAN_SPLIT_ID = ' || p_LOAN_SPLIT_ID);
3470:
3471: open split_details_cur(p_LOAN_SPLIT_ID);
3472: fetch split_details_cur into

Line 3469: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'p_LOAN_SPLIT_ID = ' || p_LOAN_SPLIT_ID);

3465: -- Api body
3466: -- --------------------------------------------------------------------
3467:
3468: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'Input:');
3469: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'p_LOAN_SPLIT_ID = ' || p_LOAN_SPLIT_ID);
3470:
3471: open split_details_cur(p_LOAN_SPLIT_ID);
3472: fetch split_details_cur into
3473: l_LOAN_ID

Line 3547: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'Calling lns_billing_batch_pub.create_offcycle_bills...');

3543: l_BILL_LINES_TBL(l_line_counter).LINE_AMOUNT := l_REQUESTED_AMOUNT;
3544: l_BILL_LINES_TBL(l_line_counter).LINE_TYPE := 'PRIN';
3545: l_BILL_LINES_TBL(l_line_counter).LINE_DESC := 'Loan split';
3546:
3547: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'Calling lns_billing_batch_pub.create_offcycle_bills...');
3548: lns_billing_batch_pub.create_offcycle_bills(p_api_version => 1.0
3549: ,p_init_msg_list => FND_API.G_TRUE
3550: ,p_commit => FND_API.G_FALSE
3551: ,p_validation_level => 100

Line 3558: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'l_return_status ' || l_return_status);

3554: ,x_return_status => l_return_status
3555: ,x_msg_count => l_msg_count
3556: ,x_msg_data => l_msg_data);
3557:
3558: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'l_return_status ' || l_return_status);
3559: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
3560: FND_MESSAGE.SET_NAME('LNS', 'LNS_INVOICE_CREATION_ERROR');
3561: FND_MSG_PUB.Add;
3562: logMessage(FND_LOG.LEVEL_UNEXPECTED, G_PKG_NAME, FND_MSG_PUB.Get(p_encoded => 'F'));

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

3558: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'l_return_status ' || l_return_status);
3559: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
3560: FND_MESSAGE.SET_NAME('LNS', 'LNS_INVOICE_CREATION_ERROR');
3561: FND_MSG_PUB.Add;
3562: logMessage(FND_LOG.LEVEL_UNEXPECTED, G_PKG_NAME, FND_MSG_PUB.Get(p_encoded => 'F'));
3563: RAISE FND_API.G_EXC_ERROR;
3564: END IF;
3565:
3566: open get_psa_cur(l_loan_id);

Line 3569: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'l_new_am_sched_id = ' || l_new_am_sched_id);

3565:
3566: open get_psa_cur(l_loan_id);
3567: fetch get_psa_cur into l_payment_schedule_id, l_new_am_sched_id;
3568: close get_psa_cur;
3569: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'l_new_am_sched_id = ' || l_new_am_sched_id);
3570: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'l_payment_schedule_id = ' || l_payment_schedule_id);
3571:
3572: -- call loan creation api
3573:

Line 3570: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'l_payment_schedule_id = ' || l_payment_schedule_id);

3566: open get_psa_cur(l_loan_id);
3567: fetch get_psa_cur into l_payment_schedule_id, l_new_am_sched_id;
3568: close get_psa_cur;
3569: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'l_new_am_sched_id = ' || l_new_am_sched_id);
3570: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'l_payment_schedule_id = ' || l_payment_schedule_id);
3571:
3572: -- call loan creation api
3573:
3574: l_LOAN_DTL_REC.product_id := l_PRODUCT_ID;

Line 3687: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'Calling LNS_LOAN_PUB.CREATE_LOAN...');

3683: l_TERM_RATES_TBL(1).BEGIN_INSTALLMENT_NUMBER := 1;
3684: l_TERM_RATES_TBL(1).END_INSTALLMENT_NUMBER := -1;
3685: l_TERM_RATES_TBL(1).INTEREST_ONLY_FLAG := null;
3686:
3687: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'Calling LNS_LOAN_PUB.CREATE_LOAN...');
3688: LNS_LOAN_PUB.CREATE_LOAN(
3689: P_API_VERSION => 1.0,
3690: P_INIT_MSG_LIST => FND_API.G_TRUE,
3691: P_COMMIT => FND_API.G_FALSE,

Line 3707: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'l_return_status ' || l_return_status);

3703: X_RETURN_STATUS => l_return_status,
3704: X_MSG_COUNT => l_msg_count,
3705: X_MSG_DATA => l_msg_data);
3706:
3707: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'l_return_status ' || l_return_status);
3708: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
3709: logMessage(FND_LOG.LEVEL_UNEXPECTED, G_PKG_NAME, FND_MSG_PUB.Get(p_encoded => 'F'));
3710: RAISE FND_API.G_EXC_ERROR;
3711: END IF;

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

3705: X_MSG_DATA => l_msg_data);
3706:
3707: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'l_return_status ' || l_return_status);
3708: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
3709: logMessage(FND_LOG.LEVEL_UNEXPECTED, G_PKG_NAME, FND_MSG_PUB.Get(p_encoded => 'F'));
3710: RAISE FND_API.G_EXC_ERROR;
3711: END IF;
3712:
3713: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'Successfully created loan with id ' || l_new_loan_id);

Line 3713: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'Successfully created loan with id ' || l_new_loan_id);

3709: logMessage(FND_LOG.LEVEL_UNEXPECTED, G_PKG_NAME, FND_MSG_PUB.Get(p_encoded => 'F'));
3710: RAISE FND_API.G_EXC_ERROR;
3711: END IF;
3712:
3713: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'Successfully created loan with id ' || l_new_loan_id);
3714:
3715: open get_loan_number(l_new_loan_id);
3716: fetch get_loan_number into l_LOAN_NUMBER;
3717: close get_loan_number;

Line 3722: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'Calling LNS_CUSTOM_PUB.parseClob...');

3718:
3719: if l_LOAN_DTL_REC.CUSTOM_PAYMENTS_FLAG = 'Y' then
3720:
3721: -- if this is custom schedule loan then parse it and save it
3722: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'Calling LNS_CUSTOM_PUB.parseClob...');
3723: LNS_CUSTOM_PUB.parseClob(
3724: P_API_VERSION => 1.0,
3725: P_INIT_MSG_LIST => FND_API.G_TRUE,
3726: P_COMMIT => FND_API.G_FALSE,

Line 3734: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'l_return_status ' || l_return_status);

3730: x_return_status => l_return_status,
3731: x_msg_count => l_msg_count,
3732: x_msg_data => l_msg_data);
3733:
3734: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'l_return_status ' || l_return_status);
3735: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
3736: logMessage(FND_LOG.LEVEL_UNEXPECTED, G_PKG_NAME, FND_MSG_PUB.Get(p_encoded => 'F'));
3737: RAISE FND_API.G_EXC_ERROR;
3738: END IF;

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

3732: x_msg_data => l_msg_data);
3733:
3734: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'l_return_status ' || l_return_status);
3735: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
3736: logMessage(FND_LOG.LEVEL_UNEXPECTED, G_PKG_NAME, FND_MSG_PUB.Get(p_encoded => 'F'));
3737: RAISE FND_API.G_EXC_ERROR;
3738: END IF;
3739:
3740: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'Calling LNS_CUSTOM_PUB.saveCustomSchedule...');

Line 3740: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'Calling LNS_CUSTOM_PUB.saveCustomSchedule...');

3736: logMessage(FND_LOG.LEVEL_UNEXPECTED, G_PKG_NAME, FND_MSG_PUB.Get(p_encoded => 'F'));
3737: RAISE FND_API.G_EXC_ERROR;
3738: END IF;
3739:
3740: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'Calling LNS_CUSTOM_PUB.saveCustomSchedule...');
3741: LNS_CUSTOM_PUB.saveCustomSchedule(
3742: P_API_VERSION => 1.0,
3743: P_INIT_MSG_LIST => FND_API.G_TRUE,
3744: P_COMMIT => FND_API.G_FALSE,

Line 3755: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'l_return_status ' || l_return_status);

3751: x_return_status => l_return_status,
3752: x_msg_count => l_msg_count,
3753: x_msg_data => l_msg_data);
3754:
3755: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'l_return_status ' || l_return_status);
3756: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
3757: logMessage(FND_LOG.LEVEL_UNEXPECTED, G_PKG_NAME, FND_MSG_PUB.Get(p_encoded => 'F'));
3758: RAISE FND_API.G_EXC_ERROR;
3759: END IF;

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

3753: x_msg_data => l_msg_data);
3754:
3755: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'l_return_status ' || l_return_status);
3756: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
3757: logMessage(FND_LOG.LEVEL_UNEXPECTED, G_PKG_NAME, FND_MSG_PUB.Get(p_encoded => 'F'));
3758: RAISE FND_API.G_EXC_ERROR;
3759: END IF;
3760:
3761: end if;

Line 3764: LogMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'Updating LNS_LOAN_CANCELLATIONS...');

3760:
3761: end if;
3762:
3763: -- update split record
3764: LogMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'Updating LNS_LOAN_CANCELLATIONS...');
3765: update LNS_LOAN_SPLITS set
3766: NEW_AM_SCHED_ID = l_new_am_sched_id
3767: ,NEW_LOAN_ID = l_new_loan_id
3768: ,LOAN_NUMBER = l_LOAN_NUMBER

Line 3777: LogMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'Done');

3773: ,LAST_UPDATE_DATE = sysdate
3774: ,LAST_UPDATED_BY = LNS_UTILITY_PUB.LAST_UPDATED_BY
3775: ,LAST_UPDATE_LOGIN = LNS_UTILITY_PUB.LAST_UPDATE_LOGIN
3776: where LOAN_SPLIT_ID = p_LOAN_SPLIT_ID;
3777: LogMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'Done');
3778:
3779: -- fix for bug 14491711
3780: FND_MESSAGE.SET_NAME('LNS', 'LNS_LOAN_SPLIT_AGR_REASON');
3781: FND_MESSAGE.SET_TOKEN('SPLIT', l_split_request);

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

3794: --
3795:
3796: if P_COMMIT = FND_API.G_TRUE then
3797: COMMIT WORK;
3798: LogMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'Commited');
3799: end if;
3800:
3801: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
3802:

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

3799: end if;
3800:
3801: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
3802:
3803: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - END');
3804:
3805: EXCEPTION
3806: WHEN OTHERS THEN
3807: ROLLBACK TO approveLoanSplitRequest;

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

3809: FND_MESSAGE.SET_NAME('LNS', 'LNS_PLSQL_API_ERROR');
3810: FND_MESSAGE.SET_TOKEN('APINAME', l_api_name);
3811: FND_MESSAGE.SET_TOKEN('ERRMSG', sqlerrm);
3812: FND_MSG_PUB.Add;
3813: LogMessage(FND_LOG.LEVEL_UNEXPECTED, G_PKG_NAME, FND_MSG_PUB.Get(p_encoded => 'F'));
3814: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
3815: end;
3816:
3817:

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

3832: begin
3833:
3834: l_api_name := 'rejectLoanSplitRequest';
3835: l_api_version_number := 1;
3836: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - BEGIN');
3837:
3838: -- Standard Start of API savepoint
3839: SAVEPOINT rejectLoanCancelRequest;
3840:

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

3856: --
3857: -- Api body
3858: -- --------------------------------------------------------------------
3859:
3860: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'Input:');
3861: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'p_LOAN_SPLIT_ID = ' || p_LOAN_SPLIT_ID);
3862:
3863: --validateLoanCancelRequest(P_LOAN_CANCELLATION_ID => p_LOAN_CANCELLATION_ID
3864: -- ,p_action => 'REJECT');

Line 3861: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'p_LOAN_SPLIT_ID = ' || p_LOAN_SPLIT_ID);

3857: -- Api body
3858: -- --------------------------------------------------------------------
3859:
3860: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'Input:');
3861: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'p_LOAN_SPLIT_ID = ' || p_LOAN_SPLIT_ID);
3862:
3863: --validateLoanCancelRequest(P_LOAN_CANCELLATION_ID => p_LOAN_CANCELLATION_ID
3864: -- ,p_action => 'REJECT');
3865:

Line 3867: LogMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'Updating LNS_LOAN_CANCELLATIONS...');

3863: --validateLoanCancelRequest(P_LOAN_CANCELLATION_ID => p_LOAN_CANCELLATION_ID
3864: -- ,p_action => 'REJECT');
3865:
3866: -- update split record
3867: LogMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'Updating LNS_LOAN_CANCELLATIONS...');
3868: update LNS_LOAN_SPLITS set
3869: STATUS = 'REJECTED'
3870: ,APPR_REJECT_DATE = sysdate
3871: ,APPR_REJECT_BY = LNS_UTILITY_PUB.USER_ID

Line 3877: LogMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'Done');

3873: ,LAST_UPDATE_DATE = sysdate
3874: ,LAST_UPDATED_BY = LNS_UTILITY_PUB.LAST_UPDATED_BY
3875: ,LAST_UPDATE_LOGIN = LNS_UTILITY_PUB.LAST_UPDATE_LOGIN
3876: where LOAN_SPLIT_ID = p_LOAN_SPLIT_ID;
3877: LogMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'Done');
3878:
3879: -- --------------------------------------------------------------------
3880: -- End of API body
3881: --

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

3881: --
3882:
3883: if P_COMMIT = FND_API.G_TRUE then
3884: COMMIT WORK;
3885: LogMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'Commited');
3886: end if;
3887:
3888: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
3889:

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

3886: end if;
3887:
3888: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
3889:
3890: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - END');
3891:
3892: EXCEPTION
3893: WHEN OTHERS THEN
3894: ROLLBACK TO rejectLoanSplitRequest;

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

3893: WHEN OTHERS THEN
3894: ROLLBACK TO rejectLoanSplitRequest;
3895: x_return_status := FND_API.G_RET_STS_ERROR;
3896: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
3897: logMessage(FND_LOG.LEVEL_ERROR, G_PKG_NAME, sqlerrm);
3898: end;
3899:
3900:
3901: