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

Line 98: l_loan_id <> FND_API.G_MISS_NUM

94: END IF;
95:
96: -- if primary key value is passed, check for uniqueness.
97: IF l_loan_id IS NOT NULL AND
98: l_loan_id <> FND_API.G_MISS_NUM
99: THEN
100: BEGIN
101: SELECT 'Y'
102: INTO l_dummy

Line 109: RAISE FND_API.G_EXC_ERROR;

105:
106: FND_MESSAGE.SET_NAME('LNS', 'LNS_API_DUPLICATE_COLUMN');
107: FND_MESSAGE.SET_TOKEN('COLUMN', 'loan_id');
108: FND_MSG_PUB.ADD;
109: RAISE FND_API.G_EXC_ERROR;
110:
111: EXCEPTION
112: WHEN NO_DATA_FOUND THEN
113: NULL;

Line 125: IF l_loan_number = FND_API.G_MISS_CHAR

121:
122: l_gen_loan_number := fnd_profile.value('LNS_GENERATE_LOAN_NUMBER');
123:
124: IF l_gen_loan_number = 'N' THEN
125: IF l_loan_number = FND_API.G_MISS_CHAR
126: OR
127: l_loan_number IS NULL
128: THEN
129: FND_MESSAGE.SET_NAME('LNS', 'LNS_API_MISSING_COLUMN');

Line 132: RAISE FND_API.G_EXC_ERROR;

128: THEN
129: FND_MESSAGE.SET_NAME('LNS', 'LNS_API_MISSING_COLUMN');
130: FND_MESSAGE.SET_TOKEN('COLUMN', 'LOAN_NUMBER');
131: FND_MSG_PUB.ADD;
132: RAISE FND_API.G_EXC_ERROR;
133: END IF;
134:
135: BEGIN
136: SELECT 'Y'

Line 144: RAISE FND_API.G_EXC_ERROR;

140:
141: FND_MESSAGE.SET_NAME('LNS', 'LNS_API_DUPLICATE_COLUMN');
142: FND_MESSAGE.SET_TOKEN('COLUMN', 'LOAN_NUMBER');
143: FND_MSG_PUB.ADD;
144: RAISE FND_API.G_EXC_ERROR;
145:
146: EXCEPTION
147: WHEN NO_DATA_FOUND THEN
148: NULL;

Line 159: IF l_loan_number <> FND_API.G_MISS_CHAR

155: OR
156: l_gen_loan_number IS NULL
157: THEN
158:
159: IF l_loan_number <> FND_API.G_MISS_CHAR
160: AND
161: l_loan_number IS NOT NULL
162: THEN
163: FND_MESSAGE.SET_NAME('LNS', 'LNS_API_LOAN_NUM_AUTO_ON');

Line 165: RAISE FND_API.G_EXC_ERROR;

161: l_loan_number IS NOT NULL
162: THEN
163: FND_MESSAGE.SET_NAME('LNS', 'LNS_API_LOAN_NUM_AUTO_ON');
164: FND_MSG_PUB.ADD;
165: RAISE FND_API.G_EXC_ERROR;
166: END IF;
167:
168: END IF;
169: */

Line 420: RAISE FND_API.G_EXC_ERROR;

416: THEN
417: FND_MESSAGE.SET_NAME('LNS', 'LNS_API_RECORD_CHANGED');
418: FND_MESSAGE.SET_TOKEN('TABLE', 'lns_loan_header_all');
419: FND_MSG_PUB.ADD;
420: RAISE FND_API.G_EXC_ERROR;
421: END IF;
422:
423: p_object_version_number := nvl(l_object_version_number, 1) + 1;
424:

Line 430: RAISE FND_API.G_EXC_ERROR;

426: FND_MESSAGE.SET_NAME('LNS', 'LNS_API_NO_RECORD');
427: FND_MESSAGE.SET_TOKEN('RECORD', 'loan header');
428: FND_MESSAGE.SET_TOKEN('VALUE', NVL(TO_CHAR(p_loan_header_rec.loan_id), 'null'));
429: FND_MSG_PUB.ADD;
430: RAISE FND_API.G_EXC_ERROR;
431: END;
432:
433: IF (p_loan_header_rec.loan_status='INCOMPLETE') THEN
434: --Update requested amount to funded amount for ERS loan

Line 445: p_loan_header_rec.secondary_status := FND_API.G_MISS_CHAR;

441: END IF;
442:
443: --update secondary status to NULL if deleted or rejected loans
444: IF (p_loan_header_rec.loan_status='DELETED' OR p_loan_header_rec.loan_status='REJECTED') THEN
445: p_loan_header_rec.secondary_status := FND_API.G_MISS_CHAR;
446: END IF;
447:
448: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
449: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, 'In do_update_loan procedure: Before call to LNS_LOAN_HEADER_ALL_PKG.Update_Row');

Line 631: l_init_msg_list := FND_API.G_FALSE;

627: l_loan_header_rec := p_loan_header_rec;
628:
629: l_init_msg_list := p_init_msg_list;
630: if (l_init_msg_list is null) then
631: l_init_msg_list := FND_API.G_FALSE;
632: end if;
633:
634: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
635: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, 'Begin Create_Loan procedure');

Line 642: IF FND_API.to_Boolean(l_init_msg_list) THEN

638: -- standard start of API savepoint
639: SAVEPOINT create_loan;
640:
641: -- initialize message list if l_init_msg_list is set to TRUE.
642: IF FND_API.to_Boolean(l_init_msg_list) THEN
643: FND_MSG_PUB.initialize;
644: END IF;
645:
646: -- initialize API return status to success.

Line 647: x_return_status := FND_API.G_RET_STS_SUCCESS;

643: FND_MSG_PUB.initialize;
644: END IF;
645:
646: -- initialize API return status to success.
647: x_return_status := FND_API.G_RET_STS_SUCCESS;
648:
649: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
650: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, 'In Create_Loan procedure: Before call to do_create_loan proc');
651: END IF;

Line 665: if (x_return_status = FND_API.G_RET_STS_SUCCESS) then

661: l_loan_id := x_loan_id;
662:
663: /*--This call is no longer needed since this is moved to
664: --the accounting page for performance reasons
665: if (x_return_status = FND_API.G_RET_STS_SUCCESS) then
666:
667: l_loan_class_code := l_loan_header_rec.loan_class_code;
668: -- call to save default distributions to the loan
669: LNS_DISTRIBUTIONS_PUB.defaultDistributions(

Line 671: p_init_msg_list => FND_API.G_TRUE,

667: l_loan_class_code := l_loan_header_rec.loan_class_code;
668: -- call to save default distributions to the loan
669: LNS_DISTRIBUTIONS_PUB.defaultDistributions(
670: p_api_version => 1.0,
671: p_init_msg_list => FND_API.G_TRUE,
672: p_commit => FND_API.G_FALSE,
673: p_loan_id => l_loan_id,
674: p_loan_class_code => l_loan_class_code,
675: x_return_status => x_return_status,

Line 672: p_commit => FND_API.G_FALSE,

668: -- call to save default distributions to the loan
669: LNS_DISTRIBUTIONS_PUB.defaultDistributions(
670: p_api_version => 1.0,
671: p_init_msg_list => FND_API.G_TRUE,
672: p_commit => FND_API.G_FALSE,
673: p_loan_id => l_loan_id,
674: p_loan_class_code => l_loan_class_code,
675: x_return_status => x_return_status,
676: x_msg_count => x_msg_count,

Line 688: WHEN FND_API.G_EXC_ERROR THEN

684: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, 'In Create_Loan procedure: After call to do_create_loan proc');
685: END IF;
686:
687: EXCEPTION
688: WHEN FND_API.G_EXC_ERROR THEN
689: ROLLBACK TO create_loan;
690: x_return_status := FND_API.G_RET_STS_ERROR;
691: FND_MSG_PUB.Count_And_Get(
692: p_encoded => FND_API.G_FALSE,

Line 690: x_return_status := FND_API.G_RET_STS_ERROR;

686:
687: EXCEPTION
688: WHEN FND_API.G_EXC_ERROR THEN
689: ROLLBACK TO create_loan;
690: x_return_status := FND_API.G_RET_STS_ERROR;
691: FND_MSG_PUB.Count_And_Get(
692: p_encoded => FND_API.G_FALSE,
693: p_count => x_msg_count,
694: p_data => x_msg_data);

Line 692: p_encoded => FND_API.G_FALSE,

688: WHEN FND_API.G_EXC_ERROR THEN
689: ROLLBACK TO create_loan;
690: x_return_status := FND_API.G_RET_STS_ERROR;
691: FND_MSG_PUB.Count_And_Get(
692: p_encoded => FND_API.G_FALSE,
693: p_count => x_msg_count,
694: p_data => x_msg_data);
695:
696: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 696: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

692: p_encoded => FND_API.G_FALSE,
693: p_count => x_msg_count,
694: p_data => x_msg_data);
695:
696: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
697: ROLLBACK TO create_loan;
698: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
699: FND_MSG_PUB.Count_And_Get(
700: p_encoded => FND_API.G_FALSE,

Line 698: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

694: p_data => x_msg_data);
695:
696: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
697: ROLLBACK TO create_loan;
698: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
699: FND_MSG_PUB.Count_And_Get(
700: p_encoded => FND_API.G_FALSE,
701: p_count => x_msg_count,
702: p_data => x_msg_data);

Line 700: p_encoded => FND_API.G_FALSE,

696: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
697: ROLLBACK TO create_loan;
698: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
699: FND_MSG_PUB.Count_And_Get(
700: p_encoded => FND_API.G_FALSE,
701: p_count => x_msg_count,
702: p_data => x_msg_data);
703:
704: WHEN OTHERS THEN

Line 706: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

702: p_data => x_msg_data);
703:
704: WHEN OTHERS THEN
705: ROLLBACK TO create_loan;
706: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
707: FND_MESSAGE.SET_NAME('LNS', 'LNS_API_OTHERS_EXCEP');
708: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
709: FND_MSG_PUB.ADD;
710: FND_MSG_PUB.Count_And_Get(

Line 711: p_encoded => FND_API.G_FALSE,

707: FND_MESSAGE.SET_NAME('LNS', 'LNS_API_OTHERS_EXCEP');
708: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
709: FND_MSG_PUB.ADD;
710: FND_MSG_PUB.Count_And_Get(
711: p_encoded => FND_API.G_FALSE,
712: p_count => x_msg_count,
713: p_data => x_msg_data);
714:
715: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN

Line 768: l_init_msg_list := FND_API.G_FALSE;

764: l_loan_header_rec := p_loan_header_rec;
765:
766: l_init_msg_list := p_init_msg_list;
767: if (l_init_msg_list is null) then
768: l_init_msg_list := FND_API.G_FALSE;
769: end if;
770:
771: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
772: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, 'Begin Update_Loan procedure');

Line 779: IF FND_API.to_Boolean(l_init_msg_list) THEN

775: -- standard start of API savepoint
776: SAVEPOINT update_loan;
777:
778: -- initialize message list if l_init_msg_list is set to TRUE.
779: IF FND_API.to_Boolean(l_init_msg_list) THEN
780: FND_MSG_PUB.initialize;
781: END IF;
782:
783: -- initialize API return status to success.

Line 784: x_return_status := FND_API.G_RET_STS_SUCCESS;

780: FND_MSG_PUB.initialize;
781: END IF;
782:
783: -- initialize API return status to success.
784: x_return_status := FND_API.G_RET_STS_SUCCESS;
785:
786: -- Get old record. Will be used by history package and
787: -- for updating loan desciption in credit mgmt credit request
788: -- as needed .

Line 790: p_init_msg_list => FND_API.G_FALSE,

786: -- Get old record. Will be used by history package and
787: -- for updating loan desciption in credit mgmt credit request
788: -- as needed .
789: get_loan_header_rec (
790: p_init_msg_list => FND_API.G_FALSE,
791: p_loan_id => l_loan_header_rec.loan_id,
792: x_loan_header_rec => l_old_loan_header_rec,
793: x_return_status => x_return_status,
794: x_msg_count => x_msg_count,

Line 797: IF x_return_status = FND_API.G_RET_STS_ERROR THEN

793: x_return_status => x_return_status,
794: x_msg_count => x_msg_count,
795: x_msg_data => x_msg_data );
796:
797: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
798: RAISE FND_API.G_EXC_ERROR;
799: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
800: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
801: END IF;

Line 798: RAISE FND_API.G_EXC_ERROR;

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

Line 799: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

795: x_msg_data => x_msg_data );
796:
797: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
798: RAISE FND_API.G_EXC_ERROR;
799: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
800: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
801: END IF;
802:
803: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN

Line 800: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

796:
797: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
798: RAISE FND_API.G_EXC_ERROR;
799: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
800: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
801: END IF;
802:
803: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
804: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, 'In Update_Loan procedure: Before call to do_update_loan proc');

Line 821: IF (l_old_loan_header_rec.credit_review_flag = 'Y' and l_loan_header_rec.loan_description is not null and l_loan_header_rec.loan_description <> FND_API.G_MISS_CHAR and l_loan_header_rec.loan_description <> l_old_loan_header_rec.loan_description) THEN

817:
818: --if the loan description has changed and credit request created
819: --for this loan participants, update the credit request with the
820: --new loan description information to fix bug#4930854
821: IF (l_old_loan_header_rec.credit_review_flag = 'Y' and l_loan_header_rec.loan_description is not null and l_loan_header_rec.loan_description <> FND_API.G_MISS_CHAR and l_loan_header_rec.loan_description <> l_old_loan_header_rec.loan_description) THEN
822: update ar_cmgt_credit_requests
823: set SOURCE_COLUMN3 = l_loan_header_rec.loan_description
824: where SOURCE_NAME = 'LNS' and
825: SOURCE_COLUMN1 = to_char(l_loan_header_rec.loan_id) and

Line 830: WHEN FND_API.G_EXC_ERROR THEN

826: SOURCE_COLUMN3 = l_old_loan_header_rec.loan_description;
827: END IF;
828:
829: EXCEPTION
830: WHEN FND_API.G_EXC_ERROR THEN
831: ROLLBACK TO update_loan;
832: x_return_status := FND_API.G_RET_STS_ERROR;
833: FND_MSG_PUB.Count_And_Get(
834: p_encoded => FND_API.G_FALSE,

Line 832: x_return_status := FND_API.G_RET_STS_ERROR;

828:
829: EXCEPTION
830: WHEN FND_API.G_EXC_ERROR THEN
831: ROLLBACK TO update_loan;
832: x_return_status := FND_API.G_RET_STS_ERROR;
833: FND_MSG_PUB.Count_And_Get(
834: p_encoded => FND_API.G_FALSE,
835: p_count => x_msg_count,
836: p_data => x_msg_data);

Line 834: p_encoded => FND_API.G_FALSE,

830: WHEN FND_API.G_EXC_ERROR THEN
831: ROLLBACK TO update_loan;
832: x_return_status := FND_API.G_RET_STS_ERROR;
833: FND_MSG_PUB.Count_And_Get(
834: p_encoded => FND_API.G_FALSE,
835: p_count => x_msg_count,
836: p_data => x_msg_data);
837:
838: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 838: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

834: p_encoded => FND_API.G_FALSE,
835: p_count => x_msg_count,
836: p_data => x_msg_data);
837:
838: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
839: ROLLBACK TO update_loan;
840: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
841: FND_MSG_PUB.Count_And_Get(
842: p_encoded => FND_API.G_FALSE,

Line 840: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

836: p_data => x_msg_data);
837:
838: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
839: ROLLBACK TO update_loan;
840: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
841: FND_MSG_PUB.Count_And_Get(
842: p_encoded => FND_API.G_FALSE,
843: p_count => x_msg_count,
844: p_data => x_msg_data);

Line 842: p_encoded => FND_API.G_FALSE,

838: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
839: ROLLBACK TO update_loan;
840: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
841: FND_MSG_PUB.Count_And_Get(
842: p_encoded => FND_API.G_FALSE,
843: p_count => x_msg_count,
844: p_data => x_msg_data);
845:
846: WHEN OTHERS THEN

Line 848: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

844: p_data => x_msg_data);
845:
846: WHEN OTHERS THEN
847: ROLLBACK TO update_loan;
848: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
849: FND_MESSAGE.SET_NAME('LNS', 'LNS_API_OTHERS_EXCEP');
850: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
851: FND_MSG_PUB.ADD;
852: FND_MSG_PUB.Count_And_Get(

Line 853: p_encoded => FND_API.G_FALSE,

849: FND_MESSAGE.SET_NAME('LNS', 'LNS_API_OTHERS_EXCEP');
850: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
851: FND_MSG_PUB.ADD;
852: FND_MSG_PUB.Count_And_Get(
853: p_encoded => FND_API.G_FALSE,
854: p_count => x_msg_count,
855: p_data => x_msg_data);
856:
857: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN

Line 908: l_init_msg_list := FND_API.G_FALSE;

904: l_loan_header_rec := p_loan_header_rec;
905:
906: l_init_msg_list := p_init_msg_list;
907: if (l_init_msg_list is null) then
908: l_init_msg_list := FND_API.G_FALSE;
909: end if;
910:
911: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
912: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, 'Begin Validate_Loan procedure');

Line 916: IF FND_API.to_Boolean(l_init_msg_list) THEN

912: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, 'Begin Validate_Loan procedure');
913: END IF;
914:
915: -- initialize message list if l_init_msg_list is set to TRUE.
916: IF FND_API.to_Boolean(l_init_msg_list) THEN
917: FND_MSG_PUB.initialize;
918: END IF;
919:
920: -- initialize API return status to success.

Line 921: x_return_status := FND_API.G_RET_STS_SUCCESS;

917: FND_MSG_PUB.initialize;
918: END IF;
919:
920: -- initialize API return status to success.
921: x_return_status := FND_API.G_RET_STS_SUCCESS;
922:
923: /* Call this only for update!
924: -- Get old record if update.
925: -- Will be used to validate value changes in fields.

Line 984: l_init_msg_list := FND_API.G_FALSE;

980: BEGIN
981:
982: l_init_msg_list := p_init_msg_list;
983: if (l_init_msg_list is null) then
984: l_init_msg_list := FND_API.G_FALSE;
985: end if;
986:
987: --Initialize message list if l_init_msg_list is set to TRUE.
988: IF FND_API.to_Boolean(l_init_msg_list) THEN

Line 988: IF FND_API.to_Boolean(l_init_msg_list) THEN

984: l_init_msg_list := FND_API.G_FALSE;
985: end if;
986:
987: --Initialize message list if l_init_msg_list is set to TRUE.
988: IF FND_API.to_Boolean(l_init_msg_list) THEN
989: FND_MSG_PUB.initialize;
990: END IF;
991:
992: --Initialize API return status to success.

Line 993: x_return_status := FND_API.G_RET_STS_SUCCESS;

989: FND_MSG_PUB.initialize;
990: END IF;
991:
992: --Initialize API return status to success.
993: x_return_status := FND_API.G_RET_STS_SUCCESS;
994:
995: --Check whether primary key has been passed in.
996: IF p_loan_id IS NULL OR
997: p_loan_id = FND_API.G_MISS_NUM THEN

Line 997: p_loan_id = FND_API.G_MISS_NUM THEN

993: x_return_status := FND_API.G_RET_STS_SUCCESS;
994:
995: --Check whether primary key has been passed in.
996: IF p_loan_id IS NULL OR
997: p_loan_id = FND_API.G_MISS_NUM THEN
998: FND_MESSAGE.SET_NAME( 'LNS', 'LNS_API_MISSING_COLUMN' );
999: FND_MESSAGE.SET_TOKEN( 'COLUMN', 'loan_id' );
1000: FND_MSG_PUB.ADD;
1001: RAISE FND_API.G_EXC_ERROR;

Line 1001: RAISE FND_API.G_EXC_ERROR;

997: p_loan_id = FND_API.G_MISS_NUM THEN
998: FND_MESSAGE.SET_NAME( 'LNS', 'LNS_API_MISSING_COLUMN' );
999: FND_MESSAGE.SET_TOKEN( 'COLUMN', 'loan_id' );
1000: FND_MSG_PUB.ADD;
1001: RAISE FND_API.G_EXC_ERROR;
1002: END IF;
1003:
1004: x_loan_header_rec.loan_id := p_loan_id;
1005:

Line 1108: p_encoded => FND_API.G_FALSE,

1104: );
1105:
1106: --Standard call to get message count and if count is 1, get message info.
1107: FND_MSG_PUB.Count_And_Get(
1108: p_encoded => FND_API.G_FALSE,
1109: p_count => x_msg_count,
1110: p_data => x_msg_data );
1111:
1112: EXCEPTION

Line 1113: WHEN FND_API.G_EXC_ERROR THEN

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

Line 1114: x_return_status := FND_API.G_RET_STS_ERROR;

1110: p_data => x_msg_data );
1111:
1112: EXCEPTION
1113: WHEN FND_API.G_EXC_ERROR THEN
1114: x_return_status := FND_API.G_RET_STS_ERROR;
1115:
1116: FND_MSG_PUB.Count_And_Get(
1117: p_encoded => FND_API.G_FALSE,
1118: p_count => x_msg_count,

Line 1117: p_encoded => FND_API.G_FALSE,

1113: WHEN FND_API.G_EXC_ERROR THEN
1114: x_return_status := FND_API.G_RET_STS_ERROR;
1115:
1116: FND_MSG_PUB.Count_And_Get(
1117: p_encoded => FND_API.G_FALSE,
1118: p_count => x_msg_count,
1119: p_data => x_msg_data );
1120:
1121: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 1121: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1117: p_encoded => FND_API.G_FALSE,
1118: p_count => x_msg_count,
1119: p_data => x_msg_data );
1120:
1121: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1122: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1123:
1124: FND_MSG_PUB.Count_And_Get(
1125: p_encoded => FND_API.G_FALSE,

Line 1122: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1118: p_count => x_msg_count,
1119: p_data => x_msg_data );
1120:
1121: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1122: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1123:
1124: FND_MSG_PUB.Count_And_Get(
1125: p_encoded => FND_API.G_FALSE,
1126: p_count => x_msg_count,

Line 1125: p_encoded => FND_API.G_FALSE,

1121: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1122: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1123:
1124: FND_MSG_PUB.Count_And_Get(
1125: p_encoded => FND_API.G_FALSE,
1126: p_count => x_msg_count,
1127: p_data => x_msg_data );
1128:
1129: WHEN OTHERS THEN

Line 1130: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1126: p_count => x_msg_count,
1127: p_data => x_msg_data );
1128:
1129: WHEN OTHERS THEN
1130: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1131: FND_MESSAGE.SET_NAME( 'LNS', 'LNS_API_OTHERS_EXCEP' );
1132: FND_MESSAGE.SET_TOKEN( 'ERROR' ,SQLERRM );
1133: FND_MSG_PUB.ADD;
1134: FND_MSG_PUB.Count_And_Get(

Line 1135: p_encoded => FND_API.G_FALSE,

1131: FND_MESSAGE.SET_NAME( 'LNS', 'LNS_API_OTHERS_EXCEP' );
1132: FND_MESSAGE.SET_TOKEN( 'ERROR' ,SQLERRM );
1133: FND_MSG_PUB.ADD;
1134: FND_MSG_PUB.Count_And_Get(
1135: p_encoded => FND_API.G_FALSE,
1136: p_count => x_msg_count,
1137: p_data => x_msg_data );
1138:
1139: END get_loan_header_rec;