Error while creating Stock Locators EBS 12.2.9
SET SERVEROUTPUT ON SIZE 1000000
DECLARE
l_msg_data VARCHAR2 (100);
l_msg_count NUMBER;
l_return_status VARCHAR2 (1);
l_locator_id NUMBER;
l_locator_exists VARCHAR2 (1);
l_org_id NUMBER := NULL;
l_organization_code VARCHAR2 (10) := 'CZK'; --'CZK';
l_concatenated_segments VARCHAR2 (100) := NULL;
l_user_id NUMBER := NULL;
l_resp_id NUMBER := NULL;
l_resp_appl_id NUMBER := NULL;
l_cnt NUMBER := 0;
BEGIN
/*
* APPS_INITIALIZE needed because Project/Task Valuesets indirectly use
* profile options
*/
SELECT fur.user_id,
fur.responsibility_id,
fur.responsibility_application_id
INTO l_user_id, l_resp_id, l_resp_appl_id
FROM fnd_user_resp_groups_direct fur,