DBA Data[Home] [Help]

APPS.IEX_STRATEGY_WORK_ITEMS_PVT dependencies on AS_UTILITY_PVT

Line 230: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(

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

Line 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:

Line 240: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(

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

Line 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:

Line 250: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(

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

Line 253: ,P_EXCEPTION_LEVEL => AS_UTILITY_PVT.G_EXC_OTHERS

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

Line 256: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PVT

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;

Line 468: AS_UTILITY_PVT.Set_Message(

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));

Line 500: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(

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

Line 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:

Line 510: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(

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

Line 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:

Line 520: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(

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

Line 523: ,P_EXCEPTION_LEVEL => AS_UTILITY_PVT.G_EXC_OTHERS

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

Line 526: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PVT

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;

Line 597: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(

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

Line 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:

Line 607: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(

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

Line 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:

Line 617: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(

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

Line 620: ,P_EXCEPTION_LEVEL => AS_UTILITY_PVT.G_EXC_OTHERS

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

Line 623: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PVT

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;