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_IMP_PVT dependencies on OKL_API

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

13:
14: l_api_name CONSTANT VARCHAR2(40) := 'INT_RATE_IMPORT';
15: l_api_version CONSTANT NUMBER := 1.0;
16: l_row_count NUMBER;
17: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
18:
19: l_idxv_rec_in idxv_rec_type;
20: l_idxv_rec_out idxv_rec_type;
21:

Line 69: x_return_status := OKL_API.G_RET_STS_SUCCESS;

65:
66: BEGIN
67:
68:
69: x_return_status := OKL_API.G_RET_STS_SUCCESS;
70:
71: l_return_status := OKL_API.START_ACTIVITY( l_api_name
72: ,g_pkg_name
73: ,p_init_msg_list

Line 71: l_return_status := OKL_API.START_ACTIVITY( l_api_name

67:
68:
69: x_return_status := OKL_API.G_RET_STS_SUCCESS;
70:
71: l_return_status := OKL_API.START_ACTIVITY( l_api_name
72: ,g_pkg_name
73: ,p_init_msg_list
74: ,l_api_version
75: ,p_api_version

Line 80: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN

76: ,'_PVT'
77: ,l_return_status);
78:
79:
80: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
81: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
82: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
83: RAISE OKL_API.G_EXCEPTION_ERROR;
84: END IF;

Line 81: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

77: ,l_return_status);
78:
79:
80: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
81: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
82: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
83: RAISE OKL_API.G_EXCEPTION_ERROR;
84: END IF;
85:

Line 82: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN

78:
79:
80: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
81: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
82: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
83: RAISE OKL_API.G_EXCEPTION_ERROR;
84: END IF;
85:
86:

Line 83: RAISE OKL_API.G_EXCEPTION_ERROR;

79:
80: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
81: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
82: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
83: RAISE OKL_API.G_EXCEPTION_ERROR;
84: END IF;
85:
86:
87:

Line 155: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN

151: x_msg_data => l_msg_data,
152: p_idxv_rec => l_idxv_rec_in,
153: x_idxv_rec => l_idxv_rec_out);
154:
155: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
156: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
157:
158: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
159: RAISE OKL_API.G_EXCEPTION_ERROR;

Line 156: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

152: p_idxv_rec => l_idxv_rec_in,
153: x_idxv_rec => l_idxv_rec_out);
154:
155: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
156: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
157:
158: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
159: RAISE OKL_API.G_EXCEPTION_ERROR;
160:

Line 158: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN

154:
155: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
156: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
157:
158: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
159: RAISE OKL_API.G_EXCEPTION_ERROR;
160:
161: END IF;
162:

Line 159: RAISE OKL_API.G_EXCEPTION_ERROR;

155: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
156: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
157:
158: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
159: RAISE OKL_API.G_EXCEPTION_ERROR;
160:
161: END IF;
162:
163: l_ivev_rec_in.idx_id := l_idxv_rec_out.id;

Line 182: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN

178: p_ivev_rec => l_ivev_rec_in,
179: x_ivev_rec => l_ivev_rec_out);
180:
181:
182: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
183:
184: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
185:
186: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN

Line 184: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

180:
181:
182: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
183:
184: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
185:
186: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
187:
188: RAISE OKL_API.G_EXCEPTION_ERROR;

Line 186: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN

182: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
183:
184: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
185:
186: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
187:
188: RAISE OKL_API.G_EXCEPTION_ERROR;
189:
190: END IF;

Line 188: RAISE OKL_API.G_EXCEPTION_ERROR;

184: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
185:
186: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
187:
188: RAISE OKL_API.G_EXCEPTION_ERROR;
189:
190: END IF;
191:
192: END IF;

Line 209: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN

205: p_idiv_tbl => l_idiv_tbl_in,
206: x_idiv_tbl => l_idiv_tbl_out);
207:
208:
209: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
210:
211: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
212:
213: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN

Line 211: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

207:
208:
209: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
210:
211: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
212:
213: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
214:
215: RAISE OKL_API.G_EXCEPTION_ERROR;

Line 213: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN

209: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
210:
211: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
212:
213: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
214:
215: RAISE OKL_API.G_EXCEPTION_ERROR;
216:
217: END IF;

Line 215: RAISE OKL_API.G_EXCEPTION_ERROR;

211: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
212:
213: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
214:
215: RAISE OKL_API.G_EXCEPTION_ERROR;
216:
217: END IF;
218:
219:

Line 220: OKL_API.END_ACTIVITY(x_msg_count, x_msg_data);

216:
217: END IF;
218:
219:
220: OKL_API.END_ACTIVITY(x_msg_count, x_msg_data);
221:
222: COMMIT WORK;
223:
224:

Line 227: WHEN OKL_API.G_EXCEPTION_ERROR THEN

223:
224:
225: EXCEPTION
226:
227: WHEN OKL_API.G_EXCEPTION_ERROR THEN
228:
229: x_return_status := OKL_API.HANDLE_EXCEPTIONS(l_api_name
230: ,g_pkg_name
231: ,'OKL_API.G_RET_STS_ERROR'

Line 229: x_return_status := OKL_API.HANDLE_EXCEPTIONS(l_api_name

225: EXCEPTION
226:
227: WHEN OKL_API.G_EXCEPTION_ERROR THEN
228:
229: x_return_status := OKL_API.HANDLE_EXCEPTIONS(l_api_name
230: ,g_pkg_name
231: ,'OKL_API.G_RET_STS_ERROR'
232: ,x_msg_count
233: ,x_msg_data

Line 231: ,'OKL_API.G_RET_STS_ERROR'

227: WHEN OKL_API.G_EXCEPTION_ERROR THEN
228:
229: x_return_status := OKL_API.HANDLE_EXCEPTIONS(l_api_name
230: ,g_pkg_name
231: ,'OKL_API.G_RET_STS_ERROR'
232: ,x_msg_count
233: ,x_msg_data
234: ,'_PVT'
235: );

Line 237: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

233: ,x_msg_data
234: ,'_PVT'
235: );
236:
237: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
238:
239: x_return_status := OKL_API.HANDLE_EXCEPTIONS(l_api_name
240: ,g_pkg_name
241: ,'OKL_API.G_RET_STS_UNEXP_ERROR'

Line 239: x_return_status := OKL_API.HANDLE_EXCEPTIONS(l_api_name

235: );
236:
237: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
238:
239: x_return_status := OKL_API.HANDLE_EXCEPTIONS(l_api_name
240: ,g_pkg_name
241: ,'OKL_API.G_RET_STS_UNEXP_ERROR'
242: ,x_msg_count
243: ,x_msg_data

Line 241: ,'OKL_API.G_RET_STS_UNEXP_ERROR'

237: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
238:
239: x_return_status := OKL_API.HANDLE_EXCEPTIONS(l_api_name
240: ,g_pkg_name
241: ,'OKL_API.G_RET_STS_UNEXP_ERROR'
242: ,x_msg_count
243: ,x_msg_data
244: ,'_PVT'
245: );

Line 249: x_return_status := OKL_API.HANDLE_EXCEPTIONS(l_api_name

245: );
246:
247: WHEN OTHERS THEN
248:
249: x_return_status := OKL_API.HANDLE_EXCEPTIONS(l_api_name
250: ,g_pkg_name
251: ,'OTHERS'
252: ,x_msg_count
253: ,x_msg_data