1248: );
1249:
1250: EXCEPTION
1251: WHEN FND_API.G_EXC_ERROR THEN
1252: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
1253: P_API_NAME => L_API_NAME
1254: ,P_PKG_NAME => G_PKG_NAME
1255: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
1256: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PUB
1252: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
1253: P_API_NAME => L_API_NAME
1254: ,P_PKG_NAME => G_PKG_NAME
1255: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
1256: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PUB
1257: ,X_MSG_COUNT => X_MSG_COUNT
1258: ,X_MSG_DATA => X_MSG_DATA
1259: ,X_RETURN_STATUS => X_RETURN_STATUS);
1260:
1258: ,X_MSG_DATA => X_MSG_DATA
1259: ,X_RETURN_STATUS => X_RETURN_STATUS);
1260:
1261: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1262: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
1263: P_API_NAME => L_API_NAME
1264: ,P_PKG_NAME => G_PKG_NAME
1265: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
1266: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PUB
1262: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
1263: P_API_NAME => L_API_NAME
1264: ,P_PKG_NAME => G_PKG_NAME
1265: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
1266: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PUB
1267: ,X_MSG_COUNT => X_MSG_COUNT
1268: ,X_MSG_DATA => X_MSG_DATA
1269: ,X_RETURN_STATUS => X_RETURN_STATUS);
1270:
1268: ,X_MSG_DATA => X_MSG_DATA
1269: ,X_RETURN_STATUS => X_RETURN_STATUS);
1270:
1271: WHEN OTHERS THEN
1272: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
1273: P_API_NAME => L_API_NAME
1274: ,P_PKG_NAME => G_PKG_NAME
1275: ,P_EXCEPTION_LEVEL => AS_UTILITY_PVT.G_EXC_OTHERS
1276: ,P_SQLCODE => SQLCODE
1271: WHEN OTHERS THEN
1272: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
1273: P_API_NAME => L_API_NAME
1274: ,P_PKG_NAME => G_PKG_NAME
1275: ,P_EXCEPTION_LEVEL => AS_UTILITY_PVT.G_EXC_OTHERS
1276: ,P_SQLCODE => SQLCODE
1277: ,P_SQLERRM => SQLERRM
1278: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PUB
1279: ,X_MSG_COUNT => X_MSG_COUNT
1274: ,P_PKG_NAME => G_PKG_NAME
1275: ,P_EXCEPTION_LEVEL => AS_UTILITY_PVT.G_EXC_OTHERS
1276: ,P_SQLCODE => SQLCODE
1277: ,P_SQLERRM => SQLERRM
1278: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PUB
1279: ,X_MSG_COUNT => X_MSG_COUNT
1280: ,X_MSG_DATA => X_MSG_DATA
1281: ,X_RETURN_STATUS => X_RETURN_STATUS);
1282: END CloseCase;
1854: IEX_DEBUG_PUB.LogMessage ('CreateCaseObjects: ' || '*********End of Procedure => '||l_api_name||' *********');
1855: END IF;
1856: EXCEPTION
1857: WHEN FND_API.G_EXC_ERROR THEN
1858: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
1859: P_API_NAME => L_API_NAME
1860: ,P_PKG_NAME => G_PKG_NAME
1861: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
1862: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PUB
1858: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
1859: P_API_NAME => L_API_NAME
1860: ,P_PKG_NAME => G_PKG_NAME
1861: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
1862: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PUB
1863: ,X_MSG_COUNT => X_MSG_COUNT
1864: ,X_MSG_DATA => X_MSG_DATA
1865: ,X_RETURN_STATUS => X_RETURN_STATUS);
1866:
1864: ,X_MSG_DATA => X_MSG_DATA
1865: ,X_RETURN_STATUS => X_RETURN_STATUS);
1866:
1867: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1868: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
1869: P_API_NAME => L_API_NAME
1870: ,P_PKG_NAME => G_PKG_NAME
1871: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
1872: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PUB
1868: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
1869: P_API_NAME => L_API_NAME
1870: ,P_PKG_NAME => G_PKG_NAME
1871: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
1872: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PUB
1873: ,X_MSG_COUNT => X_MSG_COUNT
1874: ,X_MSG_DATA => X_MSG_DATA
1875: ,X_RETURN_STATUS => X_RETURN_STATUS);
1876:
1874: ,X_MSG_DATA => X_MSG_DATA
1875: ,X_RETURN_STATUS => X_RETURN_STATUS);
1876:
1877: WHEN OTHERS THEN
1878: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
1879: P_API_NAME => L_API_NAME
1880: ,P_PKG_NAME => G_PKG_NAME
1881: ,P_EXCEPTION_LEVEL => AS_UTILITY_PVT.G_EXC_OTHERS
1882: ,P_SQLCODE => SQLCODE
1877: WHEN OTHERS THEN
1878: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
1879: P_API_NAME => L_API_NAME
1880: ,P_PKG_NAME => G_PKG_NAME
1881: ,P_EXCEPTION_LEVEL => AS_UTILITY_PVT.G_EXC_OTHERS
1882: ,P_SQLCODE => SQLCODE
1883: ,P_SQLERRM => SQLERRM
1884: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PUB
1885: ,X_MSG_COUNT => X_MSG_COUNT
1880: ,P_PKG_NAME => G_PKG_NAME
1881: ,P_EXCEPTION_LEVEL => AS_UTILITY_PVT.G_EXC_OTHERS
1882: ,P_SQLCODE => SQLCODE
1883: ,P_SQLERRM => SQLERRM
1884: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PUB
1885: ,X_MSG_COUNT => X_MSG_COUNT
1886: ,X_MSG_DATA => X_MSG_DATA
1887: ,X_RETURN_STATUS => X_RETURN_STATUS);
1888: END CreateCaseObjects;
2802: IEX_DEBUG_PUB.LogMessage ('UpdateCase: ' || '*********End of Procedure => '||l_api_name||' *********');
2803: END IF;
2804: EXCEPTION
2805: WHEN FND_API.G_EXC_ERROR THEN
2806: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
2807: P_API_NAME => L_API_NAME
2808: ,P_PKG_NAME => G_PKG_NAME
2809: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
2810: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PUB
2806: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
2807: P_API_NAME => L_API_NAME
2808: ,P_PKG_NAME => G_PKG_NAME
2809: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
2810: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PUB
2811: ,X_MSG_COUNT => X_MSG_COUNT
2812: ,X_MSG_DATA => X_MSG_DATA
2813: ,X_RETURN_STATUS => X_RETURN_STATUS);
2814:
2812: ,X_MSG_DATA => X_MSG_DATA
2813: ,X_RETURN_STATUS => X_RETURN_STATUS);
2814:
2815: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2816: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
2817: P_API_NAME => L_API_NAME
2818: ,P_PKG_NAME => G_PKG_NAME
2819: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
2820: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PUB
2816: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
2817: P_API_NAME => L_API_NAME
2818: ,P_PKG_NAME => G_PKG_NAME
2819: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
2820: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PUB
2821: ,X_MSG_COUNT => X_MSG_COUNT
2822: ,X_MSG_DATA => X_MSG_DATA
2823: ,X_RETURN_STATUS => X_RETURN_STATUS);
2824:
2822: ,X_MSG_DATA => X_MSG_DATA
2823: ,X_RETURN_STATUS => X_RETURN_STATUS);
2824:
2825: WHEN OTHERS THEN
2826: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
2827: P_API_NAME => L_API_NAME
2828: ,P_PKG_NAME => G_PKG_NAME
2829: ,P_EXCEPTION_LEVEL => AS_UTILITY_PVT.G_EXC_OTHERS
2830: ,P_SQLCODE => SQLCODE
2825: WHEN OTHERS THEN
2826: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
2827: P_API_NAME => L_API_NAME
2828: ,P_PKG_NAME => G_PKG_NAME
2829: ,P_EXCEPTION_LEVEL => AS_UTILITY_PVT.G_EXC_OTHERS
2830: ,P_SQLCODE => SQLCODE
2831: ,P_SQLERRM => SQLERRM
2832: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PUB
2833: ,X_MSG_COUNT => X_MSG_COUNT
2828: ,P_PKG_NAME => G_PKG_NAME
2829: ,P_EXCEPTION_LEVEL => AS_UTILITY_PVT.G_EXC_OTHERS
2830: ,P_SQLCODE => SQLCODE
2831: ,P_SQLERRM => SQLERRM
2832: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PUB
2833: ,X_MSG_COUNT => X_MSG_COUNT
2834: ,X_MSG_DATA => X_MSG_DATA
2835: ,X_RETURN_STATUS => X_RETURN_STATUS);
2836: END UpdateCase;
3059: );
3060:
3061: EXCEPTION
3062: WHEN FND_API.G_EXC_ERROR THEN
3063: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
3064: P_API_NAME => L_API_NAME
3065: ,P_PKG_NAME => G_PKG_NAME
3066: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
3067: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PUB
3063: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
3064: P_API_NAME => L_API_NAME
3065: ,P_PKG_NAME => G_PKG_NAME
3066: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
3067: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PUB
3068: ,X_MSG_COUNT => X_MSG_COUNT
3069: ,X_MSG_DATA => X_MSG_DATA
3070: ,X_RETURN_STATUS => X_RETURN_STATUS);
3071:
3069: ,X_MSG_DATA => X_MSG_DATA
3070: ,X_RETURN_STATUS => X_RETURN_STATUS);
3071:
3072: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3073: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
3074: P_API_NAME => L_API_NAME
3075: ,P_PKG_NAME => G_PKG_NAME
3076: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
3077: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PUB
3073: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
3074: P_API_NAME => L_API_NAME
3075: ,P_PKG_NAME => G_PKG_NAME
3076: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
3077: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PUB
3078: ,X_MSG_COUNT => X_MSG_COUNT
3079: ,X_MSG_DATA => X_MSG_DATA
3080: ,X_RETURN_STATUS => X_RETURN_STATUS);
3081:
3079: ,X_MSG_DATA => X_MSG_DATA
3080: ,X_RETURN_STATUS => X_RETURN_STATUS);
3081:
3082: WHEN OTHERS THEN
3083: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
3084: P_API_NAME => L_API_NAME
3085: ,P_PKG_NAME => G_PKG_NAME
3086: ,P_EXCEPTION_LEVEL => AS_UTILITY_PVT.G_EXC_OTHERS
3087: ,P_SQLCODE => SQLCODE
3082: WHEN OTHERS THEN
3083: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
3084: P_API_NAME => L_API_NAME
3085: ,P_PKG_NAME => G_PKG_NAME
3086: ,P_EXCEPTION_LEVEL => AS_UTILITY_PVT.G_EXC_OTHERS
3087: ,P_SQLCODE => SQLCODE
3088: ,P_SQLERRM => SQLERRM
3089: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PUB
3090: ,X_MSG_COUNT => X_MSG_COUNT
3085: ,P_PKG_NAME => G_PKG_NAME
3086: ,P_EXCEPTION_LEVEL => AS_UTILITY_PVT.G_EXC_OTHERS
3087: ,P_SQLCODE => SQLCODE
3088: ,P_SQLERRM => SQLERRM
3089: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PUB
3090: ,X_MSG_COUNT => X_MSG_COUNT
3091: ,X_MSG_DATA => X_MSG_DATA
3092: ,X_RETURN_STATUS => X_RETURN_STATUS);
3093: