TCA API to create customer with error
I need help, I have created the script to use the hz_cust_accout_v2pub.create_cust_account to create customer, and I am facing the error
'Column party number must have a value' after executing the script. Please advise me. Thanks.
this is the script I created to test,
set serveroutput on size 1000000
declare
l_user_id number :=0;
l_resp_id number :=0;
l_application_id number :=0;
l_err_msg varchar2(500) :=null;
l_log varchar2(2000) :=null;
l_output_rec varchar2(2000) :=null;
l_process varchar2(100) :=null;
l_statement varchar2(100) :=null;
l_error_flag boolean;
l_total_rec number:=0;