1. Get rid of all advertisements and get unlimited access to documents by upgrading to Premium Membership. Upgrade to Premium Now and also get a Premium Badge!

How to show the warning status if RDF concurrent program does not return any row.?

Discussion in 'Oracle Forms and Reports' started by sambuduk, Feb 13, 2014.

  1. sambuduk

    sambuduk Forum Advisor

    Messages:
    242
    Likes Received:
    73
    Trophy Points:
    455
    Location:
    Hyderabad , Telangana
    Hi ,

    How to show the warning status(Yellow colour) if RDF concurrent program does not return any row???

    I tried with " raise srw.program_abort; " but it is giving Error (Red color) status.


    Regards
    Sambasiva Reddy.K
     
  2. jagadekara

    jagadekara Forum Guru

    Messages:
    1,126
    Likes Received:
    145
    Trophy Points:
    1,805
    Location:
    Pulivendula
    Re: How to show the warning status if RDF concurrent program does not return any row.

    Hi Sambasiva Reddy.K,

    No need of raise srw.program_abort;

    just use the API fnd_concurrent.set_completion_status in after report trigger.
     
  3. sambuduk

    sambuduk Forum Advisor

    Messages:
    242
    Likes Received:
    73
    Trophy Points:
    455
    Location:
    Hyderabad , Telangana
    Re: How to show the warning status if RDF concurrent program does not return any row.

    Hi,

    Ya By using fnd_concurrent.set_completion_status() we can achive this. But is it right way???

    Regds
    Samba
     
  4. jagadekara

    jagadekara Forum Guru

    Messages:
    1,126
    Likes Received:
    145
    Trophy Points:
    1,805
    Location:
    Pulivendula
    Re: How to show the warning status if RDF concurrent program does not return any row.

    I think So....

    And one more thing....

    For this you should use P_CONC_REQUEST_ID and user exits.
    And you shouldn't use fnd_global.apps_initialize.
     
  5. jagadekara

    jagadekara Forum Guru

    Messages:
    1,126
    Likes Received:
    145
    Trophy Points:
    1,805
    Location:
    Pulivendula
    Re: How to show the warning status if RDF concurrent program does not return any row.

    You can see the clear document on this Here
     
    sambuduk likes this.
  6. starrk1982

    starrk1982 Active Member

    Messages:
    6
    Likes Received:
    2
    Trophy Points:
    85
    Location:
    Abu Dhabi
    Re: How to show the warning status if RDF concurrent program does not return any row.

    basically you want to tell the user that the report didn't fetch a single record. if that the case then why do you force raising warning which might mislead you in the future debugging.
    rather than using it, use COUNT function and associate it with a message of your choice for the user
    (e.g: if count(column1)=0 then display 0 record fetched).