DBA Data[Home] [Help]

APPS.OKL_OPEN_INT_PUB dependencies on FND_MSG_PUB

Line 73: FND_MSG_PUB.count_and_get(

69: ROLLBACK TO open_int_insert;
70: x_return_status := FND_API.G_RET_STS_ERROR;
71: x_msg_count := l_msg_count ;
72: x_msg_data := l_msg_data ;
73: FND_MSG_PUB.count_and_get(
74: p_count => x_msg_count
75: ,p_data => x_msg_data);
76: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
77: ROLLBACK TO open_int_insert;

Line 81: FND_MSG_PUB.count_and_get(

77: ROLLBACK TO open_int_insert;
78: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
79: x_msg_count := l_msg_count ;
80: x_msg_data := l_msg_data ;
81: FND_MSG_PUB.count_and_get(
82: p_count => x_msg_count
83: ,p_data => x_msg_data);
84: WHEN OTHERS THEN
85: ROLLBACK TO open_int_insert;

Line 89: FND_MSG_PUB.ADD_EXC_MSG('OKL_OPEN_INT_PUB','insert_open_int');

85: ROLLBACK TO open_int_insert;
86: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
87: x_msg_count := l_msg_count ;
88: x_msg_data := l_msg_data ;
89: FND_MSG_PUB.ADD_EXC_MSG('OKL_OPEN_INT_PUB','insert_open_int');
90: FND_MSG_PUB.count_and_get(
91: p_count => x_msg_count
92: ,p_data => x_msg_data);
93: END insert_open_int;

Line 90: FND_MSG_PUB.count_and_get(

86: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
87: x_msg_count := l_msg_count ;
88: x_msg_data := l_msg_data ;
89: FND_MSG_PUB.ADD_EXC_MSG('OKL_OPEN_INT_PUB','insert_open_int');
90: FND_MSG_PUB.count_and_get(
91: p_count => x_msg_count
92: ,p_data => x_msg_data);
93: END insert_open_int;
94:

Line 158: FND_MSG_PUB.count_and_get(

154: ROLLBACK TO open_int_insert;
155: x_return_status := FND_API.G_RET_STS_ERROR;
156: x_msg_count := l_msg_count ;
157: x_msg_data := l_msg_data ;
158: FND_MSG_PUB.count_and_get(
159: p_count => x_msg_count
160: ,p_data => x_msg_data);
161: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
162: ROLLBACK TO open_int_insert;

Line 166: FND_MSG_PUB.count_and_get(

162: ROLLBACK TO open_int_insert;
163: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
164: x_msg_count := l_msg_count ;
165: x_msg_data := l_msg_data ;
166: FND_MSG_PUB.count_and_get(
167: p_count => x_msg_count
168: ,p_data => x_msg_data);
169: WHEN OTHERS THEN
170: ROLLBACK TO open_int_insert;

Line 174: FND_MSG_PUB.ADD_EXC_MSG('OKL_OPEN_INT_PUB','insert_open_int');

170: ROLLBACK TO open_int_insert;
171: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
172: x_msg_count := l_msg_count ;
173: x_msg_data := l_msg_data ;
174: FND_MSG_PUB.ADD_EXC_MSG('OKL_OPEN_INT_PUB','insert_open_int');
175: FND_MSG_PUB.count_and_get(
176: p_count => x_msg_count
177: ,p_data => x_msg_data);
178: END insert_open_int;

Line 175: FND_MSG_PUB.count_and_get(

171: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
172: x_msg_count := l_msg_count ;
173: x_msg_data := l_msg_data ;
174: FND_MSG_PUB.ADD_EXC_MSG('OKL_OPEN_INT_PUB','insert_open_int');
175: FND_MSG_PUB.count_and_get(
176: p_count => x_msg_count
177: ,p_data => x_msg_data);
178: END insert_open_int;
179:

Line 206: FND_MSG_PUB.count_and_get(

202:
203: EXCEPTION
204:
205: WHEN FND_API.G_EXC_ERROR THEN
206: FND_MSG_PUB.count_and_get(
207: p_count => x_msg_count
208: ,p_data => x_msg_data);
209: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
210: FND_MSG_PUB.count_and_get(

Line 210: FND_MSG_PUB.count_and_get(

206: FND_MSG_PUB.count_and_get(
207: p_count => x_msg_count
208: ,p_data => x_msg_data);
209: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
210: FND_MSG_PUB.count_and_get(
211: p_count => x_msg_count
212: ,p_data => x_msg_data);
213: WHEN OTHERS THEN
214: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 215: FND_MSG_PUB.ADD_EXC_MSG('OKL_OPEN_INT_PUB','lock_open_int');

211: p_count => x_msg_count
212: ,p_data => x_msg_data);
213: WHEN OTHERS THEN
214: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
215: FND_MSG_PUB.ADD_EXC_MSG('OKL_OPEN_INT_PUB','lock_open_int');
216: FND_MSG_PUB.count_and_get(
217: p_count => x_msg_count
218: ,p_data => x_msg_data);
219: END lock_open_int;

Line 216: FND_MSG_PUB.count_and_get(

212: ,p_data => x_msg_data);
213: WHEN OTHERS THEN
214: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
215: FND_MSG_PUB.ADD_EXC_MSG('OKL_OPEN_INT_PUB','lock_open_int');
216: FND_MSG_PUB.count_and_get(
217: p_count => x_msg_count
218: ,p_data => x_msg_data);
219: END lock_open_int;
220:

Line 246: FND_MSG_PUB.count_and_get(

242: END IF;
243: EXCEPTION
244:
245: WHEN FND_API.G_EXC_ERROR THEN
246: FND_MSG_PUB.count_and_get(
247: p_count => x_msg_count
248: ,p_data => x_msg_data);
249: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
250: FND_MSG_PUB.count_and_get(

Line 250: FND_MSG_PUB.count_and_get(

246: FND_MSG_PUB.count_and_get(
247: p_count => x_msg_count
248: ,p_data => x_msg_data);
249: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
250: FND_MSG_PUB.count_and_get(
251: p_count => x_msg_count
252: ,p_data => x_msg_data);
253: WHEN OTHERS THEN
254: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 255: FND_MSG_PUB.ADD_EXC_MSG('OKL_OPEN_INT_PUB','lock_open_int');

251: p_count => x_msg_count
252: ,p_data => x_msg_data);
253: WHEN OTHERS THEN
254: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
255: FND_MSG_PUB.ADD_EXC_MSG('OKL_OPEN_INT_PUB','lock_open_int');
256: FND_MSG_PUB.count_and_get(
257: p_count => x_msg_count
258: ,p_data => x_msg_data);
259: END lock_open_int;

Line 256: FND_MSG_PUB.count_and_get(

252: ,p_data => x_msg_data);
253: WHEN OTHERS THEN
254: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
255: FND_MSG_PUB.ADD_EXC_MSG('OKL_OPEN_INT_PUB','lock_open_int');
256: FND_MSG_PUB.count_and_get(
257: p_count => x_msg_count
258: ,p_data => x_msg_data);
259: END lock_open_int;
260:

Line 328: FND_MSG_PUB.count_and_get(

324: ROLLBACK TO open_int_update;
325: x_return_status := FND_API.G_RET_STS_ERROR;
326: x_msg_count := l_msg_count ;
327: x_msg_data := l_msg_data ;
328: FND_MSG_PUB.count_and_get(
329: p_count => x_msg_count
330: ,p_data => x_msg_data);
331: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
332: ROLLBACK TO open_int_update;

Line 336: FND_MSG_PUB.count_and_get(

332: ROLLBACK TO open_int_update;
333: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
334: x_msg_count := l_msg_count ;
335: x_msg_data := l_msg_data ;
336: FND_MSG_PUB.count_and_get(
337: p_count => x_msg_count
338: ,p_data => x_msg_data);
339: WHEN OTHERS THEN
340: ROLLBACK TO open_int_update;

Line 344: FND_MSG_PUB.ADD_EXC_MSG('OKL_OPEN_INT_PUB','update_open_int');

340: ROLLBACK TO open_int_update;
341: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
342: x_msg_count := l_msg_count ;
343: x_msg_data := l_msg_data ;
344: FND_MSG_PUB.ADD_EXC_MSG('OKL_OPEN_INT_PUB','update_open_int');
345: FND_MSG_PUB.count_and_get(
346: p_count => x_msg_count
347: ,p_data => x_msg_data);
348: END update_open_int;

Line 345: FND_MSG_PUB.count_and_get(

341: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
342: x_msg_count := l_msg_count ;
343: x_msg_data := l_msg_data ;
344: FND_MSG_PUB.ADD_EXC_MSG('OKL_OPEN_INT_PUB','update_open_int');
345: FND_MSG_PUB.count_and_get(
346: p_count => x_msg_count
347: ,p_data => x_msg_data);
348: END update_open_int;
349:

Line 415: FND_MSG_PUB.count_and_get(

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

Line 423: FND_MSG_PUB.count_and_get(

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

Line 431: FND_MSG_PUB.ADD_EXC_MSG('OKL_OPEN_INT_PUB','update_open_int');

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

Line 432: FND_MSG_PUB.count_and_get(

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

Line 499: FND_MSG_PUB.count_and_get(

495: ROLLBACK TO open_int_delete_rec;
496: x_return_status := FND_API.G_RET_STS_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 FND_API.G_EXC_UNEXPECTED_ERROR THEN
503: ROLLBACK TO open_int_delete_rec;

Line 507: FND_MSG_PUB.count_and_get(

503: ROLLBACK TO open_int_delete_rec;
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.count_and_get(
508: p_count => x_msg_count
509: ,p_data => x_msg_data);
510: WHEN OTHERS THEN
511: ROLLBACK TO open_int_delete_rec;

Line 515: FND_MSG_PUB.ADD_EXC_MSG('OKL_OPEN_INT_PUB','delete_open_int');

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

Line 516: FND_MSG_PUB.count_and_get(

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

Line 594: FND_MSG_PUB.count_and_get(

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

Line 602: FND_MSG_PUB.count_and_get(

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

Line 610: FND_MSG_PUB.ADD_EXC_MSG('OKL_OPEN_INT_PUB','delete_open_int');

606: ROLLBACK TO open_int_delete_tbl;
607: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
608: x_msg_count := l_msg_count ;
609: x_msg_data := l_msg_data ;
610: FND_MSG_PUB.ADD_EXC_MSG('OKL_OPEN_INT_PUB','delete_open_int');
611: FND_MSG_PUB.count_and_get(
612: p_count => x_msg_count
613: ,p_data => x_msg_data);
614: END delete_open_int;

Line 611: FND_MSG_PUB.count_and_get(

607: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
608: x_msg_count := l_msg_count ;
609: x_msg_data := l_msg_data ;
610: FND_MSG_PUB.ADD_EXC_MSG('OKL_OPEN_INT_PUB','delete_open_int');
611: FND_MSG_PUB.count_and_get(
612: p_count => x_msg_count
613: ,p_data => x_msg_data);
614: END delete_open_int;
615:

Line 682: FND_MSG_PUB.count_and_get(

678: ROLLBACK TO open_int_validate;
679: x_return_status := FND_API.G_RET_STS_ERROR;
680: x_msg_count := l_msg_count ;
681: x_msg_data := l_msg_data ;
682: FND_MSG_PUB.count_and_get(
683: p_count => x_msg_count
684: ,p_data => x_msg_data);
685: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
686: ROLLBACK TO open_int_validate;

Line 690: FND_MSG_PUB.count_and_get(

686: ROLLBACK TO open_int_validate;
687: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
688: x_msg_count := l_msg_count ;
689: x_msg_data := l_msg_data ;
690: FND_MSG_PUB.count_and_get(
691: p_count => x_msg_count
692: ,p_data => x_msg_data);
693: WHEN OTHERS THEN
694: ROLLBACK TO open_int_validate;

Line 698: FND_MSG_PUB.ADD_EXC_MSG('OKL_OPEN_INT_PUB','validate_open_int');

694: ROLLBACK TO open_int_validate;
695: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
696: x_msg_count := l_msg_count ;
697: x_msg_data := l_msg_data ;
698: FND_MSG_PUB.ADD_EXC_MSG('OKL_OPEN_INT_PUB','validate_open_int');
699: FND_MSG_PUB.count_and_get(
700: p_count => x_msg_count
701: ,p_data => x_msg_data);
702: END validate_open_int;

Line 699: FND_MSG_PUB.count_and_get(

695: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
696: x_msg_count := l_msg_count ;
697: x_msg_data := l_msg_data ;
698: FND_MSG_PUB.ADD_EXC_MSG('OKL_OPEN_INT_PUB','validate_open_int');
699: FND_MSG_PUB.count_and_get(
700: p_count => x_msg_count
701: ,p_data => x_msg_data);
702: END validate_open_int;
703:

Line 766: FND_MSG_PUB.count_and_get(

762: ROLLBACK TO open_int_validate;
763: x_return_status := FND_API.G_RET_STS_ERROR;
764: x_msg_count := l_msg_count ;
765: x_msg_data := l_msg_data ;
766: FND_MSG_PUB.count_and_get(
767: p_count => x_msg_count
768: ,p_data => x_msg_data);
769: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
770: ROLLBACK TO open_int_validate;

Line 774: FND_MSG_PUB.count_and_get(

770: ROLLBACK TO open_int_validate;
771: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
772: x_msg_count := l_msg_count ;
773: x_msg_data := l_msg_data ;
774: FND_MSG_PUB.count_and_get(
775: p_count => x_msg_count
776: ,p_data => x_msg_data);
777: WHEN OTHERS THEN
778: ROLLBACK TO open_int_validate;

Line 782: FND_MSG_PUB.ADD_EXC_MSG('OKL_OPEN_INT_PUB','validate_open_int');

778: ROLLBACK TO open_int_validate;
779: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
780: x_msg_count := l_msg_count ;
781: x_msg_data := l_msg_data ;
782: FND_MSG_PUB.ADD_EXC_MSG('OKL_OPEN_INT_PUB','validate_open_int');
783: FND_MSG_PUB.count_and_get(
784: p_count => x_msg_count
785: ,p_data => x_msg_data);
786: END validate_open_int;

Line 783: FND_MSG_PUB.count_and_get(

779: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
780: x_msg_count := l_msg_count ;
781: x_msg_data := l_msg_data ;
782: FND_MSG_PUB.ADD_EXC_MSG('OKL_OPEN_INT_PUB','validate_open_int');
783: FND_MSG_PUB.count_and_get(
784: p_count => x_msg_count
785: ,p_data => x_msg_data);
786: END validate_open_int;
787: