DBA Data[Home] [Help]

APPS.LNS_TERMS_PUB dependencies on FND_LOG

Line 29: IF log_level >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN

25: is
26:
27: begin
28:
29: IF log_level >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
30: FND_LOG.STRING(log_level, module, message);
31: END IF;
32:
33: end;

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

26:
27: begin
28:
29: IF log_level >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
30: FND_LOG.STRING(log_level, module, message);
31: END IF;
32:
33: end;
34:

Line 85: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, ' - Begin do_create_term procedure');

81:
82: BEGIN
83: l_term_id := p_loan_term_rec.term_id;
84:
85: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, ' - Begin do_create_term procedure');
86: -- if primary key value is passed, check for uniqueness.
87: IF l_term_id IS NOT NULL AND
88: l_term_id <> FND_API.G_MISS_NUM
89: THEN

Line 146: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, ' - In do_create_term procedure: Before call to LNS_TERMS_PKG.Insert_Row');

142: IF (p_loan_term_rec.next_payment_due_date is null) THEN
143: p_loan_term_rec.next_payment_due_date := p_loan_term_rec.first_payment_date;
144: END IF;
145:
146: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, ' - In do_create_term procedure: Before call to LNS_TERMS_PKG.Insert_Row');
147:
148: -- call table-handler.
149: LNS_TERMS_PKG.Insert_Row (X_TERM_ID => p_loan_term_rec.term_id
150: ,X_LOAN_ID => p_loan_term_rec.loan_id

Line 219: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, ' - In do_create_term procedure: After call to LNS_TERMS.Insert_Row');

215: );
216:
217: x_term_id := p_loan_term_rec.term_id;
218:
219: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, ' - In do_create_term procedure: After call to LNS_TERMS.Insert_Row');
220:
221: END do_create_term;
222:
223:

Line 263: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, ' - Begin do_update_term procedure');

259: l_msg_data VARCHAR2(2000);
260:
261: BEGIN
262:
263: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, ' - Begin do_update_term procedure');
264:
265: -- check whether record has been updated by another user. If not, lock it.
266: BEGIN
267: SELECT OBJECT_VERSION_NUMBER,

Line 313: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, ' - In do_update_term procedure: Before call to LNS_TERMS_PKG.Update_Row');

309: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
310: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
311: END IF;
312:
313: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, ' - In do_update_term procedure: Before call to LNS_TERMS_PKG.Update_Row');
314:
315: p_object_version_number := nvl(l_object_version_number, 1) + 1;
316:
317: --Call to table-handler

Line 388: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, ' - In do_update_term procedure: After call to LNS_TERMS_PKG.Update_Row');

384: X_CALC_EARLY_PAY_CR => p_loan_term_rec.CALC_EARLY_PAY_CR,
385: X_FLUCTUATE_EQ_PAY_AMOUNT => p_loan_term_rec.FLUCTUATE_EQ_PAY_AMOUNT
386: );
387:
388: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, ' - In do_update_term procedure: After call to LNS_TERMS_PKG.Update_Row');
389:
390: END do_update_term;
391:
392: PROCEDURE default_delinquency_amount(

Line 415: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, ' - In default_delinquency_amount procedure: Before call to default_delinquency_amount');

411: BEGIN
412:
413: -- fix for bug 8830789
414:
415: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, ' - In default_delinquency_amount procedure: Before call to default_delinquency_amount');
416:
417: LNS_FINANCIALS.runAmortization(
418: P_API_VERSION => 1.0,
419: P_INIT_MSG_LIST => FND_API.G_TRUE,

Line 467: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, ' - In default_delinquency_amount procedure: After call to default_delinquency_amount');

463: X_RETURN_STATUS => x_return_status,
464: X_MSG_COUNT => l_msg_count,
465: X_MSG_DATA => l_msg_data);
466:
467: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, ' - In default_delinquency_amount procedure: After call to default_delinquency_amount');
468:
469: END default_delinquency_amount;
470:
471:

Line 490: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN

486: l_return_status VARCHAR2(1);
487:
488: BEGIN
489:
490: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
491: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, 'In calculate_delinquency_amount procedure');
492: END IF;
493:
494: LNS_FINANCIALS.runAmortization(

Line 491: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, 'In calculate_delinquency_amount procedure');

487:
488: BEGIN
489:
490: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
491: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, 'In calculate_delinquency_amount procedure');
492: END IF;
493:
494: LNS_FINANCIALS.runAmortization(
495: P_API_VERSION => 1.0,

Line 523: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN

519:
520: p_delinq_amt := l_delinq_amt;
521:
522:
523: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
524: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, 'Exiting calculate_delinquency_amount procedure');
525: END IF;
526:
527: END calculate_delinquency_amount;

Line 524: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, 'Exiting calculate_delinquency_amount procedure');

520: p_delinq_amt := l_delinq_amt;
521:
522:
523: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
524: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, 'Exiting calculate_delinquency_amount procedure');
525: END IF;
526:
527: END calculate_delinquency_amount;
528:

Line 553: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, ' - In default_threshold_amount procedure: Before call to default_threshold_amount');

549: BEGIN
550:
551: -- fix for bug 8830789
552:
553: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, ' - In default_threshold_amount procedure: Before call to default_threshold_amount');
554:
555: LNS_FINANCIALS.runAmortization(
556: P_API_VERSION => 1.0,
557: P_INIT_MSG_LIST => FND_API.G_TRUE,

Line 595: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, ' - In default_threshold_amount procedure: After call to default_threshold_amount');

591: X_RETURN_STATUS => x_return_status,
592: X_MSG_COUNT => l_msg_count,
593: X_MSG_DATA => l_msg_data);
594:
595: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, ' - In default_threshold_amount procedure: After call to default_threshold_amount');
596:
597: END default_threshold_amount;
598:
599:

Line 615: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN

611: l_fees_tbl LNS_FINANCIALS.FEES_TBL;
612:
613: BEGIN
614:
615: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
616: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, 'In calculate_threshold_amount procedure');
617: END IF;
618:
619: l_default_threshold_amt := 2 * nvl(p_delinquent_threshold_amt,0) ;

Line 616: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, 'In calculate_threshold_amount procedure');

612:
613: BEGIN
614:
615: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
616: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, 'In calculate_threshold_amount procedure');
617: END IF;
618:
619: l_default_threshold_amt := 2 * nvl(p_delinquent_threshold_amt,0) ;
620: p_default_threshold_amt := l_default_threshold_amt;

Line 623: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN

619: l_default_threshold_amt := 2 * nvl(p_delinquent_threshold_amt,0) ;
620: p_default_threshold_amt := l_default_threshold_amt;
621:
622:
623: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
624: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, 'Exiting calculate_threshold_amount procedure');
625: END IF;
626:
627: END calculate_default_amount;

Line 624: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, 'Exiting calculate_threshold_amount procedure');

620: p_default_threshold_amt := l_default_threshold_amt;
621:
622:
623: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
624: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, 'Exiting calculate_threshold_amount procedure');
625: END IF;
626:
627: END calculate_default_amount;
628:

Line 678: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, ' - Begin Create_Term procedure');

674:
675: BEGIN
676: l_loan_term_rec := p_loan_term_rec;
677:
678: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, ' - Begin Create_Term procedure');
679:
680: -- standard start of API savepoint
681: SAVEPOINT create_term;
682:

Line 691: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, ' - In Create_Term procedure: Before call to do_create_term proc');

687:
688: -- initialize API return status to success.
689: x_return_status := FND_API.G_RET_STS_SUCCESS;
690:
691: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, ' - In Create_Term procedure: Before call to do_create_term proc');
692:
693: -- call to business logic.
694: do_create_term(
695: l_loan_term_rec,

Line 700: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, ' - In Create_Term procedure: After call to do_create_term proc');

696: x_term_id,
697: x_return_status
698: );
699:
700: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, ' - In Create_Term procedure: After call to do_create_term proc');
701:
702: EXCEPTION
703: WHEN FND_API.G_EXC_ERROR THEN
704: ROLLBACK TO create_term;

Line 727: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN

723: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,
724: p_count => x_msg_count,
725: p_data => x_msg_data);
726:
727: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
728: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, 'End Create_Term procedure');
729: END IF;
730:
731: END create_term;

Line 728: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, 'End Create_Term procedure');

724: p_count => x_msg_count,
725: p_data => x_msg_data);
726:
727: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
728: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, 'End Create_Term procedure');
729: END IF;
730:
731: END create_term;
732:

Line 779: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, ' - Begin Update_Term procedure');

775: BEGIN
776:
777: l_loan_term_rec := p_loan_term_rec;
778:
779: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, ' - Begin Update_Term procedure');
780:
781: -- standard start of API savepoint
782: SAVEPOINT update_term;
783:

Line 807: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, ' - In Update_Term procedure: Before call to do_update_term proc');

803: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
804: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
805: END IF;
806:
807: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, ' - In Update_Term procedure: Before call to do_update_term proc');
808:
809: -- call to business logic.
810: do_update_term(
811: l_loan_term_rec,

Line 816: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, ' - In Update_Term procedure: After call to do_update_term proc');

812: p_object_version_number,
813: x_return_status
814: );
815:
816: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, ' - In Update_Term procedure: After call to do_update_term proc');
817:
818: EXCEPTION
819: WHEN FND_API.G_EXC_ERROR THEN
820: ROLLBACK TO update_term;

Line 843: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN

839: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,
840: p_count => x_msg_count,
841: p_data => x_msg_data);
842:
843: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
844: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, 'End Update_Term procedure');
845: END IF;
846:
847: END update_term;

Line 844: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, 'End Update_Term procedure');

840: p_count => x_msg_count,
841: p_data => x_msg_data);
842:
843: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
844: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, 'End Update_Term procedure');
845: END IF;
846:
847: END update_term;
848:

Line 899: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, ' - Begin Validate_Term procedure');

895: */
896: BEGIN
897: l_loan_term_rec := p_loan_term_rec;
898:
899: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, ' - Begin Validate_Term procedure');
900:
901: -- initialize API return status to success.
902: x_return_status := FND_API.G_RET_STS_SUCCESS;
903:

Line 932: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, ' - End Validate_Term procedure');

928: p_encoded => FND_API.G_FALSE,
929: p_count => x_msg_count,
930: p_data => x_msg_data );
931:
932: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, ' - End Validate_Term procedure');
933:
934:
935: EXCEPTION
936: WHEN FND_API.G_EXC_ERROR THEN

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

1207:
1208: begin
1209: l_api_name := 'validate_rate_schedule';
1210:
1211: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - BEGIN');
1212:
1213: -- Initialize API return status to SUCCESS
1214: x_return_status := FND_API.G_RET_STS_SUCCESS;
1215:

Line 1264: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - End');

1260: end if;
1261:
1262: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
1263:
1264: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - End');
1265:
1266:
1267: EXCEPTION
1268:

Line 1271: IF ( FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN

1267: EXCEPTION
1268:
1269: WHEN FND_API.G_EXC_ERROR THEN
1270: x_return_status := FND_API.G_RET_STS_ERROR;
1271: IF ( FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
1272: FND_LOG.STRING(FND_LOG.LEVEL_ERROR, G_PKG_NAME, sqlerrm);
1273: END IF;
1274:
1275: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 1272: FND_LOG.STRING(FND_LOG.LEVEL_ERROR, G_PKG_NAME, sqlerrm);

1268:
1269: WHEN FND_API.G_EXC_ERROR THEN
1270: x_return_status := FND_API.G_RET_STS_ERROR;
1271: IF ( FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
1272: FND_LOG.STRING(FND_LOG.LEVEL_ERROR, G_PKG_NAME, sqlerrm);
1273: END IF;
1274:
1275: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1276: x_return_status := FND_API.G_RET_STS_ERROR;

Line 1277: IF ( FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN

1273: END IF;
1274:
1275: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1276: x_return_status := FND_API.G_RET_STS_ERROR;
1277: IF ( FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
1278: FND_LOG.STRING(FND_LOG.LEVEL_ERROR, G_PKG_NAME, sqlerrm);
1279: END IF;
1280:
1281: WHEN OTHERS THEN

Line 1278: FND_LOG.STRING(FND_LOG.LEVEL_ERROR, G_PKG_NAME, sqlerrm);

1274:
1275: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1276: x_return_status := FND_API.G_RET_STS_ERROR;
1277: IF ( FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
1278: FND_LOG.STRING(FND_LOG.LEVEL_ERROR, G_PKG_NAME, sqlerrm);
1279: END IF;
1280:
1281: WHEN OTHERS THEN
1282: x_return_status := FND_API.G_RET_STS_ERROR;

Line 1283: IF ( FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN

1279: END IF;
1280:
1281: WHEN OTHERS THEN
1282: x_return_status := FND_API.G_RET_STS_ERROR;
1283: IF ( FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
1284: FND_LOG.STRING(FND_LOG.LEVEL_ERROR, G_PKG_NAME, sqlerrm);
1285: END IF;
1286:
1287: end validate_rate_schedule;

Line 1284: FND_LOG.STRING(FND_LOG.LEVEL_ERROR, G_PKG_NAME, sqlerrm);

1280:
1281: WHEN OTHERS THEN
1282: x_return_status := FND_API.G_RET_STS_ERROR;
1283: IF ( FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
1284: FND_LOG.STRING(FND_LOG.LEVEL_ERROR, G_PKG_NAME, sqlerrm);
1285: END IF;
1286:
1287: end validate_rate_schedule;
1288: