DBA Data[Home] [Help]

APPS.OKL_INS_CLASS_CATS_PUB dependencies on FND_MSG_PUB

Line 75: FND_MSG_PUB.count_and_get(

71: ROLLBACK TO ins_class_cats_insert;
72: x_return_status := FND_API.G_RET_STS_ERROR;
73: x_msg_count := l_msg_count ;
74: x_msg_data := l_msg_data ;
75: FND_MSG_PUB.count_and_get(
76: p_count => x_msg_count
77: ,p_data => x_msg_data);
78: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
79: ROLLBACK TO ins_class_cats_insert;

Line 83: FND_MSG_PUB.count_and_get(

79: ROLLBACK TO ins_class_cats_insert;
80: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
81: x_msg_count := l_msg_count ;
82: x_msg_data := l_msg_data ;
83: FND_MSG_PUB.count_and_get(
84: p_count => x_msg_count
85: ,p_data => x_msg_data);
86: WHEN OTHERS THEN
87: ROLLBACK TO ins_class_cats_insert;

Line 91: FND_MSG_PUB.ADD_EXC_MSG('OKL_INS_CLASS_CATS_PUB','insert_ins_class_cats');

87: ROLLBACK TO ins_class_cats_insert;
88: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
89: x_msg_count := l_msg_count ;
90: x_msg_data := l_msg_data ;
91: FND_MSG_PUB.ADD_EXC_MSG('OKL_INS_CLASS_CATS_PUB','insert_ins_class_cats');
92: FND_MSG_PUB.count_and_get(
93: p_count => x_msg_count
94: ,p_data => x_msg_data);
95: END insert_ins_class_cats;

Line 92: FND_MSG_PUB.count_and_get(

88: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
89: x_msg_count := l_msg_count ;
90: x_msg_data := l_msg_data ;
91: FND_MSG_PUB.ADD_EXC_MSG('OKL_INS_CLASS_CATS_PUB','insert_ins_class_cats');
92: FND_MSG_PUB.count_and_get(
93: p_count => x_msg_count
94: ,p_data => x_msg_data);
95: END insert_ins_class_cats;
96:

Line 163: FND_MSG_PUB.count_and_get(

159: ROLLBACK TO ins_class_cats_insert;
160: x_return_status := FND_API.G_RET_STS_ERROR;
161: x_msg_count := l_msg_count ;
162: x_msg_data := l_msg_data ;
163: FND_MSG_PUB.count_and_get(
164: p_count => x_msg_count
165: ,p_data => x_msg_data);
166: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
167: ROLLBACK TO ins_class_cats_insert;

Line 171: FND_MSG_PUB.count_and_get(

167: ROLLBACK TO ins_class_cats_insert;
168: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
169: x_msg_count := l_msg_count ;
170: x_msg_data := l_msg_data ;
171: FND_MSG_PUB.count_and_get(
172: p_count => x_msg_count
173: ,p_data => x_msg_data);
174: WHEN OTHERS THEN
175: ROLLBACK TO ins_class_cats_insert;

Line 179: FND_MSG_PUB.ADD_EXC_MSG('OKL_INS_CLASS_CATS_PUB','insert_ins_class_cats');

175: ROLLBACK TO ins_class_cats_insert;
176: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
177: x_msg_count := l_msg_count ;
178: x_msg_data := l_msg_data ;
179: FND_MSG_PUB.ADD_EXC_MSG('OKL_INS_CLASS_CATS_PUB','insert_ins_class_cats');
180: FND_MSG_PUB.count_and_get(
181: p_count => x_msg_count
182: ,p_data => x_msg_data);
183: END insert_ins_class_cats;

Line 180: FND_MSG_PUB.count_and_get(

176: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
177: x_msg_count := l_msg_count ;
178: x_msg_data := l_msg_data ;
179: FND_MSG_PUB.ADD_EXC_MSG('OKL_INS_CLASS_CATS_PUB','insert_ins_class_cats');
180: FND_MSG_PUB.count_and_get(
181: p_count => x_msg_count
182: ,p_data => x_msg_data);
183: END insert_ins_class_cats;
184:

Line 212: FND_MSG_PUB.count_and_get(

208:
209: EXCEPTION
210:
211: WHEN FND_API.G_EXC_ERROR THEN
212: FND_MSG_PUB.count_and_get(
213: p_count => x_msg_count
214: ,p_data => x_msg_data);
215: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
216: FND_MSG_PUB.count_and_get(

Line 216: FND_MSG_PUB.count_and_get(

212: FND_MSG_PUB.count_and_get(
213: p_count => x_msg_count
214: ,p_data => x_msg_data);
215: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
216: FND_MSG_PUB.count_and_get(
217: p_count => x_msg_count
218: ,p_data => x_msg_data);
219: WHEN OTHERS THEN
220: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 221: FND_MSG_PUB.ADD_EXC_MSG('OKL_INS_CLASS_CATS_PUB','lock_ins_class_cats');

217: p_count => x_msg_count
218: ,p_data => x_msg_data);
219: WHEN OTHERS THEN
220: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
221: FND_MSG_PUB.ADD_EXC_MSG('OKL_INS_CLASS_CATS_PUB','lock_ins_class_cats');
222: FND_MSG_PUB.count_and_get(
223: p_count => x_msg_count
224: ,p_data => x_msg_data);
225: END lock_ins_class_cats;

Line 222: FND_MSG_PUB.count_and_get(

218: ,p_data => x_msg_data);
219: WHEN OTHERS THEN
220: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
221: FND_MSG_PUB.ADD_EXC_MSG('OKL_INS_CLASS_CATS_PUB','lock_ins_class_cats');
222: FND_MSG_PUB.count_and_get(
223: p_count => x_msg_count
224: ,p_data => x_msg_data);
225: END lock_ins_class_cats;
226:

Line 254: FND_MSG_PUB.count_and_get(

250:
251: EXCEPTION
252:
253: WHEN FND_API.G_EXC_ERROR THEN
254: FND_MSG_PUB.count_and_get(
255: p_count => x_msg_count
256: ,p_data => x_msg_data);
257: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
258: FND_MSG_PUB.count_and_get(

Line 258: FND_MSG_PUB.count_and_get(

254: FND_MSG_PUB.count_and_get(
255: p_count => x_msg_count
256: ,p_data => x_msg_data);
257: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
258: FND_MSG_PUB.count_and_get(
259: p_count => x_msg_count
260: ,p_data => x_msg_data);
261: WHEN OTHERS THEN
262: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 263: FND_MSG_PUB.ADD_EXC_MSG('OKL_INS_CLASS_CATS_PUB','lock_ins_class_cats');

259: p_count => x_msg_count
260: ,p_data => x_msg_data);
261: WHEN OTHERS THEN
262: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
263: FND_MSG_PUB.ADD_EXC_MSG('OKL_INS_CLASS_CATS_PUB','lock_ins_class_cats');
264: FND_MSG_PUB.count_and_get(
265: p_count => x_msg_count
266: ,p_data => x_msg_data);
267: END lock_ins_class_cats;

Line 264: FND_MSG_PUB.count_and_get(

260: ,p_data => x_msg_data);
261: WHEN OTHERS THEN
262: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
263: FND_MSG_PUB.ADD_EXC_MSG('OKL_INS_CLASS_CATS_PUB','lock_ins_class_cats');
264: FND_MSG_PUB.count_and_get(
265: p_count => x_msg_count
266: ,p_data => x_msg_data);
267: END lock_ins_class_cats;
268:

Line 337: FND_MSG_PUB.count_and_get(

333: ROLLBACK TO ins_class_cats_update;
334: x_return_status := FND_API.G_RET_STS_ERROR;
335: x_msg_count := l_msg_count ;
336: x_msg_data := l_msg_data ;
337: FND_MSG_PUB.count_and_get(
338: p_count => x_msg_count
339: ,p_data => x_msg_data);
340:
341:

Line 347: FND_MSG_PUB.count_and_get(

343: ROLLBACK TO ins_class_cats_update;
344: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
345: x_msg_count := l_msg_count ;
346: x_msg_data := l_msg_data ;
347: FND_MSG_PUB.count_and_get(
348: p_count => x_msg_count
349: ,p_data => x_msg_data);
350:
351:

Line 357: FND_MSG_PUB.ADD_EXC_MSG('OKL_INS_CLASS_CATS_PUB','update_ins_class_cats');

353: ROLLBACK TO ins_class_cats_update;
354: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
355: x_msg_count := l_msg_count ;
356: x_msg_data := l_msg_data ;
357: FND_MSG_PUB.ADD_EXC_MSG('OKL_INS_CLASS_CATS_PUB','update_ins_class_cats');
358: FND_MSG_PUB.count_and_get(
359: p_count => x_msg_count
360: ,p_data => x_msg_data);
361:

Line 358: FND_MSG_PUB.count_and_get(

354: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
355: x_msg_count := l_msg_count ;
356: x_msg_data := l_msg_data ;
357: FND_MSG_PUB.ADD_EXC_MSG('OKL_INS_CLASS_CATS_PUB','update_ins_class_cats');
358: FND_MSG_PUB.count_and_get(
359: p_count => x_msg_count
360: ,p_data => x_msg_data);
361:
362:

Line 433: FND_MSG_PUB.count_and_get(

429: ROLLBACK TO ins_class_cats_update;
430: x_return_status := FND_API.G_RET_STS_ERROR;
431: x_msg_count := l_msg_count ;
432: x_msg_data := l_msg_data ;
433: FND_MSG_PUB.count_and_get(
434: p_count => x_msg_count
435: ,p_data => x_msg_data);
436: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
437: ROLLBACK TO ins_class_cats_update;

Line 441: FND_MSG_PUB.count_and_get(

437: ROLLBACK TO ins_class_cats_update;
438: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
439: x_msg_count := l_msg_count ;
440: x_msg_data := l_msg_data ;
441: FND_MSG_PUB.count_and_get(
442: p_count => x_msg_count
443: ,p_data => x_msg_data);
444: WHEN OTHERS THEN
445: ROLLBACK TO ins_class_cats_update;

Line 449: FND_MSG_PUB.ADD_EXC_MSG('OKL_INS_CLASS_CATS_PUB','update_ins_class_cats');

445: ROLLBACK TO ins_class_cats_update;
446: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
447: x_msg_count := l_msg_count ;
448: x_msg_data := l_msg_data ;
449: FND_MSG_PUB.ADD_EXC_MSG('OKL_INS_CLASS_CATS_PUB','update_ins_class_cats');
450: FND_MSG_PUB.count_and_get(
451: p_count => x_msg_count
452: ,p_data => x_msg_data);
453: END update_ins_class_cats;

Line 450: FND_MSG_PUB.count_and_get(

446: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
447: x_msg_count := l_msg_count ;
448: x_msg_data := l_msg_data ;
449: FND_MSG_PUB.ADD_EXC_MSG('OKL_INS_CLASS_CATS_PUB','update_ins_class_cats');
450: FND_MSG_PUB.count_and_get(
451: p_count => x_msg_count
452: ,p_data => x_msg_data);
453: END update_ins_class_cats;
454:

Line 519: FND_MSG_PUB.count_and_get(

515: ROLLBACK TO ins_class_cats_delete_rec;
516: x_return_status := FND_API.G_RET_STS_ERROR;
517: x_msg_count := l_msg_count ;
518: x_msg_data := l_msg_data ;
519: FND_MSG_PUB.count_and_get(
520: p_count => x_msg_count
521: ,p_data => x_msg_data);
522: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
523: ROLLBACK TO ins_class_cats_delete_rec;

Line 527: FND_MSG_PUB.count_and_get(

523: ROLLBACK TO ins_class_cats_delete_rec;
524: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
525: x_msg_count := l_msg_count ;
526: x_msg_data := l_msg_data ;
527: FND_MSG_PUB.count_and_get(
528: p_count => x_msg_count
529: ,p_data => x_msg_data);
530: WHEN OTHERS THEN
531: ROLLBACK TO ins_class_cats_delete_rec;

Line 535: FND_MSG_PUB.ADD_EXC_MSG('OKL_INS_CLASS_CATS_PUB','delete_ins_class_cats');

531: ROLLBACK TO ins_class_cats_delete_rec;
532: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
533: x_msg_count := l_msg_count ;
534: x_msg_data := l_msg_data ;
535: FND_MSG_PUB.ADD_EXC_MSG('OKL_INS_CLASS_CATS_PUB','delete_ins_class_cats');
536: FND_MSG_PUB.count_and_get(
537: p_count => x_msg_count
538: ,p_data => x_msg_data);
539: END delete_ins_class_cats;

Line 536: FND_MSG_PUB.count_and_get(

532: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
533: x_msg_count := l_msg_count ;
534: x_msg_data := l_msg_data ;
535: FND_MSG_PUB.ADD_EXC_MSG('OKL_INS_CLASS_CATS_PUB','delete_ins_class_cats');
536: FND_MSG_PUB.count_and_get(
537: p_count => x_msg_count
538: ,p_data => x_msg_data);
539: END delete_ins_class_cats;
540:

Line 616: FND_MSG_PUB.count_and_get(

612: ROLLBACK TO ins_class_cats_delete_tbl;
613: x_return_status := FND_API.G_RET_STS_ERROR;
614: x_msg_count := l_msg_count ;
615: x_msg_data := l_msg_data ;
616: FND_MSG_PUB.count_and_get(
617: p_count => x_msg_count
618: ,p_data => x_msg_data);
619: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
620: ROLLBACK TO ins_class_cats_delete_tbl;

Line 624: FND_MSG_PUB.count_and_get(

620: ROLLBACK TO ins_class_cats_delete_tbl;
621: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
622: x_msg_count := l_msg_count ;
623: x_msg_data := l_msg_data ;
624: FND_MSG_PUB.count_and_get(
625: p_count => x_msg_count
626: ,p_data => x_msg_data);
627: WHEN OTHERS THEN
628: ROLLBACK TO ins_class_cats_delete_tbl;

Line 632: FND_MSG_PUB.ADD_EXC_MSG('OKL_INS_CLASS_CATS_PUB','delete_ins_class_cats');

628: ROLLBACK TO ins_class_cats_delete_tbl;
629: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
630: x_msg_count := l_msg_count ;
631: x_msg_data := l_msg_data ;
632: FND_MSG_PUB.ADD_EXC_MSG('OKL_INS_CLASS_CATS_PUB','delete_ins_class_cats');
633: FND_MSG_PUB.count_and_get(
634: p_count => x_msg_count
635: ,p_data => x_msg_data);
636: END delete_ins_class_cats;

Line 633: FND_MSG_PUB.count_and_get(

629: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
630: x_msg_count := l_msg_count ;
631: x_msg_data := l_msg_data ;
632: FND_MSG_PUB.ADD_EXC_MSG('OKL_INS_CLASS_CATS_PUB','delete_ins_class_cats');
633: FND_MSG_PUB.count_and_get(
634: p_count => x_msg_count
635: ,p_data => x_msg_data);
636: END delete_ins_class_cats;
637:

Line 706: FND_MSG_PUB.count_and_get(

702: ROLLBACK TO ins_class_cats_validate;
703: x_return_status := FND_API.G_RET_STS_ERROR;
704: x_msg_count := l_msg_count ;
705: x_msg_data := l_msg_data ;
706: FND_MSG_PUB.count_and_get(
707: p_count => x_msg_count
708: ,p_data => x_msg_data);
709: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
710: ROLLBACK TO ins_class_cats_validate;

Line 714: FND_MSG_PUB.count_and_get(

710: ROLLBACK TO ins_class_cats_validate;
711: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
712: x_msg_count := l_msg_count ;
713: x_msg_data := l_msg_data ;
714: FND_MSG_PUB.count_and_get(
715: p_count => x_msg_count
716: ,p_data => x_msg_data);
717: WHEN OTHERS THEN
718: ROLLBACK TO ins_class_cats_validate;

Line 722: FND_MSG_PUB.ADD_EXC_MSG('OKL_INS_CLASS_CATS_PUB','validate_ins_class_cats');

718: ROLLBACK TO ins_class_cats_validate;
719: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
720: x_msg_count := l_msg_count ;
721: x_msg_data := l_msg_data ;
722: FND_MSG_PUB.ADD_EXC_MSG('OKL_INS_CLASS_CATS_PUB','validate_ins_class_cats');
723: FND_MSG_PUB.count_and_get(
724: p_count => x_msg_count
725: ,p_data => x_msg_data);
726: END validate_ins_class_cats;

Line 723: FND_MSG_PUB.count_and_get(

719: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
720: x_msg_count := l_msg_count ;
721: x_msg_data := l_msg_data ;
722: FND_MSG_PUB.ADD_EXC_MSG('OKL_INS_CLASS_CATS_PUB','validate_ins_class_cats');
723: FND_MSG_PUB.count_and_get(
724: p_count => x_msg_count
725: ,p_data => x_msg_data);
726: END validate_ins_class_cats;
727:

Line 791: FND_MSG_PUB.count_and_get(

787: ROLLBACK TO ins_class_cats_validate;
788: x_return_status := FND_API.G_RET_STS_ERROR;
789: x_msg_count := l_msg_count ;
790: x_msg_data := l_msg_data ;
791: FND_MSG_PUB.count_and_get(
792: p_count => x_msg_count
793: ,p_data => x_msg_data);
794: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
795: ROLLBACK TO ins_class_cats_validate;

Line 799: FND_MSG_PUB.count_and_get(

795: ROLLBACK TO ins_class_cats_validate;
796: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
797: x_msg_count := l_msg_count ;
798: x_msg_data := l_msg_data ;
799: FND_MSG_PUB.count_and_get(
800: p_count => x_msg_count
801: ,p_data => x_msg_data);
802: WHEN OTHERS THEN
803: ROLLBACK TO ins_class_cats_validate;

Line 807: FND_MSG_PUB.ADD_EXC_MSG('OKL_INS_CLASS_CATS_PUB','validate_ins_class_cats');

803: ROLLBACK TO ins_class_cats_validate;
804: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
805: x_msg_count := l_msg_count ;
806: x_msg_data := l_msg_data ;
807: FND_MSG_PUB.ADD_EXC_MSG('OKL_INS_CLASS_CATS_PUB','validate_ins_class_cats');
808: FND_MSG_PUB.count_and_get(
809: p_count => x_msg_count
810: ,p_data => x_msg_data);
811: END validate_ins_class_cats;

Line 808: FND_MSG_PUB.count_and_get(

804: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
805: x_msg_count := l_msg_count ;
806: x_msg_data := l_msg_data ;
807: FND_MSG_PUB.ADD_EXC_MSG('OKL_INS_CLASS_CATS_PUB','validate_ins_class_cats');
808: FND_MSG_PUB.count_and_get(
809: p_count => x_msg_count
810: ,p_data => x_msg_data);
811: END validate_ins_class_cats;
812: