Hi Gurus,
I am developing a form(6i) in which i have a requirement in such a way that
i am calling a stored procedure in my form ,procedure will return a pl/sql collection output and collection data populated in my block(Non DB block). some times procedure will consume time for fetching data.
I have a requirement to show a progress popup, before calling the procedure and once procedure return the data , i need to close the popup automatically. message in the popup need to change based on the input passed to the procedure.
For that i created a new dialog window, dialog canvas, block with one text item whose width and height is 0 , i change the prompt of the text item dynamically to show the message. now the problem is if have a message buildin before the go_item of the progress window, window is appearing , else it won't.
Message('Please note Package Explosion Process will take sometime');(if i remove this message buildin, it is not showing below window)
Set_Item_Property('BLK_PROGRESS.TEXT_BOILER_PLATE',Prompt_Text,'Please Wait a few second, Package Explosion Request for Pallet/ Carton ' ||:Blk_View_Rma_Serial.Text_Package_Num || ' is on progress now........');
Go_Item('BLK_PROGRESS.TEXT_BOILER_PLATE');
Go_Block('BLK_PROGRESS');
Show_View('CANVAS_PROGRESS');
fnd_message.Set_string('Package Explosion Completed');
Fnd_message.hint;
i change all possible sequence of go_item, go_block, show view as well.,But same result. if i add fnd_message buildin instead of message also it leads to same result, not showing the message window.
please help me to resolve this problem.
thanks