181: IEX_DEBUG_PUB.LogMessage ('********* End of Procedure =>IEX_CASE_OBJECTS_PVT.Create_case_objects ******** ');
182: END IF;
183: EXCEPTION
184: WHEN FND_API.G_EXC_ERROR THEN
185: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
186: P_API_NAME => L_API_NAME
187: ,P_PKG_NAME => G_PKG_NAME
188: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
189: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PVT
185: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
186: P_API_NAME => L_API_NAME
187: ,P_PKG_NAME => G_PKG_NAME
188: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
189: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PVT
190: ,X_MSG_COUNT => X_MSG_COUNT
191: ,X_MSG_DATA => X_MSG_DATA
192: ,X_RETURN_STATUS => X_RETURN_STATUS);
193:
191: ,X_MSG_DATA => X_MSG_DATA
192: ,X_RETURN_STATUS => X_RETURN_STATUS);
193:
194: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
195: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
196: P_API_NAME => L_API_NAME
197: ,P_PKG_NAME => G_PKG_NAME
198: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
199: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PVT
195: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
196: P_API_NAME => L_API_NAME
197: ,P_PKG_NAME => G_PKG_NAME
198: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
199: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PVT
200: ,X_MSG_COUNT => X_MSG_COUNT
201: ,X_MSG_DATA => X_MSG_DATA
202: ,X_RETURN_STATUS => X_RETURN_STATUS);
203:
201: ,X_MSG_DATA => X_MSG_DATA
202: ,X_RETURN_STATUS => X_RETURN_STATUS);
203:
204: WHEN OTHERS THEN
205: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
206: P_API_NAME => L_API_NAME
207: ,P_PKG_NAME => G_PKG_NAME
208: ,P_EXCEPTION_LEVEL => AS_UTILITY_PVT.G_EXC_OTHERS
209: ,P_SQLCODE => SQLCODE
204: WHEN OTHERS THEN
205: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
206: P_API_NAME => L_API_NAME
207: ,P_PKG_NAME => G_PKG_NAME
208: ,P_EXCEPTION_LEVEL => AS_UTILITY_PVT.G_EXC_OTHERS
209: ,P_SQLCODE => SQLCODE
210: ,P_SQLERRM => SQLERRM
211: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PVT
212: ,X_MSG_COUNT => X_MSG_COUNT
207: ,P_PKG_NAME => G_PKG_NAME
208: ,P_EXCEPTION_LEVEL => AS_UTILITY_PVT.G_EXC_OTHERS
209: ,P_SQLCODE => SQLCODE
210: ,P_SQLERRM => SQLERRM
211: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PVT
212: ,X_MSG_COUNT => X_MSG_COUNT
213: ,X_MSG_DATA => X_MSG_DATA
214: ,X_RETURN_STATUS => X_RETURN_STATUS);
215: End Create_case_objects;
341: IEX_DEBUG_PUB.LogMessage ('********* end of Procedure =>IEX_CASE_OBJECTS_PVT.update_case_objects ******** ');
342: END IF;
343: EXCEPTION
344: WHEN FND_API.G_EXC_ERROR THEN
345: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
346: P_API_NAME => L_API_NAME
347: ,P_PKG_NAME => G_PKG_NAME
348: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
349: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PVT
345: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
346: P_API_NAME => L_API_NAME
347: ,P_PKG_NAME => G_PKG_NAME
348: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
349: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PVT
350: ,X_MSG_COUNT => X_MSG_COUNT
351: ,X_MSG_DATA => X_MSG_DATA
352: ,X_RETURN_STATUS => X_RETURN_STATUS);
353:
351: ,X_MSG_DATA => X_MSG_DATA
352: ,X_RETURN_STATUS => X_RETURN_STATUS);
353:
354: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
355: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
356: P_API_NAME => L_API_NAME
357: ,P_PKG_NAME => G_PKG_NAME
358: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
359: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PVT
355: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
356: P_API_NAME => L_API_NAME
357: ,P_PKG_NAME => G_PKG_NAME
358: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
359: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PVT
360: ,X_MSG_COUNT => X_MSG_COUNT
361: ,X_MSG_DATA => X_MSG_DATA
362: ,X_RETURN_STATUS => X_RETURN_STATUS);
363:
361: ,X_MSG_DATA => X_MSG_DATA
362: ,X_RETURN_STATUS => X_RETURN_STATUS);
363:
364: WHEN OTHERS THEN
365: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
366: P_API_NAME => L_API_NAME
367: ,P_PKG_NAME => G_PKG_NAME
368: ,P_EXCEPTION_LEVEL => AS_UTILITY_PVT.G_EXC_OTHERS
369: ,P_SQLCODE => SQLCODE
364: WHEN OTHERS THEN
365: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
366: P_API_NAME => L_API_NAME
367: ,P_PKG_NAME => G_PKG_NAME
368: ,P_EXCEPTION_LEVEL => AS_UTILITY_PVT.G_EXC_OTHERS
369: ,P_SQLCODE => SQLCODE
370: ,P_SQLERRM => SQLERRM
371: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PVT
372: ,X_MSG_COUNT => X_MSG_COUNT
367: ,P_PKG_NAME => G_PKG_NAME
368: ,P_EXCEPTION_LEVEL => AS_UTILITY_PVT.G_EXC_OTHERS
369: ,P_SQLCODE => SQLCODE
370: ,P_SQLERRM => SQLERRM
371: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PVT
372: ,X_MSG_COUNT => X_MSG_COUNT
373: ,X_MSG_DATA => X_MSG_DATA
374: ,X_RETURN_STATUS => X_RETURN_STATUS);
375: End Update_case_objects;
443: );
444:
445: EXCEPTION
446: WHEN FND_API.G_EXC_ERROR THEN
447: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
448: P_API_NAME => L_API_NAME
449: ,P_PKG_NAME => G_PKG_NAME
450: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
451: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PVT
447: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
448: P_API_NAME => L_API_NAME
449: ,P_PKG_NAME => G_PKG_NAME
450: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
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:
453: ,X_MSG_DATA => X_MSG_DATA
454: ,X_RETURN_STATUS => X_RETURN_STATUS);
455:
456: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
457: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
458: P_API_NAME => L_API_NAME
459: ,P_PKG_NAME => G_PKG_NAME
460: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
461: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PVT
457: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
458: P_API_NAME => L_API_NAME
459: ,P_PKG_NAME => G_PKG_NAME
460: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
461: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PVT
462: ,X_MSG_COUNT => X_MSG_COUNT
463: ,X_MSG_DATA => X_MSG_DATA
464: ,X_RETURN_STATUS => X_RETURN_STATUS);
465:
463: ,X_MSG_DATA => X_MSG_DATA
464: ,X_RETURN_STATUS => X_RETURN_STATUS);
465:
466: WHEN OTHERS THEN
467: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
468: P_API_NAME => L_API_NAME
469: ,P_PKG_NAME => G_PKG_NAME
470: ,P_EXCEPTION_LEVEL => AS_UTILITY_PVT.G_EXC_OTHERS
471: ,P_SQLCODE => SQLCODE
466: WHEN OTHERS THEN
467: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
468: P_API_NAME => L_API_NAME
469: ,P_PKG_NAME => G_PKG_NAME
470: ,P_EXCEPTION_LEVEL => AS_UTILITY_PVT.G_EXC_OTHERS
471: ,P_SQLCODE => SQLCODE
472: ,P_SQLERRM => SQLERRM
473: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PVT
474: ,X_MSG_COUNT => X_MSG_COUNT
469: ,P_PKG_NAME => G_PKG_NAME
470: ,P_EXCEPTION_LEVEL => AS_UTILITY_PVT.G_EXC_OTHERS
471: ,P_SQLCODE => SQLCODE
472: ,P_SQLERRM => SQLERRM
473: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PVT
474: ,X_MSG_COUNT => X_MSG_COUNT
475: ,X_MSG_DATA => X_MSG_DATA
476: ,X_RETURN_STATUS => X_RETURN_STATUS);
477: End Delete_case_objects;