DBA Data[Home] [Help]

APPS.OKL_INS_QUOTE_PUB dependencies on FND_MSG_PUB

Line 61: FND_MSG_PUB.count_and_get(

57: ROLLBACK TO ins_save_quote;
58: x_return_status := FND_API.G_RET_STS_ERROR;
59: x_msg_count := l_msg_count ;
60: x_msg_data := l_msg_data ;
61: FND_MSG_PUB.count_and_get(
62: p_count => x_msg_count
63: ,p_data => x_msg_data);
64: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
65: ROLLBACK TO ins_save_quote;

Line 69: FND_MSG_PUB.count_and_get(

65: ROLLBACK TO ins_save_quote;
66: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
67: x_msg_count := l_msg_count ;
68: x_msg_data := l_msg_data ;
69: FND_MSG_PUB.count_and_get(
70: p_count => x_msg_count
71: ,p_data => x_msg_data);
72: WHEN OTHERS THEN
73: ROLLBACK TO ins_save_quote;

Line 77: FND_MSG_PUB.ADD_EXC_MSG('OKL_INS_QUOTE_PUB','save_quote');

73: ROLLBACK TO ins_save_quote;
74: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
75: x_msg_count := l_msg_count ;
76: x_msg_data := l_msg_data ;
77: FND_MSG_PUB.ADD_EXC_MSG('OKL_INS_QUOTE_PUB','save_quote');
78: FND_MSG_PUB.count_and_get(
79: p_count => x_msg_count
80: ,p_data => x_msg_data);
81: END save_quote ;

Line 78: FND_MSG_PUB.count_and_get(

74: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
75: x_msg_count := l_msg_count ;
76: x_msg_data := l_msg_data ;
77: FND_MSG_PUB.ADD_EXC_MSG('OKL_INS_QUOTE_PUB','save_quote');
78: FND_MSG_PUB.count_and_get(
79: p_count => x_msg_count
80: ,p_data => x_msg_data);
81: END save_quote ;
82:

Line 133: FND_MSG_PUB.count_and_get(

129: ROLLBACK TO ins_save_accept_quote;
130: x_return_status := FND_API.G_RET_STS_ERROR;
131: x_msg_count := l_msg_count ;
132: x_msg_data := l_msg_data ;
133: FND_MSG_PUB.count_and_get(
134: p_count => x_msg_count
135: ,p_data => x_msg_data);
136: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
137: ROLLBACK TO ins_save_accept_quote;

Line 141: FND_MSG_PUB.count_and_get(

137: ROLLBACK TO ins_save_accept_quote;
138: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
139: x_msg_count := l_msg_count ;
140: x_msg_data := l_msg_data ;
141: FND_MSG_PUB.count_and_get(
142: p_count => x_msg_count
143: ,p_data => x_msg_data);
144: WHEN OTHERS THEN
145: ROLLBACK TO ins_save_accept_quote;

Line 149: FND_MSG_PUB.ADD_EXC_MSG('OKL_INS_QUOTE_PUB','save_accept_quote');

145: ROLLBACK TO ins_save_accept_quote;
146: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
147: x_msg_count := l_msg_count ;
148: x_msg_data := l_msg_data ;
149: FND_MSG_PUB.ADD_EXC_MSG('OKL_INS_QUOTE_PUB','save_accept_quote');
150: FND_MSG_PUB.count_and_get(
151: p_count => x_msg_count
152: ,p_data => x_msg_data);
153: END save_accept_quote ;

Line 150: FND_MSG_PUB.count_and_get(

146: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
147: x_msg_count := l_msg_count ;
148: x_msg_data := l_msg_data ;
149: FND_MSG_PUB.ADD_EXC_MSG('OKL_INS_QUOTE_PUB','save_accept_quote');
150: FND_MSG_PUB.count_and_get(
151: p_count => x_msg_count
152: ,p_data => x_msg_data);
153: END save_accept_quote ;
154:

Line 201: FND_MSG_PUB.count_and_get(

197: ROLLBACK TO ins_accept_quote;
198: x_return_status := FND_API.G_RET_STS_ERROR;
199: x_msg_count := l_msg_count ;
200: x_msg_data := l_msg_data ;
201: FND_MSG_PUB.count_and_get(
202: p_count => x_msg_count
203: ,p_data => x_msg_data);
204: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
205: ROLLBACK TO ins_accept_quote;

Line 209: FND_MSG_PUB.count_and_get(

205: ROLLBACK TO ins_accept_quote;
206: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
207: x_msg_count := l_msg_count ;
208: x_msg_data := l_msg_data ;
209: FND_MSG_PUB.count_and_get(
210: p_count => x_msg_count
211: ,p_data => x_msg_data);
212: WHEN OTHERS THEN
213: ROLLBACK TO ins_accept_quote;

Line 217: FND_MSG_PUB.ADD_EXC_MSG('OKL_INS_QUOTE_PUB','accept_quote');

213: ROLLBACK TO ins_accept_quote;
214: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
215: x_msg_count := l_msg_count ;
216: x_msg_data := l_msg_data ;
217: FND_MSG_PUB.ADD_EXC_MSG('OKL_INS_QUOTE_PUB','accept_quote');
218: FND_MSG_PUB.count_and_get(
219: p_count => x_msg_count
220: ,p_data => x_msg_data);
221: END accept_quote;

Line 218: FND_MSG_PUB.count_and_get(

214: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
215: x_msg_count := l_msg_count ;
216: x_msg_data := l_msg_data ;
217: FND_MSG_PUB.ADD_EXC_MSG('OKL_INS_QUOTE_PUB','accept_quote');
218: FND_MSG_PUB.count_and_get(
219: p_count => x_msg_count
220: ,p_data => x_msg_data);
221: END accept_quote;
222:

Line 272: FND_MSG_PUB.count_and_get(

268: ROLLBACK TO ins_create_ins_streams;
269: x_return_status := FND_API.G_RET_STS_ERROR;
270: x_msg_count := l_msg_count ;
271: x_msg_data := l_msg_data ;
272: FND_MSG_PUB.count_and_get(
273: p_count => x_msg_count
274: ,p_data => x_msg_data);
275: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
276: ROLLBACK TO ins_create_ins_streams;

Line 280: FND_MSG_PUB.count_and_get(

276: ROLLBACK TO ins_create_ins_streams;
277: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
278: x_msg_count := l_msg_count ;
279: x_msg_data := l_msg_data ;
280: FND_MSG_PUB.count_and_get(
281: p_count => x_msg_count
282: ,p_data => x_msg_data);
283: WHEN OTHERS THEN
284: ROLLBACK TO ins_create_ins_streams;

Line 288: FND_MSG_PUB.ADD_EXC_MSG('OKL_INS_QUOTE_PUB','create_ins_streams');

284: ROLLBACK TO ins_create_ins_streams;
285: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
286: x_msg_count := l_msg_count ;
287: x_msg_data := l_msg_data ;
288: FND_MSG_PUB.ADD_EXC_MSG('OKL_INS_QUOTE_PUB','create_ins_streams');
289: FND_MSG_PUB.count_and_get(
290: p_count => x_msg_count
291: ,p_data => x_msg_data);
292: END create_ins_streams ;

Line 289: FND_MSG_PUB.count_and_get(

285: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
286: x_msg_count := l_msg_count ;
287: x_msg_data := l_msg_data ;
288: FND_MSG_PUB.ADD_EXC_MSG('OKL_INS_QUOTE_PUB','create_ins_streams');
289: FND_MSG_PUB.count_and_get(
290: p_count => x_msg_count
291: ,p_data => x_msg_data);
292: END create_ins_streams ;
293:

Line 348: FND_MSG_PUB.count_and_get(

344: ROLLBACK TO ins_calc_lease_premium;
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 ins_calc_lease_premium;

Line 356: FND_MSG_PUB.count_and_get(

352: ROLLBACK TO ins_calc_lease_premium;
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 ins_calc_lease_premium;

Line 364: FND_MSG_PUB.ADD_EXC_MSG('OKL_INS_QUOTE_PUB','calc_lease_premium');

360: ROLLBACK TO ins_calc_lease_premium;
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_INS_QUOTE_PUB','calc_lease_premium');
365: FND_MSG_PUB.count_and_get(
366: p_count => x_msg_count
367: ,p_data => x_msg_data);
368: END calc_lease_premium ;

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_INS_QUOTE_PUB','calc_lease_premium');
365: FND_MSG_PUB.count_and_get(
366: p_count => x_msg_count
367: ,p_data => x_msg_data);
368: END calc_lease_premium ;
369:

Line 420: FND_MSG_PUB.count_and_get(

416: ROLLBACK TO ins_activate_ins_stream;
417: x_return_status := FND_API.G_RET_STS_ERROR;
418: x_msg_count := l_msg_count ;
419: x_msg_data := l_msg_data ;
420: FND_MSG_PUB.count_and_get(
421: p_count => x_msg_count
422: ,p_data => x_msg_data);
423: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
424: ROLLBACK TO ins_activate_ins_stream;

Line 428: FND_MSG_PUB.count_and_get(

424: ROLLBACK TO ins_activate_ins_stream;
425: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
426: x_msg_count := l_msg_count ;
427: x_msg_data := l_msg_data ;
428: FND_MSG_PUB.count_and_get(
429: p_count => x_msg_count
430: ,p_data => x_msg_data);
431: WHEN OTHERS THEN
432: ROLLBACK TO ins_activate_ins_stream;

Line 436: FND_MSG_PUB.ADD_EXC_MSG('OKL_INS_QUOTE_PUB','activate_ins_stream');

432: ROLLBACK TO ins_activate_ins_stream;
433: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
434: x_msg_count := l_msg_count ;
435: x_msg_data := l_msg_data ;
436: FND_MSG_PUB.ADD_EXC_MSG('OKL_INS_QUOTE_PUB','activate_ins_stream');
437: FND_MSG_PUB.count_and_get(
438: p_count => x_msg_count
439: ,p_data => x_msg_data);
440: END activate_ins_stream;

Line 437: FND_MSG_PUB.count_and_get(

433: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
434: x_msg_count := l_msg_count ;
435: x_msg_data := l_msg_data ;
436: FND_MSG_PUB.ADD_EXC_MSG('OKL_INS_QUOTE_PUB','activate_ins_stream');
437: FND_MSG_PUB.count_and_get(
438: p_count => x_msg_count
439: ,p_data => x_msg_data);
440: END activate_ins_stream;
441:

Line 500: FND_MSG_PUB.count_and_get(

496: ROLLBACK TO activate_ins_streams;
497: x_return_status := FND_API.G_RET_STS_ERROR;
498: x_msg_count := l_msg_count ;
499: x_msg_data := l_msg_data ;
500: FND_MSG_PUB.count_and_get(
501: p_count => x_msg_count
502: ,p_data => x_msg_data);
503: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
504: ROLLBACK TO activate_ins_streams;

Line 508: FND_MSG_PUB.count_and_get(

504: ROLLBACK TO activate_ins_streams;
505: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
506: x_msg_count := l_msg_count ;
507: x_msg_data := l_msg_data ;
508: FND_MSG_PUB.count_and_get(
509: p_count => x_msg_count
510: ,p_data => x_msg_data);
511: WHEN OTHERS THEN
512: ROLLBACK TO activate_ins_streams;

Line 516: FND_MSG_PUB.ADD_EXC_MSG('OKL_INS_QUOTE_PUB','activate_ins_streams');

512: ROLLBACK TO activate_ins_streams;
513: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
514: x_msg_count := l_msg_count ;
515: x_msg_data := l_msg_data ;
516: FND_MSG_PUB.ADD_EXC_MSG('OKL_INS_QUOTE_PUB','activate_ins_streams');
517: FND_MSG_PUB.count_and_get(
518: p_count => x_msg_count
519: ,p_data => x_msg_data);
520: END activate_ins_streams;

Line 517: FND_MSG_PUB.count_and_get(

513: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
514: x_msg_count := l_msg_count ;
515: x_msg_data := l_msg_data ;
516: FND_MSG_PUB.ADD_EXC_MSG('OKL_INS_QUOTE_PUB','activate_ins_streams');
517: FND_MSG_PUB.count_and_get(
518: p_count => x_msg_count
519: ,p_data => x_msg_data);
520: END activate_ins_streams;
521:

Line 568: FND_MSG_PUB.count_and_get(

564: ROLLBACK TO activate_ins_policy;
565: x_return_status := FND_API.G_RET_STS_ERROR;
566: x_msg_count := l_msg_count ;
567: x_msg_data := l_msg_data ;
568: FND_MSG_PUB.count_and_get(
569: p_count => x_msg_count
570: ,p_data => x_msg_data);
571: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
572: ROLLBACK TO activate_ins_policy;

Line 576: FND_MSG_PUB.count_and_get(

572: ROLLBACK TO activate_ins_policy;
573: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
574: x_msg_count := l_msg_count ;
575: x_msg_data := l_msg_data ;
576: FND_MSG_PUB.count_and_get(
577: p_count => x_msg_count
578: ,p_data => x_msg_data);
579: WHEN OTHERS THEN
580: ROLLBACK TO activate_ins_policy;

Line 584: FND_MSG_PUB.ADD_EXC_MSG('OKL_INS_QUOTE_PUB','activate_ins_policy');

580: ROLLBACK TO activate_ins_policy;
581: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
582: x_msg_count := l_msg_count ;
583: x_msg_data := l_msg_data ;
584: FND_MSG_PUB.ADD_EXC_MSG('OKL_INS_QUOTE_PUB','activate_ins_policy');
585: FND_MSG_PUB.count_and_get(
586: p_count => x_msg_count
587: ,p_data => x_msg_data);
588: END activate_ins_policy;

Line 585: FND_MSG_PUB.count_and_get(

581: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
582: x_msg_count := l_msg_count ;
583: x_msg_data := l_msg_data ;
584: FND_MSG_PUB.ADD_EXC_MSG('OKL_INS_QUOTE_PUB','activate_ins_policy');
585: FND_MSG_PUB.count_and_get(
586: p_count => x_msg_count
587: ,p_data => x_msg_data);
588: END activate_ins_policy;
589:

Line 645: FND_MSG_PUB.count_and_get(

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

Line 653: FND_MSG_PUB.count_and_get(

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

Line 661: FND_MSG_PUB.ADD_EXC_MSG('OKL_INS_QUOTE_PUB','calc_optional_premium');

657: ROLLBACK TO ins_calc_optional_premium;
658: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
659: x_msg_count := l_msg_count ;
660: x_msg_data := l_msg_data ;
661: FND_MSG_PUB.ADD_EXC_MSG('OKL_INS_QUOTE_PUB','calc_optional_premium');
662: FND_MSG_PUB.count_and_get(
663: p_count => x_msg_count
664: ,p_data => x_msg_data);
665: END calc_optional_premium ;

Line 662: FND_MSG_PUB.count_and_get(

658: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
659: x_msg_count := l_msg_count ;
660: x_msg_data := l_msg_data ;
661: FND_MSG_PUB.ADD_EXC_MSG('OKL_INS_QUOTE_PUB','calc_optional_premium');
662: FND_MSG_PUB.count_and_get(
663: p_count => x_msg_count
664: ,p_data => x_msg_data);
665: END calc_optional_premium ;
666:

Line 729: FND_MSG_PUB.count_and_get(

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

Line 737: FND_MSG_PUB.count_and_get(

733: ROLLBACK TO ins_calc_total_premium;
734: x_return_status := FND_API.G_RET_STS_UNEXP_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 OTHERS THEN
741: ROLLBACK TO ins_calc_total_premium;

Line 745: FND_MSG_PUB.ADD_EXC_MSG('OKL_INS_QUOTE_PUB','calc_total_premium');

741: ROLLBACK TO ins_calc_total_premium;
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.ADD_EXC_MSG('OKL_INS_QUOTE_PUB','calc_total_premium');
746: FND_MSG_PUB.count_and_get(
747: p_count => x_msg_count
748: ,p_data => x_msg_data);
749: END calc_total_premium ;

Line 746: FND_MSG_PUB.count_and_get(

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.ADD_EXC_MSG('OKL_INS_QUOTE_PUB','calc_total_premium');
746: FND_MSG_PUB.count_and_get(
747: p_count => x_msg_count
748: ,p_data => x_msg_data);
749: END calc_total_premium ;
750: --------------------------

Line 803: FND_MSG_PUB.count_and_get(

799: ROLLBACK TO create_third_prt_ins;
800: x_return_status := FND_API.G_RET_STS_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 FND_API.G_EXC_UNEXPECTED_ERROR THEN
807: ROLLBACK TO create_third_prt_ins;

Line 811: FND_MSG_PUB.count_and_get(

807: ROLLBACK TO create_third_prt_ins;
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.count_and_get(
812: p_count => x_msg_count
813: ,p_data => x_msg_data);
814: WHEN OTHERS THEN
815: ROLLBACK TO create_third_prt_ins;

Line 819: FND_MSG_PUB.ADD_EXC_MSG('OKL_INS_QUOTE_PUB','create_third_prt_ins');

815: ROLLBACK TO create_third_prt_ins;
816: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
817: x_msg_count := l_msg_count ;
818: x_msg_data := l_msg_data ;
819: FND_MSG_PUB.ADD_EXC_MSG('OKL_INS_QUOTE_PUB','create_third_prt_ins');
820: FND_MSG_PUB.count_and_get(
821: p_count => x_msg_count
822: ,p_data => x_msg_data);
823: END create_third_prt_ins ;

Line 820: FND_MSG_PUB.count_and_get(

816: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
817: x_msg_count := l_msg_count ;
818: x_msg_data := l_msg_data ;
819: FND_MSG_PUB.ADD_EXC_MSG('OKL_INS_QUOTE_PUB','create_third_prt_ins');
820: FND_MSG_PUB.count_and_get(
821: p_count => x_msg_count
822: ,p_data => x_msg_data);
823: END create_third_prt_ins ;
824: -----------------------------------