226: IEX_DEBUG_PUB.LogMessage ('********* end of Procedure =>IEX_strategy_work_items_PVT.Create_strategy_work_items ******** ');
227: END IF;
228: EXCEPTION
229: WHEN FND_API.G_EXC_ERROR THEN
230: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
231: P_API_NAME => L_API_NAME
232: ,P_PKG_NAME => G_PKG_NAME
233: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
234: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PVT
230: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
231: P_API_NAME => L_API_NAME
232: ,P_PKG_NAME => G_PKG_NAME
233: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
234: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PVT
235: ,X_MSG_COUNT => X_MSG_COUNT
236: ,X_MSG_DATA => X_MSG_DATA
237: ,X_RETURN_STATUS => X_RETURN_STATUS);
238:
236: ,X_MSG_DATA => X_MSG_DATA
237: ,X_RETURN_STATUS => X_RETURN_STATUS);
238:
239: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
240: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
241: P_API_NAME => L_API_NAME
242: ,P_PKG_NAME => G_PKG_NAME
243: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
244: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PVT
240: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
241: P_API_NAME => L_API_NAME
242: ,P_PKG_NAME => G_PKG_NAME
243: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
244: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PVT
245: ,X_MSG_COUNT => X_MSG_COUNT
246: ,X_MSG_DATA => X_MSG_DATA
247: ,X_RETURN_STATUS => X_RETURN_STATUS);
248:
246: ,X_MSG_DATA => X_MSG_DATA
247: ,X_RETURN_STATUS => X_RETURN_STATUS);
248:
249: WHEN OTHERS THEN
250: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
251: P_API_NAME => L_API_NAME
252: ,P_PKG_NAME => G_PKG_NAME
253: ,P_EXCEPTION_LEVEL => AS_UTILITY_PVT.G_EXC_OTHERS
254: ,P_SQLCODE => SQLCODE
249: WHEN OTHERS THEN
250: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
251: P_API_NAME => L_API_NAME
252: ,P_PKG_NAME => G_PKG_NAME
253: ,P_EXCEPTION_LEVEL => AS_UTILITY_PVT.G_EXC_OTHERS
254: ,P_SQLCODE => SQLCODE
255: ,P_SQLERRM => SQLERRM
256: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PVT
257: ,X_MSG_COUNT => X_MSG_COUNT
252: ,P_PKG_NAME => G_PKG_NAME
253: ,P_EXCEPTION_LEVEL => AS_UTILITY_PVT.G_EXC_OTHERS
254: ,P_SQLCODE => SQLCODE
255: ,P_SQLERRM => SQLERRM
256: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PVT
257: ,X_MSG_COUNT => X_MSG_COUNT
258: ,X_MSG_DATA => X_MSG_DATA
259: ,X_RETURN_STATUS => X_RETURN_STATUS);
260: End Create_strategy_work_items;
464: WHEN OTHERS THEN
465: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
466: IEX_DEBUG_PUB.LogMessage( debug_msg => 'IEU_UWQM_ITEMS' || to_char(p_strategy_work_item_rec.work_item_id), print_date => 'Y');
467: END IF;
468: AS_UTILITY_PVT.Set_Message(
469: p_msg_level => FND_MSG_PUB.G_MSG_LVL_ERROR,
470: p_msg_name => 'IEX_METAPHOR_CREATION_FAILED',
471: p_token1 => 'WORK_ITEM ',
472: p_token1_value => to_char(p_strategy_work_item_rec.work_item_id));
496: IEX_DEBUG_PUB.LogMessage ('********* end of Procedure =>IEX_strategy_work_items_PVT.update_strategy_work_items ******** ');
497: END IF;
498: EXCEPTION
499: WHEN FND_API.G_EXC_ERROR THEN
500: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
501: P_API_NAME => L_API_NAME
502: ,P_PKG_NAME => G_PKG_NAME
503: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
504: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PVT
500: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
501: P_API_NAME => L_API_NAME
502: ,P_PKG_NAME => G_PKG_NAME
503: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
504: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PVT
505: ,X_MSG_COUNT => X_MSG_COUNT
506: ,X_MSG_DATA => X_MSG_DATA
507: ,X_RETURN_STATUS => X_RETURN_STATUS);
508:
506: ,X_MSG_DATA => X_MSG_DATA
507: ,X_RETURN_STATUS => X_RETURN_STATUS);
508:
509: WHEN FND_API.G_EXC_UNEXPECTED_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_UNEXP_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_UNEXP_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 OTHERS 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 => AS_UTILITY_PVT.G_EXC_OTHERS
524: ,P_SQLCODE => SQLCODE
519: WHEN OTHERS 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 => AS_UTILITY_PVT.G_EXC_OTHERS
524: ,P_SQLCODE => SQLCODE
525: ,P_SQLERRM => SQLERRM
526: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PVT
527: ,X_MSG_COUNT => X_MSG_COUNT
522: ,P_PKG_NAME => G_PKG_NAME
523: ,P_EXCEPTION_LEVEL => AS_UTILITY_PVT.G_EXC_OTHERS
524: ,P_SQLCODE => SQLCODE
525: ,P_SQLERRM => SQLERRM
526: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PVT
527: ,X_MSG_COUNT => X_MSG_COUNT
528: ,X_MSG_DATA => X_MSG_DATA
529: ,X_RETURN_STATUS => X_RETURN_STATUS);
530: End Update_strategy_work_items;
593: );
594:
595: EXCEPTION
596: WHEN FND_API.G_EXC_ERROR THEN
597: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
598: P_API_NAME => L_API_NAME
599: ,P_PKG_NAME => G_PKG_NAME
600: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
601: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PVT
597: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
598: P_API_NAME => L_API_NAME
599: ,P_PKG_NAME => G_PKG_NAME
600: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
601: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PVT
602: ,X_MSG_COUNT => X_MSG_COUNT
603: ,X_MSG_DATA => X_MSG_DATA
604: ,X_RETURN_STATUS => X_RETURN_STATUS);
605:
603: ,X_MSG_DATA => X_MSG_DATA
604: ,X_RETURN_STATUS => X_RETURN_STATUS);
605:
606: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
607: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
608: P_API_NAME => L_API_NAME
609: ,P_PKG_NAME => G_PKG_NAME
610: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
611: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PVT
607: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
608: P_API_NAME => L_API_NAME
609: ,P_PKG_NAME => G_PKG_NAME
610: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
611: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PVT
612: ,X_MSG_COUNT => X_MSG_COUNT
613: ,X_MSG_DATA => X_MSG_DATA
614: ,X_RETURN_STATUS => X_RETURN_STATUS);
615:
613: ,X_MSG_DATA => X_MSG_DATA
614: ,X_RETURN_STATUS => X_RETURN_STATUS);
615:
616: WHEN OTHERS THEN
617: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
618: P_API_NAME => L_API_NAME
619: ,P_PKG_NAME => G_PKG_NAME
620: ,P_EXCEPTION_LEVEL => AS_UTILITY_PVT.G_EXC_OTHERS
621: ,P_SQLCODE => SQLCODE
616: WHEN OTHERS THEN
617: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
618: P_API_NAME => L_API_NAME
619: ,P_PKG_NAME => G_PKG_NAME
620: ,P_EXCEPTION_LEVEL => AS_UTILITY_PVT.G_EXC_OTHERS
621: ,P_SQLCODE => SQLCODE
622: ,P_SQLERRM => SQLERRM
623: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PVT
624: ,X_MSG_COUNT => X_MSG_COUNT
619: ,P_PKG_NAME => G_PKG_NAME
620: ,P_EXCEPTION_LEVEL => AS_UTILITY_PVT.G_EXC_OTHERS
621: ,P_SQLCODE => SQLCODE
622: ,P_SQLERRM => SQLERRM
623: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PVT
624: ,X_MSG_COUNT => X_MSG_COUNT
625: ,X_MSG_DATA => X_MSG_DATA
626: ,X_RETURN_STATUS => X_RETURN_STATUS);
627: End Delete_strategy_work_items;