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_MESSAGE

Line 106: FND_MESSAGE.SET_NAME('LNS', 'LNS_API_DUPLICATE_COLUMN');

102: INTO l_dummy
103: FROM LNS_LOAN_HEADERS_ALL
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:

Line 107: FND_MESSAGE.SET_TOKEN('COLUMN', 'loan_id');

103: FROM LNS_LOAN_HEADERS_ALL
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

Line 129: FND_MESSAGE.SET_NAME('LNS', 'LNS_API_MISSING_COLUMN');

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');
130: FND_MESSAGE.SET_TOKEN('COLUMN', 'LOAN_NUMBER');
131: FND_MSG_PUB.ADD;
132: RAISE FND_API.G_EXC_ERROR;
133: END IF;

Line 130: FND_MESSAGE.SET_TOKEN('COLUMN', 'LOAN_NUMBER');

126: OR
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:

Line 141: FND_MESSAGE.SET_NAME('LNS', 'LNS_API_DUPLICATE_COLUMN');

137: INTO l_dummy
138: FROM LNS_LOAN_HEADERS_ALL
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:

Line 142: FND_MESSAGE.SET_TOKEN('COLUMN', 'LOAN_NUMBER');

138: FROM LNS_LOAN_HEADERS_ALL
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

Line 163: FND_MESSAGE.SET_NAME('LNS', 'LNS_API_LOAN_NUM_AUTO_ON');

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');
164: FND_MSG_PUB.ADD;
165: RAISE FND_API.G_EXC_ERROR;
166: END IF;
167:

Line 417: FND_MESSAGE.SET_NAME('LNS', 'LNS_API_RECORD_CHANGED');

413: p_object_version_number = l_object_version_number
414: )
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;

Line 418: FND_MESSAGE.SET_TOKEN('TABLE', 'lns_loan_header_all');

414: )
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:

Line 426: FND_MESSAGE.SET_NAME('LNS', 'LNS_API_NO_RECORD');

422:
423: p_object_version_number := nvl(l_object_version_number, 1) + 1;
424:
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;

Line 427: FND_MESSAGE.SET_TOKEN('RECORD', 'loan header');

423: p_object_version_number := nvl(l_object_version_number, 1) + 1;
424:
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;

Line 428: FND_MESSAGE.SET_TOKEN('VALUE', NVL(TO_CHAR(p_loan_header_rec.loan_id), 'null'));

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

Line 707: FND_MESSAGE.SET_NAME('LNS', 'LNS_API_OTHERS_EXCEP');

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(
711: p_encoded => FND_API.G_FALSE,

Line 708: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);

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

Line 849: FND_MESSAGE.SET_NAME('LNS', 'LNS_API_OTHERS_EXCEP');

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(
853: p_encoded => FND_API.G_FALSE,

Line 850: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);

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

Line 998: FND_MESSAGE.SET_NAME( 'LNS', 'LNS_API_MISSING_COLUMN' );

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;
1002: END IF;

Line 999: FND_MESSAGE.SET_TOKEN( 'COLUMN', 'loan_id' );

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;
1002: END IF;
1003:

Line 1131: FND_MESSAGE.SET_NAME( 'LNS', 'LNS_API_OTHERS_EXCEP' );

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(
1135: p_encoded => FND_API.G_FALSE,

Line 1132: FND_MESSAGE.SET_TOKEN( 'ERROR' ,SQLERRM );

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