190: IEX_DEBUG_PUB.LogMessage ('********* End of Procedure =>IEX_STRATEGY_PVT.create_STRATEGY ******** ');
191: END IF;
192: EXCEPTION
193: WHEN FND_API.G_EXC_ERROR THEN
194: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
195: P_API_NAME => L_API_NAME
196: ,P_PKG_NAME => G_PKG_NAME
197: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
198: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PVT
194: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
195: P_API_NAME => L_API_NAME
196: ,P_PKG_NAME => G_PKG_NAME
197: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
198: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PVT
199: ,X_MSG_COUNT => X_MSG_COUNT
200: ,X_MSG_DATA => X_MSG_DATA
201: ,X_RETURN_STATUS => X_RETURN_STATUS);
202:
200: ,X_MSG_DATA => X_MSG_DATA
201: ,X_RETURN_STATUS => X_RETURN_STATUS);
202:
203: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
204: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
205: P_API_NAME => L_API_NAME
206: ,P_PKG_NAME => G_PKG_NAME
207: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
208: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PVT
204: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
205: P_API_NAME => L_API_NAME
206: ,P_PKG_NAME => G_PKG_NAME
207: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
208: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PVT
209: ,X_MSG_COUNT => X_MSG_COUNT
210: ,X_MSG_DATA => X_MSG_DATA
211: ,X_RETURN_STATUS => X_RETURN_STATUS);
212:
210: ,X_MSG_DATA => X_MSG_DATA
211: ,X_RETURN_STATUS => X_RETURN_STATUS);
212:
213: WHEN OTHERS THEN
214: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
215: P_API_NAME => L_API_NAME
216: ,P_PKG_NAME => G_PKG_NAME
217: ,P_EXCEPTION_LEVEL => AS_UTILITY_PVT.G_EXC_OTHERS
218: ,P_SQLCODE => SQLCODE
213: WHEN OTHERS THEN
214: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
215: P_API_NAME => L_API_NAME
216: ,P_PKG_NAME => G_PKG_NAME
217: ,P_EXCEPTION_LEVEL => AS_UTILITY_PVT.G_EXC_OTHERS
218: ,P_SQLCODE => SQLCODE
219: ,P_SQLERRM => SQLERRM
220: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PVT
221: ,X_MSG_COUNT => X_MSG_COUNT
216: ,P_PKG_NAME => G_PKG_NAME
217: ,P_EXCEPTION_LEVEL => AS_UTILITY_PVT.G_EXC_OTHERS
218: ,P_SQLCODE => SQLCODE
219: ,P_SQLERRM => SQLERRM
220: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PVT
221: ,X_MSG_COUNT => X_MSG_COUNT
222: ,X_MSG_DATA => X_MSG_DATA
223: ,X_RETURN_STATUS => X_RETURN_STATUS);
224: End Create_strategy;
366: IEX_DEBUG_PUB.LogMessage ('********* End of Procedure =>IEX_strategy_PVT.Update_strategy ******** ');
367: END IF;
368: EXCEPTION
369: WHEN FND_API.G_EXC_ERROR THEN
370: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
371: P_API_NAME => L_API_NAME
372: ,P_PKG_NAME => G_PKG_NAME
373: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
374: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PVT
370: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
371: P_API_NAME => L_API_NAME
372: ,P_PKG_NAME => G_PKG_NAME
373: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
374: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PVT
375: ,X_MSG_COUNT => X_MSG_COUNT
376: ,X_MSG_DATA => X_MSG_DATA
377: ,X_RETURN_STATUS => X_RETURN_STATUS);
378:
376: ,X_MSG_DATA => X_MSG_DATA
377: ,X_RETURN_STATUS => X_RETURN_STATUS);
378:
379: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
380: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
381: P_API_NAME => L_API_NAME
382: ,P_PKG_NAME => G_PKG_NAME
383: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
384: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PVT
380: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
381: P_API_NAME => L_API_NAME
382: ,P_PKG_NAME => G_PKG_NAME
383: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
384: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PVT
385: ,X_MSG_COUNT => X_MSG_COUNT
386: ,X_MSG_DATA => X_MSG_DATA
387: ,X_RETURN_STATUS => X_RETURN_STATUS);
388:
386: ,X_MSG_DATA => X_MSG_DATA
387: ,X_RETURN_STATUS => X_RETURN_STATUS);
388:
389: WHEN OTHERS THEN
390: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
391: P_API_NAME => L_API_NAME
392: ,P_PKG_NAME => G_PKG_NAME
393: ,P_EXCEPTION_LEVEL => AS_UTILITY_PVT.G_EXC_OTHERS
394: ,P_SQLCODE => SQLCODE
389: WHEN OTHERS THEN
390: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
391: P_API_NAME => L_API_NAME
392: ,P_PKG_NAME => G_PKG_NAME
393: ,P_EXCEPTION_LEVEL => AS_UTILITY_PVT.G_EXC_OTHERS
394: ,P_SQLCODE => SQLCODE
395: ,P_SQLERRM => SQLERRM
396: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PVT
397: ,X_MSG_COUNT => X_MSG_COUNT
392: ,P_PKG_NAME => G_PKG_NAME
393: ,P_EXCEPTION_LEVEL => AS_UTILITY_PVT.G_EXC_OTHERS
394: ,P_SQLCODE => SQLCODE
395: ,P_SQLERRM => SQLERRM
396: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PVT
397: ,X_MSG_COUNT => X_MSG_COUNT
398: ,X_MSG_DATA => X_MSG_DATA
399: ,X_RETURN_STATUS => X_RETURN_STATUS);
400: End Update_strategy;
468: );
469:
470: EXCEPTION
471: WHEN FND_API.G_EXC_ERROR THEN
472: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
473: P_API_NAME => L_API_NAME
474: ,P_PKG_NAME => G_PKG_NAME
475: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
476: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PVT
472: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
473: P_API_NAME => L_API_NAME
474: ,P_PKG_NAME => G_PKG_NAME
475: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
476: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PVT
477: ,X_MSG_COUNT => X_MSG_COUNT
478: ,X_MSG_DATA => X_MSG_DATA
479: ,X_RETURN_STATUS => X_RETURN_STATUS);
480:
478: ,X_MSG_DATA => X_MSG_DATA
479: ,X_RETURN_STATUS => X_RETURN_STATUS);
480:
481: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
482: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
483: P_API_NAME => L_API_NAME
484: ,P_PKG_NAME => G_PKG_NAME
485: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
486: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PVT
482: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
483: P_API_NAME => L_API_NAME
484: ,P_PKG_NAME => G_PKG_NAME
485: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
486: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PVT
487: ,X_MSG_COUNT => X_MSG_COUNT
488: ,X_MSG_DATA => X_MSG_DATA
489: ,X_RETURN_STATUS => X_RETURN_STATUS);
490:
488: ,X_MSG_DATA => X_MSG_DATA
489: ,X_RETURN_STATUS => X_RETURN_STATUS);
490:
491: WHEN OTHERS THEN
492: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
493: P_API_NAME => L_API_NAME
494: ,P_PKG_NAME => G_PKG_NAME
495: ,P_EXCEPTION_LEVEL => AS_UTILITY_PVT.G_EXC_OTHERS
496: ,P_SQLCODE => SQLCODE
491: WHEN OTHERS THEN
492: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
493: P_API_NAME => L_API_NAME
494: ,P_PKG_NAME => G_PKG_NAME
495: ,P_EXCEPTION_LEVEL => AS_UTILITY_PVT.G_EXC_OTHERS
496: ,P_SQLCODE => SQLCODE
497: ,P_SQLERRM => SQLERRM
498: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PVT
499: ,X_MSG_COUNT => X_MSG_COUNT
494: ,P_PKG_NAME => G_PKG_NAME
495: ,P_EXCEPTION_LEVEL => AS_UTILITY_PVT.G_EXC_OTHERS
496: ,P_SQLCODE => SQLCODE
497: ,P_SQLERRM => SQLERRM
498: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PVT
499: ,X_MSG_COUNT => X_MSG_COUNT
500: ,X_MSG_DATA => X_MSG_DATA
501: ,X_RETURN_STATUS => X_RETURN_STATUS);
502: End Delete_strategy;