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

Line 100: l_return_status := OKL_API.START_ACTIVITY(l_api_name

96: -------------------
97:
98: BEGIN
99:
100: l_return_status := OKL_API.START_ACTIVITY(l_api_name
101: ,G_PKG_NAME
102: ,p_init_msg_list
103: ,l_api_version
104: ,p_api_version

Line 108: IF (l_return_status = OKL_API.g_ret_sts_unexp_error) THEN

104: ,p_api_version
105: ,'_PVT'
106: ,l_return_status);
107:
108: IF (l_return_status = OKL_API.g_ret_sts_unexp_error) THEN
109: RAISE OKL_API.g_exception_unexpected_error;
110: ELSIF (l_return_Status = OKL_API.g_ret_sts_error) THEN
111: RAISE OKL_API.g_exception_error;
112: END IF;

Line 109: RAISE OKL_API.g_exception_unexpected_error;

105: ,'_PVT'
106: ,l_return_status);
107:
108: IF (l_return_status = OKL_API.g_ret_sts_unexp_error) THEN
109: RAISE OKL_API.g_exception_unexpected_error;
110: ELSIF (l_return_Status = OKL_API.g_ret_sts_error) THEN
111: RAISE OKL_API.g_exception_error;
112: END IF;
113:

Line 110: ELSIF (l_return_Status = OKL_API.g_ret_sts_error) THEN

106: ,l_return_status);
107:
108: IF (l_return_status = OKL_API.g_ret_sts_unexp_error) THEN
109: RAISE OKL_API.g_exception_unexpected_error;
110: ELSIF (l_return_Status = OKL_API.g_ret_sts_error) THEN
111: RAISE OKL_API.g_exception_error;
112: END IF;
113:
114: l_btch_tbl := p_btch_tbl;

Line 111: RAISE OKL_API.g_exception_error;

107:
108: IF (l_return_status = OKL_API.g_ret_sts_unexp_error) THEN
109: RAISE OKL_API.g_exception_unexpected_error;
110: ELSIF (l_return_Status = OKL_API.g_ret_sts_error) THEN
111: RAISE OKL_API.g_exception_error;
112: END IF;
113:
114: l_btch_tbl := p_btch_tbl;
115:

Line 185: IF (l_return_status = OKL_API.g_ret_sts_unexp_error) THEN

181: ,x_msg_data => l_msg_data
182: ,p_btcv_tbl => l_btcv_tbl
183: );
184:
185: IF (l_return_status = OKL_API.g_ret_sts_unexp_error) THEN
186: RAISE OKL_API.g_exception_unexpected_error;
187: ELSIF (l_return_Status = OKL_API.g_ret_sts_error) THEN
188: RAISE OKL_API.g_exception_error;
189: END IF;

Line 186: RAISE OKL_API.g_exception_unexpected_error;

182: ,p_btcv_tbl => l_btcv_tbl
183: );
184:
185: IF (l_return_status = OKL_API.g_ret_sts_unexp_error) THEN
186: RAISE OKL_API.g_exception_unexpected_error;
187: ELSIF (l_return_Status = OKL_API.g_ret_sts_error) THEN
188: RAISE OKL_API.g_exception_error;
189: END IF;
190:

Line 187: ELSIF (l_return_Status = OKL_API.g_ret_sts_error) THEN

183: );
184:
185: IF (l_return_status = OKL_API.g_ret_sts_unexp_error) THEN
186: RAISE OKL_API.g_exception_unexpected_error;
187: ELSIF (l_return_Status = OKL_API.g_ret_sts_error) THEN
188: RAISE OKL_API.g_exception_error;
189: END IF;
190:
191: END IF;

Line 188: RAISE OKL_API.g_exception_error;

184:
185: IF (l_return_status = OKL_API.g_ret_sts_unexp_error) THEN
186: RAISE OKL_API.g_exception_unexpected_error;
187: ELSIF (l_return_Status = OKL_API.g_ret_sts_error) THEN
188: RAISE OKL_API.g_exception_error;
189: END IF;
190:
191: END IF;
192:

Line 204: IF (l_return_status = OKL_API.g_ret_sts_unexp_error) THEN

200: x_msg_data => l_msg_data,
201: p_rctv_tbl => l_rctv_tbl
202: );
203:
204: IF (l_return_status = OKL_API.g_ret_sts_unexp_error) THEN
205: RAISE OKL_API.g_exception_unexpected_error;
206: ELSIF (l_return_Status = OKL_API.g_ret_sts_error) THEN
207: RAISE OKL_API.g_exception_error;
208: END IF;

Line 205: RAISE OKL_API.g_exception_unexpected_error;

201: p_rctv_tbl => l_rctv_tbl
202: );
203:
204: IF (l_return_status = OKL_API.g_ret_sts_unexp_error) THEN
205: RAISE OKL_API.g_exception_unexpected_error;
206: ELSIF (l_return_Status = OKL_API.g_ret_sts_error) THEN
207: RAISE OKL_API.g_exception_error;
208: END IF;
209:

Line 206: ELSIF (l_return_Status = OKL_API.g_ret_sts_error) THEN

202: );
203:
204: IF (l_return_status = OKL_API.g_ret_sts_unexp_error) THEN
205: RAISE OKL_API.g_exception_unexpected_error;
206: ELSIF (l_return_Status = OKL_API.g_ret_sts_error) THEN
207: RAISE OKL_API.g_exception_error;
208: END IF;
209:
210: END IF;

Line 207: RAISE OKL_API.g_exception_error;

203:
204: IF (l_return_status = OKL_API.g_ret_sts_unexp_error) THEN
205: RAISE OKL_API.g_exception_unexpected_error;
206: ELSIF (l_return_Status = OKL_API.g_ret_sts_error) THEN
207: RAISE OKL_API.g_exception_error;
208: END IF;
209:
210: END IF;
211:

Line 223: IF (l_return_status = OKL_API.g_ret_sts_unexp_error) THEN

219: x_msg_data => l_msg_data,
220: p_rcav_tbl => l_rcav_tbl
221: );
222:
223: IF (l_return_status = OKL_API.g_ret_sts_unexp_error) THEN
224: RAISE OKL_API.g_exception_unexpected_error;
225: ELSIF (l_return_Status = OKL_API.g_ret_sts_error) THEN
226: RAISE OKL_API.g_exception_error;
227: END IF;

Line 224: RAISE OKL_API.g_exception_unexpected_error;

220: p_rcav_tbl => l_rcav_tbl
221: );
222:
223: IF (l_return_status = OKL_API.g_ret_sts_unexp_error) THEN
224: RAISE OKL_API.g_exception_unexpected_error;
225: ELSIF (l_return_Status = OKL_API.g_ret_sts_error) THEN
226: RAISE OKL_API.g_exception_error;
227: END IF;
228:

Line 225: ELSIF (l_return_Status = OKL_API.g_ret_sts_error) THEN

221: );
222:
223: IF (l_return_status = OKL_API.g_ret_sts_unexp_error) THEN
224: RAISE OKL_API.g_exception_unexpected_error;
225: ELSIF (l_return_Status = OKL_API.g_ret_sts_error) THEN
226: RAISE OKL_API.g_exception_error;
227: END IF;
228:
229: END IF;

Line 226: RAISE OKL_API.g_exception_error;

222:
223: IF (l_return_status = OKL_API.g_ret_sts_unexp_error) THEN
224: RAISE OKL_API.g_exception_unexpected_error;
225: ELSIF (l_return_Status = OKL_API.g_ret_sts_error) THEN
226: RAISE OKL_API.g_exception_error;
227: END IF;
228:
229: END IF;
230:

Line 235: OKL_API.end_activity(x_msg_count, x_msg_data);

231: x_return_status := l_return_status;
232: x_msg_data := l_msg_data;
233: x_msg_count := l_msg_count;
234:
235: OKL_API.end_activity(x_msg_count, x_msg_data);
236:
237: EXCEPTION
238:
239: WHEN G_EXCEPTION_HALT_VALIDATION THEN

Line 240: x_return_status := OKL_API.G_RET_STS_ERROR;

236:
237: EXCEPTION
238:
239: WHEN G_EXCEPTION_HALT_VALIDATION THEN
240: x_return_status := OKL_API.G_RET_STS_ERROR;
241: x_return_status := OKL_API.HANDLE_EXCEPTIONS
242: (
243: l_api_name,
244: G_PKG_NAME,

Line 241: x_return_status := OKL_API.HANDLE_EXCEPTIONS

237: EXCEPTION
238:
239: WHEN G_EXCEPTION_HALT_VALIDATION THEN
240: x_return_status := OKL_API.G_RET_STS_ERROR;
241: x_return_status := OKL_API.HANDLE_EXCEPTIONS
242: (
243: l_api_name,
244: G_PKG_NAME,
245: 'OKL_API.G_RET_STS_ERROR',

Line 245: 'OKL_API.G_RET_STS_ERROR',

241: x_return_status := OKL_API.HANDLE_EXCEPTIONS
242: (
243: l_api_name,
244: G_PKG_NAME,
245: 'OKL_API.G_RET_STS_ERROR',
246: x_msg_count,
247: x_msg_data,
248: '_PVT'
249: );

Line 252: WHEN OKL_API.g_exception_error THEN

248: '_PVT'
249: );
250:
251:
252: WHEN OKL_API.g_exception_error THEN
253: x_return_status := OKL_API.HANDLE_EXCEPTIONS
254: (
255: l_api_name,
256: G_PKG_NAME,

Line 253: x_return_status := OKL_API.HANDLE_EXCEPTIONS

249: );
250:
251:
252: WHEN OKL_API.g_exception_error THEN
253: x_return_status := OKL_API.HANDLE_EXCEPTIONS
254: (
255: l_api_name,
256: G_PKG_NAME,
257: 'OKL_API.G_RET_STS_ERROR',

Line 257: 'OKL_API.G_RET_STS_ERROR',

253: x_return_status := OKL_API.HANDLE_EXCEPTIONS
254: (
255: l_api_name,
256: G_PKG_NAME,
257: 'OKL_API.G_RET_STS_ERROR',
258: x_msg_count,
259: x_msg_data,
260: '_PVT'
261: );

Line 263: WHEN OKL_API.g_exception_unexpected_error THEN

259: x_msg_data,
260: '_PVT'
261: );
262:
263: WHEN OKL_API.g_exception_unexpected_error THEN
264: x_return_status := OKL_API.HANDLE_EXCEPTIONS
265: (
266: l_api_name,
267: G_PKG_NAME,

Line 264: x_return_status := OKL_API.HANDLE_EXCEPTIONS

260: '_PVT'
261: );
262:
263: WHEN OKL_API.g_exception_unexpected_error THEN
264: x_return_status := OKL_API.HANDLE_EXCEPTIONS
265: (
266: l_api_name,
267: G_PKG_NAME,
268: 'OKL_API.G_RET_STS_ERROR',

Line 268: 'OKL_API.G_RET_STS_ERROR',

264: x_return_status := OKL_API.HANDLE_EXCEPTIONS
265: (
266: l_api_name,
267: G_PKG_NAME,
268: 'OKL_API.G_RET_STS_ERROR',
269: x_msg_count,
270: x_msg_data,
271: '_PVT'
272: );

Line 275: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;

271: '_PVT'
272: );
273:
274: WHEN OTHERS THEN
275: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;
276: OKL_API.set_message( p_app_name => g_app_name
277: , p_msg_name => g_unexpected_error
278: , p_token1 => g_sqlcode_token
279: , p_token1_value => SQLCODE

Line 276: OKL_API.set_message( p_app_name => g_app_name

272: );
273:
274: WHEN OTHERS THEN
275: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;
276: OKL_API.set_message( p_app_name => g_app_name
277: , p_msg_name => g_unexpected_error
278: , p_token1 => g_sqlcode_token
279: , p_token1_value => SQLCODE
280: , p_token2 => g_sqlerrm_token