delete a stock locator is not working

[sudharshan]

hi,

i am trying to delete a stock locator using an api and it is not working.i will post the code here.

CREATE OR REPLACE PROCEDURE APPS.delete_locator (
p_organization_id IN NUMBER,
p_err_code OUT NUMBER,
p_err_msg OUT VARCHAR2
)
IS
l_return_status VARCHAR2 (1);
l_msg_count NUMBER;
l_msg_data VARCHAR2 (2000);
l_organization_id NUMBER;
l_organization_code VARCHAR2 (3);
l_validation_req_flag VARCHAR2 (1);
l_message VARCHAR2 (32000) := NULL;

CURSOR c1
IS
SELECT organization_id, organization_code
FROM mtl_parameters
WHERE organization_id = p_organization_id;

CURSOR c2
IS
SELECT inventory_location_id, concatenated_segments
FROM mtl_item_locations_kfv
WHERE organization_id = p_organization_id;
BEGIN

--dbms_output.put_line('first');
FOR my_org_id IN c1
LOOP
FOR my_loc_id IN c2
LOOP
inv_loc_wms_pub.delete_locator
(x_return_status => l_return_status,
x_msg_count => l_msg_count,
x_msg_data => l_msg_data,
p_inventory_location_id => my_loc_id.inventory_location_id,
p_concatenated_segments => my_loc_id.concatenated_segments,
p_organization_id => my_org_id.organization_id,
p_organization_code => my_org_id.organization_code,
p_validation_req_flag => 'N'
);
END LOOP;
END LOOP;





IF l_return_status = fnd_api.g_ret_sts_success
THEN
p_err_code := 0;
p_err_msg := 'Success';
RETURN;
ELSE

FOR i IN 1 .. l_msg_count
LOOP
l_message := l_message||fnd_msg_pub.get (i, 'F');
END LOOP;

p_err_code := -99999;
p_err_msg := SUBSTR (l_message, 1, 4000);
RETURN;
END IF;



END delete_locator;
/


i am not getting any error message but the same time it is not getting deleted. can someone help me through this.



regards

sudharshan

[ahmadbilal]

Try This and Let Us Know In case of any issue


http://oracleebusinesssuite.wordpress.c ... using-api/

[sudharshan]

hi

i got the solution when you have locator active you cannot delete it.


regards

Sudharshan

[admin]

Thanks for sharing your experience with us.