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_PROCESS_TMPT_SET_PUB dependencies on FND_MSG_PUB

Line 76: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE

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;

Line 82: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE

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;

Line 87: FND_MSG_PUB.ADD_EXC_MSG('OKL_PROCESS_TMPT_SET_PUB','create_tmpt_set');

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);

Line 89: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE

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;

Line 153: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE

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;

Line 159: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE

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;

Line 164: FND_MSG_PUB.ADD_EXC_MSG('OKL_PROCESS_TMPT_SET_PUB','create_tmpt_set');

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);

Line 166: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE

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;

Line 227: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE

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;

Line 233: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE

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;

Line 238: FND_MSG_PUB.ADD_EXC_MSG('OKL_PROCESS_TMPT_SET_PUB','create_tmpt_set');

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);

Line 240: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE

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;

Line 314: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE

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;

Line 320: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE

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;

Line 325: FND_MSG_PUB.ADD_EXC_MSG('OKL_PROCESS_TMPT_SET_PUB','update_tmpt_set');

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);

Line 327: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE

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;

Line 388: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE

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;

Line 394: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE

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;

Line 399: FND_MSG_PUB.ADD_EXC_MSG('OKL_PROCESS_TMPT_SET_PUB','update_tmpt_set');

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);

Line 401: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE

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;

Line 462: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE

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;

Line 468: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE

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;

Line 473: FND_MSG_PUB.ADD_EXC_MSG('OKL_PROCESS_TMPT_SET_PUB','update_tmpt_set');

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);

Line 475: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE

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;

Line 535: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE

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;

Line 541: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE

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;

Line 546: FND_MSG_PUB.ADD_EXC_MSG('OKL_PROCESS_TMPT_SET_PUB','delete_tmpt_set');

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);

Line 548: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE

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;

Line 605: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE

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;

Line 611: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE

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;

Line 616: FND_MSG_PUB.ADD_EXC_MSG('OKL_PROCESS_TMPT_SET_PUB','delete_tmpt_set');

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);

Line 618: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE

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;

Line 676: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE

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;

Line 682: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE

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;

Line 687: FND_MSG_PUB.ADD_EXC_MSG('OKL_PROCESS_TMPT_SET_PUB','create_template');

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);

Line 689: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE

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;

Line 747: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE

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;

Line 753: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE

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;

Line 758: FND_MSG_PUB.ADD_EXC_MSG('OKL_PROCESS_TMPT_SET_PUB','create_template');

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);

Line 760: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE

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;

Line 821: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE

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;

Line 827: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE

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;

Line 832: FND_MSG_PUB.ADD_EXC_MSG('OKL_PROCESS_TMPT_SET_PUB','update_template');

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);

Line 834: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE

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;

Line 894: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE

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;

Line 900: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE

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;

Line 905: FND_MSG_PUB.ADD_EXC_MSG('OKL_PROCESS_TMPT_SET_PUB','update_template');

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);

Line 907: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE

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;

Line 966: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE

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;

Line 972: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE

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;

Line 977: FND_MSG_PUB.ADD_EXC_MSG('OKL_PROCESS_TMPT_SET_PUB','delete_template');

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);

Line 979: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE

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;

Line 1035: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE

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;

Line 1041: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE

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;

Line 1046: FND_MSG_PUB.ADD_EXC_MSG('OKL_PROCESS_TMPT_SET_PUB','delete_template');

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);

Line 1048: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE

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;

Line 1109: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE

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;

Line 1115: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE

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;

Line 1120: FND_MSG_PUB.ADD_EXC_MSG('OKL_PROCESS_TMPT_SET_PUB','create_tmpt_lines');

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);

Line 1122: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE

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;

Line 1181: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE

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;

Line 1187: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE

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;

Line 1192: FND_MSG_PUB.ADD_EXC_MSG('OKL_PROCESS_TMPT_SET_PUB','create_tmpt_lines');

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);

Line 1194: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE

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;

Line 1255: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE

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;

Line 1261: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE

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;

Line 1266: FND_MSG_PUB.ADD_EXC_MSG('OKL_PROCESS_TMPT_SET_PUB','update_tmpt_lines');

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);

Line 1268: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE

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;

Line 1328: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE

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;

Line 1334: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE

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;

Line 1339: FND_MSG_PUB.ADD_EXC_MSG('OKL_PROCESS_TMPT_SET_PUB','update_tmpt_lines');

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);

Line 1341: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE

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;

Line 1400: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE

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;

Line 1406: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE

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;

Line 1411: FND_MSG_PUB.ADD_EXC_MSG('OKL_PROCESS_TMPT_SET_PUB','delete_tmpt_lines');

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);

Line 1413: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE

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;

Line 1469: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE

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;

Line 1475: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE

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;

Line 1480: FND_MSG_PUB.ADD_EXC_MSG('OKL_PROCESS_TMPT_SET_PUB','delete_tmpt_lines');

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);

Line 1482: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE

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;

Line 1544: FND_MSG_PUB.Count_and_get(p_encoded => OKL_API.G_FALSE

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;

Line 1550: FND_MSG_PUB.Count_and_get(p_encoded => OKL_API.G_FALSE

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;

Line 1555: FND_MSG_PUB.ADD_EXC_MSG('OKL_COPY_TEMPLATE_PUB','COPY_TMPL_SET');

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;

Line 1556: FND_MSG_PUB.Count_and_get(p_encoded => OKL_API.G_FALSE

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;

Line 1615: FND_MSG_PUB.Count_and_get(p_encoded => OKL_API.G_FALSE

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;

Line 1621: FND_MSG_PUB.Count_and_get(p_encoded => OKL_API.G_FALSE

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;

Line 1626: FND_MSG_PUB.ADD_EXC_MSG('OKL_COPY_TEMPLATE_PUB','COPY_TEMPLATE');

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;

Line 1627: FND_MSG_PUB.Count_and_get(p_encoded => OKL_API.G_FALSE

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;