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.OKL_INTEREST_MAINT_PUB dependencies on OKL_API

Line 16: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;

12: AS
13:
14: l_api_version NUMBER := 1.0;
15: l_api_name CONSTANT VARCHAR2(30) := 'INT_HDR_INS_UPDT';
16: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
17: l_idxv_rec IDXV_REC_TYPE := p_idxv_rec;
18:
19: BEGIN
20:

Line 41: IF x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR THEN

37: x_msg_data => x_msg_data,
38: p_idxv_rec => l_idxv_rec);
39:
40:
41: IF x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR THEN
42:
43: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
44:
45: ELSIF x_return_status = OKL_API.G_RET_STS_ERROR THEN

Line 45: ELSIF x_return_status = OKL_API.G_RET_STS_ERROR THEN

41: IF x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR THEN
42:
43: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
44:
45: ELSIF x_return_status = OKL_API.G_RET_STS_ERROR THEN
46:
47: RAISE FND_API.G_EXC_ERROR;
48:
49: END IF;

Line 61: FND_MSG_PUB.Count_and_get(p_encoded => OKL_API.G_FALSE

57: WHEN FND_API.G_EXC_ERROR THEN
58: ROLLBACK TO INT_HDR_INS_UPDT1;
59: x_return_status := FND_API.G_RET_STS_ERROR;
60:
61: FND_MSG_PUB.Count_and_get(p_encoded => OKL_API.G_FALSE
62: ,p_count => x_msg_count
63: ,p_data => x_msg_data);
64:
65: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 68: FND_MSG_PUB.Count_and_get(p_encoded => OKL_API.G_FALSE

64:
65: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
66: ROLLBACK TO INT_HDR_INS_UPDT1;
67: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
68: FND_MSG_PUB.Count_and_get(p_encoded => OKL_API.G_FALSE
69: ,p_count => x_msg_count
70: ,p_data => x_msg_data);
71:
72: WHEN OTHERS THEN

Line 76: FND_MSG_PUB.Count_and_get(p_encoded => OKL_API.G_FALSE

72: WHEN OTHERS THEN
73:
74: ROLLBACK TO INT_HDR_INS_UPDT1;
75: FND_MSG_PUB.ADD_EXC_MSG('OKL_INTEREST_MAINT_PUB','INT_HDR_INS_UPDT');
76: FND_MSG_PUB.Count_and_get(p_encoded => OKL_API.G_FALSE
77: ,p_count => x_msg_count
78: ,p_data => x_msg_data);
79: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
80:

Line 96: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;

92:
93:
94: l_api_version NUMBER := 1.0;
95: l_api_name CONSTANT VARCHAR2(30) := 'INT_HDR_INS_UPDT';
96: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
97: l_idxv_tbl IDXV_TBL_TYPE := p_idxv_tbl;
98:
99:
100: BEGIN

Line 122: IF x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR THEN

118: x_msg_data => x_msg_data,
119: p_idxv_tbl => p_idxv_tbl);
120:
121:
122: IF x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR THEN
123:
124: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
125:
126: ELSIF x_return_status = OKL_API.G_RET_STS_ERROR THEN

Line 126: ELSIF x_return_status = OKL_API.G_RET_STS_ERROR THEN

122: IF x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR THEN
123:
124: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
125:
126: ELSIF x_return_status = OKL_API.G_RET_STS_ERROR THEN
127:
128: RAISE FND_API.G_EXC_ERROR;
129:
130: END IF;

Line 142: FND_MSG_PUB.Count_and_get(p_encoded => OKL_API.G_FALSE

138: WHEN FND_API.G_EXC_ERROR THEN
139: ROLLBACK TO INT_HDR_INS_UPDT1;
140: x_return_status := FND_API.G_RET_STS_ERROR;
141:
142: FND_MSG_PUB.Count_and_get(p_encoded => OKL_API.G_FALSE
143: ,p_count => x_msg_count
144: ,p_data => x_msg_data);
145:
146: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 149: FND_MSG_PUB.Count_and_get(p_encoded => OKL_API.G_FALSE

145:
146: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
147: ROLLBACK TO INT_HDR_INS_UPDT1;
148: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
149: FND_MSG_PUB.Count_and_get(p_encoded => OKL_API.G_FALSE
150: ,p_count => x_msg_count
151: ,p_data => x_msg_data);
152:
153: WHEN OTHERS THEN

Line 157: FND_MSG_PUB.Count_and_get(p_encoded => OKL_API.G_FALSE

153: WHEN OTHERS THEN
154:
155: ROLLBACK TO INT_HDR_INS_UPDT1;
156: FND_MSG_PUB.ADD_EXC_MSG('OKL_INTEREST_MAINT_PUB','INT_HDR_INS_UPDT');
157: FND_MSG_PUB.Count_and_get(p_encoded => OKL_API.G_FALSE
158: ,p_count => x_msg_count
159: ,p_data => x_msg_data);
160: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
161:

Line 177: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;

173: AS
174:
175: l_api_version NUMBER := 1.0;
176: l_api_name CONSTANT VARCHAR2(30) := 'INT_DTL_INS_UPDT';
177: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
178: l_ivev_rec IVEV_REC_TYPE := p_ivev_rec;
179:
180: BEGIN
181:

Line 201: IF x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR THEN

197: x_msg_data => x_msg_data,
198: p_ivev_rec => p_ivev_rec);
199:
200:
201: IF x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR THEN
202: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
203: ELSIF x_return_status = OKL_API.G_RET_STS_ERROR THEN
204: RAISE FND_API.G_EXC_ERROR;
205: END IF;

Line 203: ELSIF x_return_status = OKL_API.G_RET_STS_ERROR THEN

199:
200:
201: IF x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR THEN
202: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
203: ELSIF x_return_status = OKL_API.G_RET_STS_ERROR THEN
204: RAISE FND_API.G_EXC_ERROR;
205: END IF;
206:
207:

Line 217: FND_MSG_PUB.Count_and_get(p_encoded => OKL_API.G_FALSE

213: WHEN FND_API.G_EXC_ERROR THEN
214: ROLLBACK TO INT_DTL_INS_UPDT1;
215: x_return_status := FND_API.G_RET_STS_ERROR;
216:
217: FND_MSG_PUB.Count_and_get(p_encoded => OKL_API.G_FALSE
218: ,p_count => x_msg_count
219: ,p_data => x_msg_data);
220:
221: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 224: FND_MSG_PUB.Count_and_get(p_encoded => OKL_API.G_FALSE

220:
221: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
222: ROLLBACK TO INT_DTL_INS_UPDT1;
223: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
224: FND_MSG_PUB.Count_and_get(p_encoded => OKL_API.G_FALSE
225: ,p_count => x_msg_count
226: ,p_data => x_msg_data);
227:
228: WHEN OTHERS THEN

Line 232: FND_MSG_PUB.Count_and_get(p_encoded => OKL_API.G_FALSE

228: WHEN OTHERS THEN
229:
230: ROLLBACK TO INT_DTL_INS_UPDT1;
231: FND_MSG_PUB.ADD_EXC_MSG('OKL_INTEREST_MAINT_PUB','INT_DTL_INS_UPDT');
232: FND_MSG_PUB.Count_and_get(p_encoded => OKL_API.G_FALSE
233: ,p_count => x_msg_count
234: ,p_data => x_msg_data);
235: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
236:

Line 254: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;

250:
251: l_api_version NUMBER := 1.0;
252:
253: l_api_name CONSTANT VARCHAR2(30) := 'INT_DTL_INS_UPDT';
254: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
255: l_ivev_tbl IVEV_TBL_TYPE := p_ivev_tbl;
256:
257:
258: BEGIN

Line 280: IF x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR THEN

276: x_msg_data => x_msg_data,
277: p_ivev_tbl => p_ivev_tbl);
278:
279:
280: IF x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR THEN
281: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
282: ELSIF x_return_status = OKL_API.G_RET_STS_ERROR THEN
283: RAISE FND_API.G_EXC_ERROR;
284: END IF;

Line 282: ELSIF x_return_status = OKL_API.G_RET_STS_ERROR THEN

278:
279:
280: IF x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR THEN
281: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
282: ELSIF x_return_status = OKL_API.G_RET_STS_ERROR THEN
283: RAISE FND_API.G_EXC_ERROR;
284: END IF;
285:
286:

Line 296: FND_MSG_PUB.Count_and_get(p_encoded => OKL_API.G_FALSE

292: WHEN FND_API.G_EXC_ERROR THEN
293: ROLLBACK TO INT_DTL_INS_UPDT1;
294: x_return_status := FND_API.G_RET_STS_ERROR;
295:
296: FND_MSG_PUB.Count_and_get(p_encoded => OKL_API.G_FALSE
297: ,p_count => x_msg_count
298: ,p_data => x_msg_data);
299:
300: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 303: FND_MSG_PUB.Count_and_get(p_encoded => OKL_API.G_FALSE

299:
300: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
301: ROLLBACK TO INT_DTL_INS_UPDT1;
302: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
303: FND_MSG_PUB.Count_and_get(p_encoded => OKL_API.G_FALSE
304: ,p_count => x_msg_count
305: ,p_data => x_msg_data);
306:
307: WHEN OTHERS THEN

Line 311: FND_MSG_PUB.Count_and_get(p_encoded => OKL_API.G_FALSE

307: WHEN OTHERS THEN
308:
309: ROLLBACK TO INT_DTL_INS_UPDT1;
310: FND_MSG_PUB.ADD_EXC_MSG('OKL_INTEREST_MAINT_PUB','INT_DTL_INS_UPDT');
311: FND_MSG_PUB.Count_and_get(p_encoded => OKL_API.G_FALSE
312: ,p_count => x_msg_count
313: ,p_data => x_msg_data);
314: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
315: