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

273: p_object_version_number = l_object_version_number
274: )
275: )
276: THEN
277: FND_MESSAGE.SET_NAME('LNS', 'LNS_API_RECORD_CHANGED');
278: FND_MESSAGE.SET_TOKEN('TABLE', 'lns_terms');
279: FND_MSG_PUB.ADD;
280: RAISE FND_API.G_EXC_ERROR;
281: END IF;

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

274: )
275: )
276: THEN
277: FND_MESSAGE.SET_NAME('LNS', 'LNS_API_RECORD_CHANGED');
278: FND_MESSAGE.SET_TOKEN('TABLE', 'lns_terms');
279: FND_MSG_PUB.ADD;
280: RAISE FND_API.G_EXC_ERROR;
281: END IF;
282:

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

281: END IF;
282:
283:
284: EXCEPTION WHEN NO_DATA_FOUND THEN
285: FND_MESSAGE.SET_NAME('LNS', 'LNS_API_NO_RECORD');
286: FND_MESSAGE.SET_TOKEN('RECORD', 'loan_term_rec');
287: FND_MESSAGE.SET_TOKEN('VALUE', NVL(TO_CHAR(p_loan_term_rec.term_id), 'null'));
288: FND_MSG_PUB.ADD;
289: RAISE FND_API.G_EXC_ERROR;

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

282:
283:
284: EXCEPTION WHEN NO_DATA_FOUND THEN
285: FND_MESSAGE.SET_NAME('LNS', 'LNS_API_NO_RECORD');
286: FND_MESSAGE.SET_TOKEN('RECORD', 'loan_term_rec');
287: FND_MESSAGE.SET_TOKEN('VALUE', NVL(TO_CHAR(p_loan_term_rec.term_id), 'null'));
288: FND_MSG_PUB.ADD;
289: RAISE FND_API.G_EXC_ERROR;
290: END;

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

283:
284: EXCEPTION WHEN NO_DATA_FOUND THEN
285: FND_MESSAGE.SET_NAME('LNS', 'LNS_API_NO_RECORD');
286: FND_MESSAGE.SET_TOKEN('RECORD', 'loan_term_rec');
287: FND_MESSAGE.SET_TOKEN('VALUE', NVL(TO_CHAR(p_loan_term_rec.term_id), 'null'));
288: FND_MSG_PUB.ADD;
289: RAISE FND_API.G_EXC_ERROR;
290: END;
291:

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

520:
521: WHEN OTHERS THEN
522: ROLLBACK TO create_term;
523: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
524: FND_MESSAGE.SET_NAME('LNS', 'LNS_API_OTHERS_EXCEP');
525: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
526: FND_MSG_PUB.ADD;
527: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,
528: p_count => x_msg_count,

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

521: WHEN OTHERS THEN
522: ROLLBACK TO create_term;
523: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
524: FND_MESSAGE.SET_NAME('LNS', 'LNS_API_OTHERS_EXCEP');
525: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
526: FND_MSG_PUB.ADD;
527: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,
528: p_count => x_msg_count,
529: p_data => x_msg_data);

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

636:
637: WHEN OTHERS THEN
638: ROLLBACK TO update_term;
639: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
640: FND_MESSAGE.SET_NAME('LNS', 'LNS_API_OTHERS_EXCEP');
641: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
642: FND_MSG_PUB.ADD;
643: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,
644: p_count => x_msg_count,

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

637: WHEN OTHERS THEN
638: ROLLBACK TO update_term;
639: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
640: FND_MESSAGE.SET_NAME('LNS', 'LNS_API_OTHERS_EXCEP');
641: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
642: FND_MSG_PUB.ADD;
643: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,
644: p_count => x_msg_count,
645: p_data => x_msg_data);

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

717: p_loan_term_rec.DAY_COUNT_METHOD <> 'ACTUAL_360' AND
718: p_loan_term_rec.DAY_COUNT_METHOD <> 'ACTUAL_365' AND
719: p_loan_term_rec.DAY_COUNT_METHOD <> 'ACTUAL_365L'))
720: then
721: FND_MESSAGE.SET_NAME('LNS', 'LNS_INVALID_DAY_COUNT');
722: FND_MSG_PUB.ADD;
723: RAISE FND_API.G_EXC_ERROR;
724: end if;
725:

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

750: p_data => x_msg_data );
751:
752: WHEN OTHERS THEN
753: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
754: FND_MESSAGE.SET_NAME( 'LNS', 'LNS_API_OTHERS_EXCEP' );
755: FND_MESSAGE.SET_TOKEN( 'ERROR' ,SQLERRM );
756: FND_MSG_PUB.ADD;
757: FND_MSG_PUB.Count_And_Get(
758: p_encoded => FND_API.G_FALSE,

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

751:
752: WHEN OTHERS THEN
753: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
754: FND_MESSAGE.SET_NAME( 'LNS', 'LNS_API_OTHERS_EXCEP' );
755: FND_MESSAGE.SET_TOKEN( 'ERROR' ,SQLERRM );
756: FND_MSG_PUB.ADD;
757: FND_MSG_PUB.Count_And_Get(
758: p_encoded => FND_API.G_FALSE,
759: p_count => x_msg_count,

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

812: x_return_status := FND_API.G_RET_STS_SUCCESS;
813:
814: --Check whether primary key has been passed in.
815: IF p_term_id IS NULL OR p_term_id = FND_API.G_MISS_NUM THEN
816: FND_MESSAGE.SET_NAME( 'LNS', 'LNS_API_MISSING_COLUMN' );
817: FND_MESSAGE.SET_TOKEN( 'COLUMN', 'term_id' );
818: FND_MSG_PUB.ADD;
819: RAISE FND_API.G_EXC_ERROR;
820: END IF;

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

813:
814: --Check whether primary key has been passed in.
815: IF p_term_id IS NULL OR p_term_id = FND_API.G_MISS_NUM THEN
816: FND_MESSAGE.SET_NAME( 'LNS', 'LNS_API_MISSING_COLUMN' );
817: FND_MESSAGE.SET_TOKEN( 'COLUMN', 'term_id' );
818: FND_MSG_PUB.ADD;
819: RAISE FND_API.G_EXC_ERROR;
820: END IF;
821:

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

906: p_data => x_msg_data );
907:
908: WHEN OTHERS THEN
909: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
910: FND_MESSAGE.SET_NAME( 'LNS', 'LNS_API_OTHERS_EXCEP' );
911: FND_MESSAGE.SET_TOKEN( 'ERROR' ,SQLERRM );
912: FND_MSG_PUB.ADD;
913: FND_MSG_PUB.Count_And_Get(
914: p_encoded => FND_API.G_FALSE,

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

907:
908: WHEN OTHERS THEN
909: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
910: FND_MESSAGE.SET_NAME( 'LNS', 'LNS_API_OTHERS_EXCEP' );
911: FND_MESSAGE.SET_TOKEN( 'ERROR' ,SQLERRM );
912: FND_MSG_PUB.ADD;
913: FND_MSG_PUB.Count_And_Get(
914: p_encoded => FND_API.G_FALSE,
915: p_count => x_msg_count,

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

1018: close c_reamortization;
1019:
1020: --dbms_output.put_line('reamortize ' || l_reamortize_overpay);
1021: if l_reamortize_overpay = 'Y' then
1022: FND_MESSAGE.SET_NAME('LNS', 'LNS_NO_REAMORTIZE');
1023: FND_MSG_PUB.Add;
1024: RAISE FND_API.G_EXC_ERROR;
1025: end if;
1026:

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

1038: for k in 1..l_rate_schedule.count
1039: loop
1040: if l_rate_schedule(k).interest_only_flag = 'Y' and l_interest_only = 'N' then
1041: dbms_output.put_line('output non continuous');
1042: FND_MESSAGE.SET_NAME('LNS', 'LNS_INTEREST_ONLY_BREAK');
1043: FND_MSG_PUB.Add;
1044: RAISE FND_API.G_EXC_ERROR;
1045: end if;
1046: l_interest_only := l_rate_schedule(k).interest_only_flag;