DBA Data[Home] [Help]

APPS.IEX_STRATEGY_WORK_ITEMS_PVT dependencies on AS_UTILITY_PVT

Line 243: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(

239: IEX_DEBUG_PUB.LogMessage ('********* end of Procedure =>IEX_strategy_work_items_PVT.Create_strategy_work_items ******** ');
240: END IF;
241: EXCEPTION
242: WHEN FND_API.G_EXC_ERROR THEN
243: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
244: P_API_NAME => L_API_NAME
245: ,P_PKG_NAME => G_PKG_NAME
246: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
247: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PVT

Line 247: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PVT

243: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
244: P_API_NAME => L_API_NAME
245: ,P_PKG_NAME => G_PKG_NAME
246: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
247: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PVT
248: ,X_MSG_COUNT => X_MSG_COUNT
249: ,X_MSG_DATA => X_MSG_DATA
250: ,X_RETURN_STATUS => X_RETURN_STATUS);
251:

Line 253: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(

249: ,X_MSG_DATA => X_MSG_DATA
250: ,X_RETURN_STATUS => X_RETURN_STATUS);
251:
252: WHEN FND_API.G_EXC_UNEXPECTED_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_UNEXP_ERROR
257: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PVT

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

Line 263: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(

259: ,X_MSG_DATA => X_MSG_DATA
260: ,X_RETURN_STATUS => X_RETURN_STATUS);
261:
262: WHEN OTHERS 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 => AS_UTILITY_PVT.G_EXC_OTHERS
267: ,P_SQLCODE => SQLCODE

Line 266: ,P_EXCEPTION_LEVEL => AS_UTILITY_PVT.G_EXC_OTHERS

262: WHEN OTHERS 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 => AS_UTILITY_PVT.G_EXC_OTHERS
267: ,P_SQLCODE => SQLCODE
268: ,P_SQLERRM => SQLERRM
269: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PVT
270: ,X_MSG_COUNT => X_MSG_COUNT

Line 269: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PVT

265: ,P_PKG_NAME => G_PKG_NAME
266: ,P_EXCEPTION_LEVEL => AS_UTILITY_PVT.G_EXC_OTHERS
267: ,P_SQLCODE => SQLCODE
268: ,P_SQLERRM => SQLERRM
269: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PVT
270: ,X_MSG_COUNT => X_MSG_COUNT
271: ,X_MSG_DATA => X_MSG_DATA
272: ,X_RETURN_STATUS => X_RETURN_STATUS);
273: End Create_strategy_work_items;

Line 481: AS_UTILITY_PVT.Set_Message(

477: WHEN OTHERS THEN
478: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
479: IEX_DEBUG_PUB.LogMessage( debug_msg => 'IEU_UWQM_ITEMS' || to_char(p_strategy_work_item_rec.work_item_id), print_date => 'Y');
480: END IF;
481: AS_UTILITY_PVT.Set_Message(
482: p_msg_level => FND_MSG_PUB.G_MSG_LVL_ERROR,
483: p_msg_name => 'IEX_METAPHOR_CREATION_FAILED',
484: p_token1 => 'WORK_ITEM ',
485: p_token1_value => to_char(p_strategy_work_item_rec.work_item_id));

Line 513: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(

509: IEX_DEBUG_PUB.LogMessage ('********* end of Procedure =>IEX_strategy_work_items_PVT.update_strategy_work_items ******** ');
510: END IF;
511: EXCEPTION
512: WHEN FND_API.G_EXC_ERROR THEN
513: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
514: P_API_NAME => L_API_NAME
515: ,P_PKG_NAME => G_PKG_NAME
516: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
517: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PVT

Line 517: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PVT

513: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
514: P_API_NAME => L_API_NAME
515: ,P_PKG_NAME => G_PKG_NAME
516: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
517: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PVT
518: ,X_MSG_COUNT => X_MSG_COUNT
519: ,X_MSG_DATA => X_MSG_DATA
520: ,X_RETURN_STATUS => X_RETURN_STATUS);
521:

Line 523: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(

519: ,X_MSG_DATA => X_MSG_DATA
520: ,X_RETURN_STATUS => X_RETURN_STATUS);
521:
522: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
523: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
524: P_API_NAME => L_API_NAME
525: ,P_PKG_NAME => G_PKG_NAME
526: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
527: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PVT

Line 527: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PVT

523: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
524: P_API_NAME => L_API_NAME
525: ,P_PKG_NAME => G_PKG_NAME
526: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
527: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PVT
528: ,X_MSG_COUNT => X_MSG_COUNT
529: ,X_MSG_DATA => X_MSG_DATA
530: ,X_RETURN_STATUS => X_RETURN_STATUS);
531:

Line 533: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(

529: ,X_MSG_DATA => X_MSG_DATA
530: ,X_RETURN_STATUS => X_RETURN_STATUS);
531:
532: WHEN OTHERS THEN
533: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
534: P_API_NAME => L_API_NAME
535: ,P_PKG_NAME => G_PKG_NAME
536: ,P_EXCEPTION_LEVEL => AS_UTILITY_PVT.G_EXC_OTHERS
537: ,P_SQLCODE => SQLCODE

Line 536: ,P_EXCEPTION_LEVEL => AS_UTILITY_PVT.G_EXC_OTHERS

532: WHEN OTHERS THEN
533: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
534: P_API_NAME => L_API_NAME
535: ,P_PKG_NAME => G_PKG_NAME
536: ,P_EXCEPTION_LEVEL => AS_UTILITY_PVT.G_EXC_OTHERS
537: ,P_SQLCODE => SQLCODE
538: ,P_SQLERRM => SQLERRM
539: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PVT
540: ,X_MSG_COUNT => X_MSG_COUNT

Line 539: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PVT

535: ,P_PKG_NAME => G_PKG_NAME
536: ,P_EXCEPTION_LEVEL => AS_UTILITY_PVT.G_EXC_OTHERS
537: ,P_SQLCODE => SQLCODE
538: ,P_SQLERRM => SQLERRM
539: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PVT
540: ,X_MSG_COUNT => X_MSG_COUNT
541: ,X_MSG_DATA => X_MSG_DATA
542: ,X_RETURN_STATUS => X_RETURN_STATUS);
543: End Update_strategy_work_items;

Line 610: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(

606: );
607:
608: EXCEPTION
609: WHEN FND_API.G_EXC_ERROR THEN
610: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
611: P_API_NAME => L_API_NAME
612: ,P_PKG_NAME => G_PKG_NAME
613: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
614: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PVT

Line 614: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PVT

610: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
611: P_API_NAME => L_API_NAME
612: ,P_PKG_NAME => G_PKG_NAME
613: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
614: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PVT
615: ,X_MSG_COUNT => X_MSG_COUNT
616: ,X_MSG_DATA => X_MSG_DATA
617: ,X_RETURN_STATUS => X_RETURN_STATUS);
618:

Line 620: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(

616: ,X_MSG_DATA => X_MSG_DATA
617: ,X_RETURN_STATUS => X_RETURN_STATUS);
618:
619: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
620: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
621: P_API_NAME => L_API_NAME
622: ,P_PKG_NAME => G_PKG_NAME
623: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
624: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PVT

Line 624: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PVT

620: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
621: P_API_NAME => L_API_NAME
622: ,P_PKG_NAME => G_PKG_NAME
623: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
624: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PVT
625: ,X_MSG_COUNT => X_MSG_COUNT
626: ,X_MSG_DATA => X_MSG_DATA
627: ,X_RETURN_STATUS => X_RETURN_STATUS);
628:

Line 630: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(

626: ,X_MSG_DATA => X_MSG_DATA
627: ,X_RETURN_STATUS => X_RETURN_STATUS);
628:
629: WHEN OTHERS THEN
630: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
631: P_API_NAME => L_API_NAME
632: ,P_PKG_NAME => G_PKG_NAME
633: ,P_EXCEPTION_LEVEL => AS_UTILITY_PVT.G_EXC_OTHERS
634: ,P_SQLCODE => SQLCODE

Line 633: ,P_EXCEPTION_LEVEL => AS_UTILITY_PVT.G_EXC_OTHERS

629: WHEN OTHERS THEN
630: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
631: P_API_NAME => L_API_NAME
632: ,P_PKG_NAME => G_PKG_NAME
633: ,P_EXCEPTION_LEVEL => AS_UTILITY_PVT.G_EXC_OTHERS
634: ,P_SQLCODE => SQLCODE
635: ,P_SQLERRM => SQLERRM
636: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PVT
637: ,X_MSG_COUNT => X_MSG_COUNT

Line 636: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PVT

632: ,P_PKG_NAME => G_PKG_NAME
633: ,P_EXCEPTION_LEVEL => AS_UTILITY_PVT.G_EXC_OTHERS
634: ,P_SQLCODE => SQLCODE
635: ,P_SQLERRM => SQLERRM
636: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PVT
637: ,X_MSG_COUNT => X_MSG_COUNT
638: ,X_MSG_DATA => X_MSG_DATA
639: ,X_RETURN_STATUS => X_RETURN_STATUS);
640: End Delete_strategy_work_items;