Home » Applications » Oracle Fusion Apps & E-Business Suite » UPDATE_BUDGET (Oracle 11.5)
icon4.gif  UPDATE_BUDGET [message #600817] Tue, 12 November 2013 17:30
kiike007
Messages: 10
Registered: October 2013
Location: México
Junior Member
Hi, following code returns status E and no retrieve a message for this error. What i do wrong ??

declare
v_msg_count NUMBER;
v_msg_data VARCHAR2(2000);
v_return_status VARCHAR2(50);
l_budget_lines_in pa_budget_pub.budget_line_in_tbl_type;
l_budget_lines_out pa_budget_pub.budget_line_out_tbl_type;
linUserId NUMBER;
linRespId NUMBER;
linApplId NUMBER;

begin

linUserId := 1373;
linRespId := 51953;
linApplId := 275;
FND_GLOBAL.APPS_INITIALIZE (linUserId
,linRespId
,linApplId);

pa_budget_pub.UPDATE_BUDGET( p_api_version_number => 1
,p_commit => 'F'
,p_init_msg_list => NULL
,p_msg_count => v_msg_count
,p_msg_data => v_msg_data
,p_return_status => v_return_status
,p_pm_product_code =>'PJM'
,p_pa_project_id => 40586
,p_pm_project_reference=>NULL
,p_budget_type_code =>'Unico'
,p_change_reason_code =>NULL
,p_description =>NULL
,p_attribute_category =>NULL
,p_attribute1 =>NULL
,p_attribute2 =>NULL
,p_attribute3 =>NULL
,p_attribute4 =>NULL
,p_attribute5 =>NULL
,p_attribute6 =>NULL
,p_attribute7 =>NULL
,p_attribute8 =>NULL
,p_attribute9 =>NULL
,p_attribute10 =>NULL
,p_attribute11 =>NULL
,p_attribute12 =>NULL
,p_attribute13 =>NULL
,p_attribute14 =>NULL
,p_attribute15 =>NULL
,p_budget_lines_in =>l_budget_lines_in
,p_budget_lines_out =>l_budget_lines_out );

dbms_output.PUT_LINE('Status:'||v_return_status||' Mensaje:'||v_msg_data);

end;


---The code returns Status:E Mensaje:
Previous Topic: Auto create Error's when approved
Next Topic: workflow query
Goto Forum:
  


Current Time: Tue Apr 16 00:35:58 CDT 2024