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;
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;
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;
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:
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;
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;
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;
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:
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;
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;
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;
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:
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;
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;
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;
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:
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;
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;
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;
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:
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;
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;
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;
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:
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;
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;
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;
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:
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;
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;
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;
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:
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;
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;
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;
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:
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;
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;
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;
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;