249: IEX_DEBUG_PUB.LogMessage ('********* End of Procedure =>IEX_CASE_CONTACTS_PVT.Create_case_contact ******** ');
250: END IF;
251: EXCEPTION
252: WHEN FND_API.G_EXC_ERROR THEN
253: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
254: P_API_NAME => L_API_NAME
255: ,P_PKG_NAME => G_PKG_NAME
256: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
257: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PVT
253: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
254: P_API_NAME => L_API_NAME
255: ,P_PKG_NAME => G_PKG_NAME
256: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
257: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PVT
258: ,X_MSG_COUNT => X_MSG_COUNT
259: ,X_MSG_DATA => X_MSG_DATA
260: ,X_RETURN_STATUS => X_RETURN_STATUS);
261:
259: ,X_MSG_DATA => X_MSG_DATA
260: ,X_RETURN_STATUS => X_RETURN_STATUS);
261:
262: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
263: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
264: P_API_NAME => L_API_NAME
265: ,P_PKG_NAME => G_PKG_NAME
266: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
267: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PVT
263: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
264: P_API_NAME => L_API_NAME
265: ,P_PKG_NAME => G_PKG_NAME
266: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
267: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PVT
268: ,X_MSG_COUNT => X_MSG_COUNT
269: ,X_MSG_DATA => X_MSG_DATA
270: ,X_RETURN_STATUS => X_RETURN_STATUS);
271:
269: ,X_MSG_DATA => X_MSG_DATA
270: ,X_RETURN_STATUS => X_RETURN_STATUS);
271:
272: WHEN OTHERS THEN
273: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
274: P_API_NAME => L_API_NAME
275: ,P_PKG_NAME => G_PKG_NAME
276: ,P_EXCEPTION_LEVEL => AS_UTILITY_PVT.G_EXC_OTHERS
277: ,P_SQLCODE => SQLCODE
272: WHEN OTHERS THEN
273: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
274: P_API_NAME => L_API_NAME
275: ,P_PKG_NAME => G_PKG_NAME
276: ,P_EXCEPTION_LEVEL => AS_UTILITY_PVT.G_EXC_OTHERS
277: ,P_SQLCODE => SQLCODE
278: ,P_SQLERRM => SQLERRM
279: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PVT
280: ,X_MSG_COUNT => X_MSG_COUNT
275: ,P_PKG_NAME => G_PKG_NAME
276: ,P_EXCEPTION_LEVEL => AS_UTILITY_PVT.G_EXC_OTHERS
277: ,P_SQLCODE => SQLCODE
278: ,P_SQLERRM => SQLERRM
279: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PVT
280: ,X_MSG_COUNT => X_MSG_COUNT
281: ,X_MSG_DATA => X_MSG_DATA
282: ,X_RETURN_STATUS => X_RETURN_STATUS);
283: End Create_case_contact;
399: IEX_DEBUG_PUB.LogMessage ('********* end of Procedure =>IEX_CASE_CONTACTS_PVT.update_case_contact ******** ');
400: END IF;
401: EXCEPTION
402: WHEN FND_API.G_EXC_ERROR THEN
403: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
404: P_API_NAME => L_API_NAME
405: ,P_PKG_NAME => G_PKG_NAME
406: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
407: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PVT
403: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
404: P_API_NAME => L_API_NAME
405: ,P_PKG_NAME => G_PKG_NAME
406: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
407: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PVT
408: ,X_MSG_COUNT => X_MSG_COUNT
409: ,X_MSG_DATA => X_MSG_DATA
410: ,X_RETURN_STATUS => X_RETURN_STATUS);
411:
409: ,X_MSG_DATA => X_MSG_DATA
410: ,X_RETURN_STATUS => X_RETURN_STATUS);
411:
412: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
413: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
414: P_API_NAME => L_API_NAME
415: ,P_PKG_NAME => G_PKG_NAME
416: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
417: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PVT
413: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
414: P_API_NAME => L_API_NAME
415: ,P_PKG_NAME => G_PKG_NAME
416: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
417: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PVT
418: ,X_MSG_COUNT => X_MSG_COUNT
419: ,X_MSG_DATA => X_MSG_DATA
420: ,X_RETURN_STATUS => X_RETURN_STATUS);
421:
419: ,X_MSG_DATA => X_MSG_DATA
420: ,X_RETURN_STATUS => X_RETURN_STATUS);
421:
422: WHEN OTHERS THEN
423: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
424: P_API_NAME => L_API_NAME
425: ,P_PKG_NAME => G_PKG_NAME
426: ,P_EXCEPTION_LEVEL => AS_UTILITY_PVT.G_EXC_OTHERS
427: ,P_SQLCODE => SQLCODE
422: WHEN OTHERS THEN
423: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
424: P_API_NAME => L_API_NAME
425: ,P_PKG_NAME => G_PKG_NAME
426: ,P_EXCEPTION_LEVEL => AS_UTILITY_PVT.G_EXC_OTHERS
427: ,P_SQLCODE => SQLCODE
428: ,P_SQLERRM => SQLERRM
429: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PVT
430: ,X_MSG_COUNT => X_MSG_COUNT
425: ,P_PKG_NAME => G_PKG_NAME
426: ,P_EXCEPTION_LEVEL => AS_UTILITY_PVT.G_EXC_OTHERS
427: ,P_SQLCODE => SQLCODE
428: ,P_SQLERRM => SQLERRM
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: End Update_case_contact;
506: IEX_DEBUG_PUB.LogMessage ('********* End of Procedure =>IEX_CASE_CONTACTS_PVT.delete_case_contact ******** ');
507: END IF;
508: EXCEPTION
509: WHEN FND_API.G_EXC_ERROR THEN
510: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
511: P_API_NAME => L_API_NAME
512: ,P_PKG_NAME => G_PKG_NAME
513: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
514: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PVT
510: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
511: P_API_NAME => L_API_NAME
512: ,P_PKG_NAME => G_PKG_NAME
513: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
514: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PVT
515: ,X_MSG_COUNT => X_MSG_COUNT
516: ,X_MSG_DATA => X_MSG_DATA
517: ,X_RETURN_STATUS => X_RETURN_STATUS);
518:
516: ,X_MSG_DATA => X_MSG_DATA
517: ,X_RETURN_STATUS => X_RETURN_STATUS);
518:
519: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
520: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
521: P_API_NAME => L_API_NAME
522: ,P_PKG_NAME => G_PKG_NAME
523: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
524: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PVT
520: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
521: P_API_NAME => L_API_NAME
522: ,P_PKG_NAME => G_PKG_NAME
523: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
524: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PVT
525: ,X_MSG_COUNT => X_MSG_COUNT
526: ,X_MSG_DATA => X_MSG_DATA
527: ,X_RETURN_STATUS => X_RETURN_STATUS);
528:
526: ,X_MSG_DATA => X_MSG_DATA
527: ,X_RETURN_STATUS => X_RETURN_STATUS);
528:
529: WHEN OTHERS 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 => AS_UTILITY_PVT.G_EXC_OTHERS
534: ,P_SQLCODE => SQLCODE
529: WHEN OTHERS 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 => AS_UTILITY_PVT.G_EXC_OTHERS
534: ,P_SQLCODE => SQLCODE
535: ,P_SQLERRM => SQLERRM
536: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PVT
537: ,X_MSG_COUNT => X_MSG_COUNT
532: ,P_PKG_NAME => G_PKG_NAME
533: ,P_EXCEPTION_LEVEL => AS_UTILITY_PVT.G_EXC_OTHERS
534: ,P_SQLCODE => SQLCODE
535: ,P_SQLERRM => SQLERRM
536: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PVT
537: ,X_MSG_COUNT => X_MSG_COUNT
538: ,X_MSG_DATA => X_MSG_DATA
539: ,X_RETURN_STATUS => X_RETURN_STATUS);
540: End Delete_case_contact;