Get the Cost of an Item (API)
API to Get the Cost of an Item
Group Team
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
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;
EXCEPTION
WHEN
OTHERS
THEN
dbms_output.put_line('Error in calling api and the error is ' ||
substr(SQLERRM,
1,
200));
END;
I was searching for this .....thanks to post this nice article
ReplyDeleteGetFundProfile