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,
29: p_init_msg_list => G_FALSE,
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);
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);
60: END IF;
61:
62: x_return_status := G_RET_STS_UNEXP_ERROR;
63:
73: p_token3_value => sqlerrm);
74:
75: IF p_transaction_control = G_TRUE THEN
76: ROLLBACK TO l_program_name;
77: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
78: END IF;
79:
80: x_return_status := G_RET_STS_UNEXP_ERROR;
81:
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,
110: p_init_msg_list => G_FALSE,
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);
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);
141: END IF;
142:
143: x_return_status := G_RET_STS_UNEXP_ERROR;
144:
154: p_token3_value => sqlerrm);
155:
156: IF p_transaction_control = G_TRUE THEN
157: ROLLBACK TO l_program_name;
158: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
159: END IF;
160:
161: x_return_status := G_RET_STS_UNEXP_ERROR;
162:
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,
190: p_init_msg_list => G_FALSE,
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);
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);
220: END IF;
221:
222: x_return_status := G_RET_STS_UNEXP_ERROR;
223:
233: p_token3_value => sqlerrm);
234:
235: IF p_transaction_control = G_TRUE THEN
236: ROLLBACK TO l_program_name;
237: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
238: END IF;
239:
240: x_return_status := G_RET_STS_UNEXP_ERROR;
241:
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,
269: p_init_msg_list => G_FALSE,
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);
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);
299: END IF;
300:
301: x_return_status := G_RET_STS_UNEXP_ERROR;
302:
312: p_token3_value => sqlerrm);
313:
314: IF p_transaction_control = G_TRUE THEN
315: ROLLBACK TO l_program_name;
316: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
317: END IF;
318:
319: x_return_status := G_RET_STS_UNEXP_ERROR;
320:
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,
349: p_init_msg_list => G_FALSE,
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);
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);
380: END IF;
381:
382: x_return_status := G_RET_STS_UNEXP_ERROR;
383:
393: p_token3_value => sqlerrm);
394:
395: IF p_transaction_control = G_TRUE THEN
396: ROLLBACK TO l_program_name;
397: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
398: END IF;
399:
400: x_return_status := G_RET_STS_UNEXP_ERROR;
401:
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,
430: p_init_msg_list => G_FALSE,
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);
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);
461: END IF;
462:
463: x_return_status := G_RET_STS_UNEXP_ERROR;
464:
474: p_token3_value => sqlerrm);
475:
476: IF p_transaction_control = G_TRUE THEN
477: ROLLBACK TO l_program_name;
478: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
479: END IF;
480:
481: x_return_status := G_RET_STS_UNEXP_ERROR;
482:
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,
510: p_init_msg_list => G_FALSE,
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);
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);
540: END IF;
541:
542: x_return_status := G_RET_STS_UNEXP_ERROR;
543:
553: p_token3_value => sqlerrm);
554:
555: IF p_transaction_control = G_TRUE THEN
556: ROLLBACK TO l_program_name;
557: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
558: END IF;
559:
560: x_return_status := G_RET_STS_UNEXP_ERROR;
561:
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,
589: p_init_msg_list => G_FALSE,
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);
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);
619: END IF;
620:
621: x_return_status := G_RET_STS_UNEXP_ERROR;
622:
632: p_token3_value => sqlerrm);
633:
634: IF p_transaction_control = G_TRUE THEN
635: ROLLBACK TO l_program_name;
636: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
637: END IF;
638:
639: x_return_status := G_RET_STS_UNEXP_ERROR;
640:
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,
668: p_init_msg_list => G_FALSE,
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);
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);
698: END IF;
699:
700: x_return_status := G_RET_STS_UNEXP_ERROR;
701:
711: p_token3_value => sqlerrm);
712:
713: IF p_transaction_control = G_TRUE THEN
714: ROLLBACK TO l_program_name;
715: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
716: END IF;
717:
718: x_return_status := G_RET_STS_UNEXP_ERROR;
719:
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,
747: p_init_msg_list => G_FALSE,
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);
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);
777: END IF;
778:
779: x_return_status := G_RET_STS_UNEXP_ERROR;
780:
790: p_token3_value => sqlerrm);
791:
792: IF p_transaction_control = G_TRUE THEN
793: ROLLBACK TO l_program_name;
794: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
795: END IF;
796:
797: x_return_status := G_RET_STS_UNEXP_ERROR;
798: