l_contact_point_rec HZ_CONTACT_POINT_V2PUB.contact_point_rec_type;
l_email_rec HZ_CONTACT_POINT_V2PUB.email_rec_type;
l_contact_point_id NUMBER;
x_return_status VARCHAR2(2000);
x_msg_count NUMBER;
x_msg_data VARCHAR2(2000);
begin
l_contact_point_rec.owner_table_id := 226285;
l_contact_point_rec.contact_point_type :=’EMAIL’;
l_contact_point_rec.owner_table_name := ‘HZ_PARTIES’;
l_contact_point_rec.created_by_module :=’POS_SUPPLIER_MGMT’;
l_email_rec.email_address := ‘[email protected]‘ ;
HZ_CONTACT_POINT_V2PUB.create_email_contact_point
(
p_contact_point_rec => l_contact_point_rec,
p_email_rec => l_email_rec,
x_contact_point_id => l_contact_point_id,
x_return_status => x_return_status,
x_msg_count => x_msg_count,
x_msg_data => x_msg_data
);
if (x_return_status <> ‘S’) then
dbms_output.put_line(‘Encountered ERROR in supplier contact !!!’);
dbms_output.put_line(‘————————————–‘);
dbms_output.put_line(x_msg_data);
IF x_msg_count > 1 THEN
FOR i IN 1..x_msg_count LOOP
dbms_output.put_line(substr(FND_MSG_PUB.Get( p_encoded => FND_API.G_FALSE ),1,255));
END LOOP;
END IF;
ELSE
dbms_output.put_line(‘Supplier Contact updated !!!!!!’||l_contact_point_id);
end if;
end;
Recent Comments