9:
10:
11: PROCEDURE insert_context_groups(
12: p_api_version IN NUMBER
13: ,p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE
14: ,x_return_status OUT NOCOPY VARCHAR2
15: ,x_msg_count OUT NOCOPY NUMBER
16: ,x_msg_data OUT NOCOPY VARCHAR2
17: ,p_cgrv_rec IN cgrv_rec_type
55: WHEN FND_API.G_EXC_ERROR THEN
56: ROLLBACK TO insert_context_groups;
57: x_return_status := FND_API.G_RET_STS_ERROR;
58:
59: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
60: ,p_count => x_msg_count
61: ,p_data => x_msg_data);
62:
63: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
62:
63: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
64: ROLLBACK TO insert_context_groups;
65: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
66: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
67: ,p_count => x_msg_count
68: ,p_data => x_msg_data);
69:
70: WHEN OTHERS THEN
69:
70: WHEN OTHERS THEN
71: FND_MSG_PUB.ADD_EXC_MSG('OKL_CONTEXT_GROUPS_PUB','insert_context_groups');
72: -- store SQL error message on message stack for caller
73: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
74: ,p_count => x_msg_count
75: ,p_data => x_msg_data);
76: -- notify caller of an UNEXPECTED error
77: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
79:
80:
81: PROCEDURE insert_context_groups(
82: p_api_version IN NUMBER
83: ,p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE
84: ,x_return_status OUT NOCOPY VARCHAR2
85: ,x_msg_count OUT NOCOPY NUMBER
86: ,x_msg_data OUT NOCOPY VARCHAR2
87: ,p_cgrv_tbl IN cgrv_tbl_type
149: WHEN FND_API.G_EXC_ERROR THEN
150: ROLLBACK TO insert_context_groups;
151: x_return_status := FND_API.G_RET_STS_ERROR;
152:
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:
157: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
156:
157: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
158: ROLLBACK TO insert_context_groups;
159: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
160: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
161: ,p_count => x_msg_count
162: ,p_data => x_msg_data);
163:
164: WHEN OTHERS THEN
163:
164: WHEN OTHERS THEN
165: FND_MSG_PUB.ADD_EXC_MSG('OKL_CONTEXT_GROUPS_PUB','insert_context_groups');
166: -- store SQL error message on message stack for caller
167: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
168: ,p_count => x_msg_count
169: ,p_data => x_msg_data);
170: -- notify caller of an UNEXPECTED error
171: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
172: END insert_context_groups;
173:
174: PROCEDURE lock_context_groups(
175: p_api_version IN NUMBER
176: ,p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE
177: ,x_return_status OUT NOCOPY VARCHAR2
178: ,x_msg_count OUT NOCOPY NUMBER
179: ,x_msg_data OUT NOCOPY VARCHAR2
180: ,p_cgrv_rec IN cgrv_rec_type
207: WHEN FND_API.G_EXC_ERROR THEN
208: ROLLBACK TO lock_context_groups;
209: x_return_status := FND_API.G_RET_STS_ERROR;
210:
211: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
212: ,p_count => x_msg_count
213: ,p_data => x_msg_data);
214:
215: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
214:
215: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
216: ROLLBACK TO lock_context_groups;
217: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
218: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
219: ,p_count => x_msg_count
220: ,p_data => x_msg_data);
221:
222: WHEN OTHERS THEN
221:
222: WHEN OTHERS THEN
223: FND_MSG_PUB.ADD_EXC_MSG('OKL_CONTEXT_GROUPS_PUB','lock_context_groups');
224: -- store SQL error message on message stack for caller
225: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
226: ,p_count => x_msg_count
227: ,p_data => x_msg_data);
228: -- notify caller of an UNEXPECTED error
229: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
230: END lock_context_groups;
231:
232: PROCEDURE lock_context_groups(
233: p_api_version IN NUMBER
234: ,p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE
235: ,x_return_status OUT NOCOPY VARCHAR2
236: ,x_msg_count OUT NOCOPY NUMBER
237: ,x_msg_data OUT NOCOPY VARCHAR2
238: ,p_cgrv_tbl IN cgrv_tbl_type
287: WHEN FND_API.G_EXC_ERROR THEN
288: ROLLBACK TO lock_context_groups;
289: x_return_status := FND_API.G_RET_STS_ERROR;
290:
291: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
292: ,p_count => x_msg_count
293: ,p_data => x_msg_data);
294:
295: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
294:
295: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
296: ROLLBACK TO lock_context_groups;
297: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
298: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
299: ,p_count => x_msg_count
300: ,p_data => x_msg_data);
301:
302: WHEN OTHERS THEN
301:
302: WHEN OTHERS THEN
303: FND_MSG_PUB.ADD_EXC_MSG('OKL_CONTEXT_GROUPS_PUB','lock_context_groups');
304: -- store SQL error message on message stack for caller
305: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
306: ,p_count => x_msg_count
307: ,p_data => x_msg_data);
308: -- notify caller of an UNEXPECTED error
309: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
310: END lock_context_groups;
311:
312: PROCEDURE update_context_groups(
313: p_api_version IN NUMBER
314: ,p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE
315: ,x_return_status OUT NOCOPY VARCHAR2
316: ,x_msg_count OUT NOCOPY NUMBER
317: ,x_msg_data OUT NOCOPY VARCHAR2
318: ,p_cgrv_rec IN cgrv_rec_type
355: WHEN FND_API.G_EXC_ERROR THEN
356: ROLLBACK TO update_context_groups;
357: x_return_status := FND_API.G_RET_STS_ERROR;
358:
359: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
360: ,p_count => x_msg_count
361: ,p_data => x_msg_data);
362:
363: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
362:
363: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
364: ROLLBACK TO update_context_groups;
365: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
366: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
367: ,p_count => x_msg_count
368: ,p_data => x_msg_data);
369:
370: WHEN OTHERS THEN
369:
370: WHEN OTHERS THEN
371: FND_MSG_PUB.ADD_EXC_MSG('OKL_CONTEXT_GROUPS_PUB','update_context_groups');
372: -- store SQL error message on message stack for caller
373: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
374: ,p_count => x_msg_count
375: ,p_data => x_msg_data);
376: -- notify caller of an UNEXPECTED error
377: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
379:
380:
381: PROCEDURE update_context_groups(
382: p_api_version IN NUMBER
383: ,p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE
384: ,x_return_status OUT NOCOPY VARCHAR2
385: ,x_msg_count OUT NOCOPY NUMBER
386: ,x_msg_data OUT NOCOPY VARCHAR2
387: ,p_cgrv_tbl IN cgrv_tbl_type
449: WHEN FND_API.G_EXC_ERROR THEN
450: ROLLBACK TO update_context_groups;
451: x_return_status := FND_API.G_RET_STS_ERROR;
452:
453: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
454: ,p_count => x_msg_count
455: ,p_data => x_msg_data);
456:
457: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
456:
457: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
458: ROLLBACK TO update_context_groups;
459: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
460: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
461: ,p_count => x_msg_count
462: ,p_data => x_msg_data);
463:
464: WHEN OTHERS THEN
463:
464: WHEN OTHERS THEN
465: FND_MSG_PUB.ADD_EXC_MSG('OKL_CONTEXT_GROUPS_PUB','update_context_groups');
466: -- store SQL error message on message stack for caller
467: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
468: ,p_count => x_msg_count
469: ,p_data => x_msg_data);
470: -- notify caller of an UNEXPECTED error
471: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
472: END update_context_groups;
473:
474: PROCEDURE delete_context_groups(
475: p_api_version IN NUMBER
476: ,p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE
477: ,x_return_status OUT NOCOPY VARCHAR2
478: ,x_msg_count OUT NOCOPY NUMBER
479: ,x_msg_data OUT NOCOPY VARCHAR2
480: ,p_cgrv_rec IN cgrv_rec_type
512: WHEN FND_API.G_EXC_ERROR THEN
513: ROLLBACK TO delete_context_groups;
514: x_return_status := FND_API.G_RET_STS_ERROR;
515:
516: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
517: ,p_count => x_msg_count
518: ,p_data => x_msg_data);
519:
520: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
519:
520: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
521: ROLLBACK TO delete_context_groups;
522: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
523: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
524: ,p_count => x_msg_count
525: ,p_data => x_msg_data);
526:
527: WHEN OTHERS THEN
526:
527: WHEN OTHERS THEN
528: FND_MSG_PUB.ADD_EXC_MSG('OKL_CONTEXT_GROUPS_PUB','delete_context_groups');
529: -- store SQL error message on message stack for caller
530: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
531: ,p_count => x_msg_count
532: ,p_data => x_msg_data);
533: -- notify caller of an UNEXPECTED error
534: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
536:
537:
538: PROCEDURE delete_context_groups(
539: p_api_version IN NUMBER
540: ,p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE
541: ,x_return_status OUT NOCOPY VARCHAR2
542: ,x_msg_count OUT NOCOPY NUMBER
543: ,x_msg_data OUT NOCOPY VARCHAR2
544: ,p_cgrv_tbl IN cgrv_tbl_type
601: WHEN FND_API.G_EXC_ERROR THEN
602: ROLLBACK TO delete_context_groups;
603: x_return_status := FND_API.G_RET_STS_ERROR;
604:
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:
609: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
608:
609: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
610: ROLLBACK TO delete_context_groups;
611: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
612: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
613: ,p_count => x_msg_count
614: ,p_data => x_msg_data);
615:
616: WHEN OTHERS THEN
615:
616: WHEN OTHERS THEN
617: FND_MSG_PUB.ADD_EXC_MSG('OKL_CONTEXT_GROUPS_PUB','delete_context_groups');
618: -- store SQL error message on message stack for caller
619: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
620: ,p_count => x_msg_count
621: ,p_data => x_msg_data);
622: -- notify caller of an UNEXPECTED error
623: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
624: END delete_context_groups;
625:
626: PROCEDURE validate_context_groups(
627: p_api_version IN NUMBER
628: ,p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE
629: ,x_return_status OUT NOCOPY VARCHAR2
630: ,x_msg_count OUT NOCOPY NUMBER
631: ,x_msg_data OUT NOCOPY VARCHAR2
632: ,p_cgrv_rec IN cgrv_rec_type
664: WHEN FND_API.G_EXC_ERROR THEN
665: ROLLBACK TO validate_context_groups;
666: x_return_status := FND_API.G_RET_STS_ERROR;
667:
668: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
669: ,p_count => x_msg_count
670: ,p_data => x_msg_data);
671:
672: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
671:
672: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
673: ROLLBACK TO validate_context_groups;
674: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
675: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
676: ,p_count => x_msg_count
677: ,p_data => x_msg_data);
678:
679: WHEN OTHERS THEN
678:
679: WHEN OTHERS THEN
680: FND_MSG_PUB.ADD_EXC_MSG('OKL_CONTEXT_GROUPS_PUB','validate_context_groups');
681: -- store SQL error message on message stack for caller
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: -- notify caller of an UNEXPECTED error
686: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
688:
689:
690: PROCEDURE validate_context_groups(
691: p_api_version IN NUMBER
692: ,p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE
693: ,x_return_status OUT NOCOPY VARCHAR2
694: ,x_msg_count OUT NOCOPY NUMBER
695: ,x_msg_data OUT NOCOPY VARCHAR2
696: ,p_cgrv_tbl IN cgrv_tbl_type
754: WHEN FND_API.G_EXC_ERROR THEN
755: ROLLBACK TO validate_context_groups;
756: x_return_status := FND_API.G_RET_STS_ERROR;
757:
758: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
759: ,p_count => x_msg_count
760: ,p_data => x_msg_data);
761:
762: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
761:
762: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
763: ROLLBACK TO validate_context_groups;
764: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
765: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
766: ,p_count => x_msg_count
767: ,p_data => x_msg_data);
768:
769: WHEN OTHERS THEN
768:
769: WHEN OTHERS THEN
770: FND_MSG_PUB.ADD_EXC_MSG('OKL_CONTEXT_GROUPS_PUB','validate_context_groups');
771: -- store SQL error message on message stack for caller
772: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
773: ,p_count => x_msg_count
774: ,p_data => x_msg_data);
775: -- notify caller of an UNEXPECTED error
776: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;