572: p_data => x_msg_data
573: );
574: EXCEPTION
575: WHEN FND_API.G_EXC_ERROR THEN
576: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
577: P_MODULE => l_module
578: ,P_API_NAME => L_API_NAME
579: ,P_PKG_NAME => G_PKG_NAME
580: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
577: P_MODULE => l_module
578: ,P_API_NAME => L_API_NAME
579: ,P_PKG_NAME => G_PKG_NAME
580: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
581: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PUB
582: ,X_MSG_COUNT => X_MSG_COUNT
583: ,X_MSG_DATA => X_MSG_DATA
584: ,X_RETURN_STATUS => X_RETURN_STATUS);
585:
583: ,X_MSG_DATA => X_MSG_DATA
584: ,X_RETURN_STATUS => X_RETURN_STATUS);
585:
586: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
587: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
588: P_MODULE => l_module
589: ,P_API_NAME => L_API_NAME
590: ,P_PKG_NAME => G_PKG_NAME
591: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
588: P_MODULE => l_module
589: ,P_API_NAME => L_API_NAME
590: ,P_PKG_NAME => G_PKG_NAME
591: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
592: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PUB
593: ,X_MSG_COUNT => X_MSG_COUNT
594: ,X_MSG_DATA => X_MSG_DATA
595: ,X_RETURN_STATUS => X_RETURN_STATUS);
596:
594: ,X_MSG_DATA => X_MSG_DATA
595: ,X_RETURN_STATUS => X_RETURN_STATUS);
596:
597: WHEN OTHERS THEN
598: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
599: P_MODULE => l_module
600: ,P_API_NAME => L_API_NAME
601: ,P_PKG_NAME => G_PKG_NAME
602: ,P_EXCEPTION_LEVEL => AS_UTILITY_PVT.G_EXC_OTHERS
598: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
599: P_MODULE => l_module
600: ,P_API_NAME => L_API_NAME
601: ,P_PKG_NAME => G_PKG_NAME
602: ,P_EXCEPTION_LEVEL => AS_UTILITY_PVT.G_EXC_OTHERS
603: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PUB
604: ,X_MSG_COUNT => X_MSG_COUNT
605: ,X_MSG_DATA => X_MSG_DATA
606: ,X_RETURN_STATUS => X_RETURN_STATUS);
599: P_MODULE => l_module
600: ,P_API_NAME => L_API_NAME
601: ,P_PKG_NAME => G_PKG_NAME
602: ,P_EXCEPTION_LEVEL => AS_UTILITY_PVT.G_EXC_OTHERS
603: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PUB
604: ,X_MSG_COUNT => X_MSG_COUNT
605: ,X_MSG_DATA => X_MSG_DATA
606: ,X_RETURN_STATUS => X_RETURN_STATUS);
607: END create_interest_code;
1242: );
1243:
1244: EXCEPTION
1245: WHEN FND_API.G_EXC_ERROR THEN
1246: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
1247: P_MODULE => l_module
1248: ,P_API_NAME => L_API_NAME
1249: ,P_PKG_NAME => G_PKG_NAME
1250: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
1247: P_MODULE => l_module
1248: ,P_API_NAME => L_API_NAME
1249: ,P_PKG_NAME => G_PKG_NAME
1250: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
1251: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PUB
1252: ,X_MSG_COUNT => X_MSG_COUNT
1253: ,X_MSG_DATA => X_MSG_DATA
1254: ,X_RETURN_STATUS => X_RETURN_STATUS);
1255:
1253: ,X_MSG_DATA => X_MSG_DATA
1254: ,X_RETURN_STATUS => X_RETURN_STATUS);
1255:
1256: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1257: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
1258: P_MODULE => l_module
1259: ,P_API_NAME => L_API_NAME
1260: ,P_PKG_NAME => G_PKG_NAME
1261: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
1258: P_MODULE => l_module
1259: ,P_API_NAME => L_API_NAME
1260: ,P_PKG_NAME => G_PKG_NAME
1261: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
1262: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PUB
1263: ,X_MSG_COUNT => X_MSG_COUNT
1264: ,X_MSG_DATA => X_MSG_DATA
1265: ,X_RETURN_STATUS => X_RETURN_STATUS);
1266:
1264: ,X_MSG_DATA => X_MSG_DATA
1265: ,X_RETURN_STATUS => X_RETURN_STATUS);
1266:
1267: WHEN OTHERS THEN
1268: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
1269: P_MODULE => l_module
1270: ,P_API_NAME => L_API_NAME
1271: ,P_PKG_NAME => G_PKG_NAME
1272: ,P_EXCEPTION_LEVEL => AS_UTILITY_PVT.G_EXC_OTHERS
1268: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
1269: P_MODULE => l_module
1270: ,P_API_NAME => L_API_NAME
1271: ,P_PKG_NAME => G_PKG_NAME
1272: ,P_EXCEPTION_LEVEL => AS_UTILITY_PVT.G_EXC_OTHERS
1273: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PUB
1274: ,X_MSG_COUNT => X_MSG_COUNT
1275: ,X_MSG_DATA => X_MSG_DATA
1276: ,X_RETURN_STATUS => X_RETURN_STATUS);
1269: P_MODULE => l_module
1270: ,P_API_NAME => L_API_NAME
1271: ,P_PKG_NAME => G_PKG_NAME
1272: ,P_EXCEPTION_LEVEL => AS_UTILITY_PVT.G_EXC_OTHERS
1273: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PUB
1274: ,X_MSG_COUNT => X_MSG_COUNT
1275: ,X_MSG_DATA => X_MSG_DATA
1276: ,X_RETURN_STATUS => X_RETURN_STATUS);
1277: END update_interest_code;