DBA Data[Home] [Help]

APPS.OKL_TRX_QUOTES_PUB dependencies on FND_MSG_PUB

Line 105: FND_MSG_PUB.count_and_get(

101: ROLLBACK TO trx_quotes_insert;
102: x_return_status := FND_API.G_RET_STS_ERROR;
103: x_msg_count := l_msg_count ;
104: x_msg_data := l_msg_data ;
105: FND_MSG_PUB.count_and_get(
106: p_count => x_msg_count
107: ,p_data => x_msg_data);
108: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
109: ROLLBACK TO trx_quotes_insert;

Line 113: FND_MSG_PUB.count_and_get(

109: ROLLBACK TO trx_quotes_insert;
110: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
111: x_msg_count := l_msg_count ;
112: x_msg_data := l_msg_data ;
113: FND_MSG_PUB.count_and_get(
114: p_count => x_msg_count
115: ,p_data => x_msg_data);
116: WHEN OTHERS THEN
117:

Line 126: FND_MSG_PUB.ADD_EXC_MSG('OKL_TRX_QUOTES_PUB','insert_trx_quotes');

122: ROLLBACK TO trx_quotes_insert;
123: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
124: x_msg_count := l_msg_count ;
125: x_msg_data := l_msg_data ;
126: FND_MSG_PUB.ADD_EXC_MSG('OKL_TRX_QUOTES_PUB','insert_trx_quotes');
127: FND_MSG_PUB.count_and_get(
128: p_count => x_msg_count
129: ,p_data => x_msg_data);
130: END insert_trx_quotes;

Line 127: FND_MSG_PUB.count_and_get(

123: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
124: x_msg_count := l_msg_count ;
125: x_msg_data := l_msg_data ;
126: FND_MSG_PUB.ADD_EXC_MSG('OKL_TRX_QUOTES_PUB','insert_trx_quotes');
127: FND_MSG_PUB.count_and_get(
128: p_count => x_msg_count
129: ,p_data => x_msg_data);
130: END insert_trx_quotes;
131:

Line 224: FND_MSG_PUB.count_and_get(

220: ROLLBACK TO trx_quotes_insert;
221: x_return_status := FND_API.G_RET_STS_ERROR;
222: x_msg_count := l_msg_count ;
223: x_msg_data := l_msg_data ;
224: FND_MSG_PUB.count_and_get(
225: p_count => x_msg_count
226: ,p_data => x_msg_data);
227: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
228: ROLLBACK TO trx_quotes_insert;

Line 232: FND_MSG_PUB.count_and_get(

228: ROLLBACK TO trx_quotes_insert;
229: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
230: x_msg_count := l_msg_count ;
231: x_msg_data := l_msg_data ;
232: FND_MSG_PUB.count_and_get(
233: p_count => x_msg_count
234: ,p_data => x_msg_data);
235: WHEN OTHERS THEN
236: IF (is_debug_exception_on) THEN

Line 244: FND_MSG_PUB.ADD_EXC_MSG('OKL_TRX_QUOTES_PUB','insert_trx_quotes');

240: ROLLBACK TO trx_quotes_insert;
241: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
242: x_msg_count := l_msg_count ;
243: x_msg_data := l_msg_data ;
244: FND_MSG_PUB.ADD_EXC_MSG('OKL_TRX_QUOTES_PUB','insert_trx_quotes');
245: FND_MSG_PUB.count_and_get(
246: p_count => x_msg_count
247: ,p_data => x_msg_data);
248: END insert_trx_quotes;

Line 245: FND_MSG_PUB.count_and_get(

241: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
242: x_msg_count := l_msg_count ;
243: x_msg_data := l_msg_data ;
244: FND_MSG_PUB.ADD_EXC_MSG('OKL_TRX_QUOTES_PUB','insert_trx_quotes');
245: FND_MSG_PUB.count_and_get(
246: p_count => x_msg_count
247: ,p_data => x_msg_data);
248: END insert_trx_quotes;
249:

Line 302: FND_MSG_PUB.count_and_get(

298:
299: EXCEPTION
300:
301: WHEN FND_API.G_EXC_ERROR THEN
302: FND_MSG_PUB.count_and_get(
303: p_count => x_msg_count
304: ,p_data => x_msg_data);
305: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
306: FND_MSG_PUB.count_and_get(

Line 306: FND_MSG_PUB.count_and_get(

302: FND_MSG_PUB.count_and_get(
303: p_count => x_msg_count
304: ,p_data => x_msg_data);
305: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
306: FND_MSG_PUB.count_and_get(
307: p_count => x_msg_count
308: ,p_data => x_msg_data);
309: WHEN OTHERS THEN
310: IF (is_debug_exception_on) THEN

Line 315: FND_MSG_PUB.ADD_EXC_MSG('OKL_TRX_QUOTES_PUB','lock_trx_quotes');

311: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_EXCEPTION,L_MODULE_NAME, 'EXCEPTION :'||'OTHERS, SQLCODE: '
312: || sqlcode || ' , SQLERRM : ' || sqlerrm);
313: END IF;
314: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
315: FND_MSG_PUB.ADD_EXC_MSG('OKL_TRX_QUOTES_PUB','lock_trx_quotes');
316: FND_MSG_PUB.count_and_get(
317: p_count => x_msg_count
318: ,p_data => x_msg_data);
319: END lock_trx_quotes;

Line 316: FND_MSG_PUB.count_and_get(

312: || sqlcode || ' , SQLERRM : ' || sqlerrm);
313: END IF;
314: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
315: FND_MSG_PUB.ADD_EXC_MSG('OKL_TRX_QUOTES_PUB','lock_trx_quotes');
316: FND_MSG_PUB.count_and_get(
317: p_count => x_msg_count
318: ,p_data => x_msg_data);
319: END lock_trx_quotes;
320:

Line 373: FND_MSG_PUB.count_and_get(

369: WHEN FND_API.G_EXC_ERROR THEN
370: IF (is_debug_exception_on) THEN
371: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_EXCEPTION,L_MODULE_NAME, 'EXCEPTION :'||'USER DEFINED');
372: END IF;
373: FND_MSG_PUB.count_and_get(
374: p_count => x_msg_count
375: ,p_data => x_msg_data);
376: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
377: IF (is_debug_exception_on) THEN

Line 381: FND_MSG_PUB.count_and_get(

377: IF (is_debug_exception_on) THEN
378: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_EXCEPTION,L_MODULE_NAME, 'EXCEPTION :'||'UNEXPECTED');
379: END IF;
380:
381: FND_MSG_PUB.count_and_get(
382: p_count => x_msg_count
383: ,p_data => x_msg_data);
384: WHEN OTHERS THEN
385:

Line 392: FND_MSG_PUB.ADD_EXC_MSG('OKL_TRX_QUOTES_PUB','lock_trx_quotes');

388: || sqlcode || ' , SQLERRM : ' || sqlerrm);
389: END IF;
390:
391: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
392: FND_MSG_PUB.ADD_EXC_MSG('OKL_TRX_QUOTES_PUB','lock_trx_quotes');
393: FND_MSG_PUB.count_and_get(
394: p_count => x_msg_count
395: ,p_data => x_msg_data);
396: END lock_trx_quotes;

Line 393: FND_MSG_PUB.count_and_get(

389: END IF;
390:
391: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
392: FND_MSG_PUB.ADD_EXC_MSG('OKL_TRX_QUOTES_PUB','lock_trx_quotes');
393: FND_MSG_PUB.count_and_get(
394: p_count => x_msg_count
395: ,p_data => x_msg_data);
396: END lock_trx_quotes;
397:

Line 492: FND_MSG_PUB.count_and_get(

488: ROLLBACK TO trx_quotes_update;
489: x_return_status := FND_API.G_RET_STS_ERROR;
490: x_msg_count := l_msg_count ;
491: x_msg_data := l_msg_data ;
492: FND_MSG_PUB.count_and_get(
493: p_count => x_msg_count
494: ,p_data => x_msg_data);
495: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
496: IF (is_debug_exception_on) THEN

Line 504: FND_MSG_PUB.count_and_get(

500: ROLLBACK TO trx_quotes_update;
501: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
502: x_msg_count := l_msg_count ;
503: x_msg_data := l_msg_data ;
504: FND_MSG_PUB.count_and_get(
505: p_count => x_msg_count
506: ,p_data => x_msg_data);
507: WHEN OTHERS THEN
508:

Line 518: FND_MSG_PUB.ADD_EXC_MSG('OKL_TRX_QUOTES_PUB','update_trx_quotes');

514: ROLLBACK TO trx_quotes_update;
515: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
516: x_msg_count := l_msg_count ;
517: x_msg_data := l_msg_data ;
518: FND_MSG_PUB.ADD_EXC_MSG('OKL_TRX_QUOTES_PUB','update_trx_quotes');
519: FND_MSG_PUB.count_and_get(
520: p_count => x_msg_count
521: ,p_data => x_msg_data);
522: END update_trx_quotes;

Line 519: FND_MSG_PUB.count_and_get(

515: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
516: x_msg_count := l_msg_count ;
517: x_msg_data := l_msg_data ;
518: FND_MSG_PUB.ADD_EXC_MSG('OKL_TRX_QUOTES_PUB','update_trx_quotes');
519: FND_MSG_PUB.count_and_get(
520: p_count => x_msg_count
521: ,p_data => x_msg_data);
522: END update_trx_quotes;
523:

Line 619: FND_MSG_PUB.count_and_get(

615: ROLLBACK TO trx_quotes_update;
616: x_return_status := FND_API.G_RET_STS_ERROR;
617: x_msg_count := l_msg_count ;
618: x_msg_data := l_msg_data ;
619: FND_MSG_PUB.count_and_get(
620: p_count => x_msg_count
621: ,p_data => x_msg_data);
622: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
623:

Line 631: FND_MSG_PUB.count_and_get(

627: ROLLBACK TO trx_quotes_update;
628: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
629: x_msg_count := l_msg_count ;
630: x_msg_data := l_msg_data ;
631: FND_MSG_PUB.count_and_get(
632: p_count => x_msg_count
633: ,p_data => x_msg_data);
634: WHEN OTHERS THEN
635:

Line 645: FND_MSG_PUB.ADD_EXC_MSG('OKL_TRX_QUOTES_PUB','update_trx_quotes');

641: ROLLBACK TO trx_quotes_update;
642: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
643: x_msg_count := l_msg_count ;
644: x_msg_data := l_msg_data ;
645: FND_MSG_PUB.ADD_EXC_MSG('OKL_TRX_QUOTES_PUB','update_trx_quotes');
646: FND_MSG_PUB.count_and_get(
647: p_count => x_msg_count
648: ,p_data => x_msg_data);
649: END update_trx_quotes;

Line 646: FND_MSG_PUB.count_and_get(

642: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
643: x_msg_count := l_msg_count ;
644: x_msg_data := l_msg_data ;
645: FND_MSG_PUB.ADD_EXC_MSG('OKL_TRX_QUOTES_PUB','update_trx_quotes');
646: FND_MSG_PUB.count_and_get(
647: p_count => x_msg_count
648: ,p_data => x_msg_data);
649: END update_trx_quotes;
650:

Line 741: FND_MSG_PUB.count_and_get(

737: ROLLBACK TO trx_quotes_delete_rec;
738: x_return_status := FND_API.G_RET_STS_ERROR;
739: x_msg_count := l_msg_count ;
740: x_msg_data := l_msg_data ;
741: FND_MSG_PUB.count_and_get(
742: p_count => x_msg_count
743: ,p_data => x_msg_data);
744: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
745:

Line 753: FND_MSG_PUB.count_and_get(

749: ROLLBACK TO trx_quotes_delete_rec;
750: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
751: x_msg_count := l_msg_count ;
752: x_msg_data := l_msg_data ;
753: FND_MSG_PUB.count_and_get(
754: p_count => x_msg_count
755: ,p_data => x_msg_data);
756: WHEN OTHERS THEN
757: IF (is_debug_exception_on) THEN

Line 766: FND_MSG_PUB.ADD_EXC_MSG('OKL_TRX_QUOTES_PUB','delete_trx_quotes');

762: ROLLBACK TO trx_quotes_delete_rec;
763: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
764: x_msg_count := l_msg_count ;
765: x_msg_data := l_msg_data ;
766: FND_MSG_PUB.ADD_EXC_MSG('OKL_TRX_QUOTES_PUB','delete_trx_quotes');
767: FND_MSG_PUB.count_and_get(
768: p_count => x_msg_count
769: ,p_data => x_msg_data);
770: END delete_trx_quotes;

Line 767: FND_MSG_PUB.count_and_get(

763: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
764: x_msg_count := l_msg_count ;
765: x_msg_data := l_msg_data ;
766: FND_MSG_PUB.ADD_EXC_MSG('OKL_TRX_QUOTES_PUB','delete_trx_quotes');
767: FND_MSG_PUB.count_and_get(
768: p_count => x_msg_count
769: ,p_data => x_msg_data);
770: END delete_trx_quotes;
771:

Line 871: FND_MSG_PUB.count_and_get(

867: ROLLBACK TO trx_quotes_delete_tbl;
868: x_return_status := FND_API.G_RET_STS_ERROR;
869: x_msg_count := l_msg_count ;
870: x_msg_data := l_msg_data ;
871: FND_MSG_PUB.count_and_get(
872: p_count => x_msg_count
873: ,p_data => x_msg_data);
874: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
875: IF (is_debug_exception_on) THEN

Line 883: FND_MSG_PUB.count_and_get(

879: ROLLBACK TO trx_quotes_delete_tbl;
880: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
881: x_msg_count := l_msg_count ;
882: x_msg_data := l_msg_data ;
883: FND_MSG_PUB.count_and_get(
884: p_count => x_msg_count
885: ,p_data => x_msg_data);
886: WHEN OTHERS THEN
887:

Line 897: FND_MSG_PUB.ADD_EXC_MSG('OKL_TRX_QUOTES_PUB','delete_trx_quotes');

893: ROLLBACK TO trx_quotes_delete_tbl;
894: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
895: x_msg_count := l_msg_count ;
896: x_msg_data := l_msg_data ;
897: FND_MSG_PUB.ADD_EXC_MSG('OKL_TRX_QUOTES_PUB','delete_trx_quotes');
898: FND_MSG_PUB.count_and_get(
899: p_count => x_msg_count
900: ,p_data => x_msg_data);
901: END delete_trx_quotes;

Line 898: FND_MSG_PUB.count_and_get(

894: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
895: x_msg_count := l_msg_count ;
896: x_msg_data := l_msg_data ;
897: FND_MSG_PUB.ADD_EXC_MSG('OKL_TRX_QUOTES_PUB','delete_trx_quotes');
898: FND_MSG_PUB.count_and_get(
899: p_count => x_msg_count
900: ,p_data => x_msg_data);
901: END delete_trx_quotes;
902:

Line 991: FND_MSG_PUB.count_and_get(

987: ROLLBACK TO trx_quotes_validate;
988: x_return_status := FND_API.G_RET_STS_ERROR;
989: x_msg_count := l_msg_count ;
990: x_msg_data := l_msg_data ;
991: FND_MSG_PUB.count_and_get(
992: p_count => x_msg_count
993: ,p_data => x_msg_data);
994: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
995:

Line 1004: FND_MSG_PUB.count_and_get(

1000: ROLLBACK TO trx_quotes_validate;
1001: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1002: x_msg_count := l_msg_count ;
1003: x_msg_data := l_msg_data ;
1004: FND_MSG_PUB.count_and_get(
1005: p_count => x_msg_count
1006: ,p_data => x_msg_data);
1007: WHEN OTHERS THEN
1008: IF (is_debug_exception_on) THEN

Line 1016: FND_MSG_PUB.ADD_EXC_MSG('OKL_TRX_QUOTES_PUB','validate_trx_quotes');

1012: ROLLBACK TO trx_quotes_validate;
1013: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1014: x_msg_count := l_msg_count ;
1015: x_msg_data := l_msg_data ;
1016: FND_MSG_PUB.ADD_EXC_MSG('OKL_TRX_QUOTES_PUB','validate_trx_quotes');
1017: FND_MSG_PUB.count_and_get(
1018: p_count => x_msg_count
1019: ,p_data => x_msg_data);
1020: END validate_trx_quotes;

Line 1017: FND_MSG_PUB.count_and_get(

1013: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1014: x_msg_count := l_msg_count ;
1015: x_msg_data := l_msg_data ;
1016: FND_MSG_PUB.ADD_EXC_MSG('OKL_TRX_QUOTES_PUB','validate_trx_quotes');
1017: FND_MSG_PUB.count_and_get(
1018: p_count => x_msg_count
1019: ,p_data => x_msg_data);
1020: END validate_trx_quotes;
1021:

Line 1108: FND_MSG_PUB.count_and_get(

1104: ROLLBACK TO trx_quotes_validate;
1105: x_return_status := FND_API.G_RET_STS_ERROR;
1106: x_msg_count := l_msg_count ;
1107: x_msg_data := l_msg_data ;
1108: FND_MSG_PUB.count_and_get(
1109: p_count => x_msg_count
1110: ,p_data => x_msg_data);
1111: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1112:

Line 1121: FND_MSG_PUB.count_and_get(

1117: ROLLBACK TO trx_quotes_validate;
1118: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1119: x_msg_count := l_msg_count ;
1120: x_msg_data := l_msg_data ;
1121: FND_MSG_PUB.count_and_get(
1122: p_count => x_msg_count
1123: ,p_data => x_msg_data);
1124: WHEN OTHERS THEN
1125: IF (is_debug_exception_on) THEN

Line 1133: FND_MSG_PUB.ADD_EXC_MSG('OKL_TRX_QUOTES_PUB','validate_trx_quotes');

1129: ROLLBACK TO trx_quotes_validate;
1130: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1131: x_msg_count := l_msg_count ;
1132: x_msg_data := l_msg_data ;
1133: FND_MSG_PUB.ADD_EXC_MSG('OKL_TRX_QUOTES_PUB','validate_trx_quotes');
1134: FND_MSG_PUB.count_and_get(
1135: p_count => x_msg_count
1136: ,p_data => x_msg_data);
1137: END validate_trx_quotes;

Line 1134: FND_MSG_PUB.count_and_get(

1130: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1131: x_msg_count := l_msg_count ;
1132: x_msg_data := l_msg_data ;
1133: FND_MSG_PUB.ADD_EXC_MSG('OKL_TRX_QUOTES_PUB','validate_trx_quotes');
1134: FND_MSG_PUB.count_and_get(
1135: p_count => x_msg_count
1136: ,p_data => x_msg_data);
1137: END validate_trx_quotes;
1138: