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.

[Home] [Help]

APPS.LNS_IMPORT_LOAN_PUB dependencies on FND_LOG

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

55: IS
56: BEGIN
57: if (p_msg_level >= G_MSG_LEVEL) then
58:
59: FND_LOG.STRING(p_msg_level, G_PKG_NAME, p_msg);
60:
61: end if;
62:
63: EXCEPTION

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

61: end if;
62:
63: EXCEPTION
64: WHEN OTHERS THEN
65: LogMessage(FND_LOG.LEVEL_UNEXPECTED, 'ERROR: ' || sqlerrm);
66: END;
67:
68:
69:

Line 130: LogMessage(FND_LOG.LEVEL_UNEXPECTED, 'ERROR: ' || p_message_name || '(' || p_token1 || ',' || p_token2 || ',' || p_token3 || ') - ' || l_text);

126: g_errors_rec(g_error_count).ERROR_NUMBER := g_error_count;
127: g_errors_rec(g_error_count).MESSAGE_NAME := p_message_name;
128: g_errors_rec(g_error_count).MESSAGE_TEXT := l_text;
129: g_errors_rec(g_error_count).LINE_NUMBER := p_line_number;
130: LogMessage(FND_LOG.LEVEL_UNEXPECTED, 'ERROR: ' || p_message_name || '(' || p_token1 || ',' || p_token2 || ',' || p_token3 || ') - ' || l_text);
131:
132: EXCEPTION
133: WHEN OTHERS THEN
134: LogMessage(FND_LOG.LEVEL_UNEXPECTED, 'ERROR: ' || sqlerrm);

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

130: LogMessage(FND_LOG.LEVEL_UNEXPECTED, 'ERROR: ' || p_message_name || '(' || p_token1 || ',' || p_token2 || ',' || p_token3 || ') - ' || l_text);
131:
132: EXCEPTION
133: WHEN OTHERS THEN
134: LogMessage(FND_LOG.LEVEL_UNEXPECTED, 'ERROR: ' || sqlerrm);
135: END;
136:
137:
138:

Line 152: logmessage(fnd_log.level_procedure, g_pkg_name || '.' || l_api_name || ' +');

148: l_temp LNS_IMPORT_LOAN_PUB.PAYMENT_HIST_REC_TYPE;
149: l_tem_pay_hist_tbl LNS_IMPORT_LOAN_PUB.PAYMENT_HIST_TBL_TYPE;
150:
151: BEGIN
152: logmessage(fnd_log.level_procedure, g_pkg_name || '.' || l_api_name || ' +');
153:
154: P_Loan_Details_Rec.next_payment_due_date := P_Loan_Details_Rec.first_payment_date;
155:
156: l_tem_pay_hist_tbl := P_PAY_HIST_TBL;

Line 159: logmessage(fnd_log.level_statement, 'Payment record ' || i);

155:
156: l_tem_pay_hist_tbl := P_PAY_HIST_TBL;
157: FOR i IN 1 .. l_tem_pay_hist_tbl.COUNT LOOP
158:
159: logmessage(fnd_log.level_statement, 'Payment record ' || i);
160: logmessage(fnd_log.level_statement, 'PAYMENT_NUMBER = ' || l_tem_pay_hist_tbl(i).PAYMENT_NUMBER);
161: logmessage(fnd_log.level_statement, 'DUE_DATE = ' || l_tem_pay_hist_tbl(i).DUE_DATE);
162: logmessage(fnd_log.level_statement, 'BILLED_PRIN = ' || l_tem_pay_hist_tbl(i).BILLED_PRIN);
163: logmessage(fnd_log.level_statement, 'BILLED_INT = ' || l_tem_pay_hist_tbl(i).BILLED_INT);

Line 160: logmessage(fnd_log.level_statement, 'PAYMENT_NUMBER = ' || l_tem_pay_hist_tbl(i).PAYMENT_NUMBER);

156: l_tem_pay_hist_tbl := P_PAY_HIST_TBL;
157: FOR i IN 1 .. l_tem_pay_hist_tbl.COUNT LOOP
158:
159: logmessage(fnd_log.level_statement, 'Payment record ' || i);
160: logmessage(fnd_log.level_statement, 'PAYMENT_NUMBER = ' || l_tem_pay_hist_tbl(i).PAYMENT_NUMBER);
161: logmessage(fnd_log.level_statement, 'DUE_DATE = ' || l_tem_pay_hist_tbl(i).DUE_DATE);
162: logmessage(fnd_log.level_statement, 'BILLED_PRIN = ' || l_tem_pay_hist_tbl(i).BILLED_PRIN);
163: logmessage(fnd_log.level_statement, 'BILLED_INT = ' || l_tem_pay_hist_tbl(i).BILLED_INT);
164: logmessage(fnd_log.level_statement, 'BILLED_FEE = ' || l_tem_pay_hist_tbl(i).BILLED_FEE);

Line 161: logmessage(fnd_log.level_statement, 'DUE_DATE = ' || l_tem_pay_hist_tbl(i).DUE_DATE);

157: FOR i IN 1 .. l_tem_pay_hist_tbl.COUNT LOOP
158:
159: logmessage(fnd_log.level_statement, 'Payment record ' || i);
160: logmessage(fnd_log.level_statement, 'PAYMENT_NUMBER = ' || l_tem_pay_hist_tbl(i).PAYMENT_NUMBER);
161: logmessage(fnd_log.level_statement, 'DUE_DATE = ' || l_tem_pay_hist_tbl(i).DUE_DATE);
162: logmessage(fnd_log.level_statement, 'BILLED_PRIN = ' || l_tem_pay_hist_tbl(i).BILLED_PRIN);
163: logmessage(fnd_log.level_statement, 'BILLED_INT = ' || l_tem_pay_hist_tbl(i).BILLED_INT);
164: logmessage(fnd_log.level_statement, 'BILLED_FEE = ' || l_tem_pay_hist_tbl(i).BILLED_FEE);
165: logmessage(fnd_log.level_statement, 'SOURCE = ' || l_tem_pay_hist_tbl(i).SOURCE);

Line 162: logmessage(fnd_log.level_statement, 'BILLED_PRIN = ' || l_tem_pay_hist_tbl(i).BILLED_PRIN);

158:
159: logmessage(fnd_log.level_statement, 'Payment record ' || i);
160: logmessage(fnd_log.level_statement, 'PAYMENT_NUMBER = ' || l_tem_pay_hist_tbl(i).PAYMENT_NUMBER);
161: logmessage(fnd_log.level_statement, 'DUE_DATE = ' || l_tem_pay_hist_tbl(i).DUE_DATE);
162: logmessage(fnd_log.level_statement, 'BILLED_PRIN = ' || l_tem_pay_hist_tbl(i).BILLED_PRIN);
163: logmessage(fnd_log.level_statement, 'BILLED_INT = ' || l_tem_pay_hist_tbl(i).BILLED_INT);
164: logmessage(fnd_log.level_statement, 'BILLED_FEE = ' || l_tem_pay_hist_tbl(i).BILLED_FEE);
165: logmessage(fnd_log.level_statement, 'SOURCE = ' || l_tem_pay_hist_tbl(i).SOURCE);
166: logmessage(fnd_log.level_statement, 'PAID_PRIN = ' || l_tem_pay_hist_tbl(i).PAID_PRIN);

Line 163: logmessage(fnd_log.level_statement, 'BILLED_INT = ' || l_tem_pay_hist_tbl(i).BILLED_INT);

159: logmessage(fnd_log.level_statement, 'Payment record ' || i);
160: logmessage(fnd_log.level_statement, 'PAYMENT_NUMBER = ' || l_tem_pay_hist_tbl(i).PAYMENT_NUMBER);
161: logmessage(fnd_log.level_statement, 'DUE_DATE = ' || l_tem_pay_hist_tbl(i).DUE_DATE);
162: logmessage(fnd_log.level_statement, 'BILLED_PRIN = ' || l_tem_pay_hist_tbl(i).BILLED_PRIN);
163: logmessage(fnd_log.level_statement, 'BILLED_INT = ' || l_tem_pay_hist_tbl(i).BILLED_INT);
164: logmessage(fnd_log.level_statement, 'BILLED_FEE = ' || l_tem_pay_hist_tbl(i).BILLED_FEE);
165: logmessage(fnd_log.level_statement, 'SOURCE = ' || l_tem_pay_hist_tbl(i).SOURCE);
166: logmessage(fnd_log.level_statement, 'PAID_PRIN = ' || l_tem_pay_hist_tbl(i).PAID_PRIN);
167: logmessage(fnd_log.level_statement, 'PAID_INT = ' || l_tem_pay_hist_tbl(i).PAID_INT);

Line 164: logmessage(fnd_log.level_statement, 'BILLED_FEE = ' || l_tem_pay_hist_tbl(i).BILLED_FEE);

160: logmessage(fnd_log.level_statement, 'PAYMENT_NUMBER = ' || l_tem_pay_hist_tbl(i).PAYMENT_NUMBER);
161: logmessage(fnd_log.level_statement, 'DUE_DATE = ' || l_tem_pay_hist_tbl(i).DUE_DATE);
162: logmessage(fnd_log.level_statement, 'BILLED_PRIN = ' || l_tem_pay_hist_tbl(i).BILLED_PRIN);
163: logmessage(fnd_log.level_statement, 'BILLED_INT = ' || l_tem_pay_hist_tbl(i).BILLED_INT);
164: logmessage(fnd_log.level_statement, 'BILLED_FEE = ' || l_tem_pay_hist_tbl(i).BILLED_FEE);
165: logmessage(fnd_log.level_statement, 'SOURCE = ' || l_tem_pay_hist_tbl(i).SOURCE);
166: logmessage(fnd_log.level_statement, 'PAID_PRIN = ' || l_tem_pay_hist_tbl(i).PAID_PRIN);
167: logmessage(fnd_log.level_statement, 'PAID_INT = ' || l_tem_pay_hist_tbl(i).PAID_INT);
168: logmessage(fnd_log.level_statement, 'PAID_FEE = ' || l_tem_pay_hist_tbl(i).PAID_FEE);

Line 165: logmessage(fnd_log.level_statement, 'SOURCE = ' || l_tem_pay_hist_tbl(i).SOURCE);

161: logmessage(fnd_log.level_statement, 'DUE_DATE = ' || l_tem_pay_hist_tbl(i).DUE_DATE);
162: logmessage(fnd_log.level_statement, 'BILLED_PRIN = ' || l_tem_pay_hist_tbl(i).BILLED_PRIN);
163: logmessage(fnd_log.level_statement, 'BILLED_INT = ' || l_tem_pay_hist_tbl(i).BILLED_INT);
164: logmessage(fnd_log.level_statement, 'BILLED_FEE = ' || l_tem_pay_hist_tbl(i).BILLED_FEE);
165: logmessage(fnd_log.level_statement, 'SOURCE = ' || l_tem_pay_hist_tbl(i).SOURCE);
166: logmessage(fnd_log.level_statement, 'PAID_PRIN = ' || l_tem_pay_hist_tbl(i).PAID_PRIN);
167: logmessage(fnd_log.level_statement, 'PAID_INT = ' || l_tem_pay_hist_tbl(i).PAID_INT);
168: logmessage(fnd_log.level_statement, 'PAID_FEE = ' || l_tem_pay_hist_tbl(i).PAID_FEE);
169: logmessage(fnd_log.level_statement, 'PAID_DATE = ' || l_tem_pay_hist_tbl(i).PAID_DATE);

Line 166: logmessage(fnd_log.level_statement, 'PAID_PRIN = ' || l_tem_pay_hist_tbl(i).PAID_PRIN);

162: logmessage(fnd_log.level_statement, 'BILLED_PRIN = ' || l_tem_pay_hist_tbl(i).BILLED_PRIN);
163: logmessage(fnd_log.level_statement, 'BILLED_INT = ' || l_tem_pay_hist_tbl(i).BILLED_INT);
164: logmessage(fnd_log.level_statement, 'BILLED_FEE = ' || l_tem_pay_hist_tbl(i).BILLED_FEE);
165: logmessage(fnd_log.level_statement, 'SOURCE = ' || l_tem_pay_hist_tbl(i).SOURCE);
166: logmessage(fnd_log.level_statement, 'PAID_PRIN = ' || l_tem_pay_hist_tbl(i).PAID_PRIN);
167: logmessage(fnd_log.level_statement, 'PAID_INT = ' || l_tem_pay_hist_tbl(i).PAID_INT);
168: logmessage(fnd_log.level_statement, 'PAID_FEE = ' || l_tem_pay_hist_tbl(i).PAID_FEE);
169: logmessage(fnd_log.level_statement, 'PAID_DATE = ' || l_tem_pay_hist_tbl(i).PAID_DATE);
170: logmessage(fnd_log.level_statement, 'RC_ID = ' || l_tem_pay_hist_tbl(i).RC_ID);

Line 167: logmessage(fnd_log.level_statement, 'PAID_INT = ' || l_tem_pay_hist_tbl(i).PAID_INT);

163: logmessage(fnd_log.level_statement, 'BILLED_INT = ' || l_tem_pay_hist_tbl(i).BILLED_INT);
164: logmessage(fnd_log.level_statement, 'BILLED_FEE = ' || l_tem_pay_hist_tbl(i).BILLED_FEE);
165: logmessage(fnd_log.level_statement, 'SOURCE = ' || l_tem_pay_hist_tbl(i).SOURCE);
166: logmessage(fnd_log.level_statement, 'PAID_PRIN = ' || l_tem_pay_hist_tbl(i).PAID_PRIN);
167: logmessage(fnd_log.level_statement, 'PAID_INT = ' || l_tem_pay_hist_tbl(i).PAID_INT);
168: logmessage(fnd_log.level_statement, 'PAID_FEE = ' || l_tem_pay_hist_tbl(i).PAID_FEE);
169: logmessage(fnd_log.level_statement, 'PAID_DATE = ' || l_tem_pay_hist_tbl(i).PAID_DATE);
170: logmessage(fnd_log.level_statement, 'RC_ID = ' || l_tem_pay_hist_tbl(i).RC_ID);
171: logmessage(fnd_log.level_statement, 'RC_METHOD_ID = ' || l_tem_pay_hist_tbl(i).RC_METHOD_ID);

Line 168: logmessage(fnd_log.level_statement, 'PAID_FEE = ' || l_tem_pay_hist_tbl(i).PAID_FEE);

164: logmessage(fnd_log.level_statement, 'BILLED_FEE = ' || l_tem_pay_hist_tbl(i).BILLED_FEE);
165: logmessage(fnd_log.level_statement, 'SOURCE = ' || l_tem_pay_hist_tbl(i).SOURCE);
166: logmessage(fnd_log.level_statement, 'PAID_PRIN = ' || l_tem_pay_hist_tbl(i).PAID_PRIN);
167: logmessage(fnd_log.level_statement, 'PAID_INT = ' || l_tem_pay_hist_tbl(i).PAID_INT);
168: logmessage(fnd_log.level_statement, 'PAID_FEE = ' || l_tem_pay_hist_tbl(i).PAID_FEE);
169: logmessage(fnd_log.level_statement, 'PAID_DATE = ' || l_tem_pay_hist_tbl(i).PAID_DATE);
170: logmessage(fnd_log.level_statement, 'RC_ID = ' || l_tem_pay_hist_tbl(i).RC_ID);
171: logmessage(fnd_log.level_statement, 'RC_METHOD_ID = ' || l_tem_pay_hist_tbl(i).RC_METHOD_ID);
172:

Line 169: logmessage(fnd_log.level_statement, 'PAID_DATE = ' || l_tem_pay_hist_tbl(i).PAID_DATE);

165: logmessage(fnd_log.level_statement, 'SOURCE = ' || l_tem_pay_hist_tbl(i).SOURCE);
166: logmessage(fnd_log.level_statement, 'PAID_PRIN = ' || l_tem_pay_hist_tbl(i).PAID_PRIN);
167: logmessage(fnd_log.level_statement, 'PAID_INT = ' || l_tem_pay_hist_tbl(i).PAID_INT);
168: logmessage(fnd_log.level_statement, 'PAID_FEE = ' || l_tem_pay_hist_tbl(i).PAID_FEE);
169: logmessage(fnd_log.level_statement, 'PAID_DATE = ' || l_tem_pay_hist_tbl(i).PAID_DATE);
170: logmessage(fnd_log.level_statement, 'RC_ID = ' || l_tem_pay_hist_tbl(i).RC_ID);
171: logmessage(fnd_log.level_statement, 'RC_METHOD_ID = ' || l_tem_pay_hist_tbl(i).RC_METHOD_ID);
172:
173: if l_tem_pay_hist_tbl(i).PAYMENT_NUMBER is null then

Line 170: logmessage(fnd_log.level_statement, 'RC_ID = ' || l_tem_pay_hist_tbl(i).RC_ID);

166: logmessage(fnd_log.level_statement, 'PAID_PRIN = ' || l_tem_pay_hist_tbl(i).PAID_PRIN);
167: logmessage(fnd_log.level_statement, 'PAID_INT = ' || l_tem_pay_hist_tbl(i).PAID_INT);
168: logmessage(fnd_log.level_statement, 'PAID_FEE = ' || l_tem_pay_hist_tbl(i).PAID_FEE);
169: logmessage(fnd_log.level_statement, 'PAID_DATE = ' || l_tem_pay_hist_tbl(i).PAID_DATE);
170: logmessage(fnd_log.level_statement, 'RC_ID = ' || l_tem_pay_hist_tbl(i).RC_ID);
171: logmessage(fnd_log.level_statement, 'RC_METHOD_ID = ' || l_tem_pay_hist_tbl(i).RC_METHOD_ID);
172:
173: if l_tem_pay_hist_tbl(i).PAYMENT_NUMBER is null then
174: logerrors(p_message_name => 'LNS_LCREATE_NULL_VALUE',

Line 171: logmessage(fnd_log.level_statement, 'RC_METHOD_ID = ' || l_tem_pay_hist_tbl(i).RC_METHOD_ID);

167: logmessage(fnd_log.level_statement, 'PAID_INT = ' || l_tem_pay_hist_tbl(i).PAID_INT);
168: logmessage(fnd_log.level_statement, 'PAID_FEE = ' || l_tem_pay_hist_tbl(i).PAID_FEE);
169: logmessage(fnd_log.level_statement, 'PAID_DATE = ' || l_tem_pay_hist_tbl(i).PAID_DATE);
170: logmessage(fnd_log.level_statement, 'RC_ID = ' || l_tem_pay_hist_tbl(i).RC_ID);
171: logmessage(fnd_log.level_statement, 'RC_METHOD_ID = ' || l_tem_pay_hist_tbl(i).RC_METHOD_ID);
172:
173: if l_tem_pay_hist_tbl(i).PAYMENT_NUMBER is null then
174: logerrors(p_message_name => 'LNS_LCREATE_NULL_VALUE',
175: p_token1 => 'P_PAY_HIST_TBL(' || i || ').PAYMENT_NUMBER');

Line 298: LogMessage(FND_LOG.LEVEL_STATEMENT, 'Sorting by payment number...');

294:
295: END LOOP;
296:
297: -- sort table
298: LogMessage(FND_LOG.LEVEL_STATEMENT, 'Sorting by payment number...');
299: for i in REVERSE 1..l_tem_pay_hist_tbl.count loop
300: for j in 1..(i-1) loop
301: if l_tem_pay_hist_tbl(j).PAYMENT_NUMBER > l_tem_pay_hist_tbl(j+1).PAYMENT_NUMBER or
302: (l_tem_pay_hist_tbl(j).PAYMENT_NUMBER = l_tem_pay_hist_tbl(j+1).PAYMENT_NUMBER and

Line 319: LogMessage(FND_LOG.LEVEL_STATEMENT, 'Done sorting.');

315:
316: end if;
317: end loop;
318: end loop;
319: LogMessage(FND_LOG.LEVEL_STATEMENT, 'Done sorting.');
320:
321: IF g_error_count > 0 THEN
322: RAISE fnd_api.g_exc_error;
323: END IF;

Line 330: logmessage(fnd_log.level_procedure, g_pkg_name || '.' || l_api_name || ' -');

326:
327: -- END OF BODY OF API
328: x_return_status := fnd_api.g_ret_sts_success;
329:
330: logmessage(fnd_log.level_procedure, g_pkg_name || '.' || l_api_name || ' -');
331:
332: EXCEPTION
333: WHEN fnd_api.g_exc_error THEN
334: x_return_status := fnd_api.g_ret_sts_error;

Line 360: logmessage(fnd_log.level_procedure, g_pkg_name || '.' || l_api_name || ' +');

356: l_funded_amount NUMBER;
357: l_dummy VARCHAR2(30);
358:
359: BEGIN
360: logmessage(fnd_log.level_procedure, g_pkg_name || '.' || l_api_name || ' +');
361:
362: l_funded_amount := 0;
363: FOR i IN 1 .. P_DISB_TBL.COUNT LOOP
364:

Line 365: logmessage(fnd_log.level_statement, 'Disbursement record ' || i);

361:
362: l_funded_amount := 0;
363: FOR i IN 1 .. P_DISB_TBL.COUNT LOOP
364:
365: logmessage(fnd_log.level_statement, 'Disbursement record ' || i);
366: logmessage(fnd_log.level_statement, 'ACTIVITY_CODE = ' || P_DISB_TBL(i).ACTIVITY_CODE);
367: logmessage(fnd_log.level_statement, 'DESCRIPTION = ' || P_DISB_TBL(i).DESCRIPTION);
368: logmessage(fnd_log.level_statement, 'AMOUNT = ' || P_DISB_TBL(i).AMOUNT);
369: logmessage(fnd_log.level_statement, 'DUE_DATE = ' || P_DISB_TBL(i).DUE_DATE);

Line 366: logmessage(fnd_log.level_statement, 'ACTIVITY_CODE = ' || P_DISB_TBL(i).ACTIVITY_CODE);

362: l_funded_amount := 0;
363: FOR i IN 1 .. P_DISB_TBL.COUNT LOOP
364:
365: logmessage(fnd_log.level_statement, 'Disbursement record ' || i);
366: logmessage(fnd_log.level_statement, 'ACTIVITY_CODE = ' || P_DISB_TBL(i).ACTIVITY_CODE);
367: logmessage(fnd_log.level_statement, 'DESCRIPTION = ' || P_DISB_TBL(i).DESCRIPTION);
368: logmessage(fnd_log.level_statement, 'AMOUNT = ' || P_DISB_TBL(i).AMOUNT);
369: logmessage(fnd_log.level_statement, 'DUE_DATE = ' || P_DISB_TBL(i).DUE_DATE);
370: logmessage(fnd_log.level_statement, 'SUBMISSION_DATE = ' || P_DISB_TBL(i).SUBMISSION_DATE);

Line 367: logmessage(fnd_log.level_statement, 'DESCRIPTION = ' || P_DISB_TBL(i).DESCRIPTION);

363: FOR i IN 1 .. P_DISB_TBL.COUNT LOOP
364:
365: logmessage(fnd_log.level_statement, 'Disbursement record ' || i);
366: logmessage(fnd_log.level_statement, 'ACTIVITY_CODE = ' || P_DISB_TBL(i).ACTIVITY_CODE);
367: logmessage(fnd_log.level_statement, 'DESCRIPTION = ' || P_DISB_TBL(i).DESCRIPTION);
368: logmessage(fnd_log.level_statement, 'AMOUNT = ' || P_DISB_TBL(i).AMOUNT);
369: logmessage(fnd_log.level_statement, 'DUE_DATE = ' || P_DISB_TBL(i).DUE_DATE);
370: logmessage(fnd_log.level_statement, 'SUBMISSION_DATE = ' || P_DISB_TBL(i).SUBMISSION_DATE);
371: logmessage(fnd_log.level_statement, 'DISBURSEMENT_DATE = ' || P_DISB_TBL(i).DISBURSEMENT_DATE);

Line 368: logmessage(fnd_log.level_statement, 'AMOUNT = ' || P_DISB_TBL(i).AMOUNT);

364:
365: logmessage(fnd_log.level_statement, 'Disbursement record ' || i);
366: logmessage(fnd_log.level_statement, 'ACTIVITY_CODE = ' || P_DISB_TBL(i).ACTIVITY_CODE);
367: logmessage(fnd_log.level_statement, 'DESCRIPTION = ' || P_DISB_TBL(i).DESCRIPTION);
368: logmessage(fnd_log.level_statement, 'AMOUNT = ' || P_DISB_TBL(i).AMOUNT);
369: logmessage(fnd_log.level_statement, 'DUE_DATE = ' || P_DISB_TBL(i).DUE_DATE);
370: logmessage(fnd_log.level_statement, 'SUBMISSION_DATE = ' || P_DISB_TBL(i).SUBMISSION_DATE);
371: logmessage(fnd_log.level_statement, 'DISBURSEMENT_DATE = ' || P_DISB_TBL(i).DISBURSEMENT_DATE);
372: logmessage(fnd_log.level_statement, 'PAYEE_PARTY_ID = ' || P_DISB_TBL(i).PAYEE_PARTY_ID);

Line 369: logmessage(fnd_log.level_statement, 'DUE_DATE = ' || P_DISB_TBL(i).DUE_DATE);

365: logmessage(fnd_log.level_statement, 'Disbursement record ' || i);
366: logmessage(fnd_log.level_statement, 'ACTIVITY_CODE = ' || P_DISB_TBL(i).ACTIVITY_CODE);
367: logmessage(fnd_log.level_statement, 'DESCRIPTION = ' || P_DISB_TBL(i).DESCRIPTION);
368: logmessage(fnd_log.level_statement, 'AMOUNT = ' || P_DISB_TBL(i).AMOUNT);
369: logmessage(fnd_log.level_statement, 'DUE_DATE = ' || P_DISB_TBL(i).DUE_DATE);
370: logmessage(fnd_log.level_statement, 'SUBMISSION_DATE = ' || P_DISB_TBL(i).SUBMISSION_DATE);
371: logmessage(fnd_log.level_statement, 'DISBURSEMENT_DATE = ' || P_DISB_TBL(i).DISBURSEMENT_DATE);
372: logmessage(fnd_log.level_statement, 'PAYEE_PARTY_ID = ' || P_DISB_TBL(i).PAYEE_PARTY_ID);
373: logmessage(fnd_log.level_statement, 'BANK_ACCOUNT_ID = ' || P_DISB_TBL(i).BANK_ACCOUNT_ID);

Line 370: logmessage(fnd_log.level_statement, 'SUBMISSION_DATE = ' || P_DISB_TBL(i).SUBMISSION_DATE);

366: logmessage(fnd_log.level_statement, 'ACTIVITY_CODE = ' || P_DISB_TBL(i).ACTIVITY_CODE);
367: logmessage(fnd_log.level_statement, 'DESCRIPTION = ' || P_DISB_TBL(i).DESCRIPTION);
368: logmessage(fnd_log.level_statement, 'AMOUNT = ' || P_DISB_TBL(i).AMOUNT);
369: logmessage(fnd_log.level_statement, 'DUE_DATE = ' || P_DISB_TBL(i).DUE_DATE);
370: logmessage(fnd_log.level_statement, 'SUBMISSION_DATE = ' || P_DISB_TBL(i).SUBMISSION_DATE);
371: logmessage(fnd_log.level_statement, 'DISBURSEMENT_DATE = ' || P_DISB_TBL(i).DISBURSEMENT_DATE);
372: logmessage(fnd_log.level_statement, 'PAYEE_PARTY_ID = ' || P_DISB_TBL(i).PAYEE_PARTY_ID);
373: logmessage(fnd_log.level_statement, 'BANK_ACCOUNT_ID = ' || P_DISB_TBL(i).BANK_ACCOUNT_ID);
374: logmessage(fnd_log.level_statement, 'PAYMENT_METHOD_CODE = ' || P_DISB_TBL(i).PAYMENT_METHOD_CODE);

Line 371: logmessage(fnd_log.level_statement, 'DISBURSEMENT_DATE = ' || P_DISB_TBL(i).DISBURSEMENT_DATE);

367: logmessage(fnd_log.level_statement, 'DESCRIPTION = ' || P_DISB_TBL(i).DESCRIPTION);
368: logmessage(fnd_log.level_statement, 'AMOUNT = ' || P_DISB_TBL(i).AMOUNT);
369: logmessage(fnd_log.level_statement, 'DUE_DATE = ' || P_DISB_TBL(i).DUE_DATE);
370: logmessage(fnd_log.level_statement, 'SUBMISSION_DATE = ' || P_DISB_TBL(i).SUBMISSION_DATE);
371: logmessage(fnd_log.level_statement, 'DISBURSEMENT_DATE = ' || P_DISB_TBL(i).DISBURSEMENT_DATE);
372: logmessage(fnd_log.level_statement, 'PAYEE_PARTY_ID = ' || P_DISB_TBL(i).PAYEE_PARTY_ID);
373: logmessage(fnd_log.level_statement, 'BANK_ACCOUNT_ID = ' || P_DISB_TBL(i).BANK_ACCOUNT_ID);
374: logmessage(fnd_log.level_statement, 'PAYMENT_METHOD_CODE = ' || P_DISB_TBL(i).PAYMENT_METHOD_CODE);
375:

Line 372: logmessage(fnd_log.level_statement, 'PAYEE_PARTY_ID = ' || P_DISB_TBL(i).PAYEE_PARTY_ID);

368: logmessage(fnd_log.level_statement, 'AMOUNT = ' || P_DISB_TBL(i).AMOUNT);
369: logmessage(fnd_log.level_statement, 'DUE_DATE = ' || P_DISB_TBL(i).DUE_DATE);
370: logmessage(fnd_log.level_statement, 'SUBMISSION_DATE = ' || P_DISB_TBL(i).SUBMISSION_DATE);
371: logmessage(fnd_log.level_statement, 'DISBURSEMENT_DATE = ' || P_DISB_TBL(i).DISBURSEMENT_DATE);
372: logmessage(fnd_log.level_statement, 'PAYEE_PARTY_ID = ' || P_DISB_TBL(i).PAYEE_PARTY_ID);
373: logmessage(fnd_log.level_statement, 'BANK_ACCOUNT_ID = ' || P_DISB_TBL(i).BANK_ACCOUNT_ID);
374: logmessage(fnd_log.level_statement, 'PAYMENT_METHOD_CODE = ' || P_DISB_TBL(i).PAYMENT_METHOD_CODE);
375:
376: if P_DISB_TBL(i).ACTIVITY_CODE is null and P_DISB_TBL(i).DESCRIPTION is null then

Line 373: logmessage(fnd_log.level_statement, 'BANK_ACCOUNT_ID = ' || P_DISB_TBL(i).BANK_ACCOUNT_ID);

369: logmessage(fnd_log.level_statement, 'DUE_DATE = ' || P_DISB_TBL(i).DUE_DATE);
370: logmessage(fnd_log.level_statement, 'SUBMISSION_DATE = ' || P_DISB_TBL(i).SUBMISSION_DATE);
371: logmessage(fnd_log.level_statement, 'DISBURSEMENT_DATE = ' || P_DISB_TBL(i).DISBURSEMENT_DATE);
372: logmessage(fnd_log.level_statement, 'PAYEE_PARTY_ID = ' || P_DISB_TBL(i).PAYEE_PARTY_ID);
373: logmessage(fnd_log.level_statement, 'BANK_ACCOUNT_ID = ' || P_DISB_TBL(i).BANK_ACCOUNT_ID);
374: logmessage(fnd_log.level_statement, 'PAYMENT_METHOD_CODE = ' || P_DISB_TBL(i).PAYMENT_METHOD_CODE);
375:
376: if P_DISB_TBL(i).ACTIVITY_CODE is null and P_DISB_TBL(i).DESCRIPTION is null then
377: logerrors(p_message_name => 'LNS_LCREATE_NULL_VALUE',

Line 374: logmessage(fnd_log.level_statement, 'PAYMENT_METHOD_CODE = ' || P_DISB_TBL(i).PAYMENT_METHOD_CODE);

370: logmessage(fnd_log.level_statement, 'SUBMISSION_DATE = ' || P_DISB_TBL(i).SUBMISSION_DATE);
371: logmessage(fnd_log.level_statement, 'DISBURSEMENT_DATE = ' || P_DISB_TBL(i).DISBURSEMENT_DATE);
372: logmessage(fnd_log.level_statement, 'PAYEE_PARTY_ID = ' || P_DISB_TBL(i).PAYEE_PARTY_ID);
373: logmessage(fnd_log.level_statement, 'BANK_ACCOUNT_ID = ' || P_DISB_TBL(i).BANK_ACCOUNT_ID);
374: logmessage(fnd_log.level_statement, 'PAYMENT_METHOD_CODE = ' || P_DISB_TBL(i).PAYMENT_METHOD_CODE);
375:
376: if P_DISB_TBL(i).ACTIVITY_CODE is null and P_DISB_TBL(i).DESCRIPTION is null then
377: logerrors(p_message_name => 'LNS_LCREATE_NULL_VALUE',
378: p_token1 => 'P_DISB_TBL(' || i || ').ACTIVITY_CODE, P_DISB_TBL(' || i || ').DESCRIPTION');

Line 458: logmessage(fnd_log.level_procedure, g_pkg_name || '.' || l_api_name || ' -');

454:
455: -- END OF BODY OF API
456: x_return_status := fnd_api.g_ret_sts_success;
457:
458: logmessage(fnd_log.level_procedure, g_pkg_name || '.' || l_api_name || ' -');
459:
460: EXCEPTION
461: WHEN fnd_api.g_exc_error THEN
462: x_return_status := fnd_api.g_ret_sts_error;

Line 586: logmessage(fnd_log.level_procedure, g_pkg_name || '.' || l_api_name || ' +');

582: order by begin_installment_number;
583:
584: BEGIN
585:
586: logmessage(fnd_log.level_procedure, g_pkg_name || '.' || l_api_name || ' +');
587:
588: -- Standard start of API savepoint
589: SAVEPOINT import_loan;
590: logmessage(fnd_log.level_statement, 'Savepoint is established');

Line 590: logmessage(fnd_log.level_statement, 'Savepoint is established');

586: logmessage(fnd_log.level_procedure, g_pkg_name || '.' || l_api_name || ' +');
587:
588: -- Standard start of API savepoint
589: SAVEPOINT import_loan;
590: logmessage(fnd_log.level_statement, 'Savepoint is established');
591:
592: -- Standard call to check for call compatibility
593:
594: IF NOT fnd_api.compatible_api_call(l_api_version, p_api_version, l_api_name, g_pkg_name) THEN

Line 628: logmessage(fnd_log.level_statement, 'Validating product...');

624: RAISE fnd_api.g_exc_error;
625: END;
626:
627: /*
628: logmessage(fnd_log.level_statement, 'Validating product...');
629: BEGIN
630: SELECT 'Y'
631: INTO l_dummy
632: from lns_loan_types loan_type,

Line 645: logmessage(fnd_log.level_statement, 'Preparing P_Loan_Details_Rec data...');

641: p_token2 => P_Loan_Details_Rec.product_id);
642: RAISE fnd_api.g_exc_error;
643: END;
644: */
645: logmessage(fnd_log.level_statement, 'Preparing P_Loan_Details_Rec data...');
646:
647: -- common attributes
648: l_LOAN_DTL_REC.product_id := P_Loan_Details_Rec.product_id;
649: l_LOAN_DTL_REC.LOAN_NUMBER := P_Loan_Details_Rec.LOAN_NUMBER;

Line 741: logmessage(fnd_log.level_statement, 'Preparing p_loan_lines_tbl data...');

737:
738: P_Loan_Details_Rec.funded_amount := 0;
739: if l_loan_class = 'ERS' then
740: -- copy loan lines
741: logmessage(fnd_log.level_statement, 'Preparing p_loan_lines_tbl data...');
742: FOR i IN 1 .. p_loan_lines_tbl.count LOOP
743:
744: l_LOAN_LINES_TBL(i).line_number := i;
745: l_LOAN_LINES_TBL(i).payment_schedule_id := -1;

Line 755: logmessage(fnd_log.level_statement, 'Preparing p_loan_part_tbl data...');

751: END LOOP;
752: end if;
753:
754: -- copy loan participants
755: logmessage(fnd_log.level_statement, 'Preparing p_loan_part_tbl data...');
756: FOR i IN 1 .. p_loan_part_tbl.count LOOP
757:
758: l_LOAN_PART_TBL(i).HZ_PARTY_ID := P_LOAN_PART_TBL(i).HZ_PARTY_ID;
759: l_LOAN_PART_TBL(i).LOAN_PARTICIPANT_TYPE := P_LOAN_PART_TBL(i).LOAN_PARTICIPANT_TYPE;

Line 770: logmessage(fnd_log.level_statement, 'Preparing p_loan_rates_tbl data...');

766:
767: END LOOP;
768:
769: -- copy rate schedule
770: logmessage(fnd_log.level_statement, 'Preparing p_loan_rates_tbl data...');
771: FOR i IN 1 .. p_loan_rates_tbl.count LOOP
772:
773: l_LOAN_RATES_TBL(i).INDEX_RATE := p_loan_rates_tbl(i).INDEX_RATE;
774: l_LOAN_RATES_TBL(i).SPREAD := p_loan_rates_tbl(i).SPREAD;

Line 783: logmessage(fnd_log.level_statement, 'Preparing p_loan_cust_sched_tbl data...');

779:
780: END LOOP;
781:
782: -- copy custom schedule
783: logmessage(fnd_log.level_statement, 'Preparing p_loan_cust_sched_tbl data...');
784: FOR i IN 1 .. p_loan_cust_sched_tbl.count LOOP
785:
786: l_loan_cust_sched_tbl(i).DUE_DATE := p_loan_cust_sched_tbl(i).DUE_DATE;
787: l_loan_cust_sched_tbl(i).RELATIVE_DATE := p_loan_cust_sched_tbl(i).RELATIVE_DATE;

Line 796: logmessage(fnd_log.level_statement, 'Calling LNS_LOAN_PUB.CREATE_LOAN...');

792: l_loan_cust_sched_tbl(i).LOCK_INT := p_loan_cust_sched_tbl(i).LOCK_INT;
793:
794: END LOOP;
795:
796: logmessage(fnd_log.level_statement, 'Calling LNS_LOAN_PUB.CREATE_LOAN...');
797: LNS_LOAN_PUB.CREATE_LOAN(
798: P_API_VERSION => 1.0,
799: P_INIT_MSG_LIST => FND_API.G_TRUE,
800: P_COMMIT => FND_API.G_FALSE,

Line 820: logmessage(fnd_log.level_unexpected, 'Loan object created successfully. New loan_id = ' || l_loan_id);

816: IF l_return_status <> 'S' THEN
817: RAISE fnd_api.g_exc_error;
818: END IF;
819:
820: logmessage(fnd_log.level_unexpected, 'Loan object created successfully. New loan_id = ' || l_loan_id);
821:
822: -- copy loan details data back
823: -- common attributes
824: P_Loan_Details_Rec.product_id := l_LOAN_DTL_REC.product_id;

Line 958: logmessage(fnd_log.level_statement, 'Validating Loan Approved Date...');

954: p_loan_cust_sched_tbl(i).LOCK_INT := l_loan_cust_sched_tbl(i).LOCK_INT;
955:
956: END LOOP;
957:
958: logmessage(fnd_log.level_statement, 'Validating Loan Approved Date...');
959:
960: IF P_Loan_Details_Rec.loan_approval_date IS NULL THEN
961: logerrors(p_message_name => 'LNS_LCREATE_NULL_VALUE',
962: p_token1 => 'P_Loan_Details_Rec.loan_approval_date');

Line 973: logmessage(fnd_log.level_statement, 'Validating Loan Approved By...');

969: p_token2 => P_Loan_Details_Rec.loan_approval_date);
970: END IF;
971: END IF;
972:
973: logmessage(fnd_log.level_statement, 'Validating Loan Approved By...');
974:
975: IF P_Loan_Details_Rec.loan_approved_by IS NULL THEN
976: logerrors(p_message_name => 'LNS_LCREATE_NULL_VALUE',
977: p_token1 => 'P_Loan_Details_Rec.loan_approved_by');

Line 1008: logmessage(fnd_log.level_unexpected, 'Calling validate_disbursements...');

1004: END IF;
1005:
1006: if l_loan_class = 'DIRECT' then
1007:
1008: logmessage(fnd_log.level_unexpected, 'Calling validate_disbursements...');
1009: validate_disbursements(P_Loan_Details_Rec
1010: ,P_DISB_TBL
1011: , l_return_status
1012: , l_msg_count

Line 1016: logmessage(fnd_log.level_unexpected, 'Validation failed in module - validate_disbursements()');

1012: , l_msg_count
1013: , l_msg_data);
1014:
1015: IF l_return_status <> 'S' THEN
1016: logmessage(fnd_log.level_unexpected, 'Validation failed in module - validate_disbursements()');
1017: RAISE fnd_api.g_exc_error;
1018: END IF;
1019:
1020: IF g_error_count > 0 THEN

Line 1041: LogMessage(FND_LOG.LEVEL_STATEMENT, 'Calling INSERT_DISB_HEADER...');

1037: if P_DISB_TBL(l_count).DISBURSEMENT_DATE is not null then
1038: l_DISB_HEADER_REC.STATUS := 'FULLY_FUNDED';
1039: end if;
1040:
1041: LogMessage(FND_LOG.LEVEL_STATEMENT, 'Calling INSERT_DISB_HEADER...');
1042: LNS_FUNDING_PUB.INSERT_DISB_HEADER(
1043: P_API_VERSION => 1.0,
1044: P_INIT_MSG_LIST => FND_API.G_TRUE,
1045: P_COMMIT => FND_API.G_FALSE,

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

1048: X_RETURN_STATUS => l_return_status,
1049: X_MSG_COUNT => l_msg_count,
1050: X_MSG_DATA => l_msg_data);
1051:
1052: LogMessage(FND_LOG.LEVEL_STATEMENT, 'l_return_status: ' || l_return_status);
1053: IF l_return_status <> 'S' THEN
1054: logmessage(fnd_log.level_unexpected, 'Call to INSERT_DISB_HEADER failed');
1055: RAISE fnd_api.g_exc_error;
1056: END IF;

Line 1054: logmessage(fnd_log.level_unexpected, 'Call to INSERT_DISB_HEADER failed');

1050: X_MSG_DATA => l_msg_data);
1051:
1052: LogMessage(FND_LOG.LEVEL_STATEMENT, 'l_return_status: ' || l_return_status);
1053: IF l_return_status <> 'S' THEN
1054: logmessage(fnd_log.level_unexpected, 'Call to INSERT_DISB_HEADER failed');
1055: RAISE fnd_api.g_exc_error;
1056: END IF;
1057:
1058: -- create disb line

Line 1073: LogMessage(FND_LOG.LEVEL_STATEMENT, 'Calling INSERT_DISB_LINE...');

1069: l_DISB_LINE_REC.STATUS := l_DISB_HEADER_REC.STATUS;
1070: l_DISB_LINE_REC.REQUEST_DATE := P_DISB_TBL(l_count).SUBMISSION_DATE;
1071: l_DISB_LINE_REC.DISBURSEMENT_DATE := P_DISB_TBL(l_count).DISBURSEMENT_DATE;
1072:
1073: LogMessage(FND_LOG.LEVEL_STATEMENT, 'Calling INSERT_DISB_LINE...');
1074: LNS_FUNDING_PUB.INSERT_DISB_LINE(
1075: P_API_VERSION => 1.0,
1076: P_INIT_MSG_LIST => FND_API.G_TRUE,
1077: P_COMMIT => FND_API.G_FALSE,

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

1080: X_RETURN_STATUS => l_return_status,
1081: X_MSG_COUNT => l_msg_count,
1082: X_MSG_DATA => l_msg_data);
1083:
1084: LogMessage(FND_LOG.LEVEL_STATEMENT, 'l_return_status: ' || l_return_status);
1085: IF l_return_status <> 'S' THEN
1086: logmessage(fnd_log.level_unexpected, 'Call to INSERT_DISB_LINE failed');
1087: RAISE fnd_api.g_exc_error;
1088: END IF;

Line 1086: logmessage(fnd_log.level_unexpected, 'Call to INSERT_DISB_LINE failed');

1082: X_MSG_DATA => l_msg_data);
1083:
1084: LogMessage(FND_LOG.LEVEL_STATEMENT, 'l_return_status: ' || l_return_status);
1085: IF l_return_status <> 'S' THEN
1086: logmessage(fnd_log.level_unexpected, 'Call to INSERT_DISB_LINE failed');
1087: RAISE fnd_api.g_exc_error;
1088: END IF;
1089:
1090: END LOOP;

Line 1099: logmessage(fnd_log.level_unexpected, 'Updated loan lines');

1095: UPDATE LNS_LOAN_LINES
1096: SET ADJUSTMENT_DATE = P_Loan_Details_Rec.LOAN_START_DATE,
1097: STATUS = 'APPROVED'
1098: WHERE LOAN_ID = l_loan_id;
1099: logmessage(fnd_log.level_unexpected, 'Updated loan lines');
1100:
1101: end if;
1102:
1103: -- store accounting

Line 1132: logmessage(fnd_log.level_unexpected, fnd_msg_pub.GET(p_encoded => 'F'));

1128:
1129: IF l_return_status <> 'S' THEN
1130: fnd_message.set_name('LNS', 'LNS_DISTRIBUTION_INVALID');
1131: fnd_msg_pub.ADD;
1132: logmessage(fnd_log.level_unexpected, fnd_msg_pub.GET(p_encoded => 'F'));
1133: RAISE fnd_api.g_exc_error;
1134: END IF;
1135:
1136: logmessage(fnd_log.level_unexpected, 'Distributions created successfully');

Line 1136: logmessage(fnd_log.level_unexpected, 'Distributions created successfully');

1132: logmessage(fnd_log.level_unexpected, fnd_msg_pub.GET(p_encoded => 'F'));
1133: RAISE fnd_api.g_exc_error;
1134: END IF;
1135:
1136: logmessage(fnd_log.level_unexpected, 'Distributions created successfully');
1137:
1138: -- generate and store agreement report
1139: LNS_REP_UTILS.STORE_LOAN_AGREEMENT(l_loan_id);
1140: logmessage(fnd_log.level_unexpected, 'Agreement report created successfully');

Line 1140: logmessage(fnd_log.level_unexpected, 'Agreement report created successfully');

1136: logmessage(fnd_log.level_unexpected, 'Distributions created successfully');
1137:
1138: -- generate and store agreement report
1139: LNS_REP_UTILS.STORE_LOAN_AGREEMENT(l_loan_id);
1140: logmessage(fnd_log.level_unexpected, 'Agreement report created successfully');
1141:
1142: logmessage(fnd_log.LEVEL_STATEMENT, 'Updating Loan object...');
1143: SELECT object_version_number, loan_number
1144: INTO l_version_number, l_loan_number

Line 1142: logmessage(fnd_log.LEVEL_STATEMENT, 'Updating Loan object...');

1138: -- generate and store agreement report
1139: LNS_REP_UTILS.STORE_LOAN_AGREEMENT(l_loan_id);
1140: logmessage(fnd_log.level_unexpected, 'Agreement report created successfully');
1141:
1142: logmessage(fnd_log.LEVEL_STATEMENT, 'Updating Loan object...');
1143: SELECT object_version_number, loan_number
1144: INTO l_version_number, l_loan_number
1145: FROM lns_loan_headers_all
1146: WHERE loan_id = l_loan_id;

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

1158: X_RETURN_STATUS => l_return_status,
1159: X_MSG_COUNT => l_msg_count,
1160: X_MSG_DATA => l_msg_data);
1161:
1162: LogMessage(FND_LOG.LEVEL_STATEMENT, 'l_return_status: ' || l_return_status);
1163:
1164: IF l_return_status <> 'S' THEN
1165: logerrors(p_message_name => 'LNS_UPD_LOAN_FAIL');
1166: RAISE fnd_api.g_exc_error;

Line 1168: logmessage(fnd_log.level_unexpected, 'Loan object updated successfully');

1164: IF l_return_status <> 'S' THEN
1165: logerrors(p_message_name => 'LNS_UPD_LOAN_FAIL');
1166: RAISE fnd_api.g_exc_error;
1167: END IF;
1168: logmessage(fnd_log.level_unexpected, 'Loan object updated successfully');
1169:
1170: logmessage(fnd_log.level_unexpected, 'Calling validate_pay_history...');
1171: validate_pay_history(P_Loan_Details_Rec
1172: ,P_PAY_HIST_TBL

Line 1170: logmessage(fnd_log.level_unexpected, 'Calling validate_pay_history...');

1166: RAISE fnd_api.g_exc_error;
1167: END IF;
1168: logmessage(fnd_log.level_unexpected, 'Loan object updated successfully');
1169:
1170: logmessage(fnd_log.level_unexpected, 'Calling validate_pay_history...');
1171: validate_pay_history(P_Loan_Details_Rec
1172: ,P_PAY_HIST_TBL
1173: , l_return_status
1174: , l_msg_count

Line 1178: logmessage(fnd_log.level_unexpected, 'Validation failed in module - validate_pay_history()');

1174: , l_msg_count
1175: , l_msg_data);
1176:
1177: IF l_return_status <> 'S' THEN
1178: logmessage(fnd_log.level_unexpected, 'Validation failed in module - validate_pay_history()');
1179: RAISE fnd_api.g_exc_error;
1180: END IF;
1181:
1182: IF g_error_count > 0 THEN

Line 1196: logmessage(fnd_log.level_statement, 'Creating bill ' || P_PAY_HIST_TBL(l_count).PAYMENT_NUMBER || ' ' || P_PAY_HIST_TBL(l_count).SOURCE || '...');

1192:
1193: l_bill_headers_tbl.delete;
1194: l_bill_lines_tbl.delete;
1195:
1196: logmessage(fnd_log.level_statement, 'Creating bill ' || P_PAY_HIST_TBL(l_count).PAYMENT_NUMBER || ' ' || P_PAY_HIST_TBL(l_count).SOURCE || '...');
1197: l_bill_headers_tbl(1).header_id := 101;
1198: l_bill_headers_tbl(1).loan_id := l_loan_id;
1199: l_bill_headers_tbl(1).assoc_payment_num := P_PAY_HIST_TBL(l_count).PAYMENT_NUMBER;
1200: l_bill_headers_tbl(1).due_date := P_PAY_HIST_TBL(l_count).DUE_DATE;

Line 1211: logmessage(fnd_log.level_statement, 'Principal = ' || l_bill_lines_tbl(l_lines_count).line_amount);

1207: l_bill_lines_tbl(l_lines_count).header_id := l_bill_headers_tbl(1).header_id;
1208: l_bill_lines_tbl(l_lines_count).line_amount := P_PAY_HIST_TBL(l_count).BILLED_PRIN;
1209: l_bill_lines_tbl(l_lines_count).line_type := 'PRIN';
1210: l_bill_lines_tbl(l_lines_count).line_desc := P_Loan_Details_Rec.legacy_reference;
1211: logmessage(fnd_log.level_statement, 'Principal = ' || l_bill_lines_tbl(l_lines_count).line_amount);
1212: END IF;
1213:
1214: IF(P_PAY_HIST_TBL(l_count).BILLED_INT > 0) THEN
1215: l_lines_count := l_lines_count + 1;

Line 1221: logmessage(fnd_log.level_statement, 'Interest = ' || l_bill_lines_tbl(l_lines_count).line_amount);

1217: l_bill_lines_tbl(l_lines_count).header_id := l_bill_headers_tbl(1).header_id;
1218: l_bill_lines_tbl(l_lines_count).line_amount := P_PAY_HIST_TBL(l_count).BILLED_INT;
1219: l_bill_lines_tbl(l_lines_count).line_type := 'INT';
1220: l_bill_lines_tbl(l_lines_count).line_desc := P_Loan_Details_Rec.legacy_reference;
1221: logmessage(fnd_log.level_statement, 'Interest = ' || l_bill_lines_tbl(l_lines_count).line_amount);
1222: END IF;
1223:
1224: IF(P_PAY_HIST_TBL(l_count).BILLED_FEE > 0) THEN
1225: l_lines_count := l_lines_count + 1;

Line 1231: logmessage(fnd_log.level_statement, 'Fees = ' || l_bill_lines_tbl(l_lines_count).line_amount);

1227: l_bill_lines_tbl(l_lines_count).header_id := l_bill_headers_tbl(1).header_id;
1228: l_bill_lines_tbl(l_lines_count).line_amount := P_PAY_HIST_TBL(l_count).BILLED_FEE;
1229: l_bill_lines_tbl(l_lines_count).line_type := 'FEE';
1230: l_bill_lines_tbl(l_lines_count).line_desc := P_Loan_Details_Rec.legacy_reference;
1231: logmessage(fnd_log.level_statement, 'Fees = ' || l_bill_lines_tbl(l_lines_count).line_amount);
1232: END IF;
1233:
1234: LNS_BILLING_BATCH_PUB.CREATE_OFFCYCLE_BILLS(
1235: P_API_VERSION => 1.0,

Line 1249: logmessage(fnd_log.level_unexpected, 'Bill ' || P_PAY_HIST_TBL(l_count).PAYMENT_NUMBER || ' created successfully');

1245: IF l_return_status <> 'S' THEN
1246: RAISE fnd_api.g_exc_error;
1247: END IF;
1248:
1249: logmessage(fnd_log.level_unexpected, 'Bill ' || P_PAY_HIST_TBL(l_count).PAYMENT_NUMBER || ' created successfully');
1250:
1251: if P_PAY_HIST_TBL(l_count).SOURCE = 'SCHEDULED' then
1252:
1253: UPDATE lns_amortization_scheds

Line 1260: logmessage(fnd_log.level_statement, 'Updated lns_amortization_scheds');

1256: WHERE amortization_schedule_id =
1257: (SELECT last_amortization_id
1258: FROM lns_loan_headers_all
1259: WHERE loan_id = l_loan_id);
1260: logmessage(fnd_log.level_statement, 'Updated lns_amortization_scheds');
1261:
1262: else
1263:
1264: UPDATE lns_amortization_scheds

Line 1270: logmessage(fnd_log.level_statement, 'Updated lns_amortization_scheds');

1266: WHERE amortization_schedule_id =
1267: (SELECT last_amortization_id
1268: FROM lns_loan_headers_all
1269: WHERE loan_id = l_loan_id);
1270: logmessage(fnd_log.level_statement, 'Updated lns_amortization_scheds');
1271:
1272: end if;
1273:
1274: l_paid_total := P_PAY_HIST_TBL(l_count).PAID_PRIN + P_PAY_HIST_TBL(l_count).PAID_INT + P_PAY_HIST_TBL(l_count).PAID_FEE;

Line 1280: logmessage(fnd_log.level_statement, 'Creating cash receipt...');

1276: if l_paid_total > 0 then
1277:
1278: if P_PAY_HIST_TBL(l_count).RC_ID is null then
1279:
1280: logmessage(fnd_log.level_statement, 'Creating cash receipt...');
1281:
1282: if P_Loan_Details_Rec.LEGACY_REFERENCE is null then
1283: l_receipt_number := l_loan_number;
1284: else

Line 1310: logmessage(fnd_log.level_unexpected, 'Cash receipt created successfully; id = ' || l_cr_id);

1306: IF l_return_status <> 'S' THEN
1307: RAISE fnd_api.g_exc_error;
1308: END IF;
1309:
1310: logmessage(fnd_log.level_unexpected, 'Cash receipt created successfully; id = ' || l_cr_id);
1311: ELSE
1312: l_cr_id := P_PAY_HIST_TBL(l_count).RC_ID;
1313: logmessage(fnd_log.level_statement, 'Using passed cash receipt id = ' || l_cr_id);
1314: END IF;

Line 1313: logmessage(fnd_log.level_statement, 'Using passed cash receipt id = ' || l_cr_id);

1309:
1310: logmessage(fnd_log.level_unexpected, 'Cash receipt created successfully; id = ' || l_cr_id);
1311: ELSE
1312: l_cr_id := P_PAY_HIST_TBL(l_count).RC_ID;
1313: logmessage(fnd_log.level_statement, 'Using passed cash receipt id = ' || l_cr_id);
1314: END IF;
1315:
1316: SELECT principal_trx_id,
1317: interest_trx_id,

Line 1333: logmessage(fnd_log.level_statement, 'Paying principal amount ' || P_PAY_HIST_TBL(l_count).PAID_PRIN ||' for transactionId ' || l_principal_trx_id);

1329: IF(P_PAY_HIST_TBL(l_count).BILLED_PRIN > 0 AND
1330: P_PAY_HIST_TBL(l_count).PAID_PRIN > 0 AND
1331: l_principal_trx_id IS NOT NULL) THEN
1332:
1333: logmessage(fnd_log.level_statement, 'Paying principal amount ' || P_PAY_HIST_TBL(l_count).PAID_PRIN ||' for transactionId ' || l_principal_trx_id);
1334: AR_RECEIPT_API_PUB.APPLY(P_API_VERSION => 1.0
1335: ,P_INIT_MSG_LIST => FND_API.G_FALSE
1336: ,P_COMMIT => FND_API.G_FALSE
1337: ,X_RETURN_STATUS => l_return_status

Line 1352: logmessage(fnd_log.level_unexpected, fnd_msg_pub.GET(p_encoded => 'F'));

1348:
1349: IF l_return_status <> 'S' THEN
1350: fnd_message.set_name('LNS', 'LNS_APPL_CR_FAIL');
1351: fnd_msg_pub.ADD;
1352: logmessage(fnd_log.level_unexpected, fnd_msg_pub.GET(p_encoded => 'F'));
1353: RAISE fnd_api.g_exc_error;
1354: END IF;
1355:
1356: logmessage(fnd_log.level_unexpected, 'Principal paid successfully');

Line 1356: logmessage(fnd_log.level_unexpected, 'Principal paid successfully');

1352: logmessage(fnd_log.level_unexpected, fnd_msg_pub.GET(p_encoded => 'F'));
1353: RAISE fnd_api.g_exc_error;
1354: END IF;
1355:
1356: logmessage(fnd_log.level_unexpected, 'Principal paid successfully');
1357:
1358: END IF;
1359:
1360: IF(P_PAY_HIST_TBL(l_count).BILLED_INT > 0 AND

Line 1364: logmessage(fnd_log.level_statement, 'Paying interest amount ' || P_PAY_HIST_TBL(l_count).PAID_INT || ' with transactionid ' || l_interest_trx_id);

1360: IF(P_PAY_HIST_TBL(l_count).BILLED_INT > 0 AND
1361: P_PAY_HIST_TBL(l_count).PAID_INT > 0 AND
1362: l_interest_trx_id IS NOT NULL) THEN
1363:
1364: logmessage(fnd_log.level_statement, 'Paying interest amount ' || P_PAY_HIST_TBL(l_count).PAID_INT || ' with transactionid ' || l_interest_trx_id);
1365:
1366: AR_RECEIPT_API_PUB.APPLY(P_API_VERSION => 1.0
1367: ,P_INIT_MSG_LIST => FND_API.G_FALSE
1368: ,P_COMMIT => FND_API.G_FALSE

Line 1384: logmessage(fnd_log.level_unexpected, fnd_msg_pub.GET(p_encoded => 'F'));

1380:
1381: IF l_return_status <> 'S' THEN
1382: fnd_message.set_name('LNS', 'LNS_APPL_CR_FAIL');
1383: fnd_msg_pub.ADD;
1384: logmessage(fnd_log.level_unexpected, fnd_msg_pub.GET(p_encoded => 'F'));
1385: RAISE fnd_api.g_exc_error;
1386: END IF;
1387:
1388: logmessage(fnd_log.level_unexpected, 'Interest paid successfully');

Line 1388: logmessage(fnd_log.level_unexpected, 'Interest paid successfully');

1384: logmessage(fnd_log.level_unexpected, fnd_msg_pub.GET(p_encoded => 'F'));
1385: RAISE fnd_api.g_exc_error;
1386: END IF;
1387:
1388: logmessage(fnd_log.level_unexpected, 'Interest paid successfully');
1389:
1390: END IF;
1391:
1392: IF(P_PAY_HIST_TBL(l_count).BILLED_FEE > 0 AND

Line 1396: logmessage(fnd_log.level_statement, 'Paying fee amount ' || P_PAY_HIST_TBL(l_count).PAID_FEE || ' with transactionid ' || l_fee_trx_id);

1392: IF(P_PAY_HIST_TBL(l_count).BILLED_FEE > 0 AND
1393: P_PAY_HIST_TBL(l_count).PAID_FEE > 0 AND
1394: l_fee_trx_id IS NOT NULL) THEN
1395:
1396: logmessage(fnd_log.level_statement, 'Paying fee amount ' || P_PAY_HIST_TBL(l_count).PAID_FEE || ' with transactionid ' || l_fee_trx_id);
1397:
1398: AR_RECEIPT_API_PUB.APPLY(P_API_VERSION => 1.0
1399: ,P_INIT_MSG_LIST => FND_API.G_FALSE
1400: ,P_COMMIT => FND_API.G_FALSE

Line 1416: logmessage(fnd_log.level_unexpected, fnd_msg_pub.GET(p_encoded => 'F'));

1412:
1413: IF l_return_status <> 'S' THEN
1414: fnd_message.set_name('LNS', 'LNS_APPL_CR_FAIL');
1415: fnd_msg_pub.ADD;
1416: logmessage(fnd_log.level_unexpected, fnd_msg_pub.GET(p_encoded => 'F'));
1417: RAISE fnd_api.g_exc_error;
1418: END IF;
1419:
1420: logmessage(fnd_log.level_unexpected, 'Fee paid successfully');

Line 1420: logmessage(fnd_log.level_unexpected, 'Fee paid successfully');

1416: logmessage(fnd_log.level_unexpected, fnd_msg_pub.GET(p_encoded => 'F'));
1417: RAISE fnd_api.g_exc_error;
1418: END IF;
1419:
1420: logmessage(fnd_log.level_unexpected, 'Fee paid successfully');
1421:
1422: END IF;
1423:
1424: END IF; --if l_paid_total > 0 then

Line 1448: -- LogMessage(FND_LOG.LEVEL_UNEXPECTED, 'ERROR: Failed to update term object.');

1444: , x_msg_count => l_msg_count
1445: , x_msg_data => l_msg_data);
1446:
1447: IF l_return_status <> 'S' THEN
1448: -- LogMessage(FND_LOG.LEVEL_UNEXPECTED, 'ERROR: Failed to update term object.');
1449: fnd_message.set_name('LNS', 'LNS_IMRT_FAIL_UPD_TERM');
1450: fnd_msg_pub.ADD;
1451: logmessage(fnd_log.level_unexpected, fnd_msg_pub.GET(p_encoded => 'F'));
1452: RAISE fnd_api.g_exc_error;

Line 1451: logmessage(fnd_log.level_unexpected, fnd_msg_pub.GET(p_encoded => 'F'));

1447: IF l_return_status <> 'S' THEN
1448: -- LogMessage(FND_LOG.LEVEL_UNEXPECTED, 'ERROR: Failed to update term object.');
1449: fnd_message.set_name('LNS', 'LNS_IMRT_FAIL_UPD_TERM');
1450: fnd_msg_pub.ADD;
1451: logmessage(fnd_log.level_unexpected, fnd_msg_pub.GET(p_encoded => 'F'));
1452: RAISE fnd_api.g_exc_error;
1453: END IF;
1454:
1455: logmessage(fnd_log.level_unexpected, 'Term object updated successfully');

Line 1455: logmessage(fnd_log.level_unexpected, 'Term object updated successfully');

1451: logmessage(fnd_log.level_unexpected, fnd_msg_pub.GET(p_encoded => 'F'));
1452: RAISE fnd_api.g_exc_error;
1453: END IF;
1454:
1455: logmessage(fnd_log.level_unexpected, 'Term object updated successfully');
1456:
1457: -- if rate_type = 'FLOATING', run UPDATE_LOAN_FLOATING_RATE
1458: if P_Loan_Details_Rec.RATE_TYPE = 'FLOATING' then
1459:

Line 1460: logmessage(fnd_log.level_statement, 'Updating floating rate schedule...');

1456:
1457: -- if rate_type = 'FLOATING', run UPDATE_LOAN_FLOATING_RATE
1458: if P_Loan_Details_Rec.RATE_TYPE = 'FLOATING' then
1459:
1460: logmessage(fnd_log.level_statement, 'Updating floating rate schedule...');
1461: LNS_INDEX_RATES_PUB.UPDATE_LOAN_FLOATING_RATE(
1462: P_API_VERSION => 1.0,
1463: P_INIT_MSG_LIST => FND_API.G_FALSE,
1464: P_COMMIT => FND_API.G_FALSE,

Line 1475: logmessage(fnd_log.LEVEL_UNEXPECTED, 'Floating rate schedule updated successfully');

1471: IF l_return_status <> 'S' THEN
1472: RAISE fnd_api.g_exc_error;
1473: END IF;
1474:
1475: logmessage(fnd_log.LEVEL_UNEXPECTED, 'Floating rate schedule updated successfully');
1476:
1477: -- fetching new rate schedule
1478: p_LOAN_RATES_TBL.delete;
1479: i := 0;

Line 1502: logmessage(fnd_log.level_statement, 'Commited');

1498: end if;
1499:
1500: IF p_commit = fnd_api.g_true THEN
1501: COMMIT WORK;
1502: logmessage(fnd_log.level_statement, 'Commited');
1503: END IF;
1504:
1505: x_loan_id := l_loan_id;
1506:

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

1506:
1507: -- END OF BODY OF API
1508: x_return_status := fnd_api.g_ret_sts_success;
1509:
1510: LogMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME || '.' || l_api_name || ' -');
1511:
1512: EXCEPTION
1513: WHEN OTHERS THEN
1514: --InsertErrors;

Line 1516: LogMessage(FND_LOG.LEVEL_UNEXPECTED, 'Rollbacked');

1512: EXCEPTION
1513: WHEN OTHERS THEN
1514: --InsertErrors;
1515: ROLLBACK TO import_loan;
1516: LogMessage(FND_LOG.LEVEL_UNEXPECTED, 'Rollbacked');
1517: X_RETURN_STATUS := 'E';
1518: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
1519: END IMPORT_LOAN;
1520:

Line 1525: G_MSG_LEVEL := FND_LOG.LEVEL_UNEXPECTED;

1521:
1522:
1523: BEGIN
1524: G_LOG_ENABLED := 'N';
1525: G_MSG_LEVEL := FND_LOG.LEVEL_UNEXPECTED;
1526:
1527: /* getting msg logging info */
1528: G_LOG_ENABLED := NVL(FND_PROFILE.VALUE('AFLOG_ENABLED'), 'N');
1529: if (G_LOG_ENABLED = 'N') then

Line 1530: G_MSG_LEVEL := FND_LOG.LEVEL_UNEXPECTED;

1526:
1527: /* getting msg logging info */
1528: G_LOG_ENABLED := NVL(FND_PROFILE.VALUE('AFLOG_ENABLED'), 'N');
1529: if (G_LOG_ENABLED = 'N') then
1530: G_MSG_LEVEL := FND_LOG.LEVEL_UNEXPECTED;
1531: else
1532: G_MSG_LEVEL := NVL(to_number(FND_PROFILE.VALUE('AFLOG_LEVEL')), FND_LOG.LEVEL_UNEXPECTED);
1533: end if;
1534:

Line 1532: G_MSG_LEVEL := NVL(to_number(FND_PROFILE.VALUE('AFLOG_LEVEL')), FND_LOG.LEVEL_UNEXPECTED);

1528: G_LOG_ENABLED := NVL(FND_PROFILE.VALUE('AFLOG_ENABLED'), 'N');
1529: if (G_LOG_ENABLED = 'N') then
1530: G_MSG_LEVEL := FND_LOG.LEVEL_UNEXPECTED;
1531: else
1532: G_MSG_LEVEL := NVL(to_number(FND_PROFILE.VALUE('AFLOG_LEVEL')), FND_LOG.LEVEL_UNEXPECTED);
1533: end if;
1534:
1535: LogMessage(FND_LOG.LEVEL_STATEMENT, 'G_LOG_ENABLED: ' || G_LOG_ENABLED);
1536: LogMessage(FND_LOG.LEVEL_STATEMENT, 'G_MSG_LEVEL: ' || G_MSG_LEVEL);

Line 1535: LogMessage(FND_LOG.LEVEL_STATEMENT, 'G_LOG_ENABLED: ' || G_LOG_ENABLED);

1531: else
1532: G_MSG_LEVEL := NVL(to_number(FND_PROFILE.VALUE('AFLOG_LEVEL')), FND_LOG.LEVEL_UNEXPECTED);
1533: end if;
1534:
1535: LogMessage(FND_LOG.LEVEL_STATEMENT, 'G_LOG_ENABLED: ' || G_LOG_ENABLED);
1536: LogMessage(FND_LOG.LEVEL_STATEMENT, 'G_MSG_LEVEL: ' || G_MSG_LEVEL);
1537:
1538: END;

Line 1536: LogMessage(FND_LOG.LEVEL_STATEMENT, 'G_MSG_LEVEL: ' || G_MSG_LEVEL);

1532: G_MSG_LEVEL := NVL(to_number(FND_PROFILE.VALUE('AFLOG_LEVEL')), FND_LOG.LEVEL_UNEXPECTED);
1533: end if;
1534:
1535: LogMessage(FND_LOG.LEVEL_STATEMENT, 'G_LOG_ENABLED: ' || G_LOG_ENABLED);
1536: LogMessage(FND_LOG.LEVEL_STATEMENT, 'G_MSG_LEVEL: ' || G_MSG_LEVEL);
1537:
1538: END;