DBA Data[Home] [Help]

APPS.OKL_TXD_QTE_LN_DTLS_PUB dependencies on FND_MSG_PUB

Line 53: FND_MSG_PUB.count_and_get(

49: ROLLBACK TO create_txd_qte_ln_dtls;
50: x_return_status := FND_API.G_RET_STS_ERROR;
51: x_msg_count := l_msg_count ;
52: x_msg_data := l_msg_data ;
53: FND_MSG_PUB.count_and_get(
54: p_count => x_msg_count
55: ,p_data => x_msg_data);
56: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
57: ROLLBACK TO create_txd_qte_ln_dtls;

Line 61: FND_MSG_PUB.count_and_get(

57: ROLLBACK TO create_txd_qte_ln_dtls;
58: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
59: x_msg_count := l_msg_count ;
60: x_msg_data := l_msg_data ;
61: FND_MSG_PUB.count_and_get(
62: p_count => x_msg_count
63: ,p_data => x_msg_data);
64: WHEN OTHERS THEN
65: ROLLBACK TO create_txd_qte_ln_dtls;

Line 69: FND_MSG_PUB.ADD_EXC_MSG('OKL_TXD_QTE_LN_DTLS_PUB','create_txd_qte_ln_dtls');

65: ROLLBACK TO create_txd_qte_ln_dtls;
66: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
67: x_msg_count := l_msg_count ;
68: x_msg_data := l_msg_data ;
69: FND_MSG_PUB.ADD_EXC_MSG('OKL_TXD_QTE_LN_DTLS_PUB','create_txd_qte_ln_dtls');
70: FND_MSG_PUB.count_and_get(
71: p_count => x_msg_count
72: ,p_data => x_msg_data);
73: END create_txd_qte_ln_dtls;

Line 70: FND_MSG_PUB.count_and_get(

66: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
67: x_msg_count := l_msg_count ;
68: x_msg_data := l_msg_data ;
69: FND_MSG_PUB.ADD_EXC_MSG('OKL_TXD_QTE_LN_DTLS_PUB','create_txd_qte_ln_dtls');
70: FND_MSG_PUB.count_and_get(
71: p_count => x_msg_count
72: ,p_data => x_msg_data);
73: END create_txd_qte_ln_dtls;
74:

Line 124: FND_MSG_PUB.count_and_get(

120: ROLLBACK TO create_txd_qte_ln_dtls_tbl;
121: x_return_status := FND_API.G_RET_STS_ERROR;
122: x_msg_count := l_msg_count ;
123: x_msg_data := l_msg_data ;
124: FND_MSG_PUB.count_and_get(
125: p_count => x_msg_count
126: ,p_data => x_msg_data);
127: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
128: ROLLBACK TO create_txd_qte_ln_dtls_tbl;

Line 132: FND_MSG_PUB.count_and_get(

128: ROLLBACK TO create_txd_qte_ln_dtls_tbl;
129: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
130: x_msg_count := l_msg_count ;
131: x_msg_data := l_msg_data ;
132: FND_MSG_PUB.count_and_get(
133: p_count => x_msg_count
134: ,p_data => x_msg_data);
135: WHEN OTHERS THEN
136: ROLLBACK TO create_txd_qte_ln_dtls_tbl;

Line 140: FND_MSG_PUB.ADD_EXC_MSG('OKL_TXD_QTE_LN_DTLS_PUB','create_txd_qte_ln_dtls_tbl');

136: ROLLBACK TO create_txd_qte_ln_dtls_tbl;
137: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
138: x_msg_count := l_msg_count ;
139: x_msg_data := l_msg_data ;
140: FND_MSG_PUB.ADD_EXC_MSG('OKL_TXD_QTE_LN_DTLS_PUB','create_txd_qte_ln_dtls_tbl');
141: FND_MSG_PUB.count_and_get(
142: p_count => x_msg_count
143: ,p_data => x_msg_data);
144: END create_txd_qte_ln_dtls;

Line 141: FND_MSG_PUB.count_and_get(

137: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
138: x_msg_count := l_msg_count ;
139: x_msg_data := l_msg_data ;
140: FND_MSG_PUB.ADD_EXC_MSG('OKL_TXD_QTE_LN_DTLS_PUB','create_txd_qte_ln_dtls_tbl');
141: FND_MSG_PUB.count_and_get(
142: p_count => x_msg_count
143: ,p_data => x_msg_data);
144: END create_txd_qte_ln_dtls;
145:

Line 189: FND_MSG_PUB.count_and_get(

185: ROLLBACK TO lock_txd_qte_ln_dtls;
186: x_return_status := FND_API.G_RET_STS_ERROR;
187: x_msg_count := l_msg_count ;
188: x_msg_data := l_msg_data ;
189: FND_MSG_PUB.count_and_get(
190: p_count => x_msg_count
191: ,p_data => x_msg_data);
192: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
193: ROLLBACK TO lock_txd_qte_ln_dtls;

Line 197: FND_MSG_PUB.count_and_get(

193: ROLLBACK TO lock_txd_qte_ln_dtls;
194: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
195: x_msg_count := l_msg_count ;
196: x_msg_data := l_msg_data ;
197: FND_MSG_PUB.count_and_get(
198: p_count => x_msg_count
199: ,p_data => x_msg_data);
200: WHEN OTHERS THEN
201: ROLLBACK TO lock_txd_qte_ln_dtls;

Line 205: FND_MSG_PUB.ADD_EXC_MSG('OKL_TXD_QTE_LN_DTLS_PUB','lock_txd_qte_ln_dtls');

201: ROLLBACK TO lock_txd_qte_ln_dtls;
202: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
203: x_msg_count := l_msg_count ;
204: x_msg_data := l_msg_data ;
205: FND_MSG_PUB.ADD_EXC_MSG('OKL_TXD_QTE_LN_DTLS_PUB','lock_txd_qte_ln_dtls');
206: FND_MSG_PUB.count_and_get(
207: p_count => x_msg_count
208: ,p_data => x_msg_data);
209: END lock_txd_qte_ln_dtls;

Line 206: FND_MSG_PUB.count_and_get(

202: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
203: x_msg_count := l_msg_count ;
204: x_msg_data := l_msg_data ;
205: FND_MSG_PUB.ADD_EXC_MSG('OKL_TXD_QTE_LN_DTLS_PUB','lock_txd_qte_ln_dtls');
206: FND_MSG_PUB.count_and_get(
207: p_count => x_msg_count
208: ,p_data => x_msg_data);
209: END lock_txd_qte_ln_dtls;
210:

Line 254: FND_MSG_PUB.count_and_get(

250: ROLLBACK TO lock_txd_qte_ln_dtls_tbl;
251: x_return_status := FND_API.G_RET_STS_ERROR;
252: x_msg_count := l_msg_count;
253: x_msg_data := l_msg_data;
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: ROLLBACK TO lock_txd_qte_ln_dtls_tbl;

Line 262: FND_MSG_PUB.count_and_get(

258: ROLLBACK TO lock_txd_qte_ln_dtls_tbl;
259: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
260: x_msg_count := l_msg_count;
261: x_msg_data := l_msg_data;
262: FND_MSG_PUB.count_and_get(
263: p_count => x_msg_count
264: ,p_data => x_msg_data);
265: WHEN OTHERS THEN
266: ROLLBACK TO lock_txd_qte_ln_dtls_tbl;

Line 270: FND_MSG_PUB.ADD_EXC_MSG('OKL_TXD_QTE_LN_DTLS_PUB','lock_txd_qte_ln_dtls_tbl');

266: ROLLBACK TO lock_txd_qte_ln_dtls_tbl;
267: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
268: x_msg_count := l_msg_count ;
269: x_msg_data := l_msg_data ;
270: FND_MSG_PUB.ADD_EXC_MSG('OKL_TXD_QTE_LN_DTLS_PUB','lock_txd_qte_ln_dtls_tbl');
271: FND_MSG_PUB.count_and_get(
272: p_count => x_msg_count
273: ,p_data => x_msg_data);
274: END lock_txd_qte_ln_dtls;

Line 271: FND_MSG_PUB.count_and_get(

267: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
268: x_msg_count := l_msg_count ;
269: x_msg_data := l_msg_data ;
270: FND_MSG_PUB.ADD_EXC_MSG('OKL_TXD_QTE_LN_DTLS_PUB','lock_txd_qte_ln_dtls_tbl');
271: FND_MSG_PUB.count_and_get(
272: p_count => x_msg_count
273: ,p_data => x_msg_data);
274: END lock_txd_qte_ln_dtls;
275:

Line 325: FND_MSG_PUB.count_and_get(

321: ROLLBACK TO update_txd_qte_ln_dtls;
322: x_return_status := FND_API.G_RET_STS_ERROR;
323: x_msg_count := l_msg_count ;
324: x_msg_data := l_msg_data ;
325: FND_MSG_PUB.count_and_get(
326: p_count => x_msg_count
327: ,p_data => x_msg_data);
328: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
329: ROLLBACK TO update_txd_qte_ln_dtls;

Line 333: FND_MSG_PUB.count_and_get(

329: ROLLBACK TO update_txd_qte_ln_dtls;
330: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
331: x_msg_count := l_msg_count ;
332: x_msg_data := l_msg_data ;
333: FND_MSG_PUB.count_and_get(
334: p_count => x_msg_count
335: ,p_data => x_msg_data);
336: WHEN OTHERS THEN
337: ROLLBACK TO update_txd_qte_ln_dtls;

Line 341: FND_MSG_PUB.ADD_EXC_MSG('OKL_TXD_QTE_LN_DTLS_PUB','update_txd_qte_ln_dtls');

337: ROLLBACK TO update_txd_qte_ln_dtls;
338: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
339: x_msg_count := l_msg_count ;
340: x_msg_data := l_msg_data ;
341: FND_MSG_PUB.ADD_EXC_MSG('OKL_TXD_QTE_LN_DTLS_PUB','update_txd_qte_ln_dtls');
342: FND_MSG_PUB.count_and_get(
343: p_count => x_msg_count
344: ,p_data => x_msg_data);
345: END update_txd_qte_ln_dtls;

Line 342: FND_MSG_PUB.count_and_get(

338: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
339: x_msg_count := l_msg_count ;
340: x_msg_data := l_msg_data ;
341: FND_MSG_PUB.ADD_EXC_MSG('OKL_TXD_QTE_LN_DTLS_PUB','update_txd_qte_ln_dtls');
342: FND_MSG_PUB.count_and_get(
343: p_count => x_msg_count
344: ,p_data => x_msg_data);
345: END update_txd_qte_ln_dtls;
346:

Line 395: FND_MSG_PUB.count_and_get(

391: ROLLBACK TO update_txd_qte_ln_dtls_tbl;
392: x_return_status := FND_API.G_RET_STS_ERROR;
393: x_msg_count := l_msg_count ;
394: x_msg_data := l_msg_data ;
395: FND_MSG_PUB.count_and_get(
396: p_count => x_msg_count
397: ,p_data => x_msg_data);
398: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
399: ROLLBACK TO update_txd_qte_ln_dtls_tbl;

Line 403: FND_MSG_PUB.count_and_get(

399: ROLLBACK TO update_txd_qte_ln_dtls_tbl;
400: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
401: x_msg_count := l_msg_count ;
402: x_msg_data := l_msg_data ;
403: FND_MSG_PUB.count_and_get(
404: p_count => x_msg_count
405: ,p_data => x_msg_data);
406: WHEN OTHERS THEN
407: ROLLBACK TO update_txd_qte_ln_dtls_tbl;

Line 411: FND_MSG_PUB.ADD_EXC_MSG('OKL_TXD_QTE_LN_DTLS_PUB','update_txd_qte_ln_dtls_tbl');

407: ROLLBACK TO update_txd_qte_ln_dtls_tbl;
408: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
409: x_msg_count := l_msg_count ;
410: x_msg_data := l_msg_data ;
411: FND_MSG_PUB.ADD_EXC_MSG('OKL_TXD_QTE_LN_DTLS_PUB','update_txd_qte_ln_dtls_tbl');
412: FND_MSG_PUB.count_and_get(
413: p_count => x_msg_count
414: ,p_data => x_msg_data);
415: END update_txd_qte_ln_dtls;

Line 412: FND_MSG_PUB.count_and_get(

408: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
409: x_msg_count := l_msg_count ;
410: x_msg_data := l_msg_data ;
411: FND_MSG_PUB.ADD_EXC_MSG('OKL_TXD_QTE_LN_DTLS_PUB','update_txd_qte_ln_dtls_tbl');
412: FND_MSG_PUB.count_and_get(
413: p_count => x_msg_count
414: ,p_data => x_msg_data);
415: END update_txd_qte_ln_dtls;
416:

Line 461: FND_MSG_PUB.count_and_get(

457: ROLLBACK TO delete_txd_qte_ln_dtls;
458: x_return_status := FND_API.G_RET_STS_ERROR;
459: x_msg_count := l_msg_count ;
460: x_msg_data := l_msg_data ;
461: FND_MSG_PUB.count_and_get(
462: p_count => x_msg_count
463: ,p_data => x_msg_data);
464: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
465: ROLLBACK TO delete_txd_qte_ln_dtls;

Line 469: FND_MSG_PUB.count_and_get(

465: ROLLBACK TO delete_txd_qte_ln_dtls;
466: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
467: x_msg_count := l_msg_count ;
468: x_msg_data := l_msg_data ;
469: FND_MSG_PUB.count_and_get(
470: p_count => x_msg_count
471: ,p_data => x_msg_data);
472: WHEN OTHERS THEN
473: ROLLBACK TO delete_txd_qte_ln_dtls;

Line 477: FND_MSG_PUB.ADD_EXC_MSG('OKL_TXD_QTE_LN_DTLS_PUB','delete_txd_qte_ln_dtls');

473: ROLLBACK TO delete_txd_qte_ln_dtls;
474: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
475: x_msg_count := l_msg_count ;
476: x_msg_data := l_msg_data ;
477: FND_MSG_PUB.ADD_EXC_MSG('OKL_TXD_QTE_LN_DTLS_PUB','delete_txd_qte_ln_dtls');
478: FND_MSG_PUB.count_and_get(
479: p_count => x_msg_count
480: ,p_data => x_msg_data);
481: END delete_txd_qte_ln_dtls;

Line 478: FND_MSG_PUB.count_and_get(

474: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
475: x_msg_count := l_msg_count ;
476: x_msg_data := l_msg_data ;
477: FND_MSG_PUB.ADD_EXC_MSG('OKL_TXD_QTE_LN_DTLS_PUB','delete_txd_qte_ln_dtls');
478: FND_MSG_PUB.count_and_get(
479: p_count => x_msg_count
480: ,p_data => x_msg_data);
481: END delete_txd_qte_ln_dtls;
482:

Line 526: FND_MSG_PUB.count_and_get(

522: ROLLBACK TO delete_txd_qte_ln_dtls_tbl;
523: x_return_status := FND_API.G_RET_STS_ERROR;
524: x_msg_count := l_msg_count ;
525: x_msg_data := l_msg_data ;
526: FND_MSG_PUB.count_and_get(
527: p_count => x_msg_count
528: ,p_data => x_msg_data);
529: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
530: ROLLBACK TO delete_txd_qte_ln_dtls_tbl;

Line 534: FND_MSG_PUB.count_and_get(

530: ROLLBACK TO delete_txd_qte_ln_dtls_tbl;
531: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
532: x_msg_count := l_msg_count ;
533: x_msg_data := l_msg_data ;
534: FND_MSG_PUB.count_and_get(
535: p_count => x_msg_count
536: ,p_data => x_msg_data);
537: WHEN OTHERS THEN
538: ROLLBACK TO delete_txd_qte_ln_dtls_tbl;

Line 542: FND_MSG_PUB.ADD_EXC_MSG('OKL_TXD_QTE_LN_DTLS_PUB','delete_txd_qte_ln_dtls_tbl');

538: ROLLBACK TO delete_txd_qte_ln_dtls_tbl;
539: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
540: x_msg_count := l_msg_count ;
541: x_msg_data := l_msg_data ;
542: FND_MSG_PUB.ADD_EXC_MSG('OKL_TXD_QTE_LN_DTLS_PUB','delete_txd_qte_ln_dtls_tbl');
543: FND_MSG_PUB.count_and_get(
544: p_count => x_msg_count
545: ,p_data => x_msg_data);
546: END delete_txd_qte_ln_dtls;

Line 543: FND_MSG_PUB.count_and_get(

539: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
540: x_msg_count := l_msg_count ;
541: x_msg_data := l_msg_data ;
542: FND_MSG_PUB.ADD_EXC_MSG('OKL_TXD_QTE_LN_DTLS_PUB','delete_txd_qte_ln_dtls_tbl');
543: FND_MSG_PUB.count_and_get(
544: p_count => x_msg_count
545: ,p_data => x_msg_data);
546: END delete_txd_qte_ln_dtls;
547:

Line 591: FND_MSG_PUB.count_and_get(

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

Line 599: FND_MSG_PUB.count_and_get(

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

Line 607: FND_MSG_PUB.ADD_EXC_MSG('OKL_TXD_QTE_LN_DTLS_PUB','validate_txd_qte_ln_dtls');

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

Line 608: FND_MSG_PUB.count_and_get(

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

Line 656: FND_MSG_PUB.count_and_get(

652: ROLLBACK TO validate_txd_qte_ln_dtls_tbl;
653: x_return_status := FND_API.G_RET_STS_ERROR;
654: x_msg_count := l_msg_count ;
655: x_msg_data := l_msg_data ;
656: FND_MSG_PUB.count_and_get(
657: p_count => x_msg_count
658: ,p_data => x_msg_data);
659: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
660: ROLLBACK TO validate_txd_qte_ln_dtls_tbl;

Line 664: FND_MSG_PUB.count_and_get(

660: ROLLBACK TO validate_txd_qte_ln_dtls_tbl;
661: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
662: x_msg_count := l_msg_count ;
663: x_msg_data := l_msg_data ;
664: FND_MSG_PUB.count_and_get(
665: p_count => x_msg_count
666: ,p_data => x_msg_data);
667: WHEN OTHERS THEN
668: ROLLBACK TO validate_txd_qte_ln_dtls_tbl;

Line 672: FND_MSG_PUB.ADD_EXC_MSG('OKL_TXD_QTE_LN_DTLS_PUB','validate_txd_qte_ln_dtls_tbl');

668: ROLLBACK TO validate_txd_qte_ln_dtls_tbl;
669: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
670: x_msg_count := l_msg_count ;
671: x_msg_data := l_msg_data ;
672: FND_MSG_PUB.ADD_EXC_MSG('OKL_TXD_QTE_LN_DTLS_PUB','validate_txd_qte_ln_dtls_tbl');
673: FND_MSG_PUB.count_and_get(
674: p_count => x_msg_count
675: ,p_data => x_msg_data);
676: END validate_txd_qte_ln_dtls;

Line 673: FND_MSG_PUB.count_and_get(

669: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
670: x_msg_count := l_msg_count ;
671: x_msg_data := l_msg_data ;
672: FND_MSG_PUB.ADD_EXC_MSG('OKL_TXD_QTE_LN_DTLS_PUB','validate_txd_qte_ln_dtls_tbl');
673: FND_MSG_PUB.count_and_get(
674: p_count => x_msg_count
675: ,p_data => x_msg_data);
676: END validate_txd_qte_ln_dtls;
677: END OKL_TXD_QTE_LN_DTLS_PUB;