4 Replies Latest reply on May 15, 2019 9:26 AM by Sanjay Desai EBS

    Pre-update trigger is not firing Custom.pll

    3553055

      Hi All,

       

      Our requirement is to compare the old and new value of item statues through custom.pll if it is not the same we need to call custom procedure, we have modified the custom.pll but the pre-update trigger is not firing. Please help us to resolve the issues.

       

      It displays up to Inside form message.

       

      IF (form_name = 'INVIDITM') and (block_name = 'MTL_SYSTEM_ITEMS') 

             THEN

             fnd_message.debug('Inside form');

      -- //Get the item name and status before update//

         If (event_name = 'PRE-UPDATE')

          THEN

      fnd_message.debug('Inside PRE-UPDATE');

       

      If ('MTL_SYSTEM_ITEMS.INVENTORY_ITEM_STATUS_CODE_MIR') IS NOT NULL THEN

       

      L_ITEM := name_in('MTL_SYSTEM_ITEMS.INVENTORY_ITEM_MIR');

       

      fnd_message.debug('Item is not null'+L_ITEM);

       

       

      select ORGANIZATION_ID,DESCRIPTION,INVENTORY_ITEM_STATUS_CODE into L_ORG_ID,L_DESCRIPTION,L_STATUS from MTL_SYSTEM_ITEMS where SEGMENT1=L_ITEM;

      fnd_message.debug('Pre update value');

      END IF;

      END IF;

      -- //calling the post update to check the data //

       

              IF (event_name = 'POST-UPDATE')

              THEN

              fnd_message.debug('Inside POST-UPDATE');

      Begin

                           apps.XXQPS_ITEM_ALERT ('L_ITEM','L_ORG_ID','L_DESCRIPTION','L_STATUS');

                              fnd_message.debug('XXQPS_ITEM_ALERT triggered');

      end ;

      end if;

      end if;

       

      Regards,

       

      Kalpana.