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!

Form personalization:Display message while passing parameter for concurrent program

Discussion in 'Oracle Apps Technical' started by Nidhi25, Feb 12, 2010.

  1. Nidhi25

    Nidhi25 Forum Genius

    Messages:
    81
    Likes Received:
    9
    Trophy Points:
    835
    we need to make a report taking two parameters from-date & to-date, & register it in apps.

    before submitting concurrent request, user will pass value for above 2 parameters. If value of to-date given by user is less than from-date, then a

    message shoud display warning user of invalid date entry.

    what could be the process steps for this personalization?

    Would appreciate a thoughtful reply on the same.

    Thanks.
     
  2. apps_expert

    apps_expert Forum Expert

    Messages:
    325
    Likes Received:
    28
    Trophy Points:
    330
    Location:
    Chennai, India
    Re: Form personalization:Display message while passing parameter for concurrent progr

    Are you talking about validating it in the report's parameter form?

    If yes, you need to open the property palette of the desired field, and click on the" validation trigger" property. An editor will appear, in which you can write the desired code to validate the user input. When your trigger determines that the user input is invalid, the validation trigger must return FALSE, and when the user input is valid, it must return TRUE.

    But I would advise you to make the validations in a Forms application rather than using the report's parameter form.
     
  3. Re: Form personalization:Display message while passing parameter for concurrent progr

    Hi Nidhi ,

    There can not be any personalization on concurrent programs.
    However you can apply following code on After Parameter Trigger in report.

    Kindly find the below code it will help you.

    Assuming report user parameter is as P_FROM_DATE & P_TO_DATE

    Code (Text):

    function AfterPForm return boolean is

    begin

      IF TO_DATE(:P_FROM_DATE ) > TO_DATE(:P_TO_DATE) THEN
            SRW.MESSAGE(1000,'From Date can not be greater than To Date');
            raise srw.program_abort;
      END IF;
     
           
      return (TRUE);
     
    end;
    This code will execute when concurrent program is submitted with wrong dates.
    Concurrent program will be completed with error and message will be displayed in log file.

    Let me know if further help is required.

    Regards,
    -Vishal