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_MSG_PUB

Line 98: FND_MSG_PUB.ADD;

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

Line 287: FND_MSG_PUB.ADD;

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

Line 296: FND_MSG_PUB.ADD;

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:
300: -- begin raverma 01-24-2006 add validation for day count

Line 685: FND_MSG_PUB.initialize;

681: SAVEPOINT create_term;
682:
683: -- initialize message list if p_init_msg_list is set to TRUE.
684: IF (p_init_msg_list is not null and FND_API.to_Boolean(p_init_msg_list)) THEN
685: FND_MSG_PUB.initialize;
686: END IF;
687:
688: -- initialize API return status to success.
689: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 706: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,

702: EXCEPTION
703: WHEN FND_API.G_EXC_ERROR THEN
704: ROLLBACK TO create_term;
705: x_return_status := FND_API.G_RET_STS_ERROR;
706: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,
707: p_count => x_msg_count,
708: p_data => x_msg_data);
709:
710: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 713: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,

709:
710: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
711: ROLLBACK TO create_term;
712: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
713: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,
714: p_count => x_msg_count,
715: p_data => x_msg_data);
716:
717: WHEN OTHERS THEN

Line 722: FND_MSG_PUB.ADD;

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

Line 723: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,

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);
726:
727: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN

Line 786: FND_MSG_PUB.initialize;

782: SAVEPOINT update_term;
783:
784: -- initialize message list if p_init_msg_list is set to TRUE.
785: IF (p_init_msg_list is not null and FND_API.to_Boolean(p_init_msg_list)) THEN
786: FND_MSG_PUB.initialize;
787: END IF;
788:
789: -- initialize API return status to success.
790: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 822: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,

818: EXCEPTION
819: WHEN FND_API.G_EXC_ERROR THEN
820: ROLLBACK TO update_term;
821: x_return_status := FND_API.G_RET_STS_ERROR;
822: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,
823: p_count => x_msg_count,
824: p_data => x_msg_data);
825:
826: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 829: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,

825:
826: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
827: ROLLBACK TO update_term;
828: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
829: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,
830: p_count => x_msg_count,
831: p_data => x_msg_data);
832:
833: WHEN OTHERS THEN

Line 838: FND_MSG_PUB.ADD;

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

Line 839: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,

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);
842:
843: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN

Line 922: FND_MSG_PUB.ADD;

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:
926: --Standard call to get message count and if count is 1, get message info.

Line 927: FND_MSG_PUB.Count_And_Get(

923: RAISE FND_API.G_EXC_ERROR;
924: end if;
925:
926: --Standard call to get message count and if count is 1, get message info.
927: FND_MSG_PUB.Count_And_Get(
928: p_encoded => FND_API.G_FALSE,
929: p_count => x_msg_count,
930: p_data => x_msg_data );
931:

Line 939: FND_MSG_PUB.Count_And_Get(

935: EXCEPTION
936: WHEN FND_API.G_EXC_ERROR THEN
937: x_return_status := FND_API.G_RET_STS_ERROR;
938:
939: FND_MSG_PUB.Count_And_Get(
940: p_encoded => FND_API.G_FALSE,
941: p_count => x_msg_count,
942: p_data => x_msg_data );
943:

Line 947: FND_MSG_PUB.Count_And_Get(

943:
944: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
945: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
946:
947: FND_MSG_PUB.Count_And_Get(
948: p_encoded => FND_API.G_FALSE,
949: p_count => x_msg_count,
950: p_data => x_msg_data );
951:

Line 956: FND_MSG_PUB.ADD;

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

Line 957: FND_MSG_PUB.Count_And_Get(

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,
960: p_data => x_msg_data );
961:

Line 1008: FND_MSG_PUB.initialize;

1004: BEGIN
1005:
1006: --Initialize message list if p_init_msg_list is set to TRUE.
1007: IF (p_init_msg_list is not null AND FND_API.to_Boolean(p_init_msg_list)) THEN
1008: FND_MSG_PUB.initialize;
1009: END IF;
1010:
1011: --Initialize API return status to success.
1012: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 1018: FND_MSG_PUB.ADD;

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:
1022: x_loan_term_rec.term_id := p_term_id;

Line 1095: FND_MSG_PUB.Count_And_Get(

1091:
1092: );
1093:
1094: --Standard call to get message count and if count is 1, get message info.
1095: FND_MSG_PUB.Count_And_Get(
1096: p_encoded => FND_API.G_FALSE,
1097: p_count => x_msg_count,
1098: p_data => x_msg_data );
1099:

Line 1104: FND_MSG_PUB.Count_And_Get(

1100: EXCEPTION
1101: WHEN FND_API.G_EXC_ERROR THEN
1102: x_return_status := FND_API.G_RET_STS_ERROR;
1103:
1104: FND_MSG_PUB.Count_And_Get(
1105: p_encoded => FND_API.G_FALSE,
1106: p_count => x_msg_count,
1107: p_data => x_msg_data );
1108:

Line 1112: FND_MSG_PUB.Count_And_Get(

1108:
1109: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1110: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1111:
1112: FND_MSG_PUB.Count_And_Get(
1113: p_encoded => FND_API.G_FALSE,
1114: p_count => x_msg_count,
1115: p_data => x_msg_data );
1116:

Line 1121: FND_MSG_PUB.ADD;

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

Line 1122: FND_MSG_PUB.Count_And_Get(

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,
1125: p_data => x_msg_data );
1126:

Line 1232: FND_MSG_PUB.Add;

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:
1236: /* removing this validation as per conversation with ravi on 11-3-2004

Line 1252: FND_MSG_PUB.Add;

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;
1256:

Line 1262: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);

1258: end if;
1259: */
1260: end if;
1261:
1262: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
1263:
1264: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - End');
1265:
1266: