403: p_data => x_msg_data );
404:
405: EXCEPTION
406: WHEN FND_API.G_EXC_ERROR THEN
407: CSC_CORE_UTILS_PVT.HANDLE_EXCEPTIONS(
408: P_API_NAME => L_API_NAME,
409: P_PKG_NAME => G_PKG_NAME,
410: P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR,
411: P_PACKAGE_TYPE => CSC_CORE_UTILS_PVT.G_PUB,
407: CSC_CORE_UTILS_PVT.HANDLE_EXCEPTIONS(
408: P_API_NAME => L_API_NAME,
409: P_PKG_NAME => G_PKG_NAME,
410: P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR,
411: P_PACKAGE_TYPE => CSC_CORE_UTILS_PVT.G_PUB,
412: X_MSG_COUNT => X_MSG_COUNT,
413: X_MSG_DATA => X_MSG_DATA,
414: X_RETURN_STATUS => X_RETURN_STATUS);
415: APP_EXCEPTION.RAISE_EXCEPTION;
414: X_RETURN_STATUS => X_RETURN_STATUS);
415: APP_EXCEPTION.RAISE_EXCEPTION;
416:
417: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
418: CSC_CORE_UTILS_PVT.HANDLE_EXCEPTIONS(
419: P_API_NAME => L_API_NAME,
420: P_PKG_NAME => G_PKG_NAME,
421: P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR,
422: P_PACKAGE_TYPE => CSC_CORE_UTILS_PVT.G_PUB,
418: CSC_CORE_UTILS_PVT.HANDLE_EXCEPTIONS(
419: P_API_NAME => L_API_NAME,
420: P_PKG_NAME => G_PKG_NAME,
421: P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR,
422: P_PACKAGE_TYPE => CSC_CORE_UTILS_PVT.G_PUB,
423: X_MSG_COUNT => X_MSG_COUNT,
424: X_MSG_DATA => X_MSG_DATA,
425: X_RETURN_STATUS => X_RETURN_STATUS);
426: APP_EXCEPTION.RAISE_EXCEPTION;
425: X_RETURN_STATUS => X_RETURN_STATUS);
426: APP_EXCEPTION.RAISE_EXCEPTION;
427:
428: WHEN OTHERS THEN
429: CSC_CORE_UTILS_PVT.HANDLE_EXCEPTIONS(
430: P_API_NAME => L_API_NAME,
431: P_PKG_NAME => G_PKG_NAME,
432: P_EXCEPTION_LEVEL => CSC_CORE_UTILS_PVT.G_MSG_LVL_OTHERS,
433: P_PACKAGE_TYPE => CSC_CORE_UTILS_PVT.G_PUB,
428: WHEN OTHERS THEN
429: CSC_CORE_UTILS_PVT.HANDLE_EXCEPTIONS(
430: P_API_NAME => L_API_NAME,
431: P_PKG_NAME => G_PKG_NAME,
432: P_EXCEPTION_LEVEL => CSC_CORE_UTILS_PVT.G_MSG_LVL_OTHERS,
433: P_PACKAGE_TYPE => CSC_CORE_UTILS_PVT.G_PUB,
434: X_MSG_COUNT => X_MSG_COUNT,
435: X_MSG_DATA => X_MSG_DATA,
436: X_RETURN_STATUS => X_RETURN_STATUS);
429: CSC_CORE_UTILS_PVT.HANDLE_EXCEPTIONS(
430: P_API_NAME => L_API_NAME,
431: P_PKG_NAME => G_PKG_NAME,
432: P_EXCEPTION_LEVEL => CSC_CORE_UTILS_PVT.G_MSG_LVL_OTHERS,
433: P_PACKAGE_TYPE => CSC_CORE_UTILS_PVT.G_PUB,
434: X_MSG_COUNT => X_MSG_COUNT,
435: X_MSG_DATA => X_MSG_DATA,
436: X_RETURN_STATUS => X_RETURN_STATUS);
437: APP_EXCEPTION.RAISE_EXCEPTION;
634: p_data => x_msg_data );
635:
636: EXCEPTION
637: WHEN FND_API.G_EXC_ERROR THEN
638: CSC_CORE_UTILS_PVT.HANDLE_EXCEPTIONS(
639: P_API_NAME => L_API_NAME,
640: P_PKG_NAME => G_PKG_NAME,
641: P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR,
642: P_PACKAGE_TYPE => CSC_CORE_UTILS_PVT.G_PUB,
638: CSC_CORE_UTILS_PVT.HANDLE_EXCEPTIONS(
639: P_API_NAME => L_API_NAME,
640: P_PKG_NAME => G_PKG_NAME,
641: P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR,
642: P_PACKAGE_TYPE => CSC_CORE_UTILS_PVT.G_PUB,
643: X_MSG_COUNT => X_MSG_COUNT,
644: X_MSG_DATA => X_MSG_DATA,
645: X_RETURN_STATUS => X_RETURN_STATUS);
646: APP_EXCEPTION.RAISE_EXCEPTION;
645: X_RETURN_STATUS => X_RETURN_STATUS);
646: APP_EXCEPTION.RAISE_EXCEPTION;
647:
648: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
649: CSC_CORE_UTILS_PVT.HANDLE_EXCEPTIONS(
650: P_API_NAME => L_API_NAME,
651: P_PKG_NAME => G_PKG_NAME,
652: P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR,
653: P_PACKAGE_TYPE => CSC_CORE_UTILS_PVT.G_PUB,
649: CSC_CORE_UTILS_PVT.HANDLE_EXCEPTIONS(
650: P_API_NAME => L_API_NAME,
651: P_PKG_NAME => G_PKG_NAME,
652: P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR,
653: P_PACKAGE_TYPE => CSC_CORE_UTILS_PVT.G_PUB,
654: X_MSG_COUNT => X_MSG_COUNT,
655: X_MSG_DATA => X_MSG_DATA,
656: X_RETURN_STATUS => X_RETURN_STATUS);
657: APP_EXCEPTION.RAISE_EXCEPTION;
656: X_RETURN_STATUS => X_RETURN_STATUS);
657: APP_EXCEPTION.RAISE_EXCEPTION;
658:
659: WHEN OTHERS THEN
660: CSC_CORE_UTILS_PVT.HANDLE_EXCEPTIONS(
661: P_API_NAME => L_API_NAME,
662: P_PKG_NAME => G_PKG_NAME,
663: P_EXCEPTION_LEVEL => CSC_CORE_UTILS_PVT.G_MSG_LVL_OTHERS,
664: P_PACKAGE_TYPE => CSC_CORE_UTILS_PVT.G_PUB,
659: WHEN OTHERS THEN
660: CSC_CORE_UTILS_PVT.HANDLE_EXCEPTIONS(
661: P_API_NAME => L_API_NAME,
662: P_PKG_NAME => G_PKG_NAME,
663: P_EXCEPTION_LEVEL => CSC_CORE_UTILS_PVT.G_MSG_LVL_OTHERS,
664: P_PACKAGE_TYPE => CSC_CORE_UTILS_PVT.G_PUB,
665: X_MSG_COUNT => X_MSG_COUNT,
666: X_MSG_DATA => X_MSG_DATA,
667: X_RETURN_STATUS => X_RETURN_STATUS);
660: CSC_CORE_UTILS_PVT.HANDLE_EXCEPTIONS(
661: P_API_NAME => L_API_NAME,
662: P_PKG_NAME => G_PKG_NAME,
663: P_EXCEPTION_LEVEL => CSC_CORE_UTILS_PVT.G_MSG_LVL_OTHERS,
664: P_PACKAGE_TYPE => CSC_CORE_UTILS_PVT.G_PUB,
665: X_MSG_COUNT => X_MSG_COUNT,
666: X_MSG_DATA => X_MSG_DATA,
667: X_RETURN_STATUS => X_RETURN_STATUS);
668: APP_EXCEPTION.RAISE_EXCEPTION;
732: p_data => x_msg_data );
733:
734: EXCEPTION
735: WHEN FND_API.G_EXC_ERROR THEN
736: CSC_CORE_UTILS_PVT.HANDLE_EXCEPTIONS(
737: P_API_NAME => L_API_NAME,
738: P_PKG_NAME => G_PKG_NAME,
739: P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR,
740: P_PACKAGE_TYPE => CSC_CORE_UTILS_PVT.G_PUB,
736: CSC_CORE_UTILS_PVT.HANDLE_EXCEPTIONS(
737: P_API_NAME => L_API_NAME,
738: P_PKG_NAME => G_PKG_NAME,
739: P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR,
740: P_PACKAGE_TYPE => CSC_CORE_UTILS_PVT.G_PUB,
741: X_MSG_COUNT => X_MSG_COUNT,
742: X_MSG_DATA => X_MSG_DATA,
743: X_RETURN_STATUS => X_RETURN_STATUS);
744:
742: X_MSG_DATA => X_MSG_DATA,
743: X_RETURN_STATUS => X_RETURN_STATUS);
744:
745: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
746: CSC_CORE_UTILS_PVT.HANDLE_EXCEPTIONS(
747: P_API_NAME => L_API_NAME,
748: P_PKG_NAME => G_PKG_NAME,
749: P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR,
750: P_PACKAGE_TYPE => CSC_CORE_UTILS_PVT.G_PUB,
746: CSC_CORE_UTILS_PVT.HANDLE_EXCEPTIONS(
747: P_API_NAME => L_API_NAME,
748: P_PKG_NAME => G_PKG_NAME,
749: P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR,
750: P_PACKAGE_TYPE => CSC_CORE_UTILS_PVT.G_PUB,
751: X_MSG_COUNT => X_MSG_COUNT,
752: X_MSG_DATA => X_MSG_DATA,
753: X_RETURN_STATUS => X_RETURN_STATUS);
754:
752: X_MSG_DATA => X_MSG_DATA,
753: X_RETURN_STATUS => X_RETURN_STATUS);
754:
755: WHEN OTHERS THEN
756: CSC_CORE_UTILS_PVT.HANDLE_EXCEPTIONS(
757: P_API_NAME => L_API_NAME,
758: P_PKG_NAME => G_PKG_NAME,
759: P_EXCEPTION_LEVEL => CSC_CORE_UTILS_PVT.G_MSG_LVL_OTHERS,
760: P_PACKAGE_TYPE => CSC_CORE_UTILS_PVT.G_PUB,
755: WHEN OTHERS THEN
756: CSC_CORE_UTILS_PVT.HANDLE_EXCEPTIONS(
757: P_API_NAME => L_API_NAME,
758: P_PKG_NAME => G_PKG_NAME,
759: P_EXCEPTION_LEVEL => CSC_CORE_UTILS_PVT.G_MSG_LVL_OTHERS,
760: P_PACKAGE_TYPE => CSC_CORE_UTILS_PVT.G_PUB,
761: X_MSG_COUNT => X_MSG_COUNT,
762: X_MSG_DATA => X_MSG_DATA,
763: X_RETURN_STATUS => X_RETURN_STATUS);
756: CSC_CORE_UTILS_PVT.HANDLE_EXCEPTIONS(
757: P_API_NAME => L_API_NAME,
758: P_PKG_NAME => G_PKG_NAME,
759: P_EXCEPTION_LEVEL => CSC_CORE_UTILS_PVT.G_MSG_LVL_OTHERS,
760: P_PACKAGE_TYPE => CSC_CORE_UTILS_PVT.G_PUB,
761: X_MSG_COUNT => X_MSG_COUNT,
762: X_MSG_DATA => X_MSG_DATA,
763: X_RETURN_STATUS => X_RETURN_STATUS);
764: