DBA Data[Home] [Help]

APPS.OKL_TRX_MSGS_PUB dependencies on FND_MSG_PUB

Line 75: FND_MSG_PUB.count_and_get(

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

Line 83: FND_MSG_PUB.count_and_get(

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

Line 91: FND_MSG_PUB.ADD_EXC_MSG('OKL_TRX_MSGS_PUB','insert_trx_msgs');

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

Line 92: FND_MSG_PUB.count_and_get(

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

Line 163: FND_MSG_PUB.count_and_get(

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

Line 171: FND_MSG_PUB.count_and_get(

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

Line 179: FND_MSG_PUB.ADD_EXC_MSG('OKL_TRX_MSGS_PUB','insert_trx_msgs');

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

Line 180: FND_MSG_PUB.count_and_get(

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

Line 212: FND_MSG_PUB.count_and_get(

208:
209: EXCEPTION
210:
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_TRX_MSGS_PUB','lock_trx_msgs');

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

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

Line 254: FND_MSG_PUB.count_and_get(

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

Line 258: FND_MSG_PUB.count_and_get(

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

Line 263: FND_MSG_PUB.ADD_EXC_MSG('OKL_TRX_MSGS_PUB','lock_trx_msgs');

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

Line 264: FND_MSG_PUB.count_and_get(

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

Line 338: FND_MSG_PUB.count_and_get(

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

Line 346: FND_MSG_PUB.count_and_get(

342: ROLLBACK TO trx_msgs_update;
343: x_return_status := FND_API.G_RET_STS_UNEXP_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 OTHERS THEN
350: ROLLBACK TO trx_msgs_update;

Line 354: FND_MSG_PUB.ADD_EXC_MSG('OKL_TRX_MSGS_PUB','update_trx_msgs');

350: ROLLBACK TO trx_msgs_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.ADD_EXC_MSG('OKL_TRX_MSGS_PUB','update_trx_msgs');
355: FND_MSG_PUB.count_and_get(
356: p_count => x_msg_count
357: ,p_data => x_msg_data);
358: END update_trx_msgs;

Line 355: FND_MSG_PUB.count_and_get(

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.ADD_EXC_MSG('OKL_TRX_MSGS_PUB','update_trx_msgs');
355: FND_MSG_PUB.count_and_get(
356: p_count => x_msg_count
357: ,p_data => x_msg_data);
358: END update_trx_msgs;
359:

Line 427: FND_MSG_PUB.count_and_get(

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

Line 435: FND_MSG_PUB.count_and_get(

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

Line 443: FND_MSG_PUB.ADD_EXC_MSG('OKL_TRX_MSGS_PUB','update_trx_msgs');

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

Line 444: FND_MSG_PUB.count_and_get(

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

Line 513: FND_MSG_PUB.count_and_get(

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

Line 521: FND_MSG_PUB.count_and_get(

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

Line 529: FND_MSG_PUB.ADD_EXC_MSG('OKL_TRX_MSGS_PUB','delete_trx_msgs');

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

Line 530: FND_MSG_PUB.count_and_get(

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

Line 610: FND_MSG_PUB.count_and_get(

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

Line 618: FND_MSG_PUB.count_and_get(

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

Line 626: FND_MSG_PUB.ADD_EXC_MSG('OKL_TRX_MSGS_PUB','delete_trx_msgs');

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

Line 627: FND_MSG_PUB.count_and_get(

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

Line 700: FND_MSG_PUB.count_and_get(

696: ROLLBACK TO trx_msgs_validate;
697: x_return_status := FND_API.G_RET_STS_ERROR;
698: x_msg_count := l_msg_count ;
699: x_msg_data := l_msg_data ;
700: FND_MSG_PUB.count_and_get(
701: p_count => x_msg_count
702: ,p_data => x_msg_data);
703: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
704: ROLLBACK TO trx_msgs_validate;

Line 708: FND_MSG_PUB.count_and_get(

704: ROLLBACK TO trx_msgs_validate;
705: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
706: x_msg_count := l_msg_count ;
707: x_msg_data := l_msg_data ;
708: FND_MSG_PUB.count_and_get(
709: p_count => x_msg_count
710: ,p_data => x_msg_data);
711: WHEN OTHERS THEN
712: ROLLBACK TO trx_msgs_validate;

Line 716: FND_MSG_PUB.ADD_EXC_MSG('OKL_TRX_MSGS_PUB','validate_trx_msgs');

712: ROLLBACK TO trx_msgs_validate;
713: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
714: x_msg_count := l_msg_count ;
715: x_msg_data := l_msg_data ;
716: FND_MSG_PUB.ADD_EXC_MSG('OKL_TRX_MSGS_PUB','validate_trx_msgs');
717: FND_MSG_PUB.count_and_get(
718: p_count => x_msg_count
719: ,p_data => x_msg_data);
720: END validate_trx_msgs;

Line 717: FND_MSG_PUB.count_and_get(

713: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
714: x_msg_count := l_msg_count ;
715: x_msg_data := l_msg_data ;
716: FND_MSG_PUB.ADD_EXC_MSG('OKL_TRX_MSGS_PUB','validate_trx_msgs');
717: FND_MSG_PUB.count_and_get(
718: p_count => x_msg_count
719: ,p_data => x_msg_data);
720: END validate_trx_msgs;
721:

Line 785: FND_MSG_PUB.count_and_get(

781: ROLLBACK TO trx_msgs_validate;
782: x_return_status := FND_API.G_RET_STS_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 FND_API.G_EXC_UNEXPECTED_ERROR THEN
789: ROLLBACK TO trx_msgs_validate;

Line 793: FND_MSG_PUB.count_and_get(

789: ROLLBACK TO trx_msgs_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.count_and_get(
794: p_count => x_msg_count
795: ,p_data => x_msg_data);
796: WHEN OTHERS THEN
797: ROLLBACK TO trx_msgs_validate;

Line 801: FND_MSG_PUB.ADD_EXC_MSG('OKL_TRX_MSGS_PUB','validate_trx_msgs');

797: ROLLBACK TO trx_msgs_validate;
798: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
799: x_msg_count := l_msg_count ;
800: x_msg_data := l_msg_data ;
801: FND_MSG_PUB.ADD_EXC_MSG('OKL_TRX_MSGS_PUB','validate_trx_msgs');
802: FND_MSG_PUB.count_and_get(
803: p_count => x_msg_count
804: ,p_data => x_msg_data);
805: END validate_trx_msgs;

Line 802: FND_MSG_PUB.count_and_get(

798: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
799: x_msg_count := l_msg_count ;
800: x_msg_data := l_msg_data ;
801: FND_MSG_PUB.ADD_EXC_MSG('OKL_TRX_MSGS_PUB','validate_trx_msgs');
802: FND_MSG_PUB.count_and_get(
803: p_count => x_msg_count
804: ,p_data => x_msg_data);
805: END validate_trx_msgs;
806: