Month: May 2014

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

On By windows7bugsIn Oracle Applications (R12.0.4), Oracle Applications(R12), Oracle related1 Comment

 

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

fnd_message.set_string

fnd_message.show

image

image

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)

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

image

image

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

image

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.

regards,

rajesh

File Manager, File Picker for Windows Phone 8.1

On By windows7bugsIn Windows PhoneLeave a comment

 

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
  5. downloads
  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”

joeredditama

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.

wp_ss_20140511_0001

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

wp_ss_20140511_0002

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”

wp_ss_20140511_0003

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

wp_ss_20140511_0004

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

wp_ss_20140511_0005

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

wp_ss_20140511_0006

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

wp_ss_20140511_0007

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)

wp_ss_20140511_0008

 

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

Have a look at the features

wp_ss_20140511_0010

wp_ss_20140511_0011

wp_ss_20140511_0012

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

rajesh