DBA Data[Home] [Help]

APPS.OKL_BUCKETS_PUB dependencies on FND_MSG_PUB

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

55: WHEN FND_API.G_EXC_ERROR THEN
56: ROLLBACK TO insert_buckets;
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

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

62:
63: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
64: ROLLBACK TO insert_buckets;
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

Line 71: FND_MSG_PUB.ADD_EXC_MSG('OKL_BUCKETS_PUB','insert_buckets');

67: ,p_count => x_msg_count
68: ,p_data => x_msg_data);
69:
70: WHEN OTHERS THEN
71: FND_MSG_PUB.ADD_EXC_MSG('OKL_BUCKETS_PUB','insert_buckets');
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);

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

69:
70: WHEN OTHERS THEN
71: FND_MSG_PUB.ADD_EXC_MSG('OKL_BUCKETS_PUB','insert_buckets');
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;

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

149: WHEN FND_API.G_EXC_ERROR THEN
150: ROLLBACK TO insert_buckets;
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

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

156:
157: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
158: ROLLBACK TO insert_buckets;
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

Line 165: FND_MSG_PUB.ADD_EXC_MSG('OKL_BUCKETS_PUB','insert_buckets');

161: ,p_count => x_msg_count
162: ,p_data => x_msg_data);
163:
164: WHEN OTHERS THEN
165: FND_MSG_PUB.ADD_EXC_MSG('OKL_BUCKETS_PUB','insert_buckets');
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);

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

163:
164: WHEN OTHERS THEN
165: FND_MSG_PUB.ADD_EXC_MSG('OKL_BUCKETS_PUB','insert_buckets');
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;

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

207: WHEN FND_API.G_EXC_ERROR THEN
208: ROLLBACK TO lock_buckets;
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

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

214:
215: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
216: ROLLBACK TO lock_buckets;
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

Line 223: FND_MSG_PUB.ADD_EXC_MSG('OKL_BUCKETS_PUB','lock_buckets');

219: ,p_count => x_msg_count
220: ,p_data => x_msg_data);
221:
222: WHEN OTHERS THEN
223: FND_MSG_PUB.ADD_EXC_MSG('OKL_BUCKETS_PUB','lock_buckets');
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);

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

221:
222: WHEN OTHERS THEN
223: FND_MSG_PUB.ADD_EXC_MSG('OKL_BUCKETS_PUB','lock_buckets');
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;

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

287: WHEN FND_API.G_EXC_ERROR THEN
288: ROLLBACK TO lock_buckets;
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

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

294:
295: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
296: ROLLBACK TO lock_buckets;
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

Line 303: FND_MSG_PUB.ADD_EXC_MSG('OKL_BUCKETS_PUB','lock_buckets');

299: ,p_count => x_msg_count
300: ,p_data => x_msg_data);
301:
302: WHEN OTHERS THEN
303: FND_MSG_PUB.ADD_EXC_MSG('OKL_BUCKETS_PUB','lock_buckets');
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);

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

301:
302: WHEN OTHERS THEN
303: FND_MSG_PUB.ADD_EXC_MSG('OKL_BUCKETS_PUB','lock_buckets');
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;

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

355: WHEN FND_API.G_EXC_ERROR THEN
356: ROLLBACK TO update_buckets;
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

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

362:
363: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
364: ROLLBACK TO update_buckets;
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

Line 371: FND_MSG_PUB.ADD_EXC_MSG('OKL_BUCKETS_PUB','update_buckets');

367: ,p_count => x_msg_count
368: ,p_data => x_msg_data);
369:
370: WHEN OTHERS THEN
371: FND_MSG_PUB.ADD_EXC_MSG('OKL_BUCKETS_PUB','update_buckets');
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);

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

369:
370: WHEN OTHERS THEN
371: FND_MSG_PUB.ADD_EXC_MSG('OKL_BUCKETS_PUB','update_buckets');
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;

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

449: WHEN FND_API.G_EXC_ERROR THEN
450: ROLLBACK TO update_buckets;
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

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

456:
457: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
458: ROLLBACK TO update_buckets;
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

Line 465: FND_MSG_PUB.ADD_EXC_MSG('OKL_BUCKETS_PUB','update_buckets');

461: ,p_count => x_msg_count
462: ,p_data => x_msg_data);
463:
464: WHEN OTHERS THEN
465: FND_MSG_PUB.ADD_EXC_MSG('OKL_BUCKETS_PUB','update_buckets');
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);

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

463:
464: WHEN OTHERS THEN
465: FND_MSG_PUB.ADD_EXC_MSG('OKL_BUCKETS_PUB','update_buckets');
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;

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

512: WHEN FND_API.G_EXC_ERROR THEN
513: ROLLBACK TO delete_buckets;
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

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

519:
520: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
521: ROLLBACK TO delete_buckets;
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

Line 528: FND_MSG_PUB.ADD_EXC_MSG('OKL_BUCKETS_PUB','delete_buckets');

524: ,p_count => x_msg_count
525: ,p_data => x_msg_data);
526:
527: WHEN OTHERS THEN
528: FND_MSG_PUB.ADD_EXC_MSG('OKL_BUCKETS_PUB','delete_buckets');
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);

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

526:
527: WHEN OTHERS THEN
528: FND_MSG_PUB.ADD_EXC_MSG('OKL_BUCKETS_PUB','delete_buckets');
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;

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

601: WHEN FND_API.G_EXC_ERROR THEN
602: ROLLBACK TO delete_buckets;
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

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

608:
609: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
610: ROLLBACK TO delete_buckets;
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

Line 617: FND_MSG_PUB.ADD_EXC_MSG('OKL_BUCKETS_PUB','delete_buckets');

613: ,p_count => x_msg_count
614: ,p_data => x_msg_data);
615:
616: WHEN OTHERS THEN
617: FND_MSG_PUB.ADD_EXC_MSG('OKL_BUCKETS_PUB','delete_buckets');
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);

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

615:
616: WHEN OTHERS THEN
617: FND_MSG_PUB.ADD_EXC_MSG('OKL_BUCKETS_PUB','delete_buckets');
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;

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

664: WHEN FND_API.G_EXC_ERROR THEN
665: ROLLBACK TO validate_buckets;
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

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

671:
672: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
673: ROLLBACK TO validate_buckets;
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

Line 680: FND_MSG_PUB.ADD_EXC_MSG('OKL_BUCKETS_PUB','validate_buckets');

676: ,p_count => x_msg_count
677: ,p_data => x_msg_data);
678:
679: WHEN OTHERS THEN
680: FND_MSG_PUB.ADD_EXC_MSG('OKL_BUCKETS_PUB','validate_buckets');
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);

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

678:
679: WHEN OTHERS THEN
680: FND_MSG_PUB.ADD_EXC_MSG('OKL_BUCKETS_PUB','validate_buckets');
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;

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

754: WHEN FND_API.G_EXC_ERROR THEN
755: ROLLBACK TO validate_buckets;
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

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

761:
762: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
763: ROLLBACK TO validate_buckets;
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

Line 770: FND_MSG_PUB.ADD_EXC_MSG('OKL_BUCKETS_PUB','validate_buckets');

766: ,p_count => x_msg_count
767: ,p_data => x_msg_data);
768:
769: WHEN OTHERS THEN
770: FND_MSG_PUB.ADD_EXC_MSG('OKL_BUCKETS_PUB','validate_buckets');
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);

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

768:
769: WHEN OTHERS THEN
770: FND_MSG_PUB.ADD_EXC_MSG('OKL_BUCKETS_PUB','validate_buckets');
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;