Tuesday, July 5, 2011

How to enable ASO (or any other module Log in PLSQL)

FND_PROFILE.PUT('ASO_ENABLE_DEBUG','Y');
ASO_DEBUG_PUB.Initialize;
ASO_DEBUG_PUB.debug_on;
ASO_DEBUG_PUB.SetDebugLevel(10);
l_file:= ASO_DEBUG_PUB.Set_Debug_Mode('FILE');

dbms_output.put_line('File :'||l_file); //This file will contain all debug statements

IF aso_debug_pub.g_debug_flag = 'Y' THEN
ASO_DEBUG_PUB.add('------------------------------------');
ASO_DEBUG_PUB.add('ASO LOG ENABLED');
ASO_DEBUG_PUB.add('------------------------------------');
END IF;

No comments:

Post a Comment