Home » Developer & Programmer » Forms » Messaging problem
Messaging problem [message #286712] Sun, 09 December 2007 23:53 Go to next message
AnamikaChaudhary
Messages: 33
Registered: December 2007
Location: Mumbai
Member
Hi,

I have an account module & i have to select one option:

When selecting brought into that page (correct), however with a popup: "please acknowledge" and when pressing ok, is exited from the screen again.& come back where i have selected that option.

Re: Messaging problem [message #286744 is a reply to message #286712] Mon, 10 December 2007 01:14 Go to previous messageGo to next message
Maaher
Messages: 7062
Registered: December 2001
Senior Member
What does the status bar say when you have the 'pleas acknowledge' message box?

MHE
Re: Messaging problem [message #286759 is a reply to message #286712] Mon, 10 December 2007 01:37 Go to previous messageGo to next message
azamkhan
Messages: 548
Registered: August 2005
Senior Member
Is the message "Please acknowledge" is your custome message. I think that it is your custome alert message.

Check your code. I think when you open the linked form a trigger or code is fired that has this message "Please Acknowledge" and just after it there is Exit form command.

Regards,
Azam Khan
Re: Messaging problem [message #286760 is a reply to message #286744] Mon, 10 December 2007 01:37 Go to previous messageGo to next message
AnamikaChaudhary
Messages: 33
Registered: December 2007
Location: Mumbai
Member
Hi,
status bar is showing "invoice is alreadt selected for payment....run clear selection for the payment "


This message is comming from Trigger WHEN_NEW_FORM_TNSTANCE:
This is the code written

startup;

DECLARE
   check_count1   NUMBER(6);
   check_count2   NUMBER(6);
   check_count3   NUMBER(6);
BEGIN
   :b1.pf3      := :GLOBAL.pf3;
   :b1.pf4      := :GLOBAL.pf4;
   :b1.co       := :GLOBAL.company;
   :b1.NAME     := :GLOBAL.company_name;
   :b1.today    := SYSDATE;

--
   SELECT bksubsrc
   INTO   :b1.bksubsrc
   FROM   apctl
   WHERE  co = :b1.co;

--
   SELECT COUNT(*)
   INTO   check_count1
   FROM   apdetail
   WHERE  SOURCE LIKE '7%'
   AND    printedcheck = 'P'
   AND    checknumber IS NOT NULL
   AND    co = :b1.co
   AND    deferral = 'P';

---
   SELECT COUNT(*)
   INTO   check_count2
   FROM   apdetail
   WHERE  SOURCE LIKE '7%'
   AND    co = :b1.co
   AND    deferral = 'P';

--
-- disabled 11/2004 -es
-- too many users in manual payment holding up check print processing
--
-- select count(*)
-- into check_count3
-- from aptrxhdr
-- where source like '3%'
-- and posted = 'N'
-- and co = :b1.co;
--
   IF NVL(check_count1, 0) > 0
   THEN
      MESSAGE(   'Unposted computer checks exist... '
              || 'Run Check Register Update first.'
             );
      PAUSE;
      NEW_FORM('ap000');
   ELSIF NVL(check_count2, 0) > 0
   THEN
      MESSAGE(   'Invoices already selected for payment... '
              || 'Run Clear Selection for Payment.'
             );
      PAUSE;
      NEW_FORM('ap000');
   ELSIF NVL(check_count3, 0) > 0
   THEN
      MESSAGE('Unposted manual checks exist... Run Voucher Posting.');
      PAUSE;
      NEW_FORM('ap000');
   END IF;
EXCEPTION
   WHEN NO_DATA_FOUND
   THEN
      NULL;
END;




when i run the count querry for count2 i get the result ZERO
select count(*)
into check_count1
from apdetail
where source like '7%'
and printedcheck = 'P'
and checknumber is not null

and deferral = 'P';

[mhe-edit]Added code tags.

[Updated on: Mon, 10 December 2007 05:26] by Moderator

Report message to a moderator

Re: Messaging problem [message #286798 is a reply to message #286759] Mon, 10 December 2007 02:44 Go to previous messageGo to next message
AnamikaChaudhary
Messages: 33
Registered: December 2007
Location: Mumbai
Member
Hi

No this message is not mine custom message.Their is no such message in my program
Re: Messaging problem [message #286869 is a reply to message #286798] Mon, 10 December 2007 05:25 Go to previous messageGo to next message
Maaher
Messages: 7062
Registered: December 2001
Senior Member
AnamikaChaudhary wrote on Mon, 10 December 2007 09:44

Their is no such message in my program

And you are sure of that? I can clearly see the message in the code you posted. And you need to check this query:
   SELECT COUNT(*)
   INTO   check_count2
   FROM   apdetail
   WHERE  SOURCE LIKE '7%'
   AND    co = :b1.co
   AND    deferral = 'P';


MHE

[edit]the line after the PAUSE (that invokes the "acknowledge" message is a NEW_FORM. Look NEW_FORM up in your Forms help. Nothing strange if you ask me.

[Updated on: Mon, 10 December 2007 05:28]

Report message to a moderator

Re: Messaging problem [message #286877 is a reply to message #286798] Mon, 10 December 2007 05:52 Go to previous message
azamkhan
Messages: 548
Registered: August 2005
Senior Member
Dear the message is due to the PAUSE command which you have placed in your code...
Actually you following condition got true

ELSIF NVL(check_count2, 0) > 0
THEN
MESSAGE( 'Invoices already selected for payment... '
|| 'Run Clear Selection for Payment.'
);
PAUSE;
NEW_FORM('ap000');

And thus system execute the command PAUSE and it causes that acknowledge message.

You have to check the query against this condition.

Regards,
Azam Khan
Previous Topic: Not allow duplicate values for an item
Next Topic: oracle connection
Goto Forum:
  


Current Time: Wed Dec 07 10:29:30 CST 2016

Total time taken to generate the page: 0.24099 seconds