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 422: FND_MESSAGE.SET_NAME('LNS', 'LNS_API_RECORD_CHANGED');

418: p_object_version_number = l_object_version_number
419: )
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;

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

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

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

427:
428: p_object_version_number := nvl(l_object_version_number, 1) + 1;
429:
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;

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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