hr_personal_pay_method_api.create_personal_pay_method errors out
pp_comment_id NUMBER;
pp_external_account_id NUMBER;
pp_effective_start_date DATE;
pp_effective_end_date DATE;
pp_object_version_number NUMBER;
pp_assignment_id number;
pp_personal_payment_method_id number;
V_ERROR VARCHAR2(1000);
l_status_flag varchar2(500) := 'Y';
l_status_msg varchar2(500) := 'Success';
l_total_rec NUMBER := 0;
l_success_rec NUMBER := 0;
l_failure_rec NUMBER := 0;
begin
hr_personal_pay_method_api.create_personal_pay_method
(
p_validate => true
,p_effective_date => trunc(sysdate)
,p_assignment_id => 1898
,p_org_payment_method_id => 61
,p_percentage => 100
,p_priority => 1
,p_territory_code