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_MSG_PUB

Line 108: FND_MSG_PUB.ADD;

104: WHERE loan_id = l_loan_id;
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

Line 131: FND_MSG_PUB.ADD;

127: l_loan_number IS NULL
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

Line 143: FND_MSG_PUB.ADD;

139: WHERE LOAN_NUMBER = l_loan_number;
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

Line 164: FND_MSG_PUB.ADD;

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

Line 419: FND_MSG_PUB.ADD;

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

Line 429: FND_MSG_PUB.ADD;

425: EXCEPTION WHEN NO_DATA_FOUND THEN
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

Line 643: FND_MSG_PUB.initialize;

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.
647: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 691: FND_MSG_PUB.Count_And_Get(

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

Line 699: FND_MSG_PUB.Count_And_Get(

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

Line 709: FND_MSG_PUB.ADD;

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(
711: p_encoded => FND_API.G_FALSE,
712: p_count => x_msg_count,
713: p_data => x_msg_data);

Line 710: FND_MSG_PUB.Count_And_Get(

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(
711: p_encoded => FND_API.G_FALSE,
712: p_count => x_msg_count,
713: p_data => x_msg_data);
714:

Line 780: FND_MSG_PUB.initialize;

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.
784: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 833: FND_MSG_PUB.Count_And_Get(

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

Line 841: FND_MSG_PUB.Count_And_Get(

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

Line 851: FND_MSG_PUB.ADD;

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(
853: p_encoded => FND_API.G_FALSE,
854: p_count => x_msg_count,
855: p_data => x_msg_data);

Line 852: FND_MSG_PUB.Count_And_Get(

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(
853: p_encoded => FND_API.G_FALSE,
854: p_count => x_msg_count,
855: p_data => x_msg_data);
856:

Line 917: FND_MSG_PUB.initialize;

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.
921: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 989: FND_MSG_PUB.initialize;

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.
993: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 1000: FND_MSG_PUB.ADD;

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;
1002: END IF;
1003:
1004: x_loan_header_rec.loan_id := p_loan_id;

Line 1107: FND_MSG_PUB.Count_And_Get(

1103: X_FORGIVENESS_PERCENT => x_loan_header_rec.FORGIVENESS_PERCENT
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:

Line 1116: FND_MSG_PUB.Count_And_Get(

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,
1119: p_data => x_msg_data );
1120:

Line 1124: FND_MSG_PUB.Count_And_Get(

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,
1127: p_data => x_msg_data );
1128:

Line 1133: FND_MSG_PUB.ADD;

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(
1135: p_encoded => FND_API.G_FALSE,
1136: p_count => x_msg_count,
1137: p_data => x_msg_data );

Line 1134: FND_MSG_PUB.Count_And_Get(

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(
1135: p_encoded => FND_API.G_FALSE,
1136: p_count => x_msg_count,
1137: p_data => x_msg_data );
1138: