Error while updating asset type using API : pa_project_assets_pub.update_project_asset
Hi Team,
Iam getting the below issue while performing asset update
Project: '' External Asset Reference or Project Asset ID is required.
Code
set serveroutput on;
declare
--
--select * from pa_projects_all where PROJECT_ID=8547;
--
--select * from pa_project_assets_all where PROJECT_ID=8547;
l_msg_count NUMBER;
l_msg_data VARCHAR2(255);
l_return_status VARCHAR2(1);
l_pa_project_id_out NUMBER;
l_segment1 varchar2(30);
l_pa_project_number_out VARCHAR2(1000);
l_pa_project_asset_id_out NUMBER;
l_pm_asset_reference_out VARCHAR2(1000);
l_pm_project_reference VARCHAR2(25):='XXSRI-API TEST PROJECT-2';--'351598';
l_pm_product_code VARCHAR2(30):= 'OKE';--'MSPROJECT';
l_pa_project_id NUMBER(15):= 8547;--21183;
l_pa_asset_name VARCHAR2(240) := 'xx test asset';--'351598 SIRIUS TP32 CRAWLEY UPLINK';
l_asset_number VARCHAR2(15):= 'A12345';--'966625';
l_asset_description VARCHAR2(80):= 'xx test asset';
l_project_asset_type VARCHAR2(30):='ESTIMATED';
ln_pa_appl_id CONSTANT NUMBER (3) := 275;
ln_user_id NUMBER := fnd_profile.VALUE ('USER_ID');
ln_responsibility_id NUMBER := fnd_profile.VALUE ('RESP_ID');
ln_business_group_id NUMBER := fnd_profile.VALUE ('PER_BUSINESS_GROUP_ID');
ln_org_id NUMBER := fnd_profile.value('ORG_ID');
begin
mo_global.set_policy_context('S',204);
--fnd_global.apps_initialize (user_id => ln_user_id,
--resp_id => ln_responsibility_id,
--resp_appl_id => ln_pa_appl_id
--);
FND_GLOBAL.APPS_INITIALIZE(1014723,56486, 275);
pa_project_assets_pub.update_project_asset(p_api_version_number => 1.0
,p_commit => FND_API.G_FALSE
,p_init_msg_list => FND_API.G_FALSE
,p_msg_count => l_msg_count
,p_msg_data => l_msg_data
,p_return_status => l_return_status
,p_pm_product_code => l_pm_product_code
,p_pm_project_reference => l_pm_project_reference
,p_pa_project_id => l_pa_project_id
,p_pa_asset_name => l_pa_asset_name
,p_asset_number =>l_asset_number
,p_asset_description => l_asset_description
,p_project_asset_type => 1