DBA Data[Home] [Help]

APPS.OKL_TRX_CSH_BATCH_PUB dependencies on FND_MSG_PUB

Line 70: FND_MSG_PUB.count_and_get(

66: ROLLBACK TO trx_csh_batch_insert;
67: x_return_status := FND_API.G_RET_STS_ERROR;
68: x_msg_count := l_msg_count ;
69: x_msg_data := l_msg_data ;
70: FND_MSG_PUB.count_and_get(
71: p_count => x_msg_count
72: ,p_data => x_msg_data);
73: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
74: ROLLBACK TO trx_csh_batch_insert;

Line 78: FND_MSG_PUB.count_and_get(

74: ROLLBACK TO trx_csh_batch_insert;
75: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
76: x_msg_count := l_msg_count ;
77: x_msg_data := l_msg_data ;
78: FND_MSG_PUB.count_and_get(
79: p_count => x_msg_count
80: ,p_data => x_msg_data);
81: WHEN OTHERS THEN
82: ROLLBACK TO trx_csh_batch_insert;

Line 86: FND_MSG_PUB.ADD_EXC_MSG('OKL_TRX_CSH_BATCH_PUB','insert_trx_csh_batch');

82: ROLLBACK TO trx_csh_batch_insert;
83: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
84: x_msg_count := l_msg_count ;
85: x_msg_data := l_msg_data ;
86: FND_MSG_PUB.ADD_EXC_MSG('OKL_TRX_CSH_BATCH_PUB','insert_trx_csh_batch');
87: FND_MSG_PUB.count_and_get(
88: p_count => x_msg_count
89: ,p_data => x_msg_data);
90: END insert_trx_csh_batch;

Line 87: FND_MSG_PUB.count_and_get(

83: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
84: x_msg_count := l_msg_count ;
85: x_msg_data := l_msg_data ;
86: FND_MSG_PUB.ADD_EXC_MSG('OKL_TRX_CSH_BATCH_PUB','insert_trx_csh_batch');
87: FND_MSG_PUB.count_and_get(
88: p_count => x_msg_count
89: ,p_data => x_msg_data);
90: END insert_trx_csh_batch;
91:

Line 162: FND_MSG_PUB.count_and_get(

158: ROLLBACK TO trx_csh_batch_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 trx_csh_batch_insert;

Line 170: FND_MSG_PUB.count_and_get(

166: ROLLBACK TO trx_csh_batch_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 trx_csh_batch_insert;

Line 178: FND_MSG_PUB.ADD_EXC_MSG('OKL_TRX_CSH_BATCH_PUB','insert_trx_csh_batch');

174: ROLLBACK TO trx_csh_batch_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_TRX_CSH_BATCH_PUB','insert_trx_csh_batch');
179: FND_MSG_PUB.count_and_get(
180: p_count => x_msg_count
181: ,p_data => x_msg_data);
182: END insert_trx_csh_batch;

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_TRX_CSH_BATCH_PUB','insert_trx_csh_batch');
179: FND_MSG_PUB.count_and_get(
180: p_count => x_msg_count
181: ,p_data => x_msg_data);
182: END insert_trx_csh_batch;
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_TRX_CSH_BATCH_PUB','lock_trx_csh_batch');

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

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

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_TRX_CSH_BATCH_PUB','lock_trx_csh_batch');
263: FND_MSG_PUB.count_and_get(
264: p_count => x_msg_count
265: ,p_data => x_msg_data);
266: END lock_trx_csh_batch;

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_TRX_CSH_BATCH_PUB','lock_trx_csh_batch');
263: FND_MSG_PUB.count_and_get(
264: p_count => x_msg_count
265: ,p_data => x_msg_data);
266: END lock_trx_csh_batch;
267:

Line 328: FND_MSG_PUB.count_and_get(

324: ROLLBACK TO trx_csh_batch_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 trx_csh_batch_update;

Line 336: FND_MSG_PUB.count_and_get(

332: ROLLBACK TO trx_csh_batch_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 trx_csh_batch_update;

Line 344: FND_MSG_PUB.ADD_EXC_MSG('OKL_TRX_CSH_BATCH_PUB','update_trx_csh_batch');

340: ROLLBACK TO trx_csh_batch_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_TRX_CSH_BATCH_PUB','update_trx_csh_batch');
345: FND_MSG_PUB.count_and_get(
346: p_count => x_msg_count
347: ,p_data => x_msg_data);
348: END update_trx_csh_batch;

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_TRX_CSH_BATCH_PUB','update_trx_csh_batch');
345: FND_MSG_PUB.count_and_get(
346: p_count => x_msg_count
347: ,p_data => x_msg_data);
348: END update_trx_csh_batch;
349:

Line 410: FND_MSG_PUB.count_and_get(

406: ROLLBACK TO trx_csh_batch_update;
407: x_return_status := FND_API.G_RET_STS_ERROR;
408: x_msg_count := l_msg_count ;
409: x_msg_data := l_msg_data ;
410: FND_MSG_PUB.count_and_get(
411: p_count => x_msg_count
412: ,p_data => x_msg_data);
413: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
414: ROLLBACK TO trx_csh_batch_update;

Line 418: FND_MSG_PUB.count_and_get(

414: ROLLBACK TO trx_csh_batch_update;
415: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
416: x_msg_count := l_msg_count ;
417: x_msg_data := l_msg_data ;
418: FND_MSG_PUB.count_and_get(
419: p_count => x_msg_count
420: ,p_data => x_msg_data);
421: WHEN OTHERS THEN
422: ROLLBACK TO trx_csh_batch_update;

Line 426: FND_MSG_PUB.ADD_EXC_MSG('OKL_TRX_CSH_BATCH_PUB','update_trx_csh_batch');

422: ROLLBACK TO trx_csh_batch_update;
423: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
424: x_msg_count := l_msg_count ;
425: x_msg_data := l_msg_data ;
426: FND_MSG_PUB.ADD_EXC_MSG('OKL_TRX_CSH_BATCH_PUB','update_trx_csh_batch');
427: FND_MSG_PUB.count_and_get(
428: p_count => x_msg_count
429: ,p_data => x_msg_data);
430: END update_trx_csh_batch;

Line 427: FND_MSG_PUB.count_and_get(

423: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
424: x_msg_count := l_msg_count ;
425: x_msg_data := l_msg_data ;
426: FND_MSG_PUB.ADD_EXC_MSG('OKL_TRX_CSH_BATCH_PUB','update_trx_csh_batch');
427: FND_MSG_PUB.count_and_get(
428: p_count => x_msg_count
429: ,p_data => x_msg_data);
430: END update_trx_csh_batch;
431:

Line 487: FND_MSG_PUB.count_and_get(

483: ROLLBACK TO trx_csh_batch_delete_rec;
484: x_return_status := FND_API.G_RET_STS_ERROR;
485: x_msg_count := l_msg_count ;
486: x_msg_data := l_msg_data ;
487: FND_MSG_PUB.count_and_get(
488: p_count => x_msg_count
489: ,p_data => x_msg_data);
490: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
491: ROLLBACK TO trx_csh_batch_delete_rec;

Line 495: FND_MSG_PUB.count_and_get(

491: ROLLBACK TO trx_csh_batch_delete_rec;
492: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
493: x_msg_count := l_msg_count ;
494: x_msg_data := l_msg_data ;
495: FND_MSG_PUB.count_and_get(
496: p_count => x_msg_count
497: ,p_data => x_msg_data);
498: WHEN OTHERS THEN
499: ROLLBACK TO trx_csh_batch_delete_rec;

Line 503: FND_MSG_PUB.ADD_EXC_MSG('OKL_TRX_CSH_BATCH_PUB','delete_trx_csh_batch');

499: ROLLBACK TO trx_csh_batch_delete_rec;
500: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
501: x_msg_count := l_msg_count ;
502: x_msg_data := l_msg_data ;
503: FND_MSG_PUB.ADD_EXC_MSG('OKL_TRX_CSH_BATCH_PUB','delete_trx_csh_batch');
504: FND_MSG_PUB.count_and_get(
505: p_count => x_msg_count
506: ,p_data => x_msg_data);
507: END delete_trx_csh_batch;

Line 504: FND_MSG_PUB.count_and_get(

500: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
501: x_msg_count := l_msg_count ;
502: x_msg_data := l_msg_data ;
503: FND_MSG_PUB.ADD_EXC_MSG('OKL_TRX_CSH_BATCH_PUB','delete_trx_csh_batch');
504: FND_MSG_PUB.count_and_get(
505: p_count => x_msg_count
506: ,p_data => x_msg_data);
507: END delete_trx_csh_batch;
508:

Line 575: FND_MSG_PUB.count_and_get(

571: ROLLBACK TO trx_csh_batch_delete_tbl;
572: x_return_status := FND_API.G_RET_STS_ERROR;
573: x_msg_count := l_msg_count ;
574: x_msg_data := l_msg_data ;
575: FND_MSG_PUB.count_and_get(
576: p_count => x_msg_count
577: ,p_data => x_msg_data);
578: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
579: ROLLBACK TO trx_csh_batch_delete_tbl;

Line 583: FND_MSG_PUB.count_and_get(

579: ROLLBACK TO trx_csh_batch_delete_tbl;
580: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
581: x_msg_count := l_msg_count ;
582: x_msg_data := l_msg_data ;
583: FND_MSG_PUB.count_and_get(
584: p_count => x_msg_count
585: ,p_data => x_msg_data);
586: WHEN OTHERS THEN
587: ROLLBACK TO trx_csh_batch_delete_tbl;

Line 591: FND_MSG_PUB.ADD_EXC_MSG('OKL_TRX_CSH_BATCH_PUB','delete_trx_csh_batch');

587: ROLLBACK TO trx_csh_batch_delete_tbl;
588: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
589: x_msg_count := l_msg_count ;
590: x_msg_data := l_msg_data ;
591: FND_MSG_PUB.ADD_EXC_MSG('OKL_TRX_CSH_BATCH_PUB','delete_trx_csh_batch');
592: FND_MSG_PUB.count_and_get(
593: p_count => x_msg_count
594: ,p_data => x_msg_data);
595: END delete_trx_csh_batch;

Line 592: FND_MSG_PUB.count_and_get(

588: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
589: x_msg_count := l_msg_count ;
590: x_msg_data := l_msg_data ;
591: FND_MSG_PUB.ADD_EXC_MSG('OKL_TRX_CSH_BATCH_PUB','delete_trx_csh_batch');
592: FND_MSG_PUB.count_and_get(
593: p_count => x_msg_count
594: ,p_data => x_msg_data);
595: END delete_trx_csh_batch;
596:

Line 653: FND_MSG_PUB.count_and_get(

649: ROLLBACK TO trx_csh_batch_validate;
650: x_return_status := FND_API.G_RET_STS_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 FND_API.G_EXC_UNEXPECTED_ERROR THEN
657: ROLLBACK TO trx_csh_batch_validate;

Line 661: FND_MSG_PUB.count_and_get(

657: ROLLBACK TO trx_csh_batch_validate;
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.count_and_get(
662: p_count => x_msg_count
663: ,p_data => x_msg_data);
664: WHEN OTHERS THEN
665: ROLLBACK TO trx_csh_batch_validate;

Line 669: FND_MSG_PUB.ADD_EXC_MSG('OKL_TRX_CSH_BATCH_PUB','validate_trx_csh_batch');

665: ROLLBACK TO trx_csh_batch_validate;
666: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
667: x_msg_count := l_msg_count ;
668: x_msg_data := l_msg_data ;
669: FND_MSG_PUB.ADD_EXC_MSG('OKL_TRX_CSH_BATCH_PUB','validate_trx_csh_batch');
670: FND_MSG_PUB.count_and_get(
671: p_count => x_msg_count
672: ,p_data => x_msg_data);
673: END validate_trx_csh_batch;

Line 670: FND_MSG_PUB.count_and_get(

666: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
667: x_msg_count := l_msg_count ;
668: x_msg_data := l_msg_data ;
669: FND_MSG_PUB.ADD_EXC_MSG('OKL_TRX_CSH_BATCH_PUB','validate_trx_csh_batch');
670: FND_MSG_PUB.count_and_get(
671: p_count => x_msg_count
672: ,p_data => x_msg_data);
673: END validate_trx_csh_batch;
674:

Line 730: FND_MSG_PUB.count_and_get(

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

Line 738: FND_MSG_PUB.count_and_get(

734: ROLLBACK TO trx_csh_batch_validate;
735: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
736: x_msg_count := l_msg_count ;
737: x_msg_data := l_msg_data ;
738: FND_MSG_PUB.count_and_get(
739: p_count => x_msg_count
740: ,p_data => x_msg_data);
741: WHEN OTHERS THEN
742: ROLLBACK TO trx_csh_batch_validate;

Line 746: FND_MSG_PUB.ADD_EXC_MSG('OKL_TRX_CSH_BATCH_PUB','validate_trx_csh_batch');

742: ROLLBACK TO trx_csh_batch_validate;
743: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
744: x_msg_count := l_msg_count ;
745: x_msg_data := l_msg_data ;
746: FND_MSG_PUB.ADD_EXC_MSG('OKL_TRX_CSH_BATCH_PUB','validate_trx_csh_batch');
747: FND_MSG_PUB.count_and_get(
748: p_count => x_msg_count
749: ,p_data => x_msg_data);
750: END validate_trx_csh_batch;

Line 747: FND_MSG_PUB.count_and_get(

743: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
744: x_msg_count := l_msg_count ;
745: x_msg_data := l_msg_data ;
746: FND_MSG_PUB.ADD_EXC_MSG('OKL_TRX_CSH_BATCH_PUB','validate_trx_csh_batch');
747: FND_MSG_PUB.count_and_get(
748: p_count => x_msg_count
749: ,p_data => x_msg_data);
750: END validate_trx_csh_batch;
751:

Line 835: FND_MSG_PUB.count_and_get(

831:
832: WHEN FND_API.G_EXC_ERROR THEN
833: ROLLBACK TO handle_batch_receipt;
834: x_return_status := FND_API.G_RET_STS_ERROR;
835: FND_MSG_PUB.count_and_get(
836: p_count => x_msg_count
837: ,p_data => x_msg_data);
838:
839: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 842: FND_MSG_PUB.count_and_get(

838:
839: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
840: ROLLBACK TO handle_batch_receipt;
841: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
842: FND_MSG_PUB.count_and_get(
843: p_count => x_msg_count
844: ,p_data => x_msg_data);
845:
846: WHEN OTHERS THEN

Line 849: FND_MSG_PUB.ADD_EXC_MSG('OKL_TRX_CSH_BATCH_PUB','handle_batch_receipt');

845:
846: WHEN OTHERS THEN
847: ROLLBACK TO handle_batch_receipt;
848: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
849: FND_MSG_PUB.ADD_EXC_MSG('OKL_TRX_CSH_BATCH_PUB','handle_batch_receipt');
850: FND_MSG_PUB.count_and_get(
851: p_count => x_msg_count
852: ,p_data => x_msg_data);
853:

Line 850: FND_MSG_PUB.count_and_get(

846: WHEN OTHERS THEN
847: ROLLBACK TO handle_batch_receipt;
848: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
849: FND_MSG_PUB.ADD_EXC_MSG('OKL_TRX_CSH_BATCH_PUB','handle_batch_receipt');
850: FND_MSG_PUB.count_and_get(
851: p_count => x_msg_count
852: ,p_data => x_msg_data);
853:
854: END handle_batch_receipt;