DBA Data[Home] [Help]

APPS.OKL_REMARKETING_COSTS_PUB dependencies on FND_MSG_PUB

Line 86: FND_MSG_PUB.count_and_get(

82: ROLLBACK TO remarketing_costs_insert;
83: x_return_status := FND_API.G_RET_STS_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 FND_API.G_EXC_UNEXPECTED_ERROR THEN
90: ROLLBACK TO remarketing_costs_insert;

Line 94: FND_MSG_PUB.count_and_get(

90: ROLLBACK TO remarketing_costs_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.count_and_get(
95: p_count => x_msg_count
96: ,p_data => x_msg_data);
97: WHEN OTHERS THEN
98: ROLLBACK TO remarketing_costs_insert;

Line 102: FND_MSG_PUB.ADD_EXC_MSG('OKL_remarketing_COSTS_PUB','insert_remarketing_costs');

98: ROLLBACK TO remarketing_costs_insert;
99: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
100: x_msg_count := l_msg_count ;
101: x_msg_data := l_msg_data ;
102: FND_MSG_PUB.ADD_EXC_MSG('OKL_remarketing_COSTS_PUB','insert_remarketing_costs');
103: FND_MSG_PUB.count_and_get(
104: p_count => x_msg_count
105: ,p_data => x_msg_data);
106: END insert_remarketing_costs;

Line 103: FND_MSG_PUB.count_and_get(

99: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
100: x_msg_count := l_msg_count ;
101: x_msg_data := l_msg_data ;
102: FND_MSG_PUB.ADD_EXC_MSG('OKL_remarketing_COSTS_PUB','insert_remarketing_costs');
103: FND_MSG_PUB.count_and_get(
104: p_count => x_msg_count
105: ,p_data => x_msg_data);
106: END insert_remarketing_costs;
107:

Line 184: FND_MSG_PUB.count_and_get(

180: ROLLBACK TO remarketing_costs_insert;
181: x_return_status := FND_API.G_RET_STS_ERROR;
182: x_msg_count := l_msg_count ;
183: x_msg_data := l_msg_data ;
184: FND_MSG_PUB.count_and_get(
185: p_count => x_msg_count
186: ,p_data => x_msg_data);
187: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
188: ROLLBACK TO remarketing_costs_insert;

Line 192: FND_MSG_PUB.count_and_get(

188: ROLLBACK TO remarketing_costs_insert;
189: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
190: x_msg_count := l_msg_count ;
191: x_msg_data := l_msg_data ;
192: FND_MSG_PUB.count_and_get(
193: p_count => x_msg_count
194: ,p_data => x_msg_data);
195: WHEN OTHERS THEN
196: ROLLBACK TO remarketing_costs_insert;

Line 200: FND_MSG_PUB.ADD_EXC_MSG('OKL_remarketing_COSTS_PUB','insert_remarketing_costs');

196: ROLLBACK TO remarketing_costs_insert;
197: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
198: x_msg_count := l_msg_count ;
199: x_msg_data := l_msg_data ;
200: FND_MSG_PUB.ADD_EXC_MSG('OKL_remarketing_COSTS_PUB','insert_remarketing_costs');
201: FND_MSG_PUB.count_and_get(
202: p_count => x_msg_count
203: ,p_data => x_msg_data);
204: END insert_remarketing_costs;

Line 201: FND_MSG_PUB.count_and_get(

197: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
198: x_msg_count := l_msg_count ;
199: x_msg_data := l_msg_data ;
200: FND_MSG_PUB.ADD_EXC_MSG('OKL_remarketing_COSTS_PUB','insert_remarketing_costs');
201: FND_MSG_PUB.count_and_get(
202: p_count => x_msg_count
203: ,p_data => x_msg_data);
204: END insert_remarketing_costs;
205:

Line 233: FND_MSG_PUB.count_and_get(

229:
230: EXCEPTION
231:
232: WHEN FND_API.G_EXC_ERROR THEN
233: FND_MSG_PUB.count_and_get(
234: p_count => x_msg_count
235: ,p_data => x_msg_data);
236: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
237: FND_MSG_PUB.count_and_get(

Line 237: FND_MSG_PUB.count_and_get(

233: FND_MSG_PUB.count_and_get(
234: p_count => x_msg_count
235: ,p_data => x_msg_data);
236: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
237: FND_MSG_PUB.count_and_get(
238: p_count => x_msg_count
239: ,p_data => x_msg_data);
240: WHEN OTHERS THEN
241: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 242: FND_MSG_PUB.ADD_EXC_MSG('OKL_remarketing_COSTS_PUB','lock_remarketing_costs');

238: p_count => x_msg_count
239: ,p_data => x_msg_data);
240: WHEN OTHERS THEN
241: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
242: FND_MSG_PUB.ADD_EXC_MSG('OKL_remarketing_COSTS_PUB','lock_remarketing_costs');
243: FND_MSG_PUB.count_and_get(
244: p_count => x_msg_count
245: ,p_data => x_msg_data);
246: END lock_remarketing_costs;

Line 243: FND_MSG_PUB.count_and_get(

239: ,p_data => x_msg_data);
240: WHEN OTHERS THEN
241: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
242: FND_MSG_PUB.ADD_EXC_MSG('OKL_remarketing_COSTS_PUB','lock_remarketing_costs');
243: FND_MSG_PUB.count_and_get(
244: p_count => x_msg_count
245: ,p_data => x_msg_data);
246: END lock_remarketing_costs;
247:

Line 275: FND_MSG_PUB.count_and_get(

271:
272: EXCEPTION
273:
274: WHEN FND_API.G_EXC_ERROR THEN
275: FND_MSG_PUB.count_and_get(
276: p_count => x_msg_count
277: ,p_data => x_msg_data);
278: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
279: FND_MSG_PUB.count_and_get(

Line 279: FND_MSG_PUB.count_and_get(

275: FND_MSG_PUB.count_and_get(
276: p_count => x_msg_count
277: ,p_data => x_msg_data);
278: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
279: FND_MSG_PUB.count_and_get(
280: p_count => x_msg_count
281: ,p_data => x_msg_data);
282: WHEN OTHERS THEN
283: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 284: FND_MSG_PUB.ADD_EXC_MSG('OKL_remarketing_COSTS_PUB','lock_remarketing_costs');

280: p_count => x_msg_count
281: ,p_data => x_msg_data);
282: WHEN OTHERS THEN
283: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
284: FND_MSG_PUB.ADD_EXC_MSG('OKL_remarketing_COSTS_PUB','lock_remarketing_costs');
285: FND_MSG_PUB.count_and_get(
286: p_count => x_msg_count
287: ,p_data => x_msg_data);
288: END lock_remarketing_costs;

Line 285: FND_MSG_PUB.count_and_get(

281: ,p_data => x_msg_data);
282: WHEN OTHERS THEN
283: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
284: FND_MSG_PUB.ADD_EXC_MSG('OKL_remarketing_COSTS_PUB','lock_remarketing_costs');
285: FND_MSG_PUB.count_and_get(
286: p_count => x_msg_count
287: ,p_data => x_msg_data);
288: END lock_remarketing_costs;
289:

Line 366: FND_MSG_PUB.count_and_get(

362: ROLLBACK TO remarketing_costs_update;
363: x_return_status := FND_API.G_RET_STS_ERROR;
364: x_msg_count := l_msg_count ;
365: x_msg_data := l_msg_data ;
366: FND_MSG_PUB.count_and_get(
367: p_count => x_msg_count
368: ,p_data => x_msg_data);
369: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
370: ROLLBACK TO remarketing_costs_update;

Line 374: FND_MSG_PUB.count_and_get(

370: ROLLBACK TO remarketing_costs_update;
371: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
372: x_msg_count := l_msg_count ;
373: x_msg_data := l_msg_data ;
374: FND_MSG_PUB.count_and_get(
375: p_count => x_msg_count
376: ,p_data => x_msg_data);
377: WHEN OTHERS THEN
378: ROLLBACK TO remarketing_costs_update;

Line 382: FND_MSG_PUB.ADD_EXC_MSG('OKL_remarketing_COSTS_PUB','update_remarketing_costs');

378: ROLLBACK TO remarketing_costs_update;
379: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
380: x_msg_count := l_msg_count ;
381: x_msg_data := l_msg_data ;
382: FND_MSG_PUB.ADD_EXC_MSG('OKL_remarketing_COSTS_PUB','update_remarketing_costs');
383: FND_MSG_PUB.count_and_get(
384: p_count => x_msg_count
385: ,p_data => x_msg_data);
386: END update_remarketing_costs;

Line 383: FND_MSG_PUB.count_and_get(

379: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
380: x_msg_count := l_msg_count ;
381: x_msg_data := l_msg_data ;
382: FND_MSG_PUB.ADD_EXC_MSG('OKL_remarketing_COSTS_PUB','update_remarketing_costs');
383: FND_MSG_PUB.count_and_get(
384: p_count => x_msg_count
385: ,p_data => x_msg_data);
386: END update_remarketing_costs;
387:

Line 464: FND_MSG_PUB.count_and_get(

460: ROLLBACK TO remarketing_costs_update;
461: x_return_status := FND_API.G_RET_STS_ERROR;
462: x_msg_count := l_msg_count ;
463: x_msg_data := l_msg_data ;
464: FND_MSG_PUB.count_and_get(
465: p_count => x_msg_count
466: ,p_data => x_msg_data);
467: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
468: ROLLBACK TO remarketing_costs_update;

Line 472: FND_MSG_PUB.count_and_get(

468: ROLLBACK TO remarketing_costs_update;
469: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
470: x_msg_count := l_msg_count ;
471: x_msg_data := l_msg_data ;
472: FND_MSG_PUB.count_and_get(
473: p_count => x_msg_count
474: ,p_data => x_msg_data);
475: WHEN OTHERS THEN
476: ROLLBACK TO remarketing_costs_update;

Line 480: FND_MSG_PUB.ADD_EXC_MSG('OKL_remarketing_COSTS_PUB','update_remarketing_costs');

476: ROLLBACK TO remarketing_costs_update;
477: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
478: x_msg_count := l_msg_count ;
479: x_msg_data := l_msg_data ;
480: FND_MSG_PUB.ADD_EXC_MSG('OKL_remarketing_COSTS_PUB','update_remarketing_costs');
481: FND_MSG_PUB.count_and_get(
482: p_count => x_msg_count
483: ,p_data => x_msg_data);
484: END update_remarketing_costs;

Line 481: FND_MSG_PUB.count_and_get(

477: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
478: x_msg_count := l_msg_count ;
479: x_msg_data := l_msg_data ;
480: FND_MSG_PUB.ADD_EXC_MSG('OKL_remarketing_COSTS_PUB','update_remarketing_costs');
481: FND_MSG_PUB.count_and_get(
482: p_count => x_msg_count
483: ,p_data => x_msg_data);
484: END update_remarketing_costs;
485:

Line 550: FND_MSG_PUB.count_and_get(

546: ROLLBACK TO remarketing_costs_delete_rec;
547: x_return_status := FND_API.G_RET_STS_ERROR;
548: x_msg_count := l_msg_count ;
549: x_msg_data := l_msg_data ;
550: FND_MSG_PUB.count_and_get(
551: p_count => x_msg_count
552: ,p_data => x_msg_data);
553: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
554: ROLLBACK TO remarketing_costs_delete_rec;

Line 558: FND_MSG_PUB.count_and_get(

554: ROLLBACK TO remarketing_costs_delete_rec;
555: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
556: x_msg_count := l_msg_count ;
557: x_msg_data := l_msg_data ;
558: FND_MSG_PUB.count_and_get(
559: p_count => x_msg_count
560: ,p_data => x_msg_data);
561: WHEN OTHERS THEN
562: ROLLBACK TO remarketing_costs_delete_rec;

Line 566: FND_MSG_PUB.ADD_EXC_MSG('OKL_remarketing_COSTS_PUB','delete_remarketing_costs');

562: ROLLBACK TO remarketing_costs_delete_rec;
563: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
564: x_msg_count := l_msg_count ;
565: x_msg_data := l_msg_data ;
566: FND_MSG_PUB.ADD_EXC_MSG('OKL_remarketing_COSTS_PUB','delete_remarketing_costs');
567: FND_MSG_PUB.count_and_get(
568: p_count => x_msg_count
569: ,p_data => x_msg_data);
570: END delete_remarketing_costs;

Line 567: FND_MSG_PUB.count_and_get(

563: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
564: x_msg_count := l_msg_count ;
565: x_msg_data := l_msg_data ;
566: FND_MSG_PUB.ADD_EXC_MSG('OKL_remarketing_COSTS_PUB','delete_remarketing_costs');
567: FND_MSG_PUB.count_and_get(
568: p_count => x_msg_count
569: ,p_data => x_msg_data);
570: END delete_remarketing_costs;
571:

Line 647: FND_MSG_PUB.count_and_get(

643: ROLLBACK TO remarketing_costs_delete_tbl;
644: x_return_status := FND_API.G_RET_STS_ERROR;
645: x_msg_count := l_msg_count ;
646: x_msg_data := l_msg_data ;
647: FND_MSG_PUB.count_and_get(
648: p_count => x_msg_count
649: ,p_data => x_msg_data);
650: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
651: ROLLBACK TO remarketing_costs_delete_tbl;

Line 655: FND_MSG_PUB.count_and_get(

651: ROLLBACK TO remarketing_costs_delete_tbl;
652: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
653: x_msg_count := l_msg_count ;
654: x_msg_data := l_msg_data ;
655: FND_MSG_PUB.count_and_get(
656: p_count => x_msg_count
657: ,p_data => x_msg_data);
658: WHEN OTHERS THEN
659: ROLLBACK TO remarketing_costs_delete_tbl;

Line 663: FND_MSG_PUB.ADD_EXC_MSG('OKL_remarketing_COSTS_PUB','delete_remarketing_costs');

659: ROLLBACK TO remarketing_costs_delete_tbl;
660: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
661: x_msg_count := l_msg_count ;
662: x_msg_data := l_msg_data ;
663: FND_MSG_PUB.ADD_EXC_MSG('OKL_remarketing_COSTS_PUB','delete_remarketing_costs');
664: FND_MSG_PUB.count_and_get(
665: p_count => x_msg_count
666: ,p_data => x_msg_data);
667: END delete_remarketing_costs;

Line 664: FND_MSG_PUB.count_and_get(

660: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
661: x_msg_count := l_msg_count ;
662: x_msg_data := l_msg_data ;
663: FND_MSG_PUB.ADD_EXC_MSG('OKL_remarketing_COSTS_PUB','delete_remarketing_costs');
664: FND_MSG_PUB.count_and_get(
665: p_count => x_msg_count
666: ,p_data => x_msg_data);
667: END delete_remarketing_costs;
668:

Line 737: FND_MSG_PUB.count_and_get(

733: ROLLBACK TO remarketing_costs_validate;
734: x_return_status := FND_API.G_RET_STS_ERROR;
735: x_msg_count := l_msg_count ;
736: x_msg_data := l_msg_data ;
737: FND_MSG_PUB.count_and_get(
738: p_count => x_msg_count
739: ,p_data => x_msg_data);
740: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
741: ROLLBACK TO remarketing_costs_validate;

Line 745: FND_MSG_PUB.count_and_get(

741: ROLLBACK TO remarketing_costs_validate;
742: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
743: x_msg_count := l_msg_count ;
744: x_msg_data := l_msg_data ;
745: FND_MSG_PUB.count_and_get(
746: p_count => x_msg_count
747: ,p_data => x_msg_data);
748: WHEN OTHERS THEN
749: ROLLBACK TO remarketing_costs_validate;

Line 753: FND_MSG_PUB.ADD_EXC_MSG('OKL_remarketing_COSTS_PUB','validate_rmrkting_costs');

749: ROLLBACK TO remarketing_costs_validate;
750: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
751: x_msg_count := l_msg_count ;
752: x_msg_data := l_msg_data ;
753: FND_MSG_PUB.ADD_EXC_MSG('OKL_remarketing_COSTS_PUB','validate_rmrkting_costs');
754: FND_MSG_PUB.count_and_get(
755: p_count => x_msg_count
756: ,p_data => x_msg_data);
757: END validate_rmrkting_costs;

Line 754: FND_MSG_PUB.count_and_get(

750: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
751: x_msg_count := l_msg_count ;
752: x_msg_data := l_msg_data ;
753: FND_MSG_PUB.ADD_EXC_MSG('OKL_remarketing_COSTS_PUB','validate_rmrkting_costs');
754: FND_MSG_PUB.count_and_get(
755: p_count => x_msg_count
756: ,p_data => x_msg_data);
757: END validate_rmrkting_costs;
758:

Line 822: FND_MSG_PUB.count_and_get(

818: ROLLBACK TO remarketing_costs_validate;
819: x_return_status := FND_API.G_RET_STS_ERROR;
820: x_msg_count := l_msg_count ;
821: x_msg_data := l_msg_data ;
822: FND_MSG_PUB.count_and_get(
823: p_count => x_msg_count
824: ,p_data => x_msg_data);
825: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
826: ROLLBACK TO remarketing_costs_validate;

Line 830: FND_MSG_PUB.count_and_get(

826: ROLLBACK TO remarketing_costs_validate;
827: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
828: x_msg_count := l_msg_count ;
829: x_msg_data := l_msg_data ;
830: FND_MSG_PUB.count_and_get(
831: p_count => x_msg_count
832: ,p_data => x_msg_data);
833: WHEN OTHERS THEN
834: ROLLBACK TO remarketing_costs_validate;

Line 838: FND_MSG_PUB.ADD_EXC_MSG('OKL_remarketing_COSTS_PUB','validate_rmrkting_costs');

834: ROLLBACK TO remarketing_costs_validate;
835: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
836: x_msg_count := l_msg_count ;
837: x_msg_data := l_msg_data ;
838: FND_MSG_PUB.ADD_EXC_MSG('OKL_remarketing_COSTS_PUB','validate_rmrkting_costs');
839: FND_MSG_PUB.count_and_get(
840: p_count => x_msg_count
841: ,p_data => x_msg_data);
842: END validate_rmrkting_costs;

Line 839: FND_MSG_PUB.count_and_get(

835: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
836: x_msg_count := l_msg_count ;
837: x_msg_data := l_msg_data ;
838: FND_MSG_PUB.ADD_EXC_MSG('OKL_remarketing_COSTS_PUB','validate_rmrkting_costs');
839: FND_MSG_PUB.count_and_get(
840: p_count => x_msg_count
841: ,p_data => x_msg_data);
842: END validate_rmrkting_costs;
843: