DBA Data[Home] [Help]

APPS.OKL_XTL_CSH_APPS_PUB dependencies on FND_MSG_PUB

Line 74: FND_MSG_PUB.count_and_get(

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

Line 82: FND_MSG_PUB.count_and_get(

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

Line 90: FND_MSG_PUB.ADD_EXC_MSG('OKL_XTL_CSH_APPS_PUB','insert_xtl_csh_apps');

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

Line 91: FND_MSG_PUB.count_and_get(

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

Line 162: FND_MSG_PUB.count_and_get(

158: ROLLBACK TO xtl_csh_apps_insert;
159: x_return_status := FND_API.G_RET_STS_ERROR;
160: x_msg_count := l_msg_count ;
161: x_msg_data := l_msg_data ;
162: FND_MSG_PUB.count_and_get(
163: p_count => x_msg_count
164: ,p_data => x_msg_data);
165: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
166: ROLLBACK TO xtl_csh_apps_insert;

Line 170: FND_MSG_PUB.count_and_get(

166: ROLLBACK TO xtl_csh_apps_insert;
167: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
168: x_msg_count := l_msg_count ;
169: x_msg_data := l_msg_data ;
170: FND_MSG_PUB.count_and_get(
171: p_count => x_msg_count
172: ,p_data => x_msg_data);
173: WHEN OTHERS THEN
174: ROLLBACK TO xtl_csh_apps_insert;

Line 178: FND_MSG_PUB.ADD_EXC_MSG('OKL_XTL_CSH_APPS_PUB','insert_xtl_csh_apps');

174: ROLLBACK TO xtl_csh_apps_insert;
175: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
176: x_msg_count := l_msg_count ;
177: x_msg_data := l_msg_data ;
178: FND_MSG_PUB.ADD_EXC_MSG('OKL_XTL_CSH_APPS_PUB','insert_xtl_csh_apps');
179: FND_MSG_PUB.count_and_get(
180: p_count => x_msg_count
181: ,p_data => x_msg_data);
182: END insert_xtl_csh_apps;

Line 179: FND_MSG_PUB.count_and_get(

175: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
176: x_msg_count := l_msg_count ;
177: x_msg_data := l_msg_data ;
178: FND_MSG_PUB.ADD_EXC_MSG('OKL_XTL_CSH_APPS_PUB','insert_xtl_csh_apps');
179: FND_MSG_PUB.count_and_get(
180: p_count => x_msg_count
181: ,p_data => x_msg_data);
182: END insert_xtl_csh_apps;
183:

Line 211: FND_MSG_PUB.count_and_get(

207:
208: EXCEPTION
209:
210: WHEN FND_API.G_EXC_ERROR THEN
211: FND_MSG_PUB.count_and_get(
212: p_count => x_msg_count
213: ,p_data => x_msg_data);
214: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
215: FND_MSG_PUB.count_and_get(

Line 215: FND_MSG_PUB.count_and_get(

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

Line 220: FND_MSG_PUB.ADD_EXC_MSG('OKL_XTL_CSH_APPS_PUB','lock_xtl_csh_apps');

216: p_count => x_msg_count
217: ,p_data => x_msg_data);
218: WHEN OTHERS THEN
219: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
220: FND_MSG_PUB.ADD_EXC_MSG('OKL_XTL_CSH_APPS_PUB','lock_xtl_csh_apps');
221: FND_MSG_PUB.count_and_get(
222: p_count => x_msg_count
223: ,p_data => x_msg_data);
224: END lock_xtl_csh_apps;

Line 221: FND_MSG_PUB.count_and_get(

217: ,p_data => x_msg_data);
218: WHEN OTHERS THEN
219: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
220: FND_MSG_PUB.ADD_EXC_MSG('OKL_XTL_CSH_APPS_PUB','lock_xtl_csh_apps');
221: FND_MSG_PUB.count_and_get(
222: p_count => x_msg_count
223: ,p_data => x_msg_data);
224: END lock_xtl_csh_apps;
225:

Line 253: FND_MSG_PUB.count_and_get(

249:
250: EXCEPTION
251:
252: WHEN FND_API.G_EXC_ERROR THEN
253: FND_MSG_PUB.count_and_get(
254: p_count => x_msg_count
255: ,p_data => x_msg_data);
256: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
257: FND_MSG_PUB.count_and_get(

Line 257: FND_MSG_PUB.count_and_get(

253: FND_MSG_PUB.count_and_get(
254: p_count => x_msg_count
255: ,p_data => x_msg_data);
256: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
257: FND_MSG_PUB.count_and_get(
258: p_count => x_msg_count
259: ,p_data => x_msg_data);
260: WHEN OTHERS THEN
261: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 262: FND_MSG_PUB.ADD_EXC_MSG('OKL_XTL_CSH_APPS_PUB','lock_xtl_csh_apps');

258: p_count => x_msg_count
259: ,p_data => x_msg_data);
260: WHEN OTHERS THEN
261: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
262: FND_MSG_PUB.ADD_EXC_MSG('OKL_XTL_CSH_APPS_PUB','lock_xtl_csh_apps');
263: FND_MSG_PUB.count_and_get(
264: p_count => x_msg_count
265: ,p_data => x_msg_data);
266: END lock_xtl_csh_apps;

Line 263: FND_MSG_PUB.count_and_get(

259: ,p_data => x_msg_data);
260: WHEN OTHERS THEN
261: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
262: FND_MSG_PUB.ADD_EXC_MSG('OKL_XTL_CSH_APPS_PUB','lock_xtl_csh_apps');
263: FND_MSG_PUB.count_and_get(
264: p_count => x_msg_count
265: ,p_data => x_msg_data);
266: END lock_xtl_csh_apps;
267:

Line 337: FND_MSG_PUB.count_and_get(

333: ROLLBACK TO xtl_csh_apps_update;
334: x_return_status := FND_API.G_RET_STS_ERROR;
335: x_msg_count := l_msg_count ;
336: x_msg_data := l_msg_data ;
337: FND_MSG_PUB.count_and_get(
338: p_count => x_msg_count
339: ,p_data => x_msg_data);
340: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
341: ROLLBACK TO xtl_csh_apps_update;

Line 345: FND_MSG_PUB.count_and_get(

341: ROLLBACK TO xtl_csh_apps_update;
342: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
343: x_msg_count := l_msg_count ;
344: x_msg_data := l_msg_data ;
345: FND_MSG_PUB.count_and_get(
346: p_count => x_msg_count
347: ,p_data => x_msg_data);
348: WHEN OTHERS THEN
349: ROLLBACK TO xtl_csh_apps_update;

Line 353: FND_MSG_PUB.ADD_EXC_MSG('OKL_XTL_CSH_APPS_PUB','update_xtl_csh_apps');

349: ROLLBACK TO xtl_csh_apps_update;
350: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
351: x_msg_count := l_msg_count ;
352: x_msg_data := l_msg_data ;
353: FND_MSG_PUB.ADD_EXC_MSG('OKL_XTL_CSH_APPS_PUB','update_xtl_csh_apps');
354: FND_MSG_PUB.count_and_get(
355: p_count => x_msg_count
356: ,p_data => x_msg_data);
357: END update_xtl_csh_apps;

Line 354: FND_MSG_PUB.count_and_get(

350: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
351: x_msg_count := l_msg_count ;
352: x_msg_data := l_msg_data ;
353: FND_MSG_PUB.ADD_EXC_MSG('OKL_XTL_CSH_APPS_PUB','update_xtl_csh_apps');
354: FND_MSG_PUB.count_and_get(
355: p_count => x_msg_count
356: ,p_data => x_msg_data);
357: END update_xtl_csh_apps;
358:

Line 426: FND_MSG_PUB.count_and_get(

422: ROLLBACK TO xtl_csh_apps_update;
423: x_return_status := FND_API.G_RET_STS_ERROR;
424: x_msg_count := l_msg_count ;
425: x_msg_data := l_msg_data ;
426: FND_MSG_PUB.count_and_get(
427: p_count => x_msg_count
428: ,p_data => x_msg_data);
429: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
430: ROLLBACK TO xtl_csh_apps_update;

Line 434: FND_MSG_PUB.count_and_get(

430: ROLLBACK TO xtl_csh_apps_update;
431: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
432: x_msg_count := l_msg_count ;
433: x_msg_data := l_msg_data ;
434: FND_MSG_PUB.count_and_get(
435: p_count => x_msg_count
436: ,p_data => x_msg_data);
437: WHEN OTHERS THEN
438: ROLLBACK TO xtl_csh_apps_update;

Line 442: FND_MSG_PUB.ADD_EXC_MSG('OKL_XTL_CSH_APPS_PUB','update_xtl_csh_apps');

438: ROLLBACK TO xtl_csh_apps_update;
439: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
440: x_msg_count := l_msg_count ;
441: x_msg_data := l_msg_data ;
442: FND_MSG_PUB.ADD_EXC_MSG('OKL_XTL_CSH_APPS_PUB','update_xtl_csh_apps');
443: FND_MSG_PUB.count_and_get(
444: p_count => x_msg_count
445: ,p_data => x_msg_data);
446: END update_xtl_csh_apps;

Line 443: FND_MSG_PUB.count_and_get(

439: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
440: x_msg_count := l_msg_count ;
441: x_msg_data := l_msg_data ;
442: FND_MSG_PUB.ADD_EXC_MSG('OKL_XTL_CSH_APPS_PUB','update_xtl_csh_apps');
443: FND_MSG_PUB.count_and_get(
444: p_count => x_msg_count
445: ,p_data => x_msg_data);
446: END update_xtl_csh_apps;
447:

Line 512: FND_MSG_PUB.count_and_get(

508: ROLLBACK TO xtl_csh_apps_delete_rec;
509: x_return_status := FND_API.G_RET_STS_ERROR;
510: x_msg_count := l_msg_count ;
511: x_msg_data := l_msg_data ;
512: FND_MSG_PUB.count_and_get(
513: p_count => x_msg_count
514: ,p_data => x_msg_data);
515: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
516: ROLLBACK TO xtl_csh_apps_delete_rec;

Line 520: FND_MSG_PUB.count_and_get(

516: ROLLBACK TO xtl_csh_apps_delete_rec;
517: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
518: x_msg_count := l_msg_count ;
519: x_msg_data := l_msg_data ;
520: FND_MSG_PUB.count_and_get(
521: p_count => x_msg_count
522: ,p_data => x_msg_data);
523: WHEN OTHERS THEN
524: ROLLBACK TO xtl_csh_apps_delete_rec;

Line 528: FND_MSG_PUB.ADD_EXC_MSG('OKL_XTL_CSH_APPS_PUB','delete_xtl_csh_apps');

524: ROLLBACK TO xtl_csh_apps_delete_rec;
525: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
526: x_msg_count := l_msg_count ;
527: x_msg_data := l_msg_data ;
528: FND_MSG_PUB.ADD_EXC_MSG('OKL_XTL_CSH_APPS_PUB','delete_xtl_csh_apps');
529: FND_MSG_PUB.count_and_get(
530: p_count => x_msg_count
531: ,p_data => x_msg_data);
532: END delete_xtl_csh_apps;

Line 529: FND_MSG_PUB.count_and_get(

525: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
526: x_msg_count := l_msg_count ;
527: x_msg_data := l_msg_data ;
528: FND_MSG_PUB.ADD_EXC_MSG('OKL_XTL_CSH_APPS_PUB','delete_xtl_csh_apps');
529: FND_MSG_PUB.count_and_get(
530: p_count => x_msg_count
531: ,p_data => x_msg_data);
532: END delete_xtl_csh_apps;
533:

Line 609: FND_MSG_PUB.count_and_get(

605: ROLLBACK TO xtl_csh_apps_delete_tbl;
606: x_return_status := FND_API.G_RET_STS_ERROR;
607: x_msg_count := l_msg_count ;
608: x_msg_data := l_msg_data ;
609: FND_MSG_PUB.count_and_get(
610: p_count => x_msg_count
611: ,p_data => x_msg_data);
612: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
613: ROLLBACK TO xtl_csh_apps_delete_tbl;

Line 617: FND_MSG_PUB.count_and_get(

613: ROLLBACK TO xtl_csh_apps_delete_tbl;
614: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
615: x_msg_count := l_msg_count ;
616: x_msg_data := l_msg_data ;
617: FND_MSG_PUB.count_and_get(
618: p_count => x_msg_count
619: ,p_data => x_msg_data);
620: WHEN OTHERS THEN
621: ROLLBACK TO xtl_csh_apps_delete_tbl;

Line 625: FND_MSG_PUB.ADD_EXC_MSG('OKL_XTL_CSH_APPS_PUB','delete_xtl_csh_apps');

621: ROLLBACK TO xtl_csh_apps_delete_tbl;
622: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
623: x_msg_count := l_msg_count ;
624: x_msg_data := l_msg_data ;
625: FND_MSG_PUB.ADD_EXC_MSG('OKL_XTL_CSH_APPS_PUB','delete_xtl_csh_apps');
626: FND_MSG_PUB.count_and_get(
627: p_count => x_msg_count
628: ,p_data => x_msg_data);
629: END delete_xtl_csh_apps;

Line 626: FND_MSG_PUB.count_and_get(

622: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
623: x_msg_count := l_msg_count ;
624: x_msg_data := l_msg_data ;
625: FND_MSG_PUB.ADD_EXC_MSG('OKL_XTL_CSH_APPS_PUB','delete_xtl_csh_apps');
626: FND_MSG_PUB.count_and_get(
627: p_count => x_msg_count
628: ,p_data => x_msg_data);
629: END delete_xtl_csh_apps;
630:

Line 695: FND_MSG_PUB.count_and_get(

691: ROLLBACK TO xtl_csh_apps_validate;
692: x_return_status := FND_API.G_RET_STS_ERROR;
693: x_msg_count := l_msg_count ;
694: x_msg_data := l_msg_data ;
695: FND_MSG_PUB.count_and_get(
696: p_count => x_msg_count
697: ,p_data => x_msg_data);
698: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
699: ROLLBACK TO xtl_csh_apps_validate;

Line 703: FND_MSG_PUB.count_and_get(

699: ROLLBACK TO xtl_csh_apps_validate;
700: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
701: x_msg_count := l_msg_count ;
702: x_msg_data := l_msg_data ;
703: FND_MSG_PUB.count_and_get(
704: p_count => x_msg_count
705: ,p_data => x_msg_data);
706: WHEN OTHERS THEN
707: ROLLBACK TO xtl_csh_apps_validate;

Line 711: FND_MSG_PUB.ADD_EXC_MSG('OKL_XTL_CSH_APPS_PUB','validate_xtl_csh_apps');

707: ROLLBACK TO xtl_csh_apps_validate;
708: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
709: x_msg_count := l_msg_count ;
710: x_msg_data := l_msg_data ;
711: FND_MSG_PUB.ADD_EXC_MSG('OKL_XTL_CSH_APPS_PUB','validate_xtl_csh_apps');
712: FND_MSG_PUB.count_and_get(
713: p_count => x_msg_count
714: ,p_data => x_msg_data);
715: END validate_xtl_csh_apps;

Line 712: FND_MSG_PUB.count_and_get(

708: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
709: x_msg_count := l_msg_count ;
710: x_msg_data := l_msg_data ;
711: FND_MSG_PUB.ADD_EXC_MSG('OKL_XTL_CSH_APPS_PUB','validate_xtl_csh_apps');
712: FND_MSG_PUB.count_and_get(
713: p_count => x_msg_count
714: ,p_data => x_msg_data);
715: END validate_xtl_csh_apps;
716:

Line 777: FND_MSG_PUB.count_and_get(

773: ROLLBACK TO xtl_csh_apps_validate;
774: x_return_status := FND_API.G_RET_STS_ERROR;
775: x_msg_count := l_msg_count ;
776: x_msg_data := l_msg_data ;
777: FND_MSG_PUB.count_and_get(
778: p_count => x_msg_count
779: ,p_data => x_msg_data);
780: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
781: ROLLBACK TO xtl_csh_apps_validate;

Line 785: FND_MSG_PUB.count_and_get(

781: ROLLBACK TO xtl_csh_apps_validate;
782: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
783: x_msg_count := l_msg_count ;
784: x_msg_data := l_msg_data ;
785: FND_MSG_PUB.count_and_get(
786: p_count => x_msg_count
787: ,p_data => x_msg_data);
788: WHEN OTHERS THEN
789: ROLLBACK TO xtl_csh_apps_validate;

Line 793: FND_MSG_PUB.ADD_EXC_MSG('OKL_XTL_CSH_APPS_PUB','validate_xtl_csh_apps');

789: ROLLBACK TO xtl_csh_apps_validate;
790: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
791: x_msg_count := l_msg_count ;
792: x_msg_data := l_msg_data ;
793: FND_MSG_PUB.ADD_EXC_MSG('OKL_XTL_CSH_APPS_PUB','validate_xtl_csh_apps');
794: FND_MSG_PUB.count_and_get(
795: p_count => x_msg_count
796: ,p_data => x_msg_data);
797: END validate_xtl_csh_apps;

Line 794: FND_MSG_PUB.count_and_get(

790: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
791: x_msg_count := l_msg_count ;
792: x_msg_data := l_msg_data ;
793: FND_MSG_PUB.ADD_EXC_MSG('OKL_XTL_CSH_APPS_PUB','validate_xtl_csh_apps');
794: FND_MSG_PUB.count_and_get(
795: p_count => x_msg_count
796: ,p_data => x_msg_data);
797: END validate_xtl_csh_apps;
798: