DBA Data[Home] [Help]

APPS.OKL_INS_POLICIES_PUB dependencies on FND_MSG_PUB

Line 59: FND_MSG_PUB.count_and_get(

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

Line 67: FND_MSG_PUB.count_and_get(

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

Line 75: FND_MSG_PUB.ADD_EXC_MSG('OKL_INS_POLICIES_PUB','insert_ins_policies');

71: ROLLBACK TO ins_policies_insert;
72: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
73: x_msg_count := l_msg_count ;
74: x_msg_data := l_msg_data ;
75: FND_MSG_PUB.ADD_EXC_MSG('OKL_INS_POLICIES_PUB','insert_ins_policies');
76: FND_MSG_PUB.count_and_get(
77: p_count => x_msg_count
78: ,p_data => x_msg_data);
79: END insert_ins_policies;

Line 76: FND_MSG_PUB.count_and_get(

72: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
73: x_msg_count := l_msg_count ;
74: x_msg_data := l_msg_data ;
75: FND_MSG_PUB.ADD_EXC_MSG('OKL_INS_POLICIES_PUB','insert_ins_policies');
76: FND_MSG_PUB.count_and_get(
77: p_count => x_msg_count
78: ,p_data => x_msg_data);
79: END insert_ins_policies;
80: PROCEDURE insert_ins_policies(

Line 133: FND_MSG_PUB.count_and_get(

129: ROLLBACK TO ins_policies_insert;
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_policies_insert;

Line 141: FND_MSG_PUB.count_and_get(

137: ROLLBACK TO ins_policies_insert;
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_policies_insert;

Line 149: FND_MSG_PUB.ADD_EXC_MSG('OKL_INS_POLICIES_PUB','insert_ins_policies');

145: ROLLBACK TO ins_policies_insert;
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_POLICIES_PUB','insert_ins_policies');
150: FND_MSG_PUB.count_and_get(
151: p_count => x_msg_count
152: ,p_data => x_msg_data);
153: END insert_ins_policies;

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_POLICIES_PUB','insert_ins_policies');
150: FND_MSG_PUB.count_and_get(
151: p_count => x_msg_count
152: ,p_data => x_msg_data);
153: END insert_ins_policies;
154: PROCEDURE lock_ins_policies(

Line 176: FND_MSG_PUB.count_and_get(

172: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
173: END IF;
174: EXCEPTION
175: WHEN FND_API.G_EXC_ERROR THEN
176: FND_MSG_PUB.count_and_get(
177: p_count => x_msg_count
178: ,p_data => x_msg_data);
179: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
180: FND_MSG_PUB.count_and_get(

Line 180: FND_MSG_PUB.count_and_get(

176: FND_MSG_PUB.count_and_get(
177: p_count => x_msg_count
178: ,p_data => x_msg_data);
179: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
180: FND_MSG_PUB.count_and_get(
181: p_count => x_msg_count
182: ,p_data => x_msg_data);
183: WHEN OTHERS THEN
184: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 185: FND_MSG_PUB.ADD_EXC_MSG('OKL_INS_POLICIES_PUB','lock_ins_policies');

181: p_count => x_msg_count
182: ,p_data => x_msg_data);
183: WHEN OTHERS THEN
184: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
185: FND_MSG_PUB.ADD_EXC_MSG('OKL_INS_POLICIES_PUB','lock_ins_policies');
186: FND_MSG_PUB.count_and_get(
187: p_count => x_msg_count
188: ,p_data => x_msg_data);
189: END lock_ins_policies;

Line 186: FND_MSG_PUB.count_and_get(

182: ,p_data => x_msg_data);
183: WHEN OTHERS THEN
184: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
185: FND_MSG_PUB.ADD_EXC_MSG('OKL_INS_POLICIES_PUB','lock_ins_policies');
186: FND_MSG_PUB.count_and_get(
187: p_count => x_msg_count
188: ,p_data => x_msg_data);
189: END lock_ins_policies;
190: PROCEDURE lock_ins_policies(

Line 212: FND_MSG_PUB.count_and_get(

208: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
209: END IF;
210: EXCEPTION
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_POLICIES_PUB','lock_ins_policies');

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

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_POLICIES_PUB','lock_ins_policies');
222: FND_MSG_PUB.count_and_get(
223: p_count => x_msg_count
224: ,p_data => x_msg_data);
225: END lock_ins_policies;
226: PROCEDURE update_ins_policies(

Line 276: FND_MSG_PUB.count_and_get(

272: ROLLBACK TO ins_policies_update;
273: x_return_status := FND_API.G_RET_STS_ERROR;
274: x_msg_count := l_msg_count ;
275: x_msg_data := l_msg_data ;
276: FND_MSG_PUB.count_and_get(
277: p_count => x_msg_count
278: ,p_data => x_msg_data);
279: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
280: ROLLBACK TO ins_policies_update;

Line 284: FND_MSG_PUB.count_and_get(

280: ROLLBACK TO ins_policies_update;
281: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
282: x_msg_count := l_msg_count ;
283: x_msg_data := l_msg_data ;
284: FND_MSG_PUB.count_and_get(
285: p_count => x_msg_count
286: ,p_data => x_msg_data);
287: WHEN OTHERS THEN
288: ROLLBACK TO ins_policies_update;

Line 292: FND_MSG_PUB.ADD_EXC_MSG('OKL_INS_POLICIES_PUB','update_ins_policies');

288: ROLLBACK TO ins_policies_update;
289: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
290: x_msg_count := l_msg_count ;
291: x_msg_data := l_msg_data ;
292: FND_MSG_PUB.ADD_EXC_MSG('OKL_INS_POLICIES_PUB','update_ins_policies');
293: FND_MSG_PUB.count_and_get(
294: p_count => x_msg_count
295: ,p_data => x_msg_data);
296: END update_ins_policies;

Line 293: FND_MSG_PUB.count_and_get(

289: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
290: x_msg_count := l_msg_count ;
291: x_msg_data := l_msg_data ;
292: FND_MSG_PUB.ADD_EXC_MSG('OKL_INS_POLICIES_PUB','update_ins_policies');
293: FND_MSG_PUB.count_and_get(
294: p_count => x_msg_count
295: ,p_data => x_msg_data);
296: END update_ins_policies;
297: PROCEDURE update_ins_policies(

Line 346: FND_MSG_PUB.count_and_get(

342: ROLLBACK TO ins_policies_update;
343: x_return_status := FND_API.G_RET_STS_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 FND_API.G_EXC_UNEXPECTED_ERROR THEN
350: ROLLBACK TO ins_policies_update;

Line 354: FND_MSG_PUB.count_and_get(

350: ROLLBACK TO ins_policies_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.count_and_get(
355: p_count => x_msg_count
356: ,p_data => x_msg_data);
357: WHEN OTHERS THEN
358: ROLLBACK TO ins_policies_update;

Line 362: FND_MSG_PUB.ADD_EXC_MSG('OKL_INS_POLICIES_PUB','update_ins_policies');

358: ROLLBACK TO ins_policies_update;
359: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
360: x_msg_count := l_msg_count ;
361: x_msg_data := l_msg_data ;
362: FND_MSG_PUB.ADD_EXC_MSG('OKL_INS_POLICIES_PUB','update_ins_policies');
363: FND_MSG_PUB.count_and_get(
364: p_count => x_msg_count
365: ,p_data => x_msg_data);
366: END update_ins_policies;

Line 363: FND_MSG_PUB.count_and_get(

359: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
360: x_msg_count := l_msg_count ;
361: x_msg_data := l_msg_data ;
362: FND_MSG_PUB.ADD_EXC_MSG('OKL_INS_POLICIES_PUB','update_ins_policies');
363: FND_MSG_PUB.count_and_get(
364: p_count => x_msg_count
365: ,p_data => x_msg_data);
366: END update_ins_policies;
367: --Put custom code for cascade delete by developer

Line 414: FND_MSG_PUB.count_and_get(

410: ROLLBACK TO ins_policies_delete_rec;
411: x_return_status := FND_API.G_RET_STS_ERROR;
412: x_msg_count := l_msg_count ;
413: x_msg_data := l_msg_data ;
414: FND_MSG_PUB.count_and_get(
415: p_count => x_msg_count
416: ,p_data => x_msg_data);
417: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
418: ROLLBACK TO ins_policies_delete_rec;

Line 422: FND_MSG_PUB.count_and_get(

418: ROLLBACK TO ins_policies_delete_rec;
419: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
420: x_msg_count := l_msg_count ;
421: x_msg_data := l_msg_data ;
422: FND_MSG_PUB.count_and_get(
423: p_count => x_msg_count
424: ,p_data => x_msg_data);
425: WHEN OTHERS THEN
426: ROLLBACK TO ins_policies_delete_rec;

Line 430: FND_MSG_PUB.ADD_EXC_MSG('OKL_INS_POLICIES_PUB','delete_ins_policies');

426: ROLLBACK TO ins_policies_delete_rec;
427: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
428: x_msg_count := l_msg_count ;
429: x_msg_data := l_msg_data ;
430: FND_MSG_PUB.ADD_EXC_MSG('OKL_INS_POLICIES_PUB','delete_ins_policies');
431: FND_MSG_PUB.count_and_get(
432: p_count => x_msg_count
433: ,p_data => x_msg_data);
434: END delete_ins_policies;

Line 431: FND_MSG_PUB.count_and_get(

427: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
428: x_msg_count := l_msg_count ;
429: x_msg_data := l_msg_data ;
430: FND_MSG_PUB.ADD_EXC_MSG('OKL_INS_POLICIES_PUB','delete_ins_policies');
431: FND_MSG_PUB.count_and_get(
432: p_count => x_msg_count
433: ,p_data => x_msg_data);
434: END delete_ins_policies;
435: PROCEDURE delete_ins_policies(

Line 491: FND_MSG_PUB.count_and_get(

487: ROLLBACK TO ins_policies_delete_tbl;
488: x_return_status := FND_API.G_RET_STS_ERROR;
489: x_msg_count := l_msg_count ;
490: x_msg_data := l_msg_data ;
491: FND_MSG_PUB.count_and_get(
492: p_count => x_msg_count
493: ,p_data => x_msg_data);
494: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
495: ROLLBACK TO ins_policies_delete_tbl;

Line 499: FND_MSG_PUB.count_and_get(

495: ROLLBACK TO ins_policies_delete_tbl;
496: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
497: x_msg_count := l_msg_count ;
498: x_msg_data := l_msg_data ;
499: FND_MSG_PUB.count_and_get(
500: p_count => x_msg_count
501: ,p_data => x_msg_data);
502: WHEN OTHERS THEN
503: ROLLBACK TO ins_policies_delete_tbl;

Line 507: FND_MSG_PUB.ADD_EXC_MSG('OKL_INS_POLICIES_PUB','delete_ins_policies');

503: ROLLBACK TO ins_policies_delete_tbl;
504: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
505: x_msg_count := l_msg_count ;
506: x_msg_data := l_msg_data ;
507: FND_MSG_PUB.ADD_EXC_MSG('OKL_INS_POLICIES_PUB','delete_ins_policies');
508: FND_MSG_PUB.count_and_get(
509: p_count => x_msg_count
510: ,p_data => x_msg_data);
511: END delete_ins_policies;

Line 508: FND_MSG_PUB.count_and_get(

504: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
505: x_msg_count := l_msg_count ;
506: x_msg_data := l_msg_data ;
507: FND_MSG_PUB.ADD_EXC_MSG('OKL_INS_POLICIES_PUB','delete_ins_policies');
508: FND_MSG_PUB.count_and_get(
509: p_count => x_msg_count
510: ,p_data => x_msg_data);
511: END delete_ins_policies;
512: PROCEDURE validate_ins_policies(

Line 558: FND_MSG_PUB.count_and_get(

554: ROLLBACK TO ins_policies_validate;
555: x_return_status := FND_API.G_RET_STS_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 FND_API.G_EXC_UNEXPECTED_ERROR THEN
562: ROLLBACK TO ins_policies_validate;

Line 566: FND_MSG_PUB.count_and_get(

562: ROLLBACK TO ins_policies_validate;
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.count_and_get(
567: p_count => x_msg_count
568: ,p_data => x_msg_data);
569: WHEN OTHERS THEN
570: ROLLBACK TO ins_policies_validate;

Line 574: FND_MSG_PUB.ADD_EXC_MSG('OKL_INS_POLICIES_PUB','validate_ins_policies');

570: ROLLBACK TO ins_policies_validate;
571: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
572: x_msg_count := l_msg_count ;
573: x_msg_data := l_msg_data ;
574: FND_MSG_PUB.ADD_EXC_MSG('OKL_INS_POLICIES_PUB','validate_ins_policies');
575: FND_MSG_PUB.count_and_get(
576: p_count => x_msg_count
577: ,p_data => x_msg_data);
578: END validate_ins_policies;

Line 575: FND_MSG_PUB.count_and_get(

571: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
572: x_msg_count := l_msg_count ;
573: x_msg_data := l_msg_data ;
574: FND_MSG_PUB.ADD_EXC_MSG('OKL_INS_POLICIES_PUB','validate_ins_policies');
575: FND_MSG_PUB.count_and_get(
576: p_count => x_msg_count
577: ,p_data => x_msg_data);
578: END validate_ins_policies;
579: PROCEDURE validate_ins_policies(

Line 625: FND_MSG_PUB.count_and_get(

621: ROLLBACK TO ins_policies_validate;
622: x_return_status := FND_API.G_RET_STS_ERROR;
623: x_msg_count := l_msg_count ;
624: x_msg_data := l_msg_data ;
625: FND_MSG_PUB.count_and_get(
626: p_count => x_msg_count
627: ,p_data => x_msg_data);
628: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
629: ROLLBACK TO ins_policies_validate;

Line 633: FND_MSG_PUB.count_and_get(

629: ROLLBACK TO ins_policies_validate;
630: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
631: x_msg_count := l_msg_count ;
632: x_msg_data := l_msg_data ;
633: FND_MSG_PUB.count_and_get(
634: p_count => x_msg_count
635: ,p_data => x_msg_data);
636: WHEN OTHERS THEN
637: ROLLBACK TO ins_policies_validate;

Line 641: FND_MSG_PUB.ADD_EXC_MSG('OKL_INS_POLICIES_PUB','validate_ins_policies');

637: ROLLBACK TO ins_policies_validate;
638: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
639: x_msg_count := l_msg_count ;
640: x_msg_data := l_msg_data ;
641: FND_MSG_PUB.ADD_EXC_MSG('OKL_INS_POLICIES_PUB','validate_ins_policies');
642: FND_MSG_PUB.count_and_get(
643: p_count => x_msg_count
644: ,p_data => x_msg_data);
645: END validate_ins_policies;

Line 642: FND_MSG_PUB.count_and_get(

638: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
639: x_msg_count := l_msg_count ;
640: x_msg_data := l_msg_data ;
641: FND_MSG_PUB.ADD_EXC_MSG('OKL_INS_POLICIES_PUB','validate_ins_policies');
642: FND_MSG_PUB.count_and_get(
643: p_count => x_msg_count
644: ,p_data => x_msg_data);
645: END validate_ins_policies;
646: END OKL_INS_POLICIES_PUB;