OraFAQ Forum: Forms » Reminder message on form 6i

Home » Developer & Programmer » Forms » Reminder message on form 6i

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Reminder message on form 6i [message #632127]

Mon, 26 January 2015 00:36

Adeel Qadir
Messages: 48
Registered: November 2013
Location: Pakistan

Member

hey!

as per my accounting software,

i want to add reminder option on purchase order form before 5 days from due date.
before 5 days on due date reminder message automatically appear????

can any one give any idea ??????

Report message to a moderator

Re: Reminder message on form 6i [message #632128 is a reply to message #632127]

Mon, 26 January 2015 00:49

Littlefoot
Messages: 21808
Registered: June 2005
Location: Croatia, Europe

Senior Member
Account Moderator

WHEN-NEW-FORM-INSTANCE trigger

if sysdate < "5 days from due date" then
   message(...);
end if;

Report message to a moderator

Re: Reminder message on form 6i [message #632129 is a reply to message #632128]

Mon, 26 January 2015 01:04

Adeel Qadir
Messages: 48
Registered: November 2013
Location: Pakistan

Member

due date in purchase order form and i want to show message on main form
how can i manage it???
and
how can i get 5 days from due date ????

Report message to a moderator

Re: Reminder message on form 6i [message #632130 is a reply to message #632129]

Mon, 26 January 2015 01:34

Littlefoot
Messages: 21808
Registered: June 2005
Location: Croatia, Europe

Senior Member
Account Moderator

Isn't the due date stored somewhere in a table? Is it hard-coded in the purchase order form? If that's so, you'll have to pass it somehow (via a parameter or a global value).

How to calculate 5 days from due date? Are you joking? You managed to write accounting software, but can't calculate 5 days from due date?

Report message to a moderator

Re: Reminder message on form 6i [message #632131 is a reply to message #632130]

Mon, 26 January 2015 01:37

Adeel Qadir
Messages: 48
Registered: November 2013
Location: Pakistan

Member

ok ok i understand
thanks for reply

Report message to a moderator

Re: Reminder message on form 6i [message #632149 is a reply to message #632131]

Mon, 26 January 2015 08:46

CraigB
Messages: 386
Registered: August 2014
Location: Utah, USA

Senior Member

That depends on how and when you want the reminder message to be sent. Any code you add to the form will only trigger the reminder message when the Form runs. What if the 5th day is on a weekend? Do you still need the reminder message sent? Do you only want the while the user is logged into your Forms application or would you prefer an email sent?

Craig...

Report message to a moderator

Previous Topic:	Different language change in oracle form at run time
Next Topic:	JRE configure in 10g form

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Thu Apr 25 04:46:56 CDT 2024