Getting null for custom profile in fnd_profile.value('XXcustomsecurity')

We are in 12.1.3
I have created new custom profile 'XXcustomsecurity'.
However, i could not get the profile value using fnd_profile.value and getting null value in our custom package


Also tried with assigning this profile value in select clause and not getting the profile value (returns null).

Ex:

select * from XX_mcd where org_id=fnd_profile.value('XXcustomsecurity');

Here fnd_profile.value('XXcustomsecurity') returns null.



Regards

Vinod