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_TERMS_PUB dependencies on FND_MESSAGE

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

92: INTO l_dummy
93: FROM LNS_TERMS
94: WHERE term_id = l_term_id;
95:
96: FND_MESSAGE.SET_NAME('LNS', 'LNS_API_DUPLICATE_COLUMN');
97: FND_MESSAGE.SET_TOKEN('COLUMN', 'term_id');
98: FND_MSG_PUB.ADD;
99: RAISE FND_API.G_EXC_ERROR;
100:

Line 97: FND_MESSAGE.SET_TOKEN('COLUMN', 'term_id');

93: FROM LNS_TERMS
94: WHERE term_id = l_term_id;
95:
96: FND_MESSAGE.SET_NAME('LNS', 'LNS_API_DUPLICATE_COLUMN');
97: FND_MESSAGE.SET_TOKEN('COLUMN', 'term_id');
98: FND_MSG_PUB.ADD;
99: RAISE FND_API.G_EXC_ERROR;
100:
101: EXCEPTION

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

281: p_object_version_number = l_object_version_number
282: )
283: )
284: THEN
285: FND_MESSAGE.SET_NAME('LNS', 'LNS_API_RECORD_CHANGED');
286: FND_MESSAGE.SET_TOKEN('TABLE', 'lns_terms');
287: FND_MSG_PUB.ADD;
288: RAISE FND_API.G_EXC_ERROR;
289: END IF;

Line 286: FND_MESSAGE.SET_TOKEN('TABLE', 'lns_terms');

282: )
283: )
284: THEN
285: FND_MESSAGE.SET_NAME('LNS', 'LNS_API_RECORD_CHANGED');
286: FND_MESSAGE.SET_TOKEN('TABLE', 'lns_terms');
287: FND_MSG_PUB.ADD;
288: RAISE FND_API.G_EXC_ERROR;
289: END IF;
290:

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

289: END IF;
290:
291:
292: EXCEPTION WHEN NO_DATA_FOUND THEN
293: FND_MESSAGE.SET_NAME('LNS', 'LNS_API_NO_RECORD');
294: FND_MESSAGE.SET_TOKEN('RECORD', 'loan_term_rec');
295: FND_MESSAGE.SET_TOKEN('VALUE', NVL(TO_CHAR(p_loan_term_rec.term_id), 'null'));
296: FND_MSG_PUB.ADD;
297: RAISE FND_API.G_EXC_ERROR;

Line 294: FND_MESSAGE.SET_TOKEN('RECORD', 'loan_term_rec');

290:
291:
292: EXCEPTION WHEN NO_DATA_FOUND THEN
293: FND_MESSAGE.SET_NAME('LNS', 'LNS_API_NO_RECORD');
294: FND_MESSAGE.SET_TOKEN('RECORD', 'loan_term_rec');
295: FND_MESSAGE.SET_TOKEN('VALUE', NVL(TO_CHAR(p_loan_term_rec.term_id), 'null'));
296: FND_MSG_PUB.ADD;
297: RAISE FND_API.G_EXC_ERROR;
298: END;

Line 295: FND_MESSAGE.SET_TOKEN('VALUE', NVL(TO_CHAR(p_loan_term_rec.term_id), 'null'));

291:
292: EXCEPTION WHEN NO_DATA_FOUND THEN
293: FND_MESSAGE.SET_NAME('LNS', 'LNS_API_NO_RECORD');
294: FND_MESSAGE.SET_TOKEN('RECORD', 'loan_term_rec');
295: FND_MESSAGE.SET_TOKEN('VALUE', NVL(TO_CHAR(p_loan_term_rec.term_id), 'null'));
296: FND_MSG_PUB.ADD;
297: RAISE FND_API.G_EXC_ERROR;
298: END;
299:

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

716:
717: WHEN OTHERS THEN
718: ROLLBACK TO create_term;
719: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
720: FND_MESSAGE.SET_NAME('LNS', 'LNS_API_OTHERS_EXCEP');
721: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
722: FND_MSG_PUB.ADD;
723: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,
724: p_count => x_msg_count,

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

717: WHEN OTHERS THEN
718: ROLLBACK TO create_term;
719: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
720: FND_MESSAGE.SET_NAME('LNS', 'LNS_API_OTHERS_EXCEP');
721: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
722: FND_MSG_PUB.ADD;
723: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,
724: p_count => x_msg_count,
725: p_data => x_msg_data);

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

832:
833: WHEN OTHERS THEN
834: ROLLBACK TO update_term;
835: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
836: FND_MESSAGE.SET_NAME('LNS', 'LNS_API_OTHERS_EXCEP');
837: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
838: FND_MSG_PUB.ADD;
839: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,
840: p_count => x_msg_count,

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

833: WHEN OTHERS THEN
834: ROLLBACK TO update_term;
835: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
836: FND_MESSAGE.SET_NAME('LNS', 'LNS_API_OTHERS_EXCEP');
837: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
838: FND_MSG_PUB.ADD;
839: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,
840: p_count => x_msg_count,
841: p_data => x_msg_data);

Line 921: FND_MESSAGE.SET_NAME('LNS', 'LNS_INVALID_DAY_COUNT');

917: p_loan_term_rec.DAY_COUNT_METHOD <> 'ACTUAL_360' AND
918: p_loan_term_rec.DAY_COUNT_METHOD <> 'ACTUAL_365' AND
919: p_loan_term_rec.DAY_COUNT_METHOD <> 'ACTUAL_365L')
920: then
921: FND_MESSAGE.SET_NAME('LNS', 'LNS_INVALID_DAY_COUNT');
922: FND_MSG_PUB.ADD;
923: RAISE FND_API.G_EXC_ERROR;
924: end if;
925:

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

950: p_data => x_msg_data );
951:
952: WHEN OTHERS THEN
953: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
954: FND_MESSAGE.SET_NAME( 'LNS', 'LNS_API_OTHERS_EXCEP' );
955: FND_MESSAGE.SET_TOKEN( 'ERROR' ,SQLERRM );
956: FND_MSG_PUB.ADD;
957: FND_MSG_PUB.Count_And_Get(
958: p_encoded => FND_API.G_FALSE,

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

951:
952: WHEN OTHERS THEN
953: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
954: FND_MESSAGE.SET_NAME( 'LNS', 'LNS_API_OTHERS_EXCEP' );
955: FND_MESSAGE.SET_TOKEN( 'ERROR' ,SQLERRM );
956: FND_MSG_PUB.ADD;
957: FND_MSG_PUB.Count_And_Get(
958: p_encoded => FND_API.G_FALSE,
959: p_count => x_msg_count,

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

1012: x_return_status := FND_API.G_RET_STS_SUCCESS;
1013:
1014: --Check whether primary key has been passed in.
1015: IF p_term_id IS NULL OR p_term_id = FND_API.G_MISS_NUM THEN
1016: FND_MESSAGE.SET_NAME( 'LNS', 'LNS_API_MISSING_COLUMN' );
1017: FND_MESSAGE.SET_TOKEN( 'COLUMN', 'term_id' );
1018: FND_MSG_PUB.ADD;
1019: RAISE FND_API.G_EXC_ERROR;
1020: END IF;

Line 1017: FND_MESSAGE.SET_TOKEN( 'COLUMN', 'term_id' );

1013:
1014: --Check whether primary key has been passed in.
1015: IF p_term_id IS NULL OR p_term_id = FND_API.G_MISS_NUM THEN
1016: FND_MESSAGE.SET_NAME( 'LNS', 'LNS_API_MISSING_COLUMN' );
1017: FND_MESSAGE.SET_TOKEN( 'COLUMN', 'term_id' );
1018: FND_MSG_PUB.ADD;
1019: RAISE FND_API.G_EXC_ERROR;
1020: END IF;
1021:

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

1115: p_data => x_msg_data );
1116:
1117: WHEN OTHERS THEN
1118: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1119: FND_MESSAGE.SET_NAME( 'LNS', 'LNS_API_OTHERS_EXCEP' );
1120: FND_MESSAGE.SET_TOKEN( 'ERROR' ,SQLERRM );
1121: FND_MSG_PUB.ADD;
1122: FND_MSG_PUB.Count_And_Get(
1123: p_encoded => FND_API.G_FALSE,

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

1116:
1117: WHEN OTHERS THEN
1118: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1119: FND_MESSAGE.SET_NAME( 'LNS', 'LNS_API_OTHERS_EXCEP' );
1120: FND_MESSAGE.SET_TOKEN( 'ERROR' ,SQLERRM );
1121: FND_MSG_PUB.ADD;
1122: FND_MSG_PUB.Count_And_Get(
1123: p_encoded => FND_API.G_FALSE,
1124: p_count => x_msg_count,

Line 1231: FND_MESSAGE.SET_NAME('LNS', 'LNS_NO_REAMORTIZE');

1227: close c_reamortization;
1228:
1229: --dbms_output.put_line('reamortize ' || l_reamortize_overpay);
1230: if l_reamortize_overpay = 'Y' then
1231: FND_MESSAGE.SET_NAME('LNS', 'LNS_NO_REAMORTIZE');
1232: FND_MSG_PUB.Add;
1233: RAISE FND_API.G_EXC_ERROR;
1234: end if;
1235:

Line 1251: FND_MESSAGE.SET_NAME('LNS', 'LNS_INTEREST_ONLY_BREAK');

1247: for k in 1..l_rate_schedule.count
1248: loop
1249: if l_rate_schedule(k).interest_only_flag = 'Y' and l_interest_only = 'N' then
1250: dbms_output.put_line('output non continuous');
1251: FND_MESSAGE.SET_NAME('LNS', 'LNS_INTEREST_ONLY_BREAK');
1252: FND_MSG_PUB.Add;
1253: RAISE FND_API.G_EXC_ERROR;
1254: end if;
1255: l_interest_only := l_rate_schedule(k).interest_only_flag;