API to Get the Cost of an Item

API to Get the Cost of an Item

 

Below code can be used to get the cost of an Item.

The function returns the item cost for a given item and the organization.

All the parameter used in the Api are IN Parameter. Cost_group_id and Cost_type_id have the default value as NULL.

We can pass cost_group_id or cost_type_id, if you desire most specific cost Information. Do not pass both the cost group and Cost type at the same time.

API can fail for the below scenario

• Invalid item/organization combination.
• Item is not cost enabled.
• Item has no cost in the specified cost group or cost type.

 

DECLARE

v_inventory_item_id NUMBER := 832215;
v_organization_id NUMBER := 209;
v_api_version NUMBER := 1.1;
v_cost_type_id NUMBER;
v_item_cost NUMBER := 0;
v_cost_group_id NUMBER;
BEGIN


dbms_output.put_line('API CST_COST_API to get the Item Cost);
v_item_cost := CST_COST_API.get_item_cost
(p_api_version => v_api_version,
p_inventory_item_id => v_inventory_item_id,
p_organization_id => v_organization_id,
p_cost_group_id => v_cost_group_id,
p_cost_type_id => v_cost_type_id
);

IF v_item_cost is NULL THEN

dbms_output.put_line('Issue in getting the Item Cost and Issue can be any one specified in the error scenario of the post');

ELSE

dbms_output.put_line('Item Cost is ' || v_item_cost);

END IF;

EXCEPTION

WHEN
OTHERS
THEN

dbms_output.put_line('Error in calling api and the error is ' ||
substr(SQLERRM,
1,
200));
END;