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_
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;