Skip to content


This will initiate the asynchronous REST call with an empty message payload. This method can be used to send BINARY (BLOB) data which there is no payload send from PL/SQL end since the data is retrieved by the middle tier later. This method uses record structure for the structural parameters.

PROCEDURE Call_Rest_EndPoint_Empty_Body(  
   rest_service_        IN      VARCHAR2,     
   url_params_          IN      type_record_ DEFAULT NULL,  
   callback_func_       IN      VARCHAR2,  
   http_method_         IN      VARCHAR2,  
   http_req_headers_    IN      VARCHAR2 DEFAULT NULL,  
   query_parameters_    IN      type_record_ DEFAULT NULL,    
   header_params_       IN      type_record_ DEFAULT NULL,
   incld_resp_info_     IN      BOOLEAN DEFAULT NULL,
   fnd_user_            IN      VARCHAR2 DEFAULT NULL,  
   key_ref_             IN      VARCHAR2 DEFAULT NULL,  
   blob_info_           IN      VARCHAR2 DEFAULT NULL,  
   sender_              IN      VARCHAR2 DEFAULT NULL,     
   receiver_            IN      VARCHAR2 DEFAULT default_recevier_,     
   subject_             IN      VARCHAR2 DEFAULT NULL,  
   in_order_            IN      BOOLEAN DEFAULT FALSE,
   fail_notify_         IN      BOOLEAN  DEFAULT FALSE,
   failed_callback_fun_ IN      VARCHAR2 DEFAULT NULL,
   accepted_res_codes_  IN      VARCHAR2 DEFAULT NULL,
   auth_params_         IN      type_record_ DEFAULT NULL);



​ The name of the Rest Service.

url_params_     URL parameters record.

callback_func_     Name of the Callback PL/SQL method.

http_method_     HTTP request method type.

http_req_headers_     Additional HTTP request headers.

query_parameters_     Optional. Query parameters of the URL.

header_params_ Optional. Header parameters.

include_resp_info_ Optional. Include the response code and response headers in the response.

fnd_user_ Optional. Can be used to pass the fnd_user who initiated the prediction call to the callback function.

key_ref_     Optional. Can be used to pass the key_ref_ of the business object to the callback function.

blob_info_    Details on BLOB data field such as Table Name, BLOB Column name and Key field and Key value.

sender_     Optional identity of sending organization. The value will be entered in FNDCN_APPLICATION_MESSAGE_TAB.SENDER.

receiver_     Optional identity of receiving organization. The value will be entered in FNDCN_APPLICATION_MESSAGE_TAB.RECEIVER.

subject_     Optional subject. The value will be entered in FNDCN_APPLICATION_MESSAGE_TAB.SUBJECT.

in_order_     Flag denoting if the message should be put to an InOrder queue. Default FALSE. If TRUE and it is not possible to find a queue or the found queue is not InOrder, an exception will be raised.

fail_notify_ Flag denoting if a notification should be sent when the request is failed. Default FALSE.

failed_callback_fun_ Optional. Name of the Callback PL/SQL method that needs to call for a failed request.

accepted_res_codes_ Optional. Rest sender can return a response based on the standard http response codes raised by each http operations. Accepted response codes in Rest Sender are 200. 202, 204, 500, 401, 301, 302, 303 and 400. If the http response code does not belong to above accepted set, Rest Sender will throw an error. Hence, if a particular response code which does not belong to above accepted response codes, but need to accept by Rest Sender, those response codes can be set as the value for this parameter. When setting more than one accepted codes, should use comma as the delimiter.

auth_params_ Optional. Authorization Parameters