298: ROLLBACK TO tbc_insert;
299: x_return_status := FND_API.G_RET_STS_ERROR;
300: x_msg_count := l_msg_count ;
301: x_msg_data := l_msg_data ;
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: ROLLBACK TO tbc_insert;
306: ROLLBACK TO tbc_insert;
307: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
308: x_msg_count := l_msg_count ;
309: x_msg_data := l_msg_data ;
310: FND_MSG_PUB.count_and_get(
311: p_count => x_msg_count
312: ,p_data => x_msg_data);
313: WHEN OTHERS THEN
314: ROLLBACK TO tbc_insert;
314: ROLLBACK TO tbc_insert;
315: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
316: x_msg_count := l_msg_count ;
317: x_msg_data := l_msg_data ;
318: FND_MSG_PUB.ADD_EXC_MSG('OKL_TBC_DEFINITIONS_PUB','insert_tbc_definition');
319: FND_MSG_PUB.count_and_get(
320: p_count => x_msg_count
321: ,p_data => x_msg_data);
322: END insert_tbc_definition;
315: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
316: x_msg_count := l_msg_count ;
317: x_msg_data := l_msg_data ;
318: FND_MSG_PUB.ADD_EXC_MSG('OKL_TBC_DEFINITIONS_PUB','insert_tbc_definition');
319: FND_MSG_PUB.count_and_get(
320: p_count => x_msg_count
321: ,p_data => x_msg_data);
322: END insert_tbc_definition;
323:
394: ROLLBACK TO tbc_insert;
395: x_return_status := FND_API.G_RET_STS_ERROR;
396: x_msg_count := l_msg_count ;
397: x_msg_data := l_msg_data ;
398: FND_MSG_PUB.count_and_get(
399: p_count => x_msg_count
400: ,p_data => x_msg_data);
401: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
402: ROLLBACK TO tbc_insert;
402: ROLLBACK TO tbc_insert;
403: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
404: x_msg_count := l_msg_count ;
405: x_msg_data := l_msg_data ;
406: FND_MSG_PUB.count_and_get(
407: p_count => x_msg_count
408: ,p_data => x_msg_data);
409: WHEN OTHERS THEN
410: ROLLBACK TO tbc_insert;
410: ROLLBACK TO tbc_insert;
411: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
412: x_msg_count := l_msg_count ;
413: x_msg_data := l_msg_data ;
414: FND_MSG_PUB.ADD_EXC_MSG('OKL_TBC_DEFINITIONS_PUB','insert_tbc_definition');
415: FND_MSG_PUB.count_and_get(
416: p_count => x_msg_count
417: ,p_data => x_msg_data);
418: END insert_tbc_definition;
411: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
412: x_msg_count := l_msg_count ;
413: x_msg_data := l_msg_data ;
414: FND_MSG_PUB.ADD_EXC_MSG('OKL_TBC_DEFINITIONS_PUB','insert_tbc_definition');
415: FND_MSG_PUB.count_and_get(
416: p_count => x_msg_count
417: ,p_data => x_msg_data);
418: END insert_tbc_definition;
419:
443:
444: EXCEPTION
445:
446: WHEN FND_API.G_EXC_ERROR THEN
447: FND_MSG_PUB.count_and_get(
448: p_count => x_msg_count
449: ,p_data => x_msg_data);
450: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
451: FND_MSG_PUB.count_and_get(
447: FND_MSG_PUB.count_and_get(
448: p_count => x_msg_count
449: ,p_data => x_msg_data);
450: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
451: FND_MSG_PUB.count_and_get(
452: p_count => x_msg_count
453: ,p_data => x_msg_data);
454: WHEN OTHERS THEN
455: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
452: p_count => x_msg_count
453: ,p_data => x_msg_data);
454: WHEN OTHERS THEN
455: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
456: FND_MSG_PUB.ADD_EXC_MSG('OKL_TBC_DEFINITIONS_PUB','lock_tbc_definition');
457: FND_MSG_PUB.count_and_get(
458: p_count => x_msg_count
459: ,p_data => x_msg_data);
460: END lock_tbc_definition;
453: ,p_data => x_msg_data);
454: WHEN OTHERS THEN
455: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
456: FND_MSG_PUB.ADD_EXC_MSG('OKL_TBC_DEFINITIONS_PUB','lock_tbc_definition');
457: FND_MSG_PUB.count_and_get(
458: p_count => x_msg_count
459: ,p_data => x_msg_data);
460: END lock_tbc_definition;
461:
486:
487: EXCEPTION
488:
489: WHEN FND_API.G_EXC_ERROR THEN
490: FND_MSG_PUB.count_and_get(
491: p_count => x_msg_count
492: ,p_data => x_msg_data);
493: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
494: FND_MSG_PUB.count_and_get(
490: FND_MSG_PUB.count_and_get(
491: p_count => x_msg_count
492: ,p_data => x_msg_data);
493: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
494: FND_MSG_PUB.count_and_get(
495: p_count => x_msg_count
496: ,p_data => x_msg_data);
497: WHEN OTHERS THEN
498: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
495: p_count => x_msg_count
496: ,p_data => x_msg_data);
497: WHEN OTHERS THEN
498: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
499: FND_MSG_PUB.ADD_EXC_MSG('OKL_TBC_DEFINITIONS_PUB','lock_tbc_definition');
500: FND_MSG_PUB.count_and_get(
501: p_count => x_msg_count
502: ,p_data => x_msg_data);
503: END lock_tbc_definition;
496: ,p_data => x_msg_data);
497: WHEN OTHERS THEN
498: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
499: FND_MSG_PUB.ADD_EXC_MSG('OKL_TBC_DEFINITIONS_PUB','lock_tbc_definition');
500: FND_MSG_PUB.count_and_get(
501: p_count => x_msg_count
502: ,p_data => x_msg_data);
503: END lock_tbc_definition;
504:
571: ROLLBACK TO tbc_update;
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 tbc_update;
579: ROLLBACK TO tbc_update;
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 tbc_update;
587: ROLLBACK TO tbc_update;
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_TBC_DEFINITIONS_PUB','update_tbc_definition');
592: FND_MSG_PUB.count_and_get(
593: p_count => x_msg_count
594: ,p_data => x_msg_data);
595: END update_tbc_definition;
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_TBC_DEFINITIONS_PUB','update_tbc_definition');
592: FND_MSG_PUB.count_and_get(
593: p_count => x_msg_count
594: ,p_data => x_msg_data);
595: END update_tbc_definition;
596:
660: ROLLBACK TO tbc_update;
661: x_return_status := FND_API.G_RET_STS_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 FND_API.G_EXC_UNEXPECTED_ERROR THEN
668: ROLLBACK TO tbc_update;
668: ROLLBACK TO tbc_update;
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.count_and_get(
673: p_count => x_msg_count
674: ,p_data => x_msg_data);
675: WHEN OTHERS THEN
676: ROLLBACK TO tbc_update;
676: ROLLBACK TO tbc_update;
677: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
678: x_msg_count := l_msg_count ;
679: x_msg_data := l_msg_data ;
680: FND_MSG_PUB.ADD_EXC_MSG('OKL_TBC_DEFINITIONS_PUB','update_tbc_definition');
681: FND_MSG_PUB.count_and_get(
682: p_count => x_msg_count
683: ,p_data => x_msg_data);
684: END update_tbc_definition;
677: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
678: x_msg_count := l_msg_count ;
679: x_msg_data := l_msg_data ;
680: FND_MSG_PUB.ADD_EXC_MSG('OKL_TBC_DEFINITIONS_PUB','update_tbc_definition');
681: FND_MSG_PUB.count_and_get(
682: p_count => x_msg_count
683: ,p_data => x_msg_data);
684: END update_tbc_definition;
685:
746: ROLLBACK TO tbc_delete;
747: x_return_status := FND_API.G_RET_STS_ERROR;
748: x_msg_count := l_msg_count ;
749: x_msg_data := l_msg_data ;
750: FND_MSG_PUB.count_and_get(
751: p_count => x_msg_count
752: ,p_data => x_msg_data);
753: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
754: ROLLBACK TO tbc_delete;
754: ROLLBACK TO tbc_delete;
755: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
756: x_msg_count := l_msg_count ;
757: x_msg_data := l_msg_data ;
758: FND_MSG_PUB.count_and_get(
759: p_count => x_msg_count
760: ,p_data => x_msg_data);
761: WHEN OTHERS THEN
762: ROLLBACK TO tbc_delete;
762: ROLLBACK TO tbc_delete;
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_TBC_DEFINITIONS_PUB','delete_tbc_definition');
767: FND_MSG_PUB.count_and_get(
768: p_count => x_msg_count
769: ,p_data => x_msg_data);
770: END delete_tbc_definition;
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_TBC_DEFINITIONS_PUB','delete_tbc_definition');
767: FND_MSG_PUB.count_and_get(
768: p_count => x_msg_count
769: ,p_data => x_msg_data);
770: END delete_tbc_definition;
771:
831: ROLLBACK TO tbc_delete;
832: x_return_status := FND_API.G_RET_STS_ERROR;
833: x_msg_count := l_msg_count ;
834: x_msg_data := l_msg_data ;
835: FND_MSG_PUB.count_and_get(
836: p_count => x_msg_count
837: ,p_data => x_msg_data);
838: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
839: ROLLBACK TO tbc_delete;
839: ROLLBACK TO tbc_delete;
840: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
841: x_msg_count := l_msg_count ;
842: x_msg_data := l_msg_data ;
843: FND_MSG_PUB.count_and_get(
844: p_count => x_msg_count
845: ,p_data => x_msg_data);
846: WHEN OTHERS THEN
847: ROLLBACK TO tbc_delete;
847: ROLLBACK TO tbc_delete;
848: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
849: x_msg_count := l_msg_count ;
850: x_msg_data := l_msg_data ;
851: FND_MSG_PUB.ADD_EXC_MSG('OKL_TBC_DEFINITIONS_PUB','delete_tbc_definition');
852: FND_MSG_PUB.count_and_get(
853: p_count => x_msg_count
854: ,p_data => x_msg_data);
855: END delete_tbc_definition;
848: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
849: x_msg_count := l_msg_count ;
850: x_msg_data := l_msg_data ;
851: FND_MSG_PUB.ADD_EXC_MSG('OKL_TBC_DEFINITIONS_PUB','delete_tbc_definition');
852: FND_MSG_PUB.count_and_get(
853: p_count => x_msg_count
854: ,p_data => x_msg_data);
855: END delete_tbc_definition;
856:
923: ROLLBACK TO tbc_validate;
924: x_return_status := FND_API.G_RET_STS_ERROR;
925: x_msg_count := l_msg_count ;
926: x_msg_data := l_msg_data ;
927: FND_MSG_PUB.count_and_get(
928: p_count => x_msg_count
929: ,p_data => x_msg_data);
930: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
931: ROLLBACK TO tbc_validate;
931: ROLLBACK TO tbc_validate;
932: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
933: x_msg_count := l_msg_count ;
934: x_msg_data := l_msg_data ;
935: FND_MSG_PUB.count_and_get(
936: p_count => x_msg_count
937: ,p_data => x_msg_data);
938: WHEN OTHERS THEN
939: ROLLBACK TO tbc_validate;
939: ROLLBACK TO tbc_validate;
940: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
941: x_msg_count := l_msg_count ;
942: x_msg_data := l_msg_data ;
943: FND_MSG_PUB.ADD_EXC_MSG('OKL_TBC_DEFINITIONS_PUB','validate_tbc_definition');
944: FND_MSG_PUB.count_and_get(
945: p_count => x_msg_count
946: ,p_data => x_msg_data);
947: END validate_tbc_definition;
940: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
941: x_msg_count := l_msg_count ;
942: x_msg_data := l_msg_data ;
943: FND_MSG_PUB.ADD_EXC_MSG('OKL_TBC_DEFINITIONS_PUB','validate_tbc_definition');
944: FND_MSG_PUB.count_and_get(
945: p_count => x_msg_count
946: ,p_data => x_msg_data);
947: END validate_tbc_definition;
948:
1009: ROLLBACK TO tbc_validate;
1010: x_return_status := FND_API.G_RET_STS_ERROR;
1011: x_msg_count := l_msg_count ;
1012: x_msg_data := l_msg_data ;
1013: FND_MSG_PUB.count_and_get(
1014: p_count => x_msg_count
1015: ,p_data => x_msg_data);
1016: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1017: ROLLBACK TO tbc_validate;
1017: ROLLBACK TO tbc_validate;
1018: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1019: x_msg_count := l_msg_count ;
1020: x_msg_data := l_msg_data ;
1021: FND_MSG_PUB.count_and_get(
1022: p_count => x_msg_count
1023: ,p_data => x_msg_data);
1024: WHEN OTHERS THEN
1025: ROLLBACK TO tbc_validate;
1025: ROLLBACK TO tbc_validate;
1026: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1027: x_msg_count := l_msg_count ;
1028: x_msg_data := l_msg_data ;
1029: FND_MSG_PUB.ADD_EXC_MSG('OKL_TBC_DEFINITIONS_PUB','validate_tbc_definition');
1030: FND_MSG_PUB.count_and_get(
1031: p_count => x_msg_count
1032: ,p_data => x_msg_data);
1033: END validate_tbc_definition;
1026: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1027: x_msg_count := l_msg_count ;
1028: x_msg_data := l_msg_data ;
1029: FND_MSG_PUB.ADD_EXC_MSG('OKL_TBC_DEFINITIONS_PUB','validate_tbc_definition');
1030: FND_MSG_PUB.count_and_get(
1031: p_count => x_msg_count
1032: ,p_data => x_msg_data);
1033: END validate_tbc_definition;
1034: