251: IEX_DEBUG_PUB.LogMessage ('********* End of Procedure =>IEX_CASES_PVT.Create_cas ******** ');
252: END IF;
253: EXCEPTION
254: WHEN FND_API.G_EXC_ERROR THEN
255: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
256: P_API_NAME => L_API_NAME
257: ,P_PKG_NAME => G_PKG_NAME
258: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
259: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PVT
255: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
256: P_API_NAME => L_API_NAME
257: ,P_PKG_NAME => G_PKG_NAME
258: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
259: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PVT
260: ,X_MSG_COUNT => X_MSG_COUNT
261: ,X_MSG_DATA => X_MSG_DATA
262: ,X_RETURN_STATUS => X_RETURN_STATUS);
263:
261: ,X_MSG_DATA => X_MSG_DATA
262: ,X_RETURN_STATUS => X_RETURN_STATUS);
263:
264: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
265: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
266: P_API_NAME => L_API_NAME
267: ,P_PKG_NAME => G_PKG_NAME
268: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
269: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PVT
265: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
266: P_API_NAME => L_API_NAME
267: ,P_PKG_NAME => G_PKG_NAME
268: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
269: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PVT
270: ,X_MSG_COUNT => X_MSG_COUNT
271: ,X_MSG_DATA => X_MSG_DATA
272: ,X_RETURN_STATUS => X_RETURN_STATUS);
273:
271: ,X_MSG_DATA => X_MSG_DATA
272: ,X_RETURN_STATUS => X_RETURN_STATUS);
273:
274: WHEN OTHERS THEN
275: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
276: P_API_NAME => L_API_NAME
277: ,P_PKG_NAME => G_PKG_NAME
278: ,P_EXCEPTION_LEVEL => AS_UTILITY_PVT.G_EXC_OTHERS
279: ,P_SQLCODE => SQLCODE
274: WHEN OTHERS THEN
275: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
276: P_API_NAME => L_API_NAME
277: ,P_PKG_NAME => G_PKG_NAME
278: ,P_EXCEPTION_LEVEL => AS_UTILITY_PVT.G_EXC_OTHERS
279: ,P_SQLCODE => SQLCODE
280: ,P_SQLERRM => SQLERRM
281: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PVT
282: ,X_MSG_COUNT => X_MSG_COUNT
277: ,P_PKG_NAME => G_PKG_NAME
278: ,P_EXCEPTION_LEVEL => AS_UTILITY_PVT.G_EXC_OTHERS
279: ,P_SQLCODE => SQLCODE
280: ,P_SQLERRM => SQLERRM
281: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PVT
282: ,X_MSG_COUNT => X_MSG_COUNT
283: ,X_MSG_DATA => X_MSG_DATA
284: ,X_RETURN_STATUS => X_RETURN_STATUS);
285: End Create_cas;
421: IEX_DEBUG_PUB.LogMessage ('********* End of Procedure =>IEX_CASES_PVT.Update_cas ******** ');
422: END IF;
423: EXCEPTION
424: WHEN FND_API.G_EXC_ERROR THEN
425: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
426: P_API_NAME => L_API_NAME
427: ,P_PKG_NAME => G_PKG_NAME
428: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
429: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PVT
425: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
426: P_API_NAME => L_API_NAME
427: ,P_PKG_NAME => G_PKG_NAME
428: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
429: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PVT
430: ,X_MSG_COUNT => X_MSG_COUNT
431: ,X_MSG_DATA => X_MSG_DATA
432: ,X_RETURN_STATUS => X_RETURN_STATUS);
433:
431: ,X_MSG_DATA => X_MSG_DATA
432: ,X_RETURN_STATUS => X_RETURN_STATUS);
433:
434: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
435: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
436: P_API_NAME => L_API_NAME
437: ,P_PKG_NAME => G_PKG_NAME
438: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
439: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PVT
435: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
436: P_API_NAME => L_API_NAME
437: ,P_PKG_NAME => G_PKG_NAME
438: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
439: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PVT
440: ,X_MSG_COUNT => X_MSG_COUNT
441: ,X_MSG_DATA => X_MSG_DATA
442: ,X_RETURN_STATUS => X_RETURN_STATUS);
443:
441: ,X_MSG_DATA => X_MSG_DATA
442: ,X_RETURN_STATUS => X_RETURN_STATUS);
443:
444: WHEN OTHERS THEN
445: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
446: P_API_NAME => L_API_NAME
447: ,P_PKG_NAME => G_PKG_NAME
448: ,P_EXCEPTION_LEVEL => AS_UTILITY_PVT.G_EXC_OTHERS
449: ,P_SQLCODE => SQLCODE
444: WHEN OTHERS THEN
445: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
446: P_API_NAME => L_API_NAME
447: ,P_PKG_NAME => G_PKG_NAME
448: ,P_EXCEPTION_LEVEL => AS_UTILITY_PVT.G_EXC_OTHERS
449: ,P_SQLCODE => SQLCODE
450: ,P_SQLERRM => SQLERRM
451: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PVT
452: ,X_MSG_COUNT => X_MSG_COUNT
447: ,P_PKG_NAME => G_PKG_NAME
448: ,P_EXCEPTION_LEVEL => AS_UTILITY_PVT.G_EXC_OTHERS
449: ,P_SQLCODE => SQLCODE
450: ,P_SQLERRM => SQLERRM
451: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PVT
452: ,X_MSG_COUNT => X_MSG_COUNT
453: ,X_MSG_DATA => X_MSG_DATA
454: ,X_RETURN_STATUS => X_RETURN_STATUS);
455: End Update_cas;
526: p_data => x_msg_data
527: );
528: EXCEPTION
529: WHEN FND_API.G_EXC_ERROR THEN
530: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
531: P_API_NAME => L_API_NAME
532: ,P_PKG_NAME => G_PKG_NAME
533: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
534: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PVT
530: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
531: P_API_NAME => L_API_NAME
532: ,P_PKG_NAME => G_PKG_NAME
533: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
534: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PVT
535: ,X_MSG_COUNT => X_MSG_COUNT
536: ,X_MSG_DATA => X_MSG_DATA
537: ,X_RETURN_STATUS => X_RETURN_STATUS);
538:
536: ,X_MSG_DATA => X_MSG_DATA
537: ,X_RETURN_STATUS => X_RETURN_STATUS);
538:
539: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
540: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
541: P_API_NAME => L_API_NAME
542: ,P_PKG_NAME => G_PKG_NAME
543: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
544: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PVT
540: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
541: P_API_NAME => L_API_NAME
542: ,P_PKG_NAME => G_PKG_NAME
543: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
544: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PVT
545: ,X_MSG_COUNT => X_MSG_COUNT
546: ,X_MSG_DATA => X_MSG_DATA
547: ,X_RETURN_STATUS => X_RETURN_STATUS);
548:
546: ,X_MSG_DATA => X_MSG_DATA
547: ,X_RETURN_STATUS => X_RETURN_STATUS);
548:
549: WHEN OTHERS THEN
550: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
551: P_API_NAME => L_API_NAME
552: ,P_PKG_NAME => G_PKG_NAME
553: ,P_EXCEPTION_LEVEL => AS_UTILITY_PVT.G_EXC_OTHERS
554: ,P_SQLCODE => SQLCODE
549: WHEN OTHERS THEN
550: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
551: P_API_NAME => L_API_NAME
552: ,P_PKG_NAME => G_PKG_NAME
553: ,P_EXCEPTION_LEVEL => AS_UTILITY_PVT.G_EXC_OTHERS
554: ,P_SQLCODE => SQLCODE
555: ,P_SQLERRM => SQLERRM
556: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PVT
557: ,X_MSG_COUNT => X_MSG_COUNT
552: ,P_PKG_NAME => G_PKG_NAME
553: ,P_EXCEPTION_LEVEL => AS_UTILITY_PVT.G_EXC_OTHERS
554: ,P_SQLCODE => SQLCODE
555: ,P_SQLERRM => SQLERRM
556: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PVT
557: ,X_MSG_COUNT => X_MSG_COUNT
558: ,X_MSG_DATA => X_MSG_DATA
559: ,X_RETURN_STATUS => X_RETURN_STATUS);
560: End Delete_cas;