APPS.EGO_ITEM_TEXT_UTIL dependencies on INV_ITEM_MSG

Line 825: Mctx INV_ITEM_MSG.Msg_Ctx_type;

821: , p_maxtime IN NUMBER DEFAULT AD_CTX_DDL.Maxtime_Unlimited
822: )
823: IS
824:
825: Mctx INV_ITEM_MSG.Msg_Ctx_type;
826: l_api_name CONSTANT VARCHAR2(30) := 'Optimize_Index';
827: l_success CONSTANT NUMBER := 0;
828: l_error CONSTANT NUMBER := 2;
829: l_debug NUMBER := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);

Line 834: INV_ITEM_MSG.Initialize;

830: l_maxtime NUMBER := NVL(p_maxtime,AD_CTX_DDL.Maxtime_Unlimited);
831:
832: BEGIN
833:
834: INV_ITEM_MSG.Initialize;
835: INV_ITEM_MSG.set_Message_Mode ('CP_LOG');
836:
837: -- Set message level
838: INV_ITEM_MSG.set_Message_Level (INV_ITEM_MSG.g_Level_Error);

Line 835: INV_ITEM_MSG.set_Message_Mode ('CP_LOG');

831:
832: BEGIN
833:
834: INV_ITEM_MSG.Initialize;
835: INV_ITEM_MSG.set_Message_Mode ('CP_LOG');
836:
837: -- Set message level
838: INV_ITEM_MSG.set_Message_Level (INV_ITEM_MSG.g_Level_Error);
839:

Line 838: INV_ITEM_MSG.set_Message_Level (INV_ITEM_MSG.g_Level_Error);

834: INV_ITEM_MSG.Initialize;
835: INV_ITEM_MSG.set_Message_Mode ('CP_LOG');
836:
837: -- Set message level
838: INV_ITEM_MSG.set_Message_Level (INV_ITEM_MSG.g_Level_Error);
839:
840: -- Define message context
841: Mctx.Package_Name := G_PKG_NAME;
842: Mctx.Procedure_Name := l_api_name;

Line 845: INV_ITEM_MSG.Debug(Mctx, 'Started AD_CTX_DDL.Optimize_Index..');

841: Mctx.Package_Name := G_PKG_NAME;
842: Mctx.Procedure_Name := l_api_name;
843:
844: IF (l_debug = 1) THEN
845: INV_ITEM_MSG.Debug(Mctx, 'Started AD_CTX_DDL.Optimize_Index..');
846: INV_ITEM_MSG.Debug(Mctx, 'Optimization Level :'||p_optlevel);
847: INV_ITEM_MSG.Debug(Mctx, 'Maximum Optimization Time :'||p_maxtime);
848: END IF;
849:

Line 846: INV_ITEM_MSG.Debug(Mctx, 'Optimization Level :'||p_optlevel);

842: Mctx.Procedure_Name := l_api_name;
843:
844: IF (l_debug = 1) THEN
845: INV_ITEM_MSG.Debug(Mctx, 'Started AD_CTX_DDL.Optimize_Index..');
846: INV_ITEM_MSG.Debug(Mctx, 'Optimization Level :'||p_optlevel);
847: INV_ITEM_MSG.Debug(Mctx, 'Maximum Optimization Time :'||p_maxtime);
848: END IF;
849:
850: --3067433: Maxtime should be null for FAST Optimize mode

Line 847: INV_ITEM_MSG.Debug(Mctx, 'Maximum Optimization Time :'||p_maxtime);

843:
844: IF (l_debug = 1) THEN
845: INV_ITEM_MSG.Debug(Mctx, 'Started AD_CTX_DDL.Optimize_Index..');
846: INV_ITEM_MSG.Debug(Mctx, 'Optimization Level :'||p_optlevel);
847: INV_ITEM_MSG.Debug(Mctx, 'Maximum Optimization Time :'||p_maxtime);
848: END IF;
849:
850: --3067433: Maxtime should be null for FAST Optimize mode
851: IF p_optlevel ='FAST' THEN

Line 860: INV_ITEM_MSG.Debug(Mctx, 'Completed AD_CTX_DDL.Optimize_Index..');

856: , optlevel => NVL(p_optlevel,AD_CTX_DDL.Optlevel_Full)
857: , maxtime => l_maxtime);
858:
859: IF (l_debug = 1) THEN
860: INV_ITEM_MSG.Debug(Mctx, 'Completed AD_CTX_DDL.Optimize_Index..');
861: END IF;
862:
863: RETCODE := l_success;
864: ERRBUF := FND_MESSAGE.Get_String('EGO', 'EGO_OPTIMINDEX_SUCCESS');

Line 867: INV_ITEM_MSG.Write_List (p_delete => TRUE);

863: RETCODE := l_success;
864: ERRBUF := FND_MESSAGE.Get_String('EGO', 'EGO_OPTIMINDEX_SUCCESS');
865:
866: -- Write all accumulated messages
867: INV_ITEM_MSG.Write_List (p_delete => TRUE);
868:
869: EXCEPTION
870: WHEN OTHERS THEN
871: RETCODE := l_error;

Line 874: INV_ITEM_MSG.Add_Message

870: WHEN OTHERS THEN
871: RETCODE := l_error;
872: ERRBUF := FND_MESSAGE.Get_String('EGO', 'EGO_OPTIMINDEX_FAILURE');
873:
874: INV_ITEM_MSG.Add_Message
875: ( p_Msg_Name => 'INV_ITEM_UNEXPECTED_ERROR'
876: , p_token1 => 'PACKAGE_NAME'
877: , p_value1 => G_PKG_NAME
878: , p_token2 => 'PROCEDURE_NAME'

Line 884: INV_ITEM_MSG.Write_List (p_delete => TRUE);

880: , p_token3 => 'ERROR_TEXT'
881: , p_value3 => SUBSTRB(SQLERRM, 1,240));
882:
883: -- Write all accumulated messages
884: INV_ITEM_MSG.Write_List (p_delete => TRUE);
885:
886: END Optimize_Index;
887: -- End : Concurrent Program for Optimize iM index
888: