847: l_api_name||': Error.' || x_err_msg);
848: END IF;
849: END IF;
850:
851: l_req_seq_id := OKC_CLS_REST_CALLS_LOGS_S.NEXTVAL;
852:
853: INSERT INTO OKC_CLS_REST_CALLS_LOGS(
854: ID,
855: REQUEST_METHOD,
849: END IF;
850:
851: l_req_seq_id := OKC_CLS_REST_CALLS_LOGS_S.NEXTVAL;
852:
853: INSERT INTO OKC_CLS_REST_CALLS_LOGS(
854: ID,
855: REQUEST_METHOD,
856: URL,
857: URI,
954: ELSE
955: l_transaction_status := 'E';
956: END IF;
957:
958: UPDATE OKC_CLS_REST_CALLS_LOGS
959: SET RESPONSE_STATUS_CODE = p_response_status_code,
960: TRANSACTION_STATUS = l_transaction_status,
961: RESPONSE = p_response,
962: LAST_UPDATED_BY = FND_GLOBAL.USER_ID,