DBA Data[Home] [Help]

APPS.OKL_CNTR_LVLNG_GRPS_PUB dependencies on FND_MSG_PUB

Line 78: FND_MSG_PUB.count_and_get(

74: ROLLBACK TO cntr_lvlng_grps_insert;
75: x_return_status := FND_API.G_RET_STS_ERROR;
76: x_msg_count := l_msg_count ;
77: x_msg_data := l_msg_data ;
78: FND_MSG_PUB.count_and_get(
79: p_count => x_msg_count
80: ,p_data => x_msg_data);
81: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
82: ROLLBACK TO cntr_lvlng_grps_insert;

Line 86: FND_MSG_PUB.count_and_get(

82: ROLLBACK TO cntr_lvlng_grps_insert;
83: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
84: x_msg_count := l_msg_count ;
85: x_msg_data := l_msg_data ;
86: FND_MSG_PUB.count_and_get(
87: p_count => x_msg_count
88: ,p_data => x_msg_data);
89: WHEN OTHERS THEN
90: ROLLBACK TO cntr_lvlng_grps_insert;

Line 94: FND_MSG_PUB.ADD_EXC_MSG('OKL_CNTR_LVLNG_GRPS_PUB','insert_cntr_lvlng_grps');

90: ROLLBACK TO cntr_lvlng_grps_insert;
91: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
92: x_msg_count := l_msg_count ;
93: x_msg_data := l_msg_data ;
94: FND_MSG_PUB.ADD_EXC_MSG('OKL_CNTR_LVLNG_GRPS_PUB','insert_cntr_lvlng_grps');
95: FND_MSG_PUB.count_and_get(
96: p_count => x_msg_count
97: ,p_data => x_msg_data);
98: END insert_cntr_lvlng_grps;

Line 95: FND_MSG_PUB.count_and_get(

91: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
92: x_msg_count := l_msg_count ;
93: x_msg_data := l_msg_data ;
94: FND_MSG_PUB.ADD_EXC_MSG('OKL_CNTR_LVLNG_GRPS_PUB','insert_cntr_lvlng_grps');
95: FND_MSG_PUB.count_and_get(
96: p_count => x_msg_count
97: ,p_data => x_msg_data);
98: END insert_cntr_lvlng_grps;
99:

Line 173: FND_MSG_PUB.count_and_get(

169: ROLLBACK TO cntr_lvlng_grps_insert;
170: x_return_status := FND_API.G_RET_STS_ERROR;
171: x_msg_count := l_msg_count ;
172: x_msg_data := l_msg_data ;
173: FND_MSG_PUB.count_and_get(
174: p_count => x_msg_count
175: ,p_data => x_msg_data);
176: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
177: ROLLBACK TO cntr_lvlng_grps_insert;

Line 181: FND_MSG_PUB.count_and_get(

177: ROLLBACK TO cntr_lvlng_grps_insert;
178: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
179: x_msg_count := l_msg_count ;
180: x_msg_data := l_msg_data ;
181: FND_MSG_PUB.count_and_get(
182: p_count => x_msg_count
183: ,p_data => x_msg_data);
184: WHEN OTHERS THEN
185: ROLLBACK TO cntr_lvlng_grps_insert;

Line 189: FND_MSG_PUB.ADD_EXC_MSG('OKL_CNTR_LVLNG_GRPS_PUB','insert_cntr_lvlng_grps');

185: ROLLBACK TO cntr_lvlng_grps_insert;
186: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
187: x_msg_count := l_msg_count ;
188: x_msg_data := l_msg_data ;
189: FND_MSG_PUB.ADD_EXC_MSG('OKL_CNTR_LVLNG_GRPS_PUB','insert_cntr_lvlng_grps');
190: FND_MSG_PUB.count_and_get(
191: p_count => x_msg_count
192: ,p_data => x_msg_data);
193: END insert_cntr_lvlng_grps;

Line 190: FND_MSG_PUB.count_and_get(

186: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
187: x_msg_count := l_msg_count ;
188: x_msg_data := l_msg_data ;
189: FND_MSG_PUB.ADD_EXC_MSG('OKL_CNTR_LVLNG_GRPS_PUB','insert_cntr_lvlng_grps');
190: FND_MSG_PUB.count_and_get(
191: p_count => x_msg_count
192: ,p_data => x_msg_data);
193: END insert_cntr_lvlng_grps;
194:

Line 222: FND_MSG_PUB.count_and_get(

218:
219: EXCEPTION
220:
221: WHEN FND_API.G_EXC_ERROR THEN
222: FND_MSG_PUB.count_and_get(
223: p_count => x_msg_count
224: ,p_data => x_msg_data);
225: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
226: FND_MSG_PUB.count_and_get(

Line 226: FND_MSG_PUB.count_and_get(

222: FND_MSG_PUB.count_and_get(
223: p_count => x_msg_count
224: ,p_data => x_msg_data);
225: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
226: FND_MSG_PUB.count_and_get(
227: p_count => x_msg_count
228: ,p_data => x_msg_data);
229: WHEN OTHERS THEN
230: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 231: FND_MSG_PUB.ADD_EXC_MSG('OKL_CNTR_LVLNG_GRPS_PUB','lock_cntr_lvlng_grps');

227: p_count => x_msg_count
228: ,p_data => x_msg_data);
229: WHEN OTHERS THEN
230: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
231: FND_MSG_PUB.ADD_EXC_MSG('OKL_CNTR_LVLNG_GRPS_PUB','lock_cntr_lvlng_grps');
232: FND_MSG_PUB.count_and_get(
233: p_count => x_msg_count
234: ,p_data => x_msg_data);
235: END lock_cntr_lvlng_grps;

Line 232: FND_MSG_PUB.count_and_get(

228: ,p_data => x_msg_data);
229: WHEN OTHERS THEN
230: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
231: FND_MSG_PUB.ADD_EXC_MSG('OKL_CNTR_LVLNG_GRPS_PUB','lock_cntr_lvlng_grps');
232: FND_MSG_PUB.count_and_get(
233: p_count => x_msg_count
234: ,p_data => x_msg_data);
235: END lock_cntr_lvlng_grps;
236:

Line 264: FND_MSG_PUB.count_and_get(

260:
261: EXCEPTION
262:
263: WHEN FND_API.G_EXC_ERROR THEN
264: FND_MSG_PUB.count_and_get(
265: p_count => x_msg_count
266: ,p_data => x_msg_data);
267: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
268: FND_MSG_PUB.count_and_get(

Line 268: FND_MSG_PUB.count_and_get(

264: FND_MSG_PUB.count_and_get(
265: p_count => x_msg_count
266: ,p_data => x_msg_data);
267: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
268: FND_MSG_PUB.count_and_get(
269: p_count => x_msg_count
270: ,p_data => x_msg_data);
271: WHEN OTHERS THEN
272: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 273: FND_MSG_PUB.ADD_EXC_MSG('OKL_CNTR_LVLNG_GRPS_PUB','lock_cntr_lvlng_grps');

269: p_count => x_msg_count
270: ,p_data => x_msg_data);
271: WHEN OTHERS THEN
272: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
273: FND_MSG_PUB.ADD_EXC_MSG('OKL_CNTR_LVLNG_GRPS_PUB','lock_cntr_lvlng_grps');
274: FND_MSG_PUB.count_and_get(
275: p_count => x_msg_count
276: ,p_data => x_msg_data);
277: END lock_cntr_lvlng_grps;

Line 274: FND_MSG_PUB.count_and_get(

270: ,p_data => x_msg_data);
271: WHEN OTHERS THEN
272: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
273: FND_MSG_PUB.ADD_EXC_MSG('OKL_CNTR_LVLNG_GRPS_PUB','lock_cntr_lvlng_grps');
274: FND_MSG_PUB.count_and_get(
275: p_count => x_msg_count
276: ,p_data => x_msg_data);
277: END lock_cntr_lvlng_grps;
278:

Line 348: FND_MSG_PUB.count_and_get(

344: ROLLBACK TO cntr_lvlng_grps_update;
345: x_return_status := FND_API.G_RET_STS_ERROR;
346: x_msg_count := l_msg_count ;
347: x_msg_data := l_msg_data ;
348: FND_MSG_PUB.count_and_get(
349: p_count => x_msg_count
350: ,p_data => x_msg_data);
351: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
352: ROLLBACK TO cntr_lvlng_grps_update;

Line 356: FND_MSG_PUB.count_and_get(

352: ROLLBACK TO cntr_lvlng_grps_update;
353: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
354: x_msg_count := l_msg_count ;
355: x_msg_data := l_msg_data ;
356: FND_MSG_PUB.count_and_get(
357: p_count => x_msg_count
358: ,p_data => x_msg_data);
359: WHEN OTHERS THEN
360: ROLLBACK TO cntr_lvlng_grps_update;

Line 364: FND_MSG_PUB.ADD_EXC_MSG('OKL_CNTR_LVLNG_GRPS_PUB','update_cntr_lvlng_grps');

360: ROLLBACK TO cntr_lvlng_grps_update;
361: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
362: x_msg_count := l_msg_count ;
363: x_msg_data := l_msg_data ;
364: FND_MSG_PUB.ADD_EXC_MSG('OKL_CNTR_LVLNG_GRPS_PUB','update_cntr_lvlng_grps');
365: FND_MSG_PUB.count_and_get(
366: p_count => x_msg_count
367: ,p_data => x_msg_data);
368: END update_cntr_lvlng_grps;

Line 365: FND_MSG_PUB.count_and_get(

361: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
362: x_msg_count := l_msg_count ;
363: x_msg_data := l_msg_data ;
364: FND_MSG_PUB.ADD_EXC_MSG('OKL_CNTR_LVLNG_GRPS_PUB','update_cntr_lvlng_grps');
365: FND_MSG_PUB.count_and_get(
366: p_count => x_msg_count
367: ,p_data => x_msg_data);
368: END update_cntr_lvlng_grps;
369:

Line 437: FND_MSG_PUB.count_and_get(

433: ROLLBACK TO cntr_lvlng_grps_update;
434: x_return_status := FND_API.G_RET_STS_ERROR;
435: x_msg_count := l_msg_count ;
436: x_msg_data := l_msg_data ;
437: FND_MSG_PUB.count_and_get(
438: p_count => x_msg_count
439: ,p_data => x_msg_data);
440: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
441: ROLLBACK TO cntr_lvlng_grps_update;

Line 445: FND_MSG_PUB.count_and_get(

441: ROLLBACK TO cntr_lvlng_grps_update;
442: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
443: x_msg_count := l_msg_count ;
444: x_msg_data := l_msg_data ;
445: FND_MSG_PUB.count_and_get(
446: p_count => x_msg_count
447: ,p_data => x_msg_data);
448: WHEN OTHERS THEN
449: ROLLBACK TO cntr_lvlng_grps_update;

Line 453: FND_MSG_PUB.ADD_EXC_MSG('OKL_CNTR_LVLNG_GRPS_PUB','update_cntr_lvlng_grps');

449: ROLLBACK TO cntr_lvlng_grps_update;
450: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
451: x_msg_count := l_msg_count ;
452: x_msg_data := l_msg_data ;
453: FND_MSG_PUB.ADD_EXC_MSG('OKL_CNTR_LVLNG_GRPS_PUB','update_cntr_lvlng_grps');
454: FND_MSG_PUB.count_and_get(
455: p_count => x_msg_count
456: ,p_data => x_msg_data);
457: END update_cntr_lvlng_grps;

Line 454: FND_MSG_PUB.count_and_get(

450: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
451: x_msg_count := l_msg_count ;
452: x_msg_data := l_msg_data ;
453: FND_MSG_PUB.ADD_EXC_MSG('OKL_CNTR_LVLNG_GRPS_PUB','update_cntr_lvlng_grps');
454: FND_MSG_PUB.count_and_get(
455: p_count => x_msg_count
456: ,p_data => x_msg_data);
457: END update_cntr_lvlng_grps;
458:

Line 523: FND_MSG_PUB.count_and_get(

519: ROLLBACK TO cntr_lvlng_grps_delete_rec;
520: x_return_status := FND_API.G_RET_STS_ERROR;
521: x_msg_count := l_msg_count ;
522: x_msg_data := l_msg_data ;
523: FND_MSG_PUB.count_and_get(
524: p_count => x_msg_count
525: ,p_data => x_msg_data);
526: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
527: ROLLBACK TO cntr_lvlng_grps_delete_rec;

Line 531: FND_MSG_PUB.count_and_get(

527: ROLLBACK TO cntr_lvlng_grps_delete_rec;
528: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
529: x_msg_count := l_msg_count ;
530: x_msg_data := l_msg_data ;
531: FND_MSG_PUB.count_and_get(
532: p_count => x_msg_count
533: ,p_data => x_msg_data);
534: WHEN OTHERS THEN
535: ROLLBACK TO cntr_lvlng_grps_delete_rec;

Line 539: FND_MSG_PUB.ADD_EXC_MSG('OKL_CNTR_LVLNG_GRPS_PUB','delete_cntr_lvlng_grps');

535: ROLLBACK TO cntr_lvlng_grps_delete_rec;
536: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
537: x_msg_count := l_msg_count ;
538: x_msg_data := l_msg_data ;
539: FND_MSG_PUB.ADD_EXC_MSG('OKL_CNTR_LVLNG_GRPS_PUB','delete_cntr_lvlng_grps');
540: FND_MSG_PUB.count_and_get(
541: p_count => x_msg_count
542: ,p_data => x_msg_data);
543: END delete_cntr_lvlng_grps;

Line 540: FND_MSG_PUB.count_and_get(

536: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
537: x_msg_count := l_msg_count ;
538: x_msg_data := l_msg_data ;
539: FND_MSG_PUB.ADD_EXC_MSG('OKL_CNTR_LVLNG_GRPS_PUB','delete_cntr_lvlng_grps');
540: FND_MSG_PUB.count_and_get(
541: p_count => x_msg_count
542: ,p_data => x_msg_data);
543: END delete_cntr_lvlng_grps;
544:

Line 620: FND_MSG_PUB.count_and_get(

616: ROLLBACK TO cntr_lvlng_grps_delete_tbl;
617: x_return_status := FND_API.G_RET_STS_ERROR;
618: x_msg_count := l_msg_count ;
619: x_msg_data := l_msg_data ;
620: FND_MSG_PUB.count_and_get(
621: p_count => x_msg_count
622: ,p_data => x_msg_data);
623: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
624: ROLLBACK TO cntr_lvlng_grps_delete_tbl;

Line 628: FND_MSG_PUB.count_and_get(

624: ROLLBACK TO cntr_lvlng_grps_delete_tbl;
625: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
626: x_msg_count := l_msg_count ;
627: x_msg_data := l_msg_data ;
628: FND_MSG_PUB.count_and_get(
629: p_count => x_msg_count
630: ,p_data => x_msg_data);
631: WHEN OTHERS THEN
632: ROLLBACK TO cntr_lvlng_grps_delete_tbl;

Line 636: FND_MSG_PUB.ADD_EXC_MSG('OKL_CNTR_LVLNG_GRPS_PUB','delete_cntr_lvlng_grps');

632: ROLLBACK TO cntr_lvlng_grps_delete_tbl;
633: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
634: x_msg_count := l_msg_count ;
635: x_msg_data := l_msg_data ;
636: FND_MSG_PUB.ADD_EXC_MSG('OKL_CNTR_LVLNG_GRPS_PUB','delete_cntr_lvlng_grps');
637: FND_MSG_PUB.count_and_get(
638: p_count => x_msg_count
639: ,p_data => x_msg_data);
640: END delete_cntr_lvlng_grps;

Line 637: FND_MSG_PUB.count_and_get(

633: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
634: x_msg_count := l_msg_count ;
635: x_msg_data := l_msg_data ;
636: FND_MSG_PUB.ADD_EXC_MSG('OKL_CNTR_LVLNG_GRPS_PUB','delete_cntr_lvlng_grps');
637: FND_MSG_PUB.count_and_get(
638: p_count => x_msg_count
639: ,p_data => x_msg_data);
640: END delete_cntr_lvlng_grps;
641:

Line 710: FND_MSG_PUB.count_and_get(

706: ROLLBACK TO cntr_lvlng_grps_validate;
707: x_return_status := FND_API.G_RET_STS_ERROR;
708: x_msg_count := l_msg_count ;
709: x_msg_data := l_msg_data ;
710: FND_MSG_PUB.count_and_get(
711: p_count => x_msg_count
712: ,p_data => x_msg_data);
713: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
714: ROLLBACK TO cntr_lvlng_grps_validate;

Line 718: FND_MSG_PUB.count_and_get(

714: ROLLBACK TO cntr_lvlng_grps_validate;
715: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
716: x_msg_count := l_msg_count ;
717: x_msg_data := l_msg_data ;
718: FND_MSG_PUB.count_and_get(
719: p_count => x_msg_count
720: ,p_data => x_msg_data);
721: WHEN OTHERS THEN
722: ROLLBACK TO cntr_lvlng_grps_validate;

Line 726: FND_MSG_PUB.ADD_EXC_MSG('OKL_CNTR_LVLNG_GRPS_PUB','validate_cntr_lvlng_grps');

722: ROLLBACK TO cntr_lvlng_grps_validate;
723: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
724: x_msg_count := l_msg_count ;
725: x_msg_data := l_msg_data ;
726: FND_MSG_PUB.ADD_EXC_MSG('OKL_CNTR_LVLNG_GRPS_PUB','validate_cntr_lvlng_grps');
727: FND_MSG_PUB.count_and_get(
728: p_count => x_msg_count
729: ,p_data => x_msg_data);
730: END validate_cntr_lvlng_grps;

Line 727: FND_MSG_PUB.count_and_get(

723: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
724: x_msg_count := l_msg_count ;
725: x_msg_data := l_msg_data ;
726: FND_MSG_PUB.ADD_EXC_MSG('OKL_CNTR_LVLNG_GRPS_PUB','validate_cntr_lvlng_grps');
727: FND_MSG_PUB.count_and_get(
728: p_count => x_msg_count
729: ,p_data => x_msg_data);
730: END validate_cntr_lvlng_grps;
731:

Line 795: FND_MSG_PUB.count_and_get(

791: ROLLBACK TO cntr_lvlng_grps_validate;
792: x_return_status := FND_API.G_RET_STS_ERROR;
793: x_msg_count := l_msg_count ;
794: x_msg_data := l_msg_data ;
795: FND_MSG_PUB.count_and_get(
796: p_count => x_msg_count
797: ,p_data => x_msg_data);
798: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
799: ROLLBACK TO cntr_lvlng_grps_validate;

Line 803: FND_MSG_PUB.count_and_get(

799: ROLLBACK TO cntr_lvlng_grps_validate;
800: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
801: x_msg_count := l_msg_count ;
802: x_msg_data := l_msg_data ;
803: FND_MSG_PUB.count_and_get(
804: p_count => x_msg_count
805: ,p_data => x_msg_data);
806: WHEN OTHERS THEN
807: ROLLBACK TO cntr_lvlng_grps_validate;

Line 811: FND_MSG_PUB.ADD_EXC_MSG('OKL_CNTR_LVLNG_GRPS_PUB','validate_cntr_lvlng_grps');

807: ROLLBACK TO cntr_lvlng_grps_validate;
808: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
809: x_msg_count := l_msg_count ;
810: x_msg_data := l_msg_data ;
811: FND_MSG_PUB.ADD_EXC_MSG('OKL_CNTR_LVLNG_GRPS_PUB','validate_cntr_lvlng_grps');
812: FND_MSG_PUB.count_and_get(
813: p_count => x_msg_count
814: ,p_data => x_msg_data);
815: END validate_cntr_lvlng_grps;

Line 812: FND_MSG_PUB.count_and_get(

808: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
809: x_msg_count := l_msg_count ;
810: x_msg_data := l_msg_data ;
811: FND_MSG_PUB.ADD_EXC_MSG('OKL_CNTR_LVLNG_GRPS_PUB','validate_cntr_lvlng_grps');
812: FND_MSG_PUB.count_and_get(
813: p_count => x_msg_count
814: ,p_data => x_msg_data);
815: END validate_cntr_lvlng_grps;
816: