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

Line 88: l_term_id <> FND_API.G_MISS_NUM

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
90: BEGIN
91: SELECT 'Y'
92: INTO l_dummy

Line 99: RAISE FND_API.G_EXC_ERROR;

95:
96: FND_MESSAGE.SET_NAME('LNS', 'LNS_API_DUPLICATE_COLUMN');
97: FND_MESSAGE.SET_TOKEN('COLUMN', 'term_id');
98: FND_MSG_PUB.ADD;
99: RAISE FND_API.G_EXC_ERROR;
100:
101: EXCEPTION
102: WHEN NO_DATA_FOUND THEN
103: NULL;

Line 108: validate_term (p_init_msg_list => FND_API.G_FALSE

104: END;
105: END IF;
106:
107: -- begin raverma 01-24-2006 add validation for day count
108: validate_term (p_init_msg_list => FND_API.G_FALSE
109: ,p_loan_term_rec => p_loan_term_rec
110: ,x_return_status => x_return_status
111: ,x_msg_count => l_msg_count
112: ,x_msg_data => l_msg_data);

Line 114: IF x_return_status = FND_API.G_RET_STS_ERROR THEN

110: ,x_return_status => x_return_status
111: ,x_msg_count => l_msg_count
112: ,x_msg_data => l_msg_data);
113:
114: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
115: RAISE FND_API.G_EXC_ERROR;
116: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
117: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
118: END IF;

Line 115: RAISE FND_API.G_EXC_ERROR;

111: ,x_msg_count => l_msg_count
112: ,x_msg_data => l_msg_data);
113:
114: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
115: RAISE FND_API.G_EXC_ERROR;
116: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
117: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
118: END IF;
119:

Line 116: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

112: ,x_msg_data => l_msg_data);
113:
114: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
115: RAISE FND_API.G_EXC_ERROR;
116: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
117: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
118: END IF;
119:
120: --Set default values for billing

Line 117: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

113:
114: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
115: RAISE FND_API.G_EXC_ERROR;
116: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
117: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
118: END IF;
119:
120: --Set default values for billing
121: IF (p_loan_term_rec.payment_application_order is null) THEN

Line 288: RAISE FND_API.G_EXC_ERROR;

284: THEN
285: FND_MESSAGE.SET_NAME('LNS', 'LNS_API_RECORD_CHANGED');
286: FND_MESSAGE.SET_TOKEN('TABLE', 'lns_terms');
287: FND_MSG_PUB.ADD;
288: RAISE FND_API.G_EXC_ERROR;
289: END IF;
290:
291:
292: EXCEPTION WHEN NO_DATA_FOUND THEN

Line 297: RAISE FND_API.G_EXC_ERROR;

293: FND_MESSAGE.SET_NAME('LNS', 'LNS_API_NO_RECORD');
294: FND_MESSAGE.SET_TOKEN('RECORD', 'loan_term_rec');
295: FND_MESSAGE.SET_TOKEN('VALUE', NVL(TO_CHAR(p_loan_term_rec.term_id), 'null'));
296: FND_MSG_PUB.ADD;
297: RAISE FND_API.G_EXC_ERROR;
298: END;
299:
300: -- begin raverma 01-24-2006 add validation for day count
301: validate_term (p_init_msg_list => FND_API.G_FALSE

Line 301: validate_term (p_init_msg_list => FND_API.G_FALSE

297: RAISE FND_API.G_EXC_ERROR;
298: END;
299:
300: -- begin raverma 01-24-2006 add validation for day count
301: validate_term (p_init_msg_list => FND_API.G_FALSE
302: ,p_loan_term_rec => p_loan_term_rec
303: ,x_return_status => x_return_status
304: ,x_msg_count => l_msg_count
305: ,x_msg_data => l_msg_data);

Line 307: IF x_return_status = FND_API.G_RET_STS_ERROR THEN

303: ,x_return_status => x_return_status
304: ,x_msg_count => l_msg_count
305: ,x_msg_data => l_msg_data);
306:
307: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
308: RAISE FND_API.G_EXC_ERROR;
309: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
310: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
311: END IF;

Line 308: RAISE FND_API.G_EXC_ERROR;

304: ,x_msg_count => l_msg_count
305: ,x_msg_data => l_msg_data);
306:
307: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
308: RAISE FND_API.G_EXC_ERROR;
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:

Line 309: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

305: ,x_msg_data => l_msg_data);
306:
307: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
308: RAISE FND_API.G_EXC_ERROR;
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');

Line 310: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

306:
307: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
308: RAISE FND_API.G_EXC_ERROR;
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:

Line 419: P_INIT_MSG_LIST => FND_API.G_TRUE,

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,
420: P_COMMIT => FND_API.G_FALSE,
421: P_LOAN_ID => p_loan_id,
422: P_BASED_ON_TERMS => 'ORIGINAL',
423: x_amort_tbl => l_amortization_tbl,

Line 420: P_COMMIT => FND_API.G_FALSE,

416:
417: LNS_FINANCIALS.runAmortization(
418: P_API_VERSION => 1.0,
419: P_INIT_MSG_LIST => FND_API.G_TRUE,
420: P_COMMIT => FND_API.G_FALSE,
421: P_LOAN_ID => p_loan_id,
422: P_BASED_ON_TERMS => 'ORIGINAL',
423: x_amort_tbl => l_amortization_tbl,
424: x_return_status => l_return_status,

Line 429: RAISE FND_API.G_EXC_ERROR;

425: x_msg_count => l_msg_count,
426: x_msg_data => l_msg_data);
427:
428: IF l_return_status <> 'S' THEN
429: RAISE FND_API.G_EXC_ERROR;
430: END IF;
431:
432: FOR i IN 1..l_amortization_tbl.COUNT LOOP
433: if l_amortization_tbl(i).INSTALLMENT_NUMBER = 1 then

Line 460: p_init_msg_list => FND_API.G_FALSE,

456: from LNS_TERMS
457: where term_id = p_term_id;
458:
459: LNS_TERMS_PUB.update_term(
460: p_init_msg_list => FND_API.G_FALSE,
461: p_loan_term_rec => l_loan_term_rec,
462: p_object_version_number => l_object_version_number,
463: X_RETURN_STATUS => x_return_status,
464: X_MSG_COUNT => l_msg_count,

Line 496: P_INIT_MSG_LIST => FND_API.G_TRUE,

492: END IF;
493:
494: LNS_FINANCIALS.runAmortization(
495: P_API_VERSION => 1.0,
496: P_INIT_MSG_LIST => FND_API.G_TRUE,
497: P_COMMIT => FND_API.G_FALSE,
498: P_LOAN_ID => p_loan_id,
499: P_BASED_ON_TERMS => 'ORIGINAL',
500: x_amort_tbl => l_amortization_tbl,

Line 497: P_COMMIT => FND_API.G_FALSE,

493:
494: LNS_FINANCIALS.runAmortization(
495: P_API_VERSION => 1.0,
496: P_INIT_MSG_LIST => FND_API.G_TRUE,
497: P_COMMIT => FND_API.G_FALSE,
498: P_LOAN_ID => p_loan_id,
499: P_BASED_ON_TERMS => 'ORIGINAL',
500: x_amort_tbl => l_amortization_tbl,
501: x_return_status => l_return_status,

Line 506: RAISE FND_API.G_EXC_ERROR;

502: x_msg_count => l_msg_count,
503: x_msg_data => l_msg_data);
504:
505: IF l_return_status <> 'S' THEN
506: RAISE FND_API.G_EXC_ERROR;
507: END IF;
508:
509: FOR i IN 1..l_amortization_tbl.COUNT LOOP
510: if l_amortization_tbl(i).INSTALLMENT_NUMBER = 1 then

Line 557: P_INIT_MSG_LIST => FND_API.G_TRUE,

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,
558: P_COMMIT => FND_API.G_FALSE,
559: P_LOAN_ID => p_loan_id,
560: P_BASED_ON_TERMS => 'ORIGINAL',
561: x_amort_tbl => l_amortization_tbl,

Line 558: P_COMMIT => FND_API.G_FALSE,

554:
555: LNS_FINANCIALS.runAmortization(
556: P_API_VERSION => 1.0,
557: P_INIT_MSG_LIST => FND_API.G_TRUE,
558: P_COMMIT => FND_API.G_FALSE,
559: P_LOAN_ID => p_loan_id,
560: P_BASED_ON_TERMS => 'ORIGINAL',
561: x_amort_tbl => l_amortization_tbl,
562: x_return_status => l_return_status,

Line 567: RAISE FND_API.G_EXC_ERROR;

563: x_msg_count => l_msg_count,
564: x_msg_data => l_msg_data);
565:
566: IF l_return_status <> 'S' THEN
567: RAISE FND_API.G_EXC_ERROR;
568: END IF;
569:
570: FOR i IN 1..l_amortization_tbl.COUNT LOOP
571: if l_amortization_tbl(i).INSTALLMENT_NUMBER = 1 then

Line 588: p_init_msg_list => FND_API.G_FALSE,

584: from LNS_TERMS
585: where term_id = p_term_id;
586:
587: LNS_TERMS_PUB.update_term(
588: p_init_msg_list => FND_API.G_FALSE,
589: p_loan_term_rec => l_loan_term_rec,
590: p_object_version_number => l_object_version_number,
591: X_RETURN_STATUS => x_return_status,
592: X_MSG_COUNT => l_msg_count,

Line 684: IF (p_init_msg_list is not null and FND_API.to_Boolean(p_init_msg_list)) THEN

680: -- standard start of API savepoint
681: SAVEPOINT create_term;
682:
683: -- initialize message list if p_init_msg_list is set to TRUE.
684: IF (p_init_msg_list is not null and FND_API.to_Boolean(p_init_msg_list)) THEN
685: FND_MSG_PUB.initialize;
686: END IF;
687:
688: -- initialize API return status to success.

Line 689: x_return_status := FND_API.G_RET_STS_SUCCESS;

685: FND_MSG_PUB.initialize;
686: END IF;
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.

Line 703: WHEN FND_API.G_EXC_ERROR THEN

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;
705: x_return_status := FND_API.G_RET_STS_ERROR;
706: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,
707: p_count => x_msg_count,

Line 705: x_return_status := FND_API.G_RET_STS_ERROR;

701:
702: EXCEPTION
703: WHEN FND_API.G_EXC_ERROR THEN
704: ROLLBACK TO create_term;
705: x_return_status := FND_API.G_RET_STS_ERROR;
706: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,
707: p_count => x_msg_count,
708: p_data => x_msg_data);
709:

Line 706: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,

702: EXCEPTION
703: WHEN FND_API.G_EXC_ERROR THEN
704: ROLLBACK TO create_term;
705: x_return_status := FND_API.G_RET_STS_ERROR;
706: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,
707: p_count => x_msg_count,
708: p_data => x_msg_data);
709:
710: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 710: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

706: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,
707: p_count => x_msg_count,
708: p_data => x_msg_data);
709:
710: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
711: ROLLBACK TO create_term;
712: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
713: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,
714: p_count => x_msg_count,

Line 712: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

708: p_data => x_msg_data);
709:
710: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
711: ROLLBACK TO create_term;
712: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
713: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,
714: p_count => x_msg_count,
715: p_data => x_msg_data);
716:

Line 713: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,

709:
710: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
711: ROLLBACK TO create_term;
712: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
713: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,
714: p_count => x_msg_count,
715: p_data => x_msg_data);
716:
717: WHEN OTHERS THEN

Line 719: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

715: p_data => x_msg_data);
716:
717: WHEN OTHERS THEN
718: ROLLBACK TO create_term;
719: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
720: FND_MESSAGE.SET_NAME('LNS', 'LNS_API_OTHERS_EXCEP');
721: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
722: FND_MSG_PUB.ADD;
723: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,

Line 723: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,

719: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
720: FND_MESSAGE.SET_NAME('LNS', 'LNS_API_OTHERS_EXCEP');
721: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
722: FND_MSG_PUB.ADD;
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

Line 785: IF (p_init_msg_list is not null and FND_API.to_Boolean(p_init_msg_list)) THEN

781: -- standard start of API savepoint
782: SAVEPOINT update_term;
783:
784: -- initialize message list if p_init_msg_list is set to TRUE.
785: IF (p_init_msg_list is not null and FND_API.to_Boolean(p_init_msg_list)) THEN
786: FND_MSG_PUB.initialize;
787: END IF;
788:
789: -- initialize API return status to success.

Line 790: x_return_status := FND_API.G_RET_STS_SUCCESS;

786: FND_MSG_PUB.initialize;
787: END IF;
788:
789: -- initialize API return status to success.
790: x_return_status := FND_API.G_RET_STS_SUCCESS;
791:
792: -- Get old record. Will be used by history package.
793: get_loan_term_rec (
794: p_init_msg_list => FND_API.G_FALSE,

Line 794: p_init_msg_list => FND_API.G_FALSE,

790: x_return_status := FND_API.G_RET_STS_SUCCESS;
791:
792: -- Get old record. Will be used by history package.
793: get_loan_term_rec (
794: p_init_msg_list => FND_API.G_FALSE,
795: p_term_id => l_loan_term_rec.term_id,
796: x_loan_term_rec => l_old_loan_term_rec,
797: x_return_status => x_return_status,
798: x_msg_count => x_msg_count,

Line 801: IF x_return_status = FND_API.G_RET_STS_ERROR THEN

797: x_return_status => x_return_status,
798: x_msg_count => x_msg_count,
799: x_msg_data => x_msg_data );
800:
801: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
802: RAISE FND_API.G_EXC_ERROR;
803: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
804: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
805: END IF;

Line 802: RAISE FND_API.G_EXC_ERROR;

798: x_msg_count => x_msg_count,
799: x_msg_data => x_msg_data );
800:
801: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
802: RAISE FND_API.G_EXC_ERROR;
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:

Line 803: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

799: x_msg_data => x_msg_data );
800:
801: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
802: RAISE FND_API.G_EXC_ERROR;
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');

Line 804: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

800:
801: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
802: RAISE FND_API.G_EXC_ERROR;
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:

Line 819: WHEN FND_API.G_EXC_ERROR THEN

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;
821: x_return_status := FND_API.G_RET_STS_ERROR;
822: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,
823: p_count => x_msg_count,

Line 821: x_return_status := FND_API.G_RET_STS_ERROR;

817:
818: EXCEPTION
819: WHEN FND_API.G_EXC_ERROR THEN
820: ROLLBACK TO update_term;
821: x_return_status := FND_API.G_RET_STS_ERROR;
822: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,
823: p_count => x_msg_count,
824: p_data => x_msg_data);
825:

Line 822: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,

818: EXCEPTION
819: WHEN FND_API.G_EXC_ERROR THEN
820: ROLLBACK TO update_term;
821: x_return_status := FND_API.G_RET_STS_ERROR;
822: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,
823: p_count => x_msg_count,
824: p_data => x_msg_data);
825:
826: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 826: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

822: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,
823: p_count => x_msg_count,
824: p_data => x_msg_data);
825:
826: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
827: ROLLBACK TO update_term;
828: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
829: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,
830: p_count => x_msg_count,

Line 828: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

824: p_data => x_msg_data);
825:
826: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
827: ROLLBACK TO update_term;
828: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
829: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,
830: p_count => x_msg_count,
831: p_data => x_msg_data);
832:

Line 829: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,

825:
826: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
827: ROLLBACK TO update_term;
828: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
829: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,
830: p_count => x_msg_count,
831: p_data => x_msg_data);
832:
833: WHEN OTHERS THEN

Line 835: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

831: p_data => x_msg_data);
832:
833: WHEN OTHERS THEN
834: ROLLBACK TO update_term;
835: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
836: FND_MESSAGE.SET_NAME('LNS', 'LNS_API_OTHERS_EXCEP');
837: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
838: FND_MSG_PUB.ADD;
839: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,

Line 839: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,

835: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
836: FND_MESSAGE.SET_NAME('LNS', 'LNS_API_OTHERS_EXCEP');
837: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
838: FND_MSG_PUB.ADD;
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

Line 902: x_return_status := FND_API.G_RET_STS_SUCCESS;

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:
904: -- day count method must be ACTUAL/ACTUAL if less than MONTHLY AMORTIZATION
905: --open c_validate_day_count(l_loan_term_rec.loan_id);
906: --fetch c_validate_day_count into l_loan_term_rec.DAY_COUNT_METHOD, l_loan_term_rec.AMORTIZATION_FREQUENCY;

Line 923: RAISE FND_API.G_EXC_ERROR;

919: p_loan_term_rec.DAY_COUNT_METHOD <> 'ACTUAL_365L')
920: then
921: FND_MESSAGE.SET_NAME('LNS', 'LNS_INVALID_DAY_COUNT');
922: FND_MSG_PUB.ADD;
923: RAISE FND_API.G_EXC_ERROR;
924: end if;
925:
926: --Standard call to get message count and if count is 1, get message info.
927: FND_MSG_PUB.Count_And_Get(

Line 928: p_encoded => FND_API.G_FALSE,

924: end if;
925:
926: --Standard call to get message count and if count is 1, get message info.
927: FND_MSG_PUB.Count_And_Get(
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');

Line 936: WHEN FND_API.G_EXC_ERROR THEN

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
937: x_return_status := FND_API.G_RET_STS_ERROR;
938:
939: FND_MSG_PUB.Count_And_Get(
940: p_encoded => FND_API.G_FALSE,

Line 937: x_return_status := FND_API.G_RET_STS_ERROR;

933:
934:
935: EXCEPTION
936: WHEN FND_API.G_EXC_ERROR THEN
937: x_return_status := FND_API.G_RET_STS_ERROR;
938:
939: FND_MSG_PUB.Count_And_Get(
940: p_encoded => FND_API.G_FALSE,
941: p_count => x_msg_count,

Line 940: p_encoded => FND_API.G_FALSE,

936: WHEN FND_API.G_EXC_ERROR THEN
937: x_return_status := FND_API.G_RET_STS_ERROR;
938:
939: FND_MSG_PUB.Count_And_Get(
940: p_encoded => FND_API.G_FALSE,
941: p_count => x_msg_count,
942: p_data => x_msg_data );
943:
944: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 944: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

940: p_encoded => FND_API.G_FALSE,
941: p_count => x_msg_count,
942: p_data => x_msg_data );
943:
944: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
945: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
946:
947: FND_MSG_PUB.Count_And_Get(
948: p_encoded => FND_API.G_FALSE,

Line 945: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

941: p_count => x_msg_count,
942: p_data => x_msg_data );
943:
944: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
945: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
946:
947: FND_MSG_PUB.Count_And_Get(
948: p_encoded => FND_API.G_FALSE,
949: p_count => x_msg_count,

Line 948: p_encoded => FND_API.G_FALSE,

944: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
945: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
946:
947: FND_MSG_PUB.Count_And_Get(
948: p_encoded => FND_API.G_FALSE,
949: p_count => x_msg_count,
950: p_data => x_msg_data );
951:
952: WHEN OTHERS THEN

Line 953: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

949: p_count => x_msg_count,
950: p_data => x_msg_data );
951:
952: WHEN OTHERS THEN
953: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
954: FND_MESSAGE.SET_NAME( 'LNS', 'LNS_API_OTHERS_EXCEP' );
955: FND_MESSAGE.SET_TOKEN( 'ERROR' ,SQLERRM );
956: FND_MSG_PUB.ADD;
957: FND_MSG_PUB.Count_And_Get(

Line 958: p_encoded => FND_API.G_FALSE,

954: FND_MESSAGE.SET_NAME( 'LNS', 'LNS_API_OTHERS_EXCEP' );
955: FND_MESSAGE.SET_TOKEN( 'ERROR' ,SQLERRM );
956: FND_MSG_PUB.ADD;
957: FND_MSG_PUB.Count_And_Get(
958: p_encoded => FND_API.G_FALSE,
959: p_count => x_msg_count,
960: p_data => x_msg_data );
961:
962: END validate_term;

Line 1007: IF (p_init_msg_list is not null AND FND_API.to_Boolean(p_init_msg_list)) THEN

1003:
1004: BEGIN
1005:
1006: --Initialize message list if p_init_msg_list is set to TRUE.
1007: IF (p_init_msg_list is not null AND FND_API.to_Boolean(p_init_msg_list)) THEN
1008: FND_MSG_PUB.initialize;
1009: END IF;
1010:
1011: --Initialize API return status to success.

Line 1012: x_return_status := FND_API.G_RET_STS_SUCCESS;

1008: FND_MSG_PUB.initialize;
1009: END IF;
1010:
1011: --Initialize API return status to success.
1012: x_return_status := FND_API.G_RET_STS_SUCCESS;
1013:
1014: --Check whether primary key has been passed in.
1015: IF p_term_id IS NULL OR p_term_id = FND_API.G_MISS_NUM THEN
1016: FND_MESSAGE.SET_NAME( 'LNS', 'LNS_API_MISSING_COLUMN' );

Line 1015: IF p_term_id IS NULL OR p_term_id = FND_API.G_MISS_NUM THEN

1011: --Initialize API return status to success.
1012: x_return_status := FND_API.G_RET_STS_SUCCESS;
1013:
1014: --Check whether primary key has been passed in.
1015: IF p_term_id IS NULL OR p_term_id = FND_API.G_MISS_NUM THEN
1016: FND_MESSAGE.SET_NAME( 'LNS', 'LNS_API_MISSING_COLUMN' );
1017: FND_MESSAGE.SET_TOKEN( 'COLUMN', 'term_id' );
1018: FND_MSG_PUB.ADD;
1019: RAISE FND_API.G_EXC_ERROR;

Line 1019: RAISE FND_API.G_EXC_ERROR;

1015: IF p_term_id IS NULL OR p_term_id = FND_API.G_MISS_NUM THEN
1016: FND_MESSAGE.SET_NAME( 'LNS', 'LNS_API_MISSING_COLUMN' );
1017: FND_MESSAGE.SET_TOKEN( 'COLUMN', 'term_id' );
1018: FND_MSG_PUB.ADD;
1019: RAISE FND_API.G_EXC_ERROR;
1020: END IF;
1021:
1022: x_loan_term_rec.term_id := p_term_id;
1023:

Line 1096: p_encoded => FND_API.G_FALSE,

1092: );
1093:
1094: --Standard call to get message count and if count is 1, get message info.
1095: FND_MSG_PUB.Count_And_Get(
1096: p_encoded => FND_API.G_FALSE,
1097: p_count => x_msg_count,
1098: p_data => x_msg_data );
1099:
1100: EXCEPTION

Line 1101: WHEN FND_API.G_EXC_ERROR THEN

1097: p_count => x_msg_count,
1098: p_data => x_msg_data );
1099:
1100: EXCEPTION
1101: WHEN FND_API.G_EXC_ERROR THEN
1102: x_return_status := FND_API.G_RET_STS_ERROR;
1103:
1104: FND_MSG_PUB.Count_And_Get(
1105: p_encoded => FND_API.G_FALSE,

Line 1102: x_return_status := FND_API.G_RET_STS_ERROR;

1098: p_data => x_msg_data );
1099:
1100: EXCEPTION
1101: WHEN FND_API.G_EXC_ERROR THEN
1102: x_return_status := FND_API.G_RET_STS_ERROR;
1103:
1104: FND_MSG_PUB.Count_And_Get(
1105: p_encoded => FND_API.G_FALSE,
1106: p_count => x_msg_count,

Line 1105: p_encoded => FND_API.G_FALSE,

1101: WHEN FND_API.G_EXC_ERROR THEN
1102: x_return_status := FND_API.G_RET_STS_ERROR;
1103:
1104: FND_MSG_PUB.Count_And_Get(
1105: p_encoded => FND_API.G_FALSE,
1106: p_count => x_msg_count,
1107: p_data => x_msg_data );
1108:
1109: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 1109: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1105: p_encoded => FND_API.G_FALSE,
1106: p_count => x_msg_count,
1107: p_data => x_msg_data );
1108:
1109: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1110: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1111:
1112: FND_MSG_PUB.Count_And_Get(
1113: p_encoded => FND_API.G_FALSE,

Line 1110: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1106: p_count => x_msg_count,
1107: p_data => x_msg_data );
1108:
1109: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1110: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1111:
1112: FND_MSG_PUB.Count_And_Get(
1113: p_encoded => FND_API.G_FALSE,
1114: p_count => x_msg_count,

Line 1113: p_encoded => FND_API.G_FALSE,

1109: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1110: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1111:
1112: FND_MSG_PUB.Count_And_Get(
1113: p_encoded => FND_API.G_FALSE,
1114: p_count => x_msg_count,
1115: p_data => x_msg_data );
1116:
1117: WHEN OTHERS THEN

Line 1118: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1114: p_count => x_msg_count,
1115: p_data => x_msg_data );
1116:
1117: WHEN OTHERS THEN
1118: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1119: FND_MESSAGE.SET_NAME( 'LNS', 'LNS_API_OTHERS_EXCEP' );
1120: FND_MESSAGE.SET_TOKEN( 'ERROR' ,SQLERRM );
1121: FND_MSG_PUB.ADD;
1122: FND_MSG_PUB.Count_And_Get(

Line 1123: p_encoded => FND_API.G_FALSE,

1119: FND_MESSAGE.SET_NAME( 'LNS', 'LNS_API_OTHERS_EXCEP' );
1120: FND_MESSAGE.SET_TOKEN( 'ERROR' ,SQLERRM );
1121: FND_MSG_PUB.ADD;
1122: FND_MSG_PUB.Count_And_Get(
1123: p_encoded => FND_API.G_FALSE,
1124: p_count => x_msg_count,
1125: p_data => x_msg_data );
1126:
1127: END get_loan_term_rec;

Line 1214: x_return_status := FND_API.G_RET_STS_SUCCESS;

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:
1216:
1217: open c_interest_only_exists(p_loan_id);
1218: fetch c_interest_only_exists into l_interest_only_rows;

Line 1233: RAISE FND_API.G_EXC_ERROR;

1229: --dbms_output.put_line('reamortize ' || l_reamortize_overpay);
1230: if l_reamortize_overpay = 'Y' then
1231: FND_MESSAGE.SET_NAME('LNS', 'LNS_NO_REAMORTIZE');
1232: FND_MSG_PUB.Add;
1233: RAISE FND_API.G_EXC_ERROR;
1234: end if;
1235:
1236: /* removing this validation as per conversation with ravi on 11-3-2004
1237: || he wants users to be able to enter in funky interest only combinations

Line 1253: RAISE FND_API.G_EXC_ERROR;

1249: if l_rate_schedule(k).interest_only_flag = 'Y' and l_interest_only = 'N' then
1250: dbms_output.put_line('output non continuous');
1251: FND_MESSAGE.SET_NAME('LNS', 'LNS_INTEREST_ONLY_BREAK');
1252: FND_MSG_PUB.Add;
1253: RAISE FND_API.G_EXC_ERROR;
1254: end if;
1255: l_interest_only := l_rate_schedule(k).interest_only_flag;
1256:
1257: end loop;

Line 1269: WHEN FND_API.G_EXC_ERROR THEN

1265:
1266:
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;

Line 1270: x_return_status := FND_API.G_RET_STS_ERROR;

1266:
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:

Line 1275: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

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

Line 1276: x_return_status := FND_API.G_RET_STS_ERROR;

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

Line 1282: x_return_status := FND_API.G_RET_STS_ERROR;

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