Oracle Applications | Making references to fnd_message package from custom PL/SQL library


Until recent times I didn’t have a single idea that, fnd_message package was NOT a database, instead PL/SQL library object, through which forms based modules were calling various elements like




One of the main reasons for believing the same was as soon as I type the name of the package, both Toad  and SQL Developer identify it as already existing object!

However, few days back I decided to shed my laziness and to revamp the core retailing application I have developed two years back, using Oracle’s public APIs for Order Management & Inventory modules.

Hence, I started designing my own PL/SQL libraries and bit the bullet while trying to make a reference to fnd_message package. The call was returning errors (please refer the below image)


Which forced me to start googling for relevant and dependable pointers towards this particular situation and came across a forum thread where one person who I respect as a “geek” tried to explain why there is a package in the database and within an PL/SQL library with the same “fnd_message”, and gradually giving it up saying “Only oracle could explain why”

Hence I opened up the Template form and try to see which attached PL/SQL library has the listing for fnd_message component calls



and the PL/SQL library “FNDSQL” attached to the TEMPLATE.fmb by default has all the components referenced with the forms modules. Once identified, I attached the same library with my custom library


and the next compilation attempt was successful!

I do hope, this information is useful to few others out there, who are trying to call the fnd_message package references with their own custom PL/SQL libraries.



File Manager, File Picker for Windows Phone 8.1


Update: If you create your own folders in your phone using Windows Explorer, the same may not be listed under “Phone folders” service provider. We guess the API what provided by Microsoft restricts the access to a pre-defined list of folders as listed below

  1. Pictures
  2. Music
  3. Videos
  4. documents
  6. ringtones

Anything other than the listed above, ie, folders created by the phone user will not be listed or available to attach with “Pocket File Manager” app!


I recall the furious arguments and personal level attacks over Microsoft tech forums about missing file manager over Windows Phone platform until recent days & joe belfiore during reddit AMA got all excited when one of the participants shot a question about “File manager”


We “heard” about it earlier, through some leaks, didn’t ? Anyway, the official app for the file explorer should be available by the end of May 2014, and the speculations are that, the file explorer will be bundled along with “OneDrive” application. let us wait and see how the implementation is going to happen.

Meanwhile let us assess couple of third party applications what are already available for managing your files (Music/Video/Documents/Downloads) in your phone!

During next few days we will be analyzing

  1. Pocket File Manager(Paid, you can try)
  2. Pocket Explorer(Paid, you can try)

apps which are already available in the Windows Phone store. We already bought Pocket File Manager (PFM as widely called by techies) and had few hands on exercises and very much pleased with the end results.


We opted to keep the “Warning” (Should it be called as “Quick help”?) appearing each time while the app is restarted


When the app is initially used, the “Root” has it’s own file system called “Local storage” with few sample folders and files. We will not be digging much into it as our primary aim is to see “what else we could do with the file manager”. The below image shows the couple of “Phone folders” we have added to the app by following instructions. Touch the + button and, you will be provided two options

“add image”(Capitalization standards)? Winking smile

“Add Provider”


Now you can select a provider from total seven (7) available right now as on while this document is prepared (this list could grow with later versions)

For our exercise we will select “Phone folder” and proceed


Once the “Phone Folder” selected, you will be provided a windows listing available Phone folders what you can attach with this little wonderful app!


Now touch the folder name you want to attach with the app and touch the done (tick) button!


The app may say the folder is empty, just ignore and complete the activity


Touch the folder name you just attached with the app and wait few seconds…and the file listing starts building up! You can use the refresh button if you think the listing was not done completely (which is almost a never happening case)



The beauty with such a listing is, you can almost do all file manipulations against the chosen file!

Have a look at the features




So, if you were eager for a file manager, you may don’t have to wait until May 2014, you can start exploring the possibilities of these applications which will not burn holes in your pockets and start managing your files as you wished until recent days.


We hope you enjoyed another quality post from windows7bugs

for windows7bugs