#1
  1. No Profile Picture
    Junior Member
    Devshed Newbie (0 - 499 posts)

    Join Date
    Dec 2003
    Location
    Peoria, Il
    Posts
    1
    Rep Power
    0

    Custom.pll, zooms, fnd_function.execute, Auto query after form navigation


    I have invoked a zoom in the custom library using fnd_function.execute, however I can not get it to auto query the form after navigation to the form. I am passing the customer number to the block field RCU_CUSTOMER_NUMBER, which is the required info for the query.

    The following is my code from the event procedure of custom.pll.

    if (event_name = 'ZOOM') then
    if (form_name = 'ARXCWMAI' and block_name = 'CQIT_PS') then
    param_to_pass1 := name_in('CQIT_PS.RAC_CUSTOMER_NUMBER';

    fnd_function.execute(FUNCTION_NAME=>'AR_ARXCWMAI_ECC',
    OPEN_FLAG=>'Y',
    SESSION_FLAG=>'N',
    OTHER_PARAMS=>'RCU_CUSTOMER_NUMBER"'||param_to_pass1||'"');
    end if;
    else
    null;
    end if;

    Please Help!
  2. #2
  3. No Profile Picture
    Registered User
    Devshed Newbie (0 - 499 posts)

    Join Date
    Jun 2014
    Posts
    1
    Rep Power
    0
    Originally Posted by Newportm
    I have invoked a zoom in the custom library using fnd_function.execute, however I can not get it to auto query the form after navigation to the form. I am passing the customer number to the block field RCU_CUSTOMER_NUMBER, which is the required info for the query.

    The following is my code from the event procedure of custom.pll.

    if (event_name = 'ZOOM') then
    if (form_name = 'ARXCWMAI' and block_name = 'CQIT_PS') then
    param_to_pass1 := name_in('CQIT_PS.RAC_CUSTOMER_NUMBER';

    fnd_function.execute(FUNCTION_NAME=>'AR_ARXCWMAI_ECC',
    OPEN_FLAG=>'Y',
    SESSION_FLAG=>'N',
    OTHER_PARAMS=>'RCU_CUSTOMER_NUMBER"'||param_to_pass1||'"');
    end if;
    else
    null;
    end if;

    Please Help!

    I believe you are missing your equal sign:

    OTHER_PARAMS=>'RCU_CUSTOMER_NUMBER="'||param_to_pass1||'"');

    Sorry if this post is no longer relevant.
  4. #3
  5. Contributing User
    Devshed Novice (500 - 999 posts)

    Join Date
    Sep 2006
    Posts
    859
    Rep Power
    388

    Cool


    . . . and closing parenthesis:
    Code:
    . . .
    param_to_pass1 := name_in('CQIT_PS.RAC_CUSTOMER_NUMBER' ) ;  -- <= here

IMN logo majestic logo threadwatch logo seochat tools logo