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

Line 6: ,p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE

2: /* $Header: OKLPICPB.pls 120.4 2005/10/30 03:31:59 appldev noship $ */
3:
4: PROCEDURE insert_itm_cat_rv_prcs(
5: p_api_version IN NUMBER
6: ,p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE
7: ,x_return_status OUT NOCOPY VARCHAR2
8: ,x_msg_count OUT NOCOPY NUMBER
9: ,x_msg_data OUT NOCOPY VARCHAR2
10: ,p_icpv_rec IN icpv_rec_type

Line 24: IF p_init_msg_list = OKL_API.G_TRUE THEN

20: IF p_transaction_control = G_TRUE THEN
21: SAVEPOINT l_program_name;
22: END IF;
23:
24: IF p_init_msg_list = OKL_API.G_TRUE THEN
25: FND_MSG_PUB.initialize;
26: END IF;
27:
28: okl_icp_pvt.insert_row(p_api_version => G_API_VERSION,

Line 37: RAISE OKL_API.G_EXCEPTION_ERROR;

33: p_icpv_rec => p_icpv_rec,
34: x_icpv_rec => x_icpv_rec);
35:
36: IF lx_return_status = G_RET_STS_ERROR THEN
37: RAISE OKL_API.G_EXCEPTION_ERROR;
38: ELSIF lx_return_status = G_RET_STS_UNEXP_ERROR THEN
39: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
40: END IF;
41:

Line 39: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

35:
36: IF lx_return_status = G_RET_STS_ERROR THEN
37: RAISE OKL_API.G_EXCEPTION_ERROR;
38: ELSIF lx_return_status = G_RET_STS_UNEXP_ERROR THEN
39: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
40: END IF;
41:
42: x_return_status := lx_return_status;
43:

Line 46: WHEN OKL_API.G_EXCEPTION_ERROR THEN

42: x_return_status := lx_return_status;
43:
44: EXCEPTION
45:
46: WHEN OKL_API.G_EXCEPTION_ERROR THEN
47:
48: IF p_transaction_control = G_TRUE THEN
49: ROLLBACK TO l_program_name;
50: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);

Line 55: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

51: END IF;
52:
53: x_return_status := G_RET_STS_ERROR;
54:
55: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
56:
57: IF p_transaction_control = G_TRUE THEN
58: ROLLBACK TO l_program_name;
59: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);

Line 66: OKL_API.SET_MESSAGE (p_app_name => G_APP_NAME,

62: x_return_status := G_RET_STS_UNEXP_ERROR;
63:
64: WHEN OTHERS THEN
65:
66: OKL_API.SET_MESSAGE (p_app_name => G_APP_NAME,
67: p_msg_name => 'OKL_DB_ERROR',
68: p_token1 => 'PROG_NAME',
69: p_token1_value => l_api_name,
70: p_token2 => 'SQLCODE',

Line 87: ,p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE

83:
84:
85: PROCEDURE insert_itm_cat_rv_prcs(
86: p_api_version IN NUMBER
87: ,p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE
88: ,x_return_status OUT NOCOPY VARCHAR2
89: ,x_msg_count OUT NOCOPY NUMBER
90: ,x_msg_data OUT NOCOPY VARCHAR2
91: ,p_icpv_tbl IN icpv_tbl_type

Line 105: IF p_init_msg_list = OKL_API.G_TRUE THEN

101: IF p_transaction_control = G_TRUE THEN
102: SAVEPOINT l_program_name;
103: END IF;
104:
105: IF p_init_msg_list = OKL_API.G_TRUE THEN
106: FND_MSG_PUB.initialize;
107: END IF;
108:
109: okl_icp_pvt.insert_row(p_api_version => G_API_VERSION,

Line 118: RAISE OKL_API.G_EXCEPTION_ERROR;

114: p_icpv_tbl => p_icpv_tbl,
115: x_icpv_tbl => x_icpv_tbl);
116:
117: IF lx_return_status = G_RET_STS_ERROR THEN
118: RAISE OKL_API.G_EXCEPTION_ERROR;
119: ELSIF lx_return_status = G_RET_STS_UNEXP_ERROR THEN
120: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
121: END IF;
122:

Line 120: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

116:
117: IF lx_return_status = G_RET_STS_ERROR THEN
118: RAISE OKL_API.G_EXCEPTION_ERROR;
119: ELSIF lx_return_status = G_RET_STS_UNEXP_ERROR THEN
120: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
121: END IF;
122:
123: x_return_status := lx_return_status;
124:

Line 127: WHEN OKL_API.G_EXCEPTION_ERROR THEN

123: x_return_status := lx_return_status;
124:
125: EXCEPTION
126:
127: WHEN OKL_API.G_EXCEPTION_ERROR THEN
128:
129: IF p_transaction_control = G_TRUE THEN
130: ROLLBACK TO l_program_name;
131: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);

Line 136: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

132: END IF;
133:
134: x_return_status := G_RET_STS_ERROR;
135:
136: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
137:
138: IF p_transaction_control = G_TRUE THEN
139: ROLLBACK TO l_program_name;
140: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);

Line 147: OKL_API.SET_MESSAGE (p_app_name => G_APP_NAME,

143: x_return_status := G_RET_STS_UNEXP_ERROR;
144:
145: WHEN OTHERS THEN
146:
147: OKL_API.SET_MESSAGE (p_app_name => G_APP_NAME,
148: p_msg_name => 'OKL_DB_ERROR',
149: p_token1 => 'PROG_NAME',
150: p_token1_value => l_api_name,
151: p_token2 => 'SQLCODE',

Line 168: ,p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE

164:
165:
166: PROCEDURE lock_itm_cat_rv_prcs(
167: p_api_version IN NUMBER
168: ,p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE
169: ,x_return_status OUT NOCOPY VARCHAR2
170: ,x_msg_count OUT NOCOPY NUMBER
171: ,x_msg_data OUT NOCOPY VARCHAR2
172: ,p_icpv_rec IN icpv_rec_type) IS

Line 185: IF p_init_msg_list = OKL_API.G_TRUE THEN

181: IF p_transaction_control = G_TRUE THEN
182: SAVEPOINT l_program_name;
183: END IF;
184:
185: IF p_init_msg_list = OKL_API.G_TRUE THEN
186: FND_MSG_PUB.initialize;
187: END IF;
188:
189: okl_icp_pvt.lock_row(p_api_version => G_API_VERSION,

Line 197: RAISE OKL_API.G_EXCEPTION_ERROR;

193: x_msg_data => x_msg_data,
194: p_icpv_rec => p_icpv_rec);
195:
196: IF lx_return_status = G_RET_STS_ERROR THEN
197: RAISE OKL_API.G_EXCEPTION_ERROR;
198: ELSIF lx_return_status = G_RET_STS_UNEXP_ERROR THEN
199: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
200: END IF;
201:

Line 199: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

195:
196: IF lx_return_status = G_RET_STS_ERROR THEN
197: RAISE OKL_API.G_EXCEPTION_ERROR;
198: ELSIF lx_return_status = G_RET_STS_UNEXP_ERROR THEN
199: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
200: END IF;
201:
202: x_return_status := lx_return_status;
203:

Line 206: WHEN OKL_API.G_EXCEPTION_ERROR THEN

202: x_return_status := lx_return_status;
203:
204: EXCEPTION
205:
206: WHEN OKL_API.G_EXCEPTION_ERROR THEN
207:
208: IF p_transaction_control = G_TRUE THEN
209: ROLLBACK TO l_program_name;
210: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);

Line 215: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

211: END IF;
212:
213: x_return_status := G_RET_STS_ERROR;
214:
215: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
216:
217: IF p_transaction_control = G_TRUE THEN
218: ROLLBACK TO l_program_name;
219: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);

Line 226: OKL_API.SET_MESSAGE (p_app_name => G_APP_NAME,

222: x_return_status := G_RET_STS_UNEXP_ERROR;
223:
224: WHEN OTHERS THEN
225:
226: OKL_API.SET_MESSAGE (p_app_name => G_APP_NAME,
227: p_msg_name => 'OKL_DB_ERROR',
228: p_token1 => 'PROG_NAME',
229: p_token1_value => l_api_name,
230: p_token2 => 'SQLCODE',

Line 247: ,p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE

243:
244:
245: PROCEDURE lock_itm_cat_rv_prcs(
246: p_api_version IN NUMBER
247: ,p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE
248: ,x_return_status OUT NOCOPY VARCHAR2
249: ,x_msg_count OUT NOCOPY NUMBER
250: ,x_msg_data OUT NOCOPY VARCHAR2
251: ,p_icpv_tbl IN icpv_tbl_type) IS

Line 264: IF p_init_msg_list = OKL_API.G_TRUE THEN

260: IF p_transaction_control = G_TRUE THEN
261: SAVEPOINT l_program_name;
262: END IF;
263:
264: IF p_init_msg_list = OKL_API.G_TRUE THEN
265: FND_MSG_PUB.initialize;
266: END IF;
267:
268: okl_icp_pvt.lock_row(p_api_version => G_API_VERSION,

Line 276: RAISE OKL_API.G_EXCEPTION_ERROR;

272: x_msg_data => x_msg_data,
273: p_icpv_tbl => p_icpv_tbl);
274:
275: IF lx_return_status = G_RET_STS_ERROR THEN
276: RAISE OKL_API.G_EXCEPTION_ERROR;
277: ELSIF lx_return_status = G_RET_STS_UNEXP_ERROR THEN
278: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
279: END IF;
280:

Line 278: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

274:
275: IF lx_return_status = G_RET_STS_ERROR THEN
276: RAISE OKL_API.G_EXCEPTION_ERROR;
277: ELSIF lx_return_status = G_RET_STS_UNEXP_ERROR THEN
278: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
279: END IF;
280:
281: x_return_status := lx_return_status;
282:

Line 285: WHEN OKL_API.G_EXCEPTION_ERROR THEN

281: x_return_status := lx_return_status;
282:
283: EXCEPTION
284:
285: WHEN OKL_API.G_EXCEPTION_ERROR THEN
286:
287: IF p_transaction_control = G_TRUE THEN
288: ROLLBACK TO l_program_name;
289: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);

Line 294: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

290: END IF;
291:
292: x_return_status := G_RET_STS_ERROR;
293:
294: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
295:
296: IF p_transaction_control = G_TRUE THEN
297: ROLLBACK TO l_program_name;
298: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);

Line 305: OKL_API.SET_MESSAGE (p_app_name => G_APP_NAME,

301: x_return_status := G_RET_STS_UNEXP_ERROR;
302:
303: WHEN OTHERS THEN
304:
305: OKL_API.SET_MESSAGE (p_app_name => G_APP_NAME,
306: p_msg_name => 'OKL_DB_ERROR',
307: p_token1 => 'PROG_NAME',
308: p_token1_value => l_api_name,
309: p_token2 => 'SQLCODE',

Line 326: ,p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE

322:
323:
324: PROCEDURE update_itm_cat_rv_prcs(
325: p_api_version IN NUMBER
326: ,p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE
327: ,x_return_status OUT NOCOPY VARCHAR2
328: ,x_msg_count OUT NOCOPY NUMBER
329: ,x_msg_data OUT NOCOPY VARCHAR2
330: ,p_icpv_rec IN icpv_rec_type

Line 344: IF p_init_msg_list = OKL_API.G_TRUE THEN

340: IF p_transaction_control = G_TRUE THEN
341: SAVEPOINT l_program_name;
342: END IF;
343:
344: IF p_init_msg_list = OKL_API.G_TRUE THEN
345: FND_MSG_PUB.initialize;
346: END IF;
347:
348: okl_icp_pvt.update_row(p_api_version => G_API_VERSION,

Line 357: RAISE OKL_API.G_EXCEPTION_ERROR;

353: p_icpv_rec => p_icpv_rec,
354: x_icpv_rec => x_icpv_rec);
355:
356: IF lx_return_status = G_RET_STS_ERROR THEN
357: RAISE OKL_API.G_EXCEPTION_ERROR;
358: ELSIF lx_return_status = G_RET_STS_UNEXP_ERROR THEN
359: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
360: END IF;
361:

Line 359: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

355:
356: IF lx_return_status = G_RET_STS_ERROR THEN
357: RAISE OKL_API.G_EXCEPTION_ERROR;
358: ELSIF lx_return_status = G_RET_STS_UNEXP_ERROR THEN
359: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
360: END IF;
361:
362: x_return_status := lx_return_status;
363:

Line 366: WHEN OKL_API.G_EXCEPTION_ERROR THEN

362: x_return_status := lx_return_status;
363:
364: EXCEPTION
365:
366: WHEN OKL_API.G_EXCEPTION_ERROR THEN
367:
368: IF p_transaction_control = G_TRUE THEN
369: ROLLBACK TO l_program_name;
370: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);

Line 375: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

371: END IF;
372:
373: x_return_status := G_RET_STS_ERROR;
374:
375: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
376:
377: IF p_transaction_control = G_TRUE THEN
378: ROLLBACK TO l_program_name;
379: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);

Line 386: OKL_API.SET_MESSAGE (p_app_name => G_APP_NAME,

382: x_return_status := G_RET_STS_UNEXP_ERROR;
383:
384: WHEN OTHERS THEN
385:
386: OKL_API.SET_MESSAGE (p_app_name => G_APP_NAME,
387: p_msg_name => 'OKL_DB_ERROR',
388: p_token1 => 'PROG_NAME',
389: p_token1_value => l_api_name,
390: p_token2 => 'SQLCODE',

Line 407: ,p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE

403:
404:
405: PROCEDURE update_itm_cat_rv_prcs(
406: p_api_version IN NUMBER
407: ,p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE
408: ,x_return_status OUT NOCOPY VARCHAR2
409: ,x_msg_count OUT NOCOPY NUMBER
410: ,x_msg_data OUT NOCOPY VARCHAR2
411: ,p_icpv_tbl IN icpv_tbl_type

Line 425: IF p_init_msg_list = OKL_API.G_TRUE THEN

421: IF p_transaction_control = G_TRUE THEN
422: SAVEPOINT l_program_name;
423: END IF;
424:
425: IF p_init_msg_list = OKL_API.G_TRUE THEN
426: FND_MSG_PUB.initialize;
427: END IF;
428:
429: okl_icp_pvt.update_row(p_api_version => G_API_VERSION,

Line 438: RAISE OKL_API.G_EXCEPTION_ERROR;

434: p_icpv_tbl => p_icpv_tbl,
435: x_icpv_tbl => x_icpv_tbl);
436:
437: IF lx_return_status = G_RET_STS_ERROR THEN
438: RAISE OKL_API.G_EXCEPTION_ERROR;
439: ELSIF lx_return_status = G_RET_STS_UNEXP_ERROR THEN
440: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
441: END IF;
442:

Line 440: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

436:
437: IF lx_return_status = G_RET_STS_ERROR THEN
438: RAISE OKL_API.G_EXCEPTION_ERROR;
439: ELSIF lx_return_status = G_RET_STS_UNEXP_ERROR THEN
440: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
441: END IF;
442:
443: x_return_status := lx_return_status;
444:

Line 447: WHEN OKL_API.G_EXCEPTION_ERROR THEN

443: x_return_status := lx_return_status;
444:
445: EXCEPTION
446:
447: WHEN OKL_API.G_EXCEPTION_ERROR THEN
448:
449: IF p_transaction_control = G_TRUE THEN
450: ROLLBACK TO l_program_name;
451: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);

Line 456: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

452: END IF;
453:
454: x_return_status := G_RET_STS_ERROR;
455:
456: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
457:
458: IF p_transaction_control = G_TRUE THEN
459: ROLLBACK TO l_program_name;
460: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);

Line 467: OKL_API.SET_MESSAGE (p_app_name => G_APP_NAME,

463: x_return_status := G_RET_STS_UNEXP_ERROR;
464:
465: WHEN OTHERS THEN
466:
467: OKL_API.SET_MESSAGE (p_app_name => G_APP_NAME,
468: p_msg_name => 'OKL_DB_ERROR',
469: p_token1 => 'PROG_NAME',
470: p_token1_value => l_api_name,
471: p_token2 => 'SQLCODE',

Line 488: ,p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE

484:
485:
486: PROCEDURE delete_itm_cat_rv_prcs(
487: p_api_version IN NUMBER
488: ,p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE
489: ,x_return_status OUT NOCOPY VARCHAR2
490: ,x_msg_count OUT NOCOPY NUMBER
491: ,x_msg_data OUT NOCOPY VARCHAR2
492: ,p_icpv_rec IN icpv_rec_type) IS

Line 505: IF p_init_msg_list = OKL_API.G_TRUE THEN

501: IF p_transaction_control = G_TRUE THEN
502: SAVEPOINT l_program_name;
503: END IF;
504:
505: IF p_init_msg_list = OKL_API.G_TRUE THEN
506: FND_MSG_PUB.initialize;
507: END IF;
508:
509: okl_icp_pvt.delete_row(p_api_version => G_API_VERSION,

Line 517: RAISE OKL_API.G_EXCEPTION_ERROR;

513: x_msg_data => x_msg_data,
514: p_icpv_rec => p_icpv_rec);
515:
516: IF lx_return_status = G_RET_STS_ERROR THEN
517: RAISE OKL_API.G_EXCEPTION_ERROR;
518: ELSIF lx_return_status = G_RET_STS_UNEXP_ERROR THEN
519: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
520: END IF;
521:

Line 519: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

515:
516: IF lx_return_status = G_RET_STS_ERROR THEN
517: RAISE OKL_API.G_EXCEPTION_ERROR;
518: ELSIF lx_return_status = G_RET_STS_UNEXP_ERROR THEN
519: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
520: END IF;
521:
522: x_return_status := lx_return_status;
523:

Line 526: WHEN OKL_API.G_EXCEPTION_ERROR THEN

522: x_return_status := lx_return_status;
523:
524: EXCEPTION
525:
526: WHEN OKL_API.G_EXCEPTION_ERROR THEN
527:
528: IF p_transaction_control = G_TRUE THEN
529: ROLLBACK TO l_program_name;
530: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);

Line 535: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

531: END IF;
532:
533: x_return_status := G_RET_STS_ERROR;
534:
535: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
536:
537: IF p_transaction_control = G_TRUE THEN
538: ROLLBACK TO l_program_name;
539: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);

Line 546: OKL_API.SET_MESSAGE (p_app_name => G_APP_NAME,

542: x_return_status := G_RET_STS_UNEXP_ERROR;
543:
544: WHEN OTHERS THEN
545:
546: OKL_API.SET_MESSAGE (p_app_name => G_APP_NAME,
547: p_msg_name => 'OKL_DB_ERROR',
548: p_token1 => 'PROG_NAME',
549: p_token1_value => l_api_name,
550: p_token2 => 'SQLCODE',

Line 567: ,p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE

563:
564:
565: PROCEDURE delete_itm_cat_rv_prcs(
566: p_api_version IN NUMBER
567: ,p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE
568: ,x_return_status OUT NOCOPY VARCHAR2
569: ,x_msg_count OUT NOCOPY NUMBER
570: ,x_msg_data OUT NOCOPY VARCHAR2
571: ,p_icpv_tbl IN icpv_tbl_type) IS

Line 584: IF p_init_msg_list = OKL_API.G_TRUE THEN

580: IF p_transaction_control = G_TRUE THEN
581: SAVEPOINT l_program_name;
582: END IF;
583:
584: IF p_init_msg_list = OKL_API.G_TRUE THEN
585: FND_MSG_PUB.initialize;
586: END IF;
587:
588: okl_icp_pvt.delete_row(p_api_version => G_API_VERSION,

Line 596: RAISE OKL_API.G_EXCEPTION_ERROR;

592: x_msg_data => x_msg_data,
593: p_icpv_tbl => p_icpv_tbl);
594:
595: IF lx_return_status = G_RET_STS_ERROR THEN
596: RAISE OKL_API.G_EXCEPTION_ERROR;
597: ELSIF lx_return_status = G_RET_STS_UNEXP_ERROR THEN
598: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
599: END IF;
600:

Line 598: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

594:
595: IF lx_return_status = G_RET_STS_ERROR THEN
596: RAISE OKL_API.G_EXCEPTION_ERROR;
597: ELSIF lx_return_status = G_RET_STS_UNEXP_ERROR THEN
598: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
599: END IF;
600:
601: x_return_status := lx_return_status;
602:

Line 605: WHEN OKL_API.G_EXCEPTION_ERROR THEN

601: x_return_status := lx_return_status;
602:
603: EXCEPTION
604:
605: WHEN OKL_API.G_EXCEPTION_ERROR THEN
606:
607: IF p_transaction_control = G_TRUE THEN
608: ROLLBACK TO l_program_name;
609: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);

Line 614: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

610: END IF;
611:
612: x_return_status := G_RET_STS_ERROR;
613:
614: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
615:
616: IF p_transaction_control = G_TRUE THEN
617: ROLLBACK TO l_program_name;
618: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);

Line 625: OKL_API.SET_MESSAGE (p_app_name => G_APP_NAME,

621: x_return_status := G_RET_STS_UNEXP_ERROR;
622:
623: WHEN OTHERS THEN
624:
625: OKL_API.SET_MESSAGE (p_app_name => G_APP_NAME,
626: p_msg_name => 'OKL_DB_ERROR',
627: p_token1 => 'PROG_NAME',
628: p_token1_value => l_api_name,
629: p_token2 => 'SQLCODE',

Line 646: ,p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE

642:
643:
644: PROCEDURE validate_itm_cat_rv_prcs(
645: p_api_version IN NUMBER
646: ,p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE
647: ,x_return_status OUT NOCOPY VARCHAR2
648: ,x_msg_count OUT NOCOPY NUMBER
649: ,x_msg_data OUT NOCOPY VARCHAR2
650: ,p_icpv_rec IN icpv_rec_type) IS

Line 663: IF p_init_msg_list = OKL_API.G_TRUE THEN

659: IF p_transaction_control = G_TRUE THEN
660: SAVEPOINT l_program_name;
661: END IF;
662:
663: IF p_init_msg_list = OKL_API.G_TRUE THEN
664: FND_MSG_PUB.initialize;
665: END IF;
666:
667: okl_icp_pvt.validate_row(p_api_version => G_API_VERSION,

Line 675: RAISE OKL_API.G_EXCEPTION_ERROR;

671: x_msg_data => x_msg_data,
672: p_icpv_rec => p_icpv_rec);
673:
674: IF lx_return_status = G_RET_STS_ERROR THEN
675: RAISE OKL_API.G_EXCEPTION_ERROR;
676: ELSIF lx_return_status = G_RET_STS_UNEXP_ERROR THEN
677: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
678: END IF;
679:

Line 677: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

673:
674: IF lx_return_status = G_RET_STS_ERROR THEN
675: RAISE OKL_API.G_EXCEPTION_ERROR;
676: ELSIF lx_return_status = G_RET_STS_UNEXP_ERROR THEN
677: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
678: END IF;
679:
680: x_return_status := lx_return_status;
681:

Line 684: WHEN OKL_API.G_EXCEPTION_ERROR THEN

680: x_return_status := lx_return_status;
681:
682: EXCEPTION
683:
684: WHEN OKL_API.G_EXCEPTION_ERROR THEN
685:
686: IF p_transaction_control = G_TRUE THEN
687: ROLLBACK TO l_program_name;
688: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);

Line 693: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

689: END IF;
690:
691: x_return_status := G_RET_STS_ERROR;
692:
693: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
694:
695: IF p_transaction_control = G_TRUE THEN
696: ROLLBACK TO l_program_name;
697: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);

Line 704: OKL_API.SET_MESSAGE (p_app_name => G_APP_NAME,

700: x_return_status := G_RET_STS_UNEXP_ERROR;
701:
702: WHEN OTHERS THEN
703:
704: OKL_API.SET_MESSAGE (p_app_name => G_APP_NAME,
705: p_msg_name => 'OKL_DB_ERROR',
706: p_token1 => 'PROG_NAME',
707: p_token1_value => l_api_name,
708: p_token2 => 'SQLCODE',

Line 725: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,

721:
722:
723: PROCEDURE validate_itm_cat_rv_prcs(
724: p_api_version IN NUMBER,
725: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
726: x_return_status OUT NOCOPY VARCHAR2,
727: x_msg_count OUT NOCOPY NUMBER,
728: x_msg_data OUT NOCOPY VARCHAR2,
729: p_icpv_tbl IN icpv_tbl_type) IS

Line 742: IF p_init_msg_list = OKL_API.G_TRUE THEN

738: IF p_transaction_control = G_TRUE THEN
739: SAVEPOINT l_program_name;
740: END IF;
741:
742: IF p_init_msg_list = OKL_API.G_TRUE THEN
743: FND_MSG_PUB.initialize;
744: END IF;
745:
746: okl_icp_pvt.validate_row(p_api_version => G_API_VERSION,

Line 754: RAISE OKL_API.G_EXCEPTION_ERROR;

750: x_msg_data => x_msg_data,
751: p_icpv_tbl => p_icpv_tbl);
752:
753: IF lx_return_status = G_RET_STS_ERROR THEN
754: RAISE OKL_API.G_EXCEPTION_ERROR;
755: ELSIF lx_return_status = G_RET_STS_UNEXP_ERROR THEN
756: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
757: END IF;
758:

Line 756: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

752:
753: IF lx_return_status = G_RET_STS_ERROR THEN
754: RAISE OKL_API.G_EXCEPTION_ERROR;
755: ELSIF lx_return_status = G_RET_STS_UNEXP_ERROR THEN
756: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
757: END IF;
758:
759: x_return_status := lx_return_status;
760:

Line 763: WHEN OKL_API.G_EXCEPTION_ERROR THEN

759: x_return_status := lx_return_status;
760:
761: EXCEPTION
762:
763: WHEN OKL_API.G_EXCEPTION_ERROR THEN
764:
765: IF p_transaction_control = G_TRUE THEN
766: ROLLBACK TO l_program_name;
767: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);

Line 772: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

768: END IF;
769:
770: x_return_status := G_RET_STS_ERROR;
771:
772: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
773:
774: IF p_transaction_control = G_TRUE THEN
775: ROLLBACK TO l_program_name;
776: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);

Line 783: OKL_API.SET_MESSAGE (p_app_name => G_APP_NAME,

779: x_return_status := G_RET_STS_UNEXP_ERROR;
780:
781: WHEN OTHERS THEN
782:
783: OKL_API.SET_MESSAGE (p_app_name => G_APP_NAME,
784: p_msg_name => 'OKL_DB_ERROR',
785: p_token1 => 'PROG_NAME',
786: p_token1_value => l_api_name,
787: p_token2 => 'SQLCODE',