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_IMPORT_LOAN_PUB dependencies on FND_API

Line 322: RAISE fnd_api.g_exc_error;

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;
324:
325: P_PAY_HIST_TBL := l_tem_pay_hist_tbl;
326:

Line 328: x_return_status := fnd_api.g_ret_sts_success;

324:
325: P_PAY_HIST_TBL := l_tem_pay_hist_tbl;
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

Line 333: WHEN fnd_api.g_exc_error THEN

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;
335: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
336: WHEN fnd_api.g_exc_unexpected_error THEN
337: x_return_status := fnd_api.g_ret_sts_unexp_error;

Line 334: x_return_status := fnd_api.g_ret_sts_error;

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;
335: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
336: WHEN fnd_api.g_exc_unexpected_error THEN
337: x_return_status := fnd_api.g_ret_sts_unexp_error;
338: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);

Line 336: WHEN fnd_api.g_exc_unexpected_error THEN

332: EXCEPTION
333: WHEN fnd_api.g_exc_error THEN
334: x_return_status := fnd_api.g_ret_sts_error;
335: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
336: WHEN fnd_api.g_exc_unexpected_error THEN
337: x_return_status := fnd_api.g_ret_sts_unexp_error;
338: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
339: WHEN others THEN
340: x_return_status := fnd_api.g_ret_sts_unexp_error;

Line 337: x_return_status := fnd_api.g_ret_sts_unexp_error;

333: WHEN fnd_api.g_exc_error THEN
334: x_return_status := fnd_api.g_ret_sts_error;
335: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
336: WHEN fnd_api.g_exc_unexpected_error THEN
337: x_return_status := fnd_api.g_ret_sts_unexp_error;
338: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
339: WHEN others THEN
340: x_return_status := fnd_api.g_ret_sts_unexp_error;
341: logerrors('Exception at '||g_pkg_name || '.' || l_api_name ||' is '||sqlerrm);

Line 340: x_return_status := fnd_api.g_ret_sts_unexp_error;

336: WHEN fnd_api.g_exc_unexpected_error THEN
337: x_return_status := fnd_api.g_ret_sts_unexp_error;
338: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
339: WHEN others THEN
340: x_return_status := fnd_api.g_ret_sts_unexp_error;
341: logerrors('Exception at '||g_pkg_name || '.' || l_api_name ||' is '||sqlerrm);
342: x_msg_count := 1;
343: x_msg_data := sqlerrm;
344:

Line 452: RAISE fnd_api.g_exc_error;

448:
449: P_Loan_Details_Rec.funded_amount := l_funded_amount;
450:
451: IF g_error_count > 0 THEN
452: RAISE fnd_api.g_exc_error;
453: END IF;
454:
455: -- END OF BODY OF API
456: x_return_status := fnd_api.g_ret_sts_success;

Line 456: x_return_status := fnd_api.g_ret_sts_success;

452: RAISE fnd_api.g_exc_error;
453: END IF;
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

Line 461: WHEN fnd_api.g_exc_error THEN

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;
463: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
464: WHEN fnd_api.g_exc_unexpected_error THEN
465: x_return_status := fnd_api.g_ret_sts_unexp_error;

Line 462: x_return_status := fnd_api.g_ret_sts_error;

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;
463: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
464: WHEN fnd_api.g_exc_unexpected_error THEN
465: x_return_status := fnd_api.g_ret_sts_unexp_error;
466: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);

Line 464: WHEN fnd_api.g_exc_unexpected_error THEN

460: EXCEPTION
461: WHEN fnd_api.g_exc_error THEN
462: x_return_status := fnd_api.g_ret_sts_error;
463: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
464: WHEN fnd_api.g_exc_unexpected_error THEN
465: x_return_status := fnd_api.g_ret_sts_unexp_error;
466: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
467: WHEN others THEN
468: x_return_status := fnd_api.g_ret_sts_unexp_error;

Line 465: x_return_status := fnd_api.g_ret_sts_unexp_error;

461: WHEN fnd_api.g_exc_error THEN
462: x_return_status := fnd_api.g_ret_sts_error;
463: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
464: WHEN fnd_api.g_exc_unexpected_error THEN
465: x_return_status := fnd_api.g_ret_sts_unexp_error;
466: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
467: WHEN others THEN
468: x_return_status := fnd_api.g_ret_sts_unexp_error;
469: logerrors('Exception at '||g_pkg_name || '.' || l_api_name ||' is '||sqlerrm);

Line 468: x_return_status := fnd_api.g_ret_sts_unexp_error;

464: WHEN fnd_api.g_exc_unexpected_error THEN
465: x_return_status := fnd_api.g_ret_sts_unexp_error;
466: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
467: WHEN others THEN
468: x_return_status := fnd_api.g_ret_sts_unexp_error;
469: logerrors('Exception at '||g_pkg_name || '.' || l_api_name ||' is '||sqlerrm);
470: x_msg_count := 1;
471: x_msg_data := sqlerrm;
472:

Line 594: IF NOT fnd_api.compatible_api_call(l_api_version, p_api_version, l_api_name, g_pkg_name) THEN

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
595: RAISE fnd_api.g_exc_unexpected_error;
596: END IF;
597:
598: -- Initialize message list if p_init_msg_list is set to TRUE

Line 595: RAISE fnd_api.g_exc_unexpected_error;

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
595: RAISE fnd_api.g_exc_unexpected_error;
596: END IF;
597:
598: -- Initialize message list if p_init_msg_list is set to TRUE
599: IF fnd_api.to_boolean(p_init_msg_list) THEN

Line 599: IF fnd_api.to_boolean(p_init_msg_list) THEN

595: RAISE fnd_api.g_exc_unexpected_error;
596: END IF;
597:
598: -- Initialize message list if p_init_msg_list is set to TRUE
599: IF fnd_api.to_boolean(p_init_msg_list) THEN
600: fnd_msg_pub.initialize;
601: END IF;
602:
603: -- Initialize API return status to success

Line 604: l_return_status := fnd_api.g_ret_sts_success;

600: fnd_msg_pub.initialize;
601: END IF;
602:
603: -- Initialize API return status to success
604: l_return_status := fnd_api.g_ret_sts_success;
605:
606: -- START OF BODY OF API
607:
608: -- Initialize Collections and Variables

Line 624: RAISE fnd_api.g_exc_error;

620: WHEN NO_DATA_FOUND THEN
621: logerrors(p_message_name => 'LNS_LCREATE_INVALID_ATTRIBUTE',
622: p_token1 => 'P_Loan_Details_Rec.product_id',
623: p_token2 => P_Loan_Details_Rec.product_id);
624: RAISE fnd_api.g_exc_error;
625: END;
626:
627: /*
628: logmessage(fnd_log.level_statement, 'Validating product...');

Line 642: RAISE fnd_api.g_exc_error;

638: WHEN NO_DATA_FOUND THEN
639: logerrors(p_message_name => 'LNS_LCREATE_INVALID_ATTRIBUTE',
640: p_token1 => 'P_Loan_Details_Rec.product_id',
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:

Line 799: P_INIT_MSG_LIST => FND_API.G_TRUE,

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,
801: P_VALIDATION_LEVEL => FND_API.G_VALID_LEVEL_FULL,
802: P_Loan_Details_Rec => l_LOAN_DTL_REC,
803: P_Loan_Lines_Tbl => l_LOAN_LINES_TBL,

Line 800: P_COMMIT => FND_API.G_FALSE,

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,
801: P_VALIDATION_LEVEL => FND_API.G_VALID_LEVEL_FULL,
802: P_Loan_Details_Rec => l_LOAN_DTL_REC,
803: P_Loan_Lines_Tbl => l_LOAN_LINES_TBL,
804: P_DISB_TBL => l_DISB_TBL,

Line 801: P_VALIDATION_LEVEL => FND_API.G_VALID_LEVEL_FULL,

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,
801: P_VALIDATION_LEVEL => FND_API.G_VALID_LEVEL_FULL,
802: P_Loan_Details_Rec => l_LOAN_DTL_REC,
803: P_Loan_Lines_Tbl => l_LOAN_LINES_TBL,
804: P_DISB_TBL => l_DISB_TBL,
805: P_LOAN_PART_TBL => l_LOAN_PART_TBL,

Line 817: RAISE fnd_api.g_exc_error;

813: X_MSG_COUNT => l_msg_count,
814: X_MSG_DATA => l_msg_data);
815:
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:

Line 1003: RAISE fnd_api.g_exc_error;

999: END;
1000: END IF;
1001:
1002: IF g_error_count > 0 THEN
1003: RAISE fnd_api.g_exc_error;
1004: END IF;
1005:
1006: if l_loan_class = 'DIRECT' then
1007:

Line 1017: RAISE fnd_api.g_exc_error;

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
1021: RAISE fnd_api.g_exc_error;

Line 1021: RAISE fnd_api.g_exc_error;

1017: RAISE fnd_api.g_exc_error;
1018: END IF;
1019:
1020: IF g_error_count > 0 THEN
1021: RAISE fnd_api.g_exc_error;
1022: END IF;
1023:
1024: FOR l_count IN 1 .. P_DISB_TBL.COUNT LOOP
1025:

Line 1044: P_INIT_MSG_LIST => FND_API.G_TRUE,

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,
1046: P_VALIDATION_LEVEL => FND_API.G_VALID_LEVEL_FULL,
1047: P_DISB_HEADER_REC => l_DISB_HEADER_REC,
1048: X_RETURN_STATUS => l_return_status,

Line 1045: P_COMMIT => FND_API.G_FALSE,

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,
1046: P_VALIDATION_LEVEL => FND_API.G_VALID_LEVEL_FULL,
1047: P_DISB_HEADER_REC => l_DISB_HEADER_REC,
1048: X_RETURN_STATUS => l_return_status,
1049: X_MSG_COUNT => l_msg_count,

Line 1046: P_VALIDATION_LEVEL => FND_API.G_VALID_LEVEL_FULL,

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,
1046: P_VALIDATION_LEVEL => FND_API.G_VALID_LEVEL_FULL,
1047: P_DISB_HEADER_REC => l_DISB_HEADER_REC,
1048: X_RETURN_STATUS => l_return_status,
1049: X_MSG_COUNT => l_msg_count,
1050: X_MSG_DATA => l_msg_data);

Line 1055: RAISE fnd_api.g_exc_error;

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
1059: select lns_disb_lines_s.NEXTVAL into l_DISB_LINE_REC.DISB_LINE_ID from dual;

Line 1076: P_INIT_MSG_LIST => FND_API.G_TRUE,

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,
1078: P_VALIDATION_LEVEL => FND_API.G_VALID_LEVEL_FULL,
1079: P_DISB_LINE_REC => l_DISB_LINE_REC,
1080: X_RETURN_STATUS => l_return_status,

Line 1077: P_COMMIT => FND_API.G_FALSE,

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,
1078: P_VALIDATION_LEVEL => FND_API.G_VALID_LEVEL_FULL,
1079: P_DISB_LINE_REC => l_DISB_LINE_REC,
1080: X_RETURN_STATUS => l_return_status,
1081: X_MSG_COUNT => l_msg_count,

Line 1078: P_VALIDATION_LEVEL => FND_API.G_VALID_LEVEL_FULL,

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,
1078: P_VALIDATION_LEVEL => FND_API.G_VALID_LEVEL_FULL,
1079: P_DISB_LINE_REC => l_DISB_LINE_REC,
1080: X_RETURN_STATUS => l_return_status,
1081: X_MSG_COUNT => l_msg_count,
1082: X_MSG_DATA => l_msg_data);

Line 1087: RAISE fnd_api.g_exc_error;

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;
1091:

Line 1121: p_init_msg_list => FND_API.G_FALSE,

1117: end loop;
1118:
1119: LNS_DISTRIBUTIONS_PUB.createDistrForImport(
1120: p_api_version => 1.0,
1121: p_init_msg_list => FND_API.G_FALSE,
1122: p_commit => FND_API.G_FALSE,
1123: p_loan_id => l_loan_id,
1124: x_distribution_tbl => l_distribution_tbl,
1125: x_return_status => l_return_status,

Line 1122: p_commit => FND_API.G_FALSE,

1118:
1119: LNS_DISTRIBUTIONS_PUB.createDistrForImport(
1120: p_api_version => 1.0,
1121: p_init_msg_list => FND_API.G_FALSE,
1122: p_commit => FND_API.G_FALSE,
1123: p_loan_id => l_loan_id,
1124: x_distribution_tbl => l_distribution_tbl,
1125: x_return_status => l_return_status,
1126: x_msg_count => l_msg_count,

Line 1133: RAISE fnd_api.g_exc_error;

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');
1137:

Line 1152: l_loan_header_rec.secondary_status := FND_API.G_MISS_CHAR;

1148: l_loan_header_rec.loan_id := l_loan_id;
1149: l_loan_header_rec.LOAN_APPROVAL_DATE := P_Loan_Details_Rec.loan_approval_date;
1150: l_loan_header_rec.LOAN_APPROVED_BY := P_Loan_Details_Rec.loan_approved_by;
1151: l_loan_header_rec.loan_status := 'ACTIVE';
1152: l_loan_header_rec.secondary_status := FND_API.G_MISS_CHAR;
1153: l_loan_header_rec.funded_amount := P_Loan_Details_Rec.funded_amount;
1154:
1155: LNS_LOAN_HEADER_PUB.UPDATE_LOAN(P_OBJECT_VERSION_NUMBER => l_version_number,
1156: P_LOAN_HEADER_REC => l_loan_header_rec,

Line 1157: P_INIT_MSG_LIST => FND_API.G_FALSE,

1153: l_loan_header_rec.funded_amount := P_Loan_Details_Rec.funded_amount;
1154:
1155: LNS_LOAN_HEADER_PUB.UPDATE_LOAN(P_OBJECT_VERSION_NUMBER => l_version_number,
1156: P_LOAN_HEADER_REC => l_loan_header_rec,
1157: P_INIT_MSG_LIST => FND_API.G_FALSE,
1158: X_RETURN_STATUS => l_return_status,
1159: X_MSG_COUNT => l_msg_count,
1160: X_MSG_DATA => l_msg_data);
1161:

Line 1166: RAISE fnd_api.g_exc_error;

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;
1167: END IF;
1168: logmessage(fnd_log.level_unexpected, 'Loan object updated successfully');
1169:
1170: logmessage(fnd_log.level_unexpected, 'Calling validate_pay_history...');

Line 1179: RAISE fnd_api.g_exc_error;

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
1183: RAISE fnd_api.g_exc_error;

Line 1183: RAISE fnd_api.g_exc_error;

1179: RAISE fnd_api.g_exc_error;
1180: END IF;
1181:
1182: IF g_error_count > 0 THEN
1183: RAISE fnd_api.g_exc_error;
1184: END IF;
1185:
1186: FOR l_count IN 1 .. P_PAY_HIST_TBL.COUNT LOOP
1187:

Line 1236: P_INIT_MSG_LIST => FND_API.G_FALSE,

1232: END IF;
1233:
1234: LNS_BILLING_BATCH_PUB.CREATE_OFFCYCLE_BILLS(
1235: P_API_VERSION => 1.0,
1236: P_INIT_MSG_LIST => FND_API.G_FALSE,
1237: P_COMMIT => FND_API.G_FALSE,
1238: P_VALIDATION_LEVEL => FND_API.G_VALID_LEVEL_FULL,
1239: P_BILL_HEADERS_TBL => l_BILL_HEADERS_TBL,
1240: P_BILL_LINES_TBL => l_BILL_LINES_TBL,

Line 1237: P_COMMIT => FND_API.G_FALSE,

1233:
1234: LNS_BILLING_BATCH_PUB.CREATE_OFFCYCLE_BILLS(
1235: P_API_VERSION => 1.0,
1236: P_INIT_MSG_LIST => FND_API.G_FALSE,
1237: P_COMMIT => FND_API.G_FALSE,
1238: P_VALIDATION_LEVEL => FND_API.G_VALID_LEVEL_FULL,
1239: P_BILL_HEADERS_TBL => l_BILL_HEADERS_TBL,
1240: P_BILL_LINES_TBL => l_BILL_LINES_TBL,
1241: x_return_status => l_return_status,

Line 1238: P_VALIDATION_LEVEL => FND_API.G_VALID_LEVEL_FULL,

1234: LNS_BILLING_BATCH_PUB.CREATE_OFFCYCLE_BILLS(
1235: P_API_VERSION => 1.0,
1236: P_INIT_MSG_LIST => FND_API.G_FALSE,
1237: P_COMMIT => FND_API.G_FALSE,
1238: P_VALIDATION_LEVEL => FND_API.G_VALID_LEVEL_FULL,
1239: P_BILL_HEADERS_TBL => l_BILL_HEADERS_TBL,
1240: P_BILL_LINES_TBL => l_BILL_LINES_TBL,
1241: x_return_status => l_return_status,
1242: x_msg_count => l_msg_count,

Line 1246: RAISE fnd_api.g_exc_error;

1242: x_msg_count => l_msg_count,
1243: x_msg_data => l_msg_data);
1244:
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:

Line 1290: P_INIT_MSG_LIST => FND_API.G_FALSE,

1286: end if;
1287:
1288: AR_RECEIPT_API_PUB.CREATE_CASH(
1289: P_API_VERSION => 1.0,
1290: P_INIT_MSG_LIST => FND_API.G_FALSE,
1291: P_COMMIT => FND_API.G_FALSE,
1292: P_CURRENCY_CODE => P_Loan_Details_Rec.LOAN_CURRENCY,
1293: P_EXCHANGE_RATE_TYPE => P_Loan_Details_Rec.EXCHANGE_RATE_TYPE,
1294: P_EXCHANGE_RATE => P_Loan_Details_Rec.EXCHANGE_RATE,

Line 1291: P_COMMIT => FND_API.G_FALSE,

1287:
1288: AR_RECEIPT_API_PUB.CREATE_CASH(
1289: P_API_VERSION => 1.0,
1290: P_INIT_MSG_LIST => FND_API.G_FALSE,
1291: P_COMMIT => FND_API.G_FALSE,
1292: P_CURRENCY_CODE => P_Loan_Details_Rec.LOAN_CURRENCY,
1293: P_EXCHANGE_RATE_TYPE => P_Loan_Details_Rec.EXCHANGE_RATE_TYPE,
1294: P_EXCHANGE_RATE => P_Loan_Details_Rec.EXCHANGE_RATE,
1295: P_EXCHANGE_RATE_DATE => P_Loan_Details_Rec.EXCHANGE_DATE,

Line 1307: RAISE fnd_api.g_exc_error;

1303: X_MSG_COUNT => L_MSG_COUNT,
1304: X_MSG_DATA => L_MSG_DATA);
1305:
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

Line 1335: ,P_INIT_MSG_LIST => FND_API.G_FALSE

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
1338: ,X_MSG_COUNT => l_msg_count
1339: ,X_MSG_DATA => l_msg_data

Line 1336: ,P_COMMIT => FND_API.G_FALSE

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
1338: ,X_MSG_COUNT => l_msg_count
1339: ,X_MSG_DATA => l_msg_data
1340: ,p_cash_receipt_id => l_cr_id

Line 1353: RAISE fnd_api.g_exc_error;

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');
1357:

Line 1367: ,P_INIT_MSG_LIST => FND_API.G_FALSE

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
1369: ,X_RETURN_STATUS => l_return_status
1370: ,X_MSG_COUNT => l_msg_count
1371: ,X_MSG_DATA => l_msg_data

Line 1368: ,P_COMMIT => FND_API.G_FALSE

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
1369: ,X_RETURN_STATUS => l_return_status
1370: ,X_MSG_COUNT => l_msg_count
1371: ,X_MSG_DATA => l_msg_data
1372: ,p_cash_receipt_id => l_cr_id

Line 1385: RAISE fnd_api.g_exc_error;

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');
1389:

Line 1399: ,P_INIT_MSG_LIST => FND_API.G_FALSE

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
1401: ,X_RETURN_STATUS => l_return_status
1402: ,X_MSG_COUNT => l_msg_count
1403: ,X_MSG_DATA => l_msg_data

Line 1400: ,P_COMMIT => FND_API.G_FALSE

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
1401: ,X_RETURN_STATUS => l_return_status
1402: ,X_MSG_COUNT => l_msg_count
1403: ,X_MSG_DATA => l_msg_data
1404: ,p_cash_receipt_id => l_cr_id

Line 1417: RAISE fnd_api.g_exc_error;

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');
1421:

Line 1441: , p_init_msg_list => fnd_api.g_false

1437: l_term_rec.loan_id := l_loan_id;
1438: l_term_rec.next_payment_due_date := P_Loan_Details_Rec.next_payment_due_date;
1439:
1440: lns_terms_pub.update_term(p_object_version_number => l_version_number
1441: , p_init_msg_list => fnd_api.g_false
1442: , p_loan_term_rec => l_term_rec
1443: , x_return_status => l_return_status
1444: , x_msg_count => l_msg_count
1445: , x_msg_data => l_msg_data);

Line 1452: RAISE fnd_api.g_exc_error;

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');
1456:

Line 1463: P_INIT_MSG_LIST => FND_API.G_FALSE,

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,
1465: P_VALIDATION_LEVEL => FND_API.G_VALID_LEVEL_FULL,
1466: P_LOAN_ID => l_loan_id,
1467: x_return_status => l_return_status,

Line 1464: P_COMMIT => FND_API.G_FALSE,

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,
1465: P_VALIDATION_LEVEL => FND_API.G_VALID_LEVEL_FULL,
1466: P_LOAN_ID => l_loan_id,
1467: x_return_status => l_return_status,
1468: x_msg_count => l_msg_count,

Line 1465: P_VALIDATION_LEVEL => FND_API.G_VALID_LEVEL_FULL,

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,
1465: P_VALIDATION_LEVEL => FND_API.G_VALID_LEVEL_FULL,
1466: P_LOAN_ID => l_loan_id,
1467: x_return_status => l_return_status,
1468: x_msg_count => l_msg_count,
1469: x_msg_data => l_msg_data);

Line 1472: RAISE fnd_api.g_exc_error;

1468: x_msg_count => l_msg_count,
1469: x_msg_data => l_msg_data);
1470:
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:

Line 1500: IF p_commit = fnd_api.g_true THEN

1496: close c_get_rate_sch_info;
1497:
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:

Line 1508: x_return_status := fnd_api.g_ret_sts_success;

1504:
1505: x_loan_id := l_loan_id;
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