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

Line 27: l_return_status := OKL_API.START_ACTIVITY(p_api_name => l_api_name,

23: BEGIN
24: l_return_status := G_RET_STS_SUCCESS;
25:
26: l_pitv_rec := p_pitv_rec;
27: l_return_status := OKL_API.START_ACTIVITY(p_api_name => l_api_name,
28: p_pkg_name => G_PKG_NAME,
29: p_init_msg_list => p_init_msg_list,
30: l_api_version => l_api_version,
31: p_api_version => p_api_version,

Line 61: OKL_API.END_ACTIVITY(x_msg_count => x_msg_count,

57: /* re-assign local record structure using output record from pvt api */
58: l_pitv_rec := x_pitv_rec;
59:
60:
61: OKL_API.END_ACTIVITY(x_msg_count => x_msg_count,
62: x_msg_data => x_msg_data);
63: x_return_status := l_return_status;
64: EXCEPTION
65: WHEN G_EXCEPTION_ERROR THEN

Line 66: x_return_status := OKL_API.HANDLE_EXCEPTIONS(p_api_name => l_api_name,

62: x_msg_data => x_msg_data);
63: x_return_status := l_return_status;
64: EXCEPTION
65: WHEN G_EXCEPTION_ERROR THEN
66: x_return_status := OKL_API.HANDLE_EXCEPTIONS(p_api_name => l_api_name,
67: p_pkg_name => G_PKG_NAME,
68: p_exc_name => G_EXC_NAME_ERROR,
69: x_msg_count => x_msg_count,
70: x_msg_data => x_msg_data,

Line 73: x_return_status := OKL_API.HANDLE_EXCEPTIONS(p_api_name => l_api_name,

69: x_msg_count => x_msg_count,
70: x_msg_data => x_msg_data,
71: p_api_type => G_API_TYPE);
72: WHEN G_EXCEPTION_UNEXPECTED_ERROR THEN
73: x_return_status := OKL_API.HANDLE_EXCEPTIONS(p_api_name => l_api_name,
74: p_pkg_name => G_PKG_NAME,
75: p_exc_name => G_EXC_NAME_UNEXP_ERROR,
76: x_msg_count => x_msg_count,
77: x_msg_data => x_msg_data,

Line 80: x_return_status := OKL_API.HANDLE_EXCEPTIONS(p_api_name => l_api_name,

76: x_msg_count => x_msg_count,
77: x_msg_data => x_msg_data,
78: p_api_type => G_API_TYPE);
79: WHEN OTHERS THEN
80: x_return_status := OKL_API.HANDLE_EXCEPTIONS(p_api_name => l_api_name,
81: p_pkg_name => G_PKG_NAME,
82: p_exc_name => G_EXC_NAME_OTHERS,
83: x_msg_count => x_msg_count,
84: x_msg_data => x_msg_data,

Line 113: l_return_status := OKL_API.START_ACTIVITY(p_api_name => l_api_name,

109: l_return_status := G_RET_STS_SUCCESS;
110:
111: l_pitv_rec := p_pitv_rec;
112:
113: l_return_status := OKL_API.START_ACTIVITY(p_api_name => l_api_name,
114: p_pkg_name => G_PKG_NAME,
115: p_init_msg_list => p_init_msg_list,
116: l_api_version => l_api_version,
117: p_api_version => p_api_version,

Line 147: OKL_API.END_ACTIVITY(x_msg_count => x_msg_count,

143: /* re-assign local record structure using output record from pvt api */
144: l_pitv_rec := x_pitv_rec;
145:
146:
147: OKL_API.END_ACTIVITY(x_msg_count => x_msg_count,
148: x_msg_data => x_msg_data);
149: x_return_status := l_return_status;
150: EXCEPTION
151: WHEN G_EXCEPTION_ERROR THEN

Line 152: x_return_status := OKL_API.HANDLE_EXCEPTIONS(p_api_name => l_api_name,

148: x_msg_data => x_msg_data);
149: x_return_status := l_return_status;
150: EXCEPTION
151: WHEN G_EXCEPTION_ERROR THEN
152: x_return_status := OKL_API.HANDLE_EXCEPTIONS(p_api_name => l_api_name,
153: p_pkg_name => G_PKG_NAME,
154: p_exc_name => G_EXC_NAME_ERROR,
155: x_msg_count => x_msg_count,
156: x_msg_data => x_msg_data,

Line 159: x_return_status := OKL_API.HANDLE_EXCEPTIONS(p_api_name => l_api_name,

155: x_msg_count => x_msg_count,
156: x_msg_data => x_msg_data,
157: p_api_type => G_API_TYPE);
158: WHEN G_EXCEPTION_UNEXPECTED_ERROR THEN
159: x_return_status := OKL_API.HANDLE_EXCEPTIONS(p_api_name => l_api_name,
160: p_pkg_name => G_PKG_NAME,
161: p_exc_name => G_EXC_NAME_UNEXP_ERROR,
162: x_msg_count => x_msg_count,
163: x_msg_data => x_msg_data,

Line 166: x_return_status := OKL_API.HANDLE_EXCEPTIONS(p_api_name => l_api_name,

162: x_msg_count => x_msg_count,
163: x_msg_data => x_msg_data,
164: p_api_type => G_API_TYPE);
165: WHEN OTHERS THEN
166: x_return_status := OKL_API.HANDLE_EXCEPTIONS(p_api_name => l_api_name,
167: p_pkg_name => G_PKG_NAME,
168: p_exc_name => G_EXC_NAME_OTHERS,
169: x_msg_count => x_msg_count,
170: x_msg_data => x_msg_data,

Line 189: l_return_status := OKL_API.START_ACTIVITY(p_api_name => l_api_name,

185: rec_num INTEGER := 0;
186: l_api_version CONSTANT NUMBER := 1;
187: BEGIN
188:
189: l_return_status := OKL_API.START_ACTIVITY(p_api_name => l_api_name,
190: p_pkg_name => G_PKG_NAME,
191: p_init_msg_list => p_init_msg_list,
192: l_api_version => l_api_version,
193: p_api_version => p_api_version,

Line 219: OKL_API.END_ACTIVITY(x_msg_count => x_msg_count,

215: ELSIF (l_return_status = G_RET_STS_ERROR) THEN
216: RAISE G_EXCEPTION_ERROR;
217: END IF;
218: END LOOP;
219: OKL_API.END_ACTIVITY(x_msg_count => x_msg_count,
220: x_msg_data => x_msg_data);
221: x_return_status := l_return_status;
222: EXCEPTION
223: WHEN G_EXCEPTION_ERROR THEN

Line 224: x_return_status := OKL_API.HANDLE_EXCEPTIONS(p_api_name => l_api_name,

220: x_msg_data => x_msg_data);
221: x_return_status := l_return_status;
222: EXCEPTION
223: WHEN G_EXCEPTION_ERROR THEN
224: x_return_status := OKL_API.HANDLE_EXCEPTIONS(p_api_name => l_api_name,
225: p_pkg_name => G_PKG_NAME,
226: p_exc_name => G_EXC_NAME_ERROR,
227: x_msg_count => x_msg_count,
228: x_msg_data => x_msg_data,

Line 231: x_return_status := OKL_API.HANDLE_EXCEPTIONS(p_api_name => l_api_name,

227: x_msg_count => x_msg_count,
228: x_msg_data => x_msg_data,
229: p_api_type => G_API_TYPE);
230: WHEN G_EXCEPTION_UNEXPECTED_ERROR THEN
231: x_return_status := OKL_API.HANDLE_EXCEPTIONS(p_api_name => l_api_name,
232: p_pkg_name => G_PKG_NAME,
233: p_exc_name => G_EXC_NAME_UNEXP_ERROR,
234: x_msg_count => x_msg_count,
235: x_msg_data => x_msg_data,

Line 238: x_return_status := OKL_API.HANDLE_EXCEPTIONS(p_api_name => l_api_name,

234: x_msg_count => x_msg_count,
235: x_msg_data => x_msg_data,
236: p_api_type => G_API_TYPE);
237: WHEN OTHERS THEN
238: x_return_status := OKL_API.HANDLE_EXCEPTIONS(p_api_name => l_api_name,
239: p_pkg_name => G_PKG_NAME,
240: p_exc_name => G_EXC_NAME_OTHERS,
241: x_msg_count => x_msg_count,
242: x_msg_data => x_msg_data,

Line 263: l_return_status := OKL_API.START_ACTIVITY(p_api_name => l_api_name,

259: rec_num INTEGER := 0;
260: l_api_version CONSTANT NUMBER := 1;
261: BEGIN
262:
263: l_return_status := OKL_API.START_ACTIVITY(p_api_name => l_api_name,
264: p_pkg_name => G_PKG_NAME,
265: p_init_msg_list => p_init_msg_list,
266: l_api_version => l_api_version,
267: p_api_version => p_api_version,

Line 295: OKL_API.END_ACTIVITY(x_msg_count => x_msg_count,

291: END IF;
292:
293: END LOOP;
294:
295: OKL_API.END_ACTIVITY(x_msg_count => x_msg_count,
296: x_msg_data => x_msg_data);
297: x_return_status := l_return_status;
298: EXCEPTION
299: WHEN G_EXCEPTION_ERROR THEN

Line 300: x_return_status := OKL_API.HANDLE_EXCEPTIONS(p_api_name => l_api_name,

296: x_msg_data => x_msg_data);
297: x_return_status := l_return_status;
298: EXCEPTION
299: WHEN G_EXCEPTION_ERROR THEN
300: x_return_status := OKL_API.HANDLE_EXCEPTIONS(p_api_name => l_api_name,
301: p_pkg_name => G_PKG_NAME,
302: p_exc_name => G_EXC_NAME_ERROR,
303: x_msg_count => x_msg_count,
304: x_msg_data => x_msg_data,

Line 307: x_return_status := OKL_API.HANDLE_EXCEPTIONS(p_api_name => l_api_name,

303: x_msg_count => x_msg_count,
304: x_msg_data => x_msg_data,
305: p_api_type => G_API_TYPE);
306: WHEN G_EXCEPTION_UNEXPECTED_ERROR THEN
307: x_return_status := OKL_API.HANDLE_EXCEPTIONS(p_api_name => l_api_name,
308: p_pkg_name => G_PKG_NAME,
309: p_exc_name => G_EXC_NAME_UNEXP_ERROR,
310: x_msg_count => x_msg_count,
311: x_msg_data => x_msg_data,

Line 314: x_return_status := OKL_API.HANDLE_EXCEPTIONS(p_api_name => l_api_name,

310: x_msg_count => x_msg_count,
311: x_msg_data => x_msg_data,
312: p_api_type => G_API_TYPE);
313: WHEN OTHERS THEN
314: x_return_status := OKL_API.HANDLE_EXCEPTIONS(p_api_name => l_api_name,
315: p_pkg_name => G_PKG_NAME,
316: p_exc_name => G_EXC_NAME_OTHERS,
317: x_msg_count => x_msg_count,
318: x_msg_data => x_msg_data,

Line 344: l_return_status := OKL_API.START_ACTIVITY(p_api_name => l_api_name,

340: BEGIN
341:
342:
343: l_pdtv_rec := p_pdtv_rec;
344: l_return_status := OKL_API.START_ACTIVITY(p_api_name => l_api_name,
345: p_pkg_name => G_PKG_NAME,
346: p_init_msg_list => p_init_msg_list,
347: l_api_version => l_api_version,
348: p_api_version => p_api_version,

Line 377: OKL_API.END_ACTIVITY(x_msg_count => x_msg_count,

373: RAISE G_EXCEPTION_ERROR;
374: END IF;
375:
376:
377: OKL_API.END_ACTIVITY(x_msg_count => x_msg_count,
378: x_msg_data => x_msg_data);
379: x_return_status := l_return_status;
380: EXCEPTION
381: WHEN G_EXCEPTION_ERROR THEN

Line 382: x_return_status := OKL_API.HANDLE_EXCEPTIONS(p_api_name => l_api_name,

378: x_msg_data => x_msg_data);
379: x_return_status := l_return_status;
380: EXCEPTION
381: WHEN G_EXCEPTION_ERROR THEN
382: x_return_status := OKL_API.HANDLE_EXCEPTIONS(p_api_name => l_api_name,
383: p_pkg_name => G_PKG_NAME,
384: p_exc_name => G_EXC_NAME_ERROR,
385: x_msg_count => x_msg_count,
386: x_msg_data => x_msg_data,

Line 389: x_return_status := OKL_API.HANDLE_EXCEPTIONS(p_api_name => l_api_name,

385: x_msg_count => x_msg_count,
386: x_msg_data => x_msg_data,
387: p_api_type => G_API_TYPE);
388: WHEN G_EXCEPTION_UNEXPECTED_ERROR THEN
389: x_return_status := OKL_API.HANDLE_EXCEPTIONS(p_api_name => l_api_name,
390: p_pkg_name => G_PKG_NAME,
391: p_exc_name => G_EXC_NAME_UNEXP_ERROR,
392: x_msg_count => x_msg_count,
393: x_msg_data => x_msg_data,

Line 396: x_return_status := OKL_API.HANDLE_EXCEPTIONS(p_api_name => l_api_name,

392: x_msg_count => x_msg_count,
393: x_msg_data => x_msg_data,
394: p_api_type => G_API_TYPE);
395: WHEN OTHERS THEN
396: x_return_status := OKL_API.HANDLE_EXCEPTIONS(p_api_name => l_api_name,
397: p_pkg_name => G_PKG_NAME,
398: p_exc_name => G_EXC_NAME_OTHERS,
399: x_msg_count => x_msg_count,
400: x_msg_data => x_msg_data,

Line 422: l_return_status := OKL_API.START_ACTIVITY(p_api_name => l_api_name,

418: l_api_version CONSTANT NUMBER := 1;
419: l_return_status VARCHAR2(1) := G_RET_STS_SUCCESS;
420: BEGIN
421:
422: l_return_status := OKL_API.START_ACTIVITY(p_api_name => l_api_name,
423: p_pkg_name => G_PKG_NAME,
424: p_init_msg_list => p_init_msg_list,
425: l_api_version => l_api_version,
426: p_api_version => p_api_version,

Line 455: OKL_API.END_ACTIVITY(x_msg_count => x_msg_count,

451: RAISE G_EXCEPTION_ERROR;
452: END IF;
453:
454: END LOOP;
455: OKL_API.END_ACTIVITY(x_msg_count => x_msg_count,
456: x_msg_data => x_msg_data);
457: x_return_status := l_return_status;
458: EXCEPTION
459: WHEN G_EXCEPTION_ERROR THEN

Line 460: x_return_status := OKL_API.HANDLE_EXCEPTIONS(p_api_name => l_api_name,

456: x_msg_data => x_msg_data);
457: x_return_status := l_return_status;
458: EXCEPTION
459: WHEN G_EXCEPTION_ERROR THEN
460: x_return_status := OKL_API.HANDLE_EXCEPTIONS(p_api_name => l_api_name,
461: p_pkg_name => G_PKG_NAME,
462: p_exc_name => G_EXC_NAME_ERROR,
463: x_msg_count => x_msg_count,
464: x_msg_data => x_msg_data,

Line 467: x_return_status := OKL_API.HANDLE_EXCEPTIONS(p_api_name => l_api_name,

463: x_msg_count => x_msg_count,
464: x_msg_data => x_msg_data,
465: p_api_type => G_API_TYPE);
466: WHEN G_EXCEPTION_UNEXPECTED_ERROR THEN
467: x_return_status := OKL_API.HANDLE_EXCEPTIONS(p_api_name => l_api_name,
468: p_pkg_name => G_PKG_NAME,
469: p_exc_name => G_EXC_NAME_UNEXP_ERROR,
470: x_msg_count => x_msg_count,
471: x_msg_data => x_msg_data,

Line 474: x_return_status := OKL_API.HANDLE_EXCEPTIONS(p_api_name => l_api_name,

470: x_msg_count => x_msg_count,
471: x_msg_data => x_msg_data,
472: p_api_type => G_API_TYPE);
473: WHEN OTHERS THEN
474: x_return_status := OKL_API.HANDLE_EXCEPTIONS(p_api_name => l_api_name,
475: p_pkg_name => G_PKG_NAME,
476: p_exc_name => G_EXC_NAME_OTHERS,
477: x_msg_count => x_msg_count,
478: x_msg_data => x_msg_data,