DBA Data[Home] [Help]

APPS.OKL_INS_EXCLUSIONS_PUB dependencies on FND_MSG_PUB

Line 63: FND_MSG_PUB.count_and_get(

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

Line 72: FND_MSG_PUB.count_and_get(

68: ROLLBACK TO ins_exclusions_insert;
69: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
70: x_msg_count := l_msg_count ;
71: x_msg_data := l_msg_data ;
72: FND_MSG_PUB.count_and_get(
73: p_count => x_msg_count
74: ,p_data => x_msg_data);
75: WHEN OTHERS THEN
76: ROLLBACK TO ins_exclusions_insert;

Line 80: FND_MSG_PUB.ADD_EXC_MSG('OKL_INS_EXCLUSIONS_PUB','insert_ins_exclusions');

76: ROLLBACK TO ins_exclusions_insert;
77: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
78: x_msg_count := l_msg_count ;
79: x_msg_data := l_msg_data ;
80: FND_MSG_PUB.ADD_EXC_MSG('OKL_INS_EXCLUSIONS_PUB','insert_ins_exclusions');
81: FND_MSG_PUB.count_and_get(
82: p_count => x_msg_count
83: ,p_data => x_msg_data);
84: END insert_ins_exclusions;

Line 81: FND_MSG_PUB.count_and_get(

77: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
78: x_msg_count := l_msg_count ;
79: x_msg_data := l_msg_data ;
80: FND_MSG_PUB.ADD_EXC_MSG('OKL_INS_EXCLUSIONS_PUB','insert_ins_exclusions');
81: FND_MSG_PUB.count_and_get(
82: p_count => x_msg_count
83: ,p_data => x_msg_data);
84: END insert_ins_exclusions;
85: PROCEDURE insert_ins_exclusions(

Line 135: FND_MSG_PUB.count_and_get(

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

Line 143: FND_MSG_PUB.count_and_get(

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

Line 151: FND_MSG_PUB.ADD_EXC_MSG('OKL_INS_EXCLUSIONS_PUB','insert_ins_exclusions');

147: ROLLBACK TO ins_exclusions_insert;
148: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
149: x_msg_count := l_msg_count ;
150: x_msg_data := l_msg_data ;
151: FND_MSG_PUB.ADD_EXC_MSG('OKL_INS_EXCLUSIONS_PUB','insert_ins_exclusions');
152: FND_MSG_PUB.count_and_get(
153: p_count => x_msg_count
154: ,p_data => x_msg_data);
155: END insert_ins_exclusions;

Line 152: FND_MSG_PUB.count_and_get(

148: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
149: x_msg_count := l_msg_count ;
150: x_msg_data := l_msg_data ;
151: FND_MSG_PUB.ADD_EXC_MSG('OKL_INS_EXCLUSIONS_PUB','insert_ins_exclusions');
152: FND_MSG_PUB.count_and_get(
153: p_count => x_msg_count
154: ,p_data => x_msg_data);
155: END insert_ins_exclusions;
156: PROCEDURE lock_ins_exclusions(

Line 248: FND_MSG_PUB.count_and_get(

244: ROLLBACK TO ins_exclusions_update;
245: x_return_status := FND_API.G_RET_STS_ERROR;
246: x_msg_count := l_msg_count ;
247: x_msg_data := l_msg_data ;
248: FND_MSG_PUB.count_and_get(
249: p_count => x_msg_count
250: ,p_data => x_msg_data);
251: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
252: ROLLBACK TO ins_exclusions_update;

Line 256: FND_MSG_PUB.count_and_get(

252: ROLLBACK TO ins_exclusions_update;
253: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
254: x_msg_count := l_msg_count ;
255: x_msg_data := l_msg_data ;
256: FND_MSG_PUB.count_and_get(
257: p_count => x_msg_count
258: ,p_data => x_msg_data);
259: WHEN OTHERS THEN
260: ROLLBACK TO ins_exclusions_update;

Line 264: FND_MSG_PUB.ADD_EXC_MSG('OKL_INS_EXCLUSIONS_PUB','update_ins_exclusions');

260: ROLLBACK TO ins_exclusions_update;
261: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
262: x_msg_count := l_msg_count ;
263: x_msg_data := l_msg_data ;
264: FND_MSG_PUB.ADD_EXC_MSG('OKL_INS_EXCLUSIONS_PUB','update_ins_exclusions');
265: FND_MSG_PUB.count_and_get(
266: p_count => x_msg_count
267: ,p_data => x_msg_data);
268: END update_ins_exclusions;

Line 265: FND_MSG_PUB.count_and_get(

261: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
262: x_msg_count := l_msg_count ;
263: x_msg_data := l_msg_data ;
264: FND_MSG_PUB.ADD_EXC_MSG('OKL_INS_EXCLUSIONS_PUB','update_ins_exclusions');
265: FND_MSG_PUB.count_and_get(
266: p_count => x_msg_count
267: ,p_data => x_msg_data);
268: END update_ins_exclusions;
269: PROCEDURE update_ins_exclusions(

Line 316: FND_MSG_PUB.count_and_get(

312: ROLLBACK TO ins_exclusions_update;
313: x_return_status := FND_API.G_RET_STS_ERROR;
314: x_msg_count := l_msg_count ;
315: x_msg_data := l_msg_data ;
316: FND_MSG_PUB.count_and_get(
317: p_count => x_msg_count
318: ,p_data => x_msg_data);
319: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
320: ROLLBACK TO ins_exclusions_update;

Line 324: FND_MSG_PUB.count_and_get(

320: ROLLBACK TO ins_exclusions_update;
321: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
322: x_msg_count := l_msg_count ;
323: x_msg_data := l_msg_data ;
324: FND_MSG_PUB.count_and_get(
325: p_count => x_msg_count
326: ,p_data => x_msg_data);
327: WHEN OTHERS THEN
328: ROLLBACK TO ins_exclusions_update;

Line 332: FND_MSG_PUB.ADD_EXC_MSG('OKL_INS_EXCLUSIONS_PUB','update_ins_exclusions');

328: ROLLBACK TO ins_exclusions_update;
329: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
330: x_msg_count := l_msg_count ;
331: x_msg_data := l_msg_data ;
332: FND_MSG_PUB.ADD_EXC_MSG('OKL_INS_EXCLUSIONS_PUB','update_ins_exclusions');
333: FND_MSG_PUB.count_and_get(
334: p_count => x_msg_count
335: ,p_data => x_msg_data);
336: END update_ins_exclusions;

Line 333: FND_MSG_PUB.count_and_get(

329: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
330: x_msg_count := l_msg_count ;
331: x_msg_data := l_msg_data ;
332: FND_MSG_PUB.ADD_EXC_MSG('OKL_INS_EXCLUSIONS_PUB','update_ins_exclusions');
333: FND_MSG_PUB.count_and_get(
334: p_count => x_msg_count
335: ,p_data => x_msg_data);
336: END update_ins_exclusions;
337: --Put custom code for cascade delete by developer

Line 390: FND_MSG_PUB.count_and_get(

386: ROLLBACK TO ins_exclusions_delete;
387: x_return_status := FND_API.G_RET_STS_ERROR;
388: x_msg_count := l_msg_count ;
389: x_msg_data := l_msg_data ;
390: FND_MSG_PUB.count_and_get(
391: p_count => x_msg_count
392: ,p_data => x_msg_data);
393: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
394: ROLLBACK TO ins_exclusions_delete;

Line 398: FND_MSG_PUB.count_and_get(

394: ROLLBACK TO ins_exclusions_delete;
395: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
396: x_msg_count := l_msg_count ;
397: x_msg_data := l_msg_data ;
398: FND_MSG_PUB.count_and_get(
399: p_count => x_msg_count
400: ,p_data => x_msg_data);
401: WHEN OTHERS THEN
402: ROLLBACK TO ins_exclusions_delete;

Line 406: FND_MSG_PUB.ADD_EXC_MSG('OKL_INS_EXCLUSIONS_PUB','delete_ins_exclusions');

402: ROLLBACK TO ins_exclusions_delete;
403: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
404: x_msg_count := l_msg_count ;
405: x_msg_data := l_msg_data ;
406: FND_MSG_PUB.ADD_EXC_MSG('OKL_INS_EXCLUSIONS_PUB','delete_ins_exclusions');
407: FND_MSG_PUB.count_and_get(
408: p_count => x_msg_count
409: ,p_data => x_msg_data);
410: END delete_ins_exclusions;

Line 407: FND_MSG_PUB.count_and_get(

403: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
404: x_msg_count := l_msg_count ;
405: x_msg_data := l_msg_data ;
406: FND_MSG_PUB.ADD_EXC_MSG('OKL_INS_EXCLUSIONS_PUB','delete_ins_exclusions');
407: FND_MSG_PUB.count_and_get(
408: p_count => x_msg_count
409: ,p_data => x_msg_data);
410: END delete_ins_exclusions;
411: PROCEDURE delete_ins_exclusions(

Line 466: FND_MSG_PUB.count_and_get(

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

Line 474: FND_MSG_PUB.count_and_get(

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

Line 482: FND_MSG_PUB.ADD_EXC_MSG('OKL_INS_EXCLUSIONS_PUB','delete_ins_exclusions');

478: ROLLBACK TO ins_exclusions_delete;
479: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
480: x_msg_count := l_msg_count ;
481: x_msg_data := l_msg_data ;
482: FND_MSG_PUB.ADD_EXC_MSG('OKL_INS_EXCLUSIONS_PUB','delete_ins_exclusions');
483: FND_MSG_PUB.count_and_get(
484: p_count => x_msg_count
485: ,p_data => x_msg_data);
486: END delete_ins_exclusions;

Line 483: FND_MSG_PUB.count_and_get(

479: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
480: x_msg_count := l_msg_count ;
481: x_msg_data := l_msg_data ;
482: FND_MSG_PUB.ADD_EXC_MSG('OKL_INS_EXCLUSIONS_PUB','delete_ins_exclusions');
483: FND_MSG_PUB.count_and_get(
484: p_count => x_msg_count
485: ,p_data => x_msg_data);
486: END delete_ins_exclusions;
487: PROCEDURE validate_ins_exclusions(

Line 529: FND_MSG_PUB.count_and_get(

525: ROLLBACK TO ins_exclusions_validate;
526: x_return_status := FND_API.G_RET_STS_ERROR;
527: x_msg_count := l_msg_count ;
528: x_msg_data := l_msg_data ;
529: FND_MSG_PUB.count_and_get(
530: p_count => x_msg_count
531: ,p_data => x_msg_data);
532: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
533: ROLLBACK TO ins_exclusions_validate;

Line 537: FND_MSG_PUB.count_and_get(

533: ROLLBACK TO ins_exclusions_validate;
534: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
535: x_msg_count := l_msg_count ;
536: x_msg_data := l_msg_data ;
537: FND_MSG_PUB.count_and_get(
538: p_count => x_msg_count
539: ,p_data => x_msg_data);
540: WHEN OTHERS THEN
541: ROLLBACK TO ins_exclusions_validate;

Line 545: FND_MSG_PUB.ADD_EXC_MSG('OKL_INS_EXCLUSIONS_PUB','validate_ins_exclusions');

541: ROLLBACK TO ins_exclusions_validate;
542: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
543: x_msg_count := l_msg_count ;
544: x_msg_data := l_msg_data ;
545: FND_MSG_PUB.ADD_EXC_MSG('OKL_INS_EXCLUSIONS_PUB','validate_ins_exclusions');
546: FND_MSG_PUB.count_and_get(
547: p_count => x_msg_count
548: ,p_data => x_msg_data);
549: END validate_ins_exclusions;

Line 546: FND_MSG_PUB.count_and_get(

542: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
543: x_msg_count := l_msg_count ;
544: x_msg_data := l_msg_data ;
545: FND_MSG_PUB.ADD_EXC_MSG('OKL_INS_EXCLUSIONS_PUB','validate_ins_exclusions');
546: FND_MSG_PUB.count_and_get(
547: p_count => x_msg_count
548: ,p_data => x_msg_data);
549: END validate_ins_exclusions;
550: PROCEDURE validate_ins_exclusions(

Line 592: FND_MSG_PUB.count_and_get(

588: ROLLBACK TO ins_exclusions_validate;
589: x_return_status := FND_API.G_RET_STS_ERROR;
590: x_msg_count := l_msg_count ;
591: x_msg_data := l_msg_data ;
592: FND_MSG_PUB.count_and_get(
593: p_count => x_msg_count
594: ,p_data => x_msg_data);
595: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
596: ROLLBACK TO ins_exclusions_validate;

Line 600: FND_MSG_PUB.count_and_get(

596: ROLLBACK TO ins_exclusions_validate;
597: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
598: x_msg_count := l_msg_count ;
599: x_msg_data := l_msg_data ;
600: FND_MSG_PUB.count_and_get(
601: p_count => x_msg_count
602: ,p_data => x_msg_data);
603: WHEN OTHERS THEN
604: ROLLBACK TO ins_exclusions_validate;

Line 608: FND_MSG_PUB.ADD_EXC_MSG('OKL_INS_EXCLUSIONS_PUB','validate_ins_exclusions');

604: ROLLBACK TO ins_exclusions_validate;
605: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
606: x_msg_count := l_msg_count ;
607: x_msg_data := l_msg_data ;
608: FND_MSG_PUB.ADD_EXC_MSG('OKL_INS_EXCLUSIONS_PUB','validate_ins_exclusions');
609: FND_MSG_PUB.count_and_get(
610: p_count => x_msg_count
611: ,p_data => x_msg_data);
612: END validate_ins_exclusions;

Line 609: FND_MSG_PUB.count_and_get(

605: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
606: x_msg_count := l_msg_count ;
607: x_msg_data := l_msg_data ;
608: FND_MSG_PUB.ADD_EXC_MSG('OKL_INS_EXCLUSIONS_PUB','validate_ins_exclusions');
609: FND_MSG_PUB.count_and_get(
610: p_count => x_msg_count
611: ,p_data => x_msg_data);
612: END validate_ins_exclusions;
613: END OKL_INS_EXCLUSIONS_PUB;