[Profile] FND: Message Level Threshold

FND: Message Level Threshold is used for debugging issues.

The internal name of the profile is FND_AS_MSG_LEVEL_THRESHOLD.

In the FND code tree, its value is checked in only one place: FND_MSG_PUB.Check_Msg_Level() function.
This function is used to check if the level of the message, that a developer wants to write to the message table, is higher or equal to the FND: Message Level Threshold value or not. If the function returns TRUE (message level >= FND_AS_MSG_LEVEL_THRESHOLD), then the developer should go ahead and write the message to the message table else the developer should should skip writing this message. The value of FND: Message Level Threshold is determined using the lookup_type Message Level Threshold which has the following lookup_codes or possible values: 

10 = Debug Low 
20 = Debug Medium 
30 = Debug High 
40 = Success 
50 = Error 
60 = Unexpected Error 

So, if FND: Message Level Threshold is set to 10, then it is likely that all messages that a developer wanted to write to the message table will get written. A value of 60 would only write Unexpected Error messages to the message table. The default value in FND_MSG_PUB.Check_Msg_Level() for FND: Message Level Threshold is 40 or Success in the absence of a set profile option value.