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 425: RAISE FND_API.G_EXC_ERROR;

421: THEN
422: FND_MESSAGE.SET_NAME('LNS', 'LNS_API_RECORD_CHANGED');
423: FND_MESSAGE.SET_TOKEN('TABLE', 'lns_loan_header_all');
424: FND_MSG_PUB.ADD;
425: RAISE FND_API.G_EXC_ERROR;
426: END IF;
427:
428: p_object_version_number := nvl(l_object_version_number, 1) + 1;
429:

Line 435: RAISE FND_API.G_EXC_ERROR;

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

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

446: END IF;
447:
448: --update secondary status to NULL if deleted or rejected loans
449: IF (p_loan_header_rec.loan_status='DELETED' OR p_loan_header_rec.loan_status='REJECTED') THEN
450: p_loan_header_rec.secondary_status := FND_API.G_MISS_CHAR;
451: END IF;
452:
453: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
454: 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 641: l_init_msg_list := FND_API.G_FALSE;

637: l_loan_header_rec := p_loan_header_rec;
638:
639: l_init_msg_list := p_init_msg_list;
640: if (l_init_msg_list is null) then
641: l_init_msg_list := FND_API.G_FALSE;
642: end if;
643:
644: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
645: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, 'Begin Create_Loan procedure');

Line 652: IF FND_API.to_Boolean(l_init_msg_list) THEN

648: -- standard start of API savepoint
649: SAVEPOINT create_loan;
650:
651: -- initialize message list if l_init_msg_list is set to TRUE.
652: IF FND_API.to_Boolean(l_init_msg_list) THEN
653: FND_MSG_PUB.initialize;
654: END IF;
655:
656: -- initialize API return status to success.

Line 657: x_return_status := FND_API.G_RET_STS_SUCCESS;

653: FND_MSG_PUB.initialize;
654: END IF;
655:
656: -- initialize API return status to success.
657: x_return_status := FND_API.G_RET_STS_SUCCESS;
658:
659: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
660: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, 'In Create_Loan procedure: Before call to do_create_loan proc');
661: END IF;

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

671: l_loan_id := x_loan_id;
672:
673: /*--This call is no longer needed since this is moved to
674: --the accounting page for performance reasons
675: if (x_return_status = FND_API.G_RET_STS_SUCCESS) then
676:
677: l_loan_class_code := l_loan_header_rec.loan_class_code;
678: -- call to save default distributions to the loan
679: LNS_DISTRIBUTIONS_PUB.defaultDistributions(

Line 681: p_init_msg_list => FND_API.G_TRUE,

677: l_loan_class_code := l_loan_header_rec.loan_class_code;
678: -- call to save default distributions to the loan
679: LNS_DISTRIBUTIONS_PUB.defaultDistributions(
680: p_api_version => 1.0,
681: p_init_msg_list => FND_API.G_TRUE,
682: p_commit => FND_API.G_FALSE,
683: p_loan_id => l_loan_id,
684: p_loan_class_code => l_loan_class_code,
685: x_return_status => x_return_status,

Line 682: p_commit => FND_API.G_FALSE,

678: -- call to save default distributions to the loan
679: LNS_DISTRIBUTIONS_PUB.defaultDistributions(
680: p_api_version => 1.0,
681: p_init_msg_list => FND_API.G_TRUE,
682: p_commit => FND_API.G_FALSE,
683: p_loan_id => l_loan_id,
684: p_loan_class_code => l_loan_class_code,
685: x_return_status => x_return_status,
686: x_msg_count => x_msg_count,

Line 698: WHEN FND_API.G_EXC_ERROR THEN

694: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, 'In Create_Loan procedure: After call to do_create_loan proc');
695: END IF;
696:
697: EXCEPTION
698: WHEN FND_API.G_EXC_ERROR THEN
699: ROLLBACK TO create_loan;
700: x_return_status := FND_API.G_RET_STS_ERROR;
701: FND_MSG_PUB.Count_And_Get(
702: p_encoded => FND_API.G_FALSE,

Line 700: x_return_status := FND_API.G_RET_STS_ERROR;

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

Line 702: p_encoded => FND_API.G_FALSE,

698: WHEN FND_API.G_EXC_ERROR THEN
699: ROLLBACK TO create_loan;
700: x_return_status := FND_API.G_RET_STS_ERROR;
701: FND_MSG_PUB.Count_And_Get(
702: p_encoded => FND_API.G_FALSE,
703: p_count => x_msg_count,
704: p_data => x_msg_data);
705:
706: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 706: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

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

Line 708: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

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

Line 710: p_encoded => FND_API.G_FALSE,

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

Line 716: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

712: p_data => x_msg_data);
713:
714: WHEN OTHERS THEN
715: ROLLBACK TO create_loan;
716: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
717: FND_MESSAGE.SET_NAME('LNS', 'LNS_API_OTHERS_EXCEP');
718: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
719: FND_MSG_PUB.ADD;
720: FND_MSG_PUB.Count_And_Get(

Line 721: p_encoded => FND_API.G_FALSE,

717: FND_MESSAGE.SET_NAME('LNS', 'LNS_API_OTHERS_EXCEP');
718: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
719: FND_MSG_PUB.ADD;
720: FND_MSG_PUB.Count_And_Get(
721: p_encoded => FND_API.G_FALSE,
722: p_count => x_msg_count,
723: p_data => x_msg_data);
724:
725: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN

Line 778: l_init_msg_list := FND_API.G_FALSE;

774: l_loan_header_rec := p_loan_header_rec;
775:
776: l_init_msg_list := p_init_msg_list;
777: if (l_init_msg_list is null) then
778: l_init_msg_list := FND_API.G_FALSE;
779: end if;
780:
781: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
782: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, 'Begin Update_Loan procedure');

Line 789: IF FND_API.to_Boolean(l_init_msg_list) THEN

785: -- standard start of API savepoint
786: SAVEPOINT update_loan;
787:
788: -- initialize message list if l_init_msg_list is set to TRUE.
789: IF FND_API.to_Boolean(l_init_msg_list) THEN
790: FND_MSG_PUB.initialize;
791: END IF;
792:
793: -- initialize API return status to success.

Line 794: x_return_status := FND_API.G_RET_STS_SUCCESS;

790: FND_MSG_PUB.initialize;
791: END IF;
792:
793: -- initialize API return status to success.
794: x_return_status := FND_API.G_RET_STS_SUCCESS;
795:
796: -- Get old record. Will be used by history package and
797: -- for updating loan desciption in credit mgmt credit request
798: -- as needed .

Line 800: p_init_msg_list => FND_API.G_FALSE,

796: -- Get old record. Will be used by history package and
797: -- for updating loan desciption in credit mgmt credit request
798: -- as needed .
799: get_loan_header_rec (
800: p_init_msg_list => FND_API.G_FALSE,
801: p_loan_id => l_loan_header_rec.loan_id,
802: x_loan_header_rec => l_old_loan_header_rec,
803: x_return_status => x_return_status,
804: x_msg_count => x_msg_count,

Line 807: IF x_return_status = FND_API.G_RET_STS_ERROR THEN

803: x_return_status => x_return_status,
804: x_msg_count => x_msg_count,
805: x_msg_data => x_msg_data );
806:
807: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
808: RAISE FND_API.G_EXC_ERROR;
809: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
810: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
811: END IF;

Line 808: RAISE FND_API.G_EXC_ERROR;

804: x_msg_count => x_msg_count,
805: x_msg_data => x_msg_data );
806:
807: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
808: RAISE FND_API.G_EXC_ERROR;
809: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
810: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
811: END IF;
812:

Line 809: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

805: x_msg_data => x_msg_data );
806:
807: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
808: RAISE FND_API.G_EXC_ERROR;
809: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
810: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
811: END IF;
812:
813: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN

Line 810: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

806:
807: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
808: RAISE FND_API.G_EXC_ERROR;
809: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
810: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
811: END IF;
812:
813: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
814: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, 'In Update_Loan procedure: Before call to do_update_loan proc');

Line 831: 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

827:
828: --if the loan description has changed and credit request created
829: --for this loan participants, update the credit request with the
830: --new loan description information to fix bug#4930854
831: 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
832: update ar_cmgt_credit_requests
833: set SOURCE_COLUMN3 = l_loan_header_rec.loan_description
834: where SOURCE_NAME = 'LNS' and
835: SOURCE_COLUMN1 = to_char(l_loan_header_rec.loan_id) and

Line 840: WHEN FND_API.G_EXC_ERROR THEN

836: SOURCE_COLUMN3 = l_old_loan_header_rec.loan_description;
837: END IF;
838:
839: EXCEPTION
840: WHEN FND_API.G_EXC_ERROR THEN
841: ROLLBACK TO update_loan;
842: x_return_status := FND_API.G_RET_STS_ERROR;
843: FND_MSG_PUB.Count_And_Get(
844: p_encoded => FND_API.G_FALSE,

Line 842: x_return_status := FND_API.G_RET_STS_ERROR;

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

Line 844: p_encoded => FND_API.G_FALSE,

840: WHEN FND_API.G_EXC_ERROR THEN
841: ROLLBACK TO update_loan;
842: x_return_status := FND_API.G_RET_STS_ERROR;
843: FND_MSG_PUB.Count_And_Get(
844: p_encoded => FND_API.G_FALSE,
845: p_count => x_msg_count,
846: p_data => x_msg_data);
847:
848: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 848: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

844: p_encoded => FND_API.G_FALSE,
845: p_count => x_msg_count,
846: p_data => x_msg_data);
847:
848: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
849: ROLLBACK TO update_loan;
850: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
851: FND_MSG_PUB.Count_And_Get(
852: p_encoded => FND_API.G_FALSE,

Line 850: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

846: p_data => x_msg_data);
847:
848: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
849: ROLLBACK TO update_loan;
850: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
851: FND_MSG_PUB.Count_And_Get(
852: p_encoded => FND_API.G_FALSE,
853: p_count => x_msg_count,
854: p_data => x_msg_data);

Line 852: p_encoded => FND_API.G_FALSE,

848: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
849: ROLLBACK TO update_loan;
850: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
851: FND_MSG_PUB.Count_And_Get(
852: p_encoded => FND_API.G_FALSE,
853: p_count => x_msg_count,
854: p_data => x_msg_data);
855:
856: WHEN OTHERS THEN

Line 858: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

854: p_data => x_msg_data);
855:
856: WHEN OTHERS THEN
857: ROLLBACK TO update_loan;
858: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
859: FND_MESSAGE.SET_NAME('LNS', 'LNS_API_OTHERS_EXCEP');
860: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
861: FND_MSG_PUB.ADD;
862: FND_MSG_PUB.Count_And_Get(

Line 863: p_encoded => FND_API.G_FALSE,

859: FND_MESSAGE.SET_NAME('LNS', 'LNS_API_OTHERS_EXCEP');
860: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
861: FND_MSG_PUB.ADD;
862: FND_MSG_PUB.Count_And_Get(
863: p_encoded => FND_API.G_FALSE,
864: p_count => x_msg_count,
865: p_data => x_msg_data);
866:
867: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN

Line 918: l_init_msg_list := FND_API.G_FALSE;

914: l_loan_header_rec := p_loan_header_rec;
915:
916: l_init_msg_list := p_init_msg_list;
917: if (l_init_msg_list is null) then
918: l_init_msg_list := FND_API.G_FALSE;
919: end if;
920:
921: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
922: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, 'Begin Validate_Loan procedure');

Line 926: IF FND_API.to_Boolean(l_init_msg_list) THEN

922: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, 'Begin Validate_Loan procedure');
923: END IF;
924:
925: -- initialize message list if l_init_msg_list is set to TRUE.
926: IF FND_API.to_Boolean(l_init_msg_list) THEN
927: FND_MSG_PUB.initialize;
928: END IF;
929:
930: -- initialize API return status to success.

Line 931: x_return_status := FND_API.G_RET_STS_SUCCESS;

927: FND_MSG_PUB.initialize;
928: END IF;
929:
930: -- initialize API return status to success.
931: x_return_status := FND_API.G_RET_STS_SUCCESS;
932:
933: /* Call this only for update!
934: -- Get old record if update.
935: -- Will be used to validate value changes in fields.

Line 994: l_init_msg_list := FND_API.G_FALSE;

990: BEGIN
991:
992: l_init_msg_list := p_init_msg_list;
993: if (l_init_msg_list is null) then
994: l_init_msg_list := FND_API.G_FALSE;
995: end if;
996:
997: --Initialize message list if l_init_msg_list is set to TRUE.
998: IF FND_API.to_Boolean(l_init_msg_list) THEN

Line 998: IF FND_API.to_Boolean(l_init_msg_list) THEN

994: l_init_msg_list := FND_API.G_FALSE;
995: end if;
996:
997: --Initialize message list if l_init_msg_list is set to TRUE.
998: IF FND_API.to_Boolean(l_init_msg_list) THEN
999: FND_MSG_PUB.initialize;
1000: END IF;
1001:
1002: --Initialize API return status to success.

Line 1003: x_return_status := FND_API.G_RET_STS_SUCCESS;

999: FND_MSG_PUB.initialize;
1000: END IF;
1001:
1002: --Initialize API return status to success.
1003: x_return_status := FND_API.G_RET_STS_SUCCESS;
1004:
1005: --Check whether primary key has been passed in.
1006: IF p_loan_id IS NULL OR
1007: p_loan_id = FND_API.G_MISS_NUM THEN

Line 1007: p_loan_id = FND_API.G_MISS_NUM THEN

1003: x_return_status := FND_API.G_RET_STS_SUCCESS;
1004:
1005: --Check whether primary key has been passed in.
1006: IF p_loan_id IS NULL OR
1007: p_loan_id = FND_API.G_MISS_NUM THEN
1008: FND_MESSAGE.SET_NAME( 'LNS', 'LNS_API_MISSING_COLUMN' );
1009: FND_MESSAGE.SET_TOKEN( 'COLUMN', 'loan_id' );
1010: FND_MSG_PUB.ADD;
1011: RAISE FND_API.G_EXC_ERROR;

Line 1011: RAISE FND_API.G_EXC_ERROR;

1007: p_loan_id = FND_API.G_MISS_NUM THEN
1008: FND_MESSAGE.SET_NAME( 'LNS', 'LNS_API_MISSING_COLUMN' );
1009: FND_MESSAGE.SET_TOKEN( 'COLUMN', 'loan_id' );
1010: FND_MSG_PUB.ADD;
1011: RAISE FND_API.G_EXC_ERROR;
1012: END IF;
1013:
1014: x_loan_header_rec.loan_id := p_loan_id;
1015:

Line 1122: p_encoded => FND_API.G_FALSE,

1118: );
1119:
1120: --Standard call to get message count and if count is 1, get message info.
1121: FND_MSG_PUB.Count_And_Get(
1122: p_encoded => FND_API.G_FALSE,
1123: p_count => x_msg_count,
1124: p_data => x_msg_data );
1125:
1126: EXCEPTION

Line 1127: WHEN FND_API.G_EXC_ERROR THEN

1123: p_count => x_msg_count,
1124: p_data => x_msg_data );
1125:
1126: EXCEPTION
1127: WHEN FND_API.G_EXC_ERROR THEN
1128: x_return_status := FND_API.G_RET_STS_ERROR;
1129:
1130: FND_MSG_PUB.Count_And_Get(
1131: p_encoded => FND_API.G_FALSE,

Line 1128: x_return_status := FND_API.G_RET_STS_ERROR;

1124: p_data => x_msg_data );
1125:
1126: EXCEPTION
1127: WHEN FND_API.G_EXC_ERROR THEN
1128: x_return_status := FND_API.G_RET_STS_ERROR;
1129:
1130: FND_MSG_PUB.Count_And_Get(
1131: p_encoded => FND_API.G_FALSE,
1132: p_count => x_msg_count,

Line 1131: p_encoded => FND_API.G_FALSE,

1127: WHEN FND_API.G_EXC_ERROR THEN
1128: x_return_status := FND_API.G_RET_STS_ERROR;
1129:
1130: FND_MSG_PUB.Count_And_Get(
1131: p_encoded => FND_API.G_FALSE,
1132: p_count => x_msg_count,
1133: p_data => x_msg_data );
1134:
1135: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 1135: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1131: p_encoded => FND_API.G_FALSE,
1132: p_count => x_msg_count,
1133: p_data => x_msg_data );
1134:
1135: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1136: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1137:
1138: FND_MSG_PUB.Count_And_Get(
1139: p_encoded => FND_API.G_FALSE,

Line 1136: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1132: p_count => x_msg_count,
1133: p_data => x_msg_data );
1134:
1135: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1136: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1137:
1138: FND_MSG_PUB.Count_And_Get(
1139: p_encoded => FND_API.G_FALSE,
1140: p_count => x_msg_count,

Line 1139: p_encoded => FND_API.G_FALSE,

1135: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1136: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1137:
1138: FND_MSG_PUB.Count_And_Get(
1139: p_encoded => FND_API.G_FALSE,
1140: p_count => x_msg_count,
1141: p_data => x_msg_data );
1142:
1143: WHEN OTHERS THEN

Line 1144: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1140: p_count => x_msg_count,
1141: p_data => x_msg_data );
1142:
1143: WHEN OTHERS THEN
1144: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1145: FND_MESSAGE.SET_NAME( 'LNS', 'LNS_API_OTHERS_EXCEP' );
1146: FND_MESSAGE.SET_TOKEN( 'ERROR' ,SQLERRM );
1147: FND_MSG_PUB.ADD;
1148: FND_MSG_PUB.Count_And_Get(

Line 1149: p_encoded => FND_API.G_FALSE,

1145: FND_MESSAGE.SET_NAME( 'LNS', 'LNS_API_OTHERS_EXCEP' );
1146: FND_MESSAGE.SET_TOKEN( 'ERROR' ,SQLERRM );
1147: FND_MSG_PUB.ADD;
1148: FND_MSG_PUB.Count_And_Get(
1149: p_encoded => FND_API.G_FALSE,
1150: p_count => x_msg_count,
1151: p_data => x_msg_data );
1152:
1153: END get_loan_header_rec;