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 424: FND_MSG_PUB.ADD;

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

Line 434: FND_MSG_PUB.ADD;

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

Line 653: FND_MSG_PUB.initialize;

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

Line 701: FND_MSG_PUB.Count_And_Get(

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

Line 709: FND_MSG_PUB.Count_And_Get(

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

Line 719: FND_MSG_PUB.ADD;

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(
721: p_encoded => FND_API.G_FALSE,
722: p_count => x_msg_count,
723: p_data => x_msg_data);

Line 720: FND_MSG_PUB.Count_And_Get(

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(
721: p_encoded => FND_API.G_FALSE,
722: p_count => x_msg_count,
723: p_data => x_msg_data);
724:

Line 790: FND_MSG_PUB.initialize;

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

Line 843: FND_MSG_PUB.Count_And_Get(

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

Line 851: FND_MSG_PUB.Count_And_Get(

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

Line 861: FND_MSG_PUB.ADD;

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(
863: p_encoded => FND_API.G_FALSE,
864: p_count => x_msg_count,
865: p_data => x_msg_data);

Line 862: FND_MSG_PUB.Count_And_Get(

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(
863: p_encoded => FND_API.G_FALSE,
864: p_count => x_msg_count,
865: p_data => x_msg_data);
866:

Line 927: FND_MSG_PUB.initialize;

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

Line 999: FND_MSG_PUB.initialize;

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

Line 1010: FND_MSG_PUB.ADD;

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;
1012: END IF;
1013:
1014: x_loan_header_rec.loan_id := p_loan_id;

Line 1121: FND_MSG_PUB.Count_And_Get(

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

Line 1130: FND_MSG_PUB.Count_And_Get(

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,
1133: p_data => x_msg_data );
1134:

Line 1138: FND_MSG_PUB.Count_And_Get(

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,
1141: p_data => x_msg_data );
1142:

Line 1147: FND_MSG_PUB.ADD;

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(
1149: p_encoded => FND_API.G_FALSE,
1150: p_count => x_msg_count,
1151: p_data => x_msg_data );

Line 1148: FND_MSG_PUB.Count_And_Get(

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(
1149: p_encoded => FND_API.G_FALSE,
1150: p_count => x_msg_count,
1151: p_data => x_msg_data );
1152: