I am trying to execute a procedure using DB trigger.
In procedure I am using API 'qp_price_list_pub.process_price_list' to insert item into price list.
when I excute this procedure on TOAD it gets excuted and inserts req rows to the price list as per my need,
but when I tried to call it from (By adding item on price list form on r12) DB trigger it wont able to get excuted.
In xx_new_item_in_dp it insert the 'INVENTORY_ITEM_ID' which I insert on appliction i.e. on 'Price List Form'(Navigation:Order Management:pricing:price lists:price list setups )
CREATE OR REPLACE TRIGGER apps.xx_add_new_item_pl
FOR EACH ROW
NEW.list_header_id = 6015
apps.xx_add_new_item_price_list(:NEW.PRODUCT_ATTR_VALUE); --This is procedure which have an API 'qp_price_list_pub.process_price_list'
INSERT INTO apps.xx_new_item_in_dp
exception when others then null;
please give some suggestions.
Thanks & Regards