error in hz_location_v2pub.create_location while creating locaton
I am getting the followin\g error while creating the loation.
return status = U
msg_count = 1
msg_data = ORA-06502: PL/SQL: numeric or value error: character string buffer too small.
any help in regards
code i am using to create loacation.
DECLARE
loc_rec hz_location_v2pub.location_rec_type;
x_return_status VARCHAR2(32767);
x_msg_count NUMBER;
x_msg_data VARCHAR2(32767);
x_location_id number;
err_msg varchar2(32767);
p_count number;
begin
loc_rec.country := 'Saudi Arabia';
loc_rec.address1 := 'Street 10';
loc_Rec.city := 'Jeddah';
loc_rec.created_by_module := 'TCA_V1_API';
hz_location_v2pub.create_location(p_init_msg_list => 'T',