374: );
375:
376: EXCEPTION
377: WHEN FND_API.G_EXC_ERROR THEN
378: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
379: P_MODULE => l_module
380: ,P_API_NAME => L_API_NAME
381: ,P_PKG_NAME => G_PKG_NAME
382: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
379: P_MODULE => l_module
380: ,P_API_NAME => L_API_NAME
381: ,P_PKG_NAME => G_PKG_NAME
382: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
383: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PUB
384: ,X_MSG_COUNT => X_MSG_COUNT
385: ,X_MSG_DATA => X_MSG_DATA
386: ,X_RETURN_STATUS => X_RETURN_STATUS);
387:
385: ,X_MSG_DATA => X_MSG_DATA
386: ,X_RETURN_STATUS => X_RETURN_STATUS);
387:
388: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
389: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
390: P_MODULE => l_module
391: ,P_API_NAME => L_API_NAME
392: ,P_PKG_NAME => G_PKG_NAME
393: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
390: P_MODULE => l_module
391: ,P_API_NAME => L_API_NAME
392: ,P_PKG_NAME => G_PKG_NAME
393: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
394: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PUB
395: ,X_MSG_COUNT => X_MSG_COUNT
396: ,X_MSG_DATA => X_MSG_DATA
397: ,X_RETURN_STATUS => X_RETURN_STATUS);
398:
396: ,X_MSG_DATA => X_MSG_DATA
397: ,X_RETURN_STATUS => X_RETURN_STATUS);
398:
399: WHEN OTHERS THEN
400: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
401: P_MODULE => l_module
402: ,P_API_NAME => L_API_NAME
403: ,P_PKG_NAME => G_PKG_NAME
404: ,P_EXCEPTION_LEVEL => AS_UTILITY_PVT.G_EXC_OTHERS
400: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
401: P_MODULE => l_module
402: ,P_API_NAME => L_API_NAME
403: ,P_PKG_NAME => G_PKG_NAME
404: ,P_EXCEPTION_LEVEL => AS_UTILITY_PVT.G_EXC_OTHERS
405: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PUB
406: ,X_MSG_COUNT => X_MSG_COUNT
407: ,X_MSG_DATA => X_MSG_DATA
408: ,X_RETURN_STATUS => X_RETURN_STATUS);
401: P_MODULE => l_module
402: ,P_API_NAME => L_API_NAME
403: ,P_PKG_NAME => G_PKG_NAME
404: ,P_EXCEPTION_LEVEL => AS_UTILITY_PVT.G_EXC_OTHERS
405: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PUB
406: ,X_MSG_COUNT => X_MSG_COUNT
407: ,X_MSG_DATA => X_MSG_DATA
408: ,X_RETURN_STATUS => X_RETURN_STATUS);
409: END create_interest_type;
878: p_data => x_msg_data
879: );
880: EXCEPTION
881: WHEN FND_API.G_EXC_ERROR THEN
882: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
883: P_MODULE => l_module
884: ,P_API_NAME => L_API_NAME
885: ,P_PKG_NAME => G_PKG_NAME
886: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
883: P_MODULE => l_module
884: ,P_API_NAME => L_API_NAME
885: ,P_PKG_NAME => G_PKG_NAME
886: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
887: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PUB
888: ,X_MSG_COUNT => X_MSG_COUNT
889: ,X_MSG_DATA => X_MSG_DATA
890: ,X_RETURN_STATUS => X_RETURN_STATUS);
891:
889: ,X_MSG_DATA => X_MSG_DATA
890: ,X_RETURN_STATUS => X_RETURN_STATUS);
891:
892: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
893: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
894: P_MODULE => l_module
895: ,P_API_NAME => L_API_NAME
896: ,P_PKG_NAME => G_PKG_NAME
897: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
894: P_MODULE => l_module
895: ,P_API_NAME => L_API_NAME
896: ,P_PKG_NAME => G_PKG_NAME
897: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
898: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PUB
899: ,X_MSG_COUNT => X_MSG_COUNT
900: ,X_MSG_DATA => X_MSG_DATA
901: ,X_RETURN_STATUS => X_RETURN_STATUS);
902:
900: ,X_MSG_DATA => X_MSG_DATA
901: ,X_RETURN_STATUS => X_RETURN_STATUS);
902:
903: WHEN OTHERS THEN
904: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
905: P_MODULE => l_module
906: ,P_API_NAME => L_API_NAME
907: ,P_PKG_NAME => G_PKG_NAME
908: ,P_EXCEPTION_LEVEL => AS_UTILITY_PVT.G_EXC_OTHERS
904: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
905: P_MODULE => l_module
906: ,P_API_NAME => L_API_NAME
907: ,P_PKG_NAME => G_PKG_NAME
908: ,P_EXCEPTION_LEVEL => AS_UTILITY_PVT.G_EXC_OTHERS
909: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PUB
910: ,X_MSG_COUNT => X_MSG_COUNT
911: ,X_MSG_DATA => X_MSG_DATA
912: ,X_RETURN_STATUS => X_RETURN_STATUS);
905: P_MODULE => l_module
906: ,P_API_NAME => L_API_NAME
907: ,P_PKG_NAME => G_PKG_NAME
908: ,P_EXCEPTION_LEVEL => AS_UTILITY_PVT.G_EXC_OTHERS
909: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PUB
910: ,X_MSG_COUNT => X_MSG_COUNT
911: ,X_MSG_DATA => X_MSG_DATA
912: ,X_RETURN_STATUS => X_RETURN_STATUS);
913: END update_interest_type;