Query to check Detailed Message of Error code Given by API

Query to check Detailed Message  of Error code Given by API

SELECT message_text

FROM fnd_new_messages

  WHERE message_name = 'AP_DISTS_NO_OPEN_FUT_PERIOD'

    AND language_code = 'US';