All ,

We are encountring an error , while uploading salary components , the lookup values exist in HR_LOOKUP table.

Here is the wrapper code which is throughing error , Help please


DECLARE
v_pay_proposal_id NUMBER;
v_object_version_number NUMBER;
v_component_id_1 NUMBER;
v_ppc_object_version_number_1 NUMBER;
v_component_id_2 NUMBER;
v_ppc_object_version_number_2 NUMBER;
v_component_id_3 NUMBER;
v_ppc_object_version_number_3 NUMBER;
v_component_id_4 NUMBER;
v_ppc_object_version_number_4 NUMBER;
v_component_id_5 NUMBER;
v_ppc_object_version_number_5 NUMBER;
v_component_id_6 NUMBER;
v_ppc_object_version_number_6 NUMBER;
v_component_id_7 NUMBER;
v_ppc_object_version_number_7 NUMBER;
v_component_id_8 NUMBER;
v_ppc_object_version_number_8 NUMBER;
v_component_id_9 NUMBER;
v_ppc_object_version_number_9 NUMBER;
v_component_id_10 NUMBER;
v_ppc_object_version_number_10 NUMBER;
v_pyp_proposed_sal_warning BOOLEAN;
v_additional_comp_warning BOOLEAN;
err_code NUMBER;
err_buff VARCHAR2(1000);
BEGIN

hr_utility.trace_on ();
hr_utility.set_trace_options ('TRACE_DEST:DBMS_OUTPUT');
hr_upload_proposal_api.upload_salary_proposal
(p_validate => FALSE,
p_change_date => '25-OCT-11',
p_business_group_id => 92,
p_assignment_id => 32657,
p_proposed_salary => 5000,
p_proposal_reason => NULL,
p_pay_proposal_id => v_pay_proposal_id,
p_object_version_number => v_object_version_number,
p_component_reason_1 => 'Performance',
p_change_amount_1 => 4000,
p_change_percentage_1 => NULL,
p_approved_1 => 'Y',
p_component_id_1 => v_component_id_1,
p_ppc_object_version_number_1 => v_ppc_object_version_number_1,
p_component_reason_2 => 'Performance',
p_change_amount_2 => 1000,
p_change_percentage_2 => NULL,
p_approved_2 => 'Y',
p_component_id_2 => v_component_id_2,
p_ppc_object_version_number_2 => v_ppc_object_version_number_2,
p_component_reason_3 => NULL,
p_change_amount_3 => NULL,
p_change_percentage_3 => NULL,
p_approved_3 => NULL,
p_component_id_3 => v_component_id_3,
p_ppc_object_version_number_3 => v_ppc_object_version_number_3,
p_component_reason_4 => NULL,
p_change_amount_4 => NULL,
p_change_percentage_4 => NULL,
p_approved_4 => NULL,
p_component_id_4 => v_component_id_4,
p_ppc_object_version_number_4 => v_ppc_object_version_number_4,
p_component_reason_5 => NULL,
p_change_amount_5 => NULL,
p_change_percentage_5 => NULL,
p_approved_5 => NULL,
p_component_id_5 => v_component_id_5,
p_ppc_object_version_number_5 => v_ppc_object_version_number_5,
p_component_reason_6 => NULL,
p_change_amount_6 => NULL,
p_change_percentage_6 => NULL,
p_approved_6 => NULL,
p_component_id_6 => v_component_id_6,
p_ppc_object_version_number_6 => v_ppc_object_version_number_6,
p_component_reason_7 => NULL,
p_change_amount_7 => NULL,
p_change_percentage_7 => NULL,
p_approved_7 => NULL,
p_component_id_7 => v_component_id_7,
p_ppc_object_version_number_7 => v_ppc_object_version_number_7,
p_component_reason_8 => NULL,
p_change_amount_8 => NULL,
p_change_percentage_8 => NULL,
p_approved_8 => NULL,
p_component_id_8 => v_component_id_8,
p_ppc_object_version_number_8 => v_ppc_object_version_number_8,
p_component_reason_9 => NULL,
p_change_amount_9 => NULL,
p_change_percentage_9 => NULL,
p_approved_9 => NULL,
p_component_id_9 => v_component_id_9,
p_ppc_object_version_number_9 => v_ppc_object_version_number_9,
p_component_reason_10 => NULL,
p_change_amount_10 => NULL,
p_change_percentage_10 => NULL,
p_approved_10 => NULL,
p_component_id_10 => v_component_id_10,
p_ppc_object_version_number_10 => v_ppc_object_version_number_10,
p_pyp_proposed_sal_warning => v_pyp_proposed_sal_warning,
p_additional_comp_warning => v_additional_comp_warning
);
hr_utility.trace_off;
DBMS_OUTPUT.put_line ('created salary' || ' ' || v_pay_proposal_id);
EXCEPTION
WHEN OTHERS
THEN
err_code := SQLCODE;
err_buff := SQLERRM;
DBMS_OUTPUT.put_line (err_code || ' ' || err_buff);
END;
/

Thanks
VJ

Are those reasons lookup codes, or meanings? The API will expect the code.

Also, check your nls_language setting for your session

All , Issue is resolved , As expected , the original program is
taking meaning instead of reasons.

Thanks Much.

VJ--