72: EXCEPTION
73: WHEN FND_API.G_EXC_ERROR THEN
74: ROLLBACK TO create_tmpt_set2;
75: x_return_status := FND_API.G_RET_STS_ERROR;
76: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
77: ,p_count => x_msg_count
78: ,p_data => x_msg_data);
79: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
80: ROLLBACK TO create_tmpt_set2;
78: ,p_data => x_msg_data);
79: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
80: ROLLBACK TO create_tmpt_set2;
81: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
82: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
83: ,p_count => x_msg_count
84: ,p_data => x_msg_data);
85: WHEN OTHERS THEN
86: ROLLBACK TO create_tmpt_set2;
83: ,p_count => x_msg_count
84: ,p_data => x_msg_data);
85: WHEN OTHERS THEN
86: ROLLBACK TO create_tmpt_set2;
87: FND_MSG_PUB.ADD_EXC_MSG('OKL_PROCESS_TMPT_SET_PUB','create_tmpt_set');
88: -- store SQL error message on message stack for caller
89: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
90: ,p_count => x_msg_count
91: ,p_data => x_msg_data);
85: WHEN OTHERS THEN
86: ROLLBACK TO create_tmpt_set2;
87: FND_MSG_PUB.ADD_EXC_MSG('OKL_PROCESS_TMPT_SET_PUB','create_tmpt_set');
88: -- store SQL error message on message stack for caller
89: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
90: ,p_count => x_msg_count
91: ,p_data => x_msg_data);
92: -- notify caller of an UNEXPECTED error
93: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
149: EXCEPTION
150: WHEN FND_API.G_EXC_ERROR THEN
151: ROLLBACK TO create_tmpt_set2;
152: x_return_status := FND_API.G_RET_STS_ERROR;
153: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
154: ,p_count => x_msg_count
155: ,p_data => x_msg_data);
156: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
157: ROLLBACK TO create_tmpt_set2;
155: ,p_data => x_msg_data);
156: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
157: ROLLBACK TO create_tmpt_set2;
158: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
159: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
160: ,p_count => x_msg_count
161: ,p_data => x_msg_data);
162: WHEN OTHERS THEN
163: ROLLBACK TO create_tmpt_set2;
160: ,p_count => x_msg_count
161: ,p_data => x_msg_data);
162: WHEN OTHERS THEN
163: ROLLBACK TO create_tmpt_set2;
164: FND_MSG_PUB.ADD_EXC_MSG('OKL_PROCESS_TMPT_SET_PUB','create_tmpt_set');
165: -- store SQL error message on message stack for caller
166: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
167: ,p_count => x_msg_count
168: ,p_data => x_msg_data);
162: WHEN OTHERS THEN
163: ROLLBACK TO create_tmpt_set2;
164: FND_MSG_PUB.ADD_EXC_MSG('OKL_PROCESS_TMPT_SET_PUB','create_tmpt_set');
165: -- store SQL error message on message stack for caller
166: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
167: ,p_count => x_msg_count
168: ,p_data => x_msg_data);
169: -- notify caller of an UNEXPECTED error
170: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
223: EXCEPTION
224: WHEN FND_API.G_EXC_ERROR THEN
225: ROLLBACK TO create_tmpt_set2;
226: x_return_status := FND_API.G_RET_STS_ERROR;
227: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
228: ,p_count => x_msg_count
229: ,p_data => x_msg_data);
230: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
231: ROLLBACK TO create_tmpt_set2;
229: ,p_data => x_msg_data);
230: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
231: ROLLBACK TO create_tmpt_set2;
232: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
233: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
234: ,p_count => x_msg_count
235: ,p_data => x_msg_data);
236: WHEN OTHERS THEN
237: ROLLBACK TO create_tmpt_set2;
234: ,p_count => x_msg_count
235: ,p_data => x_msg_data);
236: WHEN OTHERS THEN
237: ROLLBACK TO create_tmpt_set2;
238: FND_MSG_PUB.ADD_EXC_MSG('OKL_PROCESS_TMPT_SET_PUB','create_tmpt_set');
239: -- store SQL error message on message stack for caller
240: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
241: ,p_count => x_msg_count
242: ,p_data => x_msg_data);
236: WHEN OTHERS THEN
237: ROLLBACK TO create_tmpt_set2;
238: FND_MSG_PUB.ADD_EXC_MSG('OKL_PROCESS_TMPT_SET_PUB','create_tmpt_set');
239: -- store SQL error message on message stack for caller
240: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
241: ,p_count => x_msg_count
242: ,p_data => x_msg_data);
243: -- notify caller of an UNEXPECTED error
244: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
310: EXCEPTION
311: WHEN FND_API.G_EXC_ERROR THEN
312: ROLLBACK TO update_tmpt_set2;
313: x_return_status := FND_API.G_RET_STS_ERROR;
314: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
315: ,p_count => x_msg_count
316: ,p_data => x_msg_data);
317: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
318: ROLLBACK TO update_tmpt_set2;
316: ,p_data => x_msg_data);
317: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
318: ROLLBACK TO update_tmpt_set2;
319: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
320: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
321: ,p_count => x_msg_count
322: ,p_data => x_msg_data);
323: WHEN OTHERS THEN
324: ROLLBACK TO update_tmpt_set2;
321: ,p_count => x_msg_count
322: ,p_data => x_msg_data);
323: WHEN OTHERS THEN
324: ROLLBACK TO update_tmpt_set2;
325: FND_MSG_PUB.ADD_EXC_MSG('OKL_PROCESS_TMPT_SET_PUB','update_tmpt_set');
326: -- store SQL error message on message stack for caller
327: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
328: ,p_count => x_msg_count
329: ,p_data => x_msg_data);
323: WHEN OTHERS THEN
324: ROLLBACK TO update_tmpt_set2;
325: FND_MSG_PUB.ADD_EXC_MSG('OKL_PROCESS_TMPT_SET_PUB','update_tmpt_set');
326: -- store SQL error message on message stack for caller
327: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
328: ,p_count => x_msg_count
329: ,p_data => x_msg_data);
330: -- notify caller of an UNEXPECTED error
331: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
384: EXCEPTION
385: WHEN FND_API.G_EXC_ERROR THEN
386: ROLLBACK TO update_tmpt_set2;
387: x_return_status := FND_API.G_RET_STS_ERROR;
388: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
389: ,p_count => x_msg_count
390: ,p_data => x_msg_data);
391: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
392: ROLLBACK TO update_tmpt_set2;
390: ,p_data => x_msg_data);
391: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
392: ROLLBACK TO update_tmpt_set2;
393: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
394: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
395: ,p_count => x_msg_count
396: ,p_data => x_msg_data);
397: WHEN OTHERS THEN
398: ROLLBACK TO update_tmpt_set2;
395: ,p_count => x_msg_count
396: ,p_data => x_msg_data);
397: WHEN OTHERS THEN
398: ROLLBACK TO update_tmpt_set2;
399: FND_MSG_PUB.ADD_EXC_MSG('OKL_PROCESS_TMPT_SET_PUB','update_tmpt_set');
400: -- store SQL error message on message stack for caller
401: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
402: ,p_count => x_msg_count
403: ,p_data => x_msg_data);
397: WHEN OTHERS THEN
398: ROLLBACK TO update_tmpt_set2;
399: FND_MSG_PUB.ADD_EXC_MSG('OKL_PROCESS_TMPT_SET_PUB','update_tmpt_set');
400: -- store SQL error message on message stack for caller
401: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
402: ,p_count => x_msg_count
403: ,p_data => x_msg_data);
404: -- notify caller of an UNEXPECTED error
405: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
458: EXCEPTION
459: WHEN FND_API.G_EXC_ERROR THEN
460: ROLLBACK TO update_tmpt_set2;
461: x_return_status := FND_API.G_RET_STS_ERROR;
462: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
463: ,p_count => x_msg_count
464: ,p_data => x_msg_data);
465: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
466: ROLLBACK TO update_tmpt_set2;
464: ,p_data => x_msg_data);
465: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
466: ROLLBACK TO update_tmpt_set2;
467: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
468: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
469: ,p_count => x_msg_count
470: ,p_data => x_msg_data);
471: WHEN OTHERS THEN
472: ROLLBACK TO update_tmpt_set2;
469: ,p_count => x_msg_count
470: ,p_data => x_msg_data);
471: WHEN OTHERS THEN
472: ROLLBACK TO update_tmpt_set2;
473: FND_MSG_PUB.ADD_EXC_MSG('OKL_PROCESS_TMPT_SET_PUB','update_tmpt_set');
474: -- store SQL error message on message stack for caller
475: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
476: ,p_count => x_msg_count
477: ,p_data => x_msg_data);
471: WHEN OTHERS THEN
472: ROLLBACK TO update_tmpt_set2;
473: FND_MSG_PUB.ADD_EXC_MSG('OKL_PROCESS_TMPT_SET_PUB','update_tmpt_set');
474: -- store SQL error message on message stack for caller
475: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
476: ,p_count => x_msg_count
477: ,p_data => x_msg_data);
478: -- notify caller of an UNEXPECTED error
479: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
531: EXCEPTION
532: WHEN FND_API.G_EXC_ERROR THEN
533: ROLLBACK TO delete_tmpt_set2;
534: x_return_status := FND_API.G_RET_STS_ERROR;
535: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
536: ,p_count => x_msg_count
537: ,p_data => x_msg_data);
538: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
539: ROLLBACK TO delete_tmpt_set2;
537: ,p_data => x_msg_data);
538: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
539: ROLLBACK TO delete_tmpt_set2;
540: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
541: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
542: ,p_count => x_msg_count
543: ,p_data => x_msg_data);
544: WHEN OTHERS THEN
545: ROLLBACK TO delete_tmpt_set2;
542: ,p_count => x_msg_count
543: ,p_data => x_msg_data);
544: WHEN OTHERS THEN
545: ROLLBACK TO delete_tmpt_set2;
546: FND_MSG_PUB.ADD_EXC_MSG('OKL_PROCESS_TMPT_SET_PUB','delete_tmpt_set');
547: -- store SQL error message on message stack for caller
548: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
549: ,p_count => x_msg_count
550: ,p_data => x_msg_data);
544: WHEN OTHERS THEN
545: ROLLBACK TO delete_tmpt_set2;
546: FND_MSG_PUB.ADD_EXC_MSG('OKL_PROCESS_TMPT_SET_PUB','delete_tmpt_set');
547: -- store SQL error message on message stack for caller
548: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
549: ,p_count => x_msg_count
550: ,p_data => x_msg_data);
551: -- notify caller of an UNEXPECTED error
552: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
601: EXCEPTION
602: WHEN FND_API.G_EXC_ERROR THEN
603: ROLLBACK TO delete_tmpt_set2;
604: x_return_status := FND_API.G_RET_STS_ERROR;
605: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
606: ,p_count => x_msg_count
607: ,p_data => x_msg_data);
608: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
609: ROLLBACK TO delete_tmpt_set2;
607: ,p_data => x_msg_data);
608: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
609: ROLLBACK TO delete_tmpt_set2;
610: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
611: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
612: ,p_count => x_msg_count
613: ,p_data => x_msg_data);
614: WHEN OTHERS THEN
615: ROLLBACK TO delete_tmpt_set2;
612: ,p_count => x_msg_count
613: ,p_data => x_msg_data);
614: WHEN OTHERS THEN
615: ROLLBACK TO delete_tmpt_set2;
616: FND_MSG_PUB.ADD_EXC_MSG('OKL_PROCESS_TMPT_SET_PUB','delete_tmpt_set');
617: -- store SQL error message on message stack for caller
618: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
619: ,p_count => x_msg_count
620: ,p_data => x_msg_data);
614: WHEN OTHERS THEN
615: ROLLBACK TO delete_tmpt_set2;
616: FND_MSG_PUB.ADD_EXC_MSG('OKL_PROCESS_TMPT_SET_PUB','delete_tmpt_set');
617: -- store SQL error message on message stack for caller
618: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
619: ,p_count => x_msg_count
620: ,p_data => x_msg_data);
621: -- notify caller of an UNEXPECTED error
622: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
672: EXCEPTION
673: WHEN FND_API.G_EXC_ERROR THEN
674: ROLLBACK TO create_template2;
675: x_return_status := FND_API.G_RET_STS_ERROR;
676: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
677: ,p_count => x_msg_count
678: ,p_data => x_msg_data);
679: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
680: ROLLBACK TO create_template2;
678: ,p_data => x_msg_data);
679: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
680: ROLLBACK TO create_template2;
681: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
682: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
683: ,p_count => x_msg_count
684: ,p_data => x_msg_data);
685: WHEN OTHERS THEN
686: ROLLBACK TO create_template2;
683: ,p_count => x_msg_count
684: ,p_data => x_msg_data);
685: WHEN OTHERS THEN
686: ROLLBACK TO create_template2;
687: FND_MSG_PUB.ADD_EXC_MSG('OKL_PROCESS_TMPT_SET_PUB','create_template');
688: -- store SQL error message on message stack for caller
689: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
690: ,p_count => x_msg_count
691: ,p_data => x_msg_data);
685: WHEN OTHERS THEN
686: ROLLBACK TO create_template2;
687: FND_MSG_PUB.ADD_EXC_MSG('OKL_PROCESS_TMPT_SET_PUB','create_template');
688: -- store SQL error message on message stack for caller
689: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
690: ,p_count => x_msg_count
691: ,p_data => x_msg_data);
692: -- notify caller of an UNEXPECTED error
693: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
743: EXCEPTION
744: WHEN FND_API.G_EXC_ERROR THEN
745: ROLLBACK TO create_template2;
746: x_return_status := FND_API.G_RET_STS_ERROR;
747: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
748: ,p_count => x_msg_count
749: ,p_data => x_msg_data);
750: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
751: ROLLBACK TO create_template2;
749: ,p_data => x_msg_data);
750: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
751: ROLLBACK TO create_template2;
752: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
753: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
754: ,p_count => x_msg_count
755: ,p_data => x_msg_data);
756: WHEN OTHERS THEN
757: ROLLBACK TO create_template2;
754: ,p_count => x_msg_count
755: ,p_data => x_msg_data);
756: WHEN OTHERS THEN
757: ROLLBACK TO create_template2;
758: FND_MSG_PUB.ADD_EXC_MSG('OKL_PROCESS_TMPT_SET_PUB','create_template');
759: -- store SQL error message on message stack for caller
760: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
761: ,p_count => x_msg_count
762: ,p_data => x_msg_data);
756: WHEN OTHERS THEN
757: ROLLBACK TO create_template2;
758: FND_MSG_PUB.ADD_EXC_MSG('OKL_PROCESS_TMPT_SET_PUB','create_template');
759: -- store SQL error message on message stack for caller
760: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
761: ,p_count => x_msg_count
762: ,p_data => x_msg_data);
763: -- notify caller of an UNEXPECTED error
764: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
817: EXCEPTION
818: WHEN FND_API.G_EXC_ERROR THEN
819: ROLLBACK TO update_template2;
820: x_return_status := FND_API.G_RET_STS_ERROR;
821: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
822: ,p_count => x_msg_count
823: ,p_data => x_msg_data);
824: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
825: ROLLBACK TO update_template2;
823: ,p_data => x_msg_data);
824: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
825: ROLLBACK TO update_template2;
826: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
827: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
828: ,p_count => x_msg_count
829: ,p_data => x_msg_data);
830: WHEN OTHERS THEN
831: ROLLBACK TO update_template2;
828: ,p_count => x_msg_count
829: ,p_data => x_msg_data);
830: WHEN OTHERS THEN
831: ROLLBACK TO update_template2;
832: FND_MSG_PUB.ADD_EXC_MSG('OKL_PROCESS_TMPT_SET_PUB','update_template');
833: -- store SQL error message on message stack for caller
834: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
835: ,p_count => x_msg_count
836: ,p_data => x_msg_data);
830: WHEN OTHERS THEN
831: ROLLBACK TO update_template2;
832: FND_MSG_PUB.ADD_EXC_MSG('OKL_PROCESS_TMPT_SET_PUB','update_template');
833: -- store SQL error message on message stack for caller
834: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
835: ,p_count => x_msg_count
836: ,p_data => x_msg_data);
837: -- notify caller of an UNEXPECTED error
838: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
890: EXCEPTION
891: WHEN FND_API.G_EXC_ERROR THEN
892: ROLLBACK TO update_template2;
893: x_return_status := FND_API.G_RET_STS_ERROR;
894: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
895: ,p_count => x_msg_count
896: ,p_data => x_msg_data);
897: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
898: ROLLBACK TO update_template2;
896: ,p_data => x_msg_data);
897: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
898: ROLLBACK TO update_template2;
899: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
900: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
901: ,p_count => x_msg_count
902: ,p_data => x_msg_data);
903: WHEN OTHERS THEN
904: ROLLBACK TO update_template2;
901: ,p_count => x_msg_count
902: ,p_data => x_msg_data);
903: WHEN OTHERS THEN
904: ROLLBACK TO update_template2;
905: FND_MSG_PUB.ADD_EXC_MSG('OKL_PROCESS_TMPT_SET_PUB','update_template');
906: -- store SQL error message on message stack for caller
907: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
908: ,p_count => x_msg_count
909: ,p_data => x_msg_data);
903: WHEN OTHERS THEN
904: ROLLBACK TO update_template2;
905: FND_MSG_PUB.ADD_EXC_MSG('OKL_PROCESS_TMPT_SET_PUB','update_template');
906: -- store SQL error message on message stack for caller
907: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
908: ,p_count => x_msg_count
909: ,p_data => x_msg_data);
910: -- notify caller of an UNEXPECTED error
911: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
962: EXCEPTION
963: WHEN FND_API.G_EXC_ERROR THEN
964: ROLLBACK TO delete_template2;
965: x_return_status := FND_API.G_RET_STS_ERROR;
966: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
967: ,p_count => x_msg_count
968: ,p_data => x_msg_data);
969: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
970: ROLLBACK TO delete_template2;
968: ,p_data => x_msg_data);
969: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
970: ROLLBACK TO delete_template2;
971: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
972: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
973: ,p_count => x_msg_count
974: ,p_data => x_msg_data);
975: WHEN OTHERS THEN
976: ROLLBACK TO delete_template2;
973: ,p_count => x_msg_count
974: ,p_data => x_msg_data);
975: WHEN OTHERS THEN
976: ROLLBACK TO delete_template2;
977: FND_MSG_PUB.ADD_EXC_MSG('OKL_PROCESS_TMPT_SET_PUB','delete_template');
978: -- store SQL error message on message stack for caller
979: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
980: ,p_count => x_msg_count
981: ,p_data => x_msg_data);
975: WHEN OTHERS THEN
976: ROLLBACK TO delete_template2;
977: FND_MSG_PUB.ADD_EXC_MSG('OKL_PROCESS_TMPT_SET_PUB','delete_template');
978: -- store SQL error message on message stack for caller
979: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
980: ,p_count => x_msg_count
981: ,p_data => x_msg_data);
982: -- notify caller of an UNEXPECTED error
983: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1031: EXCEPTION
1032: WHEN FND_API.G_EXC_ERROR THEN
1033: ROLLBACK TO delete_template2;
1034: x_return_status := FND_API.G_RET_STS_ERROR;
1035: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
1036: ,p_count => x_msg_count
1037: ,p_data => x_msg_data);
1038: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1039: ROLLBACK TO delete_template2;
1037: ,p_data => x_msg_data);
1038: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1039: ROLLBACK TO delete_template2;
1040: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1041: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
1042: ,p_count => x_msg_count
1043: ,p_data => x_msg_data);
1044: WHEN OTHERS THEN
1045: ROLLBACK TO delete_template2;
1042: ,p_count => x_msg_count
1043: ,p_data => x_msg_data);
1044: WHEN OTHERS THEN
1045: ROLLBACK TO delete_template2;
1046: FND_MSG_PUB.ADD_EXC_MSG('OKL_PROCESS_TMPT_SET_PUB','delete_template');
1047: -- store SQL error message on message stack for caller
1048: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
1049: ,p_count => x_msg_count
1050: ,p_data => x_msg_data);
1044: WHEN OTHERS THEN
1045: ROLLBACK TO delete_template2;
1046: FND_MSG_PUB.ADD_EXC_MSG('OKL_PROCESS_TMPT_SET_PUB','delete_template');
1047: -- store SQL error message on message stack for caller
1048: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
1049: ,p_count => x_msg_count
1050: ,p_data => x_msg_data);
1051: -- notify caller of an UNEXPECTED error
1052: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1105: EXCEPTION
1106: WHEN FND_API.G_EXC_ERROR THEN
1107: ROLLBACK TO create_tmpt_lines2;
1108: x_return_status := FND_API.G_RET_STS_ERROR;
1109: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
1110: ,p_count => x_msg_count
1111: ,p_data => x_msg_data);
1112: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1113: ROLLBACK TO create_tmpt_lines2;
1111: ,p_data => x_msg_data);
1112: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1113: ROLLBACK TO create_tmpt_lines2;
1114: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1115: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
1116: ,p_count => x_msg_count
1117: ,p_data => x_msg_data);
1118: WHEN OTHERS THEN
1119: ROLLBACK TO create_tmpt_lines2;
1116: ,p_count => x_msg_count
1117: ,p_data => x_msg_data);
1118: WHEN OTHERS THEN
1119: ROLLBACK TO create_tmpt_lines2;
1120: FND_MSG_PUB.ADD_EXC_MSG('OKL_PROCESS_TMPT_SET_PUB','create_tmpt_lines');
1121: -- store SQL error message on message stack for caller
1122: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
1123: ,p_count => x_msg_count
1124: ,p_data => x_msg_data);
1118: WHEN OTHERS THEN
1119: ROLLBACK TO create_tmpt_lines2;
1120: FND_MSG_PUB.ADD_EXC_MSG('OKL_PROCESS_TMPT_SET_PUB','create_tmpt_lines');
1121: -- store SQL error message on message stack for caller
1122: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
1123: ,p_count => x_msg_count
1124: ,p_data => x_msg_data);
1125: -- notify caller of an UNEXPECTED error
1126: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1177: EXCEPTION
1178: WHEN FND_API.G_EXC_ERROR THEN
1179: ROLLBACK TO create_tmpt_lines2;
1180: x_return_status := FND_API.G_RET_STS_ERROR;
1181: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
1182: ,p_count => x_msg_count
1183: ,p_data => x_msg_data);
1184: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1185: ROLLBACK TO create_tmpt_lines2;
1183: ,p_data => x_msg_data);
1184: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1185: ROLLBACK TO create_tmpt_lines2;
1186: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1187: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
1188: ,p_count => x_msg_count
1189: ,p_data => x_msg_data);
1190: WHEN OTHERS THEN
1191: ROLLBACK TO create_tmpt_lines2;
1188: ,p_count => x_msg_count
1189: ,p_data => x_msg_data);
1190: WHEN OTHERS THEN
1191: ROLLBACK TO create_tmpt_lines2;
1192: FND_MSG_PUB.ADD_EXC_MSG('OKL_PROCESS_TMPT_SET_PUB','create_tmpt_lines');
1193: -- store SQL error message on message stack for caller
1194: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
1195: ,p_count => x_msg_count
1196: ,p_data => x_msg_data);
1190: WHEN OTHERS THEN
1191: ROLLBACK TO create_tmpt_lines2;
1192: FND_MSG_PUB.ADD_EXC_MSG('OKL_PROCESS_TMPT_SET_PUB','create_tmpt_lines');
1193: -- store SQL error message on message stack for caller
1194: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
1195: ,p_count => x_msg_count
1196: ,p_data => x_msg_data);
1197: -- notify caller of an UNEXPECTED error
1198: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1251: EXCEPTION
1252: WHEN FND_API.G_EXC_ERROR THEN
1253: ROLLBACK TO update_tmpt_lines2;
1254: x_return_status := FND_API.G_RET_STS_ERROR;
1255: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
1256: ,p_count => x_msg_count
1257: ,p_data => x_msg_data);
1258: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1259: ROLLBACK TO update_tmpt_lines2;
1257: ,p_data => x_msg_data);
1258: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1259: ROLLBACK TO update_tmpt_lines2;
1260: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1261: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
1262: ,p_count => x_msg_count
1263: ,p_data => x_msg_data);
1264: WHEN OTHERS THEN
1265: ROLLBACK TO update_tmpt_lines2;
1262: ,p_count => x_msg_count
1263: ,p_data => x_msg_data);
1264: WHEN OTHERS THEN
1265: ROLLBACK TO update_tmpt_lines2;
1266: FND_MSG_PUB.ADD_EXC_MSG('OKL_PROCESS_TMPT_SET_PUB','update_tmpt_lines');
1267: -- store SQL error message on message stack for caller
1268: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
1269: ,p_count => x_msg_count
1270: ,p_data => x_msg_data);
1264: WHEN OTHERS THEN
1265: ROLLBACK TO update_tmpt_lines2;
1266: FND_MSG_PUB.ADD_EXC_MSG('OKL_PROCESS_TMPT_SET_PUB','update_tmpt_lines');
1267: -- store SQL error message on message stack for caller
1268: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
1269: ,p_count => x_msg_count
1270: ,p_data => x_msg_data);
1271: -- notify caller of an UNEXPECTED error
1272: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1324: EXCEPTION
1325: WHEN FND_API.G_EXC_ERROR THEN
1326: ROLLBACK TO update_tmpt_lines2;
1327: x_return_status := FND_API.G_RET_STS_ERROR;
1328: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
1329: ,p_count => x_msg_count
1330: ,p_data => x_msg_data);
1331: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1332: ROLLBACK TO update_tmpt_lines2;
1330: ,p_data => x_msg_data);
1331: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1332: ROLLBACK TO update_tmpt_lines2;
1333: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1334: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
1335: ,p_count => x_msg_count
1336: ,p_data => x_msg_data);
1337: WHEN OTHERS THEN
1338: ROLLBACK TO update_tmpt_lines2;
1335: ,p_count => x_msg_count
1336: ,p_data => x_msg_data);
1337: WHEN OTHERS THEN
1338: ROLLBACK TO update_tmpt_lines2;
1339: FND_MSG_PUB.ADD_EXC_MSG('OKL_PROCESS_TMPT_SET_PUB','update_tmpt_lines');
1340: -- store SQL error message on message stack for caller
1341: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
1342: ,p_count => x_msg_count
1343: ,p_data => x_msg_data);
1337: WHEN OTHERS THEN
1338: ROLLBACK TO update_tmpt_lines2;
1339: FND_MSG_PUB.ADD_EXC_MSG('OKL_PROCESS_TMPT_SET_PUB','update_tmpt_lines');
1340: -- store SQL error message on message stack for caller
1341: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
1342: ,p_count => x_msg_count
1343: ,p_data => x_msg_data);
1344: -- notify caller of an UNEXPECTED error
1345: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1396: EXCEPTION
1397: WHEN FND_API.G_EXC_ERROR THEN
1398: ROLLBACK TO delete_tmpt_lines2;
1399: x_return_status := FND_API.G_RET_STS_ERROR;
1400: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
1401: ,p_count => x_msg_count
1402: ,p_data => x_msg_data);
1403: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1404: ROLLBACK TO delete_tmpt_lines2;
1402: ,p_data => x_msg_data);
1403: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1404: ROLLBACK TO delete_tmpt_lines2;
1405: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1406: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
1407: ,p_count => x_msg_count
1408: ,p_data => x_msg_data);
1409: WHEN OTHERS THEN
1410: ROLLBACK TO delete_tmpt_lines2;
1407: ,p_count => x_msg_count
1408: ,p_data => x_msg_data);
1409: WHEN OTHERS THEN
1410: ROLLBACK TO delete_tmpt_lines2;
1411: FND_MSG_PUB.ADD_EXC_MSG('OKL_PROCESS_TMPT_SET_PUB','delete_tmpt_lines');
1412: -- store SQL error message on message stack for caller
1413: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
1414: ,p_count => x_msg_count
1415: ,p_data => x_msg_data);
1409: WHEN OTHERS THEN
1410: ROLLBACK TO delete_tmpt_lines2;
1411: FND_MSG_PUB.ADD_EXC_MSG('OKL_PROCESS_TMPT_SET_PUB','delete_tmpt_lines');
1412: -- store SQL error message on message stack for caller
1413: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
1414: ,p_count => x_msg_count
1415: ,p_data => x_msg_data);
1416: -- notify caller of an UNEXPECTED error
1417: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1465: EXCEPTION
1466: WHEN FND_API.G_EXC_ERROR THEN
1467: ROLLBACK TO delete_tmpt_lines2;
1468: x_return_status := FND_API.G_RET_STS_ERROR;
1469: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
1470: ,p_count => x_msg_count
1471: ,p_data => x_msg_data);
1472: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1473: ROLLBACK TO delete_tmpt_lines2;
1471: ,p_data => x_msg_data);
1472: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1473: ROLLBACK TO delete_tmpt_lines2;
1474: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1475: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
1476: ,p_count => x_msg_count
1477: ,p_data => x_msg_data);
1478: WHEN OTHERS THEN
1479: ROLLBACK TO delete_tmpt_lines2;
1476: ,p_count => x_msg_count
1477: ,p_data => x_msg_data);
1478: WHEN OTHERS THEN
1479: ROLLBACK TO delete_tmpt_lines2;
1480: FND_MSG_PUB.ADD_EXC_MSG('OKL_PROCESS_TMPT_SET_PUB','delete_tmpt_lines');
1481: -- store SQL error message on message stack for caller
1482: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
1483: ,p_count => x_msg_count
1484: ,p_data => x_msg_data);
1478: WHEN OTHERS THEN
1479: ROLLBACK TO delete_tmpt_lines2;
1480: FND_MSG_PUB.ADD_EXC_MSG('OKL_PROCESS_TMPT_SET_PUB','delete_tmpt_lines');
1481: -- store SQL error message on message stack for caller
1482: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
1483: ,p_count => x_msg_count
1484: ,p_data => x_msg_data);
1485: -- notify caller of an UNEXPECTED error
1486: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1540: EXCEPTION
1541: WHEN FND_API.G_EXC_ERROR THEN
1542: ROLLBACK TO COPY_TMPL_SET2;
1543: x_return_status := FND_API.G_RET_STS_ERROR;
1544: FND_MSG_PUB.Count_and_get(p_encoded => OKL_API.G_FALSE
1545: ,p_count => x_msg_count
1546: ,p_data => x_msg_data);
1547: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1548: ROLLBACK TO COPY_TMPL_SET2;
1546: ,p_data => x_msg_data);
1547: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1548: ROLLBACK TO COPY_TMPL_SET2;
1549: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1550: FND_MSG_PUB.Count_and_get(p_encoded => OKL_API.G_FALSE
1551: ,p_count => x_msg_count
1552: ,p_data => x_msg_data);
1553: WHEN OTHERS THEN
1554: ROLLBACK TO COPY_TMPL_SET2;
1551: ,p_count => x_msg_count
1552: ,p_data => x_msg_data);
1553: WHEN OTHERS THEN
1554: ROLLBACK TO COPY_TMPL_SET2;
1555: FND_MSG_PUB.ADD_EXC_MSG('OKL_COPY_TEMPLATE_PUB','COPY_TMPL_SET');
1556: FND_MSG_PUB.Count_and_get(p_encoded => OKL_API.G_FALSE
1557: ,p_count => x_msg_count
1558: ,p_data => x_msg_data);
1559: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1552: ,p_data => x_msg_data);
1553: WHEN OTHERS THEN
1554: ROLLBACK TO COPY_TMPL_SET2;
1555: FND_MSG_PUB.ADD_EXC_MSG('OKL_COPY_TEMPLATE_PUB','COPY_TMPL_SET');
1556: FND_MSG_PUB.Count_and_get(p_encoded => OKL_API.G_FALSE
1557: ,p_count => x_msg_count
1558: ,p_data => x_msg_data);
1559: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1560: END COPY_TMPL_SET;
1611: EXCEPTION
1612: WHEN FND_API.G_EXC_ERROR THEN
1613: ROLLBACK TO COPY_TEMPLATE2;
1614: x_return_status := FND_API.G_RET_STS_ERROR;
1615: FND_MSG_PUB.Count_and_get(p_encoded => OKL_API.G_FALSE
1616: ,p_count => x_msg_count
1617: ,p_data => x_msg_data);
1618: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1619: ROLLBACK TO COPY_TEMPLATE2;
1617: ,p_data => x_msg_data);
1618: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1619: ROLLBACK TO COPY_TEMPLATE2;
1620: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1621: FND_MSG_PUB.Count_and_get(p_encoded => OKL_API.G_FALSE
1622: ,p_count => x_msg_count
1623: ,p_data => x_msg_data);
1624: WHEN OTHERS THEN
1625: ROLLBACK TO COPY_TEMPLATE2;
1622: ,p_count => x_msg_count
1623: ,p_data => x_msg_data);
1624: WHEN OTHERS THEN
1625: ROLLBACK TO COPY_TEMPLATE2;
1626: FND_MSG_PUB.ADD_EXC_MSG('OKL_COPY_TEMPLATE_PUB','COPY_TEMPLATE');
1627: FND_MSG_PUB.Count_and_get(p_encoded => OKL_API.G_FALSE
1628: ,p_count => x_msg_count
1629: ,p_data => x_msg_data);
1630: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1623: ,p_data => x_msg_data);
1624: WHEN OTHERS THEN
1625: ROLLBACK TO COPY_TEMPLATE2;
1626: FND_MSG_PUB.ADD_EXC_MSG('OKL_COPY_TEMPLATE_PUB','COPY_TEMPLATE');
1627: FND_MSG_PUB.Count_and_get(p_encoded => OKL_API.G_FALSE
1628: ,p_count => x_msg_count
1629: ,p_data => x_msg_data);
1630: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1631: END COPY_TEMPLATE;