DBA Data[Home] [Help]

APPS.OKL_INVOICE_FORMATS_PUB dependencies on FND_MSG_PUB

Line 75: FND_MSG_PUB.count_and_get(

71: ROLLBACK TO invoice_formats_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 invoice_formats_insert;

Line 83: FND_MSG_PUB.count_and_get(

79: ROLLBACK TO invoice_formats_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 invoice_formats_insert;

Line 91: FND_MSG_PUB.ADD_EXC_MSG('OKL_INVOICE_FORMATS_PUB','insert_invoice_formats');

87: ROLLBACK TO invoice_formats_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_INVOICE_FORMATS_PUB','insert_invoice_formats');
92: FND_MSG_PUB.count_and_get(
93: p_count => x_msg_count
94: ,p_data => x_msg_data);
95: END insert_invoice_formats;

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_INVOICE_FORMATS_PUB','insert_invoice_formats');
92: FND_MSG_PUB.count_and_get(
93: p_count => x_msg_count
94: ,p_data => x_msg_data);
95: END insert_invoice_formats;
96:

Line 163: FND_MSG_PUB.count_and_get(

159: ROLLBACK TO invoice_formats_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 invoice_formats_insert;

Line 171: FND_MSG_PUB.count_and_get(

167: ROLLBACK TO invoice_formats_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 invoice_formats_insert;

Line 179: FND_MSG_PUB.ADD_EXC_MSG('OKL_INVOICE_FORMATS_PUB','insert_invoice_formats');

175: ROLLBACK TO invoice_formats_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_INVOICE_FORMATS_PUB','insert_invoice_formats');
180: FND_MSG_PUB.count_and_get(
181: p_count => x_msg_count
182: ,p_data => x_msg_data);
183: END insert_invoice_formats;

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_INVOICE_FORMATS_PUB','insert_invoice_formats');
180: FND_MSG_PUB.count_and_get(
181: p_count => x_msg_count
182: ,p_data => x_msg_data);
183: END insert_invoice_formats;
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_INVOICE_FORMATS_PUB','lock_invoice_formats');

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_INVOICE_FORMATS_PUB','lock_invoice_formats');
222: FND_MSG_PUB.count_and_get(
223: p_count => x_msg_count
224: ,p_data => x_msg_data);
225: END lock_invoice_formats;

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_INVOICE_FORMATS_PUB','lock_invoice_formats');
222: FND_MSG_PUB.count_and_get(
223: p_count => x_msg_count
224: ,p_data => x_msg_data);
225: END lock_invoice_formats;
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_INVOICE_FORMATS_PUB','lock_invoice_formats');

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_INVOICE_FORMATS_PUB','lock_invoice_formats');
264: FND_MSG_PUB.count_and_get(
265: p_count => x_msg_count
266: ,p_data => x_msg_data);
267: END lock_invoice_formats;

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_INVOICE_FORMATS_PUB','lock_invoice_formats');
264: FND_MSG_PUB.count_and_get(
265: p_count => x_msg_count
266: ,p_data => x_msg_data);
267: END lock_invoice_formats;
268:

Line 338: FND_MSG_PUB.count_and_get(

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

Line 346: FND_MSG_PUB.count_and_get(

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

Line 354: FND_MSG_PUB.ADD_EXC_MSG('OKL_INVOICE_FORMATS_PUB','update_invoice_formats');

350: ROLLBACK TO invoice_formats_update;
351: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
352: x_msg_count := l_msg_count ;
353: x_msg_data := l_msg_data ;
354: FND_MSG_PUB.ADD_EXC_MSG('OKL_INVOICE_FORMATS_PUB','update_invoice_formats');
355: FND_MSG_PUB.count_and_get(
356: p_count => x_msg_count
357: ,p_data => x_msg_data);
358: END update_invoice_formats;

Line 355: FND_MSG_PUB.count_and_get(

351: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
352: x_msg_count := l_msg_count ;
353: x_msg_data := l_msg_data ;
354: FND_MSG_PUB.ADD_EXC_MSG('OKL_INVOICE_FORMATS_PUB','update_invoice_formats');
355: FND_MSG_PUB.count_and_get(
356: p_count => x_msg_count
357: ,p_data => x_msg_data);
358: END update_invoice_formats;
359:

Line 427: FND_MSG_PUB.count_and_get(

423: ROLLBACK TO invoice_formats_update;
424: x_return_status := FND_API.G_RET_STS_ERROR;
425: x_msg_count := l_msg_count ;
426: x_msg_data := l_msg_data ;
427: FND_MSG_PUB.count_and_get(
428: p_count => x_msg_count
429: ,p_data => x_msg_data);
430: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
431: ROLLBACK TO invoice_formats_update;

Line 435: FND_MSG_PUB.count_and_get(

431: ROLLBACK TO invoice_formats_update;
432: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
433: x_msg_count := l_msg_count ;
434: x_msg_data := l_msg_data ;
435: FND_MSG_PUB.count_and_get(
436: p_count => x_msg_count
437: ,p_data => x_msg_data);
438: WHEN OTHERS THEN
439: ROLLBACK TO invoice_formats_update;

Line 443: FND_MSG_PUB.ADD_EXC_MSG('OKL_INVOICE_FORMATS_PUB','update_invoice_formats');

439: ROLLBACK TO invoice_formats_update;
440: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
441: x_msg_count := l_msg_count ;
442: x_msg_data := l_msg_data ;
443: FND_MSG_PUB.ADD_EXC_MSG('OKL_INVOICE_FORMATS_PUB','update_invoice_formats');
444: FND_MSG_PUB.count_and_get(
445: p_count => x_msg_count
446: ,p_data => x_msg_data);
447: END update_invoice_formats;

Line 444: FND_MSG_PUB.count_and_get(

440: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
441: x_msg_count := l_msg_count ;
442: x_msg_data := l_msg_data ;
443: FND_MSG_PUB.ADD_EXC_MSG('OKL_INVOICE_FORMATS_PUB','update_invoice_formats');
444: FND_MSG_PUB.count_and_get(
445: p_count => x_msg_count
446: ,p_data => x_msg_data);
447: END update_invoice_formats;
448:

Line 541: FND_MSG_PUB.count_and_get(

537: ROLLBACK TO invoice_formats_delete_rec;
538: x_return_status := FND_API.G_RET_STS_ERROR;
539: x_msg_count := l_msg_count ;
540: x_msg_data := l_msg_data ;
541: FND_MSG_PUB.count_and_get(
542: p_count => x_msg_count
543: ,p_data => x_msg_data);
544: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
545: ROLLBACK TO invoice_formats_delete_rec;

Line 549: FND_MSG_PUB.count_and_get(

545: ROLLBACK TO invoice_formats_delete_rec;
546: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
547: x_msg_count := l_msg_count ;
548: x_msg_data := l_msg_data ;
549: FND_MSG_PUB.count_and_get(
550: p_count => x_msg_count
551: ,p_data => x_msg_data);
552: WHEN OTHERS THEN
553: ROLLBACK TO invoice_formats_delete_rec;

Line 557: FND_MSG_PUB.ADD_EXC_MSG('OKL_INVOICE_FORMATS_PUB','delete_invoice_formats');

553: ROLLBACK TO invoice_formats_delete_rec;
554: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
555: x_msg_count := l_msg_count ;
556: x_msg_data := l_msg_data ;
557: FND_MSG_PUB.ADD_EXC_MSG('OKL_INVOICE_FORMATS_PUB','delete_invoice_formats');
558: FND_MSG_PUB.count_and_get(
559: p_count => x_msg_count
560: ,p_data => x_msg_data);
561: END delete_invoice_formats;

Line 558: FND_MSG_PUB.count_and_get(

554: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
555: x_msg_count := l_msg_count ;
556: x_msg_data := l_msg_data ;
557: FND_MSG_PUB.ADD_EXC_MSG('OKL_INVOICE_FORMATS_PUB','delete_invoice_formats');
558: FND_MSG_PUB.count_and_get(
559: p_count => x_msg_count
560: ,p_data => x_msg_data);
561: END delete_invoice_formats;
562:

Line 638: FND_MSG_PUB.count_and_get(

634: ROLLBACK TO invoice_formats_delete_tbl;
635: x_return_status := FND_API.G_RET_STS_ERROR;
636: x_msg_count := l_msg_count ;
637: x_msg_data := l_msg_data ;
638: FND_MSG_PUB.count_and_get(
639: p_count => x_msg_count
640: ,p_data => x_msg_data);
641: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
642: ROLLBACK TO invoice_formats_delete_tbl;

Line 646: FND_MSG_PUB.count_and_get(

642: ROLLBACK TO invoice_formats_delete_tbl;
643: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
644: x_msg_count := l_msg_count ;
645: x_msg_data := l_msg_data ;
646: FND_MSG_PUB.count_and_get(
647: p_count => x_msg_count
648: ,p_data => x_msg_data);
649: WHEN OTHERS THEN
650: ROLLBACK TO invoice_formats_delete_tbl;

Line 654: FND_MSG_PUB.ADD_EXC_MSG('OKL_INVOICE_FORMATS_PUB','delete_invoice_formats');

650: ROLLBACK TO invoice_formats_delete_tbl;
651: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
652: x_msg_count := l_msg_count ;
653: x_msg_data := l_msg_data ;
654: FND_MSG_PUB.ADD_EXC_MSG('OKL_INVOICE_FORMATS_PUB','delete_invoice_formats');
655: FND_MSG_PUB.count_and_get(
656: p_count => x_msg_count
657: ,p_data => x_msg_data);
658: END delete_invoice_formats;

Line 655: FND_MSG_PUB.count_and_get(

651: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
652: x_msg_count := l_msg_count ;
653: x_msg_data := l_msg_data ;
654: FND_MSG_PUB.ADD_EXC_MSG('OKL_INVOICE_FORMATS_PUB','delete_invoice_formats');
655: FND_MSG_PUB.count_and_get(
656: p_count => x_msg_count
657: ,p_data => x_msg_data);
658: END delete_invoice_formats;
659:

Line 728: FND_MSG_PUB.count_and_get(

724: ROLLBACK TO invoice_formats_validate;
725: x_return_status := FND_API.G_RET_STS_ERROR;
726: x_msg_count := l_msg_count ;
727: x_msg_data := l_msg_data ;
728: FND_MSG_PUB.count_and_get(
729: p_count => x_msg_count
730: ,p_data => x_msg_data);
731: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
732: ROLLBACK TO invoice_formats_validate;

Line 736: FND_MSG_PUB.count_and_get(

732: ROLLBACK TO invoice_formats_validate;
733: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
734: x_msg_count := l_msg_count ;
735: x_msg_data := l_msg_data ;
736: FND_MSG_PUB.count_and_get(
737: p_count => x_msg_count
738: ,p_data => x_msg_data);
739: WHEN OTHERS THEN
740: ROLLBACK TO invoice_formats_validate;

Line 744: FND_MSG_PUB.ADD_EXC_MSG('OKL_INVOICE_FORMATS_PUB','validate_invoice_formats');

740: ROLLBACK TO invoice_formats_validate;
741: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
742: x_msg_count := l_msg_count ;
743: x_msg_data := l_msg_data ;
744: FND_MSG_PUB.ADD_EXC_MSG('OKL_INVOICE_FORMATS_PUB','validate_invoice_formats');
745: FND_MSG_PUB.count_and_get(
746: p_count => x_msg_count
747: ,p_data => x_msg_data);
748: END validate_invoice_formats;

Line 745: FND_MSG_PUB.count_and_get(

741: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
742: x_msg_count := l_msg_count ;
743: x_msg_data := l_msg_data ;
744: FND_MSG_PUB.ADD_EXC_MSG('OKL_INVOICE_FORMATS_PUB','validate_invoice_formats');
745: FND_MSG_PUB.count_and_get(
746: p_count => x_msg_count
747: ,p_data => x_msg_data);
748: END validate_invoice_formats;
749:

Line 813: FND_MSG_PUB.count_and_get(

809: ROLLBACK TO invoice_formats_validate;
810: x_return_status := FND_API.G_RET_STS_ERROR;
811: x_msg_count := l_msg_count ;
812: x_msg_data := l_msg_data ;
813: FND_MSG_PUB.count_and_get(
814: p_count => x_msg_count
815: ,p_data => x_msg_data);
816: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
817: ROLLBACK TO invoice_formats_validate;

Line 821: FND_MSG_PUB.count_and_get(

817: ROLLBACK TO invoice_formats_validate;
818: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
819: x_msg_count := l_msg_count ;
820: x_msg_data := l_msg_data ;
821: FND_MSG_PUB.count_and_get(
822: p_count => x_msg_count
823: ,p_data => x_msg_data);
824: WHEN OTHERS THEN
825: ROLLBACK TO invoice_formats_validate;

Line 829: FND_MSG_PUB.ADD_EXC_MSG('OKL_INVOICE_FORMATS_PUB','validate_invoice_formats');

825: ROLLBACK TO invoice_formats_validate;
826: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
827: x_msg_count := l_msg_count ;
828: x_msg_data := l_msg_data ;
829: FND_MSG_PUB.ADD_EXC_MSG('OKL_INVOICE_FORMATS_PUB','validate_invoice_formats');
830: FND_MSG_PUB.count_and_get(
831: p_count => x_msg_count
832: ,p_data => x_msg_data);
833: END validate_invoice_formats;

Line 830: FND_MSG_PUB.count_and_get(

826: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
827: x_msg_count := l_msg_count ;
828: x_msg_data := l_msg_data ;
829: FND_MSG_PUB.ADD_EXC_MSG('OKL_INVOICE_FORMATS_PUB','validate_invoice_formats');
830: FND_MSG_PUB.count_and_get(
831: p_count => x_msg_count
832: ,p_data => x_msg_data);
833: END validate_invoice_formats;
834: