Total Pageviews

October 11, 2016

10/11/2016 01:10:00 AM
Oracle Order Management Holds

Order Management OE_ORDER_:HOLDS API  Issue: Applying Holds using OE_HOLDS_PUB.apply_holds using the below code. 


FOR l_orders in c_orders LOOP 
l_order_tbl(1).header_id := l_orders.header_id; 
OE_HOLDS_PUB.apply_holds(p_api_version => 6000 
p_init_msg_list => FND_API.G_FALSE, 
p_commit => FND_API.G_FALSE, 
p_validation_level => FND_API.G_VALID_LEVEL_FULL , 
p_order_tbl => l_order_tbl, 
--p_entity_code => 'O', 
--p_entity_id => l_orders.header_id, 
p_hold_id => 1,--l_hold_rec.hold_id, 
p_hold_until_date => SYSDATE + 1, 
p_hold_comment => 'Hold API test on ' || 
to_char(SYSDATE, 
'DD-MON-YYYY HH24:MI:SS'), 
x_return_status => l_return_status, 
x_msg_count => l_msg_count, 
x_msg_data => l_msg_data); 

dbms_output.put_line('Order Number = ' || l_orders.order_number); 
dbms_output.put_line('Return Status = ' || l_return_status); 
dbms_output.put_line('Message Count = ' || l_msg_count); 
dbms_output.put_line('Message Data = :' || l_msg_data || ':'); 
END LOOP; 

Return Status is S,,unable  to see the hold in Order?Reason?

Answer:

Print the msg data as below a

for I in 1.. l_msg_cont 
loop 
fnd_msg_pub.get( 
p_msg_index... 
....) 
dbms_output.put_line('Order Number = ' || l_orders.order_number); 
dbms_output.put_line('Return Status = ' || l_return_status); 
dbms_output.put_line('Message Count = ' || l_msg_count); 
dbms_output.put_line('Message Data = :' || l_msg_data || ':'); .. 
commit;
end loop; 
 
Related Posts Plugin for WordPress, Blogger...