Sales Rep API in Oracle Application

First we need to create resource then create salesrep.

begin
JTF_RS_RESOURCE_PUB.create_resource
(p_api_version =>l_api_version,
p_init_msg_list =>l_init_msg_list,
p_commit =>l_commit,
p_category =>l_category,
p_source_id =>l_source_id,
p_address_id =>l_address_id,
p_contact_id =>l_contact_id,
p_managing_emp_id =>l_managing_emp_id,
p_managing_emp_num =>l_managing_emp_num,
p_start_date_active =>l_start_date_active,
p_end_date_active =>l_end_date_active,
p_time_zone =>l_time_zone,
p_cost_per_hr =>l_cost_per_hr,
p_primary_language =>l_primary_language,
p_secondary_language =>l_secondary_language,
p_support_site_id =>l_support_site_id,
p_ies_agent_login =>l_ies_agent_login,
p_server_group_id =>l_server_group_id,
p_interaction_center_namE =>l_interaction_center_name,
p_assigned_to_group_id =>l_assigned_to_group_id,
p_cost_center =>l_cost_center,
p_charge_to_cost_center =>l_charge_to_cost_center,
p_comp_currency_code =>l_comp_currency_code,
p_commissionable_flag =>l_commissionable_flag,
p_hold_reason_code =>l_hold_reason_code,
p_hold_payment =>l_hold_payment,
p_comp_service_team_id =>l_comp_service_team_id,
p_user_id =>l_user_id,
p_transaction_number =>l_transaction_number,
x_return_status =>l_return_status,
x_msg_count =>l_msg_count,
x_msg_data =>l_msg_data,
x_resource_id =>o_resource_id,
x_resource_number =>l_resource_number,
p_resource_name =>l_resource_name,
p_source_name =>l_source_name,
p_source_number =>l_source_number,
P_user_name =>l1_user_name
);
EXCEPTION
WHEN OTHERS THEN
l_msg_data:= SUBSTR (SQLERRM,1,80);
END;
IF l_return_status = 'S' then
l1_api_version :=1.0;
l1_resource_id :=o_resource_id;
l1_name :=l_xxemig_salesreps_tbl(j).sp_name;
l1_status := 'A';
l1_start_date_active := l_start_date_active;
1_end_date_active := l_end_date_active ;
SELECT JTF_RS_SALESREP_NUMBER_S.nextval
INTO l1_salesrep_number FROM dual;
BEGIN
JTF_RS_SALESREPS_PUB.create_salesrep
(p_api_version =>l1_api_version,
p_init_msg_list =>l1_init_msg_list,
p_commit =>l1_commit,
p_resource_id =>l1_resource_id,
p_sales_credit_type_id =>g_sales_credit_type_id,
p_name =>l1_name,
p_status =>l1_status,
p_start_date_active =>l1_start_date_active,
p_end_date_active =>l1_end_date_active,
p_gl_id_rev =>l1_gl_id_rev,
p_gl_id_freight =>l1_gl_id_freight,
p_gl_id_rec =>l1_gl_id_rec,
p_set_of_books_id =>g_set_of_books_id,
p_salesrep_number =>l1_salesrep_number,
p_email_address =>l1_email_address,
p_wh_update_date =>l1_wh_update_date,
p_sales_tax_geocode =>l1_sales_tax_geocode,
p_sales_tax_inside_city_limits =>v_sales_tax_inside_city_limits,
x_return_status =>l1_return_status,
x_msg_count =>l1_msg_count,
x_msg_data =>l1_msg_data,
x_salesrep_id =>l1_salesrep_id
);
EXCEPTION
WHEN OTHERS THEN
l_msg_data:= SUBSTR (SQLERRM,1,80);
END;
END;
END IF;