3/16/2021 Oracle Applications: Oracle API For Item Process
More satya012
Home AP AR GL INV PO OM HR PA FAQS SCRIPTS PL-SQL TECH OAF FUSION
FRIDAY, NOVEMBER 16, 2012
Oracle API For Item Process
SET SERVEROUTPUT ON
CREATE OR REPLACE PROCEDURE ProcessItems
AS
l_api_version NUMBER := 1.0;
l_init_msg_list VARCHAR2(2) := FND_API.G_TRUE;
l_commit VARCHAR2(2) := FND_API.G_FALSE;
l_item_tbl EGO_ITEM_PUB.ITEM_TBL_TYPE;
l_role_grant_tbl EGO_ITEM_PUB.ROLE_GRANT_TBL_TYPE := EGO_ITEM_PUB.G_MISS_ROLE_GRANT_TBL;
x_item_tbl EGO_ITEM_PUB.ITEM_TBL_TYPE;
x_message_list Error_Handler.Error_Tbl_Type;
x_return_status VARCHAR2(2);
x_msg_count NUMBER := 0;
l_user_id NUMBER := -1;
l_resp_id NUMBER := -1;
l_application_id NUMBER := -1;
l_rowcnt NUMBER := 1;
l_user_name VARCHAR2(30) := 'MGRPLM';
l_resp_name VARCHAR2(30) := 'EGO_DEVELOPMENT_MANAGER';
CURSOR csr_org_items IS
SELECT organization_code, item_name, item_catalog_group_id
FROM my_org_items;
BEGIN
-- Get the user_id
SELECT user_id
INTO l_user_id
FROM fnd_user
WHERE user_name = l_user_name;
-- Get the application_id and responsibility_id
SELECT application_id, responsibility_id
INTO l_application_id, l_resp_id
FROM fnd_responsibility
WHERE responsibility_key = l_resp_name;
FND_GLOBAL.APPS_INITIALIZE(l_user_id, l_resp_id, l_application_id); -- MGRPLM / Development Manager / EGO
dbms_output.put_line('Initialized applications context: '|| l_user_id || ' '|| l_resp_id ||' '|| l_application_id
);
-- Load l_item_tbl with the data
FOR itm IN csr_org_items LOOP
l_item_tbl(l_rowcnt).Transaction_Type := 'CREATE';
l_item_tbl(l_rowcnt).Segment1 := itm.item_name;
l_item_tbl(l_rowcnt).Description := 'SU API TEST';
l_item_tbl(l_rowcnt).Organization_Code := itm.organization_code;
l_item_tbl(l_rowcnt).Template_Name := 'Finished Good';
l_item_tbl(l_rowcnt).Inventory_Item_Status_Code := 'Active';
l_item_tbl(l_rowcnt).Item_Catalog_Group_Id := itm.item_catalog_group_id;
l_rowcnt := l_rowcnt + 1;
END LOOP;
-- call API to load Items
DBMS_OUTPUT.PUT_LINE('=====================================');
DBMS_OUTPUT.PUT_LINE('Calling EGO_ITEM_PUB.Process_Items API');
EGO_ITEM_PUB.PROCESS_ITEMS(
p_api_version => l_api_version
,p_init_msg_list => l_init_msg_list
,p_commit => l_commit
,p_item_tbl => l_item_tbl
,p_role_grant_tbl => l_role_grant_tbl
oracleapps88.blogspot.com/2012/11/oracle-api-for-item-process.html 1/3
3/16/2021 Oracle Applications: Oracle API For Item Process
,x_item_tbl => x_item_tbl
,x_return_status => x_return_status
,x_msg_count => x_msg_count);
DBMS_OUTPUT.PUT_LINE('=====================================');
DBMS_OUTPUT.PUT_LINE('Return Status: '||x_return_status);
IF (x_return_status = FND_API.G_RET_STS_SUCCESS) THEN
FOR i IN 1..x_item_tbl.COUNT LOOP
DBMS_OUTPUT.PUT_LINE('Inventory Item Id :'||to_char(x_item_tbl(i).inventory_item_id));
DBMS_OUTPUT.PUT_LINE('Organization Id :'||to_char(x_item_tbl(i).organization_id));
END LOOP;
ELSE
DBMS_OUTPUT.PUT_LINE('Error Messages :');
Error_Handler.GET_MESSAGE_LIST(x_message_list=>x_message_list);
FOR i IN 1..x_message_list.COUNT LOOP
DBMS_OUTPUT.PUT_LINE(x_message_list(i).message_text);
END LOOP;
END IF;
DBMS_OUTPUT.PUT_LINE('=====================================');
EXCEPTION
WHEN OTHERS THEN
DBMS_OUTPUT.PUT_LINE('Exception Occured :');
DBMS_OUTPUT.PUT_LINE(SQLCODE ||':'||SQLERRM);
DBMS_OUTPUT.PUT_LINE('=====================================');
END;
/
Best Blogger Gadgets
Posted by Raju Chinthapatla at 7:41:00 PM
Labels: API, CONVERSIONS, ITEMS
2 comments:
Anonymous said...
You should enable copying of content. Thanks anyway.
September 8, 2014 at 10:38 PM
Anonymous said...
Good Article
use
V_user_id NUMBER := Fnd_global.User_id;
V_resp_id NUMBER := Fnd_global.Resp_id;
V_resp_appl_id NUMBER := Fnd_global.Resp_appl_id; instead of select queries
August 12, 2019 at 5:18 PM
Post a Comment
Enter your comment...
Comment as: satish (Google Sign out
Publish Preview Notify me
Newer Post Home Older Post
Subscribe to: Post Comments (Atom)
oracleapps88.blogspot.com/2012/11/oracle-api-for-item-process.html 2/3
3/16/2021 Oracle Applications: Oracle API For Item Process
Email : OracleApps88@Yahoo.Com. Picture Window theme. Theme images by konradlew. Powered by Blogger.
Get Flower Effect
oracleapps88.blogspot.com/2012/11/oracle-api-for-item-process.html 3/3
